Core/Spells: add an other condition to SpellInfo::NeedsToBeTriggeredByCaster to correct spells with are wrongly triggered by target instead of caster

- convert archavons rock shards to spellscript (now it works properly)
- add a spellscript for one spell that can't be corrected by this (and delete the sai hack, now i uses the correct spell)

1 files changed, 13 insertions, 0 deletions

diff --git a/sql/updates/world/2013_09_06_01_world_misc.sql b/sql/updates/world/2013_09_06_01_world_misc.sql
new file mode 100644
index 00000000000..10533e8354c
--- /dev/null
+++ b/sql/updates/world/2013_09_06_01_world_misc.sql
@@ -0,0 +1,13 @@
+DELETE FROM `smart_scripts` WHERE `entryorguid`=28481 AND `source_type`=0;
+UPDATE `creature_template` SET `AIName`='' WHERE `entry`=28481;
+
+DELETE FROM `spell_script_names` WHERE `spell_id` IN (51769,51770,58941);
+INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES 
+(51769,'spell_q12619_emblazon_runeblade'),
+(51770,'spell_q12619_emblazon_runeblade_effect'),
+(58941,'spell_archavon_rock_shards');
+
+DELETE FROM `spelldifficulty_dbc` WHERE `id` IN (58695,58696);
+INSERT INTO `spelldifficulty_dbc`(`id`,`spellid0`,`spellid1`) VALUES 
+(58695,58695,60883),
+(58696,58696,60884);