[GR Matticus]

Hi there.

Thanks for the mod.

I have an issue when clicking the "Ranking" tab under the Experience header.

Database error:

Database error in vBulletin 4.0.4:

Invalid SQL:
SELECT
		COUNT(*) AS users
		FROM vbu4xperience_stats AS x
		INNER JOIN vbu4user AS u
		ON u.userid=x.userid 
		WHERE 1=1 AND u.userid NOT IN(News Bot);

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 'Bot)' at line 6
Error Number  : 1064
Request Date  : Sunday, July 11th 2010 @ 03:18:00 PM
Error Date    : Sunday, July 11th 2010 @ 03:18:00 PM
Script        : http://www.gamersrest.com/xperience.php?go=ranking
Referrer      : http://www.gamersrest.com/xperience.php
IP Address    : 92.238.98.110
Username      : GR Matticus
Classname     : vB_Database
MySQL Version : 5.0.91-community

I had to run an SQL query to fix a bug with vBulletin and not sure if this might of caused this?

Thanks.

EDIT: User error, I entered "News Bot" in the ignore users list and not the users ID. Now working ok. Sorry!