[Release] FiveM Player Logger

Nathan_C · February 26, 2019, 10:02pm

This simple script logs player identifiers to a MySQL table when they connect to server and logs when they leave. Very useful for stats generation and capturing licenses if you need to ban users who leave too quickly.

Repository Link

Release

Enjoy. I plan on expanding this script in the future to add kick/ban logs and whatever other events I can capture.

You must have mysql-async functioning for this to work, of course.

godgutten · February 26, 2019, 10:05pm

Ohh nice cant wait to test this

I have a question tho what types of licenses is it logging?

and is it logging all possible licenses so say it finders steam and normal fivem license it is logging both in the same table in the database?

Edit:

NWM found it out

github.com

nathanctech/fivem_logger/blob/master/logger/log_server.lua#L7-L10


-- update player without a leave date, server must have crashed

local data = {}

data["server"] = server_name

MySQL.Async.execute("update player_log set leave_date = NOW() where server_name = @server and leave_date IS NULL", data)

hallux · February 26, 2019, 10:06pm

Looking at and understanding the code basics tells you exactly what it’s logging…

Nathan_C · February 26, 2019, 10:07pm

What hallux said. Those that feel like it can add columns to the table for other identifiers if they care, but I only log the ones that are really relevant.

godgutten · February 26, 2019, 10:08pm

Okay!

Yeah okay thanks for the info i was just wondering

DavidR · February 26, 2019, 10:19pm

I love it, much love <3

ItzDusty · February 26, 2019, 10:23pm

Nice release,

However, this will fill up databases like crazy as it duplicates entires. I joined once, restarted, joined again and there’s now two entires of me joining. Is this a bug? Did I install it wrong?

FAXES · February 26, 2019, 10:45pm

Ewwwww. Nathen C.

Nathan_C · February 26, 2019, 11:12pm

This is intentional. It will log every instance of someone connecting (successfully, spawning into the server). This is so you can log players over time.

If absolutely required you can “clean up” every so often by removing old entries with a simple query.

That said, you can have tens of thousands of records in the table and it should not affect performance much provided the mysql server isn’t running on a hamster wheel.

FAXES · February 26, 2019, 11:23pm

Suggestion:

Use the playerconnecting event. This would make it more ‘secure’ and also playerspawnned will execute everytime a player respawns… Using playerconnecting would also make the whole script server-side…

Nathan_C · February 26, 2019, 11:27pm

I should probably add a variable so it only fires once…

I don’t use playerConnecting because that fires every time an attempt is made. If the server’s full, the user gets rejected by hardcap but that event is still fired. Some people like spam connecting for whatever reason.

Nathan_C · February 26, 2019, 11:37pm

1.0.1 released. This fixes the bug where a new entry is logged whenever the player respawns rather than first connect.

Probe · February 27, 2019, 8:18am

Would it be possible to make this output to a discord chanel through webhooks?

Scott_UK · February 27, 2019, 8:50am

Nathan_C · February 27, 2019, 1:51pm

Sure, with the tutorial above, but that is outside the scope of this release.

NightStalker · May 13, 2019, 10:20pm

Awesome script, thanks for sharing!

Nathan_C · May 14, 2019, 3:55am

I have released 1.0.2 which resolves some issues with leave logging.

lucas54 · June 17, 2020, 1:50pm

je doit metre quoi ici server_name = GetConvar(“server_num”, “UNK”) – should be a CONVAR in server.cfg

ReadyIsHot · September 28, 2020, 9:30pm

did you add the kick and ban

Mark_Gozel · November 3, 2020, 1:18pm

is there a way to make this script log when someone starts and ends there shift im trying to get webhood to log how many hours my workers worked at the end of the week so i can pay them