TrinityCore
Loading...
Searching...
No Matches
Public Types | Public Member Functions | List of all members
CharacterDatabaseConnection Class Reference

#include <CharacterDatabase.h>

Public Types

typedef CharacterDatabaseStatements Statements
 

Public Member Functions

 CharacterDatabaseConnection (MySQLConnectionInfo &connInfo)
 
 CharacterDatabaseConnection (ProducerConsumerQueue< SQLOperation * > *q, MySQLConnectionInfo &connInfo)
 
 ~CharacterDatabaseConnection ()
 
void DoPrepareStatements () override
 
- Public Member Functions inherited from MySQLConnection
 MySQLConnection (MySQLConnectionInfo &connInfo)
 
 MySQLConnection (ProducerConsumerQueue< SQLOperation * > *queue, MySQLConnectionInfo &connInfo)
 Constructor for synchronous connections. More...
 
virtual ~MySQLConnection ()
 Constructor for asynchronous connections. More...
 
virtual uint32 Open ()
 
void Close ()
 
bool PrepareStatements ()
 
bool Execute (char const *sql)
 
bool Execute (PreparedStatementBase *stmt)
 
ResultSet * Query (char const *sql)
 
PreparedResultSet * Query (PreparedStatementBase *stmt)
 
bool _Query (char const *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. More...
 
uint32 GetServerVersion () const
 
MySQLPreparedStatement * GetPreparedStatement (uint32 index)
 
void PrepareStatement (uint32 index, std::string const &sql, ConnectionFlags flags)
 
virtual void DoPrepareStatements ()=0
 
- Protected Attributes inherited from MySQLConnection
PreparedStatementContainer m_stmts
 
bool m_reconnecting
 PreparedStatements storage. More...
 
bool m_prepareError
 Are we reconnecting? More...
 

Member Typedef Documentation

◆ Statements

typedef CharacterDatabaseStatements CharacterDatabaseConnection::Statements

Constructor & Destructor Documentation

◆ CharacterDatabaseConnection() [1/2]

CharacterDatabaseConnection::CharacterDatabaseConnection ( MySQLConnectionInfo &  connInfo)
782 : MySQLConnection(connInfo)
783{
784}
MySQLConnection
Definition: MySQLConnection.h:55

◆ CharacterDatabaseConnection() [2/2]

CharacterDatabaseConnection::CharacterDatabaseConnection ( ProducerConsumerQueue< SQLOperation * > *  q,
MySQLConnectionInfo &  connInfo 
)
786 : MySQLConnection(q, connInfo)
787{
788}

◆ ~CharacterDatabaseConnection()

CharacterDatabaseConnection::~CharacterDatabaseConnection ( )
791{
792}

Member Function Documentation

◆ DoPrepareStatements()

void CharacterDatabaseConnection::DoPrepareStatements ( )
overridevirtual

Implements MySQLConnection.

22{
23 if (!m_reconnecting)
24 m_stmts.resize(MAX_CHARACTERDATABASE_STATEMENTS);
25
26#define SelectItemInstanceContent "ii.guid, ii.itemEntry, ii.creatorGuid, ii.giftCreatorGuid, ii.count, ii.duration, ii.charges, ii.flags, ii.enchantments, ii.randomBonusListId, " \
27 "ii.durability, ii.playedTime, ii.text, ii.battlePetSpeciesId, ii.battlePetBreedData, ii.battlePetLevel, ii.battlePetDisplayId, ii.context, ii.bonusListIDs, " \
28 "iit.itemModifiedAppearanceAllSpecs, iit.itemModifiedAppearanceSpec1, iit.itemModifiedAppearanceSpec2, iit.itemModifiedAppearanceSpec3, iit.itemModifiedAppearanceSpec4, iit.itemModifiedAppearanceSpec5, " \
29 "iit.spellItemEnchantmentAllSpecs, iit.spellItemEnchantmentSpec1, iit.spellItemEnchantmentSpec2, iit.spellItemEnchantmentSpec3, iit.spellItemEnchantmentSpec4, iit.spellItemEnchantmentSpec5, " \
30 "iit.secondaryItemModifiedAppearanceAllSpecs, iit.secondaryItemModifiedAppearanceSpec1, iit.secondaryItemModifiedAppearanceSpec2, iit.secondaryItemModifiedAppearanceSpec3, iit.secondaryItemModifiedAppearanceSpec4, iit.itemModifiedAppearanceSpec5, " \
31 "ig.gemItemId1, ig.gemBonuses1, ig.gemContext1, ig.gemScalingLevel1, ig.gemItemId2, ig.gemBonuses2, ig.gemContext2, ig.gemScalingLevel2, ig.gemItemId3, ig.gemBonuses3, ig.gemContext3, ig.gemScalingLevel3, " \
32 "im.fixedScalingLevel, im.artifactKnowledgeLevel"
33
34 PrepareStatement(CHAR_DEL_POOL_QUEST_SAVE, "DELETE FROM pool_quest_save WHERE pool_id = ?", CONNECTION_ASYNC);
35 PrepareStatement(CHAR_INS_POOL_QUEST_SAVE, "INSERT INTO pool_quest_save (pool_id, quest_id) VALUES (?, ?)", CONNECTION_ASYNC);
36 PrepareStatement(CHAR_DEL_NONEXISTENT_GUILD_BANK_ITEM, "DELETE FROM guild_bank_item WHERE guildid = ? AND TabId = ? AND SlotId = ?", CONNECTION_ASYNC);
37 PrepareStatement(CHAR_DEL_EXPIRED_BANS, "UPDATE character_banned SET active = 0 WHERE unbandate <= UNIX_TIMESTAMP() AND unbandate <> bandate", CONNECTION_ASYNC);
38 PrepareStatement(CHAR_SEL_CHECK_NAME, "SELECT 1 FROM characters WHERE name = ?", CONNECTION_BOTH);
39 PrepareStatement(CHAR_SEL_CHECK_GUID, "SELECT 1 FROM characters WHERE guid = ?", CONNECTION_SYNCH);
40 PrepareStatement(CHAR_SEL_SUM_CHARS, "SELECT COUNT(guid) FROM characters WHERE account = ? AND deleteDate IS NULL", CONNECTION_BOTH);
41 PrepareStatement(CHAR_SEL_CHAR_CREATE_INFO, "SELECT level, race, class FROM characters WHERE account = ? LIMIT 0, ?", CONNECTION_ASYNC);
42 PrepareStatement(CHAR_INS_CHARACTER_BAN, "INSERT INTO character_banned (guid, bandate, unbandate, bannedby, banreason, active) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?, 1)", CONNECTION_ASYNC);
43 PrepareStatement(CHAR_UPD_CHARACTER_BAN, "UPDATE character_banned SET active = 0 WHERE guid = ? AND active != 0", CONNECTION_ASYNC);
44 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);
45 PrepareStatement(CHAR_SEL_BANINFO, "SELECT bandate, unbandate-bandate, active, unbandate, banreason, bannedby FROM character_banned WHERE guid = ? ORDER BY bandate ASC", CONNECTION_SYNCH);
46 PrepareStatement(CHAR_SEL_GUID_BY_NAME_FILTER, "SELECT guid, name FROM characters WHERE name LIKE CONCAT('%%', ?, '%%')", CONNECTION_SYNCH);
47 PrepareStatement(CHAR_SEL_BANINFO_LIST, "SELECT bandate, unbandate, bannedby, banreason FROM character_banned WHERE guid = ? ORDER BY unbandate", CONNECTION_SYNCH);
48 PrepareStatement(CHAR_SEL_BANNED_NAME, "SELECT characters.name FROM characters, character_banned WHERE character_banned.guid = ? AND character_banned.guid = characters.guid", CONNECTION_SYNCH);
49 PrepareStatement(CHAR_SEL_MAIL_LIST_COUNT, "SELECT COUNT(id) FROM mail WHERE receiver = ? ", CONNECTION_SYNCH);
50 PrepareStatement(CHAR_SEL_MAIL_LIST_INFO, "SELECT id, sender, (SELECT name FROM characters WHERE guid = sender) AS sendername, receiver, (SELECT name FROM characters WHERE guid = receiver) AS receivername, "
51 "subject, deliver_time, expire_time, money, has_items FROM mail WHERE receiver = ? ", CONNECTION_SYNCH);
52 PrepareStatement(CHAR_SEL_MAIL_LIST_ITEMS, "SELECT itemEntry,count FROM item_instance WHERE guid = ?", CONNECTION_SYNCH);
53 PrepareStatement(CHAR_SEL_ENUM, "SELECT c.guid, c.name, c.race, c.class, c.gender, c.level, c.zone, c.map, c.position_x, c.position_y, c.position_z, "
54 "gm.guildid, c.playerFlags, c.at_login, cp.entry, cp.modelid, cp.level, c.equipmentCache, cb.guid, c.slot, c.logout_time, c.activeTalentGroup, c.lastLoginBuild "
55 "FROM characters AS c LEFT JOIN character_pet AS cp ON c.summonedPetNumber = cp.id LEFT JOIN guild_member AS gm ON c.guid = gm.guid "
56 "LEFT JOIN character_banned AS cb ON c.guid = cb.guid AND cb.active = 1 WHERE c.account = ? AND c.deleteInfos_Name IS NULL", CONNECTION_ASYNC);
57 PrepareStatement(CHAR_SEL_ENUM_DECLINED_NAME, "SELECT c.guid, c.name, c.race, c.class, c.gender, c.level, c.zone, c.map, "
58 "c.position_x, c.position_y, c.position_z, gm.guildid, c.playerFlags, c.at_login, cp.entry, cp.modelid, cp.level, c.equipmentCache, "
59 "cb.guid, c.slot, c.logout_time, c.activeTalentGroup, c.lastLoginBuild, cd.genitive FROM characters AS c LEFT JOIN character_pet AS cp ON c.summonedPetNumber = cp.id "
60 "LEFT JOIN character_declinedname AS cd ON c.guid = cd.guid LEFT JOIN guild_member AS gm ON c.guid = gm.guid "
61 "LEFT JOIN character_banned AS cb ON c.guid = cb.guid AND cb.active = 1 WHERE c.account = ? AND c.deleteInfos_Name IS NULL", CONNECTION_ASYNC);
62 PrepareStatement(CHAR_SEL_ENUM_CUSTOMIZATIONS, "SELECT cc.guid, cc.chrCustomizationOptionID, cc.chrCustomizationChoiceID FROM character_customizations cc "
63 "LEFT JOIN characters c ON cc.guid = c.guid WHERE c.account = ? AND c.deleteInfos_Name IS NULL ORDER BY cc.guid, cc.chrCustomizationOptionID", CONNECTION_ASYNC);
64 PrepareStatement(CHAR_SEL_UNDELETE_ENUM, "SELECT c.guid, c.deleteInfos_Name, c.race, c.class, c.gender, c.level, c.zone, c.map, c.position_x, c.position_y, c.position_z, "
65 "gm.guildid, c.playerFlags, c.at_login, cp.entry, cp.modelid, cp.level, c.equipmentCache, cb.guid, c.slot, c.logout_time, c.activeTalentGroup, c.lastLoginBuild "
66 "FROM characters AS c LEFT JOIN character_pet AS cp ON c.summonedPetNumber = cp.id LEFT JOIN guild_member AS gm ON c.guid = gm.guid "
67 "LEFT JOIN character_banned AS cb ON c.guid = cb.guid AND cb.active = 1 WHERE c.deleteInfos_Account = ? AND c.deleteInfos_Name IS NOT NULL", CONNECTION_ASYNC);
68 PrepareStatement(CHAR_SEL_UNDELETE_ENUM_DECLINED_NAME, "SELECT c.guid, c.deleteInfos_Name, c.race, c.class, c.gender, c.level, c.zone, c.map, "
69 "c.position_x, c.position_y, c.position_z, gm.guildid, c.playerFlags, c.at_login, cp.entry, cp.modelid, cp.level, c.equipmentCache, "
70 "cb.guid, c.slot, c.logout_time, c.activeTalentGroup, c.lastLoginBuild, cd.genitive FROM characters AS c LEFT JOIN character_pet AS cp ON c.summonedPetNumber = cp.id "
71 "LEFT JOIN character_declinedname AS cd ON c.guid = cd.guid LEFT JOIN guild_member AS gm ON c.guid = gm.guid "
72 "LEFT JOIN character_banned AS cb ON c.guid = cb.guid AND cb.active = 1 WHERE c.deleteInfos_Account = ? AND c.deleteInfos_Name IS NOT NULL", CONNECTION_ASYNC);
73 PrepareStatement(CHAR_SEL_UNDELETE_ENUM_CUSTOMIZATIONS, "SELECT cc.guid, cc.chrCustomizationOptionID, cc.chrCustomizationChoiceID FROM character_customizations cc "
74 "LEFT JOIN characters c ON cc.guid = c.guid WHERE c.deleteInfos_Account = ? AND c.deleteInfos_Name IS NOT NULL ORDER BY cc.guid, cc.chrCustomizationOptionID", CONNECTION_ASYNC);
75
76 PrepareStatement(CHAR_SEL_FREE_NAME, "SELECT name, at_login FROM characters WHERE guid = ? AND NOT EXISTS (SELECT NULL FROM characters WHERE name = ?)", CONNECTION_ASYNC);
77 PrepareStatement(CHAR_SEL_CHAR_ZONE, "SELECT zone FROM characters WHERE guid = ?", CONNECTION_SYNCH);
78 PrepareStatement(CHAR_SEL_CHAR_POSITION_XYZ, "SELECT map, position_x, position_y, position_z FROM characters WHERE guid = ?", CONNECTION_SYNCH);
79 PrepareStatement(CHAR_SEL_CHAR_POSITION, "SELECT position_x, position_y, position_z, orientation, map, taxi_path FROM characters WHERE guid = ?", CONNECTION_SYNCH);
80
81 PrepareStatement(CHAR_DEL_BATTLEGROUND_RANDOM_ALL, "DELETE FROM character_battleground_random", CONNECTION_ASYNC);
82 PrepareStatement(CHAR_DEL_BATTLEGROUND_RANDOM, "DELETE FROM character_battleground_random WHERE guid = ?", CONNECTION_ASYNC);
83 PrepareStatement(CHAR_INS_BATTLEGROUND_RANDOM, "INSERT INTO character_battleground_random (guid) VALUES (?)", CONNECTION_ASYNC);
84
85 PrepareStatement(CHAR_SEL_CHARACTER, "SELECT c.guid, account, name, race, class, gender, level, xp, money, inventorySlots, bankSlots, restState, playerFlags, playerFlagsEx, "
86 "position_x, position_y, position_z, map, orientation, taximask, createTime, createMode, cinematic, totaltime, leveltime, rest_bonus, logout_time, is_logout_resting, resettalents_cost, "
87 "resettalents_time, primarySpecialization, trans_x, trans_y, trans_z, trans_o, transguid, extra_flags, summonedPetNumber, at_login, zone, online, death_expire_time, taxi_path, dungeonDifficulty, "
88 "totalKills, todayKills, yesterdayKills, chosenTitle, watchedFaction, drunk, "
89 "health, power1, power2, power3, power4, power5, power6, power7, instance_id, activeTalentGroup, lootSpecId, exploredZones, knownTitles, actionBars, raidDifficulty, legacyRaidDifficulty, fishingSteps, "
90 "honor, honorLevel, honorRestState, honorRestBonus, numRespecs "
91 "FROM characters c LEFT JOIN character_fishingsteps cfs ON c.guid = cfs.guid WHERE c.guid = ?", CONNECTION_ASYNC);
92
93 PrepareStatement(CHAR_SEL_CHARACTER_CUSTOMIZATIONS, "SELECT chrCustomizationOptionID, chrCustomizationChoiceID FROM character_customizations WHERE guid = ? ORDER BY chrCustomizationOptionID", CONNECTION_ASYNC);
94 PrepareStatement(CHAR_SEL_GROUP_MEMBER, "SELECT guid FROM group_member WHERE memberGuid = ?", CONNECTION_BOTH);
95 PrepareStatement(CHAR_SEL_CHARACTER_AURAS, "SELECT casterGuid, itemGuid, spell, effectMask, recalculateMask, difficulty, stackCount, maxDuration, remainTime, remainCharges, castItemId, castItemLevel FROM character_aura WHERE guid = ?", CONNECTION_ASYNC);
96 PrepareStatement(CHAR_SEL_CHARACTER_AURA_EFFECTS, "SELECT casterGuid, itemGuid, spell, effectMask, effectIndex, amount, baseAmount FROM character_aura_effect WHERE guid = ?", CONNECTION_ASYNC);
97 PrepareStatement(CHAR_SEL_CHARACTER_SPELL, "SELECT spell, active, disabled FROM character_spell WHERE guid = ?", CONNECTION_ASYNC);
98 PrepareStatement(CHAR_SEL_CHARACTER_SPELL_FAVORITES, "SELECT spell FROM character_spell_favorite WHERE guid = ?", CONNECTION_ASYNC);
99 PrepareStatement(CHAR_SEL_CHARACTER_QUESTSTATUS, "SELECT quest, status, explored, acceptTime, endTime FROM character_queststatus WHERE guid = ? AND status <> 0", CONNECTION_ASYNC);
100 PrepareStatement(CHAR_SEL_CHARACTER_QUESTSTATUS_OBJECTIVES, "SELECT quest, objective, data FROM character_queststatus_objectives WHERE guid = ?", CONNECTION_ASYNC);
101 PrepareStatement(CHAR_SEL_CHARACTER_QUESTSTATUS_OBJECTIVES_CRITERIA, "SELECT questObjectiveId FROM character_queststatus_objectives_criteria WHERE guid = ?", CONNECTION_ASYNC);
102 PrepareStatement(CHAR_SEL_CHARACTER_QUESTSTATUS_OBJECTIVES_CRITERIA_PROGRESS, "SELECT criteriaId, counter, date FROM character_queststatus_objectives_criteria_progress WHERE guid = ?", CONNECTION_ASYNC);
103
104 PrepareStatement(CHAR_SEL_CHARACTER_QUESTSTATUS_DAILY, "SELECT quest, time FROM character_queststatus_daily WHERE guid = ?", CONNECTION_ASYNC);
105 PrepareStatement(CHAR_SEL_CHARACTER_QUESTSTATUS_WEEKLY, "SELECT quest FROM character_queststatus_weekly WHERE guid = ?", CONNECTION_ASYNC);
106 PrepareStatement(CHAR_SEL_CHARACTER_QUESTSTATUS_MONTHLY, "SELECT quest FROM character_queststatus_monthly WHERE guid = ?", CONNECTION_ASYNC);
107 PrepareStatement(CHAR_SEL_CHARACTER_QUESTSTATUS_SEASONAL, "SELECT quest, event, completedTime FROM character_queststatus_seasonal WHERE guid = ?", CONNECTION_ASYNC);
108 PrepareStatement(CHAR_DEL_CHARACTER_QUESTSTATUS_DAILY, "DELETE FROM character_queststatus_daily WHERE guid = ?", CONNECTION_ASYNC);
109 PrepareStatement(CHAR_DEL_CHARACTER_QUESTSTATUS_WEEKLY, "DELETE FROM character_queststatus_weekly WHERE guid = ?", CONNECTION_ASYNC);
110 PrepareStatement(CHAR_DEL_CHARACTER_QUESTSTATUS_MONTHLY, "DELETE FROM character_queststatus_monthly WHERE guid = ?", CONNECTION_ASYNC);
111 PrepareStatement(CHAR_DEL_CHARACTER_QUESTSTATUS_SEASONAL, "DELETE FROM character_queststatus_seasonal WHERE guid = ?", CONNECTION_ASYNC);
112 PrepareStatement(CHAR_INS_CHARACTER_QUESTSTATUS_DAILY, "INSERT INTO character_queststatus_daily (guid, quest, time) VALUES (?, ?, ?)", CONNECTION_ASYNC);
113 PrepareStatement(CHAR_INS_CHARACTER_QUESTSTATUS_WEEKLY, "INSERT INTO character_queststatus_weekly (guid, quest) VALUES (?, ?)", CONNECTION_ASYNC);
114 PrepareStatement(CHAR_INS_CHARACTER_QUESTSTATUS_MONTHLY, "INSERT INTO character_queststatus_monthly (guid, quest) VALUES (?, ?)", CONNECTION_ASYNC);
115 PrepareStatement(CHAR_INS_CHARACTER_QUESTSTATUS_SEASONAL, "INSERT INTO character_queststatus_seasonal (guid, quest, event, completedTime) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
116 PrepareStatement(CHAR_DEL_RESET_CHARACTER_QUESTSTATUS_DAILY, "DELETE FROM character_queststatus_daily", CONNECTION_ASYNC);
117 PrepareStatement(CHAR_DEL_RESET_CHARACTER_QUESTSTATUS_WEEKLY, "DELETE FROM character_queststatus_weekly", CONNECTION_ASYNC);
118 PrepareStatement(CHAR_DEL_RESET_CHARACTER_QUESTSTATUS_MONTHLY, "DELETE FROM character_queststatus_monthly", CONNECTION_ASYNC);
119 PrepareStatement(CHAR_DEL_RESET_CHARACTER_QUESTSTATUS_SEASONAL_BY_EVENT, "DELETE FROM character_queststatus_seasonal WHERE event = ? AND completedTime < ?", CONNECTION_ASYNC);
120
121 PrepareStatement(CHAR_SEL_CHARACTER_REPUTATION, "SELECT faction, standing, flags FROM character_reputation WHERE guid = ?", CONNECTION_ASYNC);
122 PrepareStatement(CHAR_SEL_CHARACTER_INVENTORY, "SELECT " SelectItemInstanceContent ", bag, slot FROM character_inventory ci JOIN item_instance ii ON ci.item = ii.guid LEFT JOIN item_instance_gems ig ON ii.guid = ig.itemGuid LEFT JOIN item_instance_transmog iit ON ii.guid = iit.itemGuid LEFT JOIN item_instance_modifiers im ON ii.guid = im.itemGuid WHERE ci.guid = ? ORDER BY (ii.flags & 0x80000) ASC, bag ASC, slot ASC", CONNECTION_ASYNC);
123 PrepareStatement(CHAR_SEL_MAIL_COUNT, "SELECT COUNT(*) FROM mail WHERE receiver = ?", CONNECTION_ASYNC);
124 PrepareStatement(CHAR_SEL_CHARACTER_SOCIALLIST, "SELECT cs.friend, c.account, cs.flags, cs.note FROM character_social cs JOIN characters c ON c.guid = cs.friend WHERE cs.guid = ? AND c.deleteinfos_name IS NULL LIMIT 255", CONNECTION_ASYNC);
125 PrepareStatement(CHAR_SEL_CHARACTER_HOMEBIND, "SELECT mapId, zoneId, posX, posY, posZ, orientation FROM character_homebind WHERE guid = ?", CONNECTION_ASYNC);
126 PrepareStatement(CHAR_SEL_CHARACTER_SPELLCOOLDOWNS, "SELECT spell, item, time, categoryId, categoryEnd FROM character_spell_cooldown WHERE guid = ? AND time > UNIX_TIMESTAMP()", CONNECTION_ASYNC);
127 PrepareStatement(CHAR_SEL_CHARACTER_SPELL_CHARGES, "SELECT categoryId, rechargeStart, rechargeEnd FROM character_spell_charges WHERE guid = ? AND rechargeEnd > UNIX_TIMESTAMP() ORDER BY rechargeEnd", CONNECTION_ASYNC);
128 PrepareStatement(CHAR_SEL_CHARACTER_DECLINEDNAMES, "SELECT genitive, dative, accusative, instrumental, prepositional FROM character_declinedname WHERE guid = ?", CONNECTION_ASYNC);
129 PrepareStatement(CHAR_SEL_GUILD_MEMBER, "SELECT guildid, `rank` FROM guild_member WHERE guid = ?", CONNECTION_BOTH);
130 PrepareStatement(CHAR_SEL_GUILD_MEMBER_EXTENDED, "SELECT g.guildid, g.name, gr.rname, gr.rid, gm.pnote, gm.offnote "
131 "FROM guild g JOIN guild_member gm ON g.guildid = gm.guildid "
132 "JOIN guild_rank gr ON g.guildid = gr.guildid AND gm.`rank` = gr.rid WHERE gm.guid = ?", CONNECTION_BOTH);
133 PrepareStatement(CHAR_SEL_CHARACTER_ACHIEVEMENTS, "SELECT achievement, date FROM character_achievement WHERE guid = ?", CONNECTION_ASYNC);
134 PrepareStatement(CHAR_SEL_CHARACTER_CRITERIAPROGRESS, "SELECT criteria, counter, date FROM character_achievement_progress WHERE guid = ?", CONNECTION_ASYNC);
135 PrepareStatement(CHAR_SEL_CHARACTER_EQUIPMENTSETS, "SELECT setguid, setindex, name, iconname, ignore_mask, AssignedSpecIndex, item0, item1, item2, item3, item4, item5, item6, item7, item8, "
136 "item9, item10, item11, item12, item13, item14, item15, item16, item17, item18 FROM character_equipmentsets WHERE guid = ? ORDER BY setindex", CONNECTION_ASYNC);
137 PrepareStatement(CHAR_SEL_CHARACTER_TRANSMOG_OUTFITS, "SELECT setguid, setindex, name, iconname, ignore_mask, appearance0, appearance1, appearance2, appearance3, appearance4, "
138 "appearance5, appearance6, appearance7, appearance8, appearance9, appearance10, appearance11, appearance12, appearance13, appearance14, appearance15, appearance16, "
139 "appearance17, appearance18, mainHandEnchant, offHandEnchant FROM character_transmog_outfits WHERE guid = ? ORDER BY setindex", CONNECTION_ASYNC);
140 PrepareStatement(CHAR_SEL_CHARACTER_BGDATA, "SELECT instanceId, team, joinX, joinY, joinZ, joinO, joinMapId, taxiStart, taxiEnd, mountSpell FROM character_battleground_data WHERE guid = ?", CONNECTION_ASYNC);
141 PrepareStatement(CHAR_SEL_CHARACTER_GLYPHS, "SELECT talentGroup, glyphId FROM character_glyphs WHERE guid = ?", CONNECTION_ASYNC);
142 PrepareStatement(CHAR_SEL_CHARACTER_TALENTS, "SELECT talentId, talentGroup FROM character_talent WHERE guid = ?", CONNECTION_ASYNC);
143 PrepareStatement(CHAR_SEL_CHARACTER_PVP_TALENTS, "SELECT talentId0, talentId1, talentId2, talentId3, talentGroup FROM character_pvp_talent WHERE guid = ?", CONNECTION_ASYNC);
144 PrepareStatement(CHAR_SEL_CHARACTER_SKILLS, "SELECT skill, value, max, professionSlot FROM character_skills WHERE guid = ?", CONNECTION_ASYNC);
145 PrepareStatement(CHAR_SEL_CHARACTER_RANDOMBG, "SELECT guid FROM character_battleground_random WHERE guid = ?", CONNECTION_ASYNC);
146 PrepareStatement(CHAR_SEL_CHARACTER_BANNED, "SELECT guid FROM character_banned WHERE guid = ? AND active = 1", CONNECTION_ASYNC);
147 PrepareStatement(CHAR_SEL_CHARACTER_QUESTSTATUSREW, "SELECT quest FROM character_queststatus_rewarded WHERE guid = ? AND active = 1", CONNECTION_ASYNC);
148 PrepareStatement(CHAR_SEL_CHARACTER_FAVORITE_AUCTIONS, "SELECT `order`, itemId, itemLevel, battlePetSpeciesId, suffixItemNameDescriptionId FROM character_favorite_auctions WHERE guid = ? ORDER BY `order`", CONNECTION_ASYNC);
149 PrepareStatement(CHAR_INS_CHARACTER_FAVORITE_AUCTION, "INSERT INTO character_favorite_auctions (guid, `order`, itemId, itemLevel, battlePetSpeciesId, suffixItemNameDescriptionId) VALUE (?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
150 PrepareStatement(CHAR_DEL_CHARACTER_FAVORITE_AUCTION, "DELETE FROM character_favorite_auctions WHERE guid = ? AND `order` = ?", CONNECTION_ASYNC);
151 PrepareStatement(CHAR_DEL_CHARACTER_FAVORITE_AUCTIONS_BY_CHAR, "DELETE FROM character_favorite_auctions WHERE guid = ?", CONNECTION_ASYNC);
152 PrepareStatement(CHAR_SEL_ACCOUNT_INSTANCELOCKTIMES, "SELECT instanceId, releaseTime FROM account_instance_times WHERE accountId = ?", CONNECTION_ASYNC);
153
154 PrepareStatement(CHAR_SEL_CHARACTER_ACTIONS_SPEC, "SELECT button, action, type FROM character_action WHERE guid = ? AND spec = ? AND traitConfigId = ? ORDER BY button", CONNECTION_ASYNC);
155 PrepareStatement(CHAR_SEL_MAILITEMS, "SELECT " SelectItemInstanceContent ", 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 LEFT JOIN item_instance_gems ig ON ii.guid = ig.itemGuid LEFT JOIN item_instance_transmog iit ON ii.guid = iit.itemGuid LEFT JOIN item_instance_modifiers im ON ii.guid = im.itemGuid WHERE m.receiver = ?", CONNECTION_BOTH);
156 PrepareStatement(CHAR_SEL_MAILITEMS_ARTIFACT, "SELECT a.itemGuid, a.xp, a.artifactAppearanceId, a.artifactTierId, ap.artifactPowerId, ap.purchasedRank FROM item_instance_artifact_powers ap LEFT JOIN item_instance_artifact a ON ap.itemGuid = a.itemGuid INNER JOIN mail_items mi ON a.itemGuid = mi.item_guid INNER JOIN mail m ON mi.mail_id = m.id WHERE m.receiver = ?", CONNECTION_BOTH);
157 PrepareStatement(CHAR_SEL_MAILITEMS_AZERITE, "SELECT iz.itemGuid, iz.xp, iz.level, iz.knowledgeLevel, "
158 "iz.selectedAzeriteEssences1specId, iz.selectedAzeriteEssences1azeriteEssenceId1, iz.selectedAzeriteEssences1azeriteEssenceId2, iz.selectedAzeriteEssences1azeriteEssenceId3, iz.selectedAzeriteEssences1azeriteEssenceId4, "
159 "iz.selectedAzeriteEssences2specId, iz.selectedAzeriteEssences2azeriteEssenceId1, iz.selectedAzeriteEssences2azeriteEssenceId2, iz.selectedAzeriteEssences2azeriteEssenceId3, iz.selectedAzeriteEssences2azeriteEssenceId4, "
160 "iz.selectedAzeriteEssences3specId, iz.selectedAzeriteEssences3azeriteEssenceId1, iz.selectedAzeriteEssences3azeriteEssenceId2, iz.selectedAzeriteEssences3azeriteEssenceId3, iz.selectedAzeriteEssences3azeriteEssenceId4, "
161 "iz.selectedAzeriteEssences4specId, iz.selectedAzeriteEssences4azeriteEssenceId1, iz.selectedAzeriteEssences4azeriteEssenceId2, iz.selectedAzeriteEssences4azeriteEssenceId3, iz.selectedAzeriteEssences4azeriteEssenceId4 "
162 "FROM item_instance_azerite iz INNER JOIN mail_items mi ON iz.itemGuid = mi.item_guid INNER JOIN mail m ON mi.mail_id = m.id WHERE m.receiver = ?", CONNECTION_BOTH);
163 PrepareStatement(CHAR_SEL_MAILITEMS_AZERITE_MILESTONE_POWER, "SELECT iamp.itemGuid, iamp.azeriteItemMilestonePowerId FROM item_instance_azerite_milestone_power iamp INNER JOIN mail_items mi ON iamp.itemGuid = mi.item_guid INNER JOIN mail m ON mi.mail_id = m.id WHERE m.receiver = ?", CONNECTION_BOTH);
164 PrepareStatement(CHAR_SEL_MAILITEMS_AZERITE_UNLOCKED_ESSENCE, "SELECT iaue.itemGuid, iaue.azeriteEssenceId, iaue.`rank` FROM item_instance_azerite_unlocked_essence iaue INNER JOIN mail_items mi ON iaue.itemGuid = mi.item_guid INNER JOIN mail m ON mi.mail_id = m.id WHERE m.receiver = ?", CONNECTION_BOTH);
165 PrepareStatement(CHAR_SEL_MAILITEMS_AZERITE_EMPOWERED, "SELECT iae.itemGuid, iae.azeritePowerId1, iae.azeritePowerId2, iae.azeritePowerId3, iae.azeritePowerId4, iae.azeritePowerId5 FROM item_instance_azerite_empowered iae INNER JOIN mail_items mi ON iae.itemGuid = mi.item_guid INNER JOIN mail m ON mi.mail_id = m.id WHERE m.receiver = ?", CONNECTION_BOTH);
166 PrepareStatement(CHAR_SEL_AUCTION_ITEMS, "SELECT " SelectItemInstanceContent ", ii.owner_guid, ai.auctionId FROM auction_items ai INNER JOIN item_instance ii ON ai.itemGuid = ii.guid LEFT JOIN item_instance_gems ig ON ii.guid = ig.itemGuid LEFT JOIN item_instance_transmog iit ON ii.guid = iit.itemGuid LEFT JOIN item_instance_modifiers im ON ii.guid = im.itemGuid", CONNECTION_SYNCH);
167 PrepareStatement(CHAR_SEL_AUCTIONS, "SELECT id, auctionHouseId, owner, bidder, minBid, buyoutOrUnitPrice, deposit, bidAmount, startTime, endTime, serverFlags FROM auctionhouse", CONNECTION_SYNCH);
168 PrepareStatement(CHAR_INS_AUCTION_ITEMS, "INSERT INTO auction_items (auctionId, itemGuid) VALUES (?, ?)", CONNECTION_ASYNC);
169 PrepareStatement(CHAR_DEL_AUCTION_ITEMS_BY_ITEM, "DELETE FROM auction_items WHERE itemGuid = ?", CONNECTION_ASYNC);
170 PrepareStatement(CHAR_SEL_AUCTION_BIDDERS, "SELECT auctionId, playerGuid FROM auction_bidders", CONNECTION_SYNCH);
171 PrepareStatement(CHAR_INS_AUCTION_BIDDER, "INSERT INTO auction_bidders (auctionId, playerGuid) VALUES (?, ?)", CONNECTION_ASYNC);
172 PrepareStatement(CHAR_DEL_AUCTION_BIDDER_BY_PLAYER, "DELETE FROM auction_bidders WHERE playerGuid = ?", CONNECTION_ASYNC);
173 PrepareStatement(CHAR_INS_AUCTION, "INSERT INTO auctionhouse (id, auctionHouseId, owner, bidder, minBid, buyoutOrUnitPrice, deposit, bidAmount, startTime, endTime, serverFlags) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
174 PrepareStatement(CHAR_DEL_AUCTION, "DELETE a, ab, ai FROM auctionhouse a LEFT JOIN auction_items ai ON a.id = ai.auctionId LEFT JOIN auction_bidders ab ON a.id = ab.auctionId WHERE a.id = ?", CONNECTION_ASYNC);
175 PrepareStatement(CHAR_UPD_AUCTION_BID, "UPDATE auctionhouse SET bidder = ?, bidAmount = ?, serverFlags = ? WHERE id = ?", CONNECTION_ASYNC);
176 PrepareStatement(CHAR_UPD_AUCTION_EXPIRATION, "UPDATE auctionhouse SET endTime = ? WHERE id = ?", CONNECTION_SYNCH);
177 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);
178 PrepareStatement(CHAR_DEL_MAIL_BY_ID, "DELETE FROM mail WHERE id = ?", CONNECTION_ASYNC);
179 PrepareStatement(CHAR_INS_MAIL_ITEM, "INSERT INTO mail_items(mail_id, item_guid, receiver) VALUES (?, ?, ?)", CONNECTION_ASYNC);
180 PrepareStatement(CHAR_DEL_MAIL_ITEM, "DELETE FROM mail_items WHERE item_guid = ?", CONNECTION_ASYNC);
181 PrepareStatement(CHAR_DEL_INVALID_MAIL_ITEM, "DELETE FROM mail_items WHERE item_guid = ?", CONNECTION_ASYNC);
182 PrepareStatement(CHAR_DEL_EMPTY_EXPIRED_MAIL, "DELETE FROM mail WHERE expire_time < ? AND has_items = 0 AND body = ''", CONNECTION_ASYNC);
183 PrepareStatement(CHAR_SEL_EXPIRED_MAIL, "SELECT id, messageType, sender, receiver, has_items, expire_time, cod, checked, mailTemplateId FROM mail WHERE expire_time < ?", CONNECTION_SYNCH);
184 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);
185 PrepareStatement(CHAR_UPD_MAIL_RETURNED, "UPDATE mail SET sender = ?, receiver = ?, expire_time = ?, deliver_time = ?, cod = 0, checked = ? WHERE id = ?", CONNECTION_ASYNC);
186 PrepareStatement(CHAR_UPD_MAIL_ITEM_RECEIVER, "UPDATE mail_items SET receiver = ? WHERE item_guid = ?", CONNECTION_ASYNC);
187 PrepareStatement(CHAR_UPD_ITEM_OWNER, "UPDATE item_instance SET owner_guid = ? WHERE guid = ?", CONNECTION_ASYNC);
188
189 PrepareStatement(CHAR_SEL_ITEM_REFUNDS, "SELECT paidMoney, paidExtendedCost FROM item_refund_instance WHERE item_guid = ? AND player_guid = ? LIMIT 1", CONNECTION_SYNCH);
190 PrepareStatement(CHAR_SEL_ITEM_BOP_TRADE, "SELECT allowedPlayers FROM item_soulbound_trade_data WHERE itemGuid = ? LIMIT 1", CONNECTION_SYNCH);
191 PrepareStatement(CHAR_DEL_ITEM_BOP_TRADE, "DELETE FROM item_soulbound_trade_data WHERE itemGuid = ? LIMIT 1", CONNECTION_ASYNC);
192 PrepareStatement(CHAR_INS_ITEM_BOP_TRADE, "INSERT INTO item_soulbound_trade_data VALUES (?, ?)", CONNECTION_ASYNC);
193 PrepareStatement(CHAR_REP_INVENTORY_ITEM, "REPLACE INTO character_inventory (guid, bag, slot, item) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
194 PrepareStatement(CHAR_REP_ITEM_INSTANCE, "REPLACE INTO item_instance (itemEntry, owner_guid, creatorGuid, giftCreatorGuid, count, duration, charges, flags, enchantments, randomBonusListId, durability, playedTime, text, battlePetSpeciesId, battlePetBreedData, battlePetLevel, battlePetDisplayId, context, bonusListIDs, guid) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
195 PrepareStatement(CHAR_UPD_ITEM_INSTANCE, "UPDATE item_instance SET itemEntry = ?, owner_guid = ?, creatorGuid = ?, giftCreatorGuid = ?, count = ?, duration = ?, charges = ?, flags = ?, enchantments = ?, randomBonusListId = ?, durability = ?, playedTime = ?, text = ?, battlePetSpeciesId = ?, battlePetBreedData = ?, battlePetLevel = ?, battlePetDisplayId = ?, context = ?, bonusListIDs = ? WHERE guid = ?", CONNECTION_ASYNC);
196 PrepareStatement(CHAR_UPD_ITEM_INSTANCE_ON_LOAD, "UPDATE item_instance SET duration = ?, flags = ?, durability = ? WHERE guid = ?", CONNECTION_ASYNC);
197 PrepareStatement(CHAR_DEL_ITEM_INSTANCE, "DELETE FROM item_instance WHERE guid = ?", CONNECTION_ASYNC);
198 PrepareStatement(CHAR_DEL_ITEM_INSTANCE_BY_OWNER, "DELETE FROM item_instance WHERE owner_guid = ?", CONNECTION_ASYNC);
199 PrepareStatement(CHAR_INS_ITEM_INSTANCE_GEMS, "INSERT INTO item_instance_gems (itemGuid, gemItemId1, gemBonuses1, gemContext1, gemScalingLevel1, gemItemId2, gemBonuses2, gemContext2, gemScalingLevel2, gemItemId3, gemBonuses3, gemContext3, gemScalingLevel3) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
200 PrepareStatement(CHAR_DEL_ITEM_INSTANCE_GEMS, "DELETE FROM item_instance_gems WHERE itemGuid = ?", CONNECTION_ASYNC);
201 PrepareStatement(CHAR_DEL_ITEM_INSTANCE_GEMS_BY_OWNER, "DELETE iig FROM item_instance_gems iig LEFT JOIN item_instance ii ON iig.itemGuid = ii.guid WHERE ii.owner_guid = ?", CONNECTION_ASYNC);
202 PrepareStatement(CHAR_INS_ITEM_INSTANCE_TRANSMOG, "INSERT INTO item_instance_transmog (itemGuid, itemModifiedAppearanceAllSpecs, itemModifiedAppearanceSpec1, itemModifiedAppearanceSpec2, itemModifiedAppearanceSpec3, itemModifiedAppearanceSpec4, itemModifiedAppearanceSpec5, "
203 "spellItemEnchantmentAllSpecs, spellItemEnchantmentSpec1, spellItemEnchantmentSpec2, spellItemEnchantmentSpec3, spellItemEnchantmentSpec4, spellItemEnchantmentSpec5, "
204 "secondaryItemModifiedAppearanceAllSpecs, secondaryItemModifiedAppearanceSpec1, secondaryItemModifiedAppearanceSpec2, secondaryItemModifiedAppearanceSpec3, secondaryItemModifiedAppearanceSpec4, secondaryItemModifiedAppearanceSpec5) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
205 PrepareStatement(CHAR_DEL_ITEM_INSTANCE_TRANSMOG, "DELETE FROM item_instance_transmog WHERE itemGuid = ?", CONNECTION_ASYNC);
206 PrepareStatement(CHAR_DEL_ITEM_INSTANCE_TRANSMOG_BY_OWNER, "DELETE iit FROM item_instance_transmog iit LEFT JOIN item_instance ii ON iit.itemGuid = ii.guid WHERE ii.owner_guid = ?", CONNECTION_ASYNC);
207 PrepareStatement(CHAR_SEL_ITEM_INSTANCE_ARTIFACT, "SELECT a.itemGuid, a.xp, a.artifactAppearanceId, a.artifactTierId, ap.artifactPowerId, ap.purchasedRank FROM item_instance_artifact_powers ap LEFT JOIN item_instance_artifact a ON ap.itemGuid = a.itemGuid INNER JOIN character_inventory ci ON ci.item = ap.itemGuid WHERE ci.guid = ?", CONNECTION_ASYNC);
208 PrepareStatement(CHAR_INS_ITEM_INSTANCE_ARTIFACT, "INSERT INTO item_instance_artifact (itemGuid, xp, artifactAppearanceId, artifactTierId) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
209 PrepareStatement(CHAR_DEL_ITEM_INSTANCE_ARTIFACT, "DELETE FROM item_instance_artifact WHERE itemGuid = ?", CONNECTION_ASYNC);
210 PrepareStatement(CHAR_DEL_ITEM_INSTANCE_ARTIFACT_BY_OWNER, "DELETE iia FROM item_instance_artifact iia LEFT JOIN item_instance ii ON iia.itemGuid = ii.guid WHERE ii.owner_guid = ?", CONNECTION_ASYNC);
211 PrepareStatement(CHAR_INS_ITEM_INSTANCE_ARTIFACT_POWERS, "INSERT INTO item_instance_artifact_powers (itemGuid, artifactPowerId, purchasedRank) VALUES (?, ?, ?)", CONNECTION_ASYNC);
212 PrepareStatement(CHAR_DEL_ITEM_INSTANCE_ARTIFACT_POWERS, "DELETE FROM item_instance_artifact_powers WHERE itemGuid = ?", CONNECTION_ASYNC);
213 PrepareStatement(CHAR_DEL_ITEM_INSTANCE_ARTIFACT_POWERS_BY_OWNER, "DELETE iiap FROM item_instance_artifact_powers iiap LEFT JOIN item_instance ii ON iiap.itemGuid = ii.guid WHERE ii.owner_guid = ?", CONNECTION_ASYNC);
214 PrepareStatement(CHAR_INS_ITEM_INSTANCE_MODIFIERS, "INSERT INTO item_instance_modifiers (itemGuid, fixedScalingLevel, artifactKnowledgeLevel) VALUES (?, ?, ?)", CONNECTION_ASYNC);
215 PrepareStatement(CHAR_DEL_ITEM_INSTANCE_MODIFIERS, "DELETE FROM item_instance_modifiers WHERE itemGuid = ?", CONNECTION_ASYNC);
216 PrepareStatement(CHAR_DEL_ITEM_INSTANCE_MODIFIERS_BY_OWNER, "DELETE im FROM item_instance_modifiers im LEFT JOIN item_instance ii ON im.itemGuid = ii.guid WHERE ii.owner_guid = ?", CONNECTION_ASYNC);
217 PrepareStatement(CHAR_SEL_ITEM_INSTANCE_AZERITE, "SELECT iz.itemGuid, iz.xp, iz.level, iz.knowledgeLevel, "
218 "iz.selectedAzeriteEssences1specId, iz.selectedAzeriteEssences1azeriteEssenceId1, iz.selectedAzeriteEssences1azeriteEssenceId2, iz.selectedAzeriteEssences1azeriteEssenceId3, iz.selectedAzeriteEssences1azeriteEssenceId4, "
219 "iz.selectedAzeriteEssences2specId, iz.selectedAzeriteEssences2azeriteEssenceId1, iz.selectedAzeriteEssences2azeriteEssenceId2, iz.selectedAzeriteEssences2azeriteEssenceId3, iz.selectedAzeriteEssences2azeriteEssenceId4, "
220 "iz.selectedAzeriteEssences3specId, iz.selectedAzeriteEssences3azeriteEssenceId1, iz.selectedAzeriteEssences3azeriteEssenceId2, iz.selectedAzeriteEssences3azeriteEssenceId3, iz.selectedAzeriteEssences3azeriteEssenceId4, "
221 "iz.selectedAzeriteEssences4specId, iz.selectedAzeriteEssences4azeriteEssenceId1, iz.selectedAzeriteEssences4azeriteEssenceId2, iz.selectedAzeriteEssences4azeriteEssenceId3, iz.selectedAzeriteEssences4azeriteEssenceId4 "
222 "FROM item_instance_azerite iz INNER JOIN character_inventory ci ON iz.itemGuid = ci.item WHERE ci.guid = ?", CONNECTION_ASYNC);
223 PrepareStatement(CHAR_INS_ITEM_INSTANCE_AZERITE, "INSERT INTO item_instance_azerite (itemGuid, xp, level, knowledgeLevel, selectedAzeriteEssences1specId, selectedAzeriteEssences1azeriteEssenceId1, selectedAzeriteEssences1azeriteEssenceId2, selectedAzeriteEssences1azeriteEssenceId3, selectedAzeriteEssences1azeriteEssenceId4, "
224 "selectedAzeriteEssences2specId, selectedAzeriteEssences2azeriteEssenceId1, selectedAzeriteEssences2azeriteEssenceId2, selectedAzeriteEssences2azeriteEssenceId3, selectedAzeriteEssences2azeriteEssenceId4, "
225 "selectedAzeriteEssences3specId, selectedAzeriteEssences3azeriteEssenceId1, selectedAzeriteEssences3azeriteEssenceId2, selectedAzeriteEssences3azeriteEssenceId3, selectedAzeriteEssences3azeriteEssenceId4, "
226 "selectedAzeriteEssences4specId, selectedAzeriteEssences4azeriteEssenceId1, selectedAzeriteEssences4azeriteEssenceId2, selectedAzeriteEssences4azeriteEssenceId3, selectedAzeriteEssences4azeriteEssenceId4) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
227 PrepareStatement(CHAR_UPD_ITEM_INSTANCE_AZERITE_ON_LOAD, "UPDATE item_instance_azerite SET xp = ?, knowledgeLevel = ? WHERE itemGuid = ?", CONNECTION_ASYNC);
228 PrepareStatement(CHAR_DEL_ITEM_INSTANCE_AZERITE, "DELETE FROM item_instance_azerite WHERE itemGuid = ?", CONNECTION_ASYNC);
229 PrepareStatement(CHAR_DEL_ITEM_INSTANCE_AZERITE_BY_OWNER, "DELETE iz FROM item_instance_azerite iz LEFT JOIN item_instance ii ON iz.itemGuid = ii.guid WHERE ii.owner_guid = ?", CONNECTION_ASYNC);
230 PrepareStatement(CHAR_SEL_ITEM_INSTANCE_AZERITE_MILESTONE_POWER, "SELECT iamp.itemGuid, iamp.azeriteItemMilestonePowerId FROM item_instance_azerite_milestone_power iamp INNER JOIN character_inventory ci ON iamp.itemGuid = ci.item WHERE ci.guid = ?", CONNECTION_ASYNC);
231 PrepareStatement(CHAR_INS_ITEM_INSTANCE_AZERITE_MILESTONE_POWER, "INSERT INTO item_instance_azerite_milestone_power (itemGuid, azeriteItemMilestonePowerId) VALUES (?, ?)", CONNECTION_ASYNC);
232 PrepareStatement(CHAR_DEL_ITEM_INSTANCE_AZERITE_MILESTONE_POWER, "DELETE FROM item_instance_azerite_milestone_power WHERE itemGuid = ?", CONNECTION_ASYNC);
233 PrepareStatement(CHAR_DEL_ITEM_INSTANCE_AZERITE_MILESTONE_POWER_BY_OWNER, "DELETE iamp FROM item_instance_azerite_milestone_power iamp LEFT JOIN item_instance ii ON iamp.itemGuid = ii.guid WHERE ii.owner_guid = ?", CONNECTION_ASYNC);
234 PrepareStatement(CHAR_SEL_ITEM_INSTANCE_AZERITE_UNLOCKED_ESSENCE, "SELECT iaue.itemGuid, iaue.azeriteEssenceId, iaue.`rank` FROM item_instance_azerite_unlocked_essence iaue INNER JOIN character_inventory ci ON iaue.itemGuid = ci.item WHERE ci.guid = ?", CONNECTION_ASYNC);
235 PrepareStatement(CHAR_INS_ITEM_INSTANCE_AZERITE_UNLOCKED_ESSENCE, "INSERT INTO item_instance_azerite_unlocked_essence (itemGuid, azeriteEssenceId, `rank`) VALUES (?, ?, ?)", CONNECTION_ASYNC);
236 PrepareStatement(CHAR_DEL_ITEM_INSTANCE_AZERITE_UNLOCKED_ESSENCE, "DELETE FROM item_instance_azerite_unlocked_essence WHERE itemGuid = ?", CONNECTION_ASYNC);
237 PrepareStatement(CHAR_DEL_ITEM_INSTANCE_AZERITE_UNLOCKED_ESSENCE_BY_OWNER, "DELETE iaue FROM item_instance_azerite_unlocked_essence iaue LEFT JOIN item_instance ii ON iaue.itemGuid = ii.guid WHERE ii.owner_guid = ?", CONNECTION_ASYNC);
238 PrepareStatement(CHAR_SEL_ITEM_INSTANCE_AZERITE_EMPOWERED, "SELECT iae.itemGuid, iae.azeritePowerId1, iae.azeritePowerId2, iae.azeritePowerId3, iae.azeritePowerId4, iae.azeritePowerId5 FROM item_instance_azerite_empowered iae INNER JOIN character_inventory ci ON iae.itemGuid = ci.item WHERE ci.guid = ?", CONNECTION_ASYNC);
239 PrepareStatement(CHAR_INS_ITEM_INSTANCE_AZERITE_EMPOWERED, "INSERT INTO item_instance_azerite_empowered (itemGuid, azeritePowerId1, azeritePowerId2, azeritePowerId3, azeritePowerId4, azeritePowerId5) VALUES (?, ?, ?, ? ,? ,?)", CONNECTION_ASYNC);
240 PrepareStatement(CHAR_UPD_ITEM_INSTANCE_AZERITE_EMPOWERED, "UPDATE item_instance_azerite_empowered SET azeritePowerId1 = ?, azeritePowerId2 = ?, azeritePowerId3 = ?, azeritePowerId4 = ?, azeritePowerId5 = ? WHERE itemGuid = ?", CONNECTION_ASYNC);
241 PrepareStatement(CHAR_DEL_ITEM_INSTANCE_AZERITE_EMPOWERED, "DELETE FROM item_instance_azerite_empowered WHERE itemGuid = ?", CONNECTION_ASYNC);
242 PrepareStatement(CHAR_DEL_ITEM_INSTANCE_AZERITE_EMPOWERED_BY_OWNER, "DELETE iae FROM item_instance_azerite_empowered iae LEFT JOIN item_instance ii ON iae.itemGuid = ii.guid WHERE ii.owner_guid = ?", CONNECTION_ASYNC);
243 PrepareStatement(CHAR_UPD_GIFT_OWNER, "UPDATE character_gifts SET guid = ? WHERE item_guid = ?", CONNECTION_ASYNC);
244 PrepareStatement(CHAR_DEL_GIFT, "DELETE FROM character_gifts WHERE item_guid = ?", CONNECTION_ASYNC);
245 PrepareStatement(CHAR_SEL_CHARACTER_GIFT_BY_ITEM, "SELECT entry, flags FROM character_gifts WHERE item_guid = ?", CONNECTION_ASYNC);
246 PrepareStatement(CHAR_SEL_ACCOUNT_BY_NAME, "SELECT account FROM characters WHERE name = ?", CONNECTION_SYNCH);
247 PrepareStatement(CHAR_UPD_ACCOUNT_BY_GUID, "UPDATE characters SET account = ? WHERE guid = ?", CONNECTION_SYNCH);
248 PrepareStatement(CHAR_DEL_ACCOUNT_INSTANCE_LOCK_TIMES, "DELETE FROM account_instance_times WHERE accountId = ?", CONNECTION_ASYNC);
249 PrepareStatement(CHAR_INS_ACCOUNT_INSTANCE_LOCK_TIMES, "INSERT INTO account_instance_times (accountId, instanceId, releaseTime) VALUES (?, ?, ?)", CONNECTION_ASYNC);
250 PrepareStatement(CHAR_SEL_MATCH_MAKER_RATING, "SELECT matchMakerRating FROM character_arena_stats WHERE guid = ? AND slot = ?", CONNECTION_SYNCH);
251 PrepareStatement(CHAR_SEL_CHARACTER_COUNT, "SELECT account, COUNT(guid) FROM characters WHERE account = ? GROUP BY account", CONNECTION_ASYNC);
252 PrepareStatement(CHAR_UPD_NAME_BY_GUID, "UPDATE characters SET name = ? WHERE guid = ?", CONNECTION_ASYNC);
253
254 // Guild handling
255 // 0: uint32, 1: string, 2: uint32, 3: string, 4: string, 5: uint64, 6-10: uint32, 11: uint64
256 PrepareStatement(CHAR_INS_GUILD, "INSERT INTO guild (guildid, name, leaderguid, info, motd, createdate, EmblemStyle, EmblemColor, BorderStyle, BorderColor, BackgroundColor, BankMoney) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
257 PrepareStatement(CHAR_DEL_GUILD, "DELETE FROM guild WHERE guildid = ?", CONNECTION_ASYNC); // 0: uint32
258 // 0: string, 1: uint32
259 PrepareStatement(CHAR_UPD_GUILD_NAME, "UPDATE guild SET name = ? WHERE guildid = ?", CONNECTION_ASYNC);
260 // 0: uint32, 1: uint32, 2: uint8, 4: string, 5: string
261 PrepareStatement(CHAR_INS_GUILD_MEMBER, "INSERT INTO guild_member (guildid, guid, `rank`, pnote, offnote) VALUES (?, ?, ?, ?, ?)", CONNECTION_ASYNC);
262 PrepareStatement(CHAR_DEL_GUILD_MEMBER, "DELETE FROM guild_member WHERE guid = ?", CONNECTION_ASYNC); // 0: uint32
263 PrepareStatement(CHAR_DEL_GUILD_MEMBERS, "DELETE FROM guild_member WHERE guildid = ?", CONNECTION_ASYNC); // 0: uint32
264 // 0: uint32, 1: uint8, 3: string, 4: uint32, 5: uint32
265 PrepareStatement(CHAR_INS_GUILD_RANK, "INSERT INTO guild_rank (guildid, rid, RankOrder, rname, rights, BankMoneyPerDay) VALUES (?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
266 PrepareStatement(CHAR_DEL_GUILD_RANKS, "DELETE FROM guild_rank WHERE guildid = ?", CONNECTION_ASYNC); // 0: uint32
267 PrepareStatement(CHAR_DEL_GUILD_RANK, "DELETE FROM guild_rank WHERE guildid = ? AND rid = ?", CONNECTION_ASYNC); // 0: uint32, 1: uint8
268 PrepareStatement(CHAR_INS_GUILD_BANK_TAB, "INSERT INTO guild_bank_tab (guildid, TabId) VALUES (?, ?)", CONNECTION_ASYNC); // 0: uint32, 1: uint8
269 PrepareStatement(CHAR_DEL_GUILD_BANK_TAB, "DELETE FROM guild_bank_tab WHERE guildid = ? AND TabId = ?", CONNECTION_ASYNC); // 0: uint32, 1: uint8
270 PrepareStatement(CHAR_DEL_GUILD_BANK_TABS, "DELETE FROM guild_bank_tab WHERE guildid = ?", CONNECTION_ASYNC); // 0: uint32
271 // 0: uint32, 1: uint8, 2: uint8, 3: uint32, 4: uint32
272 PrepareStatement(CHAR_INS_GUILD_BANK_ITEM, "INSERT INTO guild_bank_item (guildid, TabId, SlotId, item_guid) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
273 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
274 PrepareStatement(CHAR_SEL_GUILD_BANK_ITEMS, "SELECT " SelectItemInstanceContent ", guildid, TabId, SlotId FROM guild_bank_item gbi INNER JOIN item_instance ii ON gbi.item_guid = ii.guid LEFT JOIN item_instance_gems ig ON ii.guid = ig.itemGuid LEFT JOIN item_instance_transmog iit ON ii.guid = iit.itemGuid LEFT JOIN item_instance_modifiers im ON ii.guid = im.itemGuid", CONNECTION_SYNCH);
275 PrepareStatement(CHAR_DEL_GUILD_BANK_ITEMS, "DELETE FROM guild_bank_item WHERE guildid = ?", CONNECTION_ASYNC); // 0: uint32
276 // 0: uint32, 1: uint8, 2: uint8, 3: uint8, 4: uint32
277 PrepareStatement(CHAR_INS_GUILD_BANK_RIGHT, "INSERT INTO guild_bank_right (guildid, TabId, rid, gbright, SlotPerDay) VALUES (?, ?, ?, ?, ?) "
278 "ON DUPLICATE KEY UPDATE gbright = VALUES(gbright), SlotPerDay = VALUES(SlotPerDay)", CONNECTION_ASYNC);
279 PrepareStatement(CHAR_DEL_GUILD_BANK_RIGHTS, "DELETE FROM guild_bank_right WHERE guildid = ?", CONNECTION_ASYNC); // 0: uint32
280 PrepareStatement(CHAR_DEL_GUILD_BANK_RIGHTS_FOR_RANK, "DELETE FROM guild_bank_right WHERE guildid = ? AND rid = ?", CONNECTION_ASYNC); // 0: uint32, 1: uint8
281 // 0-1: uint32, 2-3: uint8, 4-5: uint32, 6: uint16, 7: uint8, 8: uint64
282 PrepareStatement(CHAR_INS_GUILD_BANK_EVENTLOG, "INSERT INTO guild_bank_eventlog (guildid, LogGuid, TabId, EventType, PlayerGuid, ItemOrMoney, ItemStackCount, DestTabId, TimeStamp) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
283 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
284 PrepareStatement(CHAR_DEL_GUILD_BANK_EVENTLOGS, "DELETE FROM guild_bank_eventlog WHERE guildid = ?", CONNECTION_ASYNC); // 0: uint32
285 // 0-1: uint32, 2: uint8, 3-4: uint32, 5: uint8, 6: uint64
286 PrepareStatement(CHAR_INS_GUILD_EVENTLOG, "INSERT INTO guild_eventlog (guildid, LogGuid, EventType, PlayerGuid1, PlayerGuid2, NewRank, TimeStamp) VALUES (?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
287 PrepareStatement(CHAR_DEL_GUILD_EVENTLOG, "DELETE FROM guild_eventlog WHERE guildid = ? AND LogGuid = ?", CONNECTION_ASYNC); // 0: uint32, 1: uint32
288 PrepareStatement(CHAR_DEL_GUILD_EVENTLOGS, "DELETE FROM guild_eventlog WHERE guildid = ?", CONNECTION_ASYNC); // 0: uint32
289 PrepareStatement(CHAR_UPD_GUILD_MEMBER_PNOTE, "UPDATE guild_member SET pnote = ? WHERE guid = ?", CONNECTION_ASYNC); // 0: string, 1: uint32
290 PrepareStatement(CHAR_UPD_GUILD_MEMBER_OFFNOTE, "UPDATE guild_member SET offnote = ? WHERE guid = ?", CONNECTION_ASYNC); // 0: string, 1: uint32
291 PrepareStatement(CHAR_UPD_GUILD_MEMBER_RANK, "UPDATE guild_member SET `rank` = ? WHERE guid = ?", CONNECTION_ASYNC); // 0: uint8, 1: uint32
292 PrepareStatement(CHAR_UPD_GUILD_MOTD, "UPDATE guild SET motd = ? WHERE guildid = ?", CONNECTION_ASYNC); // 0: string, 1: uint32
293 PrepareStatement(CHAR_UPD_GUILD_INFO, "UPDATE guild SET info = ? WHERE guildid = ?", CONNECTION_ASYNC); // 0: string, 1: uint32
294 PrepareStatement(CHAR_UPD_GUILD_LEADER, "UPDATE guild SET leaderguid = ? WHERE guildid = ?", CONNECTION_ASYNC); // 0: uint32, 1: uint64
295 PrepareStatement(CHAR_UPD_GUILD_RANK_ORDER, "UPDATE guild_rank SET RankOrder = ? WHERE rid = ? AND guildid = ?", CONNECTION_ASYNC); // 0-1: uint8, 2: uint32
296 PrepareStatement(CHAR_UPD_GUILD_RANK_NAME, "UPDATE guild_rank SET rname = ? WHERE rid = ? AND guildid = ?", CONNECTION_ASYNC); // 0: string, 1: uint8, 2: uint32
297 PrepareStatement(CHAR_UPD_GUILD_RANK_RIGHTS, "UPDATE guild_rank SET rights = ? WHERE rid = ? AND guildid = ?", CONNECTION_ASYNC); // 0: uint32, 1: uint8, 2: uint32
298 // 0-5: uint32
299 PrepareStatement(CHAR_UPD_GUILD_EMBLEM_INFO, "UPDATE guild SET EmblemStyle = ?, EmblemColor = ?, BorderStyle = ?, BorderColor = ?, BackgroundColor = ? WHERE guildid = ?", CONNECTION_ASYNC);
300 // 0: string, 1: string, 2: uint32, 3: uint8
301 PrepareStatement(CHAR_UPD_GUILD_BANK_TAB_INFO, "UPDATE guild_bank_tab SET TabName = ?, TabIcon = ? WHERE guildid = ? AND TabId = ?", CONNECTION_ASYNC);
302 PrepareStatement(CHAR_UPD_GUILD_BANK_MONEY, "UPDATE guild SET BankMoney = ? WHERE guildid = ?", CONNECTION_ASYNC); // 0: uint64, 1: uint32
303 // 0: uint8, 1: uint32, 2: uint8, 3: uint32
304 PrepareStatement(CHAR_UPD_GUILD_RANK_BANK_MONEY, "UPDATE guild_rank SET BankMoneyPerDay = ? WHERE rid = ? AND guildid = ?", CONNECTION_ASYNC); // 0: uint32, 1: uint8, 2: uint32
305 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
306
307 PrepareStatement(CHAR_INS_GUILD_MEMBER_WITHDRAW_TABS,
308 "INSERT INTO guild_member_withdraw (guid, tab0, tab1, tab2, tab3, tab4, tab5, tab6, tab7) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) "
309 "ON DUPLICATE KEY UPDATE tab0 = VALUES (tab0), tab1 = VALUES (tab1), tab2 = VALUES (tab2), tab3 = VALUES (tab3), tab4 = VALUES (tab4), tab5 = VALUES (tab5), tab6 = VALUES (tab6), tab7 = VALUES (tab7)", CONNECTION_ASYNC);
310 PrepareStatement(CHAR_INS_GUILD_MEMBER_WITHDRAW_MONEY, "INSERT INTO guild_member_withdraw (guid, money) VALUES (?, ?) ON DUPLICATE KEY UPDATE money = VALUES (money)", CONNECTION_ASYNC);
311 PrepareStatement(CHAR_DEL_GUILD_MEMBER_WITHDRAW, "DELETE FROM guild_member_withdraw", CONNECTION_ASYNC);
312
313 // 0: uint32, 1: uint32, 2: uint32
314 PrepareStatement(CHAR_SEL_CHAR_DATA_FOR_GUILD, "SELECT name, level, race, class, gender, zone, account FROM characters WHERE guid = ?", CONNECTION_SYNCH);
315 PrepareStatement(CHAR_DEL_GUILD_ACHIEVEMENT, "DELETE FROM guild_achievement WHERE guildId = ? AND achievement = ?", CONNECTION_ASYNC);
316 PrepareStatement(CHAR_INS_GUILD_ACHIEVEMENT, "INSERT INTO guild_achievement (guildId, achievement, date, guids) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
317 PrepareStatement(CHAR_DEL_GUILD_ACHIEVEMENT_CRITERIA, "DELETE FROM guild_achievement_progress WHERE guildId = ? AND criteria = ?", CONNECTION_ASYNC);
318 PrepareStatement(CHAR_INS_GUILD_ACHIEVEMENT_CRITERIA, "INSERT INTO guild_achievement_progress (guildId, criteria, counter, date, completedGuid) VALUES (?, ?, ?, ?, ?)", CONNECTION_ASYNC);
319 PrepareStatement(CHAR_DEL_ALL_GUILD_ACHIEVEMENTS, "DELETE FROM guild_achievement WHERE guildId = ? AND achievement NOT IN (5407,5408,5409,5410,5411,5985,6126,6628,6678,6679,6680,8257,8512,8513,9397,9399,10380)", CONNECTION_ASYNC);
320 PrepareStatement(CHAR_DEL_ALL_GUILD_ACHIEVEMENT_CRITERIA, "DELETE FROM guild_achievement_progress WHERE guildId = ?", CONNECTION_ASYNC);
321 PrepareStatement(CHAR_SEL_GUILD_ACHIEVEMENT, "SELECT achievement, date, guids FROM guild_achievement WHERE guildId = ?", CONNECTION_SYNCH);
322 PrepareStatement(CHAR_SEL_GUILD_ACHIEVEMENT_CRITERIA, "SELECT criteria, counter, date, completedGuid FROM guild_achievement_progress WHERE guildId = ?", CONNECTION_SYNCH);
323 PrepareStatement(CHAR_INS_GUILD_NEWS, "INSERT INTO guild_newslog (guildid, LogGuid, EventType, PlayerGuid, Flags, Value, Timestamp) VALUES (?, ?, ?, ?, ?, ?, ?)"
324 " ON DUPLICATE KEY UPDATE LogGuid = VALUES (LogGuid), EventType = VALUES (EventType), PlayerGuid = VALUES (PlayerGuid), Flags = VALUES (Flags), Value = VALUES (Value), Timestamp = VALUES (Timestamp)", CONNECTION_ASYNC);
325
326 // Chat channel handling
327 PrepareStatement(CHAR_UPD_CHANNEL, "INSERT INTO channels (name, team, announce, ownership, password, bannedList, lastUsed) VALUES (?, ?, ?, ?, ?, ?, UNIX_TIMESTAMP()) "
328 "ON DUPLICATE KEY UPDATE announce=VALUES(announce), ownership=VALUES(ownership), password=VALUES(password), bannedList=VALUES(bannedList), lastUsed=VALUES(lastUsed)", CONNECTION_ASYNC);
329 PrepareStatement(CHAR_UPD_CHANNEL_USAGE, "UPDATE channels SET lastUsed = UNIX_TIMESTAMP() WHERE name = ? AND team = ?", CONNECTION_ASYNC);
330 PrepareStatement(CHAR_UPD_CHANNEL_OWNERSHIP, "UPDATE channels SET ownership = ? WHERE name LIKE ?", CONNECTION_ASYNC);
331 PrepareStatement(CHAR_DEL_CHANNEL, "DELETE FROM channels WHERE name = ? AND team = ?", CONNECTION_ASYNC);
332 PrepareStatement(CHAR_DEL_OLD_CHANNELS, "DELETE FROM channels WHERE ownership = 1 AND lastUsed + ? < UNIX_TIMESTAMP()", CONNECTION_ASYNC);
333
334 // Equipmentsets
335 PrepareStatement(CHAR_UPD_EQUIP_SET, "UPDATE character_equipmentsets SET name=?, iconname=?, ignore_mask=?, AssignedSpecIndex=?, item0=?, item1=?, item2=?, item3=?, "
336 "item4=?, item5=?, item6=?, item7=?, item8=?, item9=?, item10=?, item11=?, item12=?, item13=?, item14=?, item15=?, item16=?, "
337 "item17=?, item18=? WHERE guid=? AND setguid=? AND setindex=?", CONNECTION_ASYNC);
338 PrepareStatement(CHAR_INS_EQUIP_SET, "INSERT INTO character_equipmentsets (guid, setguid, setindex, name, iconname, ignore_mask, AssignedSpecIndex, item0, item1, item2, item3, "
339 "item4, item5, item6, item7, item8, item9, item10, item11, item12, item13, item14, item15, item16, item17, item18) "
340 "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
341 PrepareStatement(CHAR_DEL_EQUIP_SET, "DELETE FROM character_equipmentsets WHERE setguid=?", CONNECTION_ASYNC);
342 PrepareStatement(CHAR_UPD_TRANSMOG_OUTFIT, "UPDATE character_transmog_outfits SET name=?, iconname=?, ignore_mask=?, appearance0=?, appearance1=?, appearance2=?, appearance3=?, "
343 "appearance4=?, appearance5=?, appearance6=?, appearance7=?, appearance8=?, appearance9=?, appearance10=?, appearance11=?, appearance12=?, appearance13=?, appearance14=?, "
344 "appearance15=?, appearance16=?, appearance17=?, appearance18=?, mainHandEnchant=?, offHandEnchant=? WHERE guid=? AND setguid=? AND setindex=?", CONNECTION_ASYNC);
345 PrepareStatement(CHAR_INS_TRANSMOG_OUTFIT, "INSERT INTO character_transmog_outfits (guid, setguid, setindex, name, iconname, ignore_mask, appearance0, appearance1, appearance2, "
346 "appearance3, appearance4, appearance5, appearance6, appearance7, appearance8, appearance9, appearance10, appearance11, appearance12, appearance13, appearance14, appearance15, "
347 "appearance16, appearance17, appearance18, mainHandEnchant, offHandEnchant) "
348 "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
349 PrepareStatement(CHAR_DEL_TRANSMOG_OUTFIT, "DELETE FROM character_transmog_outfits WHERE setguid=?", CONNECTION_ASYNC);
350
351 // Auras
352 PrepareStatement(CHAR_INS_AURA, "INSERT INTO character_aura (guid, casterGuid, itemGuid, spell, effectMask, recalculateMask, difficulty, stackCount, maxDuration, remainTime, remainCharges, castItemId, castItemLevel) "
353 "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
354 PrepareStatement(CHAR_INS_AURA_EFFECT, "INSERT INTO character_aura_effect (guid, casterGuid, itemGuid, spell, effectMask, effectIndex, amount, baseAmount) "
355 "VALUES (?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
356
357 // Currency
358 PrepareStatement(CHAR_SEL_PLAYER_CURRENCY, "SELECT Currency, Quantity, WeeklyQuantity, TrackedQuantity, IncreasedCapQuantity, EarnedQuantity, Flags FROM character_currency WHERE CharacterGuid = ?", CONNECTION_ASYNC);
359 PrepareStatement(CHAR_UPD_PLAYER_CURRENCY, "UPDATE character_currency SET Quantity = ?, WeeklyQuantity = ?, TrackedQuantity = ?, IncreasedCapQuantity = ?, EarnedQuantity = ?, Flags = ? WHERE CharacterGuid = ? AND Currency = ?", CONNECTION_ASYNC);
360 PrepareStatement(CHAR_REP_PLAYER_CURRENCY, "REPLACE INTO character_currency (CharacterGuid, Currency, Quantity, WeeklyQuantity, TrackedQuantity, IncreasedCapQuantity, EarnedQuantity, Flags) VALUES (?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
361 PrepareStatement(CHAR_DEL_PLAYER_CURRENCY, "DELETE FROM character_currency WHERE CharacterGuid = ?", CONNECTION_ASYNC);
362
363 // Account data
364 PrepareStatement(CHAR_SEL_ACCOUNT_DATA, "SELECT type, time, data FROM account_data WHERE accountId = ?", CONNECTION_ASYNC);
365 PrepareStatement(CHAR_REP_ACCOUNT_DATA, "REPLACE INTO account_data (accountId, type, time, data) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
366 PrepareStatement(CHAR_DEL_ACCOUNT_DATA, "DELETE FROM account_data WHERE accountId = ?", CONNECTION_ASYNC);
367 PrepareStatement(CHAR_SEL_PLAYER_ACCOUNT_DATA, "SELECT type, time, data FROM character_account_data WHERE guid = ?", CONNECTION_ASYNC);
368 PrepareStatement(CHAR_REP_PLAYER_ACCOUNT_DATA, "REPLACE INTO character_account_data(guid, type, time, data) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
369 PrepareStatement(CHAR_DEL_PLAYER_ACCOUNT_DATA, "DELETE FROM character_account_data WHERE guid = ?", CONNECTION_ASYNC);
370
371 // Tutorials
372 PrepareStatement(CHAR_SEL_TUTORIALS, "SELECT tut0, tut1, tut2, tut3, tut4, tut5, tut6, tut7 FROM account_tutorial WHERE accountId = ?", CONNECTION_ASYNC);
373 PrepareStatement(CHAR_INS_TUTORIALS, "INSERT INTO account_tutorial(tut0, tut1, tut2, tut3, tut4, tut5, tut6, tut7, accountId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
374 PrepareStatement(CHAR_UPD_TUTORIALS, "UPDATE account_tutorial SET tut0 = ?, tut1 = ?, tut2 = ?, tut3 = ?, tut4 = ?, tut5 = ?, tut6 = ?, tut7 = ? WHERE accountId = ?", CONNECTION_ASYNC);
375 PrepareStatement(CHAR_DEL_TUTORIALS, "DELETE FROM account_tutorial WHERE accountId = ?", CONNECTION_ASYNC);
376
377 // Game event saves
378 PrepareStatement(CHAR_DEL_GAME_EVENT_SAVE, "DELETE FROM game_event_save WHERE eventEntry = ?", CONNECTION_ASYNC);
379 PrepareStatement(CHAR_INS_GAME_EVENT_SAVE, "INSERT INTO game_event_save (eventEntry, state, next_start) VALUES (?, ?, ?)", CONNECTION_ASYNC);
380
381 // Game event condition saves
382 PrepareStatement(CHAR_DEL_ALL_GAME_EVENT_CONDITION_SAVE, "DELETE FROM game_event_condition_save WHERE eventEntry = ?", CONNECTION_ASYNC);
383 PrepareStatement(CHAR_DEL_GAME_EVENT_CONDITION_SAVE, "DELETE FROM game_event_condition_save WHERE eventEntry = ? AND condition_id = ?", CONNECTION_ASYNC);
384 PrepareStatement(CHAR_INS_GAME_EVENT_CONDITION_SAVE, "INSERT INTO game_event_condition_save (eventEntry, condition_id, done) VALUES (?, ?, ?)", CONNECTION_ASYNC);
385
386 // Petitions
387 PrepareStatement(CHAR_SEL_PETITION, "SELECT ownerguid, name FROM petition WHERE petitionguid = ?", CONNECTION_SYNCH);
388 PrepareStatement(CHAR_SEL_PETITION_SIGNATURE, "SELECT playerguid FROM petition_sign WHERE petitionguid = ?", CONNECTION_SYNCH);
389 PrepareStatement(CHAR_DEL_ALL_PETITION_SIGNATURES, "DELETE FROM petition_sign WHERE playerguid = ?", CONNECTION_ASYNC);
390 PrepareStatement(CHAR_SEL_PETITION_BY_OWNER, "SELECT petitionguid FROM petition WHERE ownerguid = ?", CONNECTION_SYNCH);
391 PrepareStatement(CHAR_SEL_PETITION_SIGNATURES, "SELECT ownerguid, (SELECT COUNT(playerguid) FROM petition_sign WHERE petition_sign.petitionguid = ?) AS signs FROM petition WHERE petitionguid = ?", CONNECTION_SYNCH);
392 PrepareStatement(CHAR_SEL_PETITION_SIG_BY_ACCOUNT, "SELECT playerguid FROM petition_sign WHERE player_account = ? AND petitionguid = ?", CONNECTION_SYNCH);
393 PrepareStatement(CHAR_SEL_PETITION_OWNER_BY_GUID, "SELECT ownerguid FROM petition WHERE petitionguid = ?", CONNECTION_SYNCH);
394 PrepareStatement(CHAR_SEL_PETITION_SIG_BY_GUID, "SELECT ownerguid, petitionguid FROM petition_sign WHERE playerguid = ?", CONNECTION_SYNCH);
395
396 // Arena teams
397 PrepareStatement(CHAR_SEL_CHARACTER_ARENAINFO, "SELECT arenaTeamId, weekGames, seasonGames, seasonWins, personalRating FROM arena_team_member WHERE guid = ?", CONNECTION_ASYNC);
398 PrepareStatement(CHAR_INS_ARENA_TEAM, "INSERT INTO arena_team (arenaTeamId, name, captainGuid, type, rating, backgroundColor, emblemStyle, emblemColor, borderStyle, borderColor) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
399 PrepareStatement(CHAR_INS_ARENA_TEAM_MEMBER, "INSERT INTO arena_team_member (arenaTeamId, guid, personalRating) VALUES (?, ?, ?)", CONNECTION_ASYNC);
400 PrepareStatement(CHAR_DEL_ARENA_TEAM, "DELETE FROM arena_team where arenaTeamId = ?", CONNECTION_ASYNC);
401 PrepareStatement(CHAR_DEL_ARENA_TEAM_MEMBERS, "DELETE FROM arena_team_member WHERE arenaTeamId = ?", CONNECTION_ASYNC);
402 PrepareStatement(CHAR_UPD_ARENA_TEAM_CAPTAIN, "UPDATE arena_team SET captainGuid = ? WHERE arenaTeamId = ?", CONNECTION_ASYNC);
403 PrepareStatement(CHAR_DEL_ARENA_TEAM_MEMBER, "DELETE FROM arena_team_member WHERE arenaTeamId = ? AND guid = ?", CONNECTION_ASYNC);
404 PrepareStatement(CHAR_UPD_ARENA_TEAM_STATS, "UPDATE arena_team SET rating = ?, weekGames = ?, weekWins = ?, seasonGames = ?, seasonWins = ?, `rank` = ? WHERE arenaTeamId = ?", CONNECTION_ASYNC);
405 PrepareStatement(CHAR_UPD_ARENA_TEAM_MEMBER, "UPDATE arena_team_member SET personalRating = ?, weekGames = ?, weekWins = ?, seasonGames = ?, seasonWins = ? WHERE arenaTeamId = ? AND guid = ?", CONNECTION_ASYNC);
406 PrepareStatement(CHAR_DEL_CHARACTER_ARENA_STATS, "DELETE FROM character_arena_stats WHERE guid = ?", CONNECTION_ASYNC);
407 PrepareStatement(CHAR_REP_CHARACTER_ARENA_STATS, "REPLACE INTO character_arena_stats (guid, slot, matchMakerRating) VALUES (?, ?, ?)", CONNECTION_ASYNC);
408 PrepareStatement(CHAR_UPD_ARENA_TEAM_NAME, "UPDATE arena_team SET name = ? WHERE arenaTeamId = ?", CONNECTION_ASYNC);
409
410 // Character battleground data
411 PrepareStatement(CHAR_INS_PLAYER_BGDATA, "INSERT INTO character_battleground_data (guid, instanceId, team, joinX, joinY, joinZ, joinO, joinMapId, taxiStart, taxiEnd, mountSpell) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
412 PrepareStatement(CHAR_DEL_PLAYER_BGDATA, "DELETE FROM character_battleground_data WHERE guid = ?", CONNECTION_ASYNC);
413
414 // Character homebind
415 PrepareStatement(CHAR_INS_PLAYER_HOMEBIND, "INSERT INTO character_homebind (guid, mapId, zoneId, posX, posY, posZ, orientation) VALUES (?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
416 PrepareStatement(CHAR_UPD_PLAYER_HOMEBIND, "UPDATE character_homebind SET mapId = ?, zoneId = ?, posX = ?, posY = ?, posZ = ?, orientation = ? WHERE guid = ?", CONNECTION_ASYNC);
417 PrepareStatement(CHAR_DEL_PLAYER_HOMEBIND, "DELETE FROM character_homebind WHERE guid = ?", CONNECTION_ASYNC);
418
419 // Corpse
420 PrepareStatement(CHAR_SEL_CORPSES, "SELECT posX, posY, posZ, orientation, mapId, displayId, itemCache, race, class, gender, flags, dynFlags, time, corpseType, instanceId, guid FROM corpse WHERE mapId = ? AND instanceId = ?", CONNECTION_SYNCH);
421 PrepareStatement(CHAR_INS_CORPSE, "INSERT INTO corpse (guid, posX, posY, posZ, orientation, mapId, displayId, itemCache, race, class, gender, flags, dynFlags, time, corpseType, instanceId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
422 PrepareStatement(CHAR_DEL_CORPSE, "DELETE FROM corpse WHERE guid = ?", CONNECTION_ASYNC);
423 PrepareStatement(CHAR_DEL_CORPSES_FROM_MAP, "DELETE c, cc, cp FROM corpse c LEFT JOIN corpse_customizations cc ON c.guid = cc.ownerGuid LEFT JOIN corpse_phases cp ON c.guid = cp.OwnerGuid WHERE c.mapId = ? AND c.instanceId = ?", CONNECTION_ASYNC);
424 PrepareStatement(CHAR_SEL_CORPSE_PHASES, "SELECT cp.OwnerGuid, cp.PhaseId FROM corpse_phases cp LEFT JOIN corpse c ON cp.OwnerGuid = c.guid WHERE c.mapId = ? AND c.instanceId = ?", CONNECTION_SYNCH);
425 PrepareStatement(CHAR_INS_CORPSE_PHASES, "INSERT INTO corpse_phases (OwnerGuid, PhaseId) VALUES (?, ?)", CONNECTION_ASYNC);
426 PrepareStatement(CHAR_DEL_CORPSE_PHASES, "DELETE FROM corpse_phases WHERE OwnerGuid = ?", CONNECTION_ASYNC);
427 PrepareStatement(CHAR_SEL_CORPSE_CUSTOMIZATIONS, "SELECT cc.ownerGuid, cc.chrCustomizationOptionID, cc.chrCustomizationChoiceID FROM corpse_customizations cc LEFT JOIN corpse c ON cc.ownerGuid = c.guid WHERE c.mapId = ? AND c.instanceId = ? ORDER BY cc.ownerGuid, cc.chrCustomizationOptionID", CONNECTION_SYNCH);
428 PrepareStatement(CHAR_INS_CORPSE_CUSTOMIZATIONS, "INSERT INTO corpse_customizations (ownerGuid, chrCustomizationOptionID, chrCustomizationChoiceID) VALUES (?, ?, ?)", CONNECTION_ASYNC);
429 PrepareStatement(CHAR_DEL_CORPSE_CUSTOMIZATIONS, "DELETE FROM corpse_customizations WHERE ownerGuid = ?", CONNECTION_ASYNC);
430 PrepareStatement(CHAR_SEL_CORPSE_LOCATION, "SELECT mapId, posX, posY, posZ, orientation FROM corpse WHERE guid = ?", CONNECTION_ASYNC);
431
432 // Respawns
433 PrepareStatement(CHAR_SEL_RESPAWNS, "SELECT type, spawnId, respawnTime FROM respawn WHERE mapId = ? AND instanceId = ?", CONNECTION_SYNCH);
434 PrepareStatement(CHAR_REP_RESPAWN, "REPLACE INTO respawn (type, spawnId, respawnTime, mapId, instanceId) VALUES (?, ?, ?, ?, ?)", CONNECTION_ASYNC);
435 PrepareStatement(CHAR_DEL_RESPAWN, "DELETE FROM respawn WHERE type = ? AND spawnId = ? AND mapId = ? AND instanceId = ?", CONNECTION_ASYNC);
436 PrepareStatement(CHAR_DEL_ALL_RESPAWNS, "DELETE FROM respawn WHERE mapId = ? AND instanceId = ?", CONNECTION_ASYNC);
437
438 // GM Bug
439 PrepareStatement(CHAR_SEL_GM_BUGS, "SELECT id, playerGuid, note, createTime, mapId, posX, posY, posZ, facing, closedBy, assignedTo, comment FROM gm_bug", CONNECTION_SYNCH);
440 PrepareStatement(CHAR_REP_GM_BUG, "REPLACE INTO gm_bug (id, playerGuid, note, createTime, mapId, posX, posY, posZ, facing, closedBy, assignedTo, comment) VALUES (?, ?, ?, UNIX_TIMESTAMP(NOW()), ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
441 PrepareStatement(CHAR_DEL_GM_BUG, "DELETE FROM gm_bug WHERE id = ?", CONNECTION_ASYNC);
442 PrepareStatement(CHAR_DEL_ALL_GM_BUGS, "DELETE FROM gm_bug", CONNECTION_ASYNC);
443
444 // GM Complaint
445 PrepareStatement(CHAR_SEL_GM_COMPLAINTS, "SELECT id, playerGuid, note, createTime, mapId, posX, posY, posZ, facing, targetCharacterGuid, reportType, reportMajorCategory, reportMinorCategoryFlags, reportLineIndex, assignedTo, closedBy, comment FROM gm_complaint", CONNECTION_SYNCH);
446 PrepareStatement(CHAR_REP_GM_COMPLAINT, "REPLACE INTO gm_complaint (id, playerGuid, note, createTime, mapId, posX, posY, posZ, facing, targetCharacterGuid, reportType, reportMajorCategory, reportMinorCategoryFlags, reportLineIndex, assignedTo, closedBy, comment) VALUES (?, ?, ?, UNIX_TIMESTAMP(NOW()), ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
447 PrepareStatement(CHAR_DEL_GM_COMPLAINT, "DELETE FROM gm_complaint WHERE id = ?", CONNECTION_ASYNC);
448 PrepareStatement(CHAR_SEL_GM_COMPLAINT_CHATLINES, "SELECT timestamp, text FROM gm_complaint_chatlog WHERE complaintId = ? ORDER BY lineId ASC", CONNECTION_SYNCH);
449 PrepareStatement(CHAR_INS_GM_COMPLAINT_CHATLINE, "INSERT INTO gm_complaint_chatlog (complaintId, lineId, timestamp, text) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
450 PrepareStatement(CHAR_DEL_GM_COMPLAINT_CHATLOG, "DELETE FROM gm_complaint_chatlog WHERE complaintId = ?", CONNECTION_ASYNC);
451 PrepareStatement(CHAR_DEL_ALL_GM_COMPLAINTS, "DELETE FROM gm_complaint", CONNECTION_ASYNC);
452 PrepareStatement(CHAR_DEL_ALL_GM_COMPLAINT_CHATLOGS, "DELETE FROM gm_complaint_chatlog", CONNECTION_ASYNC);
453
454 // GM Suggestion
455 PrepareStatement(CHAR_SEL_GM_SUGGESTIONS, "SELECT id, playerGuid, note, createTime, mapId, posX, posY, posZ, facing, closedBy, assignedTo, comment FROM gm_suggestion", CONNECTION_SYNCH);
456 PrepareStatement(CHAR_REP_GM_SUGGESTION, "REPLACE INTO gm_suggestion (id, playerGuid, note, createTime, mapId, posX, posY, posZ, facing, closedBy, assignedTo, comment) VALUES (?, ?, ?, UNIX_TIMESTAMP(NOW()), ?, ?, ?, ?, ?, ? ,? ,?)", CONNECTION_ASYNC);
457 PrepareStatement(CHAR_DEL_GM_SUGGESTION, "DELETE FROM gm_suggestion WHERE id = ?", CONNECTION_ASYNC);
458 PrepareStatement(CHAR_DEL_ALL_GM_SUGGESTIONS, "DELETE FROM gm_suggestion", CONNECTION_ASYNC);
459
460 // LFG Data
461 PrepareStatement(CHAR_INS_LFG_DATA, "INSERT INTO lfg_data (guid, dungeon, state) VALUES (?, ?, ?)", CONNECTION_ASYNC);
462 PrepareStatement(CHAR_DEL_LFG_DATA, "DELETE FROM lfg_data WHERE guid = ?", CONNECTION_ASYNC);
463
464 // Player saving
465 PrepareStatement(CHAR_INS_CHARACTER, "INSERT INTO characters (guid, account, name, race, class, gender, level, xp, money, inventorySlots, bankSlots, restState, playerFlags, playerFlagsEx, "
466 "map, instance_id, dungeonDifficulty, raidDifficulty, legacyRaidDifficulty, position_x, position_y, position_z, orientation, trans_x, trans_y, trans_z, trans_o, transguid, "
467 "taximask, createTime, createMode, cinematic, "
468 "totaltime, leveltime, rest_bonus, logout_time, is_logout_resting, resettalents_cost, resettalents_time, primarySpecialization, "
469 "extra_flags, summonedPetNumber, at_login, "
470 "death_expire_time, taxi_path, totalKills, "
471 "todayKills, yesterdayKills, chosenTitle, watchedFaction, drunk, health, power1, power2, power3, "
472 "power4, power5, power6, power7, latency, activeTalentGroup, lootSpecId, exploredZones, equipmentCache, knownTitles, actionBars, lastLoginBuild) VALUES "
473 "(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)", CONNECTION_ASYNC);
474 PrepareStatement(CHAR_UPD_CHARACTER, "UPDATE characters SET name=?,race=?,class=?,gender=?,level=?,xp=?,money=?,inventorySlots=?,bankSlots=?,restState=?,playerFlags=?,playerFlagsEx=?,"
475 "map=?,instance_id=?,dungeonDifficulty=?,raidDifficulty=?,legacyRaidDifficulty=?,position_x=?,position_y=?,position_z=?,orientation=?,trans_x=?,trans_y=?,trans_z=?,trans_o=?,transguid=?,taximask=?,cinematic=?,totaltime=?,leveltime=?,rest_bonus=?,"
476 "logout_time=?,is_logout_resting=?,resettalents_cost=?,resettalents_time=?,numRespecs=?,primarySpecialization=?,extra_flags=?,summonedPetNumber=?,at_login=?,zone=?,death_expire_time=?,taxi_path=?,"
477 "totalKills=?,todayKills=?,yesterdayKills=?,chosenTitle=?,"
478 "watchedFaction=?,drunk=?,health=?,power1=?,power2=?,power3=?,power4=?,power5=?,power6=?,power7=?,latency=?,activeTalentGroup=?,lootSpecId=?,exploredZones=?,"
479 "equipmentCache=?,knownTitles=?,actionBars=?,online=?,honor=?,honorLevel=?,honorRestState=?,honorRestBonus=?,lastLoginBuild=? WHERE guid=?", CONNECTION_ASYNC);
480
481 PrepareStatement(CHAR_UPD_ADD_AT_LOGIN_FLAG, "UPDATE characters SET at_login = at_login | ? WHERE guid = ?", CONNECTION_ASYNC);
482 PrepareStatement(CHAR_UPD_REM_AT_LOGIN_FLAG, "UPDATE characters set at_login = at_login & ~ ? WHERE guid = ?", CONNECTION_ASYNC);
483 PrepareStatement(CHAR_UPD_ALL_AT_LOGIN_FLAGS, "UPDATE characters SET at_login = at_login | ?", CONNECTION_ASYNC);
484 PrepareStatement(CHAR_INS_BUG_REPORT, "INSERT INTO bugreport (type, content) VALUES(?, ?)", CONNECTION_ASYNC);
485 PrepareStatement(CHAR_UPD_PETITION_NAME, "UPDATE petition SET name = ? WHERE petitionguid = ?", CONNECTION_ASYNC);
486 PrepareStatement(CHAR_INS_PETITION_SIGNATURE, "INSERT INTO petition_sign (ownerguid, petitionguid, playerguid, player_account) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
487 PrepareStatement(CHAR_UPD_ACCOUNT_ONLINE, "UPDATE characters SET online = 0 WHERE account = ?", CONNECTION_ASYNC);
488 PrepareStatement(CHAR_INS_CHARACTER_CUSTOMIZATION, "INSERT INTO character_customizations (guid, chrCustomizationOptionID, chrCustomizationChoiceID) VALUES (?, ?, ?)", CONNECTION_ASYNC);
489 PrepareStatement(CHAR_DEL_CHARACTER_CUSTOMIZATIONS, "DELETE FROM character_customizations WHERE guid = ?", CONNECTION_ASYNC);
490 PrepareStatement(CHAR_INS_GROUP, "INSERT INTO `groups` (guid, leaderGuid, lootMethod, looterGuid, lootThreshold, icon1, icon2, icon3, icon4, icon5, icon6, icon7, icon8, groupType, difficulty, raidDifficulty, legacyRaidDifficulty, masterLooterGuid) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
491 PrepareStatement(CHAR_INS_GROUP_MEMBER, "INSERT INTO group_member (guid, memberGuid, memberFlags, subgroup, roles) VALUES(?, ?, ?, ?, ?)", CONNECTION_ASYNC);
492 PrepareStatement(CHAR_DEL_GROUP_MEMBER, "DELETE FROM group_member WHERE memberGuid = ?", CONNECTION_ASYNC);
493 PrepareStatement(CHAR_UPD_GROUP_LEADER, "UPDATE `groups` SET leaderGuid = ? WHERE guid = ?", CONNECTION_ASYNC);
494 PrepareStatement(CHAR_UPD_GROUP_TYPE, "UPDATE `groups` SET groupType = ? WHERE guid = ?", CONNECTION_ASYNC);
495 PrepareStatement(CHAR_UPD_GROUP_MEMBER_SUBGROUP, "UPDATE group_member SET subgroup = ? WHERE memberGuid = ?", CONNECTION_ASYNC);
496 PrepareStatement(CHAR_UPD_GROUP_MEMBER_FLAG, "UPDATE group_member SET memberFlags = ? WHERE memberGuid = ?", CONNECTION_ASYNC);
497 PrepareStatement(CHAR_UPD_GROUP_DIFFICULTY, "UPDATE `groups` SET difficulty = ? WHERE guid = ?", CONNECTION_ASYNC);
498 PrepareStatement(CHAR_UPD_GROUP_RAID_DIFFICULTY, "UPDATE `groups` SET raidDifficulty = ? WHERE guid = ?", CONNECTION_ASYNC);
499 PrepareStatement(CHAR_UPD_GROUP_LEGACY_RAID_DIFFICULTY, "UPDATE `groups` SET legacyRaidDifficulty = ? WHERE guid = ?", CONNECTION_ASYNC);
500 PrepareStatement(CHAR_DEL_INVALID_SPELL_SPELLS, "DELETE FROM character_spell WHERE spell = ?", CONNECTION_ASYNC);
501 PrepareStatement(CHAR_UPD_DELETE_INFO, "UPDATE characters SET deleteInfos_Name = name, deleteInfos_Account = account, deleteDate = UNIX_TIMESTAMP(), name = '', account = 0 WHERE guid = ?", CONNECTION_ASYNC);
502 PrepareStatement(CHAR_UPD_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);
503 PrepareStatement(CHAR_UPD_ZONE, "UPDATE characters SET zone = ? WHERE guid = ?", CONNECTION_ASYNC);
504 PrepareStatement(CHAR_UPD_LEVEL, "UPDATE characters SET level = ?, xp = 0 WHERE guid = ?", CONNECTION_ASYNC);
505 PrepareStatement(CHAR_DEL_INVALID_ACHIEV_PROGRESS_CRITERIA, "DELETE FROM character_achievement_progress WHERE criteria = ?", CONNECTION_ASYNC);
506 PrepareStatement(CHAR_DEL_INVALID_ACHIEV_PROGRESS_CRITERIA_GUILD, "DELETE FROM guild_achievement_progress WHERE criteria = ?", CONNECTION_ASYNC);
507 PrepareStatement(CHAR_DEL_INVALID_ACHIEVMENT, "DELETE FROM character_achievement WHERE achievement = ?", CONNECTION_ASYNC);
508 PrepareStatement(CHAR_DEL_INVALID_PET_SPELL, "DELETE FROM pet_spell WHERE spell = ?", CONNECTION_ASYNC);
509 PrepareStatement(CHAR_UPD_CHAR_ONLINE, "UPDATE characters SET online = 1 WHERE guid = ?", CONNECTION_ASYNC);
510 PrepareStatement(CHAR_UPD_CHAR_NAME_AT_LOGIN, "UPDATE characters SET name = ?, at_login = ? WHERE guid = ?", CONNECTION_ASYNC);
511 PrepareStatement(CHAR_REP_WORLD_STATE, "REPLACE INTO world_state_value (Id, Value) VALUES (?, ?)", CONNECTION_ASYNC);
512 PrepareStatement(CHAR_REP_WORLD_VARIABLE, "REPLACE INTO world_variable (Id, Value) VALUES (?, ?)", CONNECTION_ASYNC);
513 PrepareStatement(CHAR_DEL_CHARACTER_SKILL, "DELETE FROM character_skills WHERE guid = ? AND skill = ?", CONNECTION_ASYNC);
514 PrepareStatement(CHAR_UPD_CHARACTER_SOCIAL_FLAGS, "UPDATE character_social SET flags = ? WHERE guid = ? AND friend = ?", CONNECTION_ASYNC);
515 PrepareStatement(CHAR_INS_CHARACTER_SOCIAL, "INSERT INTO character_social (guid, friend, flags) VALUES (?, ?, ?)", CONNECTION_ASYNC);
516 PrepareStatement(CHAR_DEL_CHARACTER_SOCIAL, "DELETE FROM character_social WHERE guid = ? AND friend = ?", CONNECTION_ASYNC);
517 PrepareStatement(CHAR_UPD_CHARACTER_SOCIAL_NOTE, "UPDATE character_social SET note = ? WHERE guid = ? AND friend = ?", CONNECTION_ASYNC);
518 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);
519 PrepareStatement(CHAR_UPD_CHARACTER_POSITION_BY_MAPID, "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 = ? AND map = ?", CONNECTION_ASYNC);
520 PrepareStatement(CHAR_SEL_CHARACTER_AURA_FROZEN, "SELECT characters.name, character_aura.remainTime FROM characters LEFT JOIN character_aura ON (characters.guid = character_aura.guid) WHERE character_aura.spell = 9454", CONNECTION_SYNCH);
521 PrepareStatement(CHAR_SEL_CHARACTER_ONLINE, "SELECT name, account, map, zone FROM characters WHERE online > 0", CONNECTION_SYNCH);
522 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_BOTH);
523 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);
524 PrepareStatement(CHAR_SEL_CHAR_DEL_INFO, "SELECT guid, deleteInfos_Name, deleteInfos_Account, deleteDate FROM characters WHERE deleteDate IS NOT NULL", CONNECTION_SYNCH);
525 PrepareStatement(CHAR_SEL_CHARS_BY_ACCOUNT_ID, "SELECT guid FROM characters WHERE account = ?", CONNECTION_SYNCH);
526 PrepareStatement(CHAR_SEL_CHAR_PINFO, "SELECT totaltime, level, money, account, race, class, map, zone, gender, health, playerFlags FROM characters WHERE guid = ?", CONNECTION_SYNCH);
527 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);
528 //0: lowGUID
529 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);
530 //0: lowGUID
531 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);
532 PrepareStatement(CHAR_SEL_CHAR_HOMEBIND, "SELECT mapId, zoneId, posX, posY, posZ, orientation FROM character_homebind WHERE guid = ?", CONNECTION_SYNCH);
533 PrepareStatement(CHAR_SEL_CHAR_GUID_NAME_BY_ACC, "SELECT guid, name, online FROM characters WHERE account = ?", CONNECTION_SYNCH);
534 PrepareStatement(CHAR_SEL_CHAR_CUSTOMIZE_INFO, "SELECT name, race, class, gender, at_login FROM characters WHERE guid = ?", CONNECTION_ASYNC);
535 PrepareStatement(CHAR_SEL_CHAR_RACE_OR_FACTION_CHANGE_INFOS, "SELECT at_login, knownTitles FROM characters WHERE guid = ?", CONNECTION_ASYNC);
536 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);
537 PrepareStatement(CHAR_SEL_CHAR_SOCIAL, "SELECT DISTINCT guid FROM character_social WHERE friend = ?", CONNECTION_SYNCH);
538 PrepareStatement(CHAR_SEL_CHAR_OLD_CHARS, "SELECT guid, deleteInfos_Account FROM characters WHERE deleteDate IS NOT NULL AND deleteDate < ?", CONNECTION_SYNCH);
539 PrepareStatement(CHAR_SEL_MAIL, "SELECT id, messageType, sender, receiver, subject, body, expire_time, deliver_time, money, cod, checked, stationery, mailTemplateId FROM mail WHERE receiver = ? ORDER BY id DESC", CONNECTION_ASYNC);
540 PrepareStatement(CHAR_DEL_CHAR_AURA_FROZEN, "DELETE FROM character_aura WHERE spell = 9454 AND guid = ?", CONNECTION_ASYNC);
541 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);
542 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);
543 PrepareStatement(CHAR_SEL_AUCTIONHOUSE_COUNT_ITEM,"SELECT COUNT(*) FROM auction_items ai INNER JOIN item_instance ii ON ii.guid = ai.itemGuid WHERE ii.itemEntry = ?", CONNECTION_SYNCH);
544 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);
545 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 "
546 "INNER JOIN character_inventory ci ON ci.guid = c.guid "
547 "INNER JOIN item_instance ii ON ii.guid = ci.item "
548 "LEFT JOIN character_inventory cb ON cb.item = ci.bag WHERE ii.itemEntry = ? LIMIT ?", CONNECTION_SYNCH);
549 PrepareStatement(CHAR_SEL_MAIL_ITEMS_BY_ENTRY, "SELECT mi.item_guid, m.sender, m.receiver, cs.account, cs.name, cr.account, cr.name "
550 "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 "
551 "INNER JOIN characters cs ON cs.guid = m.sender INNER JOIN characters cr ON cr.guid = m.receiver WHERE ii.itemEntry = ? LIMIT ?", CONNECTION_SYNCH);
552 PrepareStatement(CHAR_SEL_AUCTIONHOUSE_ITEM_BY_ENTRY, "SELECT ai.itemGuid, c.guid, c.account, c.name FROM auctionhouse ah INNER JOIN auction_items ai ON ah.id = ai.auctionId INNER JOIN characters c ON c.guid = ah.owner INNER JOIN item_instance ii ON ii.guid = ai.itemGuid WHERE ii.itemEntry = ? LIMIT ?", CONNECTION_SYNCH);
553 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);
554 PrepareStatement(CHAR_DEL_CHAR_ACHIEVEMENT, "DELETE FROM character_achievement WHERE guid = ?", CONNECTION_ASYNC);
555 PrepareStatement(CHAR_DEL_CHAR_ACHIEVEMENT_PROGRESS, "DELETE FROM character_achievement_progress WHERE guid = ?", CONNECTION_ASYNC);
556 PrepareStatement(CHAR_INS_CHAR_ACHIEVEMENT, "INSERT INTO character_achievement (guid, achievement, date) VALUES (?, ?, ?)", CONNECTION_ASYNC);
557 PrepareStatement(CHAR_DEL_CHAR_ACHIEVEMENT_PROGRESS_BY_CRITERIA, "DELETE FROM character_achievement_progress WHERE guid = ? AND criteria = ?", CONNECTION_ASYNC);
558 PrepareStatement(CHAR_INS_CHAR_ACHIEVEMENT_PROGRESS, "INSERT INTO character_achievement_progress (guid, criteria, counter, date) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
559 PrepareStatement(CHAR_DEL_CHAR_REPUTATION_BY_FACTION, "DELETE FROM character_reputation WHERE guid = ? AND faction = ?", CONNECTION_ASYNC);
560 PrepareStatement(CHAR_INS_CHAR_REPUTATION_BY_FACTION, "INSERT INTO character_reputation (guid, faction, standing, flags) VALUES (?, ?, ? , ?)", CONNECTION_ASYNC);
561 PrepareStatement(CHAR_DEL_ITEM_REFUND_INSTANCE, "DELETE FROM item_refund_instance WHERE item_guid = ?", CONNECTION_ASYNC);
562 PrepareStatement(CHAR_INS_ITEM_REFUND_INSTANCE, "INSERT INTO item_refund_instance (item_guid, player_guid, paidMoney, paidExtendedCost) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
563 PrepareStatement(CHAR_DEL_GROUP, "DELETE FROM `groups` WHERE guid = ?", CONNECTION_ASYNC);
564 PrepareStatement(CHAR_DEL_GROUP_MEMBER_ALL, "DELETE FROM group_member WHERE guid = ?", CONNECTION_ASYNC);
565 PrepareStatement(CHAR_INS_CHAR_GIFT, "INSERT INTO character_gifts (guid, item_guid, entry, flags) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
566 PrepareStatement(CHAR_DEL_MAIL_ITEM_BY_ID, "DELETE FROM mail_items WHERE mail_id = ?", CONNECTION_ASYNC);
567 PrepareStatement(CHAR_INS_PETITION, "INSERT INTO petition (ownerguid, petitionguid, name) VALUES (?, ?, ?)", CONNECTION_ASYNC);
568 PrepareStatement(CHAR_DEL_PETITION_BY_GUID, "DELETE FROM petition WHERE petitionguid = ?", CONNECTION_ASYNC);
569 PrepareStatement(CHAR_DEL_PETITION_SIGNATURE_BY_GUID, "DELETE FROM petition_sign WHERE petitionguid = ?", CONNECTION_ASYNC);
570 PrepareStatement(CHAR_DEL_CHAR_DECLINED_NAME, "DELETE FROM character_declinedname WHERE guid = ?", CONNECTION_ASYNC);
571 PrepareStatement(CHAR_INS_CHAR_DECLINED_NAME, "INSERT INTO character_declinedname (guid, genitive, dative, accusative, instrumental, prepositional) VALUES (?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
572 PrepareStatement(CHAR_UPD_CHAR_RACE, "UPDATE characters SET race = ?, extra_flags = extra_flags | ? WHERE guid = ?", CONNECTION_ASYNC);
573 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);
574 PrepareStatement(CHAR_INS_CHAR_SKILL_LANGUAGE, "INSERT INTO `character_skills` (guid, skill, value, max) VALUES (?, ?, 300, 300)", CONNECTION_ASYNC);
575 PrepareStatement(CHAR_UPD_CHAR_TAXI_PATH, "UPDATE characters SET taxi_path = '' WHERE guid = ?", CONNECTION_ASYNC);
576 PrepareStatement(CHAR_UPD_CHAR_TAXIMASK, "UPDATE characters SET taximask = ? WHERE guid = ?", CONNECTION_ASYNC);
577 PrepareStatement(CHAR_DEL_CHAR_QUESTSTATUS, "DELETE FROM character_queststatus WHERE guid = ?", CONNECTION_ASYNC);
578 PrepareStatement(CHAR_DEL_CHAR_QUESTSTATUS_OBJECTIVES, "DELETE FROM character_queststatus_objectives WHERE guid = ?", CONNECTION_ASYNC);
579 PrepareStatement(CHAR_DEL_CHAR_QUESTSTATUS_OBJECTIVES_CRITERIA, "DELETE FROM character_queststatus_objectives_criteria WHERE guid = ?", CONNECTION_ASYNC);
580 PrepareStatement(CHAR_DEL_CHAR_QUESTSTATUS_OBJECTIVES_CRITERIA_PROGRESS, "DELETE FROM character_queststatus_objectives_criteria_progress WHERE guid = ?", CONNECTION_ASYNC);
581 PrepareStatement(CHAR_DEL_CHAR_QUESTSTATUS_OBJECTIVES_CRITERIA_PROGRESS_BY_CRITERIA, "DELETE FROM character_queststatus_objectives_criteria_progress WHERE guid = ? AND criteriaId = ?", CONNECTION_ASYNC);
582 PrepareStatement(CHAR_DEL_CHAR_SOCIAL_BY_GUID, "DELETE FROM character_social WHERE guid = ?", CONNECTION_ASYNC);
583 PrepareStatement(CHAR_DEL_CHAR_SOCIAL_BY_FRIEND, "DELETE FROM character_social WHERE friend = ?", CONNECTION_ASYNC);
584 PrepareStatement(CHAR_DEL_CHAR_ACHIEVEMENT_BY_ACHIEVEMENT, "DELETE FROM character_achievement WHERE achievement = ? AND guid = ?", CONNECTION_ASYNC);
585 PrepareStatement(CHAR_UPD_CHAR_ACHIEVEMENT, "UPDATE character_achievement SET achievement = ? where achievement = ? AND guid = ?", CONNECTION_ASYNC);
586 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);
587 PrepareStatement(CHAR_DEL_CHAR_SPELL_BY_SPELL, "DELETE FROM character_spell WHERE spell = ? AND guid = ?", CONNECTION_ASYNC);
588 PrepareStatement(CHAR_UPD_CHAR_SPELL_FACTION_CHANGE, "UPDATE character_spell SET spell = ? where spell = ? AND guid = ?", CONNECTION_ASYNC);
589 PrepareStatement(CHAR_SEL_CHAR_REP_BY_FACTION, "SELECT standing FROM character_reputation WHERE faction = ? AND guid = ?", CONNECTION_SYNCH);
590 PrepareStatement(CHAR_DEL_CHAR_REP_BY_FACTION, "DELETE FROM character_reputation WHERE faction = ? AND guid = ?", CONNECTION_ASYNC);
591 PrepareStatement(CHAR_UPD_CHAR_REP_FACTION_CHANGE, "UPDATE character_reputation SET faction = ?, standing = ? WHERE faction = ? AND guid = ?", CONNECTION_ASYNC);
592 PrepareStatement(CHAR_UPD_CHAR_TITLES_FACTION_CHANGE, "UPDATE characters SET knownTitles = ? WHERE guid = ?", CONNECTION_ASYNC);
593 PrepareStatement(CHAR_RES_CHAR_TITLES_FACTION_CHANGE, "UPDATE characters SET chosenTitle = 0 WHERE guid = ?", CONNECTION_ASYNC);
594 PrepareStatement(CHAR_DEL_CHAR_SPELL_COOLDOWNS, "DELETE FROM character_spell_cooldown WHERE guid = ?", CONNECTION_ASYNC);
595 PrepareStatement(CHAR_INS_CHAR_SPELL_COOLDOWN, "INSERT INTO character_spell_cooldown (guid, spell, item, time, categoryId, categoryEnd) VALUES (?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
596 PrepareStatement(CHAR_DEL_CHAR_SPELL_CHARGES, "DELETE FROM character_spell_charges WHERE guid = ?", CONNECTION_ASYNC);
597 PrepareStatement(CHAR_INS_CHAR_SPELL_CHARGES, "INSERT INTO character_spell_charges (guid, categoryId, rechargeStart, rechargeEnd) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
598 PrepareStatement(CHAR_DEL_CHARACTER, "DELETE FROM characters WHERE guid = ?", CONNECTION_ASYNC);
599 PrepareStatement(CHAR_DEL_CHAR_ACTION, "DELETE FROM character_action WHERE guid = ?", CONNECTION_ASYNC);
600 PrepareStatement(CHAR_DEL_CHAR_AURA, "DELETE FROM character_aura WHERE guid = ?", CONNECTION_ASYNC);
601 PrepareStatement(CHAR_DEL_CHAR_AURA_EFFECT, "DELETE FROM character_aura_effect WHERE guid = ?", CONNECTION_ASYNC);
602 PrepareStatement(CHAR_DEL_CHAR_GIFT, "DELETE FROM character_gifts WHERE guid = ?", CONNECTION_ASYNC);
603 PrepareStatement(CHAR_DEL_CHAR_INVENTORY, "DELETE FROM character_inventory WHERE guid = ?", CONNECTION_ASYNC);
604 PrepareStatement(CHAR_DEL_CHAR_QUESTSTATUS_REWARDED, "DELETE FROM character_queststatus_rewarded WHERE guid = ?", CONNECTION_ASYNC);
605 PrepareStatement(CHAR_DEL_CHAR_REPUTATION, "DELETE FROM character_reputation WHERE guid = ?", CONNECTION_ASYNC);
606 PrepareStatement(CHAR_DEL_CHAR_SPELL, "DELETE FROM character_spell WHERE guid = ?", CONNECTION_ASYNC);
607 PrepareStatement(CHAR_DEL_MAIL, "DELETE FROM mail WHERE receiver = ?", CONNECTION_ASYNC);
608 PrepareStatement(CHAR_DEL_MAIL_ITEMS, "DELETE FROM mail_items WHERE receiver = ?", CONNECTION_ASYNC);
609 PrepareStatement(CHAR_DEL_CHAR_ACHIEVEMENTS, "DELETE FROM character_achievement WHERE guid = ? AND achievement NOT IN (456,457,458,459,460,461,462,463,464,465,466,467,1400,1402,1404,1405,1406,1407,1408,1409,1410,1411,1412,1413,1414,1415,1416,1417,1418,1419,1420,1421,1422,1423,1424,1425,1426,1427,1463,3117,3259,4078,4576,4998,4999,5000,5001,5002,5003,5004,5005,5006,5007,5008,5381,5382,5383,5384,5385,5386,5387,5388,5389,5390,5391,5392,5393,5394,5395,5396,6433,6523,6524,6743,6744,6745,6746,6747,6748,6749,6750,6751,6752,6829,6859,6860,6861,6862,6863,6864,6865,6866,6867,6868,6869,6870,6871,6872,6873)", CONNECTION_ASYNC);
610 PrepareStatement(CHAR_DEL_CHAR_EQUIPMENTSETS, "DELETE FROM character_equipmentsets WHERE guid = ?", CONNECTION_ASYNC);
611 PrepareStatement(CHAR_DEL_CHAR_TRANSMOG_OUTFITS, "DELETE FROM character_transmog_outfits WHERE guid = ?", CONNECTION_ASYNC);
612 PrepareStatement(CHAR_DEL_GUILD_EVENTLOG_BY_PLAYER, "DELETE FROM guild_eventlog WHERE PlayerGuid1 = ? OR PlayerGuid2 = ?", CONNECTION_ASYNC);
613 PrepareStatement(CHAR_DEL_GUILD_BANK_EVENTLOG_BY_PLAYER, "DELETE FROM guild_bank_eventlog WHERE PlayerGuid = ?", CONNECTION_ASYNC);
614 PrepareStatement(CHAR_DEL_CHAR_GLYPHS, "DELETE FROM character_glyphs WHERE guid = ?", CONNECTION_ASYNC);
615 PrepareStatement(CHAR_DEL_CHAR_TALENT, "DELETE FROM character_talent WHERE guid = ?", CONNECTION_ASYNC);
616 PrepareStatement(CHAR_DEL_CHAR_PVP_TALENT, "DELETE FROM character_pvp_talent WHERE guid = ?", CONNECTION_ASYNC);
617 PrepareStatement(CHAR_DEL_CHAR_SKILLS, "DELETE FROM character_skills WHERE guid = ?", CONNECTION_ASYNC);
618 PrepareStatement(CHAR_UPD_CHAR_MONEY, "UPDATE characters SET money = ? WHERE guid = ?", CONNECTION_ASYNC);
619 PrepareStatement(CHAR_INS_CHAR_ACTION, "INSERT INTO character_action (guid, spec, traitConfigId, button, action, type) VALUES (?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
620 PrepareStatement(CHAR_UPD_CHAR_ACTION, "UPDATE character_action SET action = ?, type = ? WHERE guid = ? AND button = ? AND spec = ? AND traitConfigId = ?", CONNECTION_ASYNC);
621 PrepareStatement(CHAR_DEL_CHAR_ACTION_BY_BUTTON_SPEC, "DELETE FROM character_action WHERE guid = ? and button = ? and spec = ? AND traitConfigId = ?", CONNECTION_ASYNC);
622 PrepareStatement(CHAR_DEL_CHAR_ACTION_BY_TRAIT_CONFIG, "DELETE FROM character_action WHERE guid = ? AND traitConfigId = ?", CONNECTION_ASYNC);
623 PrepareStatement(CHAR_DEL_CHAR_INVENTORY_BY_ITEM, "DELETE FROM character_inventory WHERE item = ?", CONNECTION_ASYNC);
624 PrepareStatement(CHAR_DEL_CHAR_INVENTORY_BY_BAG_SLOT, "DELETE FROM character_inventory WHERE bag = ? AND slot = ? AND guid = ?", CONNECTION_ASYNC);
625 PrepareStatement(CHAR_UPD_MAIL, "UPDATE mail SET has_items = ?, expire_time = ?, deliver_time = ?, money = ?, cod = ?, checked = ? WHERE id = ?", CONNECTION_ASYNC);
626 PrepareStatement(CHAR_REP_CHAR_QUESTSTATUS, "REPLACE INTO character_queststatus (guid, quest, status, explored, acceptTime, endTime) VALUES (?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
627 PrepareStatement(CHAR_DEL_CHAR_QUESTSTATUS_BY_QUEST, "DELETE FROM character_queststatus WHERE guid = ? AND quest = ?", CONNECTION_ASYNC);
628 PrepareStatement(CHAR_REP_CHAR_QUESTSTATUS_OBJECTIVES, "REPLACE INTO character_queststatus_objectives (guid, quest, objective, data) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
629 PrepareStatement(CHAR_DEL_CHAR_QUESTSTATUS_OBJECTIVES_BY_QUEST, "DELETE FROM character_queststatus_objectives WHERE guid = ? AND quest = ?", CONNECTION_ASYNC);
630 PrepareStatement(CHAR_INS_CHAR_QUESTSTATUS_OBJECTIVES_CRITERIA, "INSERT INTO character_queststatus_objectives_criteria (guid, questObjectiveId) VALUES (?, ?)", CONNECTION_ASYNC);
631 PrepareStatement(CHAR_INS_CHAR_QUESTSTATUS_OBJECTIVES_CRITERIA_PROGRESS, "INSERT INTO character_queststatus_objectives_criteria_progress (guid, criteriaId, counter, date) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
632 PrepareStatement(CHAR_INS_CHAR_QUESTSTATUS_REWARDED, "INSERT IGNORE INTO character_queststatus_rewarded (guid, quest, active) VALUES (?, ?, 1)", CONNECTION_ASYNC);
633 PrepareStatement(CHAR_DEL_CHAR_QUESTSTATUS_REWARDED_BY_QUEST, "DELETE FROM character_queststatus_rewarded WHERE guid = ? AND quest = ?", CONNECTION_ASYNC);
634 PrepareStatement(CHAR_UPD_CHAR_QUESTSTATUS_REWARDED_FACTION_CHANGE, "UPDATE character_queststatus_rewarded SET quest = ? WHERE quest = ? AND guid = ?", CONNECTION_ASYNC);
635 PrepareStatement(CHAR_UPD_CHAR_QUESTSTATUS_REWARDED_ACTIVE, "UPDATE character_queststatus_rewarded SET active = 1 WHERE guid = ?", CONNECTION_ASYNC);
636 PrepareStatement(CHAR_UPD_CHAR_QUESTSTATUS_REWARDED_ACTIVE_BY_QUEST, "UPDATE character_queststatus_rewarded SET active = 0 WHERE quest = ? AND guid = ?", CONNECTION_ASYNC);
637 PrepareStatement(CHAR_DEL_INVALID_QUEST_PROGRESS_CRITERIA, "DELETE FROM character_queststatus_objectives_criteria WHERE questObjectiveId = ?", CONNECTION_ASYNC);
638 PrepareStatement(CHAR_DEL_CHAR_SKILL_BY_SKILL, "DELETE FROM character_skills WHERE guid = ? AND skill = ?", CONNECTION_ASYNC);
639 PrepareStatement(CHAR_INS_CHAR_SKILLS, "INSERT INTO character_skills (guid, skill, value, max, professionSlot) VALUES (?, ?, ?, ?, ?)", CONNECTION_ASYNC);
640 PrepareStatement(CHAR_UPD_CHAR_SKILLS, "UPDATE character_skills SET value = ?, max = ?, professionSlot = ? WHERE guid = ? AND skill = ?", CONNECTION_ASYNC);
641 PrepareStatement(CHAR_INS_CHAR_SPELL, "INSERT INTO character_spell (guid, spell, active, disabled) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
642 PrepareStatement(CHAR_DEL_CHAR_SPELL_FAVORITE, "DELETE FROM character_spell_favorite WHERE guid = ? AND spell = ?", CONNECTION_ASYNC);
643 PrepareStatement(CHAR_DEL_CHAR_SPELL_FAVORITE_BY_CHAR, "DELETE FROM character_spell_favorite WHERE guid = ?", CONNECTION_ASYNC);
644 PrepareStatement(CHAR_INS_CHAR_SPELL_FAVORITE, "INSERT INTO character_spell_favorite (guid, spell) VALUES (?, ?)", CONNECTION_ASYNC);
645 PrepareStatement(CHAR_DEL_CHAR_STATS, "DELETE FROM character_stats WHERE guid = ?", CONNECTION_ASYNC);
646 PrepareStatement(CHAR_INS_CHAR_STATS, "INSERT INTO character_stats (guid, maxhealth, maxpower1, maxpower2, maxpower3, maxpower4, maxpower5, maxpower6, maxpower7, strength, agility, stamina, intellect, "
647 "armor, resHoly, resFire, resNature, resFrost, resShadow, resArcane, blockPct, dodgePct, parryPct, critPct, rangedCritPct, spellCritPct, attackPower, rangedAttackPower, "
648 "spellPower, resilience) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
649 PrepareStatement(CHAR_DEL_PETITION_BY_OWNER, "DELETE FROM petition WHERE ownerguid = ?", CONNECTION_ASYNC);
650 PrepareStatement(CHAR_DEL_PETITION_SIGNATURE_BY_OWNER, "DELETE FROM petition_sign WHERE ownerguid = ?", CONNECTION_ASYNC);
651 PrepareStatement(CHAR_INS_CHAR_GLYPHS, "INSERT INTO character_glyphs VALUES(?, ?, ?)", CONNECTION_ASYNC);
652 PrepareStatement(CHAR_INS_CHAR_TALENT, "INSERT INTO character_talent (guid, talentId, talentGroup) VALUES (?, ?, ?)", CONNECTION_ASYNC);
653 PrepareStatement(CHAR_INS_CHAR_PVP_TALENT, "INSERT INTO character_pvp_talent (guid, talentId0, talentId1, talentId2, talentId3, talentGroup) VALUES (?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
654 PrepareStatement(CHAR_UPD_CHAR_LIST_SLOT, "UPDATE characters SET slot = ? WHERE guid = ? AND account = ?", CONNECTION_ASYNC);
655 PrepareStatement(CHAR_INS_CHAR_FISHINGSTEPS, "INSERT INTO character_fishingsteps (guid, fishingSteps) VALUES (?, ?)", CONNECTION_ASYNC);
656 PrepareStatement(CHAR_DEL_CHAR_FISHINGSTEPS, "DELETE FROM character_fishingsteps WHERE guid = ?", CONNECTION_ASYNC);
657 PrepareStatement(CHAR_SEL_CHAR_TRAIT_ENTRIES, "SELECT traitConfigId, traitNodeId, traitNodeEntryId, `rank`, grantedRanks FROM character_trait_entry WHERE guid = ?", CONNECTION_ASYNC);
658 PrepareStatement(CHAR_INS_CHAR_TRAIT_ENTRIES, "INSERT INTO character_trait_entry (guid, traitConfigId, traitNodeId, traitNodeEntryId, `rank`, grantedRanks) VALUES (?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
659 PrepareStatement(CHAR_DEL_CHAR_TRAIT_ENTRIES, "DELETE FROM character_trait_entry WHERE guid = ? AND traitConfigId = ?", CONNECTION_ASYNC);
660 PrepareStatement(CHAR_DEL_CHAR_TRAIT_ENTRIES_BY_CHAR, "DELETE FROM character_trait_entry WHERE guid = ?", CONNECTION_ASYNC);
661 PrepareStatement(CHAR_SEL_CHAR_TRAIT_CONFIGS, "SELECT traitConfigId, type, chrSpecializationId, combatConfigFlags, localIdentifier, skillLineId, traitSystemId, `name` FROM character_trait_config WHERE guid = ?", CONNECTION_ASYNC);
662 PrepareStatement(CHAR_INS_CHAR_TRAIT_CONFIGS, "INSERT INTO character_trait_config (guid, traitConfigId, type, chrSpecializationId, combatConfigFlags, localIdentifier, skillLineId, traitSystemId, `name`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
663 PrepareStatement(CHAR_DEL_CHAR_TRAIT_CONFIGS, "DELETE FROM character_trait_config WHERE guid = ? AND traitConfigId = ?", CONNECTION_ASYNC);
664 PrepareStatement(CHAR_DEL_CHAR_TRAIT_CONFIGS_BY_CHAR, "DELETE FROM character_trait_config WHERE guid = ?", CONNECTION_ASYNC);
665
666 // Void Storage
667 PrepareStatement(CHAR_SEL_CHAR_VOID_STORAGE, "SELECT itemId, itemEntry, slot, creatorGuid, randomBonusListId, fixedScalingLevel, artifactKnowledgeLevel, context, bonusListIDs FROM character_void_storage WHERE playerGuid = ?", CONNECTION_ASYNC);
668 PrepareStatement(CHAR_REP_CHAR_VOID_STORAGE_ITEM, "REPLACE INTO character_void_storage (itemId, playerGuid, itemEntry, slot, creatorGuid, randomBonusListId, fixedScalingLevel, artifactKnowledgeLevel, context, bonusListIDs) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
669 PrepareStatement(CHAR_DEL_CHAR_VOID_STORAGE_ITEM_BY_CHAR_GUID, "DELETE FROM character_void_storage WHERE playerGuid = ?", CONNECTION_ASYNC);
670 PrepareStatement(CHAR_DEL_CHAR_VOID_STORAGE_ITEM_BY_SLOT, "DELETE FROM character_void_storage WHERE slot = ? AND playerGuid = ?", CONNECTION_ASYNC);
671
672 // CompactUnitFrame profiles
673 PrepareStatement(CHAR_SEL_CHAR_CUF_PROFILES, "SELECT id, name, frameHeight, frameWidth, sortBy, healthText, boolOptions, topPoint, bottomPoint, leftPoint, topOffset, bottomOffset, leftOffset FROM character_cuf_profiles WHERE guid = ?", CONNECTION_ASYNC);
674 PrepareStatement(CHAR_REP_CHAR_CUF_PROFILES, "REPLACE INTO character_cuf_profiles (guid, id, name, frameHeight, frameWidth, sortBy, healthText, boolOptions, topPoint, bottomPoint, leftPoint, topOffset, bottomOffset, leftOffset) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
675 PrepareStatement(CHAR_DEL_CHAR_CUF_PROFILES_BY_ID, "DELETE FROM character_cuf_profiles WHERE guid = ? AND id = ?", CONNECTION_ASYNC);
676 PrepareStatement(CHAR_DEL_CHAR_CUF_PROFILES, "DELETE FROM character_cuf_profiles WHERE guid = ?", CONNECTION_ASYNC);
677
678 // Items that hold loot or money
679 PrepareStatement(CHAR_SEL_ITEMCONTAINER_ITEMS, "SELECT container_id, item_id, item_count, item_index, follow_rules, ffa, blocked, counted, under_threshold, needs_quest, rnd_bonus, context, bonus_list_ids FROM item_loot_items", CONNECTION_SYNCH);
680 PrepareStatement(CHAR_DEL_ITEMCONTAINER_ITEMS, "DELETE FROM item_loot_items WHERE container_id = ?", CONNECTION_ASYNC);
681 PrepareStatement(CHAR_DEL_ITEMCONTAINER_ITEM, "DELETE FROM item_loot_items WHERE container_id = ? AND item_id = ? AND item_count = ? AND item_index = ?", CONNECTION_ASYNC);
682 PrepareStatement(CHAR_INS_ITEMCONTAINER_ITEMS, "INSERT INTO item_loot_items (container_id, item_id, item_count, item_index, follow_rules, ffa, blocked, counted, under_threshold, needs_quest, rnd_bonus, context, bonus_list_ids) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
683 PrepareStatement(CHAR_SEL_ITEMCONTAINER_MONEY, "SELECT container_id, money FROM item_loot_money", CONNECTION_SYNCH);
684 PrepareStatement(CHAR_DEL_ITEMCONTAINER_MONEY, "DELETE FROM item_loot_money WHERE container_id = ?", CONNECTION_ASYNC);
685 PrepareStatement(CHAR_INS_ITEMCONTAINER_MONEY, "INSERT INTO item_loot_money (container_id, money) VALUES (?, ?)", CONNECTION_ASYNC);
686
687 // Calendar
688 PrepareStatement(CHAR_REP_CALENDAR_EVENT, "REPLACE INTO calendar_events (EventID, Owner, Title, Description, EventType, TextureID, Date, Flags, LockDate) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
689 PrepareStatement(CHAR_DEL_CALENDAR_EVENT, "DELETE FROM calendar_events WHERE EventID = ?", CONNECTION_ASYNC);
690 PrepareStatement(CHAR_REP_CALENDAR_INVITE, "REPLACE INTO calendar_invites (InviteID, EventID, Invitee, Sender, Status, ResponseTime, ModerationRank, Note) VALUES (?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
691 PrepareStatement(CHAR_DEL_CALENDAR_INVITE, "DELETE FROM calendar_invites WHERE InviteID = ?", CONNECTION_ASYNC);
692
693 // Pet
694 PrepareStatement(CHAR_SEL_CHAR_PET_IDS, "SELECT id FROM character_pet WHERE owner = ?", CONNECTION_SYNCH);
695 PrepareStatement(CHAR_DEL_CHAR_PET_DECLINEDNAME_BY_OWNER, "DELETE FROM character_pet_declinedname WHERE owner = ?", CONNECTION_ASYNC);
696 PrepareStatement(CHAR_DEL_CHAR_PET_DECLINEDNAME, "DELETE FROM character_pet_declinedname WHERE id = ?", CONNECTION_ASYNC);
697 PrepareStatement(CHAR_INS_CHAR_PET_DECLINEDNAME, "INSERT INTO character_pet_declinedname (id, owner, genitive, dative, accusative, instrumental, prepositional) VALUES (?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
698 PrepareStatement(CHAR_SEL_PET_AURA, "SELECT casterGuid, spell, effectMask, recalculateMask, difficulty, stackCount, maxDuration, remainTime, remainCharges FROM pet_aura WHERE guid = ?", CONNECTION_ASYNC);
699 PrepareStatement(CHAR_SEL_PET_AURA_EFFECT, "SELECT casterGuid, spell, effectMask, effectIndex, amount, baseAmount FROM pet_aura_effect WHERE guid = ?", CONNECTION_ASYNC);
700 PrepareStatement(CHAR_SEL_PET_SPELL, "SELECT spell, active FROM pet_spell WHERE guid = ?", CONNECTION_ASYNC);
701 PrepareStatement(CHAR_SEL_PET_SPELL_COOLDOWN, "SELECT spell, time, categoryId, categoryEnd FROM pet_spell_cooldown WHERE guid = ? AND time > UNIX_TIMESTAMP()", CONNECTION_ASYNC);
702 PrepareStatement(CHAR_SEL_PET_DECLINED_NAME, "SELECT genitive, dative, accusative, instrumental, prepositional FROM character_pet_declinedname WHERE owner = ? AND id = ?", CONNECTION_ASYNC);
703 PrepareStatement(CHAR_DEL_PET_AURAS, "DELETE FROM pet_aura WHERE guid = ?", CONNECTION_BOTH);
704 PrepareStatement(CHAR_DEL_PET_AURA_EFFECTS, "DELETE FROM pet_aura_effect WHERE guid = ?", CONNECTION_BOTH);
705 PrepareStatement(CHAR_DEL_PET_SPELLS, "DELETE FROM pet_spell WHERE guid = ?", CONNECTION_ASYNC);
706 PrepareStatement(CHAR_DEL_PET_SPELL_COOLDOWNS, "DELETE FROM pet_spell_cooldown WHERE guid = ?", CONNECTION_BOTH);
707 PrepareStatement(CHAR_INS_PET_SPELL_COOLDOWN, "INSERT INTO pet_spell_cooldown (guid, spell, time, categoryId, categoryEnd) VALUES (?, ?, ?, ?, ?)", CONNECTION_BOTH);
708 PrepareStatement(CHAR_SEL_PET_SPELL_CHARGES, "SELECT categoryId, rechargeStart, rechargeEnd FROM pet_spell_charges WHERE guid = ? AND rechargeEnd > UNIX_TIMESTAMP() ORDER BY rechargeEnd", CONNECTION_ASYNC);
709 PrepareStatement(CHAR_DEL_PET_SPELL_CHARGES, "DELETE FROM pet_spell_charges WHERE guid = ?", CONNECTION_ASYNC);
710 PrepareStatement(CHAR_INS_PET_SPELL_CHARGES, "INSERT INTO pet_spell_charges (guid, categoryId, rechargeStart, rechargeEnd) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
711 PrepareStatement(CHAR_DEL_PET_SPELL_BY_SPELL, "DELETE FROM pet_spell WHERE guid = ? and spell = ?", CONNECTION_ASYNC);
712 PrepareStatement(CHAR_INS_PET_SPELL, "INSERT INTO pet_spell (guid, spell, active) VALUES (?, ?, ?)", CONNECTION_BOTH);
713 PrepareStatement(CHAR_INS_PET_AURA, "INSERT INTO pet_aura (guid, casterGuid, spell, effectMask, recalculateMask, difficulty, stackCount, maxDuration, remainTime, remainCharges) "
714 "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_BOTH);
715 PrepareStatement(CHAR_INS_PET_AURA_EFFECT, "INSERT INTO pet_aura_effect (guid, casterGuid, spell, effectMask, effectIndex, amount, baseAmount) "
716 "VALUES (?, ?, ?, ?, ?, ?, ?)", CONNECTION_BOTH);
717 PrepareStatement(CHAR_SEL_CHAR_PETS, "SELECT id, entry, modelid, level, exp, Reactstate, slot, name, renamed, curhealth, curmana, abdata, savetime, CreatedBySpell, PetType, specialization FROM character_pet WHERE owner = ?", CONNECTION_ASYNC);
718 PrepareStatement(CHAR_DEL_CHAR_PET_BY_OWNER, "DELETE FROM character_pet WHERE owner = ?", CONNECTION_ASYNC);
719 PrepareStatement(CHAR_UPD_CHAR_PET_NAME, "UPDATE character_pet SET name = ?, renamed = 1 WHERE owner = ? AND id = ?", CONNECTION_ASYNC);
720 PrepareStatement(CHAR_UPD_CHAR_PET_SLOT_BY_ID, "UPDATE character_pet SET slot = ? WHERE owner = ? AND id = ?", CONNECTION_ASYNC);
721 PrepareStatement(CHAR_DEL_CHAR_PET_BY_ID, "DELETE FROM character_pet WHERE id = ?", CONNECTION_ASYNC);
722 PrepareStatement(CHAR_DEL_ALL_PET_SPELLS_BY_OWNER, "DELETE FROM pet_spell WHERE guid in (SELECT id FROM character_pet WHERE owner=?)", CONNECTION_ASYNC);
723 PrepareStatement(CHAR_UPD_PET_SPECS_BY_OWNER, "UPDATE character_pet SET specialization = 0 WHERE owner=?", CONNECTION_ASYNC);
724 PrepareStatement(CHAR_INS_PET, "INSERT INTO character_pet (id, entry, owner, modelid, level, exp, Reactstate, slot, name, renamed, curhealth, curmana, abdata, savetime, CreatedBySpell, PetType, specialization) "
725 "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
726
727 // PvPstats
728 PrepareStatement(CHAR_SEL_PVPSTATS_MAXID, "SELECT MAX(id) FROM pvpstats_battlegrounds", CONNECTION_SYNCH);
729 PrepareStatement(CHAR_INS_PVPSTATS_BATTLEGROUND, "INSERT INTO pvpstats_battlegrounds (id, winner_faction, bracket_id, type, date) VALUES (?, ?, ?, ?, NOW())", CONNECTION_ASYNC);
730 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);
731 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);
732
733 // QuestTracker
734 PrepareStatement(CHAR_INS_QUEST_TRACK, "INSERT INTO quest_tracker (id, character_guid, quest_accept_time, core_hash, core_revision) VALUES (?, ?, NOW(), ?, ?)", CONNECTION_ASYNC);
735 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);
736 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);
737 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);
738
739 // Garrison
740 PrepareStatement(CHAR_SEL_CHARACTER_GARRISON, "SELECT siteLevelId, followerActivationsRemainingToday FROM character_garrison WHERE guid = ?", CONNECTION_ASYNC);
741 PrepareStatement(CHAR_INS_CHARACTER_GARRISON, "INSERT INTO character_garrison (guid, siteLevelId, followerActivationsRemainingToday) VALUES (?, ?, ?)", CONNECTION_ASYNC);
742 PrepareStatement(CHAR_DEL_CHARACTER_GARRISON, "DELETE FROM character_garrison WHERE guid = ?", CONNECTION_ASYNC);
743 PrepareStatement(CHAR_UPD_CHARACTER_GARRISON_FOLLOWER_ACTIVATIONS, "UPDATE character_garrison SET followerActivationsRemainingToday = ?", CONNECTION_ASYNC);
744 PrepareStatement(CHAR_SEL_CHARACTER_GARRISON_BLUEPRINTS, "SELECT buildingId FROM character_garrison_blueprints WHERE guid = ?", CONNECTION_ASYNC);
745 PrepareStatement(CHAR_INS_CHARACTER_GARRISON_BLUEPRINTS, "INSERT INTO character_garrison_blueprints (guid, buildingId) VALUES (?, ?)", CONNECTION_ASYNC);
746 PrepareStatement(CHAR_DEL_CHARACTER_GARRISON_BLUEPRINTS, "DELETE FROM character_garrison_blueprints WHERE guid = ?", CONNECTION_ASYNC);
747 PrepareStatement(CHAR_SEL_CHARACTER_GARRISON_BUILDINGS, "SELECT plotInstanceId, buildingId, timeBuilt, active FROM character_garrison_buildings WHERE guid = ?", CONNECTION_ASYNC);
748 PrepareStatement(CHAR_INS_CHARACTER_GARRISON_BUILDINGS, "INSERT INTO character_garrison_buildings (guid, plotInstanceId, buildingId, timeBuilt, active) VALUES (?, ?, ?, ?, ?)", CONNECTION_ASYNC);
749 PrepareStatement(CHAR_DEL_CHARACTER_GARRISON_BUILDINGS, "DELETE FROM character_garrison_buildings WHERE guid = ?", CONNECTION_ASYNC);
750 PrepareStatement(CHAR_SEL_CHARACTER_GARRISON_FOLLOWERS, "SELECT dbId, followerId, quality, level, itemLevelWeapon, itemLevelArmor, xp, currentBuilding, currentMission, status FROM character_garrison_followers WHERE guid = ?", CONNECTION_ASYNC);
751 PrepareStatement(CHAR_INS_CHARACTER_GARRISON_FOLLOWERS, "INSERT INTO character_garrison_followers (dbId, guid, followerId, quality, level, itemLevelWeapon, itemLevelArmor, xp, currentBuilding, currentMission, status) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
752 PrepareStatement(CHAR_DEL_CHARACTER_GARRISON_FOLLOWERS, "DELETE gfab, gf FROM character_garrison_follower_abilities gfab INNER JOIN character_garrison_followers gf ON gfab.dbId = gf.dbId WHERE gf.guid = ?", CONNECTION_ASYNC);
753 PrepareStatement(CHAR_SEL_CHARACTER_GARRISON_FOLLOWER_ABILITIES, "SELECT gfab.dbId, gfab.abilityId FROM character_garrison_follower_abilities gfab INNER JOIN character_garrison_followers gf ON gfab.dbId = gf.dbId WHERE guid = ? ORDER BY gfab.slot", CONNECTION_ASYNC);
754 PrepareStatement(CHAR_INS_CHARACTER_GARRISON_FOLLOWER_ABILITIES, "INSERT INTO character_garrison_follower_abilities (dbId, abilityId, slot) VALUES (?, ?, ?)", CONNECTION_ASYNC);
755
756 // Black Market
757 PrepareStatement(CHAR_SEL_BLACKMARKET_AUCTIONS, "SELECT marketId, currentBid, time, numBids, bidder FROM blackmarket_auctions", CONNECTION_SYNCH);
758 PrepareStatement(CHAR_DEL_BLACKMARKET_AUCTIONS, "DELETE FROM blackmarket_auctions WHERE marketId = ?", CONNECTION_ASYNC);
759 PrepareStatement(CHAR_UPD_BLACKMARKET_AUCTIONS, "UPDATE blackmarket_auctions SET currentBid = ?, time = ?, numBids = ?, bidder = ? WHERE marketId = ?", CONNECTION_ASYNC);
760 PrepareStatement(CHAR_INS_BLACKMARKET_AUCTIONS, "INSERT INTO blackmarket_auctions (marketId, currentBid, time, numBids, bidder) VALUES (?, ?, ?, ? ,?)", CONNECTION_ASYNC);
761
762 // Spell Location
763 PrepareStatement(CHAR_SEL_CHARACTER_AURA_STORED_LOCATIONS, "SELECT Spell, MapId, PositionX, PositionY, PositionZ, Orientation FROM character_aura_stored_location WHERE Guid = ?", CONNECTION_ASYNC);
764 PrepareStatement(CHAR_DEL_CHARACTER_AURA_STORED_LOCATIONS_BY_GUID, "DELETE FROM character_aura_stored_location WHERE Guid = ?", CONNECTION_ASYNC);
765 PrepareStatement(CHAR_DEL_CHARACTER_AURA_STORED_LOCATION, "DELETE FROM character_aura_stored_location WHERE Guid = ? AND Spell = ?", CONNECTION_ASYNC);
766 PrepareStatement(CHAR_INS_CHARACTER_AURA_STORED_LOCATION, "INSERT INTO character_aura_stored_location (Guid, Spell, MapId, PositionX, PositionY, PositionZ, Orientation) "
767 "VALUES (?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
768
769 // War mode
770 PrepareStatement(CHAR_SEL_WAR_MODE_TUNING, "SELECT race, COUNT(guid) FROM characters WHERE ((playerFlags & ?) = ?) AND logout_time >= (UNIX_TIMESTAMP() - 604800) GROUP BY race", CONNECTION_SYNCH);
771
772 // Instance locks
773 PrepareStatement(CHAR_DEL_CHARACTER_INSTANCE_LOCK, "DELETE FROM character_instance_lock WHERE guid = ? AND mapId = ? AND lockId = ?", CONNECTION_ASYNC);
774 PrepareStatement(CHAR_DEL_CHARACTER_INSTANCE_LOCK_BY_GUID, "DELETE FROM character_instance_lock WHERE guid = ?", CONNECTION_ASYNC);
775 PrepareStatement(CHAR_INS_CHARACTER_INSTANCE_LOCK, "INSERT INTO character_instance_lock (guid, mapId, lockId, instanceId, difficulty, data, completedEncountersMask, entranceWorldSafeLocId, expiryTime, extended) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
776 PrepareStatement(CHAR_UPD_CHARACTER_INSTANCE_LOCK_EXTENSION, "UPDATE character_instance_lock SET extended = ? WHERE guid = ? AND mapId = ? AND lockId = ?", CONNECTION_ASYNC);
777 PrepareStatement(CHAR_UPD_CHARACTER_INSTANCE_LOCK_FORCE_EXPIRE, "UPDATE character_instance_lock SET expiryTime = ?, extended = 0 WHERE guid = ? AND mapId = ? AND lockId = ?", CONNECTION_ASYNC);
778 PrepareStatement(CHAR_DEL_INSTANCE, "DELETE FROM instance WHERE instanceId = ?", CONNECTION_ASYNC);
779 PrepareStatement(CHAR_INS_INSTANCE, "INSERT INTO instance (instanceId, data, completedEncountersMask, entranceWorldSafeLocId) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
780}
SelectItemInstanceContent
#define SelectItemInstanceContent
CHAR_SEL_CORPSE_CUSTOMIZATIONS
@ CHAR_SEL_CORPSE_CUSTOMIZATIONS
Definition: CharacterDatabase.h:334
CHAR_INS_TUTORIALS
@ CHAR_INS_TUTORIALS
Definition: CharacterDatabase.h:288
CHAR_DEL_CHAR_GLYPHS
@ CHAR_DEL_CHAR_GLYPHS
Definition: CharacterDatabase.h:498
CHAR_SEL_CHARACTER_GARRISON_BUILDINGS
@ CHAR_SEL_CHARACTER_GARRISON_BUILDINGS
Definition: CharacterDatabase.h:619
CHAR_SEL_CHAR_CUSTOMIZE_INFO
@ CHAR_SEL_CHAR_CUSTOMIZE_INFO
Definition: CharacterDatabase.h:423
CHAR_DEL_ITEM_INSTANCE_AZERITE_MILESTONE_POWER_BY_OWNER
@ CHAR_DEL_ITEM_INSTANCE_AZERITE_MILESTONE_POWER_BY_OWNER
Definition: CharacterDatabase.h:184
CHAR_DEL_CHAR_SOCIAL_BY_FRIEND
@ CHAR_DEL_CHAR_SOCIAL_BY_FRIEND
Definition: CharacterDatabase.h:467
CHAR_SEL_PINFO_XP
@ CHAR_SEL_PINFO_XP
Definition: CharacterDatabase.h:418
CHAR_UPD_TUTORIALS
@ CHAR_UPD_TUTORIALS
Definition: CharacterDatabase.h:289
CHAR_UPD_ITEM_INSTANCE
@ CHAR_UPD_ITEM_INSTANCE
Definition: CharacterDatabase.h:156
CHAR_INS_GUILD_MEMBER
@ CHAR_INS_GUILD_MEMBER
Definition: CharacterDatabase.h:208
CHAR_DEL_CHAR_GIFT
@ CHAR_DEL_CHAR_GIFT
Definition: CharacterDatabase.h:486
CHAR_SEL_CHAR_TRAIT_CONFIGS
@ CHAR_SEL_CHAR_TRAIT_CONFIGS
Definition: CharacterDatabase.h:543
CHAR_DEL_CHAR_PET_DECLINEDNAME_BY_OWNER
@ CHAR_DEL_CHAR_PET_DECLINEDNAME_BY_OWNER
Definition: CharacterDatabase.h:582
CHAR_DEL_CHANNEL
@ CHAR_DEL_CHANNEL
Definition: CharacterDatabase.h:261
CHAR_UPD_ITEM_INSTANCE_ON_LOAD
@ CHAR_UPD_ITEM_INSTANCE_ON_LOAD
Definition: CharacterDatabase.h:157
CHAR_SEL_CHAR_OLD_CHARS
@ CHAR_SEL_CHAR_OLD_CHARS
Definition: CharacterDatabase.h:427
CHAR_UPD_CHAR_INVENTORY_FACTION_CHANGE
@ CHAR_UPD_CHAR_INVENTORY_FACTION_CHANGE
Definition: CharacterDatabase.h:470
CHAR_SEL_CHECK_NAME
@ CHAR_SEL_CHECK_NAME
Definition: CharacterDatabase.h:35
CHAR_DEL_GUILD_BANK_EVENTLOG_BY_PLAYER
@ CHAR_DEL_GUILD_BANK_EVENTLOG_BY_PLAYER
Definition: CharacterDatabase.h:497
CHAR_UPD_MAIL
@ CHAR_UPD_MAIL
Definition: CharacterDatabase.h:509
CHAR_SEL_CHARACTER_PVP_TALENTS
@ CHAR_SEL_CHARACTER_PVP_TALENTS
Definition: CharacterDatabase.h:112
CHAR_UPD_CHANNEL
@ CHAR_UPD_CHANNEL
Definition: CharacterDatabase.h:258
CHAR_INS_PETITION_SIGNATURE
@ CHAR_INS_PETITION_SIGNATURE
Definition: CharacterDatabase.h:371
CHAR_SEL_CHAR_INVENTORY_ITEM_BY_ENTRY
@ CHAR_SEL_CHAR_INVENTORY_ITEM_BY_ENTRY
Definition: CharacterDatabase.h:434
CHAR_DEL_ITEM_INSTANCE_AZERITE_BY_OWNER
@ CHAR_DEL_ITEM_INSTANCE_AZERITE_BY_OWNER
Definition: CharacterDatabase.h:180
CHAR_UPD_GUILD_MOTD
@ CHAR_UPD_GUILD_MOTD
Definition: CharacterDatabase.h:233
CHAR_REP_CALENDAR_EVENT
@ CHAR_REP_CALENDAR_EVENT
Definition: CharacterDatabase.h:558
CHAR_DEL_CHARACTER_QUESTSTATUS_WEEKLY
@ CHAR_DEL_CHARACTER_QUESTSTATUS_WEEKLY
Definition: CharacterDatabase.h:81
CHAR_INS_ITEM_INSTANCE_AZERITE_EMPOWERED
@ CHAR_INS_ITEM_INSTANCE_AZERITE_EMPOWERED
Definition: CharacterDatabase.h:190
CHAR_DEL_GUILD_BANK_TABS
@ CHAR_DEL_GUILD_BANK_TABS
Definition: CharacterDatabase.h:216
CHAR_SEL_PVPSTATS_FACTIONS_OVERALL
@ CHAR_SEL_PVPSTATS_FACTIONS_OVERALL
Definition: CharacterDatabase.h:605
CHAR_UPD_CHAR_ONLINE
@ CHAR_UPD_CHAR_ONLINE
Definition: CharacterDatabase.h:394
CHAR_REP_CHAR_VOID_STORAGE_ITEM
@ CHAR_REP_CHAR_VOID_STORAGE_ITEM
Definition: CharacterDatabase.h:549
CHAR_SEL_CHAR_GUID_NAME_BY_ACC
@ CHAR_SEL_CHAR_GUID_NAME_BY_ACC
Definition: CharacterDatabase.h:422
CHAR_DEL_CHAR_QUESTSTATUS_REWARDED_BY_QUEST
@ CHAR_DEL_CHAR_QUESTSTATUS_REWARDED_BY_QUEST
Definition: CharacterDatabase.h:517
CHAR_DEL_CHARACTER_FAVORITE_AUCTION
@ CHAR_DEL_CHARACTER_FAVORITE_AUCTION
Definition: CharacterDatabase.h:119
CHAR_INS_CHAR_SPELL
@ CHAR_INS_CHAR_SPELL
Definition: CharacterDatabase.h:525
CHAR_DEL_ALL_GM_COMPLAINTS
@ CHAR_DEL_ALL_GM_COMPLAINTS
Definition: CharacterDatabase.h:355
CHAR_DEL_PETITION_BY_GUID
@ CHAR_DEL_PETITION_BY_GUID
Definition: CharacterDatabase.h:452
CHAR_SEL_CHARACTER
@ CHAR_SEL_CHARACTER
Definition: CharacterDatabase.h:64
CHAR_REP_GM_SUGGESTION
@ CHAR_REP_GM_SUGGESTION
Definition: CharacterDatabase.h:359
CHAR_INS_GUILD_ACHIEVEMENT_CRITERIA
@ CHAR_INS_GUILD_ACHIEVEMENT_CRITERIA
Definition: CharacterDatabase.h:251
CHAR_UPD_ITEM_OWNER
@ CHAR_UPD_ITEM_OWNER
Definition: CharacterDatabase.h:149
CHAR_UPD_GUILD_BANK_TAB_TEXT
@ CHAR_UPD_GUILD_BANK_TAB_TEXT
Definition: CharacterDatabase.h:243
CHAR_DEL_ITEM_INSTANCE_GEMS
@ CHAR_DEL_ITEM_INSTANCE_GEMS
Definition: CharacterDatabase.h:161
CHAR_SEL_CHAR_HOMEBIND
@ CHAR_SEL_CHAR_HOMEBIND
Definition: CharacterDatabase.h:421
CHAR_DEL_ARENA_TEAM_MEMBERS
@ CHAR_DEL_ARENA_TEAM_MEMBERS
Definition: CharacterDatabase.h:302
CHAR_INS_CHARACTER_INSTANCE_LOCK
@ CHAR_INS_CHARACTER_INSTANCE_LOCK
Definition: CharacterDatabase.h:642
CHAR_SEL_MAIL_LIST_COUNT
@ CHAR_SEL_MAIL_LIST_COUNT
Definition: CharacterDatabase.h:46
CHAR_DEL_ALL_RESPAWNS
@ CHAR_DEL_ALL_RESPAWNS
Definition: CharacterDatabase.h:342
CHAR_DEL_GAME_EVENT_SAVE
@ CHAR_DEL_GAME_EVENT_SAVE
Definition: CharacterDatabase.h:292
CHAR_SEL_PET_AURA
@ CHAR_SEL_PET_AURA
Definition: CharacterDatabase.h:563
CHAR_INS_GUILD_NEWS
@ CHAR_INS_GUILD_NEWS
Definition: CharacterDatabase.h:256
CHAR_DEL_ITEM_INSTANCE_ARTIFACT
@ CHAR_DEL_ITEM_INSTANCE_ARTIFACT
Definition: CharacterDatabase.h:168
CHAR_SEL_GM_COMPLAINTS
@ CHAR_SEL_GM_COMPLAINTS
Definition: CharacterDatabase.h:349
CHAR_SEL_PLAYER_CURRENCY
@ CHAR_SEL_PLAYER_CURRENCY
Definition: CharacterDatabase.h:275
CHAR_UPD_QUEST_TRACK_COMPLETE_TIME
@ CHAR_UPD_QUEST_TRACK_COMPLETE_TIME
Definition: CharacterDatabase.h:609
CHAR_DEL_CHARACTER_GARRISON
@ CHAR_DEL_CHARACTER_GARRISON
Definition: CharacterDatabase.h:614
CHAR_DEL_CORPSE_CUSTOMIZATIONS
@ CHAR_DEL_CORPSE_CUSTOMIZATIONS
Definition: CharacterDatabase.h:336
CHAR_SEL_CHARACTER_QUESTSTATUS_OBJECTIVES_CRITERIA_PROGRESS
@ CHAR_SEL_CHARACTER_QUESTSTATUS_OBJECTIVES_CRITERIA_PROGRESS
Definition: CharacterDatabase.h:75
CHAR_DEL_EMPTY_EXPIRED_MAIL
@ CHAR_DEL_EMPTY_EXPIRED_MAIL
Definition: CharacterDatabase.h:144
CHAR_DEL_GUILD
@ CHAR_DEL_GUILD
Definition: CharacterDatabase.h:206
CHAR_UPD_REM_AT_LOGIN_FLAG
@ CHAR_UPD_REM_AT_LOGIN_FLAG
Definition: CharacterDatabase.h:367
CHAR_DEL_GUILD_BANK_RIGHTS
@ CHAR_DEL_GUILD_BANK_RIGHTS
Definition: CharacterDatabase.h:222
CHAR_SEL_CHARACTER_QUESTSTATUSREW
@ CHAR_SEL_CHARACTER_QUESTSTATUSREW
Definition: CharacterDatabase.h:116
CHAR_DEL_ITEM_INSTANCE_TRANSMOG
@ CHAR_DEL_ITEM_INSTANCE_TRANSMOG
Definition: CharacterDatabase.h:164
CHAR_SEL_PLAYER_ACCOUNT_DATA
@ CHAR_SEL_PLAYER_ACCOUNT_DATA
Definition: CharacterDatabase.h:283
CHAR_DEL_ARENA_TEAM
@ CHAR_DEL_ARENA_TEAM
Definition: CharacterDatabase.h:301
CHAR_UPD_CHAR_QUESTSTATUS_REWARDED_FACTION_CHANGE
@ CHAR_UPD_CHAR_QUESTSTATUS_REWARDED_FACTION_CHANGE
Definition: CharacterDatabase.h:518
CHAR_SEL_AUCTION_ITEMS
@ CHAR_SEL_AUCTION_ITEMS
Definition: CharacterDatabase.h:128
CHAR_DEL_CHARACTER_FAVORITE_AUCTIONS_BY_CHAR
@ CHAR_DEL_CHARACTER_FAVORITE_AUCTIONS_BY_CHAR
Definition: CharacterDatabase.h:120
CHAR_DEL_RESET_CHARACTER_QUESTSTATUS_MONTHLY
@ CHAR_DEL_RESET_CHARACTER_QUESTSTATUS_MONTHLY
Definition: CharacterDatabase.h:90
CHAR_UPD_LEVEL
@ CHAR_UPD_LEVEL
Definition: CharacterDatabase.h:389
CHAR_DEL_GUILD_EVENTLOG_BY_PLAYER
@ CHAR_DEL_GUILD_EVENTLOG_BY_PLAYER
Definition: CharacterDatabase.h:496
CHAR_INS_CHARACTER_GARRISON_BUILDINGS
@ CHAR_INS_CHARACTER_GARRISON_BUILDINGS
Definition: CharacterDatabase.h:620
CHAR_DEL_PET_SPELL_CHARGES
@ CHAR_DEL_PET_SPELL_CHARGES
Definition: CharacterDatabase.h:573
CHAR_INS_GROUP_MEMBER
@ CHAR_INS_GROUP_MEMBER
Definition: CharacterDatabase.h:376
CHAR_DEL_ALL_GM_BUGS
@ CHAR_DEL_ALL_GM_BUGS
Definition: CharacterDatabase.h:347
CHAR_DEL_ITEM_INSTANCE
@ CHAR_DEL_ITEM_INSTANCE
Definition: CharacterDatabase.h:158
CHAR_UPD_EQUIP_SET
@ CHAR_UPD_EQUIP_SET
Definition: CharacterDatabase.h:264
CHAR_SEL_CHARACTER_FAVORITE_AUCTIONS
@ CHAR_SEL_CHARACTER_FAVORITE_AUCTIONS
Definition: CharacterDatabase.h:117
CHAR_INS_AURA_EFFECT
@ CHAR_INS_AURA_EFFECT
Definition: CharacterDatabase.h:273
CHAR_INS_CHARACTER_BAN
@ CHAR_INS_CHARACTER_BAN
Definition: CharacterDatabase.h:39
CHAR_DEL_CHAR_AURA_FROZEN
@ CHAR_DEL_CHAR_AURA_FROZEN
Definition: CharacterDatabase.h:429
CHAR_DEL_CHAR_SKILL_LANGUAGES
@ CHAR_DEL_CHAR_SKILL_LANGUAGES
Definition: CharacterDatabase.h:457
CHAR_DEL_CHAR_SKILLS
@ CHAR_DEL_CHAR_SKILLS
Definition: CharacterDatabase.h:501
CHAR_SEL_CHARACTER_GARRISON
@ CHAR_SEL_CHARACTER_GARRISON
Definition: CharacterDatabase.h:612
CHAR_SEL_CHARACTER_AURAS
@ CHAR_SEL_CHARACTER_AURAS
Definition: CharacterDatabase.h:67
CHAR_DEL_CALENDAR_INVITE
@ CHAR_DEL_CALENDAR_INVITE
Definition: CharacterDatabase.h:561
CHAR_DEL_ITEMCONTAINER_MONEY
@ CHAR_DEL_ITEMCONTAINER_MONEY
Definition: CharacterDatabase.h:599
CHAR_DEL_CHAR_PET_BY_OWNER
@ CHAR_DEL_CHAR_PET_BY_OWNER
Definition: CharacterDatabase.h:581
CHAR_DEL_CHARACTER_AURA_STORED_LOCATIONS_BY_GUID
@ CHAR_DEL_CHARACTER_AURA_STORED_LOCATIONS_BY_GUID
Definition: CharacterDatabase.h:634
CHAR_DEL_CHARACTER_BAN
@ CHAR_DEL_CHARACTER_BAN
Definition: CharacterDatabase.h:41
CHAR_DEL_AUCTION_BIDDER_BY_PLAYER
@ CHAR_DEL_AUCTION_BIDDER_BY_PLAYER
Definition: CharacterDatabase.h:138
CHAR_DEL_TUTORIALS
@ CHAR_DEL_TUTORIALS
Definition: CharacterDatabase.h:290
CHAR_DEL_CHAR_TRANSMOG_OUTFITS
@ CHAR_DEL_CHAR_TRANSMOG_OUTFITS
Definition: CharacterDatabase.h:495
CHAR_SEL_CHAR_PETS
@ CHAR_SEL_CHAR_PETS
Definition: CharacterDatabase.h:584
CHAR_SEL_MAILITEMS_AZERITE
@ CHAR_SEL_MAILITEMS_AZERITE
Definition: CharacterDatabase.h:124
CHAR_INS_CHARACTER_QUESTSTATUS_SEASONAL
@ CHAR_INS_CHARACTER_QUESTSTATUS_SEASONAL
Definition: CharacterDatabase.h:87
CHAR_UPD_GUILD_RANK_NAME
@ CHAR_UPD_GUILD_RANK_NAME
Definition: CharacterDatabase.h:237
CHAR_SEL_AUCTION_BIDDERS
@ CHAR_SEL_AUCTION_BIDDERS
Definition: CharacterDatabase.h:136
CHAR_INS_CHAR_TALENT
@ CHAR_INS_CHAR_TALENT
Definition: CharacterDatabase.h:534
CHAR_DEL_CHAR_STATS
@ CHAR_DEL_CHAR_STATS
Definition: CharacterDatabase.h:529
CHAR_DEL_ALL_GUILD_ACHIEVEMENTS
@ CHAR_DEL_ALL_GUILD_ACHIEVEMENTS
Definition: CharacterDatabase.h:252
CHAR_DEL_CHARACTER_CUSTOMIZATIONS
@ CHAR_DEL_CHARACTER_CUSTOMIZATIONS
Definition: CharacterDatabase.h:374
CHAR_DEL_ITEM_INSTANCE_BY_OWNER
@ CHAR_DEL_ITEM_INSTANCE_BY_OWNER
Definition: CharacterDatabase.h:159
CHAR_SEL_ACCOUNT_INSTANCELOCKTIMES
@ CHAR_SEL_ACCOUNT_INSTANCELOCKTIMES
Definition: CharacterDatabase.h:121
CHAR_DEL_CHAR_INVENTORY_BY_ITEM
@ CHAR_DEL_CHAR_INVENTORY_BY_ITEM
Definition: CharacterDatabase.h:507
CHAR_DEL_GROUP_MEMBER_ALL
@ CHAR_DEL_GROUP_MEMBER_ALL
Definition: CharacterDatabase.h:448
CHAR_UPD_GUILD_NAME
@ CHAR_UPD_GUILD_NAME
Definition: CharacterDatabase.h:207
CHAR_INS_CHAR_SKILLS
@ CHAR_INS_CHAR_SKILLS
Definition: CharacterDatabase.h:523
CHAR_DEL_CHAR_CUF_PROFILES
@ CHAR_DEL_CHAR_CUF_PROFILES
Definition: CharacterDatabase.h:556
CHAR_INS_GUILD_EVENTLOG
@ CHAR_INS_GUILD_EVENTLOG
Definition: CharacterDatabase.h:227
CHAR_DEL_ITEMCONTAINER_ITEM
@ CHAR_DEL_ITEMCONTAINER_ITEM
Definition: CharacterDatabase.h:596
CHAR_UPD_PLAYER_CURRENCY
@ CHAR_UPD_PLAYER_CURRENCY
Definition: CharacterDatabase.h:276
CHAR_UPD_CHAR_ACHIEVEMENT
@ CHAR_UPD_CHAR_ACHIEVEMENT
Definition: CharacterDatabase.h:469
CHAR_DEL_CHARACTER_GARRISON_FOLLOWERS
@ CHAR_DEL_CHARACTER_GARRISON_FOLLOWERS
Definition: CharacterDatabase.h:624
CHAR_INS_POOL_QUEST_SAVE
@ CHAR_INS_POOL_QUEST_SAVE
Definition: CharacterDatabase.h:32
CHAR_UPD_MAIL_RETURNED
@ CHAR_UPD_MAIL_RETURNED
Definition: CharacterDatabase.h:147
CHAR_UPD_GUILD_EMBLEM_INFO
@ CHAR_UPD_GUILD_EMBLEM_INFO
Definition: CharacterDatabase.h:239
CHAR_INS_BLACKMARKET_AUCTIONS
@ CHAR_INS_BLACKMARKET_AUCTIONS
Definition: CharacterDatabase.h:631
CHAR_DEL_POOL_QUEST_SAVE
@ CHAR_DEL_POOL_QUEST_SAVE
Definition: CharacterDatabase.h:31
CHAR_SEL_CHARACTER_QUESTSTATUS_OBJECTIVES_CRITERIA
@ CHAR_SEL_CHARACTER_QUESTSTATUS_OBJECTIVES_CRITERIA
Definition: CharacterDatabase.h:74
CHAR_SEL_PVPSTATS_MAXID
@ CHAR_SEL_PVPSTATS_MAXID
Definition: CharacterDatabase.h:602
CHAR_UPD_CHARACTER_BAN
@ CHAR_UPD_CHARACTER_BAN
Definition: CharacterDatabase.h:40
CHAR_INS_PET_AURA_EFFECT
@ CHAR_INS_PET_AURA_EFFECT
Definition: CharacterDatabase.h:578
CHAR_DEL_INVALID_PET_SPELL
@ CHAR_DEL_INVALID_PET_SPELL
Definition: CharacterDatabase.h:393
CHAR_SEL_CHAR_DEL_INFO_BY_NAME
@ CHAR_SEL_CHAR_DEL_INFO_BY_NAME
Definition: CharacterDatabase.h:413
CHAR_SEL_CHAR_DEL_INFO
@ CHAR_SEL_CHAR_DEL_INFO
Definition: CharacterDatabase.h:414
CHAR_SEL_EXPIRED_MAIL
@ CHAR_SEL_EXPIRED_MAIL
Definition: CharacterDatabase.h:145
CHAR_DEL_AUCTION
@ CHAR_DEL_AUCTION
Definition: CharacterDatabase.h:130
CHAR_SEL_PETITION_OWNER_BY_GUID
@ CHAR_SEL_PETITION_OWNER_BY_GUID
Definition: CharacterDatabase.h:317
CHAR_REP_RESPAWN
@ CHAR_REP_RESPAWN
Definition: CharacterDatabase.h:340
CHAR_DEL_ITEMCONTAINER_ITEMS
@ CHAR_DEL_ITEMCONTAINER_ITEMS
Definition: CharacterDatabase.h:595
CHAR_DEL_CHARACTER_INSTANCE_LOCK
@ CHAR_DEL_CHARACTER_INSTANCE_LOCK
Definition: CharacterDatabase.h:640
CHAR_DEL_GROUP
@ CHAR_DEL_GROUP
Definition: CharacterDatabase.h:447
CHAR_DEL_CALENDAR_EVENT
@ CHAR_DEL_CALENDAR_EVENT
Definition: CharacterDatabase.h:559
CHAR_SEL_ITEMCONTAINER_ITEMS
@ CHAR_SEL_ITEMCONTAINER_ITEMS
Definition: CharacterDatabase.h:594
CHAR_REP_INVENTORY_ITEM
@ CHAR_REP_INVENTORY_ITEM
Definition: CharacterDatabase.h:154
CHAR_DEL_CHAR_DECLINED_NAME
@ CHAR_DEL_CHAR_DECLINED_NAME
Definition: CharacterDatabase.h:454
CHAR_DEL_INVALID_QUEST_PROGRESS_CRITERIA
@ CHAR_DEL_INVALID_QUEST_PROGRESS_CRITERIA
Definition: CharacterDatabase.h:521
CHAR_DEL_GUILD_BANK_EVENTLOGS
@ CHAR_DEL_GUILD_BANK_EVENTLOGS
Definition: CharacterDatabase.h:226
CHAR_DEL_PETITION_SIGNATURE_BY_OWNER
@ CHAR_DEL_PETITION_SIGNATURE_BY_OWNER
Definition: CharacterDatabase.h:532
CHAR_SEL_MAILITEMS_AZERITE_MILESTONE_POWER
@ CHAR_SEL_MAILITEMS_AZERITE_MILESTONE_POWER
Definition: CharacterDatabase.h:125
CHAR_SEL_MAILITEMS_AZERITE_UNLOCKED_ESSENCE
@ CHAR_SEL_MAILITEMS_AZERITE_UNLOCKED_ESSENCE
Definition: CharacterDatabase.h:126
CHAR_SEL_CHAR_RACE_OR_FACTION_CHANGE_INFOS
@ CHAR_SEL_CHAR_RACE_OR_FACTION_CHANGE_INFOS
Definition: CharacterDatabase.h:424
CHAR_INS_PET_SPELL_CHARGES
@ CHAR_INS_PET_SPELL_CHARGES
Definition: CharacterDatabase.h:574
CHAR_DEL_ALL_GM_COMPLAINT_CHATLOGS
@ CHAR_DEL_ALL_GM_COMPLAINT_CHATLOGS
Definition: CharacterDatabase.h:356
CHAR_INS_EQUIP_SET
@ CHAR_INS_EQUIP_SET
Definition: CharacterDatabase.h:265
CHAR_DEL_ALL_PETITION_SIGNATURES
@ CHAR_DEL_ALL_PETITION_SIGNATURES
Definition: CharacterDatabase.h:313
CHAR_DEL_ITEM_INSTANCE_ARTIFACT_POWERS
@ CHAR_DEL_ITEM_INSTANCE_ARTIFACT_POWERS
Definition: CharacterDatabase.h:171
CHAR_SEL_ACCOUNT_BY_NAME
@ CHAR_SEL_ACCOUNT_BY_NAME
Definition: CharacterDatabase.h:197
CHAR_SEL_CHARACTER_AURA_FROZEN
@ CHAR_SEL_CHARACTER_AURA_FROZEN
Definition: CharacterDatabase.h:409
CHAR_SEL_CHARACTER_QUESTSTATUS_MONTHLY
@ CHAR_SEL_CHARACTER_QUESTSTATUS_MONTHLY
Definition: CharacterDatabase.h:78
CHAR_DEL_CHAR_SPELL_FAVORITE
@ CHAR_DEL_CHAR_SPELL_FAVORITE
Definition: CharacterDatabase.h:526
CHAR_UPD_BLACKMARKET_AUCTIONS
@ CHAR_UPD_BLACKMARKET_AUCTIONS
Definition: CharacterDatabase.h:630
CHAR_DEL_ITEM_INSTANCE_AZERITE_EMPOWERED
@ CHAR_DEL_ITEM_INSTANCE_AZERITE_EMPOWERED
Definition: CharacterDatabase.h:192
CHAR_INS_BATTLEGROUND_RANDOM
@ CHAR_INS_BATTLEGROUND_RANDOM
Definition: CharacterDatabase.h:62
CHAR_SEL_MAILITEMS
@ CHAR_SEL_MAILITEMS
Definition: CharacterDatabase.h:122
CHAR_DEL_PLAYER_BGDATA
@ CHAR_DEL_PLAYER_BGDATA
Definition: CharacterDatabase.h:321
CHAR_UPD_QUEST_TRACK_ABANDON_TIME
@ CHAR_UPD_QUEST_TRACK_ABANDON_TIME
Definition: CharacterDatabase.h:610
CHAR_SEL_BANNED_NAME
@ CHAR_SEL_BANNED_NAME
Definition: CharacterDatabase.h:45
CHAR_UPD_CHANNEL_OWNERSHIP
@ CHAR_UPD_CHANNEL_OWNERSHIP
Definition: CharacterDatabase.h:260
CHAR_DEL_CHAR_QUESTSTATUS_OBJECTIVES
@ CHAR_DEL_CHAR_QUESTSTATUS_OBJECTIVES
Definition: CharacterDatabase.h:462
CHAR_UPD_CHAR_SKILLS
@ CHAR_UPD_CHAR_SKILLS
Definition: CharacterDatabase.h:524
CHAR_INS_PVPSTATS_PLAYER
@ CHAR_INS_PVPSTATS_PLAYER
Definition: CharacterDatabase.h:604
CHAR_INS_CHAR_TRAIT_ENTRIES
@ CHAR_INS_CHAR_TRAIT_ENTRIES
Definition: CharacterDatabase.h:540
CHAR_SEL_CHAR_VOID_STORAGE
@ CHAR_SEL_CHAR_VOID_STORAGE
Definition: CharacterDatabase.h:548
CHAR_SEL_CHECK_GUID
@ CHAR_SEL_CHECK_GUID
Definition: CharacterDatabase.h:36
CHAR_SEL_CHARACTER_COUNT
@ CHAR_SEL_CHARACTER_COUNT
Definition: CharacterDatabase.h:202
CHAR_UPD_DELETE_INFO
@ CHAR_UPD_DELETE_INFO
Definition: CharacterDatabase.h:386
CHAR_UPD_PETITION_NAME
@ CHAR_UPD_PETITION_NAME
Definition: CharacterDatabase.h:370
CHAR_SEL_GUILD_BANK_ITEMS
@ CHAR_SEL_GUILD_BANK_ITEMS
Definition: CharacterDatabase.h:219
CHAR_INS_PET_SPELL_COOLDOWN
@ CHAR_INS_PET_SPELL_COOLDOWN
Definition: CharacterDatabase.h:571
CHAR_DEL_CHAR_CUF_PROFILES_BY_ID
@ CHAR_DEL_CHAR_CUF_PROFILES_BY_ID
Definition: CharacterDatabase.h:555
CHAR_REP_CALENDAR_INVITE
@ CHAR_REP_CALENDAR_INVITE
Definition: CharacterDatabase.h:560
CHAR_DEL_CHAR_SPELL_FAVORITE_BY_CHAR
@ CHAR_DEL_CHAR_SPELL_FAVORITE_BY_CHAR
Definition: CharacterDatabase.h:527
CHAR_DEL_RESET_CHARACTER_QUESTSTATUS_SEASONAL_BY_EVENT
@ CHAR_DEL_RESET_CHARACTER_QUESTSTATUS_SEASONAL_BY_EVENT
Definition: CharacterDatabase.h:91
CHAR_DEL_ALL_GAME_EVENT_CONDITION_SAVE
@ CHAR_DEL_ALL_GAME_EVENT_CONDITION_SAVE
Definition: CharacterDatabase.h:295
CHAR_UPD_CHAR_PET_SLOT_BY_ID
@ CHAR_UPD_CHAR_PET_SLOT_BY_ID
Definition: CharacterDatabase.h:588
CHAR_DEL_INVALID_MAIL_ITEM
@ CHAR_DEL_INVALID_MAIL_ITEM
Definition: CharacterDatabase.h:143
CHAR_DEL_CHARACTER_SKILL
@ CHAR_DEL_CHARACTER_SKILL
Definition: CharacterDatabase.h:398
CHAR_DEL_GUILD_BANK_RIGHTS_FOR_RANK
@ CHAR_DEL_GUILD_BANK_RIGHTS_FOR_RANK
Definition: CharacterDatabase.h:223
CHAR_SEL_BANINFO
@ CHAR_SEL_BANINFO
Definition: CharacterDatabase.h:42
CHAR_SEL_CORPSE_PHASES
@ CHAR_SEL_CORPSE_PHASES
Definition: CharacterDatabase.h:331
CHAR_INS_PLAYER_HOMEBIND
@ CHAR_INS_PLAYER_HOMEBIND
Definition: CharacterDatabase.h:323
CHAR_SEL_PETITION_BY_OWNER
@ CHAR_SEL_PETITION_BY_OWNER
Definition: CharacterDatabase.h:314
CHAR_DEL_CHAR_FISHINGSTEPS
@ CHAR_DEL_CHAR_FISHINGSTEPS
Definition: CharacterDatabase.h:538
CHAR_SEL_GM_SUGGESTIONS
@ CHAR_SEL_GM_SUGGESTIONS
Definition: CharacterDatabase.h:358
CHAR_DEL_ALL_GM_SUGGESTIONS
@ CHAR_DEL_ALL_GM_SUGGESTIONS
Definition: CharacterDatabase.h:361
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:385
CHAR_UPD_ARENA_TEAM_STATS
@ CHAR_UPD_ARENA_TEAM_STATS
Definition: CharacterDatabase.h:305
CHAR_INS_CHARACTER_QUESTSTATUS_DAILY
@ CHAR_INS_CHARACTER_QUESTSTATUS_DAILY
Definition: CharacterDatabase.h:84
CHAR_INS_CHARACTER_CUSTOMIZATION
@ CHAR_INS_CHARACTER_CUSTOMIZATION
Definition: CharacterDatabase.h:373
CHAR_INS_CHARACTER_GARRISON_BLUEPRINTS
@ CHAR_INS_CHARACTER_GARRISON_BLUEPRINTS
Definition: CharacterDatabase.h:617
CHAR_DEL_CHAR_SPELL_COOLDOWNS
@ CHAR_DEL_CHAR_SPELL_COOLDOWNS
Definition: CharacterDatabase.h:478
CHAR_UPD_NAME_BY_GUID
@ CHAR_UPD_NAME_BY_GUID
Definition: CharacterDatabase.h:203
CHAR_INS_GAME_EVENT_SAVE
@ CHAR_INS_GAME_EVENT_SAVE
Definition: CharacterDatabase.h:293
CHAR_INS_CHAR_SKILL_LANGUAGE
@ CHAR_INS_CHAR_SKILL_LANGUAGE
Definition: CharacterDatabase.h:458
CHAR_SEL_TUTORIALS
@ CHAR_SEL_TUTORIALS
Definition: CharacterDatabase.h:287
CHAR_INS_CHAR_FISHINGSTEPS
@ CHAR_INS_CHAR_FISHINGSTEPS
Definition: CharacterDatabase.h:537
CHAR_INS_BUG_REPORT
@ CHAR_INS_BUG_REPORT
Definition: CharacterDatabase.h:369
CHAR_SEL_CHARACTER_BGDATA
@ CHAR_SEL_CHARACTER_BGDATA
Definition: CharacterDatabase.h:109
CHAR_SEL_CHARACTER_SOCIALLIST
@ CHAR_SEL_CHARACTER_SOCIALLIST
Definition: CharacterDatabase.h:97
CHAR_DEL_CHAR_QUESTSTATUS_OBJECTIVES_CRITERIA_PROGRESS
@ CHAR_DEL_CHAR_QUESTSTATUS_OBJECTIVES_CRITERIA_PROGRESS
Definition: CharacterDatabase.h:464
CHAR_DEL_CHAR_ACTION_BY_BUTTON_SPEC
@ CHAR_DEL_CHAR_ACTION_BY_BUTTON_SPEC
Definition: CharacterDatabase.h:505
CHAR_UPD_CHAR_SPELL_FACTION_CHANGE
@ CHAR_UPD_CHAR_SPELL_FACTION_CHANGE
Definition: CharacterDatabase.h:472
CHAR_UPD_CHAR_TAXI_PATH
@ CHAR_UPD_CHAR_TAXI_PATH
Definition: CharacterDatabase.h:459
CHAR_DEL_MAIL_ITEM
@ CHAR_DEL_MAIL_ITEM
Definition: CharacterDatabase.h:142
CHAR_UPD_CHAR_TAXIMASK
@ CHAR_UPD_CHAR_TAXIMASK
Definition: CharacterDatabase.h:460
CHAR_DEL_ALL_PET_SPELLS_BY_OWNER
@ CHAR_DEL_ALL_PET_SPELLS_BY_OWNER
Definition: CharacterDatabase.h:590
CHAR_INS_GROUP
@ CHAR_INS_GROUP
Definition: CharacterDatabase.h:375
CHAR_SEL_CHAR_TRAIT_ENTRIES
@ CHAR_SEL_CHAR_TRAIT_ENTRIES
Definition: CharacterDatabase.h:539
CHAR_SEL_BANINFO_LIST
@ CHAR_SEL_BANINFO_LIST
Definition: CharacterDatabase.h:44
CHAR_DEL_CHAR_ACHIEVEMENT_PROGRESS_BY_CRITERIA
@ CHAR_DEL_CHAR_ACHIEVEMENT_PROGRESS_BY_CRITERIA
Definition: CharacterDatabase.h:441
CHAR_SEL_CHARACTER_QUESTSTATUS_WEEKLY
@ CHAR_SEL_CHARACTER_QUESTSTATUS_WEEKLY
Definition: CharacterDatabase.h:77
CHAR_DEL_PLAYER_HOMEBIND
@ CHAR_DEL_PLAYER_HOMEBIND
Definition: CharacterDatabase.h:325
CHAR_SEL_ITEM_INSTANCE_AZERITE_UNLOCKED_ESSENCE
@ CHAR_SEL_ITEM_INSTANCE_AZERITE_UNLOCKED_ESSENCE
Definition: CharacterDatabase.h:185
CHAR_DEL_CHAR_EQUIPMENTSETS
@ CHAR_DEL_CHAR_EQUIPMENTSETS
Definition: CharacterDatabase.h:494
CHAR_REP_CHAR_CUF_PROFILES
@ CHAR_REP_CHAR_CUF_PROFILES
Definition: CharacterDatabase.h:554
CHAR_DEL_GM_BUG
@ CHAR_DEL_GM_BUG
Definition: CharacterDatabase.h:346
CHAR_SEL_CHARACTER_ACTIONS_SPEC
@ CHAR_SEL_CHARACTER_ACTIONS_SPEC
Definition: CharacterDatabase.h:95
CHAR_INS_MAIL_ITEM
@ CHAR_INS_MAIL_ITEM
Definition: CharacterDatabase.h:141
CHAR_DEL_CHARACTER_QUESTSTATUS_DAILY
@ CHAR_DEL_CHARACTER_QUESTSTATUS_DAILY
Definition: CharacterDatabase.h:80
CHAR_SEL_CHAR_POSITION
@ CHAR_SEL_CHAR_POSITION
Definition: CharacterDatabase.h:58
CHAR_UPD_CHAR_ACTION
@ CHAR_UPD_CHAR_ACTION
Definition: CharacterDatabase.h:504
CHAR_UPD_GUILD_MEMBER_RANK
@ CHAR_UPD_GUILD_MEMBER_RANK
Definition: CharacterDatabase.h:232
CHAR_UPD_AUCTION_EXPIRATION
@ CHAR_UPD_AUCTION_EXPIRATION
Definition: CharacterDatabase.h:132
CHAR_INS_GUILD_RANK
@ CHAR_INS_GUILD_RANK
Definition: CharacterDatabase.h:211
CHAR_SEL_ENUM_CUSTOMIZATIONS
@ CHAR_SEL_ENUM_CUSTOMIZATIONS
Definition: CharacterDatabase.h:51
CHAR_SEL_CHARACTER_GARRISON_FOLLOWER_ABILITIES
@ CHAR_SEL_CHARACTER_GARRISON_FOLLOWER_ABILITIES
Definition: CharacterDatabase.h:625
CHAR_INS_AUCTION_ITEMS
@ CHAR_INS_AUCTION_ITEMS
Definition: CharacterDatabase.h:134
CHAR_SEL_ITEM_INSTANCE_AZERITE_EMPOWERED
@ CHAR_SEL_ITEM_INSTANCE_AZERITE_EMPOWERED
Definition: CharacterDatabase.h:189
CHAR_DEL_EQUIP_SET
@ CHAR_DEL_EQUIP_SET
Definition: CharacterDatabase.h:266
CHAR_INS_CHAR_ACHIEVEMENT_PROGRESS
@ CHAR_INS_CHAR_ACHIEVEMENT_PROGRESS
Definition: CharacterDatabase.h:442
CHAR_INS_GUILD
@ CHAR_INS_GUILD
Definition: CharacterDatabase.h:205
CHAR_SEL_CHAR_REP_BY_FACTION
@ CHAR_SEL_CHAR_REP_BY_FACTION
Definition: CharacterDatabase.h:473
CHAR_INS_AURA
@ CHAR_INS_AURA
Definition: CharacterDatabase.h:272
CHAR_SEL_GUILD_ACHIEVEMENT
@ CHAR_SEL_GUILD_ACHIEVEMENT
Definition: CharacterDatabase.h:254
CHAR_DEL_ITEM_INSTANCE_ARTIFACT_POWERS_BY_OWNER
@ CHAR_DEL_ITEM_INSTANCE_ARTIFACT_POWERS_BY_OWNER
Definition: CharacterDatabase.h:172
CHAR_DEL_CHARACTER_ARENA_STATS
@ CHAR_DEL_CHARACTER_ARENA_STATS
Definition: CharacterDatabase.h:307
CHAR_SEL_CHARACTER_HOMEBIND
@ CHAR_SEL_CHARACTER_HOMEBIND
Definition: CharacterDatabase.h:98
CHAR_SEL_PETITION_SIG_BY_GUID
@ CHAR_SEL_PETITION_SIG_BY_GUID
Definition: CharacterDatabase.h:318
CHAR_INS_ARENA_TEAM_MEMBER
@ CHAR_INS_ARENA_TEAM_MEMBER
Definition: CharacterDatabase.h:300
CHAR_INS_ITEM_INSTANCE_ARTIFACT_POWERS
@ CHAR_INS_ITEM_INSTANCE_ARTIFACT_POWERS
Definition: CharacterDatabase.h:170
CHAR_SEL_FREE_NAME
@ CHAR_SEL_FREE_NAME
Definition: CharacterDatabase.h:55
CHAR_INS_CORPSE_PHASES
@ CHAR_INS_CORPSE_PHASES
Definition: CharacterDatabase.h:332
CHAR_UPD_GUILD_RANK_BANK_MONEY
@ CHAR_UPD_GUILD_RANK_BANK_MONEY
Definition: CharacterDatabase.h:242
CHAR_SEL_ENUM
@ CHAR_SEL_ENUM
Definition: CharacterDatabase.h:49
CHAR_UPD_GUILD_LEADER
@ CHAR_UPD_GUILD_LEADER
Definition: CharacterDatabase.h:235
CHAR_SEL_SUM_CHARS
@ CHAR_SEL_SUM_CHARS
Definition: CharacterDatabase.h:37
CHAR_SEL_GROUP_MEMBER
@ CHAR_SEL_GROUP_MEMBER
Definition: CharacterDatabase.h:66
CHAR_INS_ITEM_INSTANCE_AZERITE
@ CHAR_INS_ITEM_INSTANCE_AZERITE
Definition: CharacterDatabase.h:177
CHAR_UPD_CHANNEL_USAGE
@ CHAR_UPD_CHANNEL_USAGE
Definition: CharacterDatabase.h:259
CHAR_SEL_MAIL_LIST_ITEMS
@ CHAR_SEL_MAIL_LIST_ITEMS
Definition: CharacterDatabase.h:48
CHAR_SEL_UNDELETE_ENUM_DECLINED_NAME
@ CHAR_SEL_UNDELETE_ENUM_DECLINED_NAME
Definition: CharacterDatabase.h:53
CHAR_UPD_CHAR_LIST_SLOT
@ CHAR_UPD_CHAR_LIST_SLOT
Definition: CharacterDatabase.h:536
CHAR_INS_CHARACTER_AURA_STORED_LOCATION
@ CHAR_INS_CHARACTER_AURA_STORED_LOCATION
Definition: CharacterDatabase.h:636
CHAR_SEL_PETITION_SIG_BY_ACCOUNT
@ CHAR_SEL_PETITION_SIG_BY_ACCOUNT
Definition: CharacterDatabase.h:316
CHAR_SEL_ITEM_INSTANCE_AZERITE_MILESTONE_POWER
@ CHAR_SEL_ITEM_INSTANCE_AZERITE_MILESTONE_POWER
Definition: CharacterDatabase.h:181
CHAR_DEL_CHAR_SPELL_BY_SPELL
@ CHAR_DEL_CHAR_SPELL_BY_SPELL
Definition: CharacterDatabase.h:471
CHAR_DEL_PET_SPELLS
@ CHAR_DEL_PET_SPELLS
Definition: CharacterDatabase.h:580
CHAR_SEL_CHAR_CREATE_INFO
@ CHAR_SEL_CHAR_CREATE_INFO
Definition: CharacterDatabase.h:38
CHAR_SEL_CHARACTER_INVENTORY
@ CHAR_SEL_CHARACTER_INVENTORY
Definition: CharacterDatabase.h:94
CHAR_UPD_CHAR_QUESTSTATUS_REWARDED_ACTIVE_BY_QUEST
@ CHAR_UPD_CHAR_QUESTSTATUS_REWARDED_ACTIVE_BY_QUEST
Definition: CharacterDatabase.h:520
CHAR_UPD_GROUP_DIFFICULTY
@ CHAR_UPD_GROUP_DIFFICULTY
Definition: CharacterDatabase.h:382
CHAR_SEL_ACCOUNT_DATA
@ CHAR_SEL_ACCOUNT_DATA
Definition: CharacterDatabase.h:280
CHAR_UPD_CHARACTER_POSITION
@ CHAR_UPD_CHARACTER_POSITION
Definition: CharacterDatabase.h:403
CHAR_DEL_RESPAWN
@ CHAR_DEL_RESPAWN
Definition: CharacterDatabase.h:341
CHAR_DEL_ITEM_BOP_TRADE
@ CHAR_DEL_ITEM_BOP_TRADE
Definition: CharacterDatabase.h:152
CHAR_INS_CHAR_ACHIEVEMENT
@ CHAR_INS_CHAR_ACHIEVEMENT
Definition: CharacterDatabase.h:440
CHAR_DEL_CHAR_TRAIT_ENTRIES
@ CHAR_DEL_CHAR_TRAIT_ENTRIES
Definition: CharacterDatabase.h:541
CHAR_DEL_CHAR_QUESTSTATUS_BY_QUEST
@ CHAR_DEL_CHAR_QUESTSTATUS_BY_QUEST
Definition: CharacterDatabase.h:511
CHAR_INS_PET
@ CHAR_INS_PET
Definition: CharacterDatabase.h:592
CHAR_UPD_QUEST_TRACK_GM_COMPLETE
@ CHAR_UPD_QUEST_TRACK_GM_COMPLETE
Definition: CharacterDatabase.h:608
CHAR_SEL_EXPIRED_MAIL_ITEMS
@ CHAR_SEL_EXPIRED_MAIL_ITEMS
Definition: CharacterDatabase.h:146
CHAR_SEL_PETITION
@ CHAR_SEL_PETITION
Definition: CharacterDatabase.h:311
CHAR_DEL_RESET_CHARACTER_QUESTSTATUS_DAILY
@ CHAR_DEL_RESET_CHARACTER_QUESTSTATUS_DAILY
Definition: CharacterDatabase.h:88
CHAR_DEL_CHARACTER_QUESTSTATUS_SEASONAL
@ CHAR_DEL_CHARACTER_QUESTSTATUS_SEASONAL
Definition: CharacterDatabase.h:83
CHAR_UPD_PET_SPECS_BY_OWNER
@ CHAR_UPD_PET_SPECS_BY_OWNER
Definition: CharacterDatabase.h:591
CHAR_DEL_ITEM_INSTANCE_MODIFIERS
@ CHAR_DEL_ITEM_INSTANCE_MODIFIERS
Definition: CharacterDatabase.h:174
CHAR_SEL_MAILITEMS_ARTIFACT
@ CHAR_SEL_MAILITEMS_ARTIFACT
Definition: CharacterDatabase.h:123
CHAR_REP_GM_BUG
@ CHAR_REP_GM_BUG
Definition: CharacterDatabase.h:345
CHAR_DEL_ACCOUNT_DATA
@ CHAR_DEL_ACCOUNT_DATA
Definition: CharacterDatabase.h:282
CHAR_DEL_CHAR_TRAIT_CONFIGS_BY_CHAR
@ CHAR_DEL_CHAR_TRAIT_CONFIGS_BY_CHAR
Definition: CharacterDatabase.h:546
CHAR_SEL_CHARACTER_QUESTSTATUS
@ CHAR_SEL_CHARACTER_QUESTSTATUS
Definition: CharacterDatabase.h:72
CHAR_UPD_CHARACTER_POSITION_BY_MAPID
@ CHAR_UPD_CHARACTER_POSITION_BY_MAPID
Definition: CharacterDatabase.h:404
CHAR_SEL_CHAR_DEL_INFO_BY_GUID
@ CHAR_SEL_CHAR_DEL_INFO_BY_GUID
Definition: CharacterDatabase.h:412
CHAR_DEL_GAME_EVENT_CONDITION_SAVE
@ CHAR_DEL_GAME_EVENT_CONDITION_SAVE
Definition: CharacterDatabase.h:296
CHAR_REP_CHARACTER_ARENA_STATS
@ CHAR_REP_CHARACTER_ARENA_STATS
Definition: CharacterDatabase.h:308
CHAR_INS_CHAR_SPELL_COOLDOWN
@ CHAR_INS_CHAR_SPELL_COOLDOWN
Definition: CharacterDatabase.h:479
CHAR_DEL_CHAR_TRAIT_CONFIGS
@ CHAR_DEL_CHAR_TRAIT_CONFIGS
Definition: CharacterDatabase.h:545
CHAR_UPD_GROUP_TYPE
@ CHAR_UPD_GROUP_TYPE
Definition: CharacterDatabase.h:379
CHAR_INS_ITEM_INSTANCE_AZERITE_MILESTONE_POWER
@ CHAR_INS_ITEM_INSTANCE_AZERITE_MILESTONE_POWER
Definition: CharacterDatabase.h:182
CHAR_SEL_GUILD_MEMBER_EXTENDED
@ CHAR_SEL_GUILD_MEMBER_EXTENDED
Definition: CharacterDatabase.h:103
CHAR_DEL_PLAYER_ACCOUNT_DATA
@ CHAR_DEL_PLAYER_ACCOUNT_DATA
Definition: CharacterDatabase.h:285
CHAR_DEL_BLACKMARKET_AUCTIONS
@ CHAR_DEL_BLACKMARKET_AUCTIONS
Definition: CharacterDatabase.h:629
CHAR_DEL_CHARACTER_GARRISON_BLUEPRINTS
@ CHAR_DEL_CHARACTER_GARRISON_BLUEPRINTS
Definition: CharacterDatabase.h:618
CHAR_UPD_ACCOUNT_ONLINE
@ CHAR_UPD_ACCOUNT_ONLINE
Definition: CharacterDatabase.h:372
CHAR_UPD_GUILD_RANK_RIGHTS
@ CHAR_UPD_GUILD_RANK_RIGHTS
Definition: CharacterDatabase.h:238
CHAR_SEL_BLACKMARKET_AUCTIONS
@ CHAR_SEL_BLACKMARKET_AUCTIONS
Definition: CharacterDatabase.h:628
CHAR_INS_INSTANCE
@ CHAR_INS_INSTANCE
Definition: CharacterDatabase.h:646
CHAR_DEL_ITEM_INSTANCE_TRANSMOG_BY_OWNER
@ CHAR_DEL_ITEM_INSTANCE_TRANSMOG_BY_OWNER
Definition: CharacterDatabase.h:165
CHAR_UPD_PLAYER_HOMEBIND
@ CHAR_UPD_PLAYER_HOMEBIND
Definition: CharacterDatabase.h:324
CHAR_DEL_MAIL
@ CHAR_DEL_MAIL
Definition: CharacterDatabase.h:491
CHAR_INS_CORPSE_CUSTOMIZATIONS
@ CHAR_INS_CORPSE_CUSTOMIZATIONS
Definition: CharacterDatabase.h:335
CHAR_INS_CHAR_GLYPHS
@ CHAR_INS_CHAR_GLYPHS
Definition: CharacterDatabase.h:533
CHAR_UPD_GUILD_MEMBER_PNOTE
@ CHAR_UPD_GUILD_MEMBER_PNOTE
Definition: CharacterDatabase.h:230
CHAR_INS_CHAR_STATS
@ CHAR_INS_CHAR_STATS
Definition: CharacterDatabase.h:530
CHAR_INS_AUCTION_BIDDER
@ CHAR_INS_AUCTION_BIDDER
Definition: CharacterDatabase.h:137
CHAR_DEL_CHAR_ACHIEVEMENT_BY_ACHIEVEMENT
@ CHAR_DEL_CHAR_ACHIEVEMENT_BY_ACHIEVEMENT
Definition: CharacterDatabase.h:468
CHAR_SEL_CHARS_BY_ACCOUNT_ID
@ CHAR_SEL_CHARS_BY_ACCOUNT_ID
Definition: CharacterDatabase.h:416
CHAR_SEL_CHAR_POSITION_XYZ
@ CHAR_SEL_CHAR_POSITION_XYZ
Definition: CharacterDatabase.h:57
CHAR_SEL_CHARACTER_TALENTS
@ CHAR_SEL_CHARACTER_TALENTS
Definition: CharacterDatabase.h:111
CHAR_DEL_CHAR_TALENT
@ CHAR_DEL_CHAR_TALENT
Definition: CharacterDatabase.h:499
CHAR_DEL_CORPSE
@ CHAR_DEL_CORPSE
Definition: CharacterDatabase.h:329
CHAR_UPD_ITEM_INSTANCE_AZERITE_ON_LOAD
@ CHAR_UPD_ITEM_INSTANCE_AZERITE_ON_LOAD
Definition: CharacterDatabase.h:178
CHAR_SEL_MAIL_LIST_INFO
@ CHAR_SEL_MAIL_LIST_INFO
Definition: CharacterDatabase.h:47
CHAR_INS_GM_COMPLAINT_CHATLINE
@ CHAR_INS_GM_COMPLAINT_CHATLINE
Definition: CharacterDatabase.h:353
CHAR_UPD_ITEM_INSTANCE_AZERITE_EMPOWERED
@ CHAR_UPD_ITEM_INSTANCE_AZERITE_EMPOWERED
Definition: CharacterDatabase.h:191
CHAR_UPD_CHARACTER_INSTANCE_LOCK_FORCE_EXPIRE
@ CHAR_UPD_CHARACTER_INSTANCE_LOCK_FORCE_EXPIRE
Definition: CharacterDatabase.h:644
CHAR_SEL_CHAR_CUF_PROFILES
@ CHAR_SEL_CHAR_CUF_PROFILES
Definition: CharacterDatabase.h:553
CHAR_DEL_CHAR_SKILL_BY_SKILL
@ CHAR_DEL_CHAR_SKILL_BY_SKILL
Definition: CharacterDatabase.h:522
CHAR_SEL_MAIL_COUNT_ITEM
@ CHAR_SEL_MAIL_COUNT_ITEM
Definition: CharacterDatabase.h:431
CHAR_SEL_GM_BUGS
@ CHAR_SEL_GM_BUGS
Definition: CharacterDatabase.h:344
CHAR_SEL_CHAR_SOCIAL
@ CHAR_SEL_CHAR_SOCIAL
Definition: CharacterDatabase.h:426
CHAR_INS_PET_SPELL
@ CHAR_INS_PET_SPELL
Definition: CharacterDatabase.h:576
CHAR_INS_ITEM_INSTANCE_AZERITE_UNLOCKED_ESSENCE
@ CHAR_INS_ITEM_INSTANCE_AZERITE_UNLOCKED_ESSENCE
Definition: CharacterDatabase.h:186
CHAR_REP_WORLD_VARIABLE
@ CHAR_REP_WORLD_VARIABLE
Definition: CharacterDatabase.h:397
CHAR_SEL_MAIL
@ CHAR_SEL_MAIL
Definition: CharacterDatabase.h:428
CHAR_UPD_CHARACTER_SOCIAL_NOTE
@ CHAR_UPD_CHARACTER_SOCIAL_NOTE
Definition: CharacterDatabase.h:402
CHAR_SEL_CHARACTER_SPELL_FAVORITES
@ CHAR_SEL_CHARACTER_SPELL_FAVORITES
Definition: CharacterDatabase.h:70
CHAR_SEL_UNDELETE_ENUM
@ CHAR_SEL_UNDELETE_ENUM
Definition: CharacterDatabase.h:52
CHAR_DEL_ITEM_INSTANCE_AZERITE_EMPOWERED_BY_OWNER
@ CHAR_DEL_ITEM_INSTANCE_AZERITE_EMPOWERED_BY_OWNER
Definition: CharacterDatabase.h:193
CHAR_DEL_CHAR_PET_BY_ID
@ CHAR_DEL_CHAR_PET_BY_ID
Definition: CharacterDatabase.h:589
CHAR_INS_GUILD_BANK_TAB
@ CHAR_INS_GUILD_BANK_TAB
Definition: CharacterDatabase.h:214
CHAR_SEL_CORPSE_LOCATION
@ CHAR_SEL_CORPSE_LOCATION
Definition: CharacterDatabase.h:337
CHAR_INS_CHARACTER_GARRISON_FOLLOWER_ABILITIES
@ CHAR_INS_CHARACTER_GARRISON_FOLLOWER_ABILITIES
Definition: CharacterDatabase.h:626
CHAR_SEL_CHAR_DATA_FOR_GUILD
@ CHAR_SEL_CHAR_DATA_FOR_GUILD
Definition: CharacterDatabase.h:247
CHAR_UPD_CHARACTER_SOCIAL_FLAGS
@ CHAR_UPD_CHARACTER_SOCIAL_FLAGS
Definition: CharacterDatabase.h:399
CHAR_UPD_GUILD_BANK_MONEY
@ CHAR_UPD_GUILD_BANK_MONEY
Definition: CharacterDatabase.h:241
CHAR_INS_AUCTION
@ CHAR_INS_AUCTION
Definition: CharacterDatabase.h:129
CHAR_INS_CHARACTER_QUESTSTATUS_WEEKLY
@ CHAR_INS_CHARACTER_QUESTSTATUS_WEEKLY
Definition: CharacterDatabase.h:85
CHAR_DEL_PET_AURAS
@ CHAR_DEL_PET_AURAS
Definition: CharacterDatabase.h:568
CHAR_SEL_CHARACTER_CRITERIAPROGRESS
@ CHAR_SEL_CHARACTER_CRITERIAPROGRESS
Definition: CharacterDatabase.h:106
CHAR_INS_CHARACTER_GARRISON
@ CHAR_INS_CHARACTER_GARRISON
Definition: CharacterDatabase.h:613
CHAR_UPD_GROUP_RAID_DIFFICULTY
@ CHAR_UPD_GROUP_RAID_DIFFICULTY
Definition: CharacterDatabase.h:383
CHAR_DEL_ITEM_REFUND_INSTANCE
@ CHAR_DEL_ITEM_REFUND_INSTANCE
Definition: CharacterDatabase.h:445
CHAR_DEL_GUILD_BANK_TAB
@ CHAR_DEL_GUILD_BANK_TAB
Definition: CharacterDatabase.h:215
CHAR_DEL_INVALID_ACHIEVMENT
@ CHAR_DEL_INVALID_ACHIEVMENT
Definition: CharacterDatabase.h:392
CHAR_DEL_CHAR_INVENTORY
@ CHAR_DEL_CHAR_INVENTORY
Definition: CharacterDatabase.h:487
CHAR_UPD_ARENA_TEAM_MEMBER
@ CHAR_UPD_ARENA_TEAM_MEMBER
Definition: CharacterDatabase.h:306
CHAR_DEL_BATTLEGROUND_RANDOM_ALL
@ CHAR_DEL_BATTLEGROUND_RANDOM_ALL
Definition: CharacterDatabase.h:60
CHAR_DEL_ACCOUNT_INSTANCE_LOCK_TIMES
@ CHAR_DEL_ACCOUNT_INSTANCE_LOCK_TIMES
Definition: CharacterDatabase.h:199
CHAR_SEL_AUCTIONHOUSE_COUNT_ITEM
@ CHAR_SEL_AUCTIONHOUSE_COUNT_ITEM
Definition: CharacterDatabase.h:432
CHAR_SEL_PET_DECLINED_NAME
@ CHAR_SEL_PET_DECLINED_NAME
Definition: CharacterDatabase.h:567
CHAR_SEL_CHARACTER_GLYPHS
@ CHAR_SEL_CHARACTER_GLYPHS
Definition: CharacterDatabase.h:110
CHAR_SEL_CHARACTER_REPUTATION
@ CHAR_SEL_CHARACTER_REPUTATION
Definition: CharacterDatabase.h:93
CHAR_DEL_CHAR_AURA
@ CHAR_DEL_CHAR_AURA
Definition: CharacterDatabase.h:484
CHAR_INS_CHARACTER
@ CHAR_INS_CHARACTER
Definition: CharacterDatabase.h:363
CHAR_UPD_GROUP_MEMBER_FLAG
@ CHAR_UPD_GROUP_MEMBER_FLAG
Definition: CharacterDatabase.h:381
MAX_CHARACTERDATABASE_STATEMENTS
@ MAX_CHARACTERDATABASE_STATEMENTS
Definition: CharacterDatabase.h:648
CHAR_DEL_CHAR_QUESTSTATUS
@ CHAR_DEL_CHAR_QUESTSTATUS
Definition: CharacterDatabase.h:461
CHAR_DEL_CHAR_ACTION
@ CHAR_DEL_CHAR_ACTION
Definition: CharacterDatabase.h:483
CHAR_DEL_CHARACTER_INSTANCE_LOCK_BY_GUID
@ CHAR_DEL_CHARACTER_INSTANCE_LOCK_BY_GUID
Definition: CharacterDatabase.h:641
CHAR_SEL_CHARACTER_SPELL
@ CHAR_SEL_CHARACTER_SPELL
Definition: CharacterDatabase.h:69
CHAR_DEL_GUILD_MEMBERS
@ CHAR_DEL_GUILD_MEMBERS
Definition: CharacterDatabase.h:210
CHAR_SEL_MATCH_MAKER_RATING
@ CHAR_SEL_MATCH_MAKER_RATING
Definition: CharacterDatabase.h:201
CHAR_INS_GUILD_MEMBER_WITHDRAW_TABS
@ CHAR_INS_GUILD_MEMBER_WITHDRAW_TABS
Definition: CharacterDatabase.h:244
CHAR_DEL_GM_COMPLAINT
@ CHAR_DEL_GM_COMPLAINT
Definition: CharacterDatabase.h:351
CHAR_REP_CHAR_QUESTSTATUS_OBJECTIVES
@ CHAR_REP_CHAR_QUESTSTATUS_OBJECTIVES
Definition: CharacterDatabase.h:512
CHAR_UPD_ARENA_TEAM_NAME
@ CHAR_UPD_ARENA_TEAM_NAME
Definition: CharacterDatabase.h:309
CHAR_INS_MAIL
@ CHAR_INS_MAIL
Definition: CharacterDatabase.h:139
CHAR_SEL_CORPSES
@ CHAR_SEL_CORPSES
Definition: CharacterDatabase.h:327
CHAR_SEL_CHAR_PET_IDS
@ CHAR_SEL_CHAR_PET_IDS
Definition: CharacterDatabase.h:583
CHAR_DEL_ITEM_INSTANCE_AZERITE_UNLOCKED_ESSENCE
@ CHAR_DEL_ITEM_INSTANCE_AZERITE_UNLOCKED_ESSENCE
Definition: CharacterDatabase.h:187
CHAR_SEL_ITEM_BOP_TRADE
@ CHAR_SEL_ITEM_BOP_TRADE
Definition: CharacterDatabase.h:151
CHAR_UPD_CHAR_REP_FACTION_CHANGE
@ CHAR_UPD_CHAR_REP_FACTION_CHANGE
Definition: CharacterDatabase.h:475
CHAR_UPD_GUILD_MEMBER_OFFNOTE
@ CHAR_UPD_GUILD_MEMBER_OFFNOTE
Definition: CharacterDatabase.h:231
CHAR_SEL_PETITION_SIGNATURE
@ CHAR_SEL_PETITION_SIGNATURE
Definition: CharacterDatabase.h:312
CHAR_INS_CHAR_GIFT
@ CHAR_INS_CHAR_GIFT
Definition: CharacterDatabase.h:449
CHAR_DEL_ITEM_INSTANCE_MODIFIERS_BY_OWNER
@ CHAR_DEL_ITEM_INSTANCE_MODIFIERS_BY_OWNER
Definition: CharacterDatabase.h:175
CHAR_DEL_GUILD_BANK_EVENTLOG
@ CHAR_DEL_GUILD_BANK_EVENTLOG
Definition: CharacterDatabase.h:225
CHAR_INS_ITEM_INSTANCE_MODIFIERS
@ CHAR_INS_ITEM_INSTANCE_MODIFIERS
Definition: CharacterDatabase.h:173
CHAR_UPD_ACCOUNT_BY_GUID
@ CHAR_UPD_ACCOUNT_BY_GUID
Definition: CharacterDatabase.h:198
CHAR_DEL_GUILD_MEMBER_WITHDRAW
@ CHAR_DEL_GUILD_MEMBER_WITHDRAW
Definition: CharacterDatabase.h:246
CHAR_DEL_GUILD_MEMBER
@ CHAR_DEL_GUILD_MEMBER
Definition: CharacterDatabase.h:209
CHAR_DEL_MAIL_BY_ID
@ CHAR_DEL_MAIL_BY_ID
Definition: CharacterDatabase.h:140
CHAR_SEL_PETITION_SIGNATURES
@ CHAR_SEL_PETITION_SIGNATURES
Definition: CharacterDatabase.h:315
CHAR_REP_PLAYER_ACCOUNT_DATA
@ CHAR_REP_PLAYER_ACCOUNT_DATA
Definition: CharacterDatabase.h:284
CHAR_DEL_AUCTION_ITEMS_BY_ITEM
@ CHAR_DEL_AUCTION_ITEMS_BY_ITEM
Definition: CharacterDatabase.h:135
CHAR_INS_ITEMCONTAINER_ITEMS
@ CHAR_INS_ITEMCONTAINER_ITEMS
Definition: CharacterDatabase.h:597
CHAR_UPD_GROUP_LEADER
@ CHAR_UPD_GROUP_LEADER
Definition: CharacterDatabase.h:378
CHAR_INS_ITEMCONTAINER_MONEY
@ CHAR_INS_ITEMCONTAINER_MONEY
Definition: CharacterDatabase.h:600
CHAR_SEL_GUILD_BANK_COUNT_ITEM
@ CHAR_SEL_GUILD_BANK_COUNT_ITEM
Definition: CharacterDatabase.h:433
CHAR_DEL_CHARACTER_SOCIAL
@ CHAR_DEL_CHARACTER_SOCIAL
Definition: CharacterDatabase.h:401
CHAR_DEL_CHAR_ACHIEVEMENTS
@ CHAR_DEL_CHAR_ACHIEVEMENTS
Definition: CharacterDatabase.h:493
CHAR_SEL_CHARACTER_QUESTSTATUS_SEASONAL
@ CHAR_SEL_CHARACTER_QUESTSTATUS_SEASONAL
Definition: CharacterDatabase.h:79
CHAR_SEL_CHAR_PINFO
@ CHAR_SEL_CHAR_PINFO
Definition: CharacterDatabase.h:417
CHAR_INS_PETITION
@ CHAR_INS_PETITION
Definition: CharacterDatabase.h:451
CHAR_DEL_CORPSE_PHASES
@ CHAR_DEL_CORPSE_PHASES
Definition: CharacterDatabase.h:333
CHAR_DEL_CHARACTER_GARRISON_BUILDINGS
@ CHAR_DEL_CHARACTER_GARRISON_BUILDINGS
Definition: CharacterDatabase.h:621
CHAR_UPD_CHAR_RACE
@ CHAR_UPD_CHAR_RACE
Definition: CharacterDatabase.h:456
CHAR_INS_LFG_DATA
@ CHAR_INS_LFG_DATA
Definition: CharacterDatabase.h:406
CHAR_INS_PLAYER_BGDATA
@ CHAR_INS_PLAYER_BGDATA
Definition: CharacterDatabase.h:320
CHAR_SEL_GUID_BY_NAME_FILTER
@ CHAR_SEL_GUID_BY_NAME_FILTER
Definition: CharacterDatabase.h:43
CHAR_SEL_CHARACTER_RANDOMBG
@ CHAR_SEL_CHARACTER_RANDOMBG
Definition: CharacterDatabase.h:114
CHAR_SEL_CHARACTER_EQUIPMENTSETS
@ CHAR_SEL_CHARACTER_EQUIPMENTSETS
Definition: CharacterDatabase.h:107
CHAR_SEL_CHARACTER_SKILLS
@ CHAR_SEL_CHARACTER_SKILLS
Definition: CharacterDatabase.h:113
CHAR_INS_CHAR_SPELL_CHARGES
@ CHAR_INS_CHAR_SPELL_CHARGES
Definition: CharacterDatabase.h:481
CHAR_DEL_CHAR_VOID_STORAGE_ITEM_BY_CHAR_GUID
@ CHAR_DEL_CHAR_VOID_STORAGE_ITEM_BY_CHAR_GUID
Definition: CharacterDatabase.h:550
CHAR_UPD_ZONE
@ CHAR_UPD_ZONE
Definition: CharacterDatabase.h:388
CHAR_SEL_CHARACTER_QUESTSTATUS_DAILY
@ CHAR_SEL_CHARACTER_QUESTSTATUS_DAILY
Definition: CharacterDatabase.h:76
CHAR_DEL_GUILD_BANK_ITEMS
@ CHAR_DEL_GUILD_BANK_ITEMS
Definition: CharacterDatabase.h:220
CHAR_INS_GAME_EVENT_CONDITION_SAVE
@ CHAR_INS_GAME_EVENT_CONDITION_SAVE
Definition: CharacterDatabase.h:297
CHAR_REP_PLAYER_CURRENCY
@ CHAR_REP_PLAYER_CURRENCY
Definition: CharacterDatabase.h:277
CHAR_UPD_ARENA_TEAM_CAPTAIN
@ CHAR_UPD_ARENA_TEAM_CAPTAIN
Definition: CharacterDatabase.h:303
CHAR_UPD_CHAR_TITLES_FACTION_CHANGE
@ CHAR_UPD_CHAR_TITLES_FACTION_CHANGE
Definition: CharacterDatabase.h:476
CHAR_DEL_GUILD_BANK_ITEM
@ CHAR_DEL_GUILD_BANK_ITEM
Definition: CharacterDatabase.h:218
CHAR_SEL_GM_COMPLAINT_CHATLINES
@ CHAR_SEL_GM_COMPLAINT_CHATLINES
Definition: CharacterDatabase.h:352
CHAR_SEL_CHAR_COD_ITEM_MAIL
@ CHAR_SEL_CHAR_COD_ITEM_MAIL
Definition: CharacterDatabase.h:425
CHAR_SEL_AUCTIONHOUSE_ITEM_BY_ENTRY
@ CHAR_SEL_AUCTIONHOUSE_ITEM_BY_ENTRY
Definition: CharacterDatabase.h:436
CHAR_DEL_GUILD_EVENTLOG
@ CHAR_DEL_GUILD_EVENTLOG
Definition: CharacterDatabase.h:228
CHAR_DEL_CHAR_REP_BY_FACTION
@ CHAR_DEL_CHAR_REP_BY_FACTION
Definition: CharacterDatabase.h:474
CHAR_REP_WORLD_STATE
@ CHAR_REP_WORLD_STATE
Definition: CharacterDatabase.h:396
CHAR_INS_ITEM_INSTANCE_TRANSMOG
@ CHAR_INS_ITEM_INSTANCE_TRANSMOG
Definition: CharacterDatabase.h:163
CHAR_UPD_CHARACTER_GARRISON_FOLLOWER_ACTIVATIONS
@ CHAR_UPD_CHARACTER_GARRISON_FOLLOWER_ACTIVATIONS
Definition: CharacterDatabase.h:615
CHAR_UPD_GUILD_INFO
@ CHAR_UPD_GUILD_INFO
Definition: CharacterDatabase.h:234
CHAR_DEL_CHAR_ACTION_BY_TRAIT_CONFIG
@ CHAR_DEL_CHAR_ACTION_BY_TRAIT_CONFIG
Definition: CharacterDatabase.h:506
CHAR_DEL_CHAR_VOID_STORAGE_ITEM_BY_SLOT
@ CHAR_DEL_CHAR_VOID_STORAGE_ITEM_BY_SLOT
Definition: CharacterDatabase.h:551
CHAR_INS_ARENA_TEAM
@ CHAR_INS_ARENA_TEAM
Definition: CharacterDatabase.h:299
CHAR_SEL_ENUM_DECLINED_NAME
@ CHAR_SEL_ENUM_DECLINED_NAME
Definition: CharacterDatabase.h:50
CHAR_DEL_PETITION_SIGNATURE_BY_GUID
@ CHAR_DEL_PETITION_SIGNATURE_BY_GUID
Definition: CharacterDatabase.h:453
CHAR_SEL_CHARACTER_SPELLCOOLDOWNS
@ CHAR_SEL_CHARACTER_SPELLCOOLDOWNS
Definition: CharacterDatabase.h:99
CHAR_SEL_ITEMCONTAINER_MONEY
@ CHAR_SEL_ITEMCONTAINER_MONEY
Definition: CharacterDatabase.h:598
CHAR_DEL_GUILD_EVENTLOGS
@ CHAR_DEL_GUILD_EVENTLOGS
Definition: CharacterDatabase.h:229
CHAR_INS_ITEM_INSTANCE_ARTIFACT
@ CHAR_INS_ITEM_INSTANCE_ARTIFACT
Definition: CharacterDatabase.h:167
CHAR_SEL_GUILD_BANK_ITEM_BY_ENTRY
@ CHAR_SEL_GUILD_BANK_ITEM_BY_ENTRY
Definition: CharacterDatabase.h:437
CHAR_INS_GUILD_BANK_EVENTLOG
@ CHAR_INS_GUILD_BANK_EVENTLOG
Definition: CharacterDatabase.h:224
CHAR_INS_QUEST_TRACK
@ CHAR_INS_QUEST_TRACK
Definition: CharacterDatabase.h:607
CHAR_UPD_ADD_AT_LOGIN_FLAG
@ CHAR_UPD_ADD_AT_LOGIN_FLAG
Definition: CharacterDatabase.h:366
CHAR_INS_CHAR_PVP_TALENT
@ CHAR_INS_CHAR_PVP_TALENT
Definition: CharacterDatabase.h:535
CHAR_RES_CHAR_TITLES_FACTION_CHANGE
@ CHAR_RES_CHAR_TITLES_FACTION_CHANGE
Definition: CharacterDatabase.h:477
CHAR_UPD_GIFT_OWNER
@ CHAR_UPD_GIFT_OWNER
Definition: CharacterDatabase.h:194
CHAR_INS_ITEM_INSTANCE_GEMS
@ CHAR_INS_ITEM_INSTANCE_GEMS
Definition: CharacterDatabase.h:160
CHAR_DEL_CORPSES_FROM_MAP
@ CHAR_DEL_CORPSES_FROM_MAP
Definition: CharacterDatabase.h:330
CHAR_INS_CHAR_QUESTSTATUS_OBJECTIVES_CRITERIA
@ CHAR_INS_CHAR_QUESTSTATUS_OBJECTIVES_CRITERIA
Definition: CharacterDatabase.h:514
CHAR_DEL_RESET_CHARACTER_QUESTSTATUS_WEEKLY
@ CHAR_DEL_RESET_CHARACTER_QUESTSTATUS_WEEKLY
Definition: CharacterDatabase.h:89
CHAR_SEL_PET_AURA_EFFECT
@ CHAR_SEL_PET_AURA_EFFECT
Definition: CharacterDatabase.h:564
CHAR_DEL_CHAR_REPUTATION
@ CHAR_DEL_CHAR_REPUTATION
Definition: CharacterDatabase.h:489
CHAR_DEL_CHAR_TRAIT_ENTRIES_BY_CHAR
@ CHAR_DEL_CHAR_TRAIT_ENTRIES_BY_CHAR
Definition: CharacterDatabase.h:542
CHAR_DEL_PET_SPELL_BY_SPELL
@ CHAR_DEL_PET_SPELL_BY_SPELL
Definition: CharacterDatabase.h:575
CHAR_DEL_OLD_CHANNELS
@ CHAR_DEL_OLD_CHANNELS
Definition: CharacterDatabase.h:262
CHAR_INS_CHARACTER_SOCIAL
@ CHAR_INS_CHARACTER_SOCIAL
Definition: CharacterDatabase.h:400
CHAR_DEL_GIFT
@ CHAR_DEL_GIFT
Definition: CharacterDatabase.h:195
CHAR_UPD_CHARACTER
@ CHAR_UPD_CHARACTER
Definition: CharacterDatabase.h:364
CHAR_SEL_RESPAWNS
@ CHAR_SEL_RESPAWNS
Definition: CharacterDatabase.h:339
CHAR_DEL_ITEM_INSTANCE_ARTIFACT_BY_OWNER
@ CHAR_DEL_ITEM_INSTANCE_ARTIFACT_BY_OWNER
Definition: CharacterDatabase.h:169
CHAR_DEL_CHARACTER_AURA_STORED_LOCATION
@ CHAR_DEL_CHARACTER_AURA_STORED_LOCATION
Definition: CharacterDatabase.h:635
CHAR_DEL_PET_SPELL_COOLDOWNS
@ CHAR_DEL_PET_SPELL_COOLDOWNS
Definition: CharacterDatabase.h:570
CHAR_DEL_ITEM_INSTANCE_AZERITE
@ CHAR_DEL_ITEM_INSTANCE_AZERITE
Definition: CharacterDatabase.h:179
CHAR_SEL_PET_SPELL
@ CHAR_SEL_PET_SPELL
Definition: CharacterDatabase.h:565
CHAR_SEL_CHARACTER_AURA_STORED_LOCATIONS
@ CHAR_SEL_CHARACTER_AURA_STORED_LOCATIONS
Definition: CharacterDatabase.h:633
CHAR_DEL_CHAR_INVENTORY_BY_BAG_SLOT
@ CHAR_DEL_CHAR_INVENTORY_BY_BAG_SLOT
Definition: CharacterDatabase.h:508
CHAR_SEL_PINFO_MAILS
@ CHAR_SEL_PINFO_MAILS
Definition: CharacterDatabase.h:419
CHAR_SEL_CHARACTER_TRANSMOG_OUTFITS
@ CHAR_SEL_CHARACTER_TRANSMOG_OUTFITS
Definition: CharacterDatabase.h:108
CHAR_INS_CHAR_REPUTATION_BY_FACTION
@ CHAR_INS_CHAR_REPUTATION_BY_FACTION
Definition: CharacterDatabase.h:444
CHAR_SEL_UNDELETE_ENUM_CUSTOMIZATIONS
@ CHAR_SEL_UNDELETE_ENUM_CUSTOMIZATIONS
Definition: CharacterDatabase.h:54
CHAR_INS_CHAR_ACTION
@ CHAR_INS_CHAR_ACTION
Definition: CharacterDatabase.h:503
CHAR_DEL_CHAR_ACHIEVEMENT_PROGRESS
@ CHAR_DEL_CHAR_ACHIEVEMENT_PROGRESS
Definition: CharacterDatabase.h:439
CHAR_DEL_CHARACTER
@ CHAR_DEL_CHARACTER
Definition: CharacterDatabase.h:482
CHAR_SEL_ITEM_REFUNDS
@ CHAR_SEL_ITEM_REFUNDS
Definition: CharacterDatabase.h:150
CHAR_SEL_CHAR_INVENTORY_COUNT_ITEM
@ CHAR_SEL_CHAR_INVENTORY_COUNT_ITEM
Definition: CharacterDatabase.h:430
CHAR_SEL_CHARACTER_GARRISON_BLUEPRINTS
@ CHAR_SEL_CHARACTER_GARRISON_BLUEPRINTS
Definition: CharacterDatabase.h:616
CHAR_INS_CHARACTER_QUESTSTATUS_MONTHLY
@ CHAR_INS_CHARACTER_QUESTSTATUS_MONTHLY
Definition: CharacterDatabase.h:86
CHAR_SEL_ITEM_INSTANCE_AZERITE
@ CHAR_SEL_ITEM_INSTANCE_AZERITE
Definition: CharacterDatabase.h:176
CHAR_SEL_CHARACTER_SPELL_CHARGES
@ CHAR_SEL_CHARACTER_SPELL_CHARGES
Definition: CharacterDatabase.h:100
CHAR_SEL_PET_SPELL_COOLDOWN
@ CHAR_SEL_PET_SPELL_COOLDOWN
Definition: CharacterDatabase.h:566
CHAR_DEL_CHAR_PVP_TALENT
@ CHAR_DEL_CHAR_PVP_TALENT
Definition: CharacterDatabase.h:500
CHAR_UPD_CHAR_MONEY
@ CHAR_UPD_CHAR_MONEY
Definition: CharacterDatabase.h:502
CHAR_SEL_CHARACTER_AURA_EFFECTS
@ CHAR_SEL_CHARACTER_AURA_EFFECTS
Definition: CharacterDatabase.h:68
CHAR_REP_ITEM_INSTANCE
@ CHAR_REP_ITEM_INSTANCE
Definition: CharacterDatabase.h:155
CHAR_UPD_CHAR_QUESTSTATUS_REWARDED_ACTIVE
@ CHAR_UPD_CHAR_QUESTSTATUS_REWARDED_ACTIVE
Definition: CharacterDatabase.h:519
CHAR_UPD_AUCTION_BID
@ CHAR_UPD_AUCTION_BID
Definition: CharacterDatabase.h:131
CHAR_DEL_GUILD_RANKS
@ CHAR_DEL_GUILD_RANKS
Definition: CharacterDatabase.h:212
CHAR_SEL_PET_SPELL_CHARGES
@ CHAR_SEL_PET_SPELL_CHARGES
Definition: CharacterDatabase.h:572
CHAR_DEL_CHAR_SOCIAL_BY_GUID
@ CHAR_DEL_CHAR_SOCIAL_BY_GUID
Definition: CharacterDatabase.h:466
CHAR_INS_CHARACTER_GARRISON_FOLLOWERS
@ CHAR_INS_CHARACTER_GARRISON_FOLLOWERS
Definition: CharacterDatabase.h:623
CHAR_SEL_CHARACTER_GIFT_BY_ITEM
@ CHAR_SEL_CHARACTER_GIFT_BY_ITEM
Definition: CharacterDatabase.h:196
CHAR_INS_GUILD_ACHIEVEMENT
@ CHAR_INS_GUILD_ACHIEVEMENT
Definition: CharacterDatabase.h:249
CHAR_SEL_CHARACTER_ACHIEVEMENTS
@ CHAR_SEL_CHARACTER_ACHIEVEMENTS
Definition: CharacterDatabase.h:105
CHAR_SEL_CHARACTER_ONLINE
@ CHAR_SEL_CHARACTER_ONLINE
Definition: CharacterDatabase.h:410
CHAR_SEL_MAILITEMS_AZERITE_EMPOWERED
@ CHAR_SEL_MAILITEMS_AZERITE_EMPOWERED
Definition: CharacterDatabase.h:127
CHAR_SEL_CHARACTER_QUESTSTATUS_OBJECTIVES
@ CHAR_SEL_CHARACTER_QUESTSTATUS_OBJECTIVES
Definition: CharacterDatabase.h:73
CHAR_UPD_CHARACTER_INSTANCE_LOCK_EXTENSION
@ CHAR_UPD_CHARACTER_INSTANCE_LOCK_EXTENSION
Definition: CharacterDatabase.h:643
CHAR_DEL_GUILD_ACHIEVEMENT
@ CHAR_DEL_GUILD_ACHIEVEMENT
Definition: CharacterDatabase.h:248
CHAR_DEL_EXPIRED_BANS
@ CHAR_DEL_EXPIRED_BANS
Definition: CharacterDatabase.h:34
CHAR_DEL_CHAR_AURA_EFFECT
@ CHAR_DEL_CHAR_AURA_EFFECT
Definition: CharacterDatabase.h:485
CHAR_DEL_GUILD_ACHIEVEMENT_CRITERIA
@ CHAR_DEL_GUILD_ACHIEVEMENT_CRITERIA
Definition: CharacterDatabase.h:250
CHAR_UPD_GUILD_RANK_ORDER
@ CHAR_UPD_GUILD_RANK_ORDER
Definition: CharacterDatabase.h:236
CHAR_INS_CHAR_TRAIT_CONFIGS
@ CHAR_INS_CHAR_TRAIT_CONFIGS
Definition: CharacterDatabase.h:544
CHAR_SEL_CHARACTER_GARRISON_FOLLOWERS
@ CHAR_SEL_CHARACTER_GARRISON_FOLLOWERS
Definition: CharacterDatabase.h:622
CHAR_DEL_ALL_GUILD_ACHIEVEMENT_CRITERIA
@ CHAR_DEL_ALL_GUILD_ACHIEVEMENT_CRITERIA
Definition: CharacterDatabase.h:253
CHAR_INS_PVPSTATS_BATTLEGROUND
@ CHAR_INS_PVPSTATS_BATTLEGROUND
Definition: CharacterDatabase.h:603
CHAR_SEL_PINFO_BANS
@ CHAR_SEL_PINFO_BANS
Definition: CharacterDatabase.h:420
CHAR_UPD_RESTORE_DELETE_INFO
@ CHAR_UPD_RESTORE_DELETE_INFO
Definition: CharacterDatabase.h:387
CHAR_UPD_GROUP_MEMBER_SUBGROUP
@ CHAR_UPD_GROUP_MEMBER_SUBGROUP
Definition: CharacterDatabase.h:380
CHAR_SEL_CHAR_ZONE
@ CHAR_SEL_CHAR_ZONE
Definition: CharacterDatabase.h:56
CHAR_SEL_ITEM_INSTANCE_ARTIFACT
@ CHAR_SEL_ITEM_INSTANCE_ARTIFACT
Definition: CharacterDatabase.h:166
CHAR_DEL_PLAYER_CURRENCY
@ CHAR_DEL_PLAYER_CURRENCY
Definition: CharacterDatabase.h:278
CHAR_REP_ACCOUNT_DATA
@ CHAR_REP_ACCOUNT_DATA
Definition: CharacterDatabase.h:281
CHAR_INS_TRANSMOG_OUTFIT
@ CHAR_INS_TRANSMOG_OUTFIT
Definition: CharacterDatabase.h:269
CHAR_INS_ITEM_BOP_TRADE
@ CHAR_INS_ITEM_BOP_TRADE
Definition: CharacterDatabase.h:153
CHAR_DEL_CHAR_QUESTSTATUS_OBJECTIVES_CRITERIA
@ CHAR_DEL_CHAR_QUESTSTATUS_OBJECTIVES_CRITERIA
Definition: CharacterDatabase.h:463
CHAR_DEL_MAIL_ITEM_BY_ID
@ CHAR_DEL_MAIL_ITEM_BY_ID
Definition: CharacterDatabase.h:450
CHAR_DEL_PET_AURA_EFFECTS
@ CHAR_DEL_PET_AURA_EFFECTS
Definition: CharacterDatabase.h:569
CHAR_DEL_GUILD_RANK
@ CHAR_DEL_GUILD_RANK
Definition: CharacterDatabase.h:213
CHAR_DEL_CHAR_REPUTATION_BY_FACTION
@ CHAR_DEL_CHAR_REPUTATION_BY_FACTION
Definition: CharacterDatabase.h:443
CHAR_INS_GUILD_BANK_ITEM
@ CHAR_INS_GUILD_BANK_ITEM
Definition: CharacterDatabase.h:217
CHAR_DEL_ITEM_INSTANCE_AZERITE_UNLOCKED_ESSENCE_BY_OWNER
@ CHAR_DEL_ITEM_INSTANCE_AZERITE_UNLOCKED_ESSENCE_BY_OWNER
Definition: CharacterDatabase.h:188
CHAR_SEL_GUILD_MEMBER
@ CHAR_SEL_GUILD_MEMBER
Definition: CharacterDatabase.h:102
CHAR_REP_CHAR_QUESTSTATUS
@ CHAR_REP_CHAR_QUESTSTATUS
Definition: CharacterDatabase.h:510
CHAR_UPD_GROUP_LEGACY_RAID_DIFFICULTY
@ CHAR_UPD_GROUP_LEGACY_RAID_DIFFICULTY
Definition: CharacterDatabase.h:384
CHAR_SEL_CHARACTER_DECLINEDNAMES
@ CHAR_SEL_CHARACTER_DECLINEDNAMES
Definition: CharacterDatabase.h:101
CHAR_SEL_CHARACTER_ARENAINFO
@ CHAR_SEL_CHARACTER_ARENAINFO
Definition: CharacterDatabase.h:104
CHAR_INS_GUILD_MEMBER_WITHDRAW_MONEY
@ CHAR_INS_GUILD_MEMBER_WITHDRAW_MONEY
Definition: CharacterDatabase.h:245
CHAR_DEL_CHAR_SPELL
@ CHAR_DEL_CHAR_SPELL
Definition: CharacterDatabase.h:490
CHAR_DEL_INVALID_ACHIEV_PROGRESS_CRITERIA
@ CHAR_DEL_INVALID_ACHIEV_PROGRESS_CRITERIA
Definition: CharacterDatabase.h:390
CHAR_INS_CORPSE
@ CHAR_INS_CORPSE
Definition: CharacterDatabase.h:328
CHAR_UPD_CHAR_NAME_AT_LOGIN
@ CHAR_UPD_CHAR_NAME_AT_LOGIN
Definition: CharacterDatabase.h:395
CHAR_UPD_TRANSMOG_OUTFIT
@ CHAR_UPD_TRANSMOG_OUTFIT
Definition: CharacterDatabase.h:268
CHAR_DEL_CHAR_QUESTSTATUS_REWARDED
@ CHAR_DEL_CHAR_QUESTSTATUS_REWARDED
Definition: CharacterDatabase.h:488
CHAR_UPD_GUILD_BANK_TAB_INFO
@ CHAR_UPD_GUILD_BANK_TAB_INFO
Definition: CharacterDatabase.h:240
CHAR_DEL_CHAR_QUESTSTATUS_OBJECTIVES_BY_QUEST
@ CHAR_DEL_CHAR_QUESTSTATUS_OBJECTIVES_BY_QUEST
Definition: CharacterDatabase.h:513
CHAR_DEL_CHAR_QUESTSTATUS_OBJECTIVES_CRITERIA_PROGRESS_BY_CRITERIA
@ CHAR_DEL_CHAR_QUESTSTATUS_OBJECTIVES_CRITERIA_PROGRESS_BY_CRITERIA
Definition: CharacterDatabase.h:465
CHAR_INS_PET_AURA
@ CHAR_INS_PET_AURA
Definition: CharacterDatabase.h:577
CHAR_INS_CHAR_DECLINED_NAME
@ CHAR_INS_CHAR_DECLINED_NAME
Definition: CharacterDatabase.h:455
CHAR_DEL_GM_COMPLAINT_CHATLOG
@ CHAR_DEL_GM_COMPLAINT_CHATLOG
Definition: CharacterDatabase.h:354
CHAR_UPD_CHAR_PET_NAME
@ CHAR_UPD_CHAR_PET_NAME
Definition: CharacterDatabase.h:587
CHAR_DEL_PETITION_BY_OWNER
@ CHAR_DEL_PETITION_BY_OWNER
Definition: CharacterDatabase.h:531
CHAR_DEL_CHAR_SPELL_CHARGES
@ CHAR_DEL_CHAR_SPELL_CHARGES
Definition: CharacterDatabase.h:480
CHAR_SEL_CHARACTER_BANNED
@ CHAR_SEL_CHARACTER_BANNED
Definition: CharacterDatabase.h:115
CHAR_DEL_CHARACTER_QUESTSTATUS_MONTHLY
@ CHAR_DEL_CHARACTER_QUESTSTATUS_MONTHLY
Definition: CharacterDatabase.h:82
CHAR_UPD_ALL_AT_LOGIN_FLAGS
@ CHAR_UPD_ALL_AT_LOGIN_FLAGS
Definition: CharacterDatabase.h:368
CHAR_DEL_GROUP_MEMBER
@ CHAR_DEL_GROUP_MEMBER
Definition: CharacterDatabase.h:377
CHAR_DEL_ITEM_INSTANCE_GEMS_BY_OWNER
@ CHAR_DEL_ITEM_INSTANCE_GEMS_BY_OWNER
Definition: CharacterDatabase.h:162
CHAR_INS_CHAR_QUESTSTATUS_OBJECTIVES_CRITERIA_PROGRESS
@ CHAR_INS_CHAR_QUESTSTATUS_OBJECTIVES_CRITERIA_PROGRESS
Definition: CharacterDatabase.h:515
CHAR_DEL_ITEM_INSTANCE_AZERITE_MILESTONE_POWER
@ CHAR_DEL_ITEM_INSTANCE_AZERITE_MILESTONE_POWER
Definition: CharacterDatabase.h:183
CHAR_INS_ACCOUNT_INSTANCE_LOCK_TIMES
@ CHAR_INS_ACCOUNT_INSTANCE_LOCK_TIMES
Definition: CharacterDatabase.h:200
CHAR_DEL_INVALID_ACHIEV_PROGRESS_CRITERIA_GUILD
@ CHAR_DEL_INVALID_ACHIEV_PROGRESS_CRITERIA_GUILD
Definition: CharacterDatabase.h:391
CHAR_SEL_WAR_MODE_TUNING
@ CHAR_SEL_WAR_MODE_TUNING
Definition: CharacterDatabase.h:638
CHAR_DEL_ARENA_TEAM_MEMBER
@ CHAR_DEL_ARENA_TEAM_MEMBER
Definition: CharacterDatabase.h:304
CHAR_DEL_MAIL_ITEMS
@ CHAR_DEL_MAIL_ITEMS
Definition: CharacterDatabase.h:492
CHAR_DEL_TRANSMOG_OUTFIT
@ CHAR_DEL_TRANSMOG_OUTFIT
Definition: CharacterDatabase.h:270
CHAR_SEL_MAIL_ITEMS_BY_ENTRY
@ CHAR_SEL_MAIL_ITEMS_BY_ENTRY
Definition: CharacterDatabase.h:435
CHAR_INS_CHARACTER_FAVORITE_AUCTION
@ CHAR_INS_CHARACTER_FAVORITE_AUCTION
Definition: CharacterDatabase.h:118
CHAR_SEL_CHARACTER_CUSTOMIZATIONS
@ CHAR_SEL_CHARACTER_CUSTOMIZATIONS
Definition: CharacterDatabase.h:65
CHAR_DEL_INSTANCE
@ CHAR_DEL_INSTANCE
Definition: CharacterDatabase.h:645
CHAR_INS_ITEM_REFUND_INSTANCE
@ CHAR_INS_ITEM_REFUND_INSTANCE
Definition: CharacterDatabase.h:446
CHAR_INS_CHAR_PET_DECLINEDNAME
@ CHAR_INS_CHAR_PET_DECLINEDNAME
Definition: CharacterDatabase.h:586
CHAR_DEL_GM_SUGGESTION
@ CHAR_DEL_GM_SUGGESTION
Definition: CharacterDatabase.h:360
CHAR_INS_CHAR_QUESTSTATUS_REWARDED
@ CHAR_INS_CHAR_QUESTSTATUS_REWARDED
Definition: CharacterDatabase.h:516
CHAR_UPD_MAIL_ITEM_RECEIVER
@ CHAR_UPD_MAIL_ITEM_RECEIVER
Definition: CharacterDatabase.h:148
CHAR_SEL_AUCTIONS
@ CHAR_SEL_AUCTIONS
Definition: CharacterDatabase.h:133
CHAR_DEL_LFG_DATA
@ CHAR_DEL_LFG_DATA
Definition: CharacterDatabase.h:407
CHAR_DEL_CHAR_ACHIEVEMENT
@ CHAR_DEL_CHAR_ACHIEVEMENT
Definition: CharacterDatabase.h:438
CHAR_INS_CHAR_SPELL_FAVORITE
@ CHAR_INS_CHAR_SPELL_FAVORITE
Definition: CharacterDatabase.h:528
CHAR_DEL_BATTLEGROUND_RANDOM
@ CHAR_DEL_BATTLEGROUND_RANDOM
Definition: CharacterDatabase.h:61
CHAR_DEL_CHAR_PET_DECLINEDNAME
@ CHAR_DEL_CHAR_PET_DECLINEDNAME
Definition: CharacterDatabase.h:585
CHAR_SEL_GUILD_ACHIEVEMENT_CRITERIA
@ CHAR_SEL_GUILD_ACHIEVEMENT_CRITERIA
Definition: CharacterDatabase.h:255
CHAR_INS_GUILD_BANK_RIGHT
@ CHAR_INS_GUILD_BANK_RIGHT
Definition: CharacterDatabase.h:221
CHAR_SEL_MAIL_COUNT
@ CHAR_SEL_MAIL_COUNT
Definition: CharacterDatabase.h:96
CHAR_REP_GM_COMPLAINT
@ CHAR_REP_GM_COMPLAINT
Definition: CharacterDatabase.h:350
CONNECTION_SYNCH
@ CONNECTION_SYNCH
Definition: MySQLConnection.h:38
CONNECTION_BOTH
@ CONNECTION_BOTH
Definition: MySQLConnection.h:39
CONNECTION_ASYNC
@ CONNECTION_ASYNC
Definition: MySQLConnection.h:37
MySQLConnection::PrepareStatement
void PrepareStatement(uint32 index, std::string const &sql, ConnectionFlags flags)
Definition: MySQLConnection.cpp:482
MySQLConnection::m_stmts
PreparedStatementContainer m_stmts
Definition: MySQLConnection.h:101
MySQLConnection::m_reconnecting
bool m_reconnecting
PreparedStatements storage.
Definition: MySQLConnection.h:102
+ Here is the call graph for this function:
The documentation for this class was generated from the following files: