[FIXED] Ubunti the Shade and Muerta loot and honor

[Kyrax]

WoW Freakz link:
https://www.wow-freakz.com/npc_finder.php?npc=68322&&name=muerta
https://www.wow-freakz.com/npc_finder.php?npc=68320&&name=ubunti-the-shade
Bug description:no loot
http://www.wowhead.com/npc=68320/ubunti-the-shade
http://www.wowhead.com/npc=68322/muerta
And as you can see in this video https://youtube.com/watch?v=-_D2zbAKCNA:


"This rare is on a 1h respawn timer.
Before patch 5.4.7 this NPCs used to drop 250 Honor Points per kill.
The drop was nerfed to only once per day for each of the three rares."
Proof: http://imgur.com/a/M5f54

[Killahin]

I wrote the loot, looking at the 548 wow head DB.

--Ubunti the Shade

INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceorQuestChance`, `lootmode`, `groupid`, `mincountorRef`, `maxcount`) VALUES (68320, 91877, 99, 1, 0, 1, 11);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceorQuestChance`, `lootmode`, `groupid`, `mincountorRef`, `maxcount`) VALUES (68320, 92784, 29, 1, 0, 1, 1);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceorQuestChance`, `lootmode`, `groupid`, `mincountorRef`, `maxcount`) VALUES (68320, 87217, 19, 1, 0, 1, 1);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceorQuestChance`, `lootmode`, `groupid`, `mincountorRef`, `maxcount`) VALUES (68320, 93194, 4, 1, 0, 1, 1);


--Muerta

INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceorQuestChance`, `lootmode`, `groupid`, `mincountorRef`, `maxcount`) VALUES (68322, 91877, 99, 1, 0, 1, 11);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceorQuestChance`, `lootmode`, `groupid`, `mincountorRef`, `maxcount`) VALUES (68322, 92786, 29, 1, 0, 1, 1);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceorQuestChance`, `lootmode`, `groupid`, `mincountorRef`, `maxcount`) VALUES (68322, 87217, 18, 1, 0, 1, 1);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceorQuestChance`, `lootmode`, `groupid`, `mincountorRef`, `maxcount`) VALUES (68322, 93194, 4, 1, 0, 1, 1);

[Kyrax]

any new's?


https://www.youtube.com/watch?v=pamGqyxnohE

[Juhziz]

Killahin wrote:

I wrote the loot, looking at the 548 wow head DB

Spoiler:

--Ubunti the Shade

INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceorQuestChance`, `lootmode`, `groupid`, `mincountorRef`, `maxcount`) VALUES (68320, 91877, 99, 1, 0, 1, 11);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceorQuestChance`, `lootmode`, `groupid`, `mincountorRef`, `maxcount`) VALUES (68320, 92784, 29, 1, 0, 1, 1);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceorQuestChance`, `lootmode`, `groupid`, `mincountorRef`, `maxcount`) VALUES (68320, 87217, 19, 1, 0, 1, 1);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceorQuestChance`, `lootmode`, `groupid`, `mincountorRef`, `maxcount`) VALUES (68320, 93194, 4, 1, 0, 1, 1);


--Muerta

INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceorQuestChance`, `lootmode`, `groupid`, `mincountorRef`, `maxcount`) VALUES (68322, 91877, 99, 1, 0, 1, 11);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceorQuestChance`, `lootmode`, `groupid`, `mincountorRef`, `maxcount`) VALUES (68322, 92786, 29, 1, 0, 1, 1);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceorQuestChance`, `lootmode`, `groupid`, `mincountorRef`, `maxcount`) VALUES (68322, 87217, 18, 1, 0, 1, 1);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceorQuestChance`, `lootmode`, `groupid`, `mincountorRef`, `maxcount`) VALUES (68322, 93194, 4, 1, 0, 1, 1);

Trebuie sa imparti chance loot la "x" rata serverului.

INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceorQuestChance`, `lootmode`, `groupid`, `mincountorRef`, `maxcount`) VALUES (68320, 91877, 19.8, 1, 0, 1, 11);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceorQuestChance`, `lootmode`, `groupid`, `mincountorRef`, `maxcount`) VALUES (68320, 92784, 5.8, 1, 0, 1, 1);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceorQuestChance`, `lootmode`, `groupid`, `mincountorRef`, `maxcount`) VALUES (68320, 87217, 3.8, 1, 0, 1, 1);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceorQuestChance`, `lootmode`, `groupid`, `mincountorRef`, `maxcount`) VALUES (68320, 93194, 1, 1, 0, 1, 1);

INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceorQuestChance`, `lootmode`, `groupid`, `mincountorRef`, `maxcount`) VALUES (68322, 91877, 19.8, 1, 0, 1, 11);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceorQuestChance`, `lootmode`, `groupid`, `mincountorRef`, `maxcount`) VALUES (68322, 92786, 5.8, 1, 0, 1, 1);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceorQuestChance`, `lootmode`, `groupid`, `mincountorRef`, `maxcount`) VALUES (68322, 87217, 3.8, 1, 0, 1, 1);
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceorQuestChance`, `lootmode`, `groupid`, `mincountorRef`, `maxcount`) VALUES (68322, 93194, 4, 1, 0, 1, 1);

@k0s, verifica query-urile inainte sa le rulezi (item id's).

-

[k0s]

Fixed