The game server database

When installing a Ryzom Core server, the mysql database is filled with various tricks, which must then be completed with the information contained in here.

This page tries to give meaning to the various values of the database.

The layout respects the tree structure in the database.

Django version of the databases

inlinetoc

The general table.

Concerns the shard itself.

• Domain_id: number identifying the domain(and this is not the shard, but what will contain one or more shards)
• Domain_name: domain name
• status
• patch_version
• backup_patch_urls
• patch_urls
• login_adress
• session_manager_address
• ring_db_name
• web_host
• web_host_php
• description

• PermissionId: Permission ID number
• UId: User(reference to User/UId)
• DomainId: Domain on which it is valid(reference to domain/domain_id)
• ShardId: Shard on which it is valid(reference to shard/shard_id).
• AccessPrivilege: conditions of the shard, user must have right conditions to be able to access the shard.
  

It's 19 characters maximum, which corresponds to the value: “OPEN, DEV, RESTRICTED”. Value for a normal user: “OPEN”. This is a set of three values: `AccessPrivilege` set ('OPEN', 'DEV', 'RESTRICTED') NOT NULL DEFAULT 'OPEN'

• ShardId: number identifying the shard(is not an autoincrement)
• Domain_id: number of the domain to which this shard is bound
• WsAddr: web address(ip) where this shard is located
• NbPlayers: number of players online
• Name: shard name
• Online: server status, is 0 or 1
• Version:?
• FixedSessionId?
• State: Server status. 4 Possible values:
  • Ds_close
  • Ds_dev which is the default
  • Ds_restricted
  • Ds_open which is the normal value of a running shard
  • MOTD: Word of the day that appears when you connect to the game server?

• UId: number identifying the user
• Login: login to login
• Password: password, chopped.
• ShardId: Shard ID where the user connects

  except that visibly, right? Some users have joined on Lirria, but remain at -1 in value: it is the permission table that manages the rights, this field is certainly a remnant of an old version. Or the value -1 has a meaning, like: all shards, but we only have one shard, we do not realize it.

• State: Online or Offline, online or offline.
• Privilege: User privilege, see rights_right. If there is nothing, basic player?

  See note above: managed by table permissions

• GroupName

  :?

• FirstName: not useful here
• LastName: id
• Birthday: to manage if people are minors or not
• Gender: unnecessary
• Country: id
• Email: useful for returning the password.
• Address: unnecessary
• City: unnecessary
• PostalCode: useless
• USState: unnecessary
• Chat : to 0, why? what's this?
• BetaKeyId: Key for those participating in the beta(opened up some bonuses later). Useless in khagnats case.
• CachedCoupons: coupons linked to codes to play without subscription. Useless in khagnats case.
• ProfileAccess ?
• Level : it can not be the level of the character, there is just the user, which has 5 characters …
• CurrentFunds : credit in case of payment?
• IdBilling ?
• Community : remainder of old separation in shard by language? useful ?
• Newsletter: subscription or name to a newsletter, not to be managed here …
• Account ?
• ChoiceSubLength :
• CurrentSubLength
• ValidIdBilling
• GMId
• ExtendedPrivilege
• ToolsGroup
• Unsubscribe
• SubDate
• SubIp
• SecurePassword
• LastInvoiceEmailCheck
• FromSource
• ValidMerchantCode
• PBC
• ApiKeySeed

About AMS

• UId
• Login
• Password
• Email
• Permission
• FirstName
• LastName
• Gender
• Country
• ReceiveMail
• Language

Web applications related to the game server.

Draft Nel Server Ryzom_Core