Solved How to make this sql query..

[Xeo]

EDIT : How to update all players position for those who are 8+ only

 

[Sonical]

In creaturescripts.xml add

	<event type="advance" name="Levelpos" event="script" value="Levelpos.lua"/>

In login.lua add

	registerCreatureEvent(cid, "Levelpos")

In creaturescripts/scripts save this file
Levelpos.lua

--Script by Sonical
local config ={
	level = 8 --Edit how much level
        storage = 22852
}
function onAdvance(cid, skill, oldLevel, newLevel)
queststatus = getPlayerStorageValue(cid,config.storage)
if getPlayerLevel(cid) > config.level and queststatus = -1 then
	db.executeQuery("UPDATE players SET posx = 1025, posy = 1028, posz = 7 WHERE `id` = " .. getPlayerGUID(cid) .. ";")
end
return true
end

 

[hodleo]

UPDATE `players` SET `posx` = 1025, `posy` = 1028, `posz` = 7 WHERE `level` < 8;

 

[Sonical]

My script didn't owrked or what? Errors?

Maybe I understood your request wrong, lawl

UPDATE `players` SET `posx` = 1025, `posy` = 1028, `posz` = 7 WHERE `level` > 8;

 

[hodleo]

EDIT : How to update all players position for those who are 8+ only

>=8

UPDATE `players` SET `posx` = 1025, `posy` = 1028, `posz` = 7 WHERE `level` >= 8;

>8

UPDATE `players` SET `posx` = 1025, `posy` = 1028, `posz` = 7 WHERE `level` > 8;

 

[Xeo]

its ok Rep for you guys,thanks a lot.