diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/6.x/2016_06_07_02_world.sql | 133 |
1 files changed, 133 insertions, 0 deletions
diff --git a/sql/updates/world/6.x/2016_06_07_02_world.sql b/sql/updates/world/6.x/2016_06_07_02_world.sql new file mode 100644 index 00000000000..e333f8064ef --- /dev/null +++ b/sql/updates/world/6.x/2016_06_07_02_world.sql @@ -0,0 +1,133 @@ +-- +DELETE FROM creature_model_info WHERE `DisplayID` IN (63353, 62228, 63352, 63355, 63357, 63363, 62056, 63356, 63348, 63358, 63362, 63360, 63361, 62357, 62676, 62011, 63023, 61989, 62012, 62816, 63549, 62458, 64433, 63547, 63139, 62633, 62014, 63285, 63282, 63289, 63281, 64438, 64685, 63552, 62040, 63081, 61857, 63022, 61751, 61753, 61885, 62650, 64724, 64721, 64725, 64723, 64101, 63024, 62882, 64119, 63144, 63751, 62555, 64043, 62180, 64042, 61982, 64044, 62179, 62186, 63099, 64131, 63343, 64023, 63193, 63238, 63241, 63240, 61851, 62747, 63210, 62006, 64134, 63208, 61781, 63214, 62579, 62578, 62679, 62677, 64854, 63052, 63542, 63546, 63545, 63539, 63541, 63543, 63169, 63515, 63178, 63180, 63514, 62258, 63171, 63168, 62036, 62035, 62185, 61842, 61806, 64266, 61752, 63467, 62368, 62311, 64115, 62632, 63044, 64112, 63143, 62227, 62240, 62183, 64049, 64884, 63447, 64196, 62241, 64596, 65663, 65704, 62467, 62007, 63761, 63753, 63757, 62361, 64702, 64242); +INSERT INTO creature_model_info (`DisplayID`, `BoundingRadius`, `CombatReach`, `DisplayID_Other_Gender`) VALUES +(63353, 0.347, 1.5, 0), -- 63353 +(62228, 1, 1.5, 0), -- 62228 +(63352, 0.347, 1.5, 0), -- 63352 +(63355, 0.208, 1.5, 0), -- 63355 +(63357, 0.306, 1.5, 0), -- 63357 +(63363, 0.698, 3, 0), -- 63363 +(62056, 0.403, 1.3, 0), -- 62056 +(63356, 0.306, 1.5, 0), -- 63356 +(63348, 0.306, 1.5, 0), -- 63348 +(63358, 0.383, 1.5, 0), -- 63358 +(63362, 0.7797601, 3.24, 0), -- 63362 +(63360, 0.372, 1.5, 0), -- 63360 +(63361, 0.372, 1.5, 0), -- 63361 +(62357, 0.558, 2.25, 0), -- 62357 +(62676, 2, 1.5, 0), -- 62676 +(62011, 0.372, 1.5, 0), -- 62011 +(63023, 2.4, 1.5, 0), -- 63023 +(61989, 0.09, 0.09, 0), -- 61989 +(62012, 0.236, 1.5, 0), -- 62012 +(62816, 4, 1.5, 0), -- 62816 +(63549, 0.4836, 1.95, 0), -- 63549 +(62458, 0.6, 2.4, 0), -- 62458 +(64433, 1.6, 3.2, 0), -- 64433 +(63547, 0.744, 3, 0), -- 63547 +(63139, 0.7068, 2.85, 0), -- 63139 +(62633, 0.372, 1.5, 0), -- 62633 +(62014, 0.372, 1.5, 0), -- 62014 +(63285, 0.306, 1.5, 0), -- 63285 +(63282, 0.8725, 3.75, 0), -- 63282 +(63289, 0.347222, 1.5, 0), -- 63289 +(63281, 0.372, 1.5, 0), -- 63281 +(64438, 0.372, 1.5, 0), -- 64438 +(64685, 0.306, 1.5, 0), -- 64685 +(63552, 0.383, 1.5, 0), -- 63552 +(62040, 0.372, 1.5, 0), -- 62040 +(63081, 0.306, 1.5, 0), -- 63081 +(61857, 2.8, 1.5, 0), -- 61857 +(63022, 2.4, 1.5, 0), -- 63022 +(61751, 0.5208, 2.1, 0), -- 61751 +(61753, 0.5394, 2.175, 0), -- 61753 +(61885, 0.6696, 2.7, 0), -- 61885 +(62650, 7.5, 28.5, 0), -- 62650 +(64724, 0.5, 5, 0), -- 64724 +(64721, 0.5, 5, 0), -- 64721 +(64725, 0.5, 5, 0), -- 64725 +(64723, 1.5, 10.5, 0), -- 64723 +(64101, 0.555, 1.5, 0), -- 64101 +(63024, 2.3, 1.388889, 0), -- 63024 +(62882, 0.5, 1, 0), -- 62882 +(64119, 3.6, 24, 0), -- 64119 +(63144, 0.75, 2.5, 0), -- 63144 +(63751, 0.694, 3, 0), -- 63751 +(62555, 0.9, 1.5, 0), -- 62555 +(64043, 3.5, 1.401869, 0), -- 64043 +(62180, 0.3, 4, 0), -- 62180 +(64042, 3.5, 1.5, 0), -- 64042 +(61982, 0.3, 1.5, 0), -- 61982 +(64044, 3.5, 1.376147, 0), -- 64044 +(62179, 1, 1.5, 0), -- 62179 +(62186, 1, 1.5, 0), -- 62186 +(63099, 0.6, 1.5, 0), -- 63099 +(64131, 0.155, 0.75, 0), -- 64131 +(63343, 0.5, 5, 0), -- 63343 +(64023, 0.9, 3, 0), -- 64023 +(63193, 0.75, 10.5, 0), -- 63193 +(63238, 1.733715, 1.5, 0), -- 63238 +(63241, 1.444762, 1.25, 0), -- 63241 +(63240, 0.68751, 30, 0), -- 63240 +(61851, 0.744, 3, 0), -- 61851 +(62747, 0.45, 1.5, 0), -- 62747 +(63210, 3, 1.5, 0), -- 63210 +(62006, 0.306, 1.5, 0), -- 62006 +(64134, 0.217, 0.7, 0), -- 64134 +(63208, 0.472, 3, 0), -- 63208 +(61781, 0.236, 1.5, 0), -- 61781 +(63214, 2.5, 1.5, 0), -- 63214 +(62579, 0.465, 1.875, 0), -- 62579 +(62578, 0.465, 1.875, 0), -- 62578 +(62679, 2, 1.5, 0), -- 62679 +(62677, 2, 1.5, 0), -- 62677 +(64854, 0.5, 5, 0), -- 64854 +(63052, 0.975, 4.875, 0), -- 63052 +(63542, 0.372, 1.5, 0), -- 63542 +(63546, 0.558, 2.25, 0), -- 63546 +(63545, 0.236, 1.5, 0), -- 63545 +(63539, 0.372, 1.5, 0), -- 63539 +(63541, 0.372, 1.5, 0), -- 63541 +(63543, 0.236, 1.5, 0), -- 63543 +(63169, 0.24, 1.5, 0), -- 63169 +(63515, 1.14, 2.85, 0), -- 63515 +(63178, 3.15, 13.5, 0), -- 63178 +(63180, 3.15, 13.5, 0), -- 63180 +(63514, 1.65, 4.125, 0), -- 63514 +(62258, 6.335, 6.25, 0), -- 62258 +(63171, 0.42, 1.5, 0), -- 63171 +(63168, 0.24, 1.5, 0), -- 63168 +(62036, 1.1, 1.65, 0), -- 62036 +(62035, 1.1, 1.65, 0), -- 62035 +(62185, 1, 1.5, 0), -- 62185 +(61842, 0.2596, 1.65, 0), -- 61842 +(61806, 0.4092, 1.65, 0), -- 61806 +(64266, 0.31, 12, 0), -- 64266 +(61752, 0.5394, 2.175, 0), -- 61752 +(63467, 0.225, 3, 0), -- 63467 +(62368, 0.1175, 0.5, 0), -- 62368 +(62311, 22, 44, 0), -- 62311 +(64115, 0.6, 1.5, 0), -- 64115 +(62632, 1.2, 1.5, 0), -- 62632 +(63044, 2.75, 4.125, 0), -- 63044 +(64112, 0.15, 0.75, 0), -- 64112 +(63143, 0.45, 1.5, 0), -- 63143 +(62227, 0.6, 3.5, 0), -- 62227 +(62240, 0.8100001, 2.025, 0), -- 62240 +(62183, 1, 1, 0), -- 62183 +(64049, 0.306, 1.5, 0), -- 64049 +(64884, 0.306, 1.5, 0), -- 64884 +(63447, 0.09, 1.5, 0), -- 63447 +(64196, 0.372, 1.5, 0), -- 64196 +(62241, 0.306, 1.5, 0), -- 62241 +(64596, 0.306, 1.5, 0), -- 64596 +(65663, 0.306, 1.5, 0), -- 65663 +(65704, 0.389, 1.5, 0), -- 65704 +(62467, 0.347222, 1.5, 0), -- 62467 +(62007, 0.306, 1.5, 0), -- 62007 +(63761, 0.9747, 4.05, 0), -- 63761 +(63753, 0.236, 1.5, 0), -- 63753 +(63757, 0.306, 1.5, 0), -- 63757 +(62361, 0.4464, 1.8, 0), -- 62361 +(64702, 1.07217, 4.455, 0), -- 64702 +(64242, 3, 2, 0); -- 64242 |