Файловый менеджер - Редактировать - /var/www/html/modules/mod_community_discussions/helper.php
Ðазад
<?php /** * @copyright (C) 2013 iJoomla, Inc. - All rights reserved. * @license GNU General Public License, version 2 (http://www.gnu.org/licenses/gpl-2.0.html) * @author iJoomla.com <webmaster@ijoomla.com> * @url https://www.jomsocial.com/license-agreement * The PHP code portions are distributed under the GPL license. If not otherwise stated, all images, manuals, cascading style sheets, and included JavaScript *are NOT GPL, and are released under the IJOOMLA Proprietary Use License v1.0 * More info at https://www.jomsocial.com/license-agreement */ defined('_JEXEC') or die('Restricted access'); if(!class_exists('modCommunityDiscussions')) { class modCommunityDiscussions { var $db; var $limit; var $filter; var $groups; function __construct( $params ) { $this->db = JFactory::getDBO(); $this->limit = $params->get( 'limit' , 10 ); $this->filter = $params->get( 'displaysetting', 0 ); $this->groups = $params->get('jsgroup', array()); $this->show_avatar = $params->get('show_avatar', 0); } function getDiscussion($showPrivateDiscussion = TRUE) { $filter = ''; if($this->filter == 2){ //type 2 is group specific if(empty($this->groups)){ return array(); } $groups = implode(',', $this->groups); $filter = ' AND g.id IN('.$groups.') '; }elseif($this->filter == 1){ //1 = show own discussion only $my = JFactory::getUser(); $filter = ' AND a.creator = '.$this->db->quote($my->id).' '; } $privacyCondition = ' '; if(empty($showPrivateDiscussion)) { $privacyCondition = ' AND g.approvals = ' . $this->db->quote('0') . ' '; } $sql = 'SELECT a. * , count( b.id ) AS counter, c.name AS username ' . 'FROM ' . $this->db->quoteName( '#__community_groups_discuss' ) . ' AS a ' . 'INNER JOIN ' . $this->db->quoteName( '#__users' ) . ' AS c ON a.creator = c.id ' . 'LEFT JOIN ' . $this->db->quoteName( '#__community_wall' ) . ' AS b ON b.contentid = a.id ' . 'AND b.type = ' . $this->db->Quote('discussions') . ' ' . 'AND a.parentid = ' . $this->db->Quote('0'). ' ' . 'INNER JOIN ' . $this->db->quoteName('#__community_groups') . 'AS g ON g.id = a.groupid ' . 'WHERE g.published = ' . $this->db->quote('1') . ' ' . $privacyCondition . $filter . 'GROUP BY a.id ' . 'ORDER BY a.created DESC ' . 'LIMIT ' . $this->limit; $query = $this->db->setQuery($sql); try { $row = $this->db->loadObjectList(); } catch (Exception $e) { JFactory::getApplication()->enqueueMessage($e->getMessage(), 'error'); } return $row; } function getGroupName($id) { $sql ='SELECT name ' . 'FROM ' . $this->db->quoteName( '#__community_groups' ) . ' ' . 'WHERE ' . $this->db->quoteName( 'id' ) . ' = ' . $this->db->quote( $id ); $query = $this->db->setQuery($sql); try { $row = $this->db->loadObject(); } catch (Exception $e) { JFactory::getApplication()->enqueueMessage($e->getMessage(), 'error'); } return $row->name; } } }
| ver. 1.1 | |
.
| PHP 8.4.18 | Ð“ÐµÐ½ÐµÑ€Ð°Ñ†Ð¸Ñ Ñтраницы: 0 |
proxy
|
phpinfo
|
ÐаÑтройка