aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authortobmaps <spambot42@yandex.ru>2011-06-18 05:17:48 +0700
committertobmaps <spambot42@yandex.ru>2011-06-18 05:17:48 +0700
commit4c23eb9fe2e147f69206c9ac9347f0660209e88d (patch)
tree27e7e3ece32a77a2bdbe3935e2fd2bba007072a9
parent7b87abe507a31909bfe630f7df944ec62c41cbfa (diff)
DB/Entities: Fix several vehicles
-rw-r--r--sql/updates/world/2011_06_17_21_world_misc.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/2011_06_17_21_world_misc.sql b/sql/updates/world/2011_06_17_21_world_misc.sql
new file mode 100644
index 00000000000..bfc6742b0b2
--- /dev/null
+++ b/sql/updates/world/2011_06_17_21_world_misc.sql
@@ -0,0 +1,9 @@
+UPDATE `creature_template` SET `baseattacktime`=2000,`speed_run`=0.99206 WHERE `entry`=35321;
+UPDATE `creature_template` SET `npcflag`=`npcflag`|0x1000000,`spell1`=51421 WHERE `entry`=28366
+UPDATE `creature_template` SET `npcflag`=`npcflag`|0x1000000,`exp`=2,`minlevel`=75,`maxlevel`=75,`baseattacktime`=2000,`speed_run`=3.42857,`VehicleId`=107 WHERE `entry`=35299;
+UPDATE `creature_model_info` SET `bounding_radius`=0.3055,`combat_reach`=1,`gender`=2 WHERE `modelid`=27101;
+UPDATE `creature_model_info` SET `bounding_radius`=0.434,`combat_reach`=1.4,`gender`=0 WHERE `modelid`=29862;
+
+DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=35299;
+INSERT INTO `npc_spellclick_spells` VALUES
+(35299,46598,0,0,0,1,0,0,0);