Reputation creature onkill
CREATE TABLE `reputation_creature_onkill` ( `creature_id` int(30) NOT NULL, `faction_change_alliance` int(30) NOT NULL, `faction_change_horde` int(30) NOT NULL, `change_value` int(30) NOT NULL, `rep_limit` int(30) NOT NULL, PRIMARY KEY (`creature_id`, `faction_change_alliance`, `faction_change_horde`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Creature System';
Creature ID = The ID in the creature_proto table, this ID is also in the entryID column of creature_names table.
Faction Change Alliance = What faction ID will be changed after killing this monster if the player is of the Alliance?
Faction Change Horde = What faction ID will be changed after killing this monster if the player is of the Horde?
Change Value = The actual value of Reputation that is rewarded. This will award X reputation for Y faction. (Y Depending on Horde or Alliance in the above two columns)
Rep Limit = Sets a cap on how much of the total rep (1 being 1/3000 neutral, 40000 being 40000/42000 revered.) An example of this is in certain instances you will no longer receive rep after you are honored or revered with a faction.