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 + totaltimeplayeddb keeps 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

Popular posts from this blog

java - How to specify maven bin in eclipse maven plugin? -

single sign on - Logging into Plone site with credentials passed through HTTP -

php - Why does AJAX not process login form? -