[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.

[amgreborn]

I updated dbtools a bit to also delete secrecs

dbtools 1.0.7.1

Changes in code

Code: Select all

/* wipedb */
Line 909/910
dbtools_sql('TRUNCATE TABLE secrecs_all');
dbtools_sql('TRUNCATE TABLE secrecs_own');

/* optimize */
Line 927/928
dbtools_sql('OPTIMIZE TABLE secrecs_all');
dbtools_sql('OPTIMIZE TABLE secrecs_own');

/* repair */
Line 945/946
dbtools_sql('REPAIR TABLE secrecs_all');
dbtools_sql('REPAIR TABLE secrecs_own');

/* removethis */
Line 1357/1358
dbtools_sql('DELETE FROM secrecs_all WHERE ChallengeID="'.mysql_real_escape_string($challengeinfo['UId']).'"');
dbtools_sql('DELETE FROM secrecs_own WHERE ChallengeID="'.mysql_real_escape_string($challengeinfo['UId']).'"');

/* removelogin */
Line 1394/1395
dbtools_sql('DELETE FROM secrecs_own WHERE PlayerNick="'.mysql_real_escape_string($param[1]).'"');
dbtools_sql('DELETE FROM secrecs_all WHERE PlayerNick="'.mysql_real_escape_string($param[1]).'"');

Also changed some strings, but I'm not listing those now