public function getAllExpireUser()
{
$lastyear = strtotime("-1 year");
$lastYearDate = date("Y-m-d", $lastyear);
$result = $this->SelectQueryBuild3("SELECT * FROM `siteuser` WHERE userID<>1");
//exempt admin
$Users = array();
while ($row = mysql_fetch_array($result)) {
$d = strtotime($row['lastlogin']);
if ((strtotime($row['lastlogin']) <= strtotime($lastYearDate) || strtotime($row['lastactivity']) <= strtotime($lastYearDate)) && $row['blocked'] != '1') {
$temp = new siteUser();
$temp->setID($row['userID']);
$temp->setUserName($row['username']);
$temp->setLastLogin($row['lastlogin']);
$temp->setLastDownload($row['lastactivity']);
$temp->setBlocked($row['blocked']);
$temp->setUserType($row['userType']);
$Users[] = $temp;
}
}
return $Users;
}
