diff options
| author | Nay <dnpd.dd@gmail.com> | 2012-08-19 09:57:13 -0700 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2012-08-19 09:57:13 -0700 |
| commit | c161da9207fb00ac0b24c661361d7d4cbc5e44a6 (patch) | |
| tree | a031186b0b7ae3b4b8fa73604d9a4880db74b6be | |
| parent | 48e50b8254a2cc45ed561e4ff96180783787d93a (diff) | |
| parent | 453158fe9d37683e9ac0785b39d81592f8b32985 (diff) | |
Merge pull request #7448 from Faq/db
DB/Loot: Some loot contents imported from UDB. Author Helias
| -rw-r--r-- | sql/updates/world/2012_08_19_00_world_pickpocketing_loot_template.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/2012_08_19_00_world_pickpocketing_loot_template.sql b/sql/updates/world/2012_08_19_00_world_pickpocketing_loot_template.sql new file mode 100644 index 00000000000..773ad9b6ebc --- /dev/null +++ b/sql/updates/world/2012_08_19_00_world_pickpocketing_loot_template.sql @@ -0,0 +1,11 @@ +-- Pickpocketing_loot_template +UPDATE creature_template SET pickpocketloot=entry WHERE entry=28200; +DELETE FROM `pickpocketing_loot_template` WHERE entry=28200; +INSERT INTO `pickpocketing_loot_template` (`entry`,`item`,`ChanceorQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +-- Dark Necromance +(28200,37467,100,1,0,1,1),-- A Steamy Romance Novel: Forbidden Love +(28200,43575,100,1,0,1,1),-- Reinforced Junkbox +(28200,35952,30,1,0,1,1),-- Briny Hardcheese +(28200,33447,22,1,0,1,1),-- Runic Healing Potion +(28200,35948,10,1,0,1,1),-- Savory Snowplum +(28200,35950,10,1,0,1,1);-- Sweet Potato Bread |