Filter Posts Hack

this is a quick dirty hack, what it does is, ok imagine this it's easier.

you're in a pub and some dude started a mega conversation and people were loving it left right and centre and getting involved but you forsaw this so recorded it, anyway you get home, grab your magic remote and play it back, once you click the filter button it only shows stuff you said, the threadmaster said and the person of your choosing said.

that's what this hack does, you click the button and it filters out all posts and leaves you with your posts, the threadmasters posts and the person of your choosings posts, great for mega long posts.

but wahhhhhh i know you're gonna mention the page numbers, well that be the case i said quick and dirty for a reason, it just won't worth more than 20 minutes

have fun with it, cos now i've written it, i've forgotten which thread on my forums inspired me to actually put in the work

oh and this has only been developed for Linear Mode :ermm: :tired:


Latest File Upload: 21/03/05 13:37

[sabret00the]

reserved post for FAQ stuff like;

does it make coffee? no


oooh and regarding screenies, i'm not sure what i'd be taking a screenshot of so please don't request em

[tehste]

Originally Posted by sabret00the

does it make coffee? no

Gutted!
None the less a nice hack

For an idea... couldnt you temporarily add all the 'background noise' users to the tachy goes to conventry? somehow?

[sabret00the]

Originally Posted by zsdave

Gutted!
None the less a nice hack

For an idea... couldnt you temporarily add all the 'background noise' users to the tachy goes to conventry? somehow?

what does the 'tachy goes to coventry' do to them?

[ericgtr]

Originally Posted by sabret00the

what does the 'tachy goes to coventry' do to them?

I belive It adds all of their posts to all users ignore list, only they don't know it, they see there posts normally. Very cool feature!

[sabret00the]

ok well in that case i'm not sure their be a point as all of their posts totally dissapear once they've been filtered out.

[Lionel]

I tried twice and both times I am getting this

 Database error in vBulletin 3.0.7:
 
Invalid SQL: 
SELECT
post.*, post.username AS postusername, post.ipaddress AS ip,
user.*, userfield.*, usertextfield.*,
icon.title as icontitle, icon.iconpath,
 
 
NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason,
post_parsed.pagetext_html, post_parsed.hasimages,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
 
FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
 
LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND deletionlog.type = 'post')
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid)
WHERE post.postid IN (0,20565,20568,20575,20577,20581,20586,20587,20590,20621,20623) AND post.userid IN (,4,1428)
ORDER BY dateline 
 
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 '4,1428)
ORDER BY dateline' at line 22
 
mysql error number: 1064

[sabret00the]

sorry about that, forgot a file edit

file re-uploaded.

[Lionel]

I am getting the same thing still

[sabret00the]

sorry lionel it seems the file didn't update/i uploaded the old version, give me two secs