[Phalynx]

Originally Posted by pedroenf

But i do not have no ' in any tittle. My forum is portuguese and we use ? and ? and ?. But none of this show in mysql errors.

The ' is reserved for use in SQL statements. It's just missing an addslash command to avoid this. Fixed in final 4.0.2

Originally Posted by WhiskeyOSS

When we click on ranking we get this error ?

Database error in vBulletin 4.0.6:

Invalid SQL:
SELECT
COUNT(*) AS users
FROM xperience_stats AS x
INNER JOIN user AS u
ON u.userid=x.userid
WHERE 1=1 AND u.userid NOT IN(Bullie44, Whitey);

MySQL Error : Unknown column 'Bullie44' in 'where clause'
Error Number : 1054
Request Date : Thursday, August 19th 2010 @ 06:48:44 PM
Error Date : Thursday, August 19th 2010 @ 06:48:44 PM
Script : http://www.teamsrgaming.com/forums/x...php?go=ranking
Referrer : http://www.teamsrgaming.com/forums/xperience.php
IP Address : 76.11.220.172
Username : WhiskeySR
Classname : vB_Database
MySQL Version : 5.0.91-log

Don't enter the username for the users beeing ignored. You will have to enter the UserID!

Originally Posted by Veer

Phalynx, Promotion system still need to be updated, promotion / demotion both not working plus getting database error when remove all promotions.

Any idea when it will be updated?

Fixed in final.
Also, promotions are working - what are you missing here? Demotions need a workaroung by doing it with an extra thing.