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; }