Posted January 5, 2016 (edited) All bosse in hm Drops drop : http://www.wowhead.com/item=115280/abrogator-stone http://www.wowhead.com/item=115981/abrogator-stone-cluster Kargath Bladefist <Warlord of the Shattered Hand> Abrogator Stone DELETE FROM `creature_loot_template` WHERE `entry`='115280'; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (78714, 105715, 1, 1, 0, 1, 1), Abrogator Stone Cluster DELETE FROM `creature_loot_template` WHERE `entry`='115981'; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (78714, 115981, 5, 1, 0, 1, 1) The Butcher Abrogator Stone DELETE FROM `creature_loot_template` WHERE `entry`='115280'; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (77404, 105715, 1, 1, 0, 1, 1), Abrogator Stone Cluster DELETE FROM `creature_loot_template` WHERE `entry`='115981'; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (77404, 115981, 5, 1, 0, 1, 1) Brackenspore <Walker of the Deep> Abrogator Stone DELETE FROM `creature_loot_template` WHERE `entry`='115280'; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (78491, 105715, 1, 1, 0, 1, 1), Abrogator Stone Cluster DELETE FROM `creature_loot_template` WHERE `entry`='115981'; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (78491, 115981, 5, 1, 0, 1, 1) Tectus <The Living Mountain> Abrogator Stone DELETE FROM `creature_loot_template` WHERE `entry`='115280'; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (78948, 105715, 1, 1, 0, 1, 1), Abrogator Stone Cluster DELETE FROM `creature_loot_template` WHERE `entry`='115981'; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (78948, 115981, 5, 1, 0, 1, 1) Pol Abrogator Stone DELETE FROM `creature_loot_template` WHERE `entry`='115280'; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (78238, 105715, 1, 1, 0, 1, 1), Abrogator Stone Cluster DELETE FROM `creature_loot_template` WHERE `entry`='115981'; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (78238, 115981, 5, 1, 0, 1, 1) Phemos Abrogator Stone DELETE FROM `creature_loot_template` WHERE `entry`='115280'; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (78237, 105715, 1, 1, 0, 1, 1), Abrogator Stone Cluster DELETE FROM `creature_loot_template` WHERE `entry`='115981'; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (78237, 115981, 5, 1, 0, 1, 1) Ko'ragh <Breaker of Magic> Abrogator Stone DELETE FROM `creature_loot_template` WHERE `entry`='115280'; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (79015, 105715, 1, 1, 0, 1, 1), Abrogator Stone Cluster DELETE FROM `creature_loot_template` WHERE `entry`='115981'; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (79015, 115981, 5, 1, 0, 1, 1) Imperator Mar'gok <Sorcerer King> Abrogator Stone DELETE FROM `creature_loot_template` WHERE `entry`='115280'; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (77428, 105715, 1, 1, 0, 1, 1), Abrogator Stone Cluster DELETE FROM `creature_loot_template` WHERE `entry`='115981'; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (77428, 115981, 5, 1, 0, 1, 1) Boss Link :http://www.wowhead.com/npc=78714 http://www.wowhead.com/npc=77404 http://www.wowhead.com/npc=78491 http://www.wowhead.com/npc=78948 http://www.wowhead.com/npc=78238 http://www.wowhead.com/npc=78237 http://www.wowhead.com/npc=79015 http://www.wowhead.com/npc=77428 http://wow.gamepedia.com/Abrogator_Stone http://us.battle.net/wow/en/forum/topic/15700020938 Edited January 5, 2016 by Rymnor 1 person likes this Share this post Link to post Share on other sites
Posted January 5, 2016 http://www.wowhead.com/npc=77404 1 person likes this Share this post Link to post Share on other sites
Posted January 5, 2016 http://tracker.ashran.com/issues/11248 1 person likes this Share this post Link to post Share on other sites
Posted January 5, 2016 21 minutes ago, Rymnor said: 77428, 115981, 5, 1, 0, 1, 1 Why do some of them have 5% dropchance and some 1%. Plus the drop chance for the Abrogator stones is way higher. I receive an Abragator Stones for all of the bosses I kill and they sometimes 4-5 drop so your maxcount and ref should be way higher and for the percentage I believe it has to be a negative otherwise they won't drop at all. Share this post Link to post Share on other sites
Posted January 5, 2016 1 minute ago, Onezero said: Why do some of them have 5% dropchance and some 1%. Plus the drop chance for the Abrogator stones is way higher. I receive an Abragator Stones for all of the bosses I kill and they sometimes 4-5 drop so your maxcount and ref should be way higher and for the percentage I believe it has to be a negative otherwise they won't drop at all. sorry this is my fail but u can't see in wowhead the dropchance sorry but ty i fix it later Share this post Link to post Share on other sites
Posted January 5, 2016 Well it has to be 100% for sure but for the random amount you have to ask a developer. Share this post Link to post Share on other sites
Posted January 5, 2016 1 hour ago, Rymnor said: All bosse in hm Drops drop : Abrogator Stone Abrogator Stone Cluster Kargath Bladefist <Warlord of the Shattered Hand> Abrogator Stone DELETE FROM `creature_loot_template` WHERE `entry`='115280'; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (78714, 105715, 100, 1, 0, 1, 1), Abrogator Stone Cluster DELETE FROM `creature_loot_template` WHERE `entry`='115981'; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (78714, 115981, 100, 1, 0, 1, 4) The Butcher Abrogator Stone DELETE FROM `creature_loot_template` WHERE `entry`='115280'; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (77404, 105715, 100, 1, 0, 1, 1), Abrogator Stone Cluster DELETE FROM `creature_loot_template` WHERE `entry`='115981'; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (77404, 115981, 100, 1, 0, 1, 4) Brackenspore <Walker of the Deep> Abrogator Stone DELETE FROM `creature_loot_template` WHERE `entry`='115280'; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (78491, 105715, 100, 1, 0, 1, 1), Abrogator Stone Cluster DELETE FROM `creature_loot_template` WHERE `entry`='115981'; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (78491, 115981, 100, 1, 0, 1, 4), Tectus <The Living Mountain> Abrogator Stone DELETE FROM `creature_loot_template` WHERE `entry`='115280'; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (78948, 105715, 100, 1, 0, 1, 1), Abrogator Stone Cluster DELETE FROM `creature_loot_template` WHERE `entry`='115981'; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (78948, 115981, 100, 1, 0, 1, 4) Pol Abrogator Stone DELETE FROM `creature_loot_template` WHERE `entry`='115280'; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (78238, 105715, 100, 1, 0, 1, 1), Abrogator Stone Cluster DELETE FROM `creature_loot_template` WHERE `entry`='115981'; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (78238, 115981, 100100, 1, 0, 1, 4) Phemos Abrogator Stone DELETE FROM `creature_loot_template` WHERE `entry`='115280'; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (78237, 105715, 100, 1, 0, 1, 1), Abrogator Stone Cluster DELETE FROM `creature_loot_template` WHERE `entry`='115981'; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (78237, 115981, 100, 1, 0, 1, 4) Ko'ragh <Breaker of Magic> Abrogator Stone DELETE FROM `creature_loot_template` WHERE `entry`='115280'; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (79015, 105715, 100, 1, 0, 1, 1), Abrogator Stone Cluster DELETE FROM `creature_loot_template` WHERE `entry`='115981'; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (79015, 115981, 100, 1, 0, 1, 4) Imperator Mar'gok <Sorcerer King> Abrogator Stone DELETE FROM `creature_loot_template` WHERE `entry`='115280'; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (77428, 105715, 100100, 1, 0, 1, 1), Abrogator Stone Cluster DELETE FROM `creature_loot_template` WHERE `entry`='115981'; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (77428, 115981, 100100100, 1, 0, 1, 4) Boss Link :Kargath Bladefist Brackenspore Brackenspore Tectus Pol Phemos Ko'ragh Imperator Mar'gok http://wow.gamepedia.com/Abrogator_Stone http://us.battle.net/wow/en/forum/topic/15700020938 So idk its fixed but i don't know i'm only 16 ^^ this is my first time Share this post Link to post Share on other sites
Posted January 6, 2016 Hello Rymnor, I hope you dont find it offending but you scripted it toatlly wrong. First of all you messed up with the entry. The entry is the boss id!! (You used it correctly after the insert but you didnt use it correctly in the delete from. Second, if you use Delete from on the boss id it will wipe out every single loot the boss has!!! thats why you should use Update and not Delete and Insert. Third, the loot chance is 100 max what do you mean by 100100100??? Forth, you put on some bosses at the INSERT INTO the id of http://www.wowhead.com/item=105715/epoch-stone. Example of how it should look like:(I havent scripted for a while so I might forgot somethings like the exact strucure or whatever but it should look something like that) UPDATE 'creature-loot-template' WHERE entry='77428' SET item= '115981', ChanceOrQuestChance='100', lootmode= '1', minCountOrRef='1', maxCount='1'; 1 person likes this Share this post Link to post Share on other sites
Posted January 6, 2016 If the boss just doesnt has this loot you can also just insert into (without the delete from) INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (77428, 115981, 100, 1, 0, 1, 1) Share this post Link to post Share on other sites
Posted January 6, 2016 1 hour ago, dvffg said: If the boss just doesnt has this loot you can also just insert into (without the delete from) INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (77428, 115981, 100, 1, 0, 1, 1) INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (77428, 115981, 100, 1, 0, 1, 1); Dont forget the ; Share this post Link to post Share on other sites
Posted January 12, 2016 The first, Im sorry to tell you that loot in bosses works different way that normal npcs so this patch wont work....I will speak with the devs who is working in Highmaul so they fix the loot (I wont explain the way that loot works in bosses because its more complicated). For the next patches (in normal npcs): If you arent adding the full loot, only 1,2 or 3 items, its better to use 'REPLACE INTO' instead of' INSERT INTO'. If you use 'insert into' for adding no full loot, you will delete the items which were dropping (dvffg explained it before). If you add the full loot and you use 'insert into', you have to use 'delete from' always before (this way you wont get duplicated key error when you add the patch more than 1 time). If you add more than 1 item, you can do it in the same 'insert to`. It isnt need to do 2 x 'insert into': Kargath Bladefist <Warlord of the Shattered Hand> Abrogator Stone REPLACE INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`,`itembonuses`) VALUES (78714, 105715, 1, 1, 0, 1, 1,''), (78714, 115981, 5, 1, 0, 1, 1,''); And the last thing, there is a more field in the loot,its `itembonuses` which is type char and its normaly empty. I hope that you continue uploading patches, thanks you for contribuying. This time i have to rejecte it. Sorry. Regards. Share this post Link to post Share on other sites
Posted January 12, 2016 to loot this thing you need the legendary quest if you don't have it you can't so first the have to fix the quest and after the loot Share this post Link to post Share on other sites