Projekt

Allgemein

Profil

Fehler #8063 » bundle_of_nether_spikes_fix.sql

b2b-offidufte, 05.11.2017 13:12

 
1
delete from item_loot_template where entry like 30320 and item like 30319;
2
delete from reference_loot_template where entry like 30320 and item like 30319;
3
insert into item_loot_template set entry=30320, item=30319, chanceorquestchance=100, mincountorref=-30320, maxcount=6, comments='Bundle of Nether Spikes';
4
insert into reference_loot_template set entry=30320, item=30319, chanceorquestchance=100, mincountorref=200, maxcount=200, comments='Bundle of Nether Spikes';
    (1-1/1)