aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/3.3.5/2018_10_04_00_world_335.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_10_04_00_world_335.sql b/sql/updates/world/3.3.5/2018_10_04_00_world_335.sql
new file mode 100644
index 00000000000..e29befc66bc
--- /dev/null
+++ b/sql/updates/world/3.3.5/2018_10_04_00_world_335.sql
@@ -0,0 +1,12 @@
+--
+DELETE FROM `creature` WHERE `guid`=86808;
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`) VALUES
+(86808, 7319, 1, 1, 1, 0, 0, 10980, 1731.3, 1303.1, 5.14113, 120, 5, 0, 0, 0, 1);
+
+DELETE FROM `pool_template` WHERE `entry`=492;
+INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES
+(492,1,"Lady Sathrah");
+DELETE FROM `pool_creature` WHERE `pool_entry`=492;
+INSERT INTO `pool_creature` (`guid`, `pool_entry`, `chance`, `description`) VALUES
+(12596,492,0,"Lady Sathrah - Spawn 1"),
+(86808,492,0,"Lady Sathrah - Spawn 2");