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.

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

Originally Posted by 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

If you read KirbyDE post for the the optimized version all you need to edit is showthread.php and thats it done.

[MorrisMcD]

Originally Posted by DR?@M W?@V?R

If you read KirbyDE post for the the optimized version all you need to edit is showthread.php and thats it done.

I saw that but I noticed that

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

exists twice in my showthread.php

Should I add

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

below both instances?

Should I remove the queries I already installed? Sorry.. I dont know what the last few posts really meant, so that may answer my question, but not really since I am not sure what you all are talking about..

Thanks

[Andreas]

As already stated here you must edit both queries.

[MorrisMcD]

Originally Posted by KirbyDE

As already stated here you must edit both queries.

I thought that is what was meant, but I just wanted to check..

Thanks

[MorrisMcD]

Ok.. Got it working... Thanks for the help.. I am running 3.0.5 and with Kirby's instructions, all works well...

Although I think I am going to change the code to have the image located in the images directory rather than the root, which is where it must be by your code..

Thanks again

[Andreas]

Well, I just adapted this from the original hack.
You can palce the image whereever you want, just make sure you got the correct path in the IMG-Tag

[Alien]

Originally Posted by KirbyDE

Well, I just adapted this from the original hack.
You can palce the image whereever you want, just make sure you got the correct path in the IMG-Tag

Again, this is awesome.. Nice work..

Any way in the popup window version to get the photo to display centered and not left aligned whenever it pops up? Or have it be dynamic so that no matter what size the picture is it will adjust the pop to be that exact size? Just an asthetics idea..

[ninjaneo]

Looks like the current versoin you copied out of some vterm window from a shell of some kind... one of the lines is cut off.

######### OPEN includes/functions_showthread.php ########

## FIND:
$show['messageicon'] = iif($post['iconpath'], true, false);


## BELOW ADD:

        // profile pic in thread
        if ($post[haspic] == "" && isset($post['userid']))
        {
            $show['haspic']=false;
            $mjctemp = $DB_site->query_first("SELECT count(*) AS count FROM " . TABLE_PREFIX . "customprofilepic WHERE userid=" . $pos$
                if ($mjctemp[count]==1) {
                        $show['haspic']=true;
                        $DB_site->query("UPDATE " . TABLE_PREFIX . "user SET haspic='1' WHERE userid = $post[userid]");
                } else {
                        $DB_site->query("UPDATE " . TABLE_PREFIX . "user SET haspic='0' WHERE userid = $post[userid]");
                }
        } else {
                if ($post[haspic]=="1")
                { $show['haspic']=true; }
                else
                { $show['haspic']=false; }
        }
        // profile pic in thread

// SAVE & CLOSE includes/functions_showthread.php

[high]* ninjaneo points to
[/high]

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

[HarryBO]

Nice Hack, but i became an parse error:

Parse error: parse error, unexpected '$' in /www/htdocs/v*****/includes/functions_showthread.php on line 1421

This is line 1421

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

[Marco van Herwaarden]

Replace the line:

PHP Code:

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


with:

PHP Code:

            $mjctemp = $DB_site->query_first("SELECT count(*) AS count FROM " . TABLE_PREFIX . "customprofilepic WHERE userid=" . $post['userid']);