29 PrepareStatement(
WORLD_SEL_CREATURE_TEXT,
"SELECT CreatureID, GroupID, ID, Text, Type, Language, Probability, Emote, Duration, Sound, SoundPlayType, BroadcastTextId, TextRange FROM creature_text",
CONNECTION_SYNCH);
30 PrepareStatement(
WORLD_SEL_SMART_SCRIPTS,
"SELECT entryorguid, source_type, id, link, Difficulties, event_type, event_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, event_param5, event_param_string, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, action_param7, 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);
35 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_INS_NPC_VENDOR,
"INSERT INTO npc_vendor (entry, item, maxcount, incrtime, extendedcost, type) VALUES(?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
46 PrepareStatement(
WORLD_INS_CREATURE_FORMATION,
"INSERT INTO creature_formations (leaderGUID, memberGUID, dist, angle, groupAI) VALUES (?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
48 PrepareStatement(
WORLD_INS_WAYPOINT_PATH_NODE,
"INSERT INTO waypoint_path_node (PathId, NodeId, PositionX, PositionY, PositionZ, Orientation) VALUES (?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
65 PrepareStatement(
WORLD_SEL_CREATURE_TEMPLATE,
"SELECT entry, KillCredit1, KillCredit2, name, femaleName, subname, TitleAlt, IconName, RequiredExpansion, VignetteID, faction, npcflag, speed_walk, speed_run, scale, Classification, dmgschool, BaseAttackTime, RangeAttackTime, BaseVariance, RangeVariance, unit_class, unit_flags, unit_flags2, unit_flags3, family, trainer_class, type, VehicleId, AIName, MovementType, ctm.HoverInitiallyEnabled, ctm.Chase, ctm.Random, ctm.InteractionPauseTimer, ExperienceModifier, RacialLeader, movementId, WidgetSetID, WidgetSetUnitConditionID, RegenHealth, CreatureImmunitiesId, flags_extra, ScriptName, StringId FROM creature_template ct LEFT JOIN creature_template_movement ctm ON ct.entry = ctm.CreatureId WHERE entry = ? OR 1 = ?",
CONNECTION_SYNCH);
67 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)) <= ? ORDER BY order_",
CONNECTION_SYNCH);
68 PrepareStatement(
WORLD_SEL_CREATURE_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 creature WHERE map = ? AND (POW(position_x - ?, 2) + POW(position_y - ?, 2) + POW(position_z - ?, 2)) <= ? ORDER BY order_",
CONNECTION_SYNCH);
69 PrepareStatement(
WORLD_INS_CREATURE,
"INSERT INTO creature (guid, id , map, spawnDifficulties, PhaseId, PhaseGroup, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, wander_distance, currentwaypoint, curhealth, curmana, MovementType, npcflag, unit_flags, unit_flags2, unit_flags3) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
72 PrepareStatement(
WORLD_INS_GAMEOBJECT,
"INSERT INTO gameobject (guid, id, map, spawnDifficulties, PhaseId, PhaseGroup, position_x, position_y, position_z, orientation, rotation0, rotation1, rotation2, rotation3, spawntimesecs, animprogress, state) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
81 PrepareStatement(
WORLD_INS_CONDITION,
"INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
CONNECTION_ASYNC);
@ WORLD_DEL_EVENT_GAMEOBJECT
@ WORLD_SEL_WAYPOINT_PATH_NODE_BY_PATHID
@ WORLD_DEL_SPAWNGROUP_MEMBER
@ WORLD_INS_CREATURE_ADDON
@ MAX_WORLDDATABASE_STATEMENTS
@ WORLD_SEL_CREATURE_ADDON_BY_GUID
@ WORLD_DEL_GAME_EVENT_MODEL_EQUIP
@ WORLD_SEL_WAYPOINT_PATH_NODE_POS_FIRST_BY_PATHID
@ WORLD_UPD_CREATURE_POSITION
@ WORLD_UPD_CREATURE_NPCFLAG
@ WORLD_INS_GRAVEYARD_ZONE
@ WORLD_SEL_GAMEOBJECT_NEAREST
@ WORLD_SEL_NPC_VENDOR_REF
@ WORLD_SEL_CREATURE_NEAREST
@ WORLD_INS_WAYPOINT_PATH_NODE
@ WORLD_REP_LINKED_RESPAWN
@ WORLD_DEL_WAYPOINT_PATH_NODE
@ WORLD_UPD_GAMEOBJECT_ZONE_AREA_DATA
@ WORLD_INS_CREATURE_FORMATION
@ WORLD_UPD_CREATURE_MOVEMENT_TYPE
@ WORLD_UPD_CREATURE_ZONE_AREA_DATA
@ WORLD_UPD_CREATURE_ADDON_PATH
@ WORLD_SEL_WAYPOINT_PATH_BY_PATHID
@ WORLD_DEL_CREATURE_ADDON
@ WORLD_SEL_SMART_SCRIPTS
@ WORLD_UPD_WAYPOINT_PATH_NODE
@ WORLD_UPD_CREATURE_SPAWN_TIME_SECS
@ WORLD_SEL_WAYPOINT_PATH_NODE_MAX_NODEID
@ WORLD_DEL_LINKED_RESPAWN
@ WORLD_SEL_CREATURE_TEMPLATE
@ WORLD_SEL_CREATURE_BY_ID
@ WORLD_DEL_GAME_EVENT_CREATURE
@ WORLD_UPD_WAYPOINT_PATH_NODE_POSITION
@ WORLD_SEL_WAYPOINT_PATH_NODE_MAX_PATHID
@ WORLD_DEL_GAMEOBJECT_ADDON
@ WORLD_SEL_CREATURE_TEXT
@ WORLD_UPD_CREATURE_WANDER_DISTANCE
@ WORLD_SEL_WAYPOINT_PATH_NODE_BY_POS
@ WORLD_SEL_GUILD_REWARDS_REQ_ACHIEVEMENTS
@ WORLD_DEL_GRAVEYARD_ZONE
@ WORLD_SEL_WAYPOINT_PATH_NODE_POS_BY_PATHID
@ WORLD_DEL_LINKED_RESPAWN_MASTER
@ WORLD_SEL_WAYPOINT_PATH_NODE_POS_LAST_BY_PATHID
@ WORLD_UPD_CREATURE_FACTION
void PrepareStatement(uint32 index, std::string_view sql, ConnectionFlags flags)
PreparedStatementContainer m_stmts
PreparedStatements storage.
bool m_reconnecting
Are we reconnecting?
void DoPrepareStatements() override
~WorldDatabaseConnection()
WorldDatabaseConnection(MySQLConnectionInfo &connInfo, ConnectionFlags connectionFlags)