[HELP] All Characters back to level 1

[Miracle`]

Help please.. Anyone have a command that all characters back to level 1? Is that in SQL right? Execute command?

[netHoxInc]

You could use a sql query, yes. Just leave it condition less or check for 'is 1==1'
query will be forced to success and set the level of any char to your needs.

Im not playing arround with SQL much so i dont got the commands in mind, still google will probably first-hit-you up.

[sebariio]

USE CHARACTER_01_DBF;
UPDATE dbo.CHARACTER_TBL SET m_nLevel = 1

[Drabur]

Are you sure you want to set all players to level 1 without reset statpoints etc?

[sebariio]

Originally Posted by Drabur

Are you sure you want to set all players to level 1 without reset statpoints etc?

He wants help to reset level
Anyway a reset with database is a bad idea even if you change the statpoints

[Miracle`]

Oh sorry i forgot to mention to reset also the statpoints

What is the command please. Need your help guys..

[.S0ulSeller]

Originally Posted by Miracle`

Execute command?

Yes.

[cookie69]

Originally Posted by Miracle`

Oh sorry i forgot to mention to reset also the statpoints

What is the command please. Need your help guys..

void CMover::InitLevel( int nJob, LONG nLevel, BOOL bGamma )

[sebariio]

I think the best way could be:
1. check last connexion date with if (lastConnexionDate < theDateYouWantToReset)
2. use InitLevel() but you will have to check if player has unauthorized equipment for a lv1
3. if player has equipment, you'll have to unequip it but it will be a problem if he has inventory full

[cookie69]

Originally Posted by sebariio

I think the best way could be:
1. check last connexion date with if (lastConnexionDate < theDateYouWantToReset)
2. use InitLevel() but you will have to check if player has unauthorized equipment for a lv1
3. if player has equipment, you'll have to unequip it but it will be a problem if he has inventory full

well, he didn't clarify what he is doing and what he wants clearly..if it is a wipe out then I guess he needs to put all chars level 1 and destroy every equipment (wipe the inventories, emails,banks...)