aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorZxBiohazardZx <zxbiohazardzx@gmail.com>2011-09-11 23:17:24 +0100
committerNay <dnpd.dd@gmail.com>2011-09-11 23:17:24 +0100
commitdad5b0bb3c1cc0d68c4e8e24a82bc0a851236d1d (patch)
treeb63903cc25995b73c9b5ad885f2e34d04179bfa6 /sql/updates
parent1d38ccaca6c98143e21d78ae2e891d9242c7a48c (diff)
DB/NPC: Spawn npc 25589 and fix some issues in its core script.
Closes #784.
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/2011_09_11_08_world_creature.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/2011_09_11_08_world_creature.sql b/sql/updates/world/2011_09_11_08_world_creature.sql
new file mode 100644
index 00000000000..de608e7cdff
--- /dev/null
+++ b/sql/updates/world/2011_09_11_08_world_creature.sql
@@ -0,0 +1,6 @@
+DELETE FROM `creature` WHERE `id`=25589;
+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
+(2017,25589,571,1,1,0,0,4464.63,5378.07,-15.2737,6.05299,600,0,0,1,0,0);
+DELETE FROM `creature_template_addon` WHERE `entry`=25589;
+INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES
+(25589,0,1,1,0, ''); -- sitting