First part of renaming sql update files which did not respect Trinity standard.

Moved old sql update files to sql\updates\3.2.2a_old folder.

--HG--
branch : trunk

7 files changed, 81 insertions, 0 deletions

diff --git a/sql/updates/3.1.3_old/6509_characters_character_skills.sql b/sql/updates/3.1.3_old/6509_characters_character_skills.sql
new file mode 100644
index 00000000000..ce6dd5af7ef
--- /dev/null
+++ b/sql/updates/3.1.3_old/6509_characters_character_skills.sql
@@ -0,0 +1,48 @@
+DROP TABLE IF EXISTS `character_skills`;
+CREATE TABLE `character_skills` (
+  `guid` int(11) unsigned NOT NULL COMMENT 'Global Unique Identifier',
+  `skill` mediumint(9) unsigned NOT NULL,
+  `value` int(11) unsigned NOT NULL,
+  `max` mediumint(9) unsigned NOT NULL,
+  i mediumint(9),
+  PRIMARY KEY  (`guid`,`skill`,`i`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
+
+
+DROP TABLE IF EXISTS temp_skills;
+CREATE TABLE temp_skills (
+  i int(11) unsigned NOT NULL,
+  PRIMARY KEY (i)
+);
+
+INSERT INTO temp_skills VALUES
+( 0),( 1),( 2),( 3),( 4),( 5),( 6),( 7),( 8),( 9),(10),(11),(12),(13),(14),(15),(16),(17),(18),(19),
+(20),(21),(22),(23),(24),(25),(26),(27),(28),(29),(30),(31),(32),(33),(34),(35),(36),(37),(38),(39),
+(40),(41),(42),(43),(44),(45),(46),(47),(48),(49),(50),(51),(52),(53),(54),(55),(56),(57),(58),(59),
+(60),(61),(62),(63),(64),(65),(66),(67),(68),(69),(70),(71),(72),(73),(74),(75),(76),(77),(78),(79),
+(80),(81),(82),(83),(84),(85),(86),(87),(88),(89),(90),(91),(92),(93),(94),(95),(96),(97),(98),(99),
+(100),(101),(102),(103),(104),(105),(106),(107),(108),(109),(110),(111),(112),(113),(114),(115),(116),(117),(118),(119),
+(120),(121),(122),(123),(124),(125),(126),(127);
+
+INSERT INTO character_skills SELECT
+guid,
+((SUBSTRING(data, length(SUBSTRING_INDEX(data, ' ', 610+3*i))+2, length(SUBSTRING_INDEX(data, ' ', 610+3*i+1))- length(SUBSTRING_INDEX(data, ' ', 610+3*i)) - 1)) & 0xFFFF) as skill,
+(SUBSTRING(data, length(SUBSTRING_INDEX(data, ' ', 610+3*i+1))+2, length(SUBSTRING_INDEX(data, ' ', 610+3*i+2))- length(SUBSTRING_INDEX(data, ' ', 610+3*i+1)) - 1)) as value,
+(0) as max,
+i
+FROM characters, temp_skills;
+
+DELETE FROM character_skills WHERE skill = 0;
+DROP TABLE IF EXISTS temp_skills;
+
+UPDATE character_skills
+  SET max = ((value & 0xFFFF0000) >> 16);
+
+UPDATE character_skills
+  SET value = (value & 0xFFFF);
+
+ALTER IGNORE TABLE character_skills
+  CHANGE COLUMN value value mediumint(9) unsigned NOT NULL,
+  DROP PRIMARY KEY,
+  ADD  PRIMARY KEY (guid,skill),
+  DROP COLUMN i;
diff --git a/sql/updates/3.1.3_old/6518_world_spell_proc_event.sql b/sql/updates/3.1.3_old/6518_world_spell_proc_event.sql
new file mode 100644
index 00000000000..70e560d67a9
--- /dev/null
+++ b/sql/updates/3.1.3_old/6518_world_spell_proc_event.sql
@@ -0,0 +1,7 @@
+-- Add 20 second cooldown for Bloodworms
+DELETE FROM `spell_proc_event` WHERE `entry` IN (49027, 49542, 49543); 
+INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES 
+(49027, 0, 0, 0, 0, 0, 0, 0, 0, 3, 20),  -- Bloodworms rank 1 
+(49542, 0, 0, 0, 0, 0, 0, 0, 0, 6, 20),  -- Bloodworms rank 2 
+(49543, 0, 0, 0, 0, 0, 0, 0, 0, 9, 20);  -- Bloodworms rank 3
+
diff --git a/sql/updates/3.1.3_old/6521_world_command.sql b/sql/updates/3.1.3_old/6521_world_command.sql
new file mode 100644
index 00000000000..11bb1c404ce
--- /dev/null
+++ b/sql/updates/3.1.3_old/6521_world_command.sql
@@ -0,0 +1 @@
+UPDATE `command` SET `name`='reload mail_loot_template' WHERE `name`='reload quest_mail_loot_template';
\ No newline at end of file
diff --git a/sql/updates/3.1.3_old/6521_world_mail_level_reward.sql b/sql/updates/3.1.3_old/6521_world_mail_level_reward.sql
new file mode 100644
index 00000000000..656bb83c69c
--- /dev/null
+++ b/sql/updates/3.1.3_old/6521_world_mail_level_reward.sql
@@ -0,0 +1,15 @@
+DROP TABLE IF EXISTS `mail_level_reward`;
+CREATE TABLE `mail_level_reward` (
+  `level` tinyint(3) unsigned NOT NULL default '0',
+  `raceMask` mediumint(8) unsigned NOT NULL default '0',
+  `mailTemplateId` mediumint(8) unsigned NOT NULL default '0',
+  `senderEntry`    mediumint(8) unsigned NOT NULL default '0',
+  PRIMARY KEY  (`level`,`raceMask`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Mail System';
+
+INSERT INTO `mail_level_reward` VALUES
+(20, 1, 224, 4732),(20, 8, 225, 4753),
+(20, 4, 226, 4772),(20, 1024, 227, 20914),
+(20, 64, 228, 7954),(20, 32, 229, 3690),
+(20, 128, 230, 7953),(20, 2, 231, 4752),
+(20, 512, 232, 16280),(20, 16, 233, 4773);
\ No newline at end of file
diff --git a/sql/updates/3.1.3_old/6521_world_quest_mail_loot_template.sql b/sql/updates/3.1.3_old/6521_world_quest_mail_loot_template.sql
new file mode 100644
index 00000000000..08ebe03eca4
--- /dev/null
+++ b/sql/updates/3.1.3_old/6521_world_quest_mail_loot_template.sql
@@ -0,0 +1,4 @@
+RENAME TABLE quest_mail_loot_template TO mail_loot_template;
+
+UPDATE mail_loot_template, quest_template
+  SET mail_loot_template.entry = quest_template.RewMailTemplateId WHERE mail_loot_template.entry = quest_template.entry;
\ No newline at end of file
diff --git a/sql/updates/3.1.3_old/6539_world_spell_proc_event.sql b/sql/updates/3.1.3_old/6539_world_spell_proc_event.sql
new file mode 100644
index 00000000000..a1d9d179a8f
--- /dev/null
+++ b/sql/updates/3.1.3_old/6539_world_spell_proc_event.sql
@@ -0,0 +1,2 @@
+-- Fixed Ruthlessness proc from Envenom
+UPDATE spell_proc_event SET spellFamilyMask1 = 8 WHERE entry IN (14156, 14160, 14161);
\ No newline at end of file
diff --git a/sql/updates/3.1.3_old/6549_world_spell_proc_event.sql b/sql/updates/3.1.3_old/6549_world_spell_proc_event.sql
new file mode 100644
index 00000000000..a7cae2b1c09
--- /dev/null
+++ b/sql/updates/3.1.3_old/6549_world_spell_proc_event.sql
@@ -0,0 +1,4 @@
+DELETE FROM `spell_proc_event` WHERE `entry` IN (16086,16544);
+INSERT INTO `spell_proc_event` VALUES 
+( 16086, 0x04, 11, 0x00000000, 0x00040000, 0x00000000, 0x00030000, 0x00000000,   0,   0,   0), -- Improved Fire Nova Totem (Rank 1)
+( 16544, 0x04, 11, 0x00000000, 0x00040000, 0x00000000, 0x00030000, 0x00000000,   0,   0,   0); -- Improved Fire Nova Totem (Rank 2)