From 823acba5cb1dd04f2e307fec70e57812fe2e356f Mon Sep 17 00:00:00 2001 From: Vincent-Michael Date: Thu, 10 Jul 2014 00:41:55 +0200 Subject: DB/Creature: Spawn Agatha for first undead quests --- sql/updates/world/2014_07_10_00_world_creature_434.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sql/updates/world/2014_07_10_00_world_creature_434.sql (limited to 'sql') diff --git a/sql/updates/world/2014_07_10_00_world_creature_434.sql b/sql/updates/world/2014_07_10_00_world_creature_434.sql new file mode 100644 index 00000000000..330366581a6 --- /dev/null +++ b/sql/updates/world/2014_07_10_00_world_creature_434.sql @@ -0,0 +1,7 @@ +DELETE FROM `creature_template_addon` WHERE `entry`=49044; +INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES +(49044, 0, 0x3010000, 0x1, '49414'); + +DELETE FROM `creature` WHERE `id`=49044; +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `phaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES +(xxxxxxx, 49044, 0, 1, 1, '', 1700.2, 1703.361, 137.1976, 1.675516, 120, 0, 0); \ No newline at end of file -- cgit v1.2.3