Show icon if user has Profile Picture

What does this do?
Basically, when viewing a thread, if a user has a Profile Picture, it will show a camera icon (or whatever picture you choose) next to his/her online status icon. For example:


How to do this hack:
Download the instructions!

Updates!
July 1, 2004: I finally got around to re-writting this a bit so that you don't have a query for every post in every thread. However, after you install this, you'll notice that the first time you view a thread there will be a ton of queries. That will happen until we've essentially cached each user's "haspic" status in the user table... meaning that, in the end, this should be a lot nicer than the last version.

[Boofo]

Nice idea but this adds a query for every post on the page. If you have 15 posts, the page will show 15 extra queries whether the user has a profile pic or not. You might want to rework the code a bit to have it only add 1 query per page.

[TechGuy]

Yeah, I know -- maybe someone around here will be smart enough to do that.

[Boofo]

Put it above the loop for the postbit and declare the globals in the loop.

[pixelpunk]

Originally Posted by Boofo

Put it above the loop for the postbit and declare the globals in the loop.

Will this decrease the queries? If so please show us where, I'd love to use this hack!

[Alien]

Anyone get this to work right, with just 1 query per page? I'd appreciate the instructions too...

[FutureDEV]

Anyone? Pretty please??

[Alien]

I hope someone updates this, as it's an excellent little add-on...

[Polo]

I agree.

if 1 query per page = I install

lol

[Dean C]

It'd probably be easier to add a field to the user table for this That way no extra queries other than when updating the profile picture