diff options
| author | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2012-04-14 15:30:40 +0200 |
|---|---|---|
| committer | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2012-04-14 15:31:04 +0200 |
| commit | ca6c8845b22c7009e9b096369ed62670e05a9ba1 (patch) | |
| tree | 5ca2233af8a53ee74621e1c7f28bd51140793818 | |
| parent | 0ec7016ccac555545598aac9464ba7f26659dafd (diff) | |
DB/Loot: Add some missing loot definitions to prevent some startup errors
| -rw-r--r-- | sql/updates/world/2012_04_14_01_world_gameobject_loot_template.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/2012_04_14_01_world_gameobject_loot_template.sql b/sql/updates/world/2012_04_14_01_world_gameobject_loot_template.sql new file mode 100644 index 00000000000..a3dd0c39865 --- /dev/null +++ b/sql/updates/world/2012_04_14_01_world_gameobject_loot_template.sql @@ -0,0 +1,11 @@ +-- Add missing gameobject_loot_templates to prevent startup errors +DELETE FROM `gameobject_loot_template` WHERE `entry` IN (3458,3459,3460,3461,15920,16841,26878,27725); +INSERT INTO `gameobject_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +(3458,4594,100,0,0,1,1), -- Rockscale Cod on Feast Fish +(3459,3771,100,0,0,1,1), -- Wild Hog Shank On Feast Boar +(3460,4538,100,0,0,1,1), -- Snapvine Watermelon on Feast Fruit +(3461,1708,100,0,0,1,1), -- Sweet Nectar on Feast Goblet +(15920,17822,-100,0,0,1,1), -- Weird Map on weird object +(16841,18950,-100,0,0,1,1), -- Chambermaid Pillaclenchers Pillow on Pillaclencher's Ornate Pillow +(26878,45062,100,0,0,1,1), -- Dusty Journal on Dusty Journal (different ID) +(27725,49648,100,0,0,1,1); -- Borrowed Tabard on Clean Laundry (might need condition!) |