Database RESET

[darkazey]

Hi,

I would like to know If there's any command that you can write in database to reset all levels and make all charas to 1000hp and 1000hp and also lvl 8 without losing ur vocation,items?

REP+
Thanks!

 

[Cs Server]

UPDATE `players` SET level=8, hitpoints=1000, manapoints=1000;

Edit:
Change "hitpoints" and "manapoints" to the exact ones that your database have, The code is CASE SENSITIVE! Hitpoints and hitpoints are TWO DIFFERENT words.



Edit2;
This will apply to every single character in your database, including Gms/Admins.

 

[darkazey]

But they will still have the same EXP before reset?

 

[darkazey]

That doesnt work in my database

 

[dereker]

show your player shema

 

[darkazey]

my what? :s BUMP! help please i will rep

I need to make everyone lvl 8 with 1000hp and 1000 mana :/

 

[TibiaGameHost]

all commands phpmyadmin
www.darkot.com/comandos.php

 

[darkazey]

Thanks alot! I rep you!

 

[TibiaGameHost]

Good Luck! '