[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

[amgreborn]

Update 1.5 ... I think this will be my last update for the plugin. The code isn't perfect yet, but as far as I know, it seems to be working. I know of some bug in calculating the database cleanup progress, but it should only be faulty in showing the progress in chat, the database itself is correctly cleaned up.
There was some code regarding a small and normal sized window, but I saw absolutely no change between those too, so I removed those.
I let the plugin run for a few weeks on my server and no one had any complaints so far, so here's the release.

Credits go to Tomek0055 for his initial code regarding the pages functionality, I made further changes to his code.

Changelog 1.5:
- Added pages to secrecs, fixes issue of displaying a too large window on challenges with many checkpoints
- Removed small/normal window size configuration, secrecs window is now set to a reasonable size
- Removed unnecessary code

Download