From 024b57bb74a664cd515cf0822d4b8e939a91fe03 Mon Sep 17 00:00:00 2001 From: Brian Date: Mon, 26 Jul 2010 17:58:25 -0600 Subject: * Implement reputation spillover via the database * Remove the nasty hack that we had to handle Vanguard Alliance / Horde * Expedition, and city spillover. * Needs DB data * Original patch by NoFantasy --HG-- branch : trunk --- sql/base/world_database.sql | 30 ++++++++++++++++++++++++++++++ 1 file changed, 30 insertions(+) (limited to 'sql/base') diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql index ebfcb2a0cfa..fbe88688b22 100644 --- a/sql/base/world_database.sql +++ b/sql/base/world_database.sql @@ -4681,6 +4681,36 @@ LOCK TABLES `reputation_reward_rate` WRITE; /*!40000 ALTER TABLE `reputation_reward_rate` DISABLE KEYS */; /*!40000 ALTER TABLE `reputation_reward_rate` ENABLE KEYS */; UNLOCK TABLES; +-- +-- Table structure for table `reputation_spillover_template` +-- + +DROP TABLE IF EXISTS `reputation_spillover_template`; +CREATE TABLE `reputation_spillover_template` ( + `faction` smallint(6) unsigned NOT NULL default '0' COMMENT 'faction entry', + `faction1` smallint(6) unsigned NOT NULL default '0' COMMENT 'faction to give spillover for', + `rate_1` float NOT NULL default '0' COMMENT 'the given rep points * rate', + `rank_1` tinyint(3) unsigned NOT NULL default '0' COMMENT 'max rank, above this will not give any spillover', + `faction2` smallint(6) unsigned NOT NULL default '0', + `rate_2` float NOT NULL default '0', + `rank_2` tinyint(3) unsigned NOT NULL default '0', + `faction3` smallint(6) unsigned NOT NULL default '0', + `rate_3` float NOT NULL default '0', + `rank_3` tinyint(3) unsigned NOT NULL default '0', + `faction4` smallint(6) unsigned NOT NULL default '0', + `rate_4` float NOT NULL default '0', + `rank_4` tinyint(3) unsigned NOT NULL default '0', + PRIMARY KEY (`faction`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Reputation spillover reputation gain'; + +-- +-- Dumping data for table `reputation_spillover_template` +-- + +LOCK TABLES `reputation_spillover_template` WRITE; +/*!40000 ALTER TABLE `reputation_spillover_template` DISABLE KEYS */; +/*!40000 ALTER TABLE `reputation_spillover_template` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `reserved_name` -- cgit v1.2.3