They should probably get the same expiration option that thread redirects now receive.
How to rotate out Soft Deletes?
Collapse
X
-
-
There is no such option that I can see.
You can prune soft deleted posts by username if you use the Prune by Username option, but I see no option to delete all soft deleted posts.Comment
-
I love vbulletin and all..I would just love to know how come something so substancial like this still hasnt been implemented.Comment
-
Comment
-
Comment
-
VB mark the deleted post in deletionlog table BUT the post it self still exist in post table so:
PHP Code:[DELETE FROM post WHERE postid IN (select primaryid from deletionlog where type = 'post')
PHP Code:DELETE FROM attachment WHERE postid IN (select primaryid from deletionlog where type = 'post')
PHP Code:DELETE FROM deletionlog WHERE type = 'post'
Last edited by Alawadat; Sat 16 Sep '06, 5:26am.Comment
-
PHP Code:[DELETE FROM post WHERE postid IN (select primaryid from deletionlog where type = 'post')
PHP Code:DELETE FROM attachment WHERE postid IN (select primaryid from deletionlog where type = 'post')
PHP Code:DELETE FROM deletionlog WHERE type = 'post'
ThanksComment
-
Yes.Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
Change CKEditor Colors to Match Style (for 4.1.4 and above)
Steve Machol Photography
Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.
Comment
-
I ask: is in vb4 a real solution for this issue? How to do it?
Running querys is a dangerous thing when you don't know what are you doing.Comment
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Comment