vb.org Archive - Problem installing Avatar 2.0 on vBB 1.1.4

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)

- - Problem installing Avatar 2.0 on vBB 1.1.4 (https://vborg.vbsupport.ru/showthread.php?t=4719)

11-19-2000 12:24 PM

Hi,

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

Code:

[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

Code:

$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

11-19-2000 12:30 PM

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. ;)

11-19-2000 12:36 PM

Quote:

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

11-19-2000 12:51 PM

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:

Code:

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

11-19-2000 01:39 PM

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!

:(

11-19-2000 01:51 PM

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

11-19-2000 03:53 PM

Delete any folders you want except 0

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

All times are GMT. The time now is 01:54 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00978 seconds Memory Usage 1,730KB 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 (3)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (7)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 bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: