Arizard / deathrun

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

Zone Records #117

Closed ghost closed 4 years ago

ghost commented 7 years ago

I have a Problem, i dont know how to delete a record, beacaus i take 2 records at placing the zones

Kenajcrap commented 7 years ago

Unfortunately, there is no command for this right now, so you are gonna have to do it the hard way:

ATTENTION: BE REALLY CAREFUL FOLLOWING THESE INSTRUCTIONS, IF YOU MESS IT UP, YOU MAY DELETE THE ENTIRE RECORD LIST

First, go to the host's developer console (if you are using a dedicated server, go to it instead of the game console ) and type:

lua_run PrintTable(sql.Query("SELECT * FROM deathrun_records WHERE mapname = '"..game.GetMap().."' ORDER BY seconds ASC LIMIT 5"))

The game console will show you the 5 best times for that map. Find the one you want to delete and copy the number in the field "seconds".

Then put the number where it says "[seconds]" in the following command:

lua_run sql.Query("DELETE FROM deathrun_records WHERE mapname = '"..game.GetMap().."' AND seconds = [seconds]")

then, to be sure it's all done, type the first command again and see if the unwanted record is gone.

If you have any trouble, don't hesitate to ask :)

SuperBobbis commented 7 years ago

You CAN do what Kena has said, but if you aren't confident with that, you can always download SQLite browser.

In order to edit/delete records this way, you have to download SQLite browser and your server's sv.db file, located in the root garrysmod folder. Once opened in SQLite, there is a series of tabs. Click on the one labelled Browse Data and then in the drop down menu select deathrun_records. Once there, just find whatever record you want to edit or delete and then do it.

If you have any questions, feel free to add me on Steam to discuss them.