All downgrade to level 8 !

[dianagirl]

Hello guys,
anyone know the Command how to downgrade in phpmyadmin everyone to level 8 ?

Not a character reset,just that everyone get level 8.
And not a item reset or smth xD


Thanks alot
repp++

 

[Amiroslo]

UPDATE players SET level = 8

 

[Ped0bear]

UPDATE players SET level = 8

Update experience aswell lol or would be bugged

 

[Amiroslo]

All player exp are 4200 and level 8
Take away all storagevalues from players
Reset skills to 10
Take away all items from all characters.
Empty all houses and set them to owner Nobody

UPDATE `players` SET `level` = 8, `experience` = 4200, `health` = 185, `healthmax` = 185, `maglevel` = 0, `mana` = 35, `manamax` = 35, `manaspent` = 0, `soul` = 100, `cap` = 470, `skull` = 0, `skulltime` = 0, `blessings` = 0, `stamina` = 151200000, `online` = 0, `promotion` = 0;
DELETE FROM `player_storage`, `player_items`, `player_depotitems`, `tile_items`, `house_lists`, `house_data`, `house_auctions`, `houses`;
UPDATE `player_skills` SET `value` = 10, `count` = 0;

without Take away all items from all characters.
Empty all houses and set them to owner Nobody

UPDATE `players` SET `level` = 8, `experience` = 4200, `health` = 185, `healthmax` = 185, `maglevel` = 0, `mana` = 35, `manamax` = 35, `manaspent` = 0, `soul` = 100, `cap` = 470, `skull` = 0, `skulltime` = 0, `blessings` = 0, `stamina` = 151200000, `online` = 0, `promotion` = 0;

use this

Update experience aswell lol or would be bugged

Fixed

 

[dianagirl]

thaanks Amirsolo
I already gave u a rep++

 

[Pakojerte]

Where should i put this code?

 

[ghettobird]

Where should i put this code?

phpmyadmin --> yourdatabase(whatever you named it) --> SQL

 

[Pakojerte]

phpmyadmin --> yourdatabase(whatever you named it) --> SQL

Tks bRO!

 

[Owner Maydel]

I Can USe It TO War Ots Its Can Got Again LEvel 300 Back and Skills Or Its WIll Bugged?