DB/Player: Add class/race level stats for the new combos (level 1 only);

Core/Misc: Set RecruitAFriend.MaxLevel to 80 (from 60);
Also fix a typo in previous commit (thanks @Blumster)

3 files changed, 69 insertions, 3 deletions

diff --git a/sql/updates/world/4.x/2011_11_27_00_world_player_levelstats.sql b/sql/updates/world/4.x/2011_11_27_00_world_player_levelstats.sql
new file mode 100644
index 00000000000..dfecacdaf07
--- /dev/null
+++ b/sql/updates/world/4.x/2011_11_27_00_world_player_levelstats.sql
@@ -0,0 +1,66 @@
+-- Races:
+SET @HUMAN := 1;
+SET @ORC := 2;
+SET @DWARF := 3;
+SET @NIGHT_ELF := 4;
+SET @UNDEAD := 5;
+SET @TAUREN := 6;
+SET @GNOME := 7;
+SET @TROLL := 8;
+SET @GOBLIN := 9;
+SET @BLOOD_ELF := 10;
+SET @DRAENEI := 11;
+SET @WORGEN := 22;
+-- Classes:
+SET @WARRIOR := 1;
+SET @PALADIN := 2;
+SET @HUNTER := 3;
+SET @ROGUE := 4;
+SET @PRIEST := 5;
+SET @DK := 6;
+SET @SHAMAN := 7;
+SET @MAGE := 8;
+SET @WARLOCK := 9;
+SET @DRUID := 11;
+
+DELETE FROM `player_levelstats` WHERE
+((`class`=@WARRIOR AND `race` IN (@BLOOD_ELF, @GOBLIN, @WORGEN)) OR
+(`class`=@PALADIN AND `race` IN (@TAUREN)) OR
+(`class`=@HUNTER  AND `race` IN (@HUMAN, @GOBLIN, @WORGEN, @UNDEAD)) OR
+(`class`=@ROGUE AND `race` IN (@GOBLIN, @WORGEN)) OR
+(`class`=@PRIEST  AND `race` IN (@GNOME, @GOBLIN, @WORGEN, @TAUREN)) OR
+(`class`=@SHAMAN  AND `race` IN (@GOBLIN, @DWARF)) OR
+(`class`=@MAGE AND `race` IN (@DWARF, @GOBLIN, @WORGEN, @NIGHT_ELF, @ORC)) OR
+(`class`=@WARLOCK AND `race` IN (@DWARF, @GOBLIN, @WORGEN, @TROLL)) OR
+(`class`=@DRUID AND `race` IN (@WORGEN, @TROLL))) AND `level`=1;
+DELETE FROM `player_levelstats` WHERE `class`=@DK AND `race` IN (@GOBLIN, @WORGEN) AND `level`=55;
+INSERT INTO `player_levelstats` (`class`, `race`, `level`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES
+(@WARRIOR, @BLOOD_ELF, 1, 20, 22, 20, 24, 19),
+(@WARRIOR, @GOBLIN, 1, 20, 22, 22, 23, 18),
+(@WARRIOR, @WORGEN, 1, 26, 22, 22, 16, 19),
+(@PALADIN, @TAUREN, 1, 27, 15, 24, 15, 23),
+(@HUNTER, @HUMAN, 1, 20,  23, 21, 20, 21),
+(@HUNTER, @WORGEN, 1, 23,  25, 21, 16, 20),
+(@HUNTER, @UNDEAD, 1, 19,  21, 22, 18, 26),
+(@HUNTER, @GOBLIN, 1, 17,  25, 21, 23, 19),
+(@ROGUE, @WORGEN, 1, 23, 25, 21, 16, 19),
+(@ROGUE, @GOBLIN, 1, 18, 25, 21, 23, 18),
+(@PRIEST, @GNOME, 1, 15 ,23, 19, 25, 23),
+(@PRIEST, @WORGEN, 1, 23 ,22, 20, 18, 22),
+(@PRIEST, @GOBLIN, 1, 17 ,22, 20, 25, 21),
+(@PRIEST, @TAUREN, 1, 25 ,15, 22, 17, 25),
+(@DK, @WORGEN, 55, 111, 75, 99, 25, 41),
+(@DK, @GOBLIN, 55, 105, 75, 99, 32, 40),
+(@SHAMAN, @DWARF, 1, 22, 16, 23, 22, 21),
+(@SHAMAN, @GOBLIN, 1, 18, 22, 21, 24, 20),
+(@MAGE, @DWARF, 1, 22, 16, 23, 22, 21),
+(@MAGE, @NIGHT_ELF, 1, 17, 25, 19, 23, 22),
+(@MAGE, @WORGEN, 1, 23, 22, 20, 19, 21),
+(@MAGE, @GOBLIN, 1, 17, 22, 20, 26, 20),
+(@MAGE, @ORC, 1, 23, 17, 22, 20, 25),
+(@WARLOCK, @WORGEN, 1, 23, 22, 21, 18, 21),
+(@WARLOCK, @DWARF, 1, 22, 16, 24, 21, 21),
+(@WARLOCK, @GOBLIN, 1, 17, 22, 21, 25, 20),
+(@WARLOCK, @TROLL, 1, 21, 22, 22, 18, 23),
+(@DRUID, @WORGEN, 1, 24, 22, 20, 18, 21),
+(@DRUID, @TROLL, 1, 22, 22, 21, 18, 23);
diff --git a/src/server/game/Miscellaneous/SharedDefines.h b/src/server/game/Miscellaneous/SharedDefines.h
index c7994125446..8c4dba94201 100755
--- a/src/server/game/Miscellaneous/SharedDefines.h
+++ b/src/server/game/Miscellaneous/SharedDefines.h
@@ -43,7 +43,7 @@ enum LootModes
     LOOT_MODE_HARD_MODE_1              = 0x2,
     LOOT_MODE_HARD_MODE_2              = 0x4,
     LOOT_MODE_HARD_MODE_3              = 0x8,
-    LOOT_MODE_HARD_MODE_4              = 0x16
+    LOOT_MODE_HARD_MODE_4              = 0x10
 };
 
 enum Gender
diff --git a/src/server/worldserver/worldserver.conf.dist b/src/server/worldserver/worldserver.conf.dist
index 818db5d46b8..6cff44baca8 100644
--- a/src/server/worldserver/worldserver.conf.dist
+++ b/src/server/worldserver/worldserver.conf.dist
@@ -1109,9 +1109,9 @@ StartArenaPoints = 0
 #    RecruitAFriend.MaxLevel
 #        Description: Highest level up to which a character can benefit from the Recruit-A-Friend
 #                     experience multiplier.
-#        Default:     60
+#        Default:     80
 
-RecruitAFriend.MaxLevel = 60
+RecruitAFriend.MaxLevel = 80
 
 #
 #    RecruitAFriend.MaxDifference