Файловый менеджер - Редактировать - /var/www/html/administrator/components/com_komento/models/users.php
Ðазад
<?php /** * @package Komento * @copyright Copyright (C) Stack Ideas Sdn Bhd. All rights reserved. * @license GNU/GPL, see LICENSE.php * Komento 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. */ defined('_JEXEC') or die('Unauthorized Access'); class KomentoModelUsers extends KomentoModel { protected $element = 'users'; protected $_total = null; protected $_pagination = null; protected $_data = null; public function __construct($config = []) { parent::__construct($config); $app = JFactory::getApplication(); $limit = $this->app->getUserStateFromRequest('com_komento.users.limit', 'limit', $app->getCfg('list_limit')); $limitstart = $this->input->get('limitstart', 0, 'int'); $this->setState('limit', $limit); $this->setState('limitstart', $limitstart); } /** * Retrieves a list of registered user from Joomla * * @since 3.1.4 * @access public */ public function getUsers($options = array()) { if (empty($this->_data)) { $query = $this->buildQuery($options); $this->_data = $this->_getList($query, $this->getState('limitstart'), $this->getState('limit')); } return $this->_data; } /** * Method to build the query for the users * * @since 3.1.4 * @access public */ public function buildQuery($options = []) { $db = KT::db(); $filter_order = $this->app->getUserStateFromRequest('com_komento.users.filter_order', 'filter_order', 'u.`id`', 'cmd'); $filter_order_Dir = $this->app->getUserStateFromRequest('com_komento.users.filter_order_Dir', 'filter_order_Dir', 'DESC', 'word'); $search = $this->app->getUserStateFromRequest('com_komento.users.search', 'search', '', 'string'); // if there is search passed in, use that $search = isset($options['search']) ? $options['search'] : $search; $search = trim(FCJString::strtolower($search)); $search = $db->escape($search); $query = "SELECT u.`id`, u.`name`, u.`username`, u.`email`, u.`registerDate`, u.`lastvisitDate` FROM " . $db->nameQuote('#__users') . " AS u WHERE 1"; if ($search) { if (stripos($search, 'id:') === 0) { $query .= ' AND u.`id` = ' . (int) substr($search, 3); } else { $query .= ' AND ((LOWER(u.`name`) LIKE ' . $db->Quote('%' . $search . '%') . ') OR (LOWER(u.`username`) LIKE ' . $db->Quote('%' . $search . '%') . '))'; } } $exclusion = isset($options['exclusion']) ? $options['exclusion'] : []; if ($exclusion) { $exclusionIds = array(); foreach ($exclusion as $exclusionId) { $exclusionIds[] = $db->Quote($exclusionId); } $exclusionIds = implode(',', $exclusionIds); $query .= ' AND u.`id` NOT IN (' . $exclusionIds . ')'; } $query .= " ORDER BY " . $filter_order . ' ' . $filter_order_Dir; return $query; } public function getPagination() { if (empty($this->_pagination)) { $this->_pagination = KT::pagination($this->getTotal(), $this->getState('limitstart'), $this->getState('limit')); } return $this->_pagination; } public function getTotal() { if (empty($this->_total)) { $query = $this->buildQuery(); $this->_total = $this->_getListCount($query); } return $this->_total; } /** * Retrieves a list of users for mention * * @since 4.0 * @access public */ public function getMentionUsers($options = array()) { if (empty($this->_data)) { $query = $this->buildQuery($options); $this->_data = $this->_getList($query); } return $this->_data; } /** * Retrieves the user's id * * @since 4.0 * @access public */ public function getUserId($key , $value) { $db = KT::db(); $sql = $db->sql(); $sql->select('#__users'); $sql->column('id'); $sql->where($key, $value); $db->setQuery($sql); $id = $db->loadResult(); return $id; } /** * Determines if a user exceeded their moderation threshold so they won't be moderated again. * * @since 4.0 * @access public */ public function exceededModerationThreshold($userId, $limit) { $db = $this->db; $query = array(); $query[] = 'SELECT COUNT(1) as `CNT` FROM `#__komento_comments` AS a'; $query[] = ' WHERE a.`created_by` = ' . $db->Quote($userId); $query[] = ' AND a.`published` = ' . $db->Quote('1'); $query = implode(' ', $query); $db->setQuery($query); $result = $db->loadResult(); if ($result >= $limit) { return true; } return false; } }
| ver. 1.1 | |
.
| PHP 8.4.18 | Ð“ÐµÐ½ÐµÑ€Ð°Ñ†Ð¸Ñ Ñтраницы: 0 |
proxy
|
phpinfo
|
ÐаÑтройка