Jump to content
  • Missing gossip from 8 HFP NPCs (Suggested Fix)


    saben
    • Status: Completed
      Main Category: Database
      Sub-Category: Minor
      Version: 22.1 Milestone: 21 Priority: Normal
      Implemented Version: 21.11

    Missing gossip from 8 HFP NPCs (Suggested Fix)

    Adds sniffed gossip for Forward Commander Maimfist, Apothercary Zelana, Overlord Hun Mainfist, Captain Darkhowl, Grelag, Zezzak, Amilya Airheart and Stone Guard Ambelan.

    -- Adds gossip to Forward Commander Maimfist
    SET @GOSSIP := 7955;
    SET @ENTRY := 19273;
    SET @NPCTEXT := 9771;

    UPDATE `creature_template` SET `GossipMenuID`=@GOSSIP WHERE `entry`=@ENTRY;

    DELETE FROM `gossip_menu` WHERE `entry`=@GOSSIP;
    INSERT INTO `gossip_menu` (`entry`, `text_id`, `script_id`, `condition_id`) VALUES (@GOSSIP, @NPCTEXT, 0, 0);

    -- Adds gossip to Apothecary Zelana
    SET @GOSSIP := 8269;
    SET @ENTRY := 21257;
    SET @NPCTEXT := 10293;

    UPDATE `creature_template` SET `GossipMenuID`=@GOSSIP WHERE `entry`=@ENTRY;

    DELETE FROM `gossip_menu` WHERE `entry`=@GOSSIP;
    INSERT INTO `gossip_menu` (`entry`, `text_id`, `script_id`, `condition_id`) VALUES (@GOSSIP, @NPCTEXT, 0, 0);

    -- Adds gossip to Overlord Hun Maimfist
    SET @GOSSIP := 7335;
    SET @ENTRY := 16576;
    SET @NPCTEXT := 8719;

    UPDATE `creature_template` SET `GossipMenuID`=@GOSSIP WHERE `entry`=@ENTRY;

    DELETE FROM `gossip_menu` WHERE `entry`=@GOSSIP;
    INSERT INTO `gossip_menu` (`entry`, `text_id`, `script_id`, `condition_id`) VALUES (@GOSSIP, @NPCTEXT, 0, 0);

    -- Adds gossip to Captain Darkhowl
    SET @GOSSIP := 8495;
    SET @ENTRY := 22107;
    SET @NPCTEXT := 10610;

    UPDATE `creature_template` SET `GossipMenuID`=@GOSSIP WHERE `entry`=@ENTRY;

    DELETE FROM `gossip_menu` WHERE `entry`=@GOSSIP;
    INSERT INTO `gossip_menu` (`entry`, `text_id`, `script_id`, `condition_id`) VALUES (@GOSSIP, @NPCTEXT, 0, 0);

    -- Adds gossip to Grelag
    SET @GOSSIP := 7348;
    SET @ENTRY := 16858;
    SET @NPCTEXT := 8767;

    UPDATE `creature_template` SET `GossipMenuID`=@GOSSIP WHERE `entry`=@ENTRY;

    DELETE FROM `gossip_menu` WHERE `entry`=@GOSSIP;
    INSERT INTO `gossip_menu` (`entry`, `text_id`, `script_id`, `condition_id`) VALUES (@GOSSIP, @NPCTEXT, 0, 0);

    -- Adds gossip to Zezzak
    SET @GOSSIP := 8505;
    SET @ENTRY := 22231;
    SET @NPCTEXT := 10636;

    UPDATE `creature_template` SET `GossipMenuID`=@GOSSIP WHERE `entry`=@ENTRY;

    DELETE FROM `gossip_menu` WHERE `entry`=@GOSSIP;
    INSERT INTO `gossip_menu` (`entry`, `text_id`, `script_id`, `condition_id`) VALUES (@GOSSIP, @NPCTEXT, 0, 0);

    -- Adds gossip to Amilya Airheart
    SET @GOSSIP := 6944;
    SET @ENTRY := 19558;
    SET @NPCTEXT := 7778;

    UPDATE `creature_template` SET `GossipMenuID`=@GOSSIP WHERE `entry`=@ENTRY;

    DELETE FROM `gossip_menu` WHERE `entry`=@GOSSIP;
    INSERT INTO `gossip_menu` (`entry`, `text_id`, `script_id`, `condition_id`) VALUES (@GOSSIP, @NPCTEXT, 0, 0);

    -- Adds gossip to Stone Guard Ambelan
    SET @GOSSIP := 7958;
    SET @ENTRY := 19332;
    SET @NPCTEXT := 9777;

    UPDATE `creature_template` SET `GossipMenuID`=@GOSSIP WHERE `entry`=@ENTRY;

    DELETE FROM `gossip_menu` WHERE `entry`=@GOSSIP;
    INSERT INTO `gossip_menu` (`entry`, `text_id`, `script_id`, `condition_id`) VALUES (@GOSSIP, @NPCTEXT, 0, 0);


    User Feedback

    Recommended Comments



    Create an account or sign in to comment

    You need to be a member in order to leave a comment

    Create an account

    Sign up for a new account in our community. It's easy!

    Register a new account

    Sign in

    Already have an account? Sign in here.

    Sign In Now

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use