Lua HELP Script for back minimal level tfs 0.3.6

[Provanya]

I wanna make war ots. So i need minimal level. And i make script. When some one die he take back level, health, mana, and cap. But they don't work.

Creaturescripts.xml

<event type="think" name="LevelUp" event="script" value="setlevel.lua"/>

login.lua

registerCreatureEvent(cid, "LevelUp")

and that code not work need help

function onThink(cid, interval)
if(getPlayerLevel(cid) < 50) then
local name = getCreatureName(cid)
doRemoveCreature(cid)
db.executeQuery("UPDATE players SET level = 50 WHERE name ='"..name.."';")
if isSorcerer(cid) or isDruid(cid) then db.executeQuery("UPDATE players SET health = 395 WHERE name ='"..name.."';")
db.executeQuery("UPDATE players SET healthmax = 395 WHERE name ='"..name.."';")
db.executeQuery("UPDATE players SET mana = 1300 WHERE name ='"..name.."';")
db.executeQuery("UPDATE players SET manamax = 1300 WHERE name ='"..name.."';")
db.executeQuery("UPDATE players SET cap = 890 WHERE name ='"..name.."';") else
if isPaladin(cid) then db.executeQuery("UPDATE players SET health = 605 WHERE name ='"..name.."';")
db.executeQuery("UPDATE players SET healthmax = 605 WHERE name ='"..name.."';")
db.executeQuery("UPDATE players SET mana = 670 WHERE name ='"..name.."';")
db.executeQuery("UPDATE players SET manamax = 670 WHERE name ='"..name.."';")
db.executeQuery("UPDATE players SET cap = 1310 WHERE name ='"..name.."';") else
("UPDATE players SET health = 815 WHERE name ='"..name.."';")
db.executeQuery("UPDATE players SET healthmax = 815 WHERE name ='"..name.."';")
db.executeQuery("UPDATE players SET mana = 250 WHERE name ='"..name.."';")
db.executeQuery("UPDATE players SET manamax = 250 WHERE name ='"..name.."';")
db.executeQuery("UPDATE players SET cap = 1520 WHERE name ='"..name.."';")


else
end
return TRUE
end

I am new and i don't know how make right that script need help

 

[WibbenZ]

You should be able to just add the player level, doPlayerAddLevel(cid, x)?
So something like this:

doPlayerAddLevel(cid, 50 - getPlayerLevel(cid))
doPlayerSave(cid)

 

[Provanya]

You should be able to just add the player level, doPlayerAddLevel(cid, x)?
So something like this:

doPlayerAddLevel(cid, 50 - getPlayerLevel(cid))
doPlayerSave(cid)

how i must write that new comand?

function onThink(cid, interval)
if(getPlayerLevel(cid) < 50) then
local name = getCreatureName(cid)
doRemoveCreature(cid)
doPlayerAddLevel(cid, 50 - getPlayerLevel(cid))
doPlayerSave(cid)

else
end
return TRUE
end

not work

 

[WibbenZ]

how i must write that new comand?


not work

if(getPlayerLevel(cid) < 50) then
    doPlayerAddLevel(cid, 50 - getPlayerLevel(cid))
    doPlayerSave(cid)
end

How ever you should use an onLogin or onAdvance script insted.