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 · #12 10-22-2004, 10:52 PM

Ill get to work on adding the requested features tomorrow

About the limit, currently there's no limit, but I suppose I should add one lol. Thats gonna be a bish to test out tho, havnt got Inline Mod Tools installed on localhost

Remi · #13 10-23-2004, 01:26 AM

very useful hack

Thanks

Logikos · #14 10-23-2004, 03:00 AM

Nice work man

Revan · #15 10-23-2004, 11:34 AM

v2 has been released, I fulfilled the feature requests of mtha.
The following features was added to the mod:

Name and link to forum of the thread/post
Reason for deletion, if any were inputted
Date of thread/post deletion
Limit the number of total entries to show per page

To upgrade, simply download the upgrade zip and follow the instructions there.
This zip will be deleted in 1 week, after that you will have to redo the file edits as described in the main zip readme.

Also, if you use this mod,

Click it!

mtha · #16 10-23-2004, 03:28 PM

that's GREAT! Thank you very much.

you may want to consider adding a phrase "del_deleted_by" for Name?

Oblivion Knight · #17 10-23-2004, 04:11 PM

Thanks for the update, running smooth..

mtha · #18 10-23-2004, 09:37 PM

In your file,

Code:

  	$softdelposts = $DB_site->query("
  		SELECT 
  			deletionlog.*,
  			deletionlog.primaryid AS postid, 
 		deletionlog.type AS deltype,			
  			deletionlog.userid AS userid, 
  			post.*,
  			post.title AS posttitle,
  			post.threadid AS threadid,
  			thread.*,
  			thread.title AS threadtitle,
  			thread.forumid AS forumid,
  			forum.*,
  			forum.title AS forumtitle,

post.* also has the userid value, this will take over the deletionlog.userid I would bring that line deletionlog.userid AS userid to the end of serquence, and put a link to deletor's profile:

In thread section
". $vbphrase['soft_deleted_by'].": <a href='" . $vboptions['bburl'] . "/member.php?u=". $thread['userid'] . "' target='_blank'>" . stripslashes($thread['username']) . "</a> 

In Post section
". $vbphrase['soft_deleted_by'].": <a href='" . $vboptions['bburl'] . "/member.php?u=". $post['userid'] . "' target='_blank'>" . stripslashes($post['username']) . "</a> 

PS. I added a phrase called soft_deleted_by as GLOBAL with the text: Deleted by (instead of using "NAME" phrase).

adding
print_table_break();

on top of
print_table_header($vbphrase['soft_deleted_posts']);

would also seperate two sections.

also, showing the total of soft deleted posts/threads (and/or the current number of thread) would be nice

something like

Soft Deleted Threads (showing thread 16 to 30 in total of 82 threads)
Soft Deleted Posts (showing post 16 to 30 in total of 511 posts)

here's the code:

Look for:
$countlog = $DB_site->query_first("SELECT COUNT(*) AS total FROM " . TABLE_PREFIX . "deletionlog");
Add after

PHP Code:


			
    $countthreads = $DB_site->query_first("SELECT COUNT(*) AS total    FROM " . TABLE_PREFIX . "deletionlog WHERE type = 'thread'");
    $countposts = $DB_site->query_first("SELECT COUNT(*) AS total    FROM " . TABLE_PREFIX . "deletionlog WHERE type = 'post'");

Look for (the first one)

print_table_header($vbphrase['soft_deleted_threads']);
while ($thread = $DB_site->fetch_array($softdelthreads))

Replace by

print_table_header("$vbphrase[soft_deleted_threads] (Total: $countthreads[total] threads)");
while ($thread = $DB_site->fetch_array($softdelthreads))

Look for

print_table_header($vbphrase['soft_deleted_posts]);
while ($post = $DB_site->fetch_array($softdelposts))

replace by

print_table_header("$vbphrase[soft_deleted_posts] (Total: $countposts[total] posts)");
while ($post = $DB_site->fetch_array($softdelposts))

Revan · #19 10-23-2004, 11:48 PM

Quote:

Originally Posted by mtha

In your file,

Code:

  	$softdelposts = $DB_site->query("
  		SELECT 
  			deletionlog.*,
  			deletionlog.primaryid AS postid, 
 		deletionlog.type AS deltype,			
  			deletionlog.userid AS userid, 
  			post.*,
  			post.title AS posttitle,
  			post.threadid AS threadid,
  			thread.*,
  			thread.title AS threadtitle,
  			thread.forumid AS forumid,
  			forum.*,
  			forum.title AS forumtitle,

post.* also has the userid value, this will take over the deletionlog.userid I would bring that line deletionlog.userid AS userid to the end of serquence, and put a link to deletor's profile:

In thread section
". $vbphrase['soft_deleted_by'].": <a href='" . $vboptions['bburl'] . "/member.php?u=". $thread['userid'] . "' target='_blank'>" . stripslashes($thread['username']) . "</a> 

In Post section
". $vbphrase['soft_deleted_by'].": <a href='" . $vboptions['bburl'] . "/member.php?u=". $post['userid'] . "' target='_blank'>" . stripslashes($post['username']) . "</a> 

PS. I added a phrase called soft_deleted_by as GLOBAL with the text: Deleted by (instead of using "NAME" phrase).

adding
print_table_break();

on top of
print_table_header($vbphrase['soft_deleted_posts']);

would also seperate two sections.

also, showing the total of soft deleted posts/threads (and/or the current number of thread) would be nice

something like

Soft Deleted Threads (showing thread 16 to 30 in total of 82 threads)
Soft Deleted Posts (showing post 16 to 30 in total of 511 posts)

here's the code:

Look for:
$countlog = $DB_site->query_first("SELECT COUNT(*) AS total FROM " . TABLE_PREFIX . "deletionlog");
Add after

PHP Code:


			
    $countthreads = $DB_site->query_first("SELECT COUNT(*) AS total    FROM " . TABLE_PREFIX . "deletionlog WHERE type = 'thread'");

    $countposts = $DB_site->query_first("SELECT COUNT(*) AS total    FROM " . TABLE_PREFIX . "deletionlog WHERE type = 'post'");

Look for (the first one)

print_table_header($vbphrase['soft_deleted_threads']);
while ($thread = $DB_site->fetch_array($softdelthreads))

Replace by

print_table_header("$vbphrase[soft_deleted_threads] (Total: $countthreads[total] threads)");
while ($thread = $DB_site->fetch_array($softdelthreads))

Look for

print_table_header($vbphrase['soft_deleted_posts]);
while ($post = $DB_site->fetch_array($softdelposts))

replace by

print_table_header("$vbphrase[soft_deleted_posts] (Total: $countposts[total] posts)");
while ($post = $DB_site->fetch_array($softdelposts))

About the post.*, when I tested it on localhost it always showed the mod name that deleted it, regardless of who the post belonged to.

I am implementing your changes on localhost now, and gonna see if theres a way to optimise it some (I always try my best to keep my query count to an all time low). Thanks alot for your suggestions

Users like you, that are able to come up with simple yet very useful suggestions (even writing them

), is what makes hacks great and hack authors happy

//peace

mtha · #20 10-24-2004, 01:03 AM

Bug ... (that might come out from original version of vB)

If you has a "soft deleted thread" containing some "soft deleted posts"

If you "Hard delete" the thread, the co-responding "soft deleted posts" will be undefined ($post['postid'] will not exists, only $post['primaryid'] exists)

Check that out, and it might be a bug in vB.com too. I dont know if it is, or if it has beed reported over there.

Additional suggestion.

01: This migh not be functionally important, but has "management" cleaner.

Giving the option to manage the thread and post seperately.

Says if you have

/forum/admincp/softdeladmin.php?type=thread, it will only process the deleted threads

/forum/admincp/softdeladmin.php?type=post, it will only process the deleted posts

if no value given, do both (like what you already have)

02: CHECK ALL option. Can you make it to check all thread and check all post seperately?

03. Thread Name/Moderator Name/Thread Link phrase should be changed

I dont think you need that phrase at all.

... development ...
I just check the moderatorlog table, and dateline information for any moderating action is recored in there (with postid and threadid if applicable).
However, for one post, there could be many record in the log, including editing, moving, deleting/undeleting many times. So I expect (guess) the latest date record for one post should be the deletion time
... well but this will introduce few more searching, sorting ... queries ...

dont know if we should use this one or just use a new date record, for convenient

(just look that back because the new deldate is only applicable for posts/threads that are deleted after this hack installed. ... or we should just update the value from moderatorlog to deletionlog ONCE)

we can also sort them by date (asc or des - dont even need to have deldate value) so all recent deletion log displayed first.

just ideas, I dont know if all of them are useful

Revan · #21 10-24-2004, 01:37 AM

Quote:

Originally Posted by mtha

Bug ... (that might come out from original version of vB)

If you has a "soft deleted thread" containing some "soft deleted posts"

If you "Hard delete" the thread, the co-responding "soft deleted posts" will be undefined ($post['postid'] will not exists, only $post['primaryid'] exists)

Check that out, and it might be a bug in vB.com too. I dont know if it is, or if it has beed reported over there.

Additional suggestion.

01: This migh not be functionally important, but has "management" cleaner.

Giving the option to manage the thread and post seperately.

Says if you have

/forum/admincp/softdeladmin.php?type=thread, it will only process the deleted threads

/forum/admincp/softdeladmin.php?type=post, it will only process the deleted posts

if no value given, do both (like what you already have)

02: CHECK ALL option. Can you make it to check all thread and check all post seperately?

03. Thread Name/Moderator Name/Thread Link phrase should be changed

I dont think you need that phrase at all.

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.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05537 seconds Memory Usage 2,331KB 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 (2)bbcode_code (2)bbcode_php (2)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 (3)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!