AzerothCore 3.3.5a
OpenSource WoW Emulator
Loading...
Searching...
No Matches
WorldDatabaseConnection Class Reference

#include "WorldDatabase.h"

Inheritance diagram for WorldDatabaseConnection:
MySQLConnection

Public Types

typedef WorldDatabaseStatements Statements
 

Public Member Functions

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

Additional Inherited Members

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

Detailed Description

Member Typedef Documentation

◆ Statements

Constructor & Destructor Documentation

◆ WorldDatabaseConnection() [1/2]

WorldDatabaseConnection::WorldDatabaseConnection ( MySQLConnectionInfo connInfo)
100 : MySQLConnection(connInfo)
101{
102}
Definition: MySQLConnection.h:56

◆ WorldDatabaseConnection() [2/2]

WorldDatabaseConnection::WorldDatabaseConnection ( ProducerConsumerQueue< SQLOperation * > *  q,
MySQLConnectionInfo connInfo 
)
104 : MySQLConnection(q, connInfo)
105{
106}

◆ ~WorldDatabaseConnection()

WorldDatabaseConnection::~WorldDatabaseConnection ( )
override
109{
110}

Member Function Documentation

◆ DoPrepareStatements()

void WorldDatabaseConnection::DoPrepareStatements ( )
overridevirtual

Implements MySQLConnection.

22{
23 if (!m_reconnecting)
25
26 PrepareStatement(WORLD_SEL_QUEST_POOLS, "SELECT entry, pool_entry FROM pool_quest", CONNECTION_SYNCH);
27 PrepareStatement(WORLD_DEL_CRELINKED_RESPAWN, "DELETE FROM linked_respawn WHERE guid = ?", CONNECTION_ASYNC);
28 PrepareStatement(WORLD_REP_CREATURE_LINKED_RESPAWN, "REPLACE INTO linked_respawn (guid, linkedGuid) VALUES (?, ?)", CONNECTION_ASYNC);
29 PrepareStatement(WORLD_SEL_CREATURE_TEXT, "SELECT CreatureID, GroupID, ID, Text, Type, Language, Probability, Emote, Duration, Sound, BroadcastTextId, TextRange FROM creature_text", CONNECTION_SYNCH);
30 PrepareStatement(WORLD_SEL_SMART_SCRIPTS, "SELECT entryorguid, source_type, id, link, event_type, event_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, event_param5, event_param6, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_param4, target_x, target_y, target_z, target_o FROM smart_scripts ORDER BY entryorguid, source_type, id, link", CONNECTION_SYNCH);
31 PrepareStatement(WORLD_SEL_SMARTAI_WP, "SELECT entry, pointid, position_x, position_y, position_z, orientation, delay FROM waypoints ORDER BY entry, pointid", CONNECTION_SYNCH);
32 PrepareStatement(WORLD_DEL_GAMEOBJECT, "DELETE FROM gameobject WHERE guid = ?", CONNECTION_ASYNC);
33 PrepareStatement(WORLD_DEL_EVENT_GAMEOBJECT, "DELETE FROM game_event_gameobject WHERE guid = ?", CONNECTION_ASYNC);
34 PrepareStatement(WORLD_INS_GRAVEYARD_ZONE, "INSERT INTO graveyard_zone (ID, GhostZone, Faction) VALUES (?, ?, ?)", CONNECTION_ASYNC);
35 PrepareStatement(WORLD_DEL_GRAVEYARD_ZONE, "DELETE FROM graveyard_zone WHERE ID = ? AND GhostZone = ? AND Faction = ?", CONNECTION_ASYNC);
36 PrepareStatement(WORLD_INS_GAME_TELE, "INSERT INTO game_tele (id, position_x, position_y, position_z, orientation, map, name) VALUES (?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
37 PrepareStatement(WORLD_DEL_GAME_TELE, "DELETE FROM game_tele WHERE name = ?", CONNECTION_ASYNC);
38 PrepareStatement(WORLD_INS_NPC_VENDOR, "INSERT INTO npc_vendor (entry, item, maxcount, incrtime, extendedcost) VALUES(?, ?, ?, ?, ?)", CONNECTION_ASYNC);
39 PrepareStatement(WORLD_DEL_NPC_VENDOR, "DELETE FROM npc_vendor WHERE entry = ? AND item = ?", CONNECTION_ASYNC);
40 PrepareStatement(WORLD_SEL_NPC_VENDOR_REF, "SELECT item, maxcount, incrtime, ExtendedCost FROM npc_vendor WHERE entry = ? ORDER BY slot ASC", CONNECTION_SYNCH);
41 PrepareStatement(WORLD_UPD_CREATURE_MOVEMENT_TYPE, "UPDATE creature SET MovementType = ? WHERE guid = ?", CONNECTION_ASYNC);
42 PrepareStatement(WORLD_UPD_CREATURE_FACTION, "UPDATE creature_template SET faction = ? WHERE entry = ?", CONNECTION_ASYNC);
43 PrepareStatement(WORLD_UPD_CREATURE_NPCFLAG, "UPDATE creature_template SET npcflag = ? WHERE entry = ?", CONNECTION_ASYNC);
44 PrepareStatement(WORLD_UPD_CREATURE_POSITION, "UPDATE creature SET position_x = ?, position_y = ?, position_z = ?, orientation = ? WHERE guid = ?", CONNECTION_ASYNC);
45 PrepareStatement(WORLD_UPD_CREATURE_WANDER_DISTANCE, "UPDATE creature SET wander_distance = ?, MovementType = ? WHERE guid = ?", CONNECTION_ASYNC);
46 PrepareStatement(WORLD_UPD_CREATURE_SPAWN_TIME_SECS, "UPDATE creature SET spawntimesecs = ? WHERE guid = ?", CONNECTION_ASYNC);
47 PrepareStatement(WORLD_INS_CREATURE_FORMATION, "INSERT INTO creature_formations (leaderGUID, memberGUID, dist, angle, groupAI) VALUES (?, ?, ?, ?, ?)", CONNECTION_ASYNC);
48 PrepareStatement(WORLD_INS_WAYPOINT_DATA, "INSERT INTO waypoint_data (id, point, position_x, position_y, position_z) VALUES (?, ?, ?, ?, ?)", CONNECTION_ASYNC);
49 PrepareStatement(WORLD_DEL_WAYPOINT_DATA, "DELETE FROM waypoint_data WHERE id = ? AND point = ?", CONNECTION_ASYNC);
50 PrepareStatement(WORLD_UPD_WAYPOINT_DATA_POINT, "UPDATE waypoint_data SET point = point - 1 WHERE id = ? AND point > ?", CONNECTION_ASYNC);
51 PrepareStatement(WORLD_UPD_WAYPOINT_DATA_POSITION, "UPDATE waypoint_data SET position_x = ?, position_y = ?, position_z = ? where id = ? AND point = ?", CONNECTION_ASYNC);
52 PrepareStatement(WORLD_UPD_WAYPOINT_DATA_WPGUID, "UPDATE waypoint_data SET wpguid = ? WHERE id = ? and point = ?", CONNECTION_ASYNC);
53 PrepareStatement(WORLD_SEL_WAYPOINT_DATA_MAX_ID, "SELECT MAX(id) FROM waypoint_data", CONNECTION_SYNCH);
54 PrepareStatement(WORLD_SEL_WAYPOINT_DATA_MAX_POINT, "SELECT MAX(point) FROM waypoint_data WHERE id = ?", CONNECTION_SYNCH);
55 PrepareStatement(WORLD_SEL_WAYPOINT_DATA_BY_ID, "SELECT point, position_x, position_y, position_z, orientation, move_type, delay, action, action_chance FROM waypoint_data WHERE id = ? ORDER BY point", CONNECTION_SYNCH);
56 PrepareStatement(WORLD_SEL_WAYPOINT_DATA_POS_BY_ID, "SELECT point, position_x, position_y, position_z FROM waypoint_data WHERE id = ?", CONNECTION_SYNCH);
57 PrepareStatement(WORLD_SEL_WAYPOINT_DATA_POS_FIRST_BY_ID, "SELECT position_x, position_y, position_z FROM waypoint_data WHERE point = 1 AND id = ?", CONNECTION_SYNCH);
58 PrepareStatement(WORLD_SEL_WAYPOINT_DATA_POS_LAST_BY_ID, "SELECT position_x, position_y, position_z, orientation FROM waypoint_data WHERE id = ? ORDER BY point DESC LIMIT 1", CONNECTION_SYNCH);
59 PrepareStatement(WORLD_SEL_WAYPOINT_DATA_BY_WPGUID, "SELECT id, point FROM waypoint_data WHERE wpguid = ?", CONNECTION_SYNCH);
60 PrepareStatement(WORLD_SEL_WAYPOINT_DATA_ALL_BY_WPGUID, "SELECT id, point, delay, move_type, action, action_chance FROM waypoint_data WHERE wpguid = ?", CONNECTION_SYNCH);
61 PrepareStatement(WORLD_UPD_WAYPOINT_DATA_ALL_WPGUID, "UPDATE waypoint_data SET wpguid = 0", CONNECTION_ASYNC);
62 PrepareStatement(WORLD_SEL_WAYPOINT_DATA_BY_POS, "SELECT id, point FROM waypoint_data WHERE (abs(position_x - ?) <= ?) and (abs(position_y - ?) <= ?) and (abs(position_z - ?) <= ?)", CONNECTION_SYNCH);
63 PrepareStatement(WORLD_SEL_WAYPOINT_DATA_WPGUID_BY_ID, "SELECT wpguid FROM waypoint_data WHERE id = ? and wpguid <> 0", CONNECTION_SYNCH);
64 PrepareStatement(WORLD_SEL_WAYPOINT_DATA_ACTION, "SELECT DISTINCT action FROM waypoint_data", CONNECTION_SYNCH);
65 PrepareStatement(WORLD_SEL_WAYPOINT_SCRIPTS_MAX_ID, "SELECT MAX(guid) FROM waypoint_scripts", CONNECTION_SYNCH);
66 PrepareStatement(WORLD_INS_CREATURE_ADDON, "INSERT INTO creature_addon(guid, path_id) VALUES (?, ?)", CONNECTION_ASYNC);
67 PrepareStatement(WORLD_UPD_CREATURE_ADDON_PATH, "UPDATE creature_addon SET path_id = ? WHERE guid = ?", CONNECTION_ASYNC);
68 PrepareStatement(WORLD_DEL_CREATURE_ADDON, "DELETE FROM creature_addon WHERE guid = ?", CONNECTION_ASYNC);
69 PrepareStatement(WORLD_SEL_CREATURE_ADDON_BY_GUID, "SELECT guid FROM creature_addon WHERE guid = ?", CONNECTION_SYNCH);
70 PrepareStatement(WORLD_INS_WAYPOINT_SCRIPT, "INSERT INTO waypoint_scripts (guid) VALUES (?)", CONNECTION_ASYNC);
71 PrepareStatement(WORLD_DEL_WAYPOINT_SCRIPT, "DELETE FROM waypoint_scripts WHERE guid = ?", CONNECTION_ASYNC);
72 PrepareStatement(WORLD_UPD_WAYPOINT_SCRIPT_ID, "UPDATE waypoint_scripts SET id = ? WHERE guid = ?", CONNECTION_ASYNC);
73 PrepareStatement(WORLD_UPD_WAYPOINT_SCRIPT_X, "UPDATE waypoint_scripts SET x = ? WHERE guid = ?", CONNECTION_ASYNC);
74 PrepareStatement(WORLD_UPD_WAYPOINT_SCRIPT_Y, "UPDATE waypoint_scripts SET y = ? WHERE guid = ?", CONNECTION_ASYNC);
75 PrepareStatement(WORLD_UPD_WAYPOINT_SCRIPT_Z, "UPDATE waypoint_scripts SET z = ? WHERE guid = ?", CONNECTION_ASYNC);
76 PrepareStatement(WORLD_UPD_WAYPOINT_SCRIPT_O, "UPDATE waypoint_scripts SET o = ? WHERE guid = ?", CONNECTION_ASYNC);
77 PrepareStatement(WORLD_SEL_WAYPOINT_SCRIPT_ID_BY_GUID, "SELECT id FROM waypoint_scripts WHERE guid = ?", CONNECTION_SYNCH);
78 PrepareStatement(WORLD_DEL_CREATURE, "DELETE FROM creature WHERE guid = ?", CONNECTION_ASYNC);
79 PrepareStatement(WORLD_SEL_COMMANDS, "SELECT name, security, help FROM command", CONNECTION_SYNCH);
80 PrepareStatement(WORLD_SEL_CREATURE_TEMPLATE, "SELECT entry, difficulty_entry_1, difficulty_entry_2, difficulty_entry_3, KillCredit1, KillCredit2, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, faction, npcflag, speed_walk, speed_run, speed_swim, speed_flight, detection_range, scale, `rank`, dmgschool, DamageModifier, BaseAttackTime, RangeAttackTime, BaseVariance, RangeVariance, unit_class, unit_flags, unit_flags2, dynamicflags, family, trainer_type, trainer_spell, trainer_class, trainer_race, type, type_flags, lootid, pickpocketloot, skinloot, PetSpellDataId, VehicleId, mingold, maxgold, AIName, MovementType, ctm.Ground, ctm.Swim, ctm.Flight, ctm.Rooted, ctm.Chase, ctm.Random, ctm.InteractionPauseTimer, HoverHeight, HealthModifier, ManaModifier, ArmorModifier, ExperienceModifier, RacialLeader, movementId, RegenHealth, mechanic_immune_mask, spell_school_immune_mask, flags_extra, ScriptName FROM creature_template ct LEFT JOIN creature_template_movement ctm ON ct.entry = ctm.CreatureId WHERE entry = ?", CONNECTION_SYNCH);
81 PrepareStatement(WORLD_SEL_WAYPOINT_SCRIPT_BY_ID, "SELECT guid, delay, command, datalong, datalong2, dataint, x, y, z, o FROM waypoint_scripts WHERE id = ?", CONNECTION_SYNCH);
82 PrepareStatement(WORLD_SEL_ITEM_TEMPLATE_BY_NAME, "SELECT entry FROM item_template WHERE name = ?", CONNECTION_SYNCH);
83 PrepareStatement(WORLD_SEL_CREATURE_BY_ID, "SELECT guid FROM creature WHERE id1 = ? OR id2 = ? OR id3 = ?", CONNECTION_SYNCH);
84 PrepareStatement(WORLD_SEL_GAMEOBJECT_NEAREST, "SELECT guid, id, position_x, position_y, position_z, map, (POW(position_x - ?, 2) + POW(position_y - ?, 2) + POW(position_z - ?, 2)) AS order_ FROM gameobject WHERE map = ? AND (POW(position_x - ?, 2) + POW(position_y - ?, 2) + POW(position_z - ?, 2)) <= ? AND (phaseMask & ?) <> 0 ORDER BY order_", CONNECTION_SYNCH);
85 PrepareStatement(WORLD_SEL_CREATURE_NEAREST, "SELECT guid, id1, id2, id3, position_x, position_y, position_z, map, (POW(position_x - ?, 2) + POW(position_y - ?, 2) + POW(position_z - ?, 2)) AS order_ FROM creature WHERE map = ? AND (POW(position_x - ?, 2) + POW(position_y - ?, 2) + POW(position_z - ?, 2)) <= ? AND (phaseMask & ?) <> 0 ORDER BY order_", CONNECTION_SYNCH);
86 PrepareStatement(WORLD_INS_CREATURE, "INSERT INTO creature (guid, id1, id2, id3, map, spawnMask, phaseMask, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, wander_distance, currentwaypoint, curhealth, curmana, MovementType, npcflag, unit_flags, dynamicflags) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
87 PrepareStatement(WORLD_DEL_GAME_EVENT_CREATURE, "DELETE FROM game_event_creature WHERE guid = ?", CONNECTION_ASYNC);
88 PrepareStatement(WORLD_DEL_GAME_EVENT_MODEL_EQUIP, "DELETE FROM game_event_model_equip WHERE guid = ?", CONNECTION_ASYNC);
89 PrepareStatement(WORLD_INS_GAMEOBJECT, "INSERT INTO gameobject (guid, id, map, spawnMask, phaseMask, position_x, position_y, position_z, orientation, rotation0, rotation1, rotation2, rotation3, spawntimesecs, animprogress, state) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
90 PrepareStatement(WORLD_INS_DISABLES, "INSERT INTO disables (entry, sourceType, flags, comment) VALUES (?, ?, ?, ?)", CONNECTION_ASYNC);
91 PrepareStatement(WORLD_SEL_DISABLES, "SELECT entry FROM disables WHERE entry = ? AND sourceType = ?", CONNECTION_SYNCH);
92 PrepareStatement(WORLD_DEL_DISABLES, "DELETE FROM disables WHERE entry = ? AND sourceType = ?", CONNECTION_ASYNC);
93 PrepareStatement(WORLD_UPD_CREATURE_ZONE_AREA_DATA, "UPDATE creature SET zoneId = ?, areaId = ? WHERE guid = ?", CONNECTION_ASYNC);
94 PrepareStatement(WORLD_UPD_GAMEOBJECT_ZONE_AREA_DATA, "UPDATE gameobject SET zoneId = ?, areaId = ? WHERE guid = ?", CONNECTION_ASYNC);
95 PrepareStatement(WORLD_INS_GAMEOBJECT_ADDON, "INSERT INTO gameobject_addon (guid, invisibilityType, invisibilityValue) VALUES (?, 0, 0)", CONNECTION_ASYNC);
96 // 0: uint8
97 PrepareStatement(WORLD_SEL_REQ_XP, "SELECT Experience FROM player_xp_for_level WHERE Level = ?", CONNECTION_SYNCH);
98}
@ WORLD_SEL_WAYPOINT_DATA_POS_LAST_BY_ID
Definition: WorldDatabase.h:63
@ WORLD_DEL_EVENT_GAMEOBJECT
Definition: WorldDatabase.h:38
@ WORLD_SEL_WAYPOINT_DATA_BY_WPGUID
Definition: WorldDatabase.h:64
@ WORLD_SEL_WAYPOINT_DATA_ACTION
Definition: WorldDatabase.h:69
@ WORLD_DEL_WAYPOINT_DATA
Definition: WorldDatabase.h:54
@ WORLD_UPD_WAYPOINT_SCRIPT_O
Definition: WorldDatabase.h:81
@ WORLD_INS_WAYPOINT_DATA
Definition: WorldDatabase.h:53
@ WORLD_SEL_WAYPOINT_DATA_POS_FIRST_BY_ID
Definition: WorldDatabase.h:62
@ WORLD_INS_CREATURE_ADDON
Definition: WorldDatabase.h:72
@ MAX_WORLDDATABASE_STATEMENTS
Definition: WorldDatabase.h:104
@ WORLD_SEL_CREATURE_ADDON_BY_GUID
Definition: WorldDatabase.h:74
@ WORLD_DEL_GAME_EVENT_MODEL_EQUIP
Definition: WorldDatabase.h:94
@ WORLD_UPD_CREATURE_POSITION
Definition: WorldDatabase.h:49
@ WORLD_SEL_QUEST_POOLS
Definition: WorldDatabase.h:31
@ WORLD_UPD_CREATURE_NPCFLAG
Definition: WorldDatabase.h:48
@ WORLD_SEL_WAYPOINT_DATA_BY_ID
Definition: WorldDatabase.h:60
@ WORLD_DEL_GAME_TELE
Definition: WorldDatabase.h:42
@ WORLD_SEL_REQ_XP
Definition: WorldDatabase.h:101
@ WORLD_INS_GRAVEYARD_ZONE
Definition: WorldDatabase.h:39
@ WORLD_SEL_GAMEOBJECT_NEAREST
Definition: WorldDatabase.h:89
@ WORLD_UPD_WAYPOINT_DATA_POINT
Definition: WorldDatabase.h:55
@ WORLD_UPD_WAYPOINT_SCRIPT_Z
Definition: WorldDatabase.h:80
@ WORLD_SEL_NPC_VENDOR_REF
Definition: WorldDatabase.h:45
@ WORLD_DEL_DISABLES
Definition: WorldDatabase.h:98
@ WORLD_SEL_CREATURE_NEAREST
Definition: WorldDatabase.h:90
@ WORLD_SEL_SMARTAI_WP
Definition: WorldDatabase.h:36
@ WORLD_INS_GAME_TELE
Definition: WorldDatabase.h:41
@ WORLD_UPD_WAYPOINT_DATA_POSITION
Definition: WorldDatabase.h:56
@ WORLD_UPD_GAMEOBJECT_ZONE_AREA_DATA
Definition: WorldDatabase.h:100
@ WORLD_REP_CREATURE_LINKED_RESPAWN
Definition: WorldDatabase.h:33
@ WORLD_SEL_COMMANDS
Definition: WorldDatabase.h:84
@ WORLD_INS_CREATURE_FORMATION
Definition: WorldDatabase.h:52
@ WORLD_UPD_CREATURE_MOVEMENT_TYPE
Definition: WorldDatabase.h:46
@ WORLD_UPD_CREATURE_ZONE_AREA_DATA
Definition: WorldDatabase.h:99
@ WORLD_SEL_WAYPOINT_DATA_BY_POS
Definition: WorldDatabase.h:67
@ WORLD_UPD_CREATURE_ADDON_PATH
Definition: WorldDatabase.h:71
@ WORLD_DEL_GAMEOBJECT
Definition: WorldDatabase.h:37
@ WORLD_DEL_CREATURE_ADDON
Definition: WorldDatabase.h:73
@ WORLD_SEL_SMART_SCRIPTS
Definition: WorldDatabase.h:35
@ WORLD_UPD_WAYPOINT_SCRIPT_X
Definition: WorldDatabase.h:78
@ WORLD_INS_WAYPOINT_SCRIPT
Definition: WorldDatabase.h:75
@ WORLD_UPD_CREATURE_SPAWN_TIME_SECS
Definition: WorldDatabase.h:51
@ WORLD_SEL_WAYPOINT_DATA_POS_BY_ID
Definition: WorldDatabase.h:61
@ WORLD_SEL_CREATURE_TEMPLATE
Definition: WorldDatabase.h:85
@ WORLD_SEL_CREATURE_BY_ID
Definition: WorldDatabase.h:88
@ WORLD_DEL_GAME_EVENT_CREATURE
Definition: WorldDatabase.h:93
@ WORLD_DEL_WAYPOINT_SCRIPT
Definition: WorldDatabase.h:76
@ WORLD_INS_GAMEOBJECT
Definition: WorldDatabase.h:95
@ WORLD_SEL_WAYPOINT_DATA_WPGUID_BY_ID
Definition: WorldDatabase.h:68
@ WORLD_SEL_WAYPOINT_SCRIPTS_MAX_ID
Definition: WorldDatabase.h:70
@ WORLD_SEL_WAYPOINT_DATA_ALL_BY_WPGUID
Definition: WorldDatabase.h:65
@ WORLD_SEL_ITEM_TEMPLATE_BY_NAME
Definition: WorldDatabase.h:87
@ WORLD_UPD_WAYPOINT_DATA_WPGUID
Definition: WorldDatabase.h:57
@ WORLD_DEL_CREATURE
Definition: WorldDatabase.h:83
@ WORLD_INS_DISABLES
Definition: WorldDatabase.h:97
@ WORLD_SEL_CREATURE_TEXT
Definition: WorldDatabase.h:34
@ WORLD_SEL_WAYPOINT_SCRIPT_BY_ID
Definition: WorldDatabase.h:86
@ WORLD_UPD_CREATURE_WANDER_DISTANCE
Definition: WorldDatabase.h:50
@ WORLD_UPD_WAYPOINT_DATA_ALL_WPGUID
Definition: WorldDatabase.h:58
@ WORLD_SEL_WAYPOINT_SCRIPT_ID_BY_GUID
Definition: WorldDatabase.h:82
@ WORLD_SEL_WAYPOINT_DATA_MAX_ID
Definition: WorldDatabase.h:59
@ WORLD_DEL_NPC_VENDOR
Definition: WorldDatabase.h:44
@ WORLD_INS_NPC_VENDOR
Definition: WorldDatabase.h:43
@ WORLD_SEL_WAYPOINT_DATA_MAX_POINT
Definition: WorldDatabase.h:66
@ WORLD_DEL_GRAVEYARD_ZONE
Definition: WorldDatabase.h:40
@ WORLD_SEL_DISABLES
Definition: WorldDatabase.h:96
@ WORLD_INS_GAMEOBJECT_ADDON
Definition: WorldDatabase.h:102
@ WORLD_UPD_WAYPOINT_SCRIPT_Y
Definition: WorldDatabase.h:79
@ WORLD_DEL_CRELINKED_RESPAWN
Definition: WorldDatabase.h:32
@ WORLD_UPD_WAYPOINT_SCRIPT_ID
Definition: WorldDatabase.h:77
@ WORLD_INS_CREATURE
Definition: WorldDatabase.h:92
@ WORLD_UPD_CREATURE_FACTION
Definition: WorldDatabase.h:47
@ CONNECTION_SYNCH
Definition: MySQLConnection.h:39
@ CONNECTION_ASYNC
Definition: MySQLConnection.h:38
void PrepareStatement(uint32 index, std::string_view sql, ConnectionFlags flags)
Definition: MySQLConnection.cpp:506
PreparedStatementContainer m_stmts
Definition: MySQLConnection.h:106
bool m_reconnecting
PreparedStatements storage.
Definition: MySQLConnection.h:107

References CONNECTION_ASYNC, CONNECTION_SYNCH, MySQLConnection::m_reconnecting, MySQLConnection::m_stmts, MAX_WORLDDATABASE_STATEMENTS, MySQLConnection::PrepareStatement(), WORLD_DEL_CREATURE, WORLD_DEL_CREATURE_ADDON, WORLD_DEL_CRELINKED_RESPAWN, WORLD_DEL_DISABLES, WORLD_DEL_EVENT_GAMEOBJECT, WORLD_DEL_GAME_EVENT_CREATURE, WORLD_DEL_GAME_EVENT_MODEL_EQUIP, WORLD_DEL_GAME_TELE, WORLD_DEL_GAMEOBJECT, WORLD_DEL_GRAVEYARD_ZONE, WORLD_DEL_NPC_VENDOR, WORLD_DEL_WAYPOINT_DATA, WORLD_DEL_WAYPOINT_SCRIPT, WORLD_INS_CREATURE, WORLD_INS_CREATURE_ADDON, WORLD_INS_CREATURE_FORMATION, WORLD_INS_DISABLES, WORLD_INS_GAME_TELE, WORLD_INS_GAMEOBJECT, WORLD_INS_GAMEOBJECT_ADDON, WORLD_INS_GRAVEYARD_ZONE, WORLD_INS_NPC_VENDOR, WORLD_INS_WAYPOINT_DATA, WORLD_INS_WAYPOINT_SCRIPT, WORLD_REP_CREATURE_LINKED_RESPAWN, WORLD_SEL_COMMANDS, WORLD_SEL_CREATURE_ADDON_BY_GUID, WORLD_SEL_CREATURE_BY_ID, WORLD_SEL_CREATURE_NEAREST, WORLD_SEL_CREATURE_TEMPLATE, WORLD_SEL_CREATURE_TEXT, WORLD_SEL_DISABLES, WORLD_SEL_GAMEOBJECT_NEAREST, WORLD_SEL_ITEM_TEMPLATE_BY_NAME, WORLD_SEL_NPC_VENDOR_REF, WORLD_SEL_QUEST_POOLS, WORLD_SEL_REQ_XP, WORLD_SEL_SMART_SCRIPTS, WORLD_SEL_SMARTAI_WP, WORLD_SEL_WAYPOINT_DATA_ACTION, WORLD_SEL_WAYPOINT_DATA_ALL_BY_WPGUID, WORLD_SEL_WAYPOINT_DATA_BY_ID, WORLD_SEL_WAYPOINT_DATA_BY_POS, WORLD_SEL_WAYPOINT_DATA_BY_WPGUID, WORLD_SEL_WAYPOINT_DATA_MAX_ID, WORLD_SEL_WAYPOINT_DATA_MAX_POINT, WORLD_SEL_WAYPOINT_DATA_POS_BY_ID, WORLD_SEL_WAYPOINT_DATA_POS_FIRST_BY_ID, WORLD_SEL_WAYPOINT_DATA_POS_LAST_BY_ID, WORLD_SEL_WAYPOINT_DATA_WPGUID_BY_ID, WORLD_SEL_WAYPOINT_SCRIPT_BY_ID, WORLD_SEL_WAYPOINT_SCRIPT_ID_BY_GUID, WORLD_SEL_WAYPOINT_SCRIPTS_MAX_ID, WORLD_UPD_CREATURE_ADDON_PATH, WORLD_UPD_CREATURE_FACTION, WORLD_UPD_CREATURE_MOVEMENT_TYPE, WORLD_UPD_CREATURE_NPCFLAG, WORLD_UPD_CREATURE_POSITION, WORLD_UPD_CREATURE_SPAWN_TIME_SECS, WORLD_UPD_CREATURE_WANDER_DISTANCE, WORLD_UPD_CREATURE_ZONE_AREA_DATA, WORLD_UPD_GAMEOBJECT_ZONE_AREA_DATA, WORLD_UPD_WAYPOINT_DATA_ALL_WPGUID, WORLD_UPD_WAYPOINT_DATA_POINT, WORLD_UPD_WAYPOINT_DATA_POSITION, WORLD_UPD_WAYPOINT_DATA_WPGUID, WORLD_UPD_WAYPOINT_SCRIPT_ID, WORLD_UPD_WAYPOINT_SCRIPT_O, WORLD_UPD_WAYPOINT_SCRIPT_X, WORLD_UPD_WAYPOINT_SCRIPT_Y, and WORLD_UPD_WAYPOINT_SCRIPT_Z.