aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2016-06-07 16:24:09 +0200
committerAokromes <Aokromes@users.noreply.github.com>2016-06-07 16:24:09 +0200
commite4adeadaef4e4d6a59c44e17d6bbec3d7e9b99f5 (patch)
treebdd38736f7622cc9b335a2e616a45068840f0c19 /sql
parent8776e350a0f1b5c7aeb9cb97e39706ceaf8ad5e7 (diff)
DB/Misc: Fix startup errors
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/6.x/2016_06_07_06_world.sql104
1 files changed, 104 insertions, 0 deletions
diff --git a/sql/updates/world/6.x/2016_06_07_06_world.sql b/sql/updates/world/6.x/2016_06_07_06_world.sql
new file mode 100644
index 00000000000..9f28f41fbc4
--- /dev/null
+++ b/sql/updates/world/6.x/2016_06_07_06_world.sql
@@ -0,0 +1,104 @@
+--
+DELETE FROM creature_model_info WHERE `DisplayID` IN (60891, 64194, 62895, 62427, 62900, 62398, 62896, 64118, 63037, 61795, 62249, 63277, 62248, 63274, 63271, 63269, 63268, 64462, 63158, 63137, 63135, 62027, 63159, 62116, 61923, 62033, 62115, 64128, 61820, 64722, 61838, 61837, 64771, 64136, 61981, 61832, 61831, 61867, 61787, 61878, 61788, 63745, 61822, 61856, 62142, 62057, 62058, 62126, 64133, 62002, 63349, 62000, 64434, 63278, 63245, 63244, 63213, 63248, 63280, 63211, 63303, 63290, 62114, 62117, 62034, 62620, 63083, 62019, 62018, 63167, 62017, 62020, 63084, 62042, 63368, 63366, 63365, 63424, 64435, 64436, 64437, 63206, 61755, 61756, 61757, 64129, 61775, 61776, 63079, 63080, 63078, 64127, 63283, 63150, 62853, 63691, 63718, 61995, 61985, 61940, 61943);
+INSERT INTO creature_model_info (`DisplayID`, `BoundingRadius`, `CombatReach`, `DisplayID_Other_Gender`) VALUES
+(60891, 0.0525, 0.15, 0), -- 60891
+(64194, 0.062, 0.2, 0), -- 64194
+(62895, 0.5394, 2.175, 0), -- 62895
+(62427, 0.5394, 2.175, 0), -- 62427
+(62900, 0.5952, 2.4, 0), -- 62900
+(62398, 0.5394, 2.175, 0), -- 62398
+(62896, 0.5394, 2.175, 0), -- 62896
+(64118, 0.03, 0.15, 0), -- 64118
+(63037, 0.525, 0.875, 0), -- 63037
+(61795, 0.39, 1.5, 0), -- 61795
+(62249, 0.208, 1.5, 0), -- 62249
+(63277, 0.347222, 1.5, 0), -- 63277
+(62248, 0.306, 1.5, 0), -- 62248
+(63274, 0.389, 1.5, 0), -- 63274
+(63271, 0.459, 2.25, 0), -- 63271
+(63269, 0.2912, 2.1, 0), -- 63269
+(63268, 0.5362, 2.1, 0), -- 63268
+(64462, 0.306, 1.5, 0), -- 64462
+(63158, 1, 1.5, 0), -- 63158
+(63137, 1.75, 2.625, 0), -- 63137
+(63135, 1.75, 2.625, 0), -- 63135
+(62027, 1.05, 1.5, 0), -- 62027
+(63159, 1, 1.5, 0), -- 63159
+(62116, 1, 1.5, 0), -- 62116
+(61923, 1, 1.5, 0), -- 61923
+(62033, 1.2, 1.8, 0), -- 62033
+(62115, 1, 1.5, 0), -- 62115
+(64128, 0.5, 0.75, 0), -- 64128
+(61820, 0.4836, 1.95, 0), -- 61820
+(64722, 0.5, 5, 0), -- 64722
+(61838, 0.2714, 1.725, 0), -- 61838
+(61837, 0.4278, 1.725, 0), -- 61837
+(64771, 0.372, 1.5, 0), -- 64771
+(64136, 0.35, 0.875, 0), -- 64136
+(61981, 1.528, 4, 0), -- 61981
+(61832, 0.4092, 1.65, 0), -- 61832
+(61831, 0.4092, 1.65, 0), -- 61831
+(61867, 0.93, 3.75, 0), -- 61867
+(61787, 0.4464, 1.8, 0), -- 61787
+(61878, 0.465, 1.875, 0), -- 61878
+(61788, 0.4092, 1.65, 0), -- 61788
+(63745, 0.537204, 1.5, 0), -- 63745
+(61822, 0.4836, 1.95, 0), -- 61822
+(61856, 0.35, 4.2, 0), -- 61856
+(62142, 0.744, 3, 0), -- 62142
+(62057, 0.6, 3, 0), -- 62057
+(62058, 0.6, 3, 0), -- 62058
+(62126, 0.137779, 1.5, 0), -- 62126
+(64133, 0.0465, 1.8, 0), -- 64133
+(62002, 0.2832, 1.8, 0), -- 62002
+(63349, 0.3519, 1.725, 0), -- 63349
+(62000, 0.2832, 1.8, 0), -- 62000
+(64434, 0.6511, 2.55, 0), -- 64434
+(63278, 0.9, 1.35, 0), -- 63278
+(63245, 0.2124, 1.35, 0), -- 63245
+(63244, 0.236, 1.5, 0), -- 63244
+(63213, 0.9, 1.35, 0), -- 63213
+(63248, 0.3348, 1.35, 0), -- 63248
+(63280, 0.9, 1.35, 0), -- 63280
+(63211, 0.9, 1.35, 0), -- 63211
+(63303, 0.3348, 1.35, 0), -- 63303
+(63290, 0.9, 1.35, 0), -- 63290
+(62114, 1, 1.5, 0), -- 62114
+(62117, 1, 1.5, 0), -- 62117
+(62034, 1.2, 1.8, 0), -- 62034
+(62620, 0.375, 1.5, 0), -- 62620
+(63083, 1, 1.5, 0), -- 63083
+(62019, 1, 1.5, 0), -- 62019
+(62018, 1, 1.5, 0), -- 62018
+(63167, 0.75, 0.75, 0), -- 63167
+(62017, 1, 1.5, 0), -- 62017
+(62020, 1, 1.5, 0), -- 62020
+(63084, 1, 1.5, 0), -- 63084
+(62042, 15, 1.5, 0), -- 62042
+(63368, 0.4, 0.4, 0), -- 63368
+(63366, 0.3, 0.3, 0), -- 63366
+(63365, 0.4, 0.4, 0), -- 63365
+(63424, 0.591, 1.5, 0), -- 63424
+(64435, 2.5, 3.125, 0), -- 64435
+(64436, 2.25, 2.8125, 0), -- 64436
+(64437, 2, 2.5, 0), -- 64437
+(63206, 0.69, 2.76, 0), -- 63206
+(61755, 0.5022, 2.025, 0), -- 61755
+(61756, 0.5208, 2.1, 0), -- 61756
+(61757, 0.3422, 2.175, 0), -- 61757
+(64129, 0.1085, 0.35, 0), -- 64129
+(61775, 0.45, 2.25, 0), -- 61775
+(61776, 0.45, 2.25, 0), -- 61776
+(63079, 0.6, 3, 0), -- 63079
+(63080, 0.69, 3.45, 0), -- 63080
+(63078, 0.9, 4.5, 0), -- 63078
+(64127, 0.35, 0.35, 0), -- 64127
+(63283, 0.306, 1.5, 0), -- 63283
+(63150, 0.611112, 10, 0), -- 63150
+(62853, 0.306, 1.5, 0), -- 62853
+(63691, 0.3, 0.375, 0), -- 63691
+(63718, 0.625, 1.25, 0), -- 63718
+(61995, 0.306, 1.5, 0), -- 61995
+(61985, 0.306, 1.5, 0), -- 61985
+(61940, 1, 5, 0), -- 61940
+(61943, 1, 1.5, 0); -- 61943