Two Featured Ad Sections on Home

[go3matix +]

Hi, how can I put two featured ad sections on the home for two different categories? Thanks again.

[Lhotch +]

Find the file /includes/classes/smarty/plugins/function.feature_listings_horizontal.php and make a copy of it in the same directory but with a new name, something like

/includes/classes/smarty/plugins/function.feature_listings_horizontal_mycat.php

Open the newly saved file and look for the following line near the top of the file

function smarty_function_feature_listings_horizontal($params, &$smarty)

change it to match the new name like so.....

function smarty_function_feature_listings_horizontal_mycat($params, &$smarty)

Then scroll down a little bit and find the database query line that looks something like this.....

$sSQL="SELECT id,title,price FROM ".PREFIX."listings WHERE display = 'Y' AND expiration > NOW() AND featured = 'Y' ORDER BY rand() LIMIT ".$number;

and change it to the following, replace "mycat" with the number of the category you want to pull ads from.

$sSQL="SELECT id,title,price FROM ".PREFIX."listings WHERE display = 'Y' AND expiration > NOW() AND section = 'mycat' featured = 'Y' ORDER BY rand() LIMIT ".$number;

Then call the new plugin just like the original by using the new plugins name like so....

{feature_listings_horizontal_mycat number=8 cols=4 table_attr='width="100%" cellpadding="3" cellspacing="3"' td_attr='style="border-top: 1px dashed #999;"'}