PDA

View Full Version : Soft Deleted Archive


Revan
06-21-2005, 10:00 PM
Soft Deleted Archive v3.2

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
NO Code Modifications needed!
More efficient forum counter rebuilding.


Screenshots attached.

Install instructions:

Click install (you want your precious support, don't you?).
Upload the files.
Import the Product XML file through your ACP.
Enjoy.


Additional Credits:

The revised cpnav_softdel.xml is thanks to Oblivion Knight.
The product-soft_deleted_archive.xml is thanks to mtha.



If you use this mod,
https://vborg.vbsupport.ru/ (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=90840)
Click it!

Dan
06-22-2005, 09:13 PM
Nice one Revan :D

* Dan clicks install

Chris M
06-22-2005, 09:17 PM
Nice Idea :)

Satan

Martin
06-22-2005, 09:18 PM
Looks possibly useful.

I was thinking about something like this last night, but more in terms of the Reported Post plugin. When a thread is deleted, it gets move to a specified forum. When a post gets deleted, it gets moved to the same forum, starting a new thread.

bigcurt
06-22-2005, 10:05 PM
Umm, any chance of release for 3.0.7 :).

Brad
06-22-2005, 10:19 PM
Nice Revan, I will use this :)

tamarian
06-22-2005, 11:21 PM
Clicks install.

This really should come standard in vB :)

Christine
06-23-2005, 01:01 AM
Awesome!!

I have over 500 soft-deleted posts on my board that I have been too lazy with my current hack to open individually to review/remove. This will be a gem when I go to 3.5 on my live site so that I can get rid of them all.

Installs with MUCH thanks. :)

Revan
06-23-2005, 08:27 AM
Umm, any chance of release for 3.0.7 :).Click me (https://vborg.vbsupport.ru/showthread.php?t=70878) ;)
You didn't think I named it 3.0 in an attempt to keep up with vB versions now did you ;)

And thanks for the nice comments guys and girls, it's really appreciated :)

bigcurt
06-23-2005, 10:32 AM
Have I said I loved you yet? 0_o....just to let you know :).

Revan
06-23-2005, 10:54 AM
Haha. Sorry mate, but my heart belongs to another <3 (and yes, she's a girl XD)
;)

Chris M
06-23-2005, 11:03 AM
It's not nice to call Brad a girl ;):p

Satan

Marco van Herwaarden
06-23-2005, 11:37 AM
It's not nice to call Brad a girl ;):p

SatanNope, that would be an insult to all women. :D

Chris M
06-23-2005, 02:54 PM
Nope, that would be an insult to all women. :D
ROFL :D

Well only attractive women ;) The ugly ones might even be flattered LOL :p

Satan

uae
06-30-2005, 05:04 PM
Perfect

Installed ...

FleaBag
07-31-2005, 02:33 PM
Would you say this is server intensive? It's timing out for me, no other script on my host does that.

Neal-UK
07-31-2005, 03:46 PM
Perfect

Installed ...

love this idea, installed! You sex sexy man (Just keeping in line with the thread, HONEST!)

Christine
07-31-2005, 04:46 PM
Revan,

I never bothered with my 3.0.7 board as I went live on 3.5 last week, but loaded this up today and got rid of hundreds of these pesky things in one click. Ran flawlessly -- and quickly.

Thanks so much for sharing this! :D

@fleabag -- you may want to try to delete fewer at one pop? If you are deleting threads that have a boatload of posts in them, that will be quite intensive...

Revan
07-31-2005, 05:14 PM
Would you say this is server intensive? It's timing out for me, no other script on my host does that.Well I can assume it will run a few more than 1 query per Post/Thread you delete, because it is updating the forum counters etc for each post. I might blatantly rip the vB function only with the update part stripped for a future version - right now Im on an RPG code roll and I don't want to spoil the moment ;)
You sex sexy man (Just keeping in line with the thread, HONEST!)*ahem* Neal sounds awfully much like a mans name, so Im gonna pretend I didn't see this ;)
Revan,

I never bothered with my 3.0.7 board as I went live on 3.5 last week, but loaded this up today and got rid of hundreds of these pesky things in one click. Ran flawlessly -- and quickly.

Thanks so much for sharing this! :DGlad to hear it's appreciated :)

Wow I cant believe I was actually the first person to think up an useful feature and put it as a hack XD
(unless someone on vB2 did it, I never looked there, I swear :p)

Boofo
07-31-2005, 10:08 PM
Excellent idea! ;)

Boofo
07-31-2005, 10:36 PM
Just an idea. Wouldn't the cpnav option be better suited in the Thread and Posts nav?

Revan
07-31-2005, 11:24 PM
Well ye, but when I made this there was no such thing as the ability to place this inside other navs ;)
Ill update this as I do the above :)

BamaStangGuy
08-03-2005, 03:47 PM
Any way to make the installer a plugin instead?

Revan
08-03-2005, 04:54 PM
You must mean product ;)
And yeah, Ill add that to my todo list :)

BamaStangGuy
08-03-2005, 05:01 PM
Yea Product sorry

Thanks

FlyBoy73
08-04-2005, 10:58 PM
Thank you! Just what we need. :)

FleaBag
08-04-2005, 11:58 PM
vB diagnostics picked solfdeladmin.php up to be a 3.0.3 file - just thought I'd let you know.

Revan
08-05-2005, 07:43 AM
Because of the header comment, no doubt :p
It obviously works in the version it's released under, I just haven't been assed to update the comment :)

FleaBag
08-05-2005, 11:01 AM
I know that, just thought you'd appreciate a reminder - it might scare novice users into deleting the file.

Revan
08-06-2005, 12:17 AM
Hehe you are right, thanks :)
I'll remember to update it when I look back here for the todo list.

FleaBag
08-06-2005, 12:40 AM
Cool... :)

mtha
08-22-2005, 05:55 AM
You must mean product ;)
And yeah, Ill add that to my todo list :)

Hey Revan,

See yo moving fast, hah :)

nice to see this one in 3.5.0

need a hand here? I just go over, and make the product for you :)

have fun


PS. you might need to uninstall old phrases, i'm not sure
this xml only replaces the installer. you still need the other files to be uploaded

Oblivion Knight
08-22-2005, 06:01 AM
Why didn't I see your port sooner? :o

Cheers Revan!

Valter
08-22-2005, 06:02 AM
Nice Extension, thanks.

Installed

BamaStangGuy
08-22-2005, 06:44 AM
Hey Revan,

See yo moving fast, hah :)

nice to see this one in 3.5.0

need a hand here? I just go over, and make the product for you :)

have fun


PS. you might need to uninstall old phrases, i'm not sure

Thanks!

Revan
08-23-2005, 02:46 PM
Hey Revan,

See yo moving fast, hah :)

nice to see this one in 3.5.0

need a hand here? I just go over, and make the product for you :)

have fun


PS. you might need to uninstall old phrases, i'm not sure
this xml only replaces the installer. you still need the other files to be uploadedHaha, Ive been abit swamped lately. Before that, I was just lazy :p
Thanks for this, Ill link to this post in the first post since Im still too swamped/lazy to rebuild the zip :p

mtha
08-24-2005, 01:35 AM
lol. that's too much Revan

Oblivion Knight
09-10-2005, 12:36 PM
If you're using the product xml by mtha, from RC3 onwards you should use the attached cpnav_softdel.xml file instead of the one included in the current zip.

This attaches the cpnav to the product rather than vBulletin itself, something which the Enhanced ACP Navigation modification uses to list the custom cpnavs in their own menu.

Valter
09-30-2005, 02:47 AM
This doesn't work on 3.5 Gold?

Revan
09-30-2005, 05:23 AM
No idea, no reason why it shouldn't... Haven't had time to test it yet.

Valter
09-30-2005, 08:38 PM
I upgraded yesterday to vB 3.5 Final and there is no "Soft Deleted Archive" in AdminCP anymore. Reinstalled hack but nothing's changed. I'll try again later.

mtha
10-01-2005, 05:11 AM
I upgraded yesterday to vB 3.5 Final and there is no "Soft Deleted Archive" in AdminCP anymore. Reinstalled hack but nothing's changed. I'll try again later.

yes it works for vb 350Gold

but, you should use Oblivion Knight cpnav_softdel.xml file there.

revan, why dont you take some time update the hack?

Revan
10-01-2005, 05:30 AM
Yeah, ok, Im gonna do that now.

Edit: There, ya happy now!? :p

mtha
10-01-2005, 06:20 AM
Edit: There, ya happy now!? :p


:ninja: no, NOT YET :nervous: :mad: hehe


I added a few filter to your hack, so it can display only post or thread, or both.

if you want, I can send you the file that I edit :)

Revan
10-01-2005, 07:16 AM
Sure, thanks :)

Valter
10-01-2005, 03:23 PM
Now it works perfect. Thanks for update ;)

FleaBag
10-02-2005, 12:45 AM
Hey Revan, seems the performance tweaking made a difference. The latest version no longer times out for me... It still takes a while to load but hell I aint complaining... It works! Thanks a lot. :)

Revan
10-02-2005, 09:09 AM
Thats great, nice to see it works better :D
How many elements (ie threads/posts) are you managing at a time?

mtha
10-02-2005, 10:08 PM
:ninja: no, NOT YET :nervous: :mad: hehe


I added a few filter to your hack, so it can display only post or thread, or both.

if you want, I can send you the file that I edit :)


try this one :)

eclectica
10-03-2005, 07:13 AM
This is helpful to keep track of all the soft deleted threads and posts. I also uploaded the file softdeladmin.php into the modcp, in addition to the admincp, so that the moderators would be able to view all soft deleted threads and posts on the forum as well.

The "flag" button seems to have the same function as "undelete" so I'm not sure what its purpose is.

I think the text Here, you can view an index of all the posts/threads that you or your moderators have "Soft Deleted". should be changed to Here, you can view an index of all the posts/threads that have been "Soft Deleted". because it also includes soft deleted posts by regular members.

Revan
10-03-2005, 08:28 AM
try this one :)Thanks, Ill look that over ASAP :)
I am unable to test this new archive due to a SQL error in vBulletin 3.5.0 which is preventing me from deleting posts. I will check it out when I am provided with a fix.
This is helpful to keep track of all the soft deleted threads and posts. I also uploaded the file softdeladmin.php into the modcp, in addition to the admincp, so that the moderators would be able to view all soft deleted threads and posts on the forum as well.Good idea, I didn't do this by default because on my forums, I dislike the idea of my moderators Hard Deleting anything. And what with there being no ways of limiting SMod permissions yet...
The "flag" button seems to have the same function as "undelete" so I'm not sure what its purpose is.I can't remember there being a "Flag" button, but I will test it out when I can test out the new softdeladmin.php from the above post.
I think the text Here, you can view an index of all the posts/threads that you or your moderators have "Soft Deleted". should be changed to Here, you can view an index of all the posts/threads that have been "Soft Deleted". because it also includes soft deleted posts by regular members.Agreed, Im changing this in the product XML now. Thanks for pointing this out :)

eclectica
10-03-2005, 08:59 AM
I see now that the flag button is used in conjunction with the other buttons, to either hard delete or to undelete. I was confused by the terminology when I first saw it. I also noticed that if the flag button is checked by itself with neither hard delete or undelete selected, it choses undelete by default so that when submitted, the flagged post is undeleted.

eclectica
10-05-2005, 08:07 AM
I just discovered that uploading the file softdeladmin.php into the modcp does not make the file work for moderators due to lack of admin permissions, though it still works for administrators in that folder.

Snake
10-06-2005, 02:25 PM
Can I have more screenshots please?

Revan
10-06-2005, 02:40 PM
I just discovered that uploading the file softdeladmin.php into the modcp does not make the file work for moderators due to lack of admin permissions, though it still works for administrators in that folder.Im pretty sure you could just remove the whole permissions check and make it work, though that would make it work for EVERY moderator, not just select ones.

Im gonna look over that new file and update this asap, just need to finish a paid job first.

Parker Clack
10-09-2005, 12:07 PM
When trying to import the cpnav_softdel.xml file I get a "Invalid File Specified" Error.

Any ideas?

Thanks,
Parker

Revan
10-10-2005, 09:14 AM
You aren't supposed to import that.
Just upload it like the folder structure suggests.

darcon
10-10-2005, 05:22 PM
/me installs on 3.5 gold
so much easier for mods to softdelete instead of moving threads to a trash forum

krg2k
11-22-2005, 10:50 PM
awesome one

telc
12-04-2005, 11:45 PM
Will this retain users posts counts the same way if you mass prune threads, in the admincp it retains users posts counts?

eclectica
12-13-2005, 10:44 AM
You can get this to work for your super moderators as well. Here is how you do it. After installing it on the board, you edit the file softdeladmin.php. Find the following and delete it:

// ######################## CHECK ADMIN PERMISSIONS #######################
if (!can_administer('canadminthreads'))
{
print_cp_no_permission();
}

Then save the file and upload it into the forum/modcp directory.

tommyxv
01-14-2006, 05:26 AM
Will this retain users posts counts the same way if you mass prune threads, in the admincp it retains users posts counts?


Good question! Can anyone answer this?

gonon
01-15-2006, 12:33 PM
After installing was amazed to see how many soft-deleted threads and posts we had....

Thanks for the product!

Megareus Rex
01-21-2006, 10:59 PM
Excellent. Loved it in 3.0, and now I have it in 3.5.

*installed*

webwheeling
02-01-2006, 04:28 AM
You can get this to work for your super moderators as well. Here is how you do it. After installing it on the board, you edit the file softdeladmin.php. Find the following and delete it:



Then save the file and upload it into the forum/modcp directory.

I did that and I don't see the Soft Deleted Archive menu in the modcp. Is there something else that needs to be done for that to appear?

username12
04-22-2006, 04:45 PM
I was just looking at some deleted posts that really should have just been moved to appropriate forums, which led me to wonder how often this happens.

*installs*

MThornback
04-25-2006, 02:39 AM
Is anyone having a problem with this interfereing with images displaying? I think its conflicting with something I installed cause as soon as I disabled it all works fine again?

lucky64
04-27-2006, 12:11 AM
Works great, thanks :)

Maybe a new feature.....ability to search by post content, thread name, soft deleter (mod/super/admin) or the creater perhaps?

eclectica
05-02-2006, 01:14 PM
I did that and I don't see the Soft Deleted Archive menu in the modcp. Is there something else that needs to be done for that to appear?

Oops, I just read your question now. Yes, something else has to be done in order to put a visible link in the moderator control panel, but that is beyond my abilities. Despite that you could just provide a list of useful links for your moderators to use or to bookmark, of which one would be /forum/modcp/softdeladmin.php.

FleaBag
05-08-2006, 11:15 AM
Moved host and this is finally working like a dream for me on 3.5.4. Must have been the old hardware at fault. Thanks for a very useful hack Revan! :)

RaZor Edge
05-15-2006, 05:38 PM
This is a really useful hack! Works great on 3.5.4. Thanks!

eclectica
06-13-2006, 08:56 PM
This doesn't work for version 3.6 beta 2, so I'm uninstalling it.

Dan
06-13-2006, 09:15 PM
This doesn't work for version 3.6 beta 2, so I'm uninstalling it.
Didn't they build this into 3.6?

eclectica
06-14-2006, 08:06 AM
Didn't they build this into 3.6?

Well I don't see it anywhere, unless I'm missing something.

Revan
06-14-2006, 08:46 PM
Check your UserCP.

eclectica
06-15-2006, 01:24 AM
Thanks, I found it.

NeutralizeR
07-13-2006, 02:58 PM
Check your UserCP.
Can you please update your hack to work with vBulletin 3.6 ?

http://www.vbulletin.com/forum/showthread.php?p=1159366#post1159366

NeutralizeR
07-17-2006, 06:26 PM
Finally, i've found a way by myself...

How to mass select all of the soft deleted posts listed under User CP?

Open your Admin CP > Styles & Templates > Moderation Templates > moderation_posts template:

Find:
$totalposts (the first one)

Add right after $totalposts:
<input type="checkbox" name="allbox" id="checkall_all" title="$vbphrase[check_uncheck_all]" onclick="inlineMod.check_all()" />
By default, only 4 soft deleted posts listed under User CP moderation menu.

How do list X soft deleted posts under User CP moderation menu?

Open your /forum/moderation.php file with your text editor.

Find:
sanitize_pageresults($totalposts, $pagenumber, $perpage, 200, 4);
Change '4' with 'X'... I've changed mine to '100' because of the massive soft deleted posts amount...

Save and upload the edited moderation.php file.

(You may want to revert 100 to 4 after you remove all soft deleted posts)

Hornstar
07-17-2006, 11:14 PM
I suppose this will make it way easier to finally manage the soft deleted posts and now hard delete them if they are useless etc.

Any word when this will be compaitible with 3.6?

telc
07-18-2006, 11:45 AM
This should be a standard feature in the VB prune.

CypherSTL
08-01-2006, 07:21 AM
Posiable for this to be ported to 3.6 (RC3 or gold)?

I have it on my 3.5.4 board and going to be upgradeing to 3.6 here as soon as gold is released and still want to keep it.

manutdvn
08-03-2006, 05:23 AM
Thank you. Great work. No proplem with 3.5.4. Installed!

Revan
08-05-2006, 02:42 PM
Posiable for this to be ported to 3.6 (RC3 or gold)?

I have it on my 3.5.4 board and going to be upgradeing to 3.6 here as soon as gold is released and still want to keep it.This is a stock feature in 3.6, you will find it in your UserCP.

CypherSTL
08-27-2006, 10:59 PM
A Soft Deleted Archive stock in 3.6.0? I don't think so, if it is there is no way to access it. There is currently no way to see what has been soft deleted in the admincp and chhose wether or not to keep them or hard delete them.

DarkHalo
09-05-2006, 04:10 AM
Installed on 3.5.4 smooth as can be. This will be very helpful, thank you.

*clicked installed*

bairy
09-05-2006, 11:36 AM
A Soft Deleted Archive stock in 3.6.0? I don't think so, if it is there is no way to access it. There is currently no way to see what has been soft deleted in the admincp and chhose wether or not to keep them or hard delete them.
It's in the UserCP (usercp.php). Check the links about 2/3rds down the left hand side.
Bugger knows why they didn't put a copy in the AdminCP but still, it's there.

CypherSTL
09-10-2006, 06:35 AM
There is no option to do anything with post you have soft deleted in the userscp, not sure what you have installed that would show that but it is not in my stock version of 3.6.0.

NeutralizeR
09-10-2006, 07:07 AM
There is no option to do anything with post you have soft deleted in the userscp, not sure what you have installed that would show that but it is not in my stock version of 3.6.0.
Yes, there is.

Under User Control Panel > on the left menu > under Subscribed Threads >

Moderation:

Deleted Threads
Deleted Posts
Moderated Threads
Moderated Posts

If you want to extend it's usage:
https://vborg.vbsupport.ru/showpost.php?p=1032344&postcount=78

bairy
09-10-2006, 07:42 AM
If it's still not there you might need to revert the usercp_shell template.

Good tips NeutralizeR, they really ought to have included a tick all and per page selector.. hopefully in 3.6.1

CypherSTL
09-14-2006, 04:40 AM
Ok first off I dont feel like looking at every single user to see if there are post of theres that where soft deleted and hard delete them, and there has been nothing done with my usercp that would require a revert. It only shows post/threads that I have subscribed to, not that others are subscribed to and have been deleted.

second I would like the option to be in the AdminCP where it is ALL in one place...just like it is in 3.5.4

bashy
09-14-2006, 06:00 PM
Try this link.... and ya dont have to search every user lol
http://www.bashys-place.com/forums/moderation.php?do=viewthreads&type=deleted

There is no option to do anything with post you have soft deleted in the userscp, not sure what you have installed that would show that but it is not in my stock version of 3.6.0.

sebbo
09-19-2006, 08:12 PM
Hi,
I keep getting this error:

Database error in vBulletin 3.6.1:

Invalid SQL:

SELECT
deletionlog.*,
deletionlog.primaryid AS postid,
deletionlog.type AS deltype,
deletionlog.userid AS userid,
thread.*,
thread.title AS threadtitle,
thread.forumid AS forumid,
forum.*,
forum.title AS forumtitle,
user.username
FROM deletionlog AS deletionlog
LEFT JOIN user AS user USING(userid)
LEFT JOIN thread AS thread ON thread.threadid = deletionlog.primaryid
LEFT JOIN forum AS forum ON forum.forumid = thread.forumid
WHERE deletionlog.type = 'thread'
ORDER BY `dateline` DESC
LIMIT 0, 15;

MySQL Error : Column 'dateline' in order clause is ambiguous
Error Number : 1052

Is this because I use 3.6.1?

Ugur CETIN
10-01-2006, 07:18 PM
yes because of 3.6.1

is there any new version of this hack? i need this...

freecodevn
10-14-2006, 07:41 PM
Hi,
I keep getting this error:

Database error in vBulletin 3.6.1:

Invalid SQL:

SELECT
deletionlog.*,
deletionlog.primaryid AS postid,
deletionlog.type AS deltype,
deletionlog.userid AS userid,
thread.*,
thread.title AS threadtitle,
thread.forumid AS forumid,
forum.*,
forum.title AS forumtitle,
user.username
FROM deletionlog AS deletionlog
LEFT JOIN user AS user USING(userid)
LEFT JOIN thread AS thread ON thread.threadid = deletionlog.primaryid
LEFT JOIN forum AS forum ON forum.forumid = thread.forumid
WHERE deletionlog.type = 'thread'
ORDER BY `dateline` DESC
LIMIT 0, 15;

MySQL Error : Column 'dateline' in order clause is ambiguous
Error Number : 1052

Is this because I use 3.6.1?

Error:
SELECT
deletionlog.*,
deletionlog.primaryid AS postid,
deletionlog.type AS deltype,
deletionlog.userid AS userid,
thread.*,
thread.title AS threadtitle,
thread.forumid AS forumid,
forum.*,
forum.title AS forumtitle,
user.username
FROM deletionlog AS deletionlog
LEFT JOIN user AS user USING(userid)
LEFT JOIN thread AS thread ON thread.threadid = deletionlog.primaryid
LEFT JOIN forum AS forum ON forum.forumid = thread.forumid
WHERE deletionlog.type = 'thread'
ORDER BY `dateline` DESC
LIMIT 0, 15;
===============
Fix

SELECT
deletionlog.*,
deletionlog.primaryid AS postid,
deletionlog.type AS deltype,
deletionlog.userid AS userid,
post.dateline AS postdateline,
thread.*,
thread.title AS threadtitle,
thread.forumid AS forumid,
forum.*,
forum.title AS forumtitle,
user.username
FROM deletionlog AS deletionlog
LEFT JOIN user AS user USING(userid)
LEFT JOIN post AS post ON post.postid=deletionlog.primaryid
LEFT JOIN thread AS thread ON thread.threadid = deletionlog.primaryid
LEFT JOIN forum AS forum ON forum.forumid = thread.forumid
WHERE deletionlog.type = 'thread'
ORDER BY `dateline` DESC
LIMIT 0, 15;


Im test VBB 3.6.2

Open file softdeladmin.php
Find line:
ORDER BY `dateline` $sqlorder
Replate with:

ORDER BY `primaryid` $sqlorder

Or dele line:

ORDER BY `dateline` $sqlorder

Or dowload attach file.
Done!

Spermy
10-21-2006, 01:11 AM
Error:
SELECT
deletionlog.*,
deletionlog.primaryid AS postid,
deletionlog.type AS deltype,
deletionlog.userid AS userid,
thread.*,
thread.title AS threadtitle,
thread.forumid AS forumid,
forum.*,
forum.title AS forumtitle,
user.username
FROM deletionlog AS deletionlog
LEFT JOIN user AS user USING(userid)
LEFT JOIN thread AS thread ON thread.threadid = deletionlog.primaryid
LEFT JOIN forum AS forum ON forum.forumid = thread.forumid
WHERE deletionlog.type = 'thread'
ORDER BY `dateline` DESC
LIMIT 0, 15;
===============
Fix

SELECT
deletionlog.*,
deletionlog.primaryid AS postid,
deletionlog.type AS deltype,
deletionlog.userid AS userid,
post.dateline AS postdateline,
thread.*,
thread.title AS threadtitle,
thread.forumid AS forumid,
forum.*,
forum.title AS forumtitle,
user.username
FROM deletionlog AS deletionlog
LEFT JOIN user AS user USING(userid)
LEFT JOIN post AS post ON post.postid=deletionlog.primaryid
LEFT JOIN thread AS thread ON thread.threadid = deletionlog.primaryid
LEFT JOIN forum AS forum ON forum.forumid = thread.forumid
WHERE deletionlog.type = 'thread'
ORDER BY `dateline` DESC
LIMIT 0, 15;


Im test VBB 3.6.2

Open file softdeladmin.php
Find line:
ORDER BY `dateline` $sqlorder
Replate with:

ORDER BY `primaryid` $sqlorder

Or dele line:

ORDER BY `dateline` $sqlorder

Or dowload attach file.
Done!

Thank you very much. I missed this.

Calibre_k
10-23-2006, 07:16 PM
Will this work with 3.60?

telc
10-23-2006, 07:27 PM
Will this work with 3.60?


3.6 has something simliar built in, you can search / view / prune soft deleted posts.

stinger2
02-13-2007, 01:07 PM
3.6 has something simliar built in, you can search / view / prune soft deleted posts.
where is that??

you only have an option for soft deleted THREADS BUT not soft deleted POSTS

telc
02-13-2007, 05:43 PM
where is that??

you only have an option for soft deleted THREADS BUT not soft deleted POSTS


3.6 has an option to find and delete all "soft deleted POSTS", They put it in UserCP not AdminCP

User Control Panel -> Moderation -> Deleted posts

http://Yourdomain/forums/moderation.php?do=viewposts&type=deleted

stinger2
02-13-2007, 08:57 PM
damn .....you are right.......when did they add this??

thanks for telling me...........i never look there in normal circumstances....hehe

thanks again

telc
02-13-2007, 09:33 PM
damn .....you are right.......when did they add this??

thanks for telling me...........i never look there in normal circumstances....hehe

thanks again

Im not sure why its not in admincp seems out of place in usercp.

northernstar
02-24-2007, 10:59 PM
I've been looking high and low for this, what a totally bizarre place to stick it in, and not to also include it in the AdminCP. sucks tho that I can select 4 at a time..i've got like 50 pages to click through.

giotmuadong
03-06-2007, 03:30 AM
do you have an update yet?

Forumi Shqiptar
04-08-2007, 05:59 PM
im getting this error in vb 3.6.4

Fatal error: Existing data passed is not an array
Called set_existing in /home/forumi/public_html/includes/functions_databuild.php on line 164
Called build_forum_counters in /home/forumi/public_html/admincp/softdeladmin.php on line 405
in /includes/class_dm.php on line 235

i did everything freecodevn said and it worked than after i deleted about 30 it started giving me this error

giotmuadong
05-24-2007, 09:48 PM
do you have an update? i use 3.6.7 now

3dsoft
06-11-2007, 06:17 AM
Ist there a way to check all soft deleted posts and hard delete them?
I am using vbulletin 3.6.7

serhat_kk
07-16-2007, 04:25 PM
Great hack. Thanks.

giotmuadong
10-12-2007, 10:02 PM
do you have this for VB 3.6 version yet?

Audentio
10-21-2007, 01:14 AM
Is there an update?

logofreax
11-19-2007, 08:46 AM
Hi, I now installed this Hack on my vBulletin 3.6.8 Patch Level 2 with the Version from Post #94 and it show me all soft deleted posts.

But I cannot flag all Posts by mark "Flag Posts"

No mark will be set, so I have to mark all by hand.

Could you please tell me how to fix it?

cu
logofreax

rapidphim
09-23-2008, 07:29 PM
will this hack work on 3.7.3?