phpMyBitTorrent Project Forums: M0dZ & HaCkZ

Members

Help

Home

Home » Discussion Forums » M0dZ & HaCkZ » Auto deleting users

Show: Today's Messages :: Show Polls :: Message Navigator

E-mail to friend

Auto deleting users [message #1353]

Mon, 17 September 2007 19:19

Revan

Messages: 125
Registered: April 2007

Super-Seeder

This script sends a warning to users who haven't been online for more than 30 days and will delete users that haven't been online for more than 40 days. It has some flaws, but it works.

Open the cleanup.php in include folder and find:

function cleanup() {
        global $db, $db_prefix, $btuser, $autoscrape, $dead_torrent_interval, $announce_interval;

        $db->sql_query("DELETE FROM ".$db_prefix."_download WHERE date < SUBDATE(SYSDATE(), INTERVAL 7 DAY);");
        $db->sql_query("DELETE FROM ".$db_prefix."_users WHERE active = 0 AND UNIX_TIMESTAMP(regdate) < UNIX_TIMESTAMP(NOW()) - 432000;");

and insert after that:

$userwarninactivesub = Array();
$userwarninactivesub[english] = "".$sitename." Warning";
$userwarninactivesub[german] = "".$sitename." Achtung";
$userwarninactivesub[spanish] = "Advertencia".$sitename."";
$userwarninactivesub[brazilian] = "".$sitename." adverte";


$userwarninactivetext = Array();

$userwarninactivetext[english] = "Hi,
we would like to warn you that you have not been active on **siteurl** for more than 30 days,
if you do not want to have your account deleted please login to it. You have 10 days to log in from now. 
Otherwise we will delete your account permanently.
Thanks **sitename** Admin
**siteurl**";

$userwarninactivetext[german] = "Wir möchten darauf hinweisen , dass du auf **siteurl** seit mehr als 30 Tagen nicht mehr aktiv warst, 
wenn Du nicht willst, dass dein Account gelöscht wird, logge dich bitte ein. 
Du hast ab jetzt 10 Tage Zeit um dich auf **sitename** einzuloggen.
Ansonsten werden wir deinen Account permanent löschen.
Danke**sitename**Admin.
**siteurl**";

$userwarninactivetext[spanish] = "Hola, 
Queriamos decirte que no visitaste nuestra pagina **siteurl** por mas de 30 dias.
Si no quieres que tu Cuenta sea borrada, por favor logueate. Tienes 10 dias para loguearte nuevamente apartir de hoy.
De otra manera borraremos tu cuenta de forma permanente.
Gracias. Los **sitename** administradores
**siteurl**";


$userwarninactivetext[brazilian] = "Oi,
Nós gostaríamos de avisa-lo que voce nao tem estado ativo no **siteurl** por mais de 30 dias.
Se voce nao quer ter sua conta excluída, por favor conecte-se. Voce tem 10 dias a partir de hoje para fazer isso.
Caso contrário nós iremos apagar sua conta permanentemente.
Obrigado **sitename** Administrador
**siteurl**";

$admin_email ="YOUR ADMIN MAIL";
$sitename= "YOUR SITE NAME";
$siteurl= "YOUR SITE URL";

$res1 = "SELECT id, email, inactwarning, lastlogin, language FROM ".$db_prefix."_users;";
$res2 = $db->sql_query($res1);
while ($get_info = $db->sql_fetchrow($res2))
{
if ($get_info[inactwarning] == 0 AND $get_info[lastlogin] != 0 AND $get_info[lastlogin] < date('Y-m-d H:i:s', time() - 2592000)) 
{
$db->sql_query("UPDATE ".$db_prefix."_users SET inactwarning = 1 WHERE ((UNIX_TIMESTAMP(lastlogin) < UNIX_TIMESTAMP(NOW()) - 2592000) AND (UNIX_TIMESTAMP(lastlogin) <> 0));");
$replace_markers = Array("**sitename**","**siteurl**");
$replace_data = Array ($sitename,$siteurl);
if ($get_info[language] == "") $get_info[language] = "english";
$warn_mail = New eMail;
$warn_mail->sender = $admin_email;
$warn_mail->subject = $userwarninactivesub[$get_info[language]];
$warn_mail->body = str_replace($replace_markers,$replace_data,$userwarninactivetext[$get_info[language]]);
$warn_mail->Add($get_info[email]);
$warn_mail->Send();
}
if ($get_info[inactwarning] == 1 AND $get_info[lastlogin] != 0 AND $get_info[lastlogin] > date('Y-m-d H:i:s', time() - 2592000))
{
$db->sql_query("UPDATE ".$db_prefix."_users SET inactwarning = 0 WHERE (inactwarning = 1) AND (UNIX_TIMESTAMP(lastlogin) > UNIX_TIMESTAMP(NOW()) - 2592000);");
}
if ($get_info[inactwarning] == 1 AND $get_info[lastlogin] != 0 AND $get_info[lastlogin] < date('Y-m-d H:i:s', time() - 3456000))
{
$db->sql_query("DELETE FROM ".$db_prefix."_users WHERE (inactwarning = 1) AND (UNIX_TIMESTAMP(lastlogin) < UNIX_TIMESTAMP(NOW()) - 3456000);");
}
}

after that you'll need to go to database and add to your users table column 'inactwarning'

This could probably need some more work on it, but I just thought I'd post it anyway..

[Updated on: Thu, 06 December 2007 17:17]