Jump to content
  • Karazhan NPC ModelID Updates


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

    Karazhan NPC ModelID Updates

    It is currently a giant sausage fest in Karazhan. This query will attach the remaining correct modelIDs that will add women into the mix. This should include all the missing ModelIDs for Karazhan. ModelIDs pulled from TDB 3.3.5.

    [Code]-- Spectral Servant
    UPDATE `creature_template` SET `modelid2`=16465, `modelid3`=16466, `modelid4`=16467 WHERE `entry`=16409;
    -- Phantom Guest
    UPDATE `creature_template` SET `modelid2`=16486, `modelid3`=16487, `modelid4`=16488 WHERE `entry`=16407;
    -- Ghostly Steward
    UPDATE `creature_template` SET `modelid2`=16536, `modelid3`=16537, `modelid4`=16538 WHERE `entry`=16414;
    -- Spectral Chef
    UPDATE `creature_template` SET `modelid2`=16525, `modelid3`=16526, `modelid4`=16527 WHERE `entry`=16411;
    -- Ghostly Baker
    UPDATE `creature_template` SET `modelid2`=16530, `modelid3`=16531, `modelid4`=16532 WHERE `entry`=16412;
    -- Phantom Valet
    UPDATE `creature_template` SET `modelid2`=16495, `modelid3`=16496, `modelid4`=16497 WHERE `entry`=16408;
    -- Spectral Sentry
    UPDATE `creature_template` SET `modelid2`=16459, `modelid3`=16460, `modelid4`=16461 WHERE `entry`=16424;
    -- Wanton Hostess
    UPDATE `creature_template` SET `modelid2`=16544, `modelid3`=16545, `modelid4`=16546 WHERE `entry`=16459;
    -- Concubine
    UPDATE `creature_template` SET `modelid2`=16552, `modelid3`=16553, `modelid4`=16554 WHERE `entry`=16461;
    -- Night Mistress
    UPDATE `creature_template` SET `modelid2`=16548, `modelid3`=16549, `modelid4`=16550 WHERE `entry`=16460;
    -- Spectral Patron
    UPDATE `creature_template` SET `modelid2`=16556, `modelid3`=16557, `modelid4`=16558 WHERE `entry`=16468;
    -- Spectral Performer
    UPDATE `creature_template` SET `modelid2`=16568, `modelid3`=16569, `modelid4`=18979 WHERE `entry`=16473;
    -- Phantom Stagehand
    UPDATE `creature_template` SET `modelid2`=16564, `modelid3`=16565, `modelid4`=16566 WHERE `entry`=16472;
    -- Ghostly Philanthropist
    UPDATE `creature_template` SET `modelid2`=16560, `modelid3`=16561, `modelid4`=16562 WHERE `entry`=16470;
    -- Shadow Pillager
    UPDATE `creature_template` SET `modelid2`=16905, `modelid3`=16906, `modelid4`=16907 WHERE `entry`=16540;
    -- Phantom Attendant
    UPDATE `creature_template` SET `modelid2`=16515, `modelid3`=16516, `modelid4`=16517 WHERE `entry`=16406;
    -- Spectral Retainer
    UPDATE `creature_template` SET `modelid2`=16510, `modelid3`=16511, `modelid4`=16512 WHERE `entry`=16410;
    -- Spectral Stable Hand
    UPDATE `creature_template` SET `modelid2`=16398, `modelid3`=16399, `modelid4`=16400 WHERE `entry`=15551;
    -- Spectral Apprentice
    UPDATE `creature_template` SET `modelid2`=16437, `modelid3`=16440, `modelid4`=16441 WHERE `entry`=16389;


    User Feedback

    Recommended Comments



    Guest
    This is now closed for further comments

×
×
  • 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