Lua How to Reset MagicLevel and Skills?

[mezuf98]

Need to set player magiclevel to 0 and skills to 10.

I tried something like this setBaseMagicLevel(0) and other things but nothing... Someone can healp me?

Thanks!

 

[Zothion]

change them in the database?

 

[mezuf98]

change them in the database?

But i need to do that in game like a talkaction: !reset, and that will set the player magic level 0 and skills 10... Because i have a skill points system and need to insert it ^^, thanks anyway...

 

[Il Knight]

Use sql Query.

 

[Zothion]

make the talkaction kick the player and query database to reset
afaik there is no way to remove skills from a player ingame
there is player:addSkillTries(), but if you try to add a negative value it seems like it internprets it like an overflow (e.g -1 tries for SKILL_CLUB got me form 10->67 axe on a sorc )

 

[mezuf98]

make the talkaction kick the player and query database to reset
afaik there is no way to remove skills from a player ingame
there is player:addSkillTries(), but if you try to add a negative value it seems like it internprets it like an overflow (e.g -1 tries for SKILL_CLUB got me form 10->67 axe on a sorc )

Hmm, ok i will try this thank you

 

[mezuf98]

It is more complicated than I expected :O
someone can give me a example how to query database ?

 

[Il Knight]

https://otland.net/threads/mysql-how-to-run-a-query.177833/

 

[Il Knight]

mm i think you can use this

//Players
UPDATE players SET level = 1, experience = 0, maglevel = 0, health = 150, healthmax = 150, mana = 0, manamax = 0, manaspent = 0, redskulltime = 0, soul = 100, town_id = 0, cap = 400, vocation = 0, posx = 32097, posy = 32219, posz = 7, lastlogin = 0, lastlogout = 0, lastip = 0, rank_id = 0, guildnick = '', bless1 = 0, bless2 = 0, bless3 = 0, bless4 = 0, bless5 = 0, bank_balance = 0;

//Skills
UPDATE player_skills SET value = 10, count = 0 WHERE skillid = 0;
UPDATE player_skills SET value = 10, count = 0 WHERE skillid = 1;
UPDATE player_skills SET value = 10, count = 0 WHERE skillid = 2;
UPDATE player_skills SET value = 10, count = 0 WHERE skillid = 3;
UPDATE player_skills SET value = 10, count = 0 WHERE skillid = 4;
UPDATE player_skills SET value = 10, count = 0 WHERE skillid = 5;
UPDATE player_skills SET value = 10, count = 0 WHERE skillid = 6;

 

[mezuf98]

mm i think you can use this

//Players
UPDATE players SET level = 1, experience = 0, maglevel = 0, health = 150, healthmax = 150, mana = 0, manamax = 0, manaspent = 0, redskulltime = 0, soul = 100, town_id = 0, cap = 400, vocation = 0, posx = 32097, posy = 32219, posz = 7, lastlogin = 0, lastlogout = 0, lastip = 0, rank_id = 0, guildnick = '', bless1 = 0, bless2 = 0, bless3 = 0, bless4 = 0, bless5 = 0, bank_balance = 0;

//Skills
UPDATE player_skills SET value = 10, count = 0 WHERE skillid = 0;
UPDATE player_skills SET value = 10, count = 0 WHERE skillid = 1;
UPDATE player_skills SET value = 10, count = 0 WHERE skillid = 2;
UPDATE player_skills SET value = 10, count = 0 WHERE skillid = 3;
UPDATE player_skills SET value = 10, count = 0 WHERE skillid = 4;
UPDATE player_skills SET value = 10, count = 0 WHERE skillid = 5;
UPDATE player_skills SET value = 10, count = 0 WHERE skillid = 6;

Dosn't work, but thanks i trying a lot here