[GOD-Dblade]

bleh i feel like a n00b well...this is what i got
Database error in vBulletin Mod Control Panel 2.2.5:

Invalid SQL: UPDATE user SET usergroupid=8 WHERE userid=
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

Date: Sunday 12th of May 2002 09:07:20 PM
Script: http://www.gods-network.com/forums/forums/mod/user.php
Referer: http://www.gods-network.com/forums/m...an&userid=2476

in my config file i have
//set fieldid's of banreason field and banuser field
$banreasonfieldid=8;
$banuntilfieldid=9;

and i also changed in showbanned.php to try to fix it this
$banreasonfieldselect, usergroup.title, user.username, user.userid, user.invisible, user.receivepm,
user.usergroupid, user.lastactivity, user.lastvisit, $banuntilfieldselect
FROM usergroup
LEFT JOIN user ON (usergroup.usergroupid = user.usergroupid)
LEFT JOIN userfield ON (userfield.userid = user.userid)
WHERE usergroup.showgroup = 1 AND usergroup.usergroupid = 15

to

$banreasonfieldselect, usergroup.title, user.username, user.userid, user.invisible, user.receivepm,
user.usergroupid, user.lastactivity, user.lastvisit, $banuntilfieldselect
FROM usergroup
LEFT JOIN user ON (usergroup.usergroupid = user.usergroupid)
LEFT JOIN userfield ON (userfield.userid = user.userid)
WHERE usergroup.showgroup = 1 AND usergroup.usergroupid = 8