Skip to content

faction Table

Defines reputation factions, their base standings per race/class, and other properties.


Schema Summary

Field Type Key Null Default Extra
id smallint(3) unsigned PRI NO 0
build smallint(4) unsigned PRI NO 5875
reputation_list_id mediumint(9) NO 0
base_rep_race_mask1 mediumint(8) unsigned NO 0
base_rep_race_mask2 mediumint(8) unsigned NO 0
base_rep_race_mask3 mediumint(8) unsigned NO 0
base_rep_race_mask4 mediumint(8) unsigned NO 0
base_rep_class_mask1 mediumint(8) unsigned NO 0
base_rep_class_mask2 mediumint(8) unsigned NO 0
base_rep_class_mask3 mediumint(8) unsigned NO 0
base_rep_class_mask4 mediumint(8) unsigned NO 0
base_rep_value1 mediumint(9) NO 0
base_rep_value2 mediumint(9) NO 0
base_rep_value3 mediumint(9) NO 0
base_rep_value4 mediumint(9) NO 0
reputation_flags1 mediumint(8) unsigned NO 0
reputation_flags2 mediumint(8) unsigned NO 0
reputation_flags3 mediumint(8) unsigned NO 0
reputation_flags4 mediumint(8) unsigned NO 0
team mediumint(8) unsigned NO 0
name varchar(256) NO ''
description varchar(512) NO ''

Field Breakdown

  • id - Primary Key. Faction (reputation group) id.
  • build - Primary Key. Client build this row targets.
  • reputation_list_id - Index players see in the rep pane (-1 not listed).
  • base_rep_race_mask1 - Race mask that receives the paired base_rep_value at creation.
  • base_rep_race_mask2 - Race mask that receives the paired base_rep_value at creation.
  • base_rep_race_mask3 - Race mask that receives the paired base_rep_value at creation.
  • base_rep_race_mask4 - Race mask that receives the paired base_rep_value at creation.
  • base_rep_class_mask1 - Class mask variant of the same pairing.
  • base_rep_class_mask2 - Class mask variant of the same pairing.
  • base_rep_class_mask3 - Class mask variant of the same pairing.
  • base_rep_class_mask4 - Class mask variant of the same pairing.
  • base_rep_value1 - Starting reputation for the corresponding mask row.
  • base_rep_value2 - Starting reputation for the corresponding mask row.
  • base_rep_value3 - Starting reputation for the corresponding mask row.
  • base_rep_value4 - Starting reputation for the corresponding mask row.
  • reputation_flags1 - Per-rank flags (visible/forgotten-at-war behaviour bits).
  • reputation_flags2 - Per-rank flags (visible/forgotten-at-war behaviour bits).
  • reputation_flags3 - Per-rank flags (visible/forgotten-at-war behaviour bits).
  • reputation_flags4 - Per-rank flags (visible/forgotten-at-war behaviour bits).
  • team - Parent faction chain link for spillover/aggregation.
  • name - Display strings.
  • description - Display strings.

Referenced by: item_template.RequiredReputationFaction and other reputation-requiring columns.