aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorShocker <shocker@freakz.ro>2011-06-12 19:46:33 +0300
committerShocker <shocker@freakz.ro>2011-06-12 19:46:33 +0300
commit13b34a5d7231a93d78b36416d2a32ef6457a0473 (patch)
treea3306cc5205311caf63fd931607d672c82b33a57 /sql
parentd277ecc26a98144a0697257b6505acc68f802f2a (diff)
Scripts/Quests: Implement quest 12659 (Scalps!)
Thanks Malcrom for condition Closes #917
Diffstat (limited to 'sql')
-rw-r--r--sql/scripts/world_scripts_full.sql1
-rw-r--r--sql/updates/world/2011_06_12_01_world_conditions.sql4
-rw-r--r--sql/updates/world/2011_06_12_01_world_spell_script_names.sql3
3 files changed, 8 insertions, 0 deletions
diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql
index b59220ec53f..6d8ca17379e 100644
--- a/sql/scripts/world_scripts_full.sql
+++ b/sql/scripts/world_scripts_full.sql
@@ -2245,6 +2245,7 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
( 55804, 'spell_q12937_relief_for_the_fallen'),
( 54798, 'spell_q12851_going_bearback'),
( 8593, 'spell_symbol_of_life_dummy'),
+( 52090, 'spell_q12659_ahunaes_knife'),
-- item
( 23074, 'spell_item_arcanite_dragonling'),
( 8063, 'spell_item_deviate_fish'),
diff --git a/sql/updates/world/2011_06_12_01_world_conditions.sql b/sql/updates/world/2011_06_12_01_world_conditions.sql
new file mode 100644
index 00000000000..65cbac95761
--- /dev/null
+++ b/sql/updates/world/2011_06_12_01_world_conditions.sql
@@ -0,0 +1,4 @@
+-- Add condition for Item 38731 "Ahunae's Knife" to target 28600 "Dead Heb'Drakkar Headhunter"
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=18 AND `SourceEntry`=38731;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
+(18,0,38731,0,24,2,28600,0,63,'','Item 38731 "Ahunae''s Knife" targets 28600 "Dead Heb''Drakkar Headhunter');
diff --git a/sql/updates/world/2011_06_12_01_world_spell_script_names.sql b/sql/updates/world/2011_06_12_01_world_spell_script_names.sql
new file mode 100644
index 00000000000..e2dbeceb417
--- /dev/null
+++ b/sql/updates/world/2011_06_12_01_world_spell_script_names.sql
@@ -0,0 +1,3 @@
+DELETE FROM `spell_script_names` WHERE `spell_id`=52090;
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
+(52090, 'spell_q12659_ahunaes_knife');