Core/Spells: Partial revert of 5ddf90c5fe8e51a72697, use checkcast hook for disallowing spells to be casted directly

Closes #2108

2 files changed, 12 insertions, 0 deletions

diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql
index 92c5b80d603..c9f3efd4b8e 100644
--- a/sql/scripts/world_scripts_full.sql
+++ b/sql/scripts/world_scripts_full.sql
@@ -1976,6 +1976,11 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
 ( 25281, 'spell_gen_turkey_marker'),
 (-55428, 'spell_gen_lifeblood'),
 ( 65917, 'spell_gen_magic_rooster'),
+( 4073,  'spell_gen_allow_cast_from_item_only'),
+( 19804, 'spell_gen_allow_cast_from_item_only'),
+( 12749, 'spell_gen_allow_cast_from_item_only'),
+( 13258, 'spell_gen_allow_cast_from_item_only'),
+( 13166, 'spell_gen_allow_cast_from_item_only'),
 -- instances
 -- Black Temple
 ( 41475, 'spell_boss_lady_malande_shield'),
diff --git a/sql/updates/world/2011_06_24_06_world_spell_script_names.sql b/sql/updates/world/2011_06_24_06_world_spell_script_names.sql
new file mode 100644
index 00000000000..5c7b6e9bfc0
--- /dev/null
+++ b/sql/updates/world/2011_06_24_06_world_spell_script_names.sql
@@ -0,0 +1,7 @@
+DELETE FROM `spell_script_names` WHERE `spell_id` IN(4073,19804,12749,13258,13166);
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
+(4073,'spell_gen_allow_cast_from_item_only'),
+(19804,'spell_gen_allow_cast_from_item_only'),
+(12749,'spell_gen_allow_cast_from_item_only'),
+(13258,'spell_gen_allow_cast_from_item_only'),
+(13166,'spell_gen_allow_cast_from_item_only');