PDA

View Full Version : Featured Listing active



RealtyOne
07-27-2004, 11:16 PM
In a standard package installation if you have a featured listing that you make inactive the listing will still be accessable via the featured listings table.

to fix this open style.php and edit the following code
function renderFeaturedListingsVertical($num_of_listings)

$listingID = make_db_extra_safe($listingID);
$sql = "SELECT ID, Title FROM " . $config[table_prefix] . "listingsDB WHERE (featured = 'yes')";
change to

$listingID = make_db_extra_safe($listingID);
$sql = "SELECT ID, Title FROM " . $config[table_prefix] . "listingsDB WHERE (featured = 'yes') AND (active = 'yes')";

Save / upload

RealEstate
07-28-2004, 07:33 PM
Good catch!

What about if the listing is deleted by the agent? Will it be automatically removed from featured listings?

RealtyOne
07-28-2004, 09:46 PM
if deleted its no longer available in the database so it wont show up :)

greengiant
09-25-2004, 09:03 PM
Closing Thread. This has been added for 2.0 Alpha 1