public function authAction()
{
$request = $this->getRequest();
$registry = Zend_Registry::getInstance();
$auth = Zend_Auth::getInstance();
$DB = $registry['DB'];
$authAdapter = new Zend_Auth_Adapter_DbTable($DB);
$authAdapter->setTableName('fitness_user_general')->setIdentityColumn('user_username')->setCredentialColumn('user_password');
if ($request->getParam('user_username') != "" && $request->getParam('user_password') != "") {
// Set the input credential values
$uname = $request->getParam('user_username');
$paswd = md5($request->getParam('user_password'));
$authAdapter->setIdentity($uname);
$authAdapter->setCredential($paswd);
$select = $authAdapter->getDbSelect();
$select->where('user_status = 1');
// Perform the authentication query, saving the result
$result = $auth->authenticate($authAdapter);
if ($result->isValid()) {
//print_r($result);
$data = $authAdapter->getResultRowObject(null, 'password');
$auth->getStorage()->write($data);
$sess = new Zend_Session_Namespace('UserSession');
if ($sess->isLocked()) {
$sess->unlock();
}
$sess->username = $uname;
//record login status
$fitnessUser = new FitnessUserGeneral();
$fitnessUser->userLogin($uname);
$loginDetails = $fitnessUser->getLastLogin($uname);
$fitnessUser->userLogin($uname);
if ($loginDetails['user_login'] == 1) {
$this->_redirect('/user/settings');
} else {
$this->_redirect('/user/listworkouts');
}
} else {
$this->_redirect('/user/loginform');
}
} else {
$this->_redirect('/user/loginform');
}
}
