I did the hard delete through this hack, and it (after deleting some threads) show up some post that are undeletable (throughj this hack) since there's no postid responding to it (dont need to delete it actually, but the records for soft delete posts in deletionlog are still exist)
I did not try in vB itself, that's why I said I thought it'd be vB bug since you use vB delete_thread and delete_post functions.

Will take some more look at that for you.
=================
update1. bing. I hit the right spot. it's vB bug, not removing post record in deletionlog if its thread is physically removed
... going to check vB bug list :P

update2. bing. actually I did report this in vB but getting no answer :D
http://www.vbulletin.com/forum/showt...=delete+thread
----------------------


about #2, if you can do #1, then #2 will automatically be solved, you just go to manage post (or thread) alone and select all :P


ps. I add some more stuff on the post above.

This hack is very usefull for me.
I attempted to write (actually advance Tigga's hack), but didnt have time to do so. Now you make it real. Thank you very much :)

The bug was reported here. Can you confirm?
http://www.vbulletin.com/forum/bugs....iew&bugid=3455

This bug hit directly to this hack, so I'd think we should urge vB.com to fix :D

I will check it out later :)

Revan! Stop releasing new hacks ¬¬ get back to work on RPG v3

anyway nice hack thanks

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

Ill look into this in a few.



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

These are ONE TIME query, to get dateline information from moderatorlog and put into deldate in deletion log.

Assume that you have whole bunch of posts/threads deleted, and you just add a new field deldate (actually you should name it dateline for vB consistancy). the deldate value for all deleted posts/threads are ZERO.
However, when a moderator/admin delete a post/thread, the action will be record into moderator log (with dateline, and action = Post/Thread XXX Deleted)
The timeline in moderator log IS the time when the mod/admin delete a thread. I can just copy this value and put into deletionlog (if the deldate indeletionlog is missing (=0)



I want to sort the list by deldate, so that all the oldest deleted post are displayed first => I can take a look and hard-delete them first

Small Bug found ....

if i select a few deleted post and i forget to tick one of the radio buttons .....

your script undeletes them instead of giving a error !

can you fix this

You mean I could add these to the installer?

And I cant name it dateline because it interferes with other rows, which causes errors. Believe me I tried ;)




Ill add this :)


Ill take a look at this when I get home, I promise :)

I got abit distracted yest cos I installed RPG Maker XP..... :p