banning.php?do=modify DB Error
 

hi,

Just a bit of quick background this hacks been upgraded constantly from 3.3.2 to 3.4.12b chances are i've missed something but the problem i currently have happens when the following file is accessed.

modcp/banning.php?do=modify

SELECT user.userid, user.username, user.usergroupid AS busergroupid,
userban.usergroupid AS ousergroupid, userban.reason AS reason,
IF(userban.displaygroupid = 0, userban.usergroupid, userban.displaygroupid) AS odisplaygroupid,
bandate, liftdate,
adminuser.userid AS adminid, adminuser.username AS adminname
FROM user AS user
LEFT JOIN userban AS userban ON(userban.userid = user.userid)
LEFT JOIN user AS adminuser ON(adminuser.userid = userban.adminid)
WHERE user.usergroupid IN(8)
ORDER BY userban.liftdate ASC, user.username AS adminname
FROM user AS user
LEFT JOIN userban AS userban ON(userban.userid = user.userid)
LEFT JOIN user AS adminuser ON(adminuser.userid = userban.adminid)
WHERE user.usergroupid IN(8)
ORDER BY userban.liftdate ASC, user.username

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS adminname
FROM user AS user
LEFT JOIN userban AS userban

mysql error number: 1064

--------------

IGNORE ITE sorry found and fixed it feel free to remove this

Glad you sort it out.

Rgds