[REQUEST] Set Offline Player Pos

[Grehy]

A command to set an offline player's position to yours, or another pos doesn't matter;

/respawn Dan

And when he logs on his position will be where you used the command

 

[Cykotitan]

function onSay(cid, words, param)
	if(not(isPlayer(getPlayerByName(param)))) then
		local pos = getCreaturePosition(cid)
		return db.executeQuery("UPDATE `players` SET `posx` = ".. pos.x ..", `posy` = ".. pos.y ..", `posz` = ".. pos.z .." WHERE `name` = '".. escapeString(param) .."';")
	else
		return doPlayerSendCancel("The player needs to be offline.")
	end
end

 

[Grehy]

[31/12/2009 18:10:29] data/talkactions/scripts/reset.lua:4: attempt to call global 'escapeString' (a nil value)
[31/12/2009 18:10:29] stack traceback:
[31/12/2009 18:10:29] data/talkactions/scripts/reset.lua:4: in function <data/talkactions/scripts/reset.lua:1>

 

[JDB]

Replace

return db.executeQuery("UPDATE `players` SET `posx` = ".. pos.x ..", `posy` = ".. pos.y ..", `posz` = ".. pos.z .." WHERE `name` = '".. db.escapeString(param) .."';")

 

[Rozinx]

Or set everyone's pos to 0 via DB.
Way easier, if you're having trouble

 

[Grehy]

Replace

return db.executeQuery("UPDATE `players` SET `posx` = ".. pos.x ..", `posy` = ".. pos.y ..", `posz` = ".. pos.z .." WHERE `name` = '".. db.escapeString(param) .."';")

[01/01/2010 01:00:41] mysql_real_query(): UPDATE `players` SET `posx` = 1051, `posy` = 1011, `posz` = 7 WHERE `name` = ''Darkalsmith''; - MYSQL ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Darkalsmith''' at line 1 (1064)