Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

sammedit

Pioneers
  • Posts

    85
  • Joined

  • Last visited

Everything posted by sammedit

  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. 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.
  8. 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(); }
  9. 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.
  10. 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.
  11. Has anybody figured out how to get the X-Sell function to work? Thank you.
  12. 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.
  13. Does anyone have the 2.3 account.php file for this contribution?
  14. 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)");
  15. Hi, I just turned on X-Sell in EP and I am running into a bug. The xsell field is not added to the excel file if you use the "Complete" download option but is added if you use the "Custom" download option and click the checkbox. Does anyone know how to fix this? I am using version 2.8 for 2.3.1. Thank you
  16. Hi, I have another quick question. When adding the optional Google breadcrumb, do I really need to make the changes on stylesheet.css, header.php, and includes/classes/breadcrumb.php? It seems to me that the code that changes the bread crumb products model to the product name in application_top.php is the only code doing anything. Will I be fine without the UL LI structure or is that required by Google to work properly? Please let me know. Thank you!
  17. Hi, If I have KISSMT_CANONICAL_ON set to true and protected $root_index = 'root', should I still be seeing index.php in the URL?
  18. Hi, My checkout_payment.php page is not showing any of the coupon code error messages such as, "Invalid Coupon Code". I can see the URL change to checkout_payment.php?payment_error=ot_coupon&error=Invalid+Coupon+Code but it does not show up on the page. I am using the stock checkout_payment.php page that came with this contribution as I didn't have any other contributions installed that had changes in this file. Any Ideas? This is driving me crazy!
  19. I have this same problem with the 1.1 version on Osc 2.3.1. Clicking the "Sign In" button takes you to the login page but doesn't log you in. The fixes posted above were already included in the 1.1 file. Anyone see any other problems?
  20. Here is the response I received from Google today when I asked if they had any plans of supporting GC on 2.3.1: Thanks for your email. Google Payments currently doesn’t provide support for OSCommerce 2.3.1, though we may introduce this feature in the future. We’ll take your feedback into account and relay it to our engineering team as we move forward with product development. We always welcome suggestions for how we can improve Google Payments, so please continue to send us your comments in the future. If you have additional questions, please visit our Help Center at http://checkout.google.com/support/sell/ Sincerely, Caden The Google Checkout Team It would probably help if everyone could also email Google about supporting it so they know it is worth their time to do so. You can write them here: http://support.google.com/checkout/sell/bin/request.py?contact_type=more_nomid&from=avl
  21. Thank you. I already have special settings in my php.ini to allow longer scripts. But I did not know that I could export by catergory. I thought that the "filter by" thing just organized the download or something. That will take care of my problem. Thank you very much for your help!
  22. Dear Surfalot, You seem to be the go to guy for EP. I really appreciate you donating your time to help people out on this forum. Osc would be useless without people like you to show us non-coders how to use it! I am hoping you can give me an idea on where to look with a problem I am having. I think I was using version 2.76e or something like that earlier today but I uploaded the latest version to see if that would fix the problem but it didn't. So the problem....I am trying to download a complete .csv file. I have like 24,000 products and like 300,000 attributes. I can download the entire file with all 24,000 products if I do not include the attributes with no problem. But if I include the attributes or try to download the attributes by themselves, the file stops short. I don't get any warning messages or time out messages, it just acts like it finished. It seems to stop around 7000 products short but not at the same place everytime. Any ideas on what would be causing that? Thank you.
  23. I know it has been over a year since I asked this question....and I never did see this post until today. I tried it and it worked perfectly. The download speed of a complete EP .csv file has gone from 2kbps to full speed:) Thank you so much for this fix.
  24. Hi, I have a search engine question regarding duplicate content. I am using a very old version of oscommerce and I could never get any SEO contributions to work on it so I ran a database query to change all of the products page title headers to equal the product name. Do you think that having the page title the same as the product name on each page is bad for the search engines? I am currently rebuilding a new website to replace the old one and I just installed Seo Urls 5 which puts the product name in the web address as well. So my question is, will having the url, page title, and product title all the same hurt my search engine rankings? Also I was wondering if this contribution is supposed to work with google checkout. My google checkout was working fine until I installed Seo 5. Now I get some mad errors saying something about headers not being able to be resent. Any and all input is welcome. Thank you! Brent
×
×
  • Create New...