search

Arizard / deathrun

Arizard's Deathrun gamemode for Garry's Mod
63 stars 38 forks source link

Records #164

Open SoflyTtv opened 3 years ago

SoflyTtv commented 3 years ago

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

ceifa commented 3 years ago

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

ceifa commented 3 years ago

I'm confused, can you elaborate your question?

SoflyTtv commented 3 years ago

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

SoflyTtv commented 3 years ago

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 commented 3 years ago

that mean i did it right

SoflyTtv commented 3 years ago

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

Arizard commented 3 years ago

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 👍