Lua Global event interface [error]

[Glidarn]

SO this is my error

ImageShack® - Online Photo and Video Hosting


Do you know what's wrong?


// Glidarn

 

[Sonical]

db.query("UPDATE `players` SET `online` = 0 WHERE `world_id` = 0;")

or

db.executeQuery("UPDATE `players` SET `online` = 0 WHERE `world_id` = 0;")

Change last 0 to world id of your server, if you've got 1 server it's probably 0

 

[Glidarn]

i used the bottom one and now it says unexpected symbol near '

function onStartup()
	db.executeQuery("UPDATE `players` SET `online` = 0 WHERE `world_id` = 0;") .. getConfigValue('worldId') .. ";")
	return true
end

 

[Sonical]

function onStartup()
	db.executeQuery("UPDATE `players` SET `online` = 0 WHERE `world_id` = 0;")
	return true
end

 

[Glidarn]

no i have the same problem that i had in the beginning :/

 

[Sonical]

Did you tried that one?

function onStartup()
	db.Query("UPDATE players SET online = 0 WHERE world_id = 0;")
	return true
end

 

[Cykotitan]

It's db.query

 

[Glidarn]

Did you tried that one?

function onStartup()
	db.Query("UPDATE players SET online = 0 WHERE world_id = 0;")
	return true
end

ye mate i did, and not i'm back to sqaure one

 

[Sonical]

Btw. you don't need that script

 

[Glidarn]

It's db.query

huh?


at Sonical: huh? I still don't understand why it isnt working lol

 

[Glidarn]

Is it anyone that knows what the problem is? :S

 

[Glidarn]

oh i posted the wrong lua script

this is the one:

function onRecord(current, old, cid)
	db.executeQuery("INSERT INTO `server_record` (`record`, `world_id`, `timestamp`) VALUES (" .. current .. ", " .. getConfigValue('worldId') .. ", " .. os.time() .. ");")
	addEvent(doBroadcastMessage, 150, "New record: " .. current .. " players are logged in.", MESSAGE_STATUS_DEFAULT)
end

 

[president vankk]

function onRecord(current, old, cid)
	db.Query("INSERT INTO `server_record` (`record`, `world_id`, `timestamp`) VALUES (" .. current .. ", " .. getConfigValue('worldId') .. ", " .. os.time() .. ");")
	addEvent(doBroadcastMessage, 150, "New record: " .. current .. " players are logged in.", MESSAGE_STATUS_DEFAULT)
end