AzerothCore 3.3.5a
OpenSource WoW Emulator
Loading...
Searching...
No Matches
Public Types | Public Member Functions | List of all members
CharacterDatabaseConnection Class Reference

#include "CharacterDatabase.h"

Inheritance diagram for CharacterDatabaseConnection:
MySQLConnection

Public Types

typedef CharacterDatabaseStatements Statements
 

Public Member Functions

 CharacterDatabaseConnection (MySQLConnectionInfo &connInfo)
 
 CharacterDatabaseConnection (ProducerConsumerQueue< SQLOperation * > *q, MySQLConnectionInfo &connInfo)
 
 ~CharacterDatabaseConnection () override
 
void DoPrepareStatements () override
 
- Public Member Functions inherited from MySQLConnection
 MySQLConnection (MySQLConnectionInfo &connInfo)
 
 MySQLConnection (ProducerConsumerQueue< SQLOperation * > *queue, MySQLConnectionInfo &connInfo)
 Constructor for synchronous connections.
 
virtual ~MySQLConnection ()
 Constructor for asynchronous connections.
 
virtual uint32 Open ()
 
void Close ()
 
bool PrepareStatements ()
 
bool Execute (std::string_view sql)
 
bool Execute (PreparedStatementBase *stmt)
 
ResultSet * Query (std::string_view sql)
 
PreparedResultSet * Query (PreparedStatementBase *stmt)
 
bool _Query (std::string_view sql, MySQLResult **pResult, MySQLField **pFields, uint64 *pRowCount, uint32 *pFieldCount)
 
bool _Query (PreparedStatementBase *stmt, MySQLPreparedStatement **mysqlStmt, MySQLResult **pResult, uint64 *pRowCount, uint32 *pFieldCount)
 
void BeginTransaction ()
 
void RollbackTransaction ()
 
void CommitTransaction ()
 
int ExecuteTransaction (std::shared_ptr< TransactionBase > transaction)
 
size_t EscapeString (char *to, const char *from, size_t length)
 
void Ping ()
 
uint32 GetLastError ()
 

Additional Inherited Members

- Protected Types inherited from MySQLConnection
typedef std::vector< std::unique_ptr< MySQLPreparedStatement > > PreparedStatementContainer
 
- Protected Member Functions inherited from MySQLConnection
bool LockIfReady ()
 
void Unlock ()
 Called by parent databasepool. Will let other threads access this connection.
 
uint32 GetServerVersion () const
 
MySQLPreparedStatement * GetPreparedStatement (uint32 index)
 
void PrepareStatement (uint32 index, std::string_view sql, ConnectionFlags flags)
 
virtual void DoPrepareStatements ()=0
 
virtual bool _HandleMySQLErrno (uint32 errNo, uint8 attempts=5)
 
- Protected Attributes inherited from MySQLConnection
PreparedStatementContainer m_stmts
 
bool m_reconnecting
 PreparedStatements storage.
 
bool m_prepareError
 Are we reconnecting?
 
MySQLHandle * m_Mysql
 Was there any error while preparing statements?
 

Detailed Description

Member Typedef Documentation

◆ Statements

typedef CharacterDatabaseStatements CharacterDatabaseConnection::Statements

Constructor & Destructor Documentation

◆ CharacterDatabaseConnection() [1/2]

CharacterDatabaseConnection::CharacterDatabaseConnection ( MySQLConnectionInfo &  connInfo)
614 : MySQLConnection(connInfo)
615{
616}
MySQLConnection
Definition: MySQLConnection.h:56

◆ CharacterDatabaseConnection() [2/2]

CharacterDatabaseConnection::CharacterDatabaseConnection ( ProducerConsumerQueue< SQLOperation * > *  q,
MySQLConnectionInfo &  connInfo 
)
618 : MySQLConnection(q, connInfo)
619{
620}

◆ ~CharacterDatabaseConnection()

CharacterDatabaseConnection::~CharacterDatabaseConnection ( )
override
623{
624}

Member Function Documentation

◆ DoPrepareStatements()

void CharacterDatabaseConnection::DoPrepareStatements ( )
overridevirtual

Implements MySQLConnection.

22{
23 if (!m_reconnecting)
24 m_stmts.resize(MAX_CHARACTERDATABASE_STATEMENTS);
25
26 PrepareStatement(CHAR_DEL_QUEST_POOL_SAVE, "DELETE FROM pool_quest_save WHERE pool_id = ?", CONNECTION_ASYNC);
27 PrepareStatement(CHAR_INS_QUEST_POOL_SAVE, "INSERT INTO pool_quest_save (pool_id, quest_id) VALUES (?, ?)", CONNECTION_ASYNC);
28 PrepareStatement(CHAR_DEL_NONEXISTENT_GUILD_BANK_ITEM, "DELETE FROM guild_bank_item WHERE guildid = ? AND TabId = ? AND SlotId = ?", CONNECTION_ASYNC);
29 PrepareStatement(CHAR_DEL_EXPIRED_BANS, "UPDATE character_banned SET active = 0 WHERE unbandate <= UNIX_TIMESTAMP() AND unbandate <> bandate", CONNECTION_ASYNC);
30 PrepareStatement(CHAR_SEL_DATA_BY_NAME, "SELECT guid, account, name, gender, race, class, level FROM characters WHERE deleteDate IS NULL AND name = ?", CONNECTION_BOTH);
31 PrepareStatement(CHAR_SEL_DATA_BY_GUID, "SELECT guid, account, name, gender, race, class, level FROM characters WHERE deleteDate IS NULL AND guid = ?", CONNECTION_BOTH);
32 PrepareStatement(CHAR_SEL_CHECK_NAME, "SELECT 1 FROM characters WHERE name = ?", CONNECTION_BOTH);
33 PrepareStatement(CHAR_SEL_CHECK_GUID, "SELECT 1 FROM characters WHERE guid = ?", CONNECTION_SYNCH);
34 PrepareStatement(CHAR_SEL_SUM_CHARS, "SELECT COUNT(guid) FROM characters WHERE account = ?", CONNECTION_BOTH);
35 PrepareStatement(CHAR_SEL_CHAR_CREATE_INFO, "SELECT level, race, class FROM characters WHERE account = ? LIMIT 0, ?", CONNECTION_ASYNC);
36 PrepareStatement(CHAR_INS_CHARACTER_BAN, "INSERT INTO character_banned VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?, 1)", CONNECTION_ASYNC);
37 PrepareStatement(CHAR_UPD_CHARACTER_BAN, "UPDATE character_banned SET active = 0 WHERE guid = ? AND active != 0", CONNECTION_ASYNC);
38 PrepareStatement(CHAR_DEL_CHARACTER_BAN, "DELETE cb FROM character_banned cb INNER JOIN characters c ON c.guid = cb.guid WHERE c.account = ?", CONNECTION_ASYNC);
39 PrepareStatement(CHAR_SEL_BANINFO, "SELECT FROM_UNIXTIME(bandate, '%Y-%m-%d %H:%i:%s'), unbandate-bandate, active, unbandate, banreason, bannedby FROM character_banned WHERE guid = ? ORDER BY bandate ASC", CONNECTION_SYNCH);
40 PrepareStatement(CHAR_SEL_GUID_BY_NAME_FILTER, "SELECT guid, name FROM characters WHERE name LIKE CONCAT('%%', ?, '%%')", CONNECTION_SYNCH);
41 PrepareStatement(CHAR_SEL_BANINFO_LIST, "SELECT bandate, unbandate, bannedby, banreason FROM character_banned WHERE guid = ? ORDER BY unbandate", CONNECTION_SYNCH);
42 PrepareStatement(CHAR_SEL_BANNED_NAME, "SELECT characters.name FROM characters, character_banned WHERE character_banned.guid = ? AND character_banned.guid = characters.guid", CONNECTION_SYNCH);
43 PrepareStatement(CHAR_SEL_ENUM, "SELECT c.guid, c.name, c.race, c.class, c.gender, c.skin, c.face, c.hairStyle, c.hairColor, c.facialStyle, c.level, c.zone, c.map, c.position_x, c.position_y, c.position_z, "
44 "gm.guildid, c.playerFlags, c.at_login, cp.entry, cp.modelid, cp.level, c.equipmentCache, cb.guid, c.extra_flags "
45 "FROM characters AS c LEFT JOIN character_pet AS cp ON c.guid = cp.owner AND cp.slot = ? LEFT JOIN guild_member AS gm ON c.guid = gm.guid "
46 "LEFT JOIN character_banned AS cb ON c.guid = cb.guid AND cb.active = 1 WHERE c.account = ? AND c.deleteInfos_Name IS NULL ORDER BY COALESCE(c.order, c.guid)", CONNECTION_ASYNC);
47 PrepareStatement(CHAR_SEL_ENUM_DECLINED_NAME, "SELECT c.guid, c.name, c.race, c.class, c.gender, c.skin, c.face, c.hairStyle, c.hairColor, c.facialStyle, c.level, c.zone, c.map, "
48 "c.position_x, c.position_y, c.position_z, gm.guildid, c.playerFlags, c.at_login, cp.entry, cp.modelid, cp.level, c.equipmentCache, "
49 "cb.guid, c.extra_flags, cd.genitive FROM characters AS c LEFT JOIN character_pet AS cp ON c.guid = cp.owner AND cp.slot = ? "
50 "LEFT JOIN character_declinedname AS cd ON c.guid = cd.guid LEFT JOIN guild_member AS gm ON c.guid = gm.guid "
51 "LEFT JOIN character_banned AS cb ON c.guid = cb.guid AND cb.active = 1 WHERE c.account = ? AND c.deleteInfos_Name IS NULL ORDER BY COALESCE(c.order, c.guid)", CONNECTION_ASYNC);
52 PrepareStatement(CHAR_SEL_FREE_NAME, "SELECT guid, name, at_login FROM characters WHERE guid = ? AND account = ? AND NOT EXISTS (SELECT NULL FROM characters WHERE name = ?)", CONNECTION_ASYNC);
53 PrepareStatement(CHAR_SEL_CHAR_ZONE, "SELECT zone FROM characters WHERE guid = ?", CONNECTION_SYNCH);
54 PrepareStatement(CHAR_SEL_CHARACTER_NAME_DATA, "SELECT race, class, gender, level FROM characters WHERE guid = ?", CONNECTION_SYNCH);
55 PrepareStatement(CHAR_SEL_CHAR_POSITION_XYZ, "SELECT map, position_x, position_y, position_z FROM characters WHERE guid = ?", CONNECTION_SYNCH);
56 PrepareStatement(CHAR_SEL_CHAR_POSITION, "SELECT position_x, position_y, position_z, orientation, map, taxi_path FROM characters WHERE guid = ?", CONNECTION_SYNCH);
57 PrepareStatement(CHAR_DEL_QUEST_STATUS_DAILY, "DELETE FROM character_queststatus_daily", CONNECTION_ASYNC);
58 PrepareStatement(CHAR_DEL_QUEST_STATUS_WEEKLY, "DELETE FROM character_queststatus_weekly", CONNECTION_ASYNC);
59 PrepareStatement(CHAR_DEL_QUEST_STATUS_MONTHLY, "DELETE FROM character_queststatus_monthly", CONNECTION_ASYNC);
60 PrepareStatement(CHAR_DEL_QUEST_STATUS_SEASONAL, "DELETE FROM character_queststatus_seasonal WHERE event = ?", CONNECTION_ASYNC);
61 PrepareStatement(CHAR_DEL_QUEST_STATUS_DAILY_CHAR, "DELETE FROM character_queststatus_daily WHERE guid = ?", CONNECTION_ASYNC);
62 PrepareStatement(CHAR_DEL_QUEST_STATUS_WEEKLY_CHAR, "DELETE FROM character_queststatus_weekly WHERE guid = ?", CONNECTION_ASYNC);
63 PrepareStatement(CHAR_DEL_QUEST_STATUS_MONTHLY_CHAR, "DELETE FROM character_queststatus_monthly WHERE guid = ?", CONNECTION_ASYNC);
64 PrepareStatement(CHAR_DEL_QUEST_STATUS_SEASONAL_CHAR, "DELETE FROM character_queststatus_seasonal WHERE guid = ?", CONNECTION_ASYNC);
65 PrepareStatement(CHAR_DEL_BATTLEGROUND_RANDOM, "DELETE FROM character_battleground_random", CONNECTION_ASYNC);
66 PrepareStatement(CHAR_INS_BATTLEGROUND_RANDOM, "INSERT INTO character_battleground_random (guid) VALUES (?)", CONNECTION_ASYNC);
67
68 // Start LoginQueryHolder content
69 PrepareStatement(CHAR_SEL_CHARACTER, "SELECT guid, account, name, race, class, gender, level, xp, money, skin, face, hairStyle, hairColor, facialStyle, bankSlots, restState, playerFlags, "
70 "position_x, position_y, position_z, map, orientation, taximask, cinematic, totaltime, leveltime, rest_bonus, logout_time, is_logout_resting, resettalents_cost, "
71 "resettalents_time, trans_x, trans_y, trans_z, trans_o, transguid, extra_flags, stable_slots, at_login, zone, online, death_expire_time, taxi_path, instance_mode_mask, "
72 "arenaPoints, totalHonorPoints, todayHonorPoints, yesterdayHonorPoints, totalKills, todayKills, yesterdayKills, chosenTitle, knownCurrencies, watchedFaction, drunk, "
73 "health, power1, power2, power3, power4, power5, power6, power7, instance_id, talentGroupsCount, activeTalentGroup, exploredZones, equipmentCache, ammoId, "
74 "knownTitles, actionBars, grantableLevels, innTriggerId FROM characters WHERE guid = ?", CONNECTION_ASYNC);
75
76 PrepareStatement(CHAR_SEL_CHARACTER_AURAS, "SELECT casterGuid, itemGuid, spell, effectMask, recalculateMask, stackCount, amount0, amount1, amount2, "
77 "base_amount0, base_amount1, base_amount2, maxDuration, remainTime, remainCharges FROM character_aura WHERE guid = ?", CONNECTION_ASYNC);
78 PrepareStatement(CHAR_SEL_CHARACTER_SPELL, "SELECT spell, specMask FROM character_spell WHERE guid = ?", CONNECTION_ASYNC);
79 PrepareStatement(CHAR_SEL_CHARACTER_QUESTSTATUS, "SELECT quest, status, explored, timer, mobcount1, mobcount2, mobcount3, mobcount4, "
80 "itemcount1, itemcount2, itemcount3, itemcount4, itemcount5, itemcount6, playercount FROM character_queststatus WHERE guid = ? AND status <> 0", CONNECTION_ASYNC);
81 PrepareStatement(CHAR_SEL_CHARACTER_DAILYQUESTSTATUS, "SELECT quest, time FROM character_queststatus_daily WHERE guid = ?", CONNECTION_ASYNC);
82 PrepareStatement(CHAR_SEL_CHARACTER_WEEKLYQUESTSTATUS, "SELECT quest FROM character_queststatus_weekly WHERE guid = ?", CONNECTION_ASYNC);
83 PrepareStatement(CHAR_SEL_CHARACTER_MONTHLYQUESTSTATUS, "SELECT quest FROM character_queststatus_monthly WHERE guid = ?", CONNECTION_ASYNC);
84 PrepareStatement(CHAR_SEL_CHARACTER_SEASONALQUESTSTATUS, "SELECT quest, event FROM character_queststatus_seasonal WHERE guid = ?", CONNECTION_ASYNC);
85 PrepareStatement(CHAR_INS_CHARACTER_DAILYQUESTSTATUS, "INSERT INTO character_queststatus_daily (guid, quest, time) VALUES (?, ?, ?)", CONNECTION_ASYNC);
86 PrepareStatement(CHAR_INS_CHARACTER_WEEKLYQUESTSTATUS, "INSERT INTO character_queststatus_weekly (guid, quest) VALUES (?, ?)", CONNECTION_ASYNC);
87 PrepareStatement(CHAR_INS_CHARACTER_MONTHLYQUESTSTATUS, "INSERT INTO character_queststatus_monthly (guid, quest) VALUES (?, ?)", CONNECTION_ASYNC);
88 PrepareStatement(CHAR_INS_CHARACTER_SEASONALQUESTSTATUS, "INSERT IGNORE INTO character_queststatus_seasonal (guid, quest, event) VALUES (?, ?, ?)", CONNECTION_ASYNC);
89 PrepareStatement(CHAR_SEL_CHARACTER_REPUTATION, "SELECT faction, standing, flags FROM character_reputation WHERE guid = ?", CONNECTION_ASYNC);
90 PrepareStatement(CHAR_SEL_CHARACTER_INVENTORY, "SELECT creatorGuid, giftCreatorGuid, count, duration, charges, flags, enchantments, randomPropertyId, durability, playedTime, text, bag, slot, "
91 "item, itemEntry FROM character_inventory ci JOIN item_instance ii ON ci.item = ii.guid WHERE ci.guid = ? ORDER BY bag, slot", CONNECTION_ASYNC);
92 PrepareStatement(CHAR_SEL_CHARACTER_ACTIONS, "SELECT a.button, a.action, a.type FROM character_action as a, characters as c WHERE a.guid = c.guid AND a.spec = c.activeTalentGroup AND a.guid = ? ORDER BY button", CONNECTION_ASYNC);
93 PrepareStatement(CHAR_SEL_CHARACTER_MAILCOUNT_UNREAD, "SELECT COUNT(id) FROM mail WHERE receiver = ? AND (checked & 1) = 0 AND deliver_time <= ?", CONNECTION_ASYNC);
94 PrepareStatement(CHAR_SEL_CHARACTER_MAILCOUNT_UNREAD_SYNCH, "SELECT COUNT(id) FROM mail WHERE receiver = ? AND (checked & 1) = 0 AND deliver_time <= ?", CONNECTION_SYNCH);
95 PrepareStatement(CHAR_SEL_MAIL_SERVER_CHARACTER, "SELECT mailId from mail_server_character WHERE guid = ? and mailId = ?", CONNECTION_ASYNC);
96 PrepareStatement(CHAR_REP_MAIL_SERVER_CHARACTER, "REPLACE INTO mail_server_character (guid, mailId) values (?, ?)", CONNECTION_ASYNC);
97 PrepareStatement(CHAR_SEL_CHARACTER_SOCIALLIST, "SELECT friend, flags, note FROM character_social JOIN characters ON characters.guid = character_social.friend WHERE character_social.guid = ? AND deleteinfos_name IS NULL LIMIT 255", CONNECTION_ASYNC);
98 PrepareStatement(CHAR_SEL_CHARACTER_HOMEBIND, "SELECT mapId, zoneId, posX, posY, posZ, posO FROM character_homebind WHERE guid = ?", CONNECTION_ASYNC);
99 PrepareStatement(CHAR_SEL_CHARACTER_SPELLCOOLDOWNS, "SELECT spell, category, item, time, needSend FROM character_spell_cooldown WHERE guid = ?", CONNECTION_ASYNC);
100 PrepareStatement(CHAR_SEL_CHARACTER_DECLINEDNAMES, "SELECT genitive, dative, accusative, instrumental, prepositional FROM character_declinedname WHERE guid = ?", CONNECTION_ASYNC);
101 PrepareStatement(CHAR_SEL_CHARACTER_ACHIEVEMENTS, "SELECT achievement, date FROM character_achievement WHERE guid = ?", CONNECTION_ASYNC);
102 PrepareStatement(CHAR_SEL_CHARACTER_CRITERIAPROGRESS, "SELECT criteria, counter, date FROM character_achievement_progress WHERE guid = ?", CONNECTION_ASYNC);
103 PrepareStatement(CHAR_SEL_CHARACTER_EQUIPMENTSETS, "SELECT setguid, setindex, name, iconname, ignore_mask, item0, item1, item2, item3, item4, item5, item6, item7, item8, "
104 "item9, item10, item11, item12, item13, item14, item15, item16, item17, item18 FROM character_equipmentsets WHERE guid = ? ORDER BY setindex", CONNECTION_ASYNC);
105 PrepareStatement(CHAR_SEL_CHARACTER_ENTRY_POINT, "SELECT joinX, joinY, joinZ, joinO, joinMapId, taxiPath0, taxiPath1, mountSpell FROM character_entry_point WHERE guid = ?", CONNECTION_ASYNC);
106 PrepareStatement(CHAR_SEL_CHARACTER_GLYPHS, "SELECT talentGroup, glyph1, glyph2, glyph3, glyph4, glyph5, glyph6 FROM character_glyphs WHERE guid = ?", CONNECTION_ASYNC);
107 PrepareStatement(CHAR_SEL_CHARACTER_TALENTS, "SELECT spell, specMask FROM character_talent WHERE guid = ?", CONNECTION_ASYNC);
108 PrepareStatement(CHAR_SEL_CHARACTER_SKILLS, "SELECT skill, value, max FROM character_skills WHERE guid = ?", CONNECTION_ASYNC);
109 PrepareStatement(CHAR_SEL_CHARACTER_RANDOMBG, "SELECT guid FROM character_battleground_random WHERE guid = ?", CONNECTION_ASYNC);
110 PrepareStatement(CHAR_SEL_CHARACTER_BANNED, "SELECT guid FROM character_banned WHERE guid = ? AND active = 1", CONNECTION_ASYNC);
111 PrepareStatement(CHAR_SEL_CHARACTER_QUESTSTATUSREW, "SELECT quest FROM character_queststatus_rewarded WHERE guid = ? AND active = 1", CONNECTION_ASYNC);
112 PrepareStatement(CHAR_SEL_ACCOUNT_INSTANCELOCKTIMES, "SELECT instanceId, releaseTime FROM account_instance_times WHERE accountId = ?", CONNECTION_ASYNC);
113 PrepareStatement(CHAR_SEL_BREW_OF_THE_MONTH, "SELECT lastEventId FROM character_brew_of_the_month WHERE guid = ?", CONNECTION_ASYNC);
114 PrepareStatement(CHAR_REP_BREW_OF_THE_MONTH, "REPLACE INTO character_brew_of_the_month (guid, lastEventId) VALUES (?, ?)", CONNECTION_ASYNC);
115 // End LoginQueryHolder content
116
117 PrepareStatement(CHAR_SEL_CHARACTER_ACTIONS_SPEC, "SELECT button, action, type FROM character_action WHERE guid = ? AND spec = ? ORDER BY button", CONNECTION_ASYNC);
118 PrepareStatement(CHAR_SEL_MAILITEMS, "SELECT creatorGuid, giftCreatorGuid, count, duration, charges, flags, enchantments, randomPropertyId, durability, playedTime, text, item_guid, itemEntry, ii.owner_guid, m.id FROM mail_items mi INNER JOIN mail m ON mi.mail_id = m.id LEFT JOIN item_instance ii ON mi.item_guid = ii.guid WHERE m.receiver = ?", CONNECTION_ASYNC);
119 PrepareStatement(CHAR_SEL_AUCTION_ITEMS, "SELECT creatorGuid, giftCreatorGuid, count, duration, charges, flags, enchantments, randomPropertyId, durability, playedTime, text, itemguid, itemEntry FROM auctionhouse ah JOIN item_instance ii ON ah.itemguid = ii.guid", CONNECTION_SYNCH);
120 PrepareStatement(CHAR_SEL_AUCTIONS, "SELECT id, houseid, itemguid, itemEntry, count, itemowner, buyoutprice, time, buyguid, lastbid, startbid, deposit FROM auctionhouse ah INNER JOIN item_instance ii ON ii.guid = ah.itemguid", CONNECTION_SYNCH);
121 PrepareStatement(CHAR_INS_AUCTION, "INSERT INTO auctionhouse (id, houseid, itemguid, itemowner, buyoutprice, time, buyguid, lastbid, startbid, deposit) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
122 PrepareStatement(CHAR_DEL_AUCTION, "DELETE FROM auctionhouse WHERE id = ?", CONNECTION_ASYNC);
123 PrepareStatement(CHAR_UPD_AUCTION_BID, "UPDATE auctionhouse SET buyguid = ?, lastbid = ? WHERE id = ?", CONNECTION_ASYNC);
124 PrepareStatement(CHAR_INS_MAIL, "INSERT INTO mail(id, messageType, stationery, mailTemplateId, sender, receiver, subject, body, has_items, expire_time, deliver_time, money, cod, checked) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
125 PrepareStatement(CHAR_DEL_MAIL_BY_ID, "DELETE FROM mail WHERE id = ?", CONNECTION_ASYNC);
126 PrepareStatement(CHAR_INS_MAIL_ITEM, "INSERT INTO mail_items(mail_id, item_guid, receiver) VALUES (?, ?, ?)", CONNECTION_ASYNC);
127 PrepareStatement(CHAR_DEL_MAIL_ITEM, "DELETE FROM mail_items WHERE item_guid = ?", CONNECTION_ASYNC);
128 PrepareStatement(CHAR_DEL_INVALID_MAIL_ITEM, "DELETE FROM mail_items WHERE item_guid = ?", CONNECTION_ASYNC);
129 PrepareStatement(CHAR_SEL_EXPIRED_MAIL, "SELECT id, messageType, sender, receiver, has_items, expire_time, stationery, checked, mailTemplateId FROM mail WHERE expire_time < ?", CONNECTION_SYNCH);
130 PrepareStatement(CHAR_SEL_EXPIRED_MAIL_ITEMS, "SELECT item_guid, itemEntry, mail_id FROM mail_items mi INNER JOIN item_instance ii ON ii.guid = mi.item_guid LEFT JOIN mail mm ON mi.mail_id = mm.id WHERE mm.id IS NOT NULL AND mm.expire_time < ?", CONNECTION_SYNCH);
131 PrepareStatement(CHAR_UPD_MAIL_RETURNED, "UPDATE mail SET sender = ?, receiver = ?, expire_time = ?, deliver_time = ?, cod = 0, checked = ? WHERE id = ?", CONNECTION_ASYNC);
132 PrepareStatement(CHAR_UPD_MAIL_ITEM_RECEIVER, "UPDATE mail_items SET receiver = ? WHERE item_guid = ?", CONNECTION_ASYNC);
133 PrepareStatement(CHAR_UPD_ITEM_OWNER, "UPDATE item_instance SET owner_guid = ? WHERE guid = ?", CONNECTION_ASYNC);
134
135 PrepareStatement(CHAR_SEL_ITEM_REFUNDS, "SELECT player_guid, paidMoney, paidExtendedCost FROM item_refund_instance WHERE item_guid = ? AND player_guid = ? LIMIT 1", CONNECTION_SYNCH);
136 PrepareStatement(CHAR_SEL_ITEM_BOP_TRADE, "SELECT allowedPlayers FROM item_soulbound_trade_data WHERE itemGuid = ? LIMIT 1", CONNECTION_SYNCH);
137 PrepareStatement(CHAR_DEL_ITEM_BOP_TRADE, "DELETE FROM item_soulbound_trade_data WHERE itemGuid = ? LIMIT 1", CONNECTION_ASYNC);
138 PrepareStatement(CHAR_INS_ITEM_BOP_TRADE, "INSERT INTO item_soulbound_trade_data VALUES (?, ?)", CONNECTION_ASYNC);
139 PrepareStatement(CHAR_REP_INVENTORY_ITEM, "REPLACE INTO character_inventory (guid, bag, slot, item) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
140 PrepareStatement(CHAR_REP_ITEM_INSTANCE, "REPLACE INTO item_instance (itemEntry, owner_guid, creatorGuid, giftCreatorGuid, count, duration, charges, flags, enchantments, randomPropertyId, durability, playedTime, text, guid) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
141 PrepareStatement(CHAR_UPD_ITEM_INSTANCE, "UPDATE item_instance SET itemEntry = ?, owner_guid = ?, creatorGuid = ?, giftCreatorGuid = ?, count = ?, duration = ?, charges = ?, flags = ?, enchantments = ?, randomPropertyId = ?, durability = ?, playedTime = ?, text = ? WHERE guid = ?", CONNECTION_ASYNC);
142 PrepareStatement(CHAR_UPD_ITEM_INSTANCE_ON_LOAD, "UPDATE item_instance SET duration = ?, flags = ?, durability = ? WHERE guid = ?", CONNECTION_ASYNC);
143 PrepareStatement(CHAR_DEL_ITEM_INSTANCE, "DELETE FROM item_instance WHERE guid = ?", CONNECTION_ASYNC);
144 PrepareStatement(CHAR_DEL_ITEM_INSTANCE_BY_OWNER, "DELETE FROM item_instance WHERE owner_guid = ?", CONNECTION_ASYNC);
145 PrepareStatement(CHAR_UPD_GIFT_OWNER, "UPDATE character_gifts SET guid = ? WHERE item_guid = ?", CONNECTION_ASYNC);
146 PrepareStatement(CHAR_DEL_GIFT, "DELETE FROM character_gifts WHERE item_guid = ?", CONNECTION_ASYNC);
147 PrepareStatement(CHAR_SEL_CHARACTER_GIFT_BY_ITEM, "SELECT entry, flags FROM character_gifts WHERE item_guid = ?", CONNECTION_ASYNC);
148 PrepareStatement(CHAR_SEL_ACCOUNT_BY_NAME, "SELECT account FROM characters WHERE name = ?", CONNECTION_SYNCH);
149 PrepareStatement(CHAR_DEL_ACCOUNT_INSTANCE_LOCK_TIMES, "DELETE FROM account_instance_times WHERE accountId = ?", CONNECTION_ASYNC);
150 PrepareStatement(CHAR_INS_ACCOUNT_INSTANCE_LOCK_TIMES, "INSERT INTO account_instance_times (accountId, instanceId, releaseTime) VALUES (?, ?, ?)", CONNECTION_ASYNC);
151 PrepareStatement(CHAR_SEL_MATCH_MAKER_RATING, "SELECT matchMakerRating, maxMMR FROM character_arena_stats WHERE guid = ? AND slot = ?", CONNECTION_SYNCH);
152 PrepareStatement(CHAR_SEL_CHARACTER_COUNT, "SELECT account, COUNT(guid) FROM characters WHERE account = ? GROUP BY account", CONNECTION_ASYNC);
153 PrepareStatement(CHAR_UPD_NAME_BY_GUID, "UPDATE characters SET name = ? WHERE guid = ?", CONNECTION_ASYNC);
154 PrepareStatement(CHAR_DEL_DECLINED_NAME, "DELETE FROM character_declinedname WHERE guid = ?", CONNECTION_ASYNC);
155
156 // Guild handling
157 // 0: uint32, 1: string, 2: uint32, 3: string, 4: string, 5: uint64, 6-10: uint32, 11: uint64
158 PrepareStatement(CHAR_INS_GUILD, "INSERT INTO guild (guildid, name, leaderguid, info, motd, createdate, EmblemStyle, EmblemColor, BorderStyle, BorderColor, BackgroundColor, BankMoney) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
159 PrepareStatement(CHAR_DEL_GUILD, "DELETE FROM guild WHERE guildid = ?", CONNECTION_ASYNC); // 0: uint32
160 // 0: string, 1: uint32
161 PrepareStatement(CHAR_UPD_GUILD_NAME, "UPDATE guild SET name = ? WHERE guildid = ?", CONNECTION_ASYNC);
162 // 0: uint32, 1: uint32, 2: uint8, 4: string, 5: string
163 PrepareStatement(CHAR_INS_GUILD_MEMBER, "INSERT INTO guild_member (guildid, guid, `rank`, pnote, offnote) VALUES (?, ?, ?, ?, ?)", CONNECTION_ASYNC);
164 PrepareStatement(CHAR_DEL_GUILD_MEMBER, "DELETE FROM guild_member WHERE guid = ?", CONNECTION_ASYNC); // 0: uint32
165 PrepareStatement(CHAR_DEL_GUILD_MEMBERS, "DELETE FROM guild_member WHERE guildid = ?", CONNECTION_ASYNC); // 0: uint32
166 PrepareStatement(CHAR_SEL_GUILD_MEMBER_EXTENDED, "SELECT g.guildid, g.name, gr.rname, gm.pnote, gm.offnote "
167 "FROM guild g JOIN guild_member gm ON g.guildid = gm.guildid "
168 "JOIN guild_rank gr ON g.guildid = gr.guildid AND gm.`rank` = gr.rid WHERE gm.guid = ?", CONNECTION_BOTH);
169 // 0: uint32, 1: uint8, 3: string, 4: uint32, 5: uint32
170 PrepareStatement(CHAR_INS_GUILD_RANK, "INSERT INTO guild_rank (guildid, rid, rname, rights, BankMoneyPerDay) VALUES (?, ?, ?, ?, ?)", CONNECTION_ASYNC);
171 PrepareStatement(CHAR_DEL_GUILD_RANKS, "DELETE FROM guild_rank WHERE guildid = ?", CONNECTION_ASYNC); // 0: uint32
172 PrepareStatement(CHAR_DEL_GUILD_LOWEST_RANK, "DELETE FROM guild_rank WHERE guildid = ? AND rid >= ?", CONNECTION_ASYNC); // 0: uint32, 1: uint8
173 PrepareStatement(CHAR_INS_GUILD_BANK_TAB, "INSERT INTO guild_bank_tab (guildid, TabId) VALUES (?, ?)", CONNECTION_ASYNC); // 0: uint32, 1: uint8
174 PrepareStatement(CHAR_DEL_GUILD_BANK_TAB, "DELETE FROM guild_bank_tab WHERE guildid = ? AND TabId = ?", CONNECTION_ASYNC); // 0: uint32, 1: uint8
175 PrepareStatement(CHAR_DEL_GUILD_BANK_TABS, "DELETE FROM guild_bank_tab WHERE guildid = ?", CONNECTION_ASYNC); // 0: uint32
176 // 0: uint32, 1: uint8, 2: uint8, 3: uint32, 4: uint32
177 PrepareStatement(CHAR_INS_GUILD_BANK_ITEM, "INSERT INTO guild_bank_item (guildid, TabId, SlotId, item_guid) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
178 PrepareStatement(CHAR_DEL_GUILD_BANK_ITEM, "DELETE FROM guild_bank_item WHERE guildid = ? AND TabId = ? AND SlotId = ?", CONNECTION_ASYNC); // 0: uint32, 1: uint8, 2: uint8
179 PrepareStatement(CHAR_DEL_GUILD_BANK_ITEMS, "DELETE FROM guild_bank_item WHERE guildid = ?", CONNECTION_ASYNC); // 0: uint32
180 // 0: uint32, 1: uint8, 2: uint8, 3: uint8, 4: uint32
181 PrepareStatement(CHAR_INS_GUILD_BANK_RIGHT, "INSERT INTO guild_bank_right (guildid, TabId, rid, gbright, SlotPerDay) VALUES (?, ?, ?, ?, ?) "
182 "ON DUPLICATE KEY UPDATE gbright = VALUES(gbright), SlotPerDay = VALUES(SlotPerDay)", CONNECTION_ASYNC);
183 PrepareStatement(CHAR_DEL_GUILD_BANK_RIGHTS, "DELETE FROM guild_bank_right WHERE guildid = ?", CONNECTION_ASYNC); // 0: uint32
184 PrepareStatement(CHAR_DEL_GUILD_BANK_RIGHTS_FOR_RANK, "DELETE FROM guild_bank_right WHERE guildid = ? AND rid = ?", CONNECTION_ASYNC); // 0: uint32, 1: uint8
185 // 0-1: uint32, 2-3: uint8, 4-5: uint32, 6: uint16, 7: uint8, 8: uint64
186 PrepareStatement(CHAR_INS_GUILD_BANK_EVENTLOG, "INSERT INTO guild_bank_eventlog (guildid, LogGuid, TabId, EventType, PlayerGuid, ItemOrMoney, ItemStackCount, DestTabId, TimeStamp) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
187 PrepareStatement(CHAR_DEL_GUILD_BANK_EVENTLOG, "DELETE FROM guild_bank_eventlog WHERE guildid = ? AND LogGuid = ? AND TabId = ?", CONNECTION_ASYNC); // 0: uint32, 1: uint32, 2: uint8
188 PrepareStatement(CHAR_DEL_GUILD_BANK_EVENTLOGS, "DELETE FROM guild_bank_eventlog WHERE guildid = ?", CONNECTION_ASYNC); // 0: uint32
189 // 0-1: uint32, 2: uint8, 3-4: uint32, 5: uint8, 6: uint64
190 PrepareStatement(CHAR_INS_GUILD_EVENTLOG, "INSERT INTO guild_eventlog (guildid, LogGuid, EventType, PlayerGuid1, PlayerGuid2, NewRank, TimeStamp) VALUES (?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
191 PrepareStatement(CHAR_DEL_GUILD_EVENTLOG, "DELETE FROM guild_eventlog WHERE guildid = ? AND LogGuid = ?", CONNECTION_ASYNC); // 0: uint32, 1: uint32
192 PrepareStatement(CHAR_DEL_GUILD_EVENTLOGS, "DELETE FROM guild_eventlog WHERE guildid = ?", CONNECTION_ASYNC); // 0: uint32
193 PrepareStatement(CHAR_UPD_GUILD_MEMBER_PNOTE, "UPDATE guild_member SET pnote = ? WHERE guid = ?", CONNECTION_ASYNC); // 0: string, 1: uint32
194 PrepareStatement(CHAR_UPD_GUILD_MEMBER_OFFNOTE, "UPDATE guild_member SET offnote = ? WHERE guid = ?", CONNECTION_ASYNC); // 0: string, 1: uint32
195 PrepareStatement(CHAR_UPD_GUILD_MEMBER_RANK, "UPDATE guild_member SET `rank` = ? WHERE guid = ?", CONNECTION_ASYNC); // 0: uint8, 1: uint32
196 PrepareStatement(CHAR_UPD_GUILD_MOTD, "UPDATE guild SET motd = ? WHERE guildid = ?", CONNECTION_ASYNC); // 0: string, 1: uint32
197 PrepareStatement(CHAR_UPD_GUILD_INFO, "UPDATE guild SET info = ? WHERE guildid = ?", CONNECTION_ASYNC); // 0: string, 1: uint32
198 PrepareStatement(CHAR_UPD_GUILD_LEADER, "UPDATE guild SET leaderguid = ? WHERE guildid = ?", CONNECTION_ASYNC); // 0: uint32, 1: uint32
199 PrepareStatement(CHAR_UPD_GUILD_RANK_NAME, "UPDATE guild_rank SET rname = ? WHERE rid = ? AND guildid = ?", CONNECTION_ASYNC); // 0: string, 1: uint8, 2: uint32
200 PrepareStatement(CHAR_UPD_GUILD_RANK_RIGHTS, "UPDATE guild_rank SET rights = ? WHERE rid = ? AND guildid = ?", CONNECTION_ASYNC); // 0: uint32, 1: uint8, 2: uint32
201 // 0-5: uint32
202 PrepareStatement(CHAR_UPD_GUILD_EMBLEM_INFO, "UPDATE guild SET EmblemStyle = ?, EmblemColor = ?, BorderStyle = ?, BorderColor = ?, BackgroundColor = ? WHERE guildid = ?", CONNECTION_ASYNC);
203 // 0: string, 1: string, 2: uint32, 3: uint8
204 PrepareStatement(CHAR_UPD_GUILD_BANK_TAB_INFO, "UPDATE guild_bank_tab SET TabName = ?, TabIcon = ? WHERE guildid = ? AND TabId = ?", CONNECTION_ASYNC);
205 PrepareStatement(CHAR_UPD_GUILD_BANK_MONEY, "UPDATE guild SET BankMoney = ? WHERE guildid = ?", CONNECTION_ASYNC); // 0: uint64, 1: uint32
206 // 0: uint8, 1: uint32, 2: uint8, 3: uint32
207 PrepareStatement(CHAR_UPD_GUILD_BANK_EVENTLOG_TAB, "UPDATE guild_bank_eventlog SET TabId = ? WHERE guildid = ? AND TabId = ? AND LogGuid = ?", CONNECTION_ASYNC);
208 PrepareStatement(CHAR_UPD_GUILD_RANK_BANK_MONEY, "UPDATE guild_rank SET BankMoneyPerDay = ? WHERE rid = ? AND guildid = ?", CONNECTION_ASYNC); // 0: uint32, 1: uint8, 2: uint32
209 PrepareStatement(CHAR_UPD_GUILD_BANK_TAB_TEXT, "UPDATE guild_bank_tab SET TabText = ? WHERE guildid = ? AND TabId = ?", CONNECTION_ASYNC); // 0: string, 1: uint32, 2: uint8
210
211 PrepareStatement(CHAR_INS_GUILD_MEMBER_WITHDRAW,
212 "INSERT INTO guild_member_withdraw (guid, tab0, tab1, tab2, tab3, tab4, tab5, money) VALUES (?, ?, ?, ?, ?, ?, ?, ?) "
213 "ON DUPLICATE KEY UPDATE tab0 = VALUES (tab0), tab1 = VALUES (tab1), tab2 = VALUES (tab2), tab3 = VALUES (tab3), tab4 = VALUES (tab4), tab5 = VALUES (tab5)", CONNECTION_ASYNC);
214 PrepareStatement(CHAR_DEL_GUILD_MEMBER_WITHDRAW, "TRUNCATE guild_member_withdraw", CONNECTION_ASYNC);
215
216 // 0: uint32, 1: uint32, 2: uint32
217 PrepareStatement(CHAR_SEL_CHAR_DATA_FOR_GUILD, "SELECT name, level, class, gender, zone, account FROM characters WHERE guid = ?", CONNECTION_SYNCH);
218
219 // Chat channel handling
220 PrepareStatement(CHAR_INS_CHANNEL, "INSERT INTO channels(channelId, name, team, announce, lastUsed) VALUES (?, ?, ?, ?, UNIX_TIMESTAMP())", CONNECTION_ASYNC);
221 PrepareStatement(CHAR_UPD_CHANNEL, "UPDATE channels SET announce = ?, password = ?, lastUsed = UNIX_TIMESTAMP() WHERE channelId = ?", CONNECTION_ASYNC);
222 PrepareStatement(CHAR_DEL_CHANNEL, "DELETE FROM channels WHERE name = ? AND team = ?", CONNECTION_ASYNC);
223 PrepareStatement(CHAR_UPD_CHANNEL_USAGE, "UPDATE channels SET lastUsed = UNIX_TIMESTAMP() WHERE channelId = ?", CONNECTION_ASYNC);
224 PrepareStatement(CHAR_DEL_OLD_CHANNELS, "DELETE FROM channels WHERE lastUsed + ? < UNIX_TIMESTAMP()", CONNECTION_ASYNC);
225 PrepareStatement(CHAR_DEL_OLD_CHANNELS_BANS, "DELETE cb.* FROM channels_bans cb LEFT JOIN channels cn ON cb.channelId=cn.channelId WHERE cn.channelId IS NULL OR cb.banTime <= UNIX_TIMESTAMP()", CONNECTION_ASYNC);
226 PrepareStatement(CHAR_INS_CHANNEL_BAN, "REPLACE INTO channels_bans VALUES (?, ?, ?)", CONNECTION_ASYNC);
227 PrepareStatement(CHAR_DEL_CHANNEL_BAN, "DELETE FROM channels_bans WHERE channelId = ? AND playerGUID = ?", CONNECTION_ASYNC);
228
229 // Equipmentsets
230 PrepareStatement(CHAR_UPD_EQUIP_SET, "UPDATE character_equipmentsets SET name=?, iconname=?, ignore_mask=?, item0=?, item1=?, item2=?, item3=?, "
231 "item4=?, item5=?, item6=?, item7=?, item8=?, item9=?, item10=?, item11=?, item12=?, item13=?, item14=?, item15=?, item16=?, "
232 "item17=?, item18=? WHERE guid=? AND setguid=? AND setindex=?", CONNECTION_ASYNC);
233 PrepareStatement(CHAR_INS_EQUIP_SET, "INSERT INTO character_equipmentsets (guid, setguid, setindex, name, iconname, ignore_mask, item0, item1, item2, item3, "
234 "item4, item5, item6, item7, item8, item9, item10, item11, item12, item13, item14, item15, item16, item17, item18) "
235 "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
236 PrepareStatement(CHAR_DEL_EQUIP_SET, "DELETE FROM character_equipmentsets WHERE setguid=?", CONNECTION_ASYNC);
237
238 // Auras
239 PrepareStatement(CHAR_INS_AURA, "INSERT INTO character_aura (guid, casterGuid, itemGuid, spell, effectMask, recalculateMask, stackcount, amount0, amount1, amount2, base_amount0, base_amount1, base_amount2, maxDuration, remainTime, remainCharges) "
240 "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
241
242 // Account data
243 PrepareStatement(CHAR_SEL_ACCOUNT_DATA, "SELECT type, time, data FROM account_data WHERE accountId = ?", CONNECTION_ASYNC);
244 PrepareStatement(CHAR_REP_ACCOUNT_DATA, "REPLACE INTO account_data (accountId, type, time, data) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
245 PrepareStatement(CHAR_DEL_ACCOUNT_DATA, "DELETE FROM account_data WHERE accountId = ?", CONNECTION_ASYNC);
246 PrepareStatement(CHAR_SEL_PLAYER_ACCOUNT_DATA, "SELECT type, time, data FROM character_account_data WHERE guid = ?", CONNECTION_ASYNC);
247 PrepareStatement(CHAR_REP_PLAYER_ACCOUNT_DATA, "REPLACE INTO character_account_data(guid, type, time, data) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
248 PrepareStatement(CHAR_DEL_PLAYER_ACCOUNT_DATA, "DELETE FROM character_account_data WHERE guid = ?", CONNECTION_ASYNC);
249
250 // Tutorials
251 PrepareStatement(CHAR_SEL_TUTORIALS, "SELECT tut0, tut1, tut2, tut3, tut4, tut5, tut6, tut7 FROM account_tutorial WHERE accountId = ?", CONNECTION_ASYNC);
252 PrepareStatement(CHAR_SEL_HAS_TUTORIALS, "SELECT 1 FROM account_tutorial WHERE accountId = ?", CONNECTION_SYNCH);
253 PrepareStatement(CHAR_INS_TUTORIALS, "INSERT INTO account_tutorial(tut0, tut1, tut2, tut3, tut4, tut5, tut6, tut7, accountId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
254 PrepareStatement(CHAR_UPD_TUTORIALS, "UPDATE account_tutorial SET tut0 = ?, tut1 = ?, tut2 = ?, tut3 = ?, tut4 = ?, tut5 = ?, tut6 = ?, tut7 = ? WHERE accountId = ?", CONNECTION_ASYNC);
255 PrepareStatement(CHAR_DEL_TUTORIALS, "DELETE FROM account_tutorial WHERE accountId = ?", CONNECTION_ASYNC);
256
257 // Instance saves
258 PrepareStatement(CHAR_INS_INSTANCE_SAVE, "INSERT INTO instance (id, map, resettime, difficulty, completedEncounters, data) VALUES (?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
259 PrepareStatement(CHAR_UPD_INSTANCE_SAVE_DATA, "UPDATE instance SET data=? WHERE id=?", CONNECTION_ASYNC);
260 PrepareStatement(CHAR_UPD_INSTANCE_SAVE_ENCOUNTERMASK, "UPDATE instance SET completedEncounters=? WHERE id=?", CONNECTION_ASYNC);
261
262 // Game event saves
263 PrepareStatement(CHAR_DEL_GAME_EVENT_SAVE, "DELETE FROM game_event_save WHERE eventEntry = ?", CONNECTION_ASYNC);
264 PrepareStatement(CHAR_INS_GAME_EVENT_SAVE, "INSERT INTO game_event_save (eventEntry, state, next_start) VALUES (?, ?, ?)", CONNECTION_ASYNC);
265
266 // Game event condition saves
267 PrepareStatement(CHAR_DEL_ALL_GAME_EVENT_CONDITION_SAVE, "DELETE FROM game_event_condition_save WHERE eventEntry = ?", CONNECTION_ASYNC);
268 PrepareStatement(CHAR_DEL_GAME_EVENT_CONDITION_SAVE, "DELETE FROM game_event_condition_save WHERE eventEntry = ? AND condition_id = ?", CONNECTION_ASYNC);
269 PrepareStatement(CHAR_INS_GAME_EVENT_CONDITION_SAVE, "INSERT INTO game_event_condition_save (eventEntry, condition_id, done) VALUES (?, ?, ?)", CONNECTION_ASYNC);
270
271 // Petitions
272 PrepareStatement(CHAR_DEL_ALL_PETITION_SIGNATURES, "DELETE FROM petition_sign WHERE playerguid = ?", CONNECTION_ASYNC);
273 PrepareStatement(CHAR_DEL_PETITION_SIGNATURE, "DELETE FROM petition_sign WHERE playerguid = ? AND type = ?", CONNECTION_ASYNC);
274
275 // Arena teams
276 PrepareStatement(CHAR_INS_ARENA_TEAM, "INSERT INTO arena_team (arenaTeamId, name, captainGuid, type, rating, backgroundColor, emblemStyle, emblemColor, borderStyle, borderColor) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
277 PrepareStatement(CHAR_INS_ARENA_TEAM_MEMBER, "INSERT INTO arena_team_member (arenaTeamId, guid) VALUES (?, ?)", CONNECTION_ASYNC);
278 PrepareStatement(CHAR_DEL_ARENA_TEAM, "DELETE FROM arena_team WHERE arenaTeamId = ?", CONNECTION_ASYNC);
279 PrepareStatement(CHAR_DEL_ARENA_TEAM_MEMBERS, "DELETE FROM arena_team_member WHERE arenaTeamId = ?", CONNECTION_ASYNC);
280 PrepareStatement(CHAR_UPD_ARENA_TEAM_CAPTAIN, "UPDATE arena_team SET captainGuid = ? WHERE arenaTeamId = ?", CONNECTION_ASYNC);
281 PrepareStatement(CHAR_DEL_ARENA_TEAM_MEMBER, "DELETE FROM arena_team_member WHERE arenaTeamId = ? AND guid = ?", CONNECTION_ASYNC);
282 PrepareStatement(CHAR_UPD_ARENA_TEAM_STATS, "UPDATE arena_team SET rating = ?, weekGames = ?, weekWins = ?, seasonGames = ?, seasonWins = ?, `rank` = ? WHERE arenaTeamId = ?", CONNECTION_ASYNC);
283 PrepareStatement(CHAR_UPD_ARENA_TEAM_MEMBER, "UPDATE arena_team_member SET personalRating = ?, weekGames = ?, weekWins = ?, seasonGames = ?, seasonWins = ? WHERE arenaTeamId = ? AND guid = ?", CONNECTION_ASYNC);
284 PrepareStatement(CHAR_REP_CHARACTER_ARENA_STATS, "REPLACE INTO character_arena_stats (guid, slot, matchMakerRating, maxMMR) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
285 PrepareStatement(CHAR_SEL_PLAYER_ARENA_TEAMS, "SELECT arena_team_member.arenaTeamId FROM arena_team_member JOIN arena_team ON arena_team_member.arenaTeamId = arena_team.arenaTeamId WHERE guid = ?", CONNECTION_SYNCH);
286 PrepareStatement(CHAR_UPD_ARENA_TEAM_NAME, "UPDATE arena_team SET name = ? WHERE arenaTeamId = ?", CONNECTION_ASYNC);
287
288 // Character battleground data
289 PrepareStatement(CHAR_INS_PLAYER_ENTRY_POINT, "INSERT INTO character_entry_point (guid, joinX, joinY, joinZ, joinO, joinMapId, taxiPath0, taxiPath1, mountSpell) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
290 PrepareStatement(CHAR_DEL_PLAYER_ENTRY_POINT, "DELETE FROM character_entry_point WHERE guid = ?", CONNECTION_ASYNC);
291
292 // Character homebind
293 PrepareStatement(CHAR_INS_PLAYER_HOMEBIND, "INSERT INTO character_homebind (guid, mapId, zoneId, posX, posY, posZ, posO) VALUES (?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
294 PrepareStatement(CHAR_UPD_PLAYER_HOMEBIND, "UPDATE character_homebind SET mapId = ?, zoneId = ?, posX = ?, posY = ?, posZ = ?, posO = ? WHERE guid = ?", CONNECTION_ASYNC);
295 PrepareStatement(CHAR_DEL_PLAYER_HOMEBIND, "DELETE FROM character_homebind WHERE guid = ?", CONNECTION_ASYNC);
296
297 // Corpse
298 PrepareStatement(CHAR_SEL_CORPSES, "SELECT posX, posY, posZ, orientation, mapId, displayId, itemCache, bytes1, bytes2, guildId, flags, dynFlags, time, corpseType, instanceId, phaseMask, guid FROM corpse WHERE mapId = ? AND instanceId = ?", CONNECTION_SYNCH);
299 PrepareStatement(CHAR_INS_CORPSE, "INSERT INTO corpse (guid, posX, posY, posZ, orientation, mapId, displayId, itemCache, bytes1, bytes2, guildId, flags, dynFlags, time, corpseType, instanceId, phaseMask) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
300 PrepareStatement(CHAR_DEL_CORPSE, "DELETE FROM corpse WHERE guid = ?", CONNECTION_ASYNC);
301 PrepareStatement(CHAR_DEL_CORPSES_FROM_MAP, "DELETE FROM corpse WHERE mapId = ? AND instanceId = ?", CONNECTION_ASYNC);
302 PrepareStatement(CHAR_SEL_CORPSE_LOCATION, "SELECT mapId, posX, posY, posZ, orientation FROM corpse WHERE guid = ?", CONNECTION_ASYNC);
303
304 // Creature respawn
305 PrepareStatement(CHAR_SEL_CREATURE_RESPAWNS, "SELECT guid, respawnTime FROM creature_respawn WHERE mapId = ? AND instanceId = ?", CONNECTION_SYNCH);
306 PrepareStatement(CHAR_REP_CREATURE_RESPAWN, "REPLACE INTO creature_respawn (guid, respawnTime, mapId, instanceId) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
307 PrepareStatement(CHAR_DEL_CREATURE_RESPAWN, "DELETE FROM creature_respawn WHERE guid = ? AND mapId = ? AND instanceId = ?", CONNECTION_ASYNC);
308 PrepareStatement(CHAR_DEL_CREATURE_RESPAWN_BY_INSTANCE, "DELETE FROM creature_respawn WHERE mapId = ? AND instanceId = ?", CONNECTION_ASYNC);
309
310 // Gameobject respawn
311 PrepareStatement(CHAR_SEL_GO_RESPAWNS, "SELECT guid, respawnTime FROM gameobject_respawn WHERE mapId = ? AND instanceId = ?", CONNECTION_SYNCH);
312 PrepareStatement(CHAR_REP_GO_RESPAWN, "REPLACE INTO gameobject_respawn (guid, respawnTime, mapId, instanceId) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
313 PrepareStatement(CHAR_DEL_GO_RESPAWN, "DELETE FROM gameobject_respawn WHERE guid = ? AND mapId = ? AND instanceId = ?", CONNECTION_ASYNC);
314 PrepareStatement(CHAR_DEL_GO_RESPAWN_BY_INSTANCE, "DELETE FROM gameobject_respawn WHERE mapId = ? AND instanceId = ?", CONNECTION_ASYNC);
315
316 // GM Tickets
317 PrepareStatement(CHAR_SEL_GM_TICKETS, "SELECT id, type, playerGuid, name, description, createTime, mapId, posX, posY, posZ, lastModifiedTime, closedBy, assignedTo, comment, response, completed, escalated, viewed, needMoreHelp, resolvedBy FROM gm_ticket", CONNECTION_SYNCH);
318 PrepareStatement(CHAR_REP_GM_TICKET, "REPLACE INTO gm_ticket (id, type, playerGuid, name, description, createTime, mapId, posX, posY, posZ, lastModifiedTime, closedBy, assignedTo, comment, response, completed, escalated, viewed, needMoreHelp, resolvedBy) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
319 PrepareStatement(CHAR_DEL_GM_TICKET, "DELETE FROM gm_ticket WHERE id = ?", CONNECTION_ASYNC);
320 PrepareStatement(CHAR_DEL_PLAYER_GM_TICKETS, "DELETE FROM gm_ticket WHERE playerGuid = ?", CONNECTION_ASYNC);
321 PrepareStatement(CHAR_UPD_PLAYER_GM_TICKETS_ON_CHAR_DELETION, "UPDATE gm_ticket SET type = 2 WHERE playerGuid = ?", CONNECTION_ASYNC);
322
323 // GM Survey/subsurvey/lag report
324 PrepareStatement(CHAR_INS_GM_SURVEY, "INSERT INTO gm_survey (guid, surveyId, mainSurvey, comment, createTime) VALUES (?, ?, ?, ?, UNIX_TIMESTAMP(NOW()))", CONNECTION_ASYNC);
325 PrepareStatement(CHAR_INS_GM_SUBSURVEY, "INSERT INTO gm_subsurvey (surveyId, questionId, answer, answerComment) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
326 PrepareStatement(CHAR_INS_LAG_REPORT, "INSERT INTO lag_reports (guid, lagType, mapId, posX, posY, posZ, latency, createTime) VALUES (?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
327
328 // LFG Data
329 PrepareStatement(CHAR_REP_LFG_DATA, "REPLACE INTO lfg_data (guid, dungeon, state) VALUES (?, ?, ?)", CONNECTION_ASYNC);
330 PrepareStatement(CHAR_DEL_LFG_DATA, "DELETE FROM lfg_data WHERE guid = ?", CONNECTION_ASYNC);
331
332 // Player saving
333 PrepareStatement(CHAR_INS_CHARACTER, "INSERT INTO characters (guid, account, name, race, class, gender, level, xp, money, skin, face, hairStyle, hairColor, facialStyle, bankSlots, restState, playerFlags, "
334 "map, instance_id, instance_mode_mask, position_x, position_y, position_z, orientation, trans_x, trans_y, trans_z, trans_o, transguid, "
335 "taximask, cinematic, "
336 "totaltime, leveltime, rest_bonus, logout_time, is_logout_resting, resettalents_cost, resettalents_time, "
337 "extra_flags, stable_slots, at_login, zone, "
338 "death_expire_time, taxi_path, arenaPoints, totalHonorPoints, todayHonorPoints, yesterdayHonorPoints, totalKills, "
339 "todayKills, yesterdayKills, chosenTitle, knownCurrencies, watchedFaction, drunk, health, power1, power2, power3, "
340 "power4, power5, power6, power7, latency, talentGroupsCount, activeTalentGroup, exploredZones, equipmentCache, "
341 "ammoId, knownTitles, actionBars, grantableLevels, innTriggerId) VALUES "
342 "(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)", CONNECTION_ASYNC);
343 PrepareStatement(CHAR_UPD_CHARACTER, "UPDATE characters SET name=?,race=?,class=?,gender=?,level=?,xp=?,money=?,skin=?,face=?,hairStyle=?,hairColor=?,facialStyle=?,bankSlots=?,restState=?,playerFlags=?,"
344 "map=?,instance_id=?,instance_mode_mask=?,position_x=?,position_y=?,position_z=?,orientation=?,trans_x=?,trans_y=?,trans_z=?,trans_o=?,transguid=?,taximask=?,cinematic=?,totaltime=?,leveltime=?,rest_bonus=?,"
345 "logout_time=?,is_logout_resting=?,resettalents_cost=?,resettalents_time=?,extra_flags=?,stable_slots=?,at_login=?,zone=?,death_expire_time=?,taxi_path=?,"
346 "arenaPoints=?,totalHonorPoints=?,todayHonorPoints=?,yesterdayHonorPoints=?,totalKills=?,todayKills=?,yesterdayKills=?,chosenTitle=?,knownCurrencies=?,"
347 "watchedFaction=?,drunk=?,health=?,power1=?,power2=?,power3=?,power4=?,power5=?,power6=?,power7=?,latency=?,talentGroupsCount=?,activeTalentGroup=?,exploredZones=?,"
348 "equipmentCache=?,ammoId=?,knownTitles=?,actionBars=?,grantableLevels=?,innTriggerId=?,online=? WHERE guid=?", CONNECTION_ASYNC);
349
350 PrepareStatement(CHAR_UPD_ADD_AT_LOGIN_FLAG, "UPDATE characters SET at_login = at_login | ? WHERE guid = ?", CONNECTION_ASYNC);
351 PrepareStatement(CHAR_UPD_REM_AT_LOGIN_FLAG, "UPDATE characters set at_login = at_login & ~ ? WHERE guid = ?", CONNECTION_ASYNC);
352 PrepareStatement(CHAR_UPD_ALL_AT_LOGIN_FLAGS, "UPDATE characters SET at_login = at_login | ?", CONNECTION_ASYNC);
353 PrepareStatement(CHAR_INS_BUG_REPORT, "INSERT INTO bugreport (type, content) VALUES(?, ?)", CONNECTION_ASYNC);
354 PrepareStatement(CHAR_UPD_PETITION_NAME, "UPDATE petition SET name = ? WHERE petitionguid = ?", CONNECTION_ASYNC);
355 PrepareStatement(CHAR_INS_PETITION_SIGNATURE, "INSERT INTO petition_sign (ownerguid, petitionguid, playerguid, player_account) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
356 PrepareStatement(CHAR_UPD_ACCOUNT_ONLINE, "UPDATE characters SET online = 0 WHERE account = ?", CONNECTION_ASYNC);
357 PrepareStatement(CHAR_INS_GROUP, "INSERT INTO `groups` (guid, leaderGuid, lootMethod, looterGuid, lootThreshold, icon1, icon2, icon3, icon4, icon5, icon6, icon7, icon8, groupType, difficulty, raidDifficulty, masterLooterGuid) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
358 PrepareStatement(CHAR_REP_GROUP_MEMBER, "REPLACE INTO group_member (guid, memberGuid, memberFlags, subgroup, roles) VALUES(?, ?, ?, ?, ?)", CONNECTION_ASYNC);
359 PrepareStatement(CHAR_DEL_GROUP_MEMBER, "DELETE FROM group_member WHERE memberGuid = ? AND guid = ?", CONNECTION_ASYNC);
360 PrepareStatement(CHAR_UPD_GROUP_LEADER, "UPDATE `groups` SET leaderGuid = ? WHERE guid = ?", CONNECTION_ASYNC);
361 PrepareStatement(CHAR_UPD_GROUP_TYPE, "UPDATE `groups` SET groupType = ? WHERE guid = ?", CONNECTION_ASYNC);
362 PrepareStatement(CHAR_UPD_GROUP_MEMBER_SUBGROUP, "UPDATE group_member SET subgroup = ? WHERE memberGuid = ?", CONNECTION_ASYNC);
363 PrepareStatement(CHAR_UPD_GROUP_MEMBER_FLAG, "UPDATE group_member SET memberFlags = ? WHERE memberGuid = ?", CONNECTION_ASYNC);
364 PrepareStatement(CHAR_UPD_GROUP_DIFFICULTY, "UPDATE `groups` SET difficulty = ? WHERE guid = ?", CONNECTION_ASYNC);
365 PrepareStatement(CHAR_UPD_GROUP_RAID_DIFFICULTY, "UPDATE `groups` SET raidDifficulty = ? WHERE guid = ?", CONNECTION_ASYNC);
366 PrepareStatement(CHAR_DEL_ALL_GM_TICKETS, "TRUNCATE TABLE gm_ticket", CONNECTION_ASYNC);
367 PrepareStatement(CHAR_DEL_INVALID_SPELL_TALENTS, "DELETE FROM character_talent WHERE spell = ?", CONNECTION_ASYNC);
368 PrepareStatement(CHAR_DEL_INVALID_SPELL_SPELLS, "DELETE FROM character_spell WHERE spell = ?", CONNECTION_ASYNC);
369 PrepareStatement(CHAR_UPD_DELETE_INFO, "UPDATE characters SET deleteInfos_Name = name, deleteInfos_Account = account, deleteDate = UNIX_TIMESTAMP(), name = '', account = 0 WHERE guid = ?", CONNECTION_ASYNC);
370 PrepareStatement(CHAR_UDP_RESTORE_DELETE_INFO, "UPDATE characters SET name = ?, account = ?, deleteDate = NULL, deleteInfos_Name = NULL, deleteInfos_Account = NULL WHERE deleteDate IS NOT NULL AND guid = ?", CONNECTION_ASYNC);
371 PrepareStatement(CHAR_UPD_ZONE, "UPDATE characters SET zone = ? WHERE guid = ?", CONNECTION_ASYNC);
372 PrepareStatement(CHAR_UPD_LEVEL, "UPDATE characters SET level = ?, xp = 0 WHERE guid = ?", CONNECTION_ASYNC);
373 PrepareStatement(CHAR_UPD_XP_ACCUMULATIVE, "UPDATE characters SET xp = xp + ? WHERE guid = ?", CONNECTION_ASYNC);
374 PrepareStatement(CHAR_DEL_INVALID_ACHIEV_PROGRESS_CRITERIA, "DELETE FROM character_achievement_progress WHERE criteria = ?", CONNECTION_ASYNC);
375 PrepareStatement(CHAR_DEL_INVALID_ACHIEVMENT, "DELETE FROM character_achievement WHERE achievement = ?", CONNECTION_ASYNC);
376 PrepareStatement(CHAR_INS_ADDON, "INSERT INTO addons (name, crc) VALUES (?, ?)", CONNECTION_ASYNC);
377 PrepareStatement(CHAR_DEL_INVALID_PET_SPELL, "DELETE FROM pet_spell WHERE spell = ?", CONNECTION_ASYNC);
378 PrepareStatement(CHAR_UPD_GLOBAL_INSTANCE_RESETTIME, "UPDATE instance_reset SET resettime = ? WHERE mapid = ? AND difficulty = ?", CONNECTION_ASYNC);
379 PrepareStatement(CHAR_UPD_CHAR_ONLINE, "UPDATE characters SET online = 1 WHERE guid = ?", CONNECTION_ASYNC);
380 PrepareStatement(CHAR_UPD_CHAR_NAME_AT_LOGIN, "UPDATE characters set name = ?, at_login = ? WHERE guid = ?", CONNECTION_ASYNC);
381 PrepareStatement(CHAR_UPD_WORLDSTATE, "UPDATE worldstates SET value = ? WHERE entry = ?", CONNECTION_ASYNC);
382 PrepareStatement(CHAR_INS_WORLDSTATE, "INSERT INTO worldstates (entry, value) VALUES (?, ?)", CONNECTION_ASYNC);
383 PrepareStatement(CHAR_DEL_CHAR_INSTANCE_BY_INSTANCE, "DELETE FROM character_instance WHERE instance = ?", CONNECTION_ASYNC);
384 PrepareStatement(CHAR_DEL_CHAR_INSTANCE_BY_INSTANCE_NOT_EXTENDED, "DELETE FROM character_instance WHERE instance = ? AND extended = 0", CONNECTION_ASYNC);
385 PrepareStatement(CHAR_UPD_CHAR_INSTANCE_SET_NOT_EXTENDED, "UPDATE character_instance SET extended = 0 WHERE instance = ?", CONNECTION_ASYNC);
386 PrepareStatement(CHAR_DEL_CHAR_INSTANCE_BY_INSTANCE_GUID, "DELETE FROM character_instance WHERE guid = ? AND instance = ?", CONNECTION_ASYNC);
387 PrepareStatement(CHAR_UPD_CHAR_INSTANCE, "UPDATE character_instance SET instance = ?, permanent = ?, extended = 0 WHERE guid = ? AND instance = ?", CONNECTION_ASYNC);
388 PrepareStatement(CHAR_UPD_CHAR_INSTANCE_EXTENDED, "UPDATE character_instance SET extended = ? WHERE guid = ? AND instance = ?", CONNECTION_ASYNC);
389 PrepareStatement(CHAR_INS_CHAR_INSTANCE, "INSERT INTO character_instance (guid, instance, permanent, extended) VALUES (?, ?, ?, 0)", CONNECTION_ASYNC);
390 PrepareStatement(CHAR_INS_ARENA_LOG_FIGHT, "INSERT INTO log_arena_fights VALUES (?, NOW(), ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
391 PrepareStatement(CHAR_INS_ARENA_LOG_MEMBERSTATS, "INSERT INTO log_arena_memberstats VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
392 PrepareStatement(CHAR_UPD_GENDER_AND_APPEARANCE, "UPDATE characters SET gender = ?, skin = ?, face = ?, hairStyle = ?, hairColor = ?, facialStyle = ? WHERE guid = ?", CONNECTION_ASYNC);
393 PrepareStatement(CHAR_DEL_CHARACTER_SKILL, "DELETE FROM character_skills WHERE guid = ? AND skill = ?", CONNECTION_ASYNC);
394 PrepareStatement(CHAR_UPD_ADD_CHARACTER_SOCIAL_FLAGS, "UPDATE character_social SET flags = flags | ? WHERE guid = ? AND friend = ?", CONNECTION_ASYNC);
395 PrepareStatement(CHAR_UPD_REM_CHARACTER_SOCIAL_FLAGS, "UPDATE character_social SET flags = flags & ~ ? WHERE guid = ? AND friend = ?", CONNECTION_ASYNC);
396 PrepareStatement(CHAR_INS_CHARACTER_SOCIAL, "REPLACE INTO character_social (guid, friend, flags) VALUES (?, ?, ?)", CONNECTION_ASYNC);
397 PrepareStatement(CHAR_DEL_CHARACTER_SOCIAL, "DELETE FROM character_social WHERE guid = ? AND friend = ?", CONNECTION_ASYNC);
398 PrepareStatement(CHAR_UPD_CHARACTER_SOCIAL_NOTE, "UPDATE character_social SET note = ? WHERE guid = ? AND friend = ?", CONNECTION_ASYNC);
399 PrepareStatement(CHAR_UPD_CHARACTER_POSITION, "UPDATE characters SET position_x = ?, position_y = ?, position_z = ?, orientation = ?, map = ?, zone = ?, trans_x = 0, trans_y = 0, trans_z = 0, transguid = 0, taxi_path = '', cinematic = 1 WHERE guid = ?", CONNECTION_ASYNC);
400 PrepareStatement(CHAR_SEL_CHARACTER_AURA_FROZEN, "SELECT characters.name FROM characters LEFT JOIN character_aura ON (characters.guid = character_aura.guid) WHERE character_aura.spell = 9454", CONNECTION_ASYNC);
401 PrepareStatement(CHAR_SEL_CHARACTER_ONLINE, "SELECT name, account, map, zone FROM characters WHERE online > 0", CONNECTION_SYNCH);
402 PrepareStatement(CHAR_SEL_CHAR_DEL_INFO_BY_GUID, "SELECT guid, deleteInfos_Name, deleteInfos_Account, deleteDate FROM characters WHERE deleteDate IS NOT NULL AND guid = ?", CONNECTION_SYNCH);
403 PrepareStatement(CHAR_SEL_CHAR_DEL_INFO_BY_NAME, "SELECT guid, deleteInfos_Name, deleteInfos_Account, deleteDate FROM characters WHERE deleteDate IS NOT NULL AND deleteInfos_Name LIKE CONCAT('%%', ?, '%%')", CONNECTION_SYNCH);
404 PrepareStatement(CHAR_SEL_CHAR_DEL_INFO, "SELECT guid, deleteInfos_Name, deleteInfos_Account, deleteDate FROM characters WHERE deleteDate IS NOT NULL", CONNECTION_SYNCH);
405 PrepareStatement(CHAR_SEL_CHARS_BY_ACCOUNT_ID, "SELECT guid FROM characters WHERE account = ?", CONNECTION_SYNCH);
406 PrepareStatement(CHAR_SEL_CHAR_PINFO, "SELECT totaltime, level, money, account, race, class, map, zone, gender, health, playerFlags FROM characters WHERE guid = ?", CONNECTION_SYNCH);
407 PrepareStatement(CHAR_SEL_PINFO_BANS, "SELECT unbandate, bandate = unbandate, bannedby, banreason FROM character_banned WHERE guid = ? AND active ORDER BY bandate ASC LIMIT 1", CONNECTION_SYNCH);
408 PrepareStatement(CHAR_SEL_PINFO_MAILS, "SELECT SUM(CASE WHEN (checked & 1) THEN 1 ELSE 0 END) AS 'readmail', COUNT(*) AS 'totalmail' FROM mail WHERE `receiver` = ?", CONNECTION_SYNCH);
409 PrepareStatement(CHAR_SEL_PINFO_XP, "SELECT a.xp, b.guid FROM characters a LEFT JOIN guild_member b ON a.guid = b.guid WHERE a.guid = ?", CONNECTION_SYNCH);
410 PrepareStatement(CHAR_SEL_CHAR_HOMEBIND, "SELECT mapId, zoneId, posX, posY, posZ, posO FROM character_homebind WHERE guid = ?", CONNECTION_SYNCH);
411 PrepareStatement(CHAR_SEL_CHAR_GUID_NAME_BY_ACC, "SELECT guid, name FROM characters WHERE account = ?", CONNECTION_SYNCH);
412 PrepareStatement(CHAR_SEL_POOL_QUEST_SAVE, "SELECT quest_id FROM pool_quest_save WHERE pool_id = ?", CONNECTION_SYNCH);
413 PrepareStatement(CHAR_SEL_CHARACTER_AT_LOGIN, "SELECT at_login FROM characters WHERE guid = ?", CONNECTION_SYNCH);
414 PrepareStatement(CHAR_SEL_CHAR_CLASS_LVL_AT_LOGIN, "SELECT class, level, at_login, knownTitles FROM characters WHERE guid = ?", CONNECTION_SYNCH);
415 PrepareStatement(CHAR_SEL_CHAR_CUSTOMIZE_INFO, "SELECT name, race, class, gender, at_login FROM characters WHERE guid = ?", CONNECTION_ASYNC);
416 PrepareStatement(CHAR_SEL_CHAR_RACE_OR_FACTION_CHANGE_INFOS, "SELECT at_login, knownTitles, money FROM characters WHERE guid = ?", CONNECTION_ASYNC);
417 PrepareStatement(CHAR_SEL_CHAR_AT_LOGIN_TITLES_MONEY, "SELECT at_login, knownTitles, money FROM characters WHERE guid = ?", CONNECTION_SYNCH);
418 PrepareStatement(CHAR_SEL_CHAR_COD_ITEM_MAIL, "SELECT id, messageType, mailTemplateId, sender, subject, body, money, has_items FROM mail WHERE receiver = ? AND has_items <> 0 AND cod <> 0", CONNECTION_SYNCH);
419 PrepareStatement(CHAR_SEL_CHAR_SOCIAL, "SELECT DISTINCT guid FROM character_social WHERE friend = ?", CONNECTION_SYNCH);
420 PrepareStatement(CHAR_SEL_CHAR_OLD_CHARS, "SELECT guid, deleteInfos_Account FROM characters WHERE deleteDate IS NOT NULL AND deleteDate < ?", CONNECTION_SYNCH);
421 PrepareStatement(CHAR_SEL_ARENA_TEAM_ID_BY_PLAYER_GUID, "SELECT arena_team_member.arenateamid FROM arena_team_member JOIN arena_team ON arena_team_member.arenateamid = arena_team.arenateamid WHERE guid = ? AND type = ? LIMIT 1", CONNECTION_SYNCH);
422 PrepareStatement(CHAR_SEL_MAIL, "SELECT id, messageType, sender, receiver, subject, body, expire_time, deliver_time, money, cod, checked, stationery, mailTemplateId FROM mail WHERE receiver = ? AND deliver_time <= ? ORDER BY id DESC", CONNECTION_ASYNC);
423 PrepareStatement(CHAR_SEL_NEXT_MAIL_DELIVERYTIME, "SELECT MIN(deliver_time) FROM mail WHERE receiver = ? AND deliver_time > ? AND (checked & 1) = 0 LIMIT 1", CONNECTION_SYNCH);
424 PrepareStatement(CHAR_DEL_CHAR_AURA_FROZEN, "DELETE FROM character_aura WHERE spell = 9454 AND guid = ?", CONNECTION_ASYNC);
425 PrepareStatement(CHAR_SEL_CHAR_INVENTORY_COUNT_ITEM, "SELECT COUNT(itemEntry) FROM character_inventory ci INNER JOIN item_instance ii ON ii.guid = ci.item WHERE itemEntry = ?", CONNECTION_SYNCH);
426 PrepareStatement(CHAR_SEL_MAIL_COUNT_ITEM, "SELECT COUNT(itemEntry) FROM mail_items mi INNER JOIN item_instance ii ON ii.guid = mi.item_guid WHERE itemEntry = ?", CONNECTION_SYNCH);
427 PrepareStatement(CHAR_SEL_AUCTIONHOUSE_COUNT_ITEM, "SELECT COUNT(itemEntry) FROM auctionhouse ah INNER JOIN item_instance ii ON ii.guid = ah.itemguid WHERE itemEntry = ?", CONNECTION_SYNCH);
428 PrepareStatement(CHAR_SEL_GUILD_BANK_COUNT_ITEM, "SELECT COUNT(itemEntry) FROM guild_bank_item gbi INNER JOIN item_instance ii ON ii.guid = gbi.item_guid WHERE itemEntry = ?", CONNECTION_SYNCH);
429 PrepareStatement(CHAR_SEL_CHAR_INVENTORY_ITEM_BY_ENTRY, "SELECT ci.item, cb.slot AS bag, ci.slot, ci.guid, c.account, c.name FROM characters c "
430 "INNER JOIN character_inventory ci ON ci.guid = c.guid "
431 "INNER JOIN item_instance ii ON ii.guid = ci.item "
432 "LEFT JOIN character_inventory cb ON cb.item = ci.bag WHERE ii.itemEntry = ? LIMIT ?", CONNECTION_SYNCH);
433 PrepareStatement(CHAR_SEL_CHAR_INVENTORY_ITEM_BY_ENTRY_AND_OWNER, "SELECT ci.item FROM character_inventory ci INNER JOIN item_instance ii ON ii.guid = ci.item WHERE ii.itemEntry = ? AND ii.owner_guid = ?", CONNECTION_SYNCH);
434 PrepareStatement(CHAR_SEL_MAIL_ITEMS_BY_ENTRY, "SELECT mi.item_guid, m.sender, m.receiver, cs.account, cs.name, cr.account, cr.name "
435 "FROM mail m INNER JOIN mail_items mi ON mi.mail_id = m.id INNER JOIN item_instance ii ON ii.guid = mi.item_guid "
436 "INNER JOIN characters cs ON cs.guid = m.sender INNER JOIN characters cr ON cr.guid = m.receiver WHERE ii.itemEntry = ? LIMIT ?", CONNECTION_SYNCH);
437 PrepareStatement(CHAR_SEL_AUCTIONHOUSE_ITEM_BY_ENTRY, "SELECT ah.itemguid, ah.itemowner, c.account, c.name FROM auctionhouse ah INNER JOIN characters c ON c.guid = ah.itemowner INNER JOIN item_instance ii ON ii.guid = ah.itemguid WHERE ii.itemEntry = ? LIMIT ?", CONNECTION_SYNCH);
438 PrepareStatement(CHAR_SEL_GUILD_BANK_ITEM_BY_ENTRY, "SELECT gi.item_guid, gi.guildid, g.name FROM guild_bank_item gi INNER JOIN guild g ON g.guildid = gi.guildid INNER JOIN item_instance ii ON ii.guid = gi.item_guid WHERE ii.itemEntry = ? LIMIT ?", CONNECTION_SYNCH);
439 PrepareStatement(CHAR_DEL_CHAR_ACHIEVEMENT, "DELETE FROM character_achievement WHERE guid = ?", CONNECTION_ASYNC);
440 PrepareStatement(CHAR_DEL_CHAR_ACHIEVEMENT_PROGRESS, "DELETE FROM character_achievement_progress WHERE guid = ?", CONNECTION_ASYNC);
441 PrepareStatement(CHAR_INS_CHAR_ACHIEVEMENT, "INSERT INTO character_achievement (guid, achievement, date) VALUES (?, ?, ?)", CONNECTION_ASYNC);
442 PrepareStatement(CHAR_DEL_CHAR_ACHIEVEMENT_PROGRESS_BY_CRITERIA, "DELETE FROM character_achievement_progress WHERE guid = ? AND criteria = ?", CONNECTION_ASYNC);
443 PrepareStatement(CHAR_INS_CHAR_ACHIEVEMENT_PROGRESS, "INSERT INTO character_achievement_progress (guid, criteria, counter, date) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
444 PrepareStatement(CHAR_DEL_CHAR_REPUTATION_BY_FACTION, "DELETE FROM character_reputation WHERE guid = ? AND faction = ?", CONNECTION_ASYNC);
445 PrepareStatement(CHAR_INS_CHAR_REPUTATION_BY_FACTION, "INSERT INTO character_reputation (guid, faction, standing, flags) VALUES (?, ?, ? , ?)", CONNECTION_ASYNC);
446 PrepareStatement(CHAR_UPD_CHAR_ARENA_POINTS, "UPDATE characters SET arenaPoints = (arenaPoints + ?) WHERE guid = ?", CONNECTION_ASYNC);
447 PrepareStatement(CHAR_DEL_ITEM_REFUND_INSTANCE, "DELETE FROM item_refund_instance WHERE item_guid = ?", CONNECTION_ASYNC);
448 PrepareStatement(CHAR_INS_ITEM_REFUND_INSTANCE, "INSERT INTO item_refund_instance (item_guid, player_guid, paidMoney, paidExtendedCost) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
449 PrepareStatement(CHAR_DEL_GROUP, "DELETE FROM `groups` WHERE guid = ?", CONNECTION_ASYNC);
450 PrepareStatement(CHAR_DEL_GROUP_MEMBER_ALL, "DELETE FROM group_member WHERE guid = ?", CONNECTION_ASYNC);
451 PrepareStatement(CHAR_INS_CHAR_GIFT, "INSERT INTO character_gifts (guid, item_guid, entry, flags) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
452 PrepareStatement(CHAR_DEL_INSTANCE_BY_INSTANCE, "DELETE FROM instance WHERE id = ?", CONNECTION_ASYNC);
453 PrepareStatement(CHAR_DEL_MAIL_ITEM_BY_ID, "DELETE FROM mail_items WHERE mail_id = ?", CONNECTION_ASYNC);
454 PrepareStatement(CHAR_INS_PETITION, "INSERT INTO petition (ownerguid, petitionguid, name, type) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
455 PrepareStatement(CHAR_DEL_PETITION_BY_GUID, "DELETE FROM petition WHERE petitionguid = ?", CONNECTION_ASYNC);
456 PrepareStatement(CHAR_DEL_PETITION_SIGNATURE_BY_GUID, "DELETE FROM petition_sign WHERE petitionguid = ?", CONNECTION_ASYNC);
457 PrepareStatement(CHAR_DEL_CHAR_DECLINED_NAME, "DELETE FROM character_declinedname WHERE guid = ?", CONNECTION_ASYNC);
458 PrepareStatement(CHAR_INS_CHAR_DECLINED_NAME, "INSERT INTO character_declinedname (guid, genitive, dative, accusative, instrumental, prepositional) VALUES (?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
459 PrepareStatement(CHAR_UPD_CHAR_RACE, "UPDATE characters SET race = ? WHERE guid = ?", CONNECTION_ASYNC);
460 PrepareStatement(CHAR_DEL_CHAR_SKILL_LANGUAGES, "DELETE FROM character_skills WHERE skill IN (98, 113, 759, 111, 313, 109, 115, 315, 673, 137) AND guid = ?", CONNECTION_ASYNC);
461 PrepareStatement(CHAR_INS_CHAR_SKILL_LANGUAGE, "INSERT INTO `character_skills` (guid, skill, value, max) VALUES (?, ?, 300, 300)", CONNECTION_ASYNC);
462 PrepareStatement(CHAR_UPD_CHAR_TAXI_PATH, "UPDATE characters SET taxi_path = '' WHERE guid = ?", CONNECTION_ASYNC);
463 PrepareStatement(CHAR_UPD_CHAR_TAXIMASK, "UPDATE characters SET taximask = ? WHERE guid = ?", CONNECTION_ASYNC);
464 PrepareStatement(CHAR_DEL_CHAR_QUESTSTATUS, "DELETE FROM character_queststatus WHERE guid = ?", CONNECTION_ASYNC);
465 PrepareStatement(CHAR_DEL_CHAR_SOCIAL_BY_GUID, "DELETE FROM character_social WHERE guid = ?", CONNECTION_ASYNC);
466 PrepareStatement(CHAR_DEL_CHAR_SOCIAL_BY_FRIEND, "DELETE FROM character_social WHERE friend = ?", CONNECTION_ASYNC);
467 PrepareStatement(CHAR_DEL_CHAR_ACHIEVEMENT_BY_ACHIEVEMENT, "DELETE FROM character_achievement WHERE achievement = ? AND guid = ?", CONNECTION_ASYNC);
468 PrepareStatement(CHAR_UPD_CHAR_ACHIEVEMENT, "UPDATE character_achievement SET achievement = ? WHERE achievement = ? AND guid = ?", CONNECTION_ASYNC);
469 PrepareStatement(CHAR_UPD_CHAR_INVENTORY_FACTION_CHANGE, "UPDATE item_instance ii, character_inventory ci SET ii.itemEntry = ? WHERE ii.itemEntry = ? AND ci.guid = ? AND ci.item = ii.guid", CONNECTION_ASYNC);
470 PrepareStatement(CHAR_DEL_CHAR_SPELL_BY_SPELL, "DELETE FROM character_spell WHERE guid = ? AND spell = ?", CONNECTION_ASYNC);
471 PrepareStatement(CHAR_UPD_CHAR_SPELL_FACTION_CHANGE, "UPDATE character_spell SET spell = ? WHERE spell = ? AND guid = ?", CONNECTION_ASYNC);
472 PrepareStatement(CHAR_SEL_CHAR_REP_BY_FACTION, "SELECT standing FROM character_reputation WHERE faction = ? AND guid = ?", CONNECTION_SYNCH);
473 PrepareStatement(CHAR_DEL_CHAR_REP_BY_FACTION, "DELETE FROM character_reputation WHERE faction = ? AND guid = ?", CONNECTION_ASYNC);
474 PrepareStatement(CHAR_UPD_CHAR_REP_FACTION_CHANGE, "UPDATE character_reputation SET faction = ?, standing = ? WHERE faction = ? AND guid = ?", CONNECTION_ASYNC);
475 PrepareStatement(CHAR_UPD_CHAR_TITLES_FACTION_CHANGE, "UPDATE characters SET knownTitles = ? WHERE guid = ?", CONNECTION_ASYNC);
476 PrepareStatement(CHAR_RES_CHAR_TITLES_FACTION_CHANGE, "UPDATE characters SET chosenTitle = 0 WHERE guid = ?", CONNECTION_ASYNC);
477 PrepareStatement(CHAR_DEL_CHAR_SPELL_COOLDOWN, "DELETE FROM character_spell_cooldown WHERE guid = ?", CONNECTION_ASYNC);
478 PrepareStatement(CHAR_DEL_CHARACTER, "DELETE FROM characters WHERE guid = ?", CONNECTION_ASYNC);
479 PrepareStatement(CHAR_DEL_CHAR_ACTION, "DELETE FROM character_action WHERE guid = ?", CONNECTION_ASYNC);
480 PrepareStatement(CHAR_DEL_CHAR_AURA, "DELETE FROM character_aura WHERE guid = ?", CONNECTION_ASYNC);
481 PrepareStatement(CHAR_DEL_CHAR_GIFT, "DELETE FROM character_gifts WHERE guid = ?", CONNECTION_ASYNC);
482 PrepareStatement(CHAR_DEL_CHAR_INSTANCE, "DELETE FROM character_instance WHERE guid = ?", CONNECTION_ASYNC);
483 PrepareStatement(CHAR_DEL_CHAR_INVENTORY, "DELETE FROM character_inventory WHERE guid = ?", CONNECTION_ASYNC);
484 PrepareStatement(CHAR_DEL_CHAR_QUESTSTATUS_REWARDED, "DELETE FROM character_queststatus_rewarded WHERE guid = ?", CONNECTION_ASYNC);
485 PrepareStatement(CHAR_DEL_CHAR_REPUTATION, "DELETE FROM character_reputation WHERE guid = ?", CONNECTION_ASYNC);
486 PrepareStatement(CHAR_DEL_CHAR_SPELL, "DELETE FROM character_spell WHERE guid = ?", CONNECTION_ASYNC);
487 PrepareStatement(CHAR_DEL_MAIL, "DELETE FROM mail WHERE receiver = ?", CONNECTION_ASYNC);
488 PrepareStatement(CHAR_DEL_MAIL_ITEMS, "DELETE FROM mail_items WHERE receiver = ?", CONNECTION_ASYNC);
489 PrepareStatement(CHAR_DEL_CHAR_ACHIEVEMENTS, "DELETE FROM character_achievement WHERE guid = ? AND achievement NOT BETWEEN '456' AND '467' AND achievement NOT BETWEEN '1400' AND '1427' AND achievement NOT IN(1463, 3117, 3259)", CONNECTION_ASYNC);
490 PrepareStatement(CHAR_DEL_CHAR_EQUIPMENTSETS, "DELETE FROM character_equipmentsets WHERE guid = ?", CONNECTION_ASYNC);
491 PrepareStatement(CHAR_DEL_GUILD_EVENTLOG_BY_PLAYER, "DELETE FROM guild_eventlog WHERE PlayerGuid1 = ? OR PlayerGuid2 = ?", CONNECTION_ASYNC);
492 PrepareStatement(CHAR_DEL_GUILD_BANK_EVENTLOG_BY_PLAYER, "DELETE FROM guild_bank_eventlog WHERE PlayerGuid = ?", CONNECTION_ASYNC);
493 PrepareStatement(CHAR_DEL_CHAR_GLYPHS, "DELETE FROM character_glyphs WHERE guid = ?", CONNECTION_ASYNC);
494 PrepareStatement(CHAR_DEL_CHAR_TALENT, "DELETE FROM character_talent WHERE guid = ?", CONNECTION_ASYNC);
495 PrepareStatement(CHAR_DEL_CHAR_SKILLS, "DELETE FROM character_skills WHERE guid = ?", CONNECTION_ASYNC);
496 PrepareStatement(CHAR_UDP_CHAR_HONOR_POINTS, "UPDATE characters SET totalHonorPoints = ? WHERE guid = ?", CONNECTION_ASYNC);
497 PrepareStatement(CHAR_UDP_CHAR_HONOR_POINTS_ACCUMULATIVE, "UPDATE characters SET totalHonorPoints = totalHonorPoints + ? WHERE guid = ?", CONNECTION_ASYNC);
498 PrepareStatement(CHAR_UDP_CHAR_ARENA_POINTS, "UPDATE characters SET arenaPoints = ? WHERE guid = ?", CONNECTION_ASYNC);
499 PrepareStatement(CHAR_UDP_CHAR_ARENA_POINTS_ACCUMULATIVE, "UPDATE characters SET arenaPoints = arenaPoints + ? WHERE guid = ?", CONNECTION_ASYNC);
500 PrepareStatement(CHAR_UDP_CHAR_MONEY, "UPDATE characters SET money = ? WHERE guid = ?", CONNECTION_ASYNC);
501 PrepareStatement(CHAR_UDP_CHAR_MONEY_ACCUMULATIVE, "UPDATE characters SET money = money + ? WHERE guid = ?", CONNECTION_ASYNC);
502 PrepareStatement(CHAR_UPD_CHAR_REMOVE_GHOST, "UPDATE characters SET playerFlags = (playerFlags & (~16)) WHERE guid = ?", CONNECTION_ASYNC);
503 PrepareStatement(CHAR_INS_CHAR_ACTION, "INSERT INTO character_action (guid, spec, button, action, type) VALUES (?, ?, ?, ?, ?)", CONNECTION_ASYNC);
504 PrepareStatement(CHAR_UPD_CHAR_ACTION, "UPDATE character_action SET action = ?, type = ? WHERE guid = ? AND button = ? AND spec = ?", CONNECTION_ASYNC);
505 PrepareStatement(CHAR_DEL_CHAR_ACTION_BY_BUTTON_SPEC, "DELETE FROM character_action WHERE guid = ? AND button = ? AND spec = ?", CONNECTION_ASYNC);
506 PrepareStatement(CHAR_DEL_CHAR_INVENTORY_BY_ITEM, "DELETE FROM character_inventory WHERE item = ?", CONNECTION_ASYNC);
507 PrepareStatement(CHAR_DEL_CHAR_INVENTORY_BY_BAG_SLOT, "DELETE FROM character_inventory WHERE bag = ? AND slot = ? AND guid = ?", CONNECTION_ASYNC);
508 PrepareStatement(CHAR_UPD_MAIL, "UPDATE mail SET has_items = ?, expire_time = ?, deliver_time = ?, money = ?, cod = ?, checked = ? WHERE id = ?", CONNECTION_ASYNC);
509 PrepareStatement(CHAR_REP_CHAR_QUESTSTATUS, "REPLACE INTO character_queststatus (guid, quest, status, explored, timer, mobcount1, mobcount2, mobcount3, mobcount4, itemcount1, itemcount2, itemcount3, itemcount4, itemcount5, itemcount6, playercount) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
510 PrepareStatement(CHAR_DEL_CHAR_QUESTSTATUS_BY_QUEST, "DELETE FROM character_queststatus WHERE guid = ? AND quest = ?", CONNECTION_ASYNC);
511 PrepareStatement(CHAR_INS_CHAR_QUESTSTATUS_REWARDED, "INSERT IGNORE INTO character_queststatus_rewarded (guid, quest, active) VALUES (?, ?, 1)", CONNECTION_ASYNC);
512 PrepareStatement(CHAR_DEL_CHAR_QUESTSTATUS_REWARDED_BY_QUEST, "DELETE FROM character_queststatus_rewarded WHERE guid = ? AND quest = ?", CONNECTION_ASYNC);
513 PrepareStatement(CHAR_UPD_CHAR_QUESTSTATUS_REWARDED_FACTION_CHANGE, "UPDATE character_queststatus_rewarded SET quest = ? WHERE quest = ? AND guid = ?", CONNECTION_ASYNC);
514 PrepareStatement(CHAR_UPD_CHAR_QUESTSTATUS_REWARDED_ACTIVE, "UPDATE character_queststatus_rewarded SET active = 1 WHERE guid = ?", CONNECTION_ASYNC);
515 PrepareStatement(CHAR_UPD_CHAR_QUESTSTATUS_REWARDED_ACTIVE_BY_QUEST, "UPDATE character_queststatus_rewarded SET active = 0 WHERE quest = ? AND guid = ?", CONNECTION_ASYNC);
516 PrepareStatement(CHAR_DEL_CHAR_SKILL_BY_SKILL, "DELETE FROM character_skills WHERE guid = ? AND skill = ?", CONNECTION_ASYNC);
517 PrepareStatement(CHAR_INS_CHAR_SKILLS, "INSERT INTO character_skills (guid, skill, value, max) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
518 PrepareStatement(CHAR_UDP_CHAR_SKILLS, "UPDATE character_skills SET value = ?, max = ? WHERE guid = ? AND skill = ?", CONNECTION_ASYNC);
519 PrepareStatement(CHAR_INS_CHAR_SPELL, "INSERT INTO character_spell (guid, spell, specMask) VALUES (?, ?, ?)", CONNECTION_ASYNC);
520 PrepareStatement(CHAR_DEL_CHAR_STATS, "DELETE FROM character_stats WHERE guid = ?", CONNECTION_ASYNC);
521 PrepareStatement(CHAR_INS_CHAR_STATS, "INSERT INTO character_stats (guid, maxhealth, maxpower1, maxpower2, maxpower3, maxpower4, maxpower5, maxpower6, maxpower7, strength, agility, stamina, intellect, spirit, "
522 "armor, resHoly, resFire, resNature, resFrost, resShadow, resArcane, blockPct, dodgePct, parryPct, critPct, rangedCritPct, spellCritPct, attackPower, rangedAttackPower, "
523 "spellPower, resilience) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
524 PrepareStatement(CHAR_SEL_CHAR_STATS, "SELECT maxhealth, strength, agility, stamina, intellect, spirit, armor, attackPower, spellPower, resilience FROM character_stats WHERE guid = ?", CONNECTION_SYNCH);
525 PrepareStatement(CHAR_DEL_PETITION_BY_OWNER, "DELETE FROM petition WHERE ownerguid = ?", CONNECTION_ASYNC);
526 PrepareStatement(CHAR_DEL_PETITION_SIGNATURE_BY_OWNER, "DELETE FROM petition_sign WHERE ownerguid = ?", CONNECTION_ASYNC);
527 PrepareStatement(CHAR_DEL_PETITION_BY_OWNER_AND_TYPE, "DELETE FROM petition WHERE ownerguid = ? AND type = ?", CONNECTION_ASYNC);
528 PrepareStatement(CHAR_DEL_PETITION_SIGNATURE_BY_OWNER_AND_TYPE, "DELETE FROM petition_sign WHERE ownerguid = ? AND type = ?", CONNECTION_ASYNC);
529 PrepareStatement(CHAR_INS_CHAR_GLYPHS, "INSERT INTO character_glyphs VALUES(?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
530 PrepareStatement(CHAR_DEL_CHAR_TALENT_BY_SPELL, "DELETE FROM character_talent WHERE guid = ? AND spell = ?", CONNECTION_ASYNC);
531 PrepareStatement(CHAR_INS_CHAR_TALENT, "INSERT INTO character_talent (guid, spell, specMask) VALUES (?, ?, ?)", CONNECTION_ASYNC);
532 PrepareStatement(CHAR_DEL_CHAR_ACTION_EXCEPT_SPEC, "DELETE FROM character_action WHERE spec<>? AND guid = ?", CONNECTION_ASYNC);
533
534 // Items that hold loot or money
535 PrepareStatement(CHAR_SEL_ITEMCONTAINER_ITEMS, "SELECT containerGUID, itemid, count, item_index, randomPropertyId, randomSuffix, follow_loot_rules, freeforall, is_blocked, is_counted, is_underthreshold, needs_quest, conditionLootId FROM item_loot_storage", CONNECTION_SYNCH);
536 PrepareStatement(CHAR_DEL_ITEMCONTAINER_SINGLE_ITEM, "DELETE FROM item_loot_storage WHERE containerGUID = ? AND itemid = ? AND count = ? AND item_index = ? LIMIT 1", CONNECTION_ASYNC);
537 PrepareStatement(CHAR_INS_ITEMCONTAINER_SINGLE_ITEM, "INSERT INTO item_loot_storage (containerGUID, itemid, item_index, count, randomPropertyId, randomSuffix, follow_loot_rules, freeforall, is_blocked, is_counted, is_underthreshold, needs_quest, conditionLootId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
538 PrepareStatement(CHAR_DEL_ITEMCONTAINER_CONTAINER, "DELETE FROM item_loot_storage WHERE containerGUID = ?", CONNECTION_ASYNC);
539
540 // Calendar
541 PrepareStatement(CHAR_REP_CALENDAR_EVENT, "REPLACE INTO calendar_events (id, creator, title, description, type, dungeon, eventtime, flags, time2) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
542 PrepareStatement(CHAR_DEL_CALENDAR_EVENT, "DELETE FROM calendar_events WHERE id = ?", CONNECTION_ASYNC);
543 PrepareStatement(CHAR_REP_CALENDAR_INVITE, "REPLACE INTO calendar_invites (id, event, invitee, sender, status, statustime, `rank`, text) VALUES (?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
544 PrepareStatement(CHAR_DEL_CALENDAR_INVITE, "DELETE FROM calendar_invites WHERE id = ?", CONNECTION_ASYNC);
545
546 // Pet
547 PrepareStatement(CHAR_SEL_CHAR_PET_IDS, "SELECT id FROM character_pet WHERE owner = ?", CONNECTION_SYNCH);
548 PrepareStatement(CHAR_DEL_CHAR_PET_DECLINEDNAME_BY_OWNER, "DELETE FROM character_pet_declinedname WHERE owner = ?", CONNECTION_ASYNC);
549 PrepareStatement(CHAR_DEL_CHAR_PET_DECLINEDNAME, "DELETE FROM character_pet_declinedname WHERE id = ?", CONNECTION_ASYNC);
550 PrepareStatement(CHAR_ADD_CHAR_PET_DECLINEDNAME, "INSERT INTO character_pet_declinedname (id, owner, genitive, dative, accusative, instrumental, prepositional) VALUES (?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
551 PrepareStatement(CHAR_SEL_PET_DECLINED_NAME, "SELECT genitive, dative, accusative, instrumental, prepositional FROM character_pet_declinedname WHERE owner = ? AND id = ?", CONNECTION_ASYNC);
552 PrepareStatement(CHAR_SEL_PET_AURA, "SELECT casterGuid, spell, effectMask, recalculateMask, stackCount, amount0, amount1, amount2, base_amount0, base_amount1, base_amount2, maxDuration, remainTime, remainCharges FROM pet_aura WHERE guid = ?", CONNECTION_ASYNC);
553 PrepareStatement(CHAR_SEL_PET_SPELL, "SELECT spell, active FROM pet_spell WHERE guid = ?", CONNECTION_ASYNC);
554 PrepareStatement(CHAR_SEL_PET_SPELL_COOLDOWN, "SELECT spell, category, time FROM pet_spell_cooldown WHERE guid = ?", CONNECTION_ASYNC);
555 PrepareStatement(CHAR_DEL_PET_AURAS, "DELETE FROM pet_aura WHERE guid = ?", CONNECTION_ASYNC);
556 PrepareStatement(CHAR_DEL_PET_SPELLS, "DELETE FROM pet_spell WHERE guid = ?", CONNECTION_ASYNC);
557 PrepareStatement(CHAR_DEL_PET_SPELL_COOLDOWNS, "DELETE FROM pet_spell_cooldown WHERE guid = ?", CONNECTION_ASYNC);
558 PrepareStatement(CHAR_INS_PET_SPELL_COOLDOWN, "INSERT INTO pet_spell_cooldown (guid, spell, category, time) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
559 PrepareStatement(CHAR_DEL_PET_SPELL_BY_SPELL, "DELETE FROM pet_spell WHERE guid = ? AND spell = ?", CONNECTION_ASYNC);
560 PrepareStatement(CHAR_INS_PET_SPELL, "INSERT INTO pet_spell (guid, spell, active) VALUES (?, ?, ?)", CONNECTION_ASYNC);
561 PrepareStatement(CHAR_INS_PET_AURA, "INSERT INTO pet_aura (guid, casterGuid, spell, effectMask, recalculateMask, stackCount, amount0, amount1, amount2, "
562 "base_amount0, base_amount1, base_amount2, maxDuration, remainTime, remainCharges) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
563 PrepareStatement(CHAR_SEL_CHAR_PETS, "SELECT id, entry, modelid, level, exp, Reactstate, slot, name, renamed, curhealth, curmana, curhappiness, abdata, savetime, CreatedBySpell, PetType FROM character_pet WHERE owner = ?", CONNECTION_ASYNC);
564 PrepareStatement(CHAR_DEL_CHAR_PET_BY_OWNER, "DELETE FROM character_pet WHERE owner = ?", CONNECTION_ASYNC);
565 PrepareStatement(CHAR_UPD_CHAR_PET_NAME, "UPDATE character_pet SET name = ?, renamed = 1 WHERE owner = ? AND id = ?", CONNECTION_ASYNC);
566 PrepareStatement(CHAR_UPD_CHAR_PET_SLOT_BY_ID, "UPDATE character_pet SET slot = ? WHERE owner = ? AND id = ?", CONNECTION_ASYNC);
567 PrepareStatement(CHAR_DEL_CHAR_PET_BY_ID, "DELETE FROM character_pet WHERE id = ?", CONNECTION_ASYNC);
568 PrepareStatement(CHAR_DEL_CHAR_PET_BY_SLOT, "DELETE FROM character_pet WHERE owner = ? AND (slot = ? OR slot > ?)", CONNECTION_ASYNC);
569 PrepareStatement(CHAR_REP_CHAR_PET, "REPLACE INTO character_pet (id, entry, owner, modelid, CreatedBySpell, PetType, level, exp, Reactstate, name, renamed, slot, curhealth, curmana, curhappiness, savetime, abdata) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
570
571 // PvPstats
572 PrepareStatement(CHAR_SEL_PVPSTATS_MAXID, "SELECT MAX(id) FROM pvpstats_battlegrounds", CONNECTION_SYNCH);
573 PrepareStatement(CHAR_INS_PVPSTATS_BATTLEGROUND, "INSERT INTO pvpstats_battlegrounds (id, winner_faction, bracket_id, type, date) VALUES (?, ?, ?, ?, NOW())", CONNECTION_ASYNC);
574 PrepareStatement(CHAR_INS_PVPSTATS_PLAYER, "INSERT INTO pvpstats_players (battleground_id, character_guid, winner, score_killing_blows, score_deaths, score_honorable_kills, score_bonus_honor, score_damage_done, score_healing_done, attr_1, attr_2, attr_3, attr_4, attr_5) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
575 PrepareStatement(CHAR_SEL_PVPSTATS_FACTIONS_OVERALL, "SELECT winner_faction, COUNT(*) AS count FROM pvpstats_battlegrounds WHERE DATEDIFF(NOW(), date) < 7 GROUP BY winner_faction ORDER BY winner_faction ASC", CONNECTION_SYNCH);
576 PrepareStatement(CHAR_SEL_PVPSTATS_BRACKET_MONTH, "SELECT character_guid, COUNT(character_guid) AS count, characters.name as character_name FROM pvpstats_players INNER JOIN pvpstats_battlegrounds ON pvpstats_players.battleground_id = pvpstats_battlegrounds.id AND bracket_id = ? AND MONTH(date) = MONTH(NOW()) AND YEAR(date) = YEAR(NOW()) INNER JOIN characters ON pvpstats_players.character_guid = characters.guid AND characters.deleteDate IS NULL WHERE pvpstats_players.winner = 1 GROUP BY character_guid ORDER BY count(character_guid) DESC LIMIT 0, ?", CONNECTION_SYNCH);
577
578 // Deserter tracker
579 PrepareStatement(CHAR_INS_DESERTER_TRACK, "INSERT INTO battleground_deserters (guid, type, datetime) VALUES (?, ?, NOW())", CONNECTION_ASYNC);
580
581 // QuestTracker
582 PrepareStatement(CHAR_INS_QUEST_TRACK, "INSERT INTO quest_tracker (id, character_guid, quest_accept_time, core_hash, core_revision) VALUES (?, ?, NOW(), ?, ?)", CONNECTION_ASYNC);
583 PrepareStatement(CHAR_UPD_QUEST_TRACK_GM_COMPLETE, "UPDATE quest_tracker SET completed_by_gm = 1 WHERE id = ? AND character_guid = ? ORDER BY quest_accept_time DESC LIMIT 1", CONNECTION_ASYNC);
584 PrepareStatement(CHAR_UPD_QUEST_TRACK_COMPLETE_TIME, "UPDATE quest_tracker SET quest_complete_time = NOW() WHERE id = ? AND character_guid = ? ORDER BY quest_accept_time DESC LIMIT 1", CONNECTION_ASYNC);
585 PrepareStatement(CHAR_UPD_QUEST_TRACK_ABANDON_TIME, "UPDATE quest_tracker SET quest_abandon_time = NOW() WHERE id = ? AND character_guid = ? ORDER BY quest_accept_time DESC LIMIT 1", CONNECTION_ASYNC);
586
587 // Recovery Item
588 PrepareStatement(CHAR_INS_RECOVERY_ITEM, "INSERT INTO recovery_item (Guid, ItemEntry, Count) VALUES (?, ?, ?)", CONNECTION_SYNCH);
589 PrepareStatement(CHAR_SEL_RECOVERY_ITEM, "SELECT id, itemEntry, Count, Guid FROM recovery_item WHERE id = ?", CONNECTION_SYNCH);
590 PrepareStatement(CHAR_SEL_RECOVERY_ITEM_LIST, "SELECT id, itemEntry, Count FROM recovery_item WHERE Guid = ? ORDER BY id DESC", CONNECTION_SYNCH);
591 PrepareStatement(CHAR_DEL_RECOVERY_ITEM, "DELETE FROM recovery_item WHERE Guid = ? AND ItemEntry = ? AND Count = ? ORDER BY Id DESC LIMIT 1", CONNECTION_ASYNC);
592 PrepareStatement(CHAR_DEL_RECOVERY_ITEM_BY_RECOVERY_ID, "DELETE FROM recovery_item WHERE id = ?", CONNECTION_ASYNC);
593
594 PrepareStatement(CHAR_SEL_HONORPOINTS, "SELECT totalHonorPoints FROM characters WHERE guid = ?", CONNECTION_SYNCH);
595 PrepareStatement(CHAR_SEL_ARENAPOINTS, "SELECT arenaPoints FROM characters WHERE guid = ?", CONNECTION_SYNCH);
596
597 // Character names
598 PrepareStatement(CHAR_INS_RESERVED_PLAYER_NAME, "INSERT IGNORE INTO reserved_name (name) VALUES (?)", CONNECTION_ASYNC);
599 PrepareStatement(CHAR_INS_PROFANITY_PLAYER_NAME, "INSERT IGNORE INTO profanity_name (name) VALUES (?)", CONNECTION_ASYNC);
600
601 // Character settings
602 PrepareStatement(CHAR_SEL_CHAR_SETTINGS, "SELECT source, data FROM character_settings WHERE guid = ?", CONNECTION_ASYNC);
603 PrepareStatement(CHAR_REP_CHAR_SETTINGS, "REPLACE INTO character_settings (guid, source, data) VALUES (?, ?, ?)", CONNECTION_ASYNC);
604 PrepareStatement(CHAR_DEL_CHAR_SETTINGS, "DELETE FROM character_settings WHERE guid = ?", CONNECTION_ASYNC);
605
606 // Instance saved data. Stores the states of gameobjects in instances to be loaded on server start
607 PrepareStatement(CHAR_SELECT_INSTANCE_SAVED_DATA, "SELECT id, guid, state FROM instance_saved_go_state_data", CONNECTION_SYNCH);
608 PrepareStatement(CHAR_UPDATE_INSTANCE_SAVED_DATA, "UPDATE instance_saved_go_state_data SET state = ? WHERE guid = ? AND id = ?", CONNECTION_ASYNC);
609 PrepareStatement(CHAR_INSERT_INSTANCE_SAVED_DATA, "INSERT INTO instance_saved_go_state_data (id, guid, state) VALUES (?, ?, ?)", CONNECTION_ASYNC);
610 PrepareStatement(CHAR_DELETE_INSTANCE_SAVED_DATA, "DELETE FROM instance_saved_go_state_data WHERE id = ?", CONNECTION_ASYNC);
611 PrepareStatement(CHAR_SANITIZE_INSTANCE_SAVED_DATA, "DELETE FROM instance_saved_go_state_data WHERE id NOT IN (SELECT instance.id FROM instance)", CONNECTION_ASYNC);
612}
CHAR_SEL_CHARACTER_ACTIONS
@ CHAR_SEL_CHARACTER_ACTIONS
Definition: CharacterDatabase.h:80
CHAR_SEL_CHARACTER_DAILYQUESTSTATUS
@ CHAR_SEL_CHARACTER_DAILYQUESTSTATUS
Definition: CharacterDatabase.h:70
CHAR_INS_TUTORIALS
@ CHAR_INS_TUTORIALS
Definition: CharacterDatabase.h:207
CHAR_DEL_CHAR_GLYPHS
@ CHAR_DEL_CHAR_GLYPHS
Definition: CharacterDatabase.h:417
CHAR_SEL_CHAR_CUSTOMIZE_INFO
@ CHAR_SEL_CHAR_CUSTOMIZE_INFO
Definition: CharacterDatabase.h:344
CHAR_DEL_QUEST_STATUS_DAILY_CHAR
@ CHAR_DEL_QUEST_STATUS_DAILY_CHAR
Definition: CharacterDatabase.h:59
CHAR_DEL_CHAR_SOCIAL_BY_FRIEND
@ CHAR_DEL_CHAR_SOCIAL_BY_FRIEND
Definition: CharacterDatabase.h:390
CHAR_SEL_PINFO_XP
@ CHAR_SEL_PINFO_XP
Definition: CharacterDatabase.h:336
CHAR_UPD_TUTORIALS
@ CHAR_UPD_TUTORIALS
Definition: CharacterDatabase.h:208
CHAR_REP_GROUP_MEMBER
@ CHAR_REP_GROUP_MEMBER
Definition: CharacterDatabase.h:282
CHAR_UPD_ITEM_INSTANCE
@ CHAR_UPD_ITEM_INSTANCE
Definition: CharacterDatabase.h:125
CHAR_INS_GUILD_MEMBER
@ CHAR_INS_GUILD_MEMBER
Definition: CharacterDatabase.h:143
CHAR_DEL_CHAR_GIFT
@ CHAR_DEL_CHAR_GIFT
Definition: CharacterDatabase.h:405
CHAR_DEL_CHAR_PET_DECLINEDNAME_BY_OWNER
@ CHAR_DEL_CHAR_PET_DECLINEDNAME_BY_OWNER
Definition: CharacterDatabase.h:473
CHAR_DEL_CHANNEL
@ CHAR_DEL_CHANNEL
Definition: CharacterDatabase.h:185
CHAR_UPD_ITEM_INSTANCE_ON_LOAD
@ CHAR_UPD_ITEM_INSTANCE_ON_LOAD
Definition: CharacterDatabase.h:126
CHAR_SEL_CHAR_OLD_CHARS
@ CHAR_SEL_CHAR_OLD_CHARS
Definition: CharacterDatabase.h:349
CHAR_REP_CHAR_SETTINGS
@ CHAR_REP_CHAR_SETTINGS
Definition: CharacterDatabase.h:516
CHAR_UPD_CHAR_INVENTORY_FACTION_CHANGE
@ CHAR_UPD_CHAR_INVENTORY_FACTION_CHANGE
Definition: CharacterDatabase.h:393
CHAR_INS_GM_SURVEY
@ CHAR_INS_GM_SURVEY
Definition: CharacterDatabase.h:267
CHAR_SEL_CHECK_NAME
@ CHAR_SEL_CHECK_NAME
Definition: CharacterDatabase.h:37
CHAR_DEL_GUILD_BANK_EVENTLOG_BY_PLAYER
@ CHAR_DEL_GUILD_BANK_EVENTLOG_BY_PLAYER
Definition: CharacterDatabase.h:416
CHAR_UPD_MAIL
@ CHAR_UPD_MAIL
Definition: CharacterDatabase.h:432
CHAR_SEL_CHARACTER_AT_LOGIN
@ CHAR_SEL_CHARACTER_AT_LOGIN
Definition: CharacterDatabase.h:342
CHAR_INS_ARENA_LOG_MEMBERSTATS
@ CHAR_INS_ARENA_LOG_MEMBERSTATS
Definition: CharacterDatabase.h:314
CHAR_UPD_CHANNEL
@ CHAR_UPD_CHANNEL
Definition: CharacterDatabase.h:184
CHAR_INS_PETITION_SIGNATURE
@ CHAR_INS_PETITION_SIGNATURE
Definition: CharacterDatabase.h:279
CHAR_SEL_CHAR_INVENTORY_ITEM_BY_ENTRY
@ CHAR_SEL_CHAR_INVENTORY_ITEM_BY_ENTRY
Definition: CharacterDatabase.h:358
CHAR_INSERT_INSTANCE_SAVED_DATA
@ CHAR_INSERT_INSTANCE_SAVED_DATA
Definition: CharacterDatabase.h:521
CHAR_DEL_CHANNEL_BAN
@ CHAR_DEL_CHANNEL_BAN
Definition: CharacterDatabase.h:190
CHAR_UPD_GUILD_MOTD
@ CHAR_UPD_GUILD_MOTD
Definition: CharacterDatabase.h:168
CHAR_REP_CALENDAR_EVENT
@ CHAR_REP_CALENDAR_EVENT
Definition: CharacterDatabase.h:456
CHAR_DEL_GUILD_BANK_TABS
@ CHAR_DEL_GUILD_BANK_TABS
Definition: CharacterDatabase.h:152
CHAR_SEL_PVPSTATS_FACTIONS_OVERALL
@ CHAR_SEL_PVPSTATS_FACTIONS_OVERALL
Definition: CharacterDatabase.h:493
CHAR_UPD_CHAR_ONLINE
@ CHAR_UPD_CHAR_ONLINE
Definition: CharacterDatabase.h:302
CHAR_SEL_CHAR_GUID_NAME_BY_ACC
@ CHAR_SEL_CHAR_GUID_NAME_BY_ACC
Definition: CharacterDatabase.h:340
CHAR_DEL_CHAR_QUESTSTATUS_REWARDED_BY_QUEST
@ CHAR_DEL_CHAR_QUESTSTATUS_REWARDED_BY_QUEST
Definition: CharacterDatabase.h:436
CHAR_INS_CHAR_SPELL
@ CHAR_INS_CHAR_SPELL
Definition: CharacterDatabase.h:443
CHAR_DEL_PETITION_BY_GUID
@ CHAR_DEL_PETITION_BY_GUID
Definition: CharacterDatabase.h:379
CHAR_SEL_CHARACTER
@ CHAR_SEL_CHARACTER
Definition: CharacterDatabase.h:66
CHAR_UPD_ITEM_OWNER
@ CHAR_UPD_ITEM_OWNER
Definition: CharacterDatabase.h:118
CHAR_UPD_GUILD_BANK_TAB_TEXT
@ CHAR_UPD_GUILD_BANK_TAB_TEXT
Definition: CharacterDatabase.h:178
CHAR_UPD_CHAR_INSTANCE_SET_NOT_EXTENDED
@ CHAR_UPD_CHAR_INSTANCE_SET_NOT_EXTENDED
Definition: CharacterDatabase.h:308
CHAR_SEL_CHAR_HOMEBIND
@ CHAR_SEL_CHAR_HOMEBIND
Definition: CharacterDatabase.h:339
CHAR_DEL_RECOVERY_ITEM_BY_RECOVERY_ID
@ CHAR_DEL_RECOVERY_ITEM_BY_RECOVERY_ID
Definition: CharacterDatabase.h:507
CHAR_INS_CHARACTER_SEASONALQUESTSTATUS
@ CHAR_INS_CHARACTER_SEASONALQUESTSTATUS
Definition: CharacterDatabase.h:77
CHAR_DEL_ARENA_TEAM_MEMBERS
@ CHAR_DEL_ARENA_TEAM_MEMBERS
Definition: CharacterDatabase.h:225
CHAR_UPD_GLOBAL_INSTANCE_RESETTIME
@ CHAR_UPD_GLOBAL_INSTANCE_RESETTIME
Definition: CharacterDatabase.h:301
CHAR_DEL_GAME_EVENT_SAVE
@ CHAR_DEL_GAME_EVENT_SAVE
Definition: CharacterDatabase.h:215
CHAR_SEL_PET_AURA
@ CHAR_SEL_PET_AURA
Definition: CharacterDatabase.h:461
CHAR_INS_ARENA_LOG_FIGHT
@ CHAR_INS_ARENA_LOG_FIGHT
Definition: CharacterDatabase.h:313
CHAR_UPD_QUEST_TRACK_COMPLETE_TIME
@ CHAR_UPD_QUEST_TRACK_COMPLETE_TIME
Definition: CharacterDatabase.h:500
CHAR_DEL_GUILD
@ CHAR_DEL_GUILD
Definition: CharacterDatabase.h:141
CHAR_DEL_ITEMCONTAINER_CONTAINER
@ CHAR_DEL_ITEMCONTAINER_CONTAINER
Definition: CharacterDatabase.h:488
CHAR_UPD_REM_AT_LOGIN_FLAG
@ CHAR_UPD_REM_AT_LOGIN_FLAG
Definition: CharacterDatabase.h:275
CHAR_DEL_GUILD_BANK_RIGHTS
@ CHAR_DEL_GUILD_BANK_RIGHTS
Definition: CharacterDatabase.h:157
CHAR_SEL_CHARACTER_QUESTSTATUSREW
@ CHAR_SEL_CHARACTER_QUESTSTATUSREW
Definition: CharacterDatabase.h:99
CHAR_SEL_PLAYER_ACCOUNT_DATA
@ CHAR_SEL_PLAYER_ACCOUNT_DATA
Definition: CharacterDatabase.h:201
CHAR_UPD_GUILD_BANK_EVENTLOG_TAB
@ CHAR_UPD_GUILD_BANK_EVENTLOG_TAB
Definition: CharacterDatabase.h:176
CHAR_DEL_ARENA_TEAM
@ CHAR_DEL_ARENA_TEAM
Definition: CharacterDatabase.h:224
CHAR_UPD_CHAR_QUESTSTATUS_REWARDED_FACTION_CHANGE
@ CHAR_UPD_CHAR_QUESTSTATUS_REWARDED_FACTION_CHANGE
Definition: CharacterDatabase.h:437
CHAR_SEL_AUCTION_ITEMS
@ CHAR_SEL_AUCTION_ITEMS
Definition: CharacterDatabase.h:104
CHAR_UPD_LEVEL
@ CHAR_UPD_LEVEL
Definition: CharacterDatabase.h:295
CHAR_DEL_GUILD_EVENTLOG_BY_PLAYER
@ CHAR_DEL_GUILD_EVENTLOG_BY_PLAYER
Definition: CharacterDatabase.h:415
CHAR_INS_CHANNEL_BAN
@ CHAR_INS_CHANNEL_BAN
Definition: CharacterDatabase.h:189
CHAR_DEL_DECLINED_NAME
@ CHAR_DEL_DECLINED_NAME
Definition: CharacterDatabase.h:138
CHAR_DEL_ITEM_INSTANCE
@ CHAR_DEL_ITEM_INSTANCE
Definition: CharacterDatabase.h:127
CHAR_UPD_EQUIP_SET
@ CHAR_UPD_EQUIP_SET
Definition: CharacterDatabase.h:192
CHAR_UPDATE_INSTANCE_SAVED_DATA
@ CHAR_UPDATE_INSTANCE_SAVED_DATA
Definition: CharacterDatabase.h:520
CHAR_INS_CHARACTER_BAN
@ CHAR_INS_CHARACTER_BAN
Definition: CharacterDatabase.h:41
CHAR_DEL_CHAR_AURA_FROZEN
@ CHAR_DEL_CHAR_AURA_FROZEN
Definition: CharacterDatabase.h:353
CHAR_DEL_CHAR_SKILL_LANGUAGES
@ CHAR_DEL_CHAR_SKILL_LANGUAGES
Definition: CharacterDatabase.h:384
CHAR_DEL_CHAR_SKILLS
@ CHAR_DEL_CHAR_SKILLS
Definition: CharacterDatabase.h:419
CHAR_SEL_CHARACTER_AURAS
@ CHAR_SEL_CHARACTER_AURAS
Definition: CharacterDatabase.h:67
CHAR_DEL_CALENDAR_INVITE
@ CHAR_DEL_CALENDAR_INVITE
Definition: CharacterDatabase.h:459
CHAR_DEL_CHAR_PET_BY_OWNER
@ CHAR_DEL_CHAR_PET_BY_OWNER
Definition: CharacterDatabase.h:472
CHAR_DEL_CHARACTER_BAN
@ CHAR_DEL_CHARACTER_BAN
Definition: CharacterDatabase.h:43
CHAR_DEL_TUTORIALS
@ CHAR_DEL_TUTORIALS
Definition: CharacterDatabase.h:209
CHAR_SEL_CHAR_PETS
@ CHAR_SEL_CHAR_PETS
Definition: CharacterDatabase.h:474
CHAR_DEL_QUEST_STATUS_WEEKLY_CHAR
@ CHAR_DEL_QUEST_STATUS_WEEKLY_CHAR
Definition: CharacterDatabase.h:60
CHAR_UPD_GUILD_RANK_NAME
@ CHAR_UPD_GUILD_RANK_NAME
Definition: CharacterDatabase.h:171
CHAR_INS_CHAR_TALENT
@ CHAR_INS_CHAR_TALENT
Definition: CharacterDatabase.h:453
CHAR_DEL_CHAR_PET_BY_SLOT
@ CHAR_DEL_CHAR_PET_BY_SLOT
Definition: CharacterDatabase.h:482
CHAR_DEL_CHAR_STATS
@ CHAR_DEL_CHAR_STATS
Definition: CharacterDatabase.h:444
CHAR_DEL_ITEM_INSTANCE_BY_OWNER
@ CHAR_DEL_ITEM_INSTANCE_BY_OWNER
Definition: CharacterDatabase.h:128
CHAR_SEL_ACCOUNT_INSTANCELOCKTIMES
@ CHAR_SEL_ACCOUNT_INSTANCELOCKTIMES
Definition: CharacterDatabase.h:100
CHAR_DEL_CHAR_INVENTORY_BY_ITEM
@ CHAR_DEL_CHAR_INVENTORY_BY_ITEM
Definition: CharacterDatabase.h:430
CHAR_DEL_GROUP_MEMBER_ALL
@ CHAR_DEL_GROUP_MEMBER_ALL
Definition: CharacterDatabase.h:374
CHAR_UPD_GUILD_NAME
@ CHAR_UPD_GUILD_NAME
Definition: CharacterDatabase.h:142
CHAR_INS_CHAR_SKILLS
@ CHAR_INS_CHAR_SKILLS
Definition: CharacterDatabase.h:441
CHAR_DEL_CREATURE_RESPAWN_BY_INSTANCE
@ CHAR_DEL_CREATURE_RESPAWN_BY_INSTANCE
Definition: CharacterDatabase.h:253
CHAR_INS_GUILD_EVENTLOG
@ CHAR_INS_GUILD_EVENTLOG
Definition: CharacterDatabase.h:162
CHAR_DEL_INVALID_SPELL_TALENTS
@ CHAR_DEL_INVALID_SPELL_TALENTS
Definition: CharacterDatabase.h:291
CHAR_UPD_CHAR_ACHIEVEMENT
@ CHAR_UPD_CHAR_ACHIEVEMENT
Definition: CharacterDatabase.h:392
CHAR_UPD_MAIL_RETURNED
@ CHAR_UPD_MAIL_RETURNED
Definition: CharacterDatabase.h:116
CHAR_UPD_GUILD_EMBLEM_INFO
@ CHAR_UPD_GUILD_EMBLEM_INFO
Definition: CharacterDatabase.h:173
CHAR_SEL_PVPSTATS_MAXID
@ CHAR_SEL_PVPSTATS_MAXID
Definition: CharacterDatabase.h:490
CHAR_UPD_CHARACTER_BAN
@ CHAR_UPD_CHARACTER_BAN
Definition: CharacterDatabase.h:42
CHAR_DEL_INVALID_PET_SPELL
@ CHAR_DEL_INVALID_PET_SPELL
Definition: CharacterDatabase.h:300
CHAR_SEL_CHAR_DEL_INFO_BY_NAME
@ CHAR_SEL_CHAR_DEL_INFO_BY_NAME
Definition: CharacterDatabase.h:331
CHAR_SEL_CHAR_DEL_INFO
@ CHAR_SEL_CHAR_DEL_INFO
Definition: CharacterDatabase.h:332
CHAR_SEL_EXPIRED_MAIL
@ CHAR_SEL_EXPIRED_MAIL
Definition: CharacterDatabase.h:114
CHAR_DEL_GO_RESPAWN
@ CHAR_DEL_GO_RESPAWN
Definition: CharacterDatabase.h:257
CHAR_DEL_AUCTION
@ CHAR_DEL_AUCTION
Definition: CharacterDatabase.h:106
CHAR_SEL_CHARACTER_MAILCOUNT_UNREAD_SYNCH
@ CHAR_SEL_CHARACTER_MAILCOUNT_UNREAD_SYNCH
Definition: CharacterDatabase.h:83
CHAR_DEL_GROUP
@ CHAR_DEL_GROUP
Definition: CharacterDatabase.h:373
CHAR_DEL_CALENDAR_EVENT
@ CHAR_DEL_CALENDAR_EVENT
Definition: CharacterDatabase.h:457
CHAR_DEL_PETITION_SIGNATURE
@ CHAR_DEL_PETITION_SIGNATURE
Definition: CharacterDatabase.h:235
CHAR_SEL_ITEMCONTAINER_ITEMS
@ CHAR_SEL_ITEMCONTAINER_ITEMS
Definition: CharacterDatabase.h:485
CHAR_REP_INVENTORY_ITEM
@ CHAR_REP_INVENTORY_ITEM
Definition: CharacterDatabase.h:123
CHAR_DEL_CHAR_DECLINED_NAME
@ CHAR_DEL_CHAR_DECLINED_NAME
Definition: CharacterDatabase.h:381
CHAR_INS_CHARACTER_WEEKLYQUESTSTATUS
@ CHAR_INS_CHARACTER_WEEKLYQUESTSTATUS
Definition: CharacterDatabase.h:75
CHAR_DEL_GUILD_BANK_EVENTLOGS
@ CHAR_DEL_GUILD_BANK_EVENTLOGS
Definition: CharacterDatabase.h:161
CHAR_DEL_PETITION_SIGNATURE_BY_OWNER
@ CHAR_DEL_PETITION_SIGNATURE_BY_OWNER
Definition: CharacterDatabase.h:448
CHAR_SEL_CHAR_RACE_OR_FACTION_CHANGE_INFOS
@ CHAR_SEL_CHAR_RACE_OR_FACTION_CHANGE_INFOS
Definition: CharacterDatabase.h:345
CHAR_INS_EQUIP_SET
@ CHAR_INS_EQUIP_SET
Definition: CharacterDatabase.h:193
CHAR_DEL_ALL_PETITION_SIGNATURES
@ CHAR_DEL_ALL_PETITION_SIGNATURES
Definition: CharacterDatabase.h:234
CHAR_SEL_ACCOUNT_BY_NAME
@ CHAR_SEL_ACCOUNT_BY_NAME
Definition: CharacterDatabase.h:132
CHAR_SEL_CHARACTER_AURA_FROZEN
@ CHAR_SEL_CHARACTER_AURA_FROZEN
Definition: CharacterDatabase.h:327
CHAR_INS_LAG_REPORT
@ CHAR_INS_LAG_REPORT
Definition: CharacterDatabase.h:269
CHAR_INS_BATTLEGROUND_RANDOM
@ CHAR_INS_BATTLEGROUND_RANDOM
Definition: CharacterDatabase.h:64
CHAR_SEL_MAILITEMS
@ CHAR_SEL_MAILITEMS
Definition: CharacterDatabase.h:101
CHAR_UPD_QUEST_TRACK_ABANDON_TIME
@ CHAR_UPD_QUEST_TRACK_ABANDON_TIME
Definition: CharacterDatabase.h:501
CHAR_SEL_BANNED_NAME
@ CHAR_SEL_BANNED_NAME
Definition: CharacterDatabase.h:47
CHAR_INS_ITEMCONTAINER_SINGLE_ITEM
@ CHAR_INS_ITEMCONTAINER_SINGLE_ITEM
Definition: CharacterDatabase.h:487
CHAR_DEL_QUEST_POOL_SAVE
@ CHAR_DEL_QUEST_POOL_SAVE
Definition: CharacterDatabase.h:31
CHAR_INS_PVPSTATS_PLAYER
@ CHAR_INS_PVPSTATS_PLAYER
Definition: CharacterDatabase.h:492
CHAR_INS_INSTANCE_SAVE
@ CHAR_INS_INSTANCE_SAVE
Definition: CharacterDatabase.h:211
CHAR_SEL_CHECK_GUID
@ CHAR_SEL_CHECK_GUID
Definition: CharacterDatabase.h:38
CHAR_SEL_CHARACTER_COUNT
@ CHAR_SEL_CHARACTER_COUNT
Definition: CharacterDatabase.h:136
CHAR_UPD_DELETE_INFO
@ CHAR_UPD_DELETE_INFO
Definition: CharacterDatabase.h:292
CHAR_UPD_PETITION_NAME
@ CHAR_UPD_PETITION_NAME
Definition: CharacterDatabase.h:278
CHAR_INS_CHARACTER_MONTHLYQUESTSTATUS
@ CHAR_INS_CHARACTER_MONTHLYQUESTSTATUS
Definition: CharacterDatabase.h:76
CHAR_INS_PET_SPELL_COOLDOWN
@ CHAR_INS_PET_SPELL_COOLDOWN
Definition: CharacterDatabase.h:466
CHAR_INS_PLAYER_ENTRY_POINT
@ CHAR_INS_PLAYER_ENTRY_POINT
Definition: CharacterDatabase.h:237
CHAR_REP_CALENDAR_INVITE
@ CHAR_REP_CALENDAR_INVITE
Definition: CharacterDatabase.h:458
CHAR_SEL_HONORPOINTS
@ CHAR_SEL_HONORPOINTS
Definition: CharacterDatabase.h:509
CHAR_SEL_CHAR_INVENTORY_ITEM_BY_ENTRY_AND_OWNER
@ CHAR_SEL_CHAR_INVENTORY_ITEM_BY_ENTRY_AND_OWNER
Definition: CharacterDatabase.h:359
CHAR_SEL_RECOVERY_ITEM_LIST
@ CHAR_SEL_RECOVERY_ITEM_LIST
Definition: CharacterDatabase.h:505
CHAR_DEL_ALL_GAME_EVENT_CONDITION_SAVE
@ CHAR_DEL_ALL_GAME_EVENT_CONDITION_SAVE
Definition: CharacterDatabase.h:218
CHAR_UPD_CHAR_PET_SLOT_BY_ID
@ CHAR_UPD_CHAR_PET_SLOT_BY_ID
Definition: CharacterDatabase.h:480
CHAR_DEL_INVALID_MAIL_ITEM
@ CHAR_DEL_INVALID_MAIL_ITEM
Definition: CharacterDatabase.h:113
CHAR_DEL_CHARACTER_SKILL
@ CHAR_DEL_CHARACTER_SKILL
Definition: CharacterDatabase.h:316
CHAR_DEL_GUILD_BANK_RIGHTS_FOR_RANK
@ CHAR_DEL_GUILD_BANK_RIGHTS_FOR_RANK
Definition: CharacterDatabase.h:158
CHAR_SEL_BANINFO
@ CHAR_SEL_BANINFO
Definition: CharacterDatabase.h:44
CHAR_INS_PLAYER_HOMEBIND
@ CHAR_INS_PLAYER_HOMEBIND
Definition: CharacterDatabase.h:240
CHAR_DEL_NONEXISTENT_GUILD_BANK_ITEM
@ CHAR_DEL_NONEXISTENT_GUILD_BANK_ITEM
Definition: CharacterDatabase.h:33
CHAR_DEL_INVALID_SPELL_SPELLS
@ CHAR_DEL_INVALID_SPELL_SPELLS
Definition: CharacterDatabase.h:290
CHAR_UPD_ARENA_TEAM_STATS
@ CHAR_UPD_ARENA_TEAM_STATS
Definition: CharacterDatabase.h:228
CHAR_SEL_ARENA_TEAM_ID_BY_PLAYER_GUID
@ CHAR_SEL_ARENA_TEAM_ID_BY_PLAYER_GUID
Definition: CharacterDatabase.h:350
CHAR_UPD_NAME_BY_GUID
@ CHAR_UPD_NAME_BY_GUID
Definition: CharacterDatabase.h:137
CHAR_INS_GAME_EVENT_SAVE
@ CHAR_INS_GAME_EVENT_SAVE
Definition: CharacterDatabase.h:216
CHAR_INS_CHAR_SKILL_LANGUAGE
@ CHAR_INS_CHAR_SKILL_LANGUAGE
Definition: CharacterDatabase.h:385
CHAR_SEL_TUTORIALS
@ CHAR_SEL_TUTORIALS
Definition: CharacterDatabase.h:205
CHAR_INS_BUG_REPORT
@ CHAR_INS_BUG_REPORT
Definition: CharacterDatabase.h:277
CHAR_SEL_CHARACTER_SOCIALLIST
@ CHAR_SEL_CHARACTER_SOCIALLIST
Definition: CharacterDatabase.h:86
CHAR_DEL_CHAR_ACTION_BY_BUTTON_SPEC
@ CHAR_DEL_CHAR_ACTION_BY_BUTTON_SPEC
Definition: CharacterDatabase.h:429
CHAR_SEL_MAIL_SERVER_CHARACTER
@ CHAR_SEL_MAIL_SERVER_CHARACTER
Definition: CharacterDatabase.h:84
CHAR_UPD_CHAR_SPELL_FACTION_CHANGE
@ CHAR_UPD_CHAR_SPELL_FACTION_CHANGE
Definition: CharacterDatabase.h:395
CHAR_UPD_CHAR_TAXI_PATH
@ CHAR_UPD_CHAR_TAXI_PATH
Definition: CharacterDatabase.h:386
CHAR_DEL_MAIL_ITEM
@ CHAR_DEL_MAIL_ITEM
Definition: CharacterDatabase.h:112
CHAR_UPD_CHAR_TAXIMASK
@ CHAR_UPD_CHAR_TAXIMASK
Definition: CharacterDatabase.h:387
CHAR_INS_GROUP
@ CHAR_INS_GROUP
Definition: CharacterDatabase.h:281
CHAR_SEL_BANINFO_LIST
@ CHAR_SEL_BANINFO_LIST
Definition: CharacterDatabase.h:46
CHAR_DEL_CHAR_ACHIEVEMENT_PROGRESS_BY_CRITERIA
@ CHAR_DEL_CHAR_ACHIEVEMENT_PROGRESS_BY_CRITERIA
Definition: CharacterDatabase.h:366
CHAR_DEL_PLAYER_HOMEBIND
@ CHAR_DEL_PLAYER_HOMEBIND
Definition: CharacterDatabase.h:242
CHAR_DEL_CHAR_EQUIPMENTSETS
@ CHAR_DEL_CHAR_EQUIPMENTSETS
Definition: CharacterDatabase.h:414
CHAR_SEL_CHARACTER_ACTIONS_SPEC
@ CHAR_SEL_CHARACTER_ACTIONS_SPEC
Definition: CharacterDatabase.h:81
CHAR_INS_MAIL_ITEM
@ CHAR_INS_MAIL_ITEM
Definition: CharacterDatabase.h:111
CHAR_SEL_CHAR_POSITION
@ CHAR_SEL_CHAR_POSITION
Definition: CharacterDatabase.h:54
CHAR_UPD_CHAR_ACTION
@ CHAR_UPD_CHAR_ACTION
Definition: CharacterDatabase.h:428
CHAR_UPD_GUILD_MEMBER_RANK
@ CHAR_UPD_GUILD_MEMBER_RANK
Definition: CharacterDatabase.h:167
CHAR_INS_GUILD_RANK
@ CHAR_INS_GUILD_RANK
Definition: CharacterDatabase.h:147
CHAR_UDP_CHAR_MONEY_ACCUMULATIVE
@ CHAR_UDP_CHAR_MONEY_ACCUMULATIVE
Definition: CharacterDatabase.h:425
CHAR_SEL_PVPSTATS_BRACKET_MONTH
@ CHAR_SEL_PVPSTATS_BRACKET_MONTH
Definition: CharacterDatabase.h:494
CHAR_REP_CREATURE_RESPAWN
@ CHAR_REP_CREATURE_RESPAWN
Definition: CharacterDatabase.h:251
CHAR_DEL_EQUIP_SET
@ CHAR_DEL_EQUIP_SET
Definition: CharacterDatabase.h:194
CHAR_INS_CHAR_ACHIEVEMENT_PROGRESS
@ CHAR_INS_CHAR_ACHIEVEMENT_PROGRESS
Definition: CharacterDatabase.h:367
CHAR_INS_GUILD
@ CHAR_INS_GUILD
Definition: CharacterDatabase.h:140
CHAR_SEL_CHAR_REP_BY_FACTION
@ CHAR_SEL_CHAR_REP_BY_FACTION
Definition: CharacterDatabase.h:396
CHAR_INS_AURA
@ CHAR_INS_AURA
Definition: CharacterDatabase.h:196
CHAR_SEL_CHARACTER_HOMEBIND
@ CHAR_SEL_CHARACTER_HOMEBIND
Definition: CharacterDatabase.h:87
CHAR_DEL_INSTANCE_BY_INSTANCE
@ CHAR_DEL_INSTANCE_BY_INSTANCE
Definition: CharacterDatabase.h:376
CHAR_DEL_RECOVERY_ITEM
@ CHAR_DEL_RECOVERY_ITEM
Definition: CharacterDatabase.h:506
CHAR_INS_ARENA_TEAM_MEMBER
@ CHAR_INS_ARENA_TEAM_MEMBER
Definition: CharacterDatabase.h:223
CHAR_SEL_FREE_NAME
@ CHAR_SEL_FREE_NAME
Definition: CharacterDatabase.h:50
CHAR_UPD_GUILD_RANK_BANK_MONEY
@ CHAR_UPD_GUILD_RANK_BANK_MONEY
Definition: CharacterDatabase.h:177
CHAR_INS_GM_SUBSURVEY
@ CHAR_INS_GM_SUBSURVEY
Definition: CharacterDatabase.h:268
CHAR_SEL_ENUM
@ CHAR_SEL_ENUM
Definition: CharacterDatabase.h:48
CHAR_UPD_GUILD_LEADER
@ CHAR_UPD_GUILD_LEADER
Definition: CharacterDatabase.h:170
CHAR_DEL_PETITION_SIGNATURE_BY_OWNER_AND_TYPE
@ CHAR_DEL_PETITION_SIGNATURE_BY_OWNER_AND_TYPE
Definition: CharacterDatabase.h:450
CHAR_REP_BREW_OF_THE_MONTH
@ CHAR_REP_BREW_OF_THE_MONTH
Definition: CharacterDatabase.h:103
CHAR_SEL_CHARACTER_ENTRY_POINT
@ CHAR_SEL_CHARACTER_ENTRY_POINT
Definition: CharacterDatabase.h:93
CHAR_SEL_SUM_CHARS
@ CHAR_SEL_SUM_CHARS
Definition: CharacterDatabase.h:39
CHAR_SEL_CHAR_STATS
@ CHAR_SEL_CHAR_STATS
Definition: CharacterDatabase.h:446
CHAR_UPD_CHANNEL_USAGE
@ CHAR_UPD_CHANNEL_USAGE
Definition: CharacterDatabase.h:186
CHAR_DEL_CHAR_SPELL_BY_SPELL
@ CHAR_DEL_CHAR_SPELL_BY_SPELL
Definition: CharacterDatabase.h:394
CHAR_DEL_PET_SPELLS
@ CHAR_DEL_PET_SPELLS
Definition: CharacterDatabase.h:471
CHAR_SEL_CHAR_CREATE_INFO
@ CHAR_SEL_CHAR_CREATE_INFO
Definition: CharacterDatabase.h:40
CHAR_SEL_CHARACTER_INVENTORY
@ CHAR_SEL_CHARACTER_INVENTORY
Definition: CharacterDatabase.h:79
CHAR_UPD_CHAR_QUESTSTATUS_REWARDED_ACTIVE_BY_QUEST
@ CHAR_UPD_CHAR_QUESTSTATUS_REWARDED_ACTIVE_BY_QUEST
Definition: CharacterDatabase.h:439
CHAR_SEL_HAS_TUTORIALS
@ CHAR_SEL_HAS_TUTORIALS
Definition: CharacterDatabase.h:206
CHAR_UPD_GROUP_DIFFICULTY
@ CHAR_UPD_GROUP_DIFFICULTY
Definition: CharacterDatabase.h:288
CHAR_SEL_ACCOUNT_DATA
@ CHAR_SEL_ACCOUNT_DATA
Definition: CharacterDatabase.h:198
CHAR_UPD_CHARACTER_POSITION
@ CHAR_UPD_CHARACTER_POSITION
Definition: CharacterDatabase.h:322
CHAR_INS_CHAR_INSTANCE
@ CHAR_INS_CHAR_INSTANCE
Definition: CharacterDatabase.h:312
CHAR_DEL_ITEM_BOP_TRADE
@ CHAR_DEL_ITEM_BOP_TRADE
Definition: CharacterDatabase.h:121
CHAR_INS_CHAR_ACHIEVEMENT
@ CHAR_INS_CHAR_ACHIEVEMENT
Definition: CharacterDatabase.h:365
CHAR_DEL_CHAR_QUESTSTATUS_BY_QUEST
@ CHAR_DEL_CHAR_QUESTSTATUS_BY_QUEST
Definition: CharacterDatabase.h:434
CHAR_UPD_QUEST_TRACK_GM_COMPLETE
@ CHAR_UPD_QUEST_TRACK_GM_COMPLETE
Definition: CharacterDatabase.h:499
CHAR_SEL_EXPIRED_MAIL_ITEMS
@ CHAR_SEL_EXPIRED_MAIL_ITEMS
Definition: CharacterDatabase.h:115
CHAR_UDP_RESTORE_DELETE_INFO
@ CHAR_UDP_RESTORE_DELETE_INFO
Definition: CharacterDatabase.h:293
CHAR_INS_ADDON
@ CHAR_INS_ADDON
Definition: CharacterDatabase.h:299
CHAR_DEL_ACCOUNT_DATA
@ CHAR_DEL_ACCOUNT_DATA
Definition: CharacterDatabase.h:200
CHAR_SEL_CHARACTER_QUESTSTATUS
@ CHAR_SEL_CHARACTER_QUESTSTATUS
Definition: CharacterDatabase.h:69
CHAR_SEL_CHAR_DEL_INFO_BY_GUID
@ CHAR_SEL_CHAR_DEL_INFO_BY_GUID
Definition: CharacterDatabase.h:330
CHAR_DEL_GAME_EVENT_CONDITION_SAVE
@ CHAR_DEL_GAME_EVENT_CONDITION_SAVE
Definition: CharacterDatabase.h:219
CHAR_REP_CHARACTER_ARENA_STATS
@ CHAR_REP_CHARACTER_ARENA_STATS
Definition: CharacterDatabase.h:230
CHAR_UPD_GROUP_TYPE
@ CHAR_UPD_GROUP_TYPE
Definition: CharacterDatabase.h:285
CHAR_SEL_GUILD_MEMBER_EXTENDED
@ CHAR_SEL_GUILD_MEMBER_EXTENDED
Definition: CharacterDatabase.h:146
CHAR_UDP_CHAR_ARENA_POINTS
@ CHAR_UDP_CHAR_ARENA_POINTS
Definition: CharacterDatabase.h:422
CHAR_DEL_PLAYER_ACCOUNT_DATA
@ CHAR_DEL_PLAYER_ACCOUNT_DATA
Definition: CharacterDatabase.h:203
CHAR_DEL_QUEST_STATUS_SEASONAL_CHAR
@ CHAR_DEL_QUEST_STATUS_SEASONAL_CHAR
Definition: CharacterDatabase.h:62
CHAR_UPD_ACCOUNT_ONLINE
@ CHAR_UPD_ACCOUNT_ONLINE
Definition: CharacterDatabase.h:280
CHAR_UPD_GUILD_RANK_RIGHTS
@ CHAR_UPD_GUILD_RANK_RIGHTS
Definition: CharacterDatabase.h:172
CHAR_SELECT_INSTANCE_SAVED_DATA
@ CHAR_SELECT_INSTANCE_SAVED_DATA
Definition: CharacterDatabase.h:519
CHAR_UDP_CHAR_SKILLS
@ CHAR_UDP_CHAR_SKILLS
Definition: CharacterDatabase.h:442
CHAR_UDP_CHAR_HONOR_POINTS_ACCUMULATIVE
@ CHAR_UDP_CHAR_HONOR_POINTS_ACCUMULATIVE
Definition: CharacterDatabase.h:421
CHAR_UPD_PLAYER_HOMEBIND
@ CHAR_UPD_PLAYER_HOMEBIND
Definition: CharacterDatabase.h:241
CHAR_DEL_CHAR_INSTANCE_BY_INSTANCE_NOT_EXTENDED
@ CHAR_DEL_CHAR_INSTANCE_BY_INSTANCE_NOT_EXTENDED
Definition: CharacterDatabase.h:307
CHAR_DEL_MAIL
@ CHAR_DEL_MAIL
Definition: CharacterDatabase.h:411
CHAR_INS_CHAR_GLYPHS
@ CHAR_INS_CHAR_GLYPHS
Definition: CharacterDatabase.h:451
CHAR_UPD_GUILD_MEMBER_PNOTE
@ CHAR_UPD_GUILD_MEMBER_PNOTE
Definition: CharacterDatabase.h:165
CHAR_INS_CHAR_STATS
@ CHAR_INS_CHAR_STATS
Definition: CharacterDatabase.h:445
CHAR_SEL_CHARACTER_NAME_DATA
@ CHAR_SEL_CHARACTER_NAME_DATA
Definition: CharacterDatabase.h:52
CHAR_DEL_CHAR_ACHIEVEMENT_BY_ACHIEVEMENT
@ CHAR_DEL_CHAR_ACHIEVEMENT_BY_ACHIEVEMENT
Definition: CharacterDatabase.h:391
CHAR_SEL_CHARS_BY_ACCOUNT_ID
@ CHAR_SEL_CHARS_BY_ACCOUNT_ID
Definition: CharacterDatabase.h:334
CHAR_SEL_CHAR_POSITION_XYZ
@ CHAR_SEL_CHAR_POSITION_XYZ
Definition: CharacterDatabase.h:53
CHAR_SEL_CHARACTER_TALENTS
@ CHAR_SEL_CHARACTER_TALENTS
Definition: CharacterDatabase.h:95
CHAR_DEL_CHAR_TALENT
@ CHAR_DEL_CHAR_TALENT
Definition: CharacterDatabase.h:418
CHAR_SEL_CHAR_CLASS_LVL_AT_LOGIN
@ CHAR_SEL_CHAR_CLASS_LVL_AT_LOGIN
Definition: CharacterDatabase.h:343
CHAR_DEL_CORPSE
@ CHAR_DEL_CORPSE
Definition: CharacterDatabase.h:246
CHAR_DEL_ALL_GM_TICKETS
@ CHAR_DEL_ALL_GM_TICKETS
Definition: CharacterDatabase.h:263
CHAR_DEL_QUEST_STATUS_WEEKLY
@ CHAR_DEL_QUEST_STATUS_WEEKLY
Definition: CharacterDatabase.h:56
CHAR_SEL_CHARACTER_WEEKLYQUESTSTATUS
@ CHAR_SEL_CHARACTER_WEEKLYQUESTSTATUS
Definition: CharacterDatabase.h:71
CHAR_DEL_CHAR_SKILL_BY_SKILL
@ CHAR_DEL_CHAR_SKILL_BY_SKILL
Definition: CharacterDatabase.h:440
CHAR_SEL_CHARACTER_MAILCOUNT_UNREAD
@ CHAR_SEL_CHARACTER_MAILCOUNT_UNREAD
Definition: CharacterDatabase.h:82
CHAR_SEL_MAIL_COUNT_ITEM
@ CHAR_SEL_MAIL_COUNT_ITEM
Definition: CharacterDatabase.h:355
CHAR_UPD_INSTANCE_SAVE_ENCOUNTERMASK
@ CHAR_UPD_INSTANCE_SAVE_ENCOUNTERMASK
Definition: CharacterDatabase.h:213
CHAR_SEL_CHAR_SOCIAL
@ CHAR_SEL_CHAR_SOCIAL
Definition: CharacterDatabase.h:348
CHAR_INS_PET_SPELL
@ CHAR_INS_PET_SPELL
Definition: CharacterDatabase.h:468
CHAR_UDP_CHAR_HONOR_POINTS
@ CHAR_UDP_CHAR_HONOR_POINTS
Definition: CharacterDatabase.h:420
CHAR_SEL_MAIL
@ CHAR_SEL_MAIL
Definition: CharacterDatabase.h:351
CHAR_UPD_CHARACTER_SOCIAL_NOTE
@ CHAR_UPD_CHARACTER_SOCIAL_NOTE
Definition: CharacterDatabase.h:321
CHAR_SEL_CHAR_SETTINGS
@ CHAR_SEL_CHAR_SETTINGS
Definition: CharacterDatabase.h:515
CHAR_DEL_CHAR_PET_BY_ID
@ CHAR_DEL_CHAR_PET_BY_ID
Definition: CharacterDatabase.h:481
CHAR_INS_GUILD_BANK_TAB
@ CHAR_INS_GUILD_BANK_TAB
Definition: CharacterDatabase.h:150
CHAR_SEL_CORPSE_LOCATION
@ CHAR_SEL_CORPSE_LOCATION
Definition: CharacterDatabase.h:248
CHAR_SEL_CHAR_DATA_FOR_GUILD
@ CHAR_SEL_CHAR_DATA_FOR_GUILD
Definition: CharacterDatabase.h:181
CHAR_UPD_GUILD_BANK_MONEY
@ CHAR_UPD_GUILD_BANK_MONEY
Definition: CharacterDatabase.h:175
CHAR_INS_AUCTION
@ CHAR_INS_AUCTION
Definition: CharacterDatabase.h:105
CHAR_DEL_PET_AURAS
@ CHAR_DEL_PET_AURAS
Definition: CharacterDatabase.h:464
CHAR_SEL_NEXT_MAIL_DELIVERYTIME
@ CHAR_SEL_NEXT_MAIL_DELIVERYTIME
Definition: CharacterDatabase.h:352
CHAR_SEL_CHARACTER_CRITERIAPROGRESS
@ CHAR_SEL_CHARACTER_CRITERIAPROGRESS
Definition: CharacterDatabase.h:91
CHAR_SEL_GM_TICKETS
@ CHAR_SEL_GM_TICKETS
Definition: CharacterDatabase.h:260
CHAR_UPD_GROUP_RAID_DIFFICULTY
@ CHAR_UPD_GROUP_RAID_DIFFICULTY
Definition: CharacterDatabase.h:289
CHAR_DEL_ITEM_REFUND_INSTANCE
@ CHAR_DEL_ITEM_REFUND_INSTANCE
Definition: CharacterDatabase.h:371
CHAR_DEL_GUILD_BANK_TAB
@ CHAR_DEL_GUILD_BANK_TAB
Definition: CharacterDatabase.h:151
CHAR_DEL_INVALID_ACHIEVMENT
@ CHAR_DEL_INVALID_ACHIEVMENT
Definition: CharacterDatabase.h:298
CHAR_DEL_CHAR_INVENTORY
@ CHAR_DEL_CHAR_INVENTORY
Definition: CharacterDatabase.h:407
CHAR_REP_CHAR_PET
@ CHAR_REP_CHAR_PET
Definition: CharacterDatabase.h:483
CHAR_UPD_ARENA_TEAM_MEMBER
@ CHAR_UPD_ARENA_TEAM_MEMBER
Definition: CharacterDatabase.h:229
CHAR_DEL_ACCOUNT_INSTANCE_LOCK_TIMES
@ CHAR_DEL_ACCOUNT_INSTANCE_LOCK_TIMES
Definition: CharacterDatabase.h:133
CHAR_DEL_CREATURE_RESPAWN
@ CHAR_DEL_CREATURE_RESPAWN
Definition: CharacterDatabase.h:252
CHAR_SEL_AUCTIONHOUSE_COUNT_ITEM
@ CHAR_SEL_AUCTIONHOUSE_COUNT_ITEM
Definition: CharacterDatabase.h:356
CHAR_SEL_PET_DECLINED_NAME
@ CHAR_SEL_PET_DECLINED_NAME
Definition: CharacterDatabase.h:478
CHAR_SEL_CHARACTER_GLYPHS
@ CHAR_SEL_CHARACTER_GLYPHS
Definition: CharacterDatabase.h:94
CHAR_DEL_OLD_CHANNELS_BANS
@ CHAR_DEL_OLD_CHANNELS_BANS
Definition: CharacterDatabase.h:188
CHAR_SEL_BREW_OF_THE_MONTH
@ CHAR_SEL_BREW_OF_THE_MONTH
Definition: CharacterDatabase.h:102
CHAR_DELETE_INSTANCE_SAVED_DATA
@ CHAR_DELETE_INSTANCE_SAVED_DATA
Definition: CharacterDatabase.h:522
CHAR_DEL_GO_RESPAWN_BY_INSTANCE
@ CHAR_DEL_GO_RESPAWN_BY_INSTANCE
Definition: CharacterDatabase.h:258
CHAR_SEL_CHARACTER_REPUTATION
@ CHAR_SEL_CHARACTER_REPUTATION
Definition: CharacterDatabase.h:78
CHAR_ADD_CHAR_PET_DECLINEDNAME
@ CHAR_ADD_CHAR_PET_DECLINEDNAME
Definition: CharacterDatabase.h:477
CHAR_DEL_QUEST_STATUS_MONTHLY_CHAR
@ CHAR_DEL_QUEST_STATUS_MONTHLY_CHAR
Definition: CharacterDatabase.h:61
CHAR_DEL_CHAR_AURA
@ CHAR_DEL_CHAR_AURA
Definition: CharacterDatabase.h:404
CHAR_INS_CHARACTER
@ CHAR_INS_CHARACTER
Definition: CharacterDatabase.h:271
CHAR_UPD_GROUP_MEMBER_FLAG
@ CHAR_UPD_GROUP_MEMBER_FLAG
Definition: CharacterDatabase.h:287
MAX_CHARACTERDATABASE_STATEMENTS
@ MAX_CHARACTERDATABASE_STATEMENTS
Definition: CharacterDatabase.h:525
CHAR_DEL_CHAR_QUESTSTATUS
@ CHAR_DEL_CHAR_QUESTSTATUS
Definition: CharacterDatabase.h:388
CHAR_DEL_CHAR_ACTION
@ CHAR_DEL_CHAR_ACTION
Definition: CharacterDatabase.h:403
CHAR_SEL_CHARACTER_SPELL
@ CHAR_SEL_CHARACTER_SPELL
Definition: CharacterDatabase.h:68
CHAR_DEL_GUILD_MEMBERS
@ CHAR_DEL_GUILD_MEMBERS
Definition: CharacterDatabase.h:145
CHAR_DEL_QUEST_STATUS_SEASONAL
@ CHAR_DEL_QUEST_STATUS_SEASONAL
Definition: CharacterDatabase.h:58
CHAR_SEL_MATCH_MAKER_RATING
@ CHAR_SEL_MATCH_MAKER_RATING
Definition: CharacterDatabase.h:135
CHAR_UPD_ARENA_TEAM_NAME
@ CHAR_UPD_ARENA_TEAM_NAME
Definition: CharacterDatabase.h:232
CHAR_INS_MAIL
@ CHAR_INS_MAIL
Definition: CharacterDatabase.h:109
CHAR_SEL_CHAR_AT_LOGIN_TITLES_MONEY
@ CHAR_SEL_CHAR_AT_LOGIN_TITLES_MONEY
Definition: CharacterDatabase.h:346
CHAR_UPD_GENDER_AND_APPEARANCE
@ CHAR_UPD_GENDER_AND_APPEARANCE
Definition: CharacterDatabase.h:315
CHAR_SEL_CORPSES
@ CHAR_SEL_CORPSES
Definition: CharacterDatabase.h:244
CHAR_DEL_CHAR_INSTANCE_BY_INSTANCE
@ CHAR_DEL_CHAR_INSTANCE_BY_INSTANCE
Definition: CharacterDatabase.h:306
CHAR_SEL_CHAR_PET_IDS
@ CHAR_SEL_CHAR_PET_IDS
Definition: CharacterDatabase.h:475
CHAR_SEL_ITEM_BOP_TRADE
@ CHAR_SEL_ITEM_BOP_TRADE
Definition: CharacterDatabase.h:120
CHAR_UPD_CHAR_REP_FACTION_CHANGE
@ CHAR_UPD_CHAR_REP_FACTION_CHANGE
Definition: CharacterDatabase.h:398
CHAR_INS_CHANNEL
@ CHAR_INS_CHANNEL
Definition: CharacterDatabase.h:183
CHAR_UPD_GUILD_MEMBER_OFFNOTE
@ CHAR_UPD_GUILD_MEMBER_OFFNOTE
Definition: CharacterDatabase.h:166
CHAR_INS_CHAR_GIFT
@ CHAR_INS_CHAR_GIFT
Definition: CharacterDatabase.h:375
CHAR_UPD_CHAR_INSTANCE_EXTENDED
@ CHAR_UPD_CHAR_INSTANCE_EXTENDED
Definition: CharacterDatabase.h:311
CHAR_DEL_PLAYER_ENTRY_POINT
@ CHAR_DEL_PLAYER_ENTRY_POINT
Definition: CharacterDatabase.h:238
CHAR_UPD_REM_CHARACTER_SOCIAL_FLAGS
@ CHAR_UPD_REM_CHARACTER_SOCIAL_FLAGS
Definition: CharacterDatabase.h:318
CHAR_REP_GO_RESPAWN
@ CHAR_REP_GO_RESPAWN
Definition: CharacterDatabase.h:256
CHAR_DEL_GUILD_BANK_EVENTLOG
@ CHAR_DEL_GUILD_BANK_EVENTLOG
Definition: CharacterDatabase.h:160
CHAR_DEL_GUILD_MEMBER_WITHDRAW
@ CHAR_DEL_GUILD_MEMBER_WITHDRAW
Definition: CharacterDatabase.h:180
CHAR_DEL_GUILD_MEMBER
@ CHAR_DEL_GUILD_MEMBER
Definition: CharacterDatabase.h:144
CHAR_DEL_MAIL_BY_ID
@ CHAR_DEL_MAIL_BY_ID
Definition: CharacterDatabase.h:110
CHAR_REP_PLAYER_ACCOUNT_DATA
@ CHAR_REP_PLAYER_ACCOUNT_DATA
Definition: CharacterDatabase.h:202
CHAR_UPD_XP_ACCUMULATIVE
@ CHAR_UPD_XP_ACCUMULATIVE
Definition: CharacterDatabase.h:296
CHAR_UPD_GROUP_LEADER
@ CHAR_UPD_GROUP_LEADER
Definition: CharacterDatabase.h:284
CHAR_SEL_GUILD_BANK_COUNT_ITEM
@ CHAR_SEL_GUILD_BANK_COUNT_ITEM
Definition: CharacterDatabase.h:357
CHAR_DEL_CHARACTER_SOCIAL
@ CHAR_DEL_CHARACTER_SOCIAL
Definition: CharacterDatabase.h:320
CHAR_DEL_CHAR_ACHIEVEMENTS
@ CHAR_DEL_CHAR_ACHIEVEMENTS
Definition: CharacterDatabase.h:413
CHAR_SEL_CHAR_PINFO
@ CHAR_SEL_CHAR_PINFO
Definition: CharacterDatabase.h:335
CHAR_SEL_POOL_QUEST_SAVE
@ CHAR_SEL_POOL_QUEST_SAVE
Definition: CharacterDatabase.h:341
CHAR_INS_PETITION
@ CHAR_INS_PETITION
Definition: CharacterDatabase.h:378
CHAR_UPD_CHAR_RACE
@ CHAR_UPD_CHAR_RACE
Definition: CharacterDatabase.h:383
CHAR_SEL_DATA_BY_GUID
@ CHAR_SEL_DATA_BY_GUID
Definition: CharacterDatabase.h:36
CHAR_INS_WORLDSTATE
@ CHAR_INS_WORLDSTATE
Definition: CharacterDatabase.h:305
CHAR_SEL_GUID_BY_NAME_FILTER
@ CHAR_SEL_GUID_BY_NAME_FILTER
Definition: CharacterDatabase.h:45
CHAR_SEL_CHARACTER_RANDOMBG
@ CHAR_SEL_CHARACTER_RANDOMBG
Definition: CharacterDatabase.h:97
CHAR_SEL_CHARACTER_EQUIPMENTSETS
@ CHAR_SEL_CHARACTER_EQUIPMENTSETS
Definition: CharacterDatabase.h:92
CHAR_SEL_CHARACTER_SKILLS
@ CHAR_SEL_CHARACTER_SKILLS
Definition: CharacterDatabase.h:96
CHAR_REP_GM_TICKET
@ CHAR_REP_GM_TICKET
Definition: CharacterDatabase.h:261
CHAR_UPD_ZONE
@ CHAR_UPD_ZONE
Definition: CharacterDatabase.h:294
CHAR_DEL_GUILD_BANK_ITEMS
@ CHAR_DEL_GUILD_BANK_ITEMS
Definition: CharacterDatabase.h:155
CHAR_INS_GAME_EVENT_CONDITION_SAVE
@ CHAR_INS_GAME_EVENT_CONDITION_SAVE
Definition: CharacterDatabase.h:220
CHAR_INS_PROFANITY_PLAYER_NAME
@ CHAR_INS_PROFANITY_PLAYER_NAME
Definition: CharacterDatabase.h:513
CHAR_UPD_ARENA_TEAM_CAPTAIN
@ CHAR_UPD_ARENA_TEAM_CAPTAIN
Definition: CharacterDatabase.h:226
CHAR_UPD_CHAR_TITLES_FACTION_CHANGE
@ CHAR_UPD_CHAR_TITLES_FACTION_CHANGE
Definition: CharacterDatabase.h:399
CHAR_DEL_GUILD_BANK_ITEM
@ CHAR_DEL_GUILD_BANK_ITEM
Definition: CharacterDatabase.h:154
CHAR_SEL_CHAR_COD_ITEM_MAIL
@ CHAR_SEL_CHAR_COD_ITEM_MAIL
Definition: CharacterDatabase.h:347
CHAR_SEL_AUCTIONHOUSE_ITEM_BY_ENTRY
@ CHAR_SEL_AUCTIONHOUSE_ITEM_BY_ENTRY
Definition: CharacterDatabase.h:361
CHAR_DEL_GUILD_EVENTLOG
@ CHAR_DEL_GUILD_EVENTLOG
Definition: CharacterDatabase.h:163
CHAR_DEL_CHAR_REP_BY_FACTION
@ CHAR_DEL_CHAR_REP_BY_FACTION
Definition: CharacterDatabase.h:397
CHAR_INS_RESERVED_PLAYER_NAME
@ CHAR_INS_RESERVED_PLAYER_NAME
Definition: CharacterDatabase.h:512
CHAR_SEL_CREATURE_RESPAWNS
@ CHAR_SEL_CREATURE_RESPAWNS
Definition: CharacterDatabase.h:250
CHAR_UPD_GUILD_INFO
@ CHAR_UPD_GUILD_INFO
Definition: CharacterDatabase.h:169
CHAR_DEL_CHAR_ACTION_EXCEPT_SPEC
@ CHAR_DEL_CHAR_ACTION_EXCEPT_SPEC
Definition: CharacterDatabase.h:454
CHAR_DEL_ITEMCONTAINER_SINGLE_ITEM
@ CHAR_DEL_ITEMCONTAINER_SINGLE_ITEM
Definition: CharacterDatabase.h:486
CHAR_INS_ARENA_TEAM
@ CHAR_INS_ARENA_TEAM
Definition: CharacterDatabase.h:222
CHAR_SEL_ENUM_DECLINED_NAME
@ CHAR_SEL_ENUM_DECLINED_NAME
Definition: CharacterDatabase.h:49
CHAR_DEL_PETITION_SIGNATURE_BY_GUID
@ CHAR_DEL_PETITION_SIGNATURE_BY_GUID
Definition: CharacterDatabase.h:380
CHAR_DEL_QUEST_STATUS_MONTHLY
@ CHAR_DEL_QUEST_STATUS_MONTHLY
Definition: CharacterDatabase.h:57
CHAR_SEL_CHARACTER_SPELLCOOLDOWNS
@ CHAR_SEL_CHARACTER_SPELLCOOLDOWNS
Definition: CharacterDatabase.h:88
CHAR_DEL_GUILD_EVENTLOGS
@ CHAR_DEL_GUILD_EVENTLOGS
Definition: CharacterDatabase.h:164
CHAR_SEL_GUILD_BANK_ITEM_BY_ENTRY
@ CHAR_SEL_GUILD_BANK_ITEM_BY_ENTRY
Definition: CharacterDatabase.h:362
CHAR_UPD_PLAYER_GM_TICKETS_ON_CHAR_DELETION
@ CHAR_UPD_PLAYER_GM_TICKETS_ON_CHAR_DELETION
Definition: CharacterDatabase.h:265
CHAR_SEL_ARENAPOINTS
@ CHAR_SEL_ARENAPOINTS
Definition: CharacterDatabase.h:510
CHAR_UPD_CHAR_INSTANCE
@ CHAR_UPD_CHAR_INSTANCE
Definition: CharacterDatabase.h:310
CHAR_INS_GUILD_BANK_EVENTLOG
@ CHAR_INS_GUILD_BANK_EVENTLOG
Definition: CharacterDatabase.h:159
CHAR_INS_CHARACTER_DAILYQUESTSTATUS
@ CHAR_INS_CHARACTER_DAILYQUESTSTATUS
Definition: CharacterDatabase.h:74
CHAR_INS_QUEST_TRACK
@ CHAR_INS_QUEST_TRACK
Definition: CharacterDatabase.h:498
CHAR_UPD_ADD_AT_LOGIN_FLAG
@ CHAR_UPD_ADD_AT_LOGIN_FLAG
Definition: CharacterDatabase.h:274
CHAR_RES_CHAR_TITLES_FACTION_CHANGE
@ CHAR_RES_CHAR_TITLES_FACTION_CHANGE
Definition: CharacterDatabase.h:400
CHAR_UPD_GIFT_OWNER
@ CHAR_UPD_GIFT_OWNER
Definition: CharacterDatabase.h:129
CHAR_REP_MAIL_SERVER_CHARACTER
@ CHAR_REP_MAIL_SERVER_CHARACTER
Definition: CharacterDatabase.h:85
CHAR_DEL_CORPSES_FROM_MAP
@ CHAR_DEL_CORPSES_FROM_MAP
Definition: CharacterDatabase.h:247
CHAR_DEL_QUEST_STATUS_DAILY
@ CHAR_DEL_QUEST_STATUS_DAILY
Definition: CharacterDatabase.h:55
CHAR_DEL_CHAR_REPUTATION
@ CHAR_DEL_CHAR_REPUTATION
Definition: CharacterDatabase.h:409
CHAR_DEL_PET_SPELL_BY_SPELL
@ CHAR_DEL_PET_SPELL_BY_SPELL
Definition: CharacterDatabase.h:467
CHAR_DEL_OLD_CHANNELS
@ CHAR_DEL_OLD_CHANNELS
Definition: CharacterDatabase.h:187
CHAR_INS_CHARACTER_SOCIAL
@ CHAR_INS_CHARACTER_SOCIAL
Definition: CharacterDatabase.h:319
CHAR_DEL_GIFT
@ CHAR_DEL_GIFT
Definition: CharacterDatabase.h:130
CHAR_UPD_CHARACTER
@ CHAR_UPD_CHARACTER
Definition: CharacterDatabase.h:272
CHAR_DEL_CHAR_INSTANCE_BY_INSTANCE_GUID
@ CHAR_DEL_CHAR_INSTANCE_BY_INSTANCE_GUID
Definition: CharacterDatabase.h:309
CHAR_SEL_CHARACTER_MONTHLYQUESTSTATUS
@ CHAR_SEL_CHARACTER_MONTHLYQUESTSTATUS
Definition: CharacterDatabase.h:72
CHAR_DEL_PET_SPELL_COOLDOWNS
@ CHAR_DEL_PET_SPELL_COOLDOWNS
Definition: CharacterDatabase.h:465
CHAR_SEL_PET_SPELL
@ CHAR_SEL_PET_SPELL
Definition: CharacterDatabase.h:462
CHAR_DEL_GM_TICKET
@ CHAR_DEL_GM_TICKET
Definition: CharacterDatabase.h:262
CHAR_DEL_CHAR_INVENTORY_BY_BAG_SLOT
@ CHAR_DEL_CHAR_INVENTORY_BY_BAG_SLOT
Definition: CharacterDatabase.h:431
CHAR_SEL_PINFO_MAILS
@ CHAR_SEL_PINFO_MAILS
Definition: CharacterDatabase.h:337
CHAR_INS_CHAR_REPUTATION_BY_FACTION
@ CHAR_INS_CHAR_REPUTATION_BY_FACTION
Definition: CharacterDatabase.h:369
CHAR_INS_CHAR_ACTION
@ CHAR_INS_CHAR_ACTION
Definition: CharacterDatabase.h:427
CHAR_DEL_CHAR_ACHIEVEMENT_PROGRESS
@ CHAR_DEL_CHAR_ACHIEVEMENT_PROGRESS
Definition: CharacterDatabase.h:364
CHAR_DEL_CHARACTER
@ CHAR_DEL_CHARACTER
Definition: CharacterDatabase.h:402
CHAR_SEL_ITEM_REFUNDS
@ CHAR_SEL_ITEM_REFUNDS
Definition: CharacterDatabase.h:119
CHAR_SEL_CHAR_INVENTORY_COUNT_ITEM
@ CHAR_SEL_CHAR_INVENTORY_COUNT_ITEM
Definition: CharacterDatabase.h:354
CHAR_DEL_CHAR_SPELL_COOLDOWN
@ CHAR_DEL_CHAR_SPELL_COOLDOWN
Definition: CharacterDatabase.h:401
CHAR_SEL_RECOVERY_ITEM
@ CHAR_SEL_RECOVERY_ITEM
Definition: CharacterDatabase.h:504
CHAR_SEL_PET_SPELL_COOLDOWN
@ CHAR_SEL_PET_SPELL_COOLDOWN
Definition: CharacterDatabase.h:463
CHAR_INS_QUEST_POOL_SAVE
@ CHAR_INS_QUEST_POOL_SAVE
Definition: CharacterDatabase.h:32
CHAR_DEL_CHAR_TALENT_BY_SPELL
@ CHAR_DEL_CHAR_TALENT_BY_SPELL
Definition: CharacterDatabase.h:452
CHAR_REP_ITEM_INSTANCE
@ CHAR_REP_ITEM_INSTANCE
Definition: CharacterDatabase.h:124
CHAR_UPD_CHAR_QUESTSTATUS_REWARDED_ACTIVE
@ CHAR_UPD_CHAR_QUESTSTATUS_REWARDED_ACTIVE
Definition: CharacterDatabase.h:438
CHAR_UPD_AUCTION_BID
@ CHAR_UPD_AUCTION_BID
Definition: CharacterDatabase.h:107
CHAR_DEL_GUILD_RANKS
@ CHAR_DEL_GUILD_RANKS
Definition: CharacterDatabase.h:148
CHAR_DEL_CHAR_SOCIAL_BY_GUID
@ CHAR_DEL_CHAR_SOCIAL_BY_GUID
Definition: CharacterDatabase.h:389
CHAR_SEL_CHARACTER_GIFT_BY_ITEM
@ CHAR_SEL_CHARACTER_GIFT_BY_ITEM
Definition: CharacterDatabase.h:131
CHAR_UPD_CHAR_REMOVE_GHOST
@ CHAR_UPD_CHAR_REMOVE_GHOST
Definition: CharacterDatabase.h:426
CHAR_SEL_CHARACTER_ACHIEVEMENTS
@ CHAR_SEL_CHARACTER_ACHIEVEMENTS
Definition: CharacterDatabase.h:90
CHAR_SEL_CHARACTER_ONLINE
@ CHAR_SEL_CHARACTER_ONLINE
Definition: CharacterDatabase.h:328
CHAR_UPD_ADD_CHARACTER_SOCIAL_FLAGS
@ CHAR_UPD_ADD_CHARACTER_SOCIAL_FLAGS
Definition: CharacterDatabase.h:317
CHAR_DEL_CHAR_SETTINGS
@ CHAR_DEL_CHAR_SETTINGS
Definition: CharacterDatabase.h:517
CHAR_UDP_CHAR_ARENA_POINTS_ACCUMULATIVE
@ CHAR_UDP_CHAR_ARENA_POINTS_ACCUMULATIVE
Definition: CharacterDatabase.h:423
CHAR_DEL_EXPIRED_BANS
@ CHAR_DEL_EXPIRED_BANS
Definition: CharacterDatabase.h:34
CHAR_INS_PVPSTATS_BATTLEGROUND
@ CHAR_INS_PVPSTATS_BATTLEGROUND
Definition: CharacterDatabase.h:491
CHAR_SEL_PINFO_BANS
@ CHAR_SEL_PINFO_BANS
Definition: CharacterDatabase.h:338
CHAR_UPD_GROUP_MEMBER_SUBGROUP
@ CHAR_UPD_GROUP_MEMBER_SUBGROUP
Definition: CharacterDatabase.h:286
CHAR_SEL_CHAR_ZONE
@ CHAR_SEL_CHAR_ZONE
Definition: CharacterDatabase.h:51
CHAR_SEL_CHARACTER_SEASONALQUESTSTATUS
@ CHAR_SEL_CHARACTER_SEASONALQUESTSTATUS
Definition: CharacterDatabase.h:73
CHAR_INS_RECOVERY_ITEM
@ CHAR_INS_RECOVERY_ITEM
Definition: CharacterDatabase.h:503
CHAR_REP_ACCOUNT_DATA
@ CHAR_REP_ACCOUNT_DATA
Definition: CharacterDatabase.h:199
CHAR_INS_ITEM_BOP_TRADE
@ CHAR_INS_ITEM_BOP_TRADE
Definition: CharacterDatabase.h:122
CHAR_UDP_CHAR_MONEY
@ CHAR_UDP_CHAR_MONEY
Definition: CharacterDatabase.h:424
CHAR_DEL_MAIL_ITEM_BY_ID
@ CHAR_DEL_MAIL_ITEM_BY_ID
Definition: CharacterDatabase.h:377
CHAR_DEL_CHAR_REPUTATION_BY_FACTION
@ CHAR_DEL_CHAR_REPUTATION_BY_FACTION
Definition: CharacterDatabase.h:368
CHAR_INS_GUILD_BANK_ITEM
@ CHAR_INS_GUILD_BANK_ITEM
Definition: CharacterDatabase.h:153
CHAR_UPD_INSTANCE_SAVE_DATA
@ CHAR_UPD_INSTANCE_SAVE_DATA
Definition: CharacterDatabase.h:212
CHAR_REP_LFG_DATA
@ CHAR_REP_LFG_DATA
Definition: CharacterDatabase.h:324
CHAR_SEL_DATA_BY_NAME
@ CHAR_SEL_DATA_BY_NAME
Definition: CharacterDatabase.h:35
CHAR_REP_CHAR_QUESTSTATUS
@ CHAR_REP_CHAR_QUESTSTATUS
Definition: CharacterDatabase.h:433
CHAR_SEL_CHARACTER_DECLINEDNAMES
@ CHAR_SEL_CHARACTER_DECLINEDNAMES
Definition: CharacterDatabase.h:89
CHAR_INS_DESERTER_TRACK
@ CHAR_INS_DESERTER_TRACK
Definition: CharacterDatabase.h:496
CHAR_DEL_CHAR_SPELL
@ CHAR_DEL_CHAR_SPELL
Definition: CharacterDatabase.h:410
CHAR_DEL_INVALID_ACHIEV_PROGRESS_CRITERIA
@ CHAR_DEL_INVALID_ACHIEV_PROGRESS_CRITERIA
Definition: CharacterDatabase.h:297
CHAR_INS_CORPSE
@ CHAR_INS_CORPSE
Definition: CharacterDatabase.h:245
CHAR_UPD_CHAR_NAME_AT_LOGIN
@ CHAR_UPD_CHAR_NAME_AT_LOGIN
Definition: CharacterDatabase.h:303
CHAR_DEL_CHAR_QUESTSTATUS_REWARDED
@ CHAR_DEL_CHAR_QUESTSTATUS_REWARDED
Definition: CharacterDatabase.h:408
CHAR_UPD_GUILD_BANK_TAB_INFO
@ CHAR_UPD_GUILD_BANK_TAB_INFO
Definition: CharacterDatabase.h:174
CHAR_INS_GUILD_MEMBER_WITHDRAW
@ CHAR_INS_GUILD_MEMBER_WITHDRAW
Definition: CharacterDatabase.h:179
CHAR_DEL_GUILD_LOWEST_RANK
@ CHAR_DEL_GUILD_LOWEST_RANK
Definition: CharacterDatabase.h:149
CHAR_INS_PET_AURA
@ CHAR_INS_PET_AURA
Definition: CharacterDatabase.h:469
CHAR_UPD_CHAR_ARENA_POINTS
@ CHAR_UPD_CHAR_ARENA_POINTS
Definition: CharacterDatabase.h:370
CHAR_INS_CHAR_DECLINED_NAME
@ CHAR_INS_CHAR_DECLINED_NAME
Definition: CharacterDatabase.h:382
CHAR_UPD_CHAR_PET_NAME
@ CHAR_UPD_CHAR_PET_NAME
Definition: CharacterDatabase.h:479
CHAR_DEL_PETITION_BY_OWNER
@ CHAR_DEL_PETITION_BY_OWNER
Definition: CharacterDatabase.h:447
CHAR_SEL_CHARACTER_BANNED
@ CHAR_SEL_CHARACTER_BANNED
Definition: CharacterDatabase.h:98
CHAR_UPD_ALL_AT_LOGIN_FLAGS
@ CHAR_UPD_ALL_AT_LOGIN_FLAGS
Definition: CharacterDatabase.h:276
CHAR_DEL_GROUP_MEMBER
@ CHAR_DEL_GROUP_MEMBER
Definition: CharacterDatabase.h:283
CHAR_SANITIZE_INSTANCE_SAVED_DATA
@ CHAR_SANITIZE_INSTANCE_SAVED_DATA
Definition: CharacterDatabase.h:523
CHAR_INS_ACCOUNT_INSTANCE_LOCK_TIMES
@ CHAR_INS_ACCOUNT_INSTANCE_LOCK_TIMES
Definition: CharacterDatabase.h:134
CHAR_SEL_GO_RESPAWNS
@ CHAR_SEL_GO_RESPAWNS
Definition: CharacterDatabase.h:255
CHAR_DEL_PLAYER_GM_TICKETS
@ CHAR_DEL_PLAYER_GM_TICKETS
Definition: CharacterDatabase.h:264
CHAR_DEL_PETITION_BY_OWNER_AND_TYPE
@ CHAR_DEL_PETITION_BY_OWNER_AND_TYPE
Definition: CharacterDatabase.h:449
CHAR_DEL_ARENA_TEAM_MEMBER
@ CHAR_DEL_ARENA_TEAM_MEMBER
Definition: CharacterDatabase.h:227
CHAR_DEL_MAIL_ITEMS
@ CHAR_DEL_MAIL_ITEMS
Definition: CharacterDatabase.h:412
CHAR_DEL_CHAR_INSTANCE
@ CHAR_DEL_CHAR_INSTANCE
Definition: CharacterDatabase.h:406
CHAR_SEL_MAIL_ITEMS_BY_ENTRY
@ CHAR_SEL_MAIL_ITEMS_BY_ENTRY
Definition: CharacterDatabase.h:360
CHAR_INS_ITEM_REFUND_INSTANCE
@ CHAR_INS_ITEM_REFUND_INSTANCE
Definition: CharacterDatabase.h:372
CHAR_INS_CHAR_QUESTSTATUS_REWARDED
@ CHAR_INS_CHAR_QUESTSTATUS_REWARDED
Definition: CharacterDatabase.h:435
CHAR_UPD_WORLDSTATE
@ CHAR_UPD_WORLDSTATE
Definition: CharacterDatabase.h:304
CHAR_UPD_MAIL_ITEM_RECEIVER
@ CHAR_UPD_MAIL_ITEM_RECEIVER
Definition: CharacterDatabase.h:117
CHAR_SEL_AUCTIONS
@ CHAR_SEL_AUCTIONS
Definition: CharacterDatabase.h:108
CHAR_DEL_LFG_DATA
@ CHAR_DEL_LFG_DATA
Definition: CharacterDatabase.h:325
CHAR_DEL_CHAR_ACHIEVEMENT
@ CHAR_DEL_CHAR_ACHIEVEMENT
Definition: CharacterDatabase.h:363
CHAR_DEL_BATTLEGROUND_RANDOM
@ CHAR_DEL_BATTLEGROUND_RANDOM
Definition: CharacterDatabase.h:63
CHAR_DEL_CHAR_PET_DECLINEDNAME
@ CHAR_DEL_CHAR_PET_DECLINEDNAME
Definition: CharacterDatabase.h:476
CHAR_SEL_PLAYER_ARENA_TEAMS
@ CHAR_SEL_PLAYER_ARENA_TEAMS
Definition: CharacterDatabase.h:231
CHAR_INS_GUILD_BANK_RIGHT
@ CHAR_INS_GUILD_BANK_RIGHT
Definition: CharacterDatabase.h:156
CONNECTION_SYNCH
@ CONNECTION_SYNCH
Definition: MySQLConnection.h:39
CONNECTION_BOTH
@ CONNECTION_BOTH
Definition: MySQLConnection.h:40
CONNECTION_ASYNC
@ CONNECTION_ASYNC
Definition: MySQLConnection.h:38
MySQLConnection::PrepareStatement
void PrepareStatement(uint32 index, std::string_view sql, ConnectionFlags flags)
Definition: MySQLConnection.cpp:503
MySQLConnection::m_stmts
PreparedStatementContainer m_stmts
Definition: MySQLConnection.h:105
MySQLConnection::m_reconnecting
bool m_reconnecting
PreparedStatements storage.
Definition: MySQLConnection.h:106

References CHAR_ADD_CHAR_PET_DECLINEDNAME, CHAR_DEL_ACCOUNT_DATA, CHAR_DEL_ACCOUNT_INSTANCE_LOCK_TIMES, CHAR_DEL_ALL_GAME_EVENT_CONDITION_SAVE, CHAR_DEL_ALL_GM_TICKETS, CHAR_DEL_ALL_PETITION_SIGNATURES, CHAR_DEL_ARENA_TEAM, CHAR_DEL_ARENA_TEAM_MEMBER, CHAR_DEL_ARENA_TEAM_MEMBERS, CHAR_DEL_AUCTION, CHAR_DEL_BATTLEGROUND_RANDOM, CHAR_DEL_CALENDAR_EVENT, CHAR_DEL_CALENDAR_INVITE, CHAR_DEL_CHANNEL, CHAR_DEL_CHANNEL_BAN, CHAR_DEL_CHAR_ACHIEVEMENT, CHAR_DEL_CHAR_ACHIEVEMENT_BY_ACHIEVEMENT, CHAR_DEL_CHAR_ACHIEVEMENT_PROGRESS, CHAR_DEL_CHAR_ACHIEVEMENT_PROGRESS_BY_CRITERIA, CHAR_DEL_CHAR_ACHIEVEMENTS, CHAR_DEL_CHAR_ACTION, CHAR_DEL_CHAR_ACTION_BY_BUTTON_SPEC, CHAR_DEL_CHAR_ACTION_EXCEPT_SPEC, CHAR_DEL_CHAR_AURA, CHAR_DEL_CHAR_AURA_FROZEN, CHAR_DEL_CHAR_DECLINED_NAME, CHAR_DEL_CHAR_EQUIPMENTSETS, CHAR_DEL_CHAR_GIFT, CHAR_DEL_CHAR_GLYPHS, CHAR_DEL_CHAR_INSTANCE, CHAR_DEL_CHAR_INSTANCE_BY_INSTANCE, CHAR_DEL_CHAR_INSTANCE_BY_INSTANCE_GUID, CHAR_DEL_CHAR_INSTANCE_BY_INSTANCE_NOT_EXTENDED, CHAR_DEL_CHAR_INVENTORY, CHAR_DEL_CHAR_INVENTORY_BY_BAG_SLOT, CHAR_DEL_CHAR_INVENTORY_BY_ITEM, CHAR_DEL_CHAR_PET_BY_ID, CHAR_DEL_CHAR_PET_BY_OWNER, CHAR_DEL_CHAR_PET_BY_SLOT, CHAR_DEL_CHAR_PET_DECLINEDNAME, CHAR_DEL_CHAR_PET_DECLINEDNAME_BY_OWNER, CHAR_DEL_CHAR_QUESTSTATUS, CHAR_DEL_CHAR_QUESTSTATUS_BY_QUEST, CHAR_DEL_CHAR_QUESTSTATUS_REWARDED, CHAR_DEL_CHAR_QUESTSTATUS_REWARDED_BY_QUEST, CHAR_DEL_CHAR_REP_BY_FACTION, CHAR_DEL_CHAR_REPUTATION, CHAR_DEL_CHAR_REPUTATION_BY_FACTION, CHAR_DEL_CHAR_SETTINGS, CHAR_DEL_CHAR_SKILL_BY_SKILL, CHAR_DEL_CHAR_SKILL_LANGUAGES, CHAR_DEL_CHAR_SKILLS, CHAR_DEL_CHAR_SOCIAL_BY_FRIEND, CHAR_DEL_CHAR_SOCIAL_BY_GUID, CHAR_DEL_CHAR_SPELL, CHAR_DEL_CHAR_SPELL_BY_SPELL, CHAR_DEL_CHAR_SPELL_COOLDOWN, CHAR_DEL_CHAR_STATS, CHAR_DEL_CHAR_TALENT, CHAR_DEL_CHAR_TALENT_BY_SPELL, CHAR_DEL_CHARACTER, CHAR_DEL_CHARACTER_BAN, CHAR_DEL_CHARACTER_SKILL, CHAR_DEL_CHARACTER_SOCIAL, CHAR_DEL_CORPSE, CHAR_DEL_CORPSES_FROM_MAP, CHAR_DEL_CREATURE_RESPAWN, CHAR_DEL_CREATURE_RESPAWN_BY_INSTANCE, CHAR_DEL_DECLINED_NAME, CHAR_DEL_EQUIP_SET, CHAR_DEL_EXPIRED_BANS, CHAR_DEL_GAME_EVENT_CONDITION_SAVE, CHAR_DEL_GAME_EVENT_SAVE, CHAR_DEL_GIFT, CHAR_DEL_GM_TICKET, CHAR_DEL_GO_RESPAWN, CHAR_DEL_GO_RESPAWN_BY_INSTANCE, CHAR_DEL_GROUP, CHAR_DEL_GROUP_MEMBER, CHAR_DEL_GROUP_MEMBER_ALL, CHAR_DEL_GUILD, CHAR_DEL_GUILD_BANK_EVENTLOG, CHAR_DEL_GUILD_BANK_EVENTLOG_BY_PLAYER, CHAR_DEL_GUILD_BANK_EVENTLOGS, CHAR_DEL_GUILD_BANK_ITEM, CHAR_DEL_GUILD_BANK_ITEMS, CHAR_DEL_GUILD_BANK_RIGHTS, CHAR_DEL_GUILD_BANK_RIGHTS_FOR_RANK, CHAR_DEL_GUILD_BANK_TAB, CHAR_DEL_GUILD_BANK_TABS, CHAR_DEL_GUILD_EVENTLOG, CHAR_DEL_GUILD_EVENTLOG_BY_PLAYER, CHAR_DEL_GUILD_EVENTLOGS, CHAR_DEL_GUILD_LOWEST_RANK, CHAR_DEL_GUILD_MEMBER, CHAR_DEL_GUILD_MEMBER_WITHDRAW, CHAR_DEL_GUILD_MEMBERS, CHAR_DEL_GUILD_RANKS, CHAR_DEL_INSTANCE_BY_INSTANCE, CHAR_DEL_INVALID_ACHIEV_PROGRESS_CRITERIA, CHAR_DEL_INVALID_ACHIEVMENT, CHAR_DEL_INVALID_MAIL_ITEM, CHAR_DEL_INVALID_PET_SPELL, CHAR_DEL_INVALID_SPELL_SPELLS, CHAR_DEL_INVALID_SPELL_TALENTS, CHAR_DEL_ITEM_BOP_TRADE, CHAR_DEL_ITEM_INSTANCE, CHAR_DEL_ITEM_INSTANCE_BY_OWNER, CHAR_DEL_ITEM_REFUND_INSTANCE, CHAR_DEL_ITEMCONTAINER_CONTAINER, CHAR_DEL_ITEMCONTAINER_SINGLE_ITEM, CHAR_DEL_LFG_DATA, CHAR_DEL_MAIL, CHAR_DEL_MAIL_BY_ID, CHAR_DEL_MAIL_ITEM, CHAR_DEL_MAIL_ITEM_BY_ID, CHAR_DEL_MAIL_ITEMS, CHAR_DEL_NONEXISTENT_GUILD_BANK_ITEM, CHAR_DEL_OLD_CHANNELS, CHAR_DEL_OLD_CHANNELS_BANS, CHAR_DEL_PET_AURAS, CHAR_DEL_PET_SPELL_BY_SPELL, CHAR_DEL_PET_SPELL_COOLDOWNS, CHAR_DEL_PET_SPELLS, CHAR_DEL_PETITION_BY_GUID, CHAR_DEL_PETITION_BY_OWNER, CHAR_DEL_PETITION_BY_OWNER_AND_TYPE, CHAR_DEL_PETITION_SIGNATURE, CHAR_DEL_PETITION_SIGNATURE_BY_GUID, CHAR_DEL_PETITION_SIGNATURE_BY_OWNER, CHAR_DEL_PETITION_SIGNATURE_BY_OWNER_AND_TYPE, CHAR_DEL_PLAYER_ACCOUNT_DATA, CHAR_DEL_PLAYER_ENTRY_POINT, CHAR_DEL_PLAYER_GM_TICKETS, CHAR_DEL_PLAYER_HOMEBIND, CHAR_DEL_QUEST_POOL_SAVE, CHAR_DEL_QUEST_STATUS_DAILY, CHAR_DEL_QUEST_STATUS_DAILY_CHAR, CHAR_DEL_QUEST_STATUS_MONTHLY, CHAR_DEL_QUEST_STATUS_MONTHLY_CHAR, CHAR_DEL_QUEST_STATUS_SEASONAL, CHAR_DEL_QUEST_STATUS_SEASONAL_CHAR, CHAR_DEL_QUEST_STATUS_WEEKLY, CHAR_DEL_QUEST_STATUS_WEEKLY_CHAR, CHAR_DEL_RECOVERY_ITEM, CHAR_DEL_RECOVERY_ITEM_BY_RECOVERY_ID, CHAR_DEL_TUTORIALS, CHAR_DELETE_INSTANCE_SAVED_DATA, CHAR_INS_ACCOUNT_INSTANCE_LOCK_TIMES, CHAR_INS_ADDON, CHAR_INS_ARENA_LOG_FIGHT, CHAR_INS_ARENA_LOG_MEMBERSTATS, CHAR_INS_ARENA_TEAM, CHAR_INS_ARENA_TEAM_MEMBER, CHAR_INS_AUCTION, CHAR_INS_AURA, CHAR_INS_BATTLEGROUND_RANDOM, CHAR_INS_BUG_REPORT, CHAR_INS_CHANNEL, CHAR_INS_CHANNEL_BAN, CHAR_INS_CHAR_ACHIEVEMENT, CHAR_INS_CHAR_ACHIEVEMENT_PROGRESS, CHAR_INS_CHAR_ACTION, CHAR_INS_CHAR_DECLINED_NAME, CHAR_INS_CHAR_GIFT, CHAR_INS_CHAR_GLYPHS, CHAR_INS_CHAR_INSTANCE, CHAR_INS_CHAR_QUESTSTATUS_REWARDED, CHAR_INS_CHAR_REPUTATION_BY_FACTION, CHAR_INS_CHAR_SKILL_LANGUAGE, CHAR_INS_CHAR_SKILLS, CHAR_INS_CHAR_SPELL, CHAR_INS_CHAR_STATS, CHAR_INS_CHAR_TALENT, CHAR_INS_CHARACTER, CHAR_INS_CHARACTER_BAN, CHAR_INS_CHARACTER_DAILYQUESTSTATUS, CHAR_INS_CHARACTER_MONTHLYQUESTSTATUS, CHAR_INS_CHARACTER_SEASONALQUESTSTATUS, CHAR_INS_CHARACTER_SOCIAL, CHAR_INS_CHARACTER_WEEKLYQUESTSTATUS, CHAR_INS_CORPSE, CHAR_INS_DESERTER_TRACK, CHAR_INS_EQUIP_SET, CHAR_INS_GAME_EVENT_CONDITION_SAVE, CHAR_INS_GAME_EVENT_SAVE, CHAR_INS_GM_SUBSURVEY, CHAR_INS_GM_SURVEY, CHAR_INS_GROUP, CHAR_INS_GUILD, CHAR_INS_GUILD_BANK_EVENTLOG, CHAR_INS_GUILD_BANK_ITEM, CHAR_INS_GUILD_BANK_RIGHT, CHAR_INS_GUILD_BANK_TAB, CHAR_INS_GUILD_EVENTLOG, CHAR_INS_GUILD_MEMBER, CHAR_INS_GUILD_MEMBER_WITHDRAW, CHAR_INS_GUILD_RANK, CHAR_INS_INSTANCE_SAVE, CHAR_INS_ITEM_BOP_TRADE, CHAR_INS_ITEM_REFUND_INSTANCE, CHAR_INS_ITEMCONTAINER_SINGLE_ITEM, CHAR_INS_LAG_REPORT, CHAR_INS_MAIL, CHAR_INS_MAIL_ITEM, CHAR_INS_PET_AURA, CHAR_INS_PET_SPELL, CHAR_INS_PET_SPELL_COOLDOWN, CHAR_INS_PETITION, CHAR_INS_PETITION_SIGNATURE, CHAR_INS_PLAYER_ENTRY_POINT, CHAR_INS_PLAYER_HOMEBIND, CHAR_INS_PROFANITY_PLAYER_NAME, CHAR_INS_PVPSTATS_BATTLEGROUND, CHAR_INS_PVPSTATS_PLAYER, CHAR_INS_QUEST_POOL_SAVE, CHAR_INS_QUEST_TRACK, CHAR_INS_RECOVERY_ITEM, CHAR_INS_RESERVED_PLAYER_NAME, CHAR_INS_TUTORIALS, CHAR_INS_WORLDSTATE, CHAR_INSERT_INSTANCE_SAVED_DATA, CHAR_REP_ACCOUNT_DATA, CHAR_REP_BREW_OF_THE_MONTH, CHAR_REP_CALENDAR_EVENT, CHAR_REP_CALENDAR_INVITE, CHAR_REP_CHAR_PET, CHAR_REP_CHAR_QUESTSTATUS, CHAR_REP_CHAR_SETTINGS, CHAR_REP_CHARACTER_ARENA_STATS, CHAR_REP_CREATURE_RESPAWN, CHAR_REP_GM_TICKET, CHAR_REP_GO_RESPAWN, CHAR_REP_GROUP_MEMBER, CHAR_REP_INVENTORY_ITEM, CHAR_REP_ITEM_INSTANCE, CHAR_REP_LFG_DATA, CHAR_REP_MAIL_SERVER_CHARACTER, CHAR_REP_PLAYER_ACCOUNT_DATA, CHAR_RES_CHAR_TITLES_FACTION_CHANGE, CHAR_SANITIZE_INSTANCE_SAVED_DATA, CHAR_SEL_ACCOUNT_BY_NAME, CHAR_SEL_ACCOUNT_DATA, CHAR_SEL_ACCOUNT_INSTANCELOCKTIMES, CHAR_SEL_ARENA_TEAM_ID_BY_PLAYER_GUID, CHAR_SEL_ARENAPOINTS, CHAR_SEL_AUCTION_ITEMS, CHAR_SEL_AUCTIONHOUSE_COUNT_ITEM, CHAR_SEL_AUCTIONHOUSE_ITEM_BY_ENTRY, CHAR_SEL_AUCTIONS, CHAR_SEL_BANINFO, CHAR_SEL_BANINFO_LIST, CHAR_SEL_BANNED_NAME, CHAR_SEL_BREW_OF_THE_MONTH, CHAR_SEL_CHAR_AT_LOGIN_TITLES_MONEY, CHAR_SEL_CHAR_CLASS_LVL_AT_LOGIN, CHAR_SEL_CHAR_COD_ITEM_MAIL, CHAR_SEL_CHAR_CREATE_INFO, CHAR_SEL_CHAR_CUSTOMIZE_INFO, CHAR_SEL_CHAR_DATA_FOR_GUILD, CHAR_SEL_CHAR_DEL_INFO, CHAR_SEL_CHAR_DEL_INFO_BY_GUID, CHAR_SEL_CHAR_DEL_INFO_BY_NAME, CHAR_SEL_CHAR_GUID_NAME_BY_ACC, CHAR_SEL_CHAR_HOMEBIND, CHAR_SEL_CHAR_INVENTORY_COUNT_ITEM, CHAR_SEL_CHAR_INVENTORY_ITEM_BY_ENTRY, CHAR_SEL_CHAR_INVENTORY_ITEM_BY_ENTRY_AND_OWNER, CHAR_SEL_CHAR_OLD_CHARS, CHAR_SEL_CHAR_PET_IDS, CHAR_SEL_CHAR_PETS, CHAR_SEL_CHAR_PINFO, CHAR_SEL_CHAR_POSITION, CHAR_SEL_CHAR_POSITION_XYZ, CHAR_SEL_CHAR_RACE_OR_FACTION_CHANGE_INFOS, CHAR_SEL_CHAR_REP_BY_FACTION, CHAR_SEL_CHAR_SETTINGS, CHAR_SEL_CHAR_SOCIAL, CHAR_SEL_CHAR_STATS, CHAR_SEL_CHAR_ZONE, CHAR_SEL_CHARACTER, CHAR_SEL_CHARACTER_ACHIEVEMENTS, CHAR_SEL_CHARACTER_ACTIONS, CHAR_SEL_CHARACTER_ACTIONS_SPEC, CHAR_SEL_CHARACTER_AT_LOGIN, CHAR_SEL_CHARACTER_AURA_FROZEN, CHAR_SEL_CHARACTER_AURAS, CHAR_SEL_CHARACTER_BANNED, CHAR_SEL_CHARACTER_COUNT, CHAR_SEL_CHARACTER_CRITERIAPROGRESS, CHAR_SEL_CHARACTER_DAILYQUESTSTATUS, CHAR_SEL_CHARACTER_DECLINEDNAMES, CHAR_SEL_CHARACTER_ENTRY_POINT, CHAR_SEL_CHARACTER_EQUIPMENTSETS, CHAR_SEL_CHARACTER_GIFT_BY_ITEM, CHAR_SEL_CHARACTER_GLYPHS, CHAR_SEL_CHARACTER_HOMEBIND, CHAR_SEL_CHARACTER_INVENTORY, CHAR_SEL_CHARACTER_MAILCOUNT_UNREAD, CHAR_SEL_CHARACTER_MAILCOUNT_UNREAD_SYNCH, CHAR_SEL_CHARACTER_MONTHLYQUESTSTATUS, CHAR_SEL_CHARACTER_NAME_DATA, CHAR_SEL_CHARACTER_ONLINE, CHAR_SEL_CHARACTER_QUESTSTATUS, CHAR_SEL_CHARACTER_QUESTSTATUSREW, CHAR_SEL_CHARACTER_RANDOMBG, CHAR_SEL_CHARACTER_REPUTATION, CHAR_SEL_CHARACTER_SEASONALQUESTSTATUS, CHAR_SEL_CHARACTER_SKILLS, CHAR_SEL_CHARACTER_SOCIALLIST, CHAR_SEL_CHARACTER_SPELL, CHAR_SEL_CHARACTER_SPELLCOOLDOWNS, CHAR_SEL_CHARACTER_TALENTS, CHAR_SEL_CHARACTER_WEEKLYQUESTSTATUS, CHAR_SEL_CHARS_BY_ACCOUNT_ID, CHAR_SEL_CHECK_GUID, CHAR_SEL_CHECK_NAME, CHAR_SEL_CORPSE_LOCATION, CHAR_SEL_CORPSES, CHAR_SEL_CREATURE_RESPAWNS, CHAR_SEL_DATA_BY_GUID, CHAR_SEL_DATA_BY_NAME, CHAR_SEL_ENUM, CHAR_SEL_ENUM_DECLINED_NAME, CHAR_SEL_EXPIRED_MAIL, CHAR_SEL_EXPIRED_MAIL_ITEMS, CHAR_SEL_FREE_NAME, CHAR_SEL_GM_TICKETS, CHAR_SEL_GO_RESPAWNS, CHAR_SEL_GUID_BY_NAME_FILTER, CHAR_SEL_GUILD_BANK_COUNT_ITEM, CHAR_SEL_GUILD_BANK_ITEM_BY_ENTRY, CHAR_SEL_GUILD_MEMBER_EXTENDED, CHAR_SEL_HAS_TUTORIALS, CHAR_SEL_HONORPOINTS, CHAR_SEL_ITEM_BOP_TRADE, CHAR_SEL_ITEM_REFUNDS, CHAR_SEL_ITEMCONTAINER_ITEMS, CHAR_SEL_MAIL, CHAR_SEL_MAIL_COUNT_ITEM, CHAR_SEL_MAIL_ITEMS_BY_ENTRY, CHAR_SEL_MAIL_SERVER_CHARACTER, CHAR_SEL_MAILITEMS, CHAR_SEL_MATCH_MAKER_RATING, CHAR_SEL_NEXT_MAIL_DELIVERYTIME, CHAR_SEL_PET_AURA, CHAR_SEL_PET_DECLINED_NAME, CHAR_SEL_PET_SPELL, CHAR_SEL_PET_SPELL_COOLDOWN, CHAR_SEL_PINFO_BANS, CHAR_SEL_PINFO_MAILS, CHAR_SEL_PINFO_XP, CHAR_SEL_PLAYER_ACCOUNT_DATA, CHAR_SEL_PLAYER_ARENA_TEAMS, CHAR_SEL_POOL_QUEST_SAVE, CHAR_SEL_PVPSTATS_BRACKET_MONTH, CHAR_SEL_PVPSTATS_FACTIONS_OVERALL, CHAR_SEL_PVPSTATS_MAXID, CHAR_SEL_RECOVERY_ITEM, CHAR_SEL_RECOVERY_ITEM_LIST, CHAR_SEL_SUM_CHARS, CHAR_SEL_TUTORIALS, CHAR_SELECT_INSTANCE_SAVED_DATA, CHAR_UDP_CHAR_ARENA_POINTS, CHAR_UDP_CHAR_ARENA_POINTS_ACCUMULATIVE, CHAR_UDP_CHAR_HONOR_POINTS, CHAR_UDP_CHAR_HONOR_POINTS_ACCUMULATIVE, CHAR_UDP_CHAR_MONEY, CHAR_UDP_CHAR_MONEY_ACCUMULATIVE, CHAR_UDP_CHAR_SKILLS, CHAR_UDP_RESTORE_DELETE_INFO, CHAR_UPD_ACCOUNT_ONLINE, CHAR_UPD_ADD_AT_LOGIN_FLAG, CHAR_UPD_ADD_CHARACTER_SOCIAL_FLAGS, CHAR_UPD_ALL_AT_LOGIN_FLAGS, CHAR_UPD_ARENA_TEAM_CAPTAIN, CHAR_UPD_ARENA_TEAM_MEMBER, CHAR_UPD_ARENA_TEAM_NAME, CHAR_UPD_ARENA_TEAM_STATS, CHAR_UPD_AUCTION_BID, CHAR_UPD_CHANNEL, CHAR_UPD_CHANNEL_USAGE, CHAR_UPD_CHAR_ACHIEVEMENT, CHAR_UPD_CHAR_ACTION, CHAR_UPD_CHAR_ARENA_POINTS, CHAR_UPD_CHAR_INSTANCE, CHAR_UPD_CHAR_INSTANCE_EXTENDED, CHAR_UPD_CHAR_INSTANCE_SET_NOT_EXTENDED, CHAR_UPD_CHAR_INVENTORY_FACTION_CHANGE, CHAR_UPD_CHAR_NAME_AT_LOGIN, CHAR_UPD_CHAR_ONLINE, CHAR_UPD_CHAR_PET_NAME, CHAR_UPD_CHAR_PET_SLOT_BY_ID, CHAR_UPD_CHAR_QUESTSTATUS_REWARDED_ACTIVE, CHAR_UPD_CHAR_QUESTSTATUS_REWARDED_ACTIVE_BY_QUEST, CHAR_UPD_CHAR_QUESTSTATUS_REWARDED_FACTION_CHANGE, CHAR_UPD_CHAR_RACE, CHAR_UPD_CHAR_REMOVE_GHOST, CHAR_UPD_CHAR_REP_FACTION_CHANGE, CHAR_UPD_CHAR_SPELL_FACTION_CHANGE, CHAR_UPD_CHAR_TAXI_PATH, CHAR_UPD_CHAR_TAXIMASK, CHAR_UPD_CHAR_TITLES_FACTION_CHANGE, CHAR_UPD_CHARACTER, CHAR_UPD_CHARACTER_BAN, CHAR_UPD_CHARACTER_POSITION, CHAR_UPD_CHARACTER_SOCIAL_NOTE, CHAR_UPD_DELETE_INFO, CHAR_UPD_EQUIP_SET, CHAR_UPD_GENDER_AND_APPEARANCE, CHAR_UPD_GIFT_OWNER, CHAR_UPD_GLOBAL_INSTANCE_RESETTIME, CHAR_UPD_GROUP_DIFFICULTY, CHAR_UPD_GROUP_LEADER, CHAR_UPD_GROUP_MEMBER_FLAG, CHAR_UPD_GROUP_MEMBER_SUBGROUP, CHAR_UPD_GROUP_RAID_DIFFICULTY, CHAR_UPD_GROUP_TYPE, CHAR_UPD_GUILD_BANK_EVENTLOG_TAB, CHAR_UPD_GUILD_BANK_MONEY, CHAR_UPD_GUILD_BANK_TAB_INFO, CHAR_UPD_GUILD_BANK_TAB_TEXT, CHAR_UPD_GUILD_EMBLEM_INFO, CHAR_UPD_GUILD_INFO, CHAR_UPD_GUILD_LEADER, CHAR_UPD_GUILD_MEMBER_OFFNOTE, CHAR_UPD_GUILD_MEMBER_PNOTE, CHAR_UPD_GUILD_MEMBER_RANK, CHAR_UPD_GUILD_MOTD, CHAR_UPD_GUILD_NAME, CHAR_UPD_GUILD_RANK_BANK_MONEY, CHAR_UPD_GUILD_RANK_NAME, CHAR_UPD_GUILD_RANK_RIGHTS, CHAR_UPD_INSTANCE_SAVE_DATA, CHAR_UPD_INSTANCE_SAVE_ENCOUNTERMASK, CHAR_UPD_ITEM_INSTANCE, CHAR_UPD_ITEM_INSTANCE_ON_LOAD, CHAR_UPD_ITEM_OWNER, CHAR_UPD_LEVEL, CHAR_UPD_MAIL, CHAR_UPD_MAIL_ITEM_RECEIVER, CHAR_UPD_MAIL_RETURNED, CHAR_UPD_NAME_BY_GUID, CHAR_UPD_PETITION_NAME, CHAR_UPD_PLAYER_GM_TICKETS_ON_CHAR_DELETION, CHAR_UPD_PLAYER_HOMEBIND, CHAR_UPD_QUEST_TRACK_ABANDON_TIME, CHAR_UPD_QUEST_TRACK_COMPLETE_TIME, CHAR_UPD_QUEST_TRACK_GM_COMPLETE, CHAR_UPD_REM_AT_LOGIN_FLAG, CHAR_UPD_REM_CHARACTER_SOCIAL_FLAGS, CHAR_UPD_TUTORIALS, CHAR_UPD_WORLDSTATE, CHAR_UPD_XP_ACCUMULATIVE, CHAR_UPD_ZONE, CHAR_UPDATE_INSTANCE_SAVED_DATA, CONNECTION_ASYNC, CONNECTION_BOTH, CONNECTION_SYNCH, MySQLConnection::m_reconnecting, MySQLConnection::m_stmts, MAX_CHARACTERDATABASE_STATEMENTS, and MySQLConnection::PrepareStatement().