Scripts/Pit of Saron: Fixed spawning quest creatures in Pit of Saron

DB/Quests: Fixed quest "The Path to the Citadel"
SQL credits - Tome

1 files changed, 39 insertions, 0 deletions

diff --git a/sql/updates/world/2011_03_18_1_world_instance_pit_of_saron.sql b/sql/updates/world/2011_03_18_1_world_instance_pit_of_saron.sql
new file mode 100644
index 00000000000..64ec58fc315
--- /dev/null
+++ b/sql/updates/world/2011_03_18_1_world_instance_pit_of_saron.sql
@@ -0,0 +1,39 @@
+DELETE FROM `creature_questrelation` WHERE `quest` IN (24510,24499,24498,24710,24711,24506,24511,24682,24507,24712,24713);
+DELETE FROM `creature_involvedrelation` WHERE `quest` IN (24510,24499,24498,24710,24711,24506,24511,24682,24507,24712,24713);
+INSERT INTO `creature_questrelation` (`id`,`quest`) VALUES 
+-- alliance
+(37776,24510),
+(37597,24499),
+(38160,24683),
+(36993,24498),
+(37591,24710),
+(38188,24711),
+-- horde
+(37780,24506),
+(37596,24511),
+(38161,24682),
+(36990,24507),
+(37592,24712),
+(38189,24713);
+INSERT INTO `creature_involvedrelation` (`id`,`quest`) VALUES 
+-- alliance
+(37597,24510),
+(38160,24499),
+(36993,24683),
+(37591,24498),
+(38188,24710),
+(37221,24711),
+-- horde
+(37596,24506),
+(38161,24511),
+(36990,24682),
+(37592,24507),
+(38189,24712),
+(37223,24713);
+
+SET @GOBJ := 201969; -- ball and chain
+UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI' WHERE `entry`=@GOBJ;
+DELETE FROM `smart_scripts` WHERE `source_type`=1 AND `entryorguid`=@GOBJ;
+INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES 
+(@GOBJ,1,0,0,64,0,100,0,0,0,0,0,33,36764,0,0,0,0,0,7,0,0,0,0,0,0,0, 'credit on gossip hello - alliance'),
+(@GOBJ,1,1,0,64,0,100,0,0,0,0,0,33,36770,0,0,0,0,0,7,0,0,0,0,0,0,0, 'credit on gossip hello - horde');