From 4565242e946001f54103d1c2c7ebea0b7ef6437b Mon Sep 17 00:00:00 2001 From: Brian Date: Mon, 26 Jul 2010 16:21:10 -0600 Subject: * Implement reputation reward rate for quest / creatures * Need DB data for this to work * Original patch by NoFantasy --HG-- branch : trunk --- sql/base/world_database.sql | 22 ++++++++++++++++++++++ sql/updates/9036_world_reputation_reward_rate.sql | 8 ++++++++ 2 files changed, 30 insertions(+) create mode 100644 sql/updates/9036_world_reputation_reward_rate.sql (limited to 'sql') diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql index 03ce3ba57f2..ebfcb2a0cfa 100644 --- a/sql/base/world_database.sql +++ b/sql/base/world_database.sql @@ -4660,6 +4660,28 @@ LOCK TABLES `reference_loot_template` WRITE; /*!40000 ALTER TABLE `reference_loot_template` ENABLE KEYS */; UNLOCK TABLES; +-- +-- Table structure for table `reputation_reward_rate` +-- + +DROP TABLE IF EXISTS `reputation_reward_rate`; +CREATE TABLE `reputation_reward_rate` ( + `faction` mediumint(8) unsigned NOT NULL default '0', + `quest_rate` float NOT NULL default '1', + `creature_rate` float NOT NULL default '1', + `spell_rate` float NOT NULL default '1', + PRIMARY KEY (`faction`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `reputation_reward_rate` +-- + +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 `reserved_name` -- diff --git a/sql/updates/9036_world_reputation_reward_rate.sql b/sql/updates/9036_world_reputation_reward_rate.sql new file mode 100644 index 00000000000..5a6d31b8e4d --- /dev/null +++ b/sql/updates/9036_world_reputation_reward_rate.sql @@ -0,0 +1,8 @@ +DROP TABLE IF EXISTS `reputation_reward_rate`; +CREATE TABLE `reputation_reward_rate` ( + `faction` mediumint(8) unsigned NOT NULL default '0', + `quest_rate` float NOT NULL default '1', + `creature_rate` float NOT NULL default '1', + `spell_rate` float NOT NULL default '1', + PRIMARY KEY (`faction`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- cgit v1.2.3