Site Tools

en:shard_database

Shard database

Information about what should be in the MYSQL database

See The game server database to understand in detail what each table contains.

nel_nel

Domain :

domain_id=12
domaine_name=ryzom_open
status=ds_open
patch_version=
backup_patch_url=address.ip:23001
patch_urls=address.ip/patch
login_address=address.ip:49998
session_manager_address=address.ip:49999
ring_db_name=ring_mini01
web_host=address.ip:30000
web_host_php=address.ip:40916
description=

Permission :

Permissionid=1(+1 each additional new permission)  
Uid=1(Even Uld to use it) 
Domainid=12  Shardid=302 
AccessPrivilege=OPEN, DEV, RESTRICTED 

Shard :

Shardid= 302
domain_id=12
WsAddr=adress.ip:
NbPlayers=0
Name=
Online=0 
Version=
FixedSessionId=0
State=ds_open
MOTD=

User :

Filled by ams

Uld=(Id of the user)
Login=(account name)
Password=(Encrypt)
ShardId=302
State=Offline
Privilege=:DEV: (To have all rights) 
.....

nel_ams

nel_ams and nel_ams_lib are filled in by AMS

nel_tool

……

neltool_domains :

domain_id=12
domain_name=ryzom_open
domaine_as_host=adress.ip
domain_as_port=46700
domain_rrd_path=/home/YOUR-USER/khanat-code/code/ryzom/server/save_shard/rrd_graphs
domain_las_admin_path=
domain_las_local_path=
domain_application=ryzom_open
......

……

netool_shards :

shard_id=302
shard_name=Open
shard_as_id=open
shard_domain_id=12
shard_lang=en
shard_restart=0

……

neltool_users :

It is filled by AMS

……

neltool_user_domains :

user_domain_id=1
user_domain_user_id=1
user_domain_domain_id=12

neltool_user_shards :

user_shard_id=1
user_shard_user_id=1
user_shard_shard_id=302
user_shard_domain_id=12

ring_mini01

……

ring_users

Filled with Shard
……

sessions

session_id=302
session_type=st_mainland
title=
owner=0
plan_date=
start_date=
description=
orientation=so_other
level=sl_a
rule_type=st_strict
access_type=at_private
state=ss_planned
.....

……

shard

shard_id=302
WSOnline=1
MOTD=Shard up
OldState=ds_restricted
RequiredState=ds_open

With the help of Depyraken! thanks to him

en/shard_database.txt · Last modified: 2016/12/20 13:36 by Domperss