GuildsTable: Difference between revisions

From PSwiki
Jump to navigation Jump to search
← Older edit
VisualWikitext
m Reverted edits by Luca (Talk) to last revision by Ethryn
Grimston (talk | contribs)
156 edits
mNo edit summary
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
{| border=1
{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|-
! field
|
! type
|id
! foreign key
|int(11)
! description
|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
|
|
|-
|-
| id
|
| int(11)
|secret_ind
|char(1)
|
|
|
|
|
|
|-
|-
| name
| varchar(25)
|
|
|max_guild_points
|int(10)
|
|
|100
|
|Stores the maximum amount of gp allowed for assignment in this guild
|-
|-
| char_id_founder
| int(10)
|
|
|motd
|char(200)
|
|
|
|
|
|-
|-
| web_page
| varchar(255)
|
|
|alliance
|int(11)
|
|
|
|
|
|-
|-
| date_created
| datetime
|
|
|bank_money_circles
|int(10) unsigned
|
|
|0
|
|
|-
|-
| karma_points
| int(10)
|
|
|bank_money_octas
|int(10) unsigned
|
|
|0
|
|
|-
|-
| secret_ind
| char(1)
|
|
|bank_money_hexas
|int(10) unsigned
|
|
|0
|
|
|-
|
|bank_money_trias
|int(10) unsigned
|
|0
|
|
|-
|-
| motd
|ADD
| char(200)
|housetype
|varchar(100)
|
|
|
|
|
|Describes the type of guildhouse, example gugguild, ojaguild, ... If empty this guild has no guildhouse
|-
|-
| alliance
|ADD
| int(11)
|houseid
|int(11)
|
|
| -1
|
|
|Incremental instance guildhouse number 
|-
|-
| bank_money_circles
|ADD
| int(10) unsigned
|house_dev_owned
|int(11)
|
|
|0
|
|
|If 1, then points to a guildhouse managed by devs and not players (example Hydlaa Museum)
|-
|-
| bank_money_octas
|ADD
| int(10) unsigned
|housedoorid
|int(11)
|
|
| -1
|
|
|The actionlocation id representing the entrance to the guildhouse
|-
|-
| bank_money_hexas
|ADD
| int(10) unsigned
|housemasterkeyid
|int(11)
|
|
| -1
|
|
|The psitem ID representing the master key for this guildhouse
|-
|-
| bank_money_trias
|ADD
| int(10) unsigned
|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,...)
|}
|}


[[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,...)
Retrieved from "https://planeshift.top-ix.org//pswiki/index.php?title=GuildsTable&oldid=24347"