fodev.net

FOnline Development => General Discussion => Topic started by: zi4rox on August 23, 2014, 01:49:31 am

Title: Maintaining a server: SQL & users
Post by: zi4rox on August 23, 2014, 01:49:31 am
As of my progress on learning fonline - i've installed a server on my localhost for tests.
Have a couple of questions here:

1. I've configured SQL Server and edited fonline_server.cfg to grant access to a DB - but it seems that fonline doesn't use it at all. No tables - all empty. What is supposed to be stored there?
2. I've noticed that registered user info is stored in /save/clients/ in files(! not in sql db? why? can it be changed?) How can I work with this player data? (ex. file username.client) Is there a tool for it or a description of file structure? For example I want to change a player name - is it possilbe? Or a stats maybe? This files drives me nuts - no way to make server store this data in sql db?

Title: Re: Maintaining a server: SQL & users
Post by: JovankaB on August 23, 2014, 11:13:34 am
As of my progress on learning fonline - i've installed a server on my localhost for tests.
Have a couple of questions here:

1. I've configured SQL Server and edited fonline_server.cfg to grant access to a DB - but it seems that fonline doesn't use it at all. No tables - all empty. What is supposed to be stored there?
2. I've noticed that registered user info is stored in /save/clients/ in files(! not in sql db? why? can it be changed?) How can I work with this player data? (ex. file username.client) Is there a tool for it or a description of file structure? For example I want to change a player name - is it possilbe? Or a stats maybe? This files drives me nuts - no way to make server store this data in sql db?

I think the SQL thingy is some experimental FOnline:2238 dll extension used for logging,
not a vanilla FOnline feature. It was disabled when FOnline:2238 server was released
because it caused problems. Check these links:

http://fodev.net/forum/index.php/topic,29387.msg258233.html#msg258233
https://github.com/rotators/fo2238/commit/a99cc4fdc0883143214d3dd0abd2038a0f2a35d5

To use it I guess you would have to uncomment __DEBUG_DISABLE_SQL__ in _defines.fos
then modify and recompile /extensions/Backend/?

Files in /save/clients/ is just the way the engine does client accounts. It doesn't use SQL.
Title: Re: Maintaining a server: SQL & users
Post by: Ghosthack on August 23, 2014, 05:44:51 pm
In an earlier version a few years ago, the engine actually did use SQL for saving world state and player data but it was changed for performance reasons so now it's all serialized into binary files instead.
Title: Re: Maintaining a server: SQL & users
Post by: Wipe on August 23, 2014, 06:13:50 pm
I wouldn't recommend re-enabling Backend.dll, we suspected memory leak somewhere out there~
Use on your own risk :)
Title: Re: Maintaining a server: SQL & users
Post by: Colaotnein on September 08, 2014, 01:50:38 pm
Can anyone tell me the start time and location? It would be my first venture so not

sure how the handicap would work
Title: Re: Maintaining a server: SQL & users
Post by: Koniko on September 08, 2014, 02:14:56 pm
@up see main.fos and conifg.fos for basic changes like date