#include "MySQLConnection.h"

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_SEL_GAME_EVENTS , WORLD_SEL_GAME_EVENT_PREREQUISITE_DATA , WORLD_SEL_GAME_EVENT_CREATURE_DATA , WORLD_SEL_GAME_EVENT_GAMEOBJECT_DATA , WORLD_SEL_GAME_EVENT_MODEL_EQUIPMENT_DATA , WORLD_SEL_GAME_EVENT_QUEST_DATA , WORLD_SEL_GAME_EVENT_GAMEOBJECT_QUEST_DATA , WORLD_SEL_GAME_EVENT_QUEST_CONDITION_DATA , WORLD_SEL_GAME_EVENT_CONDITION_DATA , WORLD_SEL_GAME_EVENT_NPC_FLAGS , WORLD_SEL_GAME_EVENT_QUEST_SEASONAL_RELATIONS , WORLD_SEL_GAME_EVENT_BATTLEGROUND_DATA , WORLD_SEL_GAME_EVENT_POOL_DATA , WORLD_SEL_GAME_EVENT_ARENA_SEASON , WORLD_SEL_GAME_EVENT_HOLIDAY_DATES , WORLD_DEL_GAME_EVENT_CREATURE , WORLD_DEL_GAME_EVENT_MODEL_EQUIP , WORLD_SEL_GAME_EVENT_NPC_VENDOR , 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 , WORLD_UPD_VERSION , MAX_WORLDDATABASE_STATEMENTS }

Enumeration Type Documentation

◆ WorldDatabaseStatements

enum WorldDatabaseStatements : uint32

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_SEL_GAME_EVENTS
WORLD_SEL_GAME_EVENT_PREREQUISITE_DATA
WORLD_SEL_GAME_EVENT_CREATURE_DATA
WORLD_SEL_GAME_EVENT_GAMEOBJECT_DATA
WORLD_SEL_GAME_EVENT_MODEL_EQUIPMENT_DATA
WORLD_SEL_GAME_EVENT_QUEST_DATA
WORLD_SEL_GAME_EVENT_GAMEOBJECT_QUEST_DATA
WORLD_SEL_GAME_EVENT_QUEST_CONDITION_DATA
WORLD_SEL_GAME_EVENT_CONDITION_DATA
WORLD_SEL_GAME_EVENT_NPC_FLAGS
WORLD_SEL_GAME_EVENT_QUEST_SEASONAL_RELATIONS
WORLD_SEL_GAME_EVENT_BATTLEGROUND_DATA
WORLD_SEL_GAME_EVENT_POOL_DATA
WORLD_SEL_GAME_EVENT_ARENA_SEASON
WORLD_SEL_GAME_EVENT_HOLIDAY_DATES
WORLD_DEL_GAME_EVENT_CREATURE
WORLD_DEL_GAME_EVENT_MODEL_EQUIP
WORLD_SEL_GAME_EVENT_NPC_VENDOR
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
WORLD_UPD_VERSION
MAX_WORLDDATABASE_STATEMENTS

{
    /*  Naming standard for defines:
        {DB}_{SEL/INS/UPD/DEL/REP}_{Summary of data changed}
        When updating more than one field, consider looking at the calling function
        name for a suiting suffix.
    */
 
    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_SEL_GAME_EVENTS,
    WORLD_SEL_GAME_EVENT_PREREQUISITE_DATA,
    WORLD_SEL_GAME_EVENT_CREATURE_DATA,
    WORLD_SEL_GAME_EVENT_GAMEOBJECT_DATA,
    WORLD_SEL_GAME_EVENT_MODEL_EQUIPMENT_DATA,
    WORLD_SEL_GAME_EVENT_QUEST_DATA,
    WORLD_SEL_GAME_EVENT_GAMEOBJECT_QUEST_DATA,
    WORLD_SEL_GAME_EVENT_QUEST_CONDITION_DATA,
    WORLD_SEL_GAME_EVENT_CONDITION_DATA,
    WORLD_SEL_GAME_EVENT_NPC_FLAGS,
    WORLD_SEL_GAME_EVENT_QUEST_SEASONAL_RELATIONS,
    WORLD_SEL_GAME_EVENT_BATTLEGROUND_DATA,
    WORLD_SEL_GAME_EVENT_POOL_DATA,
    WORLD_SEL_GAME_EVENT_ARENA_SEASON,
    WORLD_SEL_GAME_EVENT_HOLIDAY_DATES,
    WORLD_DEL_GAME_EVENT_CREATURE,
    WORLD_DEL_GAME_EVENT_MODEL_EQUIP,
    WORLD_SEL_GAME_EVENT_NPC_VENDOR,
    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,
    WORLD_UPD_VERSION,
 
    MAX_WORLDDATABASE_STATEMENTS
};

Classes

Enumerations

Enumeration Type Documentation

◆ WorldDatabaseStatements