[furnival]

Hello, I wonder if anyone can help me: someone wrote a custom Joomla module for me which gets the most-recently updated threads from my VBulletin forum and displays them in Joomla. The problem is I have to delete a lot of forum spam, but if I only use "soft delete" these deleted threads still appear in the list of most recently-updated threads, according to the SQL code below:

PHP Code:

$qry = "select * from my_DB_thread order by lastpost Desc limit $count"; 


Is there any way I can alter this SQL code to exclude soft deleted threads please? (I don't want to have to ask my moderators to "hard delete" posts as it could lead to problems.)

Thanks for any help anyone can give on this. I am running VB 3.8.x.

--------------- Added [DATE]1291123075[/DATE] at [TIME]1291123075[/TIME] ---------------

Sorry this was easy. I should have checked the DB table structure. I just added
WHERE visible='1'
to my SQL query.
Please consider this thread closed. Thanks.