Ayuda con paginaweb en el ranking

Topic created · 3 Posts · 407 Views
  • 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

Log in to reply