Sign in to follow this  
Followers 0
Florix

[Accepted][Battle for Azeroth]: Firelands Tokens

2 posts in this topic

Title: Firelands Tokens
Bugtracker Link:


Patch Content:

Just noticed, that those tokens give no items. So, here's the fix for loot. I havn't found anything in my Database related to spec/class loot.

Chest:
https://www.wowhead.com/item=71672/chest-of-the-fiery-vanquisher
https://www.wowhead.com/item=71686/chest-of-the-fiery-protector
https://www.wowhead.com/item=71679/chest-of-the-fiery-conqueror
All 3 use the same spell https://www.wowhead.com/spell=238264/create-item for spell_loot_template

 

DELETE FROM `spell_loot_template` WHERE `entry`='238264';
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238264','71476','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238264','71481','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238264','71486','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238264','71494','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238264','71499','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238264','71501','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238264','71510','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238264','71512','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238264','71517','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238264','71522','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238264','71530','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238264','71535','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238264','71537','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238264','71542','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238264','71547','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238264','71552','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238264','71600','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238264','71604','0','1','0','1','1');



Pants:
https://www.wowhead.com/item=71671/leggings-of-the-fiery-vanquisher
https://www.wowhead.com/item=71685/leggings-of-the-fiery-protector
https://www.wowhead.com/item=71678/leggings-of-the-fiery-conqueror
Spell: https://www.wowhead.com/spell=238189/create-item

 

DELETE FROM `spell_loot_template` WHERE `entry`='238189';
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238189','71479','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238189','71484','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238189','71489','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238189','71493','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238189','71498','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238189','71504','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238189','71509','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238189','71515','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238189','71520','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238189','71525','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238189','71529','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238189','71534','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238189','71540','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238189','71545','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238189','71550','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238189','71596','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238189','71602','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238189','71607','0','1','0','1','1');


Gloves:

https://www.wowhead.com/item=71676/gauntlets-of-the-fiery-conqueror
https://www.wowhead.com/item=71683/gauntlets-of-the-fiery-protector
https://www.wowhead.com/item=71669/gauntlets-of-the-fiery-vanquisher
Spell: https://www.wowhead.com/spell=238265/create-item

 

DELETE FROM `spell_loot_template` WHERE `entry`='238265';
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238265','71477','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238265','71482','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238265','71487','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238265','71491','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238265','71496','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238265','71502','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238265','71507','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238265','71513','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238265','71518','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238265','71523','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238265','71527','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238265','71532','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238265','71538','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238265','71543','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238265','71548','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238265','71553','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238265','71594','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238265','71601','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238265','71605','0','1','0','1','1');


Shoulders:
https://www.wowhead.com/item=71681/mantle-of-the-fiery-conqueror
https://www.wowhead.com/item=71688/mantle-of-the-fiery-protector
https://www.wowhead.com/item=71674/mantle-of-the-fiery-vanquisher
Spell: https://www.wowhead.com/spell=238266/create-item

 

DELETE FROM `spell_loot_template` WHERE `entry`='238266';
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238266','70941','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238266','70946','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238266','70951','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238266','71049','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238266','71053','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238266','71062','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238266','71067','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238266','71072','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238266','71095','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238266','71101','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238266','71106','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238266','71111','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238266','71275','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238266','71280','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238266','71285','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238266','71290','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238266','71295','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238266','71300','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238266','71305','0','1','0','1','1');


Helmet:
https://www.wowhead.com/item=71675/helm-of-the-fiery-conqueror
https://www.wowhead.com/item=71682/helm-of-the-fiery-protector
https://www.wowhead.com/item=71668/helm-of-the-fiery-vanquisher
Spell: https://www.wowhead.com/spell=238187/create-item

 

DELETE FROM `spell_loot_template` WHERE `entry`='238187';
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238187','70944','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238187','70948','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238187','70954','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238187','71047','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238187','71051','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238187','71060','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238187','71065','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238187','71070','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238187','71093','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238187','71098','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238187','71103','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238187','71108','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238187','71272','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238187','71277','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238187','71282','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238187','71287','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238187','71293','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238187','71298','0','1','0','1','1');
insert into `spell_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) values('238187','71303','0','1','0','1','1');

 

Share this post


Link to post
Share on other sites

Hello @Florix,

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

Regards, Thyvene.

Share this post


Link to post
Share on other sites
Guest
This topic is now closed to further replies.
Sign in to follow this  
Followers 0