SQL Statement failed on preparation: SELECT BA.bid ban_id, BA.type, BA.ip ban_ip, BA.authid, BA.name player_name, created ban_created, ends ban_ends, length ban_length, reason ban_reason, BA.ureason unban_reason, BA.aid, AD.gid AS gid, adminIp, BA.sid ban_server, country ban_country, RemovedOn, RemovedBy, RemoveType row_type, SE.ip server_ip, AD.user admin_name, AD.comment admin_comm, AD.skype admin_skype, AD.vk admin_vk, AD.authid admin_authid, AD.gid, MO.icon as mod_icon, CAST(MID(BA.authid, 9, 1) AS UNSIGNED) + CAST('76561197960265728' AS UNSIGNED) + CAST(MID(BA.authid, 11, 10) * 2 AS UNSIGNED) AS community_id, (SELECT count(*) FROM sb_demos as DM WHERE (DM.demtype='B' or DM.demtype='U') and DM.demid = BA.bid) as demo_count, (SELECT count(*) FROM sb_bans as BH WHERE (BH.type = BA.type AND BH.type = 0 AND BH.authid = BA.authid AND BH.authid != '' AND BH.authid IS NOT NULL) OR (BH.type = BA.type AND BH.type = 1 AND BH.ip = BA.ip AND BH.ip != '' AND BH.ip IS NOT NULL)) as history_count FROM sb_bans AS BA LEFT JOIN sb_servers AS SE ON SE.sid = BA.sid LEFT JOIN sb_mods AS MO on SE.modid = MO.mid LEFT JOIN sb_admins AS AD ON BA.aid = AD.aid WHERE BA.ip LIKE ? OR BA.authid LIKE ? or BA.name LIKE ? or BA.reason LIKE ? ORDER BY BA.created DESC LIMIT ?,?'
SQL Statement failed on preparation: SELECT count(BA.bid) FROM sb_bans AS BA WHERE BA.ip LIKE ? OR BA.authid LIKE ? OR BA.name LIKE ? OR BA.reason LIKE ?'
Баны не найдены.