[Accepted][Battle for Azeroth]: Barnacled Lockbox

[jela]

Patch Content:

Title:Barnacled Lockbox

 

Bugtracker Link:https://firestorm-servers.com/en/report/see_report/96810

Correction:Adding loot to gameobject

 

169475=Barnacled Lockbox

UPDATE `gameobject_template` SET `lootid`=169475 WHERE `entry`=169475;
DELETE FROM `gameobject_loot_template` WHERE `entry`='169475';

INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
('169475', '170118', '6', '1', '0', '1', '1'),
('169475', '170116', '6', '1', '0', '1', '1'),
('169475', '170114', '6', '1', '0', '1', '1'),
('169475', '170120', '6', '1', '0', '1', '1'),
('169475', '170115', '6', '1', '0', '1', '1'),
('169475', '170119', '6', '1', '0', '1', '1'),
('169475', '170117', '6', '1', '0', '1', '1'),
('169475', '170112', '6', '1', '0', '1', '1'),
('169475', '169415', '1.7', '1', '0', '1', '1'),
('169475', '169414', '1.7', '1', '0', '1', '1'),
('169475', '169417', '1.7', '1', '0', '1', '1'),
('169475', '169426', '1.7', '1', '0', '1', '1'),
('169475', '169402', '1.6', '1', '0', '1', '1'),
('169475', '169403', '1.6', '1', '0', '1', '1'),
('169475', '169431', '1.6', '1', '0', '1', '1'),
('169475', '169413', '1.6', '1', '0', '1', '1'),
('169475', '169412', '1.6', '1', '0', '1', '1'),
('169475', '169434', '1.6', '1', '0', '1', '1'),
('169475', '169410', '1.6', '1', '0', '1', '1'),
('169475', '169408', '1.6', '1', '0', '1', '1'),
('169475', '169428', '1.6', '1', '0', '1', '1'),
('169475', '169421', '1.6', '1', '0', '1', '1'),
('169475', '169423', '1.6', '1', '0', '1', '1'),
('169475', '169433', '1.6', '1', '0', '1', '1'),
('169475', '169427', '1.6', '1', '0', '1', '1'),
('169475', '169400', '1.5', '1', '0', '1', '1'),
('169475', '169404', '1.5', '1', '0', '1', '1'),
('169475', '169399', '1.5', '1', '0', '1', '1'),
('169475', '169401', '1.5', '1', '0', '1', '1'),
('169475', '169425', '1.5', '1', '0', '1', '1'),
('169475', '169398', '1.5', '1', '0', '1', '1'),
('169475', '169420', '1.5', '1', '0', '1', '1'),
('169475', '169418', '1.5', '1', '0', '1', '1'),
('169475', '169411', '1.5', '1', '0', '1', '1'),
('169475', '169409', '1.5', '1', '0', '1', '1'),
('169475', '169407', '1.5', '1', '0', '1', '1'),
('169475', '169405', '1.5', '1', '0', '1', '1'),
('169475', '169422', '1.5', '1', '0', '1', '1'),
('169475', '169429', '1.5', '1', '0', '1', '1'),
('169475', '169435', '1.4', '1', '0', '1', '1'),
('169475', '169419', '1.4', '1', '0', '1', '1'),
('169475', '169416', '1.4', '1', '0', '1', '1'),
('169475', '169406', '1.4', '1', '0', '1', '1'),
('169475', '169424', '1.4', '1', '0', '1', '1'),

 

 

Edited December 9, 2020 by jela

[Daxter]

Chests/gameobjects don't have 'lootId', they have 'data1' (if they are of the type 3 or 25 (chests or fishing pools))

I also don't think this will work for BfA, since WoD the collumns have changed  and you appear to use the one from MoP and before. For more info go to trinitycore wiki for loot templates.

[Florix]

Well, at the end there should be ;

 

('169475', '169419', '1.4', '1', '0', '1', '1'),
('169475', '169416', '1.4', '1', '0', '1', '1'),
('169475', '169406', '1.4', '1', '0', '1', '1'),
('169475', '169424', '1.4', '1', '0', '1', '1');

 

[Thyvene]

Greetings @jela,

Your patch is accepted, thank you for contributing to Firestorm.

Regards, Thyvene.