furnival
11-30-2010, 10:05 AM
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:
$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 1291123075 at 1291123075 ---------------
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.
$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 1291123075 at 1291123075 ---------------
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.