MaNGOS merge: Mail System.

* Store loot in mail_loot_template indexed by mail template ids.
* Implement proper creating mail text copy item from mail template based mail.
* Move send functions to new MailDraft class from WorldSession.
* Implement mails sending at player levelup.
* Autor VladimirMangos, converted by me.

--HG--
branch : trunk

4 files changed, 54 insertions, 21 deletions

diff --git a/sql/updates/6521_world_command.sql b/sql/updates/6521_world_command.sql
new file mode 100644
index 00000000000..11bb1c404ce
--- /dev/null
+++ b/sql/updates/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/6521_world_mail_level_reward.sql b/sql/updates/6521_world_mail_level_reward.sql
new file mode 100644
index 00000000000..656bb83c69c
--- /dev/null
+++ b/sql/updates/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/6521_world_quest_mail_loot_template.sql b/sql/updates/6521_world_quest_mail_loot_template.sql
new file mode 100644
index 00000000000..08ebe03eca4
--- /dev/null
+++ b/sql/updates/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/world.sql b/sql/world.sql
index 3907d139b01..d8a20c724b0 100644
--- a/sql/world.sql
+++ b/sql/world.sql
@@ -1814,6 +1814,40 @@ CREATE TABLE `locales_quest` (
 SET character_set_client = @saved_cs_client;
 
 --
+-- Table structure for table `mail_level_reward`
+--
+
+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';
+
+--
+-- Table structure for table `mail_loot_template`
+--
+
+DROP TABLE IF EXISTS `mail_loot_template`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `mail_loot_template` (
+  `entry` mediumint(8) unsigned NOT NULL default '0',
+  `item` mediumint(8) unsigned NOT NULL default '0',
+  `ChanceOrQuestChance` float NOT NULL default '100',
+  `groupid` tinyint(3) unsigned NOT NULL default '0',
+  `mincountOrRef` mediumint(9) NOT NULL default '1',
+  `maxcount` tinyint(3) unsigned NOT NULL default '1',
+  `lootcondition` tinyint(3) unsigned NOT NULL default '0',
+  `condition_value1` mediumint(8) unsigned NOT NULL default '0',
+  `condition_value2` mediumint(8) unsigned NOT NULL default '0',
+  PRIMARY KEY  (`entry`,`item`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';
+SET character_set_client = @saved_cs_client;
+
+--
 -- Table structure for table `milling_loot_template`
 --
 
@@ -2380,27 +2414,6 @@ CREATE TABLE `quest_end_scripts` (
 SET character_set_client = @saved_cs_client;
 
 --
--- Table structure for table `quest_mail_loot_template`
---
-
-DROP TABLE IF EXISTS `quest_mail_loot_template`;
-SET @saved_cs_client     = @@character_set_client;
-SET character_set_client = utf8;
-CREATE TABLE `quest_mail_loot_template` (
-  `entry` mediumint(8) unsigned NOT NULL default '0',
-  `item` mediumint(8) unsigned NOT NULL default '0',
-  `ChanceOrQuestChance` float NOT NULL default '100',
-  `groupid` tinyint(3) unsigned NOT NULL default '0',
-  `mincountOrRef` mediumint(9) NOT NULL default '1',
-  `maxcount` tinyint(3) unsigned NOT NULL default '1',
-  `lootcondition` tinyint(3) unsigned NOT NULL default '0',
-  `condition_value1` mediumint(8) unsigned NOT NULL default '0',
-  `condition_value2` mediumint(8) unsigned NOT NULL default '0',
-  PRIMARY KEY  (`entry`,`item`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';
-SET character_set_client = @saved_cs_client;
-
---
 -- Table structure for table `quest_start_scripts`
 --