Solved Help with db.query

[Zoe Skandinavia]

Hi, im trying to make a script that do reset the player saying a command but when i reach the level required, don't works. This is the code:

function onSay(cid, words, param)
    local player = Player(cid)
    local level = getPlayerLevel(cid)
    local pid = getPlayerGUID(cid)
    local resets = db.storeQuery("SELECT `resets` FROM `players` WHERE `id` = "..pid.." LIMIT 1")
    local value = tonumber(result.getDataInt(result_resets, "resets"))
    local newlevel = 8
if (level >= 100 and level <= 2999) and (value == 0) then
    doRemoveCreature(cid)
    db.query("UPDATE 'players' SET 'resets' = 1 WHERE `id` = "..pid.." LIMIT 1")
    db.query("UPDATE `players` SET `health` = 800, `healthmax` = 800, `level` = "..newlevel..", `experience` = 0, `maglevel` = 20, `mana` = 400, `manamax` = 400, `cap` = 500, `soul` = 200, `posx` = 32369, `posy` = 32241, `posz` = 7, `skull` = 0, `skulltime` = 0 WHERE `id` = "..pid.." LIMIT 1")
elseif (level >= 3000 and level <= 3999) and (value == 1)then
        doRemoveCreature(cid)
        db.query("UPDATE 'players' SET 'resets' = 2 WHERE `id` = "..pid.." LIMIT 1")
        db.query("UPDATE `players` SET `health` = 1000, `healthmax` = 1000, `level` = "..newlevel..", `experience` = 0, `maglevel` = 22, `mana` = 600, `manamax` = 600, `cap` = 550, `soul` = 220, `posx` = 32369, `posy` = 32241, `posz` = 7, `skull` = 0, `skulltime` = 0 WHERE `id` = "..pid.." LIMIT 1")
elseif (level >= 4000 and level <= 4999) and (value == 2) then
        doRemoveCreature(cid)
        db.query("UPDATE 'players' SET 'resets' = 3 WHERE `id` = "..pid.." LIMIT 1")
        db.query("UPDATE `players` SET `health` = 1200, `healthmax` = 1200, `level` = "..newlevel..", `experience` = 0, `maglevel` = 25, `mana` = 800, `manamax` = 800, `cap` = 600, `soul` = 240, `posx` = 32369, `posy` = 32241, `posz` = 7, `skull` = 0, `skulltime` = 0 WHERE `id` = "..pid.." LIMIT 1")
elseif (level >= 5000 and level <= 5999) and (value == 3) then
        doRemoveCreature(cid)
        db.query("UPDATE 'players' SET 'resets' = 4 WHERE `id` = "..pid.." LIMIT 1")
        db.query("UPDATE `players` SET `health` = 1500, `healthmax` = 1500, `level` = "..newlevel..", `experience` = 0, `maglevel` = 30, `mana` = 1200, `manamax` = 1200, `cap` = 700, `soul` = 300, `posx` = 32369, `posy` = 32241, `posz` = 7, `skull` = 0, `skulltime` = 0 WHERE `id` = "..pid.." LIMIT 1")
else
        player:popupFYI("You can't make a update to your player. Level too low.")
end

end

Please help, thanks

 

[Zoe Skandinavia]

Solved.