Soft Deleted Archive v2.7

Soft Deleted Archive v2.7

If you have a forum where you disallow your Moderators to Hard Delete posts, you might want to look over exactly what posts they have deleted, in case of disputes between staff and members. But running a huge forum with hundreds of threads, this task can get tiring.
This is where the Soft Deleted Archive comes in handy!

Features:

• Seperate threads and posts
• Name and link to forum of the thread/post
• Username that posted the post
• Username that deleted the post
• Reason for deletion, if any were inputted
• Date of thread/post deletion
• For threads, link that takes you directly to the thread in question
• For posts, link that takes you directly to the post in question, for manual managing
• Limit the number of total entries to show per page
• Ability to choose Sorting Order (Ascending or Descending)
• Flagging Threads and Posts seperately
• Fully phrased
• Ability to Hard Delete selected threads/posts
• Ability to Restore selected threads/posts

Screenshots attached.
They are abit outdated, but they present the gist of the hack.

If you use this mod,

Click it!

[mtha]

Originally Posted by Revan

About that bug, I havnt really tried it. Do you mean if you hard delete a thread through this hack or vB itself?

Sug #1: This Ill do tomorrow. 4.30 AM here XD
Sug #2: Not poss as I am using vB internal JScript (I know no JS myself), and it checks all the elements in a form.

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
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

[mtha]

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

[Revan]

I will check it out later

[Blam Forumz]

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

anyway nice hack thanks

[Revan]

XD which part of the middle section of my sig didnt you understand

EDIT:

Originally Posted by mtha

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

Yes, I can confirm. I am posting a reply in this bug report as soon as I posted this

[mtha]

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

[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..?

[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%';

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)

Sort ASC by deldate:

Look for (2 places
LIMIT " . (($page - 1) * $perpage) . ", $perpage

Add after:
ORDER BY `deldate` ASC

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

[teksigns]

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

[Revan]

Originally Posted by mtha

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)

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

Originally Posted by mtha

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

Ill add this

Originally Posted by teksigns

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

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

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