What's new

Fix for hundreds of creature equipment issues and DBError.log cleanup v7.0.2

mastermind

Silver Supporter
Senior User
188
2017
13
Location
PA, USA
The first update fixes issues listed in the DBError.log file. This took a massive chunk of errors out of the file.

Most of the creatures in this first update had corresponding entries in the creature_equip_template table.
The second corrects the creature_template.equipemnt_id field to associate properly with the creature_equip_template, which already had
existing entry for these creatures.

Code:
-- --------------------------------------------------------------------------------------------------------------------
-- Repack version:               7.0.2
-- DBError.log Clean-up creature equipment id errors
-- --------------------------------------------------------------------------------------------------------------------

UPDATE `creature` SET `equipment_id` = 0 WHERE `id` in (7,97,233,235,290,327,392,459,478,732,918,1073,1164,1176,1177,1197,1261,1325,1433,1490,1642,1660,1661,1665,1756,1783,1784,2166,2334,2535,2545,2548,2549,2596,2860,2949,3216,3266,3268,3438,3517,4436,4500,4501,4505,4506,4518,4542,4623,4834,6373,6491,7024,7441,9476,10506,10818,10819,10820,10936,11318,11321,11811,12423,13116,13117,14026,14341,14347,14401,14529,15077,15078,15079,15119,15192,15454,16245,16781,16817,16818,17146,17147,17555,17714,17887,19536,21310,21971,22013,22317,22473,22917,23037,23052,23053,23089,23837,24700,25334,25883,25884,25962,25975,25994,26073,26076,26113,26123,26124,26161,26200,26221,26520,26588,26954,27544,27837,28383,28505,29375,29501,31522,31523,32858,32971,32978,33048,33056,33057,33082,33112,33117,33119,33166,33195,33253,33262,33277,33313,33421,33487,33688,34041,34316,34348,34359,34395,34401,34402,34405,34415,34429,34485,34486,34673,34689,34692,34695,34696,35077,35229,35650,35753,35845,36092,36176,36457,36470,36597,36600,36616,36712,36942,36943,37055,37179,37701,37887,37896,38003,38066,38111,38120,38124,38438,38526,38539,38611,38614,38647,38703,38704,38745,38766,38767,38928,38966,39044,39068,39097,39318,39333,39426,39622,39644,39660,40066,40578,40660,40712,40991,41056,41200,41298,41307,41325,41398,42010,42216,42317,42333,42349,42383,42386,42390,42428,42592,42680,42683,42691,42692,42695,42696,42704,42764,42767,42768,42789,42940,42968,43116,43164,43165,43166,43167,43184,43187,43194,43222,43229,43247,43248,43340,43430,43438,43440,43458,43508,43537,43541,43571,43572,43594,43636,43778,43925,44000,44036,44038,44126,44131,44171,44223,44263,44289,44293,44329,44458,44467,44548,44556,44560,44592,44593,44608,44609,44610,44632,44806,44839,44848,44855,44911,44938,44957,44979,44990,45002,45166,45195,45235,45239,45252,45374,45400,45416,45417,45539,45574,45738,45847,45849,45850,46037,46048,46049,46054,46122,46138,46151,46175,46185,46344,46375,46391,46395,46397,46398,46407,46408,46411,46467,46471,46482,46614,46647,46654,46655,46658,46963,47030,47031,47116,47162,47366,47421,47569,47790,48005,48080,48280,48286,48304,48311,48331,48586,48704,48726,48736,48764,48797,49060,49956,50001,50049,50135,50306,50595,52175,52408,52605,52832,52835,52997,53052,53386,53394,53527,53715,54313,54334,54404,54589,55230,55265,55294,55308,55312,55346,55536,55537,55689,56103,56104,56427,56575,56699,57158,57160,57262,57265,57287,57288,57348,57377,57378,57379,57882,58232,60019,77555,90000,90001,90002,90003,105411,111223,112962,125251,366000,455610,462510,466580,573777,850000);

-- ----------------------------------------------------------------------------------------------------------------------------
-- Repack version:               7.0.2
-- Sets creature_template.equipment_id field to match creature_equip_template.id (for the creatures listed above where needed)
-- ----------------------------------------------------------------------------------------------------------------------------

UPDATE `creature_template` SET `equipment_id` = 11811 WHERE `entry` = 11811;
UPDATE `creature_template` SET `equipment_id` = 14341 WHERE `entry` = 14341;
UPDATE `creature_template` SET `equipment_id` = 22473 WHERE `entry` = 22473;
UPDATE `creature_template` SET `equipment_id` = 24700 WHERE `entry` = 24700;
UPDATE `creature_template` SET `equipment_id` = 33082 WHERE `entry` = 33082;
UPDATE `creature_template` SET `equipment_id` = 39644 WHERE `entry` = 39644;
UPDATE `creature_template` SET `equipment_id` = 40578 WHERE `entry` = 40578;
UPDATE `creature_template` SET `equipment_id` = 42333 WHERE `entry` = 42333;
UPDATE `creature_template` SET `equipment_id` = 43440 WHERE `entry` = 43440;
UPDATE `creature_template` SET `equipment_id` = 43458 WHERE `entry` = 43458;
UPDATE `creature_template` SET `equipment_id` = 43778 WHERE `entry` = 43778;
UPDATE `creature_template` SET `equipment_id` = 45539 WHERE `entry` = 45539;
UPDATE `creature_template` SET `equipment_id` = 46037 WHERE `entry` = 46037;
UPDATE `creature_template` SET `equipment_id` = 46048 WHERE `entry` = 46048;
UPDATE `creature_template` SET `equipment_id` = 46049 WHERE `entry` = 46049;
UPDATE `creature_template` SET `equipment_id` = 46151 WHERE `entry` = 46151;
UPDATE `creature_template` SET `equipment_id` = 47162 WHERE `entry` = 47162;
UPDATE `creature_template` SET `equipment_id` = 48280 WHERE `entry` = 48280;
UPDATE `creature_template` SET `equipment_id` = 50595 WHERE `entry` = 50595;
UPDATE `creature_template` SET `equipment_id` = 54589 WHERE `entry` = 54589;
 
Top