Файловый менеджер - Редактировать - /var/www/html/libraries/kunena/src/User/KunenaUserFinder.php
Ðазад
<?php /** * Kunena Component * * @package Kunena.Framework * @subpackage User * * @copyright Copyright (C) 2008 - @currentyear@ Kunena Team. All rights reserved. * @license https://www.gnu.org/copyleft/gpl.html GNU/GPL * @link https://www.kunena.org **/ namespace Kunena\Forum\Libraries\User; \defined('_JEXEC') or die(); use Exception; use Joomla\CMS\Date\Date; use Kunena\Forum\Libraries\Config\KunenaConfig; use Kunena\Forum\Libraries\Database\Finder\KunenaFinder; use Joomla\CMS\Factory; /** * Class \Kunena\Forum\Libraries\User\KunenaUserFinder * * @since Kunena 6.0 */ class KunenaUserFinder extends KunenaFinder { /** * @var string * @since Kunena 6.0 */ protected $table = '#__users'; /** * @var KunenaConfig|mixed * @since Kunena 6.0 */ protected $config; /** * Constructor. * * @since Kunena 6.0 * * @throws Exception */ public function __construct() { parent::__construct(); $this->config = KunenaConfig::getInstance(); $this->limit = $this->config->userlistRows; $this->query->leftJoin($this->db->quoteName('#__kunena_users', 'ku') . ' ON ' . $this->db->quoteName('ku.userid') . ' = ' . $this->db->quoteName('a.id')); } /** * Filter by time, either on registration or last visit date. * * @param Date|null $starting Starting date or null if older than ending date. * @param Date|null $ending Ending date or null if newer than starting date. * @param bool $register True = registration date, False = last visit date. * * @return $this * * @since Kunena 6.0 */ public function filterByTime(?Date $starting = null, ?Date $ending = null, $register = true): KunenaFinder { $name = $register ? 'registerDate' : 'lastvisitDate'; if ($starting && $ending) { $this->query->where($this->db->quoteName('a.' . $name) . ' BETWEEN ' . $this->db->quote($starting->toUnix()) . ' AND ' . $this->db->quote($ending->toUnix())); } elseif ($starting) { $this->query->where($this->db->quoteName('a.' . $name) . ' > ' . $this->db->quote($starting->toUnix())); } elseif ($ending) { $this->query->where($this->db->quoteName('a.' . $name) . ' <= ' . $this->db->quote($ending->toUnix())); } return $this; } /** * @param array $ignore ignore * * @return $this * * @since Kunena 6.0 */ public function filterByConfiguration(array $ignore = []): KunenaFinder { if ($this->config->userlistCountUsers == '1') { $this->query->where('(' . $this->db->quoteName('a.block') . ' = 0 OR ' . $this->db->quoteName('a.activation') . '="")'); } elseif ($this->config->userlistCountUsers == '2') { $this->query->where('(' . $this->db->quoteName('a.block') . ' = 0 AND ' . $this->db->quoteName('a.activation') . '="")'); } elseif ($this->config->userlistCountUsers == '3') { $this->query->where($this->db->quoteName('a.block') . ' = 0'); } // Hide super admins from the list if ($this->config->superAdminUserlist && $ignore) { $this->query->where($this->db->quoteName('a.id') . ' NOT IN (' . implode(',', $ignore) . ')'); } return $this; } /** * @param string $search search * * @return $this * * @since Kunena 6.0 */ public function filterByName(string $search): KunenaFinder { $search = '%' . $search . '%'; if ($search) { if ($this->config->username) { $this->query->where($this->db->quoteName('a.username') . ' LIKE ' . $this->db->quote($search)); } else { $this->query->where($this->db->quoteName('a.name') . ' LIKE ' . $this->db->quote($search)); } } return $this; } /** * Filter the users by type (banned, admin, moderator...) * * @param string $usertype Set the type of user to filter * * @return $this * * @since Kunena 7.0.0 */ public function filterByUserType(string $usertype): KunenaFinder { $dateNow = Factory::getDate()->toSql(); // Select users banned if ($usertype == 'banned') { $this->query->where($this->db->quoteName('ku.banned') . ' != ' . $this->db->quote('1000-01-01 00:00:00') . ' OR ' . $this->db->quoteName('ku.banned') . '>=' . $this->db->quote($dateNow)); } elseif ($usertype == 'globalmod') { $this->query->where($this->db->quoteName('ku.moderator') . ' =1 '); } elseif ($usertype == 'user') { $this->query->where($this->db->quoteName('ku.moderator') . ' =0'); $this->query->where('(' . $this->db->quoteName('ku.banned') . ' = ' . $this->db->quote('1000-01-01 00:00:00') . ' OR ' . $this->db->quoteName('ku.banned') . '<=' . $this->db->quote($dateNow) . ')'); $this->query->innerJoin('#__user_usergroup_map AS uum', 'ku.userid=uum.user_id'); $this->query->where($this->db->quoteName('uum.group_id') . ' !=8'); } return $this; } /** * Get users. * * @return array * * @since Kunena 6.0 * * @throws \Exception */ public function find(): array { $results = parent::find(); return KunenaUserHelper::loadUsers($results); } }
| ver. 1.1 | |
.
| PHP 8.4.18 | Ð“ÐµÐ½ÐµÑ€Ð°Ñ†Ð¸Ñ Ñтраницы: 0 |
proxy
|
phpinfo
|
ÐаÑтройка