In mysql_stmt_prepare() id: 1, sql: "DELETE FROM ip_banned WHERE unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 2, sql: "UPDATE account_banned SET active = 0 WHERE active = 1 AND unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 3, sql: "(SELECT unbandate > UNIX_TIMESTAMP() OR unbandate = bandate AS banned, NULL as country FROM ip_banned WHERE ip = ?) UNION (SELECT NULL AS banned, country FROM ip2nation WHERE INET_NTOA(ip) = ?)"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 4, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban')"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 7, sql: "DELETE FROM account_banned WHERE id = ?"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 8, sql: "UPDATE account SET sessionkey = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 9, sql: "SELECT username, sessionkey FROM account WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 10, sql: "UPDATE account SET v = ?, s = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 14, sql: "SELECT a.id, a.sessionkey, ba.last_ip, ba.locked, ba.lock_country, a.expansion, a.mutetime, ba.locale, a.recruiter, a.os, ba.id, ba.email, aa.gmLevel, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, ab.unbandate > UNIX_TIMESTAMP() OR ab.unbandate = ab.bandate, r.id FROM account a LEFT JOIN account r ON a.id = r.recruiter LEFT JOIN battlenet_accounts ba ON a.battlenet_account = ba.id LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID IN (-1, ?) LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 WHERE a.username = ? ORDER BY aa.RealmID DESC LIMIT 1"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 17, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?)"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 18, sql: "DELETE FROM ip_banned WHERE ip = ?"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 22, sql: "INSERT INTO account_banned VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?, 1)"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 23, sql: "UPDATE account_banned SET active = 0 WHERE id = ? AND active != 0"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 24, sql: "DELETE FROM realmcharacters WHERE acctid = ? AND realmid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 25, sql: "DELETE FROM realmcharacters WHERE acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 26, sql: "INSERT INTO realmcharacters (numchars, acctid, realmid) VALUES (?, ?, ?)"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 27, sql: "SELECT SUM(numchars) FROM realmcharacters WHERE acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 29, sql: "INSERT INTO realmcharacters (realmid, acctid, numchars) SELECT realmlist.id, account.id, 0 FROM realmlist, account LEFT JOIN realmcharacters ON acctid=account.id WHERE acctid IS NULL"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 30, sql: "UPDATE account SET expansion = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 31, sql: "UPDATE account SET locked = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 32, sql: "UPDATE account SET lock_country = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 33, sql: "INSERT INTO logs (time, realm, type, level, string) VALUES (?, ?, ?, ?, ?)"
Table 'auth.logs' doesn't exist
In mysql_stmt_prepare() id: 34, sql: "UPDATE account SET v = 0, s = 0, username = ?, sha_pass_hash = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 35, sql: "UPDATE account SET v = 0, s = 0, sha_pass_hash = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 36, sql: "UPDATE account SET email = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 37, sql: "UPDATE account SET reg_mail = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 38, sql: "UPDATE account SET mutetime = ? , mutereason = ? , muteby = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 39, sql: "UPDATE account SET mutetime = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 40, sql: "UPDATE account SET last_ip = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 41, sql: "UPDATE account SET last_attempt_ip = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 42, sql: "UPDATE account SET online = 1 WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 43, sql: "UPDATE uptime SET uptime = ?, maxplayers = ? WHERE realmid = ? AND starttime = ?"
Table 'auth.uptime' doesn't exist
In mysql_stmt_prepare() id: 44, sql: "DELETE FROM logs WHERE (time + ?) < ? AND realm = ?"
Table 'auth.logs' doesn't exist
In mysql_stmt_prepare() id: 45, sql: "DELETE FROM account_access WHERE id = ?"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 46, sql: "DELETE FROM account_access WHERE id = ? AND (RealmID = ? OR RealmID = -1)"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 47, sql: "INSERT INTO account_access (id,gmlevel,RealmID) VALUES (?, ?, ?)"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 62, sql: "DELETE FROM account WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 68, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, (SELECT last_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 69, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, (SELECT last_attempt_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 70, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, ?, ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 71, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, 0, 1, ?, ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 73, sql: "SELECT permissionId, granted FROM rbac_account_permissions WHERE accountId = ? AND (realmId = ? OR realmId = -1) ORDER BY permissionId, realmId"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 74, sql: "INSERT INTO rbac_account_permissions (accountId, permissionId, granted, realmId) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE granted = VALUES(granted)"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 75, sql: "DELETE FROM rbac_account_permissions WHERE accountId = ? AND permissionId = ? AND (realmId = ? OR realmId = -1)"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 76, sql: "INSERT INTO account_muted VALUES (?, UNIX_TIMESTAMP(), ?, ?, ?)"
Table 'auth.account_muted' doesn't exist
In mysql_stmt_prepare() id: 78, sql: "DELETE FROM account_muted WHERE guid = ?"
Table 'auth.account_muted' doesn't exist
In mysql_stmt_prepare() id: 79, sql: "SELECT ba.id, ba.sha_pass_hash, ba.failed_logins, ba.LoginTicket, ba.LoginTicketExpiry, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id WHERE email = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 80, sql: "UPDATE battlenet_accounts SET LoginTicket = ?, LoginTicketExpiry = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 81, sql: "SELECT LoginTicketExpiry FROM battlenet_accounts WHERE LoginTicket = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 82, sql: "UPDATE battlenet_accounts SET LoginTicketExpiry = ? WHERE LoginTicket = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 83, sql: "SELECT ba.id, UPPER(ba.email), ba.locked, ba.lock_country, ba.last_ip, ba.LoginTicketExpiry, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, bab.unbandate = bab.bandate, a.id, a.username, ab.unbandate, ab.unbandate = ab.bandate, aa.gmlevel FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account a ON ba.id = a.battlenet_account LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID = -1 WHERE ba.LoginTicket = ? ORDER BY a.id"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 84, sql: "UPDATE battlenet_accounts SET last_ip = ?, last_login = NOW(), locale = ?, failed_logins = 0, os = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 86, sql: "SELECT rc.acctid, rc.numchars, r.id, r.Region, r.Battlegroup FROM realmcharacters rc INNER JOIN realmlist r ON rc.realmid = r.id WHERE rc.acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 87, sql: "SELECT rc.acctid, rc.numchars, r.id, r.Region, r.Battlegroup FROM realmcharacters rc INNER JOIN realmlist r ON rc.realmid = r.id LEFT JOIN account a ON rc.acctid = a.id WHERE a.battlenet_account = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 88, sql: "SELECT lpc.accountId, lpc.region, lpc.battlegroup, lpc.realmId, lpc.characterName, lpc.characterGUID, lpc.lastPlayedTime FROM account_last_played_character lpc LEFT JOIN account a ON lpc.accountId = a.id WHERE a.battlenet_account = ?"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 89, sql: "DELETE FROM account_last_played_character WHERE accountId = ? AND region = ? AND battlegroup = ?"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 90, sql: "INSERT INTO account_last_played_character (accountId, region, battlegroup, realmId, characterName, characterGUID, lastPlayedTime) VALUES (?,?,?,?,?,?,?)"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 94, sql: "UPDATE battlenet_accounts SET sha_pass_hash = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 96, sql: "UPDATE battlenet_accounts SET locked = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 97, sql: "UPDATE battlenet_accounts SET lock_country = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 99, sql: "UPDATE account SET battlenet_account = ?, battlenet_index = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 102, sql: "SELECT a.username, a.expansion, ab.bandate, ab.unbandate, ab.banreason FROM account AS a LEFT JOIN account_banned AS ab ON a.id = ab.id AND ab.active = 1 INNER JOIN battlenet_accounts AS ba ON a.battlenet_account = ba.id WHERE ba.LoginTicket = ? ORDER BY a.id"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 103, sql: "UPDATE battlenet_accounts SET failed_logins = failed_logins + 1 WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 104, sql: "INSERT INTO battlenet_account_bans(id, bandate, unbandate, bannedby, banreason) VALUES(?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban')"
Table 'auth.battlenet_account_bans' doesn't exist
In mysql_stmt_prepare() id: 105, sql: "DELETE FROM battlenet_account_bans WHERE unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.battlenet_account_bans' doesn't exist
In mysql_stmt_prepare() id: 106, sql: "UPDATE battlenet_accounts SET failed_logins = 0 WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 107, sql: "SELECT LastCharacterUndelete FROM battlenet_accounts WHERE Id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 108, sql: "UPDATE battlenet_accounts SET LastCharacterUndelete = UNIX_TIMESTAMP() WHERE Id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 109, sql: "SELECT itemId, isFavourite FROM battlenet_account_toys WHERE accountId = ?"
Table 'auth.battlenet_account_toys' doesn't exist
In mysql_stmt_prepare() id: 110, sql: "REPLACE INTO battlenet_account_toys (accountId, itemId, isFavourite) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_toys' doesn't exist
In mysql_stmt_prepare() id: 111, sql: "SELECT guid, species, breed, level, exp, health, quality, flags, name FROM battle_pets WHERE battlenetAccountId = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 112, sql: "INSERT INTO battle_pets (guid, battlenetAccountId, species, breed, level, exp, health, quality, flags, name) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 113, sql: "DELETE FROM battle_pets WHERE battlenetAccountId = ? AND guid = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 114, sql: "UPDATE battle_pets SET level = ?, exp = ?, health = ?, quality = ?, flags = ?, name = ? WHERE battlenetAccountId = ? AND guid = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 115, sql: "SELECT id, battlePetGuid, locked FROM battle_pet_slots WHERE battlenetAccountId = ?"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 116, sql: "INSERT INTO battle_pet_slots (id, battlenetAccountId, battlePetGuid, locked) VALUES (?, ?, ?, ?)"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 117, sql: "DELETE FROM battle_pet_slots WHERE battlenetAccountId = ?"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 118, sql: "SELECT itemId, flags FROM battlenet_account_heirlooms WHERE accountId = ?"
Table 'auth.battlenet_account_heirlooms' doesn't exist
In mysql_stmt_prepare() id: 119, sql: "REPLACE INTO battlenet_account_heirlooms (accountId, itemId, flags) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_heirlooms' doesn't exist
In mysql_stmt_prepare() id: 120, sql: "SELECT mountSpellId, flags FROM battlenet_account_mounts WHERE battlenetAccountId = ?"
Table 'auth.battlenet_account_mounts' doesn't exist
In mysql_stmt_prepare() id: 121, sql: "REPLACE INTO battlenet_account_mounts (battlenetAccountId, mountSpellId, flags) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_mounts' doesn't exist
In mysql_stmt_prepare() id: 122, sql: "SELECT blobIndex, appearanceMask FROM battlenet_item_appearances WHERE battlenetAccountId = ? ORDER BY blobIndex DESC"
Table 'auth.battlenet_item_appearances' doesn't exist
In mysql_stmt_prepare() id: 123, sql: "INSERT INTO battlenet_item_appearances (battlenetAccountId, blobIndex, appearanceMask) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE appearanceMask = appearanceMask | VALUES(appearanceMask)"
Table 'auth.battlenet_item_appearances' doesn't exist
In mysql_stmt_prepare() id: 124, sql: "SELECT itemModifiedAppearanceId FROM battlenet_item_favorite_appearances WHERE battlenetAccountId = ?"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 125, sql: "INSERT INTO battlenet_item_favorite_appearances (battlenetAccountId, itemModifiedAppearanceId) VALUES (?, ?)"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 126, sql: "DELETE FROM battlenet_item_favorite_appearances WHERE battlenetAccountId = ? AND itemModifiedAppearanceId = ?"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 1, sql: "DELETE FROM ip_banned WHERE unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 2, sql: "UPDATE account_banned SET active = 0 WHERE active = 1 AND unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 3, sql: "(SELECT unbandate > UNIX_TIMESTAMP() OR unbandate = bandate AS banned, NULL as country FROM ip_banned WHERE ip = ?) UNION (SELECT NULL AS banned, country FROM ip2nation WHERE INET_NTOA(ip) = ?)"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 4, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban')"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 7, sql: "DELETE FROM account_banned WHERE id = ?"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 8, sql: "UPDATE account SET sessionkey = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 9, sql: "SELECT username, sessionkey FROM account WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 10, sql: "UPDATE account SET v = ?, s = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 14, sql: "SELECT a.id, a.sessionkey, ba.last_ip, ba.locked, ba.lock_country, a.expansion, a.mutetime, ba.locale, a.recruiter, a.os, ba.id, ba.email, aa.gmLevel, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, ab.unbandate > UNIX_TIMESTAMP() OR ab.unbandate = ab.bandate, r.id FROM account a LEFT JOIN account r ON a.id = r.recruiter LEFT JOIN battlenet_accounts ba ON a.battlenet_account = ba.id LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID IN (-1, ?) LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 WHERE a.username = ? ORDER BY aa.RealmID DESC LIMIT 1"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 17, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?)"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 18, sql: "DELETE FROM ip_banned WHERE ip = ?"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 22, sql: "INSERT INTO account_banned VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?, 1)"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 23, sql: "UPDATE account_banned SET active = 0 WHERE id = ? AND active != 0"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 24, sql: "DELETE FROM realmcharacters WHERE acctid = ? AND realmid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 25, sql: "DELETE FROM realmcharacters WHERE acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 26, sql: "INSERT INTO realmcharacters (numchars, acctid, realmid) VALUES (?, ?, ?)"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 27, sql: "SELECT SUM(numchars) FROM realmcharacters WHERE acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 29, sql: "INSERT INTO realmcharacters (realmid, acctid, numchars) SELECT realmlist.id, account.id, 0 FROM realmlist, account LEFT JOIN realmcharacters ON acctid=account.id WHERE acctid IS NULL"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 30, sql: "UPDATE account SET expansion = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 31, sql: "UPDATE account SET locked = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 32, sql: "UPDATE account SET lock_country = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 33, sql: "INSERT INTO logs (time, realm, type, level, string) VALUES (?, ?, ?, ?, ?)"
Table 'auth.logs' doesn't exist
In mysql_stmt_prepare() id: 34, sql: "UPDATE account SET v = 0, s = 0, username = ?, sha_pass_hash = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 35, sql: "UPDATE account SET v = 0, s = 0, sha_pass_hash = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 36, sql: "UPDATE account SET email = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 37, sql: "UPDATE account SET reg_mail = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 38, sql: "UPDATE account SET mutetime = ? , mutereason = ? , muteby = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 39, sql: "UPDATE account SET mutetime = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 40, sql: "UPDATE account SET last_ip = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 41, sql: "UPDATE account SET last_attempt_ip = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 42, sql: "UPDATE account SET online = 1 WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 43, sql: "UPDATE uptime SET uptime = ?, maxplayers = ? WHERE realmid = ? AND starttime = ?"
Table 'auth.uptime' doesn't exist
In mysql_stmt_prepare() id: 44, sql: "DELETE FROM logs WHERE (time + ?) < ? AND realm = ?"
Table 'auth.logs' doesn't exist
In mysql_stmt_prepare() id: 45, sql: "DELETE FROM account_access WHERE id = ?"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 46, sql: "DELETE FROM account_access WHERE id = ? AND (RealmID = ? OR RealmID = -1)"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 47, sql: "INSERT INTO account_access (id,gmlevel,RealmID) VALUES (?, ?, ?)"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 62, sql: "DELETE FROM account WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 68, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, (SELECT last_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 69, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, (SELECT last_attempt_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 70, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, ?, ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 71, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, 0, 1, ?, ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 73, sql: "SELECT permissionId, granted FROM rbac_account_permissions WHERE accountId = ? AND (realmId = ? OR realmId = -1) ORDER BY permissionId, realmId"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 74, sql: "INSERT INTO rbac_account_permissions (accountId, permissionId, granted, realmId) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE granted = VALUES(granted)"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 75, sql: "DELETE FROM rbac_account_permissions WHERE accountId = ? AND permissionId = ? AND (realmId = ? OR realmId = -1)"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 76, sql: "INSERT INTO account_muted VALUES (?, UNIX_TIMESTAMP(), ?, ?, ?)"
Table 'auth.account_muted' doesn't exist
In mysql_stmt_prepare() id: 78, sql: "DELETE FROM account_muted WHERE guid = ?"
Table 'auth.account_muted' doesn't exist
In mysql_stmt_prepare() id: 79, sql: "SELECT ba.id, ba.sha_pass_hash, ba.failed_logins, ba.LoginTicket, ba.LoginTicketExpiry, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id WHERE email = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 80, sql: "UPDATE battlenet_accounts SET LoginTicket = ?, LoginTicketExpiry = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 81, sql: "SELECT LoginTicketExpiry FROM battlenet_accounts WHERE LoginTicket = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 82, sql: "UPDATE battlenet_accounts SET LoginTicketExpiry = ? WHERE LoginTicket = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 83, sql: "SELECT ba.id, UPPER(ba.email), ba.locked, ba.lock_country, ba.last_ip, ba.LoginTicketExpiry, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, bab.unbandate = bab.bandate, a.id, a.username, ab.unbandate, ab.unbandate = ab.bandate, aa.gmlevel FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account a ON ba.id = a.battlenet_account LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID = -1 WHERE ba.LoginTicket = ? ORDER BY a.id"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 84, sql: "UPDATE battlenet_accounts SET last_ip = ?, last_login = NOW(), locale = ?, failed_logins = 0, os = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 86, sql: "SELECT rc.acctid, rc.numchars, r.id, r.Region, r.Battlegroup FROM realmcharacters rc INNER JOIN realmlist r ON rc.realmid = r.id WHERE rc.acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 87, sql: "SELECT rc.acctid, rc.numchars, r.id, r.Region, r.Battlegroup FROM realmcharacters rc INNER JOIN realmlist r ON rc.realmid = r.id LEFT JOIN account a ON rc.acctid = a.id WHERE a.battlenet_account = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 88, sql: "SELECT lpc.accountId, lpc.region, lpc.battlegroup, lpc.realmId, lpc.characterName, lpc.characterGUID, lpc.lastPlayedTime FROM account_last_played_character lpc LEFT JOIN account a ON lpc.accountId = a.id WHERE a.battlenet_account = ?"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 89, sql: "DELETE FROM account_last_played_character WHERE accountId = ? AND region = ? AND battlegroup = ?"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 90, sql: "INSERT INTO account_last_played_character (accountId, region, battlegroup, realmId, characterName, characterGUID, lastPlayedTime) VALUES (?,?,?,?,?,?,?)"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 94, sql: "UPDATE battlenet_accounts SET sha_pass_hash = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 96, sql: "UPDATE battlenet_accounts SET locked = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 97, sql: "UPDATE battlenet_accounts SET lock_country = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 99, sql: "UPDATE account SET battlenet_account = ?, battlenet_index = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 102, sql: "SELECT a.username, a.expansion, ab.bandate, ab.unbandate, ab.banreason FROM account AS a LEFT JOIN account_banned AS ab ON a.id = ab.id AND ab.active = 1 INNER JOIN battlenet_accounts AS ba ON a.battlenet_account = ba.id WHERE ba.LoginTicket = ? ORDER BY a.id"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 103, sql: "UPDATE battlenet_accounts SET failed_logins = failed_logins + 1 WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 104, sql: "INSERT INTO battlenet_account_bans(id, bandate, unbandate, bannedby, banreason) VALUES(?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban')"
Table 'auth.battlenet_account_bans' doesn't exist
In mysql_stmt_prepare() id: 105, sql: "DELETE FROM battlenet_account_bans WHERE unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.battlenet_account_bans' doesn't exist
In mysql_stmt_prepare() id: 106, sql: "UPDATE battlenet_accounts SET failed_logins = 0 WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 107, sql: "SELECT LastCharacterUndelete FROM battlenet_accounts WHERE Id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 108, sql: "UPDATE battlenet_accounts SET LastCharacterUndelete = UNIX_TIMESTAMP() WHERE Id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 109, sql: "SELECT itemId, isFavourite FROM battlenet_account_toys WHERE accountId = ?"
Table 'auth.battlenet_account_toys' doesn't exist
In mysql_stmt_prepare() id: 110, sql: "REPLACE INTO battlenet_account_toys (accountId, itemId, isFavourite) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_toys' doesn't exist
In mysql_stmt_prepare() id: 111, sql: "SELECT guid, species, breed, level, exp, health, quality, flags, name FROM battle_pets WHERE battlenetAccountId = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 112, sql: "INSERT INTO battle_pets (guid, battlenetAccountId, species, breed, level, exp, health, quality, flags, name) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 113, sql: "DELETE FROM battle_pets WHERE battlenetAccountId = ? AND guid = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 114, sql: "UPDATE battle_pets SET level = ?, exp = ?, health = ?, quality = ?, flags = ?, name = ? WHERE battlenetAccountId = ? AND guid = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 115, sql: "SELECT id, battlePetGuid, locked FROM battle_pet_slots WHERE battlenetAccountId = ?"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 116, sql: "INSERT INTO battle_pet_slots (id, battlenetAccountId, battlePetGuid, locked) VALUES (?, ?, ?, ?)"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 117, sql: "DELETE FROM battle_pet_slots WHERE battlenetAccountId = ?"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 118, sql: "SELECT itemId, flags FROM battlenet_account_heirlooms WHERE accountId = ?"
Table 'auth.battlenet_account_heirlooms' doesn't exist
In mysql_stmt_prepare() id: 119, sql: "REPLACE INTO battlenet_account_heirlooms (accountId, itemId, flags) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_heirlooms' doesn't exist
In mysql_stmt_prepare() id: 120, sql: "SELECT mountSpellId, flags FROM battlenet_account_mounts WHERE battlenetAccountId = ?"
Table 'auth.battlenet_account_mounts' doesn't exist
In mysql_stmt_prepare() id: 121, sql: "REPLACE INTO battlenet_account_mounts (battlenetAccountId, mountSpellId, flags) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_mounts' doesn't exist
In mysql_stmt_prepare() id: 122, sql: "SELECT blobIndex, appearanceMask FROM battlenet_item_appearances WHERE battlenetAccountId = ? ORDER BY blobIndex DESC"
Table 'auth.battlenet_item_appearances' doesn't exist
In mysql_stmt_prepare() id: 123, sql: "INSERT INTO battlenet_item_appearances (battlenetAccountId, blobIndex, appearanceMask) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE appearanceMask = appearanceMask | VALUES(appearanceMask)"
Table 'auth.battlenet_item_appearances' doesn't exist
In mysql_stmt_prepare() id: 124, sql: "SELECT itemModifiedAppearanceId FROM battlenet_item_favorite_appearances WHERE battlenetAccountId = ?"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 125, sql: "INSERT INTO battlenet_item_favorite_appearances (battlenetAccountId, itemModifiedAppearanceId) VALUES (?, ?)"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 126, sql: "DELETE FROM battlenet_item_favorite_appearances WHERE battlenetAccountId = ? AND itemModifiedAppearanceId = ?"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 1, sql: "DELETE FROM ip_banned WHERE unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 2, sql: "UPDATE account_banned SET active = 0 WHERE active = 1 AND unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 3, sql: "(SELECT unbandate > UNIX_TIMESTAMP() OR unbandate = bandate AS banned, NULL as country FROM ip_banned WHERE ip = ?) UNION (SELECT NULL AS banned, country FROM ip2nation WHERE INET_NTOA(ip) = ?)"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 4, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban')"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 7, sql: "DELETE FROM account_banned WHERE id = ?"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 8, sql: "UPDATE account SET sessionkey = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 9, sql: "SELECT username, sessionkey FROM account WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 10, sql: "UPDATE account SET v = ?, s = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 14, sql: "SELECT a.id, a.sessionkey, ba.last_ip, ba.locked, ba.lock_country, a.expansion, a.mutetime, ba.locale, a.recruiter, a.os, ba.id, ba.email, aa.gmLevel, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, ab.unbandate > UNIX_TIMESTAMP() OR ab.unbandate = ab.bandate, r.id FROM account a LEFT JOIN account r ON a.id = r.recruiter LEFT JOIN battlenet_accounts ba ON a.battlenet_account = ba.id LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID IN (-1, ?) LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 WHERE a.username = ? ORDER BY aa.RealmID DESC LIMIT 1"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 17, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?)"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 18, sql: "DELETE FROM ip_banned WHERE ip = ?"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 22, sql: "INSERT INTO account_banned VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?, 1)"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 23, sql: "UPDATE account_banned SET active = 0 WHERE id = ? AND active != 0"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 24, sql: "DELETE FROM realmcharacters WHERE acctid = ? AND realmid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 25, sql: "DELETE FROM realmcharacters WHERE acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 26, sql: "INSERT INTO realmcharacters (numchars, acctid, realmid) VALUES (?, ?, ?)"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 27, sql: "SELECT SUM(numchars) FROM realmcharacters WHERE acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 29, sql: "INSERT INTO realmcharacters (realmid, acctid, numchars) SELECT realmlist.id, account.id, 0 FROM realmlist, account LEFT JOIN realmcharacters ON acctid=account.id WHERE acctid IS NULL"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 30, sql: "UPDATE account SET expansion = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 31, sql: "UPDATE account SET locked = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 32, sql: "UPDATE account SET lock_country = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 33, sql: "INSERT INTO logs (time, realm, type, level, string) VALUES (?, ?, ?, ?, ?)"
Table 'auth.logs' doesn't exist
In mysql_stmt_prepare() id: 34, sql: "UPDATE account SET v = 0, s = 0, username = ?, sha_pass_hash = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 35, sql: "UPDATE account SET v = 0, s = 0, sha_pass_hash = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 36, sql: "UPDATE account SET email = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 37, sql: "UPDATE account SET reg_mail = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 38, sql: "UPDATE account SET mutetime = ? , mutereason = ? , muteby = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 39, sql: "UPDATE account SET mutetime = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 40, sql: "UPDATE account SET last_ip = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 41, sql: "UPDATE account SET last_attempt_ip = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 42, sql: "UPDATE account SET online = 1 WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 43, sql: "UPDATE uptime SET uptime = ?, maxplayers = ? WHERE realmid = ? AND starttime = ?"
Table 'auth.uptime' doesn't exist
In mysql_stmt_prepare() id: 44, sql: "DELETE FROM logs WHERE (time + ?) < ? AND realm = ?"
Table 'auth.logs' doesn't exist
In mysql_stmt_prepare() id: 45, sql: "DELETE FROM account_access WHERE id = ?"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 46, sql: "DELETE FROM account_access WHERE id = ? AND (RealmID = ? OR RealmID = -1)"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 47, sql: "INSERT INTO account_access (id,gmlevel,RealmID) VALUES (?, ?, ?)"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 62, sql: "DELETE FROM account WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 68, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, (SELECT last_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 69, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, (SELECT last_attempt_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 70, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, ?, ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 71, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, 0, 1, ?, ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 73, sql: "SELECT permissionId, granted FROM rbac_account_permissions WHERE accountId = ? AND (realmId = ? OR realmId = -1) ORDER BY permissionId, realmId"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 74, sql: "INSERT INTO rbac_account_permissions (accountId, permissionId, granted, realmId) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE granted = VALUES(granted)"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 75, sql: "DELETE FROM rbac_account_permissions WHERE accountId = ? AND permissionId = ? AND (realmId = ? OR realmId = -1)"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 76, sql: "INSERT INTO account_muted VALUES (?, UNIX_TIMESTAMP(), ?, ?, ?)"
Table 'auth.account_muted' doesn't exist
In mysql_stmt_prepare() id: 78, sql: "DELETE FROM account_muted WHERE guid = ?"
Table 'auth.account_muted' doesn't exist
In mysql_stmt_prepare() id: 79, sql: "SELECT ba.id, ba.sha_pass_hash, ba.failed_logins, ba.LoginTicket, ba.LoginTicketExpiry, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id WHERE email = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 80, sql: "UPDATE battlenet_accounts SET LoginTicket = ?, LoginTicketExpiry = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 81, sql: "SELECT LoginTicketExpiry FROM battlenet_accounts WHERE LoginTicket = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 82, sql: "UPDATE battlenet_accounts SET LoginTicketExpiry = ? WHERE LoginTicket = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 83, sql: "SELECT ba.id, UPPER(ba.email), ba.locked, ba.lock_country, ba.last_ip, ba.LoginTicketExpiry, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, bab.unbandate = bab.bandate, a.id, a.username, ab.unbandate, ab.unbandate = ab.bandate, aa.gmlevel FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account a ON ba.id = a.battlenet_account LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID = -1 WHERE ba.LoginTicket = ? ORDER BY a.id"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 84, sql: "UPDATE battlenet_accounts SET last_ip = ?, last_login = NOW(), locale = ?, failed_logins = 0, os = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 86, sql: "SELECT rc.acctid, rc.numchars, r.id, r.Region, r.Battlegroup FROM realmcharacters rc INNER JOIN realmlist r ON rc.realmid = r.id WHERE rc.acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 87, sql: "SELECT rc.acctid, rc.numchars, r.id, r.Region, r.Battlegroup FROM realmcharacters rc INNER JOIN realmlist r ON rc.realmid = r.id LEFT JOIN account a ON rc.acctid = a.id WHERE a.battlenet_account = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 88, sql: "SELECT lpc.accountId, lpc.region, lpc.battlegroup, lpc.realmId, lpc.characterName, lpc.characterGUID, lpc.lastPlayedTime FROM account_last_played_character lpc LEFT JOIN account a ON lpc.accountId = a.id WHERE a.battlenet_account = ?"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 89, sql: "DELETE FROM account_last_played_character WHERE accountId = ? AND region = ? AND battlegroup = ?"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 90, sql: "INSERT INTO account_last_played_character (accountId, region, battlegroup, realmId, characterName, characterGUID, lastPlayedTime) VALUES (?,?,?,?,?,?,?)"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 94, sql: "UPDATE battlenet_accounts SET sha_pass_hash = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 96, sql: "UPDATE battlenet_accounts SET locked = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 97, sql: "UPDATE battlenet_accounts SET lock_country = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 99, sql: "UPDATE account SET battlenet_account = ?, battlenet_index = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 102, sql: "SELECT a.username, a.expansion, ab.bandate, ab.unbandate, ab.banreason FROM account AS a LEFT JOIN account_banned AS ab ON a.id = ab.id AND ab.active = 1 INNER JOIN battlenet_accounts AS ba ON a.battlenet_account = ba.id WHERE ba.LoginTicket = ? ORDER BY a.id"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 103, sql: "UPDATE battlenet_accounts SET failed_logins = failed_logins + 1 WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 104, sql: "INSERT INTO battlenet_account_bans(id, bandate, unbandate, bannedby, banreason) VALUES(?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban')"
Table 'auth.battlenet_account_bans' doesn't exist
In mysql_stmt_prepare() id: 105, sql: "DELETE FROM battlenet_account_bans WHERE unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.battlenet_account_bans' doesn't exist
In mysql_stmt_prepare() id: 106, sql: "UPDATE battlenet_accounts SET failed_logins = 0 WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 107, sql: "SELECT LastCharacterUndelete FROM battlenet_accounts WHERE Id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 108, sql: "UPDATE battlenet_accounts SET LastCharacterUndelete = UNIX_TIMESTAMP() WHERE Id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 109, sql: "SELECT itemId, isFavourite FROM battlenet_account_toys WHERE accountId = ?"
Table 'auth.battlenet_account_toys' doesn't exist
In mysql_stmt_prepare() id: 110, sql: "REPLACE INTO battlenet_account_toys (accountId, itemId, isFavourite) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_toys' doesn't exist
In mysql_stmt_prepare() id: 111, sql: "SELECT guid, species, breed, level, exp, health, quality, flags, name FROM battle_pets WHERE battlenetAccountId = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 112, sql: "INSERT INTO battle_pets (guid, battlenetAccountId, species, breed, level, exp, health, quality, flags, name) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 113, sql: "DELETE FROM battle_pets WHERE battlenetAccountId = ? AND guid = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 114, sql: "UPDATE battle_pets SET level = ?, exp = ?, health = ?, quality = ?, flags = ?, name = ? WHERE battlenetAccountId = ? AND guid = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 115, sql: "SELECT id, battlePetGuid, locked FROM battle_pet_slots WHERE battlenetAccountId = ?"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 116, sql: "INSERT INTO battle_pet_slots (id, battlenetAccountId, battlePetGuid, locked) VALUES (?, ?, ?, ?)"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 117, sql: "DELETE FROM battle_pet_slots WHERE battlenetAccountId = ?"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 118, sql: "SELECT itemId, flags FROM battlenet_account_heirlooms WHERE accountId = ?"
Table 'auth.battlenet_account_heirlooms' doesn't exist
In mysql_stmt_prepare() id: 119, sql: "REPLACE INTO battlenet_account_heirlooms (accountId, itemId, flags) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_heirlooms' doesn't exist
In mysql_stmt_prepare() id: 120, sql: "SELECT mountSpellId, flags FROM battlenet_account_mounts WHERE battlenetAccountId = ?"
Table 'auth.battlenet_account_mounts' doesn't exist
In mysql_stmt_prepare() id: 121, sql: "REPLACE INTO battlenet_account_mounts (battlenetAccountId, mountSpellId, flags) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_mounts' doesn't exist
In mysql_stmt_prepare() id: 122, sql: "SELECT blobIndex, appearanceMask FROM battlenet_item_appearances WHERE battlenetAccountId = ? ORDER BY blobIndex DESC"
Table 'auth.battlenet_item_appearances' doesn't exist
In mysql_stmt_prepare() id: 123, sql: "INSERT INTO battlenet_item_appearances (battlenetAccountId, blobIndex, appearanceMask) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE appearanceMask = appearanceMask | VALUES(appearanceMask)"
Table 'auth.battlenet_item_appearances' doesn't exist
In mysql_stmt_prepare() id: 124, sql: "SELECT itemModifiedAppearanceId FROM battlenet_item_favorite_appearances WHERE battlenetAccountId = ?"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 125, sql: "INSERT INTO battlenet_item_favorite_appearances (battlenetAccountId, itemModifiedAppearanceId) VALUES (?, ?)"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 126, sql: "DELETE FROM battlenet_item_favorite_appearances WHERE battlenetAccountId = ? AND itemModifiedAppearanceId = ?"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 1, sql: "DELETE FROM ip_banned WHERE unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 2, sql: "UPDATE account_banned SET active = 0 WHERE active = 1 AND unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 3, sql: "(SELECT unbandate > UNIX_TIMESTAMP() OR unbandate = bandate AS banned, NULL as country FROM ip_banned WHERE ip = ?) UNION (SELECT NULL AS banned, country FROM ip2nation WHERE INET_NTOA(ip) = ?)"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 4, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban')"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 7, sql: "DELETE FROM account_banned WHERE id = ?"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 8, sql: "UPDATE account SET sessionkey = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 9, sql: "SELECT username, sessionkey FROM account WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 10, sql: "UPDATE account SET v = ?, s = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 14, sql: "SELECT a.id, a.sessionkey, ba.last_ip, ba.locked, ba.lock_country, a.expansion, a.mutetime, ba.locale, a.recruiter, a.os, ba.id, ba.email, aa.gmLevel, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, ab.unbandate > UNIX_TIMESTAMP() OR ab.unbandate = ab.bandate, r.id FROM account a LEFT JOIN account r ON a.id = r.recruiter LEFT JOIN battlenet_accounts ba ON a.battlenet_account = ba.id LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID IN (-1, ?) LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 WHERE a.username = ? ORDER BY aa.RealmID DESC LIMIT 1"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 17, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?)"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 18, sql: "DELETE FROM ip_banned WHERE ip = ?"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 22, sql: "INSERT INTO account_banned VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?, 1)"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 23, sql: "UPDATE account_banned SET active = 0 WHERE id = ? AND active != 0"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 24, sql: "DELETE FROM realmcharacters WHERE acctid = ? AND realmid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 25, sql: "DELETE FROM realmcharacters WHERE acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 26, sql: "INSERT INTO realmcharacters (numchars, acctid, realmid) VALUES (?, ?, ?)"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 27, sql: "SELECT SUM(numchars) FROM realmcharacters WHERE acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 29, sql: "INSERT INTO realmcharacters (realmid, acctid, numchars) SELECT realmlist.id, account.id, 0 FROM realmlist, account LEFT JOIN realmcharacters ON acctid=account.id WHERE acctid IS NULL"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 30, sql: "UPDATE account SET expansion = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 31, sql: "UPDATE account SET locked = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 32, sql: "UPDATE account SET lock_country = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 33, sql: "INSERT INTO logs (time, realm, type, level, string) VALUES (?, ?, ?, ?, ?)"
Table 'auth.logs' doesn't exist
In mysql_stmt_prepare() id: 34, sql: "UPDATE account SET v = 0, s = 0, username = ?, sha_pass_hash = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 35, sql: "UPDATE account SET v = 0, s = 0, sha_pass_hash = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 36, sql: "UPDATE account SET email = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 37, sql: "UPDATE account SET reg_mail = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 38, sql: "UPDATE account SET mutetime = ? , mutereason = ? , muteby = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 39, sql: "UPDATE account SET mutetime = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 40, sql: "UPDATE account SET last_ip = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 41, sql: "UPDATE account SET last_attempt_ip = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 42, sql: "UPDATE account SET online = 1 WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 43, sql: "UPDATE uptime SET uptime = ?, maxplayers = ? WHERE realmid = ? AND starttime = ?"
Table 'auth.uptime' doesn't exist
In mysql_stmt_prepare() id: 44, sql: "DELETE FROM logs WHERE (time + ?) < ? AND realm = ?"
Table 'auth.logs' doesn't exist
In mysql_stmt_prepare() id: 45, sql: "DELETE FROM account_access WHERE id = ?"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 46, sql: "DELETE FROM account_access WHERE id = ? AND (RealmID = ? OR RealmID = -1)"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 47, sql: "INSERT INTO account_access (id,gmlevel,RealmID) VALUES (?, ?, ?)"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 62, sql: "DELETE FROM account WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 68, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, (SELECT last_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 69, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, (SELECT last_attempt_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 70, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, ?, ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 71, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, 0, 1, ?, ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 73, sql: "SELECT permissionId, granted FROM rbac_account_permissions WHERE accountId = ? AND (realmId = ? OR realmId = -1) ORDER BY permissionId, realmId"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 74, sql: "INSERT INTO rbac_account_permissions (accountId, permissionId, granted, realmId) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE granted = VALUES(granted)"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 75, sql: "DELETE FROM rbac_account_permissions WHERE accountId = ? AND permissionId = ? AND (realmId = ? OR realmId = -1)"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 76, sql: "INSERT INTO account_muted VALUES (?, UNIX_TIMESTAMP(), ?, ?, ?)"
Table 'auth.account_muted' doesn't exist
In mysql_stmt_prepare() id: 78, sql: "DELETE FROM account_muted WHERE guid = ?"
Table 'auth.account_muted' doesn't exist
In mysql_stmt_prepare() id: 79, sql: "SELECT ba.id, ba.sha_pass_hash, ba.failed_logins, ba.LoginTicket, ba.LoginTicketExpiry, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id WHERE email = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 80, sql: "UPDATE battlenet_accounts SET LoginTicket = ?, LoginTicketExpiry = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 81, sql: "SELECT LoginTicketExpiry FROM battlenet_accounts WHERE LoginTicket = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 82, sql: "UPDATE battlenet_accounts SET LoginTicketExpiry = ? WHERE LoginTicket = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 83, sql: "SELECT ba.id, UPPER(ba.email), ba.locked, ba.lock_country, ba.last_ip, ba.LoginTicketExpiry, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, bab.unbandate = bab.bandate, a.id, a.username, ab.unbandate, ab.unbandate = ab.bandate, aa.gmlevel FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account a ON ba.id = a.battlenet_account LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID = -1 WHERE ba.LoginTicket = ? ORDER BY a.id"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 84, sql: "UPDATE battlenet_accounts SET last_ip = ?, last_login = NOW(), locale = ?, failed_logins = 0, os = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 86, sql: "SELECT rc.acctid, rc.numchars, r.id, r.Region, r.Battlegroup FROM realmcharacters rc INNER JOIN realmlist r ON rc.realmid = r.id WHERE rc.acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 87, sql: "SELECT rc.acctid, rc.numchars, r.id, r.Region, r.Battlegroup FROM realmcharacters rc INNER JOIN realmlist r ON rc.realmid = r.id LEFT JOIN account a ON rc.acctid = a.id WHERE a.battlenet_account = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 88, sql: "SELECT lpc.accountId, lpc.region, lpc.battlegroup, lpc.realmId, lpc.characterName, lpc.characterGUID, lpc.lastPlayedTime FROM account_last_played_character lpc LEFT JOIN account a ON lpc.accountId = a.id WHERE a.battlenet_account = ?"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 89, sql: "DELETE FROM account_last_played_character WHERE accountId = ? AND region = ? AND battlegroup = ?"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 90, sql: "INSERT INTO account_last_played_character (accountId, region, battlegroup, realmId, characterName, characterGUID, lastPlayedTime) VALUES (?,?,?,?,?,?,?)"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 94, sql: "UPDATE battlenet_accounts SET sha_pass_hash = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 96, sql: "UPDATE battlenet_accounts SET locked = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 97, sql: "UPDATE battlenet_accounts SET lock_country = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 99, sql: "UPDATE account SET battlenet_account = ?, battlenet_index = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 102, sql: "SELECT a.username, a.expansion, ab.bandate, ab.unbandate, ab.banreason FROM account AS a LEFT JOIN account_banned AS ab ON a.id = ab.id AND ab.active = 1 INNER JOIN battlenet_accounts AS ba ON a.battlenet_account = ba.id WHERE ba.LoginTicket = ? ORDER BY a.id"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 103, sql: "UPDATE battlenet_accounts SET failed_logins = failed_logins + 1 WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 104, sql: "INSERT INTO battlenet_account_bans(id, bandate, unbandate, bannedby, banreason) VALUES(?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban')"
Table 'auth.battlenet_account_bans' doesn't exist
In mysql_stmt_prepare() id: 105, sql: "DELETE FROM battlenet_account_bans WHERE unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.battlenet_account_bans' doesn't exist
In mysql_stmt_prepare() id: 106, sql: "UPDATE battlenet_accounts SET failed_logins = 0 WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 107, sql: "SELECT LastCharacterUndelete FROM battlenet_accounts WHERE Id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 108, sql: "UPDATE battlenet_accounts SET LastCharacterUndelete = UNIX_TIMESTAMP() WHERE Id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 109, sql: "SELECT itemId, isFavourite FROM battlenet_account_toys WHERE accountId = ?"
Table 'auth.battlenet_account_toys' doesn't exist
In mysql_stmt_prepare() id: 110, sql: "REPLACE INTO battlenet_account_toys (accountId, itemId, isFavourite) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_toys' doesn't exist
In mysql_stmt_prepare() id: 111, sql: "SELECT guid, species, breed, level, exp, health, quality, flags, name FROM battle_pets WHERE battlenetAccountId = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 112, sql: "INSERT INTO battle_pets (guid, battlenetAccountId, species, breed, level, exp, health, quality, flags, name) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 113, sql: "DELETE FROM battle_pets WHERE battlenetAccountId = ? AND guid = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 114, sql: "UPDATE battle_pets SET level = ?, exp = ?, health = ?, quality = ?, flags = ?, name = ? WHERE battlenetAccountId = ? AND guid = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 115, sql: "SELECT id, battlePetGuid, locked FROM battle_pet_slots WHERE battlenetAccountId = ?"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 116, sql: "INSERT INTO battle_pet_slots (id, battlenetAccountId, battlePetGuid, locked) VALUES (?, ?, ?, ?)"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 117, sql: "DELETE FROM battle_pet_slots WHERE battlenetAccountId = ?"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 118, sql: "SELECT itemId, flags FROM battlenet_account_heirlooms WHERE accountId = ?"
Table 'auth.battlenet_account_heirlooms' doesn't exist
In mysql_stmt_prepare() id: 119, sql: "REPLACE INTO battlenet_account_heirlooms (accountId, itemId, flags) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_heirlooms' doesn't exist
In mysql_stmt_prepare() id: 120, sql: "SELECT mountSpellId, flags FROM battlenet_account_mounts WHERE battlenetAccountId = ?"
Table 'auth.battlenet_account_mounts' doesn't exist
In mysql_stmt_prepare() id: 121, sql: "REPLACE INTO battlenet_account_mounts (battlenetAccountId, mountSpellId, flags) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_mounts' doesn't exist
In mysql_stmt_prepare() id: 122, sql: "SELECT blobIndex, appearanceMask FROM battlenet_item_appearances WHERE battlenetAccountId = ? ORDER BY blobIndex DESC"
Table 'auth.battlenet_item_appearances' doesn't exist
In mysql_stmt_prepare() id: 123, sql: "INSERT INTO battlenet_item_appearances (battlenetAccountId, blobIndex, appearanceMask) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE appearanceMask = appearanceMask | VALUES(appearanceMask)"
Table 'auth.battlenet_item_appearances' doesn't exist
In mysql_stmt_prepare() id: 124, sql: "SELECT itemModifiedAppearanceId FROM battlenet_item_favorite_appearances WHERE battlenetAccountId = ?"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 125, sql: "INSERT INTO battlenet_item_favorite_appearances (battlenetAccountId, itemModifiedAppearanceId) VALUES (?, ?)"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 126, sql: "DELETE FROM battlenet_item_favorite_appearances WHERE battlenetAccountId = ? AND itemModifiedAppearanceId = ?"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 1, sql: "DELETE FROM ip_banned WHERE unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 2, sql: "UPDATE account_banned SET active = 0 WHERE active = 1 AND unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 3, sql: "(SELECT unbandate > UNIX_TIMESTAMP() OR unbandate = bandate AS banned, NULL as country FROM ip_banned WHERE ip = ?) UNION (SELECT NULL AS banned, country FROM ip2nation WHERE INET_NTOA(ip) = ?)"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 4, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban')"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 7, sql: "DELETE FROM account_banned WHERE id = ?"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 8, sql: "UPDATE account SET sessionkey = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 9, sql: "SELECT username, sessionkey FROM account WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 10, sql: "UPDATE account SET v = ?, s = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 14, sql: "SELECT a.id, a.sessionkey, ba.last_ip, ba.locked, ba.lock_country, a.expansion, a.mutetime, ba.locale, a.recruiter, a.os, ba.id, ba.email, aa.gmLevel, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, ab.unbandate > UNIX_TIMESTAMP() OR ab.unbandate = ab.bandate, r.id FROM account a LEFT JOIN account r ON a.id = r.recruiter LEFT JOIN battlenet_accounts ba ON a.battlenet_account = ba.id LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID IN (-1, ?) LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 WHERE a.username = ? ORDER BY aa.RealmID DESC LIMIT 1"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 17, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?)"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 18, sql: "DELETE FROM ip_banned WHERE ip = ?"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 22, sql: "INSERT INTO account_banned VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?, 1)"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 23, sql: "UPDATE account_banned SET active = 0 WHERE id = ? AND active != 0"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 24, sql: "DELETE FROM realmcharacters WHERE acctid = ? AND realmid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 25, sql: "DELETE FROM realmcharacters WHERE acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 26, sql: "INSERT INTO realmcharacters (numchars, acctid, realmid) VALUES (?, ?, ?)"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 27, sql: "SELECT SUM(numchars) FROM realmcharacters WHERE acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 29, sql: "INSERT INTO realmcharacters (realmid, acctid, numchars) SELECT realmlist.id, account.id, 0 FROM realmlist, account LEFT JOIN realmcharacters ON acctid=account.id WHERE acctid IS NULL"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 30, sql: "UPDATE account SET expansion = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 31, sql: "UPDATE account SET locked = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 32, sql: "UPDATE account SET lock_country = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 33, sql: "INSERT INTO logs (time, realm, type, level, string) VALUES (?, ?, ?, ?, ?)"
Table 'auth.logs' doesn't exist
In mysql_stmt_prepare() id: 34, sql: "UPDATE account SET v = 0, s = 0, username = ?, sha_pass_hash = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 35, sql: "UPDATE account SET v = 0, s = 0, sha_pass_hash = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 36, sql: "UPDATE account SET email = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 37, sql: "UPDATE account SET reg_mail = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 38, sql: "UPDATE account SET mutetime = ? , mutereason = ? , muteby = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 39, sql: "UPDATE account SET mutetime = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 40, sql: "UPDATE account SET last_ip = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 41, sql: "UPDATE account SET last_attempt_ip = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 42, sql: "UPDATE account SET online = 1 WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 43, sql: "UPDATE uptime SET uptime = ?, maxplayers = ? WHERE realmid = ? AND starttime = ?"
Table 'auth.uptime' doesn't exist
In mysql_stmt_prepare() id: 44, sql: "DELETE FROM logs WHERE (time + ?) < ? AND realm = ?"
Table 'auth.logs' doesn't exist
In mysql_stmt_prepare() id: 45, sql: "DELETE FROM account_access WHERE id = ?"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 46, sql: "DELETE FROM account_access WHERE id = ? AND (RealmID = ? OR RealmID = -1)"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 47, sql: "INSERT INTO account_access (id,gmlevel,RealmID) VALUES (?, ?, ?)"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 62, sql: "DELETE FROM account WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 68, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, (SELECT last_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 69, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, (SELECT last_attempt_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 70, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, ?, ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 71, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, 0, 1, ?, ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 73, sql: "SELECT permissionId, granted FROM rbac_account_permissions WHERE accountId = ? AND (realmId = ? OR realmId = -1) ORDER BY permissionId, realmId"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 74, sql: "INSERT INTO rbac_account_permissions (accountId, permissionId, granted, realmId) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE granted = VALUES(granted)"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 75, sql: "DELETE FROM rbac_account_permissions WHERE accountId = ? AND permissionId = ? AND (realmId = ? OR realmId = -1)"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 76, sql: "INSERT INTO account_muted VALUES (?, UNIX_TIMESTAMP(), ?, ?, ?)"
Table 'auth.account_muted' doesn't exist
In mysql_stmt_prepare() id: 78, sql: "DELETE FROM account_muted WHERE guid = ?"
Table 'auth.account_muted' doesn't exist
In mysql_stmt_prepare() id: 79, sql: "SELECT ba.id, ba.sha_pass_hash, ba.failed_logins, ba.LoginTicket, ba.LoginTicketExpiry, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id WHERE email = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 80, sql: "UPDATE battlenet_accounts SET LoginTicket = ?, LoginTicketExpiry = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 81, sql: "SELECT LoginTicketExpiry FROM battlenet_accounts WHERE LoginTicket = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 82, sql: "UPDATE battlenet_accounts SET LoginTicketExpiry = ? WHERE LoginTicket = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 83, sql: "SELECT ba.id, UPPER(ba.email), ba.locked, ba.lock_country, ba.last_ip, ba.LoginTicketExpiry, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, bab.unbandate = bab.bandate, a.id, a.username, ab.unbandate, ab.unbandate = ab.bandate, aa.gmlevel FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account a ON ba.id = a.battlenet_account LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID = -1 WHERE ba.LoginTicket = ? ORDER BY a.id"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 84, sql: "UPDATE battlenet_accounts SET last_ip = ?, last_login = NOW(), locale = ?, failed_logins = 0, os = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 86, sql: "SELECT rc.acctid, rc.numchars, r.id, r.Region, r.Battlegroup FROM realmcharacters rc INNER JOIN realmlist r ON rc.realmid = r.id WHERE rc.acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 87, sql: "SELECT rc.acctid, rc.numchars, r.id, r.Region, r.Battlegroup FROM realmcharacters rc INNER JOIN realmlist r ON rc.realmid = r.id LEFT JOIN account a ON rc.acctid = a.id WHERE a.battlenet_account = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 88, sql: "SELECT lpc.accountId, lpc.region, lpc.battlegroup, lpc.realmId, lpc.characterName, lpc.characterGUID, lpc.lastPlayedTime FROM account_last_played_character lpc LEFT JOIN account a ON lpc.accountId = a.id WHERE a.battlenet_account = ?"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 89, sql: "DELETE FROM account_last_played_character WHERE accountId = ? AND region = ? AND battlegroup = ?"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 90, sql: "INSERT INTO account_last_played_character (accountId, region, battlegroup, realmId, characterName, characterGUID, lastPlayedTime) VALUES (?,?,?,?,?,?,?)"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 94, sql: "UPDATE battlenet_accounts SET sha_pass_hash = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 96, sql: "UPDATE battlenet_accounts SET locked = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 97, sql: "UPDATE battlenet_accounts SET lock_country = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 99, sql: "UPDATE account SET battlenet_account = ?, battlenet_index = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 102, sql: "SELECT a.username, a.expansion, ab.bandate, ab.unbandate, ab.banreason FROM account AS a LEFT JOIN account_banned AS ab ON a.id = ab.id AND ab.active = 1 INNER JOIN battlenet_accounts AS ba ON a.battlenet_account = ba.id WHERE ba.LoginTicket = ? ORDER BY a.id"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 103, sql: "UPDATE battlenet_accounts SET failed_logins = failed_logins + 1 WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 104, sql: "INSERT INTO battlenet_account_bans(id, bandate, unbandate, bannedby, banreason) VALUES(?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban')"
Table 'auth.battlenet_account_bans' doesn't exist
In mysql_stmt_prepare() id: 105, sql: "DELETE FROM battlenet_account_bans WHERE unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.battlenet_account_bans' doesn't exist
In mysql_stmt_prepare() id: 106, sql: "UPDATE battlenet_accounts SET failed_logins = 0 WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 107, sql: "SELECT LastCharacterUndelete FROM battlenet_accounts WHERE Id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 108, sql: "UPDATE battlenet_accounts SET LastCharacterUndelete = UNIX_TIMESTAMP() WHERE Id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 109, sql: "SELECT itemId, isFavourite FROM battlenet_account_toys WHERE accountId = ?"
Table 'auth.battlenet_account_toys' doesn't exist
In mysql_stmt_prepare() id: 110, sql: "REPLACE INTO battlenet_account_toys (accountId, itemId, isFavourite) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_toys' doesn't exist
In mysql_stmt_prepare() id: 111, sql: "SELECT guid, species, breed, level, exp, health, quality, flags, name FROM battle_pets WHERE battlenetAccountId = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 112, sql: "INSERT INTO battle_pets (guid, battlenetAccountId, species, breed, level, exp, health, quality, flags, name) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 113, sql: "DELETE FROM battle_pets WHERE battlenetAccountId = ? AND guid = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 114, sql: "UPDATE battle_pets SET level = ?, exp = ?, health = ?, quality = ?, flags = ?, name = ? WHERE battlenetAccountId = ? AND guid = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 115, sql: "SELECT id, battlePetGuid, locked FROM battle_pet_slots WHERE battlenetAccountId = ?"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 116, sql: "INSERT INTO battle_pet_slots (id, battlenetAccountId, battlePetGuid, locked) VALUES (?, ?, ?, ?)"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 117, sql: "DELETE FROM battle_pet_slots WHERE battlenetAccountId = ?"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 118, sql: "SELECT itemId, flags FROM battlenet_account_heirlooms WHERE accountId = ?"
Table 'auth.battlenet_account_heirlooms' doesn't exist
In mysql_stmt_prepare() id: 119, sql: "REPLACE INTO battlenet_account_heirlooms (accountId, itemId, flags) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_heirlooms' doesn't exist
In mysql_stmt_prepare() id: 120, sql: "SELECT mountSpellId, flags FROM battlenet_account_mounts WHERE battlenetAccountId = ?"
Table 'auth.battlenet_account_mounts' doesn't exist
In mysql_stmt_prepare() id: 121, sql: "REPLACE INTO battlenet_account_mounts (battlenetAccountId, mountSpellId, flags) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_mounts' doesn't exist
In mysql_stmt_prepare() id: 122, sql: "SELECT blobIndex, appearanceMask FROM battlenet_item_appearances WHERE battlenetAccountId = ? ORDER BY blobIndex DESC"
Table 'auth.battlenet_item_appearances' doesn't exist
In mysql_stmt_prepare() id: 123, sql: "INSERT INTO battlenet_item_appearances (battlenetAccountId, blobIndex, appearanceMask) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE appearanceMask = appearanceMask | VALUES(appearanceMask)"
Table 'auth.battlenet_item_appearances' doesn't exist
In mysql_stmt_prepare() id: 124, sql: "SELECT itemModifiedAppearanceId FROM battlenet_item_favorite_appearances WHERE battlenetAccountId = ?"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 125, sql: "INSERT INTO battlenet_item_favorite_appearances (battlenetAccountId, itemModifiedAppearanceId) VALUES (?, ?)"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 126, sql: "DELETE FROM battlenet_item_favorite_appearances WHERE battlenetAccountId = ? AND itemModifiedAppearanceId = ?"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 1, sql: "DELETE FROM ip_banned WHERE unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 2, sql: "UPDATE account_banned SET active = 0 WHERE active = 1 AND unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 3, sql: "(SELECT unbandate > UNIX_TIMESTAMP() OR unbandate = bandate AS banned, NULL as country FROM ip_banned WHERE ip = ?) UNION (SELECT NULL AS banned, country FROM ip2nation WHERE INET_NTOA(ip) = ?)"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 4, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban')"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 7, sql: "DELETE FROM account_banned WHERE id = ?"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 8, sql: "UPDATE account SET sessionkey = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 9, sql: "SELECT username, sessionkey FROM account WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 10, sql: "UPDATE account SET v = ?, s = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 14, sql: "SELECT a.id, a.sessionkey, ba.last_ip, ba.locked, ba.lock_country, a.expansion, a.mutetime, ba.locale, a.recruiter, a.os, ba.id, ba.email, aa.gmLevel, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, ab.unbandate > UNIX_TIMESTAMP() OR ab.unbandate = ab.bandate, r.id FROM account a LEFT JOIN account r ON a.id = r.recruiter LEFT JOIN battlenet_accounts ba ON a.battlenet_account = ba.id LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID IN (-1, ?) LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 WHERE a.username = ? ORDER BY aa.RealmID DESC LIMIT 1"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 17, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?)"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 18, sql: "DELETE FROM ip_banned WHERE ip = ?"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 22, sql: "INSERT INTO account_banned VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?, 1)"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 23, sql: "UPDATE account_banned SET active = 0 WHERE id = ? AND active != 0"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 24, sql: "DELETE FROM realmcharacters WHERE acctid = ? AND realmid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 25, sql: "DELETE FROM realmcharacters WHERE acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 26, sql: "INSERT INTO realmcharacters (numchars, acctid, realmid) VALUES (?, ?, ?)"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 27, sql: "SELECT SUM(numchars) FROM realmcharacters WHERE acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 29, sql: "INSERT INTO realmcharacters (realmid, acctid, numchars) SELECT realmlist.id, account.id, 0 FROM realmlist, account LEFT JOIN realmcharacters ON acctid=account.id WHERE acctid IS NULL"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 30, sql: "UPDATE account SET expansion = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 31, sql: "UPDATE account SET locked = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 32, sql: "UPDATE account SET lock_country = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 33, sql: "INSERT INTO logs (time, realm, type, level, string) VALUES (?, ?, ?, ?, ?)"
Table 'auth.logs' doesn't exist
In mysql_stmt_prepare() id: 34, sql: "UPDATE account SET v = 0, s = 0, username = ?, sha_pass_hash = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 35, sql: "UPDATE account SET v = 0, s = 0, sha_pass_hash = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 36, sql: "UPDATE account SET email = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 37, sql: "UPDATE account SET reg_mail = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 38, sql: "UPDATE account SET mutetime = ? , mutereason = ? , muteby = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 39, sql: "UPDATE account SET mutetime = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 40, sql: "UPDATE account SET last_ip = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 41, sql: "UPDATE account SET last_attempt_ip = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 42, sql: "UPDATE account SET online = 1 WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 43, sql: "UPDATE uptime SET uptime = ?, maxplayers = ? WHERE realmid = ? AND starttime = ?"
Table 'auth.uptime' doesn't exist
In mysql_stmt_prepare() id: 44, sql: "DELETE FROM logs WHERE (time + ?) < ? AND realm = ?"
Table 'auth.logs' doesn't exist
In mysql_stmt_prepare() id: 45, sql: "DELETE FROM account_access WHERE id = ?"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 46, sql: "DELETE FROM account_access WHERE id = ? AND (RealmID = ? OR RealmID = -1)"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 47, sql: "INSERT INTO account_access (id,gmlevel,RealmID) VALUES (?, ?, ?)"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 62, sql: "DELETE FROM account WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 68, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, (SELECT last_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 69, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, (SELECT last_attempt_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 70, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, ?, ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 71, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, 0, 1, ?, ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 73, sql: "SELECT permissionId, granted FROM rbac_account_permissions WHERE accountId = ? AND (realmId = ? OR realmId = -1) ORDER BY permissionId, realmId"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 74, sql: "INSERT INTO rbac_account_permissions (accountId, permissionId, granted, realmId) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE granted = VALUES(granted)"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 75, sql: "DELETE FROM rbac_account_permissions WHERE accountId = ? AND permissionId = ? AND (realmId = ? OR realmId = -1)"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 76, sql: "INSERT INTO account_muted VALUES (?, UNIX_TIMESTAMP(), ?, ?, ?)"
Table 'auth.account_muted' doesn't exist
In mysql_stmt_prepare() id: 78, sql: "DELETE FROM account_muted WHERE guid = ?"
Table 'auth.account_muted' doesn't exist
In mysql_stmt_prepare() id: 79, sql: "SELECT ba.id, ba.sha_pass_hash, ba.failed_logins, ba.LoginTicket, ba.LoginTicketExpiry, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id WHERE email = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 80, sql: "UPDATE battlenet_accounts SET LoginTicket = ?, LoginTicketExpiry = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 81, sql: "SELECT LoginTicketExpiry FROM battlenet_accounts WHERE LoginTicket = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 82, sql: "UPDATE battlenet_accounts SET LoginTicketExpiry = ? WHERE LoginTicket = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 83, sql: "SELECT ba.id, UPPER(ba.email), ba.locked, ba.lock_country, ba.last_ip, ba.LoginTicketExpiry, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, bab.unbandate = bab.bandate, a.id, a.username, ab.unbandate, ab.unbandate = ab.bandate, aa.gmlevel FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account a ON ba.id = a.battlenet_account LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID = -1 WHERE ba.LoginTicket = ? ORDER BY a.id"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 84, sql: "UPDATE battlenet_accounts SET last_ip = ?, last_login = NOW(), locale = ?, failed_logins = 0, os = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 86, sql: "SELECT rc.acctid, rc.numchars, r.id, r.Region, r.Battlegroup FROM realmcharacters rc INNER JOIN realmlist r ON rc.realmid = r.id WHERE rc.acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 87, sql: "SELECT rc.acctid, rc.numchars, r.id, r.Region, r.Battlegroup FROM realmcharacters rc INNER JOIN realmlist r ON rc.realmid = r.id LEFT JOIN account a ON rc.acctid = a.id WHERE a.battlenet_account = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 88, sql: "SELECT lpc.accountId, lpc.region, lpc.battlegroup, lpc.realmId, lpc.characterName, lpc.characterGUID, lpc.lastPlayedTime FROM account_last_played_character lpc LEFT JOIN account a ON lpc.accountId = a.id WHERE a.battlenet_account = ?"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 89, sql: "DELETE FROM account_last_played_character WHERE accountId = ? AND region = ? AND battlegroup = ?"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 90, sql: "INSERT INTO account_last_played_character (accountId, region, battlegroup, realmId, characterName, characterGUID, lastPlayedTime) VALUES (?,?,?,?,?,?,?)"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 94, sql: "UPDATE battlenet_accounts SET sha_pass_hash = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 96, sql: "UPDATE battlenet_accounts SET locked = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 97, sql: "UPDATE battlenet_accounts SET lock_country = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 99, sql: "UPDATE account SET battlenet_account = ?, battlenet_index = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 102, sql: "SELECT a.username, a.expansion, ab.bandate, ab.unbandate, ab.banreason FROM account AS a LEFT JOIN account_banned AS ab ON a.id = ab.id AND ab.active = 1 INNER JOIN battlenet_accounts AS ba ON a.battlenet_account = ba.id WHERE ba.LoginTicket = ? ORDER BY a.id"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 103, sql: "UPDATE battlenet_accounts SET failed_logins = failed_logins + 1 WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 104, sql: "INSERT INTO battlenet_account_bans(id, bandate, unbandate, bannedby, banreason) VALUES(?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban')"
Table 'auth.battlenet_account_bans' doesn't exist
In mysql_stmt_prepare() id: 105, sql: "DELETE FROM battlenet_account_bans WHERE unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.battlenet_account_bans' doesn't exist
In mysql_stmt_prepare() id: 106, sql: "UPDATE battlenet_accounts SET failed_logins = 0 WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 107, sql: "SELECT LastCharacterUndelete FROM battlenet_accounts WHERE Id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 108, sql: "UPDATE battlenet_accounts SET LastCharacterUndelete = UNIX_TIMESTAMP() WHERE Id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 109, sql: "SELECT itemId, isFavourite FROM battlenet_account_toys WHERE accountId = ?"
Table 'auth.battlenet_account_toys' doesn't exist
In mysql_stmt_prepare() id: 110, sql: "REPLACE INTO battlenet_account_toys (accountId, itemId, isFavourite) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_toys' doesn't exist
In mysql_stmt_prepare() id: 111, sql: "SELECT guid, species, breed, level, exp, health, quality, flags, name FROM battle_pets WHERE battlenetAccountId = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 112, sql: "INSERT INTO battle_pets (guid, battlenetAccountId, species, breed, level, exp, health, quality, flags, name) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 113, sql: "DELETE FROM battle_pets WHERE battlenetAccountId = ? AND guid = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 114, sql: "UPDATE battle_pets SET level = ?, exp = ?, health = ?, quality = ?, flags = ?, name = ? WHERE battlenetAccountId = ? AND guid = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 115, sql: "SELECT id, battlePetGuid, locked FROM battle_pet_slots WHERE battlenetAccountId = ?"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 116, sql: "INSERT INTO battle_pet_slots (id, battlenetAccountId, battlePetGuid, locked) VALUES (?, ?, ?, ?)"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 117, sql: "DELETE FROM battle_pet_slots WHERE battlenetAccountId = ?"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 118, sql: "SELECT itemId, flags FROM battlenet_account_heirlooms WHERE accountId = ?"
Table 'auth.battlenet_account_heirlooms' doesn't exist
In mysql_stmt_prepare() id: 119, sql: "REPLACE INTO battlenet_account_heirlooms (accountId, itemId, flags) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_heirlooms' doesn't exist
In mysql_stmt_prepare() id: 120, sql: "SELECT mountSpellId, flags FROM battlenet_account_mounts WHERE battlenetAccountId = ?"
Table 'auth.battlenet_account_mounts' doesn't exist
In mysql_stmt_prepare() id: 121, sql: "REPLACE INTO battlenet_account_mounts (battlenetAccountId, mountSpellId, flags) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_mounts' doesn't exist
In mysql_stmt_prepare() id: 122, sql: "SELECT blobIndex, appearanceMask FROM battlenet_item_appearances WHERE battlenetAccountId = ? ORDER BY blobIndex DESC"
Table 'auth.battlenet_item_appearances' doesn't exist
In mysql_stmt_prepare() id: 123, sql: "INSERT INTO battlenet_item_appearances (battlenetAccountId, blobIndex, appearanceMask) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE appearanceMask = appearanceMask | VALUES(appearanceMask)"
Table 'auth.battlenet_item_appearances' doesn't exist
In mysql_stmt_prepare() id: 124, sql: "SELECT itemModifiedAppearanceId FROM battlenet_item_favorite_appearances WHERE battlenetAccountId = ?"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 125, sql: "INSERT INTO battlenet_item_favorite_appearances (battlenetAccountId, itemModifiedAppearanceId) VALUES (?, ?)"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 126, sql: "DELETE FROM battlenet_item_favorite_appearances WHERE battlenetAccountId = ? AND itemModifiedAppearanceId = ?"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 1, sql: "DELETE FROM ip_banned WHERE unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 2, sql: "UPDATE account_banned SET active = 0 WHERE active = 1 AND unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 3, sql: "(SELECT unbandate > UNIX_TIMESTAMP() OR unbandate = bandate AS banned, NULL as country FROM ip_banned WHERE ip = ?) UNION (SELECT NULL AS banned, country FROM ip2nation WHERE INET_NTOA(ip) = ?)"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 4, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban')"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 7, sql: "DELETE FROM account_banned WHERE id = ?"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 8, sql: "UPDATE account SET sessionkey = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 9, sql: "SELECT username, sessionkey FROM account WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 10, sql: "UPDATE account SET v = ?, s = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 14, sql: "SELECT a.id, a.sessionkey, ba.last_ip, ba.locked, ba.lock_country, a.expansion, a.mutetime, ba.locale, a.recruiter, a.os, ba.id, ba.email, aa.gmLevel, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, ab.unbandate > UNIX_TIMESTAMP() OR ab.unbandate = ab.bandate, r.id FROM account a LEFT JOIN account r ON a.id = r.recruiter LEFT JOIN battlenet_accounts ba ON a.battlenet_account = ba.id LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID IN (-1, ?) LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 WHERE a.username = ? ORDER BY aa.RealmID DESC LIMIT 1"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 17, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?)"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 18, sql: "DELETE FROM ip_banned WHERE ip = ?"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 22, sql: "INSERT INTO account_banned VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?, 1)"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 23, sql: "UPDATE account_banned SET active = 0 WHERE id = ? AND active != 0"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 24, sql: "DELETE FROM realmcharacters WHERE acctid = ? AND realmid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 25, sql: "DELETE FROM realmcharacters WHERE acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 26, sql: "INSERT INTO realmcharacters (numchars, acctid, realmid) VALUES (?, ?, ?)"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 27, sql: "SELECT SUM(numchars) FROM realmcharacters WHERE acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 29, sql: "INSERT INTO realmcharacters (realmid, acctid, numchars) SELECT realmlist.id, account.id, 0 FROM realmlist, account LEFT JOIN realmcharacters ON acctid=account.id WHERE acctid IS NULL"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 30, sql: "UPDATE account SET expansion = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 31, sql: "UPDATE account SET locked = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 32, sql: "UPDATE account SET lock_country = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 33, sql: "INSERT INTO logs (time, realm, type, level, string) VALUES (?, ?, ?, ?, ?)"
Table 'auth.logs' doesn't exist
In mysql_stmt_prepare() id: 34, sql: "UPDATE account SET v = 0, s = 0, username = ?, sha_pass_hash = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 35, sql: "UPDATE account SET v = 0, s = 0, sha_pass_hash = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 36, sql: "UPDATE account SET email = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 37, sql: "UPDATE account SET reg_mail = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 38, sql: "UPDATE account SET mutetime = ? , mutereason = ? , muteby = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 39, sql: "UPDATE account SET mutetime = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 40, sql: "UPDATE account SET last_ip = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 41, sql: "UPDATE account SET last_attempt_ip = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 42, sql: "UPDATE account SET online = 1 WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 43, sql: "UPDATE uptime SET uptime = ?, maxplayers = ? WHERE realmid = ? AND starttime = ?"
Table 'auth.uptime' doesn't exist
In mysql_stmt_prepare() id: 44, sql: "DELETE FROM logs WHERE (time + ?) < ? AND realm = ?"
Table 'auth.logs' doesn't exist
In mysql_stmt_prepare() id: 45, sql: "DELETE FROM account_access WHERE id = ?"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 46, sql: "DELETE FROM account_access WHERE id = ? AND (RealmID = ? OR RealmID = -1)"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 47, sql: "INSERT INTO account_access (id,gmlevel,RealmID) VALUES (?, ?, ?)"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 62, sql: "DELETE FROM account WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 68, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, (SELECT last_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 69, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, (SELECT last_attempt_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 70, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, ?, ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 71, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, 0, 1, ?, ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 73, sql: "SELECT permissionId, granted FROM rbac_account_permissions WHERE accountId = ? AND (realmId = ? OR realmId = -1) ORDER BY permissionId, realmId"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 74, sql: "INSERT INTO rbac_account_permissions (accountId, permissionId, granted, realmId) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE granted = VALUES(granted)"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 75, sql: "DELETE FROM rbac_account_permissions WHERE accountId = ? AND permissionId = ? AND (realmId = ? OR realmId = -1)"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 76, sql: "INSERT INTO account_muted VALUES (?, UNIX_TIMESTAMP(), ?, ?, ?)"
Table 'auth.account_muted' doesn't exist
In mysql_stmt_prepare() id: 78, sql: "DELETE FROM account_muted WHERE guid = ?"
Table 'auth.account_muted' doesn't exist
In mysql_stmt_prepare() id: 79, sql: "SELECT ba.id, ba.sha_pass_hash, ba.failed_logins, ba.LoginTicket, ba.LoginTicketExpiry, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id WHERE email = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 80, sql: "UPDATE battlenet_accounts SET LoginTicket = ?, LoginTicketExpiry = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 81, sql: "SELECT LoginTicketExpiry FROM battlenet_accounts WHERE LoginTicket = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 82, sql: "UPDATE battlenet_accounts SET LoginTicketExpiry = ? WHERE LoginTicket = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 83, sql: "SELECT ba.id, UPPER(ba.email), ba.locked, ba.lock_country, ba.last_ip, ba.LoginTicketExpiry, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, bab.unbandate = bab.bandate, a.id, a.username, ab.unbandate, ab.unbandate = ab.bandate, aa.gmlevel FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account a ON ba.id = a.battlenet_account LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID = -1 WHERE ba.LoginTicket = ? ORDER BY a.id"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 84, sql: "UPDATE battlenet_accounts SET last_ip = ?, last_login = NOW(), locale = ?, failed_logins = 0, os = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 86, sql: "SELECT rc.acctid, rc.numchars, r.id, r.Region, r.Battlegroup FROM realmcharacters rc INNER JOIN realmlist r ON rc.realmid = r.id WHERE rc.acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 87, sql: "SELECT rc.acctid, rc.numchars, r.id, r.Region, r.Battlegroup FROM realmcharacters rc INNER JOIN realmlist r ON rc.realmid = r.id LEFT JOIN account a ON rc.acctid = a.id WHERE a.battlenet_account = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 88, sql: "SELECT lpc.accountId, lpc.region, lpc.battlegroup, lpc.realmId, lpc.characterName, lpc.characterGUID, lpc.lastPlayedTime FROM account_last_played_character lpc LEFT JOIN account a ON lpc.accountId = a.id WHERE a.battlenet_account = ?"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 89, sql: "DELETE FROM account_last_played_character WHERE accountId = ? AND region = ? AND battlegroup = ?"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 90, sql: "INSERT INTO account_last_played_character (accountId, region, battlegroup, realmId, characterName, characterGUID, lastPlayedTime) VALUES (?,?,?,?,?,?,?)"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 94, sql: "UPDATE battlenet_accounts SET sha_pass_hash = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 96, sql: "UPDATE battlenet_accounts SET locked = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 97, sql: "UPDATE battlenet_accounts SET lock_country = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 99, sql: "UPDATE account SET battlenet_account = ?, battlenet_index = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 102, sql: "SELECT a.username, a.expansion, ab.bandate, ab.unbandate, ab.banreason FROM account AS a LEFT JOIN account_banned AS ab ON a.id = ab.id AND ab.active = 1 INNER JOIN battlenet_accounts AS ba ON a.battlenet_account = ba.id WHERE ba.LoginTicket = ? ORDER BY a.id"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 103, sql: "UPDATE battlenet_accounts SET failed_logins = failed_logins + 1 WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 104, sql: "INSERT INTO battlenet_account_bans(id, bandate, unbandate, bannedby, banreason) VALUES(?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban')"
Table 'auth.battlenet_account_bans' doesn't exist
In mysql_stmt_prepare() id: 105, sql: "DELETE FROM battlenet_account_bans WHERE unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.battlenet_account_bans' doesn't exist
In mysql_stmt_prepare() id: 106, sql: "UPDATE battlenet_accounts SET failed_logins = 0 WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 107, sql: "SELECT LastCharacterUndelete FROM battlenet_accounts WHERE Id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 108, sql: "UPDATE battlenet_accounts SET LastCharacterUndelete = UNIX_TIMESTAMP() WHERE Id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 109, sql: "SELECT itemId, isFavourite FROM battlenet_account_toys WHERE accountId = ?"
Table 'auth.battlenet_account_toys' doesn't exist
In mysql_stmt_prepare() id: 110, sql: "REPLACE INTO battlenet_account_toys (accountId, itemId, isFavourite) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_toys' doesn't exist
In mysql_stmt_prepare() id: 111, sql: "SELECT guid, species, breed, level, exp, health, quality, flags, name FROM battle_pets WHERE battlenetAccountId = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 112, sql: "INSERT INTO battle_pets (guid, battlenetAccountId, species, breed, level, exp, health, quality, flags, name) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 113, sql: "DELETE FROM battle_pets WHERE battlenetAccountId = ? AND guid = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 114, sql: "UPDATE battle_pets SET level = ?, exp = ?, health = ?, quality = ?, flags = ?, name = ? WHERE battlenetAccountId = ? AND guid = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 115, sql: "SELECT id, battlePetGuid, locked FROM battle_pet_slots WHERE battlenetAccountId = ?"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 116, sql: "INSERT INTO battle_pet_slots (id, battlenetAccountId, battlePetGuid, locked) VALUES (?, ?, ?, ?)"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 117, sql: "DELETE FROM battle_pet_slots WHERE battlenetAccountId = ?"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 118, sql: "SELECT itemId, flags FROM battlenet_account_heirlooms WHERE accountId = ?"
Table 'auth.battlenet_account_heirlooms' doesn't exist
In mysql_stmt_prepare() id: 119, sql: "REPLACE INTO battlenet_account_heirlooms (accountId, itemId, flags) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_heirlooms' doesn't exist
In mysql_stmt_prepare() id: 120, sql: "SELECT mountSpellId, flags FROM battlenet_account_mounts WHERE battlenetAccountId = ?"
Table 'auth.battlenet_account_mounts' doesn't exist
In mysql_stmt_prepare() id: 121, sql: "REPLACE INTO battlenet_account_mounts (battlenetAccountId, mountSpellId, flags) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_mounts' doesn't exist
In mysql_stmt_prepare() id: 122, sql: "SELECT blobIndex, appearanceMask FROM battlenet_item_appearances WHERE battlenetAccountId = ? ORDER BY blobIndex DESC"
Table 'auth.battlenet_item_appearances' doesn't exist
In mysql_stmt_prepare() id: 123, sql: "INSERT INTO battlenet_item_appearances (battlenetAccountId, blobIndex, appearanceMask) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE appearanceMask = appearanceMask | VALUES(appearanceMask)"
Table 'auth.battlenet_item_appearances' doesn't exist
In mysql_stmt_prepare() id: 124, sql: "SELECT itemModifiedAppearanceId FROM battlenet_item_favorite_appearances WHERE battlenetAccountId = ?"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 125, sql: "INSERT INTO battlenet_item_favorite_appearances (battlenetAccountId, itemModifiedAppearanceId) VALUES (?, ?)"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 126, sql: "DELETE FROM battlenet_item_favorite_appearances WHERE battlenetAccountId = ? AND itemModifiedAppearanceId = ?"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
Could not connect to MySQL database at 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (10061)
In mysql_stmt_prepare() id: 1, sql: "DELETE FROM ip_banned WHERE unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 2, sql: "UPDATE account_banned SET active = 0 WHERE active = 1 AND unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 3, sql: "(SELECT unbandate > UNIX_TIMESTAMP() OR unbandate = bandate AS banned, NULL as country FROM ip_banned WHERE ip = ?) UNION (SELECT NULL AS banned, country FROM ip2nation WHERE INET_NTOA(ip) = ?)"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 4, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban')"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 7, sql: "DELETE FROM account_banned WHERE id = ?"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 8, sql: "UPDATE account SET sessionkey = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 9, sql: "SELECT username, sessionkey FROM account WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 10, sql: "UPDATE account SET v = ?, s = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 14, sql: "SELECT a.id, a.sessionkey, ba.last_ip, ba.locked, ba.lock_country, a.expansion, a.mutetime, ba.locale, a.recruiter, a.os, ba.id, ba.email, aa.gmLevel, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, ab.unbandate > UNIX_TIMESTAMP() OR ab.unbandate = ab.bandate, r.id FROM account a LEFT JOIN account r ON a.id = r.recruiter LEFT JOIN battlenet_accounts ba ON a.battlenet_account = ba.id LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID IN (-1, ?) LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 WHERE a.username = ? ORDER BY aa.RealmID DESC LIMIT 1"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 17, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?)"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 18, sql: "DELETE FROM ip_banned WHERE ip = ?"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 22, sql: "INSERT INTO account_banned VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?, 1)"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 23, sql: "UPDATE account_banned SET active = 0 WHERE id = ? AND active != 0"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 24, sql: "DELETE FROM realmcharacters WHERE acctid = ? AND realmid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 25, sql: "DELETE FROM realmcharacters WHERE acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 26, sql: "INSERT INTO realmcharacters (numchars, acctid, realmid) VALUES (?, ?, ?)"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 27, sql: "SELECT SUM(numchars) FROM realmcharacters WHERE acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 29, sql: "INSERT INTO realmcharacters (realmid, acctid, numchars) SELECT realmlist.id, account.id, 0 FROM realmlist, account LEFT JOIN realmcharacters ON acctid=account.id WHERE acctid IS NULL"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 30, sql: "UPDATE account SET expansion = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 31, sql: "UPDATE account SET locked = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 32, sql: "UPDATE account SET lock_country = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 33, sql: "INSERT INTO logs (time, realm, type, level, string) VALUES (?, ?, ?, ?, ?)"
Table 'auth.logs' doesn't exist
In mysql_stmt_prepare() id: 34, sql: "UPDATE account SET v = 0, s = 0, username = ?, sha_pass_hash = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 35, sql: "UPDATE account SET v = 0, s = 0, sha_pass_hash = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 36, sql: "UPDATE account SET email = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 37, sql: "UPDATE account SET reg_mail = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 38, sql: "UPDATE account SET mutetime = ? , mutereason = ? , muteby = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 39, sql: "UPDATE account SET mutetime = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 40, sql: "UPDATE account SET last_ip = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 41, sql: "UPDATE account SET last_attempt_ip = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 42, sql: "UPDATE account SET online = 1 WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 43, sql: "UPDATE uptime SET uptime = ?, maxplayers = ? WHERE realmid = ? AND starttime = ?"
Table 'auth.uptime' doesn't exist
In mysql_stmt_prepare() id: 44, sql: "DELETE FROM logs WHERE (time + ?) < ? AND realm = ?"
Table 'auth.logs' doesn't exist
In mysql_stmt_prepare() id: 45, sql: "DELETE FROM account_access WHERE id = ?"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 46, sql: "DELETE FROM account_access WHERE id = ? AND (RealmID = ? OR RealmID = -1)"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 47, sql: "INSERT INTO account_access (id,gmlevel,RealmID) VALUES (?, ?, ?)"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 62, sql: "DELETE FROM account WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 68, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, (SELECT last_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 69, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, (SELECT last_attempt_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 70, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, ?, ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 71, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, 0, 1, ?, ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 73, sql: "SELECT permissionId, granted FROM rbac_account_permissions WHERE accountId = ? AND (realmId = ? OR realmId = -1) ORDER BY permissionId, realmId"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 74, sql: "INSERT INTO rbac_account_permissions (accountId, permissionId, granted, realmId) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE granted = VALUES(granted)"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 75, sql: "DELETE FROM rbac_account_permissions WHERE accountId = ? AND permissionId = ? AND (realmId = ? OR realmId = -1)"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 76, sql: "INSERT INTO account_muted VALUES (?, UNIX_TIMESTAMP(), ?, ?, ?)"
Table 'auth.account_muted' doesn't exist
In mysql_stmt_prepare() id: 78, sql: "DELETE FROM account_muted WHERE guid = ?"
Table 'auth.account_muted' doesn't exist
In mysql_stmt_prepare() id: 79, sql: "SELECT ba.id, ba.sha_pass_hash, ba.failed_logins, ba.LoginTicket, ba.LoginTicketExpiry, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id WHERE email = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 80, sql: "UPDATE battlenet_accounts SET LoginTicket = ?, LoginTicketExpiry = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 81, sql: "SELECT LoginTicketExpiry FROM battlenet_accounts WHERE LoginTicket = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 82, sql: "UPDATE battlenet_accounts SET LoginTicketExpiry = ? WHERE LoginTicket = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 83, sql: "SELECT ba.id, UPPER(ba.email), ba.locked, ba.lock_country, ba.last_ip, ba.LoginTicketExpiry, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, bab.unbandate = bab.bandate, a.id, a.username, ab.unbandate, ab.unbandate = ab.bandate, aa.gmlevel FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account a ON ba.id = a.battlenet_account LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID = -1 WHERE ba.LoginTicket = ? ORDER BY a.id"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 84, sql: "UPDATE battlenet_accounts SET last_ip = ?, last_login = NOW(), locale = ?, failed_logins = 0, os = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 86, sql: "SELECT rc.acctid, rc.numchars, r.id, r.Region, r.Battlegroup FROM realmcharacters rc INNER JOIN realmlist r ON rc.realmid = r.id WHERE rc.acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 87, sql: "SELECT rc.acctid, rc.numchars, r.id, r.Region, r.Battlegroup FROM realmcharacters rc INNER JOIN realmlist r ON rc.realmid = r.id LEFT JOIN account a ON rc.acctid = a.id WHERE a.battlenet_account = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 88, sql: "SELECT lpc.accountId, lpc.region, lpc.battlegroup, lpc.realmId, lpc.characterName, lpc.characterGUID, lpc.lastPlayedTime FROM account_last_played_character lpc LEFT JOIN account a ON lpc.accountId = a.id WHERE a.battlenet_account = ?"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 89, sql: "DELETE FROM account_last_played_character WHERE accountId = ? AND region = ? AND battlegroup = ?"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 90, sql: "INSERT INTO account_last_played_character (accountId, region, battlegroup, realmId, characterName, characterGUID, lastPlayedTime) VALUES (?,?,?,?,?,?,?)"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 94, sql: "UPDATE battlenet_accounts SET sha_pass_hash = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 96, sql: "UPDATE battlenet_accounts SET locked = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 97, sql: "UPDATE battlenet_accounts SET lock_country = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 99, sql: "UPDATE account SET battlenet_account = ?, battlenet_index = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 102, sql: "SELECT a.username, a.expansion, ab.bandate, ab.unbandate, ab.banreason FROM account AS a LEFT JOIN account_banned AS ab ON a.id = ab.id AND ab.active = 1 INNER JOIN battlenet_accounts AS ba ON a.battlenet_account = ba.id WHERE ba.LoginTicket = ? ORDER BY a.id"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 103, sql: "UPDATE battlenet_accounts SET failed_logins = failed_logins + 1 WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 104, sql: "INSERT INTO battlenet_account_bans(id, bandate, unbandate, bannedby, banreason) VALUES(?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban')"
Table 'auth.battlenet_account_bans' doesn't exist
In mysql_stmt_prepare() id: 105, sql: "DELETE FROM battlenet_account_bans WHERE unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.battlenet_account_bans' doesn't exist
In mysql_stmt_prepare() id: 106, sql: "UPDATE battlenet_accounts SET failed_logins = 0 WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 107, sql: "SELECT LastCharacterUndelete FROM battlenet_accounts WHERE Id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 108, sql: "UPDATE battlenet_accounts SET LastCharacterUndelete = UNIX_TIMESTAMP() WHERE Id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 109, sql: "SELECT itemId, isFavourite FROM battlenet_account_toys WHERE accountId = ?"
Table 'auth.battlenet_account_toys' doesn't exist
In mysql_stmt_prepare() id: 110, sql: "REPLACE INTO battlenet_account_toys (accountId, itemId, isFavourite) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_toys' doesn't exist
In mysql_stmt_prepare() id: 111, sql: "SELECT guid, species, breed, level, exp, health, quality, flags, name FROM battle_pets WHERE battlenetAccountId = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 112, sql: "INSERT INTO battle_pets (guid, battlenetAccountId, species, breed, level, exp, health, quality, flags, name) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 113, sql: "DELETE FROM battle_pets WHERE battlenetAccountId = ? AND guid = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 114, sql: "UPDATE battle_pets SET level = ?, exp = ?, health = ?, quality = ?, flags = ?, name = ? WHERE battlenetAccountId = ? AND guid = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 115, sql: "SELECT id, battlePetGuid, locked FROM battle_pet_slots WHERE battlenetAccountId = ?"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 116, sql: "INSERT INTO battle_pet_slots (id, battlenetAccountId, battlePetGuid, locked) VALUES (?, ?, ?, ?)"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 117, sql: "DELETE FROM battle_pet_slots WHERE battlenetAccountId = ?"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 118, sql: "SELECT itemId, flags FROM battlenet_account_heirlooms WHERE accountId = ?"
Table 'auth.battlenet_account_heirlooms' doesn't exist
In mysql_stmt_prepare() id: 119, sql: "REPLACE INTO battlenet_account_heirlooms (accountId, itemId, flags) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_heirlooms' doesn't exist
In mysql_stmt_prepare() id: 120, sql: "SELECT mountSpellId, flags FROM battlenet_account_mounts WHERE battlenetAccountId = ?"
Table 'auth.battlenet_account_mounts' doesn't exist
In mysql_stmt_prepare() id: 121, sql: "REPLACE INTO battlenet_account_mounts (battlenetAccountId, mountSpellId, flags) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_mounts' doesn't exist
In mysql_stmt_prepare() id: 122, sql: "SELECT blobIndex, appearanceMask FROM battlenet_item_appearances WHERE battlenetAccountId = ? ORDER BY blobIndex DESC"
Table 'auth.battlenet_item_appearances' doesn't exist
In mysql_stmt_prepare() id: 123, sql: "INSERT INTO battlenet_item_appearances (battlenetAccountId, blobIndex, appearanceMask) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE appearanceMask = appearanceMask | VALUES(appearanceMask)"
Table 'auth.battlenet_item_appearances' doesn't exist
In mysql_stmt_prepare() id: 124, sql: "SELECT itemModifiedAppearanceId FROM battlenet_item_favorite_appearances WHERE battlenetAccountId = ?"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 125, sql: "INSERT INTO battlenet_item_favorite_appearances (battlenetAccountId, itemModifiedAppearanceId) VALUES (?, ?)"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 126, sql: "DELETE FROM battlenet_item_favorite_appearances WHERE battlenetAccountId = ? AND itemModifiedAppearanceId = ?"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 1, sql: "DELETE FROM ip_banned WHERE unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 2, sql: "UPDATE account_banned SET active = 0 WHERE active = 1 AND unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 3, sql: "(SELECT unbandate > UNIX_TIMESTAMP() OR unbandate = bandate AS banned, NULL as country FROM ip_banned WHERE ip = ?) UNION (SELECT NULL AS banned, country FROM ip2nation WHERE INET_NTOA(ip) = ?)"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 4, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban')"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 7, sql: "DELETE FROM account_banned WHERE id = ?"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 8, sql: "UPDATE account SET sessionkey = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 9, sql: "SELECT username, sessionkey FROM account WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 10, sql: "UPDATE account SET v = ?, s = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 14, sql: "SELECT a.id, a.sessionkey, ba.last_ip, ba.locked, ba.lock_country, a.expansion, a.mutetime, ba.locale, a.recruiter, a.os, ba.id, ba.email, aa.gmLevel, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, ab.unbandate > UNIX_TIMESTAMP() OR ab.unbandate = ab.bandate, r.id FROM account a LEFT JOIN account r ON a.id = r.recruiter LEFT JOIN battlenet_accounts ba ON a.battlenet_account = ba.id LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID IN (-1, ?) LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 WHERE a.username = ? ORDER BY aa.RealmID DESC LIMIT 1"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 17, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?)"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 18, sql: "DELETE FROM ip_banned WHERE ip = ?"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 22, sql: "INSERT INTO account_banned VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?, 1)"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 23, sql: "UPDATE account_banned SET active = 0 WHERE id = ? AND active != 0"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 24, sql: "DELETE FROM realmcharacters WHERE acctid = ? AND realmid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 25, sql: "DELETE FROM realmcharacters WHERE acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 26, sql: "INSERT INTO realmcharacters (numchars, acctid, realmid) VALUES (?, ?, ?)"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 27, sql: "SELECT SUM(numchars) FROM realmcharacters WHERE acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 29, sql: "INSERT INTO realmcharacters (realmid, acctid, numchars) SELECT realmlist.id, account.id, 0 FROM realmlist, account LEFT JOIN realmcharacters ON acctid=account.id WHERE acctid IS NULL"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 30, sql: "UPDATE account SET expansion = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 31, sql: "UPDATE account SET locked = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 32, sql: "UPDATE account SET lock_country = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 33, sql: "INSERT INTO logs (time, realm, type, level, string) VALUES (?, ?, ?, ?, ?)"
Table 'auth.logs' doesn't exist
In mysql_stmt_prepare() id: 34, sql: "UPDATE account SET v = 0, s = 0, username = ?, sha_pass_hash = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 35, sql: "UPDATE account SET v = 0, s = 0, sha_pass_hash = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 36, sql: "UPDATE account SET email = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 37, sql: "UPDATE account SET reg_mail = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 38, sql: "UPDATE account SET mutetime = ? , mutereason = ? , muteby = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 39, sql: "UPDATE account SET mutetime = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 40, sql: "UPDATE account SET last_ip = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 41, sql: "UPDATE account SET last_attempt_ip = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 42, sql: "UPDATE account SET online = 1 WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 43, sql: "UPDATE uptime SET uptime = ?, maxplayers = ? WHERE realmid = ? AND starttime = ?"
Table 'auth.uptime' doesn't exist
In mysql_stmt_prepare() id: 44, sql: "DELETE FROM logs WHERE (time + ?) < ? AND realm = ?"
Table 'auth.logs' doesn't exist
In mysql_stmt_prepare() id: 45, sql: "DELETE FROM account_access WHERE id = ?"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 46, sql: "DELETE FROM account_access WHERE id = ? AND (RealmID = ? OR RealmID = -1)"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 47, sql: "INSERT INTO account_access (id,gmlevel,RealmID) VALUES (?, ?, ?)"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 62, sql: "DELETE FROM account WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 68, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, (SELECT last_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 69, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, (SELECT last_attempt_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 70, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, ?, ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 71, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, 0, 1, ?, ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 73, sql: "SELECT permissionId, granted FROM rbac_account_permissions WHERE accountId = ? AND (realmId = ? OR realmId = -1) ORDER BY permissionId, realmId"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 74, sql: "INSERT INTO rbac_account_permissions (accountId, permissionId, granted, realmId) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE granted = VALUES(granted)"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 75, sql: "DELETE FROM rbac_account_permissions WHERE accountId = ? AND permissionId = ? AND (realmId = ? OR realmId = -1)"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 76, sql: "INSERT INTO account_muted VALUES (?, UNIX_TIMESTAMP(), ?, ?, ?)"
Table 'auth.account_muted' doesn't exist
In mysql_stmt_prepare() id: 78, sql: "DELETE FROM account_muted WHERE guid = ?"
Table 'auth.account_muted' doesn't exist
In mysql_stmt_prepare() id: 79, sql: "SELECT ba.id, ba.sha_pass_hash, ba.failed_logins, ba.LoginTicket, ba.LoginTicketExpiry, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id WHERE email = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 80, sql: "UPDATE battlenet_accounts SET LoginTicket = ?, LoginTicketExpiry = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 81, sql: "SELECT LoginTicketExpiry FROM battlenet_accounts WHERE LoginTicket = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 82, sql: "UPDATE battlenet_accounts SET LoginTicketExpiry = ? WHERE LoginTicket = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 83, sql: "SELECT ba.id, UPPER(ba.email), ba.locked, ba.lock_country, ba.last_ip, ba.LoginTicketExpiry, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, bab.unbandate = bab.bandate, a.id, a.username, ab.unbandate, ab.unbandate = ab.bandate, aa.gmlevel FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account a ON ba.id = a.battlenet_account LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID = -1 WHERE ba.LoginTicket = ? ORDER BY a.id"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 84, sql: "UPDATE battlenet_accounts SET last_ip = ?, last_login = NOW(), locale = ?, failed_logins = 0, os = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 86, sql: "SELECT rc.acctid, rc.numchars, r.id, r.Region, r.Battlegroup FROM realmcharacters rc INNER JOIN realmlist r ON rc.realmid = r.id WHERE rc.acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 87, sql: "SELECT rc.acctid, rc.numchars, r.id, r.Region, r.Battlegroup FROM realmcharacters rc INNER JOIN realmlist r ON rc.realmid = r.id LEFT JOIN account a ON rc.acctid = a.id WHERE a.battlenet_account = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 88, sql: "SELECT lpc.accountId, lpc.region, lpc.battlegroup, lpc.realmId, lpc.characterName, lpc.characterGUID, lpc.lastPlayedTime FROM account_last_played_character lpc LEFT JOIN account a ON lpc.accountId = a.id WHERE a.battlenet_account = ?"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 89, sql: "DELETE FROM account_last_played_character WHERE accountId = ? AND region = ? AND battlegroup = ?"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 90, sql: "INSERT INTO account_last_played_character (accountId, region, battlegroup, realmId, characterName, characterGUID, lastPlayedTime) VALUES (?,?,?,?,?,?,?)"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 94, sql: "UPDATE battlenet_accounts SET sha_pass_hash = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 96, sql: "UPDATE battlenet_accounts SET locked = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 97, sql: "UPDATE battlenet_accounts SET lock_country = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 99, sql: "UPDATE account SET battlenet_account = ?, battlenet_index = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 102, sql: "SELECT a.username, a.expansion, ab.bandate, ab.unbandate, ab.banreason FROM account AS a LEFT JOIN account_banned AS ab ON a.id = ab.id AND ab.active = 1 INNER JOIN battlenet_accounts AS ba ON a.battlenet_account = ba.id WHERE ba.LoginTicket = ? ORDER BY a.id"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 103, sql: "UPDATE battlenet_accounts SET failed_logins = failed_logins + 1 WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 104, sql: "INSERT INTO battlenet_account_bans(id, bandate, unbandate, bannedby, banreason) VALUES(?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban')"
Table 'auth.battlenet_account_bans' doesn't exist
In mysql_stmt_prepare() id: 105, sql: "DELETE FROM battlenet_account_bans WHERE unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.battlenet_account_bans' doesn't exist
In mysql_stmt_prepare() id: 106, sql: "UPDATE battlenet_accounts SET failed_logins = 0 WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 107, sql: "SELECT LastCharacterUndelete FROM battlenet_accounts WHERE Id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 108, sql: "UPDATE battlenet_accounts SET LastCharacterUndelete = UNIX_TIMESTAMP() WHERE Id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 109, sql: "SELECT itemId, isFavourite FROM battlenet_account_toys WHERE accountId = ?"
Table 'auth.battlenet_account_toys' doesn't exist
In mysql_stmt_prepare() id: 110, sql: "REPLACE INTO battlenet_account_toys (accountId, itemId, isFavourite) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_toys' doesn't exist
In mysql_stmt_prepare() id: 111, sql: "SELECT guid, species, breed, level, exp, health, quality, flags, name FROM battle_pets WHERE battlenetAccountId = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 112, sql: "INSERT INTO battle_pets (guid, battlenetAccountId, species, breed, level, exp, health, quality, flags, name) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 113, sql: "DELETE FROM battle_pets WHERE battlenetAccountId = ? AND guid = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 114, sql: "UPDATE battle_pets SET level = ?, exp = ?, health = ?, quality = ?, flags = ?, name = ? WHERE battlenetAccountId = ? AND guid = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 115, sql: "SELECT id, battlePetGuid, locked FROM battle_pet_slots WHERE battlenetAccountId = ?"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 116, sql: "INSERT INTO battle_pet_slots (id, battlenetAccountId, battlePetGuid, locked) VALUES (?, ?, ?, ?)"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 117, sql: "DELETE FROM battle_pet_slots WHERE battlenetAccountId = ?"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 118, sql: "SELECT itemId, flags FROM battlenet_account_heirlooms WHERE accountId = ?"
Table 'auth.battlenet_account_heirlooms' doesn't exist
In mysql_stmt_prepare() id: 119, sql: "REPLACE INTO battlenet_account_heirlooms (accountId, itemId, flags) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_heirlooms' doesn't exist
In mysql_stmt_prepare() id: 120, sql: "SELECT mountSpellId, flags FROM battlenet_account_mounts WHERE battlenetAccountId = ?"
Table 'auth.battlenet_account_mounts' doesn't exist
In mysql_stmt_prepare() id: 121, sql: "REPLACE INTO battlenet_account_mounts (battlenetAccountId, mountSpellId, flags) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_mounts' doesn't exist
In mysql_stmt_prepare() id: 122, sql: "SELECT blobIndex, appearanceMask FROM battlenet_item_appearances WHERE battlenetAccountId = ? ORDER BY blobIndex DESC"
Table 'auth.battlenet_item_appearances' doesn't exist
In mysql_stmt_prepare() id: 123, sql: "INSERT INTO battlenet_item_appearances (battlenetAccountId, blobIndex, appearanceMask) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE appearanceMask = appearanceMask | VALUES(appearanceMask)"
Table 'auth.battlenet_item_appearances' doesn't exist
In mysql_stmt_prepare() id: 124, sql: "SELECT itemModifiedAppearanceId FROM battlenet_item_favorite_appearances WHERE battlenetAccountId = ?"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 125, sql: "INSERT INTO battlenet_item_favorite_appearances (battlenetAccountId, itemModifiedAppearanceId) VALUES (?, ?)"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 126, sql: "DELETE FROM battlenet_item_favorite_appearances WHERE battlenetAccountId = ? AND itemModifiedAppearanceId = ?"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 1, sql: "DELETE FROM ip_banned WHERE unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 2, sql: "UPDATE account_banned SET active = 0 WHERE active = 1 AND unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 3, sql: "(SELECT unbandate > UNIX_TIMESTAMP() OR unbandate = bandate AS banned, NULL as country FROM ip_banned WHERE ip = ?) UNION (SELECT NULL AS banned, country FROM ip2nation WHERE INET_NTOA(ip) = ?)"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 4, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban')"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 7, sql: "DELETE FROM account_banned WHERE id = ?"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 8, sql: "UPDATE account SET sessionkey = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 9, sql: "SELECT username, sessionkey FROM account WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 10, sql: "UPDATE account SET v = ?, s = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 14, sql: "SELECT a.id, a.sessionkey, ba.last_ip, ba.locked, ba.lock_country, a.expansion, a.mutetime, ba.locale, a.recruiter, a.os, ba.id, ba.email, aa.gmLevel, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, ab.unbandate > UNIX_TIMESTAMP() OR ab.unbandate = ab.bandate, r.id FROM account a LEFT JOIN account r ON a.id = r.recruiter LEFT JOIN battlenet_accounts ba ON a.battlenet_account = ba.id LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID IN (-1, ?) LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 WHERE a.username = ? ORDER BY aa.RealmID DESC LIMIT 1"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 17, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?)"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 18, sql: "DELETE FROM ip_banned WHERE ip = ?"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 22, sql: "INSERT INTO account_banned VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?, 1)"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 23, sql: "UPDATE account_banned SET active = 0 WHERE id = ? AND active != 0"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 24, sql: "DELETE FROM realmcharacters WHERE acctid = ? AND realmid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 25, sql: "DELETE FROM realmcharacters WHERE acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 26, sql: "INSERT INTO realmcharacters (numchars, acctid, realmid) VALUES (?, ?, ?)"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 27, sql: "SELECT SUM(numchars) FROM realmcharacters WHERE acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 29, sql: "INSERT INTO realmcharacters (realmid, acctid, numchars) SELECT realmlist.id, account.id, 0 FROM realmlist, account LEFT JOIN realmcharacters ON acctid=account.id WHERE acctid IS NULL"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 30, sql: "UPDATE account SET expansion = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 31, sql: "UPDATE account SET locked = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 32, sql: "UPDATE account SET lock_country = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 33, sql: "INSERT INTO logs (time, realm, type, level, string) VALUES (?, ?, ?, ?, ?)"
Table 'auth.logs' doesn't exist
In mysql_stmt_prepare() id: 34, sql: "UPDATE account SET v = 0, s = 0, username = ?, sha_pass_hash = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 35, sql: "UPDATE account SET v = 0, s = 0, sha_pass_hash = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 36, sql: "UPDATE account SET email = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 37, sql: "UPDATE account SET reg_mail = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 38, sql: "UPDATE account SET mutetime = ? , mutereason = ? , muteby = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 39, sql: "UPDATE account SET mutetime = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 40, sql: "UPDATE account SET last_ip = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 41, sql: "UPDATE account SET last_attempt_ip = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 42, sql: "UPDATE account SET online = 1 WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 43, sql: "UPDATE uptime SET uptime = ?, maxplayers = ? WHERE realmid = ? AND starttime = ?"
Table 'auth.uptime' doesn't exist
In mysql_stmt_prepare() id: 44, sql: "DELETE FROM logs WHERE (time + ?) < ? AND realm = ?"
Table 'auth.logs' doesn't exist
In mysql_stmt_prepare() id: 45, sql: "DELETE FROM account_access WHERE id = ?"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 46, sql: "DELETE FROM account_access WHERE id = ? AND (RealmID = ? OR RealmID = -1)"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 47, sql: "INSERT INTO account_access (id,gmlevel,RealmID) VALUES (?, ?, ?)"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 62, sql: "DELETE FROM account WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 68, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, (SELECT last_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 69, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, (SELECT last_attempt_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 70, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, ?, ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 71, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, 0, 1, ?, ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 73, sql: "SELECT permissionId, granted FROM rbac_account_permissions WHERE accountId = ? AND (realmId = ? OR realmId = -1) ORDER BY permissionId, realmId"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 74, sql: "INSERT INTO rbac_account_permissions (accountId, permissionId, granted, realmId) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE granted = VALUES(granted)"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 75, sql: "DELETE FROM rbac_account_permissions WHERE accountId = ? AND permissionId = ? AND (realmId = ? OR realmId = -1)"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 76, sql: "INSERT INTO account_muted VALUES (?, UNIX_TIMESTAMP(), ?, ?, ?)"
Table 'auth.account_muted' doesn't exist
In mysql_stmt_prepare() id: 78, sql: "DELETE FROM account_muted WHERE guid = ?"
Table 'auth.account_muted' doesn't exist
In mysql_stmt_prepare() id: 79, sql: "SELECT ba.id, ba.sha_pass_hash, ba.failed_logins, ba.LoginTicket, ba.LoginTicketExpiry, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id WHERE email = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 80, sql: "UPDATE battlenet_accounts SET LoginTicket = ?, LoginTicketExpiry = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 81, sql: "SELECT LoginTicketExpiry FROM battlenet_accounts WHERE LoginTicket = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 82, sql: "UPDATE battlenet_accounts SET LoginTicketExpiry = ? WHERE LoginTicket = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 83, sql: "SELECT ba.id, UPPER(ba.email), ba.locked, ba.lock_country, ba.last_ip, ba.LoginTicketExpiry, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, bab.unbandate = bab.bandate, a.id, a.username, ab.unbandate, ab.unbandate = ab.bandate, aa.gmlevel FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account a ON ba.id = a.battlenet_account LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID = -1 WHERE ba.LoginTicket = ? ORDER BY a.id"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 84, sql: "UPDATE battlenet_accounts SET last_ip = ?, last_login = NOW(), locale = ?, failed_logins = 0, os = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 86, sql: "SELECT rc.acctid, rc.numchars, r.id, r.Region, r.Battlegroup FROM realmcharacters rc INNER JOIN realmlist r ON rc.realmid = r.id WHERE rc.acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 87, sql: "SELECT rc.acctid, rc.numchars, r.id, r.Region, r.Battlegroup FROM realmcharacters rc INNER JOIN realmlist r ON rc.realmid = r.id LEFT JOIN account a ON rc.acctid = a.id WHERE a.battlenet_account = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 88, sql: "SELECT lpc.accountId, lpc.region, lpc.battlegroup, lpc.realmId, lpc.characterName, lpc.characterGUID, lpc.lastPlayedTime FROM account_last_played_character lpc LEFT JOIN account a ON lpc.accountId = a.id WHERE a.battlenet_account = ?"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 89, sql: "DELETE FROM account_last_played_character WHERE accountId = ? AND region = ? AND battlegroup = ?"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 90, sql: "INSERT INTO account_last_played_character (accountId, region, battlegroup, realmId, characterName, characterGUID, lastPlayedTime) VALUES (?,?,?,?,?,?,?)"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 94, sql: "UPDATE battlenet_accounts SET sha_pass_hash = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 96, sql: "UPDATE battlenet_accounts SET locked = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 97, sql: "UPDATE battlenet_accounts SET lock_country = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 99, sql: "UPDATE account SET battlenet_account = ?, battlenet_index = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 102, sql: "SELECT a.username, a.expansion, ab.bandate, ab.unbandate, ab.banreason FROM account AS a LEFT JOIN account_banned AS ab ON a.id = ab.id AND ab.active = 1 INNER JOIN battlenet_accounts AS ba ON a.battlenet_account = ba.id WHERE ba.LoginTicket = ? ORDER BY a.id"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 103, sql: "UPDATE battlenet_accounts SET failed_logins = failed_logins + 1 WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 104, sql: "INSERT INTO battlenet_account_bans(id, bandate, unbandate, bannedby, banreason) VALUES(?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban')"
Table 'auth.battlenet_account_bans' doesn't exist
In mysql_stmt_prepare() id: 105, sql: "DELETE FROM battlenet_account_bans WHERE unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.battlenet_account_bans' doesn't exist
In mysql_stmt_prepare() id: 106, sql: "UPDATE battlenet_accounts SET failed_logins = 0 WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 107, sql: "SELECT LastCharacterUndelete FROM battlenet_accounts WHERE Id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 108, sql: "UPDATE battlenet_accounts SET LastCharacterUndelete = UNIX_TIMESTAMP() WHERE Id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 109, sql: "SELECT itemId, isFavourite FROM battlenet_account_toys WHERE accountId = ?"
Table 'auth.battlenet_account_toys' doesn't exist
In mysql_stmt_prepare() id: 110, sql: "REPLACE INTO battlenet_account_toys (accountId, itemId, isFavourite) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_toys' doesn't exist
In mysql_stmt_prepare() id: 111, sql: "SELECT guid, species, breed, level, exp, health, quality, flags, name FROM battle_pets WHERE battlenetAccountId = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 112, sql: "INSERT INTO battle_pets (guid, battlenetAccountId, species, breed, level, exp, health, quality, flags, name) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 113, sql: "DELETE FROM battle_pets WHERE battlenetAccountId = ? AND guid = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 114, sql: "UPDATE battle_pets SET level = ?, exp = ?, health = ?, quality = ?, flags = ?, name = ? WHERE battlenetAccountId = ? AND guid = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 115, sql: "SELECT id, battlePetGuid, locked FROM battle_pet_slots WHERE battlenetAccountId = ?"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 116, sql: "INSERT INTO battle_pet_slots (id, battlenetAccountId, battlePetGuid, locked) VALUES (?, ?, ?, ?)"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 117, sql: "DELETE FROM battle_pet_slots WHERE battlenetAccountId = ?"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 118, sql: "SELECT itemId, flags FROM battlenet_account_heirlooms WHERE accountId = ?"
Table 'auth.battlenet_account_heirlooms' doesn't exist
In mysql_stmt_prepare() id: 119, sql: "REPLACE INTO battlenet_account_heirlooms (accountId, itemId, flags) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_heirlooms' doesn't exist
In mysql_stmt_prepare() id: 120, sql: "SELECT mountSpellId, flags FROM battlenet_account_mounts WHERE battlenetAccountId = ?"
Table 'auth.battlenet_account_mounts' doesn't exist
In mysql_stmt_prepare() id: 121, sql: "REPLACE INTO battlenet_account_mounts (battlenetAccountId, mountSpellId, flags) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_mounts' doesn't exist
In mysql_stmt_prepare() id: 122, sql: "SELECT blobIndex, appearanceMask FROM battlenet_item_appearances WHERE battlenetAccountId = ? ORDER BY blobIndex DESC"
Table 'auth.battlenet_item_appearances' doesn't exist
In mysql_stmt_prepare() id: 123, sql: "INSERT INTO battlenet_item_appearances (battlenetAccountId, blobIndex, appearanceMask) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE appearanceMask = appearanceMask | VALUES(appearanceMask)"
Table 'auth.battlenet_item_appearances' doesn't exist
In mysql_stmt_prepare() id: 124, sql: "SELECT itemModifiedAppearanceId FROM battlenet_item_favorite_appearances WHERE battlenetAccountId = ?"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 125, sql: "INSERT INTO battlenet_item_favorite_appearances (battlenetAccountId, itemModifiedAppearanceId) VALUES (?, ?)"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 126, sql: "DELETE FROM battlenet_item_favorite_appearances WHERE battlenetAccountId = ? AND itemModifiedAppearanceId = ?"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 1, sql: "DELETE FROM ip_banned WHERE unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 2, sql: "UPDATE account_banned SET active = 0 WHERE active = 1 AND unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 3, sql: "(SELECT unbandate > UNIX_TIMESTAMP() OR unbandate = bandate AS banned, NULL as country FROM ip_banned WHERE ip = ?) UNION (SELECT NULL AS banned, country FROM ip2nation WHERE INET_NTOA(ip) = ?)"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 4, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban')"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 7, sql: "DELETE FROM account_banned WHERE id = ?"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 8, sql: "UPDATE account SET sessionkey = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 9, sql: "SELECT username, sessionkey FROM account WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 10, sql: "UPDATE account SET v = ?, s = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 14, sql: "SELECT a.id, a.sessionkey, ba.last_ip, ba.locked, ba.lock_country, a.expansion, a.mutetime, ba.locale, a.recruiter, a.os, ba.id, ba.email, aa.gmLevel, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, ab.unbandate > UNIX_TIMESTAMP() OR ab.unbandate = ab.bandate, r.id FROM account a LEFT JOIN account r ON a.id = r.recruiter LEFT JOIN battlenet_accounts ba ON a.battlenet_account = ba.id LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID IN (-1, ?) LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 WHERE a.username = ? ORDER BY aa.RealmID DESC LIMIT 1"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 17, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?)"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 18, sql: "DELETE FROM ip_banned WHERE ip = ?"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 22, sql: "INSERT INTO account_banned VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?, 1)"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 23, sql: "UPDATE account_banned SET active = 0 WHERE id = ? AND active != 0"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 24, sql: "DELETE FROM realmcharacters WHERE acctid = ? AND realmid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 25, sql: "DELETE FROM realmcharacters WHERE acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 26, sql: "INSERT INTO realmcharacters (numchars, acctid, realmid) VALUES (?, ?, ?)"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 27, sql: "SELECT SUM(numchars) FROM realmcharacters WHERE acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 29, sql: "INSERT INTO realmcharacters (realmid, acctid, numchars) SELECT realmlist.id, account.id, 0 FROM realmlist, account LEFT JOIN realmcharacters ON acctid=account.id WHERE acctid IS NULL"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 30, sql: "UPDATE account SET expansion = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 31, sql: "UPDATE account SET locked = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 32, sql: "UPDATE account SET lock_country = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 33, sql: "INSERT INTO logs (time, realm, type, level, string) VALUES (?, ?, ?, ?, ?)"
Table 'auth.logs' doesn't exist
In mysql_stmt_prepare() id: 34, sql: "UPDATE account SET v = 0, s = 0, username = ?, sha_pass_hash = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 35, sql: "UPDATE account SET v = 0, s = 0, sha_pass_hash = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 36, sql: "UPDATE account SET email = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 37, sql: "UPDATE account SET reg_mail = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 38, sql: "UPDATE account SET mutetime = ? , mutereason = ? , muteby = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 39, sql: "UPDATE account SET mutetime = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 40, sql: "UPDATE account SET last_ip = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 41, sql: "UPDATE account SET last_attempt_ip = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 42, sql: "UPDATE account SET online = 1 WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 43, sql: "UPDATE uptime SET uptime = ?, maxplayers = ? WHERE realmid = ? AND starttime = ?"
Table 'auth.uptime' doesn't exist
In mysql_stmt_prepare() id: 44, sql: "DELETE FROM logs WHERE (time + ?) < ? AND realm = ?"
Table 'auth.logs' doesn't exist
In mysql_stmt_prepare() id: 45, sql: "DELETE FROM account_access WHERE id = ?"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 46, sql: "DELETE FROM account_access WHERE id = ? AND (RealmID = ? OR RealmID = -1)"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 47, sql: "INSERT INTO account_access (id,gmlevel,RealmID) VALUES (?, ?, ?)"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 62, sql: "DELETE FROM account WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 68, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, (SELECT last_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 69, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, (SELECT last_attempt_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 70, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, ?, ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 71, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, 0, 1, ?, ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 73, sql: "SELECT permissionId, granted FROM rbac_account_permissions WHERE accountId = ? AND (realmId = ? OR realmId = -1) ORDER BY permissionId, realmId"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 74, sql: "INSERT INTO rbac_account_permissions (accountId, permissionId, granted, realmId) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE granted = VALUES(granted)"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 75, sql: "DELETE FROM rbac_account_permissions WHERE accountId = ? AND permissionId = ? AND (realmId = ? OR realmId = -1)"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 76, sql: "INSERT INTO account_muted VALUES (?, UNIX_TIMESTAMP(), ?, ?, ?)"
Table 'auth.account_muted' doesn't exist
In mysql_stmt_prepare() id: 78, sql: "DELETE FROM account_muted WHERE guid = ?"
Table 'auth.account_muted' doesn't exist
In mysql_stmt_prepare() id: 79, sql: "SELECT ba.id, ba.sha_pass_hash, ba.failed_logins, ba.LoginTicket, ba.LoginTicketExpiry, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id WHERE email = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 80, sql: "UPDATE battlenet_accounts SET LoginTicket = ?, LoginTicketExpiry = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 81, sql: "SELECT LoginTicketExpiry FROM battlenet_accounts WHERE LoginTicket = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 82, sql: "UPDATE battlenet_accounts SET LoginTicketExpiry = ? WHERE LoginTicket = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 83, sql: "SELECT ba.id, UPPER(ba.email), ba.locked, ba.lock_country, ba.last_ip, ba.LoginTicketExpiry, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, bab.unbandate = bab.bandate, a.id, a.username, ab.unbandate, ab.unbandate = ab.bandate, aa.gmlevel FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account a ON ba.id = a.battlenet_account LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID = -1 WHERE ba.LoginTicket = ? ORDER BY a.id"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 84, sql: "UPDATE battlenet_accounts SET last_ip = ?, last_login = NOW(), locale = ?, failed_logins = 0, os = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 86, sql: "SELECT rc.acctid, rc.numchars, r.id, r.Region, r.Battlegroup FROM realmcharacters rc INNER JOIN realmlist r ON rc.realmid = r.id WHERE rc.acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 87, sql: "SELECT rc.acctid, rc.numchars, r.id, r.Region, r.Battlegroup FROM realmcharacters rc INNER JOIN realmlist r ON rc.realmid = r.id LEFT JOIN account a ON rc.acctid = a.id WHERE a.battlenet_account = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 88, sql: "SELECT lpc.accountId, lpc.region, lpc.battlegroup, lpc.realmId, lpc.characterName, lpc.characterGUID, lpc.lastPlayedTime FROM account_last_played_character lpc LEFT JOIN account a ON lpc.accountId = a.id WHERE a.battlenet_account = ?"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 89, sql: "DELETE FROM account_last_played_character WHERE accountId = ? AND region = ? AND battlegroup = ?"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 90, sql: "INSERT INTO account_last_played_character (accountId, region, battlegroup, realmId, characterName, characterGUID, lastPlayedTime) VALUES (?,?,?,?,?,?,?)"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 94, sql: "UPDATE battlenet_accounts SET sha_pass_hash = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 96, sql: "UPDATE battlenet_accounts SET locked = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 97, sql: "UPDATE battlenet_accounts SET lock_country = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 99, sql: "UPDATE account SET battlenet_account = ?, battlenet_index = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 102, sql: "SELECT a.username, a.expansion, ab.bandate, ab.unbandate, ab.banreason FROM account AS a LEFT JOIN account_banned AS ab ON a.id = ab.id AND ab.active = 1 INNER JOIN battlenet_accounts AS ba ON a.battlenet_account = ba.id WHERE ba.LoginTicket = ? ORDER BY a.id"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 103, sql: "UPDATE battlenet_accounts SET failed_logins = failed_logins + 1 WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 104, sql: "INSERT INTO battlenet_account_bans(id, bandate, unbandate, bannedby, banreason) VALUES(?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban')"
Table 'auth.battlenet_account_bans' doesn't exist
In mysql_stmt_prepare() id: 105, sql: "DELETE FROM battlenet_account_bans WHERE unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.battlenet_account_bans' doesn't exist
In mysql_stmt_prepare() id: 106, sql: "UPDATE battlenet_accounts SET failed_logins = 0 WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 107, sql: "SELECT LastCharacterUndelete FROM battlenet_accounts WHERE Id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 108, sql: "UPDATE battlenet_accounts SET LastCharacterUndelete = UNIX_TIMESTAMP() WHERE Id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 109, sql: "SELECT itemId, isFavourite FROM battlenet_account_toys WHERE accountId = ?"
Table 'auth.battlenet_account_toys' doesn't exist
In mysql_stmt_prepare() id: 110, sql: "REPLACE INTO battlenet_account_toys (accountId, itemId, isFavourite) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_toys' doesn't exist
In mysql_stmt_prepare() id: 111, sql: "SELECT guid, species, breed, level, exp, health, quality, flags, name FROM battle_pets WHERE battlenetAccountId = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 112, sql: "INSERT INTO battle_pets (guid, battlenetAccountId, species, breed, level, exp, health, quality, flags, name) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 113, sql: "DELETE FROM battle_pets WHERE battlenetAccountId = ? AND guid = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 114, sql: "UPDATE battle_pets SET level = ?, exp = ?, health = ?, quality = ?, flags = ?, name = ? WHERE battlenetAccountId = ? AND guid = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 115, sql: "SELECT id, battlePetGuid, locked FROM battle_pet_slots WHERE battlenetAccountId = ?"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 116, sql: "INSERT INTO battle_pet_slots (id, battlenetAccountId, battlePetGuid, locked) VALUES (?, ?, ?, ?)"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 117, sql: "DELETE FROM battle_pet_slots WHERE battlenetAccountId = ?"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 118, sql: "SELECT itemId, flags FROM battlenet_account_heirlooms WHERE accountId = ?"
Table 'auth.battlenet_account_heirlooms' doesn't exist
In mysql_stmt_prepare() id: 119, sql: "REPLACE INTO battlenet_account_heirlooms (accountId, itemId, flags) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_heirlooms' doesn't exist
In mysql_stmt_prepare() id: 120, sql: "SELECT mountSpellId, flags FROM battlenet_account_mounts WHERE battlenetAccountId = ?"
Table 'auth.battlenet_account_mounts' doesn't exist
In mysql_stmt_prepare() id: 121, sql: "REPLACE INTO battlenet_account_mounts (battlenetAccountId, mountSpellId, flags) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_mounts' doesn't exist
In mysql_stmt_prepare() id: 122, sql: "SELECT blobIndex, appearanceMask FROM battlenet_item_appearances WHERE battlenetAccountId = ? ORDER BY blobIndex DESC"
Table 'auth.battlenet_item_appearances' doesn't exist
In mysql_stmt_prepare() id: 123, sql: "INSERT INTO battlenet_item_appearances (battlenetAccountId, blobIndex, appearanceMask) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE appearanceMask = appearanceMask | VALUES(appearanceMask)"
Table 'auth.battlenet_item_appearances' doesn't exist
In mysql_stmt_prepare() id: 124, sql: "SELECT itemModifiedAppearanceId FROM battlenet_item_favorite_appearances WHERE battlenetAccountId = ?"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 125, sql: "INSERT INTO battlenet_item_favorite_appearances (battlenetAccountId, itemModifiedAppearanceId) VALUES (?, ?)"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 126, sql: "DELETE FROM battlenet_item_favorite_appearances WHERE battlenetAccountId = ? AND itemModifiedAppearanceId = ?"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 1, sql: "DELETE FROM ip_banned WHERE unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 2, sql: "UPDATE account_banned SET active = 0 WHERE active = 1 AND unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 3, sql: "(SELECT unbandate > UNIX_TIMESTAMP() OR unbandate = bandate AS banned, NULL as country FROM ip_banned WHERE ip = ?) UNION (SELECT NULL AS banned, country FROM ip2nation WHERE INET_NTOA(ip) = ?)"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 4, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban')"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 7, sql: "DELETE FROM account_banned WHERE id = ?"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 8, sql: "UPDATE account SET sessionkey = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 9, sql: "SELECT username, sessionkey FROM account WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 10, sql: "UPDATE account SET v = ?, s = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 14, sql: "SELECT a.id, a.sessionkey, ba.last_ip, ba.locked, ba.lock_country, a.expansion, a.mutetime, ba.locale, a.recruiter, a.os, ba.id, ba.email, aa.gmLevel, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, ab.unbandate > UNIX_TIMESTAMP() OR ab.unbandate = ab.bandate, r.id FROM account a LEFT JOIN account r ON a.id = r.recruiter LEFT JOIN battlenet_accounts ba ON a.battlenet_account = ba.id LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID IN (-1, ?) LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 WHERE a.username = ? ORDER BY aa.RealmID DESC LIMIT 1"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 17, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?)"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 18, sql: "DELETE FROM ip_banned WHERE ip = ?"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 22, sql: "INSERT INTO account_banned VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?, 1)"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 23, sql: "UPDATE account_banned SET active = 0 WHERE id = ? AND active != 0"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 24, sql: "DELETE FROM realmcharacters WHERE acctid = ? AND realmid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 25, sql: "DELETE FROM realmcharacters WHERE acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 26, sql: "INSERT INTO realmcharacters (numchars, acctid, realmid) VALUES (?, ?, ?)"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 27, sql: "SELECT SUM(numchars) FROM realmcharacters WHERE acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 29, sql: "INSERT INTO realmcharacters (realmid, acctid, numchars) SELECT realmlist.id, account.id, 0 FROM realmlist, account LEFT JOIN realmcharacters ON acctid=account.id WHERE acctid IS NULL"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 30, sql: "UPDATE account SET expansion = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 31, sql: "UPDATE account SET locked = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 32, sql: "UPDATE account SET lock_country = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 33, sql: "INSERT INTO logs (time, realm, type, level, string) VALUES (?, ?, ?, ?, ?)"
Table 'auth.logs' doesn't exist
In mysql_stmt_prepare() id: 34, sql: "UPDATE account SET v = 0, s = 0, username = ?, sha_pass_hash = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 35, sql: "UPDATE account SET v = 0, s = 0, sha_pass_hash = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 36, sql: "UPDATE account SET email = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 37, sql: "UPDATE account SET reg_mail = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 38, sql: "UPDATE account SET mutetime = ? , mutereason = ? , muteby = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 39, sql: "UPDATE account SET mutetime = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 40, sql: "UPDATE account SET last_ip = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 41, sql: "UPDATE account SET last_attempt_ip = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 42, sql: "UPDATE account SET online = 1 WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 43, sql: "UPDATE uptime SET uptime = ?, maxplayers = ? WHERE realmid = ? AND starttime = ?"
Table 'auth.uptime' doesn't exist
In mysql_stmt_prepare() id: 44, sql: "DELETE FROM logs WHERE (time + ?) < ? AND realm = ?"
Table 'auth.logs' doesn't exist
In mysql_stmt_prepare() id: 45, sql: "DELETE FROM account_access WHERE id = ?"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 46, sql: "DELETE FROM account_access WHERE id = ? AND (RealmID = ? OR RealmID = -1)"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 47, sql: "INSERT INTO account_access (id,gmlevel,RealmID) VALUES (?, ?, ?)"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 62, sql: "DELETE FROM account WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 68, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, (SELECT last_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 69, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, (SELECT last_attempt_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 70, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, ?, ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 71, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, 0, 1, ?, ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 73, sql: "SELECT permissionId, granted FROM rbac_account_permissions WHERE accountId = ? AND (realmId = ? OR realmId = -1) ORDER BY permissionId, realmId"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 74, sql: "INSERT INTO rbac_account_permissions (accountId, permissionId, granted, realmId) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE granted = VALUES(granted)"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 75, sql: "DELETE FROM rbac_account_permissions WHERE accountId = ? AND permissionId = ? AND (realmId = ? OR realmId = -1)"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 76, sql: "INSERT INTO account_muted VALUES (?, UNIX_TIMESTAMP(), ?, ?, ?)"
Table 'auth.account_muted' doesn't exist
In mysql_stmt_prepare() id: 78, sql: "DELETE FROM account_muted WHERE guid = ?"
Table 'auth.account_muted' doesn't exist
In mysql_stmt_prepare() id: 79, sql: "SELECT ba.id, ba.sha_pass_hash, ba.failed_logins, ba.LoginTicket, ba.LoginTicketExpiry, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id WHERE email = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 80, sql: "UPDATE battlenet_accounts SET LoginTicket = ?, LoginTicketExpiry = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 81, sql: "SELECT LoginTicketExpiry FROM battlenet_accounts WHERE LoginTicket = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 82, sql: "UPDATE battlenet_accounts SET LoginTicketExpiry = ? WHERE LoginTicket = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 83, sql: "SELECT ba.id, UPPER(ba.email), ba.locked, ba.lock_country, ba.last_ip, ba.LoginTicketExpiry, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, bab.unbandate = bab.bandate, a.id, a.username, ab.unbandate, ab.unbandate = ab.bandate, aa.gmlevel FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account a ON ba.id = a.battlenet_account LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID = -1 WHERE ba.LoginTicket = ? ORDER BY a.id"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 84, sql: "UPDATE battlenet_accounts SET last_ip = ?, last_login = NOW(), locale = ?, failed_logins = 0, os = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 86, sql: "SELECT rc.acctid, rc.numchars, r.id, r.Region, r.Battlegroup FROM realmcharacters rc INNER JOIN realmlist r ON rc.realmid = r.id WHERE rc.acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 87, sql: "SELECT rc.acctid, rc.numchars, r.id, r.Region, r.Battlegroup FROM realmcharacters rc INNER JOIN realmlist r ON rc.realmid = r.id LEFT JOIN account a ON rc.acctid = a.id WHERE a.battlenet_account = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 88, sql: "SELECT lpc.accountId, lpc.region, lpc.battlegroup, lpc.realmId, lpc.characterName, lpc.characterGUID, lpc.lastPlayedTime FROM account_last_played_character lpc LEFT JOIN account a ON lpc.accountId = a.id WHERE a.battlenet_account = ?"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 89, sql: "DELETE FROM account_last_played_character WHERE accountId = ? AND region = ? AND battlegroup = ?"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 90, sql: "INSERT INTO account_last_played_character (accountId, region, battlegroup, realmId, characterName, characterGUID, lastPlayedTime) VALUES (?,?,?,?,?,?,?)"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 94, sql: "UPDATE battlenet_accounts SET sha_pass_hash = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 96, sql: "UPDATE battlenet_accounts SET locked = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 97, sql: "UPDATE battlenet_accounts SET lock_country = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 99, sql: "UPDATE account SET battlenet_account = ?, battlenet_index = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 102, sql: "SELECT a.username, a.expansion, ab.bandate, ab.unbandate, ab.banreason FROM account AS a LEFT JOIN account_banned AS ab ON a.id = ab.id AND ab.active = 1 INNER JOIN battlenet_accounts AS ba ON a.battlenet_account = ba.id WHERE ba.LoginTicket = ? ORDER BY a.id"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 103, sql: "UPDATE battlenet_accounts SET failed_logins = failed_logins + 1 WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 104, sql: "INSERT INTO battlenet_account_bans(id, bandate, unbandate, bannedby, banreason) VALUES(?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban')"
Table 'auth.battlenet_account_bans' doesn't exist
In mysql_stmt_prepare() id: 105, sql: "DELETE FROM battlenet_account_bans WHERE unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.battlenet_account_bans' doesn't exist
In mysql_stmt_prepare() id: 106, sql: "UPDATE battlenet_accounts SET failed_logins = 0 WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 107, sql: "SELECT LastCharacterUndelete FROM battlenet_accounts WHERE Id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 108, sql: "UPDATE battlenet_accounts SET LastCharacterUndelete = UNIX_TIMESTAMP() WHERE Id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 109, sql: "SELECT itemId, isFavourite FROM battlenet_account_toys WHERE accountId = ?"
Table 'auth.battlenet_account_toys' doesn't exist
In mysql_stmt_prepare() id: 110, sql: "REPLACE INTO battlenet_account_toys (accountId, itemId, isFavourite) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_toys' doesn't exist
In mysql_stmt_prepare() id: 111, sql: "SELECT guid, species, breed, level, exp, health, quality, flags, name FROM battle_pets WHERE battlenetAccountId = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 112, sql: "INSERT INTO battle_pets (guid, battlenetAccountId, species, breed, level, exp, health, quality, flags, name) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 113, sql: "DELETE FROM battle_pets WHERE battlenetAccountId = ? AND guid = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 114, sql: "UPDATE battle_pets SET level = ?, exp = ?, health = ?, quality = ?, flags = ?, name = ? WHERE battlenetAccountId = ? AND guid = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 115, sql: "SELECT id, battlePetGuid, locked FROM battle_pet_slots WHERE battlenetAccountId = ?"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 116, sql: "INSERT INTO battle_pet_slots (id, battlenetAccountId, battlePetGuid, locked) VALUES (?, ?, ?, ?)"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 117, sql: "DELETE FROM battle_pet_slots WHERE battlenetAccountId = ?"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 118, sql: "SELECT itemId, flags FROM battlenet_account_heirlooms WHERE accountId = ?"
Table 'auth.battlenet_account_heirlooms' doesn't exist
In mysql_stmt_prepare() id: 119, sql: "REPLACE INTO battlenet_account_heirlooms (accountId, itemId, flags) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_heirlooms' doesn't exist
In mysql_stmt_prepare() id: 120, sql: "SELECT mountSpellId, flags FROM battlenet_account_mounts WHERE battlenetAccountId = ?"
Table 'auth.battlenet_account_mounts' doesn't exist
In mysql_stmt_prepare() id: 121, sql: "REPLACE INTO battlenet_account_mounts (battlenetAccountId, mountSpellId, flags) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_mounts' doesn't exist
In mysql_stmt_prepare() id: 122, sql: "SELECT blobIndex, appearanceMask FROM battlenet_item_appearances WHERE battlenetAccountId = ? ORDER BY blobIndex DESC"
Table 'auth.battlenet_item_appearances' doesn't exist
In mysql_stmt_prepare() id: 123, sql: "INSERT INTO battlenet_item_appearances (battlenetAccountId, blobIndex, appearanceMask) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE appearanceMask = appearanceMask | VALUES(appearanceMask)"
Table 'auth.battlenet_item_appearances' doesn't exist
In mysql_stmt_prepare() id: 124, sql: "SELECT itemModifiedAppearanceId FROM battlenet_item_favorite_appearances WHERE battlenetAccountId = ?"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 125, sql: "INSERT INTO battlenet_item_favorite_appearances (battlenetAccountId, itemModifiedAppearanceId) VALUES (?, ?)"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 126, sql: "DELETE FROM battlenet_item_favorite_appearances WHERE battlenetAccountId = ? AND itemModifiedAppearanceId = ?"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 1, sql: "DELETE FROM ip_banned WHERE unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 2, sql: "UPDATE account_banned SET active = 0 WHERE active = 1 AND unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 3, sql: "(SELECT unbandate > UNIX_TIMESTAMP() OR unbandate = bandate AS banned, NULL as country FROM ip_banned WHERE ip = ?) UNION (SELECT NULL AS banned, country FROM ip2nation WHERE INET_NTOA(ip) = ?)"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 4, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban')"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 7, sql: "DELETE FROM account_banned WHERE id = ?"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 8, sql: "UPDATE account SET sessionkey = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 9, sql: "SELECT username, sessionkey FROM account WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 10, sql: "UPDATE account SET v = ?, s = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 14, sql: "SELECT a.id, a.sessionkey, ba.last_ip, ba.locked, ba.lock_country, a.expansion, a.mutetime, ba.locale, a.recruiter, a.os, ba.id, ba.email, aa.gmLevel, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, ab.unbandate > UNIX_TIMESTAMP() OR ab.unbandate = ab.bandate, r.id FROM account a LEFT JOIN account r ON a.id = r.recruiter LEFT JOIN battlenet_accounts ba ON a.battlenet_account = ba.id LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID IN (-1, ?) LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 WHERE a.username = ? ORDER BY aa.RealmID DESC LIMIT 1"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 17, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?)"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 18, sql: "DELETE FROM ip_banned WHERE ip = ?"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 22, sql: "INSERT INTO account_banned VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?, 1)"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 23, sql: "UPDATE account_banned SET active = 0 WHERE id = ? AND active != 0"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 24, sql: "DELETE FROM realmcharacters WHERE acctid = ? AND realmid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 25, sql: "DELETE FROM realmcharacters WHERE acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 26, sql: "INSERT INTO realmcharacters (numchars, acctid, realmid) VALUES (?, ?, ?)"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 27, sql: "SELECT SUM(numchars) FROM realmcharacters WHERE acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 29, sql: "INSERT INTO realmcharacters (realmid, acctid, numchars) SELECT realmlist.id, account.id, 0 FROM realmlist, account LEFT JOIN realmcharacters ON acctid=account.id WHERE acctid IS NULL"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 30, sql: "UPDATE account SET expansion = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 31, sql: "UPDATE account SET locked = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 32, sql: "UPDATE account SET lock_country = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 33, sql: "INSERT INTO logs (time, realm, type, level, string) VALUES (?, ?, ?, ?, ?)"
Table 'auth.logs' doesn't exist
In mysql_stmt_prepare() id: 34, sql: "UPDATE account SET v = 0, s = 0, username = ?, sha_pass_hash = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 35, sql: "UPDATE account SET v = 0, s = 0, sha_pass_hash = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 36, sql: "UPDATE account SET email = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 37, sql: "UPDATE account SET reg_mail = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 38, sql: "UPDATE account SET mutetime = ? , mutereason = ? , muteby = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 39, sql: "UPDATE account SET mutetime = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 40, sql: "UPDATE account SET last_ip = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 41, sql: "UPDATE account SET last_attempt_ip = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 42, sql: "UPDATE account SET online = 1 WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 43, sql: "UPDATE uptime SET uptime = ?, maxplayers = ? WHERE realmid = ? AND starttime = ?"
Table 'auth.uptime' doesn't exist
In mysql_stmt_prepare() id: 44, sql: "DELETE FROM logs WHERE (time + ?) < ? AND realm = ?"
Table 'auth.logs' doesn't exist
In mysql_stmt_prepare() id: 45, sql: "DELETE FROM account_access WHERE id = ?"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 46, sql: "DELETE FROM account_access WHERE id = ? AND (RealmID = ? OR RealmID = -1)"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 47, sql: "INSERT INTO account_access (id,gmlevel,RealmID) VALUES (?, ?, ?)"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 62, sql: "DELETE FROM account WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 68, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, (SELECT last_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 69, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, (SELECT last_attempt_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 70, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, ?, ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 71, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, 0, 1, ?, ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 73, sql: "SELECT permissionId, granted FROM rbac_account_permissions WHERE accountId = ? AND (realmId = ? OR realmId = -1) ORDER BY permissionId, realmId"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 74, sql: "INSERT INTO rbac_account_permissions (accountId, permissionId, granted, realmId) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE granted = VALUES(granted)"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 75, sql: "DELETE FROM rbac_account_permissions WHERE accountId = ? AND permissionId = ? AND (realmId = ? OR realmId = -1)"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 76, sql: "INSERT INTO account_muted VALUES (?, UNIX_TIMESTAMP(), ?, ?, ?)"
Table 'auth.account_muted' doesn't exist
In mysql_stmt_prepare() id: 78, sql: "DELETE FROM account_muted WHERE guid = ?"
Table 'auth.account_muted' doesn't exist
In mysql_stmt_prepare() id: 79, sql: "SELECT ba.id, ba.sha_pass_hash, ba.failed_logins, ba.LoginTicket, ba.LoginTicketExpiry, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id WHERE email = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 80, sql: "UPDATE battlenet_accounts SET LoginTicket = ?, LoginTicketExpiry = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 81, sql: "SELECT LoginTicketExpiry FROM battlenet_accounts WHERE LoginTicket = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 82, sql: "UPDATE battlenet_accounts SET LoginTicketExpiry = ? WHERE LoginTicket = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 83, sql: "SELECT ba.id, UPPER(ba.email), ba.locked, ba.lock_country, ba.last_ip, ba.LoginTicketExpiry, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, bab.unbandate = bab.bandate, a.id, a.username, ab.unbandate, ab.unbandate = ab.bandate, aa.gmlevel FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account a ON ba.id = a.battlenet_account LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID = -1 WHERE ba.LoginTicket = ? ORDER BY a.id"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 84, sql: "UPDATE battlenet_accounts SET last_ip = ?, last_login = NOW(), locale = ?, failed_logins = 0, os = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 86, sql: "SELECT rc.acctid, rc.numchars, r.id, r.Region, r.Battlegroup FROM realmcharacters rc INNER JOIN realmlist r ON rc.realmid = r.id WHERE rc.acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 87, sql: "SELECT rc.acctid, rc.numchars, r.id, r.Region, r.Battlegroup FROM realmcharacters rc INNER JOIN realmlist r ON rc.realmid = r.id LEFT JOIN account a ON rc.acctid = a.id WHERE a.battlenet_account = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 88, sql: "SELECT lpc.accountId, lpc.region, lpc.battlegroup, lpc.realmId, lpc.characterName, lpc.characterGUID, lpc.lastPlayedTime FROM account_last_played_character lpc LEFT JOIN account a ON lpc.accountId = a.id WHERE a.battlenet_account = ?"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 89, sql: "DELETE FROM account_last_played_character WHERE accountId = ? AND region = ? AND battlegroup = ?"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 90, sql: "INSERT INTO account_last_played_character (accountId, region, battlegroup, realmId, characterName, characterGUID, lastPlayedTime) VALUES (?,?,?,?,?,?,?)"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 94, sql: "UPDATE battlenet_accounts SET sha_pass_hash = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 96, sql: "UPDATE battlenet_accounts SET locked = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 97, sql: "UPDATE battlenet_accounts SET lock_country = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 99, sql: "UPDATE account SET battlenet_account = ?, battlenet_index = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 102, sql: "SELECT a.username, a.expansion, ab.bandate, ab.unbandate, ab.banreason FROM account AS a LEFT JOIN account_banned AS ab ON a.id = ab.id AND ab.active = 1 INNER JOIN battlenet_accounts AS ba ON a.battlenet_account = ba.id WHERE ba.LoginTicket = ? ORDER BY a.id"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 103, sql: "UPDATE battlenet_accounts SET failed_logins = failed_logins + 1 WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 104, sql: "INSERT INTO battlenet_account_bans(id, bandate, unbandate, bannedby, banreason) VALUES(?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban')"
Table 'auth.battlenet_account_bans' doesn't exist
In mysql_stmt_prepare() id: 105, sql: "DELETE FROM battlenet_account_bans WHERE unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.battlenet_account_bans' doesn't exist
In mysql_stmt_prepare() id: 106, sql: "UPDATE battlenet_accounts SET failed_logins = 0 WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 107, sql: "SELECT LastCharacterUndelete FROM battlenet_accounts WHERE Id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 108, sql: "UPDATE battlenet_accounts SET LastCharacterUndelete = UNIX_TIMESTAMP() WHERE Id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 109, sql: "SELECT itemId, isFavourite FROM battlenet_account_toys WHERE accountId = ?"
Table 'auth.battlenet_account_toys' doesn't exist
In mysql_stmt_prepare() id: 110, sql: "REPLACE INTO battlenet_account_toys (accountId, itemId, isFavourite) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_toys' doesn't exist
In mysql_stmt_prepare() id: 111, sql: "SELECT guid, species, breed, level, exp, health, quality, flags, name FROM battle_pets WHERE battlenetAccountId = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 112, sql: "INSERT INTO battle_pets (guid, battlenetAccountId, species, breed, level, exp, health, quality, flags, name) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 113, sql: "DELETE FROM battle_pets WHERE battlenetAccountId = ? AND guid = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 114, sql: "UPDATE battle_pets SET level = ?, exp = ?, health = ?, quality = ?, flags = ?, name = ? WHERE battlenetAccountId = ? AND guid = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 115, sql: "SELECT id, battlePetGuid, locked FROM battle_pet_slots WHERE battlenetAccountId = ?"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 116, sql: "INSERT INTO battle_pet_slots (id, battlenetAccountId, battlePetGuid, locked) VALUES (?, ?, ?, ?)"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 117, sql: "DELETE FROM battle_pet_slots WHERE battlenetAccountId = ?"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 118, sql: "SELECT itemId, flags FROM battlenet_account_heirlooms WHERE accountId = ?"
Table 'auth.battlenet_account_heirlooms' doesn't exist
In mysql_stmt_prepare() id: 119, sql: "REPLACE INTO battlenet_account_heirlooms (accountId, itemId, flags) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_heirlooms' doesn't exist
In mysql_stmt_prepare() id: 120, sql: "SELECT mountSpellId, flags FROM battlenet_account_mounts WHERE battlenetAccountId = ?"
Table 'auth.battlenet_account_mounts' doesn't exist
In mysql_stmt_prepare() id: 121, sql: "REPLACE INTO battlenet_account_mounts (battlenetAccountId, mountSpellId, flags) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_mounts' doesn't exist
In mysql_stmt_prepare() id: 122, sql: "SELECT blobIndex, appearanceMask FROM battlenet_item_appearances WHERE battlenetAccountId = ? ORDER BY blobIndex DESC"
Table 'auth.battlenet_item_appearances' doesn't exist
In mysql_stmt_prepare() id: 123, sql: "INSERT INTO battlenet_item_appearances (battlenetAccountId, blobIndex, appearanceMask) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE appearanceMask = appearanceMask | VALUES(appearanceMask)"
Table 'auth.battlenet_item_appearances' doesn't exist
In mysql_stmt_prepare() id: 124, sql: "SELECT itemModifiedAppearanceId FROM battlenet_item_favorite_appearances WHERE battlenetAccountId = ?"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 125, sql: "INSERT INTO battlenet_item_favorite_appearances (battlenetAccountId, itemModifiedAppearanceId) VALUES (?, ?)"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 126, sql: "DELETE FROM battlenet_item_favorite_appearances WHERE battlenetAccountId = ? AND itemModifiedAppearanceId = ?"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 1, sql: "DELETE FROM ip_banned WHERE unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 2, sql: "UPDATE account_banned SET active = 0 WHERE active = 1 AND unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 3, sql: "(SELECT unbandate > UNIX_TIMESTAMP() OR unbandate = bandate AS banned, NULL as country FROM ip_banned WHERE ip = ?) UNION (SELECT NULL AS banned, country FROM ip2nation WHERE INET_NTOA(ip) = ?)"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 4, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban')"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 7, sql: "DELETE FROM account_banned WHERE id = ?"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 8, sql: "UPDATE account SET sessionkey = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 9, sql: "SELECT username, sessionkey FROM account WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 10, sql: "UPDATE account SET v = ?, s = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 14, sql: "SELECT a.id, a.sessionkey, ba.last_ip, ba.locked, ba.lock_country, a.expansion, a.mutetime, ba.locale, a.recruiter, a.os, ba.id, ba.email, aa.gmLevel, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, ab.unbandate > UNIX_TIMESTAMP() OR ab.unbandate = ab.bandate, r.id FROM account a LEFT JOIN account r ON a.id = r.recruiter LEFT JOIN battlenet_accounts ba ON a.battlenet_account = ba.id LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID IN (-1, ?) LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 WHERE a.username = ? ORDER BY aa.RealmID DESC LIMIT 1"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 17, sql: "INSERT INTO ip_banned (ip, bandate, unbandate, bannedby, banreason) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?)"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 18, sql: "DELETE FROM ip_banned WHERE ip = ?"
Table 'auth.ip_banned' doesn't exist
In mysql_stmt_prepare() id: 22, sql: "INSERT INTO account_banned VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?, 1)"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 23, sql: "UPDATE account_banned SET active = 0 WHERE id = ? AND active != 0"
Table 'auth.account_banned' doesn't exist
In mysql_stmt_prepare() id: 24, sql: "DELETE FROM realmcharacters WHERE acctid = ? AND realmid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 25, sql: "DELETE FROM realmcharacters WHERE acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 26, sql: "INSERT INTO realmcharacters (numchars, acctid, realmid) VALUES (?, ?, ?)"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 27, sql: "SELECT SUM(numchars) FROM realmcharacters WHERE acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 29, sql: "INSERT INTO realmcharacters (realmid, acctid, numchars) SELECT realmlist.id, account.id, 0 FROM realmlist, account LEFT JOIN realmcharacters ON acctid=account.id WHERE acctid IS NULL"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 30, sql: "UPDATE account SET expansion = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 31, sql: "UPDATE account SET locked = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 32, sql: "UPDATE account SET lock_country = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 33, sql: "INSERT INTO logs (time, realm, type, level, string) VALUES (?, ?, ?, ?, ?)"
Table 'auth.logs' doesn't exist
In mysql_stmt_prepare() id: 34, sql: "UPDATE account SET v = 0, s = 0, username = ?, sha_pass_hash = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 35, sql: "UPDATE account SET v = 0, s = 0, sha_pass_hash = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 36, sql: "UPDATE account SET email = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 37, sql: "UPDATE account SET reg_mail = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 38, sql: "UPDATE account SET mutetime = ? , mutereason = ? , muteby = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 39, sql: "UPDATE account SET mutetime = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 40, sql: "UPDATE account SET last_ip = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 41, sql: "UPDATE account SET last_attempt_ip = ? WHERE username = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 42, sql: "UPDATE account SET online = 1 WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 43, sql: "UPDATE uptime SET uptime = ?, maxplayers = ? WHERE realmid = ? AND starttime = ?"
Table 'auth.uptime' doesn't exist
In mysql_stmt_prepare() id: 44, sql: "DELETE FROM logs WHERE (time + ?) < ? AND realm = ?"
Table 'auth.logs' doesn't exist
In mysql_stmt_prepare() id: 45, sql: "DELETE FROM account_access WHERE id = ?"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 46, sql: "DELETE FROM account_access WHERE id = ? AND (RealmID = ? OR RealmID = -1)"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 47, sql: "INSERT INTO account_access (id,gmlevel,RealmID) VALUES (?, ?, ?)"
Table 'auth.account_access' doesn't exist
In mysql_stmt_prepare() id: 62, sql: "DELETE FROM account WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 68, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, (SELECT last_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 69, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, (SELECT last_attempt_ip FROM account WHERE id = ?), ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 70, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, ?, ?, ?, ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 71, sql: "INSERT INTO logs_ip_actions (account_id,character_guid,type,ip,systemnote,unixtime,time) VALUES (?, 0, 1, ?, ?, unix_timestamp(NOW()), NOW())"
Table 'auth.logs_ip_actions' doesn't exist
In mysql_stmt_prepare() id: 73, sql: "SELECT permissionId, granted FROM rbac_account_permissions WHERE accountId = ? AND (realmId = ? OR realmId = -1) ORDER BY permissionId, realmId"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 74, sql: "INSERT INTO rbac_account_permissions (accountId, permissionId, granted, realmId) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE granted = VALUES(granted)"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 75, sql: "DELETE FROM rbac_account_permissions WHERE accountId = ? AND permissionId = ? AND (realmId = ? OR realmId = -1)"
Table 'auth.rbac_account_permissions' doesn't exist
In mysql_stmt_prepare() id: 76, sql: "INSERT INTO account_muted VALUES (?, UNIX_TIMESTAMP(), ?, ?, ?)"
Table 'auth.account_muted' doesn't exist
In mysql_stmt_prepare() id: 78, sql: "DELETE FROM account_muted WHERE guid = ?"
Table 'auth.account_muted' doesn't exist
In mysql_stmt_prepare() id: 79, sql: "SELECT ba.id, ba.sha_pass_hash, ba.failed_logins, ba.LoginTicket, ba.LoginTicketExpiry, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id WHERE email = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 80, sql: "UPDATE battlenet_accounts SET LoginTicket = ?, LoginTicketExpiry = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 81, sql: "SELECT LoginTicketExpiry FROM battlenet_accounts WHERE LoginTicket = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 82, sql: "UPDATE battlenet_accounts SET LoginTicketExpiry = ? WHERE LoginTicket = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 83, sql: "SELECT ba.id, UPPER(ba.email), ba.locked, ba.lock_country, ba.last_ip, ba.LoginTicketExpiry, bab.unbandate > UNIX_TIMESTAMP() OR bab.unbandate = bab.bandate, bab.unbandate = bab.bandate, a.id, a.username, ab.unbandate, ab.unbandate = ab.bandate, aa.gmlevel FROM battlenet_accounts ba LEFT JOIN battlenet_account_bans bab ON ba.id = bab.id LEFT JOIN account a ON ba.id = a.battlenet_account LEFT JOIN account_banned ab ON a.id = ab.id AND ab.active = 1 LEFT JOIN account_access aa ON a.id = aa.id AND aa.RealmID = -1 WHERE ba.LoginTicket = ? ORDER BY a.id"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 84, sql: "UPDATE battlenet_accounts SET last_ip = ?, last_login = NOW(), locale = ?, failed_logins = 0, os = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 86, sql: "SELECT rc.acctid, rc.numchars, r.id, r.Region, r.Battlegroup FROM realmcharacters rc INNER JOIN realmlist r ON rc.realmid = r.id WHERE rc.acctid = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 87, sql: "SELECT rc.acctid, rc.numchars, r.id, r.Region, r.Battlegroup FROM realmcharacters rc INNER JOIN realmlist r ON rc.realmid = r.id LEFT JOIN account a ON rc.acctid = a.id WHERE a.battlenet_account = ?"
Table 'auth.realmcharacters' doesn't exist
In mysql_stmt_prepare() id: 88, sql: "SELECT lpc.accountId, lpc.region, lpc.battlegroup, lpc.realmId, lpc.characterName, lpc.characterGUID, lpc.lastPlayedTime FROM account_last_played_character lpc LEFT JOIN account a ON lpc.accountId = a.id WHERE a.battlenet_account = ?"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 89, sql: "DELETE FROM account_last_played_character WHERE accountId = ? AND region = ? AND battlegroup = ?"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 90, sql: "INSERT INTO account_last_played_character (accountId, region, battlegroup, realmId, characterName, characterGUID, lastPlayedTime) VALUES (?,?,?,?,?,?,?)"
Table 'auth.account_last_played_character' doesn't exist
In mysql_stmt_prepare() id: 94, sql: "UPDATE battlenet_accounts SET sha_pass_hash = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 96, sql: "UPDATE battlenet_accounts SET locked = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 97, sql: "UPDATE battlenet_accounts SET lock_country = ? WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 99, sql: "UPDATE account SET battlenet_account = ?, battlenet_index = ? WHERE id = ?"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 102, sql: "SELECT a.username, a.expansion, ab.bandate, ab.unbandate, ab.banreason FROM account AS a LEFT JOIN account_banned AS ab ON a.id = ab.id AND ab.active = 1 INNER JOIN battlenet_accounts AS ba ON a.battlenet_account = ba.id WHERE ba.LoginTicket = ? ORDER BY a.id"
Table 'auth.account' doesn't exist
In mysql_stmt_prepare() id: 103, sql: "UPDATE battlenet_accounts SET failed_logins = failed_logins + 1 WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 104, sql: "INSERT INTO battlenet_account_bans(id, bandate, unbandate, bannedby, banreason) VALUES(?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, 'Trinity Auth', 'Failed login autoban')"
Table 'auth.battlenet_account_bans' doesn't exist
In mysql_stmt_prepare() id: 105, sql: "DELETE FROM battlenet_account_bans WHERE unbandate<>bandate AND unbandate<=UNIX_TIMESTAMP()"
Table 'auth.battlenet_account_bans' doesn't exist
In mysql_stmt_prepare() id: 106, sql: "UPDATE battlenet_accounts SET failed_logins = 0 WHERE id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 107, sql: "SELECT LastCharacterUndelete FROM battlenet_accounts WHERE Id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 108, sql: "UPDATE battlenet_accounts SET LastCharacterUndelete = UNIX_TIMESTAMP() WHERE Id = ?"
Table 'auth.battlenet_accounts' doesn't exist
In mysql_stmt_prepare() id: 109, sql: "SELECT itemId, isFavourite FROM battlenet_account_toys WHERE accountId = ?"
Table 'auth.battlenet_account_toys' doesn't exist
In mysql_stmt_prepare() id: 110, sql: "REPLACE INTO battlenet_account_toys (accountId, itemId, isFavourite) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_toys' doesn't exist
In mysql_stmt_prepare() id: 111, sql: "SELECT guid, species, breed, level, exp, health, quality, flags, name FROM battle_pets WHERE battlenetAccountId = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 112, sql: "INSERT INTO battle_pets (guid, battlenetAccountId, species, breed, level, exp, health, quality, flags, name) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 113, sql: "DELETE FROM battle_pets WHERE battlenetAccountId = ? AND guid = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 114, sql: "UPDATE battle_pets SET level = ?, exp = ?, health = ?, quality = ?, flags = ?, name = ? WHERE battlenetAccountId = ? AND guid = ?"
Table 'auth.battle_pets' doesn't exist
In mysql_stmt_prepare() id: 115, sql: "SELECT id, battlePetGuid, locked FROM battle_pet_slots WHERE battlenetAccountId = ?"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 116, sql: "INSERT INTO battle_pet_slots (id, battlenetAccountId, battlePetGuid, locked) VALUES (?, ?, ?, ?)"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 117, sql: "DELETE FROM battle_pet_slots WHERE battlenetAccountId = ?"
Table 'auth.battle_pet_slots' doesn't exist
In mysql_stmt_prepare() id: 118, sql: "SELECT itemId, flags FROM battlenet_account_heirlooms WHERE accountId = ?"
Table 'auth.battlenet_account_heirlooms' doesn't exist
In mysql_stmt_prepare() id: 119, sql: "REPLACE INTO battlenet_account_heirlooms (accountId, itemId, flags) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_heirlooms' doesn't exist
In mysql_stmt_prepare() id: 120, sql: "SELECT mountSpellId, flags FROM battlenet_account_mounts WHERE battlenetAccountId = ?"
Table 'auth.battlenet_account_mounts' doesn't exist
In mysql_stmt_prepare() id: 121, sql: "REPLACE INTO battlenet_account_mounts (battlenetAccountId, mountSpellId, flags) VALUES (?, ?, ?)"
Table 'auth.battlenet_account_mounts' doesn't exist
In mysql_stmt_prepare() id: 122, sql: "SELECT blobIndex, appearanceMask FROM battlenet_item_appearances WHERE battlenetAccountId = ? ORDER BY blobIndex DESC"
Table 'auth.battlenet_item_appearances' doesn't exist
In mysql_stmt_prepare() id: 123, sql: "INSERT INTO battlenet_item_appearances (battlenetAccountId, blobIndex, appearanceMask) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE appearanceMask = appearanceMask | VALUES(appearanceMask)"
Table 'auth.battlenet_item_appearances' doesn't exist
In mysql_stmt_prepare() id: 124, sql: "SELECT itemModifiedAppearanceId FROM battlenet_item_favorite_appearances WHERE battlenetAccountId = ?"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 125, sql: "INSERT INTO battlenet_item_favorite_appearances (battlenetAccountId, itemModifiedAppearanceId) VALUES (?, ?)"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist
In mysql_stmt_prepare() id: 126, sql: "DELETE FROM battlenet_item_favorite_appearances WHERE battlenetAccountId = ? AND itemModifiedAppearanceId = ?"
Table 'auth.battlenet_item_favorite_appearances' doesn't exist