Ayuda con paginaweb en el ranking
-
hola este es el problema alguien que me ayude. uso la pagina MT2-CMS Y cliente Daroo
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\includes-public\classement.php on line 119
Erreur SQL !
SELECT account_id,name,level,level_step,exp,job,skill_group FROM player WHERE name NOT IN(SELECT mName FROM common.gmlist) ORDER BY level DESC, exp DESC LIMIT 0, 1000
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (big5_chinese_ci,IMPLICIT) for operation '=' -
cambia WHERE name NOT IN(SELECT mName FROM common.gmlist) por WHERE name NOT LIKE '%[%' y a los pjs gm/ adm etc le tienes que poner lo de [ ej: [ADM]
-
sigue igual