[RELEASE vB2.0] quick 'who posted'

[Kier]

This is a fairly simple hack, but my users wanted it, so here it is.



What it does is to add a link to the number of replies for a thread, which allows users to quickly see who has posted in a thread without opening the showthread.php page. The results are shown in a small popup window.

Any suggestions or comments are welcome.

[edit: this hack is now included in vBulletin 2.0.3 and above]

[PeF]

Another awesome release from Kier. Thanks again. :)

[chrispadfield]

that is nice. Does it use any extra queries on forumdisplay or only when you click on the pop-up? I like it a lot.

[Kier]

No extra queries on forumdisplay.php at all. :)

[leadZERO]

Very nice.

I had some people asking for this, one less thing I have to write, thank you so much :)

[Me2Be]

This is COOL!!!

[conan]

Awesome another 5 star rating :)

[conan]

I just installed the hack, and I have to say it was the easiest install I've ever did, the hack works great and it's pretty fast.

I think VBB's dev team ought be looking for someone like you Kier ;)

[conan]

Originally posted by eva2000
yes i agree - installed it in less than 2 mins :)

works great hopefully it works in all netscape and IE browsers :D
I've tested on NN and no problems at all!

[mrlister]

man you're just one awsome hacking machine. You just keep on coming and coming and each time they get better and better. :)

[Shane]

heh. Nice hack.. might have to install once our site is ready to move to vb 2.0 beta 2. *cough* Rat *cough* Well... there are other reasons for our delay, but.... it's cool. :D

[Cold Steel]

Excellent hack.

Keep up the good work.

[chrispadfield]

brilliant. Just installed it and it works perfectly. 5 Stars!

[Craig A]

Cool! Many thanks for that - my users will appreciate it :)

[jojo85]

http://www.jeuxwebmasters.com/forums/forumdisplay.php?s=&forumid=19

Nice :)

[chrispadfield]

one thing i was wondering, when you move a thread you get the "-" as the number of replies. With this hack it is no underlined because it still works but looks a little silly. Is there any way to not have this when the thread is moved. I would imagine not because you can't do and if elseif routine in the templates but just thought i would ask.

[Kier]

It would be fairly easy to implement that, but as you pointed out, it would require a little condition to be placed in the php code, rather than a simple template change.

If you really want it, this is the code to modify:

Find in forumdisplay.php:
} else {
if ($foruminfo[allowratings]) { replace with
} else {
$thread[replycount] = "<a href=\"javascript:who($thread[threadid])\">$thread[replycount]</a>";
if ($foruminfo[allowratings]) { This code should be around line 390... but I can't give you an exact line number, as my forumdisplay.php doesn't really look much like the original ;)

You will also need to remove the hyperlink from the forumdisplaybit template.

[Kier]

Yep, open whoposted.php and select the whole SQL query, and replace it with this:
$posts = $DB_site->query("SELECT
COUNT(postid) AS posts, post.userid, user.username, subscribethread.userid AS subuserid
FROM post LEFT JOIN user USING (userid)
LEFT JOIN subscribethread ON
(subscribethread.threadid=post.threadid AND subscribethread.userid=user.userid)
WHERE post.threadid=\"$threadid\"
GROUP BY post.userid ORDER BY posts DESC"); then further down the code, find this:
eval("\$posters .= \"".gettemplate("whopostedbit")."\";"); and immediately above it, add this:
if ($post[userid]==$post[subuserid]) $subscribed = " <smallfont>[subscribed]</smallfont>";
else $subscribed = ""; then open your whopostedbit template and just after the closing </a> of the profile link, add $subscribed.

That oughta do it :)

[eva2000]

hmm it didn't work nothing no indicator of who subscribed showed up ?

[Kier]

oops... you should add $subscribed to your templates... not $subscribe. Sorry.

[chrispadfield]

thanks Kier for the change, will do it on next upgrade. cheers.

[bira]

great hack kier.

Just a couple of comments:

1. General comment to all: with regards to the $subscribed thingy, bear in mind that this is a serious invasion of privacy. And, unlike the "who is online", where you allow users to opt out, in adding this $subscrived thingy to the hack you are not allowing anyone any opt-out option.


2. Kier, I LOVE your hacks so please take my following comment as a constructive one: you do not follow strict php coding, which makes it immensely hard to debug a code that consists of your code and others.

Could you perhaps make sure you always use { and } for the ifs and elses? I think in a code made public, strict and global coding guidelines are imperative.

Anyhow, again, thanks for yet another great hack.

Cheers,

Bira

[Freddie Bingham]

2. Kier, I LOVE your hacks so please take my following comment as a constructive one: you do not follow strict php coding, which makes it immensely hard to debug a code that consists of your code and others.

Could you perhaps make sure you always use { and } for the ifs and elses? I think in a code made public, strict and global coding guidelines are imperative.

Bira there is no "strict php coding" rulebook that says one must enclose if/then segments withing curly braces. Without curly braces the compiler will only process the first following line for inclusion in the if/then. It is perfectly valid code.

i.e.



if ($x)
if ($y)
if ($z)
echo "YES";


is the same as and as valid as



if ($x) {
if ($y) {
if ($z) {
echo "YES";
}
}
}

[Lordmusic]

This hack is great, but it has a flaw. When you do a search, say for the new posts, or any search for that matter, it does not have the hack in it. I am sure it's a simple bit of code editing but I am just toO damn lazy to look into it...

Lordmusic

[Kier]

Originally posted by bira
unlike the "who is online", where you allow users to opt out, in adding this $subscrived thingy to the hack you are not allowing anyone any opt-out option. Okay, if you want to allow users to opt-out, we'll use the invisible setting, so that 'invisible' users don't have their subscriptions shown:

Replace the query with this:
$posts = $DB_site->query("SELECT
COUNT(postid) AS posts, post.userid, user.username, user.invisible subscribethread.userid AS subuserid
FROM post LEFT JOIN user USING (userid)
LEFT JOIN subscribethread ON
(subscribethread.threadid=post.threadid AND subscribethread.userid=user.userid)
WHERE post.threadid=\"$threadid\"
GROUP BY post.userid ORDER BY posts DESC"); then change the conditional code to this:
if ($post[userid]==$post[subuserid] && !$post[invisible]) $subscribed = " <smallfont>[subscribed]</smallfont>";
else $subscribed = ""; All done. Privacy restored.
make sure you always use { and } for the ifs and elses My new PM hack will be a model of strict coding.
Anyhow, again, thanks for yet another great hack.Welcome.

[bira]

Freddie,

When I have your original code, plus someone else's hack, plus Kier, etc - if the style of coding is not unified, it makes it damn hard to debug if there's a mistake somewhere or a missing curly.

I am not saying this won't work - fact is it does - I am merely asking if possible that hackers restrict themselves to the same "full" (for lack of better word) coding.

[Kier]

Originally posted by Lordmusic
This hack is great, but it has a flaw. When you do a search, say for the new posts, or any search for that matter, it does not have the hack in it. I am sure it's a simple bit of code editing but I am just toO damn lazy to look into it...

Lordmusic This would be a simple template edit.

[claypots]

A great hack!

A couple of suggestions:

At the bottom of the pop-up box allow the user to click to go the actual thread and to close the window. [you can probably do these in a blink of an eye but I thgout I'd suggest it]

Again, great work!

[Kier]

To do that, simply add this to your whoposted template:
<a href="javascript:opener.location=('showthread.php?s=$ses sion[sessionhash]&threadid=$threadid');">Go to this thread</a>

[bira]

you can add self.close() to that javascript link, and the small window will close while the thread loads in the big window :)

[claypots]

Thanks!

[Kier]

Good idea bira :) For those who are not too familiar with javascript syntax, that would make the link look like this:
<a href="javascript:opener.location=('showthread.php?s=$ses sion[sessionhash]&threadid=$threadid'); self.close();">Show thread and close this window</a>

[Lordmusic]

Just I am too dumb to know which one, please enlighten me...

[tubedogg]

Originally posted by freddie


Bira there is no "strict php coding" rulebook that says one must enclose if/then segments withing curly braces.
i.e.



if ($x)
if ($y)
if ($z)
echo "YES";


is the same as and as valid as



if ($x) {
if ($y) {
if ($z) {
echo "YES";
}
}
}


Not to mention the first makes your code shorter. :) Not to argue, bira, but I always use if ($whatever): instead of if ($whatever) { because I am forever forgetting to close the curly braces. So maybe I'm just lazy :) but I prefer to not use the braces.

[CJ]

good hack!

congrats

[Mas*Mind]

Originally posted by tubedogg


Not to mention the first makes your code shorter. :) Not to argue, bira, but I always use if ($whatever): instead of if ($whatever) { because I am forever forgetting to close the curly braces. So maybe I'm just lazy :) but I prefer to not use the braces.

Well, you do have to enclose it in brackets when an if block contains multiple statements...

offtopic:

I don't get why many people code like this:



if($this) {
doThis();
doThat();
if($that) {
bla()
}
}
else {
doThose();
doThese();
}


This way you easily forget those brackets to close, especially with nesting if's and else's...

It's far better to code like this:



if($this)
{ doThis();
doThat();
if($that)
{ bla();
}
}
else
{ doThose();
doThese();
}


When I go to the vb-code I often can't see what belongs to where...

[bira]

Originally posted by Mas*Mind

Well, you do have to enclose it in brackets when an if block contains multiple statements...


No, not in the alternative method he's talking about.

if you do if(whaterver): then you can have as many statements as you want, up until you write endif;

BUT, that method as well as my previous complaint just makes the code even more incomprehensible.

[Mas*Mind]

yeah, I noticed that...just quoted wrong :o

I wanted to quote on this


ira there is no "strict php coding" rulebook that says one must enclose if/then segments withing curly braces

[bokhalifa]

hi
Kier

not working
http://bokhalifa.org/daar/bo/whoposted.php

help me;)

[bokhalifa]

yea:D
Thanks!
eva2000;)

[Lost]

yeah since beta 4/4.1 it hasn't worked
So this hack will not work on beta 4??
Is that right????
Sorry to ask a dumb question....

[tubedogg]

It works on my beta 4.1...

[Raptor]

just installed on beta 5 - works like a charm !

[TigerLily]

Works on my copy of beta 5 too. Thanks, Kier!
Kim:)

[TechTalk]

I like this because it is a standalone hack :) I wont add hacks that require editing of main files for sake of updating.


Thanks alot

~Chris

[Mas*Mind]

One tiny bug....the post count is always one too many...

simple fix: replace $totalposts = number_format($totalposts); with $totalposts = number_format($totalposts)-1;

It bugs me why it is btw...Can't find anything wrong in the code...maybe $totalposts has to be initialized on zero first...but as far as I know that doesn't matter (didn't tested it though)

[Mas*Mind]

DUH...

forgot that total replies isn't the same as total posts, to be exactly: The difference is one :D

[Hooper]

Great Hack. Works just fine.

Thank You Kier.

[amsch]

I just love it and it was easy to install for a php dummy like me!
Amy

[jucs]

I got a file not found error in the popup.:(

Any ideas why?

In this template, there already is "topic Table" tag at the top. Do you put it above that or the script under it.

<!-- topic table -->
<script language="Javascript">
function who(threadid) {
window.open("whoposted.php?s=$session[sessionhash]&threadid="+threadid, "moo", "toolbar=no,scrollbars=yes,resizable=yes,width=200, height=300");
}
</script>

[jucs]

See my other post. I just need to know the answer to the question. And, why it would not be working. I followed directions to the letter too. :(

Update..duh me. The darn whoposted.php file got uploaded as whoposted_php. :rolleyes:

[express]

Great Hack Thanks

http://www.realwebhost.net


Joey

[Thomas P]

amazing hack!
thanks kier,
-Tom

[WEAPON]

Great hack. Works perfectly.

[AnnaFan]

Hi,

under replies I found this:

0normalfont>

What is wrong? I think the normalfont tag is wrong. But I can´t find the error. Can somebody help me please?

[version2]

I am trying to get this to work. I dont know exactly what went wrong, but when you click on the thread[replycount] link it pops up a box with template info. Its not parsing it.

Trying to figure it out..any ideas?

Here is a link:

http://www.mysticwicks.com/whoposted.php?threadid=2937

[c-prompt]

On yours how did you get it to change cell color for each post. Or, I should say using 2 colors that alternate. The script as written only uses 1 color for both cells.


Thanks

[TWTCommish]

It requires some mild hacking. Find the while() loop used to display the threads in forumdisplay.php, and add this before it:

$alt_num = 1;

Then, right inside the loop, add something like this:



$alt_color = ($alt_num % 2 == 0) ? "#FFFFFF" : "#E9E9E9";
$alt_num++;


Then just reference $alt_color instead of "{firstaltcolor}", etc, in your forumdisplay_bit template. I did it with my forums here: http://forums.thestands.com

[mister]

easy install, awesome feature.

5-star.

thanks kier.

[version2]

Originally posted by version2
I am trying to get this to work. I dont know exactly what went wrong, but when you click on the thread[replycount] link it pops up a box with template info. Its not parsing it.

Trying to figure it out..any ideas?

Here is a link:

http://www.mysticwicks.com/whoposted.php?threadid=2937

Anyone?

[RobAC]

If you do a view source on this page, these are the warning messages you find embedded near the top:

<b>Warning</b>: Cannot add header information - headers already sent by (output started at /home/version2/public_html/whoposted.php:4) in <b>/home/version2/public_html/admin/functions.php</b> on line <b>1187</b><br>
<br>
<b>Warning</b>: Cannot add header information - headers already sent by (output started at /home/version2/public_html/whoposted.php:4) in <b>/home/version2/public_html/admin/functions.php</b> on line <b>1187</b><br>

[express]

This is a great hack. Is there a way to add this to a forum on the total post column?

Joey

[heynurse]

kier.... u da man!

great hack! Very useful. 5 - *****'s

[MarkB]

I installed this but had to remove it as whoposted.php, when opened from the thread list, showed nothing but the source code - and I am sure I've followed every step of the installation correctly. Does anyone have any ideas? :(

[version2]

Originally posted by MarkB
I installed this but had to remove it as whoposted.php, when opened from the thread list, showed nothing but the source code - and I am sure I've followed every step of the installation correctly. Does anyone have any ideas? :(

I have the same problem...and I still never figured it out.

[version2]

Originally posted by RobAC
If you do a view source on this page, these are the warning messages you find embedded near the top:

<b>Warning</b>: Cannot add header information - headers already sent by (output started at /home/version2/public_html/whoposted.php:4) in <b>/home/version2/public_html/admin/functions.php</b> on line <b>1187</b><br>
<br>
<b>Warning</b>: Cannot add header information - headers already sent by (output started at /home/version2/public_html/whoposted.php:4) in <b>/home/version2/public_html/admin/functions.php</b> on line <b>1187</b><br>

Rob, sorry for being a bit clueless here. But, I have no idea what that is supposed to mean. :p

[Kier]

This hack is now included in vBulletin 2.0.3