PDA

View Full Version : Filter Posts Hack


sabret00the
03-19-2005, 10:00 PM
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 :p

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
03-20-2005, 04:20 PM
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
03-20-2005, 08:30 PM
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
03-20-2005, 08:42 PM
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
03-21-2005, 01:29 AM
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
03-21-2005, 07:46 AM
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
03-21-2005, 08:30 AM
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
03-21-2005, 09:30 AM
sorry about that, forgot a file edit :(

file re-uploaded.

Lionel
03-21-2005, 11:22 AM
I am getting the same thing still

sabret00the
03-21-2005, 11:24 AM
sorry lionel it seems the file didn't update/i uploaded the old version, give me two secs

sabret00the
03-21-2005, 11:29 AM
ok working version now up.

Lionel
03-21-2005, 11:39 AM
there are 2 instances of this. Place in both? At least the second instance works


if (!isset($qrfirstpostid))
{
$qrfirstpostid = $post['postid'];
}

sabret00the
03-21-2005, 11:49 AM
it's the second instance.

random1
06-14-2007, 07:16 AM
not working on 3.6.7?