[3.1][3.2][BETA] ActiveUser - Конкурс на самого активного пользователя

[Sheer]

Включите debug после чего перейдите по ссылке SQL Explain внизу главной страницы форума и посмотрите время выполнения скриптов php и время выполнения sql-запросов. Выглядит примерно так

Screenshot_2019-09-22 SQL Report.png

[TomRX]

Сделал:

SQL Report

Page generated in 0.4666 seconds with 12 queries + 1 query returning data from cache

Time spent on mysqli queries: 0.01331s | Time spent on PHP: 0.45332s

Нужно всё сюда скопировать? Или нужно попытаться открыть страницу с таблицей ActiveUser и после этого посмотреть что будет написано в дебаге?

Отправлено спустя 7 минут 10 секунд:
Query #8

Код: Выделить всё

SELECT t.poster_id, t.forum_id, s.user_warnings, s.username, s.user_avatar_type, s.user_avatar, s.user_avatar_width, s.user_avatar_height, s.user_type, s.user_colour, s.user_lastvisit, s.user_regdate, s.user_id, COUNT(poster_id) as cnt
FROM phpbb3_posts AS t LEFT JOIN phpbb3_users AS s ON (s.user_id = t.poster_id)
WHERE post_time >= 1567270800
AND post_time <= 1569142671
AND user_warnings <= 2
AND group_id IN (2,3,7)
AND forum_id NOT IN (50,60)
GROUP BY poster_id
ORDER BY cnt DESC, rand()
LIMIT 7

Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE t range forum_id,poster_id forum_id 3 140747 Using index condition; Using where; Using temporary; Using filesort
1 SIMPLE s eq_ref PRIMARY PRIMARY 4 fr5243_fialki.t.poster_id 1 Using where

Before: 0.41314s | After: 6.69538s | Elapsed: 6.28224s

Отправлено спустя 6 минут 15 секунд:
Тормозит реально жутко, вот ссылка на страницу с таблицей https://fialka.tomsk.ru/forum/activeuser
Неделю назад этих тормозов не было.

[Michel]

Адаптировал под версию форума 3.3.5, запустил вроде всё робит нормально. Исправил иконки. В наличии только Русский язык.

saturnZ.rar

[1smerch1]

Michel, не работает php 8.1, ошибка:

Код: Выделить всё

[phpBB Debug] PHP Warning: in file [ROOT]/ext/saturnZ/activeuser/controller/activeuser.php on line 203: Trying to access array offset on value of type bool
[phpBB Debug] PHP Warning: in file [ROOT]/ext/saturnZ/activeuser/controller/activeuser.php on line 204: Trying to access array offset on value of type bool
[phpBB Debug] PHP Warning: in file [ROOT]/ext/saturnZ/activeuser/controller/activeuser.php on line 205: Trying to access array offset on value of type bool
[phpBB Debug] PHP Warning: in file [ROOT]/ext/saturnZ/activeuser/controller/activeuser.php on line 206: Trying to access array offset on value of type bool
[phpBB Debug] PHP Warning: in file [ROOT]/ext/saturnZ/activeuser/controller/activeuser.php on line 206: Trying to access array offset on value of type bool
[phpBB Debug] PHP Warning: in file [ROOT]/ext/saturnZ/activeuser/controller/activeuser.php on line 206: Trying to access array offset on value of type bool
[phpBB Debug] PHP Warning: in file [ROOT]/ext/saturnZ/activeuser/controller/activeuser.php on line 206: Trying to access array offset on value of type bool
[phpBB Debug] PHP Warning: in file [ROOT]/ext/sniper/mobiledevice/core/functions.php on line 358: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3008)
[phpBB Debug] PHP Warning: in file [ROOT]/ext/sniper/mobiledevice/core/functions.php on line 359: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3008)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4129: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3008)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4129: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3008)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4129: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3008)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4129: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3008)

Подскажите как исправить, очень нужное расширение.

Отправлено спустя 4 минуты 36 секунд:
Правда данные не удалял

Отправлено спустя 3 минуты 12 секунд:
Всего 2 расширения это и библиотека не работают должным образом.

Отправлено спустя 28 минут 9 секунд:
Ошибка в этих строчках:

Код: Выделить всё

$you_user_warnings = $row_You['user_warnings'];
			$you_group_id = $row_You['group_id'];
			$you_user_posts = $row_You['cnt'];
			$you_username = get_username_string((($row_You['user_type'] == USER_IGNORE) ? 'no_profile' : 'full'), $row_You['user_id'], $row_You['username'], $row_You['user_colour']);

[Siava]

1smerch1, попробуйте заменить на

Код: Выделить всё

$you_user_warnings = $row_You['user_warnings'] ?? 0;
			$you_group_id = $row_You['group_id'] ?? 0;
			$you_user_posts = $row_You['cnt'] ?? 0;
			$you_username = get_username_string((($row_You['user_type'] == USER_IGNORE) ? 'no_profile' : 'full'), $row_You['user_id'] ?? 0, $row_You['username'] ?? '', $row_You['user_colour'] ?? '');

[1smerch1]

Есть модуль для портала рабочий под версию 3.3.5?

[Michel]

Обновил один из старых форумов. Получил следующую ошибку:

Код: Выделить всё

[phpBB Debug] PHP Warning: in file [ROOT]/ext/saturnZ/activeuser/controller/activeuser.php on line 203: Trying to access array offset on value of type bool
[phpBB Debug] PHP Warning: in file [ROOT]/ext/saturnZ/activeuser/controller/activeuser.php on line 204: Trying to access array offset on value of type bool
[phpBB Debug] PHP Warning: in file [ROOT]/ext/saturnZ/activeuser/controller/activeuser.php on line 205: Trying to access array offset on value of type bool
[phpBB Debug] PHP Warning: in file [ROOT]/ext/saturnZ/activeuser/controller/activeuser.php on line 206: Trying to access array offset on value of type bool
[phpBB Debug] PHP Warning: in file [ROOT]/ext/saturnZ/activeuser/controller/activeuser.php on line 206: Trying to access array offset on value of type bool
[phpBB Debug] PHP Warning: in file [ROOT]/ext/saturnZ/activeuser/controller/activeuser.php on line 206: Trying to access array offset on value of type bool
[phpBB Debug] PHP Warning: in file [ROOT]/ext/saturnZ/activeuser/controller/activeuser.php on line 206: Trying to access array offset on value of type bool
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4191: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3076)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4191: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3076)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4191: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3076)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4191: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3076)

Версия phpBB: 3.3.14
Версия php: 8.4.4
Манипуляции с предложениями от Siava, не принесла результатов. Несколько ошибок исчезло, но не более того. Модуль на портал вообще отказался работать.

Отправлено спустя 41 секунду:
Что подскажите великие Гуру? Хорошее расширение...

[rxu]

Манипуляции с предложениями от Siava, не принесла результатов.

Эти ошибки уже после внесения правок?

[Michel]

Эти ошибки уже после внесения правок?

Вот ошибки после внесения правок!

Код: Выделить всё

[phpBB Debug] PHP Warning: in file [ROOT]/ext/saturnZ/activeuser/controller/activeuser.php on line 206: Trying to access array offset on false
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4191: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3076)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4191: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3076)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4191: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3076)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4191: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3076)

Отправлено спустя 5 минут 53 секунды:
Плюс шрифт ведёт себя неадекватно Увеличенный какой-то.

6666.jpg

[rxu]

Открыть /ext/saturnZ/activeuser/controller/activeuser.php,

НАЙТИ

Код: Выделить всё

	$row_You = $this->db->sql_fetchrow($res_You);
			$you_user_warnings = $row_You['user_warnings'];
			$you_group_id = $row_You['group_id'];
			$you_user_posts = $row_You['cnt'];
			$you_username = get_username_string((($row_You['user_type'] == USER_IGNORE) ? 'no_profile' : 'full'), $row_You['user_id'], $row_You['username'], $row_You['user_colour']);

if($you_user_posts)
{
				$this->template->assign_block_vars('you_user_posts', array(
	'NAME'			=> "$you_username",
	'POSTS'			=> "$you_user_posts",
	'MONTH'			=> "".$month_real_Array[$pmonth_real].":",
	'TEXT'			=> "".$this->user->lang['TEXT_YOU_POSTS_TRUE']."",
				));
}

ЗАМЕНИТЬ НА

Код: Выделить всё

if ($row_You = $this->db->sql_fetchrow($res_You))
{
	$you_user_warnings = $row_You['user_warnings'];
	$you_group_id = $row_You['group_id'];
	$you_user_posts = $row_You['cnt'];
	$you_username = get_username_string((($row_You['user_type'] == USER_IGNORE) ? 'no_profile' : 'full'), $row_You['user_id'], $row_You['username'], $row_You['user_colour']);

	$this->template->assign_block_vars('you_user_posts', array(
		'NAME'			=> "$you_username",
		'POSTS'			=> "$you_user_posts",
		'MONTH'			=> "".$month_real_Array[$pmonth_real].":",
		'TEXT'			=> "".$this->user->lang['TEXT_YOU_POSTS_TRUE']."",
	));
}

[Michel]

Открыть /ext/saturnZ/activeuser/controller/activeuser.php,

Отлично, вроде всё тип топ.
Теперь с блоком для портала. После включения происходит полный ахтунг

Код: Выделить всё

Fatal error: Uncaught ReflectionException: Class "board3\portal\modules\activeuser" does not exist in /var/www/123/data/www/site/vendor/symfony/dependency-injection/ContainerBuilder.php:1174 Stack trace: #0 /var/www/123/data/www/site/vendor/symfony/dependency-injection/ContainerBuilder.php(1174): ReflectionClass->__construct('board3\\portal\\m...') #1 /var/www/123/data/www/site/vendor/symfony/dependency-injection/ContainerBuilder.php(634): Symfony\Component\DependencyInjection\ContainerBuilder->createService(Object(Symfony\Component\DependencyInjection\Definition), Array, true, 'board3.portal.m...') #2 /var/www/123/data/www/site/vendor/symfony/dependency-injection/ContainerBuilder.php(588): Symfony\Component\DependencyInjection\ContainerBuilder->doGet('board3.portal.m...', 1) #3 /var/www/123/data/www/site/phpbb/di/service_collection.php(57): Symfony\Component\DependencyInjection\ContainerBuilder->get('board3.portal.m...') #4 /var/www/123/data/www/site/phpbb/di/service_collection_iterator.php(44): phpbb\di\service_collection->offsetGet('board3.portal.m...') #5 /var/www/123/data/www/site/ext/board3/portal/includes/helper.php(41): phpbb\di\service_collection_iterator->current() #6 /var/www/123/data/www/site/ext/board3/portal/includes/helper.php(29): board3\portal\includes\helper->register_modules(Object(phpbb\di\service_collection)) #7 [internal function]: board3\portal\includes\helper->__construct(Object(phpbb\di\service_collection)) #8 /var/www/123/data/www/site/vendor/symfony/dependency-injection/ContainerBuilder.php(1176): ReflectionClass->newInstanceArgs(Array) #9 /var/www/123/data/www/site/vendor/symfony/dependency-injection/ContainerBuilder.php(634): Symfony\Component\DependencyInjection\ContainerBuilder->createService(Object(Symfony\Component\DependencyInjection\Definition), Array, false, 'board3.portal.h...') #10 /var/www/123/data/www/site/vendor/symfony/dependency-injection/ContainerBuilder.php(1281): Symfony\Component\DependencyInjection\ContainerBuilder->doGet('board3.portal.h...', 1, Array, false) #11 /var/www/123/data/www/site/vendor/symfony/dependency-injection/ContainerBuilder.php(1238): Symfony\Component\DependencyInjection\ContainerBuilder->doResolveServices(Object(Symfony\Component\DependencyInjection\Reference), Array, false) #12 /var/www/123/data/www/site/vendor/symfony/dependency-injection/ContainerBuilder.php(1149): Symfony\Component\DependencyInjection\ContainerBuilder->doResolveServices(Array, Array, false) #13 /var/www/123/data/www/site/vendor/symfony/dependency-injection/ContainerBuilder.php(634): Symfony\Component\DependencyInjection\ContainerBuilder->createService(Object(Symfony\Component\DependencyInjection\Definition), Array, false, 'board3.portal.c...') #14 /var/www/123/data/www/site/vendor/symfony/dependency-injection/ContainerBuilder.php(1281): Symfony\Component\DependencyInjection\ContainerBuilder->doGet('board3.portal.c...', 1, Array, false) #15 /var/www/123/data/www/site/vendor/symfony/dependency-injection/ContainerBuilder.php(1238): Symfony\Component\DependencyInjection\ContainerBuilder->doResolveServices(Object(Symfony\Component\DependencyInjection\Reference), Array, false) #16 /var/www/123/data/www/site/vendor/symfony/dependency-injection/ContainerBuilder.php(1149): Symfony\Component\DependencyInjection\ContainerBuilder->doResolveServices(Array, Array, false) #17 /var/www/123/data/www/site/vendor/symfony/dependency-injection/ContainerBuilder.php(634): Symfony\Component\DependencyInjection\ContainerBuilder->createService(Object(Symfony\Component\DependencyInjection\Definition), Array, false, 'board3.portal.m...') #18 /var/www/123/data/www/site/vendor/symfony/dependency-injection/ContainerBuilder.php(1281): Symfony\Component\DependencyInjection\ContainerBuilder->doGet('board3.portal.m...', 1, Array, false) #19 /var/www/123/data/www/site/vendor/symfony/dependency-injection/ContainerBuilder.php(1238): Symfony\Component\DependencyInjection\ContainerBuilder->doResolveServices(Object(Symfony\Component\DependencyInjection\Reference), Array, false) #20 /var/www/123/data/www/site/vendor/symfony/dependency-injection/ContainerBuilder.php(1149): Symfony\Component\DependencyInjection\ContainerBuilder->doResolveServices(Array, Array, false) #21 /var/www/123/data/www/site/vendor/symfony/dependency-injection/ContainerBuilder.php(634): Symfony\Component\DependencyInjection\ContainerBuilder->createService(Object(Symfony\Component\DependencyInjection\Definition), Array, false, 'board3.portal.l...') #22 /var/www/123/data/www/site/vendor/symfony/dependency-injection/ContainerBuilder.php(1281): Symfony\Component\DependencyInjection\ContainerBuilder->doGet('board3.portal.l...', 1, Array, false) #23 /var/www/123/data/www/site/vendor/symfony/dependency-injection/ContainerBuilder.php(1231): Symfony\Component\DependencyInjection\ContainerBuilder->doResolveServices(Object(Symfony\Component\DependencyInjection\Reference)) #24 /var/www/123/data/www/site/vendor/symfony/dependency-injection/ContainerBuilder.php(1243): Symfony\Component\DependencyInjection\ContainerBuilder->resolveServices(Object(Symfony\Component\DependencyInjection\Reference)) #25 /var/www/123/data/www/site/vendor/symfony/event-dispatcher/EventDispatcher.php(231): Symfony\Component\DependencyInjection\ContainerBuilder->{closure:Symfony\Component\DependencyInjection\ContainerBuilder::doResolveServices():1242}() #26 /var/www/123/data/www/site/vendor/symfony/event-dispatcher/EventDispatcher.php(61): Symfony\Component\EventDispatcher\EventDispatcher->sortListeners('core.user_setup') #27 /var/www/123/data/www/site/vendor/symfony/event-dispatcher/EventDispatcher.php(43): Symfony\Component\EventDispatcher\EventDispatcher->getListeners('core.user_setup') #28 /var/www/123/data/www/site/phpbb/event/dispatcher.php(62): Symfony\Component\EventDispatcher\EventDispatcher->dispatch('core.user_setup', Object(phpbb\event\data)) #29 /var/www/123/data/www/site/phpbb/event/dispatcher.php(46): phpbb\event\dispatcher->dispatch('core.user_setup', Object(phpbb\event\data)) #30 /var/www/123/data/www/site/phpbb/user.php(232): phpbb\event\dispatcher->trigger_event('core.user_setup', Array) #31 /var/www/123/data/www/site/adm/index.php(31): phpbb\user->setup('acp/common') #32 {main} thrown in /var/www/123/data/www/site/vendor/symfony/dependency-injection/ContainerBuilder.php on line 1174

После обновления страницы получаем следующее:

Код: Выделить всё

Fatal error: Uncaught Error: Class "board3\portal\modules\activeuser" not found in /var/www/123/data/www/site/cache/production/container_dbdbe80dc7030ae9bd39ee30cca82130.php:1409 Stack trace: #0 /var/www/123/data/www/site/vendor/symfony/dependency-injection/Container.php(306): phpbb_cache_container->getBoard3_Portal_Module_ActiveuserService() #1 /var/www/123/data/www/site/phpbb/di/service_collection.php(57): Symfony\Component\DependencyInjection\Container->get('board3.portal.m...') #2 /var/www/123/data/www/site/phpbb/di/service_collection_iterator.php(44): phpbb\di\service_collection->offsetGet('board3.portal.m...') #3 /var/www/123/data/www/site/ext/board3/portal/includes/helper.php(41): phpbb\di\service_collection_iterator->current() #4 /var/www/123/data/www/site/ext/board3/portal/includes/helper.php(29): board3\portal\includes\helper->register_modules(Object(phpbb\di\service_collection)) #5 /var/www/123/data/www/site/cache/production/container_dbdbe80dc7030ae9bd39ee30cca82130.php(1379): board3\portal\includes\helper->__construct(Object(phpbb\di\service_collection)) #6 /var/www/123/data/www/site/cache/production/container_dbdbe80dc7030ae9bd39ee30cca82130.php(1359): phpbb_cache_container->getBoard3_Portal_HelperService() #7 /var/www/123/data/www/site/cache/production/container_dbdbe80dc7030ae9bd39ee30cca82130.php(1399): phpbb_cache_container->getBoard3_Portal_ControllerHelperService() #8 /var/www/123/data/www/site/cache/production/container_dbdbe80dc7030ae9bd39ee30cca82130.php(1389): phpbb_cache_container->getBoard3_Portal_MainService() #9 /var/www/123/data/www/site/cache/production/container_dbdbe80dc7030ae9bd39ee30cca82130.php(2732): phpbb_cache_container->getBoard3_Portal_ListenerService() #10 /var/www/123/data/www/site/vendor/symfony/event-dispatcher/EventDispatcher.php(231): phpbb_cache_container->{closure:phpbb_cache_container::getDispatcherService():2731}() #11 /var/www/123/data/www/site/vendor/symfony/event-dispatcher/EventDispatcher.php(61): Symfony\Component\EventDispatcher\EventDispatcher->sortListeners('core.user_setup') #12 /var/www/123/data/www/site/vendor/symfony/event-dispatcher/EventDispatcher.php(43): Symfony\Component\EventDispatcher\EventDispatcher->getListeners('core.user_setup') #13 /var/www/123/data/www/site/phpbb/event/dispatcher.php(62): Symfony\Component\EventDispatcher\EventDispatcher->dispatch('core.user_setup', Object(phpbb\event\data)) #14 /var/www/123/data/www/site/phpbb/event/dispatcher.php(46): phpbb\event\dispatcher->dispatch('core.user_setup', Object(phpbb\event\data)) #15 /var/www/123/data/www/site/phpbb/user.php(232): phpbb\event\dispatcher->trigger_event('core.user_setup', Array) #16 /var/www/123/data/www/site/adm/index.php(31): phpbb\user->setup('acp/common') #17 {main} thrown in /var/www/123/data/www/site/cache/production/container_dbdbe80dc7030ae9bd39ee30cca82130.php on line 1409

[rxu]

Теперь с блоком для портала.

Что это и где его код?

[Michel]

Что это и где его код?

Конкурс.rar

[rxu]

Конкурс.rar

Из этого архива, что и куда копируете? Файл board3\portal\modules\activeuser.php существует?

[Michel]

Из этого архива, что и куда копируете? Файл board3\portal\modules\activeuser.php существует?

Да, это я виноват. При обновлении портала удалил файлы, а заново не залил от расширения. Старею...
В общем залил файлы, получил следующие ошибки но форум запустился:

Код: Выделить всё

[phpBB Debug] PHP Warning: in file [ROOT]/ext/board3/portal/modules/activeuser.php on line 381: Undefined variable $date_ab
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4191: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3076)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4191: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3076)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4191: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3076)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4191: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3076)

Файлы для портала:

portal.rar