diff options
| author | gecko32 <gecko32@trinity.contrib> | 2012-05-31 18:40:34 +0100 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2012-05-31 18:40:34 +0100 |
| commit | 851f43b0a618fa1977197d53ab005c8d0da91327 (patch) | |
| tree | 2e4fa0ba08f9a71c810028e9ac97f7cf4f2d90b6 | |
| parent | 7824b84e3af4eb2bca8d22d5b1a0b18a2b9452be (diff) | |
DB/Loot: Update drop chance of Ensorcelled Parchment from 0.2% to 100%
Change respawn time of that chest from 2 secs to 3 minutes
Closes #6445
| -rw-r--r-- | sql/updates/world/2012_05_31_03_world_gameobject_loot_template.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/2012_05_31_03_world_gameobject_loot_template.sql b/sql/updates/world/2012_05_31_03_world_gameobject_loot_template.sql new file mode 100644 index 00000000000..5dcedaaf342 --- /dev/null +++ b/sql/updates/world/2012_05_31_03_world_gameobject_loot_template.sql @@ -0,0 +1,4 @@ +-- Update drop chance of Ensorcelled Parchment from 0.2% to 100% +UPDATE `gameobject_loot_template` SET `ChanceOrQuestChance`=100 WHERE `entry`=1570 AND `item`=3706; +-- Change spawntime from 2 secs to 3 minutes +UPDATE `gameobject` SET `spawntimesecs`=180 WHERE `id`=1765; |