|
|
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 | |
| |
− | +---------------+-------------+------+-----+---------+-------+
| |