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