Quote:
Originally Posted by klaush
Hi Zach; we need to exclude one or two categories.
Possible?
Thanks!
|
Edit the file:
- forums/modules/vbg_comments.php
Add Bold:
Code:
$getposts = $db->query("
SELECT posts.title, posts.userid, posts.username, posts.dateline, posts.pagetext, posts.imageid, posts.visible, posts.allowsmilie, posts.iconid, posts.showsignature, posts.ipaddress, images.userid as imageuserid, images.filename,images.extension, images.height, images.width, images.thumbname
FROM " . TABLE_PREFIX . "adv_gallery_posts as posts
LEFT JOIN " . TABLE_PREFIX . "adv_gallery_images AS images ON (images.imageid = posts.imageid)
WHERE images.catid NOT IN (6,7,8,9)
ORDER BY dateline DESC
LIMIT " . $vba_options[comments_block_count]
);
In the EX: I used ID's: 6,7,8,9