Reputation creature onkill

From ArcEmu-Wiki
Revision as of 15:59, 27 January 2011 by Hypershadow66 (Talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

SQL Structure

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.

Personal tools