Avatar Hack Errors

[Gellpak]

I am uninstalling what i have done to make vbb funtional again, but if someone who has had this problem or knows how to fix it will tell me i will probably install it again.....

I installed the avatar hack exactly as the readme stated, but the second to last file to edit (showthread.php) did not have the requested text to find contained within. i looked through it and it did contain the ,iconpath in a few places so i hoped that it was a more current version and continued to change the templates. now when i attempt to view the page i get the infamous MySQL database error and a horde of emails. the readme helped none in actually installing, just the script editing. so i didnt know where to upload the accompanying scripts or where i could find help. so, i came here. any ideas?

first of all we need the error message to figure it out.....but i im sure of the error do you use 1.1.5....if yes i know what you have not done right it take me 2 week to find this error....and if you do a search on avatar hack you will find a tread...i dont remember how many page long and you will surely find a solution to your proble if not ask me i will help you with pleasure :)

and the file go in the vb root

have a good day

Showthread.php has been slightly rewritten in 1.1.5. Look for a line which looks like:
$posts=$DB_site->query("SELECT post.dateline as dateline,post.postid as <continued>

If you can't figure out the problem, feel free to contact me on ICQ 17278616

heres the error.....

Database error in vBulletin: Invalid SQL: SELECT daysprune,lastvisit,lastactivity,cookieuser,userna me,password,usergroupid,timezo neoffset,iconpath FROM user WHERE userid=1
mysql error: Unknown column 'iconpath' in 'field list'
mysql error number: 1054
Date: Wednesday 14th of February 2001 02:57:57 PM
Script: /php/forums/index.php

i discovered in showthread.php the pattern to the new , select statement though i dont understand it, i added a

,user.iconpath as iconpath

on the end instead of a simple ,iconpath as is stated in the readme.

now unfortunately the same error continues in the index.php file.

i fixed that by inserting a new row in the database (iconpath, varchar 200) but its a bit of a quick fix i suspect

ok, i think i fixed all the problems. the readme was horribly inadequate.....

and i am having trouble figuring out how to add icons. placing them in the directory does not work, is that a problem in itself?

now im having trouble with an upload script i am writing. ill redirect you to the post ---

http://www.vbulletin.com/forum/showthread.php?s=&threadid=8702