[HELP] All Characters back to level 1

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

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.

USE CHARACTER_01_DBF;
UPDATE dbo.CHARACTER_TBL SET m_nLevel = 1

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

Quote:

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

Oh sorry i forgot to mention to reset also the statpoints :o

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

[Only registered and activated users can see links. Click Here To Register...]

Quote:

Originally Posted by Miracle` Execute command?

Yes.

Quote:

Originally Posted by Miracle` Oh sorry i forgot to mention to reset also the statpoints :o What is the command please. Need your help guys..

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

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

Quote:

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...)