[SQL] Reset Account without deleting accounts.

[Ancore]

I want to do the following:

When I say there will be an Account Reset, just downgrade all the players to level 8 and every skill to 10 and stamina refill, obviously deleting the storages, items, house tiles, etc...
Reset all the things that an Account Reset resets but not the Accounts, Characters.


I just know it is possible to do by using sql queries... but can't figure out how to do it and didn't find anything on the search (google and otland), that is why I come here to ask some help.
Thanks!

 

[averatec]

update players set level=8, health=420, healthmax=420, mana=35, manamax=35, manaspent=0, maglevel= 0, stamina=151200000, cap=470, balance=0, promotion=0;
update player_skills set value=10, count=0;
truncate player_items;
truncate player_depotitems;
truncate player_storage;
truncate houses;
truncate tiles;
truncate tile_items;
truncate house_data;

 

[Ancore]

Thanks Averatec!

 

[martinadicto]

where put it?

 

[Ancore]

Db query

 

[xshaggyx]

I have a error help plz

#1054 - Unknown column 'promotion' in 'field list'

 

[Fluorescente]

I have a error help plz

#1054 - Unknown column 'promotion' in 'field list'

You don´t have the column promotion in players table
promotion = 0 means the character isn´t promoted
promotion = 1 means the character is promoted

Maybe your database have a vocation column which means:
Sorcerer = 1
Druid = 2
Paladin = 3
Knight = 4
Master Sorcerer = 5
Elder Druid = 6
Royal Paladin = 7
Elite Knight = 8

Look if this is correct in otserver-folder\data\XML\vocations.xml

So,
You need a DB query with this logic:
If 5 change to 1
If 6 change to 2
If 7 change to 3
If 8 change to 4