• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

[Database] Reset players

Sort by date Sort by votes
Rab said:
Code: 
DELETE FROM players WHERE level < 500000
Click to expand...

This doesn't clean accounts, depot items, house items, player stroages, global stroages, frags etc.

Easiest way can be import orginal tfs database and add all your qustom things to it (custom = war system, vip system things etc.)
 
Upvote 0 Downvote
Your using linux yet you don't know how to use mysql console?

Just google it, you don't have to be an expert to do such things.

What you need to know is how to drop a database, create a new database and re-import plain tfs mysql schema.
 
Upvote 0 Downvote
Sonical said:
This doesn't clean accounts, depot items, house items, player stroages, global stroages, frags etc.

Easiest way can be import orginal tfs database and add all your qustom things to it (custom = war system, vip system things etc.)
Click to expand...

this will delete everything;

Code: 
DELETE FROM `players` WHERE `name` NOT IN ('[Admin]','Druid Sample','Sorcerer Sample','Knight Sample','Paladin Sample')
 
Upvote 0 Downvote
Beon said:
this will delete everything;

Code: 
DELETE FROM `players` WHERE `name` NOT IN ('[Admin]','Druid Sample','Sorcerer Sample','Knight Sample','Paladin Sample')
Click to expand...

Simply DELETE FROM accounts; will do the same (since triggers are there), omg...
 
Upvote 0 Downvote
Back
Top