http://et.splatterladder.com/?mod=serverlist
QUELLTEXT
! SQL QUERY FAILED:
SELECT TSI.IDX, TSI.MESSAGES, TSI.PROTECTION, IF( LENGTH(TSI.MESSAGES) <1 AND TSI.RATINGMSG < 1, TRUE, FALSE ) AS ISRANKED , TSI.SPECRANK+TSI.MOJO AS MYSPECRANK ,TSI.NAME, TSI.RAWNAME, TSI.IP, UNIX_TIMESTAMP()-TSI.LASTRESPONSE, TSI.MODNAME, TSI.MODVERSION, TSI.GAMETYPE, TSI.GAMESTATUS, TSI.MAPTIMELEFT, TSI.GAMEID, TSI.PROTOCOL, TMI.IDX, TMI.MAPNAME ,TMI.CAPTION, TSI.STATUS, TSI.MAXSLOTS, TSI.CURRSLOTS, TSI.PRIVSLOTS, TSI.INVSLOTS, TSI.FLAGS, TSI.OS, TSI.COUNTRY, TSI.REGION, round(TSI.POPULARITY*100) AS POPULARITY, UNIX_TIMESTAMP()-TSI.LASTSCAN AS SCANLEFTTIME, STATUS="I" AS IGN FROM clq_server_info AS TSI, clq_map_info AS TMI WHERE TMI.MAPNAME=TSI.MAPNAME AND TMI.GAMEID=TSI.GAMEID AND TSI.ENABLED="yes" AND TSI.CURRSLOTS0 AND FIND_IN_SET("pb",FLAGS)>0 AND FIND_IN_SET("pw",FLAGS)=0 AND FIND_IN_SET("bt",FLAGS)>0 AND FIND_IN_SET("al",FLAGS)>0 AND FIND_IN_SET("bot",FLAGS)=0 AND TSI.REGION IN ("e") ORDER BY MYSPECRANK DESC, TSI.STATUS DESC, TSI.LASTRESPONSE DESC
BIGINT UNSIGNED value is out of range in '(`sl_et_corr`.`TSI`.`MAXSLOTS` - `sl_et_corr`.`TSI`.`PRIVSLOTS`)'
SELECT TSI.IDX, TSI.MESSAGES, TSI.PROTECTION, IF( LENGTH(TSI.MESSAGES) <1 AND TSI.RATINGMSG < 1, TRUE, FALSE ) AS ISRANKED , TSI.SPECRANK+TSI.MOJO AS MYSPECRANK ,TSI.NAME, TSI.RAWNAME, TSI.IP, UNIX_TIMESTAMP()-TSI.LASTRESPONSE, TSI.MODNAME, TSI.MODVERSION, TSI.GAMETYPE, TSI.GAMESTATUS, TSI.MAPTIMELEFT, TSI.GAMEID, TSI.PROTOCOL, TMI.IDX, TMI.MAPNAME ,TMI.CAPTION, TSI.STATUS, TSI.MAXSLOTS, TSI.CURRSLOTS, TSI.PRIVSLOTS, TSI.INVSLOTS, TSI.FLAGS, TSI.OS, TSI.COUNTRY, TSI.REGION, round(TSI.POPULARITY*100) AS POPULARITY, UNIX_TIMESTAMP()-TSI.LASTSCAN AS SCANLEFTTIME, STATUS="I" AS IGN FROM clq_server_info AS TSI, clq_map_info AS TMI WHERE TMI.MAPNAME=TSI.MAPNAME AND TMI.GAMEID=TSI.GAMEID AND TSI.ENABLED="yes" AND TSI.CURRSLOTS0 AND FIND_IN_SET("pb",FLAGS)>0 AND FIND_IN_SET("pw",FLAGS)=0 AND FIND_IN_SET("bt",FLAGS)>0 AND FIND_IN_SET("al",FLAGS)>0 AND FIND_IN_SET("bot",FLAGS)=0 AND TSI.REGION IN ("e") ORDER BY MYSPECRANK DESC, TSI.STATUS DESC, TSI.LASTRESPONSE DESC
BIGINT UNSIGNED value is out of range in '(`sl_et_corr`.`TSI`.`MAXSLOTS` - `sl_et_corr`.`TSI`.`PRIVSLOTS`)'