phpBB.de

Code: Alles auswählen

<?php
define('IN_PHPBB', true);
$phpbb_root_path = '../';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);

$p = $c = 0;

$con = mysql_connect ($dbhost, $dbuser, $dbpasswd);
mysql_select_db($dbname);

$now = time();
$days = 90;
$quar = $now - (86400*$days);

// diese query anpassen, um die user auszuwählen, die gelöscht werden sollen.
$sql = "select user_id, username, user_email, user_lastvisit, user_regdate, user_posts from " . $table_prefix . "users where user_id >0 and (user_regdate<=$quar and user_lastvisit<=$quar)";

$res = mysql_query($sql);
echo "$days Tage sind seit dem " . gmdate("d.M.Y", $quar) . " vorbei. Timestamp für diesen Tag: $quar.<br /><br />";
echo "<b>Abfrage</b>:<br /><i>$sql</i>";
echo "<h2>Seit mehr als $days Tagen nicht mehr aktive User</h2>\n";
while ($row = mysql_fetch_array($res)) {

	set_time_limit(30);

	echo gmdate("d.m.Y", $row['user_regdate']) . ":" . gmdate("d.m.Y", $row['user_lastvisit']) . $row['username'] . ": " . $row['user_email'] . ": " . $row['user_posts'] . ": ";

	$sql2 = "select count(post_id) as ps from " . $table_prefix . "posts as p where p.poster_id= " . $row['user_id'];
	$res2 = mysql_query($sql2);
	$row2 = mysql_fetch_array($res2);
	$p += $row2['ps'];
	echo $row2['ps'] . ": ";

	$c++;

	$user_id = $row['user_id'];

	$sql = "SELECT g.group_id
		FROM " . USER_GROUP_TABLE . " ug, " . GROUPS_TABLE . " g
		WHERE ug.user_id = $user_id
			AND g.group_id = ug.group_id
			AND g.group_single_user = 1";
	if( !($result = $db->sql_query($sql)) )
	{
		echo 'Could not obtain group information for this user';
	}

	set_time_limit(30);

	$row = $db->sql_fetchrow($result);

	$sql = "UPDATE " . POSTS_TABLE . "
		SET poster_id = " . ANONYMOUS . ", post_username = '$username'
		WHERE poster_id = $user_id";
	if( !$db->sql_query($sql) )
	{
		echo 'Could not update posts for this user';
	}

	set_time_limit(30);

	$sql = "UPDATE " . TOPICS_TABLE . "
		SET topic_poster = " . ANONYMOUS . "
		WHERE topic_poster = $user_id";
	if( !$db->sql_query($sql) )
	{
		echo 'Could not update topics for this user';
	}

	set_time_limit(30);

	$sql = "DELETE FROM " . USERS_TABLE . "
		WHERE user_id = $user_id";
	if( !$db->sql_query($sql) )
	{
		echo 'Could not delete user';
	}

	set_time_limit(30);

	$sql = "DELETE FROM " . USER_GROUP_TABLE . "
		WHERE user_id = $user_id";
	if( !$db->sql_query($sql) )
	{
		echo 'Could not delete user from user_group table';
	}

	set_time_limit(30);

	$sql = "DELETE FROM " . GROUPS_TABLE . "
		WHERE group_id = " . $row['group_id'];
	if( !$db->sql_query($sql) )
	{
		echo 'Could not delete group for this user';
	}

	set_time_limit(30);

	$sql = "DELETE FROM " . AUTH_ACCESS_TABLE . "
		WHERE group_id = " . $row['group_id'];
	if( !$db->sql_query($sql) )
	{
		echo 'Could not delete group for this user';
	}

	set_time_limit(30);

	$sql = "DELETE FROM " . TOPICS_WATCH_TABLE . "
		WHERE user_id = $user_id";
	if ( !$db->sql_query($sql) )
	{
		echo 'Could not delete user from topic watch table';
	}

	echo 'User deleted<br />';

}
echo $c . " " . $p;
?>

Code: Alles auswählen

$sql = "select user_id, username, user_email, user_lastvisit, user_regdate, user_posts from " . $table_prefix . "users where user_id >0 and user_posts=0";