This is an old revision of the document!
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
