Projekt

Allgemein

Profil

Aktionen
Link kopieren

Fehler #18426

geschlossen

Fehler #16381: [Release] Düsterbruch - Ost - Das Wucherborkenviertel

[NPC] Düsterbruch Eisenborke

Von Adrulex vor mehr als 8 Jahren hinzugefügt. Vor mehr als 8 Jahren aktualisiert.

Status:
Live
Priorität:
Normal
Zugewiesen an:
-
Kategorie:
Kreaturen
Zielversion:
Instanzen - Classic
Beginn:
07.04.2016
DB-Link:
Update Text Deutsch:

Beschreibung

Nach dem Kill vom vorher benötigten Boss Zevrim Dornhuf (https://db.rising-gods.de/?npc=11490) ändert sich der Zustand von Eisenborke (https://db.rising-gods.de/?npc=14241)
Der Befehl zum Öffnen der Tür beim "neuen" Eisenborke ist zwar auswählbar, allerdings passiert danach nichts mehr, sodass Düsterbruch nicht abschließbar ist, weil die Tür zum Weiterkommen verschlossen bleibt.

Aktionen
Link kopieren
 #1

Von Rushor vor mehr als 8 Jahren aktualisiert

  • Thema wurde von Eisenborke - Düsterbruch zu [NPC] Düsterbruch Eisenborke geändert
  • Status wurde von Neu zu Live geändert
  • Zielversion wurde auf Instanzen - Classic gesetzt
  • Übergeordnetes Ticket wurde auf #16381 gesetzt
-- DB/Creature: Ironbark / Ironbark the redeemed
SET @OGUID=35834;
DELETE FROM `gameobject` WHERE `id`=176907;
INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`,  `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
(@OGUID, 176907, 429, 1, 1,  131.3599, -278.9299, -56.00667, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1); -- 176907 (Area: 5913)

UPDATE `creature_template` SET `npcflag`=1,`gossip_menu_id`=5602 WHERE  `entry`IN(11491,14241);

DELETE FROM `creature` WHERE  `guid`=84262; -- Delete the permament spawn of Ironbark the redeemed

DELETE FROM `gossip_menu` WHERE `entry`=5602;
INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES
(5602, 6695); -- 11491

DELETE FROM `gossip_menu_option` WHERE `menu_id`=5602;
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `OptionBroadcastTextID`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`, `BoxBroadcastTextID`) VALUES 
(5602, 0, 0, 'Thank you, Ironbark. We are ready for you to open the door.', 0, 1, 1, 0, 0, 0, 0, '', 0);

DELETE FROM `creature_text` WHERE `entry`=14241;
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES 
(14241, 0, 0, 'At last... Freed from his cursed grasp!', 14, 0, 100, 0, 0, 0, 0, 'Old Ironbark'),
(14241, 1, 0, 'As you wish...', 12, 0, 100, 0, 0, 0, 0,'Old Ironbark'),
(14241, 2, 0, 'My strength wanes, mortal. I have done as promised, the way is clear. I now return to whence I came.', 12, 0, 100, 0, 0, 0, 0, 'Old Ironbark');

DELETE FROM `waypoints` where `entry`=11491;
INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES 
(11491, 1, -46.50295, -268.5359, -57.49783, 'Old Ironbark'),
(11491, 2, -10.61148, -281.6762, -53.74153, 'Old Ironbark'),
(11491, 3, 17.28245, -286.9468, -52.28185, 'Old Ironbark'),
(11491, 4, 51.79745, -270.5228, -53.03123, 'Old Ironbark'),
(11491, 5, 74.17236, -272.7652, -54.82667, 'Old Ironbark'),
(11491, 6, 117.4012, -277.8298, -55.85518, 'Old Ironbark');

UPDATE `creature_template` SET `AIName`='SmartAI' WHERE  `entry`IN(11491,14241);

DELETE FROM `smart_scripts` WHERE `entryorguid`=11491 AND `source_type`=0;
DELETE FROM `smart_scripts` WHERE `entryorguid`=14241 AND `source_type`=0;
DELETE FROM `smart_scripts` WHERE `entryorguid`=11490 AND `source_type`=0 AND `id`=2;

DELETE FROM `smart_scripts` WHERE `entryorguid`=1149100 AND `source_type`=9;
DELETE FROM `smart_scripts` WHERE `entryorguid`=1424100 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 
(11491, 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 81, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Old Ironbark - On Spawn - Set NPC Flags'),
(11491,0,1,2,38,0,100,1,10,10,0,0,36,14241,0,0,0,0,0,1,0,0,0,0,0,0,0,'Old Ironbark - On Data Set 10 10 - Update Template To ''Ironbark the Redeemed'' (No Repeat)'),
(11491, 0, 2, 3, 61, 0, 100, 0, 1, 1, 0, 0, 81, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Old Ironbark - On Data Set - Change Entry'),
(11491, 0, 3, 0, 61, 0, 100, 0, 1, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Old Ironbark - On Data Set - Say Line 0'),
(11491, 0, 4, 5, 62, 0, 100, 0, 5602, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Old Ironbark - On Gossip Option Select - Say Line 1'),
(11491, 0, 5, 6, 61, 0, 100, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Old Ironbark - On Gossip Option Select - Close Gossip'),
(11491, 0, 6, 7, 61, 0, 100, 0, 0, 0, 0, 0, 81, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Old Ironbark - On Gossip Option Select - Set NPC Flags'),
(11491, 0, 7, 0, 61, 0, 100, 0, 0, 0, 0, 0, 53, 0, 11491, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Old Ironbark - On Gossip Option Select - Start WP'),
(11491, 0, 8, 0, 40, 0, 100, 0, 6, 11491, 0, 0, 80, 1149100, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Old Ironbark - On Reached WP6 - Run Script'),
(11490, 0, 2, 0, 6, 0, 100, 0, 0, 0, 0, 0, 34, 3, 3, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Zevrim Thornhoof - On Death - Set Instance Data (Encounter 3 - Done)'),
(1149100, 9, 0, 0, 0, 0, 100, 0, 10000, 10000, 0, 0, 5, 35, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Old Ironbark - Script - Play Emote OneShotAttackUnarmed'),
(1149100, 9, 1, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 5, 35, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Old Ironbark - Script - Play Emote OneShotAttackUnarmed'),
(1149100, 9, 2, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 5, 35, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Old Ironbark - Script - Play Emote OneShotAttackUnarmed'),
(1149100, 9, 3, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 9, 0, 0, 0, 0, 0, 0, 14, @OGUID, 176907, 0, 0, 0, 0, 0, 'Old Ironbark - Script - Activate Game Object'),
(1149100, 9, 4, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Old Ironbark - Script - Say Line 2'),
(1149100, 9, 5, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 90, 7, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Old Ironbark - Script - Set Bytes 1'),
(1149100, 9, 6, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Old Ironbark - Script - Despawn'),
(14241, 0, 4, 5, 62, 0, 100, 0, 5602, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Old Ironbark - On Gossip Option Select - Say Line 1'),
(14241, 0, 5, 6, 61, 0, 100, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Old Ironbark - On Gossip Option Select - Close Gossip'),
(14241, 0, 6, 7, 61, 0, 100, 0, 0, 0, 0, 0, 81, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Old Ironbark - On Gossip Option Select - Set NPC Flags'),
(14241, 0, 7, 0, 61, 0, 100, 0, 0, 0, 0, 0, 53, 0, 11491, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Old Ironbark - On Gossip Option Select - Start WP'),
(14241, 0, 8, 0, 40, 0, 100, 0, 6, 11491, 0, 0, 80, 1424100, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Old Ironbark - On Reached WP6 - Run Script'),
(1424100, 9, 0, 0, 0, 0, 100, 0, 10000, 10000, 0, 0, 5, 35, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Old Ironbark - Script - Play Emote OneShotAttackUnarmed'),
(1424100, 9, 1, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 5, 35, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Old Ironbark - Script - Play Emote OneShotAttackUnarmed'),
(1424100, 9, 2, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 5, 35, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Old Ironbark - Script - Play Emote OneShotAttackUnarmed'),
(1424100, 9, 3, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 9, 0, 0, 0, 0, 0, 0, 14, @OGUID, 176907, 0, 0, 0, 0, 0, 'Old Ironbark - Script - Activate Game Object'),
(1424100, 9, 4, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Old Ironbark - Script - Say Line 2'),
(1424100, 9, 5, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 90, 7, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Old Ironbark - Script - Set Bytes 1'),
(1424100, 9, 6, 0, 0, 0, 100, 0, 6000, 6000, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Old Ironbark - Script - Despawn');

-- Old Ironbark SAI
SET @ENTRY := 11491;
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,11,0,100,0,0,0,0,0,81,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Old Ironbark - On Respawn - Set Npc Flag "),
(@ENTRY,0,1,2,38,0,100,1,10,10,0,0,12,14241,7,0,0,0,0,1,0,0,0,0,0,0,0,"Old Ironbark - On Data Set 10 10 - Summon Creature 'Ironbark the Redeemed' (No Repeat)"),
(@ENTRY,0,2,3,61,0,100,0,10,10,0,0,41,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Old Ironbark - On Data Set 10 10 - Despawn Instant (No Repeat)");

-- Zevrim Thornhoof SAI
SET @ENTRY := 11490;
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,0,0,100,2,5000,9000,20000,26000,11,22478,0,0,0,0,0,5,0,0,0,0,0,0,0,"Zevrim Thornhoof - In Combat - Cast 'Intense Pain' (Normal Dungeon)"),
(@ENTRY,0,1,0,0,0,100,2,9000,12000,15000,18000,11,22651,1,0,0,0,0,5,0,0,0,0,0,0,0,"Zevrim Thornhoof - In Combat - Cast 'Sacrifice' (Normal Dungeon)"),
(@ENTRY,0,2,0,6,0,100,0,0,0,0,0,45,10,10,0,0,0,0,19,11491,1000,0,0,0,0,0,"Zevrim Thornhoof - On Just Died - Set Data 10 10");

UPDATE `gossip_menu_option` SET `OptionBroadcastTextID` = 9103 WHERE `menu_id` = 5602 AND `id` = 0;

UPDATE `creature_text` SET `BroadcastTextId` = 9104 WHERE `entry` = 14241 AND `groupid` = 0;
UPDATE `creature_text` SET `BroadcastTextId` = 9099 WHERE `entry` = 14241 AND `groupid` = 1;
UPDATE `creature_text` SET `BroadcastTextId` = 9100 WHERE `entry` = 14241 AND `groupid` = 2;
UPDATE `creature_template` SET `faction`=35 WHERE  `entry`=14241;

fixed mit dem nächsten crash

Aktionen
Link kopieren

Auch abrufbar als: Atom PDF