Database cleaning

[gmakhs]

hi im looking foward to clean up my database im writing this post to ask for help ut i will keep googling.

i m looking for a script that will delte all empty accounts

[qwerty13]

all this is done on each server startup.. just run

DELETE FROM characters WHERE account_name LIKE "put the sad account here";
DELETE FROM accounts WHERE login LIKE "put the sad account here";

Btw, first try it on test server.

[janiii]

it depends
- if you have login tables in same database as gameserver tables:

Code: Select all

DELETE FROM accounts WHERE login NOT IN (SELECT DISTINCT(account_name) FROM characters);

- if they are in separate databases but same machine )l2j_login is the login database name, l2j_game is the gameserver database name):

Code: Select all

DELETE FROM l2j_login.accounts WHERE login NOT IN (SELECT DISTINCT(account_name) FROM l2j_game.characters);

be sure to make a backup before!

[gmakhs]

thanks im gonna try it tommorow anbd ofc i will do backup first!