Page 1 of 1

[offline players / player_backend]

Posted: Fri Jul 31, 2020 08:02
by bosapara
To open offline player's data before (player_backend = files), you had to open his file: /worlds/gameworld/players/playerfile (gif below)

Sometimes it need to restore an account, check cheater and etc.

Is it possible to open offline player data with "player_backend = sqlite3"?

Image

Re: [offline players / player_backend]

Posted: Sat Aug 01, 2020 09:46
by sirrobzeroone
sqlitedb browser might be what your after.

https://github.com/sqlitebrowser/sqlitebrowser/

edit: website https://sqlitebrowser.org/

Re: [offline players / player_backend]

Posted: Sat Aug 01, 2020 10:40
by bosapara
sirrobzeroone:

Maybe I explained it inaccurately. Can admins / moderators open offline player data inside of online server just with command? (player_backend = sqlite3)

With "player_backend = files" definitely was possible.

Editing an sqlite3 base with editor is a few different thing.

Re: [offline players / player_backend]

Posted: Sat Aug 01, 2020 13:10
by Krock
https://github.com/minetest/minetest/issues/6193

Write a mod that requires lua-sqlite3 and use that to read out the database. Though parallel writes must not be done -> open as read only and keep database access as short as possible.

Re: [offline players / player_backend]

Posted: Sun Aug 16, 2020 19:59
by bosapara
As i understood correctly, "core.get_player_or_load" will work only with last new Minetest versions.
Krock wrote:
Sat Aug 01, 2020 13:10
Write a mod that requires lua-sqlite3 and use that to read out the database. Though parallel writes must not be done -> open as read only and keep database access as short as possible.
Do similar mods exist which using lua-sqlite? Asked because Google is silent about how to use such a huge data files.