Trinitycore: DB/CreatureModelInfo: Add missing creature_model_info (Part 1)

Created on 30 Dec 2020  路  5Comments  路  Source: TrinityCore/TrinityCore


creature_model_info.sql

DELETE FROM `creature_model_info` WHERE `DisplayID` IN 
(75371,78851,81106,84585,86404,86424,88786,88787,89266,89374,89419,90252,90257,90303,91010,91669,91670,91775,91776,
 91777,91778,91779,91780,91781,91782,91851,91853,91854,91995,91996,91997,91998,92198,92463,92464,92690,92691,92693,
 92751,92795,92803,92804,92821,92822,92823,92825,92831,93574,93637,94939,95022,95040,95041,95075,95204,95210,95595,
 95596,95599,95600,95602,95603,95605,95606,95608,95609,95610,95611,95616,95617,95619,95621,95626,95627,95628,95629,
 95765,95920,96136,96314,96315,96317,96318,96320,96363,96364,96384,96541,96778,96883,96884,96885,96903,96905,96906,
 96910,96913,96914,96915,96916,96419,96420,97213,97228,97229,97258,97267,97757,97795,97834,97915,98013,98571,98725,
 98730,99206,99207,99375,99385,99389,99391,99401,99444,99445,99449,99451,99452,99453,99456,99458,99462,99497,99498,
 99499,99507,99615,99666,99667,99807,99808,99809,99810,99811,99812,99813,99814,99815,99816,99817,99818,99819,99821,
 99822,99949,100003,100004,100159,100160,100165,100167,100168,100170,100172,100174,100184,100444);
INSERT INTO `creature_model_info` (`DisplayID`, `BoundingRadius`, `CombatReach`, `DisplayID_Other_Gender`, `VerifiedBuild`) VALUES
(75371, 0.334899783134460449, 0.4375, 0, 36839),
(78851, 0.255721211433410644, 1, 0, 36839),
(81106, 0.798952639102935791, 1.125, 0, 36839),
(84585, 0.882957339286804199, 0, 0, 36839),
(86404, 2.144748687744140625, 3.75, 0, 36839),
(86424, 1.71579897403717041, 3, 0, 36839),
(88786, 0.426489889621734619, 1, 0, 36839),
(88787, 0.426489889621734619, 1, 0, 36839),
(89266, 0.426489889621734619, 1, 0, 36839),
(89374, 0.208000004291534423, 1.5, 0, 36839),
(89419, 0.382999986410140991, 1.5, 0, 36839),
(90252, 0.305999994277954101, 1.5, 0, 36839),
(90257, 0.236000001430511474, 1.5, 0, 36839),
(90303, 0.305999994277954101, 1.5, 0, 36839),
(91010, 0.305999994277954101, 1.5, 0, 36839),
(91669, 0.236000001430511474, 1.5, 0, 36839),
(91670, 0.372000008821487426, 1.5, 0, 36839),
(91775, 1.71579897403717041, 3, 0, 36839),
(91776, 1.71579897403717041, 3, 0, 36839),
(91777, 1.71579897403717041, 3, 0, 36839),
(91778, 1.71579897403717041, 3, 0, 36839),
(91779, 1.71579897403717041, 3, 0, 36839),
(91780, 1.71579897403717041, 3, 0, 36839),
(91781, 1.71579897403717041, 3, 0, 36839),
(91782, 1.71579897403717041, 3, 0, 36839),
(91851, 1.973168730735778808, 3.449999809265136718, 0, 36839),
(91853, 1.973168730735778808, 3.449999809265136718, 0, 36839),
(91854, 1.973168730735778808, 3.449999809265136718, 0, 36839),
(91995, 0.347000002861022949, 1.5, 0, 36839),
(91996, 1, 1.5, 0, 36839),
(91997, 0.347222000360488891, 1.5, 0, 36839),
(91998, 0.305999994277954101, 1.5, 0, 36839),
(92198, 0.305999994277954101, 1.5, 0, 36839),
(92463, 0.382999986410140991, 1.5, 0, 36839),
(92464, 0.382999986410140991, 1.5, 0, 36839),
(92690, 0.208000004291534423, 1.5, 0, 36839),
(92691, 0.434946358203887939, 1, 0, 36839),
(92693, 0.434946358203887939, 1, 0, 36839),
(92751, 0.305999994277954101, 1.5, 0, 36839),
(92795, 0.347000002861022949, 1.5, 0, 36839),
(92803, 0.694444000720977783, 3, 0, 36839),
(92804, 0.347222000360488891, 1.5, 0, 36839),
(92821, 2.144748687744140625, 3.750000238418579101, 0, 36839),
(92822, 2.144748687744140625, 3.750000238418579101, 0, 36839),
(92823, 2.144748926162719726, 3.750000238418579101, 0, 36839),
(92825, 1, 1.5, 0, 36839),
(92831, 1.71579897403717041, 3, 0, 36839),
(93574, 0.360905170440673828, 0, 0, 36839),
(93637, 0.305999994277954101, 1.5, 0, 36839),
(94939, 0.305999994277954101, 1.5, 0, 36839),
(95022, 1.973168730735778808, 3.449999809265136718, 0, 36839),
(95040, 1, 1.5, 0, 36839),
(95041, 0.305999994277954101, 1.5, 0, 36839),
(95075, 1, 1.5, 0, 36839),
(95204, 0.729166150093078613, 3.149999856948852539, 0, 36839),
(95210, 0.347222000360488891, 1.5, 0, 36839),
(95595, 0.388999998569488525, 1.5, 0, 36839),
(95596, 0.305999994277954101, 1.5, 0, 36839),
(95599, 0.347000002861022949, 1.5, 0, 36839),
(95600, 0.208000004291534423, 1.5, 0, 36839),
(95602, 1, 1.5, 0, 36839),
(95603, 0.305999994277954101, 1.5, 0, 36839),
(95605, 0.347222000360488891, 1.5, 0, 36839),
(95606, 0.208000004291534423, 1.5, 0, 36839),
(95608, 1, 1.5, 0, 36839),
(95609, 0.347000002861022949, 1.5, 0, 36839),
(95610, 0.208000004291534423, 1.5, 0, 36839),
(95611, 0.305999994277954101, 1.5, 0, 36839),
(95616, 0.305999994277954101, 1.5, 0, 36839),
(95617, 0.305999994277954101, 1.5, 0, 36839),
(95619, 0.347000002861022949, 1.5, 0, 36839),
(95621, 1, 1.5, 0, 36839),
(95626, 0.208000004291534423, 1.5, 0, 36839),
(95627, 0.305999994277954101, 1.5, 0, 36839),
(95628, 0.347222000360488891, 1.5, 0, 36839),
(95629, 0.347000002861022949, 1.5, 0, 36839),
(95765, 0.300000011920928955, 5, 0, 36839),
(95920, 0.382819831371307373, 1, 0, 36839),
(96136, 0.208000004291534423, 1.5, 0, 36839),
(96314, 0.305999994277954101, 1.5, 0, 36839),
(96315, 0.236000001430511474, 1.5, 0, 36839),
(96317, 0.698000013828277587, 3, 0, 36839),
(96318, 0.347222000360488891, 1.5, 0, 36839),
(96320, 0.382999986410140991, 1.5, 0, 36839),
(96363, 0.382999986410140991, 1.5, 0, 36839),
(96364, 0.305999994277954101, 1.5, 0, 36839),
(96384, 0.305999994277954101, 1.5, 0, 36839),
(96541, 1.5, 6, 0, 36839),
(96778, 2.690669536590576171, 5.25, 0, 36839),
(96883, 0.236000001430511474, 1.5, 0, 36839),
(96884, 0.305999994277954101, 1.5, 0, 36839),
(96885, 0.698000013828277587, 3, 0, 36839),
(96903, 0.372000008821487426, 1.5, 0, 36839),
(96905, 0.382999986410140991, 1.5, 0, 36839),
(96906, 0.236000001430511474, 1.5, 0, 36839),
(96910, 0.347222000360488891, 1.5, 0, 36839),
(96913, 0.382999986410140991, 1.5, 0, 36839),
(96914, 0.372000008821487426, 1.5, 0, 36839),
(96915, 0.305999994277954101, 1.5, 0, 36839),
(96916, 0.722000002861022949, 3, 0, 36839),
(96419, 0.382999986410140991, 1.5, 0, 36839),
(96420, 0.722000002861022949, 3, 0, 36839),
(97213, 3.041802883148193359, 6.299999713897705078, 0, 36839),
(97228, 0.347000002861022949, 1.5, 0, 36839),
(97229, 0.305999994277954101, 1.5, 0, 36839),
(97258, 2.921010494232177734, 6, 0, 36839),
(97267, 0.310000002384185791, 1, 0, 36839),
(97757, 0.402149975299835205, 1.574999928474426269, 0, 36839),
(97795, 0.382999986410140991, 1.5, 0, 36839),
(97834, 0.305999994277954101, 1.5, 0, 36839),
(97915, 0.236000001430511474, 1.5, 0, 36839),
(98013, 11.64418411254882812, 12, 0, 36839),
(98571, 0.305999994277954101, 1.5, 0, 36839),
(98725, 0.382999986410140991, 1.5, 0, 36839),
(98730, 0.305999994277954101, 1.5, 0, 36839),
(99206, 0.305999994277954101, 1.5, 0, 36839),
(99207, 1, 1.5, 0, 36839),
(99375, 0.347222000360488891, 1.5, 0, 36839),
(99385, 0.305999994277954101, 1.5, 0, 36839),
(99389, 0.305999994277954101, 1.5, 0, 36839),
(99391, 0.208000004291534423, 1.5, 0, 36839),
(99401, 0.305999994277954101, 1.5, 0, 36839),
(99444, 0.236000001430511474, 1.5, 0, 36839),
(99445, 0.208000004291534423, 1.5, 0, 36839),
(99449, 0.372000008821487426, 1.5, 0, 36839),
(99451, 0.236000001430511474, 1.5, 0, 36839),
(99452, 0.372000008821487426, 1.5, 0, 36839),
(99453, 0.372000008821487426, 1.5, 0, 36839),
(99456, 0.372000008821487426, 1.5, 0, 36839),
(99458, 0.372000008821487426, 1.5, 0, 36839),
(99462, 0.305999994277954101, 1.5, 0, 36839),
(99497, 0.305999994277954101, 1.5, 0, 36839),
(99498, 0.208000004291534423, 1.5, 0, 36839),
(99499, 0.305999994277954101, 1.5, 0, 36839),
(99507, 0.305999994277954101, 1.5, 0, 36839),
(99615, 0.305999994277954101, 1.5, 0, 36839),
(99666, 0.305999994277954101, 1.5, 0, 36839),
(99667, 0.208000004291534423, 1.5, 0, 36839),
(99807, 0.372000008821487426, 1.5, 0, 36839),
(99808, 0.236000001430511474, 1.5, 0, 36839),
(99809, 0.305999994277954101, 1.5, 0, 36839),
(99810, 0.236000001430511474, 1.5, 0, 36839),
(99811, 0.236000001430511474, 1.5, 0, 36839),
(99812, 0.372000008821487426, 1.5, 0, 36839),
(99813, 0.372000008821487426, 1.5, 0, 36839),
(99814, 0.372000008821487426, 1.5, 0, 36839),
(99815, 0.236000001430511474, 1.5, 0, 36839),
(99816, 0.372000008821487426, 1.5, 0, 36839),
(99817, 0.236000001430511474, 1.5, 0, 36839),
(99818, 0.305999994277954101, 1.5, 0, 36839),
(99819, 0.372000008821487426, 1.5, 0, 36839),
(99821, 0.372000008821487426, 1.5, 0, 36839),
(99822, 0.236000001430511474, 1.5, 0, 36839),
(99949, 0.208000004291534423, 1.5, 0, 36839),
(100003, 0.208000004291534423, 1.5, 0, 36839),
(100004, 0.208000004291534423, 1.5, 0, 36839),
(100159, 0.305999994277954101, 1.5, 0, 36839),
(100160, 0.305999994277954101, 1.5, 0, 36839),
(100165, 0.305999994277954101, 1.5, 0, 36839),
(100167, 0.305999994277954101, 1.5, 0, 36839),
(100168, 0.305999994277954101, 1.5, 0, 36839),
(100170, 0.208000004291534423, 1.5, 0, 36839),
(100172, 0.208000004291534423, 1.5, 0, 36839),
(100174, 0.305999994277954101, 1.5, 0, 36839),
(100184, 0.208000004291534423, 1.5, 0, 36839),
(100444, 0.372000008821487426, 1.5, 0, 36839);

UPDATE `creature_model_info` SET `BoundingRadius`=0.928183615207672119, `CombatReach`=0.655102074146270751, `VerifiedBuild`=36839 WHERE `DisplayID` IN (283,1088,1157);
UPDATE `creature_model_info` SET `BoundingRadius`=0.681569099426269531, `CombatReach`=1.399999976158142089, `VerifiedBuild`=36839 WHERE `DisplayID`=913;
UPDATE `creature_model_info` SET `BoundingRadius`=0.277218431234359741, `CombatReach`=0.649999976158142089, `VerifiedBuild`=36839 WHERE `DisplayID`=2177;
UPDATE `creature_model_info` SET `BoundingRadius`=1.491378188133239746, `CombatReach`=2.099999904632568359, `VerifiedBuild`=36839 WHERE `DisplayID`=4658;
UPDATE `creature_model_info` SET `BoundingRadius`=1.544346451759338378, `CombatReach`=1.724999904632568359, `VerifiedBuild`=36839 WHERE `DisplayID`=43225;
UPDATE `creature_model_info` SET `BoundingRadius`=1.611492037773132324, `CombatReach`=1.800000071525573730, `VerifiedBuild`=36839 WHERE `DisplayID`=43226;
UPDATE `creature_model_info` SET `BoundingRadius`=2.104584932327270507, `CombatReach`=1.346938848495483398, `VerifiedBuild`=36839 WHERE `DisplayID` IN (52656,52696);
UPDATE `creature_model_info` SET `BoundingRadius`=2.161906719207763671, `CombatReach`=3.779999971389770507, `VerifiedBuild`=36839 WHERE `DisplayID`=58433;
UPDATE `creature_model_info` SET `BoundingRadius`=3.922137737274169921, `CombatReach`=2.775510311126708984, `VerifiedBuild`=36839 WHERE `DisplayID`=64922;
UPDATE `creature_model_info` SET `BoundingRadius`=1.220593214035034179, `CombatReach`=0.699999988079071044, `VerifiedBuild`=36839 WHERE `DisplayID`=64984;
UPDATE `creature_model_info` SET `BoundingRadius`=0.444560199975967407, `CombatReach`=1.132652997970581054, `VerifiedBuild`=36839 WHERE `DisplayID` IN (70178,70179);
UPDATE `creature_model_info` SET `BoundingRadius`=1.156236171722412109, `CombatReach`=0.699999988079071044, `VerifiedBuild`=36839 WHERE `DisplayID`=73350;

UPDATE `creature_model_info` SET `BoundingRadius`=0.334899783134460449, `CombatReach`=0.4375, `VerifiedBuild`=36839 WHERE `DisplayID`=75374;
UPDATE `creature_model_info` SET `BoundingRadius`=0.341551274061203002, `CombatReach`=0.4375, `VerifiedBuild`=36839 WHERE `DisplayID` IN (75380,87603);

UPDATE `creature_model_info` SET `BoundingRadius`=0.798952639102935791, `CombatReach`=1.125, `VerifiedBuild`=36839 WHERE `DisplayID` IN (1963,6106,81105);
UPDATE `creature_model_info` SET `BoundingRadius`=0.514177203178405761, `CombatReach`=1.875, `VerifiedBuild`=36839 WHERE `DisplayID`=66292;
UPDATE `creature_model_info` SET `BoundingRadius`=0.348749995231628417, `CombatReach`=1.125, `VerifiedBuild`=36839 WHERE `DisplayID`=73335;

UPDATE `creature_model_info` SET `BoundingRadius`=0.902500033378601074, `CombatReach`=3.75, `VerifiedBuild`=36839 WHERE `DisplayID`=5205;
UPDATE `creature_model_info` SET `BoundingRadius`=2.144748687744140625, `CombatReach`=3.75, `VerifiedBuild`=36839 WHERE `DisplayID`=56491;

UPDATE `creature_model_info` SET `BoundingRadius`=0.305999994277954101, `CombatReach`=1.5, `VerifiedBuild`=36839 WHERE `DisplayID` IN (6446,12669,12921,33948,36815,36816,42274);
UPDATE `creature_model_info` SET `BoundingRadius`=1.342910051345825195, `CombatReach`=1.5, `VerifiedBuild`=36839 WHERE `DisplayID` IN (26566,34007);
UPDATE `creature_model_info` SET `BoundingRadius`=1.014356374740600585, `CombatReach`=2.5, `VerifiedBuild`=36839 WHERE `DisplayID`= 70162;
UPDATE `creature_model_info` SET `BoundingRadius`=1.866102457046508789, `CombatReach`=1.5, `VerifiedBuild`=36839 WHERE `DisplayID`= 77902;
UPDATE `creature_model_info` SET `BoundingRadius`=1.140607118606567382, `CombatReach`=1.5, `VerifiedBuild`=36839 WHERE `DisplayID`= 79720;

UPDATE `creature_model_info` SET `BoundingRadius`=1.175999999046325683, `CombatReach`=1, `VerifiedBuild`=36839 WHERE `DisplayID`=6807;
UPDATE `creature_model_info` SET `BoundingRadius`=0.722000002861022949, `CombatReach`=3, `VerifiedBuild`=36839 WHERE `DisplayID` IN (6854,29569,49770,90255,90314);
UPDATE `creature_model_info` SET `BoundingRadius`=0.698000013828277587, `CombatReach`=3, `VerifiedBuild`=36839 WHERE `DisplayID`=49781;

UPDATE `creature_model_info` SET `BoundingRadius`=0.300000011920928955, `VerifiedBuild`=36839 WHERE `DisplayID`=3619;
UPDATE `creature_model_info` SET `BoundingRadius`=2.274878740310668945, `VerifiedBuild`=36839 WHERE `DisplayID`=5233;
UPDATE `creature_model_info` SET `BoundingRadius`=2.036857128143310546, `VerifiedBuild`=36839 WHERE `DisplayID`=23681;
UPDATE `creature_model_info` SET `BoundingRadius`=0.310000002384185791, `VerifiedBuild`=36839 WHERE `DisplayID`=40122;

UPDATE `creature_model_info` SET `VerifiedBuild`=36839 WHERE `DisplayID` IN 
(31, 80, 134, 137, 207, 221, 247, 304, 328, 338, 342, 344, 704, 744, 802, 901, 983, 987,
 1037, 1042, 1065, 1072, 1141, 1197, 1198, 1310, 1311, 1312, 1313, 1314, 1315, 1316, 1318, 1319,
 1320, 1323, 1329, 1332, 1333, 1358, 1366, 1368, 1372, 1373, 1374, 1375, 1379, 1380, 1381, 1382,
 1383, 1384, 1386, 1387, 1388, 1390, 1392, 1393, 1394, 1418, 1423, 1427, 1429, 1431, 1433, 1434,
 1436, 1437, 1438, 1439, 1440, 1441, 1443, 1444, 1445, 1446, 1448, 1449, 1450, 1505, 1507, 1508,
 1509, 1510, 1511, 1512, 1513, 1515, 1516, 1517, 1518, 1519, 1520, 1521, 1522, 1523, 1541, 1696,
 1697, 1762, 1815, 1986, 1987, 2176, 2327, 2328, 2402, 2404, 2405, 2706, 2954, 2974, 3128, 3133,
 3167, 3238, 3246, 3281, 3288, 3448, 3449, 3604, 3605, 3606, 3608, 3609, 4259, 4260, 4356, 4363,
 4368, 4382, 4384, 4386, 4464, 4469, 4514, 4601, 4602, 4612, 4626, 4888, 4959, 4960, 4996, 5000,
 5074, 5082, 5128, 5444, 5446, 5545, 5546, 5547, 5551, 5567, 5705, 5706, 5728, 5769, 5770, 5846,
 6005, 6006, 6839, 6843, 6873, 7136, 7137, 7511, 7613, 7673, 7991, 7992, 8000, 8001, 8848, 8971,
 9133, 10186, 10472, 10625, 10824, 11414, 11686, 12910, 12917, 12919, 12920, 12922, 12924, 12925,
 13171, 13349, 13355, 13356, 13843, 14338, 14369, 14370, 14413, 14414, 14415, 14431, 14472, 14492,
 14499, 14573, 14574, 14575, 14582, 14583, 14589, 14616, 14732, 14733, 15294, 15352, 15369, 15467,
 15468, 15470, 15594, 15921, 16235, 16238, 16697, 16850, 17250, 17694, 17696, 17697, 17703, 17717,
 17719, 17722, 18055, 18269, 18800, 18801, 19216, 19670, 20545, 20985, 20988, 21072, 21264, 21342,
 21512, 22493, 22661, 22739, 22740, 22743, 22744, 22746, 22750, 22769, 22873, 23516, 24079, 24979,
 25319, 25336, 25901, 27510, 27684, 27685, 27686, 27687, 27690, 27727, 27823, 28048, 28111, 28118,
 28120, 28282, 28507, 29496, 29795, 31737, 31738, 31760, 31953, 31988, 32170, 32171, 32936, 32937,
 32938, 32981, 32982, 33032, 33303, 33468, 33469, 33470, 33507, 33518, 33519, 33520, 33699, 33701,
 33743, 33750, 33751, 34004, 34070, 34136, 34139, 34141, 34143, 34144, 34154, 34155, 34156, 34157,
 34185, 34406, 34412, 35051, 35053, 35133, 35140, 35141, 35148, 35183, 35184, 35185, 35186, 35187,
 35192, 35193, 35194, 35195, 35198, 35216, 35218, 35237, 35241, 35242, 35244, 35301, 35498, 35499,
 35500, 35504, 35695, 35816, 35818, 35819, 35827, 35843, 35844, 36213, 36357, 36545, 36559, 36583,
 36584, 36585, 36597, 36598, 36615, 36758, 36814, 36839, 37020, 37087, 37088, 37138, 37310, 37311,
 37328, 37329, 37330, 37331, 37372, 37437, 37706, 37719, 37720, 37724, 38047, 38418, 38419, 38800,
 38804, 39532, 39637, 39809, 39910, 40012, 40013, 40123, 42273, 42275, 42276, 42279, 42384, 42385,
 42386, 42387, 42388, 42389, 42720, 42722, 42782, 43669, 43717, 43718, 43719, 43720, 43721, 43722,
 43724, 43725, 43726, 44604, 44740, 44816, 45170, 45319, 45320, 45862, 45864, 45865, 46026, 46093,
 46132, 46929, 46930, 46986, 47231, 47243, 47465, 47982, 49021, 51166, 51613, 60207, 60316, 61023,
 61024, 61763, 61764, 63597, 63605, 64062, 64328, 64330, 64331, 66644, 70440, 70446, 70448, 70451,
 70722, 70861, 71224, 72049, 72325, 73494, 75898, 77687, 77690, 77694, 77903, 78151, 78416, 78748,
 79390, 79614, 79770, 79771, 79773, 79774, 80362, 80910, 81857, 82115, 82576, 82770, 83764, 83765,
 84351, 85697, 85966, 86332, 86333, 86393, 87182, 87221, 87371, 87372, 87543, 87544, 87594, 89545,
 89803, 89870, 89935, 89937, 90133, 90242, 90243, 90244, 90245, 90246, 90254, 90258, 90293, 90300,
 90301, 90312, 90313, 90315, 90318, 90319, 90366);

Branch(es): master

TC rev. hash/commit:
TrinityCore rev. e26122d 2020-12-28 11:32:57 +0100 (master branch) (Win64, Release, Static) (worldserver-daemon)

Operating system: Windows 10 Pro version 20H2, Version OS: 19042.662

Branch-master Comp-Database Feedback-PatchFix
Source
picture osleyder85

Most helpful comment

Pastebin next time please 馃槃

picture MaxtorCoder on 30 Dec 2020
😄2 👍2

All 5 comments

Pastebin next time please 馃槃

MaxtorCoder picture MaxtorCoder on 30 Dec 2020
😄2 👍2

There is quite a lot of simplification potential in that SQL file, especially for the last query, the SET VerifiedBuild=36839 part, making it 253 lines instead of 746.

Please notice that SQL allows for the same set of data to be applied to multiple entries per query, as long as all those entries share the exact same data set.

Allow me to suggest the following (collapsed content):


creature_model_info.sql

DELETE FROM `creature_model_info` WHERE `DisplayID` IN 
(75371,78851,81106,84585,86404,86424,88786,88787,89266,89374,89419,90252,90257,90303,91010,91669,91670,91775,91776,
 91777,91778,91779,91780,91781,91782,91851,91853,91854,91995,91996,91997,91998,92198,92463,92464,92690,92691,92693,
 92751,92795,92803,92804,92821,92822,92823,92825,92831,93574,93637,94939,95022,95040,95041,95075,95204,95210,95595,
 95596,95599,95600,95602,95603,95605,95606,95608,95609,95610,95611,95616,95617,95619,95621,95626,95627,95628,95629,
 95765,95920,96136,96314,96315,96317,96318,96320,96363,96364,96384,96541,96778,96883,96884,96885,96903,96905,96906,
 96910,96913,96914,96915,96916,96419,96420,97213,97228,97229,97258,97267,97757,97795,97834,97915,98013,98571,98725,
 98730,99206,99207,99375,99385,99389,99391,99401,99444,99445,99449,99451,99452,99453,99456,99458,99462,99497,99498,
 99499,99507,99615,99666,99667,99807,99808,99809,99810,99811,99812,99813,99814,99815,99816,99817,99818,99819,99821,
 99822,99949,100003,100004,100159,100160,100165,100167,100168,100170,100172,100174,100184,100444);
INSERT INTO `creature_model_info` (`DisplayID`, `BoundingRadius`, `CombatReach`, `DisplayID_Other_Gender`, `VerifiedBuild`) VALUES
(75371, 0.334899783134460449, 0.4375, 0, 36839),
(78851, 0.255721211433410644, 1, 0, 36839),
(81106, 0.798952639102935791, 1.125, 0, 36839),
(84585, 0.882957339286804199, 0, 0, 36839),
(86404, 2.144748687744140625, 3.75, 0, 36839),
(86424, 1.71579897403717041, 3, 0, 36839),
(88786, 0.426489889621734619, 1, 0, 36839),
(88787, 0.426489889621734619, 1, 0, 36839),
(89266, 0.426489889621734619, 1, 0, 36839),
(89374, 0.208000004291534423, 1.5, 0, 36839),
(89419, 0.382999986410140991, 1.5, 0, 36839),
(90252, 0.305999994277954101, 1.5, 0, 36839),
(90257, 0.236000001430511474, 1.5, 0, 36839),
(90303, 0.305999994277954101, 1.5, 0, 36839),
(91010, 0.305999994277954101, 1.5, 0, 36839),
(91669, 0.236000001430511474, 1.5, 0, 36839),
(91670, 0.372000008821487426, 1.5, 0, 36839),
(91775, 1.71579897403717041, 3, 0, 36839),
(91776, 1.71579897403717041, 3, 0, 36839),
(91777, 1.71579897403717041, 3, 0, 36839),
(91778, 1.71579897403717041, 3, 0, 36839),
(91779, 1.71579897403717041, 3, 0, 36839),
(91780, 1.71579897403717041, 3, 0, 36839),
(91781, 1.71579897403717041, 3, 0, 36839),
(91782, 1.71579897403717041, 3, 0, 36839),
(91851, 1.973168730735778808, 3.449999809265136718, 0, 36839),
(91853, 1.973168730735778808, 3.449999809265136718, 0, 36839),
(91854, 1.973168730735778808, 3.449999809265136718, 0, 36839),
(91995, 0.347000002861022949, 1.5, 0, 36839),
(91996, 1, 1.5, 0, 36839),
(91997, 0.347222000360488891, 1.5, 0, 36839),
(91998, 0.305999994277954101, 1.5, 0, 36839),
(92198, 0.305999994277954101, 1.5, 0, 36839),
(92463, 0.382999986410140991, 1.5, 0, 36839),
(92464, 0.382999986410140991, 1.5, 0, 36839),
(92690, 0.208000004291534423, 1.5, 0, 36839),
(92691, 0.434946358203887939, 1, 0, 36839),
(92693, 0.434946358203887939, 1, 0, 36839),
(92751, 0.305999994277954101, 1.5, 0, 36839),
(92795, 0.347000002861022949, 1.5, 0, 36839),
(92803, 0.694444000720977783, 3, 0, 36839),
(92804, 0.347222000360488891, 1.5, 0, 36839),
(92821, 2.144748687744140625, 3.750000238418579101, 0, 36839),
(92822, 2.144748687744140625, 3.750000238418579101, 0, 36839),
(92823, 2.144748926162719726, 3.750000238418579101, 0, 36839),
(92825, 1, 1.5, 0, 36839),
(92831, 1.71579897403717041, 3, 0, 36839),
(93574, 0.360905170440673828, 0, 0, 36839),
(93637, 0.305999994277954101, 1.5, 0, 36839),
(94939, 0.305999994277954101, 1.5, 0, 36839),
(95022, 1.973168730735778808, 3.449999809265136718, 0, 36839),
(95040, 1, 1.5, 0, 36839),
(95041, 0.305999994277954101, 1.5, 0, 36839),
(95075, 1, 1.5, 0, 36839),
(95204, 0.729166150093078613, 3.149999856948852539, 0, 36839),
(95210, 0.347222000360488891, 1.5, 0, 36839),
(95595, 0.388999998569488525, 1.5, 0, 36839),
(95596, 0.305999994277954101, 1.5, 0, 36839),
(95599, 0.347000002861022949, 1.5, 0, 36839),
(95600, 0.208000004291534423, 1.5, 0, 36839),
(95602, 1, 1.5, 0, 36839),
(95603, 0.305999994277954101, 1.5, 0, 36839),
(95605, 0.347222000360488891, 1.5, 0, 36839),
(95606, 0.208000004291534423, 1.5, 0, 36839),
(95608, 1, 1.5, 0, 36839),
(95609, 0.347000002861022949, 1.5, 0, 36839),
(95610, 0.208000004291534423, 1.5, 0, 36839),
(95611, 0.305999994277954101, 1.5, 0, 36839),
(95616, 0.305999994277954101, 1.5, 0, 36839),
(95617, 0.305999994277954101, 1.5, 0, 36839),
(95619, 0.347000002861022949, 1.5, 0, 36839),
(95621, 1, 1.5, 0, 36839),
(95626, 0.208000004291534423, 1.5, 0, 36839),
(95627, 0.305999994277954101, 1.5, 0, 36839),
(95628, 0.347222000360488891, 1.5, 0, 36839),
(95629, 0.347000002861022949, 1.5, 0, 36839),
(95765, 0.300000011920928955, 5, 0, 36839),
(95920, 0.382819831371307373, 1, 0, 36839),
(96136, 0.208000004291534423, 1.5, 0, 36839),
(96314, 0.305999994277954101, 1.5, 0, 36839),
(96315, 0.236000001430511474, 1.5, 0, 36839),
(96317, 0.698000013828277587, 3, 0, 36839),
(96318, 0.347222000360488891, 1.5, 0, 36839),
(96320, 0.382999986410140991, 1.5, 0, 36839),
(96363, 0.382999986410140991, 1.5, 0, 36839),
(96364, 0.305999994277954101, 1.5, 0, 36839),
(96384, 0.305999994277954101, 1.5, 0, 36839),
(96541, 1.5, 6, 0, 36839),
(96778, 2.690669536590576171, 5.25, 0, 36839),
(96883, 0.236000001430511474, 1.5, 0, 36839),
(96884, 0.305999994277954101, 1.5, 0, 36839),
(96885, 0.698000013828277587, 3, 0, 36839),
(96903, 0.372000008821487426, 1.5, 0, 36839),
(96905, 0.382999986410140991, 1.5, 0, 36839),
(96906, 0.236000001430511474, 1.5, 0, 36839),
(96910, 0.347222000360488891, 1.5, 0, 36839),
(96913, 0.382999986410140991, 1.5, 0, 36839),
(96914, 0.372000008821487426, 1.5, 0, 36839),
(96915, 0.305999994277954101, 1.5, 0, 36839),
(96916, 0.722000002861022949, 3, 0, 36839),
(96419, 0.382999986410140991, 1.5, 0, 36839),
(96420, 0.722000002861022949, 3, 0, 36839),
(97213, 3.041802883148193359, 6.299999713897705078, 0, 36839),
(97228, 0.347000002861022949, 1.5, 0, 36839),
(97229, 0.305999994277954101, 1.5, 0, 36839),
(97258, 2.921010494232177734, 6, 0, 36839),
(97267, 0.310000002384185791, 1, 0, 36839),
(97757, 0.402149975299835205, 1.574999928474426269, 0, 36839),
(97795, 0.382999986410140991, 1.5, 0, 36839),
(97834, 0.305999994277954101, 1.5, 0, 36839),
(97915, 0.236000001430511474, 1.5, 0, 36839),
(98013, 11.64418411254882812, 12, 0, 36839),
(98571, 0.305999994277954101, 1.5, 0, 36839),
(98725, 0.382999986410140991, 1.5, 0, 36839),
(98730, 0.305999994277954101, 1.5, 0, 36839),
(99206, 0.305999994277954101, 1.5, 0, 36839),
(99207, 1, 1.5, 0, 36839),
(99375, 0.347222000360488891, 1.5, 0, 36839),
(99385, 0.305999994277954101, 1.5, 0, 36839),
(99389, 0.305999994277954101, 1.5, 0, 36839),
(99391, 0.208000004291534423, 1.5, 0, 36839),
(99401, 0.305999994277954101, 1.5, 0, 36839),
(99444, 0.236000001430511474, 1.5, 0, 36839),
(99445, 0.208000004291534423, 1.5, 0, 36839),
(99449, 0.372000008821487426, 1.5, 0, 36839),
(99451, 0.236000001430511474, 1.5, 0, 36839),
(99452, 0.372000008821487426, 1.5, 0, 36839),
(99453, 0.372000008821487426, 1.5, 0, 36839),
(99456, 0.372000008821487426, 1.5, 0, 36839),
(99458, 0.372000008821487426, 1.5, 0, 36839),
(99462, 0.305999994277954101, 1.5, 0, 36839),
(99497, 0.305999994277954101, 1.5, 0, 36839),
(99498, 0.208000004291534423, 1.5, 0, 36839),
(99499, 0.305999994277954101, 1.5, 0, 36839),
(99507, 0.305999994277954101, 1.5, 0, 36839),
(99615, 0.305999994277954101, 1.5, 0, 36839),
(99666, 0.305999994277954101, 1.5, 0, 36839),
(99667, 0.208000004291534423, 1.5, 0, 36839),
(99807, 0.372000008821487426, 1.5, 0, 36839),
(99808, 0.236000001430511474, 1.5, 0, 36839),
(99809, 0.305999994277954101, 1.5, 0, 36839),
(99810, 0.236000001430511474, 1.5, 0, 36839),
(99811, 0.236000001430511474, 1.5, 0, 36839),
(99812, 0.372000008821487426, 1.5, 0, 36839),
(99813, 0.372000008821487426, 1.5, 0, 36839),
(99814, 0.372000008821487426, 1.5, 0, 36839),
(99815, 0.236000001430511474, 1.5, 0, 36839),
(99816, 0.372000008821487426, 1.5, 0, 36839),
(99817, 0.236000001430511474, 1.5, 0, 36839),
(99818, 0.305999994277954101, 1.5, 0, 36839),
(99819, 0.372000008821487426, 1.5, 0, 36839),
(99821, 0.372000008821487426, 1.5, 0, 36839),
(99822, 0.236000001430511474, 1.5, 0, 36839),
(99949, 0.208000004291534423, 1.5, 0, 36839),
(100003, 0.208000004291534423, 1.5, 0, 36839),
(100004, 0.208000004291534423, 1.5, 0, 36839),
(100159, 0.305999994277954101, 1.5, 0, 36839),
(100160, 0.305999994277954101, 1.5, 0, 36839),
(100165, 0.305999994277954101, 1.5, 0, 36839),
(100167, 0.305999994277954101, 1.5, 0, 36839),
(100168, 0.305999994277954101, 1.5, 0, 36839),
(100170, 0.208000004291534423, 1.5, 0, 36839),
(100172, 0.208000004291534423, 1.5, 0, 36839),
(100174, 0.305999994277954101, 1.5, 0, 36839),
(100184, 0.208000004291534423, 1.5, 0, 36839),
(100444, 0.372000008821487426, 1.5, 0, 36839);

UPDATE `creature_model_info` SET `BoundingRadius`=0.928183615207672119, `CombatReach`=0.655102074146270751, `VerifiedBuild`=36839 WHERE `DisplayID` IN (283,1088,1157);
UPDATE `creature_model_info` SET `BoundingRadius`=0.681569099426269531, `CombatReach`=1.399999976158142089, `VerifiedBuild`=36839 WHERE `DisplayID`=913;
UPDATE `creature_model_info` SET `BoundingRadius`=0.277218431234359741, `CombatReach`=0.649999976158142089, `VerifiedBuild`=36839 WHERE `DisplayID`=2177;
UPDATE `creature_model_info` SET `BoundingRadius`=1.491378188133239746, `CombatReach`=2.099999904632568359, `VerifiedBuild`=36839 WHERE `DisplayID`=4658;
UPDATE `creature_model_info` SET `BoundingRadius`=1.544346451759338378, `CombatReach`=1.724999904632568359, `VerifiedBuild`=36839 WHERE `DisplayID`=43225;
UPDATE `creature_model_info` SET `BoundingRadius`=1.611492037773132324, `CombatReach`=1.800000071525573730, `VerifiedBuild`=36839 WHERE `DisplayID`=43226;
UPDATE `creature_model_info` SET `BoundingRadius`=2.104584932327270507, `CombatReach`=1.346938848495483398, `VerifiedBuild`=36839 WHERE `DisplayID` IN (52656,52696);
UPDATE `creature_model_info` SET `BoundingRadius`=2.161906719207763671, `CombatReach`=3.779999971389770507, `VerifiedBuild`=36839 WHERE `DisplayID`=58433;
UPDATE `creature_model_info` SET `BoundingRadius`=3.922137737274169921, `CombatReach`=2.775510311126708984, `VerifiedBuild`=36839 WHERE `DisplayID`=64922;
UPDATE `creature_model_info` SET `BoundingRadius`=1.220593214035034179, `CombatReach`=0.699999988079071044, `VerifiedBuild`=36839 WHERE `DisplayID`=64984;
UPDATE `creature_model_info` SET `BoundingRadius`=0.444560199975967407, `CombatReach`=1.132652997970581054, `VerifiedBuild`=36839 WHERE `DisplayID` IN (70178,70179);
UPDATE `creature_model_info` SET `BoundingRadius`=1.156236171722412109, `CombatReach`=0.699999988079071044, `VerifiedBuild`=36839 WHERE `DisplayID`=73350;

UPDATE `creature_model_info` SET `BoundingRadius`=0.334899783134460449, `CombatReach`=0.4375, `VerifiedBuild`=36839 WHERE `DisplayID`=75374;
UPDATE `creature_model_info` SET `BoundingRadius`=0.341551274061203002, `CombatReach`=0.4375, `VerifiedBuild`=36839 WHERE `DisplayID` IN (75380,87603);

UPDATE `creature_model_info` SET `BoundingRadius`=0.798952639102935791, `CombatReach`=1.125, `VerifiedBuild`=36839 WHERE `DisplayID` IN (1963,6106,81105);
UPDATE `creature_model_info` SET `BoundingRadius`=0.514177203178405761, `CombatReach`=1.875, `VerifiedBuild`=36839 WHERE `DisplayID`=66292;
UPDATE `creature_model_info` SET `BoundingRadius`=0.348749995231628417, `CombatReach`=1.125, `VerifiedBuild`=36839 WHERE `DisplayID`=73335;

UPDATE `creature_model_info` SET `BoundingRadius`=0.902500033378601074, `CombatReach`=3.75, `VerifiedBuild`=36839 WHERE `DisplayID`=5205;
UPDATE `creature_model_info` SET `BoundingRadius`=2.144748687744140625, `CombatReach`=3.75, `VerifiedBuild`=36839 WHERE `DisplayID`=56491;

UPDATE `creature_model_info` SET `BoundingRadius`=0.305999994277954101, `CombatReach`=1.5, `VerifiedBuild`=36839 WHERE `DisplayID` IN (6446,12669,12921,33948,36815,36816,42274);
UPDATE `creature_model_info` SET `BoundingRadius`=1.342910051345825195, `CombatReach`=1.5, `VerifiedBuild`=36839 WHERE `DisplayID` IN (26566,34007);
UPDATE `creature_model_info` SET `BoundingRadius`=1.014356374740600585, `CombatReach`=2.5, `VerifiedBuild`=36839 WHERE `DisplayID`= 70162;
UPDATE `creature_model_info` SET `BoundingRadius`=1.866102457046508789, `CombatReach`=1.5, `VerifiedBuild`=36839 WHERE `DisplayID`= 77902;
UPDATE `creature_model_info` SET `BoundingRadius`=1.140607118606567382, `CombatReach`=1.5, `VerifiedBuild`=36839 WHERE `DisplayID`= 79720;

UPDATE `creature_model_info` SET `BoundingRadius`=1.175999999046325683, `CombatReach`=1, `VerifiedBuild`=36839 WHERE `DisplayID`=6807;
UPDATE `creature_model_info` SET `BoundingRadius`=0.722000002861022949, `CombatReach`=3, `VerifiedBuild`=36839 WHERE `DisplayID` IN (6854,29569,49770,90255,90314);
UPDATE `creature_model_info` SET `BoundingRadius`=0.698000013828277587, `CombatReach`=3, `VerifiedBuild`=36839 WHERE `DisplayID`=49781;

UPDATE `creature_model_info` SET `BoundingRadius`=0.300000011920928955, `VerifiedBuild`=36839 WHERE `DisplayID`=3619;
UPDATE `creature_model_info` SET `BoundingRadius`=2.274878740310668945, `VerifiedBuild`=36839 WHERE `DisplayID`=5233;
UPDATE `creature_model_info` SET `BoundingRadius`=2.036857128143310546, `VerifiedBuild`=36839 WHERE `DisplayID`=23681;
UPDATE `creature_model_info` SET `BoundingRadius`=0.310000002384185791, `VerifiedBuild`=36839 WHERE `DisplayID`=40122;

UPDATE `creature_model_info` SET `VerifiedBuild`=36839 WHERE `DisplayID` IN 
(31, 80, 134, 137, 207, 221, 247, 304, 328, 338, 342, 344, 704, 744, 802, 901, 983, 987,
 1037, 1042, 1065, 1072, 1141, 1197, 1198, 1310, 1311, 1312, 1313, 1314, 1315, 1316, 1318, 1319,
 1320, 1323, 1329, 1332, 1333, 1358, 1366, 1368, 1372, 1373, 1374, 1375, 1379, 1380, 1381, 1382,
 1383, 1384, 1386, 1387, 1388, 1390, 1392, 1393, 1394, 1418, 1423, 1427, 1429, 1431, 1433, 1434,
 1436, 1437, 1438, 1439, 1440, 1441, 1443, 1444, 1445, 1446, 1448, 1449, 1450, 1505, 1507, 1508,
 1509, 1510, 1511, 1512, 1513, 1515, 1516, 1517, 1518, 1519, 1520, 1521, 1522, 1523, 1541, 1696,
 1697, 1762, 1815, 1986, 1987, 2176, 2327, 2328, 2402, 2404, 2405, 2706, 2954, 2974, 3128, 3133,
 3167, 3238, 3246, 3281, 3288, 3448, 3449, 3604, 3605, 3606, 3608, 3609, 4259, 4260, 4356, 4363,
 4368, 4382, 4384, 4386, 4464, 4469, 4514, 4601, 4602, 4612, 4626, 4888, 4959, 4960, 4996, 5000,
 5074, 5082, 5128, 5444, 5446, 5545, 5546, 5547, 5551, 5567, 5705, 5706, 5728, 5769, 5770, 5846,
 6005, 6006, 6839, 6843, 6873, 7136, 7137, 7511, 7613, 7673, 7991, 7992, 8000, 8001, 8848, 8971,
 9133, 10186, 10472, 10625, 10824, 11414, 11686, 12910, 12917, 12919, 12920, 12922, 12924, 12925,
 13171, 13349, 13355, 13356, 13843, 14338, 14369, 14370, 14413, 14414, 14415, 14431, 14472, 14492,
 14499, 14573, 14574, 14575, 14582, 14583, 14589, 14616, 14732, 14733, 15294, 15352, 15369, 15467,
 15468, 15470, 15594, 15921, 16235, 16238, 16697, 16850, 17250, 17694, 17696, 17697, 17703, 17717,
 17719, 17722, 18055, 18269, 18800, 18801, 19216, 19670, 20545, 20985, 20988, 21072, 21264, 21342,
 21512, 22493, 22661, 22739, 22740, 22743, 22744, 22746, 22750, 22769, 22873, 23516, 24079, 24979,
 25319, 25336, 25901, 27510, 27684, 27685, 27686, 27687, 27690, 27727, 27823, 28048, 28111, 28118,
 28120, 28282, 28507, 29496, 29795, 31737, 31738, 31760, 31953, 31988, 32170, 32171, 32936, 32937,
 32938, 32981, 32982, 33032, 33303, 33468, 33469, 33470, 33507, 33518, 33519, 33520, 33699, 33701,
 33743, 33750, 33751, 34004, 34070, 34136, 34139, 34141, 34143, 34144, 34154, 34155, 34156, 34157,
 34185, 34406, 34412, 35051, 35053, 35133, 35140, 35141, 35148, 35183, 35184, 35185, 35186, 35187,
 35192, 35193, 35194, 35195, 35198, 35216, 35218, 35237, 35241, 35242, 35244, 35301, 35498, 35499,
 35500, 35504, 35695, 35816, 35818, 35819, 35827, 35843, 35844, 36213, 36357, 36545, 36559, 36583,
 36584, 36585, 36597, 36598, 36615, 36758, 36814, 36839, 37020, 37087, 37088, 37138, 37310, 37311,
 37328, 37329, 37330, 37331, 37372, 37437, 37706, 37719, 37720, 37724, 38047, 38418, 38419, 38800,
 38804, 39532, 39637, 39809, 39910, 40012, 40013, 40123, 42273, 42275, 42276, 42279, 42384, 42385,
 42386, 42387, 42388, 42389, 42720, 42722, 42782, 43669, 43717, 43718, 43719, 43720, 43721, 43722,
 43724, 43725, 43726, 44604, 44740, 44816, 45170, 45319, 45320, 45862, 45864, 45865, 46026, 46093,
 46132, 46929, 46930, 46986, 47231, 47243, 47465, 47982, 49021, 51166, 51613, 60207, 60316, 61023,
 61024, 61763, 61764, 63597, 63605, 64062, 64328, 64330, 64331, 66644, 70440, 70446, 70448, 70451,
 70722, 70861, 71224, 72049, 72325, 73494, 75898, 77687, 77690, 77694, 77903, 78151, 78416, 78748,
 79390, 79614, 79770, 79771, 79773, 79774, 80362, 80910, 81857, 82115, 82576, 82770, 83764, 83765,
 84351, 85697, 85966, 86332, 86333, 86393, 87182, 87221, 87371, 87372, 87543, 87544, 87594, 89545,
 89803, 89870, 89935, 89937, 90133, 90242, 90243, 90244, 90245, 90246, 90254, 90258, 90293, 90300,
 90301, 90312, 90313, 90315, 90318, 90319, 90366);

I am not using the master branch or the 9.x game client at all, so please don't ask me to verify any sniff validity of this data content.
I am here just to share from general MySQL usage experience.

illfated picture illfated on 30 Dec 2020

Will check that

funjoker picture funjoker on 30 Dec 2020
👍2

Ref. also new ticket with similar content: #25792

illfated picture illfated on 2 Jan 2021

Yes of course, it is the continuation of the 1st part

osleyder85 picture osleyder85 on 2 Jan 2021
Was this page helpful?
0 / 5 - 0 ratings

Related issues

Jildor picture Jildor  路  3Comments
Keader picture Keader  路  3Comments
funjoker picture funjoker  路  3Comments
Rushor picture Rushor  路  3Comments
Rochet2 picture Rochet2  路  3Comments