AzerothCore
Pages :

player_factionchange_items

<-Back-to:World

The `player_factionchange_items` table

Basically all item changes made when player changes faction.

Table Structure

Field Type Attributes Key Null Default Extra Comment
alliance_id INT UNSIGNED PRI NO
alliance_comment TEXT NO
horde_id INT UNSIGNED PRI NO
horde_comment TEXT NO

Description of the fields

alliance_id

This is the alliance item ID. If you convert to horde and your items have a record in his table, they will be converted to #horde_id

alliance_comment

This is for easy item name identifying. Comment style should be name(ItemLevel)

horde_id

This is the horde item ID. If you convert to alliance and your items have a record in his table, they will be converted to #alliance_id

horde_comment

This is for easy item name identifying. Comment style should be name (ItemLevel)