Author Topic: Maintaining a server: SQL & users  (Read 4914 times)

Maintaining a server: SQL & users
« 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?


JovankaB

  • Guest
Re: Maintaining a server: SQL & users
« Reply #1 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.
« Last Edit: August 23, 2014, 11:35:30 am by JovankaB »

Offline Ghosthack

  • Rotator
  • Bytecruncher
Re: Maintaining a server: SQL & users
« Reply #2 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.

Offline Wipe

  • Rotator
  • Random is god
Re: Maintaining a server: SQL & users
« Reply #3 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 :)
Games are meant to be created, not played...

Re: Maintaining a server: SQL & users
« Reply #4 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

Re: Maintaining a server: SQL & users
« Reply #5 on: September 08, 2014, 02:14:56 pm »
@up see main.fos and conifg.fos for basic changes like date