Stadler
Tue 1st Oct '02, 8:03pm
In the Moderator's Control Panel the wrong Styleset is displayed when viewing a user, because the styleid isn't chosen from the usertable.
To correct this, do the following:
in mod/user.php find
$user=$DB_site->query_first("SELECT userid,usergroupid,username,password,email,parente mail,coppauser,homepage,icq,aim,yahoo,signature,ad minemail,showemail,invisible,usertitle,customtitle ,FROM_UNIXTIME(joindate) AS joindate,cookieuser,daysprune,FROM_UNIXTIME(lastvi sit) AS lastvisit,FROM_UNIXTIME(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,posts,timezoneoffset,emailnotification,em ailonpm,receivepm,ipaddress FROM user WHERE userid=$userid");and replace it with $user=$DB_site->query_first("SELECT userid,usergroupid,username,password,email,styleid ,parentemail,coppauser,homepage,icq,aim,yahoo,sign ature,adminemail,showemail,invisible,usertitle,cus tomtitle,FROM_UNIXTIME(joindate) AS joindate,cookieuser,daysprune,FROM_UNIXTIME(lastvi sit) AS lastvisit,FROM_UNIXTIME(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,posts,timezoneoffset,emailnotification,em ailonpm,receivepm,ipaddress FROM user WHERE userid=$userid");
Tried to highlight the change, but the forum screwed everything, so I reverted it back {Stadler}
To correct this, do the following:
in mod/user.php find
$user=$DB_site->query_first("SELECT userid,usergroupid,username,password,email,parente mail,coppauser,homepage,icq,aim,yahoo,signature,ad minemail,showemail,invisible,usertitle,customtitle ,FROM_UNIXTIME(joindate) AS joindate,cookieuser,daysprune,FROM_UNIXTIME(lastvi sit) AS lastvisit,FROM_UNIXTIME(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,posts,timezoneoffset,emailnotification,em ailonpm,receivepm,ipaddress FROM user WHERE userid=$userid");and replace it with $user=$DB_site->query_first("SELECT userid,usergroupid,username,password,email,styleid ,parentemail,coppauser,homepage,icq,aim,yahoo,sign ature,adminemail,showemail,invisible,usertitle,cus tomtitle,FROM_UNIXTIME(joindate) AS joindate,cookieuser,daysprune,FROM_UNIXTIME(lastvi sit) AS lastvisit,FROM_UNIXTIME(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,posts,timezoneoffset,emailnotification,em ailonpm,receivepm,ipaddress FROM user WHERE userid=$userid");
Tried to highlight the change, but the forum screwed everything, so I reverted it back {Stadler}