/lib/CleanUp.php

<?php



function autoclean() {

    global $autoclean_interval;



    $now = time();

    $docleanup = 0;



    $res = mysql_query("SELECT value_u FROM avps WHERE arg = 'lastcleantime'");

    $row = mysql_fetch_array($res);

    if (!$row) {

        mysql_query("INSERT INTO avps (arg, value_u) VALUES ('lastcleantime',$now)");

        return;

    }

    $ts = $row[0];

    if ($ts + $autoclean_interval > $now)

        return;

    mysql_query("UPDATE avps SET value_u=$now WHERE arg='lastcleantime' AND value_u = $ts");

    if (!mysql_affected_rows())

        return;



    docleanup();

}





function docleanup() {

	global $torrent_dir, $signup_timeout, $max_dead_torrent_time, $autoclean_interval;



	set_time_limit(0);

	ignore_user_abort(1);



	do {

		$res = mysql_query("SELECT id FROM torrents");

		$ar = array();

		while ($row = mysql_fetch_array($res)) {

			$id = $row[0];

			$ar[$id] = 1;

		}



		if (!count($ar))

			break;



		$dp = @opendir($torrent_dir);

		if (!$dp)

			break;



		$ar2 = array();

		while (($file = readdir($dp)) !== false) {

			if (!preg_match('/^(\d+)\.torrent$/', $file, $m))

				continue;

			$id = $m[1];

			$ar2[$id] = 1;

			if (isset($ar[$id]) && $ar[$id])

				continue;

			$ff = $torrent_dir . "/$file";

			unlink($ff);

		}

		closedir($dp);



		if (!count($ar2))

			break;



		$delids = array();

		foreach (array_keys($ar) as $k) {

			if (isset($ar2[$k]) && $ar2[$k])

				continue;

			$delids[] = $k;

			unset($ar[$k]);

		}

		if (count($delids))

			mysql_query("DELETE FROM torrents WHERE id IN (" . join(",", $delids) . ")");



		$res = mysql_query("SELECT torrent FROM peers GROUP BY torrent");

		$delids = array();

		while ($row = mysql_fetch_array($res)) {

			$id = $row[0];

			if (isset($ar[$id]) && $ar[$id])

				continue;

			$delids[] = $id;

		}

		if (count($delids))

			mysql_query("DELETE FROM peers WHERE torrent IN (" . join(",", $delids) . ")");



		$res = mysql_query("SELECT torrent FROM files GROUP BY torrent");

		$delids = array();

		while ($row = mysql_fetch_array($res)) {

			$id = $row[0];

			if ($ar[$id])

				continue;

			$delids[] = $id;

		}

		if (count($delids))

			mysql_query("DELETE FROM files WHERE torrent IN (" . join(",", $delids) . ")");

	} while (0);



	$deadtime = deadtime();

	mysql_query("DELETE FROM peers WHERE last_action < FROM_UNIXTIME($deadtime)");



	$deadtime -= $max_dead_torrent_time;

	mysql_query("UPDATE torrents SET visible='no' WHERE visible='yes' AND last_action < FROM_UNIXTIME($deadtime)");



	$deadtime = time() - $signup_timeout;

	mysql_query("DELETE FROM users WHERE status = 'pending' AND added < FROM_UNIXTIME($deadtime) AND last_login < FROM_UNIXTIME($deadtime) AND last_access < FROM_UNIXTIME($deadtime)");



	$torrents = array();

	$res = mysql_query("SELECT torrent, seeder, COUNT(*) AS c FROM peers GROUP BY torrent, seeder");

	while ($row = mysql_fetch_assoc($res)) {

		if ($row["seeder"] == "yes")

			$key = "seeders";

		else

			$key = "leechers";

		$torrents[$row["torrent"]][$key] = $row["c"];

	}



	$res = mysql_query("SELECT torrent, COUNT(*) AS c FROM comments GROUP BY torrent");

	while ($row = mysql_fetch_assoc($res)) {

		$torrents[$row["torrent"]]["comments"] = $row["c"];

	}



	$fields = explode(":", "comments:leechers:seeders");

	$res = mysql_query("SELECT id, seeders, leechers, comments FROM torrents");

	while ($row = mysql_fetch_assoc($res)) {

		$id = $row["id"];

		$torr = $torrents[$id];

		foreach ($fields as $field) {

			if (!isset($torr[$field]))

				$torr[$field] = 0;

		}

		$update = array();

		foreach ($fields as $field) {

			if ($torr[$field] != $row[$field])

				$update[] = "$field = " . $torr[$field];

		}

		if (count($update))

			mysql_query("UPDATE torrents SET " . implode(",", $update) . " WHERE id = $id");

	}



	//delete inactive user accounts

	$secs = 42*86400;

	$dt = sqlesc(get_date_time(gmtime() - $secs));

	$maxclass = UC_POWER_USER;

	mysql_query("DELETE FROM users WHERE status='confirmed' AND class <= $maxclass AND last_access < $dt");



	// lock topics where last post was made more than x days ago

	$secs = 7*86400;

	$res = mysql_query("SELECT topics.id FROM topics JOIN posts ON topics.lastpost = posts.id AND topics.sticky = 'no' WHERE " . gmtime() . " - UNIX_TIMESTAMP(posts.added) > $secs") or mysql_error();

	while ($arr = mysql_fetch_assoc($res))

		mysql_query("UPDATE topics SET locked='yes' WHERE id=$arr[id]") or mysql_error();



  //remove expired warnings

  $res = mysql_query("SELECT id FROM users WHERE warned='yes' AND warneduntil < NOW() AND warneduntil <> '0000-00-00 00:00:00'") or mysql_error();

  if (mysql_num_rows($res) > 0)

  {

    $dt = sqlesc(get_date_time());

    $msg = sqlesc("Your warning has been removed. Please keep in your best behaviour from now on.\n");

    while ($arr = mysql_fetch_assoc($res))

    {

      mysql_query("UPDATE users SET warned = 'no', warneduntil = '0000-00-00 00:00:00' WHERE id = $arr[id]") or mysql_error();

      mysql_query("INSERT INTO messages (sender, receiver, added, msg, poster) VALUES(0, $arr[id], $dt, $msg, 0)") or mysql_error();

    }

  }



	// promote power users

	$limit = 25*1024*1024*1024;

	$minratio = 1.05;

	$maxdt = sqlesc(get_date_time(gmtime() - 86400*28));

	$res = mysql_query("SELECT id FROM users WHERE class = 0 AND uploaded >= $limit AND uploaded / downloaded >= $minratio AND added < $maxdt") or mysql_error();

	if (mysql_num_rows($res) > 0)

	{

		$dt = sqlesc(get_date_time());

		$msg = sqlesc("Congratulations, you have been auto-promoted to [b]Power User[/b]. :)\nYou can now download dox over 1 meg and view torrent NFOs.\n");

		while ($arr = mysql_fetch_assoc($res))

		{

			mysql_query("UPDATE users SET class = 1 WHERE id = $arr[id]") or mysql_error();

			mysql_query("INSERT INTO messages (sender, receiver, added, msg, poster) VALUES(0, $arr[id], $dt, $msg, 0)") or mysql_error();

		}

	}



	// demote power users

	$minratio = 0.95;

	$res = mysql_query("SELECT id FROM users WHERE class = 1 AND uploaded / downloaded < $minratio") or mysql_error();

	if (mysql_num_rows($res) > 0)

	{

		$dt = sqlesc(get_date_time());

		$msg = sqlesc("You have been auto-demoted from [b]Power User[/b] to [b]User[/b] because your share ratio has dropped below $minratio.\n");

		while ($arr = mysql_fetch_assoc($res))

		{

			mysql_query("UPDATE users SET class = 0 WHERE id = $arr[id]") or mysql_error();

			mysql_query("INSERT INTO messages (sender, receiver, added, msg, poster) VALUES(0, $arr[id], $dt, $msg, 0)") or mysql_error();

		}

	}



	// Update stats

	$seeders = get_row_count("peers", "WHERE seeder='yes'");

	$leechers = get_row_count("peers", "WHERE seeder='no'");

	mysql_query("UPDATE avps SET value_u=$seeders WHERE arg='seeders'") or mysql_error();

	mysql_query("UPDATE avps SET value_u=$leechers WHERE arg='leechers'") or mysql_error();



	// update forum post/topic count

	$forums = mysql_query("select id from forums");

	while ($forum = mysql_fetch_assoc($forums))

	{

		$postcount = 0;

		$topiccount = 0;

		$topics = mysql_query("select id from topics where forumid=$forum[id]");

		while ($topic = mysql_fetch_assoc($topics))

		{

			$res = mysql_query("select count(*) from posts where topicid=$topic[id]");

			$arr = mysql_fetch_row($res);

			$postcount += $arr[0];

			++$topiccount;

		}

		mysql_query("update forums set postcount=$postcount, topiccount=$topiccount where id=$forum[id]");

	}



	// delete old torrents

	$days = 28;

	$dt = sqlesc(get_date_time(gmtime() - ($days * 86400)));

	$res = mysql_query("SELECT id, name FROM torrents WHERE added < $dt");

	while ($arr = mysql_fetch_assoc($res))

	{

		@unlink("$torrent_dir/$arr[id].torrent");

		mysql_query("DELETE FROM torrents WHERE id=$arr[id]");

		mysql_query("DELETE FROM peers WHERE torrent=$arr[id]");

		mysql_query("DELETE FROM comments WHERE torrent=$arr[id]");

		mysql_query("DELETE FROM files WHERE torrent=$arr[id]");

		write_log("Torrent $arr[id] ($arr[name]) was deleted by system (older than $days days)");

	}



}



?>