Latest News: (loading..)

sammedit

Members
  • Content count

    85
  • Joined

  • Last visited

1 Follower

About sammedit

Profile Information

  • Real Name
    B
  • Gender
    Male
  1. @@SharperJacks Did you make changes on both admin/includes/functions/general.php and catalog/includes/functions/general.php? There is code in the instructions to add to both of those pages. That is likely your problem.
  2. FYI: I have not been able to get the unsubscribe add on to work on the sales_followup emails.
  3. @@npn2531 For some reason this site won't let me email you. So here it is: Mail Manager Newsletter Unsubscribe Add On Add these two files to your catalog directory: unsubscribe.php <?php //////////////////////////////////////////////////////////////////////////// // $Id: Newsletter Unsubscribe, v 1.0 (/catalog/unsubscribe.php) 2003/01/24 // Programed By: Christopher Bradley (www.wizardsandwars.com) // // Developed for osCommerce, Open Source E-Commerce Solutions // http://www.oscommerce.com // Copyright (c) 2003 osCommerce // // Released under the GNU General Public License // /////////////////////////////////////////////////////////////////////////// require('includes/application_top.php'); require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_UNSUBSCRIBE); if (isset($HTTP_GET_VARS['email'])) { $email_to_unsubscribe = ereg_replace('[^0-9A-Za-z@._-]', '', $HTTP_GET_VARS['email']); } else { $email_to_unsubscribe = ''; } $breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_UNSUBSCRIBE, '', 'NONSSL')); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <base href="<?php echo (getenv('HTTPS') == 'on' ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <link rel="stylesheet" type="text/css" href="stylesheet.css"> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="3" cellpadding="3"> <tr> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td> <!-- body_text //--> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="main"><?php echo UNSUBSCRIBE_TEXT_INFORMATION; ?></td> </tr> </table></td> </tr> <tr> <td align="center" class="main"><br><?php echo '<a href="' . tep_href_link(FILENAME_UNSUBSCRIBE_DONE, 'email=' . $email_to_unsubscribe, 'NONSSL') . '">' . tep_image_button('button_unsubscribe.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td> </tr> </table></td> <!-- body_text_eof //--> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> <!-- right_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_right.php'); ?> <!-- right_navigation_eof //--> </table></td> </tr> </table> <!-- body_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> <br> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> unsubscribe_done.php <?php //////////////////////////////////////////////////////////////////////////// // $Id: Newsletter Unsubscribe, v 1.0 (/catalog/unsubscribe_done.php) 2003/01/24 // Programed By: Christopher Bradley (www.wizardsandwars.com) // // Developed for osCommerce, Open Source E-Commerce Solutions // http://www.oscommerce.com // Copyright (c) 2003 osCommerce // // Released under the GNU General Public License // /////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////////////// require('includes/application_top.php'); require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_UNSUBSCRIBE); if (isset($HTTP_GET_VARS['email'])) { $email_to_unsubscribe = ereg_replace('[^0-9A-Za-z@._-]', '', $HTTP_GET_VARS['email']); } else { $email_to_unsubscribe = ''; } $breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_UNSUBSCRIBE, '', 'NONSSL')); // Check and see if the email exists in the database, and is subscribed to the newsletter. $cus_subscribe_raw = "select 1 from " . TABLE_CUSTOMERS . " where customers_newsletter = '1' and customers_email_address = '" . $email_to_unsubscribe . "'"; $cus_subscribe_query = tep_db_query($cus_subscribe_raw); $cus_subscribe = tep_db_fetch_array($cus_subscribe_query); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <base href="<?php echo (getenv('HTTPS') == 'on' ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <link rel="stylesheet" type="text/css" href="stylesheet.css"> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="3" cellpadding="3"> <tr> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td> <!-- body_text //--> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <?php // If we found the customers email address, and they currently subscribe if ($cus_subscribe) { // Unsubscribe them tep_db_query("update " . TABLE_CUSTOMERS . " set customers_newsletter = '0' where customers_email_address = '" . $email_to_unsubscribe . "'"); ?> <td class="main"><?php echo UNSUBSCRIBE_DONE_TEXT_INFORMATION . $email_to_unsubscribe; ?></td> <?php // Otherwise, we want to display an error message (This should never occur, unless they try to unsubscribe twice) } else { ?> <td class="main"><?php echo UNSUBSCRIBE_ERROR_INFORMATION . $email_to_unsubscribe; ?></td> <?php } ?> </tr> </table></td> </tr> <tr> <td align="center" class="main"><br><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT, '', 'NONSSL') . '">' . tep_image_button('button_continue_shopping.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td> </tr> </table></td> <!-- body_text_eof //--> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> <!-- right_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_right.php'); ?> <!-- right_navigation_eof //--> </table></td> </tr> </table> <!-- body_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> <br> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> Then add catalog/includes/languages/english/unsubscribe.php <?php //////////////////////////////////////////////////////////////////////////// // $Id: Newsletter Unsubscribe, (/catalog/includes/languages/english/unsubscribe.php)v 1.2 2004/04/29 // Programed By: Christopher Bradley (www.wizardsandwars.com) // Modified by Jim Keebaugh // // Developed for osCommerce, Open Source E-Commerce Solutions // http://www.oscommerce.com // Copyright (c) 2003 osCommerce // // Released under the GNU General Public License // /////////////////////////////////////////////////////////////////////////// define('NAVBAR_TITLE', 'Unsubscribe'); define('HEADING_TITLE', 'Unsubscribe from our Newsletter'); define('UNSUBSCRIBE_TEXT_INFORMATION', '<br>We\'re sorry to hear that you wish to unsubscribe from our newsletter. If you have concerns about your privacy, please see our <a href="' . FILENAME_PRIVACY . '"><u>privacy notice</u></a>.<br><br>Subscribers to our newsletter are kept notified of new products, price reductions, and site news.<br><br>If you still do not wish to receive your newsletter, please click the button below. '); define('UNSUBSCRIBE_DONE_TEXT_INFORMATION', '<br>Your email address, listed below, has been removed from our Newsletter Subscription list, as per your request. <br><br>'); define('UNSUBSCRIBE_ERROR_INFORMATION', '<br>The email address listed below was not found in our newsletter database, or has already been removed from our newletter subscription list. <br><br>'); ?> Then create an unsubscribe button and post as catalog/includes/languages/english/images/buttons/button_unsubscribe.gif or draw your own and change applicable code. EDITS: admin/includes/modules/newsletters/newsletter.php Find: $mimemessage = new email(array('X-Mailer: osCommerce bulk mailer')); $mimemessage->add_text($this->content); $mimemessage->build_message(); while ($mail = tep_db_fetch_array($mail_query)) { $mimemessage->send($mail['customers_firstname'] . ' ' . $mail['customers_lastname'], $mail['customers_email_address'], '', EMAIL_FROM, $this->title); } Change to: // Begin Unsubscribe $mimemessage = new email(array('X-Mailer: osCommerce bulk mailer')); while ($mail = tep_db_fetch_array($mail_query)) { $mimemessage->add_html($this->content . TEXT_UNSUBSCRIBE . '<a href="' . HTTP_CATALOG_SERVER . DIR_WS_CATALOG . FILENAME_UNSUBSCRIBE . "?email=" . $mail['customers_email_address'] . '">' . HTTP_CATALOG_SERVER . DIR_WS_CATALOG . FILENAME_UNSUBSCRIBE . "?email=" . $mail['customers_email_address'] . '</a>'); $mimemessage->build_message(); $mimemessage->send($mail['customers_firstname'] . ' ' . $mail['customers_lastname'], $mail['customers_email_address'], '', EMAIL_FROM, $this->title); } // End Unsubscribe In /catalog/includes/filenames.php Add: /// Begin Unsubscribe define('FILENAME_UNSUBSCRIBE', 'unsubscribe.php'); define('FILENAME_UNSUBSCRIBE_DONE', 'unsubscribe_done.php'); /// End Unsubscribe In admin/includes/languages/english/modules/newsletters/newsletter.php and admin/includes/languages/english/mm_bulkmail.php Add: /// Begin Unsubscribe define('TEXT_UNSUBSCRIBE', "\n\nTo unsubscribe from this newsletter, just click on the following link:\n"); /// End Unsubscribe In admin/includes/filenames.php Add: //// Begin Unsubscribe define('FILENAME_UNSUBSCRIBE', 'unsubscribe.php'); //// End Unsubscribe Then in admin/mm_bulkmail.php Find: // compile mailpiece $output_content_html= $template['htmlheader'].$newsletter['content'].$template['htmlfooter']; $output_content_txt= $template['txtheader'].$newsletter['txtcontent'].$template['txtfooter']; // placeholders $placeholders=array('storeurl', 'storeowner','storeemail'); $values=array(HTTP_SERVER,STORE_OWNER,STORE_OWNER_EMAIL_ADDRESS); $output_content_html=str_replace($placeholders, $values, $output_content_html); // get customer selection criteria and additional content from module require(DIR_WS_MODULES . 'mail_manager/' . $newsletter['module'] . substr($PHP_SELF, strrpos($PHP_SELF, '.'))); and replace with: // compile mailpiece $output_content_html= $template['htmlheader'].$newsletter['content'].$template['htmlfooter']; $output_content_txt= $template['txtheader'].$newsletter['txtcontent'].$template['txtfooter']; require(DIR_WS_MODULES . 'mail_manager/' . $newsletter['module'] . substr($PHP_SELF, strrpos($PHP_SELF, '.'))); $unsubscribe = TEXT_UNSUBSCRIBE . '<a href="' . HTTP_CATALOG_SERVER . DIR_WS_CATALOG . FILENAME_UNSUBSCRIBE . "?email=" . $mail['customers_email_address'] . '">' . HTTP_CATALOG_SERVER . DIR_WS_CATALOG . FILENAME_UNSUBSCRIBE . "?email=" . $mail['customers_email_address'] . '</a>'; // placeholders $placeholders=array('storeurl', 'storeowner','storeemail', '$unsubscribe'); $values=array(HTTP_CATALOG_SERVER,STORE_OWNER,STORE_OWNER_EMAIL_ADDRESS, $unsubscribe); $output_content_html=str_replace($placeholders, $values, $output_content_html); Then add $unsubscribe into your newsletter or into the template. I think that is it. It will also add an unsubscribe link to your stock newsletter setup. Let me know if you get it to work. sammedit
  4. @@npn2531 Hey, I would post the changes but I am not a coder and I am working on a custom template. But as I stated above, if someone tries my code and it works without any issues, then I will post it. And regarding the time issue, for anyone who is interested, on admin/includes/modules/mail_manager/sales_followup.php change: date('Y-m-d h:m:s') to date('Y-m-d h:i:s') Now, regarding the unsubscribe issue. I will put the code together and email it to you. But you will definitely need to test it and possibly make some changes. I use 2.3.3 but will send files for 2.2. Let me know how it works.
  5. @@npn2531 Are you having any trouble with the sales follow up dates not showing the correct time? When I go to send a sales follow up email, here is what I see: email orders older than (<=): 2012-09-16 11:09:45 but no older than (>): 2012-08-17 11:08:45 The times are always a minute off from each other and the minute hand on both NEVER move. They always stay and 08 and 09. The hour changes and the seconds change but not the minutes. Does it work correctly on your store?
  6. @@hho That is because it is called Store Credit. The directions are wrong.
  7. @@Clau123 How buggy?
  8. Try this. If it works for you, I will add it to the contribution area. replace all contents of admin/includes/boxes/mail_manager.php with: <?php /* $Id: tools.php 1739 2007-12-20 00:52:16Z hpdl $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2002 osCommerce Released under the GNU General Public License */ $cl_box_groups[] = array( 'heading' => BOX_HEADING_MAIL_MANAGER, 'apps' => array( array( 'code' => FILENAME_MM_RESPONSEMAIL, 'title' => BOX_MM_RESPONSEMAIL, 'link' => tep_href_link(FILENAME_MM_RESPONSEMAIL) ), array( 'code' => FILENAME_MM_BULKMAIL, 'title' => BOX_MM_BULKMAIL, 'link' => tep_href_link(FILENAME_MM_BULKMAIL) ), array( 'code' => FILENAME_MM_TEMPLATES, 'title' => BOX_MM_TEMPLATES, 'link' => tep_href_link(FILENAME_MM_TEMPLATES) ), array( 'code' => FILENAME_MM_EMAIL, 'title' => BOX_MM_EMAIL, 'link' => tep_href_link(FILENAME_MM_EMAIL) ) ) ); $box = new box; echo $box->menuBox($heading, $contents); ?> In admin/mm_bulkmail.php, admin/mm_email.php, admin/mm_responsemail.php, admin/mm_templates.php: find: <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="2" cellpadding="2"> <tr> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td> and replace with: <?php require(DIR_WS_INCLUDES . 'template_top.php'); ?> Then find: <!-- body_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> <br> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> and replace with: </body> </html> <?php require(DIR_WS_INCLUDES . 'template_bottom.php'); require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> And that should do it. Let me know if it works for you.
  9. Hey FWR, osC 2.3.3 changes the tep_redirect($url) function in includes/functions/general.php which was modified by you for this contribution. osC's changes are very similar to the changes you already had in place. There are a couple differences in code and I was wondering if you could take a look at it and let us know how to proceed with this code if we upgrade to 2.3.3. Thank you. FWR's code: * ULTIMATE Seo Urls 5 PRO by FWR Media * Redirect to another page or site */ function tep_redirect($url) { if ( (strstr($url, "\n") != false) || (strstr($url, "\r") != false) ) { tep_redirect(tep_href_link(FILENAME_DEFAULT, '', 'NONSSL', false)); } if ( (ENABLE_SSL == true) && (getenv('HTTPS') == 'on') ) { // We are loading an SSL page if (substr($url, 0, strlen(HTTP_SERVER)) == HTTP_SERVER) { // NONSSL url $url = HTTPS_SERVER . substr($url, strlen(HTTP_SERVER)); // Change it to SSL } } if ( false !== strpos($url, '&') ){ $url = str_replace('&', '&', $url); } session_write_close(); header('Location: ' . $url); exit; } osC 2.3.3 code: function tep_redirect($url) { if ( (strstr($url, "\n") != false) || (strstr($url, "\r") != false) ) { tep_redirect(tep_href_link(FILENAME_DEFAULT, '', 'NONSSL', false)); } if ( (ENABLE_SSL == true) && (getenv('HTTPS') == 'on') ) { // We are loading an SSL page if (substr($url, 0, strlen(HTTP_SERVER)) == HTTP_SERVER) { // NONSSL url $url = HTTPS_SERVER . substr($url, strlen(HTTP_SERVER)); // Change it to SSL } } if ( strpos($url, '&') !== false ) { $url = str_replace('&', '&', $url); } header('Location: ' . $url); tep_exit(); }
  10. I'm not really sure what you mean. It comes with it's own newsletter mailer called bulkmail manager. If a customer signs up for the default newsletter when they create an account, you can choose to send them a newsletter through the bulkmail manager just like you can with the default newsletter setup.
  11. I use it on 2.3.2. I had to modify some of the admin files to make it show up properly in the admin like you have to do on most contribs written for 2.2. But aside from that it is fully functional.
  12. Has anybody figured out how to get the X-Sell function to work? Thank you.
  13. I went ahead and edited the account.php page myself. Here it is: <?php /* $Id$ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2010 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); if (!tep_session_is_registered('customer_id')) { $navigation->set_snapshot(); tep_redirect(tep_href_link(FILENAME_LOGIN, '', 'SSL')); } require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_ACCOUNT); $breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_ACCOUNT, '', 'SSL')); require(DIR_WS_INCLUDES . 'template_top.php'); ?> <h1><?php echo HEADING_TITLE; ?></h1> <?php if ($messageStack->size('account') > 0) { echo $messageStack->output('account'); } ?> <div class="contentContainer"> <h2><?php echo MY_ACCOUNT_TITLE; ?></h2> <div class="contentText"> <ul class="accountLinkList"> <li><span class="ui-icon ui-icon-person accountLinkListEntry"></span><?php echo '<a href="' . tep_href_link(FILENAME_ACCOUNT_EDIT, '', 'SSL') . '">' . MY_ACCOUNT_INFORMATION . '</a>'; ?></li> <li><span class="ui-icon ui-icon-home accountLinkListEntry"></span><?php echo '<a href="' . tep_href_link(FILENAME_ADDRESS_BOOK, '', 'SSL') . '">' . MY_ACCOUNT_ADDRESS_BOOK . '</a>'; ?></li> <li><span class="ui-icon ui-icon-key accountLinkListEntry"></span><?php echo '<a href="' . tep_href_link(FILENAME_ACCOUNT_PASSWORD, '', 'SSL') . '">' . MY_ACCOUNT_PASSWORD . '</a>'; ?></li> </ul> </div> <h2><?php echo MY_ORDERS_TITLE; ?></h2> <div class="contentText"> <ul class="accountLinkList"> <li><span class="ui-icon ui-icon-cart accountLinkListEntry"></span><?php echo '<a href="' . tep_href_link(FILENAME_ACCOUNT_HISTORY, '', 'SSL') . '">' . MY_ORDERS_VIEW . '</a>'; ?></li> </ul> </div> <h2><?php echo EMAIL_NOTIFICATIONS_TITLE; ?></h2> <div class="contentText"> <ul class="accountLinkList"> <li><span class="ui-icon ui-icon-mail-closed accountLinkListEntry"></span><?php echo '<a href="' . tep_href_link(FILENAME_ACCOUNT_NEWSLETTERS, '', 'SSL') . '">' . EMAIL_NOTIFICATIONS_NEWSLETTERS . '</a>'; ?></li> <li><span class="ui-icon ui-icon-heart accountLinkListEntry"></span><?php echo '<a href="' . tep_href_link(FILENAME_ACCOUNT_NOTIFICATIONS, '', 'SSL') . '">' . EMAIL_NOTIFICATIONS_PRODUCTS . '</a>'; ?></li> </ul> </div> <?php //CCGV BEGIN if (tep_session_is_registered('customer_id')) { $gv_query = tep_db_query("select amount from " . TABLE_COUPON_GV_CUSTOMER . " where customer_id = '" . $customer_id . "'"); $gv_result = tep_db_fetch_array($gv_query); if ($gv_result['amount'] > 0 ) { ?> <h2><?php echo MY_ORDERS_GV; ?></h2> <div class="contentText"> <ul class="accountLinkList"> <li><span class="ui-icon ui-icon-star accountLinkListEntry"></span><?php echo CCGV_BALANCE; ?> <?php echo $currencies->format($gv_result['amount']); ?></li> <li><span class="ui-icon ui-icon-mail-closed accountLinkListEntry"></span><?php echo '<a href="' . tep_href_link(FILENAME_GV_SEND, '', 'SSL') . '">' . CCGV_SENDVOUCHER . '</a>'; ?></li> <li><span class="ui-icon ui-icon-help accountLinkListEntry"></span><?php echo '<a href="' . tep_href_link(FILENAME_GV_FAQ, '', 'SSL') . '">' . CCGV_FAQ . '</a>'; ?></li> </ul> </div> <?php } else {} } // CCGV END ?> </div> <?php require(DIR_WS_INCLUDES . 'template_bottom.php'); require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> You also need to add the code below to catalog/includes/language/yourlanguage/account.php define('MY_ORDERS_GV', 'Gift Card Info'); define('CCGV_BALANCE', 'Your balance is '); define('CCGV_SENDVOUCHER', 'Share your balance'); define('CCGV_FAQ', 'Gift Card FAQ'); I am not a coder but if the file looks good, it should probably be added to the contribution download since it is missing.
  14. Does anyone have the 2.3 account.php file for this contribution?
  15. Here is another problem I am getting with X-Sell enabled. 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 1)' at line 2 insert into products_xsell (products_id, xsell_id, sort_order) values ( 2, , 1) I am pretty sure the error is coming from this but I don't know how to change the syntax to make it work. tep_db_query("insert into ".TABLE_PRODUCTS_XSELL." (products_id, xsell_id, sort_order) values ( ".$v_products_id.", ".$cross_sell_row['products_id'].", 1)"); tep_db_query("insert into ".TABLE_PRODUCTS_XSELL." (products_id, xsell_id, sort_order) values ( ".$cross_sell_row['products_id'].", ".$v_products_id.", 1)");