Talkaction /update [solved]

[LucasFerraz]

I need a talkaction /update.

It will teleport all players online/offline to temple.
(It will not teleport players in accountid 1)

 

[Ratser]

In talkactions.xml:

	<talkaction log="yes" words="/update" access="5" event="buffer" value="townId = 1	t = getTownTemplePosition(townId)	db.query('UPDATE `players` SET `posx` = ' .. t.x .. ', `posy` = ' .. t.y .. ', `posz` = ' .. t.z .. ' WHERE `account_id` > 1;')	for _, pid in pairs(getPlayersOnline()) do	doTeleportThing(pid, getTownTemplePosition(townId))	end"/>

That's it.

 

[LucasFerraz]

Do not work.
Is possible using script?

 

[Ratser]

What error did it show up?

It's really the same thing... :/

function onSay(cid, words, param, channel)
	local townId = 1
	local t = getTownTemplePosition(townId)
	db.query('UPDATE `players` SET `posx` = ' .. t.x .. ', `posy` = ' .. t.y .. ', `posz` = ' .. t.z .. ' WHERE `id` > 1;')
	for _, pid in pairs(getPlayersOnline()) do
		doTeleportThing(pid, getTownTemplePosition(townId))
	end

	return true
end

 

[LucasFerraz]

What error did it show up?

It's really the same thing... :/

function onSay(cid, words, param, channel)
	local townId = 1
	local t = getTownTemplePosition(townId)
	db.query('UPDATE `players` SET `posx` = ' .. t.x .. ', `posy` = ' .. t.y .. ', `posz` = ' .. t.z .. ' WHERE `id` > 1;')
	for _, pid in pairs(getPlayersOnline()) do
		doTeleportThing(pid, getTownTemplePosition(townId))
	end

	return true
end

1. Is it teleporting only if AccountId >= 2?

 

[Ratser]

Wait...accountId or playerId?

WHERE `id` > 1;'

^This is only sending players with playerId > 1 to the temple.

 

[LucasFerraz]

IF accountId >= 2 then GO TO TEMPLE
If accountId < 2 then NOTHING HAPPENS

 

[Ratser]

function onSay(cid, words, param, channel)
	local townId = 1
	local t = getTownTemplePosition(townId)
	db.query('UPDATE `players` SET `posx` = ' .. t.x .. ', `posy` = ' .. t.y .. ', `posz` = ' .. t.z .. ' WHERE `account_id` > 1;')
	for _, pid in pairs(getPlayersOnline()) do
		doTeleportThing(pid, getTownTemplePosition(townId))
	end

	return true
end

 

[LucasFerraz]

Will it teleport offline players too?

 

[Ratser]

That's what the query does. If any offline player logs in after executing /update he will appear on the temple.

 

[LucasFerraz]

Thank you

 

[Fresh]

It gives me ideas to make maps update without ot restart.

 

[LucasFerraz]

Lol. How?

 

[GhostX]

Well there is /reload scripts, so it should be possible to code a /reload map. And that tps all players to temple, or kicks players then tp them. Or "gameworld is currently under maintenence" And then can update it through a command. It is possible.. Althought may crash the server is too much changes idk TRY IT

 

[LucasFerraz]

Nice