search

Looking4Group / L4G_Core

Looking4Group Core
http://looking4group.eu
GNU General Public License v2.0
37 stars 73 forks source link

Plans: Felsteel Gloves is prob bugged #3824

Closed Prodahua closed 7 years ago

Prodahua commented 7 years ago

Hey, so on your DB the "Auchenai Monk" from Auchindoun should drop the plan with 9% rate and on other sites it shows like 0,69% drop so as Rogue u can go inside solo to the two man grps sap the priest and kill the monk when u vanish the monk respawns and i can kill him again i did this and killed the monks in auchenai crypts like 300 times and every single time hes droping only silver not one single green not one single cloth only silver, i just couldnt believe this whats going on

AnonXS commented 7 years ago

Sounds like no Loottable being linked to the mob.

http://db.hellfire-tbc.com/?npc=18497, http://db.hellfire-tbc.com/?npc=20299

http://db.hellfire-tbc.com/?item=23605, http://db.hellfire-tbc.com/?item=23606, http://db.hellfire-tbc.com/?item=23607

Prodahua commented 7 years ago

But i have seen this recipe on other players also the "plans: felsteel leggings" from unchained doombringer on the hellfire DB its like 10% droprate hahaha never its just not possible so how can i get this i have seen players with both, and is the first recipe just bugged when soloed ?

Prodahua commented 7 years ago

HAHAHAHA now after i reported this i farmed crypts now 3h+ still not dropping and even worse when i solo it like before saping priest-killing monk-vanish the monks spawn a add now almost every time TY

AnonXS commented 7 years ago

Just hoping you have blacksmithing with high skill otherwise you are not able to see that pattern.

Prodahua commented 7 years ago

My bs is now 375 i farmed the khoriumbelt plan whats again not the helffire db droprate like 2% is it took me 5h i had bs skill 361 when i farmed at crypts and arca

AnonXS commented 7 years ago 

DELETE FROM `creature_loot_template` WHERE `entry` IN (18497,20299);
INSERT INTO `creature_loot_template` VALUES (18497, 21877, 24.59, 0, 2, 3, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (18497, 27855, 6, 0, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (18497, 27860, 3, 0, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (18497, 23605, 8.56, 0, 1, 1, 7, 164, 1);
INSERT INTO `creature_loot_template` VALUES (18497, 24000, 3, 1, -24000, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (18497, 24001, 3, 1, -24001, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (18497, 24007, 1, 1, -24007, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (18497, 24008, 1, 1, -24008, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (18497, 24035, 1, 1, -24035, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (18497, 24092, 0.5, 1, -24092, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (18497, 50028, 0.005, 1, -50028, 1, 0, 0, 0);

INSERT INTO `creature_loot_template` VALUES (20299, 21877, 24.59, 0, 2, 3, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (20299, 27855, 9, 0, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (20299, 27860, 4, 0, 1, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (20299, 23605, 11.2, 0, 1, 1, 7, 164, 1);
INSERT INTO `creature_loot_template` VALUES (20299, 24001, 3, 1, -24001, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (20299, 24002, 3, 1, -24002, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (20299, 24011, 1, 1, -24011, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (20299, 24013, 1, 1, -24013, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (20299, 24014, 0.2, 1, -24014, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (20299, 24035, 1, 1, -24035, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (20299, 24092, 0.5, 1, -24092, 1, 0, 0, 0);
INSERT INTO `creature_loot_template` VALUES (20299, 50028, 0.005, 1, -50028, 1, 0, 0, 0);

UPDATE `creature_template` SET `pickpocketloot` = 20299 WHERE `entry` = 20299;
DELETE FROM `pickpocketing_loot_template` WHERE `entry` = 20299;
INSERT INTO `pickpocketing_loot_template` VALUES (20299, 29571, 8.64, 0, 1, 1, 0, 0, 0);
INSERT INTO `pickpocketing_loot_template` VALUES (20299, 29569, 10.08, 0, 1, 1, 0, 0, 0);
INSERT INTO `pickpocketing_loot_template` VALUES (20299, 22829, 3.52, 0, 1, 1, 0, 0, 0);
INSERT INTO `pickpocketing_loot_template` VALUES (20299, 27855, 3.2, 0, 1, 1, 0, 0, 0);
INSERT INTO `pickpocketing_loot_template` VALUES (20299, 30458, 2.24, 0, 1, 1, 0, 0, 0);
INSERT INTO `pickpocketing_loot_template` VALUES (20299, 23439, 0.16, 0, 1, 1, 0, 0, 0);
INSERT INTO `pickpocketing_loot_template` VALUES (20299, 27856, 2.56, 0, 1, 1, 0, 0, 0);

-- this is just wrong
DELETE FROM `creature_loot_template` WHERE `item` = 28551;

Befor: unbenannt After: unbenannt

Didnt change dropchance, just improving loottable.

AnonXS commented 7 years ago

https://github.com/Looking4Group/L4G_Core/pull/3843/commits/41b06d9c955965be48e7bdf789572ff62a2bfe79