Is it possible to reduce magic level or skills?

[ligus]

Hello, does anyone know how can be done something like this:
When player die then return his magic level and skills to any special value?
I tried with:

doPlayerAddMagLevel(cid, -(maglevel-60))

and:

doPlayerAddSkill(cid, SKILL__MAGLEVEL,-(maglevel-60), true)

but it does not work

 

[nclx]

Just change it directly with DB calls

 

[ligus]

Umm.. I want to make something like this: player starts with 20 magic level and when he die then his mlvl returns to 20. Is it possible to not save mlvl to database? In this way there will be always 20 mlvl

 

[Limos]

You can add a query in a death/preparedeath script and in a logout script that sets ml to 20, then in login.lua also if ml is higher then 20 with doRemoveCreature(cid) incase people xlog.

 

[ligus]

What query?

 

[Limos]

db.query("UPDATE `players` SET `maglevel` = 20 WHERE `id` = " .. getPlayerGUID(cid))

 

[ligus]

Hmm, it does not work for me:/

I have in creaturescripts.xml:

<event type="death" name="reduceDeath" script="reduceDeath.lua"/>
<event type="logout" name="reduceLog" script="reduceLog.lua"/>

login.lua:

registerCreatureEvent(cid, "reduceDeath")
registerCreatureEvent(cid, "reduceLog")

and scripts:

function onLogout(cid)
    db.executeQuery("UPDATE `players` SET `maglevel` = 20 WHERE `id` = " .. getPlayerGUID(cid))
    return true
end

function onDeath(cid)
    db.executeQuery("UPDATE `players` SET `maglevel` = 20 WHERE `id` = " .. getPlayerGUID(cid))
    return true
end

What's wrong?

 

[Limos]

Add them with addEvent and set time to 1.
In login.lua the addEvent isn't needed, only the doRemoveCreature(cid) above the query, because the player has to be offline when it runs the query.

 

[ligus]

Trying to do it:

local function reducemlvl(cid)
        db.executeQuery("UPDATE `players` SET `maglevel` = 20 WHERE `id` = " .. getPlayerGUID(cid))
    return TRUE
end 

function onLogout(cid)
    addEvent(reducemlvl, 1, cid)
    return true
end

There is error:

Player not found when requesting player info #6

What's wrong here?

 

[Limos]

function onLogout(cid)
   addEvent(db.executeQuery, 1, "UPDATE `players` SET `maglevel` = 20 WHERE `id` = " .. getPlayerGUID(cid))
   return true
end