The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Problem with soft delete query
Hello and Greetings,
I found a query: Code:
DELETE FROM " . TABLE_PREFIX . "post WHERE visible = '2' TIA |
#2
|
||||
|
||||
What do you mean "clear it from the thread"? Is it still showing up in the showthread page or do you mean it is still listed as the last post of the thread or ??
|
#3
|
|||
|
|||
Its a test "thread" ... I looked at this thing for hours thinking that it was a "post", oops! Just check the posts that I deleted with the query and they are indeed gone.
Edit: In case this is not clear, if you are trying to get rid of "soft deletes" via a CRON hack, you have to do two queries, one to get rid of the "posts" and another if you want to delete "threads". For example, a member creates a thread, adds a post then figures out its a mistake and deletes it. If you use the query above it only removes the "post". You have to run a second query to remove the soft delete on the thread: Code:
DELETE FROM " . TABLE_PREFIX . "thread WHERE visible = '2' HTH |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|