Tavari

Highmaul bugged drop

13 posts in this topic

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 by Rymnor
1 person likes this

Share this post


Link to post
Share on other sites
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
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 :D i fix it later

Share this post


Link to post
Share on other sites

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
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 :D

Share this post


Link to post
Share on other sites

Missing ; after )

Share this post


Link to post
Share on other sites

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

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
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

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

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
Guest
This topic is now closed to further replies.