Posted 12 January 2013 - 07:07 PM
The break down..
1: Two servers [hardware]
- a: Each running the following.
2: Log in application
- used to take in info, check against existing accounts + passwords saved in a database table.
3: Character selection
- Client asks server upon log in, which characters and info to display, this qeuery pulls the info of character from the static info saved in the character database table [which is separate from the account table].
4: World application.
- This is the major application, it pulls the info selected from the character table, and holds it as static information while running the systems of the world server. The world server has several tables, all seperate / unique from each other. Consisting of NPC info, Quest info, Map info, Items of all types etc.
Merging the "servers" would consist of the following.
1:Taking the Leonis & Draconis character database table, and appending them with something like an identifier, be it L & D or what not. After that edit has been made, The tables may be condensed into 1 table. without discrepensy on name duplicates.
2: Taking the character table again, and appending the character ID's with an injection to add a "1-" for leonis and a "2-" for Draconis. This prevents the server from getting duplicate results while pulling characters on an ID qeuery.
3: Performing the same injection method on the item database table, that does the same appending to the "item owner ID" row, preventing the server from getting duplicates on the request of items, based on owner ID requests from the client / server.
4: Remove the log in server application, and world server application from Draconis server. Draconis is now ready to be shut down. As the data has been merged, and should no longer require any modifications, based on characters, ID's and item databases.
5: Storage. All items from Draconis storage, should be edited to a new ID slot for a temporary storage feature. Similar to an IM storage, but cannot ever have items placed into it. Only removed. This prevents storage issues with full storage, for storage slot ID's that are currently occupied.
6: Server is ready to be ran.
Issues that were corrected.
Duplicate char names.
Duplicate character ID's
Duplicate item owner ID's
Duplicate storage slot ID's that are filled.
Merging a server, is work yes, but it's a simple procedure that if followed correctly, will not produce errors..
But like I said, it's still only a fantasy.