Core/Guilds: Implemented basic guild leveling (no player statistics/reputation)

3 files changed, 39 insertions, 0 deletions

diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 718ff3dba20..404ffbb6593 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -1639,6 +1639,9 @@ CREATE TABLE `guild` (
   `motd` varchar(128) NOT NULL DEFAULT '',
   `createdate` int(10) unsigned NOT NULL DEFAULT '0',
   `BankMoney` bigint(20) unsigned NOT NULL DEFAULT '0',
+  `level` int(10) unsigned DEFAULT '1',
+  `experience` bigint(20) unsigned DEFAULT '0',
+  `todayExperience` bigint(20) unsigned DEFAULT '0',
   PRIMARY KEY (`guildid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild System';
 /*!40101 SET character_set_client = @saved_cs_client */;
diff --git a/sql/updates/characters/2012_09_07_00_characters_guild_434.sql b/sql/updates/characters/2012_09_07_00_characters_guild_434.sql
new file mode 100644
index 00000000000..31695bab93f
--- /dev/null
+++ b/sql/updates/characters/2012_09_07_00_characters_guild_434.sql
@@ -0,0 +1,3 @@
+ALTER TABLE guild ADD `level` INT(10) unsigned DEFAULT '1' AFTER `BankMoney`;
+ALTER TABLE guild ADD `experience` BIGINT(20) unsigned DEFAULT '0' AFTER `level`;
+ALTER TABLE guild ADD `todayExperience` BIGINT(20) unsigned DEFAULT '0' AFTER `experience`;
diff --git a/sql/updates/world/2012_09_09_00_world_guild_xp_for_level.sql b/sql/updates/world/2012_09_09_00_world_guild_xp_for_level.sql
new file mode 100644
index 00000000000..aa2ee143d53
--- /dev/null
+++ b/sql/updates/world/2012_09_09_00_world_guild_xp_for_level.sql
@@ -0,0 +1,33 @@
+DROP TABLE IF EXISTS `guild_xp_for_level`;
+CREATE TABLE `guild_xp_for_level` (
+  `lvl` int(11) unsigned NOT NULL,
+  `xp_for_next_level` bigint(20) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`lvl`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+INSERT INTO `guild_xp_for_level` VALUES
+(1,16580000),
+(2,18240000),
+(3,19900000),
+(4,21550000),
+(5,23220000),
+(6,24880000),
+(7,26530000),
+(8,28190000),
+(9,29850000),
+(10,31510000),
+(11,33170000),
+(12,34820000),
+(13,36490000),
+(14,38140000),
+(15,39800000),
+(16,41450000),
+(17,43120000),
+(18,44780000),
+(19,46430000),
+(20,48090000),
+(21,49750000),
+(22,51410000),
+(23,53060000),
+(24,54730000),
+(25,56390000);