Problem installing Avatar 2.0 on vBB 1.1.4

Hi,

I have got to this step in the avatar 2.0 install guide:

[showthread.php]

Find:
~~~~~~~~~~
$userinfo=$DB_site->query_first("SELECT userid,email,username,usertitle,signature,showemail,homepage,icq,aim,yahoo,joindate,posts FROM user WHERE userid=$userid");
~~~~~~~~~~

Change to:
(Add ",iconpath" before "FROM")
~~~~~~~~~~
$userinfo=$DB_site->query_first("SELECT userid,email,username,usertitle,signature,showemail,homepage,icq,aim,yahoo,joindate,posts,iconpath FROM user WHERE userid=$userid");
~~~~~~~~~~

The problem is that in the showthread.php I can not find

$userinfo=$DB_site->query_first("SELECT userid,email,username,usertitle,signature,showemail,homepage,icq,aim,yahoo,joindate,posts FROM user WHERE userid=$userid");

Anyone know how to get this hack working?

Thanks,

Nick

Find

$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,post.pollid as pollid,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,user.receivepm as receivepm,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");


Just add user.iconpath as iconpath
I have some other hacks installed so do not copy all this line.

Originally posted by PeF
Find

$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,post.pollid as pollid,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,user.receivepm as receivepm,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");


Just add user.iconpath as iconpath
I have some other hacks installed so do not copy all this line.

Thanks

Hi,

I uploaded all the files and I got the


There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.



The Email says this:

Database error in vBulletin: Invalid SQL: SELECT daysprune,lastvisit,lastactivity,cookieuser,username,password,usergroupid,timezoneoffset,iconpath FROM user WHERE userid=1
mysql error: Unknown column 'iconpath' in 'field list'
mysql error number: 1054
Date: Sunday 19th of November 2000 02:45:47 PM
Script: /forum/update.php
Referer:

Any ideas?

Thanks,

Nick

Hi,

got this working after tweaking my database a bit and editing the update.php script.

If i'd known the troubles with 1.1.4 and most of the hacks, I wouldn't have upgraded!

Hi,

just like to know who chose those images to include in the package.....pokemon?

hehe

I take it if i just delete the folder they are in, eg 100 and 150 they won't show up in the avatar listings?

Can I also take it that if i create a new folder and add images to it, they will be added to the avatar listing?

thanks,

Nick

Delete any folders you want except 0

If you want to create new folders, just make sure the name consists of a number.