MySQL Database

[Deaktiver]

Hello,

today I need help with my MySQL databse. There are over 5000 registered players and I need a System/Tool/Programm that delet EVERY INACTIV player and account after 1 month. I saw something 3 months ago but I didnt remember..I am using nicaw acc I saw this system on avarins aac but I don't remember..
I hope someone can help me


Thanks!

 

[Jester]

Im not very sure but to tell you my tought, there are some commands for phpmyadmin. It would remove players that didnt login with 30 days or the days you set. I know its possible in that way because I had the code long time ago but I ain't sure now if still works.

 

[ntmr]

It's easy to do

DELETE FROM players WHERE lastlogin < 'INACTIVE_TIME_LIMIT';

To calculate the INACTIVE_TIME_LIMIT you can use this script:

<?php
$inactive_days = 90; # edit it with the max inactive days (1 = 1 day)

$inactive_time = 86400 * $inactive_days;
$inactive_time_limit = time() - $inactive_time;
echo $inactive_time_limit;
?>

I've not tested it, but may be work

#edit

It will delete all players that never logged in too :X