Sign in to follow this  
Followers 0
Misahky

[09.01.2017] How to submit a patch

1 post in this topic

To contribute to the project, use the Submit a patch FORM.

Greetings!

Please read this topic before posting patches.
 

What Patches can be posted?

We accept here SQL patches.
 

Format

Please use this Format. It helps us a lot checking your patch in an efficient way.

 

Quote

Title: [Legion] Wrathguard Invader

Bugtracker link: https://firestorm-servers.com/en/report/see_report/29958

Correction: Adding missing loot


UPDATE `creature_template` SET `lootid`=90230 WHERE `entry`=90230;
DELETE FROM `creature_loot_template` WHERE `entry`=90230;

INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(90230, 121002, 0.03, 1, 0, 1, 1), 
(90230, 121005, 0.03, 1, 0, 1, 1), 
(90230, 121012, 0.06, 1, 0, 1, 1), 
(90230, 121018, 0.06, 1, 0, 1, 1), 
(90230, 121019, 0.06, 1, 0, 1, 1), 
(90230, 121020, 0.03, 1, 0, 1, 1), 
(90230, 121021, 0.04, 1, 0, 1, 1), 
(90230, 121044, 0.01, 1, 0, 1, 1), 
(90230, 121049, 0.03, 1, 0, 1, 1), 
(90230, 121051, 0.06, 1, 0, 1, 1), 
(90230, 121052, 0.01, 1, 0, 1, 1), 
(90230, 121053, 0.02, 1, 0, 1, 1), 
(90230, 128610, 0.03, 1, 0, 1, 1), 
(90230, 132199, 8, 1, 0, 1, 1), 
(90230, 132200, 0.25, 1, 0, 1, 1), 
(90230, 132204, 100, 1, 0, 1, 1), 
(90230, 132231, 34, 1, 0, 1, 1), 
(90230, 132749, -0.03, 1, 0, 1, 1), 
(90230, 137677, -20, 1, 0, 1, 1), 
(90230, 138781, 0.88, 1, 0, 1, 1), 
(90230, 138782, 0.18, 1, 0, 1, 1), 
(90230, 138817, 14, 1, 0, 1, 1), 
(90230, 138991, -7, 1, 0, 1, 1), 
(90230, 139520, -0.06, 1, 0, 1, 1), 
(90230, 140220, 0.09, 1, 0, 1, 1), 
(90230, 140221, 0.01, 1, 0, 1, 1), 
(90230, 140222, 0.11, 1, 0, 1, 1), 
(90230, 140224, 0.06, 1, 0, 1, 1), 
(90230, 140225, 0.03, 1, 0, 1, 1), 
(90230, 140226, 0.06, 1, 0, 1, 1), 
(90230, 140227, 0.03, 1, 0, 1, 1), 
(90230, 141035, 0.01, 1, 0, 1, 1), 
(90230, 141064, 0.08, 1, 0, 1, 1), 
(90230, 141285, 0.01, 1, 0, 1, 1);

 

As most of the patches are loots, you can use the patch I showed as a structure reference - it's up to date.
If you have any questions about the database structure you need, feel free to PM a Developer here at the Forums. We will help you.

 

Thanks for your help!

 

History:

ALL LEGION PATCHES BEFORE 09.01.2017 have been declined due to structure changes!

Edited by Dallaryen
Added link to hard-to-find submit form

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