Update Player Pos - Help

[Meferot]

I have problem whit this script:

function onThink(cid, interval, lastExecution)

local pos = getCreaturePosition(cid)

db.executeQuery("UPDATE `players` SET `posx` = '".. pos.x .."', `posy` = '".. pos.y .."' WHERE `name` = '".. getCreatureName(cid) .."' LIMIT 1;")

return TRUE
end

This is error:

[Error - GlobalEvent Interface]
data/globalevents/scripts/pos.luanThink
Description:
(luaGetThingPosition) Thing not found

[Error - GlobalEvent Interface]
data/globalevents/scripts/pos.luanThink
Description:
data/globalevents/scripts/pos.lua:5: attempt to index local 'pos' (a boolean val
ue)
stack traceback:
data/globalevents/scripts/pos.lua:5: in function <data/globalevents/scri
pts/pos.lua:1>
[Error - GlobalEvents::think] Couldn't execute event: pos

How to fix it?

 

[Serginov]

Why do you need that? The position of a player updates in the database when the server saves or the player logout.

 

[Jano]

globalevents and cid ?_?

 

[FeragonOnline]

i use this tfs 0.3.6
Go to data/globalevents/start.lua and delete all in it.
Then paste this:

function onStartup()
db.executeQuery("UPDATE `players` SET `online` = 0 WHERE `world_id` = " .. getConfigValue('worldId') .. ";")
db.executeQuery("UPDATE players SET posx = 32369, posy = 32241, posz = 7;")
return TRUE
end

 

[Meferot]

Why do you need that? The position of a player updates in the database when the server saves or the player logout.

Thanks for help but i founded other method. Why i need it? Look: Norah - Who is online?
90% done.