Difference between revisions of "Development:Network"

From VsWiki
Jump to: navigation, search
(NEW : DATABASE FOR ACCOUNT SERVER)
m (mooved on todo)
 
Line 11: Line 11:
  
 
'''There's still a lot to do'''.
 
'''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:
 
 
 
<nowiki>+---------------+-----------------+------+-----+-----------+-------+
 
| 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 | |
 
+---------------+-------------+------+-----+---------+-------+</nowiki>
 
 
 
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 | |
 
+---------------+-------------+------+-----+---------+-------+
 

Latest revision as of 17:05, 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.