*Remove Mana Tap from players and Drop Mana Tap's code. This spell not needed in 3.0.2+

--HG--
branch : trunk

2 files changed, 10 insertions, 0 deletions

diff --git a/sql/updates/3235_characters.sql b/sql/updates/3235_characters.sql
new file mode 100644
index 00000000000..814b2dda67c
--- /dev/null
+++ b/sql/updates/3235_characters.sql
@@ -0,0 +1,4 @@
+DELETE FROM `character_action` WHERE `type` = 0 AND `action` = 28734;
+DELETE FROM `character_aura` WHERE `spell` = 28734;
+DELETE FROM `character_spell` WHERE `spell` = 28734;
+DELETE FROM `character_spell_cooldown` WHERE `spell` = 28734;
diff --git a/sql/updates/3235_world.sql b/sql/updates/3235_world.sql
new file mode 100644
index 00000000000..68c18dfc886
--- /dev/null
+++ b/sql/updates/3235_world.sql
@@ -0,0 +1,6 @@
+DELETE FROM `playercreateinfo_action` WHERE `type` = 0 AND `action` = 28734;
+DELETE FROM `playercreateinfo_spell` WHERE `spell` = 28734;
+DELETE FROM `playercreateinfo_spell_custom` WHERE `spell` = 28734;
+
+UPDATE `playercreateinfo_action` SET `button` = 3 WHERE `race` = 10 AND `class` IN (2, 3, 5, 8, 9) AND `action` = 28730 AND `type` = 0;
+UPDATE `playercreateinfo_action` SET `button` = 4 WHERE `race` = 10 AND `class` = 4 AND `action` = 25046 AND `type` = 0;