Records

[SoflyTtv]

Im having a hard time finding the date for records to edit or delete

[ceifa]

It's stored on local server sqlite, basically the sv.db file.

[ceifa]

I'm confused, can you elaborate your question?

[SoflyTtv]

nvm i got the sqlite done with what i do i just drop the file on the console

[SoflyTtv]

i see this / SQLite version 3.34.0 2020-12-01 16:14:00
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> .help
.archive ... Manage SQL archives

[SoflyTtv]

that mean i did it right

[SoflyTtv]

what commands i use to make it work and edit the sd.db

[Arizard]

I like to use https://sqlitebrowser.org/

1. Stop your server (so that no new records can be created while you make changes)
2. Download the sv.db file from the server's garrysmod directory. Save a backup of the original sv.db file somewhere!
3. Open sv.db using SQLite Browser. Go to the Browse Data tab.
4. Select the deathrun_records table.
5. Find the rows you want to edit, and then edit them. The columns are sid64 (the player's 64-bit Steam ID), mapname (the name of the map), and seconds (time taken to complete the map, in seconds).
6. Click Write changes.
7. Upload the sv.db file back into the server.
8. Start the server again 👍