Player Database access?

[Ballsinacan01 6]

Has anyone found a way to access the player database? I have a couple of players who are unable to spawn into our server in vybor. They load in and then the game crashes on them. 

 

They are able to access other servers and load in

Edited October 5, 2018 by Ballsinacan01

[Aussie Cleetus 57]

if you have any idea how to use sqlite, you could open the file and remove the players, but I'd recommend backing it up first

[Ballsinacan01 6]

@Aussie Cleetus Thank you for the response and I do, but don't I require a username and password or is this db not password protected?

[philippj 103]

11 minutes ago, Ballsinacan01 said:

@Aussie Cleetus Thank you for the response and I do, but don't I require a username and password or is this db not password protected?

You don't require a password for the player database

[Aussie Cleetus 57]

philippj is correct, no password to access the database, it's an open one.

The reason nobody tends to mess with it much is, the formatting of the data is pretty cryptic, but deleting entries should be no issue

[Ballsinacan01 6]

@philippj and @Aussie Cleetus Thank you, you are right not sure how I am going to match up the unique ID to the player name. I would think they would just use guid for player id but i guess not

Edited October 5, 2018 by Ballsinacan01

[philippj 103]

28 minutes ago, Ballsinacan01 said:

@philippj and @Aussie Cleetus Thank you, you are right not sure how I am going to match up the unique ID to the player name. I would think they would just use guid for player id but i guess not

ID = Auto-Increment 

UID = Bohemia Interactive UID => Base64(SHA256(SteamID64))

BattlEye GUID => MD5(BE+SteamID64)

BI probably wants internal UIDs but dunno why they changed it.

And ingame names are currently useless as well because the majority of players are not using the -name startup param. 

There is no easy solution to match up all the different IDs except the one you are already using ;)

Edited October 5, 2018 by philippj

[AXEL777 2]

On 05.10.2018 at 10:21 PM, philippj said:

ID = Auto-Increment 

UID = Bohemia Interactive UID => Base64(SHA256(SteamID64))

BattlEye GUID => MD5(BE+SteamID64)

BI probably wants internal UIDs but dunno why they changed it.

And ingame names are currently useless as well because the majority of players are not using the -name startup param. 

There is no easy solution to match up all the different IDs except the one you are already using ;)

i am test convert my steam id to SHA256 and next Base64, but i am don't have a new uid bohemia

[philippj 103]

Python 2.7: https://gist.github.com/philippj/8d6473ca544b78b6b701c816d4d9e0bb

Input: 76561198227028860

Output: GHe+2LuKcWsM4PMs9rYJma7JT3AE5e2qDcjMRqAqG9w=

 

[Sid Debian 132]

Try to use SteamID32. Not SteanID64.

[LastS 7]

Nice