diff options
author | Kandera <KanderaDev@gmail.com> | 2012-09-14 09:58:42 -0400 |
---|---|---|
committer | Kandera <KanderaDev@gmail.com> | 2012-09-14 09:58:42 -0400 |
commit | 2773adbb3804c6f383e67a08fa9d0e8dc0d9aaeb (patch) | |
tree | 652b117893ecccfe460f7228342ce285dc6a7962 | |
parent | 6e134d47613498cb2b8587ce7a7f71d27570cdce (diff) |
DB/Loot: Sister svalna is supposed to also drop one emblem of frost
-rw-r--r-- | sql/updates/world/2012_09_14_01_world_creature_loot_template.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/2012_09_14_01_world_creature_loot_template.sql b/sql/updates/world/2012_09_14_01_world_creature_loot_template.sql new file mode 100644 index 00000000000..02b9ad761bd --- /dev/null +++ b/sql/updates/world/2012_09_14_01_world_creature_loot_template.sql @@ -0,0 +1,4 @@ +INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +(37126, 49426, 100, 1, 0, 0, 1, 1), +(37126, 1, 100, 1, 0, 0, -100002, 1); +UPDATE `creature_template` SET `lootid` = 37126 WHERE `entry` IN (37126,38258); |