protected function getLastActive() { // init $this->set('success', false); $this->set('errormessage', 'Invalid session.'); $_userID = $this->get('userid'); if ($_userID) { // query VARS $_numRows = 0; $_queryResult = false; $_cacheNameSpace = false; $_dbName = 'appsecurity'; // use app DB $_useCacheforQuery = false; $_cacheTTL = 172800; $_query = 'SELECT * FROM users WHERE userid="' . $_userID . '"'; $_obj = new \PAJ\Library\DB\MYSQL\QueryAllRows($_query, $_cacheNameSpace, $_dbName, $_useCacheforQuery, $_cacheTTL); $_queryResult = $_obj->get('queryresult'); $_numRows = $_obj->get('queryrows'); if ($_numRows) { $this->set('success', true); $this->set('output', array('getLastActive' => $_queryResult, 'numrows' => $_numRows, 'output' => 'Session getactive timestamp retrieved.')); } else { $this->set('errormessage', 'Error obtaining last active timestamp.'); } } }
/** * DBPasswordResetRequestsValidate function. * @what - validate the password reset token and email in the database * @access private * @param mixed $_userEmail * @param mixed $_token * @return void */ private function DBPasswordResetRequestsValidate($_userEmail, $_token) { $_queryResult = false; $_numRows = 0; $_cacheNameSpace = false; $_dbName = $this->get('dbname'); $_useCacheforQuery = false; $_cacheTTL = 172800; $_query = "SELECT * FROM passwordresetrequests WHERE (email = '" . $_userEmail . "' AND token = '" . $_token . "') LIMIT 1"; $_obj = new \PAJ\Library\DB\MYSQL\QueryAllRows($_query, $_cacheNameSpace, $_dbName, $_useCacheforQuery, $_cacheTTL); $_queryResult = $_obj->get('queryresult'); $_numRows = $_obj->get('queryrows'); unset($_obj); if ($_numRows > 0) { return true; } else { // no records found return false; } }