So up to this date. I've done the following so far.
1. Create a scripting DLL that can be used by all the server components that provides LUA scripting. This is only for the server side development. We will be providing a client side scripting component that will allow users to modify their GUI and events/actions on the client.
2. Started the programming of the Logging server and now have a 70% complete server that has multiple threads for each connection and can log to the database (MS SQL and MySQL so far). This took longer to code because of the next point.
3. Completed a generic data DLL that will provide connectivity to the following databases (MS SQL, MSDE, MySQL, PostgreSQL, and Oracle). It is designed so you set the property of which database type you are connecting to and it will use the appropriate drivers and methodology to connect and provide access. We are currently fully tested on MS SQL, MSDE, and MySQL due to the space on my server. We will be removing MSDE and MySQL and installing PostgreSQL and Oracle to complete the supported databases. This component will be a life saver because it doesn't need to know anything about the actual DB structure. We have designed it to either run statements (stored procedures or SQL script) that either return data or just modifies data.
4. Completed a test client that simulates multiple connections to the logging server to test robustness and effectiveness. So far so good.
The next server on my plate is the Login server. I will be using ticket authentication (was pointed in this direction here by someone (sorry I forgot who, but I do appreciate it) to access the system after a successful login. This will in turn pass off a list of possible Master servers, who in turn use the ticket to authenticate the client accessing them.
Well, that's it for now. I hope I'll be able to post more frequently now that I'm back on track and moving forward.
Thanks for reading!
Eric 'Wackatronic' Tomlinson
Prinicipal, ImagiNet Games, Inc.