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!

[Megareus Rex]

Great hack, I love it!

Only one question though. The hack displays the post date of all of the deleted threads/posts as Dec 31 1969. Why?

[yoyoyoyo]

thanks much!

[Revan]

Originally Posted by Megareus Rex

Great hack, I love it!

Only one question though. The hack displays the post date of all of the deleted threads/posts as Dec 31 1969. Why?

Because the entries displayed were deleted before the hack started counting Post dates

[Christine]

Added this tonight. I can't wait to get my live site on 3.5 -- I have in the neighborhood of 500 soft-deleted posts that I have been too lazy with my current hack to open each one to review and get rid of.

[mkdevo]

installed. works great! thanks!

[kadafi_alive]

I would warn others to stay away from this hack. Once you attempt to hard-delete soft-deleted posts or threads, it suddenly deletes random posts or threads that weren't soft-deleted in the first place

[Revan]

This is highly impossible, not only because the hack cannot touch threads/posts not in the deletionlog table, but because no other user on the interweb has reported this issue. Does that not strike you as odd?

[kadafi_alive]

Hi Revan

It did after running this code (provided by mtha) to remove the 1970 bug:

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

After that, it randomely started deleting posts and threads. In fact, can someone tell me how to reverse that SQl query 'cause I keep getting database errors now such as:

Invalid SQL:
REPLACE INTO deletionlog
(primaryid, type, userid, username, reason, deldate)
VALUES
(85514, 'post', 193, 'user',
'', '1127836289')

mysql error: Unknown column 'deldate' in 'field list'

mysql error number: 1054

[Revan]

for some reason the deldate column vanished, try running this:
[sql]ALTER TABLE deletionlog ADD deldate INT(10) UNSIGNED NOT NULL DEFAULT '0'[/sql]

[mtha]

well, actually you tried to run the uninstall.php, and DID NOT remove the code that he edited.

please reverse ALL the file editing that mention in install.txt, or upload your original

admincp/index.php
includes/functions_databuild.php
clientscript/vbulletin_global.js

if you dont have any other hack (that require editing those files) installed

Originally Posted by kadafi_alive

Hi,

I haven't edited anything regarding the hack. I only uploaded the softdeladmin.php in admincp and run softdel_install.php. When uninstalling, I ran softdel_uninstall.php and thats it.

Regards