The way I understand it is that the database (your .sql file) holds all of your players accounts, names, levels, races, deities, items, NPC's, rules, aa's, factions, zones, etc. If you make changes to that .sql file, that means you are simultaneously making changes to your server. Some changes can be applied using #hotfix in game, others need a fresh server restart to see the changes. For example, change the name of "a bat" in Greater Faydark to "an epic bat" in your SQL file and then type #repop in game and your "a bat" should now be called "an epic bat". You've effectively just made changes to your "server's database".
The actual server itself is just a series of programs running on your PC so that there is an actual world to even login to. The server is just referencing that .sql database so it know's how to populate your world with your specific settings.
Some things, like quests, are in the quests folder server side, and would need to be altered there. Hopefully this helps a little.
|
Threaded Mode
