Fehler #37463: [Instanz][Stratholme][NPC] Postmeister Malown - spawnt zu früh - RG Live WotLK 3.3.5a - Der Rising Gods Bugtracker

Aktionen

Link kopieren

Fehler #37463

offen

[Instanz][Stratholme][NPC] Postmeister Malown - spawnt zu früh

Von Lufros vor fast 5 Jahren hinzugefügt. Vor 1 Tag aktualisiert.

Status:

In Bearbeitung

Priorität:

Normal

Zugewiesen an:

Dev-Conan

Kategorie:

Zielversion:

Beginn:

04.03.2020

DB-Link:

https://db.rising-gods.de/?npc=11143

Update Text Deutsch:

Tags:

Creature Instance Stratholme

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.

https://wowwiki.fandom.com/wiki/Postmaster_Malown

Aktionen

Link kopieren

Von Connex vor fast 5 Jahren aktualisiert

Tags wurde von Instance, Stratholme, NPC zu Instance, Stratholme, Creature geändert

Aktionen

Link kopieren

Von Rushor vor fast 5 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

Link kopieren

Von Dev-Conan vor 2 Tagen aktualisiert

Status wurde von Bestätigt zu In Bearbeitung geändert
Zugewiesen an wurde auf Dev-Conan gesetzt

Aktionen

Link kopieren

Auch abrufbar als: Atom PDF

Projekt

Allgemein

Profil

RG Live WotLK 3.3.5a

Benutzerdefinierte Abfragen

Fehler #37463

[Instanz][Stratholme][NPC] Postmeister Malown - spawnt zu früh

Von Connex vor fast 5 Jahren aktualisiert

Von Rushor vor fast 5 Jahren aktualisiert

Von Dev-Conan vor 2 Tagen aktualisiert