Quote:
Originally Posted by Revan
XD which part of the middle section of my sig didnt you understand
EDIT:
Yes, I can confirm. I am posting a reply in this bug report as soon as I posted this 
|
Cool, the bug was fix by Freddie over vB.com
http://www.vbulletin.com/forum/bugs....iew&bugid=3455
Now you can keep advancing the hack Revan
Bug. When hard deleting a thread, it doesnt come back to the deleted list. can anyone confirm?
If you want to update deldate from moderator log (if available), these two querries could help:
UPDATE deletionlog, moderatorlog SET deletionlog.deldate=moderatorlog.dateline
WHERE deletionlog.type = 'post' AND deletionlog.deldate=0 AND (moderatorlog.postid = deletionlog.primaryid) AND moderatorlog.action LIKE 'post %deleted%';
UPDATE deletionlog, moderatorlog SET deletionlog.deldate=moderatorlog.dateline
WHERE deletionlog.type = 'thread' AND deletionlog.deldate=0 AND (moderatorlog.threadid = deletionlog.primaryid) AND moderatorlog.action LIKE 'thread %deleted%';
Note: if you have prune your moderator log sometime, there will be some date missing in deldate (since you dont have the information in moderatorlog either)
Sort ASC by deldate:
Look for (2 places
LIMIT " . (($page - 1) * $perpage) . ", $perpage
Add after:
ORDER BY `deldate` ASC