[LUA] Change level of a player in a script....

[Dantarrix]

Well, i need that, in a script, change the level of a player...
For example:
From 50 to 25.....
I think the only way is executing this:

db.executeQuery("UPDATE 'players' SET 'level'= 25 WHERE 'id'=x;")

I dont know what i neet to put on x.....
How i get the player's id in db in lua....??

 

[Cykotitan]

wont work if hes online, better use doPlayerAddLevel

Otherwise, getPlayerGUID(cid)

 

[Dantarrix]

doPlayerAddLevel(cid, -25)???

 

[owned]

also, if your using that and updating the database with only the level, its probably not going to change the players hp and mana to how it should be.

 

[Bogart]

also, if your using that and updating the database with only the level, its probably not going to change the players hp and mana to how it should be.

this.
and IIRC doPlayerAddLevel(cid, -25) won't work, although you can use doPlayerAddExperience(cid, (getExperienceForLevel(25) - getPlayerExperience(cid))) but the player has to heal/drink a potion to get normal hp.
I.E. if a player 30 logs and you make him get lvl 25 by this script, he will have the same hp and mana of a level 30 unless he heals/drinks a potion.

 

[Kekox]

Try:

doPlayerAddLevel(25-getPlayerLevel(cid))

or as bogart said:

doPlayerAddExperience(cid, getExperienceForLevel(25) - getPlayerExperience(cid))

 

[Znote]

Just take the level mana/hp calculations from my script from my Quest OTs project:
http://otland.net/f251/help-me-suggestions-my-quest-ots-110025/#post1096376