diff options
| author | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2012-05-19 23:23:16 +0200 |
|---|---|---|
| committer | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2012-05-19 23:23:16 +0200 |
| commit | 0dd97dfcb62d91ed132789532623f5c2f164a608 (patch) | |
| tree | a524b679eaacea263c941e66a2d76ff17357ebca | |
| parent | c4a98cb04129f70e1aaf5c80a7eeb0f16569e5b9 (diff) | |
DB/Loot: fix the last startups related to loot. this should be all...
| -rw-r--r-- | sql/updates/world/2012_05_19_06_gameobject_loot_template.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/world/2012_05_19_06_gameobject_loot_template.sql b/sql/updates/world/2012_05_19_06_gameobject_loot_template.sql new file mode 100644 index 00000000000..f5d496b465b --- /dev/null +++ b/sql/updates/world/2012_05_19_06_gameobject_loot_template.sql @@ -0,0 +1,13 @@ +DELETE FROM `reference_loot_template` WHERE `entry`=34172; +DELETE FROM `creature_loot_template` WHERE `entry`=38013; +DELETE FROM `gameobject_loot_template` WHERE `entry=28683 +INSERT INTO `gameobject_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +(28683,35498,3,1,0,1,1), -- Formula: Enchant Weapon - Deathfrost +(28683,35557,28,1,0,1,2), -- Huge Snowball +(28683,35720,3,1,0,5,6), -- Lord of Frost's Private Label +(28683,35723,12,1,0,1,1), -- Shards of Ahune +(28683,54801,0,1,1,1,1), -- Icebound Cloak +(28683,54802,0,1,1,1,1), -- The Frost Lord's War Cloak +(28683,54803,0,1,1,1,1), -- The Frost Lord's Battle Shroud +(28683,54804,0,1,1,1,1), -- Shroud of Winter's Chill +(28683,54805,0,1,1,1,1); -- Cloak of the Frigid Winds |