Difference between revisions of "Development:Network"

From VsWiki
Jump to: navigation, search
m (update)
(Markets:)
Line 126: Line 126:
  
  
NEW : DATABASE FOR ACCOUNT SERVER
+
 
 +
== NEW : DATABASE FOR ACCOUNT SERVER ==
 +
 
  
 
Current user_table:
 
Current user_table:

Revision as of 17:00, 26 April 2014

  • LAN Game - How to start up a simple server and battle each other.
    • If your computer is directly attached to the network or you have a router/firewall, you can set it up to allow others to connect to your server.

Networking documentation goes here:

There's still a lot to do.


Update of April 2014 :

2 members are working at the MMO Development :

*Eye~R ( hosting , gameplay designer )
*Ezee ( Dev , graphics , gameplay )

Eye~R wrote a first TODO list , because of " There's still a lot to do. " :

Vegastrike MMO Server ToDo list:

Vegaserver:

Fix "turrets" Fix owning >1 ship = player dies



Account Server:

Python:

PHP: Make the fuckin thing talk to MySQL =(



Website:

Pretty frontend, user signup and general website

Home page

About page

Signup page

Login Page


Admin control interface

Ability to review users logged in and evict

Ability to maintain blocklist (may tie this directly into the firewall)

Ability to perform basic admin of user accounts (issue password reset request to previously defined email, alter applicaable email, add user to blocklist)

Ability to perform basic admin of server


User control interface

Ability to change contact Email

Ability to change alternate contact details

Abiltiy to change about

Abiltiy to upload avatar

Ability to upload personal livery

Ability to maintain friends/contacts



DataBase:

Bases table

user table

Add fields for signup IP, last logged in IP and last 10 unique IP's

Add field for email used in signup

Add field for date/time of signup.

Add field for current email, to be used possibly for sending auth code to confirm human signup

Add fields for optional alternate contact details, and an "about" section for profile

Add fields for rank and for faction(default Unadorned)

Add field for IsSuper to indicate SuperUser

Add field for IsFaction to denote Faction Leader status

Add field for Ship (possibly better in accounts?)

account table

Possibly split CSV into applicable fields? will make tweaking of any particular value "easier"..


Markets:

Create sensible "production Tree"


NEW : DATABASE FOR ACCOUNT SERVER

Current user_table:


+---------------+-----------------+------+-----+-----------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+-----------------+------+-----+-----------+-------+ | username | varchar(20) | YES | | NULL | | | user_id | varchar(20) | YES | PRI | NULL | Auto-Increment | | user_password | varchar(50)| YES | | NULL | | +---------------+-------------+------+-----+---------+-------+

Proposed:


+---------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+-------------+------+-----+---------+-------+ | username | varchar(20) | YES | | NULL | | | user_id | varchar(20) | YES | | NULL | | | user_password | varchar(50) | YES | | NULL | | | signup_mail | varchar(30)| YES | | NULL | | | timedate_stamp | date(30)|YES| | NULL | | | user_mail | varchar(30)|YES| | NULL | | | signup_ip | varchar(12)|YES| | NULL | | | current_ip | varchar(12)|YES| | NULL | | | known_ip | varcahr(120)|YES| | NULL | | | issuper | int(1) | NO | | 0 | | | isfaction | int(1) | NO | | 0 | | | rank | varchar(20)|YES| | NULL | | | ship | varchar(30)|YES| | NULL | | | alt_contact| varchar(180)| YES | | NULL | | | about | varchar(1000)| YES | NULL | | +---------------+-------------+------+-----+---------+-------+