Debug
Table 'stats1.bans_banhistory' doesn't exist
SQL Query type: EXECUTE
Script: '/bans/index.php'
SQL Query: SELECT SE.ip as server_ip ,SE.port as server_port ,MO.icon as mod_icon ,AD.user as admin_name ,BN.* FROM ( SELECT 'B' as row_type ,BA.bid as ban_id ,BA.ip as ban_ip ,BA.authid as authid ,BA.name as player_name ,BA.created as ban_created ,BA.ends as ban_ends ,BA.length as ban_length ,BA.reason as ban_reason ,BA.aid as ban_admin ,BA.sid as ban_server ,BA.country as ban_country ,(SELECT (SELECT count(*) from bans_banhistory as BH WHERE BH.authid=BA.authid) + (SELECT count(*) from bans_bans as BaH WHERE BaH.authid=BA.authid)) as history_count ,(SELECT count(*) FROM bans_demos as DM WHERE DM.demtype='B' and DM.demid=BA.bid) as demo_count FROM bans_bans as BA -- WHERE (`length` = '0' OR `ends` > UNIX_TIMESTAMP()) UNION SELECT 'U' as row_type ,BH.HistId as ban_id ,BH.ip as ban_ip ,BH.authid as authid ,BH.name as player_name ,BH.created as ban_created ,BH.ends as ban_ends ,BH.length as ban_length ,BH.reason as ban_reason ,BH.adminid as ban_admin ,BH.sid as ban_server ,BH.country as ban_country ,(SELECT (SELECT count(*) from bans_banhistory as BH2 WHERE BH2.authid=BH.authid) + (SELECT count(*) from bans_bans as BaH2 WHERE BaH2.authid=BH.authid)) as history_count ,(SELECT count(*) FROM bans_demos as DM WHERE DM.demtype='B' and DM.demid=BH.HistId) as demo_count FROM bans_banhistory BH ) as BN LEFT JOIN bans_servers AS SE ON BN.ban_server = SE.sid LEFT JOIN bans_mods AS MO on SE.modid = MO.mid LEFT JOIN bans_admins AS AD ON BN.ban_admin=AD.aid ORDER BY ban_created DESC LIMIT 0,30
SQL Params:
SQL Query type: EXECUTE
Script: '/bans/index.php'
SQL Query: SELECT SE.ip as server_ip ,SE.port as server_port ,MO.icon as mod_icon ,AD.user as admin_name ,BN.* FROM ( SELECT 'B' as row_type ,BA.bid as ban_id ,BA.ip as ban_ip ,BA.authid as authid ,BA.name as player_name ,BA.created as ban_created ,BA.ends as ban_ends ,BA.length as ban_length ,BA.reason as ban_reason ,BA.aid as ban_admin ,BA.sid as ban_server ,BA.country as ban_country ,(SELECT (SELECT count(*) from bans_banhistory as BH WHERE BH.authid=BA.authid) + (SELECT count(*) from bans_bans as BaH WHERE BaH.authid=BA.authid)) as history_count ,(SELECT count(*) FROM bans_demos as DM WHERE DM.demtype='B' and DM.demid=BA.bid) as demo_count FROM bans_bans as BA -- WHERE (`length` = '0' OR `ends` > UNIX_TIMESTAMP()) UNION SELECT 'U' as row_type ,BH.HistId as ban_id ,BH.ip as ban_ip ,BH.authid as authid ,BH.name as player_name ,BH.created as ban_created ,BH.ends as ban_ends ,BH.length as ban_length ,BH.reason as ban_reason ,BH.adminid as ban_admin ,BH.sid as ban_server ,BH.country as ban_country ,(SELECT (SELECT count(*) from bans_banhistory as BH2 WHERE BH2.authid=BH.authid) + (SELECT count(*) from bans_bans as BaH2 WHERE BaH2.authid=BH.authid)) as history_count ,(SELECT count(*) FROM bans_demos as DM WHERE DM.demtype='B' and DM.demid=BH.HistId) as demo_count FROM bans_banhistory BH ) as BN LEFT JOIN bans_servers AS SE ON BN.ban_server = SE.sid LEFT JOIN bans_mods AS MO on SE.modid = MO.mid LEFT JOIN bans_admins AS AD ON BN.ban_admin=AD.aid ORDER BY ban_created DESC LIMIT 0,30
SQL Params:
Table 'stats1.bans_banhistory' doesn't exist
SQL Query type: EXECUTE
Script: '/bans/index.php'
SQL Query: SELECT (count(bid) + (SELECT count(HistId) FROM bans_banhistory)) FROM bans_bans WHERE `length` = '0' OR `ends` > UNIX_TIMESTAMP()
SQL Params:
No Bans Found. SQL Query type: EXECUTE
Script: '/bans/index.php'
SQL Query: SELECT (count(bid) + (SELECT count(HistId) FROM bans_banhistory)) FROM bans_bans WHERE `length` = '0' OR `ends` > UNIX_TIMESTAMP()
SQL Params:
