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?

thanks much!

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

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.

:D

installed. works great! thanks!

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

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?

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

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

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