Site Tools

en:nel_mysql

The game server database

nel

The general table.

nel

Concerns the shard itself.

domain

  • 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

permission

In this table the fields UId, DomainId and ShardId should be foreign keys, but they are not defined as well

  • 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'

shard

Check that Online and NbPlayers are active.

  • 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?

user

Is it possible to turn over certain tables that we do not have and do not even ask for information, like the country?

In fact, we should keep only what really serves the game, and for the rest tie it to our table of users on khaganat, among other things for email and age.

  • 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

ams

About AMS

nel_ams

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

nel_ams_lib

ams_api_keys
ams_querycache
assigned
email
forwarded
in_group
in_support_group
plugins
settings
support_group
tag
tagged
ticket
ticket_attachments
ticket_category
ticket_content
ticket_group
ticket_info
ticket_log
ticket_reply
ticket_user
updates

nel_tool

neltool_annotations

neltool_applications

neltool_domains

neltool_groups

neltool_group_applications

neltool_group_domains

neltool_group_shards

neltool_locks

neltool_logs

neltool_notes

neltool_restart_groups

neltool_restart_messages

neltool_restart_sequences

neltool_shards

neltool_stats_hd_datas

neltool_stats_hd_times

neltool_users

neltool_user_applications

neltool_user_domains

neltool_user_shards

webig

Web applications related to the game server.

accounts

players

en/nel_mysql.txt · Last modified: 2016/12/20 14:01 by Domperss