// Data
$news = $newsDb->getAllWithDescById($id, $this->_languageId);
// $author = $newsDb->getAuthor($id,$this->_languageId)->toArray();
// $authorName = (empty($author))? '' : $author['name'];
//if content is empty, will be redirecting to list of news
if ($news['content']) {
//update viewer
//hanya increamen 1 saja setiap kali content detaul di load
// $newsDb->updateField($id,array('viewer'=>$news['viewer']+1));
// View
$this->view->news = $news;
$this->view->id = $id;
// $this->view->author = $authorName;
} else {
$this->_redirector->gotoUrl($this->view->baseUrl('/news/index/'));
}
}
/**
* IS : -
* FS : -
* Desc : controller untuk ! form
*/
/**
* IS: -
* FS: -
* Desc: Fungsi untuk generate RSS
*/
public function rssAction()
{
// Tidak pake layout
//$this->getResponse()->setHeader('Content-Type', 'text/xml');
$this->_helper->layout->disableLayout();
// Model
$newsDb = new Model_DbTable_News();
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'));
}
