[LUA and DB] Table with decrease value

[Dantarrix]

Hello OTLanders....

I'm here to ask you a short questions that i think i will have a correct answer until tomorrow...

1. How to add a value to a db table by a script?
db.executeQuery("UPDATE ~ ???

2. How to make that value to decrease while time is passing, only when server is online...

That's all... Thank you...

 

[Milice]

add a value or a column? do add a column you alter the table

ALTER players ADD blah blah blah make a search on mysql.com or something

 

[sn3ejk]

2. How to make that value to decrease while time is passing, only when server is online...

Globalevents.

config =
{
	storageId = 1000
}

function onThink(interval, lastExecution, thinkInterval)
	doSetStorage(config.storageId, math.min(0, getStorage(config.storageId)) + interval)
	return true
end

 

[Dantarrix]

And storage with os.time should work? ://

 

[Milice]

And storage with os.time should work? ://

Ofc it would world