TribesTable: Difference between revisions

From PSwiki
Jump to navigation Jump to search
← Older editNewer edit →
VisualWikitext
Eonwind (talk | contribs)
175 edits
No edit summary
Grimston (talk | contribs)
156 edits
No edit summary
Line 1: Line 1:
{| border="1"
{| class="wikitable"
|-
|+
! field
!UE
! type
! foreign key
! description
|-
| id
| integer
|
|
|-
| name
| varchar
|
|
|-
| home_sector_id
| integer
|
|
|-
| home_x
| real
|
|
|-
| home_y
| real
|
|
|-
| home_z
| real
|
|
|-
| home_radius
| real
|
|
|-
| max_size
| integer
|
|
|-
| wealth_resource_name
| varchar
|
|
|-
| wealth_resource_nick
| varchar
|
|
|-
| wealth_resource_area
| varchar
|
|
|-
| wealth_gather_need
| varchar
|
| The need used to gather resources
|-
| wealth_resource_growth
| real
|
|
|-
| wealth_resource_growth_active
| real
|
|
|-
| wealth_resource_growth_active_limit
| integer
|
|
|-
| reproduction_cost
| integer
|
|
|-
| npc_idle_behavior
| varchar
|
|
|-
| tribal_recipe
| integer
|
|
|}
 
 
[[Category:Engine documents]]
 
 
 
 
{|
!Field
!Field
!type
!Type
!Key Type
!Default
!Extra
!Description
!Description
|-
|-
|
|id
|id
|int
|int(10)
|The ID of the tribe.
|PRI
|
|auto_increment
|The ID of the tribe.  
|-
|-
|
|name
|name
|string
|varchar(30)
|The name of the tribe.
|
|
|
|  
|-
|-
|
|home_sector_id
|home_sector_id
|int
|int(10) unsigned
|The ID of the sector where the tribe home is located
|
|0
|
|  
|-
|-
|
|home_x
|home_x
|float
|float(10,2)
|X-coordinate of the tribe home location
|
|0.00
|
|  
|-
|-
|
|home_y
|home_y
|float
|float(10,2)
|Y-coordinate of the tribe home location
|
|0.00
|
|  
|-
|-
|
|home_z
|home_z
|float
|float(10,2)
|Z-coordinate of the tribe home location
|
|0.00
|
|  
|-
|-
|
|home_radius
|home_radius
|float
|float(10,2)
|The radius of the tribe home
|
|0.00
|
|  
|-
|-
|
|max_size
|max_size
|int
|int(10)
|The maximum number of tribe memers allowed for this tribe.
|
|0
|
|  
|-
|-
|
|wealth_resource_name
|wealth_resource_name
|string
|varchar(30)
|Name of the resource this tribe treasures most. Collecting this will enable growth capability in the tribe.
|
|
|
|  
|-
|-
|
|wealth_resource_nick
|wealth_resource_nick
|string
|varchar(30)
|Commands like dig use the nick of the resource instead of the name.
|
|
|
|  
|-
|-
|
|wealth_resource_area
|wealth_resource_area
|string
|varchar(30)
|The name of the Location Type that represents location where the wealth resource might be found.
|
|
|
|  
|-
|-
|
|wealth_gather_need
|wealth_gather_need
|string
|varchar(30)
|The name of the tribe need that will enable collection of wealth resources. Made the primary need when the tribe has dead members.
|
|
|
|The need used to gather resources  
|-
|-
|
|wealth_resource_growth
|wealth_resource_growth
|float
|float(10,2)
|When there are no members of the tribe we need a push of resources at this rate to enable reproduction.
|
|0.00
|
|
|-
|-
| wealth_resource_growth_active
|
| real
|wealth_resource_growth_active
|  
|float(10,2)
|
|0.00
|
|  
|  
|-
|-
| wealth_resource_growth_active_limit
|
| integer
|wealth_resource_growth_active_limit
|  
|int(10)
|
|0
|
|  
|  
|-
|-
|
|reproduction_cost
|reproduction_cost
|int
|int(10)
|The cost to reproduce.
|
|0
|
|  
|-
|-
| npc_idle_behavior
|ADD
| varchar
|npc_idle_behavior
| (default value 'do nothing')
|varchar(30)
|
|do nothing
|
|  
|  
|-
|-
|ADD
|tribal_recipe
|tribal_recipe
|int
|int(5)
|the id of the tribal recipe to load on each npcclient startup
|
|
|
|
|-
|ADD
|enabled
|tinyint(4)
|
|1
|
|Is this tribe enabled or not
|}
|}

Revision as of 13:31, 11 January 2022

UE Field Type Key Type Default Extra Description
id int(10) PRI auto_increment The ID of the tribe.
name varchar(30)
home_sector_id int(10) unsigned 0
home_x float(10,2) 0.00
home_y float(10,2) 0.00
home_z float(10,2) 0.00
home_radius float(10,2) 0.00
max_size int(10) 0
wealth_resource_name varchar(30)
wealth_resource_nick varchar(30)
wealth_resource_area varchar(30)
wealth_gather_need varchar(30) The need used to gather resources
wealth_resource_growth float(10,2) 0.00
wealth_resource_growth_active float(10,2) 0.00
wealth_resource_growth_active_limit int(10) 0
reproduction_cost int(10) 0
ADD npc_idle_behavior varchar(30) do nothing
ADD tribal_recipe int(5)
ADD enabled tinyint(4) 1 Is this tribe enabled or not
Retrieved from "https://planeshift.top-ix.org//pswiki/index.php?title=TribesTable&oldid=24316"