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!

[Bozkurtum]

Very useful hack

Thanks

[mtha]

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

actually, being able to reverse order back and fort, or choose ASC or DESC when displaying is better. You can either add another link (to reverse order) or have another option to chose sorting direction

[Revan]

v2.2 is released, implementing fixes of the bugs mentioned already, and mtha's feature requests.

To upgrade, simply replace softdeladmin.php with the one in the zip.


Thanks for installing this hack!

[Oblivion Knight]

Updated.. Again.. Thanks

[msimplay]

i have the assign physical delete hack installed and i seem to get errors with this one now


i'm getting error where i can't normally delete a post only physical delete and somehow people can delete there own threads

this is the error i get when i try to delete a post normally

Database error in vBulletin 3.0.0:

Invalid SQL: 
				REPLACE INTO deletionlog
				(primaryid, type, userid, username, reason, deldate)
				VALUES
				(, 'post', 1, 'wAmbAm',
				'', '1099124008')
			
mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near ' 'post', 1, 'wAmbAm',
				'', '1099124008')' at line 4

mysql error number: 1064

Date: Saturday 30th of October 2004 01:13:29 AM
Script: http://www.wambam.net/vbulletin/editpost.php
Referer: http://www.wambam.net/vbulletin/editpost.php?do=editpost&p=4504
Username: wAmbAm
IP Address: 82.37.24.63

can anyone help me
i;ve disabled my forums until i can fix this

[Revan]

I am using both hacks in perfect combination
Your problem is that whatever is assigning the primaryid seems to have broken.

[msimplay]

Originally Posted by Revan

I am using both hacks in perfect combination
Your problem is that whatever is assigning the primaryid seems to have broken.

i repaired the error by using repair tables however its weird that using the none physical delete seems to be now deleting threads

[mtha]

Originally Posted by msimplay

i repaired the error by using repair tables however its weird that using the none physical delete seems to be now deleting threads

Total Entries: 1830

You've messed up with the counting part:
Page1:

Soft Deleted Threads (Showing thread 1 to 14, total: 14 threads)
Soft Deleted Posts (Showing post 1 to 15, total: 15 posts)


Page2
Soft Deleted Posts (Showing post 16 to 1830, total: 15 posts)

Page3:
Soft Deleted Posts (Showing post 31 to 1830, total: 15 posts)


also, here you have

$countlog = $DB_site->query_first("SELECT COUNT(*) AS total FROM " . TABLE_PREFIX . "deletionlog");
$numentries = &$countlog['total'];
$numpages = ceil($numentries / $perpage);


your $countlog is post+thread counts
$perpage is actually post perpage AND thread perpage.

=> $countlog / $perpage is NOT correct $numpages.
You have to get
$countpost and $countthread

if $countpost > $countthread => $numentries = $countpost, else $entries = $countthread

otherwise, if you have more than one page of thread and post deleted, the last pages will give empty results.

[msimplay]

Originally Posted by mtha

Total Entries: 1830

You've messed up with the counting part:
Page1:

Soft Deleted Threads (Showing thread 1 to 14, total: 14 threads)
Soft Deleted Posts (Showing post 1 to 15, total: 15 posts)


Page2
Soft Deleted Posts (Showing post 16 to 1830, total: 15 posts)

Page3:
Soft Deleted Posts (Showing post 31 to 1830, total: 15 posts)


also, here you have

$countlog = $DB_site->query_first("SELECT COUNT(*) AS total FROM " . TABLE_PREFIX . "deletionlog");
$numentries = &$countlog['total'];
$numpages = ceil($numentries / $perpage);


your $countlog is post+thread counts
$perpage is actually post perpage AND thread perpage.

=> $countlog / $perpage is NOT correct $numpages.
You have to get
$countpost and $countthread

if $countpost > $countthread => $numentries = $countpost, else $entries = $countthread

otherwise, if you have more than one page of thread and post deleted, the last pages will give empty results.

hmm dunno i seemed to have fixed it by rehacking my functions_databuild.php
i've left the rest untouched

[mtha]

sorry msimplay, I didnt mean to quote your post. I am talking about the whole hack.

Revan

Here's what I use, I think it'd be better

Look for (Line 114)

PHP Code:

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


Replaced by

PHP Code:

//    $countlog = $DB_site->query_first("SELECT COUNT(*) AS total    FROM " . TABLE_PREFIX . "deletionlog");
 $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'");
     $totalcount = ($countthreads['total'] + $countposts['total']);
  if ($countthreads['total'] > $countposts['total']) {
      $numentries = &$countthreads['total'];
  }
  else $numentries = &$countposts['total']; 


line 171, look for

PHP Code:

         <td class="thead">' . $vbphrase['total_entries'] . ': ' . $numentries . ' 


replaced by

PHP Code:

              <td class="thead">' . $vbphrase['total_entries'] . ': ' . $totalcount . ' 


line 207. look for

PHP Code:

         $threads = $DB_site->query_first("SELECT COUNT(*) AS threads FROM " . TABLE_PREFIX . "deletionlog WHERE `type`='thread'");
              $totalthreads = $threads['threads'];
             $iifcalc = iif($page - 1 == 0, 1, (($page - 1) * $perpage) + 1);
              $threadpage = $totalthreads - $iifcalc;
              $threadpage = $threadpage + $iifcalc;
             $threadpage = iif($page - 1 == 0, $numthreads * $page, $threadpage); 


replaced by

PHP Code:

            $totalthreads = $countthreads['total'];
                      $iifcalc = iif($page - 1 == 0, 1, (($page - 1) * $perpage) + 1);
                      $threadpage = ($iifcalc + $perpage - 1);
                      if ($threadpage > $totalthreads) {$threadpage = $totalthreads;} 


Line 269, look for

PHP Code:

            $totalposts = $numentries - $numthreads;
             $iifcalc = iif($page - 1 == 0, 1, (($page - 1) * $perpage) + 1);
             $postpage = $totalposts - $iifcalc;
             $postpage = $postpage + $iifcalc;
             $postpage = iif($page - 1 == 0, $numposts * $page, $postpage);
             print_table_header("$vbphrase[soft_deleted_posts] (Showing post $iifcalc to $postpage, total: $numposts posts)"); 


replaced by

PHP Code:

            $totalposts = $countposts['total'];
            $iifcalc = iif($page - 1 == 0, 1, (($page - 1) * $perpage) + 1);
 
             $postpage = ($iifcalc + $perpage - 1);
             if ($postpage > $totalposts) {$postpage = $totalposts;}
             print_table_header("$vbphrase[soft_deleted_posts] (Showing post $iifcalc to $postpage, total: $totalposts posts)");