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'));
}
}
public function activateTwitter($queryData)
{
$loggedInUserId = $this->getIdentityId();
if ($loggedInUserId) {
$db = Zend_Db_Table::getDefaultAdapter();
$userDao = new Default_Dao_User();
$userRow = $userDao->fetchRow($db->quoteInto('id = ?', $loggedInUserId));
if ($userRow) {
$config = new Zend_Config_Ini(APPLICATION_PATH . '/configs/twitter.ini');
$consumer = new Zend_Oauth_Consumer($config);
$get = array();
parse_str($queryData, $get);
$token = $consumer->getAccessToken($get, unserialize($userRow['twitter_request_token']));
$db = Zend_Db_Table::getDefaultAdapter();
$data = array('twitter_access_token' => serialize($token), 'twitter_request_token' => NULL);
$userDao->update($data, $db->quoteInto('id = ?', $loggedInUserId));
}
}
}
protected function getIdentityRow()
{
$user = Zend_Auth::getInstance()->getIdentity();
$userTable = new Default_Dao_User();
return $userTable->fetchRow("id = '{$user->id}'");
}
