Help with rebirth system

[Xerath]

using this rebirth system in tfs 0.4 8.6, no errors in distro everythings works other then the level reset i stay the same level?

local config = {
    price = 0, -- Price of first rebirth
    priceIncrease = 0, -- Works as 'price' + current rebirths * priceIncrease.
    rebirthLevel = 717, -- Level for first rebirth.
    rebirthIncrease = 0, -- Works as 'rebirthLevel' + current rebirths * rebirthIncrease.
    maxRebirths = 1000, -- Number of times a player can rebirth.
    level = 8, -- The level the player is set to apon rebirth.
    healthPercent = 1.00, -- 1.00 = 100%.
    health = 100, -- Only used if 'healthPercent' = 0.
    manaPercent = 1.00, -- 1.00 = 100%.
    mana = 100, -- Only used if 'manaPercent' = 0.
    keepSkills = true, -- Wether players keep skills and level apon rebirth.
    skillLevel = 10, -- Only used if 'keepSkills' = false.
    magicLevel = 0, -- Only used if 'keepSkills' = false.
    capacity = 10000, -- The capacity players are set to apon rebirth.
    templePos = {x = 1000, y = 1000, z = 7}, -- The place where players reset to should there town id return 0.
    Rebirth = 1 -- how many Rebirth player will get.
}
local focuses = {}
local function isFocused(cid)
    for i, v in pairs(focuses) do
        if(v == cid) then
            return true
        end
    end
    return false
end
local function addFocus(cid)
    if(not isFocused(cid)) then
        table.insert(focuses, cid)
    end
end
local function removeFocus(cid)
    for i, v in pairs(focuses) do
        if(v == cid) then
            table.remove(focuses, i)
            break
        end
    end
end
local function lookAtFocus()
    for i, v in pairs(focuses) do
        if(isPlayer(v)) then
            doNpcSetCreatureFocus(v)
            return
        end
    end
    doNpcSetCreatureFocus(0)
end
function onCreatureDisappear(cid)
    if(isFocused(cid)) then
        selfSay("Goodbye.")
        removeFocus(cid)
    end
end

  
function onCreatureSay(cid, type, msg)
    if((msg == "hi") and not (isFocused(cid))) then
        selfSay("Welcome, ".. getCreatureName(cid) ..".", cid, true)
        selfSay("Im in charge of the {Rebirth} system.", cid)
        addFocus(cid)
        status = 1
    elseif((isFocused(cid)) and (msg == "rebirth")  or (msg == "Rebirth") or (msg == "reb")  and (status == 1)) then
              if(isInArray({1,2,3,4,5, 6, 7, 8,9,10,11,12}, getPlayerVocation(cid))) then
        if (getPlayerRebirth(cid, config.Rebirth) < config.maxRebirths) then
            Rebirth = getPlayerRebirth(cid, config.Rebirth)
            rebirthLevel = config.rebirthLevel + (config.rebirthIncrease * Rebirth)
            if (getPlayerLevel(cid) >= rebirthLevel) then
                money = config.price + (config.priceIncrease * Rebirth)
                if (getPlayerMoney(cid) >= money) then
                    selfSay("Once you rebirth you will have to level up again from the beginning! Are you sure you still want to rebirth?", cid)
                    status = 2
                else
                    selfSay("You need at least " .. money .. " gold before you can rebirth.", cid)
                    status = 1
                end
                else
                    selfSay("You need to be at least level " .. rebirthLevel .. " before you can rebirth.", cid)
                status = 1
                end
            else
            selfSay("It seems you can not rebirth anymore you are max rebirth .", cid)
            status = 1
            end
        else
            selfSay("Please talk with Zarzor King and promote first.", cid)
             status = 1
        end
    elseif((isFocused(cid)) and (msg == "yes") and (status == 2)) then
        selfSay("Ok then i will rebirth you.", cid)
        selfSay("You will now be logged out.", cid)
        doPlayerRemoveMoney(cid, money)
        addEvent(doRebirthPlayer, 0, {cid=cid})
        removeFocus(cid)
    elseif((isFocused(cid)) and (msg == "no") and (status == 2)) then
        selfSay("Maybe one day you will wise up and change your mind!", cid)
        status = 1
    elseif((isFocused(cid)) and (msg == "bye" or msg == "goodbye" or msg == "cya")) then
        selfSay("Goodbye!", cid, true)
        removeFocus(cid)
    end
end
function onPlayerCloseChannel(cid)
    if(isFocused(cid)) then
        selfSay("Goodbye.")
        removeFocus(cid)
    end
end
function onThink()
    for i, focus in pairs(focuses) do
        if(not isCreature(focus)) then
            removeFocus(focus)
        else
            local distance = getDistanceTo(focus) or -1
            if((distance > 4) or (distance == -1)) then
                selfSay("Goodbye.")
                removeFocus(focus)
            end
        end
    end
    lookAtFocus()
end
function doRebirthPlayer(cid)
    cid = cid.cid
    if (cid == nil) then
        return true
    end
    local guid = getPlayerGUID(cid)
    if (config.healthPercent > 0) then
        health = getCreatureMaxHealth(cid) * config.healthPercent
    else
        health = config.health
    end
    if (config.manaPercent > 0) then
        mana = getCreatureMaxMana(cid) * config.manaPercent
    else
        mana = config.mana
    end
    if (getPlayerTown(cid) > 0) then
        pos = getTownTemplePosition(getPlayerTown(cid))
    else
        pos = config.templePos
end
    doAddRebirth(cid, config.Rebirth, getPlayerRebirth(cid, config.Rebirth) + 1)

    doRemoveCreature(cid, true)
    db.escapeString("UPDATE `players` SET level = " .. config.level .. " WHERE id = " .. guid .. ";")
    db.escapeString("UPDATE `players` SET health = " .. health .. " WHERE id = " .. guid .. ";")
    db.escapeString("UPDATE `players` SET healthmax = " .. health .. " WHERE id = " .. guid .. ";")
    db.escapeString("UPDATE `players` SET mana = " .. mana .. " WHERE id = " .. guid .. ";")
    db.escapeString("UPDATE `players` SET manamax = " .. mana .. " WHERE id = " .. guid .. ";")
    db.escapeString("UPDATE `players` SET posx = " .. pos.x .. " WHERE id = " .. guid .. ";")
    db.escapeString("UPDATE `players` SET posy = " .. pos.y .. " WHERE id = " .. guid .. ";")
    db.escapeString("UPDATE `players` SET posz = " .. pos.z .. " WHERE id = " .. guid .. ";")
    db.escapeString("UPDATE `players` SET cap = " .. config.capacity .. " WHERE id = " .. guid .. ";")

    if (not config.keepSkills) then
        db.escapeString("UPDATE `players` SET maglevel = " .. config.magicLevel .. " WHERE id = " .. guid .. ";")
        db.escapeString("UPDATE `player_skills` SET value = " .. config.skillLevel .. " WHERE id = " .. guid .. ";")
    end
    return true
end

anyone know what's wrong?

 

[Xikini]

It doesn't appear to be editing the experience of your character, only the level.
I suspect it reduces your level, then the system adds the level back upon login, as the experience your character has is indicating level XXX.

try adding this in

db.escapeString("UPDATE `players` SET experience = 4200 WHERE id = " .. guid .. ";")

4200 = experience for level 8.

 

[slavi]

Isn't `escapeString` to escape a string ? Why you use it as execute/asnyc query?

 

[Xerath]

db.escapeString doesn't give errors,
db.execute does

 

[slavi]

i didn't it's the function itself.

But escapeString isn't the right one. It maybe executeQuery asyncQuery storeQuery

check your combat.lua

 

[Infernum]

It should be db.query