diff options
| author | Killyana <morphone1@gmail.com> | 2020-02-21 22:16:57 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-12-22 00:59:32 +0100 |
| commit | fa6902cd28b7f96c940870596c4d9067b5e2178f (patch) | |
| tree | 8d72c1eab558393ffcd70794fef2b4e2b6833879 | |
| parent | abd6d1e408da1873d572161dd9ea551a3f995301 (diff) | |
DB/Creature: Remove dups and add some missing Ribbon Pole Debug Target
(cherry picked from commit ac6baa547376e09e4527706ee98f586957cea74a)
| -rw-r--r-- | sql/updates/world/master/2021_12_21_32_world_2020_02_21_02_world.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_12_21_32_world_2020_02_21_02_world.sql b/sql/updates/world/master/2021_12_21_32_world_2020_02_21_02_world.sql new file mode 100644 index 00000000000..6a30756e92b --- /dev/null +++ b/sql/updates/world/master/2021_12_21_32_world_2020_02_21_02_world.sql @@ -0,0 +1,10 @@ +-- +DELETE FROM `creature` WHERE `guid` IN (1886, 94839, 94831, 94808, 94805, 94840, 94814, 94803); +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `phaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +( 1886, 17066, 530, 0, 0, '0', 0, 0, 0, -3821.98, -11508.3, -132.124, 0.9075, 180, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(94803, 17066, 530, 0, 0, '0', 0, 0, 0, -2988.84, 4126.660, 11, 3.26329, 180, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(94805, 17066, 571, 0, 0, '0', 0, 0, 0, 3943.700, -620.329, 249, 4.94546, 180, 0, 0, 1, 0, 0, 0, 0, 0, 0), +(94808, 17066, 571, 0, 0, '0', 0, 0, 0, 5151.540, -709.361, 176.093, 2.02988, 180, 0, 0, 1, 0, 0, 0, 0, 0, 0); +DELETE FROM `game_event_creature` WHERE `guid` IN (1886, 94839, 94831, 94808, 94805, 94840, 94814, 94803); +INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES +(1,1886),(1,94803),(1,94805),(1,94808); |