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/updates/9036_world_reputation_reward_rate.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 sql/updates/9036_world_reputation_reward_rate.sql (limited to 'sql/updates') 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