Isn't time played stored in pga.db?

General Discussion
1

according to the internets , time played is stored in

local/share/lutris/pga.db

so edit that and you are good to go.
wrong.
i used sqlitebrowser to edit the time played to 0 and i still get the the previous values.

it looks like all the game data is stored in pga.db so it seems like this should be the right place.

anybody have any idea where time played is really stored ?

(also strace does not seem to think that pga.db is ever being opened, which is odd)

edit: i forgot to mention. i actually renamed pga.db to foo.db and lutris didn’t seem to care.
maybe pga.db was used in previous versions of lutris, but not any longer?

2

That was weird. it IS stored in pga.db. Modified it and re-ran Lutris several times with no effect and suddenly the changes i made appeared. Only thing i can think of is that i didn’t really close Lutris (?).

A script that zeros out the play time. For your convenience :smiley:
There’s no particular reason for ‘playtime > 1.0’.

#!/bin/bash

echo "select * from games" | sqlite3 .local/share/lutris/pga.db
printf "\n"
echo "select name, playtime from games" | sqlite3 .local/share/lutris/pga.db
printf "\nUpdating...\n\n"
echo "update games set playtime=0.0 where playtime > 1.0" | sqlite3 .local/share/lutris/pga.db
echo "select name, playtime from games" | sqlite3 .local/share/lutris/pga.db