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;
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 accountSign in
Already have an account? Sign in here.
Sign In Now