$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);
$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';