Jump to content
jcisar

Featured Product Support v1.5.4

Recommended Posts

This should be a simple one. On the large Featured Products box on the main page (not the info box in the column) how do I remove the link to the Featured Products page?

 

I want the large box and the title "Featured Products", I just want to remove the ability to click on the Featured Products title and bring up the Featured Products page. Therefore, I'm seeking the area where that link is in order to remove it.

 

Ideas?

 

Thanks,

Anthony

 

Does anybody know how to do this? It's quite an old post, but I'd appreciate an answer to his question...

 

Thanks alot.

Share this post


Link to post
Share on other sites

I am running

osCommerce Online Merchant v2.3.1

 

and I went through step by step and at the end the catalog infobox disappeared in the admin section. and then no products showed up on my main page.

 

Any thoughts in what I might have missed or what I need to change? I did a restore of the site (I saved my changes files and can easily swap them back in)

 

Any suggestions would be appreciated.

Share this post


Link to post
Share on other sites

Stephanie,

 

I am just completing the update to Featured Products for use with v2.3.1. I will upload it to the contribution area by Friday.

 

 

 

Chris


:|: Was this post helpful ? Click the LIKE THIS button :|:

 

See my Profile to learn more about add ons, templates, support plans and custom coding (click here)

Share this post


Link to post
Share on other sites

I am running

osCommerce Online Merchant v2.3.1

 

and I went through step by step and at the end the catalog infobox disappeared in the admin section. and then no products showed up on my main page.

 

Any thoughts in what I might have missed or what I need to change? I did a restore of the site (I saved my changes files and can easily swap them back in)

 

Any suggestions would be appreciated.

 

Awesome Thank you!!!

Edited by QDblue2000

Share this post


Link to post
Share on other sites

Hi Guys, I have been trying to figure this out now for a week, pulling my hair out. I installed Featured products version 1.6.5. Everything works fine except the formatting, the box is tiny and it has pushed my left column out. The original code for new_products was

 

<?php

/*

$Id: new_products.php,v 1.34 2003/06/09 22:49:58 hpdl Exp $

 

E-Commerce Solutions

 

Copyright © 2005 www.flash-template-design.com

 

Released under the GNU General Public License

*/

?>

<!-- new_products //-->

<tr>

<td>

<?php

$info_box_contents = array();

$info_box_contents[] = array('text' => TABLE_HEADING_NEW_PRODUCTS);

 

new infoBoxHeading1($info_box_contents,true,true,false);

?>

<div style="background-color:#FFF; border:1px solid #A6B3BA; border-width:0px 1px; text-align:center; ">

<?php

if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) {

$new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);

} else {

$new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);

}

 

$row = 0;

$col = 0;

$info_box_contents = array();

while ($new_products = tep_db_fetch_array($new_products_query)) {

$new_products['products_name'] = tep_get_products_name($new_products['products_id']);

 

$sql = 'SELECT `products_description` FROM `products_description` WHERE products_id ='.$new_products['products_id'].' && language_id='.(int)$languages_id;

$description_query = tep_db_query($sql);

$description = mysql_fetch_array($description_query, MYSQL_ASSOC);

$description['products_description'] = substr($description['products_description'], 0, 65);

$desc_len = strlen($description['products_description']);

$description['products_description'][$desc_len-1] = '.';

$description['products_description'][$desc_len-2] = '.';

$description['products_description'][$desc_len-3] = '.';

 

if ( ($col == 1 && $row == 0) || ($col == 1 && $row == 2) ){

$info_box_contents[$row][$col] = array('align' => 'center',

'params' => 'width="1" height="100%" valign="middle" ',

'text' => '<table height="" width="100%" border="0" cellspacing="0" cellpadding="0" >

<tr>

<td><div style="width:1px;"><span style="font-size:1px;"> </span></div></td>

</tr>

</table>');

}

elseif (($col == 0 && $row == 1) || ($col == 2 && $row == 1)) {

$info_box_contents[$row][$col] = array('align' => 'center',

'params' => 'height="1"',

'text' => '<table width="95%" border="0" cellspacing="0" cellpadding="0" >

<tr>

<td style="font-size:1px;background:url(images/points.gif) repeat-x;"> </td>

</tr>

</table>');

}

elseif ($col == 1 && $row == 1) {

$info_box_contents[$row][$col] = array('align' => '',

'params' => '',

'text' => '<span style="font-size:1px;"> </span>');

}

else {

$info_box_contents[$row][$col] = array('align' => 'center',

'params' => 'class="main" width="50%" valign="top" align="left"',

'text' => '<table width="96%" cellpadding=0 cellspacing=0 border=0 style="margin-bottom:4px;">

<tr>

 

<td colspan="2" height="35" style="padding:0px 10px;" align=left><div class="productName"><b>'.$new_products['products_name'].'</b></div></td>

</tr>

<tr>

<td style="padding-bottom:2px;"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $new_products['products_image'], $new_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'align="absmiddle"') . '</a></td>

<td height="32" valign="bottom" align="left" style="color:#586770; font-size:11px; font-weight:bold;">Price:<br/><span style="color:#C20000; font-size:14px; font-weight:bold; "> ' . $currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id'])).'</span></td>

</tr>

 

<tr>

<td colspan="2" class="main" valign=top align="right" style="padding-right:1px; >'. tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=add_product')).'

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

<tr>

<td style="padding-top:1px; padding-right:1px;" ><a href="'.tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']).'">'.tep_image_button('button_details.gif', IMAGE_BUTTON_DETAILS).'</a></td><td style="padding-top:1px;"><a href="' . tep_href_link(FILENAME_DEFAULT, tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $new_products['products_id']) . '">' . tep_image_button('button_add_to_cart.gif', IMAGE_BUTTON_IN_CART) . '</a></td>

</tr>

</table></form>

</td>

</tr>

</table>'); }

 

 

$col ++;

if ($col > 2) {

$col = 0;

$row ++;

}

 

}

new contentBox($info_box_contents, 0);

?>

</div>

<?php new infoBoxFooter(''); ?>

</td>

</tr>

<!-- new_products_eof //-->

 

 

 

And the code for the featured that replaced it is

 

<?php

/*

$Id: featured.php,v 1.7 2008/08/22 22:30:20 aa0001 Exp $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2002 osCommerce

 

Released under the GNU General Public License

 

Featured Products V1.1

Displays a list of featured products, selected from admin

For use as an Infobox instead of the "New Products" Infobox

*/

?>

<!-- featured_products //-->

<?php

if( defined('FEATURED_PRODUCTS_DISPLAY') AND FEATURED_PRODUCTS_DISPLAY == 'true' ) {

$featured_products_category_id = (isset($new_products_category_id))?$new_products_category_id:'0';

$cat_name_query = tep_db_query('SELECT `categories_name` FROM ' . TABLE_CATEGORIES_DESCRIPTION . " WHERE `categories_id` = '" . $featured_products_category_id . "' limit 1");

$cat_name_fetch = tep_db_fetch_array($cat_name_query);

$cat_name = $cat_name_fetch['categories_name'];

$info_box_contents = array();

 

list($usec, $sec) = explode(' ', microtime());

srand( (float) $sec + ((float) $usec * 100000) );

$mtm= rand();

 

if ( (!isset($featured_products_category_id)) || ($featured_products_category_id == '0') ) {

$info_box_contents[] = array('align' => 'left', 'text' => '<a class="headerNavigation" href="' . tep_href_link(FILENAME_FEATURED_PRODUCTS) . '">' . TABLE_HEADING_FEATURED_PRODUCTS . '</a>');

 

// Phocea Optimize featured query

// Ben: Option to only show featured products on sale

$query = 'SELECT p.products_id, p.products_image, p.products_tax_class_id, IF (s.status, s.specials_new_products_price, NULL) AS specials_new_products_price, p.products_price, pd.products_name ';

 

if ( defined('FEATURED_PRODUCTS_SPECIALS_ONLY') AND FEATURED_PRODUCTS_SPECIALS_ONLY == 'true' ) {

$query .= 'FROM ' . TABLE_SPECIALS . ' s LEFT JOIN ' . TABLE_PRODUCTS . ' p ON s.products_id = p.products_id ';

} else {

$query .= 'FROM ' . TABLE_PRODUCTS . ' p LEFT JOIN ' . TABLE_SPECIALS . ' s ON p.products_id = s.products_id ';

}

 

$query .= 'LEFT JOIN ' . TABLE_PRODUCTS_DESCRIPTION . " pd ON p.products_id = pd.products_id AND pd.language_id = '" . $languages_id . "'

LEFT JOIN " . TABLE_FEATURED . " f ON p.products_id = f.products_id

WHERE p.products_status = '1' AND f.status = '1' order by rand($mtm) DESC limit " . MAX_DISPLAY_FEATURED_PRODUCTS;

 

$featured_products_query = tep_db_query( $query );

} else {

$info_box_contents[] = array('align' => 'left', 'text' => sprintf(TABLE_HEADING_FEATURED_PRODUCTS_CATEGORY, $cat_name));

$subcategories_array = array();

tep_get_subcategories($subcategories_array, $featured_products_category_id);

$featured_products_category_id_list = tep_array_values_to_string($subcategories_array);

if ($featured_products_category_id_list == '') {

$featured_products_category_id_list .= $featured_products_category_id;

} else {

$featured_products_category_id_list .= ',' . $featured_products_category_id;

}

 

if ( defined('FEATURED_PRODUCTS_SUB_CATEGORIES') AND FEATURED_PRODUCTS_SUB_CATEGORIES == 'true' ) {

// current catID as starting value

$cats[] = $new_products_category_id;

// put cat-IDs of all cats nested in current branch into $cats array,

// go through all subbranches

for($i=0; $i<count($cats); $i++) {

$categorie_query = tep_db_query('SELECT `categories_id` FROM ' . TABLE_CATEGORIES . " WHERE parent_id = '" . (int)$cats[$i] . "'");

while ($categorie = tep_db_fetch_array($categorie_query)) {

$cats[] = $categorie['categories_id'];

}

// sort out doubles

$cats = array_unique($cats);

}

$catIdSql = implode(', ', $cats);

} else {

$catIdSql = $featured_products_category_id_list;

}

 

// Phocea Optimize featured query

$query = 'SELECT distinct p.products_id, p.products_image, p.products_tax_class_id, IF (s.status, s.specials_new_products_price, NULL) AS specials_new_products_price, p.products_price, pd.products_name

FROM ' . TABLE_PRODUCTS . ' p LEFT JOIN ' . TABLE_PRODUCTS_TO_CATEGORIES . ' p2c using(products_id)

LEFT JOIN ' . TABLE_CATEGORIES . ' c USING (categories_id)

LEFT JOIN ' . TABLE_FEATURED . ' f ON p.products_id = f.products_id

LEFT JOIN ' . TABLE_SPECIALS . ' s ON p.products_id = s.products_id

LEFT JOIN ' . TABLE_PRODUCTS_DESCRIPTION . " pd ON p.products_id = pd.products_id AND pd.language_id = '" . $languages_id . "'

where c.categories_id IN(" . $catIdSql . ") AND p.products_status = '1' AND f.status = '1' ";

 

if ( defined('FEATURED_PRODUCTS_SPECIALS_ONLY') AND FEATURED_PRODUCTS_SPECIALS_ONLY == 'true' ) {

$query .= " AND s.status = '1' ";

}

$query .= 'ORDER BY rand(' . $mtm . ') DESC LIMIT ' . MAX_DISPLAY_FEATURED_PRODUCTS;

 

$featured_products_query = tep_db_query( $query );

}

 

$row = 0;

$col = 0;

$num = 0;

while ($featured_products = tep_db_fetch_array($featured_products_query)) {

$num ++;

if ($num == 1) {

new contentBoxHeading($info_box_contents);

}

// If on special show regular and sale price

if (tep_not_null($featured_products['specials_new_products_price'])) {

$products_price = '<s>' . $currencies->display_price($featured_products['products_price'], tep_get_tax_rate($featured_products['products_tax_class_id'])) . '</s><br>';

$products_price .= '<span class="productSpecialPrice">' . $currencies->display_price($featured_products['specials_new_products_price'], tep_get_tax_rate($featured_products['products_tax_class_id'])) . '</span>';

} else {

$products_price = $currencies->display_price($featured_products['products_price'], tep_get_tax_rate($featured_products['products_tax_class_id']));

}

$info_box_contents[$row][$col] = array('align' => 'center',

'params' => 'class="smallText" width="5%" valign="top"',

'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $featured_products['products_image'], $featured_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products['products_id']) . '">' . $featured_products['products_name'] . '</a><br>' . $products_price);

$col ++;

if ($col > 3) {

$col = 0;

$row ++;

}

}

if($num) {

 

new contentBox($info_box_contents);

}

} else {

// If it's disabled, then include the original New Products box

// include (DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); // disable for dont show if desactive the feature module

}

?>

<!-- featured_products_eof //-->

 

 

Please Please can someone help me.

 

Scott

Share this post


Link to post
Share on other sites

Stephanie,

 

I am just completing the update to Featured Products for use with v2.3.1. I will upload it to the contribution area by Friday.

 

 

 

Chris

 

Chris

 

was this updated. I checked for Featured Products under the contributes area and I am not seeing it.

 

thanks

Stephanie

Share this post


Link to post
Share on other sites

Hi Stephanie,

 

I know, I am sorry I have been very busy. I will get it uploaded as soon as possible.

 

 

 

 

Chris


:|: Was this post helpful ? Click the LIKE THIS button :|:

 

See my Profile to learn more about add ons, templates, support plans and custom coding (click here)

Share this post


Link to post
Share on other sites

The New Support forum for Featured Products for v2.3.x is located here:

 

http://forums.oscommerce.com/topic/370855-contribution-featured-products-for-v23x/

 

 

 

Featured Products v2.3.x can be downloaded here:

 

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

 

 

 

Chris


:|: Was this post helpful ? Click the LIKE THIS button :|:

 

See my Profile to learn more about add ons, templates, support plans and custom coding (click here)

Share this post


Link to post
Share on other sites

Does anybody know how to do this? It's quite an old post, but I'd appreciate an answer to his question...

 

Thanks alot.

 

To remove the link from the Box Heading:

 

line 31 of includes\modules\featured.php

 

Change

 

$info_box_contents[] = array('align' => 'left', 'text' => '<a class="headerNavigation" href="' . tep_href_link(FILENAME_FEATURED_PRODUCTS) . '">' . TABLE_HEADING_FEATURED_PRODUCTS . '</a>');

 

to

 

$info_box_contents[] = array('align' => 'left', 'text' => TABLE_HEADING_FEATURED_PRODUCTS );

Share this post


Link to post
Share on other sites

Okay folks, I have just added this contribution and it is great. All is working - Special thank you to those that created and contributed to it - Great Job. To see mine it is www.nontando.com

There are 3 things that I would additionally like to do:

 

1. How can add my specials (at its special prices) to the featured products, and it displays the special prices. I just added 2 items that fall under that category ad it display the original price. I know there is an option for specials in config, but that only will allow me to display items on special (it still displays the original price).

 

2. I would like to beautify the featured products box a bit (similar to the way the new products worked), i.e. change font, perhaps a border/box, etc. How would I do this.

 

3. One of the main resons I added this contr, is the ability to have featured products selected and displayed for specific holidays, etc. Hence, i would like to be able to change the heading that currently says "Featured Products" to the applicable occasion, e.g. "Gift Ideas for Fathers Day". I know I can probably hard code it in index.php - just wondering if was a way without changing this file.

 

Thank so much, Gary

Share this post


Link to post
Share on other sites

Hi all,

 

Hope someone can elp with this.

 

I am running featured.php and have managed to limit the columns to 2 instead of 3 columns as 3 columns were pushing my borders out.

 

However the featured.php box is still too wide but only because the length of the text. Does anyone know of a way to wrap the text after 20 characters or so?

 

Or is there a way of limiting the actual table itself so it nevers goes beyond a certain amount. Below is the code I am using in featured.php module.

 

Help.

 

******

<?php

/*

$Id: featured.php,v 1.7 2008/08/22 22:30:20 aa0001 Exp $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2002 osCommerce

 

Released under the GNU General Public License

 

Featured Products V1.1

Displays a list of featured products, selected from admin

For use as an Infobox instead of the "New Products" Infobox

*/

?>

<!-- featured_products //-->

<?php

if( defined('FEATURED_PRODUCTS_DISPLAY') AND FEATURED_PRODUCTS_DISPLAY == 'true' ) {

$featured_products_category_id = $new_products_category_id;

$cat_name_query = tep_db_query('SELECT `categories_name` FROM ' . TABLE_CATEGORIES_DESCRIPTION . " WHERE `categories_id` = '" . $featured_products_category_id . "' limit 1");

$cat_name_fetch = tep_db_fetch_array($cat_name_query);

$cat_name = $cat_name_fetch['categories_name'];

$info_box_contents = array();

 

list($usec, $sec) = explode(' ', microtime());

srand( (float) $sec + ((float) $usec * 100000) );

$mtm= rand();

 

if ( (!isset($featured_products_category_id)) || ($featured_products_category_id == '0') ) {

$info_box_contents[] = array('align' => 'left', 'text' => '<a class="headerNavigation" href="' . tep_href_link(FILENAME_FEATURED_PRODUCTS) . '">' . TABLE_HEADING_FEATURED_PRODUCTS . '</a>');

 

// Phocea Optimize featured query

// Ben: Option to only show featured products on sale

$query = 'SELECT p.products_id, p.products_image, p.products_tax_class_id, IF (s.status, s.specials_new_products_price, NULL) AS specials_new_products_price, p.products_price, pd.products_name ';

 

if ( defined('FEATURED_PRODUCTS_SPECIALS_ONLY') AND FEATURED_PRODUCTS_SPECIALS_ONLY == 'true' ) {

$query .= 'FROM ' . TABLE_SPECIALS . ' s LEFT JOIN ' . TABLE_PRODUCTS . ' p ON s.products_id = p.products_id ';

} else {

$query .= 'FROM ' . TABLE_PRODUCTS . ' p LEFT JOIN ' . TABLE_SPECIALS . ' s ON p.products_id = s.products_id ';

}

 

$query .= 'LEFT JOIN ' . TABLE_PRODUCTS_DESCRIPTION . " pd ON p.products_id = pd.products_id AND pd.language_id = '" . $languages_id . "'

LEFT JOIN " . TABLE_FEATURED . " f ON p.products_id = f.products_id

WHERE p.products_status = '1' AND f.status = '1' order by rand($mtm) DESC limit " . MAX_DISPLAY_FEATURED_PRODUCTS;

 

$featured_products_query = tep_db_query( $query );

} else {

$info_box_contents[] = array('align' => 'left', 'text' => sprintf(TABLE_HEADING_FEATURED_PRODUCTS_CATEGORY, $cat_name));

$subcategories_array = array();

tep_get_subcategories($subcategories_array, $featured_products_category_id);

$featured_products_category_id_list = tep_array_values_to_string($subcategories_array);

if ($featured_products_category_id_list == '') {

$featured_products_category_id_list .= $featured_products_category_id;

} else {

$featured_products_category_id_list .= ',' . $featured_products_category_id;

}

 

if ( defined('FEATURED_PRODUCTS_SUB_CATEGORIES') AND FEATURED_PRODUCTS_SUB_CATEGORIES == 'true' ) {

// current catID as starting value

$cats[] = $new_products_category_id;

// put cat-IDs of all cats nested in current branch into $cats array,

// go through all subbranches

for($i=0; $i<count($cats); $i++) {

$categorie_query = tep_db_query('SELECT `categories_id` FROM ' . TABLE_CATEGORIES . " WHERE parent_id = '" . (int)$cats[$i] . "'");

while ($categorie = tep_db_fetch_array($categorie_query)) {

$cats[] = $categorie['categories_id'];

}

// sort out doubles

$cats = array_unique($cats);

}

$catIdSql = implode(', ', $cats);

} else {

$catIdSql = $featured_products_category_id_list;

}

 

// Phocea Optimize featured query

$query = 'SELECT distinct p.products_id, p.products_image, p.products_tax_class_id, IF (s.status, s.specials_new_products_price, NULL) AS specials_new_products_price, p.products_price, pd.products_name

FROM ' . TABLE_PRODUCTS . ' p LEFT JOIN ' . TABLE_PRODUCTS_TO_CATEGORIES . ' p2c using(products_id)

LEFT JOIN ' . TABLE_CATEGORIES . ' c USING (categories_id)

LEFT JOIN ' . TABLE_FEATURED . ' f ON p.products_id = f.products_id

LEFT JOIN ' . TABLE_SPECIALS . ' s ON p.products_id = s.products_id

LEFT JOIN ' . TABLE_PRODUCTS_DESCRIPTION . " pd ON p.products_id = pd.products_id AND pd.language_id = '" . $languages_id . "'

where c.categories_id IN(" . $catIdSql . ") AND p.products_status = '1' AND f.status = '1' ";

 

if ( defined('FEATURED_PRODUCTS_SPECIALS_ONLY') AND FEATURED_PRODUCTS_SPECIALS_ONLY == 'true' ) {

$query .= " AND s.status = '1' ";

}

$query .= 'ORDER BY rand(' . $mtm . ') DESC LIMIT ' . MAX_DISPLAY_FEATURED_PRODUCTS;

 

$featured_products_query = tep_db_query( $query );

}

 

$row = 0;

$col = 0;

$num = 0;

while ($featured_products = tep_db_fetch_array($featured_products_query)) {

$num ++;

if ($num == 1) {

new contentBoxHeading($info_box_contents);

}

// If on special show regular and sale price

if (tep_not_null($featured_products['specials_new_products_price'])) {

$products_price = '<s>' . $currencies->display_price($featured_products['products_price'], tep_get_tax_rate($featured_products['products_tax_class_id'])) . '</s><br>';

$products_price .= '<span class="productSpecialPrice">' . $currencies->display_price($featured_products['specials_new_products_price'], tep_get_tax_rate($featured_products['products_tax_class_id'])) . '</span>';

} else {

$products_price = $currencies->display_price($featured_products['products_price'], tep_get_tax_rate($featured_products['products_tax_class_id']));

}

$info_box_contents[$row][$col] = array('align' => 'center',

'params' => 'class="smallText" width="15" valign="top"',

'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $featured_products['products_image'], $featured_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products['products_id']) . '">' . $featured_products['products_name'] . '</a><br>' . $products_price);

$col ++;

if ($col > 1) {

$col = 0;

$row ++;

}

}

if($num) {

 

new contentBox($info_box_contents);

}

} else {

// If it's disabled, then include the original New Products box

// include (DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); // disable for dont show if desactive the feature module

}

?>

<!-- featured_products_eof //-->

******

Share this post


Link to post
Share on other sites

Hello everyone. I just installed the Featured Products 1.6.3 add-on to my oscommerce 2.2 rc1 store and this is the link to go to for help. I've searched and searched for someone with the same exact problem as me, but couldn't find one. There were some with similar problems, but they either were never offered a solution, or there solution didn't work for me.

 

I went through all of the steps and made sure all of the changes were made correctly. I am kind of ignorant about how to use phpMyAdmin, so that may be the reason I am getting the error I'm getting. On step 9 of the install instructions, it says:

 

Step 9:

Edit the file /catalog/includes/application_top.php:

 

Find:

tep_expire_specials();

 

Add after:

// BOF: Featured Products

// auto expire featured products

require(DIR_WS_FUNCTIONS . 'featured.php');

tep_expire_featured();

// EOF: Featured Products

 

 

That is exactly what I did and the code was put in there right. Now, the last step before using this add-on is this:

 

Step 17: 
Now you need to create the database table that will be holding the featured products. To do so, you will need to run the featured_products_english.sql file's contents in your favorite sql interface (like phpmyadmin) to your existing database.

 

I THINK that I did this right, but I am not sure. Here is the error code that I am getting on the main page of my store now:

 

Warning: require(includes/functions/featured.php) [function.require]: failed to open stream: No such file or directory in /home/pinpoin4/public_html/gospeltractorg/store/includes/application_top.php on line 472

 

Warning: require(includes/functions/featured.php) [function.require]: failed to open stream: No such file or directory in /home/pinpoin4/public_html/gospeltractorg/store/includes/application_top.php on line 472

 

Fatal error: require() [function.require]: Failed opening required 'includes/functions/featured.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/pinpoin4/public_html/gospeltractorg/store/includes/application_top.php on line 472

 

If I've done something wrong concerning step 17, can someone please walk me through it step by step? It seems that step 17 assumes that I know more than I do about using phpMyAdmin. Thank you for any help anyone gives...

Share this post


Link to post
Share on other sites

Hi,

 

Just installed this but when I go into the admin and catalog all I have is < instead of saying Featured Products, when i click on the < it states

 

The requested URL /zxmnv/< was not found on this server.

 

the zxmnv is the name of my admin folder

 

Any help on this would be greatly appreciated.

 

Many thanks

Share this post


Link to post
Share on other sites

Hi,

 

Just installed this but when I go into the admin and catalog all I have is < instead of saying Featured Products, when i click on the < it states

 

The requested URL /zxmnv/< was not found on this server.

 

the zxmnv is the name of my admin folder

 

Any help on this would be greatly appreciated.

 

Many thanks

 

 

Sorry think i've added this to the wrong page. I have now added it to the one for 2.3.

Share this post


Link to post
Share on other sites

I spent at LEAST an hour relentlessly looking through this thread for info on this, but havent been able to find anything. My eyes are freakin out from all the manual searching.

(There should be a better way to find posts about issues we are looking for!)

 

At any rate... On the store I am working on, the featured products on the main page is blue and doesnt match the rest of the site at all. I have searched through the files and not been able to find the formatting and table info or color info anywhere...

 

PLEASE, can someone let me know how to make this match the rest of the site?

 

It would be great if we can even just ditch the visible table and just make it white with no border... And get rid of the "Featured Products" heading in the top of the table all together...

 

Thank you in advance. I like the way this works, and appreciate all the time gone into doing this for us... I just need the table info gone and remove the header title for it too..

 

You can see what I mean here:

 

http://www.rivasremedies.com/store/index.php

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×