Information about what should be in the MYSQL database
See The game server database to understand in detail what each table contains.
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=
Permissionid=1(+1 each additional new permission) Uid=1(Even Uld to use it) Domainid=12 Shardid=302 AccessPrivilege=OPEN, DEV, RESTRICTED
Shardid= 302 domain_id=12 WsAddr=adress.ip: NbPlayers=0 Name= Online=0 Version= FixedSessionId=0 State=ds_open MOTD=
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 and nel_ams_lib are filled in by AMS
……
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 ......
……
shard_id=302 shard_name=Open shard_as_id=open shard_domain_id=12 shard_lang=en shard_restart=0
……
It is filled by AMS
……
user_domain_id=1 user_domain_user_id=1 user_domain_domain_id=12
user_shard_id=1 user_shard_user_id=1 user_shard_shard_id=302 user_shard_domain_id=12
……
Filled with Shard
……
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_id=302 WSOnline=1 MOTD=Shard up OldState=ds_restricted RequiredState=ds_open
With the help of Depyraken! thanks to him