The Arcive of Official vBulletin Modifications Site.

Soft Deleted Archive v2.7 · **Released**: 10-21-2004

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!

Revan · #52 11-01-2004, 04:38 PM

Try running it several times?
Lol only thing I can think of

Oblivion Knight · #53 11-01-2004, 04:51 PM

That query won't work on the other 3 because they weren't deleted by a moderator, so there's no record of them in the moderatorlog.. Is there any other way to get the timestamp?

mtha · #54 11-01-2004, 07:12 PM

Quote:

Originally Posted by Oblivion Knight

That query won't work on the other 3 because they weren't deleted by a moderator, so there's no record of them in the moderatorlog.. Is there any other way to get the timestamp?

.. or your moderatorlog was pruned sometime before.

hehe, yes. Ask those who deleted it, when he/she did delete the post/thread and fill them in.

If you make up some number, it wouldnt be different from 00:00, 1st Jan 1970 right?

I dont know if there's any other place that record this timestamp, so for my forum, I just ... let it be, or try to ... hard delete them if they are worth to be deleted.

if you can find the place where this deletion time recorded, let me know

mtha · #55 11-01-2004, 07:14 PM

Quote:

Originally Posted by Revan

Ive implemented both fixes, and they work just fine.
Cheers

Updated to v2.5:
To upgrade, replace softdeladmin.php with the one in the zip.

I'd think that you should state what's new/fix for each version, easier to keep track of hack

Revan · #56 11-02-2004, 05:09 AM

Hm okay lol

Fixes/Features for v2.5:

Fixed calculation of pages
Fixed calculation of threads/posts
Fixed broken redirect when hard deleting records
Added Posted By in the record view

I think thats about it

And @ the missing timestamps: Unless they are posts/threads that you want sticking around for usage as evidence against spammers, why not just remove them and be done with it

mtha · #57 11-02-2004, 02:18 PM

Quote:

Originally Posted by Revan

And @ the missing timestamps: Unless they are posts/threads that you want sticking around for usage as evidence against spammers, why not just remove them and be done with it

I have about 1000 softdeleted post timestamps missing

. it'll take sometime to check and hard delete all of them

anyway, if post's owner want to delete a post, there's no reason for not delete them (unless it contains valuable information that you want to keep).

msimplay · #58 11-02-2004, 05:50 PM

PHP Code:


			
open includes/functions_databuild
 _____________________________
 
 Find (around line 401-407):
 -----------------------------
 
             $DB_site->query("
                 REPLACE INTO " . TABLE_PREFIX . "deletionlog
                 (primaryid, type, userid, username, reason)
                 VALUES
                 ($postinfo[postid], 'post', $delinfo[userid], '" . addslashes($delinfo['username']) . "',
                 '" . addslashes(fetch_censored_text(htmlspecialchars_uni($delinfo['reason']))) . "')
             ");
 
 
 Replace with:
 -----------------------------
 
             $DB_site->query("
                 REPLACE INTO " . TABLE_PREFIX . "deletionlog
                 (primaryid, type, userid, username, reason, deldate)
                 VALUES
                 ($postinfo[postid], 'post', $delinfo[userid], '" . addslashes($delinfo['username']) . "',
                 '" . addslashes(fetch_censored_text(htmlspecialchars_uni($delinfo['reason']))) . "', '" . TIMENOW . "')
             ");
 
 
 
 Find (around line 295-301):
 -----------------------------
 
             $DB_site->query("
                 REPLACE INTO " . TABLE_PREFIX . "deletionlog
                 (primaryid, type, userid, username, reason)
                 VALUES
                 ($threadinfo[threadid], 'thread', $delinfo[userid], '" . addslashes($delinfo['username']) . "',
                  '" . addslashes(htmlspecialchars_uni(fetch_censored_text($delinfo['reason']))) . "')
             ");
 
 
 Replace with:
 -----------------------------
 
             $DB_site->query("
                 REPLACE INTO " . TABLE_PREFIX . "deletionlog
                 (primaryid, type, userid, username, reason, deldate)
                 VALUES
                 ($threadinfo[threadid], 'thread', $delinfo[userid], '" . addslashes($delinfo['username']) . "',
                  '" . addslashes(htmlspecialchars_uni(fetch_censored_text($delinfo['reason']))) . "', '" . TIMENOW . "')
             ");

just wanted to know if those file edits are absolutely neccessary as the hack seemed to work well even without those
the reason i know is because i had some trouble with my functions_databuild.php and i didn't do the file edits until i realised that they were meant to be there for this hack

Revan · #59 11-02-2004, 07:41 PM

If you do not perform that edit, the date stamp of the deleted posts/threads will appear as "00:00, 1st Jan 1970" (in whatever default date format you have).
So if you dont care much for when they are deleted, and you wouldnt use the sorting feature anyways, then its not needed

msimplay · #60 11-02-2004, 07:57 PM

Quote:

Originally Posted by Revan

If you do not perform that edit, the date stamp of the deleted posts/threads will appear as "00:00, 1st Jan 1970" (in whatever default date format you have).
So if you dont care much for when they are deleted, and you wouldnt use the sorting feature anyways, then its not needed

hmm i'm using version 3.0 and i didn't have to do those edits for the right time

Revan · #61 11-03-2004, 01:29 PM

I am referring to future records

If they dont get a date inserted, how will the script know what date they were deleted, hm?

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04505 seconds Memory Usage 2,336KB Queries Executed 26 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)bbcode_php (4)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!