Sign in to follow this  
Followers 0
Tavari

[Declined][Legion/WoD] Timeless-isle Chest fix

Started by Tavari,

3 posts in this topic

Posted (edited)

-- http://www.wowhead.com/timeless-isle#show:treasure 

-- http://www.wowhead.com/object=222684/glinting-sand
DELETE FROM `gameobject_loot_template` WHERE `entry`='222684';
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`,`itembonuses`) VALUES
('222684', '102225', '3', '1', '0', '1', '1','');
UPDATE `gameobject_template` SET `data1`='222684' WHERE `entry`='222684';
 
-- http://www.wowhead.com/object=222689/fiery-altar-of-ordos
DELETE FROM `gameobject_loot_template` WHERE `entry`='222689';
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`,`itembonuses`) VALUES
('222689', '102464', '30', '1', '0', '1', '1','');
UPDATE `gameobject_template` SET `data1`='222689' WHERE `entry`='222689';
 
-- http://www.wowhead.com/object=221673/blazing-chest
DELETE FROM `gameobject_loot_template` WHERE `entry`='221673';
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`,`itembonuses`) VALUES
('221673', '103982', '100', '1', '0', '1', '1',''),
('221673', '102318', '10', '1', '0', '1', '1',''),
('221673', '104347', '10', '1', '0', '1', '1',''),
('221673', '102291', '10', '1', '0', '1', '1',''),
('221673', '102284', '6', '1', '0', '1', '1',''),
('221673', '102264', '6', '1', '0', '1', '1',''),
('221673', '102265', '6', '1', '0', '1', '1',''),
('221673', '102268', '6', '1', '0', '1', '1',''),
('221673', '102290', '5', '1', '0', '1', '1',''),
('221673', '102285', '5', '1', '0', '1', '1',''),
('221673', '102321', '5', '1', '0', '1', '1',''),
('221673', '102286', '5', '1', '0', '1', '1',''),
('221673', '102287', '5', '1', '0', '1', '1',''),
('221673', '102288', '5', '1', '0', '1', '1',''),
('221673', '102289', '5', '1', '0', '1', '1',''),
('221673', '102283', '5', '1', '0', '1', '1',''),
('221673', '102278', '5', '1', '0', '1', '1',''),
('221673', '102277', '5', '1', '0', '1', '1',''),
('221673', '102281', '5', '1', '0', '1', '1',''),
('221673', '102279', '5', '1', '0', '1', '1',''),
('221673', '102280', '5', '1', '0', '1', '1',''),
('221673', '102282', '5', '1', '0', '1', '1',''),
('221673', '102269', '5', '1', '0', '1', '1',''),
('221673', '102320', '5', '1', '0', '1', '1',''),
('221673', '102263', '5', '1', '0', '1', '1',''),
('221673', '102266', '5', '1', '0', '1', '1',''),
('221673', '102267', '5', '1', '0', '1', '1',''),
('221673', '102322', '5', '1', '0', '1', '1',''),
('221673', '102276', '4', '1', '0', '1', '1',''),
('221673', '102323', '4', '1', '0', '1', '1',''),
('221673', '102270', '4', '1', '0', '1', '1',''),
('221673', '102271', '4', '1', '0', '1', '1',''),
('221673', '102272', '4', '1', '0', '1', '1',''),
('221673', '102273', '4', '1', '0', '1', '1',''),
('221673', '102274', '4', '1', '0', '1', '1',''),
('221673', '102275', '4', '1', '0', '1', '1','');
UPDATE `gameobject_template` SET `data1`='221673' WHERE `entry`='221673';
 
-- http://www.wowhead.com/object=220819/spirit-chest
DELETE FROM `gameobject_loot_template` WHERE `entry`='220819';
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`,`itembonuses`) VALUES
('220819', '777', '100', '1', '0', '9', '9','');
UPDATE `gameobject_template` SET `data1`='220819' WHERE `entry`='220819';
 
-- http://www.wowhead.com/object=221036/gleaming-treasure-satchel
DELETE FROM `gameobject_loot_template` WHERE `entry`='221036';
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`,`itembonuses`) VALUES
('221036', '738', '100', '1', '0', '45', '45',''),
('221036', '777', '100', '1', '0', '13', '13','');
UPDATE `gameobject_template` SET `data1`='221036' WHERE `entry`='221036';
 
-- http://www.wowhead.com/object=222685/crane-nest
DELETE FROM `gameobject_loot_template` WHERE `entry`='222685';
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`,`itembonuses`) VALUES
('222685', '104157', '2', '1', '0', '1', '1','');
UPDATE `gameobject_template` SET `data1`='222685' WHERE `entry`='222685';
 
-- http://www.wowhead.com/object=221670/moss-covered-chest
DELETE FROM `gameobject_loot_template` WHERE `entry`='221670';
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`,`itembonuses`) VALUES
('221670', '102318', '3', '1', '0', '1', '1',''),
('221670', '102291', '1.8', '1', '0', '1', '1',''),
('221670', '104347', '1.5', '1', '0', '1', '1',''),
('221670', '102265', '1.1', '1', '0', '1', '1',''),
('221670', '102290', '1', '1', '0', '1', '1',''),
('221670', '102321', '1', '1', '0', '1', '1',''),
('221670', '102287', '1', '1', '0', '1', '1',''),
('221670', '102288', '1', '1', '0', '1', '1',''),
('221670', '102284', '1', '1', '0', '1', '1',''),
('221670', '102289', '1', '1', '0', '1', '1',''),
('221670', '102269', '1', '1', '0', '1', '1',''),
('221670', '102264', '1', '1', '0', '1', '1',''),
('221670', '102320', '1', '1', '0', '1', '1',''),
('221670', '102263', '1', '1', '0', '1', '1',''),
('221670', '102266', '1', '1', '0', '1', '1',''),
('221670', '102267', '1', '1', '0', '1', '1',''),
('221670', '102268', '1', '1', '0', '1', '1',''),
('221670', '102281', '0.9', '1', '0', '1', '1',''),
('221670', '102285', '0.9', '1', '0', '1', '1',''),
('221670', '102286', '0.9', '1', '0', '1', '1',''),
('221670', '102283', '0.9', '1', '0', '1', '1',''),
('221670', '102278', '0.9', '1', '0', '1', '1',''),
('221670', '102322', '0.9', '1', '0', '1', '1',''),
('221670', '102277', '0.9', '1', '0', '1', '1',''),
('221670', '102279', '0.9', '1', '0', '1', '1',''),
('221670', '102280', '0.9', '1', '0', '1', '1',''),
('221670', '102282', '0.9', '1', '0', '1', '1',''),
('221670', '102273', '0.9', '1', '0', '1', '1',''),
('221670', '102272', '0.8', '1', '0', '1', '1',''),
('221670', '102276', '0.8', '1', '0', '1', '1',''),
('221670', '102271', '0.8', '1', '0', '1', '1',''),
('221670', '102323', '0.8', '1', '0', '1', '1',''),
('221670', '102270', '0.8', '1', '0', '1', '1',''),
('221670', '102274', '0.8', '1', '0', '1', '1',''),
('221670', '102275', '0.8', '1', '0', '1', '1',''),
('221670', '104345', '0.4', '1', '0', '1', '1','');
UPDATE `gameobject_template` SET `data1`='221670' WHERE `entry`='221670';
 
-- http://www.wowhead.com/object=222688/firestorm-egg
DELETE FROM `gameobject_loot_template` WHERE `entry`='222688';
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`,`itembonuses`) VALUES
('222688', '104257', '5', '1', '0', '1', '1','');
UPDATE `gameobject_template` SET `data1`='222688' WHERE `entry`='222688';
 
-- http://www.wowhead.com/object=222687/ordon-supplies
DELETE FROM `gameobject_loot_template` WHERE `entry`='222687';
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`,`itembonuses`) VALUES
('222687', '87226', '3', '1', '0', '1', '1',''),
('222687', '74642', '3', '1', '0', '1', '1',''),
('222687', '76081', '3', '1', '0', '1', '1',''),
('222687', '76079', '3', '1', '0', '1', '1',''),
('222687', '76080', '3', '1', '0', '1', '1',''),
('222687', '76078', '3', '1', '0', '1', '1',''),
('222687', '76077', '3', '1', '0', '1', '1',''),
('222687', '76076', '3', '1', '0', '1', '1',''),
('222687', '76075', '3', '1', '0', '1', '1',''),
('222687', '76083', '3', '1', '0', '1', '1','');
UPDATE `gameobject_template` SET `data1`='222687' WHERE `entry`='222687';
 
-- http://www.wowhead.com/object=220902/rope-bound-treasure-chest
DELETE FROM `gameobject_loot_template` WHERE `entry`='220902';
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`,`itembonuses`) VALUES
('220902', '777', '100', '1', '0', '45', '45',''),
('220902', '738', '100', '1', '0', '49', '49','');
UPDATE `gameobject_template` SET `data1`='220902' WHERE `entry`='220902';
 
-- http://www.wowhead.com/object=220908/mist-covered-treasure-chest
DELETE FROM `gameobject_loot_template` WHERE `entry`='220902';
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`,`itembonuses`) VALUES
('220908', '777', '100', '1', '0', '35', '35',''),
('220908', '738', '100', '1', '0', '42', '42','');
UPDATE `gameobject_template` SET `data1`='220908' WHERE `entry`='220908';
 
-- http://www.wowhead.com/object=220986/blackguards-jetsam
DELETE FROM `gameobject_loot_template` WHERE `entry`='220986';
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`,`itembonuses`) VALUES
('220986', '102318', '0.7', '1', '0', '1', '1',''),
('220986', '104347', '0.7', '1', '0', '1', '1',''),
('220986', '102320', '0.6', '1', '0', '1', '1',''),
('220986', '102291', '0.6', '1', '0', '1', '1',''),
('220986', '102288', '0.5', '1', '0', '1', '1',''),
('220986', '102272', '0.5', '1', '0', '1', '1',''),
('220986', '102269', '0.5', '1', '0', '1', '1',''),
('220986', '102268', '0.5', '1', '0', '1', '1',''),
('220986', '102290', '0.4', '1', '0', '1', '1',''),
('220986', '102285', '0.4', '1', '0', '1', '1',''),
('220986', '102321', '0.4', '1', '0', '1', '1',''),
('220986', '102286', '0.4', '1', '0', '1', '1',''),
('220986', '102287', '0.4', '1', '0', '1', '1',''),
('220986', '102284', '0.4', '1', '0', '1', '1',''),
('220986', '102289', '0.4', '1', '0', '1', '1',''),
('220986', '102283', '0.4', '1', '0', '1', '1',''),
('220986', '102278', '0.4', '1', '0', '1', '1',''),
('220986', '102322', '0.4', '1', '0', '1', '1',''),
('220986', '102280', '0.4', '1', '0', '1', '1',''),
('220986', '102281', '0.4', '1', '0', '1', '1',''),
('220986', '102271', '0.4', '1', '0', '1', '1',''),
('220986', '102323', '0.4', '1', '0', '1', '1',''),
('220986', '102270', '0.4', '1', '0', '1', '1',''),
('220986', '102264', '0.4', '1', '0', '1', '1',''),
('220986', '102263', '0.4', '1', '0', '1', '1',''),
('220986', '102265', '0.4', '1', '0', '1', '1',''),
('220986', '102266', '0.4', '1', '0', '1', '1',''),
('220986', '102277', '0.3', '1', '0', '1', '1',''),
('220986', '102279', '0.3', '1', '0', '1', '1',''),
('220986', '102282', '0.3', '1', '0', '1', '1',''),
('220986', '102276', '0.3', '1', '0', '1', '1',''),
('220986', '102273', '0.3', '1', '0', '1', '1',''),
('220986', '102274', '0.3', '1', '0', '1', '1',''),
('220986', '102275', '0.3', '1', '0', '1', '1',''),
('220986', '102267', '0.3', '1', '0', '1', '1','');
UPDATE `gameobject_template` SET `data1`='220986' WHERE `entry`='220986';
 
-- http://www.wowhead.com/object=223116/sturdy-chest
DELETE FROM `gameobject_loot_template` WHERE `entry`='223116';
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`,`itembonuses`) VALUES
('223116', '102318', '4', '1', '0', '1', '1',''),
('223116', '102285', '2', '1', '0', '1', '1',''),
('223116', '102291', '2', '1', '0', '1', '1',''),
('223116', '102279', '1.9', '1', '0', '1', '1',''),
('223116', '102265', '1.8', '1', '0', '1', '1',''),
('223116', '104347', '1.7', '1', '0', '1', '1',''),
('223116', '102281', '1.7', '1', '0', '1', '1',''),
('223116', '102321', '1.6', '1', '0', '1', '1',''),
('223116', '102288', '1.6', '1', '0', '1', '1',''),
('223116', '102277', '1.6', '1', '0', '1', '1',''),
('223116', '102270', '1.6', '1', '0', '1', '1',''),
('223116', '102272', '1.6', '1', '0', '1', '1',''),
('223116', '102263', '1.6', '1', '0', '1', '1',''),
('223116', '102289', '1.6', '1', '0', '1', '1',''),
('223116', '102287', '1.5', '1', '0', '1', '1',''),
('223116', '102289', '1.5', '1', '0', '1', '1',''),
('223116', '102278', '1.5', '1', '0', '1', '1',''),
('223116', '102280', '1.5', '1', '0', '1', '1',''),
('223116', '102276', '1.5', '1', '0', '1', '1',''),
('223116', '102266', '1.5', '1', '0', '1', '1',''),
('223116', '102267', '1.5', '1', '0', '1', '1',''),
('223116', '102290', '1.4', '1', '0', '1', '1',''),
('223116', '102283', '1.4', '1', '0', '1', '1',''),
('223116', '102282', '1.4', '1', '0', '1', '1',''),
('223116', '102273', '1.3', '1', '0', '1', '1',''),
('223116', '102322', '1.3', '1', '0', '1', '1',''),
('223116', '102269', '1.3', '1', '0', '1', '1',''),
('223116', '102286', '1.2', '1', '0', '1', '1',''),
('223116', '102284', '1.2', '1', '0', '1', '1',''),
('223116', '102271', '1.2', '1', '0', '1', '1',''),
('223116', '102274', '1.2', '1', '0', '1', '1',''),
('223116', '102275', '1.2', '1', '0', '1', '1',''),
('223116', '102320', '1.2', '1', '0', '1', '1',''),
('223116', '104345', '1.1', '1', '0', '1', '1',''),
('223116', '102323', '1.1', '1', '0', '1', '1',''),
('223116', '102264', '1.1', '1', '0', '1', '1',''),
('223116', '103982', '0.4', '1', '0', '1', '1','');
UPDATE `gameobject_template` SET `data1`='223116' WHERE `entry`='223116';

 

Edited by Rymnor

Share this post

Link to post
Share on other sites

Posted (edited) 

-- http://www.wowhead.com/object=220908/mist-covered-treasure-chest
DELETE FROM `gameobject_loot_template` WHERE `entry`='220908';
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`,`itembonuses`) VALUES
('220908', '777', '100', '1', '0', '35', '35',''),
('220908', '738', '100', '1', '0', '42', '42','');
UPDATE `gameobject_template` SET `data1`='220908' WHERE `entry`='220908';

have correct the script there was 1 error

Edited by Rymnor

Share this post

Link to post
Share on other sites

Posted 

DELETE FROM `gameobject_loot_template` WHERE `entry`='223116';
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`,`itembonuses`) VALUES
('223116', '102318', '4', '1', '0', '1', '1',''),
('223116', '102285', '2', '1', '0', '1', '1',''),
('223116', '102291', '2', '1', '0', '1', '1',''),
('223116', '102279', '1.9', '1', '0', '1', '1',''),
('223116', '102265', '1.8', '1', '0', '1', '1',''),
('223116', '104347', '1.7', '1', '0', '1', '1',''),
('223116', '102281', '1.7', '1', '0', '1', '1',''),
('223116', '102321', '1.6', '1', '0', '1', '1',''),
('223116', '102288', '1.6', '1', '0', '1', '1',''),
('223116', '102277', '1.6', '1', '0', '1', '1',''),
('223116', '102270', '1.6', '1', '0', '1', '1',''),
('223116', '102272', '1.6', '1', '0', '1', '1',''),
('223116', '102263', '1.6', '1', '0', '1', '1',''),
('223116', '102268', '1.6', '1', '0', '1', '1',''),
('223116', '102287', '1.5', '1', '0', '1', '1',''),
('223116', '102289', '1.5', '1', '0', '1', '1',''),
('223116', '102278', '1.5', '1', '0', '1', '1',''),
('223116', '102280', '1.5', '1', '0', '1', '1',''),
('223116', '102276', '1.5', '1', '0', '1', '1',''),
('223116', '102266', '1.5', '1', '0', '1', '1',''),
('223116', '102267', '1.5', '1', '0', '1', '1',''),
('223116', '102290', '1.4', '1', '0', '1', '1',''),
('223116', '102283', '1.4', '1', '0', '1', '1',''),
('223116', '102282', '1.4', '1', '0', '1', '1',''),
('223116', '102273', '1.3', '1', '0', '1', '1',''),
('223116', '102322', '1.3', '1', '0', '1', '1',''),
('223116', '102269', '1.3', '1', '0', '1', '1',''),
('223116', '102286', '1.2', '1', '0', '1', '1',''),
('223116', '102284', '1.2', '1', '0', '1', '1',''),
('223116', '102271', '1.2', '1', '0', '1', '1',''),
('223116', '102274', '1.2', '1', '0', '1', '1',''),
('223116', '102275', '1.2', '1', '0', '1', '1',''),
('223116', '102320', '1.2', '1', '0', '1', '1',''),
('223116', '104345', '1.1', '1', '0', '1', '1',''),
('223116', '102323', '1.1', '1', '0', '1', '1',''),
('223116', '102264', '1.1', '1', '0', '1', '1',''),
('223116', '103982', '0.4', '1', '0', '1', '1','');
UPDATE `gameobject_template` SET `data1`='223116' WHERE `entry`='223116';

Sorry here was a error 2.

Share this post

Link to post
Share on other sites
Guest
This topic is now closed to further replies.
Sign in to follow this  
Followers 0
Go To Topic Listing Declined