public function delAction() { //获取文章id if ($this->getRequest()->isGet()) { $account_id = $this->_request->get('id'); $nickname = $this->_request->get('nickname'); $article = new Application_Model_DbTable_Account(); $db = $article->getAdapter(); //删除用户 $where0 = $db->quoteInto('id = ?', $account_id); $db->delete('account', $where0); //删除文章 $where1 = $db->quoteInto('account_id = ?', $account_id); $db->delete('article', $where1); //删除文章对应的评论 $where2 = $db->quoteInto('account_id = ?', $account_id); $db->delete('comment', $where2); //删除用户目录 $dir = BLOG_ROOT . '/public/' . $nickname; $this->delDirAndFile($dir); } //判断是否是ajax传值 if ($this->getRequest()->isXmlHttpRequest() || $this->_getParam('ajax') == 1) { $this->_helper->layout->setLayout('empty_layout'); $this->_helper->viewRenderer->setNoRender(); $this->_response->appendBody(2); } else { $this->_helper->viewRenderer->setNoRender(); $this->_forward('index'); } }
public function findAction() { $this->view->headTitle("密码找回"); //$this->_helper->viewRenderer->setNoRender (); if ($this->getRequest()->isPost()) { $nickname = trim($this->_request->getParam('nickname')); $email = trim($this->_request->getParam('email')); $account = new Application_Model_DbTable_Account(); $db = $account->getAdapter(); $select = $db->select(); $select->from('account', array('nickname', 'password')); $select->where('nickname = ?', $nickname); $select->where('email = ?', $email); $result = $db->fetchRow($select); if ($result) { $smtpemailto = $email; $mailsubject = "cblog登陆密码找回"; $mailbody = "<h1>cblog博客登陆密码找回</h1><p>您的博客:<br/><span>登陆账户为: " . $result['nickname'] . "</span> <br/> <span>登陆密码为: " . $result['password'] . "</span></p>"; if ($this->send($smtpemailto, $mailsubject, $mailbody)) { // if($this->mailSend($smtpemailto,$mailsubject,$mailbody)){ $status = "ok"; $response = "密码已发到您的邮箱,请注意查收!"; } else { $status = "sorry"; $response = "邮箱服务出错,请稍后再试!"; } } else { $status = "sorry"; $response = "你输入的用户名和邮箱不匹配,请重试!"; } //print_r($this->_request->getParams()); //var_dump($result); if ($this->getRequest()->isXmlHttpRequest() || $this->_request->getParam('ajax') == 1) { $this->_helper->layout->setLayout('empty_layout'); $this->_helper->viewRenderer->setNoRender(); $this->_response->appendBody($status); } else { echo "<script type='text/javascript'>alert('{$response}')</script>"; } } }
public function pwdAction() { if ($this->getRequest()->isPost()) { $oldpwd = trim($this->_request->getParam('oldpwd')); $newpwd = trim($this->_request->getParam('newpwd')); $confirmpwd = trim($this->_request->getParam('confirmpwd')); $account = new Application_Model_DbTable_Account(); $db = $account->getAdapter(); $select = $db->select(); $select->from('account', 'password'); $select->where('id = ?', BLOGGER_ID); $data = $db->fetchRow($select); if ($oldpwd != $data['password']) { $response = "请输入原始注册密码!"; } else { if ($newpwd != $confirmpwd) { $response = "两次密码输入不一致!"; } else { $affected = $account->updatePwd(BLOGGER_ID, $newpwd); if ($affected >= 1) { $response = "密码修改成功!"; } else { $response = "系统出错,请稍后再试!"; } } } if ($this->getRequest()->isXmlHttpRequest() || $this->_request->getParam('ajax') == 1) { $this->_helper->layout->setLayout('empty_layout'); $this->_helper->viewRenderer->setNoRender(); $this->_response->appendBody($response); } else { $this->_forward('profile'); echo "<script type='text/javascript'>alert('{$response}')</script>"; } } }
public function indexAction() { $cache = Zend_Registry::get('cache'); $id = md5("aboutmeControllerIndex"); if (($result = $cache->load($id)) === false) { //$data = $db->fetchAll($select); $account = new Application_Model_DbTable_Account(); $db = $account->getAdapter(); //获取用户信息 $select = $db->select(); $select->from('account', array('nickname', 'photo')); $select->where('id = ?', BLOGGER_ID); $result = $db->fetchRow($select); //获取博主 原创 翻译 转载各自篇数,和评论数 $select = $db->select(); $select->from('article', array('count(*) totalori')); $select->where('atype_id = 1'); $select->where('account_id = ?', BLOGGER_ID); $arr = $db->fetchRow($select); $result['totalori'] = $arr['totalori']; $select = $db->select(); $select->from('article', array('count(*) totaltrans')); $select->where('atype_id = 2'); $select->where('account_id = ?', BLOGGER_ID); $arr = $db->fetchRow($select); $result['totaltrans'] = $arr['totaltrans']; $select = $db->select(); $select->from('article', array('count(*) totalresp')); $select->where('atype_id = 3'); $select->where('account_id = ?', BLOGGER_ID); $arr = $db->fetchRow($select); $result['totalresp'] = $arr['totalresp']; $comment = new Application_Model_CommentMapper(); $comment_info = $comment->findBloggerAritcleComment(BLOGGER_ID); $totalComment = count($comment_info); $result['totalcom'] = $totalComment; //获取博客访问量 //获取博主已访问过的ip $select = $db->select(); $select->from('view_statistic', 'ip'); $select->where('account_id = ?', BLOGGER_ID); $ips = $db->fetchAll($select); //获取当前访问ip include_once APPLICATION_PATH . '/../library/Cblog/RealIp.php'; $ipObj = new Cblog_RealIp(); $ip = $ipObj->getIp(); foreach ($ips as $arr) { if ($ip == $arr['ip']) { $status = "yes"; break; } } $select = $db->select(); $select->from('view_statistic', 'count(id) as totalview'); $select->where('account_id = ?', BLOGGER_ID); $totalViews = $db->fetchOne($select); //print_r($status); if (!isset($status)) { $viewstastic = new Application_Model_DbTable_ViewStatistic(); $viewstastic->addViewIp(BLOGGER_ID, $ip); $result['totalview'] = $totalViews + 1; } else { $result['totalview'] = $totalViews; } $cache->save($result, $id, array('aboutmebox')); } //print_r($result); $this->view->data = $result; }