Solved !rebirth error

[GoalTV]

Hello.

I have problem with my Talkactions on rebirth system its works and give rebirth but level is same like before 717171 its same after rebirth for some reason level don't get restart this is my talkactions

local level = 717171 -- the min level
function onSay(cid, words, param, channel)
if(getPlayerLevel(cid) >= level) then
doCreatureSetStorage(cid, 85987, getCreatureStorage(cid, 85987) == -1 and 1 or getCreatureStorage(cid, 85987) + 1)
doRemoveCreature(cid)
db.executeQuery("UPDATE `players` SET `level` = 8, `experience` = 4200, `healthmax` = 2000, `manamax` = 2000, `promotion` = 0 WHERE `id` ='"..id.."';")
db.executeQuery("UPDATE `players` SET `name` = '"..getCreatureName(cid).."' WHERE `id` ='"..getPlayerGUID(cid).."';")
else
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_RED, "You need level " .. level .. ".")
end
return true
end

Best Regards
mlody.1039

 

[Ninja]

local level = 717171 -- the min level
function onSay(cid, words, param, channel)
    if(getPlayerLevel(cid) >= level) then
        doCreatureSetStorage(cid, 85987, getCreatureStorage(cid, 85987) == -1 and 1 or getCreatureStorage(cid, 85987) + 1)
        doRemoveCreature(cid)
        db.executeQuery("UPDATE `players` SET `level` = 8, `experience` = 4200, `healthmax` = 2000, `manamax` = 2000, `promotion` = 0 WHERE `id` = " .. getPlayerGUID(cid))
        db.executeQuery("UPDATE `players` SET `name` = '"..getCreatureName(cid).."' WHERE `id` = " .. getPlayerGUID(cid))
    else
        doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_RED, "You need level " .. level .. ".")
    end
    return true
end

 

[GoalTV]

Hello.

Still level is same...

thanks for help


Best Regards
mlody.1039

 

[GoalTV]

and this error come up in engine

[Error - TalkAction Interface]
data/talkactions/scripts/rebirth.lua:onSay
Description:
(internalGetPlayerInfo) Player not found when requesting player info #18

[Error - TalkAction Interface]
data/talkactions/scripts/rebirth.lua:onSay
Description:
data/talkactions/scripts/rebirth.lua:6: attempt to concatenate a boolean value
stack traceback:
        data/talkactions/scripts/rebirth.lua:6: in function <data/talkactions/scripts/rebirth.lua:2>

 

[Summ]

I am not sure why you wanted to set the players name to the players name, so I removed that part too.

local level = 717171 -- the min level
function onSay(cid, words, param, channel)
    if(getPlayerLevel(cid) >= level) then
        local guid = getPlayerGUID(cid)
        doCreatureSetStorage(cid, 85987, getCreatureStorage(cid, 85987) == -1 and 1 or getCreatureStorage(cid, 85987) + 1)
        doRemoveCreature(cid)
        db.executeQuery("UPDATE `players` SET `level` = 8, `experience` = 4200, `healthmax` = 2000, `manamax` = 2000, `promotion` = 0 WHERE `id` = " .. guid)
    else
        doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_RED, "You need level " .. level .. ".")
    end
    return true
end

 

[GoalTV]

Thank you its works !!!
Rep+ for you

=update=
how to add rep in this new forum?

Best Regards
mlody.1039

 

[Summ]

You can only "Like" posts.

 

[GoalTV]

Oh that what I hate in this new forum actually I hate everything in this new forum I hope old forum will be back with vbullien

thank you again for your help I will try make this !rebirth for mysql now

best regards
mlody.1039