Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Featured Product Support v1.5.4


jcisar

Recommended Posts

I installed 161 w/STS 453 instructions(running STS), but have a problem. If I enable Featured Products in the Admin, the Featured Products box "pushes" the main page content ($content) out of the middle column, instead of displayed under the main page content. According to Bill K's excellent instructions, I should be able to position the Featured box anywhere I want it:

 

Step 15.2:

Add the following STS Tag anywhere on your template pages if you want an individual (separate) Featured Infobox (optional), use this tag ONLY if you turn the Feature option OFF in your store's admin.

 

$featuredbox

 

but the $featuredbox tag does not work if I turn off the Featured option in the Admin and when enabled, I get 2 Featured Products on the main page? anybody know what's going on?

 

thanks,

 

Jerry, step 15.2 is referring to the smaller Featured infobox that usually would be displayed in the left or right colum of your shop. The box you are referring to is contained within the $content tag of the main column of your site and can be turned off in the admin.

 

If the Featured box in the main column is throwing off your layout, you may have messed something up in the index.php file during the installation or just need to tweak a td or tr where the Feartured box is being called in that file (index.php).

 

Hope this helped,

Bill Kellum

 

Sounds Good Productions

STS Tutorials & more: STSv4.6, STS Add-ons (STS Power Pack), STS V4 Forum STS Forum FREE TEMPLATE

Link to comment
Share on other sites

Jerry, step 15.2 is referring to the smaller Featured infobox that usually would be displayed in the left or right colum of your shop. The box you are referring to is contained within the $content tag of the main column of your site and can be turned off in the admin.

 

If the Featured box in the main column is throwing off your layout, you may have messed something up in the index.php file during the installation or just need to tweak a td or tr where the Feartured box is being called in that file (index.php).

 

Hope this helped,

Bill: Thanks for your reply, but, no, I can't see any problem with index.php. Here's the code..maybe you can spot something I'm missing?

<?php

/*

$Id: index.php 1739 2007-12-20 00:52:16Z hpdl $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 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="3" cellpadding="3">

<tr>

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<!-- left_navigation //-->

<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

<!-- left_navigation_eof //-->

</table></td>

<!-- body_text //-->

<?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="0">

<tr>

<td class="pageHeading"><?php echo $category['categories_name'] ?></td>

<td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . $category['categories_image'], $category['categories_name'], HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>

</tr>

</table></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<td><table border="0" width="100%" cellspacing="0" cellpadding="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_FEATURED); ?></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;

}

}

 

// 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, 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 left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c 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, 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 left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m 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 left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c 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 left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c 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);

 

switch ($column_list[$sort_col-1]) {

case 'PRODUCT_LIST_MODEL':

$listing_sql .= " order by p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

break;

case 'PRODUCT_LIST_NAME':

$listing_sql .= " order by pd.products_name " . ($sort_order == 'd' ? 'desc' : '');

break;

case 'PRODUCT_LIST_MANUFACTURER':

$listing_sql .= " order by m.manufacturers_name " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

break;

case 'PRODUCT_LIST_QUANTITY':

$listing_sql .= " order by p.products_quantity " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

break;

case 'PRODUCT_LIST_IMAGE':

$listing_sql .= " order by pd.products_name";

break;

case 'PRODUCT_LIST_WEIGHT':

$listing_sql .= " order by p.products_weight " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

break;

case 'PRODUCT_LIST_PRICE':

$listing_sql .= " order by 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 if (isset($HTTP_GET_VARS['manufacturers_id'])) {

 

$category_query = tep_db_query("select manufacturers_name from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'");

 

$category = tep_db_fetch_array($category_query);

 

if ($category['manufacturers_name'] != "") {echo $category['manufacturers_name'];} else { echo HEADING_TITLE;}

 

} else {

 

$category_query = tep_db_query("select cd.categories_name 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);

 

if ($category['categories_name'] != "") {echo $category['categories_name'];} else { 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', $HTTP_GET_VARS['sort']);

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 tep_hide_session_id() . '</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'];

}

?>

<td align="right"><?php echo tep_image(DIR_WS_IMAGES . $image, HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>

</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><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_image(DIR_WS_IMAGES . 'table_background_default.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>

</tr>

</table></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<td><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td class="main"><?php //echo tep_customer_greeting(); ?></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<td class="main"><?php echo TEXT_MAIN; ?></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<td><?php include(DIR_WS_MODULES . FILENAME_FEATURED); ?></td>

</tr>

<?php

include(DIR_WS_MODULES . FILENAME_UPCOMING_PRODUCTS);

?>

</table></td>

</tr>

</table></td>

<?php

}

?>

<!-- body_text_eof //-->

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<!-- right_navigation //-->

<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>

<!-- right_navigation_eof //-->

</table></td>

</tr>

</table>

<!-- body_eof //-->

 

<!-- footer //-->

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

<!-- footer_eof //-->

<br>

</body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Link to comment
Share on other sites

First of all I wanted to thank you for such complete instructions. It was all very understandable, even for a beginner like me except for the sql section. I think I may have figured it out. But I do have a problem.

 

I've worked all day trying to install Featured Products 161 with STS. I managed to make it through all the steps except for the ones for STS Template. In the admin side it will let me activate Featured and change how many products I wanted displayed. It also let me add products to Featured. But when I try to go to my live site it won't come up. It shows this message: Fatal error: Call to a member function add_current_page() on a non-object in /home/doglady8/public_html/includes/application_top.php on line 312

 

I don't understand it, I never changed anything on that line of the code. It seemed like it was going pretty good. I did the manual install so none of the changes to text and colors would be lost.

 

Please help me out. This is the first contribution I've been brave enough to try to install but I thought since your instructions were so good that I would be able to do it. Now I don't know what to do unless I restore the backup I made before starting.

 

I'm at a stand-still! Please help me figure out what is wrong.

Link to comment
Share on other sites

First of all I wanted to thank you for such complete instructions. It was all very understandable, even for a beginner like me except for the sql section. I think I may have figured it out. But I do have a problem.

 

I've worked all day trying to install Featured Products 161 with STS. I managed to make it through all the steps except for the ones for STS Template. In the admin side it will let me activate Featured and change how many products I wanted displayed. It also let me add products to Featured. But when I try to go to my live site it won't come up. It shows this message: Fatal error: Call to a member function add_current_page() on a non-object in /home/doglady8/public_html/includes/application_top.php on line 312

 

I don't understand it, I never changed anything on that line of the code. It seemed like it was going pretty good. I did the manual install so none of the changes to text and colors would be lost.

 

Please help me out. This is the first contribution I've been brave enough to try to install but I thought since your instructions were so good that I would be able to do it. Now I don't know what to do unless I restore the backup I made before starting.

 

I'm at a stand-still! Please help me figure out what is wrong.

 

Carol,

 

An easy solution would be for you to use a file comparison utility such as Beyond Compare or WinMerge to compare your files with those from the contribution. This will quickly show you where you may have gone wrong.

 

Hope this helps,

Bill Kellum

 

Sounds Good Productions

STS Tutorials & more: STSv4.6, STS Add-ons (STS Power Pack), STS V4 Forum STS Forum FREE TEMPLATE

Link to comment
Share on other sites

We've installed 1.59 and everything works as suggested with one exception. The only products that will show in the featured box on the front page are specials. Products that are not currently in the specials sections will not show in the features display on the front page.

 

Any ideas?

Link to comment
Share on other sites

Hi - there seems to be *BUG* with the latest (1.61) version of this contribution... The author adds joins for the Special products (evidentally to display the prices, etc...), however this makes it so that NO featured products will be displayed UNLESS they are on special...

 

I fixed mine (for the moment) by using the includes/modules/featured.php file in the Contribs page just before the 1.60 (or 160) update...

 

+1 on that...

 

I just came here after trying to install Featured Products 161 with STS 453 instructions.zip on my store. Everything seems to be working quite well, except for the fact that only "featured products" that have a "special price" will be showing up on the featured products boxes.

There is a post from yesterday that says this also happens with 1.59 installed, so I will try to compare SQL queries on the latest versions to try and find out how to fix it, but with the version I have installed myself, Out of all the products I add as featured, they will only show uyp as featured on the store if they have a special price.

MindTwist of Twisted Reality and Twisted Tienda

Link to comment
Share on other sites

Since everything else seems to be working fine, I just changed the file /includes/modules/featured.php by a previous version, looking for one that would work ok and show products that do not have a special price.

 

I have installed the latest version available as of today, "Featured Products 161 with STS 453 instructions" uploaded by Phocea on 25/Jun/2008

 

I tried the file /includes/modules/featured.php from 1.60, also by Phocea on 25/Jun/2008. No luck, I was geting a strange SQL error, probably that's why he uploaded 1.61 the same day.

 

I then tried the small featured.php file uploaded by itjust on 10/Jun/2008. That one seemed to work ok and I was seeing all products, but it displays no prices at all. No normal prices, no special prices, just the products :(

 

Then I went all the way back to 1.5.9, uploaded by bkellum on 15/Jul/2007. Using the included /includes/modules/featured.php on that version, my problem has been solved. Now all the featured products I select will be shown, no matter if they have special price or not.

MindTwist of Twisted Reality and Twisted Tienda

Link to comment
Share on other sites

Since everything else seems to be working fine, I just changed the file /includes/modules/featured.php by a previous version, looking for one that would work ok and show products that do not have a special price.

 

I have installed the latest version available as of today, "Featured Products 161 with STS 453 instructions" uploaded by Phocea on 25/Jun/2008

 

I tried the file /includes/modules/featured.php from 1.60, also by Phocea on 25/Jun/2008. No luck, I was geting a strange SQL error, probably that's why he uploaded 1.61 the same day.

 

I then tried the small featured.php file uploaded by itjust on 10/Jun/2008. That one seemed to work ok and I was seeing all products, but it displays no prices at all. No normal prices, no special prices, just the products :(

 

Then I went all the way back to 1.5.9, uploaded by bkellum on 15/Jul/2007. Using the included /includes/modules/featured.php on that version, my problem has been solved. Now all the featured products I select will be shown, no matter if they have special price or not.

 

Hi Mindtwist. Thats exactly what I had to do verbatim to resolve my issue. Seems like somewhere along the line after the revised bkellum version, the DB query stopped showing all of the products and or prices.

 

It would be nice to have these versions better governed. maybe every install has to be changed docs only. Or every package has to include all documents , including revised docs.

Link to comment
Share on other sites

Can someone PLEASE advise on how you can sort the featured products by price and ensure it doesn't randomly display the products? I have searched everywhere and have found no answers and I can't have this featured products on the home page displaying products on the fly, it needs to be set. As a suggestion, I would include this functionality in this contribution as a rather important aspect.

Brenda

Link to comment
Share on other sites

Can someone PLEASE advise on how you can sort the featured products by price and ensure it doesn't randomly display the products? I have searched everywhere and have found no answers and I can't have this featured products on the home page displaying products on the fly, it needs to be set. As a suggestion, I would include this functionality in this contribution as a rather important aspect.

Brenda

 

Brenda,

 

As a quick solution, download and install my version of the contribution. I know it gives you complete control over the products listed (that is one of the best features of the Featured Products contribution to begin with).

Bill Kellum

 

Sounds Good Productions

STS Tutorials & more: STSv4.6, STS Add-ons (STS Power Pack), STS V4 Forum STS Forum FREE TEMPLATE

Link to comment
Share on other sites

Can someone PLEASE advise on how you can sort the featured products by price and ensure it doesn't randomly display the products? I have searched everywhere and have found no answers and I can't have this featured products on the home page displaying products on the fly, it needs to be set. As a suggestion, I would include this functionality in this contribution as a rather important aspect.

Brenda

 

You want Featured to show the products you choose? Then choose only the number of products you are displaying on the main page... If you are displaying maybe 6 products, don't "feature" more than 6 products, and those will always be showing on the main index.

 

If you want to sort the, edit /includes/modules/featured.php and you need to replace on the SQL queries "order by rand($mtm)" for something like "order by p.products_price". Notice there are two SQL queries, one for the index, and one for sub categories.

MindTwist of Twisted Reality and Twisted Tienda

Link to comment
Share on other sites

Brenda,

 

As a quick solution, download and install my version of the contribution. I know it gives you complete control over the products listed (that is one of the best features of the Featured Products contribution to begin with).

 

 

Hi, This is the product I downloaded and installed; featureds Products 161 with STS. Everytime the home page is refreshed the items are randomly ordered. I'd be happy to accept a sort by price as long as it sticks, but that doesn't seem to happen. it would be nice if the featured products had a sort like the product sort contribution so you can explicitly set the items you want in your own desired orders vs price, mfg, etc.

Link to comment
Share on other sites

You want Featured to show the products you choose? Then choose only the number of products you are displaying on the main page... If you are displaying maybe 6 products, don't "feature" more than 6 products, and those will always be showing on the main index.

 

If you want to sort the, edit /includes/modules/featured.php and you need to replace on the SQL queries "order by rand($mtm)" for something like "order by p.products_price". Notice there are two SQL queries, one for the index, and one for sub categories.

 

The number I am displaying on featured is what is set in the admin tool. All the products are being diaplsyed as desired, it is just the sort order and on every page load it keeps changing. I did try changing the rand with no success, but will try again, perhaps I missed one of the statements. Thanks.

Link to comment
Share on other sites

I installed V 1.59 of Featured Products and have encountered a very strange issue. If I enable Display Featured Products, and use the mods shown, the center column displays the featured products as expected. However, then nothing in any category or sub category will display. When you click on a category or subcategory, only the featured products show. I also am using the SPPC mod. My setup is php 5.2.5, osCommerce 2.2-MS2, mySQL 4.1.22. :blink: Any ideas?

Link to comment
Share on other sites

I'm having strange problems with this contrib...it's working on my site but it's only showing one product in the main index even though I have selected 6 or so. On the right info box I have the featured section working fine with alll 6 products showing up right. Why won't the index section not work right?

 

Thanks,

 

Nigel

Edited by Tsuri Japan
Link to comment
Share on other sites

hi

 

the same problem , in the center module of index.php just show 1 product (even if in the admin section I have 6 prods to shown), and looking for why , I found that the only product shown is in "specials" too. so the central module it only shows prods that are in specials too .

 

I have this contribution : Featured Products 161 with STS 453.

I don't work with STS

 

solution?

 

bye

Edited by ivanrok
Link to comment
Share on other sites

I ran into the same problem and this solved it for me as well and is probably worth repeating:

I downloaded the package 'Featured Products 161 with STS 453 instructions' and installed everything but did not have the Featured Products section show up on my store's homepage. I repeated the entire install thinking I missed something with no luck.

 

Following Didgemandu's suggestion I went to the submission titled: 'featured.php now showing products from all nested subcategories' and uploaded the file: includes/modules/featured.php and the Featured Products displayed properly on my homepage.

 

Here's the file you'll need:

http://addons.oscommerce.com/info/651

To find the message about this just go to page 11 I think and you'll find it!

Just in case here's the post that totally got this to work:

http://www.oscommerce.com/forums/index.php?s=&...t&p=1273107

 

Got it, this worked for me! Great contrib because I was doing a sale on one of my catagories.... then I dropped this contrib below the banner where the sale is being promoted!! Perfect for sales then adding the items you want to sell below it!!!

 

Thanks very much.....

 

Nigel

Edited by Tsuri Japan
Link to comment
Share on other sites

It was all going so well LOL! Back end seems find but this error at the front?

 

1146 - Table '******_osc2.TABLE_FEATURED' doesn't exist

select featured_id from TABLE_FEATURED where status = '1' and now() >= expires_date and expires_date > 0

[TEP STOP]

 

I ran both sql queries/files and I can see the table in the list and view it but outside of that I don't know what else to do, could someone in the know please direct me in a wee solution, purty please? :blush:

 

Thanks

Heather

Link to comment
Share on other sites

No matter, I installed the back up for now as I have the weekend child free to work on things and I needed to be able to view the front page for design edits. I will try again another day. cheers!

Link to comment
Share on other sites

It was all going so well LOL! Back end seems find but this error at the front?

 

1146 - Table '******_osc2.TABLE_FEATURED' doesn't exist

select featured_id from TABLE_FEATURED where status = '1' and now() >= expires_date and expires_date > 0

[TEP STOP]

 

I ran both sql queries/files and I can see the table in the list and view it but outside of that I don't know what else to do, could someone in the know please direct me in a wee solution, purty please? :blush:

 

Thanks

Heather

 

It appears you might have run the same sql setup twice. Select the corect ersion to setup, open phpMyAdmin and first run a query using the DROP table NAME_OF_TABLE. That will clean out the old tables. The run the correct script to set up the table you need.

 

Good luck!

:rolleyes:

Edited by mmeachm
Link to comment
Share on other sites

It appears you might have run the same sql setup twice. Select the corect ersion to setup, open phpMyAdmin and first run a query using the DROP table NAME_OF_TABLE. That will clean out the old tables. The run the correct script to set up the table you need.

 

Good luck!

:rolleyes:

 

Thank you, it is very possible that I did that, another lesson learned, tables dropped and all is well. Cheers :)

Link to comment
Share on other sites

Hello,

thanks for the contrib !

I would like to display this FEATURES MENU in the main menu, not on the left column...

And I'd like to display a black background on this "feature" area.

Is it possible or not?

Thanks a lot !

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...