When I go to try to limit the Admin from not being included in the stats it has a database error. Please advise.
This is the error I get:
PHP Code:
Database error in vBulletin 4.2.0:
Invalid SQL:
SELECT
u.userid,
points_threads+points_thread_votes+points_thread_replycount+points_thread_views+points_thread_stickies+points_thread_tags+points_posts+points_post_attachment
AS get_count
FROM xperience_stats as s
INNER JOIN user as u ON u.userid = s.userid
WHERE 1 = 1 AND u.userid NOT IN(1,) AND NOT (1=2 OR u.usergroupid = '6' OR FIND_IN_SET(6, u.membergroupids))
ORDER BY get_count DESC, points_xperience DESC
LIMIT 0,1;
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 ') AND NOT (1=2 OR u.usergroupid = '6' OR FIND_IN_SET(6, u.membergroupids))
' at line 7
Error Number : 1064
Request Date : Sunday, July 1st 2012 @ 07:54:04 PM
Error Date : Sunday, July 1st 2012 @ 07:54:04 PM