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