Jump to content
  • Scarab Chests in AQ40/AQ20 FIX


    Arkadus
    • Status: Completed
      Main Category: Database
      Sub-Category: Item
      Version: 2.0.11 Milestone: 20 Priority: Low
      Implemented Version: 0.20

    As title describes

    UPDATE `gameobject` SET `spawntimesecs` = 604800 WHERE `id` = 180690;

    REPLACE INTO `gameobject_loot_template`
    (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `condition_id`)
    VALUES
    (180690, 21156, 100, 0, 1, 1, 0),
    (180690, 20874, 20, 0, 1, 1, 0),
    (180690, 20876, 20, 0, 1, 1, 0),
    (180690, 20877, 20, 0, 1, 1, 0),
    (180690, 20878, 20, 0, 1, 1, 0),
    (180690, 20881, 20, 0, 1, 1, 0);

    REPLACE INTO `gameobject_loot_template`
    (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `condition_id`)
    VALUES
    (180691, 21156, 100, 0, 1, 1, 0),
    (180691, 20873, 12.5, 0, 1, 1, 0),
    (180691, 20869, 12.5, 0, 1, 1, 0),
    (180691, 20866, 12.5, 0, 1, 1, 0),
    (180691, 20870, 12.5, 0, 1, 1, 0),
    (180691, 20868, 12.5, 0, 1, 1, 0),
    (180691, 20871, 12.5, 0, 1, 1, 0),
    (180691, 20867, 12.5, 0, 1, 1, 0),
    (180691, 20872, 12.5, 0, 1, 1, 0);

    DELETE FROM `gameobject_loot_template` WHERE `entry` = 17533 OR `entry` = 17532;

    UPDATE `gameobject_template` SET `data1` = 180690 WHERE `entry` = 180690;
    UPDATE `gameobject_template` SET `data1` = 180691 WHERE `entry` = 180691;


    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