Jump to content


  • Content count

  • Joined

  • Last visited

Everything posted by janetgot

  1. We'd like to offer people a discount coupon if they submit a product review on our site, and I'm trying to figure out how best to implement this. I'm planning to install the Request a Review contribution (http://addons.oscommerce.com/info/5471) but I think we need a little more than that, since the write review form doesn't collect an email address, we'll need to manually pair up orders with reviews... has anybody done something like this and is there a contribution or solution that makes this work? Thanks! Janet
  2. janetgot

    [contribution] Simple Template System (sts)

    edited: sorry, the forum hiccupped and posted my question twice
  3. janetgot

    [contribution] Simple Template System (sts)

    edited: server hiccup...
  4. janetgot

    [contribution] Simple Template System (sts)

    I have a strange problem with a heavily modified shop that uses STS... I'm not sure when this problem started, but I am having no luck tracking down the issue/resolution and am hoping somebody here can help. My issue is with my menu... I have Top level categories and 2 levels of subcategories. From the homepage all the menus go to the proper category page and display the correct STS template. But if I click into a Subcategory, and then from there click BACK to a top level category, the cPath is holding on to the subcategory path, and while it displays the correct products, my template is not working, and it will show the template from the corresponding subcategory that is connected to that cPath... Right now, I have my categories.php page hardcoded with my menu. I know this is only a temporary fix, and I'd really appreciate any ideas on where I might find the problem? I'm not sure that this is an STS problem but since it is a problem calling the correct template, I am hoping somebody might have run into this issue too? Thanks, Janet If it helps, here is my categories.php file:
  5. janetgot

    "Dynamenu" for osCommerce

    I tried putting the code there, and the page ignored it... When I set this up on the dev site, I put the code with the rest of my includes in the sts_user_code.php file as such: $sts->start_capture(); require(DIR_WS_INCLUDES . 'boxes/dm_categories.php'); $sts->stop_capture('dmbox', 'box'); I have tried putting the footer code in application_bottom.php and in my STS footer box... The error shows up when I upload the sts_user_code.php file and this is the error I get: LayersMenu Error: setDirroot: ./ is not a directory. Halted. Can it be something in layersmenu-common.inc.php where the error initiates? function setDirrootCommon($dirroot) { if (!is_dir($dirroot)) { $this->error("setDirroot: $dirroot is not a directory."); return false; } if (substr($dirroot, -1) != '/') { $dirroot .= '/'; } $oldlength = strlen($this->dirroot); $foobar = strpos($this->libjsdir, $this->dirroot); if (!($foobar === false || $foobar != 0)) { $this->libjsdir = $dirroot . substr($this->libjsdir, $oldlength); } $foobar = strpos($this->imgdir, $this->dirroot); if (!($foobar === false || $foobar != 0)) { $this->imgdir = $dirroot . substr($this->imgdir, $oldlength); } $foobar = strpos($this->icondir, $this->dirroot); if (!($foobar === false || $foobar != 0)) { $this->icondir = $dirroot . substr($this->icondir, $oldlength); } $foobar = strpos($this->tpldir, $this->dirroot); if (!($foobar === false || $foobar != 0)) { $this->tpldir = $dirroot . substr($this->tpldir, $oldlength); } $this->dirroot = $dirroot; return true; }
  6. janetgot

    "Dynamenu" for osCommerce

    I am using STS and trying to install this on a live store. It worked on my dev server, but on the live site, I am get the following error: LayersMenu Error: setDirroot: ./ is not a directory. Halted. I get this error when I add this code to my sts_user_code.php file per the instructions from How to get Dynamenu to work with STSv4x By: Bill Kellum $sts->start_capture(); require(DIR_WS_BOXES . 'dm_categories.php'); $sts->stop_capture('dmbox', 'box'); Can somebody help me figure out how I can eliminate this error? Thanks, Janet
  7. janetgot

    [Contribution] Show Sub-categories

    I am having this same problem, and have tried this fix, but nothing changed... are there any updates to this fix? Thanks.
  8. janetgot

    Shipping Zone Question

    Josh, have you tried this contribution? I just installed it and it works great. http://www.oscommerce.com/community/contri...ons,3404/page,3
  9. janetgot

    free shipping

    Hi, I just installed this module, but I'm not seeing it show up on my checkout_shipping.php page... I am using this version: Free Shipping w/ Minimum Amount3.5e-b Ran the US Lower 48 SQL statement in update for us and canada ship zones And configured the module in admin, selecting the Lower 48 I am also using a tax zone for orders placed in Rhode Island. This is the only other Tax Zone in my list. But when I checkout, I don't see the free shipping option. I'm also using UPS and Zone Based Express Shipping Rates, which do show up. I turned off the OSC Free Shipping option in the Order Total Section. I'm stumped. Can anybody offer suggestions of what might be causing this to not work? Thanks, Janet
  10. janetgot

    Seperate Pricing Per Customer v3.5

    Hi Jan, I appreciate your help! I think you pointed me in the right direction... I looked at the case delete_attributes section and compared it to the install version. there was some code there I missed... I've included the code below... when I tried this, I get two confirm/cancel buttons side by side, and if I confirm using either one, the attribute deletes... should there be two here? Or is there something I need to adjust? Here's the code, and thank you so much for your assistance!
  11. janetgot

    Seperate Pricing Per Customer v3.5

    Hello, Thank you for this contribution, it is a big help to a client who wants wholesale pricing for her site. I am stuck on one silly thing now. On the admin side, my products attributes won't delete. I don't get an error message, but the attribute that is assigned to the product won't go away when I hit delete, and then confirm. I'll copy my code below. I think it might have started with this contribution because I don't see any other mods near this code. However, I do have QTPro V4 installed as well. Here's my code... any ideas?
  12. Thanks, I was able to sort it out and get it working again... I'll check out Contribution Tracker... sounds like it would be VERY helpful!
  13. Hi, I think I messed something up ! I'm in process of rebuilding an old osCommerce site using the latest versions of all the contributions, and I'm almost done. I have PWA installed and tested on my development server... all is well. However, here's where I messed up... I tranferred all my customers and order data from my old live database to my new database and I might have broken PWA there. Now on my newly moved site, when I fill out my address page in create_account.php and hit next, I get the following error: Here's where it coughs: I looked in my customer table and don't see the column, but I also don't see it in the english.sql for this app, so I'm a little stumped if I'm on the right track. If anybody has an idea of where I should look to fix it, I'd greatly appreciate it... meanwhile, I'll keep looking on my own and try adding the column back over on the dev site... Thanks, Janet
  14. janetgot

    [Contribution] STS v4

    Yes, I tried porting over the data, but it's not showing up... I think because my product categories do not match up with the old database. Bummer!
  15. janetgot

    [Contribution] STS v4

    I am not sure I'm asking in the right place, but perhaps somebody here can help. I have STS installed on a heavily modified version of osCommerce but needed to upgrade to the RC version, so I basically am starting from scratch and reinstalling using all the latest versions of my favorite contributions (like STS!). I have everything almost ready for prime time. The one thing I wasn't able to get ported over was the actual product/orders data for the "Bestsellers" info box. I moved over all the data from my live site's customers and orders tables, but it doesn't show up. If I put in a fake order, the product shows up as a bestseller, so I know it's working right in STS. I was just hoping to port over the historical data from the old site. When recreating the site I wasn't able to match up all my category ids, and I'm sure my product ids are also not the same... can somebody tell me if this is the problem with the data not transferring? If so, I'll just call it a night! Thanks so much, and again, thanks for a great contribution... this one makes all the difference! Janet
  16. Hi, I'm trying to add extra functionality to the Fast Easy Cross Sell contribution, similar to the Variation to cross sell module http://addons.oscommerce.com/info/2539, which fill in random products if you don't have products selected through the module... however, I'm getting errors (probably because I'm not a great php coder! :rolleyes: ) Here's the code from the original module: and here's my boggled code from the Fast Easy Checkout includes/modules/cross_sell_products.php my initial error is Parse error: parse error in \includes\modules\cross_sell_products.php on line 43 which is right at the start of the code... If I can get this to work, I can add it to the contibutions, as I think it is a great idea from the XSELL contribution. Any ideas on how to get it going? Thanks, Janet
  17. janetgot

    SUPPORT : XML Export contribution

    Hi, this is a great module and I was able to get it going without any troubles... my only question is when I do an export, it creates the initial file, but I'd like to be able to overwrite the file with the same name. Right now I have to manually delete the file in order to create a new version of the same name. Is there a way to do this? Many thanks, Janet
  18. janetgot

    Credit Card Providers

    I've used authorize.net on a bunch of clients and it's very easy to set up and works well with osCommerce. I found your post because another client wants to use QBMS because they are using it for their brick and mortar store and I'm trying to hack my way through it... if you don't mind, can you tell me what the difference is between the hosting and desktop? I'm not sure how to figure out which they have (I'm working remotely). Thanks, Janet
  19. janetgot

    Fast Easy Cross Sell

    I installed this on a fairly heavily modified store running v2.2 RC1... I can get to the Cross Sell page in admin, but if I enter a model number and hit the search button it just keeps taking me to the login screen. Any idea what I did wrong? I've rechecked my installation twice. Thanks, Janet
  20. janetgot

    Export orders into csv

    Hi, I'm hoping to get this contribution to work, however, when I use it, it only exports the customer contact information, and none of the order data (products info) is saved to the csv file. Here is my exportorders.php file. Any ideas? <?php /* $Id: exportorders.php,v 1.1 April 21, 2006 Harris Ahmed $ osCommerce, Open Source E-Commerce Solutions [url="http://www.oscommerce.com"]http://www.oscommerce.com[/url] Copyright © 2004 Oscommerce Use this module on your own risk. I will be updating a new one soon. This template is used to create the csv export for Ideal Computer Systems Accounting Software */ define('FILENAME_EXPORTORDERS', 'exportorders.php'); require('includes/application_top.php'); require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_EXPORTORDERS); // Check if the form is submitted if (!$submitted || $submitted != 1) { ?> <!-- header_eof //--> <!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"> </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="2"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> <td class="pageHeading" align="right"></td> </tr> </table></td> </tr> <!-- first ends // --> <tr> <td><table border="0" style="font-family:tahoma;font-size:11px;" width="100%" cellspacing="2" cellpadding="2"> <tr> <td><?php echo tep_draw_form('exportorders', FILENAME_EXPORTORDERS); ?> <table border="0" style="font-family:tahoma;font-size:11px;" cellpadding="3"> <tr> <td><?php echo INPUT_START; ?></td> <td><!-- input name="start" size="5" value="<?php echo $start; ?>"> --> <?php $orders_list_query = tep_db_query("SELECT orders_id, date_purchased FROM orders ORDER BY orders_id"); $orders_list_array = array(); $orders_list_array[] = array('id' => '', 'text' => '---'); while ($orders_list = tep_db_fetch_array($orders_list_query)) { $orders_list_array[] = array('id' => $orders_list['orders_id'], 'text' => $orders_list['orders_id']." - ".tep_date_short($orders_list['date_purchased'])); } echo ' ' . tep_draw_pull_down_menu('start', $orders_list_array, (isset($_GET['orders_id']) ? $_GET['orders_id'] : ''), 'size="1"') . ' '; ?></td> </tr> <tr> <td><?php echo INPUT_END; ?></td> <td><!-- <input name="end" size="5" value="<?php echo $end; ?>"> --> <?php echo ' ' . tep_draw_pull_down_menu('end', $orders_list_array, (isset($_GET['orders_id']) ? $_GET['orders_id'] : ''), 'size="1"') . ' '; ?></td> </tr> <tr> <td> </td> <td><input type="submit" value="<?php echo INPUT_VALID; ?>"></td> </tr> </table> <input type="hidden" name="submitted" value="1"> </form></td> </tr> <tr> <td><?php echo INPUT_DESC; ?></td> </tr> <tr> <td> </td> </tr> <tr> <td> </td> </tr> </table></td> </tr> </table></td> </tr> </table> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> <?php } // submitted so generate csv if the form is submitted else { generatecsv($start, $end); } // generates csv file from $start order to $end order, inclusive function generatecsv($start, $end) { // Patch dlan // if both fields are empty we select all orders if ($start=="" && $end=="") { $orders = tep_db_query("SELECT orders_id, date_purchased, customers_name, cc_owner, customers_company, customers_email_address, billing_street_address, billing_city, billing_state, billing_postcode, billing_country, customers_telephone, delivery_name, delivery_company, delivery_street_address, delivery_city, delivery_state, delivery_postcode, delivery_country, cc_type, cc_number, cc_expires FROM orders ORDER BY orders_id"); // if $start is empty we select all orders up to $end } else if($start=="" && $end!="") { $orders = tep_db_query("SELECT orders_id, date_purchased, customers_name, cc_owner, customers_company, customers_email_address, billing_street_address, billing_city, billing_state, billing_postcode, billing_country, customers_telephone, delivery_name, delivery_company, delivery_street_address, delivery_city, delivery_state, delivery_postcode, delivery_country, cc_type, cc_number, cc_expires FROM orders WHERE orders_id <= $end ORDER BY orders_id"); // if $end is empty we select all orders from $start } else if($start!="" && $end=="") { $orders = tep_db_query("SELECT orders_id, date_purchased, customers_name, cc_owner, customers_company, customers_email_address, billing_street_address, billing_city, billing_state, billing_postcode, billing_country, customers_telephone, delivery_name, delivery_company, delivery_street_address, delivery_city, delivery_state, delivery_postcode, delivery_country, cc_type, cc_number, cc_expires FROM orders WHERE orders_id >= $start ORDER BY orders_id"); // if both fields are filed in we select orders betwenn $start and $end } else { $orders = tep_db_query("SELECT orders_id, date_purchased, customers_name, cc_owner, customers_company, customers_email_address, billing_street_address, billing_city, billing_state, billing_postcode, billing_country, customers_telephone, delivery_name, delivery_company, delivery_street_address, delivery_city, delivery_state, delivery_postcode, delivery_country, cc_type, cc_number, cc_expires FROM orders WHERE orders_id >= $start AND orders_id <= $end ORDER BY orders_id"); } //patch //$csv_output ="\n"; while ($row_orders = mysql_fetch_array($orders)) { //start one loop $Orders_id = $row_orders["orders_id"]; $Date1 = $row_orders["date_purchased"]; //list($Date, $Time) = explode (' ',$Date1); $Date = date('m/d/Y', strtotime($Date1)); $Time= date('H:i:s', strtotime($Date1)); $Name_On_Card1 = $row_orders["customers_name"]; $Name_On_Card = filter_text($Name_On_Card1);// order changed list($First_Name,$Last_Name) = explode(', ',$Name_On_Card1); // order changed $Company = filter_text($row_orders["customers_company"]); $email = filter_text($row_orders["customers_email_address"]); $Billing_Address_1 = filter_text($row_orders["billing_street_address"]); $Billing_Address_2 = ""; $Billing_City = filter_text($row_orders["billing_city"]); $Billing_State = filter_text($row_orders["billing_state"]); $Billing_Zip = filter_text($row_orders["billing_postcode"]); $Billing_Country = str_replace("(48 Contiguous Sta", "", $row_orders["billing_country"]); $Billing_Phone = filter_text($row_orders["customers_telephone"]); $ShipTo_Name1 = $row_orders["delivery_name"]; $ShipTo_Name = filter_text($ShipTo_Name1); // order changed list($ShipTo_First_Name,$ShipTo_Last_Name) = explode(', ',$ShipTo_Name1); // order changed $ShipTo_Company = filter_text($row_orders["delivery_company"]); $ShipTo_Address_1 = filter_text($row_orders["delivery_street_address"]); $ShipTo_Address_2 = ""; $ShipTo_City = filter_text($row_orders["delivery_city"]); $ShipTo_State = filter_text($row_orders["delivery_state"]); $ShipTo_Zip = filter_text($row_orders["delivery_postcode"]); $ShipTo_Country = str_replace("(48 Contiguous Sta", "", $row_orders["delivery_country"]); $ShipTo_Phone = ""; $Card_Type = $row_orders["cc_type"]; $Card_Number = $row_orders["cc_number"]; $Exp_Date = $row_orders["cc_expires"]; $Bank_Name = ""; $Gateway = ""; $AVS_Code = ""; $Transaction_ID = ""; $Order_Special_Notes = ""; // -------------------- QUERIES 1 ------------------------------------// //Orders_status_history for comments $orders_status_history = tep_db_query("select comments from orders_status_history where orders_id = " . $Orders_id); //$row_orders_status_history = tep_db_fetch_array($comments); while($row_orders_status_history = mysql_fetch_array($orders_status_history)) { // end // $Comments = filter_text($row_orders_status_history["comments"]); } // -------------------- QUERIES 2 ------------------------------------// //Orders_subtotal $orders_subtotal = tep_db_query("select value from orders_total where class = 'ot_subtotal' and orders_id = " . $Orders_id); //$row_orders_subtotal = tep_db_fetch_array($orders_subtotal); while($row_orders_subtotal = mysql_fetch_array($orders_subtotal)) { // end // $Order_Subtotal = filter_text($row_orders_subtotal["value"]); } // -------------------- QUERIES 3 ------------------------------------// //Orders_tax $orders_tax = tep_db_query("select value from orders_total where class = 'ot_tax' and orders_id = " . $Orders_id); //$row_orders_tax = tep_db_fetch_array($orders_tax); while($row_orders_tax = mysql_fetch_array($orders_tax)) { // end // $Order_Tax = filter_text($row_orders_tax["value"]); } // -------------------- QUERIES 4 ------------------------------------// //Orders_Insurance $orders_insurance = tep_db_query("select value from orders_total where class = 'ot_insurance' and orders_id = " . $Orders_id); //$row_orders_insurance = tep_db_fetch_array($orders_insurance); while($row_orders_insurance = mysql_fetch_array($orders_insurance)) { // end // $Order_Insurance = filter_text($row_orders_insurance["value"]); } $Tax_Exempt_Message = ""; // -------------------- QUERIES 5 ------------------------------------// //Orders_Shipping $orders_shipping = tep_db_query("select title, value from orders_total where class = 'ot_shipping' and orders_id = " . $Orders_id); //$row_orders_shipping = tep_db_fetch_array($orders_shipping); while($row_orders_shipping = mysql_fetch_array($orders_shipping)) { // end // $Order_Shipping_Total = $row_orders_shipping["value"]; $Shipping_Method = filter_text($row_orders_shipping["title"]); // Shipping method from query 5 } // -------------------- QUERIES 6 ------------------------------------// //Orders_Residential Del Fee (Giftwrap) $orders_residential_fee = tep_db_query("select value from orders_total where class = 'ot_giftwrap' and orders_id = " . $Orders_id); //$row_orders_residential_fee = tep_db_fetch_array($orders_residential_fee); while($row_orders_residential_fee = mysql_fetch_array($orders_residential_fee)) { // end // $Small_Order_Fee = $row_orders_residential_fee["value"]; } //////////////////////////////////// $Discount_Rate = ""; $Discount_Message = ""; $CODAmount = ""; // -------------------- QUERIES 7 ------------------------------------// //Orders_Total $orders_total = tep_db_query("select value from orders_total where class = 'ot_total' and orders_id = " . $Orders_id); //$row_orders_total = tep_db_fetch_array($orders_total); while($row_orders_total = mysql_fetch_array($orders_total)) { // end // $Order_Grand_Total = $row_orders_total["value"]; } // -------------------- QUERIES 8 ------------------------------------// //Products COunt $orders_count = tep_db_query("select count(products_quantity) as o_count from orders_products where orders_id = " . $Orders_id); //$row_orders_total = tep_db_fetch_array($orders_total); while($row_orders_count = mysql_fetch_array($orders_count)) { // end // $Number_of_Items = $row_orders_count[0]; // used array to show the number of items ordered } // $Shipping_Weight = ""; $Coupon_Code = ""; $Order_security_msg = ""; $Order_Surcharge_Amount = ""; $Order_Surcharge_Something = ""; $Affiliate_code = ""; $Sentiment_message = ""; $Checkout_form_type = ""; $Card_CVV_value = $row_orders["cvvnumber"]; $future1 = ""; $future2 = ""; $future3 = ""; $future4 = ""; $future5 = ""; $future6 = ""; $future7 = ""; $future8 = ""; $future9 = ""; // csv settings $CSV_SEPARATOR = ","; $CSV_NEWLINE = "\r\n"; $csv_output .= $Orders_id . "," ; $csv_output .= $Date . "," ; $csv_output .= $Time . "," ; $csv_output .= $First_Name . "," ; $csv_output .= $Last_Name . "," ; $csv_output .= $Name_On_Card . "," ; $csv_output .= $Company . "," ; $csv_output .= $email . "," ; $csv_output .= $Billing_Address_1 . "," ; $csv_output .= $Billing_Address_2 . "," ; $csv_output .= $Billing_City . "," ; $csv_output .= $Billing_State . "," ; $csv_output .= $Billing_Zip . "," ; $csv_output .= $Billing_Country . "," ; $csv_output .= $Billing_Phone . "," ; $csv_output .= $ShipTo_First_Name . "," ; $csv_output .= $ShipTo_Last_Name . "," ; $csv_output .= $ShipTo_Name . "," ; $csv_output .= $ShipTo_Company . "," ; $csv_output .= $ShipTo_Address_1 . "," ; $csv_output .= $ShipTo_Address_2 . "," ; $csv_output .= $ShipTo_City . "," ; $csv_output .= $ShipTo_State . "," ; $csv_output .= $ShipTo_Zip . "," ; $csv_output .= $ShipTo_Country . "," ; $csv_output .= $ShipTo_Phone . "," ; $csv_output .= $Card_Type . "," ; $csv_output .= $Card_Number . "," ; $csv_output .= $Exp_Date . "," ; $csv_output .= $Bank_Name . "," ; $csv_output .= $Gateway . "," ; $csv_output .= $AVS_Code . "," ; $csv_output .= $Transaction_ID . "," ; $csv_output .= $Order_Special_Notes . "," ; $csv_output .= $Comments . "," ; $csv_output .= $Order_Subtotal . "," ; $csv_output .= $Order_Tax . "," ; $csv_output .= $Order_Insurance . "," ; $csv_output .= $Tax_Exempt_Message . "," ; $csv_output .= $Order_Shipping_Total . "," ; $csv_output .= $Small_Order_Fee . "," ; $csv_output .= $Discount_Rate . "," ; $csv_output .= $Discount_Message . "," ; $csv_output .= $CODAmount . "," ; $csv_output .= $Order_Grand_Total . "," ; $csv_output .= $Number_of_Items . "," ; $csv_output .= $Shipping_Method . "," ; $csv_output .= $Shipping_Weight . "," ; $csv_output .= $Coupon_Code . "," ; $csv_output .= $Order_security_msg . "," ; $csv_output .= $Order_Surcharge_Amount . "," ; $csv_output .= $Order_Surcharge_Something . "," ; $csv_output .= $Affiliate_code . "," ; $csv_output .= $Sentiment_message . "," ; $csv_output .= $Checkout_form_type . "," ; $csv_output .= $Card_CVV_value . "," ; $csv_output .= $future1 . "," ; $csv_output .= $future2 . "," ; $csv_output .= $future3 . "," ; $csv_output .= $future4 . "," ; $csv_output .= $future5 . "," ; $csv_output .= $future6 . "," ; $csv_output .= $future7 . "," ; $csv_output .= $future8 . "," ; $csv_output .= $future9 ; // -------------------- QUERIES 9 ------------------------------------// //Get list of products ordered $orders_products = tep_db_query("select products_model, products_price, products_quantity, products_name from orders_products where orders_id = " . $Orders_id); // While loop to list the item while($row_orders_products = mysql_fetch_array($orders_products)) { $csv_output .= "," . "BEGIN_ITEM". "," ; $csv_output .= filter_text($row_orders_products[0]) . "," ; $csv_output .= $row_orders_products[1] . "," ; $csv_output .= $row_orders_products[2] . "," ; $csv_output .= filter_text($row_orders_products[3]) . "," ; $csv_output .= "END_ITEM"; } // end while loop for products // --------------------------------------------------------------------------// $csv_output .= "\n"; } // while loop main first //print header("Content-Type: application/force-download\n"); header("Cache-Control: cache, must-revalidate"); header("Pragma: public"); header("Content-Disposition: attachment; filename=ordersexports_" . date("Ymd") . ".csv"); print $csv_output; exit; }//function main function filter_text($text) { $filter_array = array(",","\r","\n","\t"); return str_replace($filter_array,"",$text); } // function for the filter ?>
  21. janetgot

    Master Products - MS2

    Edited -- never mind... found the answer in the forums almost as soon as I had asked... thank you very much... the answer is here http://forums.oscommerce.com/index.php?s=&...t&p=1167467 Forgive me if this is covered someplace in this forum, but I've been looking and am not sure what to search on... anyway, I have Master Products installed and for the most part, it is working correctly, however, we have a weird situation in that sometimes the slave will show up under the wrong Master, even though it is assigned to the correct Master. I'm trying to narrow down why/how this happens but so far, it's a mystery. The one interesting clue I've noticed is when it happens the product id's are similar (for example, if I have a product id of 98, it is also showing the slaves for product id 198, but not vice versa) Has anybody seen this before and can you point me in the right direction for bug fixing? Meanwhile, I'll keep plugging away... Many thanks, Janet
  22. janetgot

    [Contribution] STS v4

    Hi Bill, thanks for your response... I'll review to see where that piece of code came from... it could be related to Ultrapics and/or the Lightbox module for Ultrapics... any way I removed that snippet, but it didn't get my little padlock to show, so I'm still looking. I didn't post the domain quite yet, just being careful since the site isn't yet ready for primetime, but I could email you the url if you think you might have some advice on getting the padlock... I've lost two days on it so far! Thanks, Janet
  23. janetgot

    [Contribution] STS v4

    Hello, I've been using STS on all my stores and I couldn't live without it... I do have a question about a new site and I'm hoping for some guidance. I've installed STSv4.5.8 on a new store and also installed Header Tags using the "How to install Header Tags Controller with the Simple Template System v4x" and I think I have it installed correctly and things are working. However, I installed my SSL certificate and am testing the site and am having a problem getting my padlock to show up on the https pages. I've been pouring over the forums looking for suggestions, and one thing I'm wondering is is the following code could be causing the problem... the code (when I view source code) is: <!-- start get_javascript(applicationtop2header) //--> <script language="javascript"><!-- function session_win() { window.open("http://www.mydomain.com/info_shopping_cart.php?osCsid=79ap2qvn77nqjqitn849bkids6","info_shopping_cart","height=460,width=430,toolbar=no,statusbar=no,scrollbars=yes").focus(); } //--></script> <!-- end get_javascript(applicationtop2header) //--> It seems to be sts related. I have another site on the same hosting that uses an older version of sts and I don't see this code when I view source code. On that site, the SSL padlock is showing on the correct pages. Am I on to something here, and if so, can somebody please guide me to how I can tweak it to make my SSL happy? Many thanks, Janet
  24. janetgot

    [Contribution] - USPS Methods

    Hi, I just wanted to thank you for this contribution... just installed it and it is working just fine... I did have a "can't resend headers" error with the functions/general.php file, and found that the call was already inserted from the Header Tags Controller contribution. I took out that snippet, and did a fresh install of the module and all was well. If somebody has the same problem and you are running Header Tags, see if you have a duplicate in functions/general.php file of this code: function tep_cfg_select_multioption($select_array, $key_value, $key = '') { for ($i=0; $i<sizeof($select_array); $i++) { $name = (($key) ? 'configuration[' . $key . '][]' : 'configuration_value'); $string .= '<br><input type="checkbox" name="' . $name . '" value="' . $select_array[$i] . '"'; $key_values = explode( ", ", $key_value); if ( in_array($select_array[$i], $key_values) ) $string .= ' CHECKED'; $string .= '> ' . $select_array[$i]; } $string .= '<input type="hidden" name="' . $name . '" value="--none--">'; return $string; } Hope this helps somebody, and thanks again! Janet
  25. Hi, I have been trying to get Easy Populate to import my data correctly, and am having the same problem this person did. I made the changes at outlined above, but I'm still having the first character of my data dropped when I import. The data I'm importing is a little different, however, in that it has single and double quotes in the title (as in this: Kainui Team Leash - 6' x 1/4"). Can anybody provide any thoughts to resolving this? Also, I have this in my product names which is also causing the problem... Thanks, Janet