- 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.
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;