DB/Quest: Add spawns for quest 12547.

Closes #895.
Fix a small type in previous commit.

2 files changed, 32 insertions, 1 deletions

diff --git a/sql/updates/world/2011_09_12_00_world_misc.sql b/sql/updates/world/2011_09_12_00_world_misc.sql
index dc71543a499..18ead48b821 100644
--- a/sql/updates/world/2011_09_12_00_world_misc.sql
+++ b/sql/updates/world/2011_09_12_00_world_misc.sql
@@ -58,4 +58,4 @@ INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_
 (@Azuregos, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Spirit of Azuregos - Link 2 say');
 
 -- Not related
-UPDATE `game_event` SET `start_time`='2011-12-04 00:01:00' WHERE eventEntry`=4;
+UPDATE `game_event` SET `start_time`='2011-12-04 00:01:00' WHERE `eventEntry`=4;
diff --git a/sql/updates/world/2011_09_12_01_world_misc.sql b/sql/updates/world/2011_09_12_01_world_misc.sql
new file mode 100644
index 00000000000..f2fa54b1b17
--- /dev/null
+++ b/sql/updates/world/2011_09_12_01_world_misc.sql
@@ -0,0 +1,31 @@
+SET @GUID = 209102;
+
+-- add creatures
+DELETE FROM `creature` WHERE `id` IN (28601, 28602) AND `map`=1;
+INSERT INTO `creature` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`) VALUES
+(@GUID+00,28601, 1, -6027.13, -1249.12, -146.765, 0.0407544),
+(@GUID+01,28602, 1, -6165.74, -1250.34, -162.183, 3.16428),
+(@GUID+02,28602, 1, -6118.16, -1258.77, -143.281, 3.17606),
+(@GUID+03,28602, 1, -6118.18, -1241.33, -143.281, 3.12169),
+(@GUID+04,28602, 1, -6104.87, -1256.41, -143.281, 3.04315),
+(@GUID+05,28602, 1, -6104.56, -1243.58, -143.281, 3.07064),
+(@GUID+06,28602, 1, -6067.35, -1243.76, -143.481, 3.17274),
+(@GUID+07,28602, 1, -6067.17, -1255.45, -143.430, 3.15703),
+(@GUID+08,28602, 1, -6038.16, -1243.56, -146.897, 3.15153),
+(@GUID+09,28602, 1, -6036.82, -1255.32, -146.901, 3.19238),
+(@GUID+10,28602, 1, -6042.26, -1249.25, -146.887, 3.19238);
+
+-- add weapons to creatures
+DELETE FROM `creature_equip_template` WHERE `entry`=2476;
+INSERT INTO `creature_equip_template` VALUES 
+(2476, 7714, 0, 0);
+
+-- correct creature_template
+UPDATE `creature_template` SET `faction_A` = 2080, `faction_H` = 2080, `lootid` = `entry` WHERE `entry` IN (28601, 28602);
+UPDATE `creature_template` SET `equipment_id` = 1803 WHERE `entry`=28601;
+UPDATE `creature_template` SET `equipment_id` = 2476 WHERE `entry`=28601;
+
+-- create questloot
+DELETE FROM `creature_loot_template` WHERE `entry`=28601;
+INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
+(28601, 38708, -100, 1, 0, 1, 1);