Windows How to Reset A server

[MxSoft]

Is there a way to reset a server without erasing the accounts?

 

[Onizuka]

go to database, choose db, choose sql tab and type this

TRUNCATE TABLE accounts

and do the same for players

TRUNCATE TABLE players

Np.

 

[MxSoft]

Ty ANco Love U

 

[Onizuka]

dont! lol i was joking. dont use those commands.


Use

UPDATE players set level=8, experience=4200, cap=400, health=185, healthmax=185, mana=35, manamax=35, maglevel=0


and just truncate table items and table items depo, etc..

 

[MxSoft]

lol i use them......

 

[MxSoft]

Is this ok?

Do you really want to :TRUNCATE `auction_system`;
TRUNCATE `bans`;
TRUNCATE `bounty_hunters`;
TRUNCATE `deaths_in_wars`;
TRUNCATE `environment_killers`;
TRUNCATE `global_storage`;
TRUNCATE `guilds`;
TRUNCATE `guild_invites`;
TRUNCATE `guild_ranks`;
TRUNCATE `houses`;
TRUNCATE `house_auctions`;
TRUNCATE `house_data`;
TRUNCATE `house_lists`;
TRUNCATE `killers`;
TRUNCATE `name`;
TRUNCATE `players`;
TRUNCATE `player_deaths`;
TRUNCATE `player_depotitems`;
TRUNCATE `player_items`;
TRUNCATE `player_killers`;
TRUNCATE `player_namelocks`;
TRUNCATE `player_skills`;
TRUNCATE `player_spells`;
TRUNCATE `player_storage`;
TRUNCATE `player_viplist`;

 

[president vankk]

DELETE FROM `players` WHERE `name` NOT IN ('[Admin]','Druid Sample','Sorcerer Sample','Knight Sample','Paladin Sample')

/\ TESTED


\/ NOT TESTED

DELETE FROM `accounts` WHERE `name` NOT IN ('1')

 

[MxSoft]

ty