aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorGacko <gacko28@gmx.de>2013-06-01 14:36:22 +0200
committerGacko <gacko28@gmx.de>2013-06-01 14:42:38 +0200
commite741821dc2b1db41017fdc954da0ea36a84ace3e (patch)
tree48d8b70224c3ff5d3ddc7cd4534fa3aa4cd9a07f
parenta78480d56e35bccaf3d673a81ec967b55fe423ae (diff)
DB: Fishing loot for Pit Of Saron
http://www.elsanglin.com/forums/topic/pit-of-saron
-rw-r--r--sql/updates/world/2013_06_01_01_world_fishing_loot_template.sql14
1 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/world/2013_06_01_01_world_fishing_loot_template.sql b/sql/updates/world/2013_06_01_01_world_fishing_loot_template.sql
new file mode 100644
index 00000000000..0a0d8f842fa
--- /dev/null
+++ b/sql/updates/world/2013_06_01_01_world_fishing_loot_template.sql
@@ -0,0 +1,14 @@
+DELETE FROM `skill_fishing_base_level` WHERE `entry`=4813;
+INSERT INTO `skill_fishing_base_level`(`entry`,`skill`) VALUE
+(4813,450);
+
+DELETE FROM `fishing_loot_template` WHERE `entry`=4813;
+INSERT INTO `fishing_loot_template`(`entry`,`item`,`ChanceOrQuestChance`,`groupid`) VALUES
+(4813,41808,58,1),
+(4813,43572,20.5,1),
+(4813,36794,5.4,1),
+(4813,4875,5,1),
+(4813,3671,4.5,1),
+(4813,25447,4.5,1),
+(4813,44475,1.1,1),
+(4813,37705,1,1);