[XASECO] Sector Records

[L3cKy]

Just in case this could/should be also included inside function chat_secrecs_cleanupdb (like if u deleted a player with /removelogin at dbtools before)

Code: Select all

mysql_query("DELETE FROM secrecs_all WHERE PlayerNick NOT IN (SELECT Login FROM players);");
mysql_query("DELETE FROM secrecs_own WHERE PlayerNick NOT IN (SELECT Login FROM players);");

Greetings

[amgreborn]

Players who are not in the players table couldn't have driven any secrecs though. So there shouldn't be any secrecs of players that are not in the players table, or am I getting something wrong here?

[L3cKy]

If a player have driven some secrecs and you delete the player (with /removelogin at dbtools) the secrecs are still there.