How to reset an ot?

[SpekkarN]

Hello i got a ot but i wounder how to reset an hole ot? So no owners for houses etc? To remove all players its just to remove database i think but an hole ot?

 

[Pitch]

Extract the ot u had before host it

 

[RealSoft]

in database

 

[SpekkarN]

Extract the ot u had before host it

I have updated the map when server has been running with players.

 

[W33dRoCks]

@SpekkarN
If your want make reset accounts, first stop ots, next going to database and delete it and again import databases....
i recommend after you reset the accounts, make a one copy from database when your configured all and next reset only you will make (DELETE) and (IMPORT) the database and only will make one reset in 10 secS? hehe

 

[Pitch]

or extract and put the updated map in the new folder how hard is it

 

[Waller]

Easiest way is the databas

 

[Fragdonut]

Could anyone give me some sql queries?
Make all players exp 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

 

[nclx]

"Can someone give me c++ and C and delphi and.............................. Code to reset ot please?... why should I make it easy if I can go the hardest way, right?...". -.-

go delete all the DB and make a new one -_-

Btw, If you don't know how to delete the database, and you can't figure that out by yourself, I recommend you to instantly delete your server folder and quit from any OT related comunity.

 

[Cykotitan]

Could anyone give me some sql queries?
Make all players exp 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;

 

[Ldrozd]

or just delete all account without account manager and samples(if you have them)

DELETE FROM `accounts` WHERE `id`!=1;