Sign in to follow this  
Followers 0
Daxter

[MoP] [#4101] [#6148] [#5838]

Started by Daxter,

6 posts in this topic

Posted (edited) 

-- No ticket
-- #63240/Loot - Shadowmaster Sydow
DELETE FROM `creature_loot_template` WHERE `entry`=63240;
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(63240, 103624, 30, 1, 0, 1, 1),
(63240, 102541, 20, 1, 0, 2, 3),
(63240, 102543, 20, 1, 0, 2, 3),
(63240, 102542, 20, 1, 0, 2, 3),
(63240, 72988, 19, 1, 0, 1, 3),
(63240, 81412, 8, 1, 0, 1, 1),
(63240, 89112, 7, 1, 0, 1, 1),
(63240, 81414, 4, 1, 0, 1, 1),
(63240, 87779, 1.8, 1, 0, 1, 1),
(63240, 81404, 1, 1, 0, 1, 1),
(63240, 88567, 0.18, 1, 0, 1, 1),
(63240, 82283, 0.11, 1, 0, 1, 1),
(63240, 90761, 0.09, 1, 0, 1, 1),
(63240, 87391, 0.06, 1, 0, 1, 1),
(63240, 90810, 0.06, 1, 0, 1, 1),
(63240, 90762, 0.06, 1, 0, 1, 1),
(63240, 82230, 0.05, 1, 0, 1, 1),
(63240, 90741, 0.05, 1, 0, 1, 1),
(63240, 82228, 0.04, 1, 0, 1, 1),
(63240, 82232, 0.04, 1, 0, 1, 1),
(63240, 82285, 0.04, 1, 0, 1, 1),
(63240, 82202, 0.04, 1, 0, 1, 1),
(63240, 90748, 0.04, 1, 0, 1, 1),
(63240, 90747, 0.04, 1, 0, 1, 1),
(63240, 90753, 0.04, 1, 0, 1, 1),
(63240, 90756, 0.04, 1, 0, 1, 1),
(63240, 90805, 0.04, 1, 0, 1, 1),
(63240, 90744, 0.04, 1, 0, 1, 1),
(63240, 90769, 0.04, 1, 0, 1, 1),
(63240, 90765, 0.04, 1, 0, 1, 1),
(63240, 100863, 0.01, 1, 0, 1, 1),
(63240, 82236, 0.01, 1, 0, 1, 1),
(63240, 82239, 0.01, 1, 0, 1, 1),
(63240, 95468, 0.01, 1, 0, 1, 1),
(63240, 82209, 0.01, 1, 0, 1, 1),
(63240, 82251, 0.01, 1, 0, 1, 1),
(63240, 82254, 0.01, 1, 0, 1, 1),
(63240, 82243, 0.01, 1, 0, 1, 1),
(63240, 90771, 0.01, 1, 0, 1, 1),
(63240, 90743, 0.01, 1, 0, 1, 1),
(63240, 90759, 0.01, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid`=63240 WHERE `entry`=63240;

-- No ticket
-- #63240/Currency drop - Shadowmaster Sydow
DELETE FROM `creature_loot_currency` WHERE `creature_id`=63240;
INSERT INTO `creature_loot_currency` (`creature_id`, `currencyId1`, `currencyId2`, `currencyId3`, `CurrencyCount1`, `CurrencyCount2`, `CurrencyCount3`) VALUES
(63240, 738, 0, 0, 1, 0, 0);

-- No ticket
-- #63240/Pickpocket - Shadowmaster Sydow
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=63240;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `chanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(63240, 88162, 0.5, 1, 0, 1, 1),
(63240, 88163, 0.5, 1, 0, 1, 1);
UPDATE `creature_template` SET `pickpocketloot`=63240 WHERE `entry`=63240;


-- Ticket: #5838
-- #72764/NPC - Great Turtle
DELETE FROM `skinning_loot_template` WHERE `entry`=72764;
INSERT INTO `skinning_loot_template` (`entry`, `item`, `chanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(72764, 72120, 88, 1, 0, 1, 7),
(72764, 79101, 55, 1, 0, 1, 6),
(72764, 72201, 10, 1, 0, 1, 1),
(72764, 103643, 5, 1, 0, 1, 1);
UPDATE `creature_template` SET `skinloot`=72764 WHERE `entry`=72764;

-- Ticket: #6148
-- #40635/Rep - Southsea Strongarm
DELETE FROM `creature_onkill_reputation` WHERE `creature_id`=40635;
INSERT INTO `creature_onkill_reputation` (`creature_id`, `RewOnKillRepFaction1`, `RewOnKillFaction2`, `MaxStanding1`, `IsTeamAward1`, `RewOnKillRepValue1`, `MaxStanding2`, `IsTeamAward2`, `RewOnKillRepValue2`, `TeamDependent`) VALUES
(40635, 369, 0, 7, 1, 5, 0, 0, 0, 0);

-- #40632/Rep - Southsea Musketeer
DELETE FROM `creature_onkill_reputation` WHERE `creature_id`=40632;
INSERT INTO `creature_onkill_reputation` (`creature_id`, `RewOnKillRepFaction1`, `RewOnKillFaction2`, `MaxStanding1`, `IsTeamAward1`, `RewOnKillRepValue1`, `MaxStanding2`, `IsTeamAward2`, `RewOnKillRepValue2`, `TeamDependent`) VALUES
(40632, 369, 0, 7, 1, 5, 0, 0, 0, 0);

-- Ticket:4101
-- #18703/Loot - Ancient Petrified Leaf
DELETE FROM `gameobject_loot_template` WHERE `item`=18703;

 

Edited by Daxter

Share this post

Link to post
Share on other sites

Posted

I can't seem to be able to edit my topic, but I made some mistakes and here's the correction:

Bugtracker links:

http://tracker.pandashan.com/issues/5838

http://tracker.pandashan.com/issues/6148

http://tracker.pandashan.com/issues/4101

Wowhead links:

http://www.wowhead.com/npc=72764/great-turtle

http://www.wowhead.com/npc=40635/southsea-strongarm

http://www.wowhead.com/npc=40632/southsea-musketeer

http://www.wowhead.com/item=18703/ancient-petrified-leaf

Correction: Fixed tickets

Patch:

  


-- No ticket
-- #63240/Loot - Shadowmaster Sydow
DELETE FROM `creature_loot_template` WHERE `entry`=63240;
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(63240, 103624, 30, 1, 0, 1, 1),
(63240, 102541, 20, 1, 0, 2, 3),
(63240, 102543, 20, 1, 0, 2, 3),
(63240, 102542, 20, 1, 0, 2, 3),
(63240, 72988, 19, 1, 0, 1, 3),
(63240, 81412, 8, 1, 0, 1, 1),
(63240, 89112, 7, 1, 0, 1, 1),
(63240, 81414, 4, 1, 0, 1, 1),
(63240, 87779, 1.8, 1, 0, 1, 1),
(63240, 81404, 1, 1, 0, 1, 1),
(63240, 88567, 0.18, 1, 0, 1, 1),
(63240, 82283, 0.11, 1, 0, 1, 1),
(63240, 90761, 0.09, 1, 0, 1, 1),
(63240, 87391, 0.06, 1, 0, 1, 1),
(63240, 90810, 0.06, 1, 0, 1, 1),
(63240, 90762, 0.06, 1, 0, 1, 1),
(63240, 82230, 0.05, 1, 0, 1, 1),
(63240, 90741, 0.05, 1, 0, 1, 1),
(63240, 82228, 0.04, 1, 0, 1, 1),
(63240, 82232, 0.04, 1, 0, 1, 1),
(63240, 82285, 0.04, 1, 0, 1, 1),
(63240, 82202, 0.04, 1, 0, 1, 1),
(63240, 90748, 0.04, 1, 0, 1, 1),
(63240, 90747, 0.04, 1, 0, 1, 1),
(63240, 90753, 0.04, 1, 0, 1, 1),
(63240, 90756, 0.04, 1, 0, 1, 1),
(63240, 90805, 0.04, 1, 0, 1, 1),
(63240, 90744, 0.04, 1, 0, 1, 1),
(63240, 90769, 0.04, 1, 0, 1, 1),
(63240, 90765, 0.04, 1, 0, 1, 1),
(63240, 100863, 0.01, 1, 0, 1, 1),
(63240, 82236, 0.01, 1, 0, 1, 1),
(63240, 82239, 0.01, 1, 0, 1, 1),
(63240, 95468, 0.01, 1, 0, 1, 1),
(63240, 82209, 0.01, 1, 0, 1, 1),
(63240, 82251, 0.01, 1, 0, 1, 1),
(63240, 82254, 0.01, 1, 0, 1, 1),
(63240, 82243, 0.01, 1, 0, 1, 1),
(63240, 90771, 0.01, 1, 0, 1, 1),
(63240, 90743, 0.01, 1, 0, 1, 1),
(63240, 90759, 0.01, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid`=63240 WHERE `entry`=63240;

-- No ticket
-- #63240/Currency drop - Shadowmaster Sydow
DELETE FROM `creature_loot_currency` WHERE `creature_id`=63240;
INSERT INTO `creature_loot_currency` (`creature_id`, `currencyId1`, `currencyId2`, `currencyId3`, `CurrencyCount1`, `CurrencyCount2`, `CurrencyCount3`) VALUES
(63240, 738, 0, 0, 1, 0, 0);

-- No ticket
-- #63240/Pickpocket - Shadowmaster Sydow
DELETE FROM `pickpocketing_loot_template` WHERE `entry`=63240;
INSERT INTO `pickpocketing_loot_template` (`entry`, `item`, `chanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(63240, 88162, 0.5, 1, 0, 1, 1),
(63240, 88163, 0.5, 1, 0, 1, 1);
UPDATE `creature_template` SET `pickpocketloot`=63240 WHERE `entry`=63240;


-- Ticket: #5838
-- #72764/NPC - Great Turtle
DELETE FROM `skinning_loot_template` WHERE `entry`=72764;
INSERT INTO `skinning_loot_template` (`entry`, `item`, `chanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(72764, 72120, 88, 1, 0, 1, 7),
(72764, 79101, 55, 1, 0, 1, 6),
(72764, 72201, 10, 1, 0, 1, 1),
(72764, 103643, 5, 1, 0, 1, 1);
UPDATE `creature_template` SET `skinloot`=72764 WHERE `entry`=72764;

UPDATE `creature_template` SET `unit_flags`=67108864 WHERE `entry`=72764

-- Ticket: #6148
-- #40635/Rep - Southsea Strongarm
DELETE FROM `creature_onkill_reputation` WHERE `creature_id`=40635;
INSERT INTO `creature_onkill_reputation` (`creature_id`, `RewOnKillRepFaction1`, `RewOnKillFaction2`, `MaxStanding1`, `IsTeamAward1`, `RewOnKillRepValue1`, `MaxStanding2`, `IsTeamAward2`, `RewOnKillRepValue2`, `TeamDependent`) VALUES
(40635, 369, 0, 7, 1, 5, 0, 0, 0, 0);

-- #40632/Rep - Southsea Musketeer
DELETE FROM `creature_onkill_reputation` WHERE `creature_id`=40632;
INSERT INTO `creature_onkill_reputation` (`creature_id`, `RewOnKillRepFaction1`, `RewOnKillFaction2`, `MaxStanding1`, `IsTeamAward1`, `RewOnKillRepValue1`, `MaxStanding2`, `IsTeamAward2`, `RewOnKillRepValue2`, `TeamDependent`) VALUES
(40632, 369, 0, 7, 1, 5, 0, 0, 0, 0);

-- Ticket:4101
-- #18703/Loot - Ancient Petrified Leaf
DELETE FROM `gameobject_loot_template` WHERE `item`=18703;

Share this post

Link to post
Share on other sites

Posted

Hello, cause of the 3% drop chance of http://www.wowhead.com/npc=63240/shadowmaster-sydow#drop-currency it have to be in creature_loot_template
So:
  

-- No ticket
-- #63240/Loot - Shadowmaster Sydow
DELETE FROM `creature_loot_template` WHERE `entry`=63240;
INSERT INTO `creature_loot_template` (`entry`, `item`, `chanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(63240, -738, 3, 1, 0, 1, 1),
(63240, 103624, 30, 1, 0, 1, 1),
(63240, 102541, 20, 1, 0, 2, 3),
(63240, 102543, 20, 1, 0, 2, 3),
(63240, 102542, 20, 1, 0, 2, 3),
(63240, 72988, 19, 1, 0, 1, 3),
(63240, 81412, 8, 1, 0, 1, 1),
(63240, 89112, 7, 1, 0, 1, 1),
(63240, 81414, 4, 1, 0, 1, 1),
(63240, 87779, 1.8, 1, 0, 1, 1),
(63240, 81404, 1, 1, 0, 1, 1),
(63240, 88567, 0.18, 1, 0, 1, 1),
(63240, 82283, 0.11, 1, 0, 1, 1),
(63240, 90761, 0.09, 1, 0, 1, 1),
(63240, 87391, 0.06, 1, 0, 1, 1),
(63240, 90810, 0.06, 1, 0, 1, 1),
(63240, 90762, 0.06, 1, 0, 1, 1),
(63240, 82230, 0.05, 1, 0, 1, 1),
(63240, 90741, 0.05, 1, 0, 1, 1),
(63240, 82228, 0.04, 1, 0, 1, 1),
(63240, 82232, 0.04, 1, 0, 1, 1),
(63240, 82285, 0.04, 1, 0, 1, 1),
(63240, 82202, 0.04, 1, 0, 1, 1),
(63240, 90748, 0.04, 1, 0, 1, 1),
(63240, 90747, 0.04, 1, 0, 1, 1),
(63240, 90753, 0.04, 1, 0, 1, 1),
(63240, 90756, 0.04, 1, 0, 1, 1),
(63240, 90805, 0.04, 1, 0, 1, 1),
(63240, 90744, 0.04, 1, 0, 1, 1),
(63240, 90769, 0.04, 1, 0, 1, 1),
(63240, 90765, 0.04, 1, 0, 1, 1),
(63240, 100863, 0.01, 1, 0, 1, 1),
(63240, 82236, 0.01, 1, 0, 1, 1),
(63240, 82239, 0.01, 1, 0, 1, 1),
(63240, 95468, 0.01, 1, 0, 1, 1),
(63240, 82209, 0.01, 1, 0, 1, 1),
(63240, 82251, 0.01, 1, 0, 1, 1),
(63240, 82254, 0.01, 1, 0, 1, 1),
(63240, 82243, 0.01, 1, 0, 1, 1),
(63240, 90771, 0.01, 1, 0, 1, 1),
(63240, 90743, 0.01, 1, 0, 1, 1),
(63240, 90759, 0.01, 1, 0, 1, 1);
UPDATE `creature_template` SET `lootid`=63240 WHERE `entry`=63240;

Anyway, added on the 5.4.8 PTR for testing.

Share this post

Link to post
Share on other sites

Posted

`RewOnKillFaction2` wrong, its `RewOnKillRepFaction2` :P 

Share this post

Link to post
Share on other sites

Posted

I won't rush it next time :P

Thanks.

Share this post

Link to post
Share on other sites

Posted

Patch Acceptet, merged soon on Live Realms.

Share this post

Link to post
Share on other sites
Sign in to follow this  
Followers 0
Go To Topic Listing Accepted