Clean database

[demondark]

How do I delete all the items, skills, vip list of players that have been deleted?

 

[ExibeR]

How do I delete all the items, skills, vip list of players that have been deleted?

Was writing, then Bintzer came... =D

 

[Bintzer]

Easy
Just run this query

DELETE FROM player_items WHERE player_id NOT IN (SELECT id FROM players);
DELETE FROM player_skills WHERE player_id NOT IN (SELECT id FROM players);
DELETE FROM player_viplist WHERE player_id NOT IN (SELECT id FROM players);

 

[ExibeR]

Easy
Just run this query

DELETE FROM player_items WHERE player_id NOT IN (SELECT id FROM players);
DELETE FROM player_skills WHERE player_id NOT IN (SELECT id FROM players);
DELETE FROM player_viplist WHERE player_id NOT IN (SELECT id FROM players);

Perhaps add:

DELETE FROM player_storage WHERE player_id NOT IN (SELECT id FROM players);
DELETE FROM player_storage WHERE player_depotitems NOT IN (SELECT id FROM players);