Version: 2.5, by Revan
Developer Last Online: Jun 2014
Version: 3.0.3
Rating:
Released: 10-21-2004
Last Update: 12-04-2004
Installs: 42
DB Changes
No support by the author.
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.
I found that username/userid are displayed not correctly, since you have different values for them. I would call each value seperately:
look for the part for
$softdelposts = $DB_site->query("
replace the whole query by
PHP Code:
$softdelposts = $DB_site->query(" SELECT deletionlog.*, deletionlog.primaryid AS postid, deletionlog.type AS deltype, deletionlog.userid AS userid, post.postid, post.threadid, post.username as postusername, post.userid as postuserid, post.title AS posttitle, post.threadid AS threadid, thread.threadid, thread.forumid, thread.title AS threadtitle, thread.forumid AS forumid, forum.forumid, forum.title AS forumtitle, user.username FROM " . TABLE_PREFIX . "deletionlog AS deletionlog LEFT JOIN " . TABLE_PREFIX . "user AS user on user.userid=deletionlog.userid LEFT JOIN " . TABLE_PREFIX . "post AS post ON post.postid=deletionlog.primaryid LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON thread.threadid=post.threadid LEFT JOIN " . TABLE_PREFIX . "forum AS forum ON forum.forumid=thread.forumid WHERE deletionlog.type = 'post' ORDER BY `deldate` $sqlorder LIMIT " . (($page - 1) * $perpage) . ", $perpage ");
I'd add another line for Posted by, showing thread/post owner too:
Whoah. This was lotta stuff XD
I cant remember, but I dont think I counted the threads and posts in a seperate query. I dont like this because I try my best to optimise my hacks, reducing query load as much as possible.
The counting worked when I tested it with multiple pages on my localhost, but my localhost is running low on posts from too much testing with this hack XD
Im gonna look into all of this when I get home
Whoah. This was lotta stuff XD
I cant remember, but I dont think I counted the threads and posts in a seperate query. I dont like this because I try my best to optimise my hacks, reducing query load as much as possible.
The counting worked when I tested it with multiple pages on my localhost, but my localhost is running low on posts from too much testing with this hack XD
Im gonna look into all of this when I get home
You counted all and counted threads. which use 2 querries.
I count thread and post, which also use 2
Yes, they were deleted BEFORE this hack was installed. Try running this:
Quote:
Originally Posted by mtha
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%';
Soft Deleted Archive v2.7 Details »»
About Developer
Visit Web Site
DB Changes 
No support by the author.
11-01-2004, 12:16 AM
)
