Example #1
0
     $jieqiTpl->assign('url_allreview', $article_dynamic_url . '/reviews.php?aid=' . $article->getVar('articleid') . '&type=all');
     $jieqiTpl->assign('url_review', $article_dynamic_url . '/reviews.php?aid=' . $article->getVar('articleid'));
 } elseif ($jieqiConfigs['article']['reviewtype'] == 2) {
     $query = JieqiQueryHandler::getInstance('JieqiQueryHandler');
     $criteria = new CriteriaCompo(new Criteria('t.ownerid', $article->getVar('articleid')));
     $criteria->add(new Criteria('p.istopic', 1));
     $criteria->setTables(jieqi_dbprefix('article_reviews') . ' t LEFT JOIN ' . jieqi_dbprefix('article_replies') . ' p ON t.topicid=p.topicid');
     $criteria->setSort('t.istop DESC, t.topicid');
     $criteria->setOrder('DESC');
     $criteria->setLimit($jieqiConfigs['article']['reviewnew']);
     $criteria->setStart(0);
     $query->queryObjects($criteria);
     $reviewrows = array();
     $k = 0;
     while ($v = $query->getObject()) {
         $reviewrows[$k] = jieqi_topic_vars($v);
         $k++;
     }
     /*
     $sql="SELECT * FROM ".jieqi_dbprefix('article_userchap')." WHERE articleid=".jieqi_dbslashes($article->getVar('articleid', 'n'))." ORDER BY userchapid DESC LIMIT 0, ".intval($jieqiConfigs['article']['userchapnew']);
     		$ret=$query->execute($sql);
     		
     include_once($jieqiModules['article']['path'].'/class/reviews.php');
     include_once(JIEQI_ROOT_PATH.'/lib/text/textfunction.php');
     
     $reviews_handler =& JieqiReviewsHandler::getInstance('JieqiReviewsHandler');
     $criteria=new CriteriaCompo(new Criteria('ownerid',  $article->getVar('articleid')));
     $criteria->setSort('istop DESC, topicid');
     $criteria->setOrder('DESC');
     $criteria->setLimit($jieqiConfigs['article']['reviewnew']);
     $criteria->setStart(0);
Example #2
0
    $jieqiTpl->assign('type', 'all');
}
//页码
include_once JIEQI_ROOT_PATH . '/include/funpost.php';
if (empty($_REQUEST['page']) || !is_numeric($_REQUEST['page'])) {
    $_REQUEST['page'] = 1;
}
if (empty($jieqiConfigs['system']['ptopicpnum'])) {
    $jieqiConfigs['system']['ptopicpnum'] = 20;
}
$criteria->setSort('topicid');
$criteria->setOrder('DESC');
$criteria->setLimit($jieqiConfigs['system']['ptopicpnum']);
$criteria->setStart(($_REQUEST['page'] - 1) * $jieqiConfigs['system']['ptopicpnum']);
$query->queryObjects($criteria);
$ptopicrows = array();
$k = 0;
while ($v = $query->getObject()) {
    $ptopicrows[$k] = jieqi_topic_vars($v);
    $ptopicrows[$k]['ownername'] = strlen($v->getVar('name')) == 0 ? $v->getVar('uname') : $v->getVar('name');
    $k++;
}
$jieqiTpl->assign_by_ref('ptopicrows', $ptopicrows);
//处理页面跳转
include_once JIEQI_ROOT_PATH . '/lib/html/page.php';
$jumppage = new JieqiPage($query->getCount($criteria), $jieqiConfigs['system']['ptopicpnum'], $_REQUEST['page']);
$jumppage->setlink('', true, true);
$jieqiTpl->assign('url_jumppage', $jumppage->whole_bar());
$jieqiTpl->setCaching(0);
$jieqiTset['jieqi_contents_template'] = JIEQI_ROOT_PATH . '/templates/ptopiclist.html';
include_once JIEQI_ROOT_PATH . '/footer.php';