[Request] userbar with character statistic and online player

[pdc58]

good afternoon someone has the script to see the players online and userbar with l2off statistic character? thanks and sorry for the inconvenience

[Simple2008]

SELECT COUNT(*) FROM user_data WHERE login > logout;

 

This query is not 100% accurate I may have to say.

When the server crashes or whatsoever online players usually stay "online" for this query.

[Anarchy]

If you are using hAuthD set UserCount in hAuthD.ini to 1

then use

SELECT TOP 1 world_user FROM lin2db.dbo.user_count WHERE server_id = 1 ORDER BY record_time DESC

where server_id is the id from the server table in lin2db, it is updated automatically by the native AuthD every 5 minutes, for hAuthD i'm not sure the delay, but it is more accurate and will return 0 when the server is down.

[pdc58]

very thanks for help  8)