public function contestmoreAction() { $uid = Zend_Registry::get('uid'); $id = $this->_request->getParam('id'); $this->view->dugaar = $id; $q = $this->_request->getParam('q'); if ($q == 'signup') { $this->view->is = 'signup'; } if ($q == 'rating') { $this->view->is = 'rating'; } if ($q == 'davaa') { $this->view->is = 'davaa'; } $tmp = 0; $davaas = new Model_DbTable_Davaa(); $this->view->davaa = $davaas->fetchAll($davaas->select()->where('fantasy_id =' . $id . ' AND active =' . $tmp)); $tmp = 1; $this->view->davaaduussan = $davaas->fetchAll($davaas->select()->where('fantasy_id =' . $id . ' AND active =' . $tmp)); $fantasys = new Model_DbTable_Fantasy(); $fantasy = $fantasys->fetchAll($fantasys->select()->where('id=' . $id)); foreach ($fantasy as $key => $value) { $this->view->fantasyname = $value['name']; } $users = new Model_DbTable_Users(); $this->view->user = $users->fetchAll($users->select()); $gals = new Model_DbTable_Gal(); $this->view->galuud = $gals->fetchAll($gals->select()); $this->view->gal = $gals->fetchAll($gals->select()->where('ezen_id =' . $uid)); $gald = $gals->fetchAll($gals->select()->where('ezen_id =' . $uid)); $gid = 0; foreach ($gald as $key => $value) { $gid = $value['id']; } $scores = new Model_DbTable_Score(); $this->view->rating = $scores->fetchAll($scores->select()->where('fantasyid =' . $id)->order('total_score DESC')); $this->view->score = $scores->fetchAll($scores->select()->where('galid =' . $gid . ' AND fantasyid=' . $id)); $form = new Form_Comment(); $request = $this->getRequest(); if ($request->isPost()) { if ($form->isValid($this->_request->getPost())) { $content = $this->_request->getParam('commentbody'); $content = $this->check($content); $uid = Zend_Registry::get('uid'); $date = date("Y-m-d H:i:s"); $uri = 'index/index/id/' . $id; $comments = new Model_DbTable_Comment(); $comments->insert(array('uri' => $uri, 'content' => $content, 'uid' => $uid, 'date' => $date)); $this->_redirect('news/more/id/' . $id); } } $form->setAction('../../index/index'); $this->view->form = $form; $news = new Model_DbTable_News(); $this->view->news = $news->fetchAll($news->select()->where('isactive = 1')->order('isping DESC')->order('date DESC')); $this->view->news1 = $news->fetchAll($news->select()->where('isactive = 0')->order('date DESC')); $page = 0; if ($this->_request->getParam("page") != null) { $page = $this->_request->getParam("page"); } $this->view->page = $page; $q = $news->fetchAll($news->select()->where('isactive = 1')->order('isping DESC')->order('date DESC')); $id = $this->_request->getParam('id'); $this->view->dugaar = $id; $paginator = Zend_Paginator::factory($q); $paginator->setItemCountPerPage("6")->setCurrentPageNumber($this->_getParam('page', 1)); $this->view->medee = $paginator; $comments = new Model_DbTable_Comment(); $this->view->comment = $comments->fetchAll($comments->select()->order('date DESC')); }
public function moreAction() { $id = $this->_request->getParam('id'); $this->view->iid = $id; $news = new Model_DbTable_News(); $this->view->news = $news->fetchAll($news->select()->where('id = ' . $id . ' AND isactive = 1')); }