character_reputation

This table holds the reputation information for each character.

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
guid	int	unsigned	PRI	NO	0		Global Unique Identifier
faction	smallint	unsigned	PRI	NO	0
standing	int	signed		NO	0
flags	smallint	unsigned		NO	0

Description of fields

guid

The guid of the character.  

faction

The Faction ID that the character has the given reputation in.  

standing

The current reputation value that the character has.  

flags

This field is a bitmask containing flags that apply to the faction and how it's displayed to the character. Just like any flag field, you can combine flags by adding them together. If this field is 0, then it is not shown in the reputation list in-game.

Value	Flag	Name	Comment
1	0x01	FACTION_FLAG_VISIBLE	makes visible in client (set or can be set at interaction with target of this faction)
2	0x02	FACTION_FLAG_AT_WAR	enable AtWar-button in client. player controlled (except opposition team always war state), Flag only set on initial creation
4	0x04	FACTION_FLAG_HIDDEN	hidden faction from reputation pane in client (player can gain reputation, but this update not sent to client)
8	0x08	FACTION_FLAG_INVISIBLE_FORCED	always overwrite FACTION_FLAG_VISIBLE and hide faction in rep.list, used for hide opposite team factions
16	0x10	FACTION_FLAG_PEACE_FORCED	always overwrite FACTION_FLAG_AT_WAR, used for prevent war with own team factions
32	0x20	FACTION_FLAG_INACTIVE	player controlled, state stored in characters.data (CMSG_SET_FACTION_INACTIVE)
64	0x40	FACTION_FLAG_RIVAL	flag for the two competing outland factions
128	0x80	FACTION_FLAG_SPECIAL	horde and alliance home cities and their northrend allies have this flag