GuildsTable: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
mNo edit summary |
||
| Line 1: | Line 1: | ||
{| class="wikitable" | {| class="wikitable" | ||
|+ | |+ | ||
| Line 75: | Line 73: | ||
|Stores the maximum amount of gp allowed for assignment in this guild | |Stores the maximum amount of gp allowed for assignment in this guild | ||
|- | |- | ||
| | | | ||
|motd | |motd | ||
|char(200) | |char(200) | ||
| Line 81: | Line 79: | ||
| | | | ||
| | | | ||
| | | | ||
|- | |- | ||
| | | | ||
| Line 179: | Line 177: | ||
|Unlocked features for the guildhouse (HEAL, MUSICHALL, FEASTHALL,...) | |Unlocked features for the guildhouse (HEAL, MUSICHALL, FEASTHALL,...) | ||
|} | |} | ||
[[Category:Engine documents]] | [[Category:Engine documents]] | ||
Latest revision as of 14:38, 11 January 2022
| UE | Field | Type | Key Type | Default | Extra | Description |
|---|---|---|---|---|---|---|
| id | int(11) | PRI | auto_increment | |||
| name | varchar(25) | UNI | ||||
| char_id_founder | int(10) | 0 | ||||
| web_page | varchar(255) | |||||
| date_created | datetime | 0000-00-00 00:00:00 | ||||
| karma_points | int(10) | 0 | ||||
| secret_ind | char(1) | |||||
| max_guild_points | int(10) | 100 | Stores the maximum amount of gp allowed for assignment in this guild | |||
| motd | char(200) | |||||
| alliance | int(11) | |||||
| bank_money_circles | int(10) unsigned | 0 | ||||
| bank_money_octas | int(10) unsigned | 0 | ||||
| bank_money_hexas | int(10) unsigned | 0 | ||||
| bank_money_trias | int(10) unsigned | 0 | ||||
| ADD | housetype | varchar(100) | Describes the type of guildhouse, example gugguild, ojaguild, ... If empty this guild has no guildhouse | |||
| ADD | houseid | int(11) | -1 | Incremental instance guildhouse number | ||
| ADD | house_dev_owned | int(11) | 0 | If 1, then points to a guildhouse managed by devs and not players (example Hydlaa Museum) | ||
| ADD | housedoorid | int(11) | -1 | The actionlocation id representing the entrance to the guildhouse | ||
| ADD | housemasterkeyid | int(11) | -1 | The psitem ID representing the master key for this guildhouse | ||
| ADD | houselockid | int(11) | -1 | The psitem ID representing the lock for the guildhouse door | ||
| ADD | houseflags | varchar(100) | Unlocked features for the guildhouse (HEAL, MUSICHALL, FEASTHALL,...) |