|
From: Eloi G. <ada...@us...> - 2008-10-08 17:11:36
|
Update of /cvsroot/phpwebsite-comm/modules/phpwsbb/class In directory ddv4jf1.ch3.sourceforge.com:/tmp/cvs-serv17831/class Modified Files: BB_Lists.php Log Message: Corrected minor bugs Index: BB_Lists.php =================================================================== RCS file: /cvsroot/phpwebsite-comm/modules/phpwsbb/class/BB_Lists.php,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** BB_Lists.php 12 Sep 2008 07:12:03 -0000 1.2 --- BB_Lists.php 8 Oct 2008 17:11:22 -0000 1.3 *************** *** 174,254 **** } - /** - * Searches the comments stored in the database - * - * @author Eloi George <el...@NO...> - * @module Article Manager - * @param none - * @return none - */ - public function search_comments ($type, $var = null) - { - /* Create DBPager object */ - PHPWS_Core::initCoreClass('DBPager.php'); - Layout::addStyle('comments'); - - $pager = new DBPager('comments_items'); - $pager->setModule('phpwsbb'); - $pager->setTemplate('search_posts.tpl'); - $pager->setCacheIdentifier('search_'.$type); - $pager->cacheQueries(); - $pager->setDefaultOrder('create_time', 'desc'); - $pager->setDefaultLimit(30); - $pager->setLimitList(array(30,60,90)); - $pager->setEmptyMessage(dgettext('phpwsbb', 'No posts were found.')); - $pager->addToggle(' toggle1"'); - $pager->addToggle(' toggle2"'); - $pager->addRowFunction(array('PHPWSBB_Lists', 'getCommentTpl')); - $pager->setSearch('title'); - - /* Modify WHERE clause to the desired list type */ - switch ($type) { - case 'userposts': - $pager->addWhere('author_id', $var); - break; - } - $pager->db->addColumn('comments_items.*'); - $pager->db->addColumn('phpws_key.title', null, 'topic_title'); - $pager->db->addColumn('phpws_key.times_viewed', null, 'times_viewed'); - $pager->db->addColumn('phpwsbb_forums.title', null, 'forum_title'); - $pager->db->addColumn('phpwsbb_forums.id', null, 'forum_id'); - $pager->db->addColumn('phpwsbb_topics.total_posts', null, 'total_posts'); - $pager->addWhere('approved', 1); - $pager->db->addWhere('phpws_key.id', 'phpwsbb_topics.key_id'); - $pager->db->addWhere('phpwsbb_topics.id', 'comments_items.thread_id'); - if(!Current_User::allow('phpwsbb', 'manage_forums')) { - $pager->db->addWhere('phpwsbb_forums.id', 'phpwsbb_topics.fid'); - $pager->db->addWhere('phpwsbb_forums.id', PHPWSBB_Data::get_forum_ids()); - } - $pager->addSortHeader('phpws_key.title', dgettext('phpwsbb', 'Topic')); - $pager->addSortHeader('phpwsbb_forums.title', dgettext('phpwsbb', 'In Forum')); - $pager->addSortHeader('create_time', dgettext('phpwsbb', 'Date')); - $pager->table_columns[] = 'phpws_key.title'; - $pager->table_columns[] = 'phpwsbb_forums.title'; - - return $pager->get(); - } - - public function getCommentTpl($data) { - $thread = new Comment_Thread; - $comment = new Comment_Item; - PHPWS_Core::plugObject($comment, $data); - $tpl = $comment->getTpl($thread); - $tpl['TOPIC_ID'] = $data['thread_id']; - $tpl['TOPIC_TITLE'] = $data['topic_title']; - $tpl['TOPIC_LBL'] = dgettext('phpwsbb', 'In Topic'); - $tpl['TOPIC_LINK'] = PHPWS_Text::rewriteLink($data['topic_title'], 'phpwsbb', array('view'=>'topic', 'id'=>$data['thread_id'])); - $tpl['FORUM_ID'] = $data['forum_id']; - $tpl['FORUM_TITLE'] = $data['forum_title']; - $tpl['FORUM_LBL'] = dgettext('phpwsbb', 'In Forum'); - $tpl['FORUM_LINK'] = PHPWS_Text::rewriteLink($data['forum_title'], 'phpwsbb', array('view'=>'forum', 'id'=>$data['forum_id'])); - $tpl['REPLY_LBL'] = dgettext('phpwsbb', 'Replies'); - $tpl['REPLIES'] = $data['total_posts'] - 1; - $tpl['VIEWS_LBL'] = dgettext('phpwsbb', 'Views'); - $tpl['TOTAL_VIEWS'] = $data['times_viewed']; - - return $tpl; - } - } ?> \ No newline at end of file --- 174,177 ---- |