Sign in to follow this  
Followers 0
jela

[Battle for Azeroth]: [Bfa]Fishing in Nazjatar

5 posts in this topic

Title: [Bfa]Fishing in Nazjatar
Bugtracker Link:


Patch Content:

 

Spoiler

DELETE FROM `fishing_loot_template` WHERE `entry`='10052' ;
 
 INSERT INTO `fishing_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES 
 
 ('10052', '168302', '0', '49', '0', '1', '1', '1', '1', 'Viper Fish'),
 ('10052', '168646', '0', '48', '0', '1', '1', '1', '1', 'Mauve Stinger'), 
 ('10052', '162515', '0', '3', '0', '1', '1', '1', '1', 'Midnight Salmon'), 
 ('10052', '160930', '0', '0.3', '0', '1', '1', '1', '1', 'Barnacled Greateaxe'), 
 ('10052', '154796', '0', '0.3', '0', '1', '1', '1', '1', '	Crumbling Chain Sabatons'), 
 ('10052', '154779', '0', '0.3', '0', '1', '1', '1', '1', 'Raptured Plate Stompers'), 
 ('10052', '154787', '0', '0.3', '0', '1', '1', '1', '1', 'Unraveling Cloth Shirt'), 
 ('10052', '160927', '0', '0.2', '0', '1', '1', '1', '1', 'Chipped Stone Hatchet'), 
 ('10052', '154770', '0', '0.2', '0', '1', '1', '1', '1', 'Cracked Hide Belt'), 
 ('10052', '154771', '0', '0.2', '0', '1', '1', '1', '1', 'Cracked Hide Boots'), 
 ('10052', '154801', '0', '0.2', '0', '1', '1', '1', '1', 'Crumbling Chain Belt'), 
 ('10052', '160925', '0', '0.2', '0', '1', '1', '1', '1', 'Crusty Cutlass'), 
 ('10052', '160934', '0', '0.2', '0', '1', '1', '1', '1', 'Mud-Soaked Crossbow'), 
 ('10052', '154785', '0', '0.2', '0', '1', '1', '1', '1', 'Raptured Plate Belt'), 
 ('10052', '154792', '0', '0.2', '0', '1', '1', '1', '1', 'Unraveling Cloth Cord'), 
 ('10052', '154788', '0', '0.2', '0', '1', '1', '1', '1', 'Unraveling Cloth Sandals'), 
 ('10052', '167059', '0', '0.11', '0', '1', '1', '1', '1', 'Chum'), 
 ('10052', '168155', '0', '0.01', '1', '1', '0', '1', '1', 'Chum-Quest Item'); 

 

 

 

Edited by jela
1 person likes this

Share this post


Link to post
Share on other sites

Greetings,
because of invalid columns I had to update your Query.
 

DELETE FROM `fishing_loot_template` WHERE `entry`='10052';
INSERT INTO `fishing_loot_template` (`Entry`, `Item`, `ChanceOrQuestChance`, `lootMode`, `groupId`, `mincountOrRef`, `maxcount`) VALUES 
('10052', '168302', '49', '1', '1', '1', '3'), -- 'Viper Fish'
('10052', '168646', '48', '1', '1', '1', '3'), -- 'Mauve Stinger'
('10052', '162515', '3', '1', '1', '1', '1'), -- 'Midnight Salmon'
('10052', '160930', '0.3', '1', '1', '1', '1'), -- 'Barnacled Greateaxe'
('10052', '154796', '0.3', '1', '1', '1', '1'), -- 'Crumbling Chain Sabatons'
('10052', '154779', '0.3', '1', '1', '1', '1'), -- 'Raptured Plate Stompers'
('10052', '154787', '0.3', '1', '1', '1', '1'), -- 'Unraveling Cloth Shirt'
('10052', '160927', '0.2', '1', '1', '1', '1'), -- 'Chipped Stone Hatchet' 
('10052', '154770', '0.2', '1', '1', '1', '1'), -- 'Cracked Hide Belt'
('10052', '154771', '0.2', '1', '1', '1', '1'), -- 'Cracked Hide Boots'
('10052', '154801', '0.2', '1', '1', '1', '1'), -- 'Crumbling Chain Belt'
('10052', '160925', '0.2', '1', '1', '1', '1'), -- 'Crusty Cutlass'
('10052', '160934', '0.2', '1', '1', '1', '1'), -- 'Mud-Soaked Crossbow'
('10052', '154785', '0.2', '1', '1', '1', '1'), -- 'Raptured Plate Belt'
('10052', '154792', '0.2', '1', '1', '1', '1'), -- 'Unraveling Cloth Cord'
('10052', '154788', '0.2', '1', '1', '1', '1'), -- 'Unraveling Cloth Sandals'
('10052', '167059', '0.11', '1', '1', '1', '1'), -- 'Chum'
('10052', '168155', '0.01', '1', '1', '1', '1'); -- 'Chum-Quest Item'

Best Regards,
QA Tawi

1 person likes this

Share this post


Link to post
Share on other sites

Several Cooking patterns impossible without this fix

1 person likes this

Share this post


Link to post
Share on other sites

As they care xD
 

Share this post


Link to post
Share on other sites

Tawi will probably apply these fixes, I assume

But yeah, this part of the forum could really use more attention or someone of rank to review them more often.

Edited by Daxter
2 people like this

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0