Life is Feudal Official Forum

[MH6]

I'm working on an interactive LiF mapping system (Baron) and part of this system requires a list of all currently active players on the server. As Steam Server Query does not reliably return this information, I wrote a script to store that information in the SQL database.

http://pastebin.com/M2FN2kwm

You just need to save this in the root folder of your dedicated server (as e.g. "baron.cs"), and add this line to your main.cs file:

Code: Select all

exec("baron.cs");

Next time you start your server, it will save all active players to the baron_players table every 10 seconds, or whatever you specify in the script. The baron_players table is just a table with an auto-increment integer ID and a CharacterID integer field.

You can then query this table to fetch all active players. Other in-game data can be stored as well, such as player name, position, health, etc.

Hope someone finds it useful, as it seems to be a common question in the modding community.

P.S.- For more adventurous modders, you can most likely hook into client connect/disconnect events and update a list that way, so you don't have to poll every # of seconds. I just didn't feel the need to do so.

[Somerlot]

Not sure how much it helps but when you use OpenOptionsPlayers in console it brings up the active players window. There might be a way to capture the information being fed into that window but I dont know that much about scripting.

[Vamyan]

Finally got annoyed by all the red text ERRR spam... optimum fix is to use dbi.Query() instead of dbi.Execute().

Simplest method is to change the sqlExecute() function to this:

Code: Select all

function sqlExecute(%sql)
{
   dbi.Query($nullobj,sqlNullCallback,%sql);
}


[Memnon]

Hi

I added this script to my server. But I am not sure how to query
The SQL database? Can someone please explain how to do this. I use heidi SQL

[KhaimovMR]

Thanks for your script. I'll implement this idea in LiFDS-CP.

[KhaimovMR]

If anybody's interested - i've implemented idea of this script in server control panel v0.9.7.
You can download it in this thread - LiFDS-CP v0.9.7