Junior Spellweaver
- Joined
- Oct 20, 2013
- Messages
- 193
- Reaction score
- 56
Soul of the Ultimate Nation
Server Development
Server Development
Overview
This Java project is being developed in IntelliJ IDEA using JDK 8. The overall development of this project will consist of three servers (Login, Game, and Chat) that will communicate with each other, other clients, and the database. The servers will be built to support the Chinese version of SUN Online Episode 1 (v1006). The scope of the project may change, especially if needing to build more than three servers.
Project Status
Login Server - In Progress: 98% complete
Create User Interface - complete
Develop NIO Server - complete
Create INI File Reader - complete
Create .txt Log Writer - complete
Create Server Reset Handler - complete
Create Packet Handler - complete
Create Packet Decoder - complete
Create Session Handler - complete
Create Message Decoder - complete
Create SQL Server Connector - complete
Figure out password encryption - complete
Create Query Writer/Reader - complete
Create Packet Decoder - complete
Create Mac Address Filter - complete
Create a feature to do trusted devices - complete
Refactoring and new features - in progress
Develop NIO Server - complete
Create INI File Reader - complete
Create .txt Log Writer - complete
Create Server Reset Handler - complete
Create Packet Handler - complete
Create Packet Decoder - complete
Create Session Handler - complete
Create Message Decoder - complete
Create SQL Server Connector - complete
Figure out password encryption - complete
Create Query Writer/Reader - complete
Create Packet Decoder - complete
Create Mac Address Filter - complete
Create a feature to do trusted devices - complete
Refactoring and new features - in progress
Create User Interface - complete
Develop NIO Server - complete
Create INI File Reader - complete
Create .txt Log Writer - complete
Create Server Reset Handler - complete
Create SQL Server Connector - complete
Create Query Writer/Reader
Develop Packet Encoder/Decoder (Encryption)
Create Data Loader
Create Character Creation Handler
Create NPC Handler
Create World Handler
Create Monster Handler
...
Create INI File Reader - complete
Create .txt Log Writer - complete
Create Server Reset Handler - complete
Create SQL Server Connector - complete
Create Query Writer/Reader
Develop Packet Encoder/Decoder (Encryption)
Create Data Loader
Create Character Creation Handler
Create NPC Handler
Create World Handler
Create Monster Handler
...
To be announced at a later date.
Create database - complete
Create Users table - complete
Create Account table - complete
Create Character table - complete
Create Character Set/Data table - complete
Create Guild table - complete
Create Friendlist table - complete
Create Warehouse/Storage table - complete
Create login for Login Server - complete
Redesign the physical/logical database design
Create login for Game Server
Establish stronger security measures
Edit login privileges for the Login/Game server
Create Stored Procedures
...
Create Users table - complete
Create Account table - complete
Create Character table - complete
Create Character Set/Data table - complete
Create Guild table - complete
Create Friendlist table - complete
Create Warehouse/Storage table - complete
Create login for Login Server - complete
Redesign the physical/logical database design
Create login for Game Server
Establish stronger security measures
Edit login privileges for the Login/Game server
Create Stored Procedures
...
Goals
Please check the Github repositories for a more updated Goals list.
1. Continue the SUNOnline v1006 database.
a. Create a logic design in 3NF.
b. Redesign existing tables and create new tables to fit the logic design.
c. Create a login for the Game Server application with strong password.
d. Grant and revoke permissions and rights to selective tables for the login of the Login and Game Server application.
e. New stored procedures built for the Game Server.
2. Continue the Game server.b. Redesign existing tables and create new tables to fit the logic design.
c. Create a login for the Game Server application with strong password.
d. Grant and revoke permissions and rights to selective tables for the login of the Login and Game Server application.
e. New stored procedures built for the Game Server.
a. Figure out the packet encryption.
b. Create dynamic packet system.
c. Create the query class.
d. Refactor and add new features.
b. Create dynamic packet system.
c. Create the query class.
d. Refactor and add new features.
Github
All setup/configuration guides, documentation, dependencies, and etc. are listed in each repository in the README. Please read that first.
- Login Server: https://github.com/Ashime/LoginServer
- Game Server: https://github.com/Ashime/GameServer
Downloads
1. Chinese S.U.N Online Episode 1 client:
- Direct (Official): Bad Request
- Mirror (Google Drive): https://drive.google.com/open?id=1KQJVbfN8LPupaxk8H0-p4V6R4Bhy4I4W
- Server Files: https://drive.google.com/open?id=13eKRIBpCjGstzzSrsqQ4REhUnFUWkPiD
- ReadMe: https://drive.google.com/open?id=1n3vp0U75T5nOHOjhPfHjKaOwAOW_9jLHTZ0KNNBp450
Other
Related Discussions:
Appreciation
I want to give thanks to @CwaniX for providing the TEA algorithm to decrypt passwords and to anyone else who have helped in the [S.U.N Online] Encryption Algorithm discussion.
Last edited: