spooks Posted April 13, 2009 Author Share Posted April 13, 2009 likely you have an error in index.php failing to add the id to the sql the name is pulled from the dbase according to the set manufacturers_id otherwise failures in database_tables.php if you have a template there are variations in those that often cause failures. Quote Sam Remember, What you think I ment may not be what I thought I ment when I said it. Contributions: Auto Backup your Database, Easy way Multi Images with Fancy Pop-ups, Easy way Products in columns with multi buy etc etc Disable any Category or Product, Easy way Secure & Improve your account pages et al. Link to comment Share on other sites More sharing options...
Kayserili Posted April 15, 2009 Share Posted April 15, 2009 likely you have an error in index.php failing to add the id to the sql the name is pulled from the dbase according to the set manufacturers_id otherwise failures in database_tables.php if you have a template there are variations in those that often cause failures. Hey Spooks, yes i have used a "template". Let me post the index.php codes. Maybe you can see the problem (if you want of course). Here it comes; <?php /* $Id: index.php,v 1.1 2003/06/11 17:37:59 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'); // the following cPath references come from application_top.php $category_depth = 'top'; if (isset($cPath) && tep_not_null($cPath)) { $categories_products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'"); $cateqories_products = tep_db_fetch_array($categories_products_query); if ($cateqories_products['total'] > 0) { $category_depth = 'products'; // display products } else { $category_parent_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$current_category_id . "'"); $category_parent = tep_db_fetch_array($category_parent_query); if ($category_parent['total'] > 0) { $category_depth = 'nested'; // navigate through the categories } else { $category_depth = 'products'; // category has no products, but display the 'no products' message } } } require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_DEFAULT); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo TITLE; ?></title> <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <link rel="stylesheet" type="text/css" href="stylesheet.css"> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <!-- body_text //--> <?php if ($category_depth == 'nested') { $category_query = tep_db_query("select cd.categories_name, c.categories_image from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . (int)$current_category_id . "' and cd.categories_id = '" . (int)$current_category_id . "' and cd.language_id = '" . (int)$languages_id . "'"); $category = tep_db_fetch_array($category_query); ?> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <?php if (isset($cPath) && strpos('_', $cPath)) { // check to see if there are deeper categories within the current category $category_links = array_reverse($cPath_array); for($i=0, $n=sizeof($category_links); $i<$n; $i++) { $categories_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$category_links[$i] . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "'"); $categories = tep_db_fetch_array($categories_query); if ($categories['total'] < 1) { // do nothing, go through the loop } else { $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$category_links[$i] . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name"); break; // we've found the deepest category the customer is in } } } else { $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$current_category_id . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name"); } $number_of_categories = tep_db_num_rows($categories_query); $rows = 0; while ($categories = tep_db_fetch_array($categories_query)) { $rows++; $cPath_new = tep_get_path($categories['categories_id']); $width = (int)(100 / MAX_DISPLAY_CATEGORIES_PER_ROW) . '%'; echo ' <td align="center" class="smallText" width="' . $width . '" valign="top"><a href="' . tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">' . tep_image(DIR_WS_IMAGES . $categories['categories_image'], $categories['categories_name'], SUBCATEGORY_IMAGE_WIDTH, SUBCATEGORY_IMAGE_HEIGHT) . '<br>' . $categories['categories_name'] . '</a></td>' . "\n"; if ((($rows / MAX_DISPLAY_CATEGORIES_PER_ROW) == floor($rows / MAX_DISPLAY_CATEGORIES_PER_ROW)) && ($rows != $number_of_categories)) { echo ' </tr>' . "\n"; echo ' <tr>' . "\n"; } } // needed for the new products module shown below $new_products_category_id = $current_category_id; ?> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td> <?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?></td> </tr> </table></td> </tr> </table></td> <?php } elseif ($category_depth == 'products' || isset($HTTP_GET_VARS['manufacturers_id'])) { // create column list $define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL, 'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME, 'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER, 'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE, 'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY, 'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT, 'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE, 'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW); asort($define_list); $column_list = array(); reset($define_list); while (list($key, $value) = each($define_list)) { if ($value > 0) $column_list[] = $key; } $select_column_list = ''; for ($i=0, $n=sizeof($column_list); $i<$n; $i++) { switch ($column_list[$i]) { case 'PRODUCT_LIST_MODEL': $select_column_list .= 'p.products_model, '; break; case 'PRODUCT_LIST_NAME': $select_column_list .= 'pd.products_name, '; break; case 'PRODUCT_LIST_MANUFACTURER': $select_column_list .= 'm.manufacturers_name, '; break; case 'PRODUCT_LIST_QUANTITY': $select_column_list .= 'p.products_quantity, '; break; case 'PRODUCT_LIST_IMAGE': $select_column_list .= 'p.products_image, '; break; case 'PRODUCT_LIST_WEIGHT': $select_column_list .= 'p.products_weight, '; break; } } $select_column_list .= 'pd.short_desc, '; // show the products of a specified manufacturer if (isset($HTTP_GET_VARS['manufacturers_id'])) { if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) { // We are asked to show only a specific category $listing_sql = "select " . $select_column_list . " p.products_id, pd.short_desc, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from (" . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c ) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'"; } else { // We show them all $listing_sql = "select " . $select_column_list . " p.products_id, pd.short_desc, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from (" . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'"; } } else { // show the products in a given categorie if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) { // We are asked to show only specific catgeory $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from (" . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; } else { // We show them all $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ((" . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p) left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; } } if ( (!isset($HTTP_GET_VARS['sort'])) || (!ereg('[1-8][ad]', $HTTP_GET_VARS['sort'])) || (substr($HTTP_GET_VARS['sort'], 0, 1) > sizeof($column_list)) ) { for ($i=0, $n=sizeof($column_list); $i<$n; $i++) { if ($column_list[$i] == 'PRODUCT_LIST_NAME') { $HTTP_GET_VARS['sort'] = $i+1 . 'a'; $listing_sql .= " order by pd.products_name"; break; } } } else { $sort_col = substr($HTTP_GET_VARS['sort'], 0 , 1); $sort_order = substr($HTTP_GET_VARS['sort'], 1); $listing_sql .= ' order by '; switch ($column_list[$sort_col-1]) { case 'PRODUCT_LIST_MODEL': $listing_sql .= "p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_NAME': $listing_sql .= "pd.products_name " . ($sort_order == 'd' ? 'desc' : ''); break; case 'PRODUCT_LIST_MANUFACTURER': $listing_sql .= "m.manufacturers_name " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_QUANTITY': $listing_sql .= "p.products_quantity " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_IMAGE': $listing_sql .= "pd.products_name"; break; case 'PRODUCT_LIST_WEIGHT': $listing_sql .= "p.products_weight " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_PRICE': $listing_sql .= "final_price " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; } } ?> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <!-- <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> <?php // optional Product List Filter if (PRODUCT_LIST_FILTER > 0) { if (isset($HTTP_GET_VARS['manufacturers_id'])) { $filterlist_sql = "select distinct c.categories_id as id, cd.categories_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' order by cd.categories_name"; } else { $filterlist_sql= "select distinct m.manufacturers_id as id, m.manufacturers_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by m.manufacturers_name"; } $filterlist_query = tep_db_query($filterlist_sql); if (tep_db_num_rows($filterlist_query) > 1) { echo ' <td align="center" class="main">' . tep_draw_form('filter', FILENAME_DEFAULT, 'get') . TEXT_SHOW . ' '; if (isset($HTTP_GET_VARS['manufacturers_id'])) { echo tep_draw_hidden_field('manufacturers_id', $HTTP_GET_VARS['manufacturers_id']); $options = array(array('id' => '', 'text' => TEXT_ALL_CATEGORIES)); } else { echo tep_draw_hidden_field('cPath', $cPath); $options = array(array('id' => '', 'text' => TEXT_ALL_MANUFACTURERS)); } echo tep_draw_hidden_field('sort', $_GET['sort']).(isset($_GET['list']) ? tep_draw_hidden_field('list', $_GET['list']) : '') . (isset($_GET['max']) ? tep_draw_hidden_field('max', $_GET['max']) : ''); while ($filterlist = tep_db_fetch_array($filterlist_query)) { $options[] = array('id' => $filterlist['id'], 'text' => $filterlist['name']); } echo tep_draw_pull_down_menu('filter_id', $options, (isset($HTTP_GET_VARS['filter_id']) ? $HTTP_GET_VARS['filter_id'] : ''), 'onchange="this.form.submit()"'); echo '</form></td>' . "\n"; } } // Get the right image for the top-right $image = DIR_WS_IMAGES . 'table_background_list.gif'; if (isset($HTTP_GET_VARS['manufacturers_id'])) { $image = tep_db_query("select manufacturers_image from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'"); $image = tep_db_fetch_array($image); $image = $image['manufacturers_image']; } elseif ($current_category_id) { $image = tep_db_query("select categories_image from " . TABLE_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'"); $image = tep_db_fetch_array($image); $image = $image['categories_image']; } ?> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> --> <tr> <td><?php include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING); ?></td> </tr> </table></td> <?php } else { // default page ?> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td> <? // STAR PRODUCT START... if (SHOW_STARPRODUCT=="true") { ?> <tr> <td><?php include(DIR_WS_MODULES . FILENAME_STAR_PRODUCT); ?></td> </tr> <? } // STAR PRODUCT END... ?> </td></tr> <tr><td> <? //<img src="images/m35.gif"> ?> <?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?> </td> </tr> </table> </td> <?php } ?> <!-- body_text_eof //--> </tr> </table> <!-- body_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> <?php echo $pagetext; ?> Quote Link to comment Share on other sites More sharing options...
spooks Posted April 15, 2009 Author Share Posted April 15, 2009 could be database_tables.php Quote Sam Remember, What you think I ment may not be what I thought I ment when I said it. Contributions: Auto Backup your Database, Easy way Multi Images with Fancy Pop-ups, Easy way Products in columns with multi buy etc etc Disable any Category or Product, Easy way Secure & Improve your account pages et al. Link to comment Share on other sites More sharing options...
mosco141319 Posted April 16, 2009 Share Posted April 16, 2009 Hi Spooks, Just wondering. Having applied your code above to remove the BUY NOW button (worked perfectly!) when stock is ZERO, how much more difficult would it be to put a SOLD OUT button there in place of the BUY NOW button - rather than removing it? I tried applying an add-on to replace the BUY NOW button with a NOTIFY ME button, but couldn't get it to work because the original install files affected had changed so much. It would be useful to be able to trigger an email once stock is in. Thanks, Jonathan Hi Spooks, If I want the new products page to display the SOLD OUT button also, is it possible? thanks & regards, Sanndra Quote Link to comment Share on other sites More sharing options...
Kayserili Posted April 16, 2009 Share Posted April 16, 2009 could be database_tables.php Hey Sam, i know i am not easy. Thanks for your clues till today. I have added the manufacturer_id to database tables.php. You where right, it wasn't defined. I have defined it like this, but still, i have no manufacturers headers in product listing; define('TABLE_MANUFACTURERS_ID','manufacturers_id'); Are there other man. tables that i need to add? Quote Link to comment Share on other sites More sharing options...
spooks Posted April 16, 2009 Author Share Posted April 16, 2009 The standard defines are define('TABLE_MANUFACTURERS', 'manufacturers'); define('TABLE_MANUFACTURERS_INFO', 'manufacturers_info'); thats asuming your dBase structure is standard of course. There's a reason that those in the know don`t use templates Quote Sam Remember, What you think I ment may not be what I thought I ment when I said it. Contributions: Auto Backup your Database, Easy way Multi Images with Fancy Pop-ups, Easy way Products in columns with multi buy etc etc Disable any Category or Product, Easy way Secure & Improve your account pages et al. Link to comment Share on other sites More sharing options...
Kayserili Posted April 16, 2009 Share Posted April 16, 2009 The standard defines are define('TABLE_MANUFACTURERS', 'manufacturers'); define('TABLE_MANUFACTURERS_INFO', 'manufacturers_info'); thats asuming your dBase structure is standard of course. There's a reason that those in the know don`t use templates You are right Sam, but i am not an expert in it. I mean, i am not a good designer. The only thing i can is programming (integrate, search for problems etc.) But this prob. is different :S I will try to track it. Thanks for your support m8. Regards, Kayserili Quote Link to comment Share on other sites More sharing options...
Hotclutch Posted April 19, 2009 Share Posted April 19, 2009 Hi Sam Is it possible to extend the P.O.A feature in the product listing to product_info.php? i.e when a customer clicks on the product page it displays the same definition for POA instead of price = 0. Thanks Ashley Quote Link to comment Share on other sites More sharing options...
spooks Posted April 19, 2009 Author Share Posted April 19, 2009 replace <td class="pageHeading" align="right" valign="top"><?php echo $products_price; ?></td> with <td class="pageHeading" align="right" valign="top"><?php echo ($product_info['products_price'] ? $products_price : TEXT_POA); ?></td> you'll need to update the language file too. Quote Sam Remember, What you think I ment may not be what I thought I ment when I said it. Contributions: Auto Backup your Database, Easy way Multi Images with Fancy Pop-ups, Easy way Products in columns with multi buy etc etc Disable any Category or Product, Easy way Secure & Improve your account pages et al. Link to comment Share on other sites More sharing options...
Hotclutch Posted April 19, 2009 Share Posted April 19, 2009 Hi Sam That had no effect I had in product_info.php <td align="right" valign="top"><h1><?php echo $products_price; ?></h1></td> which I replaced with <td align="right" valign="top"><h1><?php echo ($product_info['products_price'] ? $products_price : TEXT_POA); ?></h1></td> Then added define('TEXT_POA', 'To Be Announced'); to includes\languages\english\product_info.php See here and here, changes are still in place. Quote Link to comment Share on other sites More sharing options...
spooks Posted April 19, 2009 Author Share Posted April 19, 2009 Perhaps u have a different sql query?, do u have $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])); a little ealier? in case its a data issue u could try <td class="pageHeading" align="right" valign="top"><?php echo ($product_info['products_price'] > 0 ? $products_price : TEXT_POA); ?></td> Quote Sam Remember, What you think I ment may not be what I thought I ment when I said it. Contributions: Auto Backup your Database, Easy way Multi Images with Fancy Pop-ups, Easy way Products in columns with multi buy etc etc Disable any Category or Product, Easy way Secure & Improve your account pages et al. Link to comment Share on other sites More sharing options...
Hotclutch Posted April 20, 2009 Share Posted April 20, 2009 Perhaps u have a different sql query?, do u have $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])); a little ealier? in case its a data issue u could try <td class="pageHeading" align="right" valign="top"><?php echo ($product_info['products_price'] > 0 ? $products_price : TEXT_POA); ?></td> Thanks a lot Sam...The above worked. And I did have if ($new_price = tep_get_products_special_price($product_info['products_id'])) { $products_price = '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>'; } else { $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])); Quote Link to comment Share on other sites More sharing options...
JonathanR Posted April 21, 2009 Share Posted April 21, 2009 This code is replacing the buy now with a details button on 0 stock, just replace 'button_details_small.gif' with a 'button_sold_out.gif' in the code &make the button Hi Sam, As a follow up to me successfully changing the button to SOLD OUT back in March, I have just noticed that whenever I do a search for an item, all results are shown with the SOLD OUT button, even when they are in stock. Before I panic too much, is there a reason for this and, more importantly, a way around it? Thanks, Jonathan Quote Link to comment Share on other sites More sharing options...
spooks Posted April 21, 2009 Author Share Posted April 21, 2009 most likely you don`t have quontity in column list but coded to display? just add p.products_quantity, to sql in advanced_search_result.php Quote Sam Remember, What you think I ment may not be what I thought I ment when I said it. Contributions: Auto Backup your Database, Easy way Multi Images with Fancy Pop-ups, Easy way Products in columns with multi buy etc etc Disable any Category or Product, Easy way Secure & Improve your account pages et al. Link to comment Share on other sites More sharing options...
JonathanR Posted April 21, 2009 Share Posted April 21, 2009 most likely you don`t have quontity in column list but coded to display? just add p.products_quantity, to sql in advanced_search_result.php Hi Sam, You are right in that I have it set in admin to not display product quantity. When I change that to set quantity to display, the problem goes away. Of course, I don't want the quantity to display and I am afraid I don't understand the part about adding p.products_quantity to the sql. Quote Link to comment Share on other sites More sharing options...
spooks Posted April 21, 2009 Author Share Posted April 21, 2009 $select_column_list = ''; to $select_column_list = 'p.products_quantity, '; Quote Sam Remember, What you think I ment may not be what I thought I ment when I said it. Contributions: Auto Backup your Database, Easy way Multi Images with Fancy Pop-ups, Easy way Products in columns with multi buy etc etc Disable any Category or Product, Easy way Secure & Improve your account pages et al. Link to comment Share on other sites More sharing options...
JonathanR Posted April 22, 2009 Share Posted April 22, 2009 $select_column_list = ''; to $select_column_list = 'p.products_quantity, '; Thank you, Sam. That worked. This contrib has seriously improved my site. Quote Link to comment Share on other sites More sharing options...
ianric Posted April 22, 2009 Share Posted April 22, 2009 Hi I've modded my specials page to display in a list like the main product listing. Is it possible to add the sort order and results per page to the specials page? If you have a look at My Website you'll see sthe styling. Specials.php looks the same Hope that makes sense Cheers Ian Hi Me again, Just searched for my post and found a few others asking the same about the specials listing. Thought I'd let everyone know that it can be done. All I did was open products_new.php and save it as specials.php (backup original first of course). then I merged the specials and new_products SQL. This is MY SQL with MY EXTRA FIELDS. The important bit is the $sort_sql $products_new_query_raw = "select p.products_date_added, p.products_id, pd.products_name, pd.products_title, p.products_media, p.products_model, p.products_category, p.products_label, p.products_catno, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price, m.manufacturers_name, p.manufacturers_id from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id = m.manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_quantity = '1' and p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and s.status = '1' and pd.language_id = '" . (int)$languages_id . "'" . $sort_sql; Change the breadcrumb and language file at the top and leave everything as is. I THINK thats all I did and it works for me. I can't guarentee it working for anyone else but it's a start for anyone who wants to try Thanks for a great contrib Ian Quote Link to comment Share on other sites More sharing options...
d0zzen Posted April 26, 2009 Share Posted April 26, 2009 Added this contribution but the image sizes get all messed up for me, I use the 'On the Fly' Auto Thumbnailer using GD Library for my picture thumbnails. I saw that it was mentioned earlier in the thread but I didn't manage to find a working fix for it.. Does anyone know how I can get it to work? When I use the Thumbnail Product Listing Style the "picture address" becomes "http://www.mysite.com/product_thumb.php?img=images/easycap_huvudbild.jpg&w=390&h=31 But when I use the standard List style the "picture address" is http://www.mysite.com/product_thumb.php?im...;w=125&h=99 Thank you, and sorry if my english is bad. Quote Link to comment Share on other sites More sharing options...
spooks Posted April 26, 2009 Author Share Posted April 26, 2009 As I detailed ealier in this thread that contrib is badly bugged, try the fixes i detailed then for it, or use a better thumbnailer http://www.oscommerce.com/forums/index.php?s=&...t&p=1372684 Quote Sam Remember, What you think I ment may not be what I thought I ment when I said it. Contributions: Auto Backup your Database, Easy way Multi Images with Fancy Pop-ups, Easy way Products in columns with multi buy etc etc Disable any Category or Product, Easy way Secure & Improve your account pages et al. Link to comment Share on other sites More sharing options...
d0zzen Posted April 27, 2009 Share Posted April 27, 2009 As I detailed ealier in this thread that contrib is badly bugged, try the fixes i detailed then for it, or use a better thumbnailer http://www.oscommerce.com/forums/index.php?s=&...t&p=1372684 Thank you, tried that but then it uses my original images, not the thumbnails :/ would be wonderful if it could be solved.. Quote Link to comment Share on other sites More sharing options...
spooks Posted April 27, 2009 Author Share Posted April 27, 2009 Thank you, tried that but then it uses my original images, not the thumbnails :/ would be wonderful if it could be solved.. As I said, the problem is due to poor coding in that contib, I have no intention to re-code this to work arround bad coding elsewhere. Personnally if I knew I had some poor code on a site I would want rid. Use oscThumb instead http://addons.oscommerce.com/info/5491 that one works Quote Sam Remember, What you think I ment may not be what I thought I ment when I said it. Contributions: Auto Backup your Database, Easy way Multi Images with Fancy Pop-ups, Easy way Products in columns with multi buy etc etc Disable any Category or Product, Easy way Secure & Improve your account pages et al. Link to comment Share on other sites More sharing options...
d0zzen Posted April 28, 2009 Share Posted April 28, 2009 As I said, the problem is due to poor coding in that contib, I have no intention to re-code this to work arround bad coding elsewhere. Personnally if I knew I had some poor code on a site I would want rid. Use oscThumb instead http://addons.oscommerce.com/info/5491 that one works Thank you! Trying that one instead then. :-) Quote Link to comment Share on other sites More sharing options...
PJ2006 Posted April 28, 2009 Share Posted April 28, 2009 Is there a way to get the boxes all the same size? I'e managed to do it to most but not all, I'm guessing that's due to the image size - what controls the image size in product listing? I want it to look like this: http://www.astleyclarke.com/designers/couture_4 I also want to change my buttons just for this page - how do I do that? Finally how can I get the name and price below the box rather than in it as in tne example, sorry so many questions. Thanks Lotti Quote Link to comment Share on other sites More sharing options...
spooks Posted April 28, 2009 Author Share Posted April 28, 2009 Have u looked through the included text file? All you want is set in admin you can change the included button_details.gif and button_details_small.gif as u like others used are button_in_cart.gif and button_buy_now.gif Quote Sam Remember, What you think I ment may not be what I thought I ment when I said it. Contributions: Auto Backup your Database, Easy way Multi Images with Fancy Pop-ups, Easy way Products in columns with multi buy etc etc Disable any Category or Product, Easy way Secure & Improve your account pages et al. 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.