Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

ComicWisdom

Archived
  • Posts

    650
  • Joined

  • Last visited

Everything posted by ComicWisdom

  1. I have downloaded and installed Ultra Pics 2.04 from 8 Dec 2007 because I don't want the lightbox contribution. There is a note in this contribution about the bug fix because it was popping up the wrong images. My installation is still popping up the wrong images. I believe I still need a correct version of additional_images.php I have tried scavanging one from different version of the contribution but have had no luck. Can someone lead me to the latest corrected version that does not have Lighbox in it and the DOES popup the CORRECT IMAGES? Or give me some instructions for fixing this. I checked the mysql database and the correct images info is definitely being upload there. Thank you,
  2. Sorry but I can't seem to get this to post to the correct thread. I have downloaded and installed Ultra Pics 2.04 from 8 Dec 2007 because I don't want the lightbox contribution. There is a note in this contribution about the bug fix because it was popping up the wrong images. My installation is still popping up the wrong images. I believe I still need a correct version of additional_images.php I have tried scavanging one from different version of the contribution but have had no luck. Can someone lead me to the latest corrected version that does not have Lighbox in it and the DOES popup the CORRECT IMAGES? Or give me some instructions for fixing this. I checked the mysql database and the correct images info is definitely being upload there. Thank you,
  3. Sometimes feet work better than heads!! Whatever that means!! I did update the database, but did forget to uninstall and reinstall the module. Sorry.
  4. I have already done that. The error persists. Field Type Collation Attributes Null Default Extra Action configuration_id int(11) No auto_increment configuration_title varchar(64) latin1_swedish_ci No configuration_key varchar(64) latin1_swedish_ci No configuration_value varchar(255) latin1_swedish_ci No configuration_description varchar(255) latin1_swedish_ci No configuration_group_id int(11) No 0 sort_order int(5) Yes NULL last_modified datetime Yes NULL date_added datetime No 0000-00-00 00:00:00 use_function varchar(255) latin1_swedish_ci Yes NULL set_function text latin1_swedish
  5. I don't know how this got here, I tried to post it to the support forum at http://www.oscommerce.com/forums/index.php?showtopic=146950
  6. I installed the USPS methods module and when I hit the edit button in admin I get the following error message Parse error: syntax error, unexpected T_GLOBAL, expecting ')' in /home/mysite/public_html/catalog/admin/modules.php(224) : eval()'d code on line 1 I have gone through the installation twice and cannot seem to find the error. Could someone help? Here is the code: <?php /* $Id: modules.php,v 1.47 2003/06/29 22:50:52 hpdl Exp $ 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'); $set = (isset($HTTP_GET_VARS['set']) ? $HTTP_GET_VARS['set'] : ''); if (tep_not_null($set)) { switch ($set) { // START STS 4.1 case 'sts': $module_type = 'sts'; $module_directory = DIR_FS_CATALOG_MODULES . 'sts/'; $module_key = 'MODULE_STS_INSTALLED'; define('HEADING_TITLE', HEADING_TITLE_MODULES_STS); break; // END STS 4.1 case 'shipping': $module_type = 'shipping'; $module_directory = DIR_FS_CATALOG_MODULES . 'shipping/'; $module_key = 'MODULE_SHIPPING_INSTALLED'; define('HEADING_TITLE', HEADING_TITLE_MODULES_SHIPPING); break; case 'ordertotal': $module_type = 'order_total'; $module_directory = DIR_FS_CATALOG_MODULES . 'order_total/'; $module_key = 'MODULE_ORDER_TOTAL_INSTALLED'; define('HEADING_TITLE', HEADING_TITLE_MODULES_ORDER_TOTAL); break; case 'payment': default: $module_type = 'payment'; $module_directory = DIR_FS_CATALOG_MODULES . 'payment/'; $module_key = 'MODULE_PAYMENT_INSTALLED'; define('HEADING_TITLE', HEADING_TITLE_MODULES_PAYMENT); break; } } $action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : ''); if (tep_not_null($action)) { switch ($action) { case 'save': while (list($key, $value) = each($HTTP_POST_VARS['configuration'])) { if( is_array( $value ) ){ $value = implode( ", ", $value); $value = ereg_replace (", --none--", "", $value); } tep_db_query("update " . TABLE_CONFIGURATION . " set configuration_value = '" . $value . "' where configuration_key = '" . $key . "'"); } tep_redirect(tep_href_link(FILENAME_MODULES, 'set=' . $set . '&module=' . $HTTP_GET_VARS['module'])); break; case 'install': case 'remove': $file_extension = substr($PHP_SELF, strrpos($PHP_SELF, '.')); $class = basename($HTTP_GET_VARS['module']); if (file_exists($module_directory . $class . $file_extension)) { include($module_directory . $class . $file_extension); $module = new $class; if ($action == 'install') { $module->install(); } elseif ($action == 'remove') { $module->remove(); } } tep_redirect(tep_href_link(FILENAME_MODULES, 'set=' . $set . '&module=' . $class)); break; } } ?> <!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="2"> <tr> <td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> </tr> </table></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_MODULES; ?></td> <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_SORT_ORDER; ?></td> <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?> </td> </tr> <?php $file_extension = substr($PHP_SELF, strrpos($PHP_SELF, '.')); $directory_array = array(); if ($dir = @dir($module_directory)) { while ($file = $dir->read()) { if (!is_dir($module_directory . $file)) { if (substr($file, strrpos($file, '.')) == $file_extension) { $directory_array[] = $file; } } } sort($directory_array); $dir->close(); } $installed_modules = array(); for ($i=0, $n=sizeof($directory_array); $i<$n; $i++) { $file = $directory_array[$i]; include(DIR_FS_CATALOG_LANGUAGES . $language . '/modules/' . $module_type . '/' . $file); include($module_directory . $file); $class = substr($file, 0, strrpos($file, '.')); if (tep_class_exists($class)) { $module = new $class; if ($module->check() > 0) { if ($module->sort_order > 0) { $installed_modules[$module->sort_order] = $file; } else { $installed_modules[] = $file; } } if ((!isset($HTTP_GET_VARS['module']) || (isset($HTTP_GET_VARS['module']) && ($HTTP_GET_VARS['module'] == $class))) && !isset($mInfo)) { $module_info = array('code' => $module->code, 'title' => $module->title, 'description' => $module->description, 'status' => $module->check()); $module_keys = $module->keys(); $keys_extra = array(); for ($j=0, $k=sizeof($module_keys); $j<$k; $j++) { $key_value_query = tep_db_query("select configuration_title, configuration_value, configuration_description, use_function, set_function from " . TABLE_CONFIGURATION . " where configuration_key = '" . $module_keys[$j] . "'"); $key_value = tep_db_fetch_array($key_value_query); $keys_extra[$module_keys[$j]]['title'] = $key_value['configuration_title']; $keys_extra[$module_keys[$j]]['value'] = $key_value['configuration_value']; $keys_extra[$module_keys[$j]]['description'] = $key_value['configuration_description']; $keys_extra[$module_keys[$j]]['use_function'] = $key_value['use_function']; $keys_extra[$module_keys[$j]]['set_function'] = $key_value['set_function']; } $module_info['keys'] = $keys_extra; $mInfo = new objectInfo($module_info); } if (isset($mInfo) && is_object($mInfo) && ($class == $mInfo->code) ) { if ($module->check() > 0) { echo ' <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_MODULES, 'set=' . $set . '&module=' . $class . '&action=edit') . '\'">' . "\n"; } else { echo ' <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)">' . "\n"; } } else { echo ' <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_MODULES, 'set=' . $set . '&module=' . $class) . '\'">' . "\n"; } ?> <td class="dataTableContent"><?php echo $module->title; ?></td> <td class="dataTableContent" align="right"><?php if (is_numeric($module->sort_order)) echo $module->sort_order; ?></td> <td class="dataTableContent" align="right"><?php if (isset($mInfo) && is_object($mInfo) && ($class == $mInfo->code) ) { echo tep_image(DIR_WS_IMAGES . 'icon_arrow_right.gif'); } else { echo '<a href="' . tep_href_link(FILENAME_MODULES, 'set=' . $set . '&module=' . $class) . '">' . tep_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . '</a>'; } ?> </td> </tr> <?php } } ksort($installed_modules); $check_query = tep_db_query("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = '" . $module_key . "'"); if (tep_db_num_rows($check_query)) { $check = tep_db_fetch_array($check_query); if ($check['configuration_value'] != implode(';', $installed_modules)) { tep_db_query("update " . TABLE_CONFIGURATION . " set configuration_value = '" . implode(';', $installed_modules) . "', last_modified = now() where configuration_key = '" . $module_key . "'"); } } else { tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Installed Modules', '" . $module_key . "', '" . implode(';', $installed_modules) . "', 'This is automatically updated. No need to edit.', '6', '0', now())"); } ?> <tr> <td colspan="3" class="smallText"><?php echo TEXT_MODULE_DIRECTORY . ' ' . $module_directory; ?></td> </tr> </table></td> <?php $heading = array(); $contents = array(); switch ($action) { case 'edit': $keys = ''; reset($mInfo->keys); while (list($key, $value) = each($mInfo->keys)) { $keys .= '<b>' . $value['title'] . '</b><br>' . $value['description'] . '<br>'; if ($value['set_function']) { eval('$keys .= ' . $value['set_function'] . "'" . $value['value'] . "', '" . $key . "');"); } else { $keys .= tep_draw_input_field('configuration[' . $key . ']', $value['value']); } $keys .= '<br><br>'; } $keys = substr($keys, 0, strrpos($keys, '<br><br>')); $heading[] = array('text' => '<b>' . $mInfo->title . '</b>'); $contents = array('form' => tep_draw_form('modules', FILENAME_MODULES, 'set=' . $set . '&module=' . $HTTP_GET_VARS['module'] . '&action=save')); $contents[] = array('text' => $keys); $contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_update.gif', IMAGE_UPDATE) . ' <a href="' . tep_href_link(FILENAME_MODULES, 'set=' . $set . '&module=' . $HTTP_GET_VARS['module']) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'); break; default: $heading[] = array('text' => '<b>' . $mInfo->title . '</b>'); if ($mInfo->status == '1') { $keys = ''; reset($mInfo->keys); while (list(, $value) = each($mInfo->keys)) { $keys .= '<b>' . $value['title'] . '</b><br>'; if ($value['use_function']) { $use_function = $value['use_function']; if (ereg('->', $use_function)) { $class_method = explode('->', $use_function); if (!is_object(${$class_method[0]})) { include(DIR_WS_CLASSES . $class_method[0] . '.php'); ${$class_method[0]} = new $class_method[0](); } $keys .= tep_call_function($class_method[1], $value['value'], ${$class_method[0]}); } else { $keys .= tep_call_function($use_function, $value['value']); } } else { $keys .= $value['value']; } $keys .= '<br><br>'; } $keys = substr($keys, 0, strrpos($keys, '<br><br>')); $contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(FILENAME_MODULES, 'set=' . $set . '&module=' . $mInfo->code . '&action=remove') . '">' . tep_image_button('button_module_remove.gif', IMAGE_MODULE_REMOVE) . '</a> <a href="' . tep_href_link(FILENAME_MODULES, 'set=' . $set . (isset($HTTP_GET_VARS['module']) ? '&module=' . $HTTP_GET_VARS['module'] : '') . '&action=edit') . '">' . tep_image_button('button_edit.gif', IMAGE_EDIT) . '</a>'); $contents[] = array('text' => '<br>' . $mInfo->description); $contents[] = array('text' => '<br>' . $keys); } else { $contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(FILENAME_MODULES, 'set=' . $set . '&module=' . $mInfo->code . '&action=install') . '">' . tep_image_button('button_module_install.gif', IMAGE_MODULE_INSTALL) . '</a>'); $contents[] = array('text' => '<br>' . $mInfo->description); } break; } if ( (tep_not_null($heading)) && (tep_not_null($contents)) ) { echo ' <td width="25%" valign="top">' . "\n"; $box = new box; echo $box->infoBox($heading, $contents); echo ' </td>' . "\n"; } ?> </tr> </table></td> </tr> </table></td> <!-- body_text_eof //--> </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'); ?>
  7. I seem to have something recursive in my STS installation, but I can't find it. When I turn on STS templates, I get the following message which goes away as soon as I turn it off again. Fatal error: Cannot redeclare clean_html_comments() (previously declared in /............/catalog/includes/functions/clean_html_comments.php:13) in /............/catalog/includes/functions/clean_html_comments.php on line 13 Could someone give me a clue as to what I did? Thank you
  8. Hi Jack, I downloaded a new copy of header tag controllers and replaced both of those files. Indeed the product_info page was included. All text was set at defaults. I filled in the pages as I did before (did not make a product_info page since it existed), filled all tags. I checked all 4 boxes for the product_info page. All stayed checked this time. Still all pages fill perfectly except for product_info. The source code from IE for the header for product_info is here. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html $htmlparams> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <title>Treasure Mountain Mining</title><base href="http://www.xxxxxxxxx.com/catalog/"> <!-- start get_javascript(applicationtop2header) //--> <script language="javascript"><!-- function popupWindow(url) { window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,re sizable=yes,copyhistory=no,width=780,height=600,screenX=150,screenY=150,top=20,le ft=20') } //--></script> <!-- end get_javascript(applicationtop2header) //--> <meta http-equiv="Content-Language" content="en-us"> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <title></title> <link rel="stylesheet" type="text/css" href="stylesheet.css"> </head> Here is the source code from the categories page (index.php) filled properly. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <!-- #BeginTemplate "!template_index.php.dwt" --> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <title>Alexandrite - xxxxxxxxxx - Mineral Specimen, Crystals, Gemstones for sale</title> <meta name="Description" content="Alexandrite Dealer in Gemstones, Mineral Specimen, Crystals with Metaphysic or Metaphysical Properties" /> <meta name="Keywords" content="Alexandrite, ,mineral specimen,gemstones,crystals,mineral,specimen,for sale,gemstone,crystal,metaphysic,metaphysical,amethyst,aquamarine,azurite,citrin e,copper,diamond,dioptase,emerald,fluorite,gold,heliodor,meteorite,phenakite,pyri te,quartz,quartz tourmaline,ruby" /> <meta name="robots" content="noodp" /> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <!-- EOF: Generated Meta Tags --> <base href="http://www.xxxxxxxxxxx.com/catalog/"> <!-- start get_javascript(applicationtop2header) //--> <!-- end get_javascript(applicationtop2header) //--> <meta http-equiv="Author" content="Ralph, http://www.xxxxxxxx.com"> <meta http-equiv="Copyright" content="http;//www.xxxxx.com"> <meta http-equiv="Distribution" content="Global"> <link rel="stylesheet" type="text/css" href="stylesheet.css"> </head>
  9. If this appears as a double post it's because I think I posted it the wrong area the first time. I have Header Tag Controllers running on my site. It is working great on all pages except those generated by product_info.php I have added the page product_info on the page control page. I have filled in the text control page... noticed that this page has an HTPA check box which will not stay checked. I have filled "all tags" on the fill tags page Still I get no info filled in for files created by product_info.php Any ideas what is going wrong? If you need the site info I will send it by PM
  10. I have Header Tag Controllers running on my site. It is working great on all pages except those generated by product_info.php I have added the page product_info on the page control page. I have filled in the text control page... noticed that this page has an HTPA check box which will not stay checked. I have filled "all tags" on the fill tags page Still I get no info filled in for files created by product_info.php Any ideas what is going wrong? If you need the site info I will send it by PM
  11. Hi, I just finished installing STS, I am now getting this message when attempting to display the catalog. Fatal error: Cannot redeclare tep_get_category_tree() (previously declared in /hsphere/local/home/username/domain/catalog/includes/modules/sts_inc/sts_user_code.php:33) in /hsphere/local/home/username/domain/catalog/includes/modules/sts_inc/sts_user_code.php on line 33 Can someone help with this? Thank you
  12. I certainly must have done something wrong because on both of the options I get blank pages. I went back through the instructions and found this. Is this where I made my mistake. The "should look like this" doesn't seem to give the results the instructions indicate. Am I misinterpreting it?
  13. Oop! I think I posted this in the wrong spot. I am going to try to repost in the correct location.
  14. I certainly must have done something wrong because on both of the options I get blank pages. I went back through the instructions and found this. Is this where I made my mistake. The should look like doesn't seem to give the results the instructions indicate. Am I misinterpreting it?
  15. oops! Actually no products show up. What I thought was a product was an item in an infobox.
  16. I have installed dynamic site map. When I run mysite.com/catalog/dynamic_sitemap.php I get only one product listed. I can't find any errors? Anyone have an idea? Ralph
  17. I have STS with HTC installed. Everything seems to work fine, but when I check the source in my browser, the META tags show the old information for the pages as show below. I don't believe I have that info in my store at all anymore. <meta name="Description" content="A osCommerce : What's New Here? - Hardware Software DVD Movies"/> <meta name="Keywords" content="A, - Hardware Software DVD Movies What's New Here?"/> Where does HTC get this info and how do I get it to change? I went directly into the "A" section of my database and filled in the header tag fields by hand, but instead of the new info, this old info keeps showing up.
  18. Did I do something wrong or is this a flaw??? When a customer creates an account, if they don't log out but instead press the continue button, they can place an immediate order. If, however, they leave the store, they can't log back in again until they're approved. What did I miss? Any ideas?
  19. I found my mistake. I added index.php to the list of files under default in admin/sts/default Thank you to all who looked and tried to help!! :D
  20. This error doesn't make sense to me. I have Simple Templates running on 3 sites now, and I've never seen this one before. As far as I know, the file it claims it can't open isn't supposed to exist. Warning: main(includes/modules/sts_inc/index.php): failed to open stream: No such file or directory in /hsphere/local/home/netkraft/mohawkmovies.com/catalog/includes/modules/sts_inc/sts_display_output.php on line 21 Warning: main(includes/modules/sts_inc/index.php): failed to open stream: No such file or directory in /hsphere/local/home/netkraft/mohawkmovies.com/catalog/includes/modules/sts_inc/sts_display_output.php on line 21 Warning: main(): Failed opening 'includes/modules/sts_inc/index.php' for inclusion (include_path='.:/usr/local/lib/php:/usr/local/lib/php/PEAR:/usr/local/share/pear') in /hsphere/local/home/netkraft/mohawkmovies.com/catalog/includes/modules/sts_inc/sts_display_output.php on line 21 Can someone give me a clue? Or am I wrong that there should be an includes/modules/sts_inc/index.php. It doesn't exist in any other site. By the way. This is a fresh install in a new store and except for STS, I haven't touched any other code or used any other contributions.... yet.
  21. A strange strange phenomena. I have installed the configuration cache contribution. Everything seemed to go smoothly except neither my webshell nor my ftp program would set the config_cache.php file to 777. I got in touch with my host and they did it from their end. I checked it and it was correct. When I went in again, it was set back to 644. Does anyone know if there is something in the program that resets these permissions?
  22. Thank you, that came down absolutely perfect and I didn't have to replace EP_DELIMITER. Trying to upload changes .... I am going from temp directory... I get the following error: User filename: EP2006Sep18-1806.txt Warning: file(/hsphere/local/home/netkraft/shelburnefallsdelivers.com/EP_TEMP_DIREP2006Sep18-1806.txt): failed to open stream: No such file or directory in /hsphere/local/home/netkraft/shelburnefallsdelivers.com/admin/easypopulate.php on line 732 Warning: Invalid argument supplied for foreach() in /hsphere/local/home/netkraft/shelburnefallsdelivers.com/admin/easypopulate.php on line 7 The temp directory is there. The file is there. And they are both 777.
  23. Here it is: <?php // Current EP Version $curver = '2.90'; /* $Id: easypopulate.php,v 2.90 2006/04/14 Davide Duca @ www.eurobigstore.com */ require('includes/application_top.php'); //**** File Splitting Configuration **** // we attempt to set the timeout limit longer for this script to avoid having to split the files // NOTE: If your server is running in safe mode, this setting cannot override the timeout set in php.ini if (EP_SET_TIME_LIMIT == 'true') {set_time_limit(330);} //**** Size of products_model in products table **** // This is automatically set to the maximum defined size of products_model in the products table. We check to make sure all models are no longer than this value. global $modelsize; $table_definition_query=tep_db_query("describe " . TABLE_PRODUCTS); while ($product_definition=tep_db_fetch_array($table_definition_query)){ if ($product_definition[Field]=='products_model'){ if (substr($product_definition[Type],0,7)=='varchar'){ $modelsize=substr($product_definition[Type],8,strlen($product_definition[Type])); $modelsize=substr($modelsize,0,(strlen($modelsize)-1)); } } } //**** Price includes tax? **** global $price_with_tax; $price_with_tax = (EP_PRICE_INC_TAX =='true' ? 1 : 0); global $separator; if (EP_DELIMITER == '\t') { $separator = "\t"; // oscommerce stores escaped delimeters in mySQL as a string and not an actual tab. } else { $separator = EP_DELIMITER; } // change this if you want to download selected product options // this might be handy, if you have a lot of product options, and your output file exceeds 256 columns (which is the max. limit MS Excel is able to handle) global $attribute_options_select; //$attribute_options_select = array('Size', 'Model'); // uncomment and fill with product options name you wish to download // comment this line, if you wish to download all product options // VJ product attributes end //******************************* // If you are running a pre-Nov1-2002 snapshot of OSC, then we need this include line to avoid // errors like: // undefined function tep_get_uploaded_file if (!function_exists(tep_get_uploaded_file)){ include (DIR_WS_FUNCTIONS . 'easypopulate_functions.php'); } //******************************* // VJ product attributes begin global $attribute_options_array; $attribute_options_array = array(); if (EP_PROD_ATTR == 'true') { if (is_array($attribute_options_select) && (count($attribute_options_select) > 0)) { foreach ($attribute_options_select as $value) { $attribute_options_query = "select distinct products_options_id from " . TABLE_PRODUCTS_OPTIONS . " where products_options_name = '" . $value . "'"; $attribute_options_values = tep_db_query($attribute_options_query); if ($attribute_options = tep_db_fetch_array($attribute_options_values)){ $attribute_options_array[] = array('products_options_id' => $attribute_options['products_options_id']); } } } else { $attribute_options_query = "select distinct products_options_id from " . TABLE_PRODUCTS_OPTIONS . " order by products_options_id"; $attribute_options_values = tep_db_query($attribute_options_query); while ($attribute_options = tep_db_fetch_array($attribute_options_values)){ $attribute_options_array[] = array('products_options_id' => $attribute_options['products_options_id']); } } } // VJ product attributes end global $filelayout, $filelayout_count, $filelayout_sql, $langcode, $fileheaders; // these are the fields that will be defaulted to the current values in the database if they are not found in the incoming file global $default_these; $default_these = array( 'v_products_image', #'v_products_dim_type', #'v_products_length', #'v_products_width', #'v_products_height', #'v_products_mimage', #'v_products_bimage', #'v_products_subimage1', #'v_products_bsubimage1', #'v_products_subimage2', #'v_products_bsubimage2', #'v_products_subimage3', 'v_categories_id', 'v_specials_price', 'v_specials_date_avail', 'v_specials_expires_date', 'v_products_price', 'products_price1', 'products_price2', 'products_price3', 'products_price4', 'products_price5', 'products_price6', 'products_price7', 'products_price8', 'products_price1_qty', 'products_price2_qty', 'products_price3_qty', 'products_price4_qty', 'products_price5_qty', 'products_price6_qty', 'products_price7_qty', 'products_price8_qty', 'products_qty_blocks', 'v_products_quantity', 'v_products_weight', 'v_date_avail', 'v_instock', 'v_tax_class_title', 'v_manufacturers_name', 'v_manufacturers_id', 'v_products_dim_type', 'v_products_length', 'v_products_width', 'v_products_height', ); //elari check default language_id from configuration table DEFAULT_LANGUAGE
  24. When the file comes down, I get "EP_DELIMITER" throughout. I needed to take those out in order to load it correctly into Excel. I then saved the file as TAB Delimited. Should I replace them? I haven't touched the easypopluate.php file which I downloaded just last night, so the problem should not be in there. But if you need it to help me, I'll post it. Thank you for helping me.
  25. The tabs don't show up, but there are tabs in it. Is there a better way to get it to you?
×
×
  • Create New...