chrisso69 Posted July 7, 2006 Share Posted July 7, 2006 Hi, I've just installed 2.2 but i get the following error when going to my index page: Parse error: syntax error, unexpected ',' in D:\hshome\chrishar\x-cessoriesgalore.com.au\catalog\includes\application_top.php on line 366 Application_top.php looks like this: <?php /* $Id: application_top.php,v 1.4 2003/10/01 09:10:28 serg Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ // start the timer for the page parse time log define('PAGE_PARSE_START_TIME', microtime()); // set the level of error reporting error_reporting(E_ALL & ~E_NOTICE); // check if register_globals is enabled. // since this is a temporary measure this message is hardcoded. The requirement will be removed before 2.2 is finalized. if (function_exists('ini_get')) { ini_get('register_globals') or exit('FATAL ERROR: register_globals is disabled in php.ini, please enable it!'); } // Set the local configuration parameters - mainly for developers if (file_exists('includes/local/configure.php')) include('includes/local/configure.php'); // include server parameters require('includes/configure.php'); if (strlen(DB_SERVER) < 1) { if (is_dir('install')) { header('Location: install/index.php'); } } // define the project version define('PROJECT_VERSION', 'osCommerce 2.2-MS2'); // set the type of request (secure or not) $request_type = (getenv('HTTPS') == 'on') ? 'SSL' : 'NONSSL'; // set php_self in the local scope if (!isset($PHP_SELF)) $PHP_SELF = $HTTP_SERVER_VARS['PHP_SELF']; if ($request_type == 'NONSSL') { define('DIR_WS_CATALOG', DIR_WS_HTTP_CATALOG); } else { define('DIR_WS_CATALOG', DIR_WS_HTTPS_CATALOG); } // include the list of project filenames require(DIR_WS_INCLUDES . 'filenames.php'); // include the list of project database tables require(DIR_WS_INCLUDES . 'database_tables.php'); // customization for the design layout define('BOX_WIDTH', 125); // how wide the boxes should be in pixels (default: 125) // include the database functions require(DIR_WS_FUNCTIONS . 'database.php'); // make a connection to the database... now tep_db_connect() or die('Unable to connect to database server!'); // set the application parameters $configuration_query = tep_db_query('select configuration_key as cfgKey, configuration_value as cfgValue from ' . TABLE_CONFIGURATION); while ($configuration = tep_db_fetch_array($configuration_query)) { define($configuration['cfgKey'], $configuration['cfgValue']); } // if gzip_compression is enabled, start to buffer the output if ( (GZIP_COMPRESSION == 'true') && ($ext_zlib_loaded = extension_loaded('zlib')) && (PHP_VERSION >= '4') ) { if (($ini_zlib_output_compression = (int)ini_get('zlib.output_compression')) < 1) { if (PHP_VERSION >= '4.0.4') { ob_start('ob_gzhandler'); } else { include(DIR_WS_FUNCTIONS . 'gzip_compression.php'); ob_start(); ob_implicit_flush(); } } else { ini_set('zlib.output_compression_level', GZIP_LEVEL); } } // set the HTTP GET parameters manually if search_engine_friendly_urls is enabled if (SEARCH_ENGINE_FRIENDLY_URLS == 'true') { if (strlen(getenv('PATH_INFO')) > 1) { $GET_array = array(); $PHP_SELF = str_replace(getenv('PATH_INFO'), '', $PHP_SELF); $vars = explode('/', substr(getenv('PATH_INFO'), 1)); for ($i=0, $n=sizeof($vars); $i<$n; $i++) { if (strpos($vars[$i], '[]')) { $GET_array[substr($vars[$i], 0, -2)][] = $vars[$i+1]; } else { $HTTP_GET_VARS[$vars[$i]] = $vars[$i+1]; } $i++; } if (sizeof($GET_array) > 0) { while (list($key, $value) = each($GET_array)) { $HTTP_GET_VARS[$key] = $value; } } } } // define general functions used application-wide require(DIR_WS_FUNCTIONS . 'general.php'); require(DIR_WS_FUNCTIONS . 'html_output.php'); // set the cookie domain $cookie_domain = (($request_type == 'NONSSL') ? HTTP_COOKIE_DOMAIN : HTTPS_COOKIE_DOMAIN); $cookie_path = (($request_type == 'NONSSL') ? HTTP_COOKIE_PATH : HTTPS_COOKIE_PATH); // include cache functions if enabled if (USE_CACHE == 'true') include(DIR_WS_FUNCTIONS . 'cache.php'); // include shopping cart class require(DIR_WS_CLASSES . 'shopping_cart.php'); // include navigation history class require(DIR_WS_CLASSES . 'navigation_history.php'); // some code to solve compatibility issues require(DIR_WS_FUNCTIONS . 'compatibility.php'); // check if sessions are supported, otherwise use the php3 compatible session class if (!function_exists('session_start')) { define('PHP_SESSION_NAME', 'osCsid'); define('PHP_SESSION_PATH', $cookie_path); define('PHP_SESSION_DOMAIN', $cookie_domain); define('PHP_SESSION_SAVE_PATH', SESSION_WRITE_DIRECTORY); include(DIR_WS_CLASSES . 'sessions.php'); } // define how the session functions will be used require(DIR_WS_FUNCTIONS . 'sessions.php'); // set the session name and save path tep_session_name('osCsid'); tep_session_save_path(SESSION_WRITE_DIRECTORY); // set the session cookie parameters if (function_exists('session_set_cookie_params')) { session_set_cookie_params(0, $cookie_path, $cookie_domain); } elseif (function_exists('ini_set')) { ini_set('session.cookie_lifetime', '0'); ini_set('session.cookie_path', $cookie_path); ini_set('session.cookie_domain', $cookie_domain); } // set the session ID if it exists if (isset($HTTP_POST_VARS[tep_session_name()])) { tep_session_id($HTTP_POST_VARS[tep_session_name()]); } elseif ( ($request_type == 'SSL') && isset($HTTP_GET_VARS[tep_session_name()]) ) { tep_session_id($HTTP_GET_VARS[tep_session_name()]); } // start the session $session_started = false; if (SESSION_FORCE_COOKIE_USE == 'True') { tep_setcookie('cookie_test', 'please_accept_for_session', time()+60*60*24*30, $cookie_path, $cookie_domain); if (isset($HTTP_COOKIE_VARS['cookie_test'])) { tep_session_start(); $session_started = true; } } elseif (SESSION_BLOCK_SPIDERS == 'True') { $user_agent = strtolower(getenv('HTTP_USER_AGENT')); $spider_flag = false; if (tep_not_null($user_agent)) { $spiders = file(DIR_WS_INCLUDES . 'spiders.txt'); for ($i=0, $n=sizeof($spiders); $i<$n; $i++) { if (tep_not_null($spiders[$i])) { if (is_integer(strpos($user_agent, trim($spiders[$i])))) { $spider_flag = true; break; } } } } if ($spider_flag == false) { tep_session_start(); $session_started = true; } } else { tep_session_start(); $session_started = true; } // set SID once, even if empty $SID = (defined('SID') ? SID : ''); // verify the ssl_session_id if the feature is enabled if ( ($request_type == 'SSL') && (SESSION_CHECK_SSL_SESSION_ID == 'True') && (ENABLE_SSL == true) && ($session_started == true) ) { $ssl_session_id = getenv('SSL_SESSION_ID'); if (!tep_session_is_registered('SSL_SESSION_ID')) { $SESSION_SSL_ID = $ssl_session_id; tep_session_register('SESSION_SSL_ID'); } if ($SESSION_SSL_ID != $ssl_session_id) { tep_session_destroy(); tep_redirect(tep_href_link(FILENAME_SSL_CHECK)); } } // verify the browser user agent if the feature is enabled if (SESSION_CHECK_USER_AGENT == 'True') { $http_user_agent = getenv('HTTP_USER_AGENT'); if (!tep_session_is_registered('SESSION_USER_AGENT')) { $SESSION_USER_AGENT = $http_user_agent; tep_session_register('SESSION_USER_AGENT'); } if ($SESSION_USER_AGENT != $http_user_agent) { tep_session_destroy(); tep_redirect(tep_href_link(FILENAME_LOGIN)); } } // verify the IP address if the feature is enabled if (SESSION_CHECK_IP_ADDRESS == 'True') { $ip_address = tep_get_ip_address(); if (!tep_session_is_registered('SESSION_IP_ADDRESS')) { $SESSION_IP_ADDRESS = $ip_address; tep_session_register('SESSION_IP_ADDRESS'); } if ($SESSION_IP_ADDRESS != $ip_address) { tep_session_destroy(); tep_redirect(tep_href_link(FILENAME_LOGIN)); } } // create the shopping cart & fix the cart if necesary if (tep_session_is_registered('cart') && is_object($cart)) { if (PHP_VERSION < 4) { $broken_cart = $cart; $cart = new shoppingCart; $cart->unserialize($broken_cart); } } else { tep_session_register('cart'); $cart = new shoppingCart; } // include currencies class and create an instance require(DIR_WS_CLASSES . 'currencies.php'); $currencies = new currencies(); // include the mail classes require(DIR_WS_CLASSES . 'mime.php'); require(DIR_WS_CLASSES . 'email.php'); // set the language if (!tep_session_is_registered('language') || isset($HTTP_GET_VARS['language'])) { if (!tep_session_is_registered('language')) { tep_session_register('language'); tep_session_register('languages_id'); } include(DIR_WS_CLASSES . 'language.php'); $lng = new language(); if (isset($HTTP_GET_VARS['language']) && tep_not_null($HTTP_GET_VARS['language'])) { $lng->set_language($HTTP_GET_VARS['language']); } else { $lng->get_browser_language(); } $language = $lng->language['directory']; $languages_id = $lng->language['id']; } // include the language translations require(DIR_WS_LANGUAGES . $language . '.php'); // currency if (!tep_session_is_registered('currency') || isset($HTTP_GET_VARS['currency']) || ( (USE_DEFAULT_LANGUAGE_CURRENCY == 'true') && (LANGUAGE_CURRENCY != $currency) ) ) { if (!tep_session_is_registered('currency')) tep_session_register('currency'); if (isset($HTTP_GET_VARS['currency'])) { if (!$currency = tep_currency_exists($HTTP_GET_VARS['currency'])) $currency = (USE_DEFAULT_LANGUAGE_CURRENCY == 'true') ? LANGUAGE_CURRENCY : DEFAULT_CURRENCY; } else { $currency = (USE_DEFAULT_LANGUAGE_CURRENCY == 'true') ? LANGUAGE_CURRENCY : DEFAULT_CURRENCY; } } // navigation history if (tep_session_is_registered('navigation')) { if (PHP_VERSION < 4) { $broken_navigation = $navigation; $navigation = new navigationHistory; $navigation->unserialize($broken_navigation); } } else { tep_session_register('navigation'); $navigation = new navigationHistory; } $navigation->add_current_page(); // Shopping cart actions if (isset($HTTP_GET_VARS['action'])) { // redirect the customer to a friendly cookie-must-be-enabled page if cookies are disabled if ($session_started == false) { tep_redirect(tep_href_link(FILENAME_COOKIE_USAGE)); } if (DISPLAY_CART == 'true') { $goto = FILENAME_SHOPPING_CART; $parameters = array('action', 'cPath', 'products_id', 'pid'); } else { $goto = basename($PHP_SELF); if ($HTTP_GET_VARS['action'] == 'buy_now') { $parameters = array('action', 'pid', 'products_id'); } else { $parameters = array('action', 'pid'); } } switch ($HTTP_GET_VARS['action']) { // customer wants to update the product quantity in their shopping cart case 'update_product' : for ($i=0, $n=sizeof($HTTP_POST_VARS['products_id']); $i<$n; $i++) { if (in_array($HTTP_POST_VARS['products_id'][$i], (is_array($HTTP_POST_VARS['cart_delete']) ? $HTTP_POST_VARS['cart_delete'] : array()))) { $cart->remove($HTTP_POST_VARS['products_id'][$i]); } else { if (PHP_VERSION < 4) { // if PHP3, make correction for lack of multidimensional array. reset($HTTP_POST_VARS); while (list($key, $value) = each($HTTP_POST_VARS)) { if (is_array($value)) { while (list($key2, $value2) = each($value)) { if (ereg ("(.*)\]\[(.*)", $key2, $var)) { $id2[$var[1]][$var[2]] = $value2; } } } } $attributes = ($id2[$HTTP_POST_VARS['products_id'][$i]]) ? $id2[$HTTP_POST_VARS['products_id'][$i]] : ''; } else { $attributes = ($HTTP_POST_VARS['id'][$HTTP_POST_VARS['products_id'][$i]]) ? $HTTP_POST_VARS['id'][$HTTP_POST_VARS['products_id'][$i]] : ''; } $cart->add_cart($HTTP_POST_VARS['products_id'][$i], $HTTP_POST_VARS['cart_quantity'][$i], $attributes, false); } } tep_redirect(tep_href_link($goto, tep_get_all_get_params($parameters))); break; // customer adds a product from the products page case 'add_product' : if (isset($HTTP_POST_VARS['products_id']) && is_numeric($HTTP_POST_VARS['products_id'])) { $cart->add_cart($HTTP_POST_VARS['products_id'], $cart->get_quantity(tep_get_uprid($HTTP_POST_VARS['products_id'], $HTTP_POST_VARS['id']))+1, $HTTP_POST_VARS['id']); } tep_redirect(tep_href_link($goto, tep_get_all_get_params($parameters))); break; /*product_listing coloumns change here */ case 'buy_now_form' : if (isset($HTTP_POST_VARS['products_id']) && is_numeric($HTTP_POST_VARS['products_id'])) { $cart->add_cart($HTTP_POST_VARS['products_id'], $cart->get_quantity(tep_get_uprid($HTTP_POST_VARS['products_id'], $HTTP_POST_VARS['id']))+($HTTP_POST_VARS['cart_quantity']), $HTTP_POST_VARS['id']); // replace quantities $cart->get_quantity($HTTP_POST_VARS['products_id'])-($cart->get_quantity($HTTP_POST_VARS['products_id']))+($HTTP_POST_VARS['cart_quantity']), $HTTP_POST_VARS['id']); } tep_redirect(tep_href_link($goto, tep_get_all_get_params($parameters))); break; // customer adds multiple products from the products_listing page case 'add_multiple' : while ( list( $key, $val ) = each( $HTTP_POST_VARS ) ) { if (substr($key,0,11) == "Qty_ProdId_" || substr($key,0,11) == "Qty_NPrdId_") { $prodId = substr($key, 11); $qty = $val; if ($qty <= 0 ) continue; if(isset($HTTP_POST_VARS["id_$prodId"]) && is_array($HTTP_POST_VARS["id_$prodId"])) { // We have attributes $cart->add_cart($prodId, $cart->get_quantity(tep_get_uprid($prodId,$HTTP_POST_VARS["id_$prodId"]))+$qty, $HTTP_POST_VARS["id_$prodId"]); } else { // No attributes $cart->add_cart($prodId, $cart->get_quantity($prodId)+$qty); } } } tep_redirect(tep_href_link($goto, tep_get_all_get_params($parameters))); break; // performed by the 'buy now' button in product listings and review page case 'buy_now' : if (isset($HTTP_GET_VARS['products_id'])) { if (tep_has_product_attributes($HTTP_GET_VARS['products_id'])) { tep_redirect(tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $HTTP_GET_VARS['products_id'])); } else { $cart->add_cart($HTTP_GET_VARS['products_id'], $cart->get_quantity($HTTP_GET_VARS['products_id'])+1); } } tep_redirect(tep_href_link($goto, tep_get_all_get_params($parameters))); break; case 'notify' : if (tep_session_is_registered('customer_id')) { if (isset($HTTP_GET_VARS['products_id'])) { $notify = $HTTP_GET_VARS['products_id']; } elseif (isset($HTTP_GET_VARS['notify'])) { $notify = $HTTP_GET_VARS['notify']; } elseif (isset($HTTP_POST_VARS['notify'])) { $notify = $HTTP_POST_VARS['notify']; } else { tep_redirect(tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action', 'notify')))); } if (!is_array($notify)) $notify = array($notify); for ($i=0, $n=sizeof($notify); $i<$n; $i++) { $check_query = tep_db_query("select count(*) as count from " . TABLE_PRODUCTS_NOTIFICATIONS . " where products_id = '" . $notify[$i] . "' and customers_id = '" . $customer_id . "'"); $check = tep_db_fetch_array($check_query); if ($check['count'] < 1) { tep_db_query("insert into " . TABLE_PRODUCTS_NOTIFICATIONS . " (products_id, customers_id, date_added) values ('" . $notify[$i] . "', '" . $customer_id . "', now())"); } } tep_redirect(tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action', 'notify')))); } else { $navigation->set_snapshot(); tep_redirect(tep_href_link(FILENAME_LOGIN, '', 'SSL')); } break; case 'notify_remove' : if (tep_session_is_registered('customer_id') && isset($HTTP_GET_VARS['products_id'])) { $check_query = tep_db_query("select count(*) as count from " . TABLE_PRODUCTS_NOTIFICATIONS . " where products_id = '" . $HTTP_GET_VARS['products_id'] . "' and customers_id = '" . $customer_id . "'"); $check = tep_db_fetch_array($check_query); if ($check['count'] > 0) { tep_db_query("delete from " . TABLE_PRODUCTS_NOTIFICATIONS . " where products_id = '" . $HTTP_GET_VARS['products_id'] . "' and customers_id = '" . $customer_id . "'"); } tep_redirect(tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')))); } else { $navigation->set_snapshot(); tep_redirect(tep_href_link(FILENAME_LOGIN, '', 'SSL')); } break; case 'cust_order' : if (tep_session_is_registered('customer_id') && isset($HTTP_GET_VARS['pid'])) { if (tep_has_product_attributes($HTTP_GET_VARS['pid'])) { tep_redirect(tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $HTTP_GET_VARS['pid'])); } else { $cart->add_cart($HTTP_GET_VARS['pid'], $cart->get_quantity($HTTP_GET_VARS['pid'])+1); } } tep_redirect(tep_href_link($goto, tep_get_all_get_params($parameters))); break; } } // include the who's online functions require(DIR_WS_FUNCTIONS . 'whos_online.php'); tep_update_whos_online(); // include the password crypto functions require(DIR_WS_FUNCTIONS . 'password_funcs.php'); // include validation functions (right now only email address) require(DIR_WS_FUNCTIONS . 'validations.php'); // split-page-results require(DIR_WS_CLASSES . 'split_page_results.php'); // infobox require(DIR_WS_CLASSES . 'boxes.php'); // auto activate and expire banners require(DIR_WS_FUNCTIONS . 'banner.php'); tep_activate_banners(); tep_expire_banners(); // auto expire special products require(DIR_WS_FUNCTIONS . 'specials.php'); tep_expire_specials(); // calculate category path if (isset($HTTP_GET_VARS['cPath'])) { $cPath = $HTTP_GET_VARS['cPath']; } elseif (isset($HTTP_GET_VARS['products_id']) && !isset($HTTP_GET_VARS['manufacturers_id'])) { $cPath = tep_get_product_path($HTTP_GET_VARS['products_id']); } else { $cPath = ''; } if (tep_not_null($cPath)) { $cPath_array = tep_parse_category_path($cPath); $cPath = implode('_', $cPath_array); $current_category_id = $cPath_array[(sizeof($cPath_array)-1)]; } else { $current_category_id = 0; } // include the breadcrumb class and start the breadcrumb trail require(DIR_WS_CLASSES . 'breadcrumb.php'); $breadcrumb = new breadcrumb; $breadcrumb->add(HEADER_TITLE_TOP, HTTP_SERVER); $breadcrumb->add(HEADER_TITLE_CATALOG, tep_href_link(FILENAME_DEFAULT)); // add category names or the manufacturer name to the breadcrumb trail if (isset($cPath_array)) { for ($i=0, $n=sizeof($cPath_array); $i<$n; $i++) { $categories_query = tep_db_query("select categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . (int)$cPath_array[$i] . "' and language_id = '" . (int)$languages_id . "'"); if (tep_db_num_rows($categories_query) > 0) { $categories = tep_db_fetch_array($categories_query); $breadcrumb->add($categories['categories_name'], tep_href_link(FILENAME_DEFAULT, 'cPath=' . implode('_', array_slice($cPath_array, 0, ($i+1))))); } else { break; } } } elseif (isset($HTTP_GET_VARS['manufacturers_id'])) { $manufacturers_query = tep_db_query("select manufacturers_name from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'"); if (tep_db_num_rows($manufacturers_query)) { $manufacturers = tep_db_fetch_array($manufacturers_query); $breadcrumb->add($manufacturers['manufacturers_name'], tep_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $HTTP_GET_VARS['manufacturers_id'])); } } // add the products model to the breadcrumb trail if (isset($HTTP_GET_VARS['products_id'])) { $model_query = tep_db_query("select products_model from " . TABLE_PRODUCTS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'"); if (tep_db_num_rows($model_query)) { $model = tep_db_fetch_array($model_query); $breadcrumb->add($model['products_model'], tep_href_link(FILENAME_PRODUCT_INFO, 'cPath=' . $cPath . '&products_id=' . $HTTP_GET_VARS['products_id'])); } } // initialize the message stack for output messages require(DIR_WS_CLASSES . 'message_stack.php'); $messageStack = new messageStack; // set which precautions should be checked define('WARN_INSTALL_EXISTENCE', 'true'); define('WARN_CONFIG_WRITEABLE', 'false'); define('WARN_SESSION_DIRECTORY_NOT_WRITEABLE', 'true'); define('WARN_SESSION_AUTO_START', 'true'); define('WARN_DOWNLOAD_DIRECTORY_NOT_READABLE', 'true'); ?> Any ideas?? Many Thanks, Chris Quote Link to comment Share on other sites More sharing options...
Guest Posted July 7, 2006 Share Posted July 7, 2006 1. First off, the database change. Run the following command on your database: INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Display Add Multiples column', 'PRODUCT_LIST_MULTIPLE', '0', 'Do you want to display the Multiple Quantity with Attributes column?', '8', '11', now()); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Display Add Multiples with Buy Now column', 'PRODUCT_LIST_BUY_NOW_MULTIPLE', '0', 'Do you want to display the Multiple Quantity Buy Now with Attributes column?', '8', '12', now()); INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Number of column per row', 'PRODUCT_LIST_NUMCOL', '3', 'How many columns per row to display?', '8', '13', now()); I'm not sure I understand this warning? can someone explain this warning to me? What do I have to look for in the sql? Quote Link to comment Share on other sites More sharing options...
djmonkey1 Posted July 10, 2006 Author Share Posted July 10, 2006 can someone explain this warning to me? What do I have to look for in the sql? For instance there is, in the first command, '8', '11', now()); in the second it's '8', '12', now()); and in the third it's '8', '13', now()); and that's the 11, 12, and 13 you have to look out for. Basically what you have to do is look in your admin->configuration->product listing page and see how many options are listed there. If it's 10, then the first number above can be 11 and you don't need to change anything. If you already have 13 options, then those three numbers should be 14, 15, and 16. It's really not a huge deal, you're just trying to avoid having multiple entries with the same number for sort_order. Quote Do, or do not. There is no try. Order Editor 5.0.6 "Ultra Violet" is now available! For support or to post comments, suggestions, etc, please visit the Order Editor support thread. Link to comment Share on other sites More sharing options...
djmonkey1 Posted July 10, 2006 Author Share Posted July 10, 2006 Hi, I've just installed 2.2 but i get the following error when going to my index page: Parse error: syntax error, unexpected ',' in D:\hshome\chrishar\x-cessoriesgalore.com.au\catalog\includes\application_top.php on line 366 Application_top.php looks like this: Any ideas?? Many Thanks, Chris I don't think anyone can read through all that, man. What's on line 366? Quote Do, or do not. There is no try. Order Editor 5.0.6 "Ultra Violet" is now available! For support or to post comments, suggestions, etc, please visit the Order Editor support thread. Link to comment Share on other sites More sharing options...
djmonkey1 Posted July 10, 2006 Author Share Posted July 10, 2006 Nevermind that! I figured out the solution, and made the IF statement for the empty cell working, if anyone wants the code I will post it :) You should post it here, it will undoubtedly help other people. Quote Do, or do not. There is no try. Order Editor 5.0.6 "Ultra Violet" is now available! For support or to post comments, suggestions, etc, please visit the Order Editor support thread. Link to comment Share on other sites More sharing options...
djmonkey1 Posted July 10, 2006 Author Share Posted July 10, 2006 I am having a problem with the product sort order. My goal is to have all of the products sorted by manufacturer name followed by product name (Ex. Sony AAA, Sony BBB, Sony CCC). I changed the following code in index.php: if ($column_list[$i] == 'PRODUCT_LIST_MANUFACTURER') { $HTTP_GET_VARS['sort'] = $i+1 . 'a'; $listing_sql .= "order by m.manufacturers_name"; This got all of the products in order by manufacturer name, but they are still not sorting by product name per each manufacturer name. It's doing something like this Sony BBB, Sony AAA, Sony DDD, Sony CCC. The only time it sorts correctly is when I click a results page, like results page 2 or even page 1. But each time I click a category, the products get scrambled again. Any help would be GREATLY appreciated! I've driven myself crazy trying to sort things like this. Luckily with MySQL the ORDER BY clause accepts multiple entries. Have you tried "order by m.manufacturers_name, pd.products_name"? Quote Do, or do not. There is no try. Order Editor 5.0.6 "Ultra Violet" is now available! For support or to post comments, suggestions, etc, please visit the Order Editor support thread. Link to comment Share on other sites More sharing options...
docKrimson Posted July 10, 2006 Share Posted July 10, 2006 Great contribution! Installed very easily. However, I noticed that New Product Listing page (products_new.php) does not render properly, mostly due to the fact that it has its own query and code for display. I wouldn't have even noticed this myself, except I had a friend log into my test site (New Products appears as a page choice for returning clients). Does anyone have an elegant fix (like linking the page to product_listing_col.php) for this? Quote Link to comment Share on other sites More sharing options...
docKrimson Posted July 12, 2006 Share Posted July 12, 2006 Guess I will have to come back to this after my vacation. If a solution exists then, I will use it. If not, I will look into modification. Great contribution! Installed very easily. However, I noticed that New Product Listing page (products_new.php) does not render properly, mostly due to the fact that it has its own query and code for display. I wouldn't have even noticed this myself, except I had a friend log into my test site (New Products appears as a page choice for returning clients). Does anyone have an elegant fix (like linking the page to product_listing_col.php) for this? Quote Link to comment Share on other sites More sharing options...
Kes Posted July 25, 2006 Share Posted July 25, 2006 Hi, I am hoping smeone can help. I have just added the latest contribution and want 1 column to display with attributes. When i have 3 columns all is well. when i have two colums the attributes double When i choose 1 column to display i get no attributes showing. Can anyone help with this please cheers Quote Link to comment Share on other sites More sharing options...
pixelhub Posted August 2, 2006 Share Posted August 2, 2006 Nevermind that! I figured out the solution, and made the IF statement for the empty cell working, if anyone wants the code I will post it :) Can you post the solution please. Cheers Craig Quote Link to comment Share on other sites More sharing options...
Patty Posted August 11, 2006 Share Posted August 11, 2006 This is a bug that was supposed to be addressed in v2.2. I actually haven't installed the new version yet so maybe I can't say for sure. Hello. Is there a fix available for this bug? I installed v2.2 uploaded by you, which is the last one, and it's still showing this problem. Tks in advance for any help on this issue. :thumbsup: Quote Patty Link to comment Share on other sites More sharing options...
maryb Posted August 15, 2006 Share Posted August 15, 2006 i think so just click on the price in the header of product listinghttp://seelily.com/index.php?cPath=3_10 This contribution does it a better way http://www.oscommerce.com/community/contributions,4235 thanks spinball Quote Link to comment Share on other sites More sharing options...
ali_razorback Posted September 22, 2006 Share Posted September 22, 2006 Hello! Firstly - thanks to all the people who ask questions and answer them too on this board - without you I would be forever posting questions myself! I'm finally stumped though on this one problem (after having searched for the answer in the forums but to no avail...) so if anyone has any clues to this problem then I'm all ears/eyes! Would be interesting if anyone else has this problem. Let me explain: I've installed this contribution, but when using the Advanced Search box and also in the products listing page, the infobox header is appearing at the top for no apparent reason! There is nothing inside it, just the coloured background for the headers. I've been all through the various .php files and I can't see what making this happen. I've shown a screenprint below so you can see: I want to get rid of this, it looks stupid hehe. This is definitely the infobox heading and not a coloured background, as you can see (if you look reeeeaaally closely) that the rounded corners are duplicating themselves and it looks feathered at both ends. If it helps, I'm using STS v4.1. I'm guessing the problem will be solved in one of the php files that is totally unrelated to the advanced search and category listings - hope to hear back from someone! Cheers again =) Quote Link to comment Share on other sites More sharing options...
infoseek Posted September 26, 2006 Share Posted September 26, 2006 How do I limit products per page. Is it possible? Quote Link to comment Share on other sites More sharing options...
skylla Posted September 26, 2006 Share Posted September 26, 2006 Yes, it's in admin How do I limit products per page. Is it possible? Quote Link to comment Share on other sites More sharing options...
infoseek Posted September 28, 2006 Share Posted September 28, 2006 Yes, it's in admin Thanks. Sorry, I got it. Such a dumb question. It's the search result. You know, I'm a jsp guru, and when it comes to php, I really have to pull my head out of my A55! Quote Link to comment Share on other sites More sharing options...
kally Posted October 5, 2006 Share Posted October 5, 2006 I was having this same problem. No matter which item had the highest number (ie. at the bottom of the list) it was duplicated. I looked over the script for hours and didn't see what was causing it. So I checked the forum and tried your fix and it worked for me, too. Thanks for posting your solution here and saving me more lost time! Two of the (several) other modules I am using are Sort Option Values and Unique Attributes. Evidently not many people are experiencing this, so I was wondering if there must be something in the combination of modules that caused it. Thanks again! Kally ... I found out around line 101 in product_listing_col.php :Look for: for ($col=0, $n=sizeof($column_list); $col<$n; $col++) { Change for: for ($col=0, $n=sizeof($column_list); $col<$n-1; $col++) { Possible that it was running through code one more time with the same last item, so I added "-1" to $col<$n;... Now it works... but what do you think of this? Does it work okay on a clean install ? Plascual Quote Link to comment Share on other sites More sharing options...
meto Posted October 15, 2006 Share Posted October 15, 2006 (edited) Thanx for this great contribution. I was wondering if it would be possible to use this listing in multi columns contribution for special products. Im searching for a way to show my special products under the main or subcategorie. I gave it a try but couldnt figure out where the underlaying query is defined and to be honest what to adjust to make it so that the special products are represented in the same way as the normal products. Any ideas or can anyone point me in the right direction? Thanks.... Edited October 15, 2006 by meto Quote Link to comment Share on other sites More sharing options...
meto Posted October 15, 2006 Share Posted October 15, 2006 Hello, I also have a problem with the filling of the remaining cells, i cant figure it out, how to standard write 3 columns even if i have 1 or 2 products. What i want is: when i have 1 or 2 products, i than still want to have 3 columns. Is this possible and how can this be done? Thanx in advange Quote Link to comment Share on other sites More sharing options...
meto Posted October 16, 2006 Share Posted October 16, 2006 Hello Again, Still nobody who have read my previous post. Doesn't matter because i came a long way by myself. I've figured out where the underlaying Query is defined but i am now stuck on the part where the catagories are tight to the result. Somehow my (int)$HTTP_GET_VARS['categories_id'] is always 0. So my products are not shown only on the specific categorie. Any ideas how the Productlisting contrib makes it so that products are tied to their categories? Thanks in advance Quote Link to comment Share on other sites More sharing options...
meto Posted October 16, 2006 Share Posted October 16, 2006 if someone read this... please ignore my previouse post. Accept the one about the spacing or filling up of the remaining cells in het productlist. i've got what i wanted. Quote Link to comment Share on other sites More sharing options...
etzeppy Posted October 24, 2006 Share Posted October 24, 2006 Does anybody know if this Contribution is compatible with the Product Sort contribution http://www.oscommerce.com/community/contributions,911. Quote Link to comment Share on other sites More sharing options...
phi148 Posted November 17, 2006 Share Posted November 17, 2006 Anyone here install this and had their picture show up TWICE ?? When I use 2 or more columns I get 2 of the same picture with every item! :blink: Anyone know why? :'( Quote Link to comment Share on other sites More sharing options...
Guest Posted November 20, 2006 Share Posted November 20, 2006 Hi everyone, I've closely followed the instructions to install the mod (v2.2), or so I thought. After making changes to includes/filenames.php (the last step), I went to see if any changes had taken effect on the website and was confronted by this on my browser. <?php /* $Id: filenames.php,v 1.4 2003/06/11 17:38:00 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce Released under the GNU General Public License */ // define the filenames used in the project define('FILENAME_ACCOUNT', 'account.php'); define('FILENAME_ACCOUNT_EDIT', 'account_edit.php'); define('FILENAME_ACCOUNT_HISTORY', 'account_history.php'); define('FILENAME_ACCOUNT_HISTORY_INFO', 'account_history_info.php'); define('FILENAME_ACCOUNT_NEWSLETTERS', 'account_newsletters.php'); define('FILENAME_ACCOUNT_NOTIFICATIONS', 'account_notifications.php'); define('FILENAME_ACCOUNT_PASSWORD', 'account_password.php'); define('FILENAME_ADDRESS_BOOK', 'address_book.php'); define('FILENAME_ADDRESS_BOOK_PROCESS', 'address_book_process.php'); define('FILENAME_ADVANCED_SEARCH', 'advanced_search.php'); define('FILENAME_ADVANCED_SEARCH_RESULT', 'advanced_search_result.php'); define('FILENAME_ALSO_PURCHASED_PRODUCTS', 'also_purchased_products.php'); define('FILENAME_CHECKOUT_CONFIRMATION', 'checkout_confirmation.php'); define('FILENAME_CHECKOUT_PAYMENT', 'checkout_payment.php'); define('FILENAME_CHECKOUT_PAYMENT_ADDRESS', 'checkout_payment_address.php'); define('FILENAME_CHECKOUT_PROCESS', 'checkout_process.php'); define('FILENAME_CHECKOUT_SHIPPING', 'checkout_shipping.php'); define('FILENAME_CHECKOUT_SHIPPING_ADDRESS', 'checkout_shipping_address.php'); define('FILENAME_CHECKOUT_SUCCESS', 'checkout_success.php'); define('FILENAME_CONTACT_US', 'contact_us.php'); define('FILENAME_CONDITIONS', 'conditions.php'); define('FILENAME_COOKIE_USAGE', 'cookie_usage.php'); define('FILENAME_CREATE_ACCOUNT', 'create_account.php'); define('FILENAME_CREATE_ACCOUNT_SUCCESS', 'create_account_success.php'); define('FILENAME_DEFAULT', 'index.php'); define('FILENAME_DOWNLOAD', 'download.php'); define('FILENAME_INFO_SHOPPING_CART', 'info_shopping_cart.php'); define('FILENAME_LOGIN', 'login.php'); define('FILENAME_LOGOFF', 'logoff.php'); define('FILENAME_NEW_PRODUCTS', 'new_products.php'); define('FILENAME_PASSWORD_FORGOTTEN', 'password_forgotten.php'); define('FILENAME_POPUP_IMAGE', 'popup_image.php'); define('FILENAME_POPUP_SEARCH_HELP', 'popup_search_help.php'); define('FILENAME_PRIVACY', 'privacy.php'); define('FILENAME_PRODUCT_INFO', 'product_info.php'); define('FILENAME_PRODUCT_LISTING', 'product_listing_col.php'); define('FILENAME_PRODUCT_REVIEWS', 'product_reviews.php'); define('FILENAME_PRODUCT_REVIEWS_INFO', 'product_reviews_info.php'); define('FILENAME_PRODUCT_REVIEWS_WRITE', 'product_reviews_write.php'); define('FILENAME_PRODUCTS_NEW', 'products_new.php'); define('FILENAME_REDIRECT', 'redirect.php'); define('FILENAME_REVIEWS', 'reviews.php'); define('FILENAME_SHIPPING', 'shipping.php'); define('FILENAME_SHOPPING_CART', 'shopping_cart.php'); define('FILENAME_SPECIALS', 'specials.php'); define('FILENAME_SSL_CHECK', 'ssl_check.php'); define('FILENAME_TELL_A_FRIEND', 'tell_a_friend.php'); define('FILENAME_UPCOMING_PRODUCTS', 'upcoming_products.php'); ?> Warning: Cannot modify header information - headers already sent by (output started at /home/limeduck/public_html/catalog/includes/filenames.php:12) in /home/limeduck/public_html/catalog/includes/functions/general.php on line 1226 Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/limeduck/public_html/catalog/includes/filenames.php:12) in /home/limeduck/public_html/catalog/includes/functions/sessions.php on line 97 Warning: main(includes/languages/english/FILENAME_DEFAULT) [function.main]: failed to open stream: No such file or directory in /home/limeduck/public_html/catalog/index.php on line 33 Warning: main(includes/languages/english/FILENAME_DEFAULT) [function.main]: failed to open stream: No such file or directory in /home/limeduck/public_html/catalog/index.php on line 33 Fatal error: main() [function.require]: Failed opening required 'includes/languages/english/FILENAME_DEFAULT' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/limeduck/public_html/catalog/index.php on line 33 Does anyone have an idea of what I did wrong? I checked out all the threads on this post but it doesn't look like anyone else has had the same problem. Thank you for your time! Quote Link to comment Share on other sites More sharing options...
Guest Posted November 21, 2006 Share Posted November 21, 2006 (edited) I know this problem has been discussed before but not sure a solution was offered:- I dont get the correct stylesheet setting displayed for the first row of my product listing in colums. Its fine for the second row onwards. is there a fix for it? Looks rellay ugly this way and I'd like to get it corrected. Also, I'd like to get rid of tzhe manufacturers name below the product picture and just display product name and price. How do I do that ? :'( Many thanks :thumbsup: BB Edited November 21, 2006 by bbrip Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.