joomla 跑马灯模块

<?php /** * Module Camp26 Scroll News For Joomla 1.5.x * Versi : 1.0 * Created by : Rony Sandra Yofa Zebua - Yarfik Ardiansyah- camp26.biz Team * License : http://www.gnu.org/copyleft/gpl.html GNU/GPL * Email : camp26team@gmail.com * Created on : 14 December 2008 * URL : http://www.camp26.biz * @version $Id: helper.php 10857 2008-08-30 06:41:16Z willebil $ * @package Joomla * @copyright Copyright (C) 2005 - 2008 Open Source Matters. All rights reserved. * @license GNU/GPL, see LICENSE.php * Joomla! is free software. This version may have been modified pursuant * to the GNU General Public License, and as distributed it includes or * is derivative of works licensed under the GNU General Public License or * other free or open source software licenses. * See COPYRIGHT.php for copyright notices and details. */ // no direct access defined('_JEXEC') or die('Restricted access'); require_once (JPATH_SITE.DS.'components'.DS.'com_content'.DS.'helpers'.DS.'route.php'); function limitscrollnews($txt,$limit) { $len=strlen($txt); if ($len <= $limit) return $txt; else { $txt = substr($txt,0,$limit); $pos = strrpos($txt," "); if($pos >0) { $txt = substr($txt,0,$pos); if (($tpos =strrpos($txt,"<")) > strrpos($txt,">") && $tpos>0) { $txt = substr($txt,0,$tpos-1); } } return $txt . "..."; } } class modCampScrollNewsHelper { function getList(&$params) { global $mainframe; $db =& JFactory::getDBO(); $user =& JFactory::getUser(); $userId = (int) $user->get('id'); $count = (int) $params->get('count', 5); $catid = trim( $params->get('catid') ); $secid = trim( $params->get('secid') ); $show_front = $params->get('show_front', 1); $aid = $user->get('aid', 0); $contentConfig = &JComponentHelper::getParams( 'com_content' ); $access = !$contentConfig->get('show_noauth'); $nullDate = $db->getNullDate(); $date =& JFactory::getDate(); $now = $date->toMySQL(); $where = 'a.state = 1' . ' AND ( a.publish_up = '.$db->Quote($nullDate).' OR a.publish_up <= '.$db->Quote($now).' )' . ' AND ( a.publish_down = '.$db->Quote($nullDate).' OR a.publish_down >= '.$db->Quote($now).' )' ; // User Filter switch ($params->get( 'user_id' )) { case 'by_me': $where .= ' AND (created_by = ' . (int) $userId . ' OR modified_by = ' . (int) $userId . ')'; break; case 'not_me': $where .= ' AND (created_by <> ' . (int) $userId . ' AND modified_by <> ' . (int) $userId . ')'; break; } // Ordering switch ($params->get( 'order_type' )) { case 1: $orderby = "a.created DESC"; break; case 2: $orderby = "a.created ASC"; break; case 3: $orderby = "a.hits DESC"; break; case 4: $orderby = "a.hits ASC"; break; case 5: $orderby = "a.ordering DESC"; break; case 6: $orderby = "a.ordering ASC"; break; case 0: default: $orderby = "RAND()"; break; } if ($catid) { $ids = explode( ',', $catid ); JArrayHelper::toInteger( $ids ); $catCondition = ' AND (cc.id=' . implode( ' OR cc.id=', $ids ) . ')'; } if ($secid) { $ids = explode( ',', $secid ); JArrayHelper::toInteger( $ids ); $secCondition = ' AND (s.id=' . implode( ' OR s.id=', $ids ) . ')'; } // Content Items only $query = 'SELECT a.*, ' . ' CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,'. ' CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug'. ' FROM #__content AS a' . ($show_front == '0' ? ' LEFT JOIN #__content_frontpage AS f ON f.content_id = a.id' : '') . ' INNER JOIN #__categories AS cc ON cc.id = a.catid' . ' INNER JOIN #__sections AS s ON s.id = a.sectionid' . ' WHERE '. $where .' AND s.id > 0' . ($access ? ' AND a.access <= ' .(int) $aid. ' AND cc.access <= ' .(int) $aid. ' AND s.access <= ' .(int) $aid : ''). ($catid ? $catCondition : ''). ($secid ? $secCondition : ''). ($show_front == '0' ? ' AND f.content_id IS NULL ' : ''). ' AND s.published = 1' . ' AND cc.published = 1' . ' ORDER BY '. $orderby; $db->setQuery($query, 0, $count); $rows = $db->loadObjectList(); $i = 0; $lists = array(); foreach ( $rows as $row ) { if($row->access <= $aid) { $lists[$i]->link = JRoute::_(ContentHelperRoute::getArticleRoute($row->slug, $row->catslug, $row->sectionid)); } else { $lists[$i]->link = JRoute::_('index.php?option=com_user&view=login'); } $lists[$i]->text = htmlspecialchars( $row->title ); $lists[$i]->introtext = htmlspecialchars( $row->introtext ); $lists[$i]->introtext = strip_tags($row->introtext,'<b></b><i><i>'); $lists[$i]->introtext = limitscrollnews($lists[$i]->introtext,200); $i++; } return $lists; } }