AzeorthCore 3.3.5a
OpenSource WoW Emulator
Loading...
Searching...
No Matches
WorldDatabase.h File Reference
#include "MySQLConnection.h"

Go to the source code of this file.

Classes

class  WorldDatabaseConnection
 

Enumerations

enum  WorldDatabaseStatements : uint32 {
  WORLD_SEL_QUEST_POOLS ,
  WORLD_DEL_CRELINKED_RESPAWN ,
  WORLD_REP_CREATURE_LINKED_RESPAWN ,
  WORLD_SEL_CREATURE_TEXT ,
  WORLD_SEL_SMART_SCRIPTS ,
  WORLD_SEL_SMARTAI_WP ,
  WORLD_DEL_GAMEOBJECT ,
  WORLD_DEL_EVENT_GAMEOBJECT ,
  WORLD_INS_GRAVEYARD_ZONE ,
  WORLD_DEL_GRAVEYARD_ZONE ,
  WORLD_INS_GAME_TELE ,
  WORLD_DEL_GAME_TELE ,
  WORLD_INS_NPC_VENDOR ,
  WORLD_DEL_NPC_VENDOR ,
  WORLD_SEL_NPC_VENDOR_REF ,
  WORLD_UPD_CREATURE_MOVEMENT_TYPE ,
  WORLD_UPD_CREATURE_FACTION ,
  WORLD_UPD_CREATURE_NPCFLAG ,
  WORLD_UPD_CREATURE_POSITION ,
  WORLD_UPD_CREATURE_WANDER_DISTANCE ,
  WORLD_UPD_CREATURE_SPAWN_TIME_SECS ,
  WORLD_INS_CREATURE_FORMATION ,
  WORLD_INS_WAYPOINT_DATA ,
  WORLD_DEL_WAYPOINT_DATA ,
  WORLD_UPD_WAYPOINT_DATA_POINT ,
  WORLD_UPD_WAYPOINT_DATA_POSITION ,
  WORLD_UPD_WAYPOINT_DATA_WPGUID ,
  WORLD_UPD_WAYPOINT_DATA_ALL_WPGUID ,
  WORLD_SEL_WAYPOINT_DATA_MAX_ID ,
  WORLD_SEL_WAYPOINT_DATA_BY_ID ,
  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_BY_WPGUID ,
  WORLD_SEL_WAYPOINT_DATA_ALL_BY_WPGUID ,
  WORLD_SEL_WAYPOINT_DATA_MAX_POINT ,
  WORLD_SEL_WAYPOINT_DATA_BY_POS ,
  WORLD_SEL_WAYPOINT_DATA_WPGUID_BY_ID ,
  WORLD_SEL_WAYPOINT_DATA_ACTION ,
  WORLD_SEL_WAYPOINT_SCRIPTS_MAX_ID ,
  WORLD_UPD_CREATURE_ADDON_PATH ,
  WORLD_INS_CREATURE_ADDON ,
  WORLD_DEL_CREATURE_ADDON ,
  WORLD_SEL_CREATURE_ADDON_BY_GUID ,
  WORLD_INS_WAYPOINT_SCRIPT ,
  WORLD_DEL_WAYPOINT_SCRIPT ,
  WORLD_UPD_WAYPOINT_SCRIPT_ID ,
  WORLD_UPD_WAYPOINT_SCRIPT_X ,
  WORLD_UPD_WAYPOINT_SCRIPT_Y ,
  WORLD_UPD_WAYPOINT_SCRIPT_Z ,
  WORLD_UPD_WAYPOINT_SCRIPT_O ,
  WORLD_SEL_WAYPOINT_SCRIPT_ID_BY_GUID ,
  WORLD_DEL_CREATURE ,
  WORLD_SEL_COMMANDS ,
  WORLD_SEL_CREATURE_TEMPLATE ,
  WORLD_SEL_WAYPOINT_SCRIPT_BY_ID ,
  WORLD_SEL_ITEM_TEMPLATE_BY_NAME ,
  WORLD_SEL_CREATURE_BY_ID ,
  WORLD_SEL_GAMEOBJECT_NEAREST ,
  WORLD_SEL_CREATURE_NEAREST ,
  WORLD_SEL_GAMEOBJECT_TARGET ,
  WORLD_INS_CREATURE ,
  WORLD_DEL_GAME_EVENT_CREATURE ,
  WORLD_DEL_GAME_EVENT_MODEL_EQUIP ,
  WORLD_INS_GAMEOBJECT ,
  WORLD_SEL_DISABLES ,
  WORLD_INS_DISABLES ,
  WORLD_DEL_DISABLES ,
  WORLD_UPD_CREATURE_ZONE_AREA_DATA ,
  WORLD_UPD_GAMEOBJECT_ZONE_AREA_DATA ,
  WORLD_SEL_REQ_XP ,
  WORLD_INS_GAMEOBJECT_ADDON ,
  MAX_WORLDDATABASE_STATEMENTS
}
 

Enumeration Type Documentation

◆ WorldDatabaseStatements

Enumerator
WORLD_SEL_QUEST_POOLS 
WORLD_DEL_CRELINKED_RESPAWN 
WORLD_REP_CREATURE_LINKED_RESPAWN 
WORLD_SEL_CREATURE_TEXT 
WORLD_SEL_SMART_SCRIPTS 
WORLD_SEL_SMARTAI_WP 
WORLD_DEL_GAMEOBJECT 
WORLD_DEL_EVENT_GAMEOBJECT 
WORLD_INS_GRAVEYARD_ZONE 
WORLD_DEL_GRAVEYARD_ZONE 
WORLD_INS_GAME_TELE 
WORLD_DEL_GAME_TELE 
WORLD_INS_NPC_VENDOR 
WORLD_DEL_NPC_VENDOR 
WORLD_SEL_NPC_VENDOR_REF 
WORLD_UPD_CREATURE_MOVEMENT_TYPE 
WORLD_UPD_CREATURE_FACTION 
WORLD_UPD_CREATURE_NPCFLAG 
WORLD_UPD_CREATURE_POSITION 
WORLD_UPD_CREATURE_WANDER_DISTANCE 
WORLD_UPD_CREATURE_SPAWN_TIME_SECS 
WORLD_INS_CREATURE_FORMATION 
WORLD_INS_WAYPOINT_DATA 
WORLD_DEL_WAYPOINT_DATA 
WORLD_UPD_WAYPOINT_DATA_POINT 
WORLD_UPD_WAYPOINT_DATA_POSITION 
WORLD_UPD_WAYPOINT_DATA_WPGUID 
WORLD_UPD_WAYPOINT_DATA_ALL_WPGUID 
WORLD_SEL_WAYPOINT_DATA_MAX_ID 
WORLD_SEL_WAYPOINT_DATA_BY_ID 
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_BY_WPGUID 
WORLD_SEL_WAYPOINT_DATA_ALL_BY_WPGUID 
WORLD_SEL_WAYPOINT_DATA_MAX_POINT 
WORLD_SEL_WAYPOINT_DATA_BY_POS 
WORLD_SEL_WAYPOINT_DATA_WPGUID_BY_ID 
WORLD_SEL_WAYPOINT_DATA_ACTION 
WORLD_SEL_WAYPOINT_SCRIPTS_MAX_ID 
WORLD_UPD_CREATURE_ADDON_PATH 
WORLD_INS_CREATURE_ADDON 
WORLD_DEL_CREATURE_ADDON 
WORLD_SEL_CREATURE_ADDON_BY_GUID 
WORLD_INS_WAYPOINT_SCRIPT 
WORLD_DEL_WAYPOINT_SCRIPT 
WORLD_UPD_WAYPOINT_SCRIPT_ID 
WORLD_UPD_WAYPOINT_SCRIPT_X 
WORLD_UPD_WAYPOINT_SCRIPT_Y 
WORLD_UPD_WAYPOINT_SCRIPT_Z 
WORLD_UPD_WAYPOINT_SCRIPT_O 
WORLD_SEL_WAYPOINT_SCRIPT_ID_BY_GUID 
WORLD_DEL_CREATURE 
WORLD_SEL_COMMANDS 
WORLD_SEL_CREATURE_TEMPLATE 
WORLD_SEL_WAYPOINT_SCRIPT_BY_ID 
WORLD_SEL_ITEM_TEMPLATE_BY_NAME 
WORLD_SEL_CREATURE_BY_ID 
WORLD_SEL_GAMEOBJECT_NEAREST 
WORLD_SEL_CREATURE_NEAREST 
WORLD_SEL_GAMEOBJECT_TARGET 
WORLD_INS_CREATURE 
WORLD_DEL_GAME_EVENT_CREATURE 
WORLD_DEL_GAME_EVENT_MODEL_EQUIP 
WORLD_INS_GAMEOBJECT 
WORLD_SEL_DISABLES 
WORLD_INS_DISABLES 
WORLD_DEL_DISABLES 
WORLD_UPD_CREATURE_ZONE_AREA_DATA 
WORLD_UPD_GAMEOBJECT_ZONE_AREA_DATA 
WORLD_SEL_REQ_XP 
WORLD_INS_GAMEOBJECT_ADDON 
MAX_WORLDDATABASE_STATEMENTS 
24{
25 /* Naming standard for defines:
26 {DB}_{SEL/INS/UPD/DEL/REP}_{Summary of data changed}
27 When updating more than one field, consider looking at the calling function
28 name for a suiting suffix.
29 */
30
103
105};
@ 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_SEL_GAMEOBJECT_TARGET
Definition: WorldDatabase.h:91
@ 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