deathrun icon indicating copy to clipboard operation
deathrun copied to clipboard

Published 20 hours ago • verified publisher icon Arizard

Records

Open SoflyTtv opened this issue 4 years ago • 7 comments

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

SoflyTtv avatar Dec 22 '20 22:12 SoflyTtv

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

ceifa avatar Dec 22 '20 22:12 ceifa

I'm confused, can you elaborate your question?

ceifa avatar Dec 22 '20 23:12 ceifa

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

SoflyTtv avatar 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

SoflyTtv avatar Dec 22 '20 23:12 SoflyTtv

that mean i did it right

SoflyTtv avatar Dec 22 '20 23:12 SoflyTtv

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

SoflyTtv avatar Dec 22 '20 23:12 SoflyTtv

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 👍

Arizard avatar Feb 13 '21 09:02 Arizard