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.

[Andreas]

Yes. Posts is for linear mode, chacheposts is for hybrid and threaded mode.

But I only tested in linear mode so far ... don't know if this does work in other modes.

[Boofo]

Originally Posted by KirbyDE

Yes. Posts is for linear mode, chacheposts is for hybrid and threaded mode.

But I only tested in linear mode so far ... don't know if this does work in other modes.

I installed it in both queries. I'll test it out for hybrid and threaded and let you know. Thanks.

[y2krazy]

/me clicks install!

[SIINSI]

Originally Posted by y2krazy

[high]* y2krazy clicks install![/high]

For some reason I get a parse error on this line...

{$mjctemp = $DB_site->query_first("SELECT count(*) AS count FROM " . TABLE_PREFIX . "customprofilepic WHERE userid=" . $pos$

Miguel

[Chazz Layne]

Getting the same problem here... happened right after upgrading to 3.0.5 from 3.0.1.

Edit - just tried the other method posted by Kirby, which seems to do absolutely nothing on Threaded mode (the only mode our forum uses). :ermm:

/me begins uninstalling hack. :tired:

[Andreas]

Hmm, I haven't upgraded to 3.0.5 yet (currently 3.0.3) but I don't see why the code I sposted shouldn't work.

Did you modify both queries?

[DR?@M W?@V?R]

Originally Posted by SIINSI

For some reason I get a parse error on this line...

{$mjctemp = $DB_site->query_first("SELECT count(*) AS count FROM " . TABLE_PREFIX . "customprofilepic WHERE userid=" . $pos$

Miguel

same here as well, also the code changes for profile.php are different for 3.0.5.

[DR?@M W?@V?R]

Originally Posted by KirbyDE

Nice one, but let me suggest an optimization (this is how I did it some weeks ago):

In showthread.php FIND

PHP Code:

post_parsed.pagetext_html, post_parsed.hasimages, 


BELOW that ADD

PHP Code:

NOT ISNULL(customprofilepic.userid) AS haspic, 


Further down in showthread.php FIND

PHP Code:

LEFT JOIN " . TABLE_PREFIX . "post_parsed AS post_parsed ON(post_parsed.postid = post.postid) 


BELOW that ADD

PHP Code:

LEFT JOIN " . TABLE_PREFIX . "customprofilepic  AS customprofilepic ON(customprofilepic.userid=post.userid) 


And use this template modification:

In template postbit FIND

PHP Code:

$post[onlinestatus] 


BELOW that ADD

PHP Code:

<if condition="$post['haspic']"><img src="/photo.gif" border=0 alt="Photo in Profile!"></if> 


That's it. This way you don't have to alter table user, file profile.php and functions_showthread.php.
You also might want to extend this for single post display and PM

Thanks for that it works on 3.0.5 in all display modes

I added this code to the image link.

<if condition="$post['haspic']"><a href="image.php?u=$post[userid]&amp;type=profile"><img src="$stylevar[imgdir_misc]/photo.gif" align="absmiddle" border="0" alt="$post[musername] Has A Photo Click Here To View"></a></if>

I would like to add a 100x100 pop up window to show the image, if anyone could help out.

[DR?@M W?@V?R]

Sorted.

PHP Code:


<if condition="$post['haspic']"><a href="image.php?u=$post[userid]&amp;type=profile" onclick="window.open('image.php?u=$post[userid]&amp;type=profile', 'popup', 'statusbar=no,menubar=no,scrollbars=no,resizable=no,width=110,height=110'); return false"><img src="$stylevar[imgdir_misc]/photo.gif" align="absmiddle" border=0 alt="$post[musername] Has A Photo Click Here To View"></a></if> 


[MorrisMcD]

I was going to install this but when I got to the profile.php, I noticed the code was different.. So I decided to abandon...

I did already run the query though.. What command would I run to reverse that?

Or, is there a set of instructions on a fresh install on 3.0.5?

Thanks