Try this link.... and ya dont have to search every user lol
http://www.bashys-place.com/forums/m...s&type=deleted

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?

yes because of 3.6.1

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

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.

Will this work with 3.60?

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

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....s&type=deleted

damn .....you are right.......when did they add this??

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

thanks again