[Revan]

Originally Posted by mtha

Bug. When hard deleting a thread, it doesnt come back to the deleted list. can anyone confirm?

Ill look into this in a few.

Originally Posted by mtha

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

Im alittle confused... Whats the usage of this..?