aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorZxBiohazardZx <zxbiohazardzx@gmail.com>2011-03-01 18:21:20 +0000
committerNay <dnpd.dd@gmail.com>2011-03-01 18:21:20 +0000
commitc242c9db3e11e76a62eb4781096ae85c27c2d91d (patch)
tree9fe1c9bdf4c61203ec87cf3b820ab1655e73983c
parent43240f8c3d723d8ae6a05b50baf0793819713954 (diff)
DB/NPC: Set correct npcflag and vehicleid for some difficulty entries npcs. Fixes DB startup errors.
Closes #814
-rw-r--r--sql/updates/world/2011_03_01_2_world_creature_template.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/world/2011_03_01_2_world_creature_template.sql b/sql/updates/world/2011_03_01_2_world_creature_template.sql
new file mode 100644
index 00000000000..b799e54617e
--- /dev/null
+++ b/sql/updates/world/2011_03_01_2_world_creature_template.sql
@@ -0,0 +1,3 @@
+UPDATE `creature_template` SET `npcflag`=`npcflag`|16777216 WHERE `entry` IN (27894,28781,30234,33062); -- match npcflag with diffentries (that got updated on 2011_02_28_7)
+UPDATE `creature_template` SET `VehicleId`=335 WHERE `entry`=34045; -- Salvaged Chopper (1)
+UPDATE `creature_template` SET `VehicleId`=335 WHERE `entry`=31748; -- Hover Disk (1)