Display ALL active listings under category list

[seymourjames +]

If you want the listings to appear under main categories and one level of subcategory but not under the top browselistings page itself then you do this instead in category.php . You don't need to touch other files at all.

replace $showlistings='N'; with

if(isset($_GET['cat']) || isset($_GET['id']))
{
$showlistings='Y';
}
else
{
$showlistings='N';
}


and then the code Eric gave for category.php

$options['section']=$sec;

Change to:

if(isset($sec)) {
$options['section']=$sec;
}

[Fatih67 +]

Originally Posted by seymourjames

If you want the listings to appear under main categories and one level of subcategory but not under the top browselistings page itself then you do this instead in category.php . You don't need to touch other files at all.

replace $showlistings='N'; with

if(isset($_GET['cat']) || isset($_GET['id']))
{
$showlistings='Y';
}
else
{
$showlistings='N';
}


and then the code Eric gave for category.php

$options['section']=$sec;

Change to:

if(isset($sec)) {
$options['section']=$sec;
}

ı tried this.

but not worked.

all listings are shown every category.. same problem..

[Lhotch +]

Originally Posted by Fatih67

ı tried this.

but not worked.

all listings are shown every category.. same problem..

Did you expect it to? Your sig says you are using 4.0.3 yet this thread is in the 4.1.X support forum. There are seperate support forums for 4.0 and 4.1 for a reason and that reason is that there are a lot of code difference between the 2 major releases.

[damiun +]

this isnt working for me either, it shows this error:

Notice: Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 SQL: SELECT id FROM class_categories WHERE parent_id In () in /usr/home/deb19947/domains/damiun.nl/public_html/includes/classes/database/mysql.php on line 143

Notice: Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND p.price BETWEEN 0 AND 99999999999 AND p.expiration > NOW() AND p.display =' at line 1 SQL: SELECT p.id, p.owner, p.title, p.featured, p.section, p.shortDescription, p.description, p.price, p.dateadded, p.expiration, p.display, p.pHighlighted, p.pBold, p.hitcount, p.url, u.username, u.state, u.city, u.country, u.extra, u.extra2, u.extra3 , p.alt_address, p.alt_city, p.alt_state, p.alt_country, p.alt_zip, p.alt_phone ,store.sTitle,store.sDescription,store.sImage FROM class_listings AS p LEFT JOIN class_users AS u ON p.owner = u.id LEFT JOIN class_store AS store ON (p.owner = store.sUserId) WHERE 1=1 AND p.section In () AND p.price BETWEEN 0 AND 99999999999 AND p.expiration > NOW() AND p.display = "Y" GROUP BY p.id, p.owner, p.title, p.featured, p.section, p.description, p.dateadded, p.expiration, p.alt_state, p.alt_city, p.alt_country ORDER BY dateadded desc in /usr/home/deb19947/domains/damiun.nl/public_html/includes/classes/database/mysql.php on line 143

Notice: Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND p.price BETWEEN 0 AND 99999999999 AND p.expiration > NOW() AND p.display =' at line 1 SQL: SELECT p.id, p.owner, p.title, p.featured, p.section, p.shortDescription, p.description, p.price, p.dateadded, p.expiration, p.display, p.pHighlighted, p.pBold, p.hitcount, p.url, u.username, u.state, u.city, u.country, u.extra, u.extra2, u.extra3 , p.alt_address, p.alt_city, p.alt_state, p.alt_country, p.alt_zip, p.alt_phone ,store.sTitle,store.sDescription,store.sImage FROM class_listings AS p LEFT JOIN class_users AS u ON p.owner = u.id LEFT JOIN class_store AS store ON (p.owner = store.sUserId) WHERE 1=1 AND p.section In () AND p.price BETWEEN 0 AND 99999999999 AND p.expiration > NOW() AND p.display = "Y" GROUP BY p.id, p.owner, p.title, p.featured, p.section, p.description, p.dateadded, p.expiration, p.alt_state, p.alt_city, p.alt_country ORDER BY dateadded desc in /usr/home/deb19947/domains/damiun.nl/public_html/includes/classes/database/mysql.php on line 143

And "$options['section']=$sec;" isnt in the category file anymore

[seymourjames +]

Go here : this is where I tied it together and updated with the release of 4.1.6. You do not use $sec in the template file. It is now $categoryid for version 4.1.6 .

Enhancing browse pages with listings

If you are running version 4.1.X but below 4.1.6 then it will work if you follow the instructions. And "$options['section']=$sec;" is in the code at line 95.

When you say it does not work it helps often to say what you actually did.