Missing NOrthrend Mining Loots

[BloodLord]

These are some Northrend gobjec loots (arcemu compatible) Testes and working great.

Just copy-paste the code into your query and execute it to avoid any errors (this is recomanded to avoid getting an error if you already have some of the data)





INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189978, 36909, 100, 0, 1, 4, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189978, 37701, 13.1, 0, 1, 2, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189978, 37705, 12.1, 0, 1, 2, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189978, 36917, 0.2, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189978, 36929, 0.2, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189978, 36920, 0.2, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189978, 36932, 0.2, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189978, 36926, 0.2, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189978, 36923, 0.2, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189979, 37701, 16.1, 0, 1, 2, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189979, 37705, 16.1, 0, 1, 2, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189979, 36917, 0.5, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189979, 36929, 0.5, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189979, 36920, 0.5, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189979, 36932, 0.5, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189979, 36926, 0.5, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189979, 36923, 0.5, 0, 1, 1, 0),
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189979, 36909, 100, 0, 1, 7, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189979, 36924, 0.2, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189979, 36930, 0.2, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189979, 36927, 0.2, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189979, 36933, 0.2, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189979, 36921, 0.2, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189981, 36912, 100, 0, 1, 7, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189981, 37703, 30.1, 0, 1, 8, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189981, 37701, 30.1, 0, 1, 8, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189981, 36917, 2.1, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189981, 36929, 2.1, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189981, 36920, 2.1, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189981, 36932, 2.1, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189981, 36926, 2.1, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189981, 36923, 2.1, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189981, 36924, 0.3, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189981, 36930, 0.3, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189981, 36927, 0.3, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189981, 36933, 0.3, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189981, 36921, 0.3, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189981, 36918, 0.3, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189980, 36912, 100, 0, 1, 4, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189980, 37703, 30.1, 0, 1, 2, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189980, 37701, 30.1, 0, 1, 2, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189980, 36917, 0.2, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189980, 36929, 0.2, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189980, 36920, 0.2, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189980, 36932, 0.2, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189980, 36926, 0.2, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 189980, 36923, 0.2, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 191133, 36910, 100, 0, 1, 4, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 191133, 37705, 50.1, 0, 1, 6, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 191133, 37701, 50.1, 0, 1, 6, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 191133, 37702, 50.1, 0, 1, 6, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 191133, 37700, 50.1, 0, 1, 6, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 191133, 36917, 4.1, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 191133, 36929, 4.1, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 191133, 36920, 4.1, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 191133, 36932, 4.1, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 191133, 36926, 4.1, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 191133, 36923, 4.1, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 191133, 36924, 1.2, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 191133, 36930, 1.2, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 191133, 36927, 1.2, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 191133, 36933, 1.2, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 191133, 36921, 1.2, 0, 1, 1, 0);
INSERT INTO `loot_gameobjects` (`index` ,`entryid` ,`itemid` ,`percentchance` ,`heroicpercentchance` ,`mincount` ,`maxcount` ,`ffa_loot`) VALUES (NULL, 191133, 36918, 1.2, 0, 1, 1, 0);




Enjoy
Credits:
Me for the time to make this script :) (100% wowhead data)

[jtarules89]

Thanks for putting this together, this could come in handy.

[Magissia]

Thanks !

[BloodLord]

Np :)


Glad I can help

[Lbniese]

Hmmm can you please make a download link too, then it would be much better, but still nice

*Woopz, Sorry for revive*

[enegue]

LBNIESE YOU ******! I don't mean it but seriously!! Stop it. It's pretty annoying. DON'T BOTHER REPLYING.

[Lbniese]

Lol yes, my bad. AGAIN

[enegue]

DUDE **** OFF! I mean it. I know you already have an infraction.