Welcome to AC Web.
Results 1 to 2 of 2
  1. #1

    [SkyFire] MoP Vendor Fixxes


    REGISTER! (FREE)
    Registered members see less ads
    and also gain access to other great features.
    This fixxes the issues on startup listed below.

    Table `(game_event_)npc_vendor` have data for not creature template (Entry: 63367) without vendor flag, ignore
    Table `(game_event_)npc_vendor` has `maxcount` (1) for item 6365 of vendor (Entry: 67181) but `incrtime`=0, ignore
    Table `(game_event_)npc_vendor` for Vendor (Entry: 70436) have in item list non-existed item (102457, type 1), ignore
    Table `(game_event_)npc_vendor` have data for not creature template (Entry: 72007) without vendor flag, ignore
    Table `(game_event_)npc_vendor` have data for not creature template (Entry: 72993) without vendor flag, ignore
    Table `(game_event_)npc_vendor` have data for not creature template (Entry: 73004) without vendor flag, ignore
    Table `(game_event_)npc_vendor` have data for not creature template (Entry: 73010) without vendor flag, ignore
    Table `(game_event_)npc_vendor` have data for not creature template (Entry: 73305) without vendor flag, ignore
    Table `(game_event_)npc_vendor` have data for not creature template (Entry: 73306) without vendor flag, ignore
    Table `(game_event_)npc_vendor` for Vendor (Entry: 73307) have in item list non-existed item (102463, type 1), ignore
    Table `(game_event_)npc_vendor` have data for not creature template (Entry: 73657) without vendor flag, ignore
    Table `(game_event_)npc_vendor` have data for not creature template (Entry: 73812) without vendor flag, ignore
    Table `(game_event_)npc_vendor` have data for not creature template (Entry: 73819) without vendor flag, ignore
    PHP Code:
    -- NPC ID 63367 Name Brewmaster Boof
    UPDATE 
    `creature_templateSET `minlevel`='82', `maxlevel`='90' WHERE `entry`=63367;
    UPDATE `creature_templateSET `npcflag`='643' WHERE `entry`=63367;

    -- 
    NPC ID 64101 Name Taijing the Zyklon
    UPDATE 
    `creature_templateSET `minlevel`='90', `maxlevel`='90' WHERE `entry`=64101;
    UPDATE `creature_templateSET `npcflag`='643' WHERE `entry`=64101;

    -- 
    NPC ID 72007 Name Master Kukuru
    UPDATE 
    `creature_templateSET `minlevel`='90', `maxlevel`='90' WHERE `entry`=72007;
    UPDATE `creature_templateSET `npcflag`='2176' WHERE `entry`=72007;

    -- 
    NPC ID 72993 Name Lao-Chen the Iron Belly
    UPDATE 
    `creature_templateSET `minlevel`='90', `maxlevel`='90' WHERE `entry`=72993;
    UPDATE `creature_templateSET `npcflag`='643' WHERE `entry`=72993;

    -- 
    NPC ID 73004 Name Brewmaster Blanche
    UPDATE 
    `creature_templateSET `minlevel`='90', `maxlevel`='90' WHERE `entry`=73004;
    UPDATE `creature_templateSET `npcflag`='643' WHERE `entry`=73004;

    -- 
    NPC ID 73010 Name Brother Rabbitsfoot
    UPDATE 
    `creature_templateSET `minlevel`='88', `maxlevel`='88' WHERE `entry`=73010;
    UPDATE `creature_templateSET `npcflag`='643' WHERE `entry`=73010;

    -- 
    NPC ID 73305 Name Mistweaver Ai
    UPDATE 
    `creature_templateSET `minlevel`='89', `maxlevel`='90' WHERE `entry`=73305;
    UPDATE `creature_templateSET `npcflag`='643' WHERE `entry`=73305;

    -- 
    NPC ID 73305 Name Brother Noodle 
    UPDATE 
    `creature_templateSET `minlevel`='90', `maxlevel`='90' WHERE `entry`=73812;
    UPDATE `creature_templateSET `npcflag`='649' WHERE `entry`=73812;

    -- 
    NPC ID 73819 Name Ku-Mo
    UPDATE 
    `creature_templateSET `minlevel`='89', `maxlevel`='89' WHERE `entry`=73819;
    UPDATE `creature_templateSET `npcflag`='128' WHERE `entry`=73819;

    -- 
    Vendor Stuff

    -- Vendor Taijing the Zyklon
    DELETE FROM 
    `npc_vendorWHERE `entry`=64101;
    INSERT INTO `npc_vendorVALUES (641010814140001),
    (
    641010814150001),
    (
    641010746360001),
    (
    641010814060001),
    (
    641010814070001);

    -- 
    Vendor Master Kukuru
    DELETE FROM 
    `npc_vendorWHERE `entry`=72007;
    INSERT INTO `npc_vendorVALUES (7200701015380052111);

    -- 
    Vendor Lao-Chen the Iron Belly
    DELETE FROM 
    `npc_vendorWHERE `entry`=72993;
    INSERT INTO `npc_vendorVALUES (729930814150001),
    (
    7299301057060001),
    (
    729930814070001);

    -- 
    Vendor Brewmaster Blanche
    DELETE FROM 
    `npc_vendorWHERE `entry`=73004;
    INSERT INTO `npc_vendorVALUES (730040814150001),
    (
    7300401057020001),
    (
    730040814070001);

    -- 
    Vendor Brother Rabbitsfoot
    DELETE FROM 
    `npc_vendorWHERE `entry`=73010;
    INSERT INTO `npc_vendorVALUES
    (7301001041400001),
    (
    7301001041410001),
    (
    7301001041420001),
    (
    7301001041430001),
    (
    7301001041440001),
    (
    7301001041450001),
    (
    7301001041460001),
    (
    7301001041480001),
    (
    7301001041490001),
    (
    7301001041500001),
    (
    7301001041510001),
    (
    7301001041520001),
    (
    7301001041530001),
    (
    7301001041540001),
    (
    7301001041550001);

    -- 
    Vendor Chao of the Hundred Crabs
    UPDATE 
    `npc_vendorSET `incrtime`='60000' WHERE `entry`=67181 AND `item`=6365;

    -- 
    Fix Missing Item Timeless Essence of the Black Dragonflight
    DELETE FROM 
    `item_templateWHERE `entry`=102457;
    INSERT INTO `item_template` (`entry`, `name`, `displayid`, `Quality`, `spellid_1`, `description`) VALUES ('102457''Timeless Essence of the Black Dragonflight''125694''1''146428''An undulating sphere of infinite blackness.');

    -- 
    Fix Missing Item Fire-Watcher's Oath
    DELETE FROM `item_template` WHERE `entry`=102463;
    INSERT INTO `item_template` (`entry`, `name`, `displayid`, `Quality`, `class`, `subclass`, `spellid_1`, `spellcooldown_1`, `description`, `Material`, `WDBVerified`) VALUES ('
    102463', 'Fire-Watcher\'s Oath''129132''3''15''4''148429''600000''Ordon Fire-Watchers carry the ashes of their victims in a special pouch that keeps them smouldering.''4''15595');
    -- 
    Fix Mising Item Kukuru's Cache Key
    INSERT INTO `item_template` (`entry`, `class`, `name`, `displayid`, `Quality`, `ItemLevel`, `stackable`, `spellid_1`, `bonding`) VALUES ('
    101538', '13', 'Kukuru\'s Cache Key''75937''3''1''20''144528''1'); 






    More later. Watch SkyFire Repository

  2. #2

    REGISTER! (FREE)
    Registered members see less ads
    and also gain access to other great features.
    Thanks for your work! Really appreciate that!

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •