Windows Everyone to level 1

[darkazey]

HI,

I was wondering.

Alot of people on my server got donates and I would like to do something that everyone returns to level 8 but they keep their donates. Is that possible? and how? please i rep!

 

[Vee]

Yes, it is just run some queries that'll reset their level, magic level, addons etc

 

[darkazey]

Can you tell me?

 

[Vightrain]

UPDATE `players` SET level = 1

 

[darkazey]

is there a command to make everyone to druid?

 

[bolero]

...

UPDATE `players` SET level = 1 WHERE vocation = 2;

 

[Vightrain]

is there a command to make everyone to druid?

UPDATE `players` SET vocation = 2;

 

[darkazey]

Thanks alot! i got one more question! i just used a wrong command is it possible to rerole back?

 

[gilbert123]

No there isnt

 

[Vightrain]

Thanks alot! i got one more question! i just used a wrong command is it possible to rerole back?

:/ no

 

[Vee]

You shouldn't run that one query that was given...as health/mana will remain whatever it was!
You must run a query like this:

For sorcerer:
UPDATE `players` SET level="8", health_now="185", health_max="185", mana_now="35", mana_max="35" WHERE vocation="1"

Note that this is just an example, I don't know the actual table names etc.