deathrun Records

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

Dec 22 '20 22:12 SoflyTtv

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

Dec 22 '20 22:12 ceifa

I'm confused, can you elaborate your question?

Dec 22 '20 23:12 ceifa

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

Dec 22 '20 23:12 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

Dec 22 '20 23:12 SoflyTtv

that mean i did it right

Dec 22 '20 23:12 SoflyTtv

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

Dec 22 '20 23:12 SoflyTtv

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

Stop your server (so that no new records can be created while you make changes)
Download the sv.db file from the server's garrysmod directory. Save a backup of the original sv.db file somewhere!
Open sv.db using SQLite Browser. Go to the Browse Data tab.
Select the deathrun_records table.
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).
Click Write changes.
Upload the sv.db file back into the server.
Start the server again 👍

Feb 13 '21 09:02 Arizard