<?php
/*=====================================================================*\
|| ###################################################################
|| # Bugdar
|| # Copyright (c)2020 Blue Static
|| # This program is free software; you can redistribute it and/or modify
|| # it under the terms of the GNU General Public License as published by
|| # the Free Software Foundation; version 2 of the License.
|| #
|| # This program is distributed in the hope that it will be useful, but
|| # WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
|| # or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
|| # more details.
|| #
|| # You should have received a copy of the GNU General Public License along
|| # with this program; if not, write to the Free Software Foundation, Inc.,
|| # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA
|| ###################################################################
\*=====================================================================*/

require_once('./includes/api_user.php');

function CronPurgeInactiveUsers()
{
	global $bugsys;
	$thirty_days_ago = TIMENOW - (60 * 60 * 24 * 30);
	$inactive_users = bugdar::$db->query("
		SELECT user.displayname, user.userid, user.email,
			useractivation.activator, useractivation.dateline
		FROM " . TABLE_PREFIX . "user AS user
		LEFT JOIN " . TABLE_PREFIX . "useractivation AS useractivation
			ON (user.userid = useractivation.userid)
		WHERE user.usergroupid = 3
		AND useractivation.dateline <= $thirty_days_ago
	");
	while ($user = $inactive_users->fetch()) {
		$data = new UserAPI($bugsys);
		$data->set('userid', $user['userid']);
		$data->set_condition();
		$data->delete();
	}
}