When i do a big update how can i let all the players to start at temple!

[otaf]

When i do a big update how can i let all the players to start at temple!

 

[chojrak]

UPDATE `players` SET `posx` = 0, `posy` = 0, `posz` = 0;

It will reset positions of all players to 0, server will automatically set it to temple positions while player login.

 

[otaf]

where do i put that?

 

[chojrak]

Are you using phpMyAdmin? If yes paste it in "SQL" tab. If not you have to execute this via php script/lua script.

 

[otaf]

i use sqlitestudio-1.1.3

 

[otaf]

where to download phpMyAdmin

 

[Henkos]

where to download phpMyAdmin

That's like you database for mysql xd

 

[otaf]

hmm i dont understand :/

 

[drax skylon]

When i do a big update how can i let all the players to start at temple!

edit each player in your database and set posx/posy/posz = "0"

after that try to update your server to MySql...it's better and easier

 

[Feragon]

when you open the server the players start in the temple
globalevents/scripts
create file start.lua and put this script

  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

in globalevents.xml put this line

	<globalevent name="serverstart" type="start" event="script" value="start.lua"/>

 

[zakius]

Ok guys, can someone makie it moving each char to his temple, not all to the same? ;d