Project SkyFire Core
SkyFire 5.4.8 server core API documentation
Loading...
Searching...
No Matches
CharacterDatabase.cpp
Go to the documentation of this file.
1/*
2* This file is part of Project SkyFire https://www.projectskyfire.org.
3* See LICENSE.md file for Copyright information
4*/
5
6#include "CharacterDatabase.h"
7
8void CharacterDatabaseConnection::DoPrepareStatements()
9{
10 if (!m_reconnecting)
11 m_stmts.resize(MAX_CHARACTERDATABASE_STATEMENTS);
12
13 PrepareStatement(CHAR_DEL_QUEST_POOL_SAVE, "DELETE FROM pool_quest_save WHERE pool_id = ?", CONNECTION_ASYNC);
14 PrepareStatement(CHAR_INS_QUEST_POOL_SAVE, "INSERT INTO pool_quest_save (pool_id, quest_id) VALUES (?, ?)", CONNECTION_ASYNC);
15 PrepareStatement(CHAR_DEL_NONEXISTENT_GUILD_BANK_ITEM, "DELETE FROM guild_bank_item WHERE guildid = ? AND TabId = ? AND SlotId = ?", CONNECTION_ASYNC);
16 PrepareStatement(CHAR_DEL_EXPIRED_BANS, "UPDATE character_banned SET active = 0 WHERE unbandate <= UNIX_TIMESTAMP() AND unbandate <> bandate", CONNECTION_ASYNC);
17 PrepareStatement(CHAR_SEL_GUID_BY_NAME, "SELECT guid FROM characters WHERE name = ?", CONNECTION_BOTH);
18 PrepareStatement(CHAR_SEL_CHECK_NAME, "SELECT 1 FROM characters WHERE name = ?", CONNECTION_BOTH);
19 PrepareStatement(CHAR_SEL_CHECK_GUID, "SELECT 1 FROM characters WHERE guid = ?", CONNECTION_SYNCH);
20 PrepareStatement(CHAR_SEL_SUM_CHARS, "SELECT COUNT(guid) FROM characters WHERE account = ?", CONNECTION_BOTH);
21 PrepareStatement(CHAR_SEL_CHAR_CREATE_INFO, "SELECT level, race, class FROM characters WHERE account = ? LIMIT 0, ?", CONNECTION_ASYNC);
22 PrepareStatement(CHAR_INS_CHARACTER_BAN, "INSERT INTO character_banned VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?, 1)", CONNECTION_ASYNC);
23 PrepareStatement(CHAR_UPD_CHARACTER_BAN, "UPDATE character_banned SET active = 0 WHERE guid = ? AND active != 0", CONNECTION_ASYNC);
24 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);
25 PrepareStatement(CHAR_SEL_BANINFO, "SELECT FROM_UNIXTIME(bandate), unbandate-bandate, active, unbandate, banreason, bannedby FROM character_banned WHERE guid = ? ORDER BY bandate ASC", CONNECTION_SYNCH);
26 PrepareStatement(CHAR_SEL_GUID_BY_NAME_FILTER, "SELECT guid, name FROM characters WHERE name LIKE CONCAT('%%', ?, '%%')", CONNECTION_SYNCH);
27 PrepareStatement(CHAR_SEL_BANINFO_LIST, "SELECT bandate, unbandate, bannedby, banreason FROM character_banned WHERE guid = ? ORDER BY unbandate", CONNECTION_SYNCH);
28 PrepareStatement(CHAR_SEL_BANNED_NAME, "SELECT characters.name FROM characters, character_banned WHERE character_banned.guid = ? AND character_banned.guid = characters.guid", CONNECTION_SYNCH);
29 PrepareStatement(CHAR_SEL_MAIL_LIST_COUNT, "SELECT COUNT(id) FROM mail WHERE receiver = ? ", CONNECTION_SYNCH);
30 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, "
31 "subject, deliver_time, expire_time, money, has_items FROM mail WHERE receiver = ? ", CONNECTION_SYNCH);
32 PrepareStatement(CHAR_SEL_MAIL_LIST_ITEMS, "SELECT itemEntry,count FROM item_instance WHERE guid = ?", CONNECTION_SYNCH);
33 PrepareStatement(CHAR_SEL_ENUM, "SELECT c.guid, c.name, c.race, c.class, c.gender, c.playerBytes, c.playerBytes2, c.level, c.zone, c.map, c.position_x, c.position_y, c.position_z, "
34 "gm.guildid, c.playerFlags, c.at_login, cp.entry, cp.modelid, cp.level, c.equipmentCache, cb.guid, c.slot, c.realm "
35 "FROM characters AS c LEFT JOIN character_pet AS cp ON c.guid = cp.owner AND cp.active = 1 LEFT JOIN guild_member AS gm ON c.guid = gm.guid "
36 "LEFT JOIN character_banned AS cb ON c.guid = cb.guid AND cb.active = 1 WHERE c.account = ? AND c.realm = ? AND c.deleteInfos_Name IS NULL", CONNECTION_ASYNC);
37 PrepareStatement(CHAR_SEL_ENUM_DECLINED_NAME, "SELECT c.guid, c.name, c.race, c.class, c.gender, c.playerBytes, c.playerBytes2, c.level, c.zone, c.map, "
38 "c.position_x, c.position_y, c.position_z, gm.guildid, c.playerFlags, c.at_login, cp.entry, cp.modelid, cp.level, c.equipmentCache, "
39 "cb.guid, c.slot, cd.genitive FROM characters AS c LEFT JOIN character_pet AS cp ON c.guid = cp.owner AND cp.active = 1 "
40 "LEFT JOIN character_declinedname AS cd ON c.guid = cd.guid LEFT JOIN guild_member AS gm ON c.guid = gm.guid "
41 "LEFT JOIN character_banned AS cb ON c.guid = cb.guid AND cb.active = 1 WHERE c.account = ? AND c.realm = ? AND c.deleteInfos_Name IS NULL", CONNECTION_ASYNC);
42 PrepareStatement(CHAR_SEL_FREE_NAME, "SELECT guid, name FROM characters WHERE guid = ? AND account = ? AND (at_login & ?) = ? AND NOT EXISTS (SELECT NULL FROM characters WHERE name = ?)", CONNECTION_ASYNC);
43 PrepareStatement(CHAR_SEL_GUID_RACE_ACC_BY_NAME, "SELECT guid, race, account FROM characters WHERE name = ?", CONNECTION_BOTH);
44 PrepareStatement(CHAR_SEL_CHAR_RACE, "SELECT race FROM characters WHERE guid = ?", CONNECTION_SYNCH);
45 PrepareStatement(CHAR_SEL_CHAR_LEVEL, "SELECT level FROM characters WHERE guid = ?", CONNECTION_SYNCH);
46 PrepareStatement(CHAR_SEL_CHAR_ZONE, "SELECT zone FROM characters WHERE guid = ?", CONNECTION_SYNCH);
47 PrepareStatement(CHAR_SEL_CHARACTER_NAME_DATA, "SELECT race, class, gender, level, realm FROM characters WHERE guid = ?", CONNECTION_SYNCH);
48 PrepareStatement(CHAR_SEL_CHAR_POSITION_XYZ, "SELECT map, position_x, position_y, position_z FROM characters WHERE guid = ?", CONNECTION_SYNCH);
49 PrepareStatement(CHAR_SEL_CHAR_POSITION, "SELECT position_x, position_y, position_z, orientation, map, taxi_path FROM characters WHERE guid = ?", CONNECTION_SYNCH);
50 PrepareStatement(CHAR_DEL_QUEST_STATUS_DAILY, "DELETE FROM character_queststatus_daily", CONNECTION_ASYNC);
51 PrepareStatement(CHAR_DEL_QUEST_STATUS_WEEKLY, "DELETE FROM character_queststatus_weekly", CONNECTION_ASYNC);
52 PrepareStatement(CHAR_DEL_QUEST_STATUS_MONTHLY, "DELETE FROM character_queststatus_monthly", CONNECTION_ASYNC);
53 PrepareStatement(CHAR_DEL_QUEST_STATUS_SEASONAL, "DELETE FROM character_queststatus_seasonal WHERE event = ?", CONNECTION_ASYNC);
54 PrepareStatement(CHAR_DEL_QUEST_STATUS_DAILY_CHAR, "DELETE FROM character_queststatus_daily WHERE guid = ?", CONNECTION_ASYNC);
55 PrepareStatement(CHAR_DEL_QUEST_STATUS_WEEKLY_CHAR, "DELETE FROM character_queststatus_weekly WHERE guid = ?", CONNECTION_ASYNC);
56 PrepareStatement(CHAR_DEL_QUEST_STATUS_MONTHLY_CHAR, "DELETE FROM character_queststatus_monthly WHERE guid = ?", CONNECTION_ASYNC);
57 PrepareStatement(CHAR_DEL_QUEST_STATUS_SEASONAL_CHAR, "DELETE FROM character_queststatus_seasonal WHERE guid = ?", CONNECTION_ASYNC);
58 PrepareStatement(CHAR_DEL_BATTLEGROUND_RANDOM, "DELETE FROM character_battleground_random", CONNECTION_ASYNC);
59 PrepareStatement(CHAR_INS_BATTLEGROUND_RANDOM, "INSERT INTO character_battleground_random (guid) VALUES (?)", CONNECTION_ASYNC);
60
61 // Start LoginQueryHolder content
62 PrepareStatement(CHAR_SEL_CHARACTER, "SELECT guid, account, name, race, class, gender, level, xp, money, playerBytes, playerBytes2, playerFlags, "
63 "position_x, position_y, position_z, map, orientation, taximask, cinematic, totaltime, leveltime, rest_bonus, logout_time, is_logout_resting, resettalents_cost, "
64 "resettalents_time, talentTree, trans_x, trans_y, trans_z, trans_o, transguid, extra_flags, stable_slots, at_login, zone, online, death_expire_time, taxi_path, dungeondifficulty, "
65 "totalKills, todayKills, yesterdayKills, chosenTitle, watchedFaction, drunk, "
66 "health, power1, power2, power3, power4, power5, instance_id, speccount, activespec, exploredZones, equipmentCache, knownTitles, actionBars, grantableLevels, lfgbonusfaction, raiddifficulty "
67 "FROM characters WHERE guid = ?", CONNECTION_ASYNC);
68
69 PrepareStatement(CHAR_SEL_GROUP_MEMBER, "SELECT guid FROM party_member WHERE memberGuid = ?", CONNECTION_BOTH);
70 PrepareStatement(CHAR_SEL_CHARACTER_INSTANCE, "SELECT id, permanent, map, difficulty, resettime FROM character_instance LEFT JOIN instance ON instance = id WHERE guid = ?", CONNECTION_ASYNC);
71 PrepareStatement(CHAR_SEL_CHARACTER_AURAS, "SELECT caster_guid, spell, effect_mask, recalculate_mask, stackcount, amount0, amount1, amount2, "
72 "base_amount0, base_amount1, base_amount2, maxduration, remaintime, remaincharges FROM character_aura WHERE guid = ?", CONNECTION_ASYNC);
73 PrepareStatement(CHAR_SEL_CHARACTER_SPELL, "SELECT spell, active, disabled FROM character_spell WHERE guid = ?", CONNECTION_ASYNC);
74 PrepareStatement(CHAR_SEL_CHARACTER_QUESTSTATUS, "SELECT quest, status, explored, timer FROM character_queststatus WHERE guid = ? AND status <> 0", CONNECTION_ASYNC);
75 PrepareStatement(CHAR_SEL_CHARACTER_QUEST_OBJECTIVE_STATUS, "SELECT `objectiveId`, `amount` FROM `character_queststatus_objective` WHERE guid = ?", CONNECTION_ASYNC);
76 PrepareStatement(CHAR_SEL_CHARACTER_DAILYQUESTSTATUS, "SELECT quest, time FROM character_queststatus_daily WHERE guid = ?", CONNECTION_ASYNC);
77 PrepareStatement(CHAR_SEL_CHARACTER_WEEKLYQUESTSTATUS, "SELECT quest FROM character_queststatus_weekly WHERE guid = ?", CONNECTION_ASYNC);
78 PrepareStatement(CHAR_SEL_CHARACTER_MONTHLYQUESTSTATUS, "SELECT quest FROM character_queststatus_monthly WHERE guid = ?", CONNECTION_ASYNC);
79 PrepareStatement(CHAR_SEL_CHARACTER_SEASONALQUESTSTATUS, "SELECT quest, event FROM character_queststatus_seasonal WHERE guid = ?", CONNECTION_ASYNC);
80 PrepareStatement(CHAR_INS_CHARACTER_DAILYQUESTSTATUS, "INSERT INTO character_queststatus_daily (guid, quest, time) VALUES (?, ?, ?)", CONNECTION_ASYNC);
81 PrepareStatement(CHAR_INS_CHARACTER_WEEKLYQUESTSTATUS, "INSERT INTO character_queststatus_weekly (guid, quest) VALUES (?, ?)", CONNECTION_ASYNC);
82 PrepareStatement(CHAR_INS_CHARACTER_MONTHLYQUESTSTATUS, "INSERT INTO character_queststatus_monthly (guid, quest) VALUES (?, ?)", CONNECTION_ASYNC);
83 PrepareStatement(CHAR_INS_CHARACTER_SEASONALQUESTSTATUS, "INSERT INTO character_queststatus_seasonal (guid, quest, event) VALUES (?, ?, ?)", CONNECTION_ASYNC);
84 PrepareStatement(CHAR_SEL_CHARACTER_REPUTATION, "SELECT faction, standing, flags FROM character_reputation WHERE guid = ?", CONNECTION_ASYNC);
85 PrepareStatement(CHAR_SEL_CHARACTER_INVENTORY, "SELECT creatorGuid, giftCreatorGuid, count, duration, charges, flags, enchantments, randomPropertyId, reforgeID, iit.transmogrifyId, durability, playedTime, text, bag, slot, "
86 "item, itemEntry FROM character_inventory ci JOIN item_instance ii ON ci.item = ii.guid LEFT JOIN item_instance_transmog iit ON ii.guid = iit.itemGuid WHERE ci.guid = ? ORDER BY bag, slot", CONNECTION_ASYNC);
87 PrepareStatement(CHAR_SEL_CHARACTER_ACTIONS, "SELECT a.button, a.action, a.type FROM character_action as a, characters as c WHERE a.guid = c.guid AND a.spec = c.activespec AND a.guid = ? ORDER BY button", CONNECTION_ASYNC);
88 PrepareStatement(CHAR_SEL_CHARACTER_MAILCOUNT, "SELECT COUNT(id) FROM mail WHERE receiver = ? AND (checked & 1) = 0 AND deliver_time <= ?", CONNECTION_ASYNC);
89 PrepareStatement(CHAR_SEL_CHARACTER_MAILDATE, "SELECT MIN(deliver_time) FROM mail WHERE receiver = ? AND (checked & 1) = 0", CONNECTION_ASYNC);
90 PrepareStatement(CHAR_SEL_MAIL_COUNT, "SELECT COUNT(*) FROM mail WHERE receiver = ?", CONNECTION_SYNCH);
91 PrepareStatement(CHAR_SEL_CHARACTER_SOCIALLIST, "SELECT friend, flags, note FROM character_social JOIN characters ON characters.guid = character_social.friend WHERE character_social.guid = ? AND deleteinfos_name IS NULL LIMIT 255", CONNECTION_ASYNC);
92 PrepareStatement(CHAR_SEL_CHARACTER_HOMEBIND, "SELECT mapId, zoneId, posX, posY, posZ FROM character_homebind WHERE guid = ?", CONNECTION_ASYNC);
93 PrepareStatement(CHAR_SEL_CHARACTER_SPELLCOOLDOWNS, "SELECT spell, item, time FROM character_spell_cooldown WHERE guid = ?", CONNECTION_ASYNC);
94 PrepareStatement(CHAR_SEL_CHARACTER_DECLINEDNAMES, "SELECT genitive, dative, accusative, instrumental, prepositional FROM character_declinedname WHERE guid = ?", CONNECTION_ASYNC);
95 PrepareStatement(CHAR_SEL_GUILD_MEMBER, "SELECT guildid, member_rank FROM guild_member WHERE guid = ?", CONNECTION_BOTH);
96 PrepareStatement(CHAR_SEL_GUILD_MEMBER_EXTENDED, "SELECT g.guildid, g.name, gr.rname, gr.rid, gm.pnote, gm.offnote "
97 "FROM guild g JOIN guild_member gm ON g.guildid = gm.guildid "
98 "JOIN guild_rank gr ON g.guildid = gr.guildid AND gm.member_rank = gr.rid WHERE gm.guid = ?", CONNECTION_BOTH);
99 PrepareStatement(CHAR_SEL_CHARACTER_ACHIEVEMENTS, "SELECT achievement, date FROM character_achievement WHERE guid = ?", CONNECTION_ASYNC);
100 PrepareStatement(CHAR_SEL_CHARACTER_CRITERIAPROGRESS, "SELECT criteria, counter, date FROM character_achievement_progress WHERE guid = ?", CONNECTION_ASYNC);
101 PrepareStatement(CHAR_SEL_CHARACTER_EQUIPMENTSETS, "SELECT setguid, setindex, name, iconname, ignore_mask, item0, item1, item2, item3, item4, item5, item6, item7, item8, "
102 "item9, item10, item11, item12, item13, item14, item15, item16, item17, item18 FROM character_equipmentsets WHERE guid = ? ORDER BY setindex", CONNECTION_ASYNC);
103 PrepareStatement(CHAR_SEL_CHARACTER_BGDATA, "SELECT instanceId, team, joinX, joinY, joinZ, joinO, joinMapId, taxiStart, taxiEnd, mountSpell FROM character_battleground_data WHERE guid = ?", CONNECTION_ASYNC);
104 PrepareStatement(CHAR_SEL_CHARACTER_GLYPHS, "SELECT spec, glyph1, glyph2, glyph3, glyph4, glyph5, glyph6 FROM character_glyphs WHERE guid = ?", CONNECTION_ASYNC);
105 PrepareStatement(CHAR_SEL_CHARACTER_TALENTS, "SELECT spell, spec FROM character_talent WHERE guid = ?", CONNECTION_ASYNC);
106 PrepareStatement(CHAR_SEL_CHARACTER_SKILLS, "SELECT skill, value, max FROM character_skills WHERE guid = ?", CONNECTION_ASYNC);
107 PrepareStatement(CHAR_SEL_CHARACTER_RANDOMBG, "SELECT guid FROM character_battleground_random WHERE guid = ?", CONNECTION_ASYNC);
108 PrepareStatement(CHAR_SEL_CHARACTER_BANNED, "SELECT guid FROM character_banned WHERE guid = ? AND active = 1", CONNECTION_ASYNC);
109 PrepareStatement(CHAR_SEL_CHARACTER_QUESTSTATUSREW, "SELECT quest FROM character_queststatus_rewarded WHERE guid = ? AND active = 1", CONNECTION_ASYNC);
110 PrepareStatement(CHAR_SEL_ACCOUNT_INSTANCELOCKTIMES, "SELECT instanceId, releaseTime FROM account_instance_times WHERE accountId = ?", CONNECTION_ASYNC);
111 // End LoginQueryHolder content
112
113 PrepareStatement(CHAR_SEL_CHARACTER_ACTIONS_SPEC, "SELECT button, action, type FROM character_action WHERE guid = ? AND spec = ? ORDER BY button", CONNECTION_SYNCH);
114 PrepareStatement(CHAR_SEL_MAILITEMS, "SELECT creatorGuid, giftCreatorGuid, count, duration, charges, flags, enchantments, randomPropertyId, durability, playedTime, text, item_guid, itemEntry, owner_guid FROM mail_items mi JOIN item_instance ii ON mi.item_guid = ii.guid WHERE mail_id = ?", CONNECTION_SYNCH);
115 PrepareStatement(CHAR_SEL_AUCTION_ITEMS, "SELECT creatorGuid, giftCreatorGuid, count, duration, charges, flags, enchantments, randomPropertyId, durability, playedTime, text, itemguid, itemEntry FROM auctionhouse ah JOIN item_instance ii ON ah.itemguid = ii.guid", CONNECTION_SYNCH);
116 PrepareStatement(CHAR_SEL_AUCTIONS, "SELECT id, auctioneerguid, itemguid, itemEntry, count, itemowner, buyoutprice, time, buyguid, lastbid, startbid, deposit FROM auctionhouse ah INNER JOIN item_instance ii ON ii.guid = ah.itemguid", CONNECTION_SYNCH);
117 PrepareStatement(CHAR_INS_AUCTION, "INSERT INTO auctionhouse (id, auctioneerguid, itemguid, itemowner, buyoutprice, time, buyguid, lastbid, startbid, deposit) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
118 PrepareStatement(CHAR_DEL_AUCTION, "DELETE FROM auctionhouse WHERE id = ?", CONNECTION_ASYNC);
119 PrepareStatement(CHAR_SEL_AUCTION_BY_TIME, "SELECT id FROM auctionhouse WHERE time <= ? ORDER BY TIME ASC", CONNECTION_SYNCH);
120 PrepareStatement(CHAR_UPD_AUCTION_BID, "UPDATE auctionhouse SET buyguid = ?, lastbid = ? WHERE id = ?", CONNECTION_ASYNC);
121 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);
122 PrepareStatement(CHAR_DEL_MAIL_BY_ID, "DELETE FROM mail WHERE id = ?", CONNECTION_ASYNC);
123 PrepareStatement(CHAR_INS_MAIL_ITEM, "INSERT INTO mail_items(mail_id, item_guid, receiver) VALUES (?, ?, ?)", CONNECTION_ASYNC);
124 PrepareStatement(CHAR_DEL_MAIL_ITEM, "DELETE FROM mail_items WHERE item_guid = ?", CONNECTION_ASYNC);
125 PrepareStatement(CHAR_DEL_INVALID_MAIL_ITEM, "DELETE FROM mail_items WHERE item_guid = ?", CONNECTION_ASYNC);
126 PrepareStatement(CHAR_DEL_EMPTY_EXPIRED_MAIL, "DELETE FROM mail WHERE expire_time < ? AND has_items = 0 AND body = ''", CONNECTION_ASYNC);
127 PrepareStatement(CHAR_SEL_EXPIRED_MAIL, "SELECT id, messageType, sender, receiver, has_items, expire_time, cod, checked, mailTemplateId FROM mail WHERE expire_time < ?", CONNECTION_SYNCH);
128 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);
129 PrepareStatement(CHAR_UPD_MAIL_RETURNED, "UPDATE mail SET sender = ?, receiver = ?, expire_time = ?, deliver_time = ?, cod = 0, checked = ? WHERE id = ?", CONNECTION_ASYNC);
130 PrepareStatement(CHAR_UPD_MAIL_ITEM_RECEIVER, "UPDATE mail_items SET receiver = ? WHERE item_guid = ?", CONNECTION_ASYNC);
131 PrepareStatement(CHAR_UPD_ITEM_OWNER, "UPDATE item_instance SET owner_guid = ? WHERE guid = ?", CONNECTION_ASYNC);
132
133 PrepareStatement(CHAR_SEL_ITEM_REFUNDS, "SELECT player_guid, paidMoney, paidExtendedCost FROM item_refund_instance WHERE item_guid = ? AND player_guid = ? LIMIT 1", CONNECTION_SYNCH);
134 PrepareStatement(CHAR_SEL_ITEM_BOP_TRADE, "SELECT allowedPlayers FROM item_soulbound_trade_data WHERE itemGuid = ? LIMIT 1", CONNECTION_SYNCH);
135 PrepareStatement(CHAR_DEL_ITEM_BOP_TRADE, "DELETE FROM item_soulbound_trade_data WHERE itemGuid = ? LIMIT 1", CONNECTION_ASYNC);
136 PrepareStatement(CHAR_INS_ITEM_BOP_TRADE, "INSERT INTO item_soulbound_trade_data VALUES (?, ?)", CONNECTION_ASYNC);
137 PrepareStatement(CHAR_REP_INVENTORY_ITEM, "REPLACE INTO character_inventory (guid, bag, slot, item) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
138 PrepareStatement(CHAR_REP_ITEM_INSTANCE, "REPLACE INTO item_instance (itemEntry, owner_guid, creatorGuid, giftCreatorGuid, count, duration, charges, flags, enchantments, randomPropertyId, reforgeID, durability, playedTime, text, guid) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
139 PrepareStatement(CHAR_UPD_ITEM_INSTANCE, "UPDATE item_instance SET itemEntry = ?, owner_guid = ?, creatorGuid = ?, giftCreatorGuid = ?, count = ?, duration = ?, charges = ?, flags = ?, enchantments = ?, randomPropertyId = ?, reforgeID = ?, durability = ?, playedTime = ?, text = ? WHERE guid = ?", CONNECTION_ASYNC);
140 PrepareStatement(CHAR_UPD_ITEM_INSTANCE_ON_LOAD, "UPDATE item_instance SET duration = ?, flags = ?, durability = ? WHERE guid = ?", CONNECTION_ASYNC);
141 PrepareStatement(CHAR_DEL_ITEM_INSTANCE, "DELETE FROM item_instance WHERE guid = ?", CONNECTION_ASYNC);
142 PrepareStatement(CHAR_DEL_ITEM_INSTANCE_BY_OWNER, "DELETE FROM item_instance WHERE owner_guid = ?", CONNECTION_ASYNC);
143 PrepareStatement(CHAR_INS_ITEM_INSTANCE_TRANSMOG, "INSERT INTO item_instance_transmog (itemGuid, transmogrifyId) VALUES (?, ?)", CONNECTION_ASYNC);
144 PrepareStatement(CHAR_DEL_ITEM_INSTANCE_TRANSMOG, "DELETE FROM item_instance_transmog WHERE itemGuid = ?", CONNECTION_ASYNC);
145 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);
146 PrepareStatement(CHAR_UPD_GIFT_OWNER, "UPDATE character_gifts SET guid = ? WHERE item_guid = ?", CONNECTION_ASYNC);
147 PrepareStatement(CHAR_DEL_GIFT, "DELETE FROM character_gifts WHERE item_guid = ?", CONNECTION_ASYNC);
148 PrepareStatement(CHAR_SEL_CHARACTER_GIFT_BY_ITEM, "SELECT entry, flags FROM character_gifts WHERE item_guid = ?", CONNECTION_SYNCH);
149 PrepareStatement(CHAR_SEL_ACCOUNT_BY_NAME, "SELECT account FROM characters WHERE name = ?", CONNECTION_SYNCH);
150 PrepareStatement(CHAR_SEL_ACCOUNT_BY_GUID, "SELECT account FROM characters WHERE guid = ?", CONNECTION_SYNCH);
151 PrepareStatement(CHAR_SEL_CHARACTER_DATA_BY_GUID, "SELECT account, name, level FROM characters WHERE guid = ?", CONNECTION_SYNCH);
152 PrepareStatement(CHAR_DEL_ACCOUNT_INSTANCE_LOCK_TIMES, "DELETE FROM account_instance_times WHERE accountId = ?", CONNECTION_ASYNC);
153 PrepareStatement(CHAR_INS_ACCOUNT_INSTANCE_LOCK_TIMES, "INSERT INTO account_instance_times (accountId, instanceId, releaseTime) VALUES (?, ?, ?)", CONNECTION_ASYNC);
154 PrepareStatement(CHAR_SEL_CHARACTER_NAME_CLASS, "SELECT name, class FROM characters WHERE guid = ?", CONNECTION_SYNCH);
155 PrepareStatement(CHAR_SEL_CHARACTER_NAME, "SELECT name FROM characters WHERE guid = ?", CONNECTION_SYNCH);
156 PrepareStatement(CHAR_SEL_MATCH_MAKER_RATING, "SELECT matchMakerRating FROM character_arena_stats WHERE guid = ? AND slot = ?", CONNECTION_SYNCH);
157 PrepareStatement(CHAR_SEL_CHARACTER_COUNT, "SELECT account, COUNT(guid) FROM characters WHERE account = ? GROUP BY account", CONNECTION_ASYNC);
158 PrepareStatement(CHAR_UPD_NAME, "UPDATE characters set name = ?, at_login = at_login & ~ ? WHERE guid = ?", CONNECTION_ASYNC);
159 PrepareStatement(CHAR_UPD_NAME_BY_GUID, "UPDATE characters SET name = ? WHERE guid = ?", CONNECTION_ASYNC);
160 PrepareStatement(CHAR_DEL_DECLINED_NAME, "DELETE FROM character_declinedname WHERE guid = ?", CONNECTION_ASYNC);
161
162 // Guild handling
163 // 0: uint32, 1: string, 2: uint32, 3: string, 4: string, 5: uint64, 6-10: uint32, 11: uint64
164 PrepareStatement(CHAR_INS_GUILD, "INSERT INTO guild (guildid, name, leaderguid, info, motd, createdate, EmblemStyle, EmblemColor, BorderStyle, BorderColor, BackgroundColor, BankMoney) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
165 PrepareStatement(CHAR_DEL_GUILD, "DELETE FROM guild WHERE guildid = ?", CONNECTION_ASYNC); // 0: uint32
166 // 0: string, 1: uint32
167 PrepareStatement(CHAR_UPD_GUILD_NAME, "UPDATE guild SET name = ? WHERE guildid = ?", CONNECTION_ASYNC);
168 // 0: uint32, 1: uint32, 2: uint8, 4: string, 5: string
169 PrepareStatement(CHAR_INS_GUILD_MEMBER, "INSERT INTO guild_member (guildid, guid, member_rank, pnote, offnote) VALUES (?, ?, ?, ?, ?)", CONNECTION_ASYNC);
170 PrepareStatement(CHAR_DEL_GUILD_MEMBER, "DELETE FROM guild_member WHERE guid = ?", CONNECTION_ASYNC); // 0: uint32
171 PrepareStatement(CHAR_DEL_GUILD_MEMBERS, "DELETE FROM guild_member WHERE guildid = ?", CONNECTION_ASYNC); // 0: uint32
172 // 0: uint32, 1: uint8, 3: string, 4: uint32
173 PrepareStatement(CHAR_INS_GUILD_RANK, "INSERT INTO guild_rank (guildid, rid, rname, rights, BankMoneyPerDay) VALUES (?, ?, ?, ?, ?)", CONNECTION_ASYNC);
174 PrepareStatement(CHAR_DEL_GUILD_RANKS, "DELETE FROM guild_rank WHERE guildid = ?", CONNECTION_ASYNC); // 0: uint32
175 PrepareStatement(CHAR_DEL_GUILD_RANK, "DELETE FROM guild_rank WHERE guildid = ? AND rid = ?", CONNECTION_ASYNC); // 0: uint32, 1: uint8
176 PrepareStatement(CHAR_INS_GUILD_BANK_TAB, "INSERT INTO guild_bank_tab (guildid, TabId) VALUES (?, ?)", CONNECTION_ASYNC); // 0: uint32, 1: uint8
177 PrepareStatement(CHAR_DEL_GUILD_BANK_TAB, "DELETE FROM guild_bank_tab WHERE guildid = ? AND TabId = ?", CONNECTION_ASYNC); // 0: uint32, 1: uint8
178 PrepareStatement(CHAR_DEL_GUILD_BANK_TABS, "DELETE FROM guild_bank_tab WHERE guildid = ?", CONNECTION_ASYNC); // 0: uint32
179 // 0: uint32, 1: uint8, 2: uint8, 3: uint32, 4: uint32
180 PrepareStatement(CHAR_INS_GUILD_BANK_ITEM, "INSERT INTO guild_bank_item (guildid, TabId, SlotId, item_guid) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
181 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
182 PrepareStatement(CHAR_DEL_GUILD_BANK_ITEMS, "DELETE FROM guild_bank_item WHERE guildid = ?", CONNECTION_ASYNC); // 0: uint32
183 // 0: uint32, 1: uint8, 2: uint8, 3: uint8, 4: uint32
184 PrepareStatement(CHAR_INS_GUILD_BANK_RIGHT, "INSERT INTO guild_bank_right (guildid, TabId, rid, gbright, SlotPerDay) VALUES (?, ?, ?, ?, ?) "
185 "ON DUPLICATE KEY UPDATE gbright = VALUES(gbright), SlotPerDay = VALUES(SlotPerDay)", CONNECTION_ASYNC);
186 PrepareStatement(CHAR_DEL_GUILD_BANK_RIGHTS, "DELETE FROM guild_bank_right WHERE guildid = ?", CONNECTION_ASYNC); // 0: uint32
187 PrepareStatement(CHAR_DEL_GUILD_BANK_RIGHTS_FOR_RANK, "DELETE FROM guild_bank_right WHERE guildid = ? AND rid = ?", CONNECTION_ASYNC); // 0: uint32, 1: uint8
188 // 0-1: uint32, 2-3: uint8, 4-5: uint32, 6: uint16, 7: uint8, 8: uint64
189 PrepareStatement(CHAR_INS_GUILD_BANK_EVENTLOG, "INSERT INTO guild_bank_eventlog (guildid, LogGuid, TabId, EventType, PlayerGuid, ItemOrMoney, ItemStackCount, DestTabId, TimeStamp) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
190 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
191 PrepareStatement(CHAR_DEL_GUILD_BANK_EVENTLOGS, "DELETE FROM guild_bank_eventlog WHERE guildid = ?", CONNECTION_ASYNC); // 0: uint32
192 // 0-1: uint32, 2: uint8, 3-4: uint32, 5: uint8, 6: uint64
193 PrepareStatement(CHAR_INS_GUILD_EVENTLOG, "INSERT INTO guild_eventlog (guildid, LogGuid, EventType, PlayerGuid1, PlayerGuid2, NewRank, TimeStamp) VALUES (?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
194 PrepareStatement(CHAR_DEL_GUILD_EVENTLOG, "DELETE FROM guild_eventlog WHERE guildid = ? AND LogGuid = ?", CONNECTION_ASYNC); // 0: uint32, 1: uint32
195 PrepareStatement(CHAR_DEL_GUILD_EVENTLOGS, "DELETE FROM guild_eventlog WHERE guildid = ?", CONNECTION_ASYNC); // 0: uint32
196 PrepareStatement(CHAR_UPD_GUILD_MEMBER_PNOTE, "UPDATE guild_member SET pnote = ? WHERE guid = ?", CONNECTION_ASYNC); // 0: string, 1: uint32
197 PrepareStatement(CHAR_UPD_GUILD_MEMBER_OFFNOTE, "UPDATE guild_member SET offnote = ? WHERE guid = ?", CONNECTION_ASYNC); // 0: string, 1: uint32
198 PrepareStatement(CHAR_UPD_GUILD_MEMBER_RANK, "UPDATE guild_member SET member_rank = ? WHERE guid = ?", CONNECTION_ASYNC); // 0: uint8, 1: uint32
199 PrepareStatement(CHAR_UPD_GUILD_MOTD, "UPDATE guild SET motd = ? WHERE guildid = ?", CONNECTION_ASYNC); // 0: string, 1: uint32
200 PrepareStatement(CHAR_UPD_GUILD_INFO, "UPDATE guild SET info = ? WHERE guildid = ?", CONNECTION_ASYNC); // 0: string, 1: uint32
201 PrepareStatement(CHAR_UPD_GUILD_LEADER, "UPDATE guild SET leaderguid = ? WHERE guildid = ?", CONNECTION_ASYNC); // 0: uint32, 1: uint32
202 PrepareStatement(CHAR_UPD_GUILD_RANK_NAME, "UPDATE guild_rank SET rname = ? WHERE rid = ? AND guildid = ?", CONNECTION_ASYNC); // 0: string, 1: uint8, 2: uint32
203 PrepareStatement(CHAR_UPD_GUILD_RANK_RIGHTS, "UPDATE guild_rank SET rights = ? WHERE rid = ? AND guildid = ?", CONNECTION_ASYNC); // 0: uint32, 1: uint8, 2: uint32
204 // 0-5: uint32
205 PrepareStatement(CHAR_UPD_GUILD_EMBLEM_INFO, "UPDATE guild SET EmblemStyle = ?, EmblemColor = ?, BorderStyle = ?, BorderColor = ?, BackgroundColor = ? WHERE guildid = ?", CONNECTION_ASYNC);
206 // 0: string, 1: string, 2: uint32, 3: uint8
207 PrepareStatement(CHAR_UPD_GUILD_BANK_TAB_INFO, "UPDATE guild_bank_tab SET TabName = ?, TabIcon = ? WHERE guildid = ? AND TabId = ?", CONNECTION_ASYNC);
208 PrepareStatement(CHAR_UPD_GUILD_BANK_MONEY, "UPDATE guild SET BankMoney = ? WHERE guildid = ?", CONNECTION_ASYNC); // 0: uint64, 1: uint32
209 // 0: uint8, 1: uint32, 2: uint8, 3: uint32
210 PrepareStatement(CHAR_UPD_GUILD_BANK_EVENTLOG_TAB, "UPDATE guild_bank_eventlog SET TabId = ? WHERE guildid = ? AND TabId = ? AND LogGuid = ?", CONNECTION_ASYNC);
211 PrepareStatement(CHAR_UPD_GUILD_RANK_BANK_MONEY, "UPDATE guild_rank SET BankMoneyPerDay = ? WHERE rid = ? AND guildid = ?", CONNECTION_ASYNC); // 0: uint32, 1: uint8, 2: uint32
212 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
213
214 PrepareStatement(CHAR_INS_GUILD_MEMBER_WITHDRAW,
215 "INSERT INTO guild_member_withdraw (guid, tab0, tab1, tab2, tab3, tab4, tab5, tab6, tab7, money) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) "
216 "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), money = VALUES (money)", CONNECTION_ASYNC);
217 PrepareStatement(CHAR_DEL_GUILD_MEMBER_WITHDRAW, "TRUNCATE guild_member_withdraw", CONNECTION_ASYNC);
218
219 // 0: uint32, 1: uint32, 2: uint32
220 PrepareStatement(CHAR_SEL_CHAR_DATA_FOR_GUILD, "SELECT name, level, class, zone, account, realm FROM characters WHERE guid = ?", CONNECTION_SYNCH);
221 PrepareStatement(CHAR_DEL_GUILD_ACHIEVEMENT, "DELETE FROM guild_achievement WHERE guildId = ? AND achievement = ?", CONNECTION_ASYNC);
222 PrepareStatement(CHAR_INS_GUILD_ACHIEVEMENT, "INSERT INTO guild_achievement (guildId, achievement, date, guids) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
223 PrepareStatement(CHAR_DEL_GUILD_ACHIEVEMENT_CRITERIA, "DELETE FROM guild_achievement_progress WHERE guildId = ? AND criteria = ?", CONNECTION_ASYNC);
224 PrepareStatement(CHAR_INS_GUILD_ACHIEVEMENT_CRITERIA, "INSERT INTO guild_achievement_progress (guildId, criteria, counter, date, completedGuid) VALUES (?, ?, ?, ?, ?)", CONNECTION_ASYNC);
225 PrepareStatement(CHAR_DEL_ALL_GUILD_ACHIEVEMENTS, "DELETE FROM guild_achievement WHERE guildId = ?", CONNECTION_ASYNC);
226 PrepareStatement(CHAR_DEL_ALL_GUILD_ACHIEVEMENT_CRITERIA, "DELETE FROM guild_achievement_progress WHERE guildId = ?", CONNECTION_ASYNC);
227 PrepareStatement(CHAR_SEL_GUILD_ACHIEVEMENT, "SELECT achievement, date, guids FROM guild_achievement WHERE guildId = ?", CONNECTION_SYNCH);
228 PrepareStatement(CHAR_SEL_GUILD_ACHIEVEMENT_CRITERIA, "SELECT criteria, counter, date, completedGuid FROM guild_achievement_progress WHERE guildId = ?", CONNECTION_SYNCH);
229 PrepareStatement(CHAR_UPD_GUILD_EXPERIENCE, "UPDATE guild SET level = ?, experience = ?, todayExperience = ? WHERE guildId = ?", CONNECTION_ASYNC);
230 PrepareStatement(CHAR_UPD_GUILD_RESET_TODAY_EXPERIENCE, "UPDATE guild SET todayExperience = 0", CONNECTION_ASYNC);
231 PrepareStatement(CHAR_INS_GUILD_NEWS, "INSERT INTO guild_newslog (guildid, LogGuid, EventType, PlayerGuid, Flags, Value, Timestamp) VALUES (?, ?, ?, ?, ?, ?, ?)"
232 " ON DUPLICATE KEY UPDATE LogGuid = VALUES (LogGuid), EventType = VALUES (EventType), PlayerGuid = VALUES (PlayerGuid), Flags = VALUES (Flags), Value = VALUES (Value), Timestamp = VALUES (Timestamp)", CONNECTION_ASYNC);
233
234 // Chat channel handling
235 PrepareStatement(CHAR_SEL_CHANNEL, "SELECT announce, ownership, password, bannedList FROM channels WHERE name = ? AND team = ?", CONNECTION_SYNCH);
236 PrepareStatement(CHAR_INS_CHANNEL, "INSERT INTO channels(name, team, lastUsed) VALUES (?, ?, UNIX_TIMESTAMP())", CONNECTION_ASYNC);
237 PrepareStatement(CHAR_UPD_CHANNEL, "UPDATE channels SET announce = ?, ownership = ?, password = ?, bannedList = ?, lastUsed = UNIX_TIMESTAMP() WHERE name = ? AND team = ?", CONNECTION_ASYNC);
238 PrepareStatement(CHAR_UPD_CHANNEL_USAGE, "UPDATE channels SET lastUsed = UNIX_TIMESTAMP() WHERE name = ? AND team = ?", CONNECTION_ASYNC);
239 PrepareStatement(CHAR_UPD_CHANNEL_OWNERSHIP, "UPDATE channels SET ownership = ? WHERE name LIKE ?", CONNECTION_ASYNC);
240 PrepareStatement(CHAR_DEL_OLD_CHANNELS, "DELETE FROM channels WHERE ownership = 1 AND lastUsed + ? < UNIX_TIMESTAMP()", CONNECTION_ASYNC);
241
242 // Equipmentsets
243 PrepareStatement(CHAR_UPD_EQUIP_SET, "UPDATE character_equipmentsets SET name=?, iconname=?, ignore_mask=?, item0=?, item1=?, item2=?, item3=?, "
244 "item4=?, item5=?, item6=?, item7=?, item8=?, item9=?, item10=?, item11=?, item12=?, item13=?, item14=?, item15=?, item16=?, "
245 "item17=?, item18=? WHERE guid=? AND setguid=? AND setindex=?", CONNECTION_ASYNC);
246 PrepareStatement(CHAR_INS_EQUIP_SET, "INSERT INTO character_equipmentsets (guid, setguid, setindex, name, iconname, ignore_mask, item0, item1, item2, item3, "
247 "item4, item5, item6, item7, item8, item9, item10, item11, item12, item13, item14, item15, item16, item17, item18) "
248 "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
249 PrepareStatement(CHAR_DEL_EQUIP_SET, "DELETE FROM character_equipmentsets WHERE setguid=?", CONNECTION_ASYNC);
250
251 // Auras
252 PrepareStatement(CHAR_INS_AURA, "INSERT INTO character_aura (guid, caster_guid, item_guid, spell, effect_mask, recalculate_mask, stackcount, amount0, amount1, amount2, base_amount0, base_amount1, base_amount2, maxduration, remaintime, remaincharges) "
253 "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
254
255 // Currency
256 PrepareStatement(CHAR_SEL_PLAYER_CURRENCY, "SELECT currency, quantity, weekly_quantity, tracked_quantity, flags FROM character_currency WHERE guid = ?", CONNECTION_ASYNC);
257 PrepareStatement(CHAR_UPD_PLAYER_CURRENCY, "UPDATE character_currency SET quantity = ?, weekly_quantity = ?, tracked_quantity = ?, flags = ? WHERE guid = ? AND currency = ?", CONNECTION_ASYNC);
258 PrepareStatement(CHAR_REP_PLAYER_CURRENCY, "REPLACE INTO character_currency (guid, currency, quantity, weekly_quantity, tracked_quantity, flags) VALUES (?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
259
260 // Account data
261 PrepareStatement(CHAR_SEL_ACCOUNT_DATA, "SELECT type, time, data FROM account_data WHERE accountId = ?", CONNECTION_SYNCH);
262 PrepareStatement(CHAR_REP_ACCOUNT_DATA, "REPLACE INTO account_data (accountId, type, time, data) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
263 PrepareStatement(CHAR_DEL_ACCOUNT_DATA, "DELETE FROM account_data WHERE accountId = ?", CONNECTION_ASYNC);
264 PrepareStatement(CHAR_SEL_PLAYER_ACCOUNT_DATA, "SELECT type, time, data FROM character_account_data WHERE guid = ?", CONNECTION_ASYNC);
265 PrepareStatement(CHAR_REP_PLAYER_ACCOUNT_DATA, "REPLACE INTO character_account_data(guid, type, time, data) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
266 PrepareStatement(CHAR_DEL_PLAYER_ACCOUNT_DATA, "DELETE FROM character_account_data WHERE guid = ?", CONNECTION_ASYNC);
267
268 // Tutorials
269 PrepareStatement(CHAR_SEL_TUTORIALS, "SELECT tut0, tut1, tut2, tut3, tut4, tut5, tut6, tut7 FROM account_tutorial WHERE accountId = ?", CONNECTION_SYNCH);
270 PrepareStatement(CHAR_SEL_HAS_TUTORIALS, "SELECT 1 FROM account_tutorial WHERE accountId = ?", CONNECTION_SYNCH);
271 PrepareStatement(CHAR_INS_TUTORIALS, "INSERT INTO account_tutorial(tut0, tut1, tut2, tut3, tut4, tut5, tut6, tut7, accountId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
272 PrepareStatement(CHAR_UPD_TUTORIALS, "UPDATE account_tutorial SET tut0 = ?, tut1 = ?, tut2 = ?, tut3 = ?, tut4 = ?, tut5 = ?, tut6 = ?, tut7 = ? WHERE accountId = ?", CONNECTION_ASYNC);
273 PrepareStatement(CHAR_DEL_TUTORIALS, "DELETE FROM account_tutorial WHERE accountId = ?", CONNECTION_ASYNC);
274
275 // Instance saves
276 PrepareStatement(CHAR_INS_INSTANCE_SAVE, "INSERT INTO instance (id, map, resettime, difficulty, completedEncounters, data) VALUES (?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
277 PrepareStatement(CHAR_UPD_INSTANCE_DATA, "UPDATE instance SET completedEncounters=?, data=? WHERE id=?", CONNECTION_ASYNC);
278
279 // Game event saves
280 PrepareStatement(CHAR_DEL_GAME_EVENT_SAVE, "DELETE FROM game_event_save WHERE eventEntry = ?", CONNECTION_ASYNC);
281 PrepareStatement(CHAR_INS_GAME_EVENT_SAVE, "INSERT INTO game_event_save (eventEntry, state, next_start) VALUES (?, ?, ?)", CONNECTION_ASYNC);
282
283 // Game event condition saves
284 PrepareStatement(CHAR_DEL_ALL_GAME_EVENT_CONDITION_SAVE, "DELETE FROM game_event_condition_save WHERE eventEntry = ?", CONNECTION_ASYNC);
285 PrepareStatement(CHAR_DEL_GAME_EVENT_CONDITION_SAVE, "DELETE FROM game_event_condition_save WHERE eventEntry = ? AND condition_id = ?", CONNECTION_ASYNC);
286 PrepareStatement(CHAR_INS_GAME_EVENT_CONDITION_SAVE, "INSERT INTO game_event_condition_save (eventEntry, condition_id, done) VALUES (?, ?, ?)", CONNECTION_ASYNC);
287
288 // Petitions
289 PrepareStatement(CHAR_SEL_PETITION, "SELECT ownerguid, name, type FROM petition WHERE petitionguid = ?", CONNECTION_SYNCH);
290 PrepareStatement(CHAR_SEL_PETITION_SIGNATURE, "SELECT playerguid FROM petition_sign WHERE petitionguid = ?", CONNECTION_SYNCH);
291 PrepareStatement(CHAR_DEL_ALL_PETITION_SIGNATURES, "DELETE FROM petition_sign WHERE playerguid = ?", CONNECTION_ASYNC);
292 PrepareStatement(CHAR_DEL_PETITION_SIGNATURE, "DELETE FROM petition_sign WHERE playerguid = ? AND type = ?", CONNECTION_ASYNC);
293 PrepareStatement(CHAR_SEL_PETITION_BY_OWNER, "SELECT petitionguid FROM petition WHERE ownerguid = ? AND type = ?", CONNECTION_SYNCH);
294
295 PrepareStatement(CHAR_SEL_PETITION_SIGNATURES, "SELECT ownerguid, (SELECT COUNT(playerguid) FROM petition_sign WHERE petition_sign.petitionguid = ?) AS signs, type FROM petition WHERE petitionguid = ?", CONNECTION_SYNCH);
296 PrepareStatement(CHAR_SEL_PETITION_SIG_BY_ACCOUNT, "SELECT playerguid FROM petition_sign WHERE player_account = ? AND petitionguid = ?", CONNECTION_SYNCH);
297 PrepareStatement(CHAR_SEL_PETITION_OWNER_BY_GUID, "SELECT ownerguid FROM petition WHERE petitionguid = ?", CONNECTION_SYNCH);
298 PrepareStatement(CHAR_SEL_PETITION_SIG_BY_GUID, "SELECT ownerguid, petitionguid FROM petition_sign WHERE playerguid = ?", CONNECTION_SYNCH);
299 PrepareStatement(CHAR_SEL_PETITION_SIG_BY_GUID_TYPE, "SELECT ownerguid, petitionguid FROM petition_sign WHERE playerguid = ? AND type = ?", CONNECTION_SYNCH);
300
301 PrepareStatement(CHAR_REP_CHARACTER_ARENA_STATS, "REPLACE INTO character_arena_stats (guid, slot, matchMakerRating) VALUES (?, ?, ?)", CONNECTION_ASYNC);
302
303 // Character battleground data
304 PrepareStatement(CHAR_INS_PLAYER_BGDATA, "INSERT INTO character_battleground_data (guid, instanceId, team, joinX, joinY, joinZ, joinO, joinMapId, taxiStart, taxiEnd, mountSpell) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
305 PrepareStatement(CHAR_DEL_PLAYER_BGDATA, "DELETE FROM character_battleground_data WHERE guid = ?", CONNECTION_ASYNC);
306
307 // Character homebind
308 PrepareStatement(CHAR_INS_PLAYER_HOMEBIND, "INSERT INTO character_homebind (guid, mapId, zoneId, posX, posY, posZ) VALUES (?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
309 PrepareStatement(CHAR_UPD_PLAYER_HOMEBIND, "UPDATE character_homebind SET mapId = ?, zoneId = ?, posX = ?, posY = ?, posZ = ? WHERE guid = ?", CONNECTION_ASYNC);
310 PrepareStatement(CHAR_DEL_PLAYER_HOMEBIND, "DELETE FROM character_homebind WHERE guid = ?", CONNECTION_ASYNC);
311
312 // Corpse
313 PrepareStatement(CHAR_SEL_CORPSES, "SELECT posX, posY, posZ, orientation, mapId, displayId, itemCache, bytes1, bytes2, flags, dynFlags, time, corpseType, instanceId, phaseMask, corpseGuid, guid FROM corpse WHERE corpseType <> 0", CONNECTION_SYNCH);
314 PrepareStatement(CHAR_INS_CORPSE, "INSERT INTO corpse (corpseGuid, guid, posX, posY, posZ, orientation, mapId, displayId, itemCache, bytes1, bytes2, flags, dynFlags, time, corpseType, instanceId, phaseMask) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
315 PrepareStatement(CHAR_DEL_CORPSE, "DELETE FROM corpse WHERE corpseGuid = ?", CONNECTION_ASYNC);
316 PrepareStatement(CHAR_DEL_PLAYER_CORPSES, "DELETE FROM corpse WHERE guid = ? AND corpseType <> 0", CONNECTION_ASYNC);
317 PrepareStatement(CHAR_DEL_OLD_CORPSES, "DELETE FROM corpse WHERE corpseType = 0 OR time < (UNIX_TIMESTAMP(NOW()) - ?)", CONNECTION_ASYNC);
318
319 // Creature respawn
320 PrepareStatement(CHAR_SEL_CREATURE_RESPAWNS, "SELECT guid, respawnTime FROM creature_respawn WHERE mapId = ? AND instanceId = ?", CONNECTION_SYNCH);
321 PrepareStatement(CHAR_REP_CREATURE_RESPAWN, "REPLACE INTO creature_respawn (guid, respawnTime, mapId, instanceId) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
322 PrepareStatement(CHAR_DEL_CREATURE_RESPAWN, "DELETE FROM creature_respawn WHERE guid = ? AND mapId = ? AND instanceId = ?", CONNECTION_ASYNC);
323 PrepareStatement(CHAR_DEL_CREATURE_RESPAWN_BY_INSTANCE, "DELETE FROM creature_respawn WHERE mapId = ? AND instanceId = ?", CONNECTION_ASYNC);
324 PrepareStatement(CHAR_SEL_MAX_CREATURE_RESPAWNS, "SELECT MAX(respawnTime), instanceId FROM creature_respawn WHERE instanceId > 0 GROUP BY instanceId", CONNECTION_SYNCH);
325
326 // Gameobject respawn
327 PrepareStatement(CHAR_SEL_GO_RESPAWNS, "SELECT guid, respawnTime FROM gameobject_respawn WHERE mapId = ? AND instanceId = ?", CONNECTION_SYNCH);
328 PrepareStatement(CHAR_REP_GO_RESPAWN, "REPLACE INTO gameobject_respawn (guid, respawnTime, mapId, instanceId) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
329 PrepareStatement(CHAR_DEL_GO_RESPAWN, "DELETE FROM gameobject_respawn WHERE guid = ? AND mapId = ? AND instanceId = ?", CONNECTION_ASYNC);
330 PrepareStatement(CHAR_DEL_GO_RESPAWN_BY_INSTANCE, "DELETE FROM gameobject_respawn WHERE mapId = ? AND instanceId = ?", CONNECTION_ASYNC);
331
332 // GM Tickets
333 PrepareStatement(CHAR_SEL_GM_TICKETS, "SELECT ticketId, guid, name, message, createTime, mapId, posX, posY, posZ, lastModifiedTime, closedBy, assignedTo, comment, response, completed, escalated, viewed, haveTicket FROM gm_tickets", CONNECTION_SYNCH);
334 PrepareStatement(CHAR_REP_GM_TICKET, "REPLACE INTO gm_tickets (ticketId, guid, name, message, createTime, mapId, posX, posY, posZ, lastModifiedTime, closedBy, assignedTo, comment, response, completed, escalated, viewed, haveTicket) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
335 PrepareStatement(CHAR_DEL_GM_TICKET, "DELETE FROM gm_tickets WHERE ticketId = ?", CONNECTION_ASYNC);
336 PrepareStatement(CHAR_DEL_PLAYER_GM_TICKETS, "DELETE FROM gm_tickets WHERE guid = ?", CONNECTION_ASYNC);
337
338 // GM Bug Tickets
339 PrepareStatement(CHAR_SEL_GM_BUGS, "SELECT ticketId, playerGuid, bugNote, ticketCreateTime, mapId, posX, posY, posZ, orientation, closedBy, assignedTo, comment FROM ticket_bug", CONNECTION_SYNCH);
340 PrepareStatement(CHAR_REP_GM_BUG, "REPLACE INTO ticket_bug (ticketId, playerGuid, bugNote, ticketCreateTime, mapId, posX, posY, posZ, orientation, closedBy, assignedTo, comment) VALUES (?, ?, ?, UNIX_TIMESTAMP(NOW()), ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
341 PrepareStatement(CHAR_DEL_GM_BUG, "DELETE FROM ticket_bug WHERE ticketId = ?", CONNECTION_ASYNC);
342 PrepareStatement(CHAR_DEL_ALL_GM_BUGS, "TRUNCATE TABLE ticket_bug", CONNECTION_ASYNC);
343
344 // GM suggest Tickets
345 PrepareStatement(CHAR_SEL_GM_SUGGESTS, "SELECT ticketId, playerGuid, suggestNote, ticketCreateTime, mapId, posX, posY, posZ, orientation, closedBy, assignedTo, comment FROM ticket_suggest", CONNECTION_SYNCH);
346 PrepareStatement(CHAR_REP_GM_SUGGEST, "REPLACE INTO ticket_suggest (ticketId, playerGuid, suggestNote, ticketCreateTime, mapId, posX, posY, posZ, orientation, closedBy, assignedTo, comment) VALUES (?, ?, ?, UNIX_TIMESTAMP(NOW()), ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
347 PrepareStatement(CHAR_DEL_GM_SUGGEST, "DELETE FROM ticket_suggest WHERE ticketId = ?", CONNECTION_ASYNC);
348 PrepareStatement(CHAR_DEL_ALL_GM_SUGGESTS, "TRUNCATE TABLE ticket_suggest", CONNECTION_ASYNC);
349
350 // GM Survey/subsurvey/lag report
351 PrepareStatement(CHAR_INS_GM_SURVEY, "INSERT INTO gm_surveys (guid, surveyId, mainSurvey, overallComment, createTime) VALUES (?, ?, ?, ?, UNIX_TIMESTAMP(NOW()))", CONNECTION_ASYNC);
352 PrepareStatement(CHAR_INS_GM_SUBSURVEY, "INSERT INTO gm_subsurveys (surveyId, subsurveyId, `rank`, comment) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
353 PrepareStatement(CHAR_INS_LAG_REPORT, "INSERT INTO lag_reports (guid, lagType, mapId, posX, posY, posZ, latency, createTime) VALUES (?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
354
355 // For loading and deleting expired auctions at startup
356 PrepareStatement(CHAR_SEL_EXPIRED_AUCTIONS, "SELECT id, auctioneerguid, itemguid, itemEntry, count, itemowner, buyoutprice, time, buyguid, lastbid, startbid, deposit FROM auctionhouse ah INNER JOIN item_instance ii ON ii.guid = ah.itemguid WHERE ah.time <= ?", CONNECTION_SYNCH);
357
358 // LFG Data
359 PrepareStatement(CHAR_INS_LFG_DATA, "INSERT INTO lfg_data (guid, dungeon, state) VALUES (?, ?, ?)", CONNECTION_ASYNC);
360 PrepareStatement(CHAR_DEL_LFG_DATA, "DELETE FROM lfg_data WHERE guid = ?", CONNECTION_ASYNC);
361
362 // Player saving
363 PrepareStatement(CHAR_INS_CHARACTER, "INSERT INTO characters (guid, realm, account, name, race, class, gender, level, xp, money, playerBytes, playerBytes2, playerFlags, "
364 "map, instance_id, dungeondifficulty,raiddifficulty, position_x, position_y, position_z, orientation, "
365 "taximask, cinematic, "
366 "totaltime, leveltime, rest_bonus, logout_time, is_logout_resting, resettalents_cost, resettalents_time, talentTree, "
367 "extra_flags, stable_slots, at_login, zone, "
368 "death_expire_time, taxi_path, totalKills, "
369 "todayKills, yesterdayKills, chosenTitle, watchedFaction, lfgbonusfaction, drunk, health, power1, power2, power3, "
370 "power4, power5, latency, speccount, activespec, exploredZones, equipmentCache, knownTitles, actionBars, grantableLevels) VALUES "
371 "(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)", CONNECTION_ASYNC);
372 PrepareStatement(CHAR_UPD_CHARACTER, "UPDATE characters SET name=?,race=?,class=?,gender=?,level=?,xp=?,money=?,playerBytes=?,playerBytes2=?,playerFlags=?,"
373 "map=?,instance_id=?,dungeondifficulty=?,raiddifficulty=?,position_x=?,position_y=?,position_z=?,orientation=?,taximask=?,cinematic=?,totaltime=?,leveltime=?,rest_bonus=?,"
374 "logout_time=?,is_logout_resting=?,resettalents_cost=?,resettalents_time=?,talentTree=?,extra_flags=?,stable_slots=?,at_login=?,zone=?,death_expire_time=?,taxi_path=?,"
375 "totalKills=?,todayKills=?,yesterdayKills=?,chosenTitle=?,"
376 "watchedFaction=?,lfgbonusfaction=?,drunk=?,health=?,power1=?,power2=?,power3=?,power4=?,power5=?,latency=?,speccount=?,activespec=?,exploredZones=?,"
377 "equipmentCache=?,knownTitles=?,actionBars=?,grantableLevels=?,online=? WHERE guid=?", CONNECTION_ASYNC);
378
379 PrepareStatement(CHAR_UPD_CHARACTER_BOOST, "UPDATE characters SET race = ?, money = money + ?, level = ?, position_x = ?, position_y = ?, position_z = ?, orientation = ?, map = ?, talenttree = ?,"
380 "trans_x = 0, trans_y = 0, trans_z = 0, trans_o = 0, transguid = 0, at_login = at_login & ~ ?, activespec = 0, equipmentCache = ? WHERE guid = ?", CONNECTION_ASYNC);
381 PrepareStatement(CHAR_UPD_ADD_AT_LOGIN_FLAG, "UPDATE characters SET at_login = at_login | ? WHERE guid = ?", CONNECTION_ASYNC);
382 PrepareStatement(CHAR_UPD_REM_AT_LOGIN_FLAG, "UPDATE characters set at_login = at_login & ~ ? WHERE guid = ?", CONNECTION_ASYNC);
383 PrepareStatement(CHAR_UPD_ALL_AT_LOGIN_FLAGS, "UPDATE characters SET at_login = at_login | ?", CONNECTION_ASYNC);
384 PrepareStatement(CHAR_INS_BUG_REPORT, "INSERT INTO bugreport (type, content) VALUES(?, ?)", CONNECTION_ASYNC);
385 PrepareStatement(CHAR_UPD_PETITION_NAME, "UPDATE petition SET name = ? WHERE petitionguid = ?", CONNECTION_ASYNC);
386 PrepareStatement(CHAR_INS_PETITION_SIGNATURE, "INSERT INTO petition_sign (ownerguid, petitionguid, playerguid, player_account) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
387 PrepareStatement(CHAR_UPD_ACCOUNT_ONLINE, "UPDATE characters SET online = 0 WHERE account = ?", CONNECTION_ASYNC);
388 PrepareStatement(CHAR_INS_GROUP, "INSERT INTO parties (guid, leaderGuid, lootMethod, looterGuid, lootThreshold, icon1, icon2, icon3, icon4, icon5, icon6, icon7, icon8, partyType, difficulty, raiddifficulty) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
389 PrepareStatement(CHAR_INS_GROUP_MEMBER, "INSERT INTO party_member (guid, memberGuid, memberFlags, subparty, roles) VALUES(?, ?, ?, ?, ?)", CONNECTION_ASYNC);
390 PrepareStatement(CHAR_DEL_GROUP_MEMBER, "DELETE FROM party_member WHERE memberGuid = ?", CONNECTION_ASYNC);
391 PrepareStatement(CHAR_DEL_GROUP_INSTANCE_PERM_BINDING, "DELETE FROM party_instance WHERE guid = ? AND instance = ?", CONNECTION_ASYNC);
392 PrepareStatement(CHAR_UPD_GROUP_LEADER, "UPDATE parties SET leaderGuid = ? WHERE guid = ?", CONNECTION_ASYNC);
393 PrepareStatement(CHAR_UPD_GROUP_TYPE, "UPDATE parties SET partyType = ? WHERE guid = ?", CONNECTION_ASYNC);
394 PrepareStatement(CHAR_UPD_GROUP_MEMBER_SUBGROUP, "UPDATE party_member SET subparty = ? WHERE memberGuid = ?", CONNECTION_ASYNC);
395 PrepareStatement(CHAR_UPD_GROUP_MEMBER_FLAG, "UPDATE party_member SET memberFlags = ? WHERE memberGuid = ?", CONNECTION_ASYNC);
396 PrepareStatement(CHAR_UPD_GROUP_DIFFICULTY, "UPDATE parties SET difficulty = ? WHERE guid = ?", CONNECTION_ASYNC);
397 PrepareStatement(CHAR_UPD_GROUP_RAID_DIFFICULTY, "UPDATE parties SET raiddifficulty = ? WHERE guid = ?", CONNECTION_ASYNC);
398 PrepareStatement(CHAR_DEL_ALL_GM_TICKETS, "TRUNCATE TABLE gm_tickets", CONNECTION_ASYNC);
399 PrepareStatement(CHAR_DEL_INVALID_SPELL_TALENTS, "DELETE FROM character_talent WHERE spell = ?", CONNECTION_ASYNC);
400 PrepareStatement(CHAR_DEL_INVALID_SPELL_SPELLS, "DELETE FROM character_spell WHERE spell = ?", CONNECTION_ASYNC);
401 PrepareStatement(CHAR_UPD_DELETE_INFO, "UPDATE characters SET deleteInfos_Name = name, deleteInfos_Account = account, deleteDate = UNIX_TIMESTAMP(), name = '', account = 0 WHERE guid = ?", CONNECTION_ASYNC);
402 PrepareStatement(CHAR_UDP_RESTORE_DELETE_INFO, "UPDATE characters SET name = ?, account = ?, deleteDate = NULL, deleteInfos_Name = NULL, deleteInfos_Account = NULL WHERE deleteDate IS NOT NULL AND guid = ?", CONNECTION_ASYNC);
403 PrepareStatement(CHAR_UPD_ZONE, "UPDATE characters SET zone = ? WHERE guid = ?", CONNECTION_ASYNC);
404 PrepareStatement(CHAR_UPD_LEVEL, "UPDATE characters SET level = ?, xp = 0 WHERE guid = ?", CONNECTION_ASYNC);
405 PrepareStatement(CHAR_DEL_INVALID_ACHIEV_PROGRESS_CRITERIA, "DELETE FROM character_achievement_progress WHERE criteria = ?", CONNECTION_ASYNC);
406 PrepareStatement(CHAR_DEL_INVALID_ACHIEV_PROGRESS_CRITERIA_GUILD, "DELETE FROM guild_achievement_progress WHERE criteria = ?", CONNECTION_ASYNC);
407 PrepareStatement(CHAR_DEL_INVALID_ACHIEVMENT, "DELETE FROM character_achievement WHERE achievement = ?", CONNECTION_ASYNC);
408 PrepareStatement(CHAR_INS_ADDON, "INSERT INTO addons (name, crc) VALUES (?, ?)", CONNECTION_ASYNC);
409 PrepareStatement(CHAR_DEL_INVALID_PET_SPELL, "DELETE FROM pet_spell WHERE spell = ?", CONNECTION_ASYNC);
410 PrepareStatement(CHAR_DEL_GROUP_INSTANCE_BY_INSTANCE, "DELETE FROM party_instance WHERE instance = ?", CONNECTION_ASYNC);
411 PrepareStatement(CHAR_DEL_GROUP_INSTANCE_BY_GUID, "DELETE FROM party_instance WHERE guid = ? AND instance = ?", CONNECTION_ASYNC);
412 PrepareStatement(CHAR_REP_GROUP_INSTANCE, "REPLACE INTO party_instance (guid, instance, permanent) VALUES (?, ?, ?)", CONNECTION_ASYNC);
413 PrepareStatement(CHAR_UPD_INSTANCE_RESETTIME, "UPDATE instance SET resettime = ? WHERE id = ?", CONNECTION_ASYNC);
414 PrepareStatement(CHAR_UPD_GLOBAL_INSTANCE_RESETTIME, "UPDATE instance_reset SET resettime = ? WHERE mapid = ? AND difficulty = ?", CONNECTION_ASYNC);
415 PrepareStatement(CHAR_UPD_CHAR_ONLINE, "UPDATE characters SET online = 1 WHERE guid = ?", CONNECTION_ASYNC);
416 PrepareStatement(CHAR_UPD_CHAR_NAME_AT_LOGIN, "UPDATE characters set name = ?, at_login = at_login & ~ ? WHERE guid = ?", CONNECTION_ASYNC);
417 PrepareStatement(CHAR_UPD_WORLDSTATE, "UPDATE worldstates SET value = ? WHERE entry = ?", CONNECTION_ASYNC);
418 PrepareStatement(CHAR_INS_WORLDSTATE, "INSERT INTO worldstates (entry, value) VALUES (?, ?)", CONNECTION_ASYNC);
419 PrepareStatement(CHAR_DEL_CHAR_INSTANCE_BY_INSTANCE_GUID, "DELETE FROM character_instance WHERE guid = ? AND instance = ?", CONNECTION_ASYNC);
420 PrepareStatement(CHAR_UPD_CHAR_INSTANCE, "UPDATE character_instance SET instance = ?, permanent = ? WHERE guid = ? AND instance = ?", CONNECTION_ASYNC);
421 PrepareStatement(CHAR_INS_CHAR_INSTANCE, "INSERT INTO character_instance (guid, instance, permanent) VALUES (?, ?, ?)", CONNECTION_ASYNC);
422 PrepareStatement(CHAR_UPD_GENDER_PLAYERBYTES, "UPDATE characters SET gender = ?, playerBytes = ?, playerBytes2 = ? WHERE guid = ?", CONNECTION_ASYNC);
423 PrepareStatement(CHAR_DEL_CHARACTER_SKILL, "DELETE FROM character_skills WHERE guid = ? AND skill = ?", CONNECTION_ASYNC);
424 PrepareStatement(CHAR_UPD_ADD_CHARACTER_SOCIAL_FLAGS, "UPDATE character_social SET flags = flags | ? WHERE guid = ? AND friend = ?", CONNECTION_ASYNC);
425 PrepareStatement(CHAR_UPD_REM_CHARACTER_SOCIAL_FLAGS, "UPDATE character_social SET flags = flags & ~ ? WHERE guid = ? AND friend = ?", CONNECTION_ASYNC);
426 PrepareStatement(CHAR_INS_CHARACTER_SOCIAL, "INSERT INTO character_social (guid, friend, flags) VALUES (?, ?, ?)", CONNECTION_ASYNC);
427 PrepareStatement(CHAR_DEL_CHARACTER_SOCIAL, "DELETE FROM character_social WHERE guid = ? AND friend = ?", CONNECTION_ASYNC);
428 PrepareStatement(CHAR_UPD_CHARACTER_SOCIAL_NOTE, "UPDATE character_social SET note = ? WHERE guid = ? AND friend = ?", CONNECTION_ASYNC);
429 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 = '' WHERE guid = ?", CONNECTION_ASYNC);
430 PrepareStatement(CHAR_SEL_CHARACTER_AURA_FROZEN, "SELECT characters.name FROM characters LEFT JOIN character_aura ON (characters.guid = character_aura.guid) WHERE character_aura.spell = 9454", CONNECTION_SYNCH);
431 PrepareStatement(CHAR_SEL_CHARACTER_ONLINE, "SELECT name, account, map, zone FROM characters WHERE online > 0", CONNECTION_SYNCH);
432 PrepareStatement(CHAR_SEL_CHAR_DEL_INFO_BY_GUID, "SELECT guid, deleteInfos_Name, deleteInfos_Account, deleteDate FROM characters WHERE deleteDate IS NOT NULL AND guid = ?", CONNECTION_SYNCH);
433 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);
434 PrepareStatement(CHAR_SEL_CHAR_DEL_INFO, "SELECT guid, deleteInfos_Name, deleteInfos_Account, deleteDate FROM characters WHERE deleteDate IS NOT NULL", CONNECTION_SYNCH);
435 PrepareStatement(CHAR_SEL_CHARS_BY_ACCOUNT_ID, "SELECT guid FROM characters WHERE account = ?", CONNECTION_SYNCH);
436 PrepareStatement(CHAR_SEL_CHAR_PINFO, "SELECT totaltime, level, money, account, race, class, map, zone, gender, health, playerFlags FROM characters WHERE guid = ?", CONNECTION_SYNCH);
437 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);
438 //0: lowGUID
439 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);
440 //0: lowGUID
441 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);
442 PrepareStatement(CHAR_SEL_CHAR_HOMEBIND, "SELECT mapId, zoneId, posX, posY, posZ FROM character_homebind WHERE guid = ?", CONNECTION_SYNCH);
443 PrepareStatement(CHAR_SEL_CHAR_GUID_NAME_BY_ACC, "SELECT guid, name FROM characters WHERE account = ?", CONNECTION_SYNCH);
444 PrepareStatement(CHAR_SEL_POOL_QUEST_SAVE, "SELECT quest_id FROM pool_quest_save WHERE pool_id = ?", CONNECTION_SYNCH);
445 PrepareStatement(CHAR_SEL_CHARACTER_AT_LOGIN, "SELECT at_login FROM characters WHERE guid = ?", CONNECTION_SYNCH);
446 PrepareStatement(CHAR_SEL_CHAR_CLASS_LVL_AT_LOGIN, "SELECT class, level, at_login, knownTitles FROM characters WHERE guid = ?", CONNECTION_SYNCH);
447 PrepareStatement(CHAR_SEL_CHAR_AT_LOGIN_TITLES, "SELECT at_login, knownTitles FROM characters WHERE guid = ?", CONNECTION_SYNCH);
448 PrepareStatement(CHAR_SEL_INSTANCE, "SELECT data, completedEncounters FROM instance WHERE map = ? AND id = ?", CONNECTION_SYNCH);
449 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);
450 PrepareStatement(CHAR_SEL_CHAR_SOCIAL, "SELECT DISTINCT guid FROM character_social WHERE friend = ?", CONNECTION_SYNCH);
451 PrepareStatement(CHAR_SEL_CHAR_OLD_CHARS, "SELECT guid, deleteInfos_Account FROM characters WHERE deleteDate IS NOT NULL AND deleteDate < ?", CONNECTION_SYNCH);
452 PrepareStatement(CHAR_SEL_MAIL, "SELECT id, messageType, sender, receiver, subject, body, has_items, expire_time, deliver_time, money, cod, checked, stationery, mailTemplateId FROM mail WHERE receiver = ? ORDER BY id DESC", CONNECTION_SYNCH);
453 PrepareStatement(CHAR_SEL_CHAR_PLAYERBYTES2, "SELECT playerBytes2 FROM characters WHERE guid = ?", CONNECTION_SYNCH);
454 PrepareStatement(CHAR_SEL_CHAR_GUID_BY_NAME, "SELECT guid FROM characters WHERE name = ?", CONNECTION_SYNCH);
455 PrepareStatement(CHAR_DEL_CHAR_AURA_FROZEN, "DELETE FROM character_aura WHERE spell = 9454 AND guid = ?", CONNECTION_ASYNC);
456 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);
457 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);
458 PrepareStatement(CHAR_SEL_AUCTIONHOUSE_COUNT_ITEM, "SELECT COUNT(itemEntry) FROM auctionhouse ah INNER JOIN item_instance ii ON ii.guid = ah.itemguid WHERE itemEntry = ?", CONNECTION_SYNCH);
459 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);
460 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 "
461 "INNER JOIN character_inventory ci ON ci.guid = c.guid "
462 "INNER JOIN item_instance ii ON ii.guid = ci.item "
463 "LEFT JOIN character_inventory cb ON cb.item = ci.bag WHERE ii.itemEntry = ? LIMIT ?", CONNECTION_SYNCH);
464 PrepareStatement(CHAR_SEL_CHAR_INVENTORY_ITEM_GUID_UNTIL_BAG_SLOT, "SELECT item FROM character_inventory WHERE bag = ? AND slot < ? AND guid = ?", CONNECTION_SYNCH);
465 PrepareStatement(CHAR_SEL_MAIL_ITEMS_BY_ENTRY, "SELECT mi.item_guid, m.sender, m.receiver, cs.account, cs.name, cr.account, cr.name "
466 "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 "
467 "INNER JOIN characters cs ON cs.guid = m.sender INNER JOIN characters cr ON cr.guid = m.receiver WHERE ii.itemEntry = ? LIMIT ?", CONNECTION_SYNCH);
468 PrepareStatement(CHAR_SEL_AUCTIONHOUSE_ITEM_BY_ENTRY, "SELECT ah.itemguid, ah.itemowner, c.account, c.name FROM auctionhouse ah INNER JOIN characters c ON c.guid = ah.itemowner INNER JOIN item_instance ii ON ii.guid = ah.itemguid WHERE ii.itemEntry = ? LIMIT ?", CONNECTION_SYNCH);
469 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);
470 PrepareStatement(CHAR_DEL_CHAR_ACHIEVEMENT, "DELETE FROM character_achievement WHERE guid = ?", CONNECTION_ASYNC);
471 PrepareStatement(CHAR_DEL_CHAR_ACHIEVEMENT_PROGRESS, "DELETE FROM character_achievement_progress WHERE guid = ?", CONNECTION_ASYNC);
472 PrepareStatement(CHAR_INS_CHAR_ACHIEVEMENT, "INSERT INTO character_achievement (guid, achievement, date) VALUES (?, ?, ?)", CONNECTION_ASYNC);
473 PrepareStatement(CHAR_DEL_CHAR_ACHIEVEMENT_PROGRESS_BY_CRITERIA, "DELETE FROM character_achievement_progress WHERE guid = ? AND criteria = ?", CONNECTION_ASYNC);
474 PrepareStatement(CHAR_INS_CHAR_ACHIEVEMENT_PROGRESS, "INSERT INTO character_achievement_progress (guid, criteria, counter, date) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
475 PrepareStatement(CHAR_DEL_CHAR_REPUTATION_BY_FACTION, "DELETE FROM character_reputation WHERE guid = ? AND faction = ?", CONNECTION_ASYNC);
476 PrepareStatement(CHAR_INS_CHAR_REPUTATION_BY_FACTION, "INSERT INTO character_reputation (guid, faction, standing, flags) VALUES (?, ?, ? , ?)", CONNECTION_ASYNC);
477 PrepareStatement(CHAR_DEL_ITEM_REFUND_INSTANCE, "DELETE FROM item_refund_instance WHERE item_guid = ?", CONNECTION_ASYNC);
478 PrepareStatement(CHAR_INS_ITEM_REFUND_INSTANCE, "INSERT INTO item_refund_instance (item_guid, player_guid, paidMoney, paidExtendedCost) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
479 PrepareStatement(CHAR_DEL_GROUP, "DELETE FROM parties WHERE guid = ?", CONNECTION_ASYNC);
480 PrepareStatement(CHAR_DEL_GROUP_MEMBER_ALL, "DELETE FROM party_member WHERE guid = ?", CONNECTION_ASYNC);
481 PrepareStatement(CHAR_INS_CHAR_GIFT, "INSERT INTO character_gifts (guid, item_guid, entry, flags) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
482 PrepareStatement(CHAR_DEL_INSTANCE_BY_INSTANCE, "DELETE FROM instance WHERE id = ?", CONNECTION_ASYNC);
483 PrepareStatement(CHAR_DEL_CHAR_INSTANCE_BY_INSTANCE, "DELETE FROM character_instance WHERE instance = ?", CONNECTION_ASYNC);
484 PrepareStatement(CHAR_DEL_CHAR_INSTANCE_BY_MAP_DIFF, "DELETE FROM character_instance USING character_instance LEFT JOIN instance ON character_instance.instance = id WHERE map = ? and difficulty = ?", CONNECTION_ASYNC);
485 PrepareStatement(CHAR_DEL_GROUP_INSTANCE_BY_MAP_DIFF, "DELETE FROM party_instance USING party_instance LEFT JOIN instance ON party_instance.instance = id WHERE map = ? and difficulty = ?", CONNECTION_ASYNC);
486 PrepareStatement(CHAR_DEL_INSTANCE_BY_MAP_DIFF, "DELETE FROM instance WHERE map = ? and difficulty = ?", CONNECTION_ASYNC);
487 PrepareStatement(CHAR_DEL_MAIL_ITEM_BY_ID, "DELETE FROM mail_items WHERE mail_id = ?", CONNECTION_ASYNC);
488 PrepareStatement(CHAR_INS_PETITION, "INSERT INTO petition (ownerguid, petitionguid, name, type) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
489 PrepareStatement(CHAR_DEL_PETITION_BY_GUID, "DELETE FROM petition WHERE petitionguid = ?", CONNECTION_ASYNC);
490 PrepareStatement(CHAR_DEL_PETITION_SIGNATURE_BY_GUID, "DELETE FROM petition_sign WHERE petitionguid = ?", CONNECTION_ASYNC);
491 PrepareStatement(CHAR_DEL_CHAR_DECLINED_NAME, "DELETE FROM character_declinedname WHERE guid = ?", CONNECTION_ASYNC);
492 PrepareStatement(CHAR_INS_CHAR_DECLINED_NAME, "INSERT INTO character_declinedname (guid, genitive, dative, accusative, instrumental, prepositional) VALUES (?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
493 PrepareStatement(CHAR_UPD_FACTION_OR_RACE, "UPDATE characters SET name = ?, race = ?, at_login = at_login & ~ ? WHERE guid = ?", CONNECTION_ASYNC);
494 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);
495 PrepareStatement(CHAR_INS_CHAR_SKILL_LANGUAGE, "INSERT INTO `character_skills` (guid, skill, value, max) VALUES (?, ?, 300, 300)", CONNECTION_ASYNC);
496 PrepareStatement(CHAR_UPD_CHAR_TAXI_PATH, "UPDATE characters SET taxi_path = '' WHERE guid = ?", CONNECTION_ASYNC);
497 PrepareStatement(CHAR_UPD_CHAR_TAXIMASK, "UPDATE characters SET taximask = ? WHERE guid = ?", CONNECTION_ASYNC);
498 PrepareStatement(CHAR_DEL_CHAR_QUESTSTATUS, "DELETE FROM character_queststatus WHERE guid = ?", CONNECTION_ASYNC);
499 PrepareStatement(CHAR_DEL_CHAR_SOCIAL_BY_GUID, "DELETE FROM character_social WHERE guid = ?", CONNECTION_ASYNC);
500 PrepareStatement(CHAR_DEL_CHAR_SOCIAL_BY_FRIEND, "DELETE FROM character_social WHERE friend = ?", CONNECTION_ASYNC);
501 PrepareStatement(CHAR_DEL_CHAR_ACHIEVEMENT_BY_ACHIEVEMENT, "DELETE FROM character_achievement WHERE achievement = ? AND guid = ?", CONNECTION_ASYNC);
502 PrepareStatement(CHAR_UPD_CHAR_ACHIEVEMENT, "UPDATE character_achievement SET achievement = ? where achievement = ? AND guid = ?", CONNECTION_ASYNC);
503 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);
504 PrepareStatement(CHAR_DEL_CHAR_SPELL_BY_SPELL, "DELETE FROM character_spell WHERE spell = ? AND guid = ?", CONNECTION_ASYNC);
505 PrepareStatement(CHAR_UPD_CHAR_SPELL_FACTION_CHANGE, "UPDATE character_spell SET spell = ? where spell = ? AND guid = ?", CONNECTION_ASYNC);
506 PrepareStatement(CHAR_SEL_CHAR_REP_BY_FACTION, "SELECT standing FROM character_reputation WHERE faction = ? AND guid = ?", CONNECTION_SYNCH);
507 PrepareStatement(CHAR_DEL_CHAR_REP_BY_FACTION, "DELETE FROM character_reputation WHERE faction = ? AND guid = ?", CONNECTION_ASYNC);
508 PrepareStatement(CHAR_UPD_CHAR_REP_FACTION_CHANGE, "UPDATE character_reputation SET faction = ?, standing = ? WHERE faction = ? AND guid = ?", CONNECTION_ASYNC);
509 PrepareStatement(CHAR_UPD_CHAR_TITLES_FACTION_CHANGE, "UPDATE characters SET knownTitles = ? WHERE guid = ?", CONNECTION_ASYNC);
510 PrepareStatement(CHAR_RES_CHAR_TITLES_FACTION_CHANGE, "UPDATE characters SET chosenTitle = 0 WHERE guid = ?", CONNECTION_ASYNC);
511 PrepareStatement(CHAR_DEL_CHAR_SPELL_COOLDOWN, "DELETE FROM character_spell_cooldown WHERE guid = ?", CONNECTION_ASYNC);
512 PrepareStatement(CHAR_DEL_CHARACTER, "DELETE FROM characters WHERE guid = ?", CONNECTION_ASYNC);
513 PrepareStatement(CHAR_DEL_CHAR_ACTION, "DELETE FROM character_action WHERE guid = ?", CONNECTION_ASYNC);
514 PrepareStatement(CHAR_DEL_CHAR_AURA, "DELETE FROM character_aura WHERE guid = ?", CONNECTION_ASYNC);
515 PrepareStatement(CHAR_DEL_CHAR_GIFT, "DELETE FROM character_gifts WHERE guid = ?", CONNECTION_ASYNC);
516 PrepareStatement(CHAR_DEL_CHAR_INSTANCE, "DELETE FROM character_instance WHERE guid = ?", CONNECTION_ASYNC);
517 PrepareStatement(CHAR_DEL_CHAR_INVENTORY, "DELETE FROM character_inventory WHERE guid = ?", CONNECTION_ASYNC);
518 PrepareStatement(CHAR_DEL_CHAR_QUESTSTATUS_REWARDED, "DELETE FROM character_queststatus_rewarded WHERE guid = ?", CONNECTION_ASYNC);
519 PrepareStatement(CHAR_DEL_CHAR_REPUTATION, "DELETE FROM character_reputation WHERE guid = ?", CONNECTION_ASYNC);
520 PrepareStatement(CHAR_DEL_CHAR_SPELL, "DELETE FROM character_spell WHERE guid = ?", CONNECTION_ASYNC);
521 PrepareStatement(CHAR_DEL_MAIL, "DELETE FROM mail WHERE receiver = ?", CONNECTION_ASYNC);
522 PrepareStatement(CHAR_DEL_MAIL_ITEMS, "DELETE FROM mail_items WHERE receiver = ?", CONNECTION_ASYNC);
523 PrepareStatement(CHAR_DEL_CHAR_ACHIEVEMENTS, "DELETE FROM character_achievement WHERE guid = ? AND achievement NOT BETWEEN '456' AND '467' AND achievement NOT BETWEEN '1400' AND '1427' AND achievement NOT IN(1463, 3117, 3259)", CONNECTION_ASYNC);
524 PrepareStatement(CHAR_DEL_CHAR_EQUIPMENTSETS, "DELETE FROM character_equipmentsets WHERE guid = ?", CONNECTION_ASYNC);
525 PrepareStatement(CHAR_DEL_GUILD_EVENTLOG_BY_PLAYER, "DELETE FROM guild_eventlog WHERE PlayerGuid1 = ? OR PlayerGuid2 = ?", CONNECTION_ASYNC);
526 PrepareStatement(CHAR_DEL_GUILD_BANK_EVENTLOG_BY_PLAYER, "DELETE FROM guild_bank_eventlog WHERE PlayerGuid = ?", CONNECTION_ASYNC);
527 PrepareStatement(CHAR_DEL_CHAR_GLYPHS, "DELETE FROM character_glyphs WHERE guid = ?", CONNECTION_ASYNC);
528 PrepareStatement(CHAR_DEL_CHAR_QUESTSTATUS_DAILY, "DELETE FROM character_queststatus_daily WHERE guid = ?", CONNECTION_ASYNC);
529 PrepareStatement(CHAR_DEL_CHAR_TALENT, "DELETE FROM character_talent WHERE guid = ?", CONNECTION_ASYNC);
530 PrepareStatement(CHAR_SEL_CHAR_TALENT, "SELECT spell FROM character_talent WHERE guid = ?", CONNECTION_SYNCH);
531 PrepareStatement(CHAR_DEL_CHAR_SKILLS, "DELETE FROM character_skills WHERE guid = ?", CONNECTION_ASYNC);
532 PrepareStatement(CHAR_UDP_CHAR_MONEY, "UPDATE characters SET money = ? WHERE guid = ?", CONNECTION_ASYNC);
533 PrepareStatement(CHAR_INS_CHAR_ACTION, "INSERT INTO character_action (guid, spec, button, action, type) VALUES (?, ?, ?, ?, ?)", CONNECTION_ASYNC);
534 PrepareStatement(CHAR_UPD_CHAR_ACTION, "UPDATE character_action SET action = ?, type = ? WHERE guid = ? AND button = ? AND spec = ?", CONNECTION_ASYNC);
535 PrepareStatement(CHAR_DEL_CHAR_ACTION_BY_BUTTON_SPEC, "DELETE FROM character_action WHERE guid = ? and button = ? and spec = ?", CONNECTION_ASYNC);
536 PrepareStatement(CHAR_DEL_CHAR_INVENTORY_BY_ITEM, "DELETE FROM character_inventory WHERE item = ?", CONNECTION_ASYNC);
537 PrepareStatement(CHAR_DEL_CHAR_INVENTORY_BY_BAG_SLOT, "DELETE FROM character_inventory WHERE bag = ? AND slot = ? AND guid = ?", CONNECTION_ASYNC);
538 PrepareStatement(CHAR_DEL_CHAR_INVENTORY_UNTIL_BAG_SLOT, "DELETE FROM character_inventory WHERE bag = ? AND slot < ? AND guid = ?", CONNECTION_ASYNC);
539 PrepareStatement(CHAR_INS_CHAR_INVENTORY, "INSERT INTO character_inventory (guid, bag, slot, item) VALUES (?, ?, ?, ?)"
540 "ON DUPLICATE KEY UPDATE item = VALUES(item)", CONNECTION_ASYNC);
541 PrepareStatement(CHAR_UPD_MAIL, "UPDATE mail SET has_items = ?, expire_time = ?, deliver_time = ?, money = ?, cod = ?, checked = ? WHERE id = ?", CONNECTION_ASYNC);
542 PrepareStatement(CHAR_REP_CHAR_QUESTSTATUS, "REPLACE INTO character_queststatus (guid, quest, status, explored, timer) VALUES (?, ?, ?, ?, ?)", CONNECTION_ASYNC);
543 PrepareStatement(CHAR_DEL_CHAR_QUESTSTATUS_BY_QUEST, "DELETE FROM character_queststatus WHERE guid = ? AND quest = ?", CONNECTION_ASYNC);
544 PrepareStatement(CHAR_REP_CHAR_QUESTSTATUS_OBJECTIVE, "REPLACE INTO `character_queststatus_objective` (`guid`, `objectiveId`, `amount`) VALUES (?, ?, ?)", CONNECTION_ASYNC);
545 PrepareStatement(CHAR_DEL_CHAR_QUESTSTATUS_OBJECTIVE, "DELETE FROM `character_queststatus_objective` WHERE `guid` = ? AND `objectiveId` = ?", CONNECTION_ASYNC);
546 PrepareStatement(CHAR_DEL_CHAR_QUESTSTATUS_OBJECTIVE_ALL, "DELETE FROM `character_queststatus_objective` WHERE `guid` = ?", CONNECTION_ASYNC);
547 PrepareStatement(CHAR_INS_CHAR_QUESTSTATUS_REWARDED, "INSERT IGNORE INTO character_queststatus_rewarded (guid, quest, active) VALUES (?, ?, 1)", CONNECTION_ASYNC);
548 PrepareStatement(CHAR_DEL_CHAR_QUESTSTATUS_REWARDED_BY_QUEST, "DELETE FROM character_queststatus_rewarded WHERE guid = ? AND quest = ?", CONNECTION_ASYNC);
549 PrepareStatement(CHAR_UPD_CHAR_QUESTSTATUS_REWARDED_FACTION_CHANGE, "UPDATE character_queststatus_rewarded SET quest = ? WHERE quest = ? AND guid = ?", CONNECTION_ASYNC);
550 PrepareStatement(CHAR_UPD_CHAR_QUESTSTATUS_REWARDED_ACTIVE, "UPDATE character_queststatus_rewarded SET active = 1 WHERE guid = ?", CONNECTION_ASYNC);
551 PrepareStatement(CHAR_UPD_CHAR_QUESTSTATUS_REWARDED_ACTIVE_BY_QUEST, "UPDATE character_queststatus_rewarded SET active = 0 WHERE quest = ? AND guid = ?", CONNECTION_ASYNC);
552 PrepareStatement(CHAR_DEL_CHAR_SKILL_BY_SKILL, "DELETE FROM character_skills WHERE guid = ? AND skill = ?", CONNECTION_ASYNC);
553 PrepareStatement(CHAR_INS_CHAR_SKILLS, "INSERT INTO character_skills (guid, skill, value, max) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
554 PrepareStatement(CHAR_UDP_CHAR_SKILLS, "UPDATE character_skills SET value = ?, max = ? WHERE guid = ? AND skill = ?", CONNECTION_ASYNC);
555 PrepareStatement(CHAR_INS_CHAR_SPELL, "INSERT INTO character_spell (guid, spell, active, disabled) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
556 PrepareStatement(CHAR_DEL_CHAR_STATS, "DELETE FROM character_stats WHERE guid = ?", CONNECTION_ASYNC);
557 PrepareStatement(CHAR_INS_CHAR_STATS, "INSERT INTO character_stats (guid, maxhealth, maxpower1, maxpower2, maxpower3, maxpower4, maxpower5, strength, agility, stamina, intellect, spirit, "
558 "armor, resHoly, resFire, resNature, resFrost, resShadow, resArcane, blockPct, dodgePct, parryPct, critPct, rangedCritPct, offhandCritPct, spellCritPct, attackPower, rangedAttackPower, "
559 "spellPower, resilience, mastery, pvpDamage, pvpHealing) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
560 PrepareStatement(CHAR_DEL_PETITION_BY_OWNER, "DELETE FROM petition WHERE ownerguid = ?", CONNECTION_ASYNC);
561 PrepareStatement(CHAR_DEL_PETITION_SIGNATURE_BY_OWNER, "DELETE FROM petition_sign WHERE ownerguid = ?", CONNECTION_ASYNC);
562 PrepareStatement(CHAR_DEL_PETITION_BY_OWNER_AND_TYPE, "DELETE FROM petition WHERE ownerguid = ? AND type = ?", CONNECTION_ASYNC);
563 PrepareStatement(CHAR_DEL_PETITION_SIGNATURE_BY_OWNER_AND_TYPE, "DELETE FROM petition_sign WHERE ownerguid = ? AND type = ?", CONNECTION_ASYNC);
564 PrepareStatement(CHAR_INS_CHAR_GLYPHS, "INSERT INTO character_glyphs (guid, spec, glyph1, glyph2, glyph3, glyph4, glyph5, glyph6) VALUES(?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
565 PrepareStatement(CHAR_DEL_CHAR_TALENT_BY_SPELL_SPEC, "DELETE FROM character_talent WHERE guid = ? and spell = ? and spec = ?", CONNECTION_ASYNC);
566 PrepareStatement(CHAR_INS_CHAR_TALENT, "INSERT INTO character_talent (guid, spell, spec) VALUES (?, ?, ?)", CONNECTION_ASYNC);
567 PrepareStatement(CHAR_DEL_CHAR_ACTION_EXCEPT_SPEC, "DELETE FROM character_action WHERE spec<>? AND guid = ?", CONNECTION_ASYNC);
568 PrepareStatement(CHAR_UPD_CHAR_LIST_SLOT, "UPDATE characters SET slot = ? WHERE guid = ?", CONNECTION_ASYNC);
569 PrepareStatement(CHAR_UPD_GROUP_ROLE, "UPDATE party_member SET roles = ? WHERE memberGuid = ?", CONNECTION_ASYNC);
570
571 // Void Storage
572 PrepareStatement(CHAR_SEL_CHAR_VOID_STORAGE, "SELECT itemId, itemEntry, slot, creatorGuid, randomProperty, suffixFactor FROM character_void_storage WHERE playerGuid = ?", CONNECTION_ASYNC);
573 PrepareStatement(CHAR_REP_CHAR_VOID_STORAGE_ITEM, "REPLACE INTO character_void_storage (itemId, playerGuid, itemEntry, slot, creatorGuid, randomProperty, suffixFactor) VALUES (?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
574 PrepareStatement(CHAR_DEL_CHAR_VOID_STORAGE_ITEM_BY_SLOT, "DELETE FROM character_void_storage WHERE slot = ? AND playerGuid = ?", CONNECTION_ASYNC);
575
576 // CompactUnitFrame profiles
577 PrepareStatement(CHAR_SEL_CHAR_CUF_PROFILES, "SELECT id, name, frameHeight, frameWidth, sortBy, healthText, boolOptions, unk146, unk147, unk148, unk150, unk152, unk154 FROM character_cuf_profiles WHERE guid = ?", CONNECTION_ASYNC);
578 PrepareStatement(CHAR_REP_CHAR_CUF_PROFILES, "REPLACE INTO character_cuf_profiles (guid, id, name, frameHeight, frameWidth, sortBy, healthText, boolOptions, unk146, unk147, unk148, unk150, unk152, unk154) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
579 PrepareStatement(CHAR_DEL_CHAR_CUF_PROFILES, "DELETE FROM character_cuf_profiles WHERE guid = ? and id = ?", CONNECTION_ASYNC);
580
581 // Guild Finder
582 PrepareStatement(CHAR_REP_GUILD_FINDER_APPLICANT, "REPLACE INTO guild_finder_applicant (guildId, playerGuid, availability, classRole, interests, comment, submitTime) VALUES(?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
583 PrepareStatement(CHAR_DEL_GUILD_FINDER_APPLICANT, "DELETE FROM guild_finder_applicant WHERE guildId = ? AND playerGuid = ?", CONNECTION_ASYNC);
584 PrepareStatement(CHAR_REP_GUILD_FINDER_GUILD_SETTINGS, "REPLACE INTO guild_finder_guild_settings (guildId, availability, classRoles, interests, level, listed, comment) VALUES(?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
585 PrepareStatement(CHAR_DEL_GUILD_FINDER_GUILD_SETTINGS, "DELETE FROM guild_finder_guild_settings WHERE guildId = ?", CONNECTION_ASYNC);
586
587 // Items that hold loot or money
588 PrepareStatement(CHAR_SEL_ITEMCONTAINER_ITEMS, "SELECT item_id, item_count, follow_rules, ffa, blocked, counted, under_threshold, needs_quest, rnd_prop, rnd_suffix FROM item_loot_items WHERE container_id = ?", CONNECTION_SYNCH);
589 PrepareStatement(CHAR_DEL_ITEMCONTAINER_ITEMS, "DELETE FROM item_loot_items WHERE container_id = ?", CONNECTION_ASYNC);
590 PrepareStatement(CHAR_DEL_ITEMCONTAINER_ITEM, "DELETE FROM item_loot_items WHERE container_id = ? AND item_id = ?", CONNECTION_ASYNC);
591 PrepareStatement(CHAR_INS_ITEMCONTAINER_ITEMS, "INSERT INTO item_loot_items (container_id, item_id, item_count, follow_rules, ffa, blocked, counted, under_threshold, needs_quest, rnd_prop, rnd_suffix) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
592 PrepareStatement(CHAR_SEL_ITEMCONTAINER_MONEY, "SELECT money FROM item_loot_money WHERE container_id = ?", CONNECTION_SYNCH);
593 PrepareStatement(CHAR_DEL_ITEMCONTAINER_MONEY, "DELETE FROM item_loot_money WHERE container_id = ?", CONNECTION_ASYNC);
594 PrepareStatement(CHAR_INS_ITEMCONTAINER_MONEY, "INSERT INTO item_loot_money (container_id, money) VALUES (?, ?)", CONNECTION_ASYNC);
595
596 // Calendar
597 PrepareStatement(CHAR_REP_CALENDAR_EVENT, "REPLACE INTO calendar_events (id, creator, title, description, type, dungeon, eventtime, flags) VALUES (?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
598 PrepareStatement(CHAR_DEL_CALENDAR_EVENT, "DELETE FROM calendar_events WHERE id = ?", CONNECTION_ASYNC);
599 PrepareStatement(CHAR_REP_CALENDAR_INVITE, "REPLACE INTO calendar_invites (id, event, invitee, sender, status, statustime, mod_rank, text) VALUES (?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
600 PrepareStatement(CHAR_DEL_CALENDAR_INVITE, "DELETE FROM calendar_invites WHERE id = ?", CONNECTION_ASYNC);
601
602 // Pet
603 PrepareStatement(CHAR_SEL_PET_SLOTS, "SELECT owner, slot FROM character_pet WHERE owner = ? AND slot >= ? AND slot <= ? ORDER BY slot", CONNECTION_ASYNC);
604 PrepareStatement(CHAR_SEL_PET_SLOTS_DETAIL, "SELECT owner, id, entry, level, name FROM character_pet WHERE owner = ? AND slot >= ? AND slot <= ? ORDER BY slot", CONNECTION_ASYNC);
605 PrepareStatement(CHAR_SEL_PET_ENTRY, "SELECT entry FROM character_pet WHERE owner = ? AND id = ? AND slot >= ? AND slot <= ?", CONNECTION_ASYNC);
606 PrepareStatement(CHAR_SEL_PET_SLOT_BY_ID, "SELECT slot, entry FROM character_pet WHERE owner = ? AND id = ?", CONNECTION_ASYNC);
607 PrepareStatement(CHAR_SEL_PET_SPELL_LIST, "SELECT DISTINCT pet_spell.spell FROM pet_spell, character_pet WHERE character_pet.owner = ? AND character_pet.id = pet_spell.guid AND character_pet.id <> ?", CONNECTION_SYNCH);
608 PrepareStatement(CHAR_SEL_CHAR_PET, "SELECT id FROM character_pet WHERE owner = ? AND id <> ?", CONNECTION_SYNCH);
609 PrepareStatement(CHAR_SEL_CHAR_PETS, "SELECT id FROM character_pet WHERE owner = ?", CONNECTION_SYNCH);
610 PrepareStatement(CHAR_SEL_CHAR_ACTIVE_PET, "SELECT id, entry, owner, modelid, level, exp, Reactstate, slot, name, renamed, curhealth, curmana, abdata, savetime, CreatedBySpell, PetType, PetSpecId, active FROM character_pet WHERE owner = ? AND (active = 1 OR slot = 0) ORDER BY active DESC, slot ASC LIMIT 1", CONNECTION_SYNCH);
611 PrepareStatement(CHAR_DEL_CHAR_PET_DECLINEDNAME_BY_OWNER, "DELETE FROM character_pet_declinedname WHERE owner = ?", CONNECTION_ASYNC);
612 PrepareStatement(CHAR_DEL_CHAR_PET_DECLINEDNAME, "DELETE FROM character_pet_declinedname WHERE id = ?", CONNECTION_ASYNC);
613 PrepareStatement(CHAR_ADD_CHAR_PET_DECLINEDNAME, "INSERT INTO character_pet_declinedname (id, owner, genitive, dative, accusative, instrumental, prepositional) VALUES (?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
614 PrepareStatement(CHAR_SEL_PET_AURA, "SELECT caster_guid, spell, effect_mask, recalculate_mask, stackcount, amount0, amount1, amount2, base_amount0, base_amount1, base_amount2, maxduration, remaintime, remaincharges FROM pet_aura WHERE guid = ?", CONNECTION_SYNCH);
615 PrepareStatement(CHAR_SEL_PET_SPELL, "SELECT spell, active FROM pet_spell WHERE guid = ?", CONNECTION_SYNCH);
616 PrepareStatement(CHAR_SEL_PET_SPELL_COOLDOWN, "SELECT spell, time FROM pet_spell_cooldown WHERE guid = ?", CONNECTION_SYNCH);
617 PrepareStatement(CHAR_SEL_PET_DECLINED_NAME, "SELECT genitive, dative, accusative, instrumental, prepositional FROM character_pet_declinedname WHERE owner = ? AND id = ?", CONNECTION_SYNCH);
618 PrepareStatement(CHAR_DEL_PET_AURAS, "DELETE FROM pet_aura WHERE guid = ?", CONNECTION_BOTH);
619 PrepareStatement(CHAR_DEL_PET_SPELLS, "DELETE FROM pet_spell WHERE guid = ?", CONNECTION_ASYNC);
620 PrepareStatement(CHAR_DEL_PET_SPELL_COOLDOWNS, "DELETE FROM pet_spell_cooldown WHERE guid = ?", CONNECTION_BOTH);
621 PrepareStatement(CHAR_INS_PET_SPELL_COOLDOWN, "INSERT INTO pet_spell_cooldown (guid, spell, time) VALUES (?, ?, ?)", CONNECTION_BOTH);
622 PrepareStatement(CHAR_DEL_PET_SPELL_BY_SPELL, "DELETE FROM pet_spell WHERE guid = ? and spell = ?", CONNECTION_ASYNC);
623 PrepareStatement(CHAR_INS_PET_SPELL, "INSERT INTO pet_spell (guid, spell, active) VALUES (?, ?, ?)", CONNECTION_BOTH);
624 PrepareStatement(CHAR_INS_PET_AURA, "INSERT INTO pet_aura (guid, caster_guid, spell, effect_mask, recalculate_mask, stackcount, amount0, amount1, amount2, "
625 "base_amount0, base_amount1, base_amount2, maxduration, remaintime, remaincharges) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_BOTH);
626 PrepareStatement(CHAR_SEL_CHAR_PET_BY_ENTRY, "SELECT id, entry, owner, modelid, level, exp, Reactstate, slot, name, renamed, curhealth, curmana, abdata, savetime, CreatedBySpell, PetType, PetSpecId, active FROM character_pet WHERE owner = ? AND id = ?", CONNECTION_SYNCH);
627 PrepareStatement(CHAR_SEL_CHAR_PET_BY_ENTRY_AND_SLOT_2, "SELECT id, entry, owner, modelid, level, exp, Reactstate, slot, name, renamed, curhealth, curmana, abdata, savetime, CreatedBySpell, PetType, PetSpecId, active FROM character_pet WHERE owner = ? AND entry = ? AND (active = 1 OR slot > ?)", CONNECTION_SYNCH);
628 PrepareStatement(CHAR_SEL_CHAR_PET_BY_SLOT, "SELECT id, entry, owner, modelid, level, exp, Reactstate, slot, name, renamed, curhealth, curmana, abdata, savetime, CreatedBySpell, PetType, PetSpecId, active FROM character_pet WHERE owner = ? AND (active = 1 OR slot > ?) ", CONNECTION_SYNCH);
629 PrepareStatement(CHAR_SEL_CHAR_PET_BY_ENTRY_AND_SLOT, "SELECT id, entry, owner, modelid, level, exp, Reactstate, slot, name, renamed, curhealth, curmana, abdata, savetime, CreatedBySpell, PetType, PetSpecId, active FROM character_pet WHERE owner = ? AND slot = ?", CONNECTION_SYNCH);
630 PrepareStatement(CHAR_DEL_CHAR_PET_BY_OWNER, "DELETE FROM character_pet WHERE owner = ?", CONNECTION_ASYNC);
631 PrepareStatement(CHAR_UPD_CHAR_PET_NAME, "UPDATE character_pet SET name = ?, renamed = 1 WHERE owner = ? AND id = ?", CONNECTION_ASYNC);
632 PrepareStatement(CHAR_UDP_CHAR_PET_SLOT_BY_SLOT_EXCLUDE_ID, "UPDATE character_pet SET slot = ? WHERE owner = ? AND slot = ? AND id <> ?", CONNECTION_ASYNC);
633 PrepareStatement(CHAR_UDP_CHAR_PET_SLOT_BY_SLOT, "UPDATE character_pet SET slot = ? WHERE owner = ? AND slot = ?", CONNECTION_ASYNC);
634 PrepareStatement(CHAR_UPD_CHAR_PET_SLOT_BY_ID, "UPDATE character_pet SET slot = ? WHERE owner = ? AND id = ?", CONNECTION_ASYNC);
635 PrepareStatement(CHAR_UPD_CHAR_PET_ACTIVE_BY_OWNER, "UPDATE character_pet SET active = 0 WHERE owner = ?", CONNECTION_ASYNC);
636 PrepareStatement(CHAR_UPD_CHAR_PET_ACTIVE_BY_ID, "UPDATE character_pet SET active = 1 WHERE owner = ? AND id = ?", CONNECTION_ASYNC);
637 PrepareStatement(CHAR_DEL_CHAR_PET_BY_ID, "DELETE FROM character_pet WHERE id = ?", CONNECTION_ASYNC);
638 PrepareStatement(CHAR_DEL_CHAR_PET_BY_SLOT, "DELETE FROM character_pet WHERE owner = ? AND (slot = ? OR slot > ?)", CONNECTION_ASYNC);
639
640 // Archaeology
641 PrepareStatement(CHAR_SEL_CHAR_RESEARCH_DIGSITES, "SELECT digsiteId, currentFindGUID, remainingFindCount FROM character_research_digsites WHERE guid = ?", CONNECTION_ASYNC);
642 PrepareStatement(CHAR_INS_CHAR_RESEARCH_DIGSITE, "INSERT INTO character_research_digsites (guid, digsiteId, currentFindGUID, remainingFindCount) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
643 PrepareStatement(CHAR_DEL_CHAR_RESEARCH_DIGSITE, "DELETE FROM character_research_digsites WHERE guid = ? AND digsiteId = ?", CONNECTION_ASYNC);
644 PrepareStatement(CHAR_SEL_CHAR_RESEARCH_HISTORY, "SELECT projectId, researchCount, firstResearchTimestamp FROM character_research_history WHERE guid = ?", CONNECTION_ASYNC);
645 PrepareStatement(CHAR_INS_CHAR_RESEARCH_HISTORY, "INSERT INTO character_research_history (guid, projectId, researchCount, firstResearchTimestamp) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
646 PrepareStatement(CHAR_DEL_CHAR_RESEARCH_HISTORY, "DELETE FROM character_research_history WHERE guid = ?", CONNECTION_ASYNC);
647 PrepareStatement(CHAR_SEL_CHAR_RESEARCH_PROJECTS, "SELECT projectId FROM character_research_projects WHERE guid = ?", CONNECTION_ASYNC);
648 PrepareStatement(CHAR_INS_CHAR_RESEARCH_PROJECT, "INSERT INTO character_research_projects (guid, projectId) VALUES (?, ?)", CONNECTION_ASYNC);
649 PrepareStatement(CHAR_DEL_CHAR_RESEARCH_PROJECTS, "DELETE FROM character_research_projects WHERE guid = ?", CONNECTION_ASYNC);
650
651 // battle Pet
652 PrepareStatement(CHAR_SEL_ACCOUNT_BATTLE_PETS, "SELECT id, species, nickname, timestamp, level, xp, health, maxHealth, power, speed, quality, breed, flags FROM account_battle_pet WHERE accountId = ?", CONNECTION_ASYNC);
653 PrepareStatement(CHAR_DEL_ACCOUNT_BATTLE_PET, "DELETE FROM account_battle_pet WHERE id = ?", CONNECTION_ASYNC);
654 PrepareStatement(CHAR_INS_ACCOUNT_BATTLE_PET, "INSERT INTO account_battle_pet (id, accountId, species, nickname, timestamp, level, xp, health, maxHealth, power, speed, quality, breed, flags) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
655 PrepareStatement(CHAR_SEL_ACCOUNT_BATTLE_PET_SLOTS, "SELECT slot1, slot2, slot3, flags FROM account_battle_pet_slots WHERE accountId = ?", CONNECTION_ASYNC);
656 PrepareStatement(CHAR_DEL_ACCOUNT_BATTLE_PET_SLOTS, "DELETE FROM account_battle_pet_slots WHERE accountId = ?", CONNECTION_ASYNC);
657 PrepareStatement(CHAR_INS_ACCOUNT_BATTLE_PET_SLOTS, "INSERT INTO account_battle_pet_slots (accountId, slot1, slot2, slot3, flags) VALUES (?, ?, ?, ?, ?)", CONNECTION_ASYNC);
658
659 // blackmarket
660 PrepareStatement(CHAR_SEL_BLACKMARKET_AUCTIONS, "SELECT auctionId, templateId, startTime, currentBidder, currentBid, minIncrement, numBids FROM blackmarket_auctions", CONNECTION_SYNCH);
661 PrepareStatement(CHAR_DEL_BLACKMARKET_AUCTION, "DELETE FROM blackmarket_auctions WHERE auctionId = ?", CONNECTION_ASYNC);
662 PrepareStatement(CHAR_INS_BLACKMARKET_AUCTION, "INSERT INTO blackmarket_auctions (auctionId, templateId, startTime, currentBidder, currentBid, minIncrement, numBids) VALUES (?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
663 PrepareStatement(CHAR_UPD_BLACKMARKET_AUCTION, "UPDATE blackmarket_auctions SET currentBidder = ?, currentBid = ?, minIncrement = ?, numBids = ? WHERE auctionId = ?", CONNECTION_ASYNC);
664}
665
CHAR_SEL_CHARACTER_ACTIONS
@ CHAR_SEL_CHARACTER_ACTIONS
Definition CharacterDatabase.h:90
CHAR_SEL_CHARACTER_DAILYQUESTSTATUS
@ CHAR_SEL_CHARACTER_DAILYQUESTSTATUS
Definition CharacterDatabase.h:80
CHAR_INS_TUTORIALS
@ CHAR_INS_TUTORIALS
Definition CharacterDatabase.h:239
CHAR_UPD_CHARACTER_BOOST
@ CHAR_UPD_CHARACTER_BOOST
Definition CharacterDatabase.h:315
CHAR_DEL_CHAR_GLYPHS
@ CHAR_DEL_CHAR_GLYPHS
Definition CharacterDatabase.h:461
CHAR_DEL_ALL_GM_SUGGESTS
@ CHAR_DEL_ALL_GM_SUGGESTS
Definition CharacterDatabase.h:303
CHAR_DEL_QUEST_STATUS_DAILY_CHAR
@ CHAR_DEL_QUEST_STATUS_DAILY_CHAR
Definition CharacterDatabase.h:66
CHAR_DEL_CHAR_SOCIAL_BY_FRIEND
@ CHAR_DEL_CHAR_SOCIAL_BY_FRIEND
Definition CharacterDatabase.h:434
CHAR_SEL_PINFO_XP
@ CHAR_SEL_PINFO_XP
Definition CharacterDatabase.h:378
CHAR_UPD_TUTORIALS
@ CHAR_UPD_TUTORIALS
Definition CharacterDatabase.h:240
CHAR_SEL_CHANNEL
@ CHAR_SEL_CHANNEL
Definition CharacterDatabase.h:213
CHAR_UPD_ITEM_INSTANCE
@ CHAR_UPD_ITEM_INSTANCE
Definition CharacterDatabase.h:137
CHAR_DEL_BLACKMARKET_AUCTION
@ CHAR_DEL_BLACKMARKET_AUCTION
Definition CharacterDatabase.h:585
CHAR_INS_GUILD_MEMBER
@ CHAR_INS_GUILD_MEMBER
Definition CharacterDatabase.h:163
CHAR_DEL_CHAR_GIFT
@ CHAR_DEL_CHAR_GIFT
Definition CharacterDatabase.h:449
CHAR_DEL_CHAR_PET_DECLINEDNAME_BY_OWNER
@ CHAR_DEL_CHAR_PET_DECLINEDNAME_BY_OWNER
Definition CharacterDatabase.h:532
CHAR_UPD_ITEM_INSTANCE_ON_LOAD
@ CHAR_UPD_ITEM_INSTANCE_ON_LOAD
Definition CharacterDatabase.h:138
CHAR_REP_GUILD_FINDER_APPLICANT
@ CHAR_REP_GUILD_FINDER_APPLICANT
Definition CharacterDatabase.h:509
CHAR_SEL_CHAR_OLD_CHARS
@ CHAR_SEL_CHAR_OLD_CHARS
Definition CharacterDatabase.h:390
CHAR_UPD_CHAR_INVENTORY_FACTION_CHANGE
@ CHAR_UPD_CHAR_INVENTORY_FACTION_CHANGE
Definition CharacterDatabase.h:437
CHAR_INS_GM_SURVEY
@ CHAR_INS_GM_SURVEY
Definition CharacterDatabase.h:307
CHAR_SEL_CHECK_NAME
@ CHAR_SEL_CHECK_NAME
Definition CharacterDatabase.h:38
CHAR_DEL_GUILD_BANK_EVENTLOG_BY_PLAYER
@ CHAR_DEL_GUILD_BANK_EVENTLOG_BY_PLAYER
Definition CharacterDatabase.h:460
CHAR_UPD_MAIL
@ CHAR_UPD_MAIL
Definition CharacterDatabase.h:473
CHAR_SEL_CHARACTER_AT_LOGIN
@ CHAR_SEL_CHARACTER_AT_LOGIN
Definition CharacterDatabase.h:384
CHAR_UPD_CHANNEL
@ CHAR_UPD_CHANNEL
Definition CharacterDatabase.h:215
CHAR_INS_PETITION_SIGNATURE
@ CHAR_INS_PETITION_SIGNATURE
Definition CharacterDatabase.h:322
CHAR_SEL_CHAR_INVENTORY_ITEM_BY_ENTRY
@ CHAR_SEL_CHAR_INVENTORY_ITEM_BY_ENTRY
Definition CharacterDatabase.h:399
CHAR_UPD_GUILD_MOTD
@ CHAR_UPD_GUILD_MOTD
Definition CharacterDatabase.h:187
CHAR_REP_CALENDAR_EVENT
@ CHAR_REP_CALENDAR_EVENT
Definition CharacterDatabase.h:514
CHAR_SEL_GUID_RACE_ACC_BY_NAME
@ CHAR_SEL_GUID_RACE_ACC_BY_NAME
Definition CharacterDatabase.h:55
CHAR_DEL_GUILD_BANK_TABS
@ CHAR_DEL_GUILD_BANK_TABS
Definition CharacterDatabase.h:171
CHAR_DEL_GROUP_INSTANCE_PERM_BINDING
@ CHAR_DEL_GROUP_INSTANCE_PERM_BINDING
Definition CharacterDatabase.h:327
CHAR_UPD_CHAR_ONLINE
@ CHAR_UPD_CHAR_ONLINE
Definition CharacterDatabase.h:350
CHAR_REP_CHAR_VOID_STORAGE_ITEM
@ CHAR_REP_CHAR_VOID_STORAGE_ITEM
Definition CharacterDatabase.h:502
CHAR_SEL_CHAR_GUID_NAME_BY_ACC
@ CHAR_SEL_CHAR_GUID_NAME_BY_ACC
Definition CharacterDatabase.h:382
CHAR_DEL_CHAR_QUESTSTATUS_REWARDED_BY_QUEST
@ CHAR_DEL_CHAR_QUESTSTATUS_REWARDED_BY_QUEST
Definition CharacterDatabase.h:480
CHAR_INS_CHAR_SPELL
@ CHAR_INS_CHAR_SPELL
Definition CharacterDatabase.h:487
CHAR_DEL_PETITION_BY_GUID
@ CHAR_DEL_PETITION_BY_GUID
Definition CharacterDatabase.h:423
CHAR_SEL_CHARACTER
@ CHAR_SEL_CHARACTER
Definition CharacterDatabase.h:73
CHAR_SEL_CHAR_PET_BY_ENTRY_AND_SLOT
@ CHAR_SEL_CHAR_PET_BY_ENTRY_AND_SLOT
Definition CharacterDatabase.h:533
CHAR_INS_GUILD_ACHIEVEMENT_CRITERIA
@ CHAR_INS_GUILD_ACHIEVEMENT_CRITERIA
Definition CharacterDatabase.h:204
CHAR_UPD_ITEM_OWNER
@ CHAR_UPD_ITEM_OWNER
Definition CharacterDatabase.h:130
CHAR_UPD_GUILD_BANK_TAB_TEXT
@ CHAR_UPD_GUILD_BANK_TAB_TEXT
Definition CharacterDatabase.h:197
CHAR_SEL_CHAR_HOMEBIND
@ CHAR_SEL_CHAR_HOMEBIND
Definition CharacterDatabase.h:381
CHAR_INS_CHARACTER_SEASONALQUESTSTATUS
@ CHAR_INS_CHARACTER_SEASONALQUESTSTATUS
Definition CharacterDatabase.h:87
CHAR_SEL_MAIL_LIST_COUNT
@ CHAR_SEL_MAIL_LIST_COUNT
Definition CharacterDatabase.h:49
CHAR_UPD_GLOBAL_INSTANCE_RESETTIME
@ CHAR_UPD_GLOBAL_INSTANCE_RESETTIME
Definition CharacterDatabase.h:349
CHAR_DEL_GAME_EVENT_SAVE
@ CHAR_DEL_GAME_EVENT_SAVE
Definition CharacterDatabase.h:246
CHAR_SEL_PET_AURA
@ CHAR_SEL_PET_AURA
Definition CharacterDatabase.h:519
CHAR_INS_GUILD_NEWS
@ CHAR_INS_GUILD_NEWS
Definition CharacterDatabase.h:211
CHAR_SEL_PLAYER_CURRENCY
@ CHAR_SEL_PLAYER_CURRENCY
Definition CharacterDatabase.h:226
CHAR_DEL_EMPTY_EXPIRED_MAIL
@ CHAR_DEL_EMPTY_EXPIRED_MAIL
Definition CharacterDatabase.h:125
CHAR_DEL_GUILD
@ CHAR_DEL_GUILD
Definition CharacterDatabase.h:161
CHAR_UPD_REM_AT_LOGIN_FLAG
@ CHAR_UPD_REM_AT_LOGIN_FLAG
Definition CharacterDatabase.h:318
CHAR_SEL_CHAR_PLAYERBYTES2
@ CHAR_SEL_CHAR_PLAYERBYTES2
Definition CharacterDatabase.h:392
CHAR_DEL_GUILD_BANK_RIGHTS
@ CHAR_DEL_GUILD_BANK_RIGHTS
Definition CharacterDatabase.h:176
CHAR_SEL_CHARACTER_QUESTSTATUSREW
@ CHAR_SEL_CHARACTER_QUESTSTATUSREW
Definition CharacterDatabase.h:111
CHAR_DEL_ITEM_INSTANCE_TRANSMOG
@ CHAR_DEL_ITEM_INSTANCE_TRANSMOG
Definition CharacterDatabase.h:142
CHAR_SEL_PLAYER_ACCOUNT_DATA
@ CHAR_SEL_PLAYER_ACCOUNT_DATA
Definition CharacterDatabase.h:233
CHAR_UPD_GUILD_BANK_EVENTLOG_TAB
@ CHAR_UPD_GUILD_BANK_EVENTLOG_TAB
Definition CharacterDatabase.h:195
CHAR_UPD_CHAR_QUESTSTATUS_REWARDED_FACTION_CHANGE
@ CHAR_UPD_CHAR_QUESTSTATUS_REWARDED_FACTION_CHANGE
Definition CharacterDatabase.h:481
CHAR_SEL_AUCTION_ITEMS
@ CHAR_SEL_AUCTION_ITEMS
Definition CharacterDatabase.h:114
CHAR_UPD_LEVEL
@ CHAR_UPD_LEVEL
Definition CharacterDatabase.h:339
CHAR_DEL_GUILD_EVENTLOG_BY_PLAYER
@ CHAR_DEL_GUILD_EVENTLOG_BY_PLAYER
Definition CharacterDatabase.h:459
CHAR_UPD_CHAR_PET_ACTIVE_BY_ID
@ CHAR_UPD_CHAR_PET_ACTIVE_BY_ID
Definition CharacterDatabase.h:552
CHAR_INS_GROUP_MEMBER
@ CHAR_INS_GROUP_MEMBER
Definition CharacterDatabase.h:325
CHAR_DEL_ALL_GM_BUGS
@ CHAR_DEL_ALL_GM_BUGS
Definition CharacterDatabase.h:298
CHAR_DEL_DECLINED_NAME
@ CHAR_DEL_DECLINED_NAME
Definition CharacterDatabase.h:157
CHAR_DEL_ITEM_INSTANCE
@ CHAR_DEL_ITEM_INSTANCE
Definition CharacterDatabase.h:139
CHAR_UPD_EQUIP_SET
@ CHAR_UPD_EQUIP_SET
Definition CharacterDatabase.h:220
CHAR_SEL_PET_ENTRY
@ CHAR_SEL_PET_ENTRY
Definition CharacterDatabase.h:536
CHAR_INS_CHARACTER_BAN
@ CHAR_INS_CHARACTER_BAN
Definition CharacterDatabase.h:42
CHAR_DEL_CHAR_AURA_FROZEN
@ CHAR_DEL_CHAR_AURA_FROZEN
Definition CharacterDatabase.h:394
CHAR_DEL_CHAR_SKILL_LANGUAGES
@ CHAR_DEL_CHAR_SKILL_LANGUAGES
Definition CharacterDatabase.h:428
CHAR_DEL_CHAR_SKILLS
@ CHAR_DEL_CHAR_SKILLS
Definition CharacterDatabase.h:464
CHAR_SEL_CHARACTER_AURAS
@ CHAR_SEL_CHARACTER_AURAS
Definition CharacterDatabase.h:76
CHAR_DEL_CALENDAR_INVITE
@ CHAR_DEL_CALENDAR_INVITE
Definition CharacterDatabase.h:517
CHAR_SEL_CHAR_ACTIVE_PET
@ CHAR_SEL_CHAR_ACTIVE_PET
Definition CharacterDatabase.h:541
CHAR_DEL_ITEMCONTAINER_MONEY
@ CHAR_DEL_ITEMCONTAINER_MONEY
Definition CharacterDatabase.h:561
CHAR_DEL_CHAR_PET_BY_OWNER
@ CHAR_DEL_CHAR_PET_BY_OWNER
Definition CharacterDatabase.h:531
CHAR_SEL_MAX_CREATURE_RESPAWNS
@ CHAR_SEL_MAX_CREATURE_RESPAWNS
Definition CharacterDatabase.h:284
CHAR_DEL_CHARACTER_BAN
@ CHAR_DEL_CHARACTER_BAN
Definition CharacterDatabase.h:44
CHAR_DEL_TUTORIALS
@ CHAR_DEL_TUTORIALS
Definition CharacterDatabase.h:241
CHAR_INS_CHAR_INVENTORY
@ CHAR_INS_CHAR_INVENTORY
Definition CharacterDatabase.h:472
CHAR_SEL_CHAR_PETS
@ CHAR_SEL_CHAR_PETS
Definition CharacterDatabase.h:540
CHAR_DEL_QUEST_STATUS_WEEKLY_CHAR
@ CHAR_DEL_QUEST_STATUS_WEEKLY_CHAR
Definition CharacterDatabase.h:67
CHAR_SEL_CHAR_INVENTORY_ITEM_GUID_UNTIL_BAG_SLOT
@ CHAR_SEL_CHAR_INVENTORY_ITEM_GUID_UNTIL_BAG_SLOT
Definition CharacterDatabase.h:400
CHAR_UPD_GUILD_RANK_NAME
@ CHAR_UPD_GUILD_RANK_NAME
Definition CharacterDatabase.h:190
CHAR_INS_CHAR_TALENT
@ CHAR_INS_CHAR_TALENT
Definition CharacterDatabase.h:496
CHAR_DEL_CHAR_PET_BY_SLOT
@ CHAR_DEL_CHAR_PET_BY_SLOT
Definition CharacterDatabase.h:554
CHAR_DEL_CHAR_STATS
@ CHAR_DEL_CHAR_STATS
Definition CharacterDatabase.h:488
CHAR_SEL_GUID_BY_NAME
@ CHAR_SEL_GUID_BY_NAME
Definition CharacterDatabase.h:37
CHAR_DEL_ALL_GUILD_ACHIEVEMENTS
@ CHAR_DEL_ALL_GUILD_ACHIEVEMENTS
Definition CharacterDatabase.h:205
CHAR_UDP_CHAR_PET_SLOT_BY_SLOT
@ CHAR_UDP_CHAR_PET_SLOT_BY_SLOT
Definition CharacterDatabase.h:549
CHAR_DEL_ITEM_INSTANCE_BY_OWNER
@ CHAR_DEL_ITEM_INSTANCE_BY_OWNER
Definition CharacterDatabase.h:140
CHAR_SEL_ACCOUNT_INSTANCELOCKTIMES
@ CHAR_SEL_ACCOUNT_INSTANCELOCKTIMES
Definition CharacterDatabase.h:112
CHAR_DEL_CHAR_INVENTORY_BY_ITEM
@ CHAR_DEL_CHAR_INVENTORY_BY_ITEM
Definition CharacterDatabase.h:469
CHAR_DEL_GROUP_MEMBER_ALL
@ CHAR_DEL_GROUP_MEMBER_ALL
Definition CharacterDatabase.h:414
CHAR_UPD_GUILD_NAME
@ CHAR_UPD_GUILD_NAME
Definition CharacterDatabase.h:162
CHAR_INS_CHAR_SKILLS
@ CHAR_INS_CHAR_SKILLS
Definition CharacterDatabase.h:485
CHAR_DEL_CREATURE_RESPAWN_BY_INSTANCE
@ CHAR_DEL_CREATURE_RESPAWN_BY_INSTANCE
Definition CharacterDatabase.h:283
CHAR_DEL_CHAR_CUF_PROFILES
@ CHAR_DEL_CHAR_CUF_PROFILES
Definition CharacterDatabase.h:507
CHAR_INS_GUILD_EVENTLOG
@ CHAR_INS_GUILD_EVENTLOG
Definition CharacterDatabase.h:181
CHAR_DEL_INVALID_SPELL_TALENTS
@ CHAR_DEL_INVALID_SPELL_TALENTS
Definition CharacterDatabase.h:335
CHAR_DEL_ITEMCONTAINER_ITEM
@ CHAR_DEL_ITEMCONTAINER_ITEM
Definition CharacterDatabase.h:558
CHAR_UPD_PLAYER_CURRENCY
@ CHAR_UPD_PLAYER_CURRENCY
Definition CharacterDatabase.h:227
CHAR_UPD_CHAR_ACHIEVEMENT
@ CHAR_UPD_CHAR_ACHIEVEMENT
Definition CharacterDatabase.h:436
CHAR_UPD_MAIL_RETURNED
@ CHAR_UPD_MAIL_RETURNED
Definition CharacterDatabase.h:128
CHAR_UPD_GUILD_EMBLEM_INFO
@ CHAR_UPD_GUILD_EMBLEM_INFO
Definition CharacterDatabase.h:192
CHAR_SEL_ACCOUNT_BATTLE_PET_SLOTS
@ CHAR_SEL_ACCOUNT_BATTLE_PET_SLOTS
Definition CharacterDatabase.h:579
CHAR_UPD_CHARACTER_BAN
@ CHAR_UPD_CHARACTER_BAN
Definition CharacterDatabase.h:43
CHAR_DEL_PLAYER_CORPSES
@ CHAR_DEL_PLAYER_CORPSES
Definition CharacterDatabase.h:277
CHAR_DEL_INVALID_PET_SPELL
@ CHAR_DEL_INVALID_PET_SPELL
Definition CharacterDatabase.h:344
CHAR_SEL_PET_SLOTS
@ CHAR_SEL_PET_SLOTS
Definition CharacterDatabase.h:534
CHAR_SEL_CHAR_DEL_INFO_BY_NAME
@ CHAR_SEL_CHAR_DEL_INFO_BY_NAME
Definition CharacterDatabase.h:373
CHAR_DEL_ACCOUNT_BATTLE_PET
@ CHAR_DEL_ACCOUNT_BATTLE_PET
Definition CharacterDatabase.h:577
CHAR_SEL_CHAR_DEL_INFO
@ CHAR_SEL_CHAR_DEL_INFO
Definition CharacterDatabase.h:374
CHAR_SEL_EXPIRED_MAIL
@ CHAR_SEL_EXPIRED_MAIL
Definition CharacterDatabase.h:126
CHAR_DEL_GO_RESPAWN
@ CHAR_DEL_GO_RESPAWN
Definition CharacterDatabase.h:288
CHAR_DEL_AUCTION
@ CHAR_DEL_AUCTION
Definition CharacterDatabase.h:116
CHAR_SEL_PETITION_OWNER_BY_GUID
@ CHAR_SEL_PETITION_OWNER_BY_GUID
Definition CharacterDatabase.h:263
CHAR_DEL_ITEMCONTAINER_ITEMS
@ CHAR_DEL_ITEMCONTAINER_ITEMS
Definition CharacterDatabase.h:557
CHAR_DEL_GROUP
@ CHAR_DEL_GROUP
Definition CharacterDatabase.h:413
CHAR_DEL_CALENDAR_EVENT
@ CHAR_DEL_CALENDAR_EVENT
Definition CharacterDatabase.h:515
CHAR_DEL_PETITION_SIGNATURE
@ CHAR_DEL_PETITION_SIGNATURE
Definition CharacterDatabase.h:258
CHAR_DEL_CHAR_INSTANCE_BY_MAP_DIFF
@ CHAR_DEL_CHAR_INSTANCE_BY_MAP_DIFF
Definition CharacterDatabase.h:418
CHAR_SEL_AUCTION_BY_TIME
@ CHAR_SEL_AUCTION_BY_TIME
Definition CharacterDatabase.h:117
CHAR_SEL_ITEMCONTAINER_ITEMS
@ CHAR_SEL_ITEMCONTAINER_ITEMS
Definition CharacterDatabase.h:556
CHAR_REP_INVENTORY_ITEM
@ CHAR_REP_INVENTORY_ITEM
Definition CharacterDatabase.h:135
CHAR_DEL_CHAR_DECLINED_NAME
@ CHAR_DEL_CHAR_DECLINED_NAME
Definition CharacterDatabase.h:425
CHAR_INS_CHARACTER_WEEKLYQUESTSTATUS
@ CHAR_INS_CHARACTER_WEEKLYQUESTSTATUS
Definition CharacterDatabase.h:85
CHAR_DEL_GUILD_BANK_EVENTLOGS
@ CHAR_DEL_GUILD_BANK_EVENTLOGS
Definition CharacterDatabase.h:180
CHAR_DEL_PETITION_SIGNATURE_BY_OWNER
@ CHAR_DEL_PETITION_SIGNATURE_BY_OWNER
Definition CharacterDatabase.h:491
CHAR_INS_EQUIP_SET
@ CHAR_INS_EQUIP_SET
Definition CharacterDatabase.h:221
CHAR_DEL_ALL_PETITION_SIGNATURES
@ CHAR_DEL_ALL_PETITION_SIGNATURES
Definition CharacterDatabase.h:257
CHAR_SEL_ACCOUNT_BY_NAME
@ CHAR_SEL_ACCOUNT_BY_NAME
Definition CharacterDatabase.h:147
CHAR_SEL_CHAR_PET_BY_SLOT
@ CHAR_SEL_CHAR_PET_BY_SLOT
Definition CharacterDatabase.h:544
CHAR_SEL_CHARACTER_AURA_FROZEN
@ CHAR_SEL_CHARACTER_AURA_FROZEN
Definition CharacterDatabase.h:369
CHAR_INS_CHAR_RESEARCH_DIGSITE
@ CHAR_INS_CHAR_RESEARCH_DIGSITE
Definition CharacterDatabase.h:567
CHAR_INS_LAG_REPORT
@ CHAR_INS_LAG_REPORT
Definition CharacterDatabase.h:309
CHAR_DEL_CHAR_RESEARCH_HISTORY
@ CHAR_DEL_CHAR_RESEARCH_HISTORY
Definition CharacterDatabase.h:571
CHAR_DEL_GUILD_FINDER_APPLICANT
@ CHAR_DEL_GUILD_FINDER_APPLICANT
Definition CharacterDatabase.h:510
CHAR_INS_BATTLEGROUND_RANDOM
@ CHAR_INS_BATTLEGROUND_RANDOM
Definition CharacterDatabase.h:71
CHAR_SEL_MAILITEMS
@ CHAR_SEL_MAILITEMS
Definition CharacterDatabase.h:113
CHAR_DEL_PLAYER_BGDATA
@ CHAR_DEL_PLAYER_BGDATA
Definition CharacterDatabase.h:268
CHAR_SEL_BANNED_NAME
@ CHAR_SEL_BANNED_NAME
Definition CharacterDatabase.h:48
CHAR_UPD_CHANNEL_OWNERSHIP
@ CHAR_UPD_CHANNEL_OWNERSHIP
Definition CharacterDatabase.h:217
CHAR_DEL_QUEST_POOL_SAVE
@ CHAR_DEL_QUEST_POOL_SAVE
Definition CharacterDatabase.h:33
CHAR_DEL_GROUP_INSTANCE_BY_INSTANCE
@ CHAR_DEL_GROUP_INSTANCE_BY_INSTANCE
Definition CharacterDatabase.h:345
CHAR_INS_INSTANCE_SAVE
@ CHAR_INS_INSTANCE_SAVE
Definition CharacterDatabase.h:243
CHAR_DEL_GROUP_INSTANCE_BY_MAP_DIFF
@ CHAR_DEL_GROUP_INSTANCE_BY_MAP_DIFF
Definition CharacterDatabase.h:419
CHAR_DEL_GUILD_FINDER_GUILD_SETTINGS
@ CHAR_DEL_GUILD_FINDER_GUILD_SETTINGS
Definition CharacterDatabase.h:512
CHAR_SEL_INSTANCE
@ CHAR_SEL_INSTANCE
Definition CharacterDatabase.h:387
CHAR_SEL_CHAR_VOID_STORAGE
@ CHAR_SEL_CHAR_VOID_STORAGE
Definition CharacterDatabase.h:501
CHAR_SEL_CHECK_GUID
@ CHAR_SEL_CHECK_GUID
Definition CharacterDatabase.h:39
CHAR_SEL_CHARACTER_COUNT
@ CHAR_SEL_CHARACTER_COUNT
Definition CharacterDatabase.h:154
CHAR_UPD_DELETE_INFO
@ CHAR_UPD_DELETE_INFO
Definition CharacterDatabase.h:336
CHAR_DEL_CHAR_RESEARCH_PROJECTS
@ CHAR_DEL_CHAR_RESEARCH_PROJECTS
Definition CharacterDatabase.h:574
CHAR_UPD_PETITION_NAME
@ CHAR_UPD_PETITION_NAME
Definition CharacterDatabase.h:321
CHAR_INS_CHARACTER_MONTHLYQUESTSTATUS
@ CHAR_INS_CHARACTER_MONTHLYQUESTSTATUS
Definition CharacterDatabase.h:86
CHAR_INS_PET_SPELL_COOLDOWN
@ CHAR_INS_PET_SPELL_COOLDOWN
Definition CharacterDatabase.h:525
CHAR_REP_CALENDAR_INVITE
@ CHAR_REP_CALENDAR_INVITE
Definition CharacterDatabase.h:516
CHAR_DEL_ALL_GAME_EVENT_CONDITION_SAVE
@ CHAR_DEL_ALL_GAME_EVENT_CONDITION_SAVE
Definition CharacterDatabase.h:249
CHAR_UPD_CHAR_PET_SLOT_BY_ID
@ CHAR_UPD_CHAR_PET_SLOT_BY_ID
Definition CharacterDatabase.h:550
CHAR_DEL_INVALID_MAIL_ITEM
@ CHAR_DEL_INVALID_MAIL_ITEM
Definition CharacterDatabase.h:124
CHAR_DEL_CHARACTER_SKILL
@ CHAR_DEL_CHARACTER_SKILL
Definition CharacterDatabase.h:358
CHAR_DEL_GUILD_BANK_RIGHTS_FOR_RANK
@ CHAR_DEL_GUILD_BANK_RIGHTS_FOR_RANK
Definition CharacterDatabase.h:177
CHAR_SEL_BANINFO
@ CHAR_SEL_BANINFO
Definition CharacterDatabase.h:45
CHAR_UDP_CHAR_PET_SLOT_BY_SLOT_EXCLUDE_ID
@ CHAR_UDP_CHAR_PET_SLOT_BY_SLOT_EXCLUDE_ID
Definition CharacterDatabase.h:548
CHAR_INS_PLAYER_HOMEBIND
@ CHAR_INS_PLAYER_HOMEBIND
Definition CharacterDatabase.h:270
CHAR_SEL_PETITION_BY_OWNER
@ CHAR_SEL_PETITION_BY_OWNER
Definition CharacterDatabase.h:259
CHAR_DEL_NONEXISTENT_GUILD_BANK_ITEM
@ CHAR_DEL_NONEXISTENT_GUILD_BANK_ITEM
Definition CharacterDatabase.h:35
CHAR_DEL_INVALID_SPELL_SPELLS
@ CHAR_DEL_INVALID_SPELL_SPELLS
Definition CharacterDatabase.h:334
CHAR_UPD_NAME_BY_GUID
@ CHAR_UPD_NAME_BY_GUID
Definition CharacterDatabase.h:156
CHAR_INS_GAME_EVENT_SAVE
@ CHAR_INS_GAME_EVENT_SAVE
Definition CharacterDatabase.h:247
CHAR_INS_CHAR_SKILL_LANGUAGE
@ CHAR_INS_CHAR_SKILL_LANGUAGE
Definition CharacterDatabase.h:429
CHAR_SEL_CHAR_PET_BY_ENTRY
@ CHAR_SEL_CHAR_PET_BY_ENTRY
Definition CharacterDatabase.h:542
CHAR_SEL_TUTORIALS
@ CHAR_SEL_TUTORIALS
Definition CharacterDatabase.h:237
CHAR_UPD_GENDER_PLAYERBYTES
@ CHAR_UPD_GENDER_PLAYERBYTES
Definition CharacterDatabase.h:357
CHAR_SEL_CHAR_LEVEL
@ CHAR_SEL_CHAR_LEVEL
Definition CharacterDatabase.h:57
CHAR_INS_BUG_REPORT
@ CHAR_INS_BUG_REPORT
Definition CharacterDatabase.h:320
CHAR_SEL_CHARACTER_BGDATA
@ CHAR_SEL_CHARACTER_BGDATA
Definition CharacterDatabase.h:105
CHAR_SEL_CHARACTER_SOCIALLIST
@ CHAR_SEL_CHARACTER_SOCIALLIST
Definition CharacterDatabase.h:95
CHAR_DEL_CHAR_ACTION_BY_BUTTON_SPEC
@ CHAR_DEL_CHAR_ACTION_BY_BUTTON_SPEC
Definition CharacterDatabase.h:468
CHAR_SEL_PET_SLOT_BY_ID
@ CHAR_SEL_PET_SLOT_BY_ID
Definition CharacterDatabase.h:537
CHAR_UPD_CHAR_SPELL_FACTION_CHANGE
@ CHAR_UPD_CHAR_SPELL_FACTION_CHANGE
Definition CharacterDatabase.h:439
CHAR_SEL_PETITION_SIG_BY_GUID_TYPE
@ CHAR_SEL_PETITION_SIG_BY_GUID_TYPE
Definition CharacterDatabase.h:265
CHAR_UPD_CHAR_TAXI_PATH
@ CHAR_UPD_CHAR_TAXI_PATH
Definition CharacterDatabase.h:430
CHAR_DEL_MAIL_ITEM
@ CHAR_DEL_MAIL_ITEM
Definition CharacterDatabase.h:123
CHAR_UPD_CHAR_TAXIMASK
@ CHAR_UPD_CHAR_TAXIMASK
Definition CharacterDatabase.h:431
CHAR_UPD_INSTANCE_DATA
@ CHAR_UPD_INSTANCE_DATA
Definition CharacterDatabase.h:244
CHAR_INS_GROUP
@ CHAR_INS_GROUP
Definition CharacterDatabase.h:324
CHAR_SEL_BANINFO_LIST
@ CHAR_SEL_BANINFO_LIST
Definition CharacterDatabase.h:47
CHAR_DEL_CHAR_ACHIEVEMENT_PROGRESS_BY_CRITERIA
@ CHAR_DEL_CHAR_ACHIEVEMENT_PROGRESS_BY_CRITERIA
Definition CharacterDatabase.h:407
CHAR_REP_GM_SUGGEST
@ CHAR_REP_GM_SUGGEST
Definition CharacterDatabase.h:304
CHAR_DEL_PLAYER_HOMEBIND
@ CHAR_DEL_PLAYER_HOMEBIND
Definition CharacterDatabase.h:272
CHAR_DEL_CHAR_EQUIPMENTSETS
@ CHAR_DEL_CHAR_EQUIPMENTSETS
Definition CharacterDatabase.h:458
CHAR_REP_CHAR_CUF_PROFILES
@ CHAR_REP_CHAR_CUF_PROFILES
Definition CharacterDatabase.h:506
CHAR_DEL_GM_BUG
@ CHAR_DEL_GM_BUG
Definition CharacterDatabase.h:300
CHAR_SEL_CHARACTER_ACTIONS_SPEC
@ CHAR_SEL_CHARACTER_ACTIONS_SPEC
Definition CharacterDatabase.h:91
CHAR_INS_MAIL_ITEM
@ CHAR_INS_MAIL_ITEM
Definition CharacterDatabase.h:122
CHAR_SEL_CHAR_POSITION
@ CHAR_SEL_CHAR_POSITION
Definition CharacterDatabase.h:61
CHAR_UPD_CHAR_ACTION
@ CHAR_UPD_CHAR_ACTION
Definition CharacterDatabase.h:467
CHAR_REP_GUILD_FINDER_GUILD_SETTINGS
@ CHAR_REP_GUILD_FINDER_GUILD_SETTINGS
Definition CharacterDatabase.h:511
CHAR_UPD_GUILD_MEMBER_RANK
@ CHAR_UPD_GUILD_MEMBER_RANK
Definition CharacterDatabase.h:186
CHAR_INS_GUILD_RANK
@ CHAR_INS_GUILD_RANK
Definition CharacterDatabase.h:166
CHAR_DEL_CHAR_TALENT_BY_SPELL_SPEC
@ CHAR_DEL_CHAR_TALENT_BY_SPELL_SPEC
Definition CharacterDatabase.h:495
CHAR_SEL_ACCOUNT_BY_GUID
@ CHAR_SEL_ACCOUNT_BY_GUID
Definition CharacterDatabase.h:148
CHAR_DEL_CHAR_INVENTORY_UNTIL_BAG_SLOT
@ CHAR_DEL_CHAR_INVENTORY_UNTIL_BAG_SLOT
Definition CharacterDatabase.h:471
CHAR_REP_CREATURE_RESPAWN
@ CHAR_REP_CREATURE_RESPAWN
Definition CharacterDatabase.h:281
CHAR_DEL_EQUIP_SET
@ CHAR_DEL_EQUIP_SET
Definition CharacterDatabase.h:222
CHAR_INS_CHAR_ACHIEVEMENT_PROGRESS
@ CHAR_INS_CHAR_ACHIEVEMENT_PROGRESS
Definition CharacterDatabase.h:408
CHAR_INS_GUILD
@ CHAR_INS_GUILD
Definition CharacterDatabase.h:160
CHAR_SEL_CHAR_REP_BY_FACTION
@ CHAR_SEL_CHAR_REP_BY_FACTION
Definition CharacterDatabase.h:440
CHAR_INS_AURA
@ CHAR_INS_AURA
Definition CharacterDatabase.h:224
CHAR_SEL_GUILD_ACHIEVEMENT
@ CHAR_SEL_GUILD_ACHIEVEMENT
Definition CharacterDatabase.h:207
CHAR_SEL_CHARACTER_HOMEBIND
@ CHAR_SEL_CHARACTER_HOMEBIND
Definition CharacterDatabase.h:96
CHAR_DEL_INSTANCE_BY_INSTANCE
@ CHAR_DEL_INSTANCE_BY_INSTANCE
Definition CharacterDatabase.h:416
CHAR_SEL_PETITION_SIG_BY_GUID
@ CHAR_SEL_PETITION_SIG_BY_GUID
Definition CharacterDatabase.h:264
CHAR_SEL_FREE_NAME
@ CHAR_SEL_FREE_NAME
Definition CharacterDatabase.h:54
CHAR_UPD_GUILD_RANK_BANK_MONEY
@ CHAR_UPD_GUILD_RANK_BANK_MONEY
Definition CharacterDatabase.h:196
CHAR_INS_GM_SUBSURVEY
@ CHAR_INS_GM_SUBSURVEY
Definition CharacterDatabase.h:308
CHAR_SEL_ENUM
@ CHAR_SEL_ENUM
Definition CharacterDatabase.h:52
CHAR_UPD_GUILD_LEADER
@ CHAR_UPD_GUILD_LEADER
Definition CharacterDatabase.h:189
CHAR_DEL_PETITION_SIGNATURE_BY_OWNER_AND_TYPE
@ CHAR_DEL_PETITION_SIGNATURE_BY_OWNER_AND_TYPE
Definition CharacterDatabase.h:493
CHAR_SEL_SUM_CHARS
@ CHAR_SEL_SUM_CHARS
Definition CharacterDatabase.h:40
CHAR_SEL_CHAR_TALENT
@ CHAR_SEL_CHAR_TALENT
Definition CharacterDatabase.h:497
CHAR_SEL_GROUP_MEMBER
@ CHAR_SEL_GROUP_MEMBER
Definition CharacterDatabase.h:74
CHAR_UPD_CHANNEL_USAGE
@ CHAR_UPD_CHANNEL_USAGE
Definition CharacterDatabase.h:216
CHAR_SEL_MAIL_LIST_ITEMS
@ CHAR_SEL_MAIL_LIST_ITEMS
Definition CharacterDatabase.h:51
CHAR_UPD_CHAR_LIST_SLOT
@ CHAR_UPD_CHAR_LIST_SLOT
Definition CharacterDatabase.h:499
CHAR_SEL_PETITION_SIG_BY_ACCOUNT
@ CHAR_SEL_PETITION_SIG_BY_ACCOUNT
Definition CharacterDatabase.h:262
CHAR_DEL_CHAR_SPELL_BY_SPELL
@ CHAR_DEL_CHAR_SPELL_BY_SPELL
Definition CharacterDatabase.h:438
CHAR_DEL_PET_SPELLS
@ CHAR_DEL_PET_SPELLS
Definition CharacterDatabase.h:530
CHAR_DEL_GROUP_INSTANCE_BY_GUID
@ CHAR_DEL_GROUP_INSTANCE_BY_GUID
Definition CharacterDatabase.h:346
CHAR_SEL_CHAR_CREATE_INFO
@ CHAR_SEL_CHAR_CREATE_INFO
Definition CharacterDatabase.h:41
CHAR_SEL_CHARACTER_INVENTORY
@ CHAR_SEL_CHARACTER_INVENTORY
Definition CharacterDatabase.h:89
CHAR_UPD_CHAR_QUESTSTATUS_REWARDED_ACTIVE_BY_QUEST
@ CHAR_UPD_CHAR_QUESTSTATUS_REWARDED_ACTIVE_BY_QUEST
Definition CharacterDatabase.h:483
CHAR_SEL_HAS_TUTORIALS
@ CHAR_SEL_HAS_TUTORIALS
Definition CharacterDatabase.h:238
CHAR_UPD_GROUP_DIFFICULTY
@ CHAR_UPD_GROUP_DIFFICULTY
Definition CharacterDatabase.h:332
CHAR_SEL_ACCOUNT_DATA
@ CHAR_SEL_ACCOUNT_DATA
Definition CharacterDatabase.h:230
CHAR_UPD_CHARACTER_POSITION
@ CHAR_UPD_CHARACTER_POSITION
Definition CharacterDatabase.h:364
CHAR_INS_CHAR_INSTANCE
@ CHAR_INS_CHAR_INSTANCE
Definition CharacterDatabase.h:356
CHAR_SEL_CHARACTER_INSTANCE
@ CHAR_SEL_CHARACTER_INSTANCE
Definition CharacterDatabase.h:75
CHAR_DEL_ITEM_BOP_TRADE
@ CHAR_DEL_ITEM_BOP_TRADE
Definition CharacterDatabase.h:133
CHAR_INS_CHAR_ACHIEVEMENT
@ CHAR_INS_CHAR_ACHIEVEMENT
Definition CharacterDatabase.h:406
CHAR_DEL_CHAR_QUESTSTATUS_BY_QUEST
@ CHAR_DEL_CHAR_QUESTSTATUS_BY_QUEST
Definition CharacterDatabase.h:475
CHAR_SEL_EXPIRED_MAIL_ITEMS
@ CHAR_SEL_EXPIRED_MAIL_ITEMS
Definition CharacterDatabase.h:127
CHAR_SEL_PETITION
@ CHAR_SEL_PETITION
Definition CharacterDatabase.h:255
CHAR_UDP_RESTORE_DELETE_INFO
@ CHAR_UDP_RESTORE_DELETE_INFO
Definition CharacterDatabase.h:337
CHAR_INS_ADDON
@ CHAR_INS_ADDON
Definition CharacterDatabase.h:343
CHAR_SEL_CHARACTER_DATA_BY_GUID
@ CHAR_SEL_CHARACTER_DATA_BY_GUID
Definition CharacterDatabase.h:158
CHAR_REP_GM_BUG
@ CHAR_REP_GM_BUG
Definition CharacterDatabase.h:299
CHAR_DEL_ACCOUNT_DATA
@ CHAR_DEL_ACCOUNT_DATA
Definition CharacterDatabase.h:232
CHAR_SEL_CHARACTER_QUESTSTATUS
@ CHAR_SEL_CHARACTER_QUESTSTATUS
Definition CharacterDatabase.h:78
CHAR_SEL_CHAR_DEL_INFO_BY_GUID
@ CHAR_SEL_CHAR_DEL_INFO_BY_GUID
Definition CharacterDatabase.h:372
CHAR_DEL_GAME_EVENT_CONDITION_SAVE
@ CHAR_DEL_GAME_EVENT_CONDITION_SAVE
Definition CharacterDatabase.h:250
CHAR_REP_CHARACTER_ARENA_STATS
@ CHAR_REP_CHARACTER_ARENA_STATS
Definition CharacterDatabase.h:253
CHAR_UPD_GROUP_TYPE
@ CHAR_UPD_GROUP_TYPE
Definition CharacterDatabase.h:329
CHAR_SEL_GUILD_MEMBER_EXTENDED
@ CHAR_SEL_GUILD_MEMBER_EXTENDED
Definition CharacterDatabase.h:100
CHAR_DEL_PLAYER_ACCOUNT_DATA
@ CHAR_DEL_PLAYER_ACCOUNT_DATA
Definition CharacterDatabase.h:235
CHAR_UPD_BLACKMARKET_AUCTION
@ CHAR_UPD_BLACKMARKET_AUCTION
Definition CharacterDatabase.h:586
CHAR_DEL_QUEST_STATUS_SEASONAL_CHAR
@ CHAR_DEL_QUEST_STATUS_SEASONAL_CHAR
Definition CharacterDatabase.h:69
CHAR_UPD_ACCOUNT_ONLINE
@ CHAR_UPD_ACCOUNT_ONLINE
Definition CharacterDatabase.h:323
CHAR_UPD_GUILD_RANK_RIGHTS
@ CHAR_UPD_GUILD_RANK_RIGHTS
Definition CharacterDatabase.h:191
CHAR_UDP_CHAR_SKILLS
@ CHAR_UDP_CHAR_SKILLS
Definition CharacterDatabase.h:486
CHAR_SEL_BLACKMARKET_AUCTIONS
@ CHAR_SEL_BLACKMARKET_AUCTIONS
Definition CharacterDatabase.h:583
CHAR_DEL_ITEM_INSTANCE_TRANSMOG_BY_OWNER
@ CHAR_DEL_ITEM_INSTANCE_TRANSMOG_BY_OWNER
Definition CharacterDatabase.h:143
CHAR_UPD_PLAYER_HOMEBIND
@ CHAR_UPD_PLAYER_HOMEBIND
Definition CharacterDatabase.h:271
CHAR_DEL_MAIL
@ CHAR_DEL_MAIL
Definition CharacterDatabase.h:455
CHAR_UPD_GUILD_RESET_TODAY_EXPERIENCE
@ CHAR_UPD_GUILD_RESET_TODAY_EXPERIENCE
Definition CharacterDatabase.h:210
CHAR_INS_CHAR_GLYPHS
@ CHAR_INS_CHAR_GLYPHS
Definition CharacterDatabase.h:494
CHAR_UPD_GUILD_MEMBER_PNOTE
@ CHAR_UPD_GUILD_MEMBER_PNOTE
Definition CharacterDatabase.h:184
CHAR_INS_CHAR_STATS
@ CHAR_INS_CHAR_STATS
Definition CharacterDatabase.h:489
CHAR_SEL_CHARACTER_NAME_DATA
@ CHAR_SEL_CHARACTER_NAME_DATA
Definition CharacterDatabase.h:59
CHAR_DEL_CHAR_ACHIEVEMENT_BY_ACHIEVEMENT
@ CHAR_DEL_CHAR_ACHIEVEMENT_BY_ACHIEVEMENT
Definition CharacterDatabase.h:435
CHAR_SEL_CHARS_BY_ACCOUNT_ID
@ CHAR_SEL_CHARS_BY_ACCOUNT_ID
Definition CharacterDatabase.h:376
CHAR_SEL_CHAR_POSITION_XYZ
@ CHAR_SEL_CHAR_POSITION_XYZ
Definition CharacterDatabase.h:60
CHAR_SEL_CHARACTER_TALENTS
@ CHAR_SEL_CHARACTER_TALENTS
Definition CharacterDatabase.h:107
CHAR_DEL_CHAR_TALENT
@ CHAR_DEL_CHAR_TALENT
Definition CharacterDatabase.h:463
CHAR_SEL_CHAR_CLASS_LVL_AT_LOGIN
@ CHAR_SEL_CHAR_CLASS_LVL_AT_LOGIN
Definition CharacterDatabase.h:385
CHAR_DEL_CORPSE
@ CHAR_DEL_CORPSE
Definition CharacterDatabase.h:276
CHAR_SEL_MAIL_LIST_INFO
@ CHAR_SEL_MAIL_LIST_INFO
Definition CharacterDatabase.h:50
CHAR_DEL_ALL_GM_TICKETS
@ CHAR_DEL_ALL_GM_TICKETS
Definition CharacterDatabase.h:294
CHAR_DEL_QUEST_STATUS_WEEKLY
@ CHAR_DEL_QUEST_STATUS_WEEKLY
Definition CharacterDatabase.h:63
CHAR_SEL_CHARACTER_NAME_CLASS
@ CHAR_SEL_CHARACTER_NAME_CLASS
Definition CharacterDatabase.h:151
CHAR_SEL_CHARACTER_WEEKLYQUESTSTATUS
@ CHAR_SEL_CHARACTER_WEEKLYQUESTSTATUS
Definition CharacterDatabase.h:81
CHAR_SEL_CHAR_CUF_PROFILES
@ CHAR_SEL_CHAR_CUF_PROFILES
Definition CharacterDatabase.h:505
CHAR_DEL_CHAR_SKILL_BY_SKILL
@ CHAR_DEL_CHAR_SKILL_BY_SKILL
Definition CharacterDatabase.h:484
CHAR_INS_ACCOUNT_BATTLE_PET
@ CHAR_INS_ACCOUNT_BATTLE_PET
Definition CharacterDatabase.h:578
CHAR_SEL_MAIL_COUNT_ITEM
@ CHAR_SEL_MAIL_COUNT_ITEM
Definition CharacterDatabase.h:396
CHAR_SEL_GM_BUGS
@ CHAR_SEL_GM_BUGS
Definition CharacterDatabase.h:297
CHAR_SEL_CHAR_SOCIAL
@ CHAR_SEL_CHAR_SOCIAL
Definition CharacterDatabase.h:389
CHAR_INS_PET_SPELL
@ CHAR_INS_PET_SPELL
Definition CharacterDatabase.h:527
CHAR_DEL_CHAR_QUESTSTATUS_DAILY
@ CHAR_DEL_CHAR_QUESTSTATUS_DAILY
Definition CharacterDatabase.h:462
CHAR_SEL_MAIL
@ CHAR_SEL_MAIL
Definition CharacterDatabase.h:391
CHAR_UPD_CHARACTER_SOCIAL_NOTE
@ CHAR_UPD_CHARACTER_SOCIAL_NOTE
Definition CharacterDatabase.h:363
CHAR_DEL_CHAR_PET_BY_ID
@ CHAR_DEL_CHAR_PET_BY_ID
Definition CharacterDatabase.h:553
CHAR_INS_GUILD_BANK_TAB
@ CHAR_INS_GUILD_BANK_TAB
Definition CharacterDatabase.h:169
CHAR_SEL_CHAR_DATA_FOR_GUILD
@ CHAR_SEL_CHAR_DATA_FOR_GUILD
Definition CharacterDatabase.h:200
CHAR_UPD_CHAR_PET_ACTIVE_BY_OWNER
@ CHAR_UPD_CHAR_PET_ACTIVE_BY_OWNER
Definition CharacterDatabase.h:551
CHAR_UPD_GUILD_BANK_MONEY
@ CHAR_UPD_GUILD_BANK_MONEY
Definition CharacterDatabase.h:194
CHAR_INS_AUCTION
@ CHAR_INS_AUCTION
Definition CharacterDatabase.h:115
CHAR_DEL_PET_AURAS
@ CHAR_DEL_PET_AURAS
Definition CharacterDatabase.h:523
CHAR_SEL_CHARACTER_CRITERIAPROGRESS
@ CHAR_SEL_CHARACTER_CRITERIAPROGRESS
Definition CharacterDatabase.h:103
CHAR_SEL_GM_TICKETS
@ CHAR_SEL_GM_TICKETS
Definition CharacterDatabase.h:291
CHAR_SEL_CHARACTER_MAILCOUNT
@ CHAR_SEL_CHARACTER_MAILCOUNT
Definition CharacterDatabase.h:92
CHAR_UPD_GROUP_RAID_DIFFICULTY
@ CHAR_UPD_GROUP_RAID_DIFFICULTY
Definition CharacterDatabase.h:333
CHAR_DEL_ITEM_REFUND_INSTANCE
@ CHAR_DEL_ITEM_REFUND_INSTANCE
Definition CharacterDatabase.h:411
CHAR_DEL_GUILD_BANK_TAB
@ CHAR_DEL_GUILD_BANK_TAB
Definition CharacterDatabase.h:170
CHAR_DEL_INVALID_ACHIEVMENT
@ CHAR_DEL_INVALID_ACHIEVMENT
Definition CharacterDatabase.h:342
CHAR_DEL_CHAR_INVENTORY
@ CHAR_DEL_CHAR_INVENTORY
Definition CharacterDatabase.h:451
CHAR_DEL_ACCOUNT_INSTANCE_LOCK_TIMES
@ CHAR_DEL_ACCOUNT_INSTANCE_LOCK_TIMES
Definition CharacterDatabase.h:149
CHAR_DEL_CREATURE_RESPAWN
@ CHAR_DEL_CREATURE_RESPAWN
Definition CharacterDatabase.h:282
CHAR_SEL_AUCTIONHOUSE_COUNT_ITEM
@ CHAR_SEL_AUCTIONHOUSE_COUNT_ITEM
Definition CharacterDatabase.h:397
CHAR_SEL_PET_DECLINED_NAME
@ CHAR_SEL_PET_DECLINED_NAME
Definition CharacterDatabase.h:522
CHAR_SEL_CHARACTER_GLYPHS
@ CHAR_SEL_CHARACTER_GLYPHS
Definition CharacterDatabase.h:106
CHAR_DEL_GO_RESPAWN_BY_INSTANCE
@ CHAR_DEL_GO_RESPAWN_BY_INSTANCE
Definition CharacterDatabase.h:289
CHAR_SEL_CHARACTER_REPUTATION
@ CHAR_SEL_CHARACTER_REPUTATION
Definition CharacterDatabase.h:88
CHAR_ADD_CHAR_PET_DECLINEDNAME
@ CHAR_ADD_CHAR_PET_DECLINEDNAME
Definition CharacterDatabase.h:546
CHAR_DEL_QUEST_STATUS_MONTHLY_CHAR
@ CHAR_DEL_QUEST_STATUS_MONTHLY_CHAR
Definition CharacterDatabase.h:68
CHAR_DEL_CHAR_AURA
@ CHAR_DEL_CHAR_AURA
Definition CharacterDatabase.h:448
CHAR_INS_CHARACTER
@ CHAR_INS_CHARACTER
Definition CharacterDatabase.h:313
CHAR_UPD_GROUP_MEMBER_FLAG
@ CHAR_UPD_GROUP_MEMBER_FLAG
Definition CharacterDatabase.h:331
MAX_CHARACTERDATABASE_STATEMENTS
@ MAX_CHARACTERDATABASE_STATEMENTS
Definition CharacterDatabase.h:588
CHAR_DEL_CHAR_QUESTSTATUS
@ CHAR_DEL_CHAR_QUESTSTATUS
Definition CharacterDatabase.h:432
CHAR_DEL_CHAR_ACTION
@ CHAR_DEL_CHAR_ACTION
Definition CharacterDatabase.h:447
CHAR_SEL_CHARACTER_SPELL
@ CHAR_SEL_CHARACTER_SPELL
Definition CharacterDatabase.h:77
CHAR_DEL_GUILD_MEMBERS
@ CHAR_DEL_GUILD_MEMBERS
Definition CharacterDatabase.h:165
CHAR_DEL_QUEST_STATUS_SEASONAL
@ CHAR_DEL_QUEST_STATUS_SEASONAL
Definition CharacterDatabase.h:65
CHAR_SEL_MATCH_MAKER_RATING
@ CHAR_SEL_MATCH_MAKER_RATING
Definition CharacterDatabase.h:153
CHAR_DEL_CHAR_QUESTSTATUS_OBJECTIVE
@ CHAR_DEL_CHAR_QUESTSTATUS_OBJECTIVE
Definition CharacterDatabase.h:477
CHAR_INS_MAIL
@ CHAR_INS_MAIL
Definition CharacterDatabase.h:120
CHAR_SEL_CORPSES
@ CHAR_SEL_CORPSES
Definition CharacterDatabase.h:274
CHAR_DEL_CHAR_INSTANCE_BY_INSTANCE
@ CHAR_DEL_CHAR_INSTANCE_BY_INSTANCE
Definition CharacterDatabase.h:417
CHAR_SEL_ITEM_BOP_TRADE
@ CHAR_SEL_ITEM_BOP_TRADE
Definition CharacterDatabase.h:132
CHAR_UPD_CHAR_REP_FACTION_CHANGE
@ CHAR_UPD_CHAR_REP_FACTION_CHANGE
Definition CharacterDatabase.h:442
CHAR_INS_CHANNEL
@ CHAR_INS_CHANNEL
Definition CharacterDatabase.h:214
CHAR_SEL_CHAR_PET
@ CHAR_SEL_CHAR_PET
Definition CharacterDatabase.h:539
CHAR_DEL_ACCOUNT_BATTLE_PET_SLOTS
@ CHAR_DEL_ACCOUNT_BATTLE_PET_SLOTS
Definition CharacterDatabase.h:580
CHAR_UPD_GUILD_MEMBER_OFFNOTE
@ CHAR_UPD_GUILD_MEMBER_OFFNOTE
Definition CharacterDatabase.h:185
CHAR_SEL_PETITION_SIGNATURE
@ CHAR_SEL_PETITION_SIGNATURE
Definition CharacterDatabase.h:256
CHAR_INS_CHAR_GIFT
@ CHAR_INS_CHAR_GIFT
Definition CharacterDatabase.h:415
CHAR_SEL_GM_SUGGESTS
@ CHAR_SEL_GM_SUGGESTS
Definition CharacterDatabase.h:302
CHAR_UPD_REM_CHARACTER_SOCIAL_FLAGS
@ CHAR_UPD_REM_CHARACTER_SOCIAL_FLAGS
Definition CharacterDatabase.h:360
CHAR_REP_GO_RESPAWN
@ CHAR_REP_GO_RESPAWN
Definition CharacterDatabase.h:287
CHAR_DEL_GUILD_BANK_EVENTLOG
@ CHAR_DEL_GUILD_BANK_EVENTLOG
Definition CharacterDatabase.h:179
CHAR_DEL_GUILD_MEMBER_WITHDRAW
@ CHAR_DEL_GUILD_MEMBER_WITHDRAW
Definition CharacterDatabase.h:199
CHAR_SEL_ACCOUNT_BATTLE_PETS
@ CHAR_SEL_ACCOUNT_BATTLE_PETS
Definition CharacterDatabase.h:576
CHAR_DEL_GUILD_MEMBER
@ CHAR_DEL_GUILD_MEMBER
Definition CharacterDatabase.h:164
CHAR_DEL_MAIL_BY_ID
@ CHAR_DEL_MAIL_BY_ID
Definition CharacterDatabase.h:121
CHAR_REP_GROUP_INSTANCE
@ CHAR_REP_GROUP_INSTANCE
Definition CharacterDatabase.h:347
CHAR_SEL_PETITION_SIGNATURES
@ CHAR_SEL_PETITION_SIGNATURES
Definition CharacterDatabase.h:261
CHAR_REP_PLAYER_ACCOUNT_DATA
@ CHAR_REP_PLAYER_ACCOUNT_DATA
Definition CharacterDatabase.h:234
CHAR_INS_ITEMCONTAINER_ITEMS
@ CHAR_INS_ITEMCONTAINER_ITEMS
Definition CharacterDatabase.h:559
CHAR_UPD_GROUP_LEADER
@ CHAR_UPD_GROUP_LEADER
Definition CharacterDatabase.h:328
CHAR_INS_ITEMCONTAINER_MONEY
@ CHAR_INS_ITEMCONTAINER_MONEY
Definition CharacterDatabase.h:562
CHAR_SEL_GUILD_BANK_COUNT_ITEM
@ CHAR_SEL_GUILD_BANK_COUNT_ITEM
Definition CharacterDatabase.h:398
CHAR_DEL_CHARACTER_SOCIAL
@ CHAR_DEL_CHARACTER_SOCIAL
Definition CharacterDatabase.h:362
CHAR_DEL_CHAR_ACHIEVEMENTS
@ CHAR_DEL_CHAR_ACHIEVEMENTS
Definition CharacterDatabase.h:457
CHAR_DEL_GM_SUGGEST
@ CHAR_DEL_GM_SUGGEST
Definition CharacterDatabase.h:305
CHAR_SEL_CHAR_PINFO
@ CHAR_SEL_CHAR_PINFO
Definition CharacterDatabase.h:377
CHAR_SEL_POOL_QUEST_SAVE
@ CHAR_SEL_POOL_QUEST_SAVE
Definition CharacterDatabase.h:383
CHAR_INS_PETITION
@ CHAR_INS_PETITION
Definition CharacterDatabase.h:422
CHAR_SEL_CHAR_GUID_BY_NAME
@ CHAR_SEL_CHAR_GUID_BY_NAME
Definition CharacterDatabase.h:393
CHAR_INS_LFG_DATA
@ CHAR_INS_LFG_DATA
Definition CharacterDatabase.h:366
CHAR_INS_PLAYER_BGDATA
@ CHAR_INS_PLAYER_BGDATA
Definition CharacterDatabase.h:267
CHAR_INS_WORLDSTATE
@ CHAR_INS_WORLDSTATE
Definition CharacterDatabase.h:353
CHAR_SEL_GUID_BY_NAME_FILTER
@ CHAR_SEL_GUID_BY_NAME_FILTER
Definition CharacterDatabase.h:46
CHAR_SEL_CHARACTER_RANDOMBG
@ CHAR_SEL_CHARACTER_RANDOMBG
Definition CharacterDatabase.h:109
CHAR_SEL_CHARACTER_EQUIPMENTSETS
@ CHAR_SEL_CHARACTER_EQUIPMENTSETS
Definition CharacterDatabase.h:104
CHAR_SEL_PET_SLOTS_DETAIL
@ CHAR_SEL_PET_SLOTS_DETAIL
Definition CharacterDatabase.h:535
CHAR_SEL_CHARACTER_SKILLS
@ CHAR_SEL_CHARACTER_SKILLS
Definition CharacterDatabase.h:108
CHAR_REP_GM_TICKET
@ CHAR_REP_GM_TICKET
Definition CharacterDatabase.h:292
CHAR_UPD_ZONE
@ CHAR_UPD_ZONE
Definition CharacterDatabase.h:338
CHAR_DEL_GUILD_BANK_ITEMS
@ CHAR_DEL_GUILD_BANK_ITEMS
Definition CharacterDatabase.h:174
CHAR_INS_GAME_EVENT_CONDITION_SAVE
@ CHAR_INS_GAME_EVENT_CONDITION_SAVE
Definition CharacterDatabase.h:251
CHAR_SEL_CHARACTER_MAILDATE
@ CHAR_SEL_CHARACTER_MAILDATE
Definition CharacterDatabase.h:93
CHAR_REP_PLAYER_CURRENCY
@ CHAR_REP_PLAYER_CURRENCY
Definition CharacterDatabase.h:228
CHAR_UPD_CHAR_TITLES_FACTION_CHANGE
@ CHAR_UPD_CHAR_TITLES_FACTION_CHANGE
Definition CharacterDatabase.h:443
CHAR_DEL_GUILD_BANK_ITEM
@ CHAR_DEL_GUILD_BANK_ITEM
Definition CharacterDatabase.h:173
CHAR_SEL_CHAR_COD_ITEM_MAIL
@ CHAR_SEL_CHAR_COD_ITEM_MAIL
Definition CharacterDatabase.h:388
CHAR_SEL_AUCTIONHOUSE_ITEM_BY_ENTRY
@ CHAR_SEL_AUCTIONHOUSE_ITEM_BY_ENTRY
Definition CharacterDatabase.h:402
CHAR_DEL_GUILD_EVENTLOG
@ CHAR_DEL_GUILD_EVENTLOG
Definition CharacterDatabase.h:182
CHAR_DEL_CHAR_REP_BY_FACTION
@ CHAR_DEL_CHAR_REP_BY_FACTION
Definition CharacterDatabase.h:441
CHAR_SEL_CHAR_RESEARCH_DIGSITES
@ CHAR_SEL_CHAR_RESEARCH_DIGSITES
Definition CharacterDatabase.h:566
CHAR_INS_ITEM_INSTANCE_TRANSMOG
@ CHAR_INS_ITEM_INSTANCE_TRANSMOG
Definition CharacterDatabase.h:141
CHAR_SEL_CREATURE_RESPAWNS
@ CHAR_SEL_CREATURE_RESPAWNS
Definition CharacterDatabase.h:280
CHAR_UPD_GUILD_INFO
@ CHAR_UPD_GUILD_INFO
Definition CharacterDatabase.h:188
CHAR_DEL_CHAR_ACTION_EXCEPT_SPEC
@ CHAR_DEL_CHAR_ACTION_EXCEPT_SPEC
Definition CharacterDatabase.h:498
CHAR_SEL_CHARACTER_QUEST_OBJECTIVE_STATUS
@ CHAR_SEL_CHARACTER_QUEST_OBJECTIVE_STATUS
Definition CharacterDatabase.h:79
CHAR_DEL_CHAR_RESEARCH_DIGSITE
@ CHAR_DEL_CHAR_RESEARCH_DIGSITE
Definition CharacterDatabase.h:568
CHAR_DEL_CHAR_VOID_STORAGE_ITEM_BY_SLOT
@ CHAR_DEL_CHAR_VOID_STORAGE_ITEM_BY_SLOT
Definition CharacterDatabase.h:503
CHAR_SEL_ENUM_DECLINED_NAME
@ CHAR_SEL_ENUM_DECLINED_NAME
Definition CharacterDatabase.h:53
CHAR_DEL_PETITION_SIGNATURE_BY_GUID
@ CHAR_DEL_PETITION_SIGNATURE_BY_GUID
Definition CharacterDatabase.h:424
CHAR_DEL_QUEST_STATUS_MONTHLY
@ CHAR_DEL_QUEST_STATUS_MONTHLY
Definition CharacterDatabase.h:64
CHAR_SEL_CHARACTER_SPELLCOOLDOWNS
@ CHAR_SEL_CHARACTER_SPELLCOOLDOWNS
Definition CharacterDatabase.h:97
CHAR_SEL_ITEMCONTAINER_MONEY
@ CHAR_SEL_ITEMCONTAINER_MONEY
Definition CharacterDatabase.h:560
CHAR_DEL_GUILD_EVENTLOGS
@ CHAR_DEL_GUILD_EVENTLOGS
Definition CharacterDatabase.h:183
CHAR_SEL_GUILD_BANK_ITEM_BY_ENTRY
@ CHAR_SEL_GUILD_BANK_ITEM_BY_ENTRY
Definition CharacterDatabase.h:403
CHAR_SEL_EXPIRED_AUCTIONS
@ CHAR_SEL_EXPIRED_AUCTIONS
Definition CharacterDatabase.h:311
CHAR_SEL_CHAR_RACE
@ CHAR_SEL_CHAR_RACE
Definition CharacterDatabase.h:56
CHAR_UPD_CHAR_INSTANCE
@ CHAR_UPD_CHAR_INSTANCE
Definition CharacterDatabase.h:355
CHAR_INS_GUILD_BANK_EVENTLOG
@ CHAR_INS_GUILD_BANK_EVENTLOG
Definition CharacterDatabase.h:178
CHAR_INS_CHARACTER_DAILYQUESTSTATUS
@ CHAR_INS_CHARACTER_DAILYQUESTSTATUS
Definition CharacterDatabase.h:84
CHAR_DEL_CHAR_QUESTSTATUS_OBJECTIVE_ALL
@ CHAR_DEL_CHAR_QUESTSTATUS_OBJECTIVE_ALL
Definition CharacterDatabase.h:478
CHAR_UPD_ADD_AT_LOGIN_FLAG
@ CHAR_UPD_ADD_AT_LOGIN_FLAG
Definition CharacterDatabase.h:317
CHAR_RES_CHAR_TITLES_FACTION_CHANGE
@ CHAR_RES_CHAR_TITLES_FACTION_CHANGE
Definition CharacterDatabase.h:444
CHAR_UPD_GIFT_OWNER
@ CHAR_UPD_GIFT_OWNER
Definition CharacterDatabase.h:144
CHAR_DEL_QUEST_STATUS_DAILY
@ CHAR_DEL_QUEST_STATUS_DAILY
Definition CharacterDatabase.h:62
CHAR_DEL_CHAR_REPUTATION
@ CHAR_DEL_CHAR_REPUTATION
Definition CharacterDatabase.h:453
CHAR_DEL_PET_SPELL_BY_SPELL
@ CHAR_DEL_PET_SPELL_BY_SPELL
Definition CharacterDatabase.h:526
CHAR_REP_CHAR_QUESTSTATUS_OBJECTIVE
@ CHAR_REP_CHAR_QUESTSTATUS_OBJECTIVE
Definition CharacterDatabase.h:476
CHAR_DEL_OLD_CHANNELS
@ CHAR_DEL_OLD_CHANNELS
Definition CharacterDatabase.h:218
CHAR_INS_CHARACTER_SOCIAL
@ CHAR_INS_CHARACTER_SOCIAL
Definition CharacterDatabase.h:361
CHAR_DEL_GIFT
@ CHAR_DEL_GIFT
Definition CharacterDatabase.h:145
CHAR_UPD_CHARACTER
@ CHAR_UPD_CHARACTER
Definition CharacterDatabase.h:314
CHAR_DEL_CHAR_INSTANCE_BY_INSTANCE_GUID
@ CHAR_DEL_CHAR_INSTANCE_BY_INSTANCE_GUID
Definition CharacterDatabase.h:354
CHAR_SEL_CHARACTER_MONTHLYQUESTSTATUS
@ CHAR_SEL_CHARACTER_MONTHLYQUESTSTATUS
Definition CharacterDatabase.h:82
CHAR_SEL_CHAR_RESEARCH_HISTORY
@ CHAR_SEL_CHAR_RESEARCH_HISTORY
Definition CharacterDatabase.h:569
CHAR_DEL_PET_SPELL_COOLDOWNS
@ CHAR_DEL_PET_SPELL_COOLDOWNS
Definition CharacterDatabase.h:524
CHAR_DEL_INSTANCE_BY_MAP_DIFF
@ CHAR_DEL_INSTANCE_BY_MAP_DIFF
Definition CharacterDatabase.h:420
CHAR_SEL_PET_SPELL
@ CHAR_SEL_PET_SPELL
Definition CharacterDatabase.h:520
CHAR_DEL_GM_TICKET
@ CHAR_DEL_GM_TICKET
Definition CharacterDatabase.h:293
CHAR_DEL_CHAR_INVENTORY_BY_BAG_SLOT
@ CHAR_DEL_CHAR_INVENTORY_BY_BAG_SLOT
Definition CharacterDatabase.h:470
CHAR_SEL_PINFO_MAILS
@ CHAR_SEL_PINFO_MAILS
Definition CharacterDatabase.h:379
CHAR_INS_CHAR_REPUTATION_BY_FACTION
@ CHAR_INS_CHAR_REPUTATION_BY_FACTION
Definition CharacterDatabase.h:410
CHAR_INS_CHAR_ACTION
@ CHAR_INS_CHAR_ACTION
Definition CharacterDatabase.h:466
CHAR_DEL_CHAR_ACHIEVEMENT_PROGRESS
@ CHAR_DEL_CHAR_ACHIEVEMENT_PROGRESS
Definition CharacterDatabase.h:405
CHAR_DEL_CHARACTER
@ CHAR_DEL_CHARACTER
Definition CharacterDatabase.h:446
CHAR_SEL_ITEM_REFUNDS
@ CHAR_SEL_ITEM_REFUNDS
Definition CharacterDatabase.h:131
CHAR_SEL_CHAR_INVENTORY_COUNT_ITEM
@ CHAR_SEL_CHAR_INVENTORY_COUNT_ITEM
Definition CharacterDatabase.h:395
CHAR_DEL_CHAR_SPELL_COOLDOWN
@ CHAR_DEL_CHAR_SPELL_COOLDOWN
Definition CharacterDatabase.h:445
CHAR_SEL_PET_SPELL_COOLDOWN
@ CHAR_SEL_PET_SPELL_COOLDOWN
Definition CharacterDatabase.h:521
CHAR_INS_QUEST_POOL_SAVE
@ CHAR_INS_QUEST_POOL_SAVE
Definition CharacterDatabase.h:34
CHAR_REP_ITEM_INSTANCE
@ CHAR_REP_ITEM_INSTANCE
Definition CharacterDatabase.h:136
CHAR_SEL_CHAR_AT_LOGIN_TITLES
@ CHAR_SEL_CHAR_AT_LOGIN_TITLES
Definition CharacterDatabase.h:386
CHAR_UPD_CHAR_QUESTSTATUS_REWARDED_ACTIVE
@ CHAR_UPD_CHAR_QUESTSTATUS_REWARDED_ACTIVE
Definition CharacterDatabase.h:482
CHAR_UPD_AUCTION_BID
@ CHAR_UPD_AUCTION_BID
Definition CharacterDatabase.h:118
CHAR_DEL_GUILD_RANKS
@ CHAR_DEL_GUILD_RANKS
Definition CharacterDatabase.h:167
CHAR_DEL_CHAR_SOCIAL_BY_GUID
@ CHAR_DEL_CHAR_SOCIAL_BY_GUID
Definition CharacterDatabase.h:433
CHAR_SEL_CHARACTER_GIFT_BY_ITEM
@ CHAR_SEL_CHARACTER_GIFT_BY_ITEM
Definition CharacterDatabase.h:146
CHAR_INS_GUILD_ACHIEVEMENT
@ CHAR_INS_GUILD_ACHIEVEMENT
Definition CharacterDatabase.h:202
CHAR_SEL_CHARACTER_ACHIEVEMENTS
@ CHAR_SEL_CHARACTER_ACHIEVEMENTS
Definition CharacterDatabase.h:102
CHAR_SEL_CHARACTER_ONLINE
@ CHAR_SEL_CHARACTER_ONLINE
Definition CharacterDatabase.h:370
CHAR_SEL_PET_SPELL_LIST
@ CHAR_SEL_PET_SPELL_LIST
Definition CharacterDatabase.h:538
CHAR_UPD_GUILD_EXPERIENCE
@ CHAR_UPD_GUILD_EXPERIENCE
Definition CharacterDatabase.h:209
CHAR_UPD_ADD_CHARACTER_SOCIAL_FLAGS
@ CHAR_UPD_ADD_CHARACTER_SOCIAL_FLAGS
Definition CharacterDatabase.h:359
CHAR_UPD_NAME
@ CHAR_UPD_NAME
Definition CharacterDatabase.h:155
CHAR_DEL_GUILD_ACHIEVEMENT
@ CHAR_DEL_GUILD_ACHIEVEMENT
Definition CharacterDatabase.h:201
CHAR_INS_BLACKMARKET_AUCTION
@ CHAR_INS_BLACKMARKET_AUCTION
Definition CharacterDatabase.h:584
CHAR_DEL_EXPIRED_BANS
@ CHAR_DEL_EXPIRED_BANS
Definition CharacterDatabase.h:36
CHAR_SEL_CHAR_RESEARCH_PROJECTS
@ CHAR_SEL_CHAR_RESEARCH_PROJECTS
Definition CharacterDatabase.h:572
CHAR_DEL_GUILD_ACHIEVEMENT_CRITERIA
@ CHAR_DEL_GUILD_ACHIEVEMENT_CRITERIA
Definition CharacterDatabase.h:203
CHAR_DEL_ALL_GUILD_ACHIEVEMENT_CRITERIA
@ CHAR_DEL_ALL_GUILD_ACHIEVEMENT_CRITERIA
Definition CharacterDatabase.h:206
CHAR_SEL_PINFO_BANS
@ CHAR_SEL_PINFO_BANS
Definition CharacterDatabase.h:380
CHAR_UPD_GROUP_MEMBER_SUBGROUP
@ CHAR_UPD_GROUP_MEMBER_SUBGROUP
Definition CharacterDatabase.h:330
CHAR_SEL_CHAR_ZONE
@ CHAR_SEL_CHAR_ZONE
Definition CharacterDatabase.h:58
CHAR_SEL_CHARACTER_SEASONALQUESTSTATUS
@ CHAR_SEL_CHARACTER_SEASONALQUESTSTATUS
Definition CharacterDatabase.h:83
CHAR_SEL_CHAR_PET_BY_ENTRY_AND_SLOT_2
@ CHAR_SEL_CHAR_PET_BY_ENTRY_AND_SLOT_2
Definition CharacterDatabase.h:543
CHAR_UPD_INSTANCE_RESETTIME
@ CHAR_UPD_INSTANCE_RESETTIME
Definition CharacterDatabase.h:348
CHAR_REP_ACCOUNT_DATA
@ CHAR_REP_ACCOUNT_DATA
Definition CharacterDatabase.h:231
CHAR_INS_ITEM_BOP_TRADE
@ CHAR_INS_ITEM_BOP_TRADE
Definition CharacterDatabase.h:134
CHAR_UDP_CHAR_MONEY
@ CHAR_UDP_CHAR_MONEY
Definition CharacterDatabase.h:465
CHAR_DEL_MAIL_ITEM_BY_ID
@ CHAR_DEL_MAIL_ITEM_BY_ID
Definition CharacterDatabase.h:421
CHAR_DEL_GUILD_RANK
@ CHAR_DEL_GUILD_RANK
Definition CharacterDatabase.h:168
CHAR_DEL_CHAR_REPUTATION_BY_FACTION
@ CHAR_DEL_CHAR_REPUTATION_BY_FACTION
Definition CharacterDatabase.h:409
CHAR_INS_GUILD_BANK_ITEM
@ CHAR_INS_GUILD_BANK_ITEM
Definition CharacterDatabase.h:172
CHAR_INS_CHAR_RESEARCH_HISTORY
@ CHAR_INS_CHAR_RESEARCH_HISTORY
Definition CharacterDatabase.h:570
CHAR_SEL_GUILD_MEMBER
@ CHAR_SEL_GUILD_MEMBER
Definition CharacterDatabase.h:99
CHAR_REP_CHAR_QUESTSTATUS
@ CHAR_REP_CHAR_QUESTSTATUS
Definition CharacterDatabase.h:474
CHAR_SEL_CHARACTER_DECLINEDNAMES
@ CHAR_SEL_CHARACTER_DECLINEDNAMES
Definition CharacterDatabase.h:98
CHAR_INS_CHAR_RESEARCH_PROJECT
@ CHAR_INS_CHAR_RESEARCH_PROJECT
Definition CharacterDatabase.h:573
CHAR_DEL_CHAR_SPELL
@ CHAR_DEL_CHAR_SPELL
Definition CharacterDatabase.h:454
CHAR_DEL_INVALID_ACHIEV_PROGRESS_CRITERIA
@ CHAR_DEL_INVALID_ACHIEV_PROGRESS_CRITERIA
Definition CharacterDatabase.h:340
CHAR_INS_CORPSE
@ CHAR_INS_CORPSE
Definition CharacterDatabase.h:275
CHAR_UPD_CHAR_NAME_AT_LOGIN
@ CHAR_UPD_CHAR_NAME_AT_LOGIN
Definition CharacterDatabase.h:351
CHAR_DEL_CHAR_QUESTSTATUS_REWARDED
@ CHAR_DEL_CHAR_QUESTSTATUS_REWARDED
Definition CharacterDatabase.h:452
CHAR_UPD_GUILD_BANK_TAB_INFO
@ CHAR_UPD_GUILD_BANK_TAB_INFO
Definition CharacterDatabase.h:193
CHAR_INS_GUILD_MEMBER_WITHDRAW
@ CHAR_INS_GUILD_MEMBER_WITHDRAW
Definition CharacterDatabase.h:198
CHAR_INS_PET_AURA
@ CHAR_INS_PET_AURA
Definition CharacterDatabase.h:528
CHAR_INS_CHAR_DECLINED_NAME
@ CHAR_INS_CHAR_DECLINED_NAME
Definition CharacterDatabase.h:426
CHAR_UPD_CHAR_PET_NAME
@ CHAR_UPD_CHAR_PET_NAME
Definition CharacterDatabase.h:547
CHAR_DEL_PETITION_BY_OWNER
@ CHAR_DEL_PETITION_BY_OWNER
Definition CharacterDatabase.h:490
CHAR_SEL_CHARACTER_BANNED
@ CHAR_SEL_CHARACTER_BANNED
Definition CharacterDatabase.h:110
CHAR_UPD_ALL_AT_LOGIN_FLAGS
@ CHAR_UPD_ALL_AT_LOGIN_FLAGS
Definition CharacterDatabase.h:319
CHAR_DEL_GROUP_MEMBER
@ CHAR_DEL_GROUP_MEMBER
Definition CharacterDatabase.h:326
CHAR_INS_ACCOUNT_INSTANCE_LOCK_TIMES
@ CHAR_INS_ACCOUNT_INSTANCE_LOCK_TIMES
Definition CharacterDatabase.h:150
CHAR_DEL_INVALID_ACHIEV_PROGRESS_CRITERIA_GUILD
@ CHAR_DEL_INVALID_ACHIEV_PROGRESS_CRITERIA_GUILD
Definition CharacterDatabase.h:341
CHAR_SEL_GO_RESPAWNS
@ CHAR_SEL_GO_RESPAWNS
Definition CharacterDatabase.h:286
CHAR_DEL_PLAYER_GM_TICKETS
@ CHAR_DEL_PLAYER_GM_TICKETS
Definition CharacterDatabase.h:295
CHAR_DEL_PETITION_BY_OWNER_AND_TYPE
@ CHAR_DEL_PETITION_BY_OWNER_AND_TYPE
Definition CharacterDatabase.h:492
CHAR_DEL_MAIL_ITEMS
@ CHAR_DEL_MAIL_ITEMS
Definition CharacterDatabase.h:456
CHAR_UPD_GROUP_ROLE
@ CHAR_UPD_GROUP_ROLE
Definition CharacterDatabase.h:564
CHAR_DEL_CHAR_INSTANCE
@ CHAR_DEL_CHAR_INSTANCE
Definition CharacterDatabase.h:450
CHAR_INS_ACCOUNT_BATTLE_PET_SLOTS
@ CHAR_INS_ACCOUNT_BATTLE_PET_SLOTS
Definition CharacterDatabase.h:581
CHAR_SEL_CHARACTER_NAME
@ CHAR_SEL_CHARACTER_NAME
Definition CharacterDatabase.h:152
CHAR_SEL_MAIL_ITEMS_BY_ENTRY
@ CHAR_SEL_MAIL_ITEMS_BY_ENTRY
Definition CharacterDatabase.h:401
CHAR_DEL_OLD_CORPSES
@ CHAR_DEL_OLD_CORPSES
Definition CharacterDatabase.h:278
CHAR_INS_ITEM_REFUND_INSTANCE
@ CHAR_INS_ITEM_REFUND_INSTANCE
Definition CharacterDatabase.h:412
CHAR_INS_CHAR_QUESTSTATUS_REWARDED
@ CHAR_INS_CHAR_QUESTSTATUS_REWARDED
Definition CharacterDatabase.h:479
CHAR_UPD_WORLDSTATE
@ CHAR_UPD_WORLDSTATE
Definition CharacterDatabase.h:352
CHAR_UPD_FACTION_OR_RACE
@ CHAR_UPD_FACTION_OR_RACE
Definition CharacterDatabase.h:427
CHAR_UPD_MAIL_ITEM_RECEIVER
@ CHAR_UPD_MAIL_ITEM_RECEIVER
Definition CharacterDatabase.h:129
CHAR_SEL_AUCTIONS
@ CHAR_SEL_AUCTIONS
Definition CharacterDatabase.h:119
CHAR_DEL_LFG_DATA
@ CHAR_DEL_LFG_DATA
Definition CharacterDatabase.h:367
CHAR_DEL_CHAR_ACHIEVEMENT
@ CHAR_DEL_CHAR_ACHIEVEMENT
Definition CharacterDatabase.h:404
CHAR_DEL_BATTLEGROUND_RANDOM
@ CHAR_DEL_BATTLEGROUND_RANDOM
Definition CharacterDatabase.h:70
CHAR_DEL_CHAR_PET_DECLINEDNAME
@ CHAR_DEL_CHAR_PET_DECLINEDNAME
Definition CharacterDatabase.h:545
CHAR_SEL_GUILD_ACHIEVEMENT_CRITERIA
@ CHAR_SEL_GUILD_ACHIEVEMENT_CRITERIA
Definition CharacterDatabase.h:208
CHAR_INS_GUILD_BANK_RIGHT
@ CHAR_INS_GUILD_BANK_RIGHT
Definition CharacterDatabase.h:175
CHAR_SEL_MAIL_COUNT
@ CHAR_SEL_MAIL_COUNT
Definition CharacterDatabase.h:94