Mar'nah <Alchemist>

Issue #1194 new
AlphaFox created an issue

Not Posible to open the Trading menu

http://www.wowhead.com/npc=24975/marnah#sells

Comments (3)

  1. job bais

    this is due not having proper flags and vendor items in the DB. suggested fix but not tested, values are from 3.3.5 Trinitycore DB..

    UPDATE creature_template` SET `npcflag` = '131' WHERE `entry` =24975;
    
    DELETE FROM `npc_vendor` WHERE `entry` = 24975
    INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES
    (24975, 3371, 0, 0, 0),
    (24975, 3372, 0, 0, 0),
    (24975, 8925, 0, 0, 0),
    (24975, 13467, 3, 9000, 0),
    (24975, 18256, 0, 0, 0),
    (24975, 22785, 3, 9000, 0),
    (24975, 22786, 3, 9000, 0),
    (24975, 22791, 3, 9000, 0),
    (24975, 22793, 1, 9000, 0),
    (24975, 40411, 0, 0, 0);
    

    please test.

  2. AlphaFox reporter
    UPDATE creature_template SET npcflag = "131" WHERE entry ="24975";
    
    DELETE FROM npc_vendor WHERE entry = "24975";
    INSERT INTO npc_vendor (entry, item, maxcount, incrtime, ExtendedCost) VALUES
    (24975, 3371, 0, 0, 0),
    (24975, 3372, 0, 0, 0),
    (24975, 8925, 0, 0, 0),
    (24975, 13467, 3, 9000, 0),
    (24975, 18256, 0, 0, 0),
    (24975, 22785, 3, 9000, 0),
    (24975, 22786, 3, 9000, 0),
    (24975, 22791, 3, 9000, 0),
    (24975, 22793, 1, 9000, 0),
    (24975, 40411, 0, 0, 0);
    

    I have change this query... now works please push to repo

  3. LordUsagi

    We don't ever encapsulate numbers unless with '

    Item 40411 doesn't exist in TBC. But that's just a note for whoever imports this to the repository!

  4. Log in to comment