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
|