Jump to content


  • Content count

  • Joined

  • Last visited

Everything posted by lyonsperf

  1. lyonsperf

    [Development] Products Specifications

    I finally finished the install on my heavily modded shop and must say it went well. The only quirks I see are that the product description is duplicated. The original description is on top and the spec box with the tabs repeats the description. How can I shut one of them off? Secondly, in the admin=>categories=>product listing page the specs box has overlapped my boxes for the meta name and meta description. This seems like a format issue on my part should be easy to fix. Eventually I hope that step by step instructions are included for the newbie. Thanks! Matt
  2. I have manually installed the latest version and it works as far as showing the ymm on the product page. But in the admin panel under configuration when I click on year make model the page has a header but nothing else. It does not look like the screenshot provided in the download. I have added all the info for each product so the database shows the applications. On my homepage the box appears in the left column but I can only select the make. The model and years are empty. If I click go the page refreshes but nothing happens. I also installed the All Products mod and made the required changes but that didn't work either. It seems like there is a file missing for catalog/admin or maybe an sql entry. Anyone have any ideas?
  3. lyonsperf

    Offical Google Checkout module for osCommerce Support Thread

    I am trying to integrate this module on a heavily modified store. I have paypal as my current payment and Multi Vendor Shipping mod for shipping. How can I get this to show the different shipping charges for items that are dropshipped? Also, is it possible to just put a google checkout button on the checkout_confirmation.php page? Would it take the calculated total and send it to google checkout?
  4. I translated the files to english. If you would like I can upload them to the add-on.
  5. lyonsperf

    [Contribution] Grab_Order_Details

    This doesn't work! It is missing coding to show it on the main page or account page.
  6. Change over to Additional Images Module. http://addons.oscommerce.com/info/1032. It works well and is fully supported in the forums.
  7. lyonsperf

    [Contribution] Complete Review System

    Hey Great! Glad that got fixed. But it seems that the images for the ratings are missing. Any ideas?
  8. lyonsperf

    Having Problems With Customers Placing Orders

    Try this <?php /* $Id: checkout_success.php,v 1.49 2003/06/09 23:03:53 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions [url="http://www.oscommerce.com"]http://www.oscommerce.com[/url] Copyright © 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); // if the customer is not logged on, redirect them to the shopping cart page if (!tep_session_is_registered('customer_id')) { tep_redirect(tep_href_link(FILENAME_SHOPPING_CART)); } if (isset($HTTP_GET_VARS['action']) && ($HTTP_GET_VARS['action'] == 'update')) { $notify_string = ''; if (isset($HTTP_POST_VARS['notify']) && !empty($HTTP_POST_VARS['notify'])) { $notify = $HTTP_POST_VARS['notify']; if (!is_array($notify)) { $notify = array($notify); } for ($i=0, $n=sizeof($notify); $i<$n; $i++) { if (is_numeric($notify[$i])) { $notify_string .= 'notify[]=' . $notify[$i] . '&'; } } if (!empty($notify_string)) { $notify_string = 'action=notify&' . substr($notify_string, 0, -1); } } tep_redirect(tep_href_link(FILENAME_DEFAULT, $notify_string)); } require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CHECKOUT_SUCCESS); $breadcrumb->add(NAVBAR_TITLE_1); $breadcrumb->add(NAVBAR_TITLE_2); $global_query = tep_db_query("select global_product_notifications from " . TABLE_CUSTOMERS_INFO . " where customers_info_id = '" . (int)$customer_id . "'"); $global = tep_db_fetch_array($global_query); if ($global['global_product_notifications'] != '1') { $orders_query = tep_db_query("select orders_id from " . TABLE_ORDERS . " where customers_id = '" . (int)$customer_id . "' order by date_purchased desc limit 1"); $orders = tep_db_fetch_array($orders_query); $products_array = array(); $products_query = tep_db_query("select products_id, products_name from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$orders['orders_id'] . "' order by products_name"); while ($products = tep_db_fetch_array($products_query)) { $products_array[] = array('id' => $products['products_id'], 'text' => $products['products_name']); } } ?> <!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; ?>"> <title><?php echo TITLE; ?></title> <base href="<?php echo (($request_type == 'SSL') ? 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"><?php echo tep_draw_form('order', tep_href_link(FILENAME_CHECKOUT_SUCCESS, 'action=update', 'SSL')); ?><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td><table border="0" width="100%" cellspacing="4" cellpadding="2"> <tr> <td valign="top"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_man_on_board.gif', HEADING_TITLE); ?></td> <td valign="top" class="main"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?><div align="center" class="pageHeading"><?php echo HEADING_TITLE; ?></div><br><?php echo TEXT_SUCCESS; ?><br><br> <?php if ($global['global_product_notifications'] != '1') { echo TEXT_NOTIFY_PRODUCTS . '<br><p class="productsNotifications">'; $products_displayed = array(); for ($i=0, $n=sizeof($products_array); $i<$n; $i++) { if (!in_array($products_array[$i]['id'], $products_displayed)) { echo tep_draw_checkbox_field('notify[]', $products_array[$i]['id']) . ' ' . $products_array[$i]['text'] . '<br>'; $products_displayed[] = $products_array[$i]['id']; } } echo '</p>'; } else { echo TEXT_SEE_ORDERS . '<br><br>' . TEXT_CONTACT_STORE_OWNER; } ?> <h3><?php echo TEXT_THANKS_FOR_SHOPPING; ?></h3></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td align="right" class="main"><?php echo tep_image_submit('button_continue.gif', IMAGE_BUTTON_CONTINUE); ?></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="0"> <tr> <td width="25%"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td width="50%" align="right"><?php echo tep_draw_separator('pixel_silver.gif', '1', '5'); ?></td> <td width="50%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td> </tr> </table></td> <td width="25%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td> <td width="25%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td> <td width="25%"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td width="50%"><?php echo tep_draw_separator('pixel_silver.gif', '100%', '1'); ?></td> <td width="50%"><?php echo tep_image(DIR_WS_IMAGES . 'checkout_bullet.gif'); ?></td> </tr> </table></td> </tr> <tr> <td align="center" width="25%" class="checkoutBarFrom"><?php echo CHECKOUT_BAR_DELIVERY; ?></td> <td align="center" width="25%" class="checkoutBarFrom"><?php echo CHECKOUT_BAR_PAYMENT; ?></td> <td align="center" width="25%" class="checkoutBarFrom"><?php echo CHECKOUT_BAR_CONFIRMATION; ?></td> <td align="center" width="25%" class="checkoutBarCurrent"><?php echo CHECKOUT_BAR_FINISHED; ?></td> </tr> </table></td> </tr> <?php if (DOWNLOAD_ENABLED == 'true') include(DIR_WS_MODULES . 'downloads.php'); ?> </table></form></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'); ?>
  9. lyonsperf

    Having Problems With Customers Placing Orders

    Please post your checkout_confirmation.php file and your checkout_success.php file.
  10. lyonsperf

    Multi_Vendor_Shipping new thread

    Just a frendily note. I have added the contribution Product Lead Time http://addons.oscommerce.com/info/6624 to my store which allows me to explain to the customer the reason for the separate shipping charges on checkout. It is important to edit the files so that the message displayed reflects your store's shipping policies. For example, my store dropships several items from around the U.S. . So I changed the coded messages to read :This product is either custom made or shipped directly from the the manufacturer. Lead time is __ Days. Hope this helps someone as it has me. Matt
  11. lyonsperf

    Parse error: parse error, unexpected T_CASE...

    You have a mismatch in your sql. The query statement doesn't match the sql values. Check your values under the Products section of sql against the section in categories.php. You need to add the missing values i.e. p.products_ where they are missing.
  12. lyonsperf

    Parse error: parse error, unexpected T_CASE...

    You need to post the whole code. The portion you posted does not have errors.
  13. lyonsperf

    Extra Product Fields 1.0

    Please make sure that you have made all the changes as shown in the revisions except the last one dated Jul 3 by wdepot. Double check all your file changes per the install directions. I assume you are using a file compare tool to find the required changes. If not please download winmerge and check to see if you placed the changes in the correct syntax. Also, please let me know what version, author and download date you used.
  14. lyonsperf

    Extra Product Fields 1.0

    Did you upload the sql file to your database? Does the Product extra fields button appear in the admin under catalog? If so when you click the button, you are taken to a page that has Field Name Sort Order Language and then a button named Add Field. Just fill in the boxes and then copen a product in the admin/catalog or create a new product and the new field should show in the new product form.
  15. lyonsperf

    Product Extra fields install help

    I found a problem with the latest product_extra_fields.php in the admin section. All the coding is on one line. I copied that file from an earlier version and it worked fine. If you have header tags Seo installed you will need to reload the header_tags.php file in catalog/includes. Other wise it puls a T_CLASS error because the database didn't refresh.
  16. lyonsperf

    [Contribution] U HTML Emails

    I installed this today and really like it. I need to add the code to my MVS contrib but i'm not clear on how to do it. Any ideas?
  17. lyonsperf


    Hi Jack, I love this mod. I just had one question, When I click on the new quote request in quote handler should that bring me to a blank add a new product page under the quotes category? I thought it would use the product info from the part the quote was requested for and I would change the pricing to adjust for increased quantity.
  18. lyonsperf

    Multi_Vendor_Shipping new thread

    I spent the last two days upgrading this wonderful contrib in my system. I had a few issues, mainly with missing parts of other contribs that were in the code as MVS. Once I got that all sorted out along with the changes that had to be made to sql, I tried to get the store back on line. Everything seems to work except the vendor e-mail function. It does not list the individual orders under each vendor as it did with the last release. I ran through the code once more but could not find the problem. Under each vendor in the vendor section of admin the number of orders attributed to them is listed but when you click the order button the page doesn't have any of the orders placed. Any ideas?
  19. lyonsperf

    Header Tags SEO

    I don't have a googlesitemap directory. All the files are loaded on my root. Thats the way surfalot set it up. Should I have him fix it or can I prevent header tags from scanning this file?
  20. lyonsperf

    Header Tags SEO

    sitemap_class.php is part of Google XML sitemap contrib. I will check the install to see if it is done correctly. Is there anything I would need to do in Hear Tags SEO?
  21. lyonsperf

    Header Tags SEO

    Hi Jack, I upgraded to the latest version and it works great with one exception. Occasionally I will get an error page when browsing the catalog that reads as follows:syntax error,unexpected T-CLASS in header_tags.php. The line quoted varies but the last time it was this one case (basename($_SERVER['PHP_SELF']) === FILENAME_SITEMAP.CLASS): If I replace the file on my server with the original one from the upgrade it goes away for a while but comes back unexpectedly. Any ideas?
  22. lyonsperf

    [Contribution] Mindsparx admin

    I am pulling what little hair I have left out. I have too many add-ons so the drop down menus require me to scroll to get the option I want. Also, I have add-ons that were in their own boxes with sub categories. They cannot be added to drop downs but need their own. Contribs like header tags seo, multi vendor shipping, links managerII, additional pages. How do I add these so that the sub cats for them show?
  23. lyonsperf

    Multi_Vendor_Shipping new thread

    I have an issue with shipping charges being displayed seperately. For one vendor I had to add seperate vendor accounts because they charge different handling fees for different items. Now when a customer selects a few of these items the shipping charges for the same shipping company, show seperately. Is there a way to get the shipping charges to combine when there is a common freight company? For example: I have vendor x set up in vendor manager as vendor x (widget) and vendor x (gadget). If the customer selects a widget and a gadget it displays like this in checkout: Qty 1 widget, Price:$1.00, FedexShipping $.50 Qty 1 gadget, Price:$2.00, Fedex Shipping $1.00 If the items were grouped together then the weights would be combined and the shipping charges would actually be less! For example I had a customer buy two products from one vendor which charged him $13.00 freight for one item and then 36.00 for the other item. when the vendor sent me the shipping confirmation the freight charges were only$36.00 because they were able to ship in one package! Any thoughts?
  24. lyonsperf

    All Customers Report

    Well I got the listings to come up in admin after severely modifying the admin/all_customers.php file. Now I can't get it to export in IE7! Here is my code for admin/all_customers.php which will get you past the DB errors <?php /* $Id: all_customers.php, v1.0 March 21, 2005 18:45:00 adapted by Robert Goth June 24, 2005 osCommerce, Open Source E-Commerce Solutions [url="http://www.oscommerce.com"]http://www.oscommerce.com[/url] Copyright © 2002 - 2004 osCommerce written by Jared Call at client' suggestion some code nicked and modified from /catalog/admin/customers.php Released under the GNU General Public License */ // entry for bouncing csv string back as file // Turn on output buffering ob_start(); if (isset($_POST['csv'])) { if (isset($HTTP_POST_VARS['saveas'])) { // rebound posted csv as save file $savename= $HTTP_POST_VARS['saveas'] . ".csv"; } else $savename='unknown.csv'; $csv_string = ''; if ($HTTP_POST_VARS['csv']) $csv_string=$HTTP_POST_VARS['csv']; if (strlen($csv_string)>0){ header("Expires: Mon, 26 Nov 1962 00:00:00 GMT"); header("Last-Modified: " . gmdate('D,d M Y H:i:s') . ' GMT'); header("Cache-Control: no-cache, must-revalidate"); header("Pragma: no-cache"); header("Content-Type: text/csv"); header("Content-Disposition: attachment; filename=$savename"); echo html_entity_decode(stripslashes($csv_string), ENT_QUOTES); } else echo "CSV string empty"; exit; }; require('includes/application_top.php'); ?> <!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; ?>"> <title><?php echo TITLE; ?></title> <link rel="stylesheet" type="text/css" href="includes/stylesheet.css"> <script language="javascript" src="includes/general.js"></script> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF"> <!-- 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> <!-- body_text //--> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td colspan="2"><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', '1', '10'); ?></td> </tr> <?php // Used to determine sorting order by field switch ($orderby) { case "email" : $db_orderby = "c.customers_email_address"; break; case "address": $db_orderby = "a.entry_street_address"; break; case "city": $db_orderby = "a.entry_city"; break; case "state": $db_orderby = "a.entry_state"; break; case "telephone": $db_orderby = "c.customers_telephone"; break; case "pcode": $db_orderby = "a.entry_postcode"; break; default : $db_orderby = "a.entry_lastname";; break; } $customers_query_raw = "SELECT c.customers_id , c.customers_default_address_id, c.customers_email_address, c.customers_telephone,a.address_book_id, a.customers_id, a.entry_firstname, a.entry_lastname, a.entry_street_address, a.entry_suburb, a.entry_city, a.entry_state, a.entry_postcode FROM " . TABLE_CUSTOMERS . " c LEFT JOIN " . TABLE_ADDRESS_BOOK . " a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id ORDER BY $db_orderby $sorted"; $customers_query = tep_db_query($customers_query_raw); //BOF HEADER ?> <tr class="dataTableHeadingRow"> <? /*<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_NUMBER; ?></td> */ ?> <td class="dataTableHeadingContent"><?php echo tep_sort_order ($orderby, $sorted, FULL_NAME, 'name');?></td> <td class="dataTableHeadingContent"><?php echo tep_sort_order ($orderby, $sorted, EMAIL, 'email');?></td> <td class="dataTableHeadingContent"><?php echo tep_sort_order ($orderby, $sorted, ADDRESS, 'address');?></td> <td class="dataTableHeadingContent"><?php echo tep_sort_order ($orderby, $sorted, CITY_NAME, 'city');?></td> <td class="dataTableHeadingContent"><?php echo tep_sort_order ($orderby, $sorted, STATE, 'state');?></td> <td class="dataTableHeadingContent"><?php echo tep_sort_order ($orderby, $sorted, POSTAL_CODE, 'pcode');?></td> <td class="dataTableHeadingContent"><?php echo tep_sort_order ($orderby, $sorted, CONTRY_NAME, 'country');?></td> <td class="dataTableHeadingContent"><?php echo tep_sort_order ($orderby, $sorted, TELEPHONE_NUMBER, 'telephone'); //EOF HEADER ?></td> </tr> <?PHP $num_rows = tep_db_num_rows($customers_query); while ($customers = tep_db_fetch_array($customers_query)) { if ( tep_not_null($customers['customers_id']) ) { $rows++; if (strlen($rows) < 2) { $rows = '0' . $rows; } $csv_accum .= "\n"; $email = '<a href="mailto:' . $customers['customers_email_address'] . '">' . $customers['customers_email_address'] . '</a>'; $full_name = '<a href="customers.php?cID=' . $customers['customers_id'] . '&action=edit"> ' . $customers['entry_lastname'] . ", " . $customers['entry_firstname'] . '</a>'; ?> <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)"> <? /* <td align="left" class="dataTableContent"><?php echo $rows; ?>.</td> */ ?> <td class="dataTableContent"><?php mirror_out($full_name);?></td> <td class="dataTableContent"><?php mirror_out($email); ?></td> <td class="dataTableContent"><?php mirror_out($customers['entry_street_address']); ?></td> <td class="dataTableContent"><?php mirror_out($customers['entry_city']); ?></td> <td class="dataTableContent"><?php mirror_out($customers['entry_state']); ?></td> <td class="dataTableContent"><?php mirror_out($customers['entry_postcode']); ?></td> <td class="dataTableContent"><?php mirror_out($customers['countries_name']); ?></td> <td class="dataTableContent"><?php mirror_out($customers['customers_telephone']); ?></td> </tr> <?php } else { } } ?> <!-- body_text_eof //--> </tr> <?PHP if ($num_rows>0 && !$print) { ?> <td class="smallText" colspan="4"><form action="<?php echo $_SERVER['PHP_SELF']; ?>" method=post> <input type='hidden' name='csv' value='<?php echo htmlentities($csv_accum, ENT_QUOTES); ?>'> <?php //suggested file name for csv, include year and month ?> <input type='hidden' name='saveas' value='Customer_List_<?php echo date("Y" . "_" . "m" . "_" . "d" . "_" . "Hi"); ?>'><input type="submit" value="<?php echo TEXT_BUTTON_REPORT_SAVE ;?>"></form> </td> </tr> <?php }; // end button for Save CSV ?> </table> <!-- body_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> </body> </html>