Added trigger effect for Blood Oath Aura for Quest "Truce?" (by Svannon)

Added serverside spell place holder for future development.
Better syntax for a recent sql update (no need to re-import it).

--HG--
branch : trunk

3 files changed, 10 insertions, 1 deletions

diff --git a/sql/updates/8915_world_trinity_string.sql b/sql/updates/8915_world_trinity_string.sql
index 49676b0870a..3c882c98895 100644
--- a/sql/updates/8915_world_trinity_string.sql
+++ b/sql/updates/8915_world_trinity_string.sql
@@ -1,4 +1,5 @@
 -- UPDATE so we don't kill customized locale strings if user has any
 UPDATE `trinity_string` SET `content_default`='The old password is wrong' WHERE `entry`=27;
 -- INSERT as this string has not been used before
-INSERT INTO `trinity_string` VALUES (62, 'One on more parameters have incorrect values', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+DELETE FROM `trinity_string` WHERE `entry`=62;
+INSERT INTO `trinity_string` (`entry`,`content_default`,`content_loc1`,`content_loc2`,`content_loc3`,`content_loc4`,`content_loc5`,`content_loc6`,`content_loc7`,`content_loc8`) VALUES (62, 'One on more parameters have incorrect values', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
diff --git a/sql/updates/8920_world_spell_dbc.sql b/sql/updates/8920_world_spell_dbc.sql
new file mode 100644
index 00000000000..a400139824a
--- /dev/null
+++ b/sql/updates/8920_world_spell_dbc.sql
@@ -0,0 +1,4 @@
+-- Add serverside spells place holders for future development
+DELETE FROM `spell_dbc` WHERE `Id` IN (70878);
+INSERT INTO `spell_dbc` (`Id`,`Comment`) VALUES
+(70878, 'Creature 40160 creature_addon serverside spell');
diff --git a/sql/updates/8920_world_spell_linked_spell.sql b/sql/updates/8920_world_spell_linked_spell.sql
new file mode 100644
index 00000000000..2b6a4bcf9ed
--- /dev/null
+++ b/sql/updates/8920_world_spell_linked_spell.sql
@@ -0,0 +1,4 @@
+-- For quest: Truce?
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=50141;
+INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES
+(50141,50001,0, 'Blood Oath to Blood Oath Aura');