lua - Adding current time played to total time played -
i have database total played game time in seconds. want fetch these seconds database, add current session play time in seconds , update database. should happen every 5 seconds. have done this, because currentsession + totaltimeplayeddb keeps adding full duration of current session on , over... ideas?
local currentplaytime = player:timeconnected() print(math.round(currentplaytime)) local playervalues = mysqlite.queryvalue([[select time chiz_time sid=']].. player:steamid() ..[[']], function(time) if time == "" time = math.round(currentplaytime) else time = math.round(time + time - currentplaytime ) end mysqlite.query([[update chiz_time set time = ']].. time ..[[' sid=']].. player:steamid() ..[[']]) end)
i
currentsession+totaltimeplayeddbkeeps adding full duration of current
you need compute delta last save time.
in init code somewhere:
lastsavetime = 0 in save routine:
totaltimeplayeddb = totaltimeplayeddb + currentsession - lastsavetime if (totaltimeplayeddb written database successfully) lastsavetime = currentsession end
Comments
Post a Comment