"Who Posted" Enhancement: View All Posts By User In This Thread

Hi all,

Don't know if there will be much interest here, but my users asked for this so I wrote a hack.

What is it?

When you click on the total replies in vBulletin, you can see a list of all posters who participated in the thread, and how many posts each had in that thread.

The hack adds a link to this pop-up window -- allowing you to view all posts by User X in that thread.

Where can I see a Demo?

I'm probably explaining it badly, so here's a demonstration:

Go to my bulletin board, at http://www.atlasf1.com/bb/index.php

Visit any one of the forums and click on the # of replies for any one of the threads (select one with lots of posts for better demonstration).

Click on the # of posts next to a username in the "Who Posted"
pop-up window

The result: you will get a page looking and behaving exactly like showthread for that thread, however it will include ONLY posts by that specific poster.

You can reply to the thread, quote a post, everything as if you were in the full thread.

You can also jump directly to the location of a specific post, by clicking on the post count to the right side of the post (you need to have Post Count hack installed for this).


How do I install it?

With almost no work at all.

Download the attachment - showposts.txt - and rename it to showposts.php. Upload it to your forums' main directory.

Edit template whopostedbit and replace

$post[posts]

with

<a href="showposts.php?s=$session[sessionhash]&threadid=$threadid&postuserid=$post[userid]" target="_blank">$post[posts]</a>

That's it

Cheers,

Bira

[bira]

Forgot to say this has been tested and works on 2.03 and up, including the latest version (2.2.1)

[Bane]

Great Idea Bira

[Lesane]

Nice Hack Bira, Thanks

[FWC]

Very cool! Thanks, Bira!

[itstd]

Pretty cool! A lot of times the mems on my forum are only interested in what a Mod replys to their question (especially a technical one) and this is perfect for that. Thanks!

[Martz]

Fantastic, I love these hacks with no file editing, just tweak a template and your away


Great work bria.

[Hooper]

Very nice. Works super. Thank you.

[Admin]

I like it, and I'm gonna install it (sometime ), but I have something to say.

Why do you need a whole new file just for getting X's posts?

Right now you have this, right?

$getpostids=$DB_site->query("
	SELECT post.postid FROM post
	WHERE post.threadid='$threadid' AND post.visible=1
	ORDER BY dateline $postorder LIMIT ".($limitlower-1).",$perpage
");

(in showthread.php)
You can just change it to something like:

$getpostids=$DB_site->query("
	SELECT post.postid FROM post
	WHERE post.threadid='$threadid' ".iif(isset($postuserid), "AND post.userid='$postuserid'", "")." AND post.visible=1
	ORDER BY dateline $postorder LIMIT ".($limitlower-1).",$perpage
");

And that's it!
(unless I'm missing something you had special in showposts.php)

Just constructive criticism.

[bira]

FireFly you must have the same checks or this file will become a way for users to look at hidden threads, for example.

I stripped off what clearly isn't needed (like go to next/last thread, like go to newest post, etc).

But you still have to make the same "work" as you would for showthread:

check in which order to show the posts - newest first or oldest first?

check whether the thread is visible

get permissions

do the posts-per-page routine

draw the navbar

bbcode et. al.

page nav

admin options or not


In short, you treat it almost exactly like you'd treat a thread. Well, it IS a thread. Just only one poster's messages in it