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);");
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);");
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]).'"');