aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/2012_05_30_01_world_creature_template.sql76
1 files changed, 76 insertions, 0 deletions
diff --git a/sql/updates/world/2012_05_30_01_world_creature_template.sql b/sql/updates/world/2012_05_30_01_world_creature_template.sql
new file mode 100644
index 00000000000..4b469a13891
--- /dev/null
+++ b/sql/updates/world/2012_05_30_01_world_creature_template.sql
@@ -0,0 +1,76 @@
+-- Missing Vehicle_Id's from UDB
+UPDATE `creature_template` SET `VehicleId`=22 WHERE `entry`=24806;
+UPDATE `creature_template` SET `VehicleId`=22 WHERE `entry`=24821;
+UPDATE `creature_template` SET `VehicleId`=22 WHERE `entry`=24823;
+UPDATE `creature_template` SET `VehicleId`=22 WHERE `entry`=24825;
+UPDATE `creature_template` SET `VehicleId`=35 WHERE `entry`=26586;
+UPDATE `creature_template` SET `VehicleId`=35 WHERE `entry`=26590;
+UPDATE `creature_template` SET `VehicleId`=42 WHERE `entry`=27061;
+UPDATE `creature_template` SET `VehicleId`=80 WHERE `entry`=27886;
+UPDATE `creature_template` SET `VehicleId`=88 WHERE `entry`=27923;
+UPDATE `creature_template` SET `VehicleId`=90 WHERE `entry`=27932;
+UPDATE `creature_template` SET `VehicleId`=134 WHERE `entry`=28115;
+UPDATE `creature_template` SET `VehicleId`=152 WHERE `entry`=28182;
+UPDATE `creature_template` SET `VehicleId`=118 WHERE `entry`=28399;
+UPDATE `creature_template` SET `VehicleId`=121 WHERE `entry`=28468;
+UPDATE `creature_template` SET `VehicleId`=126 WHERE `entry`=28665;
+UPDATE `creature_template` SET `VehicleId`=138 WHERE `entry`=28817;
+UPDATE `creature_template` SET `VehicleId`=146 WHERE `entry`=28875;
+UPDATE `creature_template` SET `VehicleId`=148 WHERE `entry`=28985;
+UPDATE `creature_template` SET `VehicleId`=148 WHERE `entry`=28999;
+UPDATE `creature_template` SET `VehicleId`=149 WHERE `entry`=29005;
+UPDATE `creature_template` SET `VehicleId`=179 WHERE `entry`=29579;
+UPDATE `creature_template` SET `VehicleId`=186 WHERE `entry`=29677;
+UPDATE `creature_template` SET `VehicleId`=197 WHERE `entry`=29754;
+UPDATE `creature_template` SET `VehicleId`=203 WHERE `entry`=29863;
+UPDATE `creature_template` SET `VehicleId`=216 WHERE `entry`=30108;
+UPDATE `creature_template` SET `VehicleId`=231 WHERE `entry`=30331;
+UPDATE `creature_template` SET `VehicleId`=240 WHERE `entry`=30487;
+UPDATE `creature_template` SET `VehicleId`=257 WHERE `entry`=30895;
+UPDATE `creature_template` SET `VehicleId`=258 WHERE `entry`=31050;
+UPDATE `creature_template` SET `VehicleId`=259 WHERE `entry`=31110;
+UPDATE `creature_template` SET `VehicleId`=262 WHERE `entry`=31125;
+UPDATE `creature_template` SET `VehicleId`=264 WHERE `entry`=31157;
+UPDATE `creature_template` SET `VehicleId`=287 WHERE `entry`=31838;
+UPDATE `creature_template` SET `VehicleId`=315 WHERE `entry`=31857;
+UPDATE `creature_template` SET `VehicleId`=315 WHERE `entry`=31858;
+UPDATE `creature_template` SET `VehicleId`=315 WHERE `entry`=31861;
+UPDATE `creature_template` SET `VehicleId`=315 WHERE `entry`=31862;
+UPDATE `creature_template` SET `VehicleId`=296 WHERE `entry`=32198;
+UPDATE `creature_template` SET `VehicleId`=296 WHERE `entry`=32208;
+UPDATE `creature_template` SET `VehicleId`=302 WHERE `entry`=32348;
+UPDATE `creature_template` SET `VehicleId`=305 WHERE `entry`=32483;
+UPDATE `creature_template` SET `VehicleId`=295 WHERE `entry`=32511;
+UPDATE `creature_template` SET `VehicleId`=287 WHERE `entry`=32513;
+UPDATE `creature_template` SET `VehicleId`=308 WHERE `entry`=32535;
+UPDATE `creature_template` SET `VehicleId`=313 WHERE `entry`=32640;
+UPDATE `creature_template` SET `VehicleId`=90 WHERE `entry`=32682;
+UPDATE `creature_template` SET `VehicleId`=347 WHERE `entry`=33108;
+UPDATE `creature_template` SET `VehicleId`=356 WHERE `entry`=33364;
+UPDATE `creature_template` SET `VehicleId`=357 WHERE `entry`=33366;
+UPDATE `creature_template` SET `VehicleId`=358 WHERE `entry`=33369;
+UPDATE `creature_template` SET `VehicleId`=370 WHERE `entry`=33432;
+UPDATE `creature_template` SET `VehicleId`=371 WHERE `entry`=33651;
+UPDATE `creature_template` SET `VehicleId`=373 WHERE `entry`=33670;
+UPDATE `creature_template` SET `VehicleId`=392 WHERE `entry`=34146;
+UPDATE `creature_template` SET `VehicleId`=395 WHERE `entry`=34150;
+UPDATE `creature_template` SET `VehicleId`=396 WHERE `entry`=34151;
+UPDATE `creature_template` SET `VehicleId`=399 WHERE `entry`=34183;
+UPDATE `creature_template` SET `VehicleId`=435 WHERE `entry`=34776;
+UPDATE `creature_template` SET `VehicleId`=514 WHERE `entry`=35069;
+UPDATE `creature_template` SET `VehicleId`=548 WHERE `entry`=36812;
+UPDATE `creature_template` SET `VehicleId`=615 WHERE `entry`=37980;
+UPDATE `creature_template` SET `VehicleId`=647 WHERE `entry`=38711;
+UPDATE `creature_template` SET `VehicleId`=648 WHERE `entry`=38712;
+UPDATE `creature_template` SET `VehicleId`=700 WHERE `entry`=39682;
+UPDATE `creature_template` SET `VehicleId`=753 WHERE `entry`=39759;
+UPDATE `creature_template` SET `VehicleId`=763 WHERE `entry`=39819;
+UPDATE `creature_template` SET `VehicleId`=711 WHERE `entry`=39860;
+UPDATE `creature_template` SET `VehicleId`=747 WHERE `entry`=40479;
+UPDATE `creature_template` SET `VehicleId`=604 WHERE `entry`=37827;
+UPDATE `creature_template` SET `VehicleId`=610 WHERE `entry`=37952;
+-- From PitCrawler
+UPDATE `creature_template` SET `vehicleId`=202 WHERE `entry`=29903; -- Frostbite
+UPDATE `creature_template` SET `vehicleId`=241 WHERE `entry`=30388; -- Stormhoof
+UPDATE `creature_template` SET `vehicleId`=25 WHERE `entry`=25194; -- Kor'kron Riding Wolf
+UPDATE `creature_template` SET `vehicleId`=108 WHERE `entry`=28639; -- Heb'Jin's Bat