Mystiq.org - forum: DB - Sea Turtle -> Itemy a objekty -> Bugreport

Tento mountík se má získat rybařením z fishing pools v Northrendu a drop má mít ve všech 0,1 %. Jedná se o:
Borean Man O' War School
Dragonfin Angelfish School
Imperial Manta Ray School
Musselback Sculpin School
Deep Sea Monsterbelly School
Fangtooth Herring School
Glassfin Minnow School
Moonglow Cuttlefish School
Nettlefish School

Upravuji status na: Převzaté
Upravuji vážnost na: 2 - Normální

Upravuji status na: Opravené!

Pridano do lootu...

pro zajimavost dotaz:

-- Bugreport ID #3767: DB - Sea Turtle
DELETE FROM `gameobject_loot_template` WHERE `item` = '46109';
INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) 
SELECT `data1`, '46109', '0.1', '1', '0', '1', '1' FROM `gameobject_template`
WHERE `entry` IN ('192051', '192048', '192052', '192046', '192053', '192049', '192059', '192054', '192057');