From 0b605fcb88d5922191434ff300db30bb68869230 Mon Sep 17 00:00:00 2001 From: megamage Date: Fri, 4 Sep 2009 22:41:39 -0500 Subject: *Add a dk quest sql back. It was removed by mistake in 5119, but was never added back. --HG-- branch : trunk --- sql/FULL/world_spell_full.sql | 3 ++- sql/updates/5576_world_scripts_dk.sql | 2 ++ 2 files changed, 4 insertions(+), 1 deletion(-) create mode 100644 sql/updates/5576_world_scripts_dk.sql (limited to 'sql') diff --git a/sql/FULL/world_spell_full.sql b/sql/FULL/world_spell_full.sql index 330e1ecc2c3..3d2d9adb482 100644 --- a/sql/FULL/world_spell_full.sql +++ b/sql/FULL/world_spell_full.sql @@ -2098,7 +2098,8 @@ update spell_area set quest_end = 12756 where spell=53081; update creature_template set spell1=53117 where entry=29104; update creature_template set spell1=53348,killcredit1=29150 where entry IN (29102,29103); - +UPDATE creature_template SET spell1=52435,spell2=52576,spell5=52588,VehicleId=79,speed=0 WHERE entry = 28833; +UPDATE `creature_template` SET vehicleid=87 WHERE (`entry`='28817'); -- mine car DELETE FROM `spell_script_target` WHERE `entry` in (53658, 53679, 53701, 53705, 53706, 53677, 53685); -- insert into spell_script_target values (53658, 1, 29173); diff --git a/sql/updates/5576_world_scripts_dk.sql b/sql/updates/5576_world_scripts_dk.sql new file mode 100644 index 00000000000..edad28297fb --- /dev/null +++ b/sql/updates/5576_world_scripts_dk.sql @@ -0,0 +1,2 @@ +UPDATE creature_template SET spell1=52435,spell2=52576,spell5=52588,VehicleId=79,speed=0 WHERE entry = 28833; +UPDATE `creature_template` SET vehicleid=87 WHERE (`entry`='28817'); -- mine car \ No newline at end of file -- cgit v1.2.3