Aktionen
Fehler #37463
offen
[Instanz][Stratholme][NPC] Postmeister Malown - spawnt zu früh
Von Lufros vor etwa 4 Jahren hinzugefügt. Vor etwa 4 Jahren aktualisiert.
Status:
Bestätigt
Priorität:
Normal
Zugewiesen an:
-
Kategorie:
-
Zielversion:
-
Beginn:
04.03.2020
Update Text Deutsch:
Tags:
Beschreibung
NPC kann beim zweiten oder sogar ersten Briefkasten spawnen.
Sollte eigentlich erst spawnen, wenn der dritte Briefkasten geöffnet wurde.
When you open the third mailbox you have a key for, Malown spawns with his 3 cronies, making it a 4-elite ambush.
Aktionen
#1
Von Connex vor etwa 4 Jahren aktualisiert
- Tags wurde von Instance, Stratholme, NPC zu Instance, Stratholme, Creature geändert
Aktionen
#2
Von Rushor vor etwa 4 Jahren aktualisiert
fix
diff --git a/sql/winchester_fixes/Instances/Eastern Kingdoms/stratholme.sql b/sql/winchester_fixes/Instances/Eastern Kingdoms/stratholme.sql
new file mode 100644
index 0000000000000000000000000000000000000000..86d6ca106d5106ae4c1d0d1ced80e725521202b2
--- /dev/null
+++ b/sql/winchester_fixes/Instances/Eastern Kingdoms/stratholme.sql
@@ -0,0 +1,180 @@
+-- ------------------------------
+-- Stratholme
+-- ------------------------------
+
+-- Creature Group Abilities
+-- Creature Group Formations
+-- Creature Pathing
+-- Gameobject Spawns
+-- ----------------------------------------------
+-- Gameobject Group Abilities
+-- ----------------------------------------------
+-- GO Fras Siabi's Postbox (176353)
+UPDATE `gameobject_template` SET AIName='SmartGameObjectAI', ScriptName='' WHERE entry=176353;
+-- Fras Siabi's Postbox SAI
+SET @ENTRY := 176353;
+UPDATE `gameobject_template` SET `AIName`="SmartGameObjectAI" WHERE `entry`=@ENTRY;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=1;
+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
+(@ENTRY,1,0,1,70,0,100,257,2,0,0,0,80,@ENTRY*100+00,2,0,0,0,0,1,0,0,0,0,0,0,0,"Fras Siabi's Postbox - On Gameobject State Changed - Run Script (No Repeat)"),
+(@ENTRY,1,1,0,61,0,100,0,0,0,0,0,67,1,8000,8000,0,0,100,1,0,0,0,0,0,0,0,"Fras Siabi's Postbox - On Gameobject State Changed - Create Timed Event (No Repeat)"),
+(@ENTRY,1,2,0,59,0,100,0,1,0,0,0,11,24627,2,0,0,0,0,1,0,0,0,0,0,0,0,"Fras Siabi's Postbox - On Timed Event 1 Triggered - Cast 'Summon Postmaster Malown' with CastFlag: 2 and TriggerFlag: 0 (TargetLimit: 0)");
+
+-- Actionlist SAI
+SET @ENTRY := 17635300;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=9;
+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
+(@ENTRY,9,0,0,0,0,100,0,0,0,0,0,34,26,0,0,0,0,0,1,0,0,0,0,0,0,0,"Fras Siabi's Postbox - On Script - Set Instance Data 26 to 0"),
+(@ENTRY,9,1,0,0,0,100,0,2000,2000,0,0,12,11142,1,300000,0,1,0,8,0,0,0,3493,-3300.28,130.47,0.07,"Fras Siabi's Postbox - On Script - Summon Creature 'Undead Postman'"),
+(@ENTRY,9,2,0,0,0,100,0,0,0,0,0,1,0,0,0,0,1,0,19,11142,50,0,0,0,0,0,"Fras Siabi's Postbox - On Script - Say Line 0"),
+(@ENTRY,9,3,0,0,0,100,0,2000,2000,0,0,12,11142,1,300000,0,1,0,8,0,0,0,3503.16,-3294.9,131.09,4.28,"Fras Siabi's Postbox - On Script - Summon Creature 'Undead Postman'"),
+(@ENTRY,9,4,0,0,0,100,0,2000,2000,0,0,12,11142,1,300000,0,1,0,8,0,0,0,3496.26,-3295.4,130.98,5.34,"Fras Siabi's Postbox - On Script - Summon Creature 'Undead Postman'");
+
+DELETE FROM `conditions` WHERE SourceTypeOrReferenceId=22 AND SourceEntry=176353;
+INSERT INTO `conditions` VALUES(22, 3, 176353, 1, 0, 13, 1, 26, 3, 0, 0, 0, 0, '', 'Run action if GetData(26) == 3');
+
+-- GO Market Row Postbox (176346)
+UPDATE `gameobject_template` SET AIName='SmartGameObjectAI', ScriptName='' WHERE entry=176346;
+-- Market Row Postbox SAI
+SET @ENTRY := 176346;
+UPDATE `gameobject_template` SET `AIName`="SmartGameObjectAI" WHERE `entry`=@ENTRY;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=1;
+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
+(@ENTRY,1,0,1,70,0,100,257,2,0,0,0,80,@ENTRY*100+00,0,0,0,0,0,1,0,0,0,0,0,0,0,"Market Row Postbox - On Gameobject State Changed - Run Script (No Repeat)"),
+(@ENTRY,1,1,0,61,0,100,0,0,0,0,0,67,1,8000,8000,0,0,100,1,0,0,0,0,0,0,0,"Market Row Postbox - On Gameobject State Changed - Create Timed Event (No Repeat)"),
+(@ENTRY,1,2,0,59,0,100,0,1,0,0,0,11,24627,2,0,0,0,0,1,0,0,0,0,0,0,0,"Fras Siabi's Postbox - On Timed Event 1 Triggered - Cast 'Summon Postmaster Malown' with CastFlag: 2 and TriggerFlag: 0 (TargetLimit: 0)");
+-- Actionlist SAI
+SET @ENTRY := 17634600;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=9;
+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
+(@ENTRY,9,0,0,0,0,100,0,0,0,0,0,34,26,0,0,0,0,0,1,0,0,0,0,0,0,0,"Market Row Postbox - On Script - Set Instance Data 26 to 0"),
+(@ENTRY,9,1,0,0,0,100,0,2000,2000,0,0,12,11142,1,300000,0,1,0,8,0,0,0,3675.35,-3395.92,132.86,5.83,"Market Row Postbox - On Script - Summon Creature 'Undead Postman'"),
+(@ENTRY,9,2,0,0,0,100,0,0,0,0,0,1,0,0,0,0,1,0,19,11142,50,0,0,0,0,0,"Market Row Postbox - On Script - Say Line 0"),
+(@ENTRY,9,3,0,0,0,100,0,2000,2000,0,0,12,11142,1,300000,0,1,0,8,0,0,0,3679.93,-3408.58,133.18,1.04,"Market Row Postbox - On Script - Summon Creature 'Undead Postman'"),
+(@ENTRY,9,4,0,0,0,100,0,2000,2000,0,0,12,11142,1,300000,0,1,0,8,0,0,0,3687.89,-3410.59,133.04,1.64,"Market Row Postbox - On Script - Summon Creature 'Undead Postman'");
+
+DELETE FROM `conditions` WHERE SourceTypeOrReferenceId=22 AND SourceEntry=176346;
+INSERT INTO `conditions` VALUES(22, 3, 176346, 1, 0, 13, 1, 26, 3, 0, 0, 0, 0, '', 'Run action if GetData(26) == 3');
+
+-- GO Elders' Square Postbox (176351)
+UPDATE `gameobject_template` SET AIName='SmartGameObjectAI', ScriptName='' WHERE entry=176351;
+-- Elders' Square Postbox SAI
+SET @ENTRY := 176351;
+UPDATE `gameobject_template` SET `AIName`="SmartGameObjectAI" WHERE `entry`=@ENTRY;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=1;
+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
+(@ENTRY,1,0,1,70,0,100,257,2,0,0,0,80,@ENTRY*100+00,0,0,0,0,0,1,0,0,0,0,0,0,0,"Elders' Square Postbox - On Gameobject State Changed - Run Script (No Repeat)"),
+(@ENTRY,1,1,0,61,0,100,0,0,0,0,0,67,1,8000,8000,0,0,100,1,0,0,0,0,0,0,0,"Elders' Square Postbox - On Gameobject State Changed - Create Timed Event (No Repeat)"),
+(@ENTRY,1,2,0,59,0,100,0,1,0,0,0,11,24627,2,0,0,0,0,1,0,0,0,0,0,0,0,"Fras Siabi's Postbox - On Timed Event 1 Triggered - Cast 'Summon Postmaster Malown' with CastFlag: 2 and TriggerFlag: 0 (TargetLimit: 0)");
+-- Actionlist SAI
+SET @ENTRY := 17635100;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=9;
+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
+(@ENTRY,9,0,0,0,0,100,0,0,0,0,0,34,26,0,0,0,0,0,1,0,0,0,0,0,0,0,"Elders' Square Postbox - On Script - Set Instance Data 26 to 0"),
+(@ENTRY,9,1,0,0,0,100,0,2000,2000,0,0,12,11142,1,300000,0,1,0,8,0,0,0,3659.46,-3634.96,138.33,1.28,"Elders' Square Postbox - On Script - Summon Creature 'Undead Postman'"),
+(@ENTRY,9,2,0,0,0,100,0,0,0,0,0,1,0,0,0,0,1,0,19,11142,50,0,0,0,0,0,"Elders' Square Postbox - On Script - Say Line 0"),
+(@ENTRY,9,3,0,0,0,100,0,2000,2000,0,0,12,11142,1,300000,0,1,0,8,0,0,0,3656.25,-3635.08,138.36,1.02,"Elders' Square Postbox - On Script - Summon Creature 'Undead Postman'"),
+(@ENTRY,9,4,0,0,0,100,0,2000,2000,0,0,12,11142,1,300000,0,1,0,8,0,0,0,3661.24,-3621,138.4,3.58,"Elders' Square Postbox - On Script - Summon Creature 'Undead Postman'");
+
+DELETE FROM `conditions` WHERE SourceTypeOrReferenceId=22 AND SourceEntry=176351;
+INSERT INTO `conditions` VALUES(22, 3, 176351, 1, 0, 13, 1, 26, 3, 0, 0, 0, 0, '', 'Run action if GetData(26) == 3');
+
+-- GO Festival Lane Postbox (176350)
+UPDATE `gameobject_template` SET AIName='SmartGameObjectAI', ScriptName='' WHERE entry=176350;
+-- Festival Lane Postbox SAI
+SET @ENTRY := 176350;
+UPDATE `gameobject_template` SET `AIName`="SmartGameObjectAI" WHERE `entry`=@ENTRY;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=1;
+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
+(@ENTRY,1,0,1,70,0,100,257,2,0,0,0,80,@ENTRY*100+00,0,0,0,0,0,1,0,0,0,0,0,0,0,"Festival Lane Postbox - On Gameobject State Changed - Run Script (No Repeat)"),
+(@ENTRY,1,1,0,61,0,100,0,0,0,0,0,67,1,8000,8000,0,0,100,1,0,0,0,0,0,0,0,"Festival Lane Postbox - On Gameobject State Changed - Create Timed Event (No Repeat)"),
+(@ENTRY,1,2,0,59,0,100,0,1,0,0,0,11,24627,2,0,0,0,0,1,0,0,0,0,0,0,0,"Fras Siabi's Postbox - On Timed Event 1 Triggered - Cast 'Summon Postmaster Malown' with CastFlag: 2 and TriggerFlag: 0 (TargetLimit: 0)");
+-- Actionlist SAI
+SET @ENTRY := 17635000;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=9;
+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
+(@ENTRY,9,0,0,0,0,100,0,0,0,0,0,34,26,0,0,0,0,0,1,0,0,0,0,0,0,0,"Festival Lane Postbox - On Script - Set Instance Data 26 to 0"),
+(@ENTRY,9,1,0,0,0,100,0,2000,2000,0,0,12,11142,1,300000,0,1,0,8,0,0,0,3651.67,-3477.88,138.05,5.59,"Festival Lane Postbox - On Script - Summon Creature 'Undead Postman'"),
+(@ENTRY,9,2,0,0,0,100,0,0,0,0,0,1,0,0,0,0,1,0,19,11142,50,0,0,0,0,0,"Festival Lane Postbox - On Script - Say Line 0"),
+(@ENTRY,9,3,0,0,0,100,0,2000,2000,0,0,12,11142,1,300000,0,1,0,8,0,0,0,3657.14,-3475.36,138.7,4.91,"Festival Lane Postbox - On Script - Summon Creature 'Undead Postman'"),
+(@ENTRY,9,4,0,0,0,100,0,2000,2000,0,0,12,11142,1,300000,0,1,0,8,0,0,0,3669.61,-3478.49,137.49,3.39,"Festival Lane Postbox - On Script - Summon Creature 'Undead Postman'");
+DELETE FROM `conditions` WHERE SourceTypeOrReferenceId=22 AND SourceEntry=176350;
+INSERT INTO `conditions` VALUES(22, 3, 176350, 1, 0, 13, 1, 26, 3, 0, 0, 0, 0, '', 'Run action if GetData(26) == 3');
+
+-- GO King's Square Postbox (176352)
+UPDATE `gameobject_template` SET AIName='SmartGameObjectAI', ScriptName='' WHERE entry=176352;
+-- King's Square Postbox SAI
+SET @ENTRY := 176352;
+UPDATE `gameobject_template` SET `AIName`="SmartGameObjectAI" WHERE `entry`=@ENTRY;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=1;
+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
+(@ENTRY,1,0,1,70,0,100,257,2,0,0,0,80,@ENTRY*100+00,0,0,0,0,0,1,0,0,0,0,0,0,0,"King's Square Postbox - On Gameobject State Changed - Run Script (No Repeat)"),
+(@ENTRY,1,1,0,61,0,100,0,0,0,0,0,67,1,8000,8000,0,0,100,1,0,0,0,0,0,0,0,"King's Square Postbox - On Gameobject State Changed - Create Timed Event (No Repeat)"),
+(@ENTRY,1,2,0,59,0,100,0,1,0,0,0,11,24627,2,0,0,0,0,1,0,0,0,0,0,0,0,"Fras Siabi's Postbox - On Timed Event 1 Triggered - Cast 'Summon Postmaster Malown' with CastFlag: 2 and TriggerFlag: 0 (TargetLimit: 0)");
+-- Actionlist SAI
+SET @ENTRY := 17635200;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=9;
+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
+(@ENTRY,9,0,0,0,0,100,0,0,0,0,0,34,26,0,0,0,0,0,1,0,0,0,0,0,0,0,"King's Square Postbox - On Script - Set Instance Data 26 to 0"),
+(@ENTRY,9,1,0,0,0,100,0,2000,2000,0,0,12,11142,1,300000,0,1,0,8,0,0,0,3568.5,-3356.91,131.06,2.07,"King's Square Postbox - On Script - Summon Creature 'Undead Postman'"),
+(@ENTRY,9,2,0,0,0,100,0,0,0,0,0,1,0,0,0,0,1,0,19,11142,50,0,0,0,0,0,"King's Square Postbox - On Script - Say Line 0"),
+(@ENTRY,9,3,0,0,0,100,0,2000,2000,0,0,12,11142,1,300000,0,1,0,8,0,0,0,3570.91,-3351.01,130.57,2.71,"King's Square Postbox - On Script - Summon Creature 'Undead Postman'"),
+(@ENTRY,9,4,0,0,0,100,0,2000,2000,0,0,12,11142,1,300000,0,1,0,8,0,0,0,3562.79,-3353.38,130.78,0.81,"King's Square Postbox - On Script - Summon Creature 'Undead Postman'");
+DELETE FROM `conditions` WHERE SourceTypeOrReferenceId=22 AND SourceEntry=176352;
+INSERT INTO `conditions` VALUES(22, 3, 176352, 1, 0, 13, 1, 26, 3, 0, 0, 0, 0, '', 'Run action if GetData(26) == 3');
+
+-- GO Crusaders' Square Postbox (176349)
+UPDATE `gameobject_template` SET AIName='SmartGameObjectAI', ScriptName='' WHERE entry=176349;
+-- Crusaders' Square Postbox SAI
+SET @ENTRY := 176349;
+UPDATE `gameobject_template` SET `AIName`="SmartGameObjectAI" WHERE `entry`=@ENTRY;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=1;
+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
+(@ENTRY,1,0,1,70,0,100,257,2,0,0,0,80,@ENTRY*100+00,0,0,0,0,0,1,0,0,0,0,0,0,0,"Crusaders' Square Postbox - On Gameobject State Changed - Run Script (No Repeat)"),
+(@ENTRY,1,1,0,61,0,100,0,0,0,0,0,67,1,8000,8000,0,0,100,1,0,0,0,0,0,0,0,"Crusaders' Square Postbox - On Gameobject State Changed - Create Timed Event (No Repeat)"),
+(@ENTRY,1,2,0,59,0,100,0,1,0,0,0,11,24627,2,0,0,0,0,1,0,0,0,0,0,0,0,"Fras Siabi's Postbox - On Timed Event 1 Triggered - Cast 'Summon Postmaster Malown' with CastFlag: 2 and TriggerFlag: 0 (TargetLimit: 0)");
+-- Actionlist SAI
+SET @ENTRY := 17634900;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=9;
+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
+(@ENTRY,9,0,0,0,0,100,0,0,0,0,0,34,26,0,0,0,0,0,1,0,0,0,0,0,0,0,"Crusaders' Square Postbox - On Script - Set Instance Data 26 to 0"),
+(@ENTRY,9,1,0,0,0,100,0,2000,2000,0,0,12,11142,1,300000,0,1,0,8,0,0,0,3664.55,-3176.47,126.42,2.2,"Crusaders' Square Postbox - On Script - Summon Creature 'Undead Postman'"),
+(@ENTRY,9,2,0,0,0,100,0,0,0,0,0,1,0,0,0,0,1,0,19,11142,50,0,0,0,0,0,"Crusaders' Square Postbox - On Script - Say Line 0"),
+(@ENTRY,9,3,0,0,0,100,0,2000,2000,0,0,12,11142,1,300000,0,1,0,8,0,0,0,3656.82,-3160.63,129.03,4.84,"Crusaders' Square Postbox - On Script - Summon Creature 'Undead Postman'"),
+(@ENTRY,9,4,0,0,0,100,0,2000,2000,0,0,12,11142,1,300000,0,1,0,8,0,0,0,3644.62,-3168.25,128.52,5.93,"Crusaders' Square Postbox - On Script - Summon Creature 'Undead Postman'");
+DELETE FROM `conditions` WHERE SourceTypeOrReferenceId=22 AND SourceEntry=176349;
+INSERT INTO `conditions` VALUES(22, 3, 176349, 1, 0, 13, 1, 26, 3, 0, 0, 0, 0, '', 'Run action if GetData(26) == 3');
+
+-- Undead Postman SAI
+SET @ENTRY := 11142;
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0;
+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
+(@ENTRY,0,0,0,1,0,100,0,0,0,5000,5000,49,0,0,0,0,0,0,21,30,0,0,0,0,0,0,"Undead Postman - Out of Combat - Start Attacking"),
+(@ENTRY,0,1,0,0,0,100,0,0,6000,20000,30000,11,5137,0,0,0,0,0,2,0,0,0,0,0,0,0,"Undead Postman - In Combat - Cast 'Call of the Grave'"),
+(@ENTRY,0,2,0,0,0,100,0,2000,9000,11000,19000,11,7713,0,0,0,0,0,1,0,0,0,0,0,0,0,"Undead Postman - In Combat - Cast 'Wailing Dead'");
+
+-- Postmaster Malown (11143)
+UPDATE `creature_template` SET AIName='SmartAI', ScriptName='' WHERE entry=11143;
+-- Postmaster Malown SAI
+SET @ENTRY := 11143;
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0;
+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
+(@ENTRY,0,0,0,1,0,100,0,0,0,5000,5000,49,0,0,0,0,0,0,21,30,0,0,0,0,0,0,"Postmaster Malown - Out of Combat - Start Attacking"),
+(@ENTRY,0,1,0,4,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Postmaster Malown - On Aggro - Say Line 0"),
+(@ENTRY,0,2,0,5,0,100,0,5000,5000,1,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Postmaster Malown - On Killed Unit - Say Line 1"),
+(@ENTRY,0,3,0,0,0,100,0,0,6000,20000,30000,11,6253,0,0,0,0,0,2,0,0,0,0,0,0,0,"Postmaster Malown - In Combat - Cast 'Backhand'"),
+(@ENTRY,0,4,0,0,0,100,0,5000,5000,40000,40000,11,13338,0,0,0,0,0,5,30,0,0,0,0,0,0,"Postmaster Malown - In Combat - Cast 'Curse of Tongues'"),
+(@ENTRY,0,5,0,0,0,100,0,25000,25000,40000,40000,11,12741,0,0,0,0,0,2,0,0,0,0,0,0,0,"Postmaster Malown - In Combat - Cast 'Curse of Weakness'"),
+(@ENTRY,0,6,0,0,0,100,0,0,6000,10000,15000,11,12542,0,0,0,0,0,6,20,0,0,0,0,0,0,"Postmaster Malown - In Combat - Cast 'Fear'");
+
+DELETE FROM `creature_text` WHERE `CreatureID` = 11143;
+INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
+(11143, 0, 0, 'Prepare to be Malowned!', 14, 0, 100, 0, 0, 0, 6504, 0, 'Postmaster Malown - Yell on Aggro'),
+(11143, 0, 1, 'You''ve been MALOWNED!', 14, 0, 100, 0, 0, 0, 6530, 0, 'Postmaster Malown - Yell on Kill');
+
+-- Spell Conditions
+-- Immunities
+-- Bosses
+-- Loot
diff --git a/src/server/scripts/EasternKingdoms/Stratholme/boss_postmaster_malown.cpp b/src/server/scripts/EasternKingdoms/Stratholme/boss_postmaster_malown.cpp
index e27979de6d281622c979b43ae03249e1459442e6..7213f925a1cd1a93827653b5da2ccd157af040f2 100644
--- a/src/server/scripts/EasternKingdoms/Stratholme/boss_postmaster_malown.cpp
+++ b/src/server/scripts/EasternKingdoms/Stratholme/boss_postmaster_malown.cpp
@@ -137,5 +137,5 @@ class boss_postmaster_malown : public CreatureScript
void AddSC_boss_postmaster_malown()
{
- new boss_postmaster_malown();
+ // new boss_postmaster_malown();
}
diff --git a/src/server/scripts/EasternKingdoms/Stratholme/instance_stratholme.cpp b/src/server/scripts/EasternKingdoms/Stratholme/instance_stratholme.cpp
index 23c3f43b9a061309d8eb1fae849b60ca8de14130..bd079850e7e94a0009b93b708d0549da851191cd 100644
--- a/src/server/scripts/EasternKingdoms/Stratholme/instance_stratholme.cpp
+++ b/src/server/scripts/EasternKingdoms/Stratholme/instance_stratholme.cpp
@@ -69,10 +69,12 @@ class instance_stratholme : public InstanceMapScript
timmySpawned = false;
scarletsKilled = 0;
+ _postboxesOpened = 0;
}
uint32 EncounterState[MAX_ENCOUNTER];
uint8 scarletsKilled;
+ uint32 _postboxesOpened;
bool IsSilverHandDead[5];
bool timmySpawned;
@@ -400,6 +402,9 @@ class instance_stratholme : public InstanceMapScript
case TYPE_SH_VICAR:
IsSilverHandDead[4] = (data) ? true : false;
break;
+ case TYPE_MALLOW:
+ ++_postboxesOpened;
+ break;
}
if (data == DONE)
@@ -412,7 +417,7 @@ class instance_stratholme : public InstanceMapScript
std::ostringstream saveStream;
saveStream << EncounterState[0] << ' ' << EncounterState[1] << ' ' << EncounterState[2] << ' '
- << EncounterState[3] << ' ' << EncounterState[4] << ' ' << EncounterState[5];
+ << EncounterState[3] << ' ' << EncounterState[4] << ' ' << EncounterState[5] << ' ' << _postboxesOpened;
OUT_SAVE_INST_DATA_COMPLETE;
return saveStream.str();
@@ -430,7 +435,7 @@ class instance_stratholme : public InstanceMapScript
std::istringstream loadStream(in);
loadStream >> EncounterState[0] >> EncounterState[1] >> EncounterState[2] >> EncounterState[3]
- >> EncounterState[4] >> EncounterState[5];
+ >> EncounterState[4] >> EncounterState[5] >> _postboxesOpened;
// Do not reset 1, 2 and 3. they are not set to done, yet .
if (EncounterState[0] == IN_PROGRESS)
@@ -463,6 +468,8 @@ class instance_stratholme : public InstanceMapScript
return EncounterState[4];
case TYPE_BARON:
return EncounterState[5];
+ case TYPE_MALLOW:
+ return _postboxesOpened;
}
return 0;
}
diff --git a/src/server/scripts/EasternKingdoms/Stratholme/stratholme.h b/src/server/scripts/EasternKingdoms/Stratholme/stratholme.h
index b48f9ff139dcca9a003143c2e96046eca0c48e21..dc9d20bc9d3155f6ddec9cc9636c819410425ec2 100644
--- a/src/server/scripts/EasternKingdoms/Stratholme/stratholme.h
+++ b/src/server/scripts/EasternKingdoms/Stratholme/stratholme.h
@@ -42,7 +42,8 @@ enum STRDataTypes
TYPE_SH_GREGOR = 22,
TYPE_SH_NEMAS = 23,
TYPE_SH_VICAR = 24,
- TYPE_SH_AELMAR = 25
+ TYPE_SH_AELMAR = 25,
+ TYPE_MALLOW = 26
};
enum STRCreatureIds
Aktionen