avatar for vbulletin 1.1.55

[[JaGz]]

Having problems installing Avatars on Vb 1.1.5 problems as in parts of the hack being Look for so and so and add this after i cant find some of the lines for this is there a fix for 1.1.5 Avatars 2.0 work on 1.15 please help thanks alot

do a search about avatar 2.0 and you will find many thing intestering i remember havinh such a problem when i install it on my 1.1.5 forum but can't remember....its something about a coma or some """ anyway you will make your way the treat have many pages and descripe all kind of problem....

have a nice day

You're probably talking about this line in showthread.php:
$userinfo=$DB_site->query_first("SELECT userid,email,username,usertitle,signature,showemai l,homepage,icq,aim,yahoo,joindate,posts FROM user WHERE userid=$userid");

It was rewritten in 1.1.5 and the line changed to:

$posts=$DB_site->query("SELECT post.dateline as dateline,post.postid as postid,post.pagetext as pagetext, <some part removed here> ,user.posts as posts FROM post <removed>


Add ,user.iconpath as iconpath after user.posts as posts so the line looks like this:

$posts=$DB_site->query("SELECT post.dateline as dateline,post.postid as postid,post.pagetext as pagetext, <some part removed here> ,user.posts as posts,user.iconpath as iconpath FROM post <removed>


Hope I'm correct. Give it a try and let us know. :)

i think is this too

G8 Thanks alot for your help

Thanks for your help has gotten me father than i have goten before.. But now i am getting this error

Database error in vBulletin: Invalid SQL: SELECT
daysprune,lastvisit,lastactivity,cookieuser,userna me,password,usergroupid,timezo neoffset,iconpath
FROM user WHERE userid=3
mysql error: Unknown column 'iconpath' in 'field list'
mysql error number: 1054

my showthread.php is as follows

$counter=0;
$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.user.iconpath as iconpath FROM post
LEFT JOIN user ON (user.userid = post.userid)
WHERE post.threadid=$threadid AND visible=1
ORDER BY dateline $postorder
LIMIT $limitlower,$perpage");

global.php
$bbusergroupid=1;

if (isset($bbuserid)!=0 and $bbuserid!=0 and isset($bbpassword)!=0) {

$bbuserid=$bbuserid;
if ($userinfo=$DB_site->query_first("SELECT daysprune,lastvisit,lastactivity,cookieuser,userna me,password,usergroupid,timezo neoffset,iconpath FROM user WHERE userid=$bbuserid")) {
if ($bbpassword==$userinfo[password] or $bbpassword==substr(md5($userinfo[password]),0,strlen($userinfo[password]))) {
if (isset($daysprune)==0 or $daysprune==0) {
$daysprune=$userinfo[daysprune];
}
Thx if ya can help

user.user.iconpath as iconpath


Correct to user.iconpath as iconpath


Also, be sure you ran update.php. It creates neccessary tables in the database.

Thank you all is working now i have 2 avatars showing but i think i can fix that thanks to all who help me

Where do you have avatars 1.1.5 from?