public function activateAction() { if ($this->getRequest()->isGet()) { $ecid = $this->_request->getParam('ecid', null); if ($ecid != null) { $db = Zend_Db_Table::getDefaultAdapter(); $userTable = new Default_Dao_User(); $stmt = $userTable->select()->where($db->quoteInto("email_confirmation_id = ?", $ecid))->where("valid is false"); $row = $userTable->fetchRow($stmt); if ($row != null) { $row['valid'] = true; $row['email_confirmation_id'] = null; $row->save(); } } } }
public function authenticate() { $userTable = new Default_Dao_User(); $stmt = $userTable->select()->where("username = ?", $this->_username)->where("password = ?", md5($this->_password))->where("valid is true"); $row = $userTable->fetchRow($stmt); if ($row != null) { $user = new Default_Dto_User(); $user->id = $row['id']; $user->username = $row['username']; $user->email = $row['email']; $user->description = $row['description']; $user->website = $row['website']; $user->entryDate = $row['entry_date']; return new Zend_Auth_Result(Zend_Auth_Result::SUCCESS, $user); } else { return new Zend_Auth_Result(Zend_Auth_Result::FAILURE_CREDENTIAL_INVALID, null, array('Wrong Password')); } }