Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[335] Burning Destroyer Loot Table (low drop rates, too many items) #18182

Closed
MrSmite opened this issue Nov 1, 2016 · 39 comments
Closed

[335] Burning Destroyer Loot Table (low drop rates, too many items) #18182

MrSmite opened this issue Nov 1, 2016 · 39 comments
Labels
Branch-3.3.5a Comp-Database Feedback-PatchFix

Comments

@MrSmite
Copy link
Contributor

MrSmite commented Nov 1, 2016 •
edited by ghost

Description: The drop rates for items off the Burning Destroyer (entry 4038) are 0.02 for many items.

Current behaviour: A lot of items have an extremely low drop rate of 0.02. Using wowhead as a basis, the lowest drop rate is 6% for an item used in crafting and the two quest items it drops are even higher.

Expected behaviour: Drop rates should be increased slightly

Steps to reproduce the problem:

  1. SELECT `entry` FROM `creature_template` WHERE `name`='Burning Destroyer';
  2. Result: 4038
  3. SELECT * FROM `creature_loot_template` WHERE `entry`= 4038;

Branch(es): 3.3.5

TC rev. hash/commit: 2db9269

TDB version: TDB_full_world_335.61_2016_04_11.sql + Updates

Operating system: WinXP / Win 7

Notes

  • This NPC also appears to drop 4 items based on wowhead but Trinity's loot table contains 52 items.
  • I know loot usually comes from sniffs but this one seems to be wrong
@SnapperRy
Copy link
Contributor

Loot doesn't come from sniffs sadly, that's why there is so much wrong data there. Most of them come from Wowhead parses back then, but that's hardly reliable for some cases :|

@MrSmite
Copy link
Contributor Author

MrSmite commented Nov 2, 2016 •
edited

Loot doesn't come from sniffs sadly,

Thanks, it's been a long time since I've looked at anything regarding loot and I wasn't sure if this was one of those "don't use wowhead" things.

The only reason this caught my eye here was I remembered farming them for Elemental Fire years back on retail (for my Alchemist to make fire resist for raids) and I wasn't seeing them drop in Trinity. I half expected the loot table to be empty.

@ghost
Copy link

ghost commented Nov 2, 2016

Did you notice that comment on wowhead, http://www.wowhead.com/npc=4038/burning-destroyer#comments:id=138911 , a player noticing that the drop rate had sunk a lot for that NPC?
Unfortunately, I never had to farm Elemental Fire myself on retail back then, so I don't know much about it. I only noticed the item randomly after reaching max level and killing random mobs for quests etc.

@Aokromes
Copy link
Member

Aokromes commented Nov 2, 2016

It looks on 3.3.5a it had a lot of garbage:

http://web.archive.org/web/20100408004042/http://www.wowhead.com/npc=4038

@offl
Copy link
Contributor

offl commented Nov 2, 2016 •
edited by ghost

(low drop rates, too many items)
Description: The drop rates for items off the Burning Destroyer (entry 4038) are 0.02 for many items.

His loot table should contain recipes. Drop rate should be low. But..
But here's a global bug: for classic creatures TC don't have references, which contains recipes.
So sometimes you can find something like this:

SELECT * FROM `creature_loot_template` WHERE `Item` IN (4350,4351,4352,4353);
-- Or you can view all recipes with small drop chance
SELECT * FROM `creature_loot_template` WHERE `Item` IN (SELECT `Entry` FROM `item_template` WHERE `class` = 9) AND `Reference` = 0;

Should be like this(this was done for Outland creatures, but not for Azeroth creatures):

SELECT * FROM `creature_loot_template` WHERE `Entry` = `19168`;
SELECT * FROM `reference_loot_template` WHERE `Entry` IN (24092,24093);
-- Perfect, as it should be
SELECT * FROM `creature_loot_template` WHERE `Item` IN (24092,24093);

Recipes contained in references.
Sorry, but I can't provide more detailed description in english.

Expected behaviour: Drop rates should be increased slightly

Huh, no :) Should be descreased, because without references items drops more frequently :)

@MrSmite
Copy link
Contributor Author

MrSmite commented Nov 2, 2016 •
edited

@tkrokli Yes, I did notice that but considering wowhead has it at 6%, it is very possible that player simply ran into a streak of bad luck. That and the fact there aren't a lot of these NPC spawned anyway. Depending on the respawn rate, it's feasible to farm for 4 hours and not see a 6% rate item.

@offl "Drop rate should be low" - I agree and IMO the 6% listed on wowhead is the "low" it should be. The 0.02% rate that Trinity has is pretty much nonexistant (approx. 18% in 1000 kills).

@ghost
Copy link

ghost commented Nov 2, 2016

0.02% is even lower, it is on par with Battered Hilt. 2% = 2 in 100, 0,2% = 2 in 1000, so 0.02% = 2 in 10,000.

@MrSmite
Copy link
Contributor Author

MrSmite commented Nov 3, 2016 •
edited

Huh, no :) Should be descreased, because without references items drops more frequently :)

If we base loot on wowhead then the elemental fire drop from this mob should be 6%, not 0.02. The fact that there are only a handful of these mobs spawned at a time (less than 10) is enough of a gating mechanism.

@offl
Copy link
Contributor

offl commented Nov 3, 2016

A lot of items have an extremely low drop rate of 0.02.

You said about items, which have low drop rate - 0.02.
Items with 0.02 drop rate - recipes.
And my story above was about recipes with drop rate 0.02, not about Elemental Fire.
I really don't know why you talk about Elemental Fire in this case.

@MrSmite
Copy link
Contributor Author

MrSmite commented Nov 3, 2016

I really don't know why you talk about Elemental Fire in this case.

I was talking about in terms of the number of possible loot items vs. the chance that Elemental Fire (7068) would even end up in the loot list when the core rolls for loot. Seems like Elemental Fire should have a higher chance (currently it's 6.118) to simulate a 6% drop rate.

Perhaps the problem is that there are 52 items when it should only be 4.

@offl
Copy link
Contributor

offl commented Nov 3, 2016

Perhaps the problem is that there are 52 items when it should only be 4.

In 3.3.5 he should have a huge list of items. Rogue Flame Spirit or Burning Ravager - too.
In this case wowhead is not a correct source for 3.3.5.

I really can't see any problem here except the problem with unimplemented references for recipes.

@offl
Copy link
Contributor

offl commented Feb 5, 2017

More info.

@MrSmite
Copy link
Contributor Author

MrSmite commented Feb 6, 2017 •
edited

Here's another reason why I believe the drop rate is too low at 0.02

-- Look up the various 'elemental' crafting items (eg: Elemental Fire, Elemental Water)
SELECT * FROM `item_template` WHERE `name` LIKE '%elemental%' AND `class`=7 AND `subclass`=10;

-- Now let's look at the drop rates
SELECT * FROM `creature_loot_template` WHERE `item` IN (7067,7068,7069,7070);

If you look at that list, you'll notice there are several NPCs where these "elemental" crafting items have a 0.02 Chance while other NPCs have them at between 2 and 10 with some even as high as 80. When you factor in the extra junk that doesn't belong, it results in most often the NPC drops nothing at all.

@offl
Copy link
Contributor

offl commented Feb 17, 2017 

SELECT * FROM `creature_loot_template` WHERE `Item` IN (7067,7068,7069,7070) AND `Chance` < 1;

Their loot tables shouldn't contain these items.
Currently they contain these items only because on retail someone used wowhead addon and opened Bag of Spoils while targeting Stonelash Pincer, Sand Skitterer and Twilight Flamereaver.

Bag of Spoils can be awarded in Silithus. Stonelash Pincer, Sand Skitterer or Twilight Flamereaver live in Silithus.

You can read multiple comments about that on wowhead.

@offl
Copy link
Contributor

offl commented Feb 17, 2017 •
edited

Also Stonelash Pincer, Sand Skitterer and Twilight Flamereaver are not elementals.

Also you can see an my fix. That's what i'm talking about above.

-- These items should be contained only in Decoded True Believer Clippings
DELETE FROM `creature_loot_template` WHERE `Item` IN (20518,20531,20532,20541,20545,20546,20552,20676,20677,20678,20679);

@ghost
Copy link

ghost commented Feb 17, 2017 •
edited by ghost

Finally I found out how to INNER JOIN info from 3 (or more) tables to see the info I want when the Comment column IS NULL (not showing names of the items / creature entries and I used to look them up separately).

SELECT c_l_t.Entry, c_t.name, c_l_t.Item, i_t.name, c_l_t.Reference, c_l_t.Chance,
 c_l_t.QuestRequired, c_l_t.LootMode, c_l_t.GroupId, c_l_t.MinCount, c_l_t.MaxCount
 FROM `creature_loot_template` c_l_t
 INNER JOIN `creature_template` c_t ON c_l_t.Entry = c_t.entry
 INNER JOIN `item_template` i_t ON c_l_t.Item = i_t.Entry
 WHERE c_l_t.Item IN (20518,20531,20532,20541,20545,20546,20552,20676,20677,20678,20679)
 ORDER BY `Entry`,`Item`;
Entry  name                      Item  name                                Reference  Chance  QuestRequired  LootMode  GroupId  MinCount  MaxCount
-----  ----------------------  ------  ----------------------------------  ---------  ------  -------------  --------  -------  --------  --------
 7449  Chillwind Ravager        20532  Scroll: Create Signet of Beckoning          0    0.02              0         1        0         1         1
 7449  Chillwind Ravager        20679  Decoded Twilight Text                       0    0.02              0         1        0         1         1
 8602  Monstrous Plaguebat      20532  Scroll: Create Signet of Beckoning          0    0.02              0         1        0         1         1
 8602  Monstrous Plaguebat      20679  Decoded Twilight Text                       0    0.02              0         1        0         1         1
11738  Sand Skitterer           20541  Decoded Twilight Text                       0    0.02              0         1        0         1         1
11738  Sand Skitterer           20545  Decoded Twilight Text                       0    0.02              0         1        0         1         1
11738  Sand Skitterer           20552  Decoded Twilight Text                       0    0.02              0         1        0         1         1
11803  Twilight Keeper Exeter   20518  Scroll: Create Crest of Beckoning           0    0.02              0         1        0         1         1
11803  Twilight Keeper Exeter   20531  Scroll: Create Signet of Beckoning          0    0.02              0         1        0         1         1
11803  Twilight Keeper Exeter   20679  Decoded Twilight Text                       0    0.02              0         1        0         1         1
11880  Twilight Avenger         20545  Decoded Twilight Text                       0    0.02              0         1        0         1         1
11881  Twilight Geolord         20541  Decoded Twilight Text                       0    0.02              0         1        0         1         1
11881  Twilight Geolord         20546  Pattern: Runed Stygian Leggings             0    0.02              0         1        0         1         1
11881  Twilight Geolord         20678  Decoded Twilight Text                       0    0.02              0         1        0         1         1
11881  Twilight Geolord         20679  Decoded Twilight Text                       0    0.02              0         1        0         1         1

( or sorted by Item ID first, then Entry )

Entry  name                      Item  name                                Reference  Chance  QuestRequired  LootMode  GroupId  MinCount  MaxCount
-----  ----------------------  ------  ----------------------------------  ---------  ------  -------------  --------  -------  --------  --------
11803  Twilight Keeper Exeter   20518  Scroll: Create Crest of Beckoning           0    0.02              0         1        0         1         1
11803  Twilight Keeper Exeter   20531  Scroll: Create Signet of Beckoning          0    0.02              0         1        0         1         1
 7449  Chillwind Ravager        20532  Scroll: Create Signet of Beckoning          0    0.02              0         1        0         1         1
 8602  Monstrous Plaguebat      20532  Scroll: Create Signet of Beckoning          0    0.02              0         1        0         1         1
11738  Sand Skitterer           20541  Decoded Twilight Text                       0    0.02              0         1        0         1         1
11881  Twilight Geolord         20541  Decoded Twilight Text                       0    0.02              0         1        0         1         1
11738  Sand Skitterer           20545  Decoded Twilight Text                       0    0.02              0         1        0         1         1
11880  Twilight Avenger         20545  Decoded Twilight Text                       0    0.02              0         1        0         1         1
11881  Twilight Geolord         20546  Pattern: Runed Stygian Leggings             0    0.02              0         1        0         1         1
11738  Sand Skitterer           20552  Decoded Twilight Text                       0    0.02              0         1        0         1         1
11881  Twilight Geolord         20678  Decoded Twilight Text                       0    0.02              0         1        0         1         1
 7449  Chillwind Ravager        20679  Decoded Twilight Text                       0    0.02              0         1        0         1         1
 8602  Monstrous Plaguebat      20679  Decoded Twilight Text                       0    0.02              0         1        0         1         1
11803  Twilight Keeper Exeter   20679  Decoded Twilight Text                       0    0.02              0         1        0         1         1
11881  Twilight Geolord         20679  Decoded Twilight Text                       0    0.02              0         1        0         1         1

Modifying the INNER JOIN query and using it on the Elemental items, we get the following output:

Entry  name                  Item  name             Reference  Chance  QuestRequired  LootMode  GroupId  MinCount  MaxCount
-----  --------------------  ----  ---------------  ---------  ------  -------------  --------  -------  --------  --------
11736  Stonelash Pincer      7069  Elemental Air            0    0.02              0         1        0         1         1
11736  Stonelash Pincer      7070  Elemental Water          0    0.02              0         1        0         1         1
11738  Sand Skitterer        7067  Elemental Earth          0    0.02              0         1        0         1         1
15201  Twilight Flamereaver  7070  Elemental Water          0    0.02              0         1        0         1         1

(TDB 335.62 + updates up to & including 2017_02_14_00_world.sql )

Killyana pushed a commit that referenced this issue Feb 18, 2017
@offl @Killyana
DB/Loot: Remove some wrong loots
6d12700 
Update #18182
Aokromes pushed a commit to Aokromes/TrinityCore that referenced this issue Feb 19, 2017
@offl @Aokromes
DB/Loot: Remove some wrong loots
a5bc07d 
Update TrinityCore#18182
Shauren pushed a commit that referenced this issue Jul 21, 2019
@offl @Shauren
DB/Loot: Remove some wrong loots
16d48f8 
Update #18182

(cherrypicked from 6d12700)
@offl
Copy link
Contributor

offl commented Mar 4, 2020

Kinda related. The only reason these herbs and ore are in loot templates is players collected them while targeting NPCs, so wowhead addon added them to NPCs loot tables. Then it was parsed.

A good argument here is herbs and ores in loot templates is mostly classic wow problem. It's because Outland and Northrend(?) loot tables were implemented without parsing from wowhead. They're much cleaner. Just compare Northrend and classic:

SELECT * FROM `creature_loot_template` WHERE `Item` IN (36901,36902,36903,36904,36905,36906,36907,36908,36909,36910,36912,37921);

SELECT * FROM `creature_loot_template` WHERE `Item` IN (765,785,2447,2449,2450,2452,2453,2770,2771,2772,2775,2776,2835,2836,2838,3355,3356,3357,3358,3369,3470,3478,3486,3818,3819,3820,3821,3857,3858,4625,7911,7912,7966,8153,8831,8836,8838,8839,8845,8846,10620,11370,12365,12644,12809,13463,13464,13465,13466,13467,13468,19726,19727,22202,22203,22710,22785,22786,22787,22788,22789,22790,22791,22792,22793,22794,22797,23424,23425,23426,23427,35128);

I'm still unsure about the chance because it appears some creature must drop herbs and ores. If you unsure about this, change the chance to <= 0.02. It will still affect thousand entries. But I recommend < 1.

DELETE FROM `creature_loot_template` WHERE `Item` IN (765,785,2447,2449,2450,2452,2453,2770,2771,2772,2775,2776,2835,2836,2838,3355,3356,3357,3358,3369,3470,3478,3486,3818,3819,3820,3821,3857,3858,4625,7911,7912,7966,8153,8831,8836,8838,8839,8845,8846,10620,11370,12365,12644,12809,13463,13464,13465,13466,13467,13468,19726,19727,22202,22203,22710,22785,22786,22787,22788,22789,22790,22791,22792,22793,22794,22797,23424,23425,23426,23427,35128,36901,36902,36903,36904,36905,36906,36907,36908,36909,36910,36912,37921) AND `Chance` < 1;

@Aokromes
Copy link
Member

Aokromes commented Mar 4, 2020

Kinda related. The only reason these herbs and ore are in loot templates is players collected them while targeting NPCs, so wowhead addon added them to NPCs loot tables. Then it was parsed.

A good argument here is herbs and ores in loot templates is mostly classic wow problem. It's because Outland and Northrend(?) loot tables were implemented without parsing from wowhead. They're much cleaner. Just compare Northrend and classic:

SELECT * FROM `creature_loot_template` WHERE `Item` IN (36901,36902,36903,36904,36905,36906,36907,36908,36909,36910,36912,37921);

SELECT * FROM `creature_loot_template` WHERE `Item` IN (765,785,2447,2449,2450,2452,2453,2770,2771,2772,2775,2776,2835,2836,2838,3355,3356,3357,3358,3369,3470,3478,3486,3818,3819,3820,3821,3857,3858,4625,7911,7912,7966,8153,8831,8836,8838,8839,8845,8846,10620,11370,12365,12644,12809,13463,13464,13465,13466,13467,13468,19726,19727,22202,22203,22710,22785,22786,22787,22788,22789,22790,22791,22792,22793,22794,22797,23424,23425,23426,23427,35128);

I'm still unsure about the chance because it appears some creature must drop herbs and ores. If you unsure about this, change the chance to <= 0.02. It will still affect thousand entries. But I recommend < 1.

DELETE FROM `creature_loot_template` WHERE `Item` IN (765,785,2447,2449,2450,2452,2453,2770,2771,2772,2775,2776,2835,2836,2838,3355,3356,3357,3358,3369,3470,3478,3486,3818,3819,3820,3821,3857,3858,4625,7911,7912,7966,8153,8831,8836,8838,8839,8845,8846,10620,11370,12365,12644,12809,13463,13464,13465,13466,13467,13468,19726,19727,22202,22203,22710,22785,22786,22787,22788,22789,22790,22791,22792,22793,22794,22797,23424,23425,23426,23427,35128,36901,36902,36903,36904,36905,36906,36907,36908,36909,36910,36912,37921) AND `Chance` < 1;

myself i have seen wtf drops (gems, herbs) from some creatures without have mining or herbalism on retail.

@offl
Copy link
Contributor

offl commented Mar 4, 2020

Like https://woehead.way-of-elendil.fr/?npc=12836#drops ?

@Killyana
Copy link
Member

Killyana commented Mar 4, 2020

If you compare classic and bfa loot, the result is stunning:
https://www.wowhead.com/npc=4038/burning-destroyer#drops
https://classic.wowhead.com/npc=4038/burning-destroyer#drops

Imo the wow addon that was used in older expansion was grabbing wrong data in some situations like mining and gathering herbs when you have a dead npc as target.
Also if you are in a party with a dead npc as target, and a member of the group loot an other npc .

About herbs dropped by creature: Only the ones that looks like trees, plants, flowers must drop.

About ore: Only elemental, and creatures in mines (miners) must drop

Fixing this loots will take a long time, I don't know if it be done.

@offl
Copy link
Contributor

offl commented Mar 4, 2020

Classic wowhead probably uses old data or simply more players killed this creature. And classic is less populated in bfa.
Web archive: http://web.archive.org/web/20100409045141/http://www.wowhead.com/npc=4038

@offl
Copy link
Contributor

offl commented Mar 4, 2020 •
edited

About herbs dropped by creature: Only the ones that looks like trees, plants, flowers must drop.

About ore: Only elemental, and creatures in mines (miners) must drop

Even if creature is not a tree the 0.02 chance looks weird. But < 1 will remove herbs from Warpwood Moss Flayer and his loot table contains so much different herbs so I think < 1 can be incorrect for some creatures

<= 0.02 is more safe then

@offl
Copy link
Contributor

offl commented Mar 6, 2020

In some cases references can be done easily:

SET @ID := 34400;

DELETE FROM `reference_loot_template` WHERE `Entry` = @ID;
INSERT INTO `reference_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`,`Comment`) VALUES
(@ID,22146,0,0,0,1,1,1,1,"Book: Gift of the Wild III"),
(@ID,22153,0,0,0,1,1,1,1,"Tome of Arcane Brilliance 2"),
(@ID,29549,0,0,0,1,1,1,1,"Codex: Prayer of Fortitude III"),
(@ID,29550,0,0,0,1,1,1,1,"Tome of Conjure Water IX"),
(@ID,31501,0,0,0,1,1,1,1,"Tome of Conjure Food VIII"),
(@ID,31837,0,0,0,1,1,1,1,"Codex: Prayer of Shadow Protection II");

DELETE FROM `creature_loot_template` WHERE `Item` IN (22146,22153,29549,29550,31501,31837);
DELETE FROM `creature_loot_template` WHERE `Item` = @ID AND `Reference` = @ID AND `Entry` IN (15547,15548,15551,16170,16171,16173,16174,16175,16178,16389,16406,16407,16408,16409,16412,16414,16415,16424,16425,16459,16461,16468,16470,16471,16472,16473,16481,16482,16485,16488,16489,16491,16492,16504,16525,16526,16529,16530,16539,16540,16544,16570,16595,16596,16945,17400,17814,17840,17993,17994,18155,18311,18312,18313,18315,18318,18319,18321,18323,18325,18326,18327,18328,18331,18404,18405,18419,18420,18421,18423,18461,18493,18495,18498,18499,18500,18501,18503,18524,18535,18536,18557,18558,18559,18631,18632,18633,18634,18635,18636,18637,18638,18639,18640,18642,18663,18702,18794,18796,18848,18856,18982,19166,19167,19208,19209,19428,19429,19486,19494,19505,19507,19508,19509,19511,19512,19513,19557,19598,19633,19712,19735,19747,19843,19865,19943,19944,19945,19960,19961,19963,19973,19984,19985,19986,19988,19990,19991,19993,19997,20031,20032,20033,20035,20036,20038,20039,20040,20041,20043,20049,20052,20058,20059,20216,20330,20334,20614,20680,20713,20714,20723,20729,20748,20751,20765,20857,20859,20866,20867,20868,20873,20875,20881,20882,20883,20896,20897,20901,20902,20905,20906,20909,20911,20925,20988,20990,21004,21033,21046,21057,21102,21123,21220,21224,21225,21226,21229,21230,21231,21232,21246,21251,21254,21263,21298,21299,21301,21339,21380,21383,21387,21492,21702,21722,21723,21767,21821,21839,21891,22044,22072,22195,22204,22254,22257,22286,22291,22847,22878,22879,22883,22939,22945,22946,22955,22960,22963,22964,23026,23029,23061,23067,23161,23162,23163,23165,23219,23222,23261,23285,23324,23339,23386,23542,23580,23581,23584,23586,23596,23597,23651,23652,23660,23661,23663,23674,23676,23690,23691,23725,23740,23760,23774,23793,23834,23874,23919,23959,23967,23989,23992,24014,24043,24064,24065,24073,24116,24179,24214,24228,24285,24371,24374,24547,24601,24614,24633,24676,24677,24681,24747,24779,24871,24872,25204,25216,25217,25226,25227,25350,25353,25386,25428,25429,25433,25449,25464,25467,25496,25522,25605,25615,25622,25650,25651,25660,25675,25680,25687,25707,25718,25721,25722,25728,25752,25760,25801,25804,25836,25843,25880,25979,26196,26197,26198,26199,26202,26252,26280,26281,26291,26343,26363,26366,26369,26370,26389,26402,26446,26447,26455,26467,26483,26592,26605,26606,26613,26643,26795,26797,26812,26816,26926,27105,27117,27202,27203,27226,27229,27259,27284,27330,27362,27363,27370,27382,27401,27421,27539,27546,27615,27699,27797,27830,27859,27860);
INSERT INTO `creature_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`,`Comment`) VALUES
(15547,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(15548,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(15551,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16170,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16171,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16173,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16174,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16175,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16178,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16389,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16406,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16407,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16408,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16409,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16412,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16414,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16415,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16424,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16425,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16459,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16461,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16468,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16470,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16471,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16472,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16473,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16481,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16482,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16485,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16488,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16489,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16491,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16492,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16504,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16525,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16526,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16529,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16530,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16539,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16540,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16544,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16570,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16595,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16596,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(16945,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(17400,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(17814,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(17840,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(17993,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(17994,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18155,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18311,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18312,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18313,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18315,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18318,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18319,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18321,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18323,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18325,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18326,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18327,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18328,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18331,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18404,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18405,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18419,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18420,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18421,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18423,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18461,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18493,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18495,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18498,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18499,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18500,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18501,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18503,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18524,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18535,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18536,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18557,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18558,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18559,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18631,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18632,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18633,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18634,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18635,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18636,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18637,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18638,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18639,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18640,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18642,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18663,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18702,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18794,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18796,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18848,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18856,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(18982,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19166,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19167,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19208,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19209,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19428,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19429,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19486,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19494,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19505,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19507,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19508,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19509,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19511,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19512,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19513,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19557,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19598,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19633,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19712,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19735,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19747,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19843,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19865,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19943,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19944,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19945,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19960,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19961,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19963,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19973,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19984,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19985,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19986,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19988,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19990,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19991,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19993,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(19997,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20031,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20032,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20033,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20035,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20036,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20038,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20039,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20040,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20041,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20043,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20049,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20052,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20058,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20059,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20216,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20330,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20334,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20614,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20680,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20713,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20714,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20723,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20729,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20748,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20751,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20765,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20857,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20859,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20866,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20867,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20868,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20873,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20875,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20881,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20882,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20883,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20896,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20897,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20901,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20902,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20905,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20906,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20909,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20911,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20925,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20988,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(20990,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(21004,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(21033,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(21046,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(21057,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(21102,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(21123,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(21220,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(21224,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(21225,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(21226,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(21229,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(21230,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(21231,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(21232,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(21246,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(21251,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(21254,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(21263,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(21298,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(21299,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(21301,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(21339,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(21380,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(21383,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(21387,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(21492,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(21702,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(21722,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(21723,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(21767,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(21821,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(21839,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(21891,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(22044,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(22072,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(22195,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(22204,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(22254,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(22257,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(22286,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(22291,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(22847,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(22878,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(22879,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(22883,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(22939,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(22945,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(22946,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(22955,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(22960,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(22963,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(22964,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23026,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23029,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23061,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23067,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23161,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23162,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23163,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23165,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23219,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23222,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23261,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23285,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23324,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23339,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23386,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23542,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23580,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23581,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23584,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23586,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23596,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23597,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23651,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23652,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23660,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23661,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23663,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23674,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23676,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23690,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23691,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23725,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23740,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23760,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23774,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23793,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23834,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23874,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23919,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23959,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23967,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23989,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(23992,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(24014,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(24043,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(24064,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(24065,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(24073,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(24116,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(24179,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(24214,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(24228,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(24285,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(24371,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(24374,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(24547,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(24601,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(24614,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(24633,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(24676,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(24677,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(24681,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(24747,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(24779,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(24871,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(24872,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25204,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25216,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25217,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25226,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25227,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25350,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25353,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25386,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25428,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25429,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25433,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25449,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25464,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25467,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25496,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25522,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25605,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25615,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25622,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25650,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25651,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25660,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25675,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25680,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25687,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25707,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25718,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25721,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25722,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25728,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25752,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25760,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25801,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25804,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25836,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25843,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25880,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(25979,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(26196,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(26197,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(26198,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(26199,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(26202,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(26252,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(26280,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(26281,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(26291,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(26343,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(26363,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(26366,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(26369,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(26370,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(26389,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(26402,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(26446,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(26447,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(26455,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(26467,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(26483,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(26592,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(26605,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(26606,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(26613,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(26643,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(26795,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(26797,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(26812,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(26816,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(26926,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(27105,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(27117,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(27202,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(27203,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(27226,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(27229,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(27259,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(27284,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(27330,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(27362,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(27363,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(27370,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(27382,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(27401,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(27421,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(27539,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(27546,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(27615,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(27699,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(27797,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(27830,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(27859,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)"),
(27860,@ID,@ID,0.5,0,1,0,1,1,"Books (Level 70)");

SET @ID := 34401;

DELETE FROM `reference_loot_template` WHERE `Entry` = @ID;
INSERT INTO `reference_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`,`Comment`) VALUES
(@ID,11732,0,0,0,1,1,1,1,"Libram of Rumination"),
(@ID,11733,0,0,0,1,1,1,1,"Libram of Constitution"),
(@ID,11734,0,0,0,1,1,1,1,"Libram of Tenacity"),
(@ID,11736,0,0,0,1,1,1,1,"Libram of Resilience"),
(@ID,11737,0,0,0,1,1,1,1,"Libram of Voracity");

DELETE FROM `creature_loot_template` WHERE `Item` IN (11732,11733,11734,11736,11737);
DELETE FROM `creature_loot_template` WHERE `Item` = @ID AND `Reference` = @ID AND `Entry` IN (1783,1784,1785,1787,1789,1791,1793,1794,1795,1796,1800,1801,1826,1827,1831,1833,1834,1835,1883,1884,4474,4475,4476,5977,5978,5981,6004,6005,6006,6007,6008,6009,6011,6143,6144,6189,6198,6199,6200,6201,6202,7025,7026,7033,7034,7035,7036,7037,7038,7107,7108,7110,7111,7112,7114,7115,7118,7120,7156,7157,7158,7440,7441,7442,7523,7524,7668,7669,7670,7671,7728,8298,8523,8524,8525,8530,8538,8540,8541,8547,8551,8891,8892,8893,8894,8895,8896,8897,8898,8899,8900,8902,8903,8904,8912,8913,8914,8915,8916,8920,8924,8977,9043,9044,9045,9046,9097,9098,9176,9197,9198,9199,9200,9201,9216,9239,9240,9257,9258,9267,9398,9437,9438,9439,9441,9443,9445,9447,9449,9450,9451,9452,9454,9462,9464,9476,9522,9541,9545,9547,9554,9602,9677,9678,9680,9681,9860,9861,9862,9877,9956,10043,10411,10580,10605,10608,10648,10801,10816,10919,10986,10987,10991,11290,11346,11355,11440,11442,11443,11451,11454,11455,11516,11552,11600,11602,11603,11604,11605,11675,11678,11830,11837,11887,12047,12048,12052,12179,12739,13089,13096,13099,13317,13396,13397,13539,13544,13546,14342,24818,24819,28608,28609,28610,28611,28846,28936,28939,28940,29000);
INSERT INTO `creature_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`,`Comment`) VALUES
(1783,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(1784,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(1785,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(1787,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(1789,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(1791,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(1793,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(1794,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(1795,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(1796,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(1800,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(1801,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(1826,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(1827,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(1831,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(1833,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(1834,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(1835,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(1883,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(1884,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(4474,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(4475,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(4476,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(5977,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(5978,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(5981,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(6004,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(6005,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(6006,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(6007,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(6008,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(6009,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(6011,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(6143,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(6144,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(6189,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(6198,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(6199,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(6200,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(6201,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(6202,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(7025,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(7026,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(7033,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(7034,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(7035,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(7036,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(7037,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(7038,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(7107,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(7108,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(7110,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(7111,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(7112,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(7114,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(7115,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(7118,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(7120,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(7156,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(7157,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(7158,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(7440,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(7441,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(7442,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(7523,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(7524,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(7668,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(7669,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(7670,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(7671,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(7728,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(8298,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(8523,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(8524,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(8525,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(8530,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(8538,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(8540,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(8541,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(8547,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(8551,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(8891,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(8892,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(8893,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(8894,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(8895,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(8896,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(8897,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(8898,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(8899,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(8900,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(8902,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(8903,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(8904,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(8912,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(8913,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(8914,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(8915,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(8916,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(8920,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(8924,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(8977,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9043,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9044,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9045,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9046,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9097,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9098,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9176,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9197,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9198,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9199,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9200,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9201,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9216,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9239,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9240,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9257,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9258,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9267,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9398,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9437,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9438,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9439,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9441,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9443,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9445,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9447,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9449,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9450,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9451,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9452,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9454,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9462,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9464,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9476,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9522,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9541,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9545,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9547,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9554,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9602,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9677,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9678,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9680,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9681,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9860,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9861,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9862,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9877,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(9956,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(10043,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(10411,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(10580,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(10605,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(10608,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(10648,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(10801,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(10816,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(10919,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(10986,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(10987,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(10991,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(11290,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(11346,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(11355,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(11440,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(11442,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(11443,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(11451,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(11454,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(11455,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(11516,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(11552,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(11600,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(11602,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(11603,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(11604,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(11605,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(11675,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(11678,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(11830,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(11837,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(11887,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(12047,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(12048,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(12052,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(12179,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(12739,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(13089,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(13096,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(13099,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(13317,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(13396,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(13397,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(13539,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(13544,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(13546,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(14342,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(24818,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(24819,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(28608,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(28609,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(28610,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(28611,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(28846,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(28936,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(28939,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(28940,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)"),
(29000,@ID,@ID,0.1,0,1,0,1,1,"Quest Librams (Level 50)");

offl referenced this issue in cmangos/tbc-db Mar 17, 2020
@killerwife
Even more herb removal from vanilla mobs
149e540
@Killyana
Copy link
Member

Killyana commented May 5, 2020

@offl if you want do some changes to this creature loot, or we close the issue

@offl
Copy link
Contributor

offl commented May 5, 2020 •
edited

Can be closed as invalid or you can change the title. As I said above the only thing here that is not corrent is unimplemented references for recipes(if it's even possible to implement them) and excess herbs and ore. Maybe they too should be in references and not just removed, hard to be 100% sure.

P.S. the references in #18182 (comment) are valid but there's some things I should do before we can add them, I'll open another issue for them later.

@offl
Copy link
Contributor

offl commented May 5, 2020 •
edited

and excess herbs and ore. Maybe they too should be in references and not just removed, hard to be 100% sure.

I was thinking about the references for them because most of herbs and ore shares the same weird chance as the recipes - 0.02.
But if we open http://web.archive.org/web/20100420041308/http://www.wowhead.com/npc=2374 there's no herbs or ore.
My best guess here is wowhead removed the entire loot after WotLK was launched + they fixed their addon.

And yeah, even if we decide to remove them, some NPCs shouldn't be affected, like http://web.archive.org/web/20100511134523/http://www.wowhead.com/npc=7100 with major chance to drop herbs (~0.8% mostly, but some herbs are with 0.02% and they're not in listed in wowhead)

Also run

SELECT * FROM creature_loot_template WHERE item IN (765,785,2447,2449,2450,2452,2453,2770,2771,2772,2775,2776,2835,2836,2838,3355,3356,3357,3358,3369,3470,3478,3486,3818,3819,3820,3821,3857,3858,4625,7911,7912,7966,8153,8831,8836,8838,8839,8845,8846,10620,11370,12365,12644,12809,13463,13464,13465,13466,13467,13468,19726,19727,22202,22203,22710,22785,22786,22787,22788,22789,22790,22791,22792,22793,22794,22797,23424,23425,23426,23427,35128,36901,36902,36903,36904,36905,36906,36907,36908,36909,36910,36912,37921) ORDER BY item LIMIT 100000;

And notice that the TBC and WotLK hebs and ore are included but how much less creatures drop them comparing to classic.

Maybe we can remove all of them if the chance < 0.03 but I'm worry then it'll be more hard to check the rest of them. I mean if the some herbs are with 0.02%, we should remove also other with 0.04% if it's the same creature.

@offl
Copy link
Contributor

offl commented May 5, 2020

Maybe we can remove all of them if the chance < 0.03 but I'm worry then it'll be more hard to check the rest of them. I mean if the some herbs are with 0.02%, we should remove also other with 0.04% if it's the same creature.

Well I tried

select entry from creature_template where entry in (select entry from creature_loot_template where item in (765,785,2447,2449,2450,2452,2453,2770,2771,2772,2775,2776,2835,2836,2838,3355,3356,3357,3358,3369,3470,3478,3486,3818,3819,3820,3821,3857,3858,4625,7911,7912,7966,8153,8831,8836,8838,8839,8845,8846,10620,11370,12365,12644,12809,13463,13464,13465,13466,13467,13468,19726,19727,22202,22203,22710,22785,22786,22787,22788,22789,22790,22791,22792,22793,22794,22797,23424,23425,23426,23427,35128,36901,36902,36903,36904,36905,36906,36907,36908,36909,36910,36912,37921) and chance < 0.05 limit 100000

Then

SELECT * FROM creature_loot_template WHERE entry in (result from previous query) AND item IN (765,785,2447,2449,2450,2452,2453,2770,2771,2772,2775,2776,2835,2836,2838,3355,3356,3357,3358,3369,3470,3478,3486,3818,3819,3820,3821,3857,3858,4625,7911,7912,7966,8153,8831,8836,8838,8839,8845,8846,10620,11370,12365,12644,12809,13463,13464,13465,13466,13467,13468,19726,19727,22202,22203,22710,22785,22786,22787,22788,22789,22790,22791,22792,22793,22794,22797,23424,23425,23426,23427,35128,36901,36902,36903,36904,36905,36906,36907,36908,36909,36910,36912,37921) LIMIT 100000

But it becomes even worse because now the low chance items are mixed with the high chance items(sometimes intended)

Then I wondered how many NPCs should be checked if we simply remove everything with the < 0.05 chance. And the result is 2400...
So only 350 creatures will be fully cleared.
Of course if we change the chance limit, more creatures will be fully cleared but it may remove something that should not be removed.

SELECT * FROM creature_template WHERE entry IN (SELECT entry FROM creature_loot_template WHERE item IN (765,785,2447,2449,2450,2452,2453,2770,2771,2772,2775,2776,2835,2836,2838,3355,3356,3357,3358,3369,3470,3478,3486,3818,3819,3820,3821,3857,3858,4625,7911,7912,7966,8153,8831,8836,8838,8839,8845,8846,10620,11370,12365,12644,12809,13463,13464,13465,13466,13467,13468,19726,19727,22202,22203,22710,22785,22786,22787,22788,22789,22790,22791,22792,22793,22794,22797,23424,23425,23426,23427,35128,36901,36902,36903,36904,36905,36906,36907,36908,36909,36910,36912,37921) AND chance > 0.04) LIMIT 100000

So I think they should be checked manually :/

@offl
Copy link
Contributor

offl commented May 5, 2020

Copper ore is already removed from all mobs, have no clue why or when

@Killyana
Copy link
Member

Killyana commented May 5, 2020

This loots are nightmares, for this reason I don't like touching them.

@offl
Copy link
Contributor

offl commented May 6, 2020 •
edited

I checked a lot of them if the chance was > 0.10 by using web archive and here's the result:

--
DELETE FROM `creature_loot_template` WHERE `Item` IN (765,785,2447,2449,2450,2452,2453,2770,2771,2772,2775,2776,2835,2836,2838,3355,3356,3357,3358,3369,3470,3478,3486,3818,3819,3820,3821,3857,3858,4625,7911,7912,7966,8153,8831,8836,8838,8839,8845,8846,10620,11370,12365,12644,12809,13463,13464,13465,13466,13467,13468,19726,19727,22202,22203,22710,22785,22786,22787,22788,22789,22790,22791,22792,22793,22794,22797,23424,23425,23426,23427,35128,36901,36902,36903,36904,36905,36906,36907,36908,36909,36910,36912,37921) AND `Entry` NOT IN (92,501,598,623,624,667,669,670,672,674,696,764,765,766,780,781,782,783,784,940,1059,1060,1061,1062,1490,1727,1731,1732,1812,1813,1851,1953,1954,1955,1956,2022,2025,2027,2029,2030,2054,2156,2157,2166,2258,2269,2359,2450,2530,2534,2551,2592,2603,2604,2605,2639,2640,2641,2642,2643,2644,2645,2646,2647,2648,2649,2650,2651,2652,2653,2654,2723,2735,2736,2745,2748,2749,2751,2752,2754,2755,2760,2763,2791,2850,2919,2976,2978,2989,3398,3535,3578,3715,3727,3733,3763,3773,3780,3781,3782,3783,3784,3834,3919,3931,4020,4021,4022,4023,4024,4025,4026,4027,4028,4029,4030,4034,4035,4036,4037,4038,4041,4042,4044,4095,4096,4113,4116,4120,4131,4132,4386,4416,4465,4466,4467,4499,4541,4625,4676,4844,4846,4849,4857,4860,4872,5055,5343,5346,5347,5354,5357,5358,5465,5469,5470,5481,5485,5490,5761,5775,5823,5826,5841,5849,5850,5852,5853,5854,5855,5859,5881,5916,5932,5933,5935,6073,6113,6124,6146,6147,6148,6218,6219,6391,6392,6407,6509,6510,6511,6512,6517,6518,6519,6520,6521,6527,6560,6585,6646,6648,6649,7016,7017,7023,7031,7032,7039,7050,7052,7056,7073,7100,7101,7104,7135,7136,7137,7138,7139,7149,7206,7228,7290,7319,7584,7665,7666,7667,7668,7728,7809,7849,7995,7996,8210,8212,8213,8215,8216,8217,8218,8219,8278,8279,8281,8282,8283,8298,8299,8384,8400,8636,8905,8906,8907,8908,8909,8910,8911,8923,8977,8981,9016,9026,9376,9396,9502,9601,9602,9681,9816,9878,9879,9938,10119,10120,10197,10202,10356,10357,10601,10602,10641,10644,10647,10663,10664,10802,10806,10817,10827,11321,11346,11355,11374,11383,11458,11459,11461,11462,11464,11465,11658,11659,11665,11666,11667,11668,11669,11714,11746,11747,11777,11778,11781,11782,11783,11784,11937,12037,12046,12076,12099,12100,12101,12159,12201,12203,12206,12207,12219,12220,12223,12224,12339,12431,12432,12433,12836,12900,12902,12918,12921,12940,13021,13022,13139,13141,13142,13196,13197,13285,13419,14221,14225,14227,14231,14266,14268,14269,14273,14277,14279,14303,14339,14340,14342,14343,14424,14427,14428,14429,14430,14431,14433,14445,14446,14448,14460,14461,14462,14464,14471,14475,14487,14535,14536,14604,14640,15205,15635,15636,15637,17235,17352,17353,20774,21251,23029,23691,23750,25707,25709,27254,300,327,448,475,574,580,616,678,679,680,709,710,711,763,813,814,818,824,947,1696,1753,1837,1839,1843,1910,1936,1961,1972,2090,2184,2186,2192,2283,2305,2420,2421,2422,2423,2431,2452,2453,2476,2541,2564,2573,2574,2719,2720,2781,2793,2931,2932,2944,3056,3058,3068,3203,3435,3438,3655,4645,5786,5799,5808,5824,5833,5834,5837);

So everything that seems intended or confirmed intended will be NOT removed, including multiple rare and unique-named creatures even if it is not confirmed they should drop something like this. Sometimes including simple NPCs with high chance to drop herb and ore but uncorfirmed by web archive.
After all the checks I'm sure we doing it right. They all literally drop herbs and ore they're near to, so it's 100% caused by the bugged wowhead addon.

TO-DO:

  1. I will remove later everything from the remaining creatures if the chance to drop is really low as the low chance is the main indicator the item was added because of the bugged wowhead addon. + some creatures in this list are really weird, they drop literally everything and their loot table contains 1600+ items.
  2. Copper ore must be restored if the chance is high and if it drops from the remaining creatures.

@offl
Copy link
Contributor

offl commented May 6, 2020

Copper Ore

-- Restore incorrectly removed Copper Ore
DELETE FROM `creature_loot_template` WHERE `Item` = 2770;
INSERT INTO `creature_loot_template` (`Entry`,`Item`,`Chance`,`GroupId`,`MinCount`,`MaxCount`) VALUES
(300,2770,0.02,0,1,1),
(327,2770,2.7,0,1,1),
(448,2770,0.02,0,1,1),
(475,2770,4.98,0,1,1),
(580,2770,0.32,0,1,1),
(598,2770,1.26,0,1,5),
(623,2770,1.16,0,1,1),
(624,2770,1.77,0,1,1),
(711,2770,0.6,0,1,1),
(824,2770,4,0,1,5),
(1727,2770,3.9,0,3,5),
(1731,2770,99.32,0,1,1),
(1753,2770,0.64,0,1,1),
(1910,2770,0.34,0,1,1),
(1953,2770,0.04,0,1,1),
(1956,2770,0.18,0,1,1),
(1961,2770,0.74,0,1,1),
(1972,2770,0.68,0,1,1),
(2090,2770,1.54,0,1,1),
(2156,2770,0.08,0,1,1),
(2157,2770,0.04,0,1,1),
(2283,2770,0.78,0,1,1),
(2305,2770,0.04,0,1,1),
(2850,2770,1.15043,0,1,1),
(2976,2770,4.98,0,1,1),
(2978,2770,4.82,0,1,1),
(2989,2770,4.68,0,1,1),
(3058,2770,0.08,0,1,1),
(3203,2770,0.76,0,1,1),
(3398,2770,3.2,0,1,1),
(3438,2770,0.38,0,1,1),
(3578,2770,3.02,0,1,1),
(3715,2770,3.58798,0,1,1),
(3727,2770,0.02,0,1,1),
(3733,2770,0.06,0,1,1),
(3763,2770,2,0,1,1),
(4020,2770,0.06,0,1,1),
(4021,2770,0.04,0,1,1),
(4022,2770,0.02,0,1,1),
(4023,2770,0.02,0,1,1),
(4024,2770,0.04,0,1,1),
(4025,2770,0.02,0,1,1),
(4026,2770,0.02,0,1,1),
(4027,2770,0.02,0,1,1),
(4028,2770,0.02,0,1,1),
(4029,2770,0.02,0,1,1),
(4034,2770,0.07,0,1,1),
(4036,2770,0.12,0,1,1),
(4037,2770,0.1,0,1,1),
(4042,2770,0.1,0,1,1),
(4044,2770,0.02,0,1,1),
(4095,2770,0.02,0,1,1),
(4113,2770,0.04,0,1,1),
(4120,2770,0.02,0,1,1),
(4416,2770,1.34,0,1,5),
(4499,2770,0.16,0,1,1),
(5055,2770,0.1,0,1,1),
(5761,2770,0.12,0,1,1),
(5786,2770,0.76,0,1,1),
(5808,2770,0.36,0,1,1),
(5824,2770,0.58,0,1,1),
(5826,2770,0.66,0,1,1),
(5837,2770,0.12,0,1,1),
(5932,2770,1.14,0,1,1),
(5933,2770,0.48,0,1,1),
(6113,2770,1.06,0,1,1),
(6124,2770,0.6,0,1,1),
(6218,2770,0.02,0,1,1),
(6391,2770,0.2,0,1,1),
(6392,2770,0.7,0,1,1),
(6407,2770,0.4,0,1,1),
(7849,2770,0.48,0,1,1),
(12431,2770,0.34,0,1,1),
(12432,2770,0.14,0,1,1),
(12433,2770,0.14,0,1,1),
(12902,2770,0.04,0,1,1),
(14266,2770,1.68,0,1,1),
(14268,2770,3.92,0,1,1),
(14269,2770,0.82,0,1,1);

Killyana pushed a commit that referenced this issue May 6, 2020
@offl @Killyana
DB/Loot: Restore incorrectly removed Copper Ore
7a26ea4 
Ref  #18182
@Killyana
Copy link
Member

Killyana commented May 6, 2020

I will close this issue as loots are general

@Killyana Killyana closed this as completed May 6, 2020
@offl
Copy link
Contributor

offl commented May 6, 2020

What about #18182 (comment)?

@Killyana
Copy link
Member

Killyana commented May 6, 2020 •
edited

Need to be pushed?

Because creatures like:
https://www.wowhead.com/npc=5761/deviate-shambler
https://www.wowhead.com/npc=1040/fen-creeper
https://www.wowhead.com/npc=15637/withered-green-keeper
https://www.wowhead.com/npc=12220/constrictor-vine
https://www.wowhead.com/npc=5485/thistleshrub-rootshaper

Must drop herbs

@offl
Copy link
Contributor

offl commented May 6, 2020

Yes, they all will be not affected, except 1040 since herbs and ore were removed and I guess long time ago
I'll restore them later

@offl
Copy link
Contributor

offl commented May 6, 2020 

--
DELETE FROM `creature_loot_template` WHERE `Item` IN (765,785,2447,2449,2450,2452,2453,2770,2771,2772,2775,2776,2835,2836,2838,3355,3356,3357,3358,3369,3470,3478,3486,3818,3819,3820,3821,3857,3858,4625,7911,7912,7966,8153,8831,8836,8838,8839,8845,8846,10620,11370,12365,12644,12809,13463,13464,13465,13466,13467,13468,19726,19727,22202,22203,22710,22785,22786,22787,22788,22789,22790,22791,22792,22793,22794,22797,23424,23425,23426,23427,35128,36901,36902,36903,36904,36905,36906,36907,36908,36909,36910,36912,37921) AND `Entry` NOT IN (92,501,598,623,624,667,669,670,672,674,696,764,765,766,780,781,782,783,784,940,1059,1060,1061,1062,1490,1727,1731,1732,1812,1813,1851,1953,1954,1955,1956,2022,2025,2027,2029,2030,2054,2156,2157,2166,2258,2269,2359,2450,2530,2534,2551,2592,2603,2604,2605,2639,2640,2641,2642,2643,2644,2645,2646,2647,2648,2649,2650,2651,2652,2653,2654,2723,2735,2736,2745,2748,2749,2751,2752,2754,2755,2760,2763,2791,2850,2919,2976,2978,2989,3398,3535,3578,3715,3727,3733,3763,3773,3780,3781,3782,3783,3784,3834,3919,3931,4020,4021,4022,4023,4024,4025,4026,4027,4028,4029,4030,4034,4035,4036,4037,4038,4041,4042,4044,4095,4096,4113,4116,4120,4131,4132,4386,4416,4465,4466,4467,4499,4541,4625,4676,4844,4846,4849,4857,4860,4872,5055,5343,5346,5347,5354,5357,5358,5465,5469,5470,5481,5485,5490,5761,5775,5823,5826,5841,5849,5850,5852,5853,5854,5855,5859,5881,5916,5932,5933,5935,6073,6113,6124,6146,6147,6148,6218,6219,6391,6392,6407,6509,6510,6511,6512,6517,6518,6519,6520,6521,6527,6560,6585,6646,6648,6649,7016,7017,7023,7031,7032,7039,7050,7052,7056,7073,7100,7101,7104,7135,7136,7137,7138,7139,7149,7206,7228,7290,7319,7584,7665,7666,7667,7668,7728,7809,7849,7995,7996,8210,8212,8213,8215,8216,8217,8218,8219,8278,8279,8281,8282,8283,8298,8299,8384,8400,8636,8905,8906,8907,8908,8909,8910,8911,8923,8977,8981,9016,9026,9376,9396,9502,9601,9602,9681,9816,9878,9879,9938,10119,10120,10197,10202,10356,10357,10601,10602,10641,10644,10647,10663,10664,10802,10806,10817,10827,11321,11346,11355,11374,11383,11458,11459,11461,11462,11464,11465,11658,11659,11665,11666,11667,11668,11669,11714,11746,11747,11777,11778,11781,11782,11783,11784,11937,12037,12046,12076,12099,12100,12101,12159,12201,12203,12206,12207,12219,12220,12223,12224,12339,12431,12432,12433,12836,12900,12902,12918,12921,12940,13021,13022,13139,13141,13142,13196,13197,13285,13419,14221,14225,14227,14231,14266,14268,14269,14273,14277,14279,14303,14339,14340,14342,14343,14424,14427,14428,14429,14430,14431,14433,14445,14446,14448,14460,14461,14462,14464,14471,14475,14487,14535,14536,14604,14640,15205,15635,15636,15637,17235,17352,17353,20774,21251,23029,23691,23750,25707,25709,27254,300,327,448,475,574,580,616,678,679,680,709,710,711,763,813,814,818,824,947,1696,1753,1837,1839,1843,1910,1936,1961,1972,2090,2184,2186,2192,2283,2305,2420,2421,2422,2423,2431,2452,2453,2476,2541,2564,2573,2574,2719,2720,2781,2793,2931,2932,2944,3056,3058,3068,3203,3435,3438,3655,4645,5786,5799,5808,5824,5833,5834,5837,1040);

-- Restore incorrectly removed herbs and ore for Fen Creeper
DELETE FROM `creature_loot_template` WHERE `Entry` = 1040 AND `Item` IN (765,785,2447,2449,2450,2452,2453,2770,2835,3356,3357);
INSERT INTO `creature_loot_template` (`Entry`,`Item`,`Chance`,`GroupId`,`MinCount`,`MaxCount`) VALUES
(1040,765,2.52,0,1,1),
(1040,785,2.54,0,1,1),
(1040,2447,2.54,0,1,1),
(1040,2449,2.78,0,1,1),
(1040,2450,2.4,0,1,1),
(1040,2452,1.1539,0,1,1),
(1040,2453,2.46,0,1,1),
(1040,2770,0.74,0,1,1),
(1040,2835,0.38,0,1,1),
(1040,3356,2.62,0,1,1),
(1040,3357,0.08,0,1,1);

@Killyana
Copy link
Member

Killyana commented May 6, 2020 •
edited

If I search for :

SELECT * FROM `creature_loot_template` WHERE `Item` IN (765,785,2447,2449,2450,2452,2453,2770,2771,2772,2775,2776,2835,2836,2838,3355,3356,3357,3358,3369,3470,3478,3486,3818,3819,3820,3821,3857,3858,4625,7911,7912,7966,8153,8831,8836,8838,8839,8845,8846,10620,11370,12365,12644,12809,13463,13464,13465,13466,13467,13468,19726,19727,22202,22203,22710,22785,22786,22787,22788,22789,22790,22791,22792,22793,22794,22797,23424,23425,23426,23427,35128,36901,36902,36903,36904,36905,36906,36907,36908,36909,36910,36912,37921) AND `Entry` NOT IN (92,501,598,623,624,667,669,670,672,674,696,764,765,766,780,781,782,783,784,940,1059,1060,1061,1062,1490,1727,1731,1732,1812,1813,1851,1953,1954,1955,1956,2022,2025,2027,2029,2030,2054,2156,2157,2166,2258,2269,2359,2450,2530,2534,2551,2592,2603,2604,2605,2639,2640,2641,2642,2643,2644,2645,2646,2647,2648,2649,2650,2651,2652,2653,2654,2723,2735,2736,2745,2748,2749,2751,2752,2754,2755,2760,2763,2791,2850,2919,2976,2978,2989,3398,3535,3578,3715,3727,3733,3763,3773,3780,3781,3782,3783,3784,3834,3919,3931,4020,4021,4022,4023,4024,4025,4026,4027,4028,4029,4030,4034,4035,4036,4037,4038,4041,4042,4044,4095,4096,4113,4116,4120,4131,4132,4386,4416,4465,4466,4467,4499,4541,4625,4676,4844,4846,4849,4857,4860,4872,5055,5343,5346,5347,5354,5357,5358,5465,5469,5470,5481,5485,5490,5761,5775,5823,5826,5841,5849,5850,5852,5853,5854,5855,5859,5881,5916,5932,5933,5935,6073,6113,6124,6146,6147,6148,6218,6219,6391,6392,6407,6509,6510,6511,6512,6517,6518,6519,6520,6521,6527,6560,6585,6646,6648,6649,7016,7017,7023,7031,7032,7039,7050,7052,7056,7073,7100,7101,7104,7135,7136,7137,7138,7139,7149,7206,7228,7290,7319,7584,7665,7666,7667,7668,7728,7809,7849,7995,7996,8210,8212,8213,8215,8216,8217,8218,8219,8278,8279,8281,8282,8283,8298,8299,8384,8400,8636,8905,8906,8907,8908,8909,8910,8911,8923,8977,8981,9016,9026,9376,9396,9502,9601,9602,9681,9816,9878,9879,9938,10119,10120,10197,10202,10356,10357,10601,10602,10641,10644,10647,10663,10664,10802,10806,10817,10827,11321,11346,11355,11374,11383,11458,11459,11461,11462,11464,11465,11658,11659,11665,11666,11667,11668,11669,11714,11746,11747,11777,11778,11781,11782,11783,11784,11937,12037,12046,12076,12099,12100,12101,12159,12201,12203,12206,12207,12219,12220,12223,12224,12339,12431,12432,12433,12836,12900,12902,12918,12921,12940,13021,13022,13139,13141,13142,13196,13197,13285,13419,14221,14225,14227,14231,14266,14268,14269,14273,14277,14279,14303,14339,14340,14342,14343,14424,14427,14428,14429,14430,14431,14433,14445,14446,14448,14460,14461,14462,14464,14471,14475,14487,14535,14536,14604,14640,15205,15635,15636,15637,17235,17352,17353,20774,21251,23029,23691,23750,25707,25709,27254,300,327,448,475,574,580,616,678,679,680,709,710,711,763,813,814,818,824,947,1696,1753,1837,1839,1843,1910,1936,1961,1972,2090,2184,2186,2192,2283,2305,2420,2421,2422,2423,2431,2452,2453,2476,2541,2564,2573,2574,2719,2720,2781,2793,2931,2932,2944,3056,3058,3068,3203,3435,3438,3655,4645,5786,5799,5808,5824,5833,5834,5837,1040) AND chance>5;

This ones will be removed, but they are correct

Edit: Maybe you forget AND chance<0.1 ?

@offl
Copy link
Contributor

offl commented May 6, 2020

No, the NOT IN list already contains everything we don't wanna touch including NPCs you mentioned above

AND `Entry` NOT IN (92,501,598,623,624,667.....

@Killyana
Copy link
Member

Killyana commented May 6, 2020

My bad didn't saw this part

Killyana pushed a commit that referenced this issue May 6, 2020
@offl @Killyana
DB/Loot: Remove some wrong loots
7395ead 
Ref #18182
This was referenced May 7, 2020
Closed
Closed
Closed
Closed
Closed
Closed
Shauren pushed a commit that referenced this issue Jan 2, 2022
@offl @Shauren
DB/Loot: Remove some wrong loots
1e5ccc8 
Ref #18182

(cherry picked from commit 7395ead)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Branch-3.3.5a Comp-Database Feedback-PatchFix
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
5 participants
@Aokromes @MrSmite @Killyana @offl @SnapperRy