Featured Listing by listing type

[Dinkum]

Currently featured listings in Irealty shows a mix of featured properties from HomesforSale and HomesforRent.

How do I change it that on certain pages it only shows HomesforSale or HomesforRent?

Thanks

[nikolosnet]

Hi Dinkum, to solve your problem for you:
1) modify file /system/modules/classifieds/config.php
replace

Code:

'featured_listings' => array
(
'display_name' => 'Featured Listings',
'script' => 'featured_listings.php',
'type' => 'user',
'access_type' => array('user'),
'params' => array ('featured_listings_template', 'number_of_rows', 'number_of_cols'),
),

to

Code:

'featured_listings' => array
(
'display_name' => 'Featured Listings',
'script' => 'featured_listings.php',
'type' => 'user',
'access_type' => array('user'),
'params' => array ('featured_listings_template', 'number_of_rows', 'number_of_cols', 'listing_type_id'),
),

2) modify file /system/lib/classifieds/Listing/ListingManager.php
replace

Code:

function getFeaturedListings($number_of_listings) {


$listings_info = DB::query("SELECT * FROM listings WHERE featured = 1 AND active = 1 ORDER BY featured_last_showed ASC LIMIT 0, ?n", $number_of_listings);

$listings = array();

to

Code:

function getFeaturedListings($number_of_listings) {

if(isset($_REQUEST['listing_type_id']))
{
$listing_type_sid = ListingTypeManager::getListingTypeSIDByID($_REQUEST['listing_type_id']);

$listings_info = DB::query("SELECT * FROM listings WHERE listing_type_sid = ?n AND featured = 1 AND active = 1 ORDER BY featured_last_showed ASC LIMIT 0, ?n", $listing_type_sid, $number_of_listings);
}
else
$listings_info = DB::query("SELECT * FROM listings WHERE featured = 1 AND active = 1 ORDER BY featured_last_showed ASC LIMIT 0, ?n", $number_of_listings);

$listings = array();

3) if you show featured listing in template by code

Code:

{module name="classifieds" function="featured_listings"}

, add to this construction parametr listing_type_id, for example,

Code:

{module name="classifieds" function="featured_listings" listing_type_id="HomesforSale"}

if you show featured listing by call user page, then modify your userpage, in this page added parametr listing_type_id, fill them

[Dinkum]

Thanks, I got it working, but had to modify the code in ListingManager.php slightly

Code:

$listings_info = DB::query("SELECT * FROM listings WHERE listing_type_sid = ?n, featured = 1 AND active = 1 ORDER BY featured_last_showed ASC LIMIT 0, ?n", $listing_type_sid, $number_of_listings);
}

to

Code:

$listings_info = DB::query("SELECT * FROM listings WHERE listing_type_sid = ?n AND featured = 1 AND active = 1 ORDER BY featured_last_showed ASC LIMIT 0, ?n", $listing_type_sid, $number_of_listings);
}

Simply replaced the comma after listng_type_sid = ?n with AND.

Thanks for the help.

[nikolosnet]

You're right, I made an error in the sql code.