Skip to content

Instantly share code, notes, and snippets.

@Kronovere
Kronovere / Wingrest_Embassy_File_Elementals.sql
Last active May 12, 2026 05:27
Wingrest Embassy File Elementals
-- Configure these to the numbers you want to use
SET @CGUID := 0;
SET @WAYPOINTID := 0;
-- Base spawn data for the creatures here
DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+66;
INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curHealthPct`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `ScriptName`, `StringId`, `VerifiedBuild`) VALUES
(@CGUID+0, 187321, 2444, 13644, 13939, '0', 0, 0, 0, -1, 0, 0, 3503.23, -1324.2, 103.915, 6.21176, 300, 0, 0, 100, 0, NULL, NULL, NULL, NULL, '', NULL, 67451),
(@CGUID+1, 187321, 2444, 13644, 13939, '0', 0, 0, 0, -1, 0, 0, 3474.28, -1324.03, 103.819, 0.566772, 300, 0, 0, 100, 2, NULL, NULL, NULL, NULL, '', NULL, 67451),
(@CGUID+2, 187321, 2444, 13644, 13939, '0', 0, 0, 0, -1, 0, 0, 3424.79, -1380.8