vb.org Archive - [Release] Custom Image Under User Name

This hack allows the user to specify an image from anywhere on the internet to appear under their user name. It was initially requested here.

This is my first public hack that serves a purpose, so be gentle. It's a little rough around the edges, possibly my good friends Mike or freddie could take a look and see if I forgot anything.

Here is an example:

http://www.bronx-bombers.com/vb114/s...php?threadid=2

Here is the code:

First, run the following SQL query to create a new field in the user table:

ALTER TABLE user ADD imgurl VARCHAR (100) not null

Next, open showthread.php:

Find:

Code:

$temps=$DB_site->query("SELECT title,template 

                        FROM template 

                        WHERE title='error_invalidid' OR title='error_nopermission' OR 



title='$foruminfo[rulestemplate]' 

                           OR title='forumrules' OR title='error_forumclosed' OR 



title='showthread_numpages' 

                           OR title='postbit_useremail' OR title='icq' OR title='aim' OR 



title='yahoo'

                           OR title='postbit_homepage' OR title='postbit_profile' OR 



title='$usetemplatebit' 

                           OR title='firstunread' OR title='showthread_nextnewestthread' 

                           OR title='showthread_nextoldestthread' OR 



title='$foruminfo[headertemplate]' 

                           OR title='$foruminfo[footertemplate]' OR title='$usetemplate'");

while ($temp=$DB_site->fetch_array($temps)) {

  $templatecache["$temp[title]"]=$temp[template];

}

Replace With:

Code:

$temps=$DB_site->query("SELECT title,template 

                        FROM template 

                        WHERE title='error_invalidid' OR title='error_nopermission' OR 



title='$foruminfo[rulestemplate]' 

                           OR title='forumrules' OR title='error_forumclosed' OR 



title='showthread_numpages' 

                           OR title='postbit_useremail' OR title='icq' OR title='aim' OR 



title='yahoo' OR title='custom_img'

                           OR title='postbit_homepage' OR title='postbit_profile' OR 



title='$usetemplatebit' 

                           OR title='firstunread' OR title='showthread_nextnewestthread' 

                           OR title='showthread_nextoldestthread' OR 



title='$foruminfo[headertemplate]' 

                           OR title='$foruminfo[footertemplate]' OR title='$usetemplate'");

while ($temp=$DB_site->fetch_array($temps)) {

  $templatecache["$temp[title]"]=$temp[template];

}

Find:

Code:

$posts=$DB_site->query("SELECT post.dateline as dateline,post.postid as postid,post.pagetext as 



pagetext,

                               post.allowsmilie as allowsmilie,post.signature AS 



showsignature,post.title as title,

                               post.ipaddress as ipaddress,post.iconid as iconid,post.username as 



fakename,

                               post.userid as userid, 

                               user.userid as userid,user.email as email,user.username as username,

                               user.usertitle as usertitle,user.signature as 



signature,user.showemail as showemail,

                               user.homepage as homepage,user.icq as icq,user.aim as aim,user.yahoo 



as yahoo,

                               user.joindate as joindate,user.posts as posts 

                        FROM post 

                        LEFT JOIN user ON (user.userid = post.userid) 

                        WHERE post.threadid=$threadid AND visible=1 

                        ORDER BY dateline $postorder

                        LIMIT $limitlower,$perpage");

And Replace With:

Code:

$posts=$DB_site->query("SELECT post.dateline as dateline,post.postid as postid,post.pagetext 



as pagetext,

                               post.allowsmilie as allowsmilie,post.signature AS 



showsignature,post.title as title,

                               post.ipaddress as ipaddress,post.iconid as iconid,post.username as 



fakename,

                               post.userid as userid, 

                               user.userid as userid,user.email as email,user.username as username,

                               user.usertitle as usertitle,user.signature as 



signature,user.showemail as showemail,

                               user.homepage as homepage,user.icq as icq,user.aim as aim,user.yahoo 



as yahoo,user.imgurl as imgurl,

                               user.joindate as joindate,user.posts as posts 

                        FROM post 

                        LEFT JOIN user ON (user.userid = post.userid) 

                        WHERE post.threadid=$threadid AND visible=1 

                        ORDER BY dateline $postorder

                        LIMIT $limitlower,$perpage");

Find:

Code:

    if ($userinfo[icq]!="") {

      $icqnumber=$userinfo[icq];

      eval("\$icq = \"".gettemplate("icq")."\";");

    } else {

      $icqnumber="";

      $icq="";

    }

And After It, Add This:

Code:

    if ($userinfo[imgurl]!="") {

      $custom_img=$userinfo[imgurl];

      eval("\$imgurl = \"".gettemplate("custom_img")."\";");

    } else {

      $custom_img="";

      $imgurl="";

    }

Save and close showthread.php.

Open member.php

In the "Modify Profile" function, find:

Code:

$timezoneoffset=$userinfo[timezoneoffset];

After it, add:

Code:

$imgurl=htmlspecialchars($userinfo[imgurl]);

In the "Update Profile" Section, Find:

Code:

  $DB_site->query("UPDATE user 

                   SET password='".addslashes($password)."',email='".addslashes($email)."',

                      



parentemail='".addslashes($parentemail)."',coppauser=$coppauser,homepage='".addslashes($homepage)."



',

                      



icq='".addslashes($icq)."',aim='".addslashes($aim)."',yahoo='".addslashes($yahoo)."',

                      



biography='".addslashes($biography)."',signature='".addslashes($signature)."',adminemail=$adminemai



l,

                      



showemail=$showemail,invisible=$invisible,cookieuser=$cookieuser,daysprune=$prunedays,

                      timezoneoffset=$timezoneoffset,emailnotification=$emailnotification 

                   WHERE userid=$userid");

And replace with:

Code:

  $DB_site->query("UPDATE user 

                   SET password='".addslashes($password)."',email='".addslashes($email)."',

                      



parentemail='".addslashes($parentemail)."',coppauser=$coppauser,homepage='".addslashes($homepage)."



',

                      



icq='".addslashes($icq)."',aim='".addslashes($aim)."',yahoo='".addslashes($yahoo)."',

                      



biography='".addslashes($biography)."',signature='".addslashes($signature)."',adminemail=$adminemai



l,imgurl='".addslashes($imgurl)."',

                      



showemail=$showemail,invisible=$invisible,cookieuser=$cookieuser,daysprune=$prunedays,

                      timezoneoffset=$timezoneoffset,emailnotification=$emailnotification 

                   WHERE userid=$userid");

Go ahead and update those files, now we have to edit templates:

Open the "modifyprofile" template, and put the following code in there somewhere:

Code:

<tr bgcolor="#DEDEDE">



<td><B><FONT face="verdana, arial, helvetica" size="2" >Custom Image URL:</font></B></td>

<td><INPUT TYPE="TEXT" NAME="imgurl" VALUE="$imgurl" SIZE=30 MAXLENGTH=100></td>



</tr>

Save That.

Open the "postbit" template, and add this wherever you want to put the image, specifying the proper height and width:

Code:

<img src="$custom_img" height="xx" width="xx">

That's it, you're all done.

I just noticed that for users that don't specify an image, you get an red x - I'll try to fix that now.

Other than that, I can't provide a lot of support, because I forgot half of what I did :).

-jim

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01108 seconds Memory Usage 1,788KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (12)bbcode_code_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: