MENZ411

Title: Quest Missing Treasure! 49409 Bugtracker Link: https://firestorm-servers.com/us/report/see_report/115120 Patch Content: possible fix for npc "Ned" (129967) in quest "Missing Treasure!" (49409) -- [FS] Quest: 49409 / Missing Treasure! / Script For Ned Only SET @GOSSIP0 := 21861; SET @NPCTEXT0 := 33404; SET @KILLCREDIT := 129967; UPDATE `creature_template` SET `AIName`='SmartAI', `ScriptName`='', `gossip_menu_id`=@GOSSIP0, `npcflag`=`npcflag`|1 WHERE `entry`=129967; DELETE FROM `gossip_menu` WHERE `MenuId` IN (@GOSSIP0+0, @GOSSIP0+1, @GOSSIP0+2); INSERT INTO `gossip_menu` (`MenuId`, `TextId`, `VerifiedBuild`) VALUES (@GOSSIP0+0, @NPCTEXT0+0, 27481), (@GOSSIP0+1, @NPCTEXT0+1, 27481), (@GOSSIP0+2, @NPCTEXT0+2, 27481); DELETE FROM `gossip_menu_option` WHERE `MenuId` IN (@GOSSIP0+0, @GOSSIP0+1, @GOSSIP0+2); INSERT INTO `gossip_menu_option` (`MenuId`, `OptionIndex`, `OptionIcon`, `OptionText`, `OptionBroadcastTextId`, `OptionType`, `OptionNpcFlag`, `VerifiedBuild`) VALUES (@GOSSIP0+0, 0, 0, '<Show the poster.> What do you know about this buried treasure?', 141439, 1, 1, 27481), (@GOSSIP0+1, 0, 0, 'No, no. Buried treasure.', 141444, 1, 1, 27481), (@GOSSIP0+2, 0, 0, 'BURIED. TREASURE.', 141446, 1, 1, 27481); DELETE FROM `gossip_menu_option_action` WHERE `MenuId` IN (@GOSSIP0+0, @GOSSIP0+1, @GOSSIP0+2); INSERT INTO `gossip_menu_option_action` (`MenuId`, `OptionIndex`, `ActionMenuId`, `ActionPoiId`) VALUES (@GOSSIP0+0, 0, @GOSSIP0+1, 0), (@GOSSIP0+1, 0, @GOSSIP0+2, 0), (@GOSSIP0+2, 0, 0, 0); DELETE FROM `smart_scripts` WHERE `entryorguid`=129967 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 (129967, 0, 0, 0, 62, 0, 100, 0, @GOSSIP0+2, 0, 0, 0, 1, 0, 2000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ned - On Gossip Select - Say Line'), (129967, 0, 1, 0, 52, 0, 100, 0, 0, 129967, 0, 0, 1, 1, 2000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ned - On Text Over - Say Line'), (129967, 0, 2, 0, 52, 0, 100, 0, 1, 129967, 0, 0, 1, 2, 2000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ned - On Text Over - Say Line'), (129967, 0, 3, 0, 52, 0, 100, 0, 2, 129967, 0, 0, 33, @KILLCREDIT, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Ned - On Text Over - Killcredit'); DELETE FROM `creature_text` WHERE `CreatureID`=129967; INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES (129967, 0, 0, 'OHHHHH. BURIED TREASURE.', 14, 0, 100, 5, 0, 0, 141440, 0, 'Ned'), (129967, 1, 0, 'NOPE DON\'T KNOW NOTHIN\' \'BOUT A TREASURE.', 14, 0, 100, 274, 0, 0, 141441, 0, 'Ned'), (129967, 2, 0, 'SOME GUY IN THE TAVERN WAS BRAGGIN\' ABOUT MARRIED PLEASURE THE OTHER DAY, THOUGH. LIKE ANYONE WANTS TO HEAR ABOUT THAT.', 14, 0, 100, 6, 0, 0, 141442, 0, 'Ned');