Code:
[COLOR="#0000FF"]SET[/COLOR] @entry:=5904;
[COLOR="#0000FF"]DELETE FROM[/COLOR] `skill_fishing_base_level` [COLOR="#0000FF"]WHERE[/COLOR] `entry`=@entry;
[COLOR="#0000FF"]INSERT INTO[/COLOR] `skill_fishing_base_level` (`entry`, `skill`) [COLOR="#0000FF"]VALUES[/COLOR]
(@entry, 75);
[COLOR="#0000FF"]
DELETE FROM[/COLOR] `fishing_loot_template` [COLOR="#0000FF"]WHERE [/COLOR]`entry`=@entry;
[COLOR="#0000FF"]INSERT INTO[/COLOR] `fishing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) [COLOR="#0000FF"]VALUES[/COLOR]
(@entry, 73269, -42, 1, 1, 1, 1),
(@entry, 6361, 53, 1, 0, 1, 1),
(@entry, 6358, 21, 1, 0, 1, 1),
(@entry, 78930, 14, 1, 0, 1, 1),
(@entry, 6359, 10, 1, 0, 1, 1),
(@entry, 6303, 1.9, 1, 0, 1, 1),
(@entry, 35285, 1.7, 1, 0, 1, 1),
(@entry, 41803, 1.4, 1, 0, 1, 1),
(@entry, 6362, 1.3, 1, 0, 1, 1),
(@entry, 53069, 1.2, 1, 0, 1, 1),
(@entry, 13888, 0.8, 1, 0, 1, 1),
(@entry, 41805, 0.6, 1, 0, 1, 1),
(@entry, 41802, 0.6, 1, 0, 1, 1),
(@entry, 6354, 0.6, 1, 0, 1, 1),
(@entry, 6352, 0.6, 1, 0, 1, 1),
(@entry, 53070, 0.5, 1, 0, 1, 1),
(@entry, 73953, 0.5, 1, 0, 1, 1),
(@entry, 45190, 0.4, 1, 0, 1, 1),
(@entry, 45191, 0.4, 1, 0, 1, 1),
(@entry, 45195, 0.4, 1, 0, 1, 1),
(@entry, 6307, 0.4, 1, 0, 1, 1),
(@entry, 13422, 0.4, 1, 0, 1, 1),
(@entry, 45194, 0.4, 1, 0, 1, 1),
(@entry, 45189, 0.4, 1, 0, 1, 1),
(@entry, 45188, 0.4, 1, 0, 1, 1),
(@entry, 7973, 0.3, 1, 0, 1, 1),
(@entry, 36781, 0.3, 1, 0, 1, 1),
(@entry, 24476, 0.3, 1, 0, 1, 1),
(@entry, 13756, 0.3, 1, 0, 1, 1),
(@entry, 13755, 0.3, 1, 0, 1, 1),
(@entry, 35286, 0.2, 1, 0, 1, 1),
(@entry, 53072, 0.19, 1, 0, 1, 1),
(@entry, 53071, 0.18, 1, 0, 1, 1),
(@entry, 13754, 0.17, 1, 0, 1, 1),
(@entry, 13893, 0.15, 1, 0, 1, 1),
(@entry, 46109, 0.001, 1, 0, 1, 1);http://s32.postimg.org/o1k6iqstx/Wo_WScrn_Shot_080415_195606.jpg
Last edited:
