This script finds all the accounts that haven't logged ingame in a specific number of days and deletes all the records related to those accounts in MuOnline and Ranking databases.
Installation
Once it's uploaded to your web-server, go to your web-browser and run the script:
A list of the inactive accounts will appear (if the installation succedded):
Check the boxes at the right of the accounts you don't want to delete, press the button and wait (It may take some time, specially if your DB is too big.)
A screen like this will appear when the task is done.
I coded this, with Dios and Mr-K's help, so all the credits go to [-D|K|L-] Team. (Thanks guys , Love Ya)
***************************************
UPDATED!!!!!!!!
Reason: It didn't work for some dbs. Fixed Now.
Please report any bugs here. Thanks.
***************************************
Installation
- Extract the files into your web-server folder.
- Edit your delcfg.php and change the settings according to your server.
(I tried to explain how to change it inside the file)
- That's all
Running the script- Edit your delcfg.php and change the settings according to your server.
(I tried to explain how to change it inside the file)
- That's all
Once it's uploaded to your web-server, go to your web-browser and run the script:
You must be registered to see links
A list of the inactive accounts will appear (if the installation succedded):
Check the boxes at the right of the accounts you don't want to delete, press the button and wait (It may take some time, specially if your DB is too big.)
A screen like this will appear when the task is done.
A few notes:
- I've tested this script on 2 servers only, Mr-K's server (1.02d) and on Dios's server (0.97d+0.99items) and it worked fine.
- This script searchs the default tables only, so if you've installed tools that use their own tables (like SkyTeam's tools), you'll have to clean them up manually.
- ALWAYS KEEP A BACK UP OF YOUR DATABASE. SPECIALLY IF YOU ARE NOT SURE OF WHAT YOU'RE TRYING.
- I've made these files for Server Owners only. This means you should not keep the files up all the time, I strongly recommend to extract the files only during maintenance and delete the files from your web-server after using them. BE CAREFULL, THIS IS A POWERFUL TOOL.
- If you still want to keep these files up, you can make a sub-folder in your web-server with password-authentication.
- Now.. this is important: IF YOU GET THIS ERROR: "Fatal error: Call to undefined function: mssql_connect() in blah blah" just check this thread: *CLICK HERE*. This is a common error and it has been solved and explained a lot of times before in this forum.
- Any doubt/suggestion/complain/critic is welcome
Credits
I coded this, with Dios and Mr-K's help, so all the credits go to [-D|K|L-] Team. (Thanks guys , Love Ya)
***************************************
UPDATED!!!!!!!!
Reason: It didn't work for some dbs. Fixed Now.
Please report any bugs here. Thanks.
***************************************
Attachments
You must be registered for see attachments list
Last edited: