26#define SelectItemInstanceContent "ii.guid, ii.itemEntry, ii.creatorGuid, ii.giftCreatorGuid, ii.count, ii.duration, ii.charges, ii.flags, ii.enchantments, ii.randomBonusListId, " \
27 "ii.durability, ii.playedTime, ii.text, ii.battlePetSpeciesId, ii.battlePetBreedData, ii.battlePetLevel, ii.battlePetDisplayId, ii.context, ii.bonusListIDs, " \
28 "iit.itemModifiedAppearanceAllSpecs, iit.itemModifiedAppearanceSpec1, iit.itemModifiedAppearanceSpec2, iit.itemModifiedAppearanceSpec3, iit.itemModifiedAppearanceSpec4, iit.itemModifiedAppearanceSpec5, " \
29 "iit.spellItemEnchantmentAllSpecs, iit.spellItemEnchantmentSpec1, iit.spellItemEnchantmentSpec2, iit.spellItemEnchantmentSpec3, iit.spellItemEnchantmentSpec4, iit.spellItemEnchantmentSpec5, " \
30 "iit.secondaryItemModifiedAppearanceAllSpecs, iit.secondaryItemModifiedAppearanceSpec1, iit.secondaryItemModifiedAppearanceSpec2, iit.secondaryItemModifiedAppearanceSpec3, iit.secondaryItemModifiedAppearanceSpec4, iit.itemModifiedAppearanceSpec5, " \
31 "ig.gemItemId1, ig.gemBonuses1, ig.gemContext1, ig.gemScalingLevel1, ig.gemItemId2, ig.gemBonuses2, ig.gemContext2, ig.gemScalingLevel2, ig.gemItemId3, ig.gemBonuses3, ig.gemContext3, ig.gemScalingLevel3, " \
32 "im.fixedScalingLevel, im.artifactKnowledgeLevel"
42 PrepareStatement(
CHAR_INS_CHARACTER_BAN,
"INSERT INTO character_banned (guid, bandate, unbandate, bannedby, banreason, active) VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?, 1)",
CONNECTION_ASYNC);
50 PrepareStatement(
CHAR_SEL_MAIL_LIST_INFO,
"SELECT id, sender, (SELECT name FROM characters WHERE guid = sender) AS sendername, receiver, (SELECT name FROM characters WHERE guid = receiver) AS receivername, "
51 "subject, deliver_time, expire_time, money, has_items FROM mail WHERE receiver = ? ",
CONNECTION_SYNCH);
53 PrepareStatement(
CHAR_SEL_ENUM,
"SELECT c.guid, c.name, c.race, c.class, c.gender, c.level, c.zone, c.map, c.position_x, c.position_y, c.position_z, "
54 "gm.guildid, c.playerFlags, c.at_login, cp.entry, cp.modelid, cp.level, c.equipmentCache, cb.guid, c.slot, c.logout_time, c.activeTalentGroup, c.lastLoginBuild, "
55 "c.personalTabardEmblemStyle, c.personalTabardEmblemColor, c.personalTabardBorderStyle, c.personalTabardBorderColor, c.personalTabardBackgroundColor "
56 "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 "
57 "LEFT JOIN character_banned AS cb ON c.guid = cb.guid AND cb.active = 1 "
59 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, "
60 "gm.guildid, c.playerFlags, c.at_login, cp.entry, cp.modelid, cp.level, c.equipmentCache, cb.guid, c.slot, c.logout_time, c.activeTalentGroup, c.lastLoginBuild, "
61 "c.personalTabardEmblemStyle, c.personalTabardEmblemColor, c.personalTabardBorderStyle, c.personalTabardBorderColor, c.personalTabardBackgroundColor, "
63 "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 "
64 "LEFT JOIN character_banned AS cb ON c.guid = cb.guid AND cb.active = 1 "
65 "LEFT JOIN character_declinedname AS cd ON c.guid = cd.guid "
68 "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);
69 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, "
70 "gm.guildid, c.playerFlags, c.at_login, cp.entry, cp.modelid, cp.level, c.equipmentCache, cb.guid, c.slot, c.logout_time, c.activeTalentGroup, c.lastLoginBuild, "
71 "c.personalTabardEmblemStyle, c.personalTabardEmblemColor, c.personalTabardBorderStyle, c.personalTabardBorderColor, c.personalTabardBackgroundColor "
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 "WHERE c.deleteInfos_Account = ? AND c.deleteInfos_Name IS NOT NULL",
CONNECTION_ASYNC);
75 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, "
76 "gm.guildid, c.playerFlags, c.at_login, cp.entry, cp.modelid, cp.level, c.equipmentCache, cb.guid, c.slot, c.logout_time, c.activeTalentGroup, c.lastLoginBuild, "
77 "c.personalTabardEmblemStyle, c.personalTabardEmblemColor, c.personalTabardBorderStyle, c.personalTabardBorderColor, c.personalTabardBackgroundColor, "
79 "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 "
80 "LEFT JOIN character_banned AS cb ON c.guid = cb.guid AND cb.active = 1 "
81 "LEFT JOIN character_declinedname AS cd ON c.guid = cd.guid "
82 "WHERE c.deleteInfos_Account = ? AND c.deleteInfos_Name IS NOT NULL",
CONNECTION_ASYNC);
84 "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);
95 PrepareStatement(
CHAR_SEL_CHARACTER,
"SELECT c.guid, account, name, race, class, gender, level, xp, money, inventorySlots, bankSlots, restState, playerFlags, playerFlagsEx, "
96 "position_x, position_y, position_z, map, orientation, taximask, createTime, createMode, cinematic, totaltime, leveltime, rest_bonus, logout_time, is_logout_resting, resettalents_cost, "
97 "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, "
98 "totalKills, todayKills, yesterdayKills, chosenTitle, watchedFaction, drunk, "
99 "health, power1, power2, power3, power4, power5, power6, power7, power8, power9, power10, instance_id, activeTalentGroup, lootSpecId, exploredZones, knownTitles, actionBars, "
100 "raidDifficulty, legacyRaidDifficulty, fishingSteps, honor, honorLevel, honorRestState, honorRestBonus, numRespecs, "
101 "personalTabardEmblemStyle, personalTabardEmblemColor, personalTabardBorderStyle, personalTabardBorderColor, personalTabardBackgroundColor "
102 "FROM characters c LEFT JOIN character_fishingsteps cfs ON c.guid = cfs.guid WHERE c.guid = ?",
CONNECTION_ASYNC);
106 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);
133 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);
142 "FROM guild g JOIN guild_member gm ON g.guildid = gm.guildid "
143 "JOIN guild_rank gr ON g.guildid = gr.guildid AND gm.`rank` = gr.rid WHERE gm.guid = ?",
CONNECTION_BOTH);
146 PrepareStatement(
CHAR_SEL_CHARACTER_EQUIPMENTSETS,
"SELECT setguid, setindex, name, iconname, ignore_mask, AssignedSpecIndex, item0, item1, item2, item3, item4, item5, item6, item7, item8, "
147 "item9, item10, item11, item12, item13, item14, item15, item16, item17, item18 FROM character_equipmentsets WHERE guid = ? ORDER BY setindex",
CONNECTION_ASYNC);
148 PrepareStatement(
CHAR_SEL_CHARACTER_TRANSMOG_OUTFITS,
"SELECT setguid, setindex, name, iconname, ignore_mask, appearance0, appearance1, appearance2, appearance3, appearance4, "
149 "appearance5, appearance6, appearance7, appearance8, appearance9, appearance10, appearance11, appearance12, appearance13, appearance14, appearance15, appearance16, "
150 "appearance17, appearance18, mainHandEnchant, offHandEnchant FROM character_transmog_outfits WHERE guid = ? ORDER BY setindex",
CONNECTION_ASYNC);
151 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);
160 PrepareStatement(
CHAR_INS_CHARACTER_FAVORITE_AUCTION,
"INSERT INTO character_favorite_auctions (guid, `order`, itemId, itemLevel, battlePetSpeciesId, suffixItemNameDescriptionId) VALUE (?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
166 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);
167 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);
169 "iz.selectedAzeriteEssences1specId, iz.selectedAzeriteEssences1azeriteEssenceId1, iz.selectedAzeriteEssences1azeriteEssenceId2, iz.selectedAzeriteEssences1azeriteEssenceId3, iz.selectedAzeriteEssences1azeriteEssenceId4, "
170 "iz.selectedAzeriteEssences2specId, iz.selectedAzeriteEssences2azeriteEssenceId1, iz.selectedAzeriteEssences2azeriteEssenceId2, iz.selectedAzeriteEssences2azeriteEssenceId3, iz.selectedAzeriteEssences2azeriteEssenceId4, "
171 "iz.selectedAzeriteEssences3specId, iz.selectedAzeriteEssences3azeriteEssenceId1, iz.selectedAzeriteEssences3azeriteEssenceId2, iz.selectedAzeriteEssences3azeriteEssenceId3, iz.selectedAzeriteEssences3azeriteEssenceId4, "
172 "iz.selectedAzeriteEssences4specId, iz.selectedAzeriteEssences4azeriteEssenceId1, iz.selectedAzeriteEssences4azeriteEssenceId2, iz.selectedAzeriteEssences4azeriteEssenceId3, iz.selectedAzeriteEssences4azeriteEssenceId4 "
173 "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);
176 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);
178 PrepareStatement(
CHAR_SEL_AUCTIONS,
"SELECT id, auctionHouseId, owner, bidder, minBid, buyoutOrUnitPrice, deposit, bidAmount, startTime, endTime, serverFlags FROM auctionhouse",
CONNECTION_SYNCH);
184 PrepareStatement(
CHAR_INS_AUCTION,
"INSERT INTO auctionhouse (id, auctionHouseId, owner, bidder, minBid, buyoutOrUnitPrice, deposit, bidAmount, startTime, endTime, serverFlags) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
188 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);
194 PrepareStatement(
CHAR_SEL_EXPIRED_MAIL,
"SELECT id, messageType, sender, receiver, has_items, expire_time, cod, checked, mailTemplateId FROM mail WHERE expire_time < ?",
CONNECTION_SYNCH);
205 PrepareStatement(
CHAR_REP_ITEM_INSTANCE,
"REPLACE INTO item_instance (itemEntry, owner_guid, creatorGuid, giftCreatorGuid, count, duration, charges, flags, enchantments, randomBonusListId, durability, playedTime, text, battlePetSpeciesId, battlePetBreedData, battlePetLevel, battlePetDisplayId, context, bonusListIDs, guid) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
206 PrepareStatement(
CHAR_UPD_ITEM_INSTANCE,
"UPDATE item_instance SET itemEntry = ?, owner_guid = ?, creatorGuid = ?, giftCreatorGuid = ?, count = ?, duration = ?, charges = ?, flags = ?, enchantments = ?, randomBonusListId = ?, durability = ?, playedTime = ?, text = ?, battlePetSpeciesId = ?, battlePetBreedData = ?, battlePetLevel = ?, battlePetDisplayId = ?, context = ?, bonusListIDs = ? WHERE guid = ?",
CONNECTION_ASYNC);
210 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);
213 PrepareStatement(
CHAR_INS_ITEM_INSTANCE_TRANSMOG,
"INSERT INTO item_instance_transmog (itemGuid, itemModifiedAppearanceAllSpecs, itemModifiedAppearanceSpec1, itemModifiedAppearanceSpec2, itemModifiedAppearanceSpec3, itemModifiedAppearanceSpec4, itemModifiedAppearanceSpec5, "
214 "spellItemEnchantmentAllSpecs, spellItemEnchantmentSpec1, spellItemEnchantmentSpec2, spellItemEnchantmentSpec3, spellItemEnchantmentSpec4, spellItemEnchantmentSpec5, "
215 "secondaryItemModifiedAppearanceAllSpecs, secondaryItemModifiedAppearanceSpec1, secondaryItemModifiedAppearanceSpec2, secondaryItemModifiedAppearanceSpec3, secondaryItemModifiedAppearanceSpec4, secondaryItemModifiedAppearanceSpec5) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
218 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);
229 "iz.selectedAzeriteEssences1specId, iz.selectedAzeriteEssences1azeriteEssenceId1, iz.selectedAzeriteEssences1azeriteEssenceId2, iz.selectedAzeriteEssences1azeriteEssenceId3, iz.selectedAzeriteEssences1azeriteEssenceId4, "
230 "iz.selectedAzeriteEssences2specId, iz.selectedAzeriteEssences2azeriteEssenceId1, iz.selectedAzeriteEssences2azeriteEssenceId2, iz.selectedAzeriteEssences2azeriteEssenceId3, iz.selectedAzeriteEssences2azeriteEssenceId4, "
231 "iz.selectedAzeriteEssences3specId, iz.selectedAzeriteEssences3azeriteEssenceId1, iz.selectedAzeriteEssences3azeriteEssenceId2, iz.selectedAzeriteEssences3azeriteEssenceId3, iz.selectedAzeriteEssences3azeriteEssenceId4, "
232 "iz.selectedAzeriteEssences4specId, iz.selectedAzeriteEssences4azeriteEssenceId1, iz.selectedAzeriteEssences4azeriteEssenceId2, iz.selectedAzeriteEssences4azeriteEssenceId3, iz.selectedAzeriteEssences4azeriteEssenceId4 "
233 "FROM item_instance_azerite iz INNER JOIN character_inventory ci ON iz.itemGuid = ci.item WHERE ci.guid = ?",
CONNECTION_ASYNC);
234 PrepareStatement(
CHAR_INS_ITEM_INSTANCE_AZERITE,
"INSERT INTO item_instance_azerite (itemGuid, xp, level, knowledgeLevel, selectedAzeriteEssences1specId, selectedAzeriteEssences1azeriteEssenceId1, selectedAzeriteEssences1azeriteEssenceId2, selectedAzeriteEssences1azeriteEssenceId3, selectedAzeriteEssences1azeriteEssenceId4, "
235 "selectedAzeriteEssences2specId, selectedAzeriteEssences2azeriteEssenceId1, selectedAzeriteEssences2azeriteEssenceId2, selectedAzeriteEssences2azeriteEssenceId3, selectedAzeriteEssences2azeriteEssenceId4, "
236 "selectedAzeriteEssences3specId, selectedAzeriteEssences3azeriteEssenceId1, selectedAzeriteEssences3azeriteEssenceId2, selectedAzeriteEssences3azeriteEssenceId3, selectedAzeriteEssences3azeriteEssenceId4, "
237 "selectedAzeriteEssences4specId, selectedAzeriteEssences4azeriteEssenceId1, selectedAzeriteEssences4azeriteEssenceId2, selectedAzeriteEssences4azeriteEssenceId3, selectedAzeriteEssences4azeriteEssenceId4) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
250 PrepareStatement(
CHAR_INS_ITEM_INSTANCE_AZERITE_EMPOWERED,
"INSERT INTO item_instance_azerite_empowered (itemGuid, azeritePowerId1, azeritePowerId2, azeritePowerId3, azeritePowerId4, azeritePowerId5) VALUES (?, ?, ?, ? ,? ,?)",
CONNECTION_ASYNC);
267 PrepareStatement(
CHAR_INS_GUILD,
"INSERT INTO guild (guildid, name, leaderguid, info, motd, createdate, EmblemStyle, EmblemColor, BorderStyle, BorderColor, BackgroundColor, BankMoney) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
272 PrepareStatement(
CHAR_INS_GUILD_MEMBER,
"INSERT INTO guild_member (guildid, guid, `rank`, pnote, offnote) VALUES (?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
276 PrepareStatement(
CHAR_INS_GUILD_RANK,
"INSERT INTO guild_rank (guildid, rid, RankOrder, rname, rights, BankMoneyPerDay) VALUES (?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
289 "ON DUPLICATE KEY UPDATE gbright = VALUES(gbright), SlotPerDay = VALUES(SlotPerDay)",
CONNECTION_ASYNC);
293 PrepareStatement(
CHAR_INS_GUILD_BANK_EVENTLOG,
"INSERT INTO guild_bank_eventlog (guildid, LogGuid, TabId, EventType, PlayerGuid, ItemOrMoney, ItemStackCount, DestTabId, TimeStamp) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
297 PrepareStatement(
CHAR_INS_GUILD_EVENTLOG,
"INSERT INTO guild_eventlog (guildid, LogGuid, EventType, PlayerGuid1, PlayerGuid2, NewRank, TimeStamp) VALUES (?, ?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
319 "INSERT INTO guild_member_withdraw (guid, tab0, tab1, tab2, tab3, tab4, tab5, tab6, tab7) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) "
320 "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);
329 PrepareStatement(
CHAR_INS_GUILD_ACHIEVEMENT_CRITERIA,
"INSERT INTO guild_achievement_progress (guildId, criteria, counter, date, completedGuid) VALUES (?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
330 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);
334 PrepareStatement(
CHAR_INS_GUILD_NEWS,
"INSERT INTO guild_newslog (guildid, LogGuid, EventType, PlayerGuid, Flags, Value, Timestamp) VALUES (?, ?, ?, ?, ?, ?, ?)"
335 " ON DUPLICATE KEY UPDATE LogGuid = VALUES (LogGuid), EventType = VALUES (EventType), PlayerGuid = VALUES (PlayerGuid), Flags = VALUES (Flags), Value = VALUES (Value), Timestamp = VALUES (Timestamp)",
CONNECTION_ASYNC);
338 PrepareStatement(
CHAR_UPD_CHANNEL,
"INSERT INTO channels (name, team, announce, ownership, password, bannedList, lastUsed) VALUES (?, ?, ?, ?, ?, ?, UNIX_TIMESTAMP()) "
339 "ON DUPLICATE KEY UPDATE announce=VALUES(announce), ownership=VALUES(ownership), password=VALUES(password), bannedList=VALUES(bannedList), lastUsed=VALUES(lastUsed)",
CONNECTION_ASYNC);
346 PrepareStatement(
CHAR_UPD_EQUIP_SET,
"UPDATE character_equipmentsets SET name=?, iconname=?, ignore_mask=?, AssignedSpecIndex=?, item0=?, item1=?, item2=?, item3=?, "
347 "item4=?, item5=?, item6=?, item7=?, item8=?, item9=?, item10=?, item11=?, item12=?, item13=?, item14=?, item15=?, item16=?, "
348 "item17=?, item18=? WHERE guid=? AND setguid=? AND setindex=?",
CONNECTION_ASYNC);
349 PrepareStatement(
CHAR_INS_EQUIP_SET,
"INSERT INTO character_equipmentsets (guid, setguid, setindex, name, iconname, ignore_mask, AssignedSpecIndex, item0, item1, item2, item3, "
350 "item4, item5, item6, item7, item8, item9, item10, item11, item12, item13, item14, item15, item16, item17, item18) "
351 "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
354 "appearance4=?, appearance5=?, appearance6=?, appearance7=?, appearance8=?, appearance9=?, appearance10=?, appearance11=?, appearance12=?, appearance13=?, appearance14=?, "
355 "appearance15=?, appearance16=?, appearance17=?, appearance18=?, mainHandEnchant=?, offHandEnchant=? WHERE guid=? AND setguid=? AND setindex=?",
CONNECTION_ASYNC);
356 PrepareStatement(
CHAR_INS_TRANSMOG_OUTFIT,
"INSERT INTO character_transmog_outfits (guid, setguid, setindex, name, iconname, ignore_mask, appearance0, appearance1, appearance2, "
357 "appearance3, appearance4, appearance5, appearance6, appearance7, appearance8, appearance9, appearance10, appearance11, appearance12, appearance13, appearance14, appearance15, "
358 "appearance16, appearance17, appearance18, mainHandEnchant, offHandEnchant) "
359 "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
363 PrepareStatement(
CHAR_INS_AURA,
"INSERT INTO character_aura (guid, casterGuid, itemGuid, spell, effectMask, recalculateMask, difficulty, stackCount, maxDuration, remainTime, remainCharges, castItemId, castItemLevel) "
364 "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
371 PrepareStatement(
CHAR_REP_PLAYER_CURRENCY,
"REPLACE INTO character_currency (CharacterGuid, Currency, Quantity, WeeklyQuantity, TrackedQuantity, IncreasedCapQuantity, EarnedQuantity, Flags) VALUES (?, ?, ?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
384 PrepareStatement(
CHAR_INS_TUTORIALS,
"INSERT INTO account_tutorial(tut0, tut1, tut2, tut3, tut4, tut5, tut6, tut7, accountId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
409 PrepareStatement(
CHAR_INS_ARENA_TEAM,
"INSERT INTO arena_team (arenaTeamId, name, captainGuid, type, rating, backgroundColor, emblemStyle, emblemColor, borderStyle, borderColor) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
422 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);
426 PrepareStatement(
CHAR_INS_PLAYER_HOMEBIND,
"INSERT INTO character_homebind (guid, mapId, zoneId, posX, posY, posZ, orientation) VALUES (?, ?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
431 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);
432 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);
438 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);
445 PrepareStatement(
CHAR_REP_RESPAWN,
"REPLACE INTO respawn (type, spawnId, respawnTime, mapId, instanceId) VALUES (?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
450 PrepareStatement(
CHAR_SEL_GM_BUGS,
"SELECT id, playerGuid, note, createTime, mapId, posX, posY, posZ, facing, closedBy, assignedTo, comment FROM gm_bug",
CONNECTION_SYNCH);
451 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);
456 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);
457 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);
466 PrepareStatement(
CHAR_SEL_GM_SUGGESTIONS,
"SELECT id, playerGuid, note, createTime, mapId, posX, posY, posZ, facing, closedBy, assignedTo, comment FROM gm_suggestion",
CONNECTION_SYNCH);
467 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);
476 PrepareStatement(
CHAR_INS_CHARACTER,
"INSERT INTO characters (guid, account, name, race, class, gender, level, xp, money, inventorySlots, bankSlots, restState, playerFlags, playerFlagsEx, "
477 "map, instance_id, dungeonDifficulty, raidDifficulty, legacyRaidDifficulty, position_x, position_y, position_z, orientation, trans_x, trans_y, trans_z, trans_o, transguid, "
478 "taximask, createTime, createMode, cinematic, "
479 "totaltime, leveltime, rest_bonus, logout_time, is_logout_resting, resettalents_cost, resettalents_time, primarySpecialization, "
480 "extra_flags, summonedPetNumber, at_login, "
481 "death_expire_time, taxi_path, totalKills, "
482 "todayKills, yesterdayKills, chosenTitle, watchedFaction, drunk, health, power1, power2, power3, "
483 "power4, power5, power6, power7, power8, power9, power10, latency, activeTalentGroup, lootSpecId, exploredZones, equipmentCache, knownTitles, actionBars, lastLoginBuild) VALUES "
484 "(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)",
CONNECTION_ASYNC);
485 PrepareStatement(
CHAR_UPD_CHARACTER,
"UPDATE characters SET name=?,race=?,class=?,gender=?,level=?,xp=?,money=?,inventorySlots=?,bankSlots=?,restState=?,playerFlags=?,playerFlagsEx=?,"
486 "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=?,"
487 "logout_time=?,is_logout_resting=?,resettalents_cost=?,resettalents_time=?,numRespecs=?,primarySpecialization=?,extra_flags=?,summonedPetNumber=?,at_login=?,zone=?,death_expire_time=?,taxi_path=?,"
488 "totalKills=?,todayKills=?,yesterdayKills=?,chosenTitle=?,"
489 "watchedFaction=?,drunk=?,health=?,power1=?,power2=?,power3=?,power4=?,power5=?,power6=?,power7=?,power8=?,power9=?,power10=?,latency=?,activeTalentGroup=?,lootSpecId=?,exploredZones=?,"
490 "equipmentCache=?,knownTitles=?,actionBars=?,online=?,honor=?,honorLevel=?,honorRestState=?,honorRestBonus=?,lastLoginBuild=? WHERE guid=?",
CONNECTION_ASYNC);
501 PrepareStatement(
CHAR_INS_GROUP,
"INSERT INTO `groups` (guid, leaderGuid, lootMethod, looterGuid, lootThreshold, icon1, icon2, icon3, icon4, icon5, icon6, icon7, icon8, groupType, difficulty, raidDifficulty, legacyRaidDifficulty, masterLooterGuid) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
502 PrepareStatement(
CHAR_INS_GROUP_MEMBER,
"INSERT INTO group_member (guid, memberGuid, memberFlags, subgroup, roles) VALUES(?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
529 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);
530 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);
537 PrepareStatement(
CHAR_SEL_CHAR_PINFO,
"SELECT totaltime, level, money, account, race, class, map, zone, gender, health, playerFlags FROM characters WHERE guid = ?",
CONNECTION_SYNCH);
550 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);
557 "INNER JOIN character_inventory ci ON ci.guid = c.guid "
558 "INNER JOIN item_instance ii ON ii.guid = ci.item "
559 "LEFT JOIN character_inventory cb ON cb.item = ci.bag WHERE ii.itemEntry = ? LIMIT ?",
CONNECTION_SYNCH);
561 "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 "
562 "INNER JOIN characters cs ON cs.guid = m.sender INNER JOIN characters cr ON cr.guid = m.receiver WHERE ii.itemEntry = ? LIMIT ?",
CONNECTION_SYNCH);
582 PrepareStatement(
CHAR_INS_CHAR_DECLINED_NAME,
"INSERT INTO character_declinedname (guid, genitive, dative, accusative, instrumental, prepositional) VALUES (?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
584 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);
606 PrepareStatement(
CHAR_INS_CHAR_SPELL_COOLDOWN,
"INSERT INTO character_spell_cooldown (guid, spell, item, time, categoryId, categoryEnd) VALUES (?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
620 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);
630 PrepareStatement(
CHAR_INS_CHAR_ACTION,
"INSERT INTO character_action (guid, spec, traitConfigId, button, action, type) VALUES (?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
637 PrepareStatement(
CHAR_REP_CHAR_QUESTSTATUS,
"REPLACE INTO character_queststatus (guid, quest, status, explored, acceptTime, endTime) VALUES (?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
650 PrepareStatement(
CHAR_INS_CHAR_SKILLS,
"INSERT INTO character_skills (guid, skill, value, max, professionSlot) VALUES (?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
657 PrepareStatement(
CHAR_INS_CHAR_STATS,
"INSERT INTO character_stats (guid, maxhealth, maxpower1, maxpower2, maxpower3, maxpower4, maxpower5, maxpower6, maxpower7, maxpower8, maxpower9, maxpower10, "
658 "strength, agility, stamina, intellect, armor, resHoly, resFire, resNature, resFrost, resShadow, resArcane, blockPct, dodgePct, parryPct, critPct, rangedCritPct, spellCritPct, "
659 "attackPower, rangedAttackPower, spellPower, resilience, mastery, versatility) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
664 PrepareStatement(
CHAR_INS_CHAR_PVP_TALENT,
"INSERT INTO character_pvp_talent (guid, talentId0, talentId1, talentId2, talentId3, talentGroup) VALUES (?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
669 PrepareStatement(
CHAR_INS_CHAR_TRAIT_ENTRIES,
"INSERT INTO character_trait_entry (guid, traitConfigId, traitNodeId, traitNodeEntryId, `rank`, grantedRanks) VALUES (?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
673 PrepareStatement(
CHAR_INS_CHAR_TRAIT_CONFIGS,
"INSERT INTO character_trait_config (guid, traitConfigId, type, chrSpecializationId, combatConfigFlags, localIdentifier, skillLineId, traitSystemId, `name`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
678 PrepareStatement(
CHAR_SEL_CHAR_VOID_STORAGE,
"SELECT itemId, itemEntry, slot, creatorGuid, randomBonusListId, fixedScalingLevel, artifactKnowledgeLevel, context, bonusListIDs FROM character_void_storage WHERE playerGuid = ?",
CONNECTION_ASYNC);
679 PrepareStatement(
CHAR_REP_CHAR_VOID_STORAGE_ITEM,
"REPLACE INTO character_void_storage (itemId, playerGuid, itemEntry, slot, creatorGuid, randomBonusListId, fixedScalingLevel, artifactKnowledgeLevel, context, bonusListIDs) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
684 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);
685 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);
690 PrepareStatement(
CHAR_SEL_ITEMCONTAINER_ITEMS,
"SELECT container_id, item_id, item_count, item_index, follow_rules, ffa, blocked, counted, under_threshold, needs_quest, rnd_bonus, context, bonus_list_ids FROM item_loot_items",
CONNECTION_SYNCH);
693 PrepareStatement(
CHAR_INS_ITEMCONTAINER_ITEMS,
"INSERT INTO item_loot_items (container_id, item_id, item_count, item_index, follow_rules, ffa, blocked, counted, under_threshold, needs_quest, rnd_bonus, context, bonus_list_ids) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
699 PrepareStatement(
CHAR_REP_CALENDAR_EVENT,
"REPLACE INTO calendar_events (EventID, Owner, Title, Description, EventType, TextureID, Date, Flags, LockDate) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
701 PrepareStatement(
CHAR_REP_CALENDAR_INVITE,
"REPLACE INTO calendar_invites (InviteID, EventID, Invitee, Sender, Status, ResponseTime, ModerationRank, Note) VALUES (?, ?, ?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
708 PrepareStatement(
CHAR_INS_CHAR_PET_DECLINEDNAME,
"INSERT INTO character_pet_declinedname (id, owner, genitive, dative, accusative, instrumental, prepositional) VALUES (?, ?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
709 PrepareStatement(
CHAR_SEL_PET_AURA,
"SELECT casterGuid, spell, effectMask, recalculateMask, difficulty, stackCount, maxDuration, remainTime, remainCharges FROM pet_aura WHERE guid = ?",
CONNECTION_ASYNC);
718 PrepareStatement(
CHAR_INS_PET_SPELL_COOLDOWN,
"INSERT INTO pet_spell_cooldown (guid, spell, time, categoryId, categoryEnd) VALUES (?, ?, ?, ?, ?)",
CONNECTION_BOTH);
724 PrepareStatement(
CHAR_INS_PET_AURA,
"INSERT INTO pet_aura (guid, casterGuid, spell, effectMask, recalculateMask, difficulty, stackCount, maxDuration, remainTime, remainCharges) "
725 "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
CONNECTION_BOTH);
728 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);
735 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) "
736 "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
740 PrepareStatement(
CHAR_INS_PVPSTATS_BATTLEGROUND,
"INSERT INTO pvpstats_battlegrounds (id, winner_faction, bracket_id, type, date) VALUES (?, ?, ?, ?, NOW())",
CONNECTION_ASYNC);
741 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);
745 PrepareStatement(
CHAR_INS_QUEST_TRACK,
"INSERT INTO quest_tracker (id, character_guid, quest_accept_time, core_hash, core_revision) VALUES (?, ?, NOW(), ?, ?)",
CONNECTION_ASYNC);
759 PrepareStatement(
CHAR_INS_CHARACTER_GARRISON_BUILDINGS,
"INSERT INTO character_garrison_buildings (guid, plotInstanceId, buildingId, timeBuilt, active) VALUES (?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
761 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);
762 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);
771 PrepareStatement(
CHAR_INS_BLACKMARKET_AUCTIONS,
"INSERT INTO blackmarket_auctions (marketId, currentBid, time, numBids, bidder) VALUES (?, ?, ?, ? ,?)",
CONNECTION_ASYNC);
786 PrepareStatement(
CHAR_INS_CHARACTER_INSTANCE_LOCK,
"INSERT INTO character_instance_lock (guid, mapId, lockId, instanceId, difficulty, data, completedEncountersMask, entranceWorldSafeLocId, expiryTime, extended) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
#define SelectItemInstanceContent
@ CHAR_SEL_CORPSE_CUSTOMIZATIONS
@ CHAR_SEL_CHARACTER_GARRISON_BUILDINGS
@ CHAR_SEL_CHAR_CUSTOMIZE_INFO
@ CHAR_DEL_ITEM_INSTANCE_AZERITE_MILESTONE_POWER_BY_OWNER
@ CHAR_DEL_CHAR_SOCIAL_BY_FRIEND
@ CHAR_SEL_CHAR_TRAIT_CONFIGS
@ CHAR_DEL_CHAR_PET_DECLINEDNAME_BY_OWNER
@ CHAR_UPD_ITEM_INSTANCE_ON_LOAD
@ CHAR_SEL_CHAR_OLD_CHARS
@ CHAR_UPD_CHAR_INVENTORY_FACTION_CHANGE
@ CHAR_DEL_GUILD_BANK_EVENTLOG_BY_PLAYER
@ CHAR_SEL_CHARACTER_PVP_TALENTS
@ CHAR_INS_PETITION_SIGNATURE
@ CHAR_SEL_CHAR_INVENTORY_ITEM_BY_ENTRY
@ CHAR_DEL_ITEM_INSTANCE_AZERITE_BY_OWNER
@ CHAR_REP_CALENDAR_EVENT
@ CHAR_DEL_CHARACTER_QUESTSTATUS_WEEKLY
@ CHAR_INS_ITEM_INSTANCE_AZERITE_EMPOWERED
@ CHAR_DEL_GUILD_BANK_TABS
@ CHAR_SEL_PVPSTATS_FACTIONS_OVERALL
@ CHAR_REP_CHAR_VOID_STORAGE_ITEM
@ CHAR_SEL_CHAR_GUID_NAME_BY_ACC
@ CHAR_DEL_CHAR_QUESTSTATUS_REWARDED_BY_QUEST
@ CHAR_DEL_CHARACTER_FAVORITE_AUCTION
@ CHAR_DEL_ALL_GM_COMPLAINTS
@ CHAR_DEL_PETITION_BY_GUID
@ CHAR_INS_GUILD_ACHIEVEMENT_CRITERIA
@ CHAR_UPD_GUILD_BANK_TAB_TEXT
@ CHAR_DEL_ITEM_INSTANCE_GEMS
@ CHAR_DEL_ARENA_TEAM_MEMBERS
@ CHAR_INS_CHARACTER_INSTANCE_LOCK
@ CHAR_SEL_MAIL_LIST_COUNT
@ CHAR_DEL_GAME_EVENT_SAVE
@ CHAR_DEL_ITEM_INSTANCE_ARTIFACT
@ CHAR_SEL_PLAYER_CURRENCY
@ CHAR_UPD_QUEST_TRACK_COMPLETE_TIME
@ CHAR_DEL_CHARACTER_GARRISON
@ CHAR_DEL_CORPSE_CUSTOMIZATIONS
@ CHAR_SEL_CHARACTER_QUESTSTATUS_OBJECTIVES_CRITERIA_PROGRESS
@ CHAR_DEL_EMPTY_EXPIRED_MAIL
@ CHAR_UPD_REM_AT_LOGIN_FLAG
@ CHAR_DEL_GUILD_BANK_RIGHTS
@ CHAR_SEL_CHARACTER_QUESTSTATUSREW
@ CHAR_DEL_ITEM_INSTANCE_TRANSMOG
@ CHAR_SEL_PLAYER_ACCOUNT_DATA
@ CHAR_UPD_CHAR_QUESTSTATUS_REWARDED_FACTION_CHANGE
@ CHAR_DEL_CHARACTER_FAVORITE_AUCTIONS_BY_CHAR
@ CHAR_DEL_RESET_CHARACTER_QUESTSTATUS_MONTHLY
@ CHAR_DEL_GUILD_EVENTLOG_BY_PLAYER
@ CHAR_INS_CHARACTER_GARRISON_BUILDINGS
@ CHAR_DEL_PET_SPELL_CHARGES
@ CHAR_SEL_CHARACTER_FAVORITE_AUCTIONS
@ CHAR_DEL_CHAR_AURA_FROZEN
@ CHAR_DEL_CHAR_SKILL_LANGUAGES
@ CHAR_SEL_CHARACTER_GARRISON
@ CHAR_SEL_CHARACTER_AURAS
@ CHAR_DEL_CALENDAR_INVITE
@ CHAR_DEL_ITEMCONTAINER_MONEY
@ CHAR_DEL_CHAR_PET_BY_OWNER
@ CHAR_DEL_CHARACTER_AURA_STORED_LOCATIONS_BY_GUID
@ CHAR_DEL_AUCTION_BIDDER_BY_PLAYER
@ CHAR_DEL_CHAR_TRANSMOG_OUTFITS
@ CHAR_SEL_MAILITEMS_AZERITE
@ CHAR_INS_CHARACTER_QUESTSTATUS_SEASONAL
@ CHAR_UPD_GUILD_RANK_NAME
@ CHAR_SEL_AUCTION_BIDDERS
@ CHAR_DEL_ALL_GUILD_ACHIEVEMENTS
@ CHAR_DEL_CHARACTER_CUSTOMIZATIONS
@ CHAR_DEL_ITEM_INSTANCE_BY_OWNER
@ CHAR_SEL_ACCOUNT_INSTANCELOCKTIMES
@ CHAR_DEL_CHAR_INVENTORY_BY_ITEM
@ CHAR_DEL_GROUP_MEMBER_ALL
@ CHAR_DEL_CHAR_CUF_PROFILES
@ CHAR_INS_GUILD_EVENTLOG
@ CHAR_DEL_ITEMCONTAINER_ITEM
@ CHAR_UPD_PLAYER_CURRENCY
@ CHAR_UPD_CHAR_ACHIEVEMENT
@ CHAR_DEL_CHARACTER_GARRISON_FOLLOWERS
@ CHAR_INS_POOL_QUEST_SAVE
@ CHAR_UPD_GUILD_EMBLEM_INFO
@ CHAR_INS_BLACKMARKET_AUCTIONS
@ CHAR_DEL_POOL_QUEST_SAVE
@ CHAR_SEL_CHARACTER_QUESTSTATUS_OBJECTIVES_CRITERIA
@ CHAR_SEL_PVPSTATS_MAXID
@ CHAR_INS_PET_AURA_EFFECT
@ CHAR_DEL_INVALID_PET_SPELL
@ CHAR_SEL_CHAR_DEL_INFO_BY_NAME
@ CHAR_SEL_PETITION_OWNER_BY_GUID
@ CHAR_DEL_ITEMCONTAINER_ITEMS
@ CHAR_DEL_CHARACTER_INSTANCE_LOCK
@ CHAR_DEL_CALENDAR_EVENT
@ CHAR_SEL_ITEMCONTAINER_ITEMS
@ CHAR_REP_INVENTORY_ITEM
@ CHAR_DEL_CHAR_DECLINED_NAME
@ CHAR_DEL_INVALID_QUEST_PROGRESS_CRITERIA
@ CHAR_DEL_GUILD_BANK_EVENTLOGS
@ CHAR_DEL_PETITION_SIGNATURE_BY_OWNER
@ CHAR_SEL_MAILITEMS_AZERITE_MILESTONE_POWER
@ CHAR_SEL_MAILITEMS_AZERITE_UNLOCKED_ESSENCE
@ CHAR_SEL_CHAR_RACE_OR_FACTION_CHANGE_INFOS
@ CHAR_INS_PET_SPELL_CHARGES
@ CHAR_DEL_ALL_GM_COMPLAINT_CHATLOGS
@ CHAR_DEL_ALL_PETITION_SIGNATURES
@ CHAR_DEL_ITEM_INSTANCE_ARTIFACT_POWERS
@ CHAR_SEL_ACCOUNT_BY_NAME
@ CHAR_SEL_CHARACTER_AURA_FROZEN
@ CHAR_SEL_CHARACTER_QUESTSTATUS_MONTHLY
@ CHAR_DEL_CHAR_SPELL_FAVORITE
@ CHAR_UPD_BLACKMARKET_AUCTIONS
@ CHAR_DEL_ITEM_INSTANCE_AZERITE_EMPOWERED
@ CHAR_INS_BATTLEGROUND_RANDOM
@ CHAR_UPD_QUEST_TRACK_ABANDON_TIME
@ CHAR_UPD_CHANNEL_OWNERSHIP
@ CHAR_DEL_CHAR_QUESTSTATUS_OBJECTIVES
@ CHAR_INS_PVPSTATS_PLAYER
@ CHAR_INS_CHAR_TRAIT_ENTRIES
@ CHAR_SEL_CHAR_VOID_STORAGE
@ CHAR_SEL_CHARACTER_COUNT
@ CHAR_SEL_GUILD_BANK_ITEMS
@ CHAR_INS_PET_SPELL_COOLDOWN
@ CHAR_DEL_CHAR_CUF_PROFILES_BY_ID
@ CHAR_REP_CALENDAR_INVITE
@ CHAR_DEL_CHAR_SPELL_FAVORITE_BY_CHAR
@ CHAR_DEL_RESET_CHARACTER_QUESTSTATUS_SEASONAL_BY_EVENT
@ CHAR_DEL_ALL_GAME_EVENT_CONDITION_SAVE
@ CHAR_UPD_CHAR_PET_SLOT_BY_ID
@ CHAR_DEL_INVALID_MAIL_ITEM
@ CHAR_DEL_CHARACTER_SKILL
@ CHAR_DEL_GUILD_BANK_RIGHTS_FOR_RANK
@ CHAR_INS_PLAYER_HOMEBIND
@ CHAR_SEL_PETITION_BY_OWNER
@ CHAR_DEL_CHAR_FISHINGSTEPS
@ CHAR_SEL_GM_SUGGESTIONS
@ CHAR_DEL_ALL_GM_SUGGESTIONS
@ CHAR_DEL_NONEXISTENT_GUILD_BANK_ITEM
@ CHAR_DEL_INVALID_SPELL_SPELLS
@ CHAR_UPD_ARENA_TEAM_STATS
@ CHAR_INS_CHARACTER_QUESTSTATUS_DAILY
@ CHAR_INS_CHARACTER_CUSTOMIZATION
@ CHAR_INS_CHARACTER_GARRISON_BLUEPRINTS
@ CHAR_DEL_CHAR_SPELL_COOLDOWNS
@ CHAR_INS_GAME_EVENT_SAVE
@ CHAR_INS_CHAR_SKILL_LANGUAGE
@ CHAR_INS_CHAR_FISHINGSTEPS
@ CHAR_SEL_CHARACTER_BGDATA
@ CHAR_SEL_CHARACTER_SOCIALLIST
@ CHAR_DEL_CHAR_QUESTSTATUS_OBJECTIVES_CRITERIA_PROGRESS
@ CHAR_DEL_CHAR_ACTION_BY_BUTTON_SPEC
@ CHAR_UPD_CHAR_SPELL_FACTION_CHANGE
@ CHAR_UPD_CHAR_TAXI_PATH
@ CHAR_DEL_ALL_PET_SPELLS_BY_OWNER
@ CHAR_SEL_CHAR_TRAIT_ENTRIES
@ CHAR_DEL_CHAR_ACHIEVEMENT_PROGRESS_BY_CRITERIA
@ CHAR_SEL_CHARACTER_QUESTSTATUS_WEEKLY
@ CHAR_DEL_PLAYER_HOMEBIND
@ CHAR_SEL_ITEM_INSTANCE_AZERITE_UNLOCKED_ESSENCE
@ CHAR_DEL_CHAR_EQUIPMENTSETS
@ CHAR_REP_CHAR_CUF_PROFILES
@ CHAR_SEL_CHARACTER_ACTIONS_SPEC
@ CHAR_DEL_CHARACTER_QUESTSTATUS_DAILY
@ CHAR_UPD_GUILD_MEMBER_RANK
@ CHAR_UPD_AUCTION_EXPIRATION
@ CHAR_SEL_ENUM_CUSTOMIZATIONS
@ CHAR_SEL_CHARACTER_GARRISON_FOLLOWER_ABILITIES
@ CHAR_SEL_ITEM_INSTANCE_AZERITE_EMPOWERED
@ CHAR_INS_CHAR_ACHIEVEMENT_PROGRESS
@ CHAR_SEL_CHAR_REP_BY_FACTION
@ CHAR_SEL_GUILD_ACHIEVEMENT
@ CHAR_DEL_ITEM_INSTANCE_ARTIFACT_POWERS_BY_OWNER
@ CHAR_DEL_CHARACTER_ARENA_STATS
@ CHAR_SEL_CHARACTER_HOMEBIND
@ CHAR_SEL_PETITION_SIG_BY_GUID
@ CHAR_INS_ARENA_TEAM_MEMBER
@ CHAR_INS_ITEM_INSTANCE_ARTIFACT_POWERS
@ CHAR_UPD_GUILD_RANK_BANK_MONEY
@ CHAR_INS_ITEM_INSTANCE_AZERITE
@ CHAR_SEL_MAIL_LIST_ITEMS
@ CHAR_SEL_UNDELETE_ENUM_DECLINED_NAME
@ CHAR_UPD_CHAR_LIST_SLOT
@ CHAR_INS_CHARACTER_AURA_STORED_LOCATION
@ CHAR_SEL_PETITION_SIG_BY_ACCOUNT
@ CHAR_SEL_ITEM_INSTANCE_AZERITE_MILESTONE_POWER
@ CHAR_DEL_CHAR_SPELL_BY_SPELL
@ CHAR_SEL_CHAR_CREATE_INFO
@ CHAR_SEL_CHARACTER_INVENTORY
@ CHAR_UPD_CHAR_QUESTSTATUS_REWARDED_ACTIVE_BY_QUEST
@ CHAR_UPD_GROUP_DIFFICULTY
@ CHAR_UPD_CHARACTER_POSITION
@ CHAR_DEL_ITEM_BOP_TRADE
@ CHAR_INS_CHAR_ACHIEVEMENT
@ CHAR_DEL_CHAR_TRAIT_ENTRIES
@ CHAR_DEL_CHAR_QUESTSTATUS_BY_QUEST
@ CHAR_UPD_QUEST_TRACK_GM_COMPLETE
@ CHAR_SEL_EXPIRED_MAIL_ITEMS
@ CHAR_DEL_RESET_CHARACTER_QUESTSTATUS_DAILY
@ CHAR_DEL_CHARACTER_QUESTSTATUS_SEASONAL
@ CHAR_UPD_PET_SPECS_BY_OWNER
@ CHAR_DEL_ITEM_INSTANCE_MODIFIERS
@ CHAR_SEL_MAILITEMS_ARTIFACT
@ CHAR_DEL_CHAR_TRAIT_CONFIGS_BY_CHAR
@ CHAR_SEL_CHARACTER_QUESTSTATUS
@ CHAR_UPD_CHARACTER_POSITION_BY_MAPID
@ CHAR_SEL_CHAR_DEL_INFO_BY_GUID
@ CHAR_DEL_GAME_EVENT_CONDITION_SAVE
@ CHAR_REP_CHARACTER_ARENA_STATS
@ CHAR_INS_CHAR_SPELL_COOLDOWN
@ CHAR_DEL_CHAR_TRAIT_CONFIGS
@ CHAR_INS_ITEM_INSTANCE_AZERITE_MILESTONE_POWER
@ CHAR_SEL_GUILD_MEMBER_EXTENDED
@ CHAR_DEL_PLAYER_ACCOUNT_DATA
@ CHAR_DEL_BLACKMARKET_AUCTIONS
@ CHAR_DEL_CHARACTER_GARRISON_BLUEPRINTS
@ CHAR_UPD_ACCOUNT_ONLINE
@ CHAR_UPD_GUILD_RANK_RIGHTS
@ CHAR_SEL_BLACKMARKET_AUCTIONS
@ CHAR_DEL_ITEM_INSTANCE_TRANSMOG_BY_OWNER
@ CHAR_UPD_PLAYER_HOMEBIND
@ CHAR_INS_CORPSE_CUSTOMIZATIONS
@ CHAR_UPD_GUILD_MEMBER_PNOTE
@ CHAR_INS_AUCTION_BIDDER
@ CHAR_DEL_CHAR_ACHIEVEMENT_BY_ACHIEVEMENT
@ CHAR_SEL_CHARS_BY_ACCOUNT_ID
@ CHAR_SEL_CHAR_POSITION_XYZ
@ CHAR_SEL_CHARACTER_TALENTS
@ CHAR_UPD_ITEM_INSTANCE_AZERITE_ON_LOAD
@ CHAR_SEL_MAIL_LIST_INFO
@ CHAR_INS_GM_COMPLAINT_CHATLINE
@ CHAR_UPD_ITEM_INSTANCE_AZERITE_EMPOWERED
@ CHAR_UPD_CHARACTER_INSTANCE_LOCK_FORCE_EXPIRE
@ CHAR_SEL_CHAR_CUF_PROFILES
@ CHAR_DEL_CHAR_SKILL_BY_SKILL
@ CHAR_SEL_MAIL_COUNT_ITEM
@ CHAR_INS_ITEM_INSTANCE_AZERITE_UNLOCKED_ESSENCE
@ CHAR_REP_WORLD_VARIABLE
@ CHAR_UPD_CHARACTER_SOCIAL_NOTE
@ CHAR_SEL_CHARACTER_SPELL_FAVORITES
@ CHAR_DEL_ITEM_INSTANCE_AZERITE_EMPOWERED_BY_OWNER
@ CHAR_DEL_CHAR_PET_BY_ID
@ CHAR_INS_GUILD_BANK_TAB
@ CHAR_SEL_CORPSE_LOCATION
@ CHAR_INS_CHARACTER_GARRISON_FOLLOWER_ABILITIES
@ CHAR_SEL_CHAR_DATA_FOR_GUILD
@ CHAR_UPD_CHARACTER_SOCIAL_FLAGS
@ CHAR_UPD_GUILD_BANK_MONEY
@ CHAR_INS_CHARACTER_QUESTSTATUS_WEEKLY
@ CHAR_SEL_CHARACTER_CRITERIAPROGRESS
@ CHAR_INS_CHARACTER_GARRISON
@ CHAR_UPD_GROUP_RAID_DIFFICULTY
@ CHAR_DEL_ITEM_REFUND_INSTANCE
@ CHAR_DEL_GUILD_BANK_TAB
@ CHAR_DEL_INVALID_ACHIEVMENT
@ CHAR_DEL_CHAR_INVENTORY
@ CHAR_UPD_ARENA_TEAM_MEMBER
@ CHAR_DEL_BATTLEGROUND_RANDOM_ALL
@ CHAR_DEL_ACCOUNT_INSTANCE_LOCK_TIMES
@ CHAR_SEL_AUCTIONHOUSE_COUNT_ITEM
@ CHAR_SEL_PET_DECLINED_NAME
@ CHAR_SEL_CHARACTER_GLYPHS
@ CHAR_SEL_CHARACTER_REPUTATION
@ CHAR_UPD_GROUP_MEMBER_FLAG
@ MAX_CHARACTERDATABASE_STATEMENTS
@ CHAR_DEL_CHAR_QUESTSTATUS
@ CHAR_DEL_CHARACTER_INSTANCE_LOCK_BY_GUID
@ CHAR_SEL_CHARACTER_SPELL
@ CHAR_SEL_MATCH_MAKER_RATING
@ CHAR_INS_GUILD_MEMBER_WITHDRAW_TABS
@ CHAR_REP_CHAR_QUESTSTATUS_OBJECTIVES
@ CHAR_UPD_ARENA_TEAM_NAME
@ CHAR_DEL_ITEM_INSTANCE_AZERITE_UNLOCKED_ESSENCE
@ CHAR_SEL_ITEM_BOP_TRADE
@ CHAR_UPD_CHAR_REP_FACTION_CHANGE
@ CHAR_UPD_GUILD_MEMBER_OFFNOTE
@ CHAR_SEL_PETITION_SIGNATURE
@ CHAR_DEL_ITEM_INSTANCE_MODIFIERS_BY_OWNER
@ CHAR_DEL_GUILD_BANK_EVENTLOG
@ CHAR_INS_ITEM_INSTANCE_MODIFIERS
@ CHAR_UPD_ACCOUNT_BY_GUID
@ CHAR_DEL_GUILD_MEMBER_WITHDRAW
@ CHAR_SEL_PETITION_SIGNATURES
@ CHAR_REP_PLAYER_ACCOUNT_DATA
@ CHAR_DEL_AUCTION_ITEMS_BY_ITEM
@ CHAR_INS_ITEMCONTAINER_ITEMS
@ CHAR_INS_ITEMCONTAINER_MONEY
@ CHAR_SEL_GUILD_BANK_COUNT_ITEM
@ CHAR_DEL_CHARACTER_SOCIAL
@ CHAR_DEL_CHAR_ACHIEVEMENTS
@ CHAR_SEL_CHARACTER_QUESTSTATUS_SEASONAL
@ CHAR_DEL_CHARACTER_GARRISON_BUILDINGS
@ CHAR_SEL_GUID_BY_NAME_FILTER
@ CHAR_SEL_CHARACTER_RANDOMBG
@ CHAR_SEL_CHARACTER_EQUIPMENTSETS
@ CHAR_SEL_CHARACTER_SKILLS
@ CHAR_INS_CHAR_SPELL_CHARGES
@ CHAR_DEL_CHAR_VOID_STORAGE_ITEM_BY_CHAR_GUID
@ CHAR_SEL_CHARACTER_QUESTSTATUS_DAILY
@ CHAR_DEL_GUILD_BANK_ITEMS
@ CHAR_INS_GAME_EVENT_CONDITION_SAVE
@ CHAR_REP_PLAYER_CURRENCY
@ CHAR_UPD_ARENA_TEAM_CAPTAIN
@ CHAR_UPD_CHAR_TITLES_FACTION_CHANGE
@ CHAR_DEL_GUILD_BANK_ITEM
@ CHAR_SEL_GM_COMPLAINT_CHATLINES
@ CHAR_SEL_CHAR_COD_ITEM_MAIL
@ CHAR_SEL_AUCTIONHOUSE_ITEM_BY_ENTRY
@ CHAR_DEL_GUILD_EVENTLOG
@ CHAR_DEL_CHAR_REP_BY_FACTION
@ CHAR_INS_ITEM_INSTANCE_TRANSMOG
@ CHAR_UPD_CHARACTER_GARRISON_FOLLOWER_ACTIVATIONS
@ CHAR_DEL_CHAR_ACTION_BY_TRAIT_CONFIG
@ CHAR_DEL_CHAR_VOID_STORAGE_ITEM_BY_SLOT
@ CHAR_SEL_ENUM_DECLINED_NAME
@ CHAR_DEL_PETITION_SIGNATURE_BY_GUID
@ CHAR_SEL_CHARACTER_SPELLCOOLDOWNS
@ CHAR_SEL_ITEMCONTAINER_MONEY
@ CHAR_DEL_GUILD_EVENTLOGS
@ CHAR_INS_ITEM_INSTANCE_ARTIFACT
@ CHAR_SEL_GUILD_BANK_ITEM_BY_ENTRY
@ CHAR_INS_GUILD_BANK_EVENTLOG
@ CHAR_UPD_ADD_AT_LOGIN_FLAG
@ CHAR_INS_CHAR_PVP_TALENT
@ CHAR_RES_CHAR_TITLES_FACTION_CHANGE
@ CHAR_INS_ITEM_INSTANCE_GEMS
@ CHAR_DEL_CORPSES_FROM_MAP
@ CHAR_INS_CHAR_QUESTSTATUS_OBJECTIVES_CRITERIA
@ CHAR_DEL_RESET_CHARACTER_QUESTSTATUS_WEEKLY
@ CHAR_SEL_PET_AURA_EFFECT
@ CHAR_DEL_CHAR_REPUTATION
@ CHAR_DEL_CHAR_TRAIT_ENTRIES_BY_CHAR
@ CHAR_DEL_PET_SPELL_BY_SPELL
@ CHAR_INS_CHARACTER_SOCIAL
@ CHAR_DEL_ITEM_INSTANCE_ARTIFACT_BY_OWNER
@ CHAR_DEL_CHARACTER_AURA_STORED_LOCATION
@ CHAR_DEL_PET_SPELL_COOLDOWNS
@ CHAR_DEL_ITEM_INSTANCE_AZERITE
@ CHAR_SEL_CHARACTER_AURA_STORED_LOCATIONS
@ CHAR_DEL_CHAR_INVENTORY_BY_BAG_SLOT
@ CHAR_SEL_CHARACTER_TRANSMOG_OUTFITS
@ CHAR_INS_CHAR_REPUTATION_BY_FACTION
@ CHAR_SEL_UNDELETE_ENUM_CUSTOMIZATIONS
@ CHAR_DEL_CHAR_ACHIEVEMENT_PROGRESS
@ CHAR_SEL_CHAR_INVENTORY_COUNT_ITEM
@ CHAR_SEL_CHARACTER_GARRISON_BLUEPRINTS
@ CHAR_INS_CHARACTER_QUESTSTATUS_MONTHLY
@ CHAR_SEL_ITEM_INSTANCE_AZERITE
@ CHAR_SEL_CHARACTER_SPELL_CHARGES
@ CHAR_SEL_PET_SPELL_COOLDOWN
@ CHAR_DEL_CHAR_PVP_TALENT
@ CHAR_SEL_CHARACTER_AURA_EFFECTS
@ CHAR_UPD_CHAR_QUESTSTATUS_REWARDED_ACTIVE
@ CHAR_SEL_PET_SPELL_CHARGES
@ CHAR_DEL_CHAR_SOCIAL_BY_GUID
@ CHAR_INS_CHARACTER_GARRISON_FOLLOWERS
@ CHAR_SEL_CHARACTER_GIFT_BY_ITEM
@ CHAR_INS_GUILD_ACHIEVEMENT
@ CHAR_SEL_CHARACTER_ACHIEVEMENTS
@ CHAR_SEL_CHARACTER_ONLINE
@ CHAR_SEL_MAILITEMS_AZERITE_EMPOWERED
@ CHAR_SEL_CHARACTER_QUESTSTATUS_OBJECTIVES
@ CHAR_UPD_CHARACTER_INSTANCE_LOCK_EXTENSION
@ CHAR_DEL_GUILD_ACHIEVEMENT
@ CHAR_DEL_CHAR_AURA_EFFECT
@ CHAR_DEL_GUILD_ACHIEVEMENT_CRITERIA
@ CHAR_UPD_GUILD_RANK_ORDER
@ CHAR_INS_CHAR_TRAIT_CONFIGS
@ CHAR_SEL_CHARACTER_GARRISON_FOLLOWERS
@ CHAR_DEL_ALL_GUILD_ACHIEVEMENT_CRITERIA
@ CHAR_INS_PVPSTATS_BATTLEGROUND
@ CHAR_UPD_RESTORE_DELETE_INFO
@ CHAR_UPD_GROUP_MEMBER_SUBGROUP
@ CHAR_SEL_ITEM_INSTANCE_ARTIFACT
@ CHAR_DEL_PLAYER_CURRENCY
@ CHAR_INS_TRANSMOG_OUTFIT
@ CHAR_INS_ITEM_BOP_TRADE
@ CHAR_DEL_CHAR_QUESTSTATUS_OBJECTIVES_CRITERIA
@ CHAR_DEL_MAIL_ITEM_BY_ID
@ CHAR_DEL_PET_AURA_EFFECTS
@ CHAR_DEL_CHAR_REPUTATION_BY_FACTION
@ CHAR_INS_GUILD_BANK_ITEM
@ CHAR_DEL_ITEM_INSTANCE_AZERITE_UNLOCKED_ESSENCE_BY_OWNER
@ CHAR_REP_CHAR_QUESTSTATUS
@ CHAR_UPD_GROUP_LEGACY_RAID_DIFFICULTY
@ CHAR_SEL_CHARACTER_DECLINEDNAMES
@ CHAR_SEL_CHARACTER_ARENAINFO
@ CHAR_INS_GUILD_MEMBER_WITHDRAW_MONEY
@ CHAR_DEL_INVALID_ACHIEV_PROGRESS_CRITERIA
@ CHAR_UPD_CHAR_NAME_AT_LOGIN
@ CHAR_UPD_TRANSMOG_OUTFIT
@ CHAR_DEL_CHAR_QUESTSTATUS_REWARDED
@ CHAR_UPD_GUILD_BANK_TAB_INFO
@ CHAR_DEL_CHAR_QUESTSTATUS_OBJECTIVES_BY_QUEST
@ CHAR_DEL_CHAR_QUESTSTATUS_OBJECTIVES_CRITERIA_PROGRESS_BY_CRITERIA
@ CHAR_INS_CHAR_DECLINED_NAME
@ CHAR_DEL_GM_COMPLAINT_CHATLOG
@ CHAR_DEL_PETITION_BY_OWNER
@ CHAR_DEL_CHAR_SPELL_CHARGES
@ CHAR_SEL_CHARACTER_BANNED
@ CHAR_DEL_CHARACTER_QUESTSTATUS_MONTHLY
@ CHAR_UPD_ALL_AT_LOGIN_FLAGS
@ CHAR_DEL_ITEM_INSTANCE_GEMS_BY_OWNER
@ CHAR_INS_CHAR_QUESTSTATUS_OBJECTIVES_CRITERIA_PROGRESS
@ CHAR_DEL_ITEM_INSTANCE_AZERITE_MILESTONE_POWER
@ CHAR_INS_ACCOUNT_INSTANCE_LOCK_TIMES
@ CHAR_DEL_INVALID_ACHIEV_PROGRESS_CRITERIA_GUILD
@ CHAR_SEL_WAR_MODE_TUNING
@ CHAR_DEL_ARENA_TEAM_MEMBER
@ CHAR_DEL_TRANSMOG_OUTFIT
@ CHAR_SEL_MAIL_ITEMS_BY_ENTRY
@ CHAR_INS_CHARACTER_FAVORITE_AUCTION
@ CHAR_SEL_CHARACTER_CUSTOMIZATIONS
@ CHAR_INS_ITEM_REFUND_INSTANCE
@ CHAR_INS_CHAR_PET_DECLINEDNAME
@ CHAR_INS_CHAR_QUESTSTATUS_REWARDED
@ CHAR_UPD_MAIL_ITEM_RECEIVER
@ CHAR_DEL_CHAR_ACHIEVEMENT
@ CHAR_INS_CHAR_SPELL_FAVORITE
@ CHAR_DEL_BATTLEGROUND_RANDOM
@ CHAR_DEL_CHAR_PET_DECLINEDNAME
@ CHAR_SEL_GUILD_ACHIEVEMENT_CRITERIA
@ CHAR_INS_GUILD_BANK_RIGHT
CharacterDatabaseConnection(MySQLConnectionInfo &connInfo, ConnectionFlags connectionFlags)
~CharacterDatabaseConnection()
void DoPrepareStatements() override
void PrepareStatement(uint32 index, std::string_view sql, ConnectionFlags flags)
PreparedStatementContainer m_stmts
PreparedStatements storage.
bool m_reconnecting
Are we reconnecting?