Material Admin

[v1.1.5.4] Material Admin - рефорк SB++ 1.5.4.7

Морковка

Котлетка ^^
Сообщения
664
Реакции
332
пару раз бывало, когда падала база mssql терялось подключение к бд
после восстановления подключения, MA не подключения обратно
но подключается моментально если выполнить команду ma_bd_connect
как можно это автоматизировать
можно ли в конфиг сделать настройку чтобы после потери подключения к бд, чтобы раз в x время команда ma_bd_connect проскакивала
 

Mury0nych

Участник
Сообщения
145
Реакции
13
Добавил сервер в MaterilAdmin, работает на VDS под управлением Pterodactyl, пишет: Ошибка, нет соединения.
Хотя онлайн сервера и т.д. показывает.
 

Kruzya

Rust как смысл жизни
Сообщения
12,385
Реакции
10,473
  • Команда форума
  • Автор ресурса
  • #8,824
@Mury0nych, очень информативно (нет).
"Ошибку соединения" пишет где? В списке серверов или где?
 

Mury0nych

Участник
Сообщения
145
Реакции
13
@Mury0nych, очень информативно (нет).
"Ошибку соединения" пишет где? В списке серверов или где?
Извиняюсь.
Ошибку пишет при добавлении кого-то в админы именно на этот сервер или же когда пытаюсь обновить Кэш администраторов.
 

Kruzya

Rust как смысл жизни
Сообщения
12,385
Реакции
10,473
  • Команда форума
  • Автор ресурса
  • #8,826
RCON включен (требуется только для CS:GO; в параметрах должен быть -usercon)? TCP-порт открыт? Мониторинг по UDP ходит целиком, ркон - по TCP.
 

s3w3r

Участник
Сообщения
5
Реакции
0
L 08/08/2022 - 21:38:53: [admin-flatfile.smx] (line 39) Invalid flag detected: :
L 08/08/2022 - 21:38:53: [admin-flatfile.smx] (line 39) Failed to bind identity STEAM_0 (method steam)
L 08/08/2022 - 21:38:53: [admin-flatfile.smx] Error(s) detected parsing addons/sourcemod/configs/admins_simple.ini
L 08/08/2022 - 21:38:53: [admin-flatfile.smx] (line 39) Invalid flag detected: :
L 08/08/2022 - 21:38:53: [admin-flatfile.smx] (line 39) Failed to bind identity STEAM_0 (method steam)
L 08/08/2022 - 21:41:08: [admin-flatfile.smx] Error(s) detected parsing addons/sourcemod/configs/admins_simple.ini
L 08/08/2022 - 21:41:08: [admin-flatfile.smx] (line 39) Invalid flag detected: :
L 08/08/2022 - 21:41:08: [admin-flatfile.smx] (line 39) Failed to bind identity STEAM_0 (method steam)
L 08/08/2022 - 21:41:08: [admin-flatfile.smx] Error(s) detected parsing addons/sourcemod/configs/admins_simple.ini
L 08/08/2022 - 21:41:08: [admin-flatfile.smx] (line 39) Invalid flag detected: :
L 08/08/2022 - 21:41:08: [admin-flatfile.smx] (line 39) Failed to bind identity STEAM_0 (method steam)
L 08/08/2022 - 21:44:37: [SM] Exception reported: Invalid VIP-group/Некорректная VIP-группа (TEST)
L 08/08/2022 - 21:44:37: [SM] Blaming: VIP_Core.smx
L 08/08/2022 - 21:44:37: [SM] Call stack trace:
L 08/08/2022 - 21:44:37: [SM] [0] ThrowNativeError
L 08/08/2022 - 21:44:37: [SM] [1] Line 609, vip/API.sp::API_GiveClientVIP
L 08/08/2022 - 21:44:37: [SM] [2] Line 567, vip/API.sp::Native_GiveClientVIP
L 08/08/2022 - 21:44:37: [SM] [4] VIP_GiveClientVIP
L 08/08/2022 - 21:44:37: [SM] [5] Line 285, C:\Users\hirowatch\Desktop\scripting\VIP_Test.sp::GiveVIPToClient
L 08/08/2022 - 21:44:37: [SM] [6] Line 233, C:\Users\hirowatch\Desktop\scripting\VIP_Test.sp::SQL_Callback_SelectClient
L 08/08/2022 - 21:44:49: [SM] Exception reported: Invalid VIP-group/Некорректная VIP-группа (TEST)
L 08/08/2022 - 21:44:49: [SM] Blaming: VIP_Core.smx
L 08/08/2022 - 21:44:49: [SM] Call stack trace:
L 08/08/2022 - 21:44:49: [SM] [0] ThrowNativeError
L 08/08/2022 - 21:44:49: [SM] [1] Line 609, vip/API.sp::API_GiveClientVIP
L 08/08/2022 - 21:44:49: [SM] [2] Line 567, vip/API.sp::Native_GiveClientVIP
L 08/08/2022 - 21:44:49: [SM] [4] VIP_GiveClientVIP
L 08/08/2022 - 21:44:49: [SM] [5] Line 285, C:\Users\hirowatch\Desktop\scripting\VIP_Test.sp::GiveVIPToClient
L 08/08/2022 - 21:44:49: [SM] [6] Line 233, C:\Users\hirowatch\Desktop\scripting\VIP_Test.sp::SQL_Callback_SelectClient
L 08/08/2022 - 21:48:31: SourceMod error session started
L 08/08/2022 - 21:48:31: Info (map "de_mirage") (file "/home/srv982124/csgo/addons/sourcemod/logs/errors_20220808.log")
L 08/08/2022 - 21:48:31: [SM] Fatal error encountered parsing translation file "vip_modules.phrases.txt"
L 08/08/2022 - 21:48:31: [SM] Error (line 0, column 0): Stream failed to open
L 08/08/2022 - 21:48:31: [admin-flatfile.smx] Error(s) detected parsing addons/sourcemod/configs/admins_simple.ini
L 08/08/2022 - 21:48:31: [admin-flatfile.smx] (line 39) Invalid flag detected: :
L 08/08/2022 - 21:48:31: [admin-flatfile.smx] (line 39) Failed to bind identity STEAM_0 (method steam)
L 08/08/2022 - 21:48:33: [lk/lk_core.smx] LK_RegisterItem ошибка: Ключ 'pokupka_vip_r1ko' уже занят
L 08/08/2022 - 21:48:34: [admin-flatfile.smx] Error(s) detected parsing addons/sourcemod/configs/admins_simple.ini
L 08/08/2022 - 21:48:34: [admin-flatfile.smx] (line 39) Invalid flag detected: :
L 08/08/2022 - 21:48:34: [admin-flatfile.smx] (line 39) Failed to bind identity STEAM_0 (method steam)
L 08/08/2022 - 21:48:34: [admin-flatfile.smx] Error(s) detected parsing addons/sourcemod/configs/admins_simple.ini
L 08/08/2022 - 21:48:34: [admin-flatfile.smx] (line 39) Invalid flag detected: :
L 08/08/2022 - 21:48:34: [admin-flatfile.smx] (line 39) Failed to bind identity STEAM_0 (method steam)
L 08/08/2022 - 21:48:38: Error log file session closed.
L 08/08/2022 - 21:48:38: SourceMod error session started
L 08/08/2022 - 21:48:38: Info (map "de_mirage") (file "/home/srv982124/csgo/addons/sourcemod/logs/errors_20220808.log")
L 08/08/2022 - 21:48:38: [SM] Fatal error encountered parsing translation file "vip_modules.phrases.txt"
L 08/08/2022 - 21:48:38: [SM] Error (line 0, column 0): Stream failed to open
L 08/08/2022 - 21:48:38: [admin-flatfile.smx] Error(s) detected parsing addons/sourcemod/configs/admins_simple.ini
L 08/08/2022 - 21:48:38: [admin-flatfile.smx] (line 39) Invalid flag detected: :
L 08/08/2022 - 21:48:38: [admin-flatfile.smx] (line 39) Failed to bind identity STEAM_0 (method steam)
L 08/08/2022 - 21:48:40: [lk/lk_core.smx] LK_RegisterItem ошибка: Ключ 'pokupka_vip_r1ko' уже занят
L 08/08/2022 - 21:50:29: [admin-flatfile.smx] Error(s) detected parsing addons/sourcemod/configs/admins_simple.ini
L 08/08/2022 - 21:50:29: [admin-flatfile.smx] (line 39) Invalid flag detected: :
L 08/08/2022 - 21:50:29: [admin-flatfile.smx] (line 39) Failed to bind identity STEAM_0 (method steam)
L 08/08/2022 - 21:50:29: [admin-flatfile.smx] Error(s) detected parsing addons/sourcemod/configs/admins_simple.ini
L 08/08/2022 - 21:50:29: [admin-flatfile.smx] (line 39) Invalid flag detected: :
L 08/08/2022 - 21:50:29: [admin-flatfile.smx] (line 39) Failed to bind identity STEAM_0 (method steam)
L 08/08/2022 - 21:55:13: SourceMod error session started
L 08/08/2022 - 21:55:13: Info (map "de_mirage") (file "/home/srv982124/csgo/addons/sourcemod/logs/errors_20220808.log")
L 08/08/2022 - 21:55:13: [SM] Fatal error encountered parsing translation file "vip_modules.phrases.txt"
L 08/08/2022 - 21:55:13: [SM] Error (line 0, column 0): Stream failed to open
L 08/08/2022 - 21:55:13: [admin-flatfile.smx] Error(s) detected parsing addons/sourcemod/configs/admins_simple.ini
L 08/08/2022 - 21:55:13: [admin-flatfile.smx] (line 39) Invalid flag detected: :
L 08/08/2022 - 21:55:13: [admin-flatfile.smx] (line 39) Failed to bind identity STEAM_0 (method steam)
L 08/08/2022 - 21:55:15: [lk/lk_core.smx] LK_RegisterItem ошибка: Ключ 'pokupka_vip_r1ko' уже занят
L 08/08/2022 - 21:55:16: [admin-flatfile.smx] Error(s) detected parsing addons/sourcemod/configs/admins_simple.ini
L 08/08/2022 - 21:55:16: [admin-flatfile.smx] (line 39) Invalid flag detected: :
L 08/08/2022 - 21:55:16: [admin-flatfile.smx] (line 39) Failed to bind identity STEAM_0 (method steam)
L 08/08/2022 - 21:55:16: [admin-flatfile.smx] Error(s) detected parsing addons/sourcemod/configs/admins_simple.ini
L 08/08/2022 - 21:55:16: [admin-flatfile.smx] (line 39) Invalid flag detected: :
L 08/08/2022 - 21:55:16: [admin-flatfile.smx] (line 39) Failed to bind identity STEAM_0 (method steam)
L 08/08/2022 - 21:55:21: Error log file session closed.
L 08/08/2022 - 21:55:21: SourceMod error session started
L 08/08/2022 - 21:55:21: Info (map "de_mirage") (file "/home/srv982124/csgo/addons/sourcemod/logs/errors_20220808.log")
L 08/08/2022 - 21:55:21: [SM] Fatal error encountered parsing translation file "vip_modules.phrases.txt"
L 08/08/2022 - 21:55:21: [SM] Error (line 0, column 0): Stream failed to open
L 08/08/2022 - 21:55:21: [admin-flatfile.smx] Error(s) detected parsing addons/sourcemod/configs/admins_simple.ini
L 08/08/2022 - 21:55:21: [admin-flatfile.smx] (line 39) Invalid flag detected: :
L 08/08/2022 - 21:55:21: [admin-flatfile.smx] (line 39) Failed to bind identity STEAM_0 (method steam)
L 08/08/2022 - 21:55:23: [lk/lk_core.smx] LK_RegisterItem ошибка: Ключ 'pokupka_vip_r1ko' уже занят
L 08/08/2022 - 21:55:48: [admin-flatfile.smx] Error(s) detected parsing addons/sourcemod/configs/admins_simple.ini
L 08/08/2022 - 21:55:48: [admin-flatfile.smx] (line 39) Invalid flag detected: :
L 08/08/2022 - 21:55:48: [admin-flatfile.smx] (line 39) Failed to bind identity STEAM_0 (method steam)
L 08/08/2022 - 21:55:48: [admin-flatfile.smx] Error(s) detected parsing addons/sourcemod/configs/admins_simple.ini
L 08/08/2022 - 21:55:48: [admin-flatfile.smx] (line 39) Invalid flag detected: :
L 08/08/2022 - 21:55:48: [admin-flatfile.smx] (line 39) Failed to bind identity STEAM_0 (method steam)
L 08/08/2022 - 22:01:15: [admin-flatfile.smx] Error(s) detected parsing addons/sourcemod/configs/admins_simple.ini
L 08/08/2022 - 22:01:15: [admin-flatfile.smx] (line 39) Invalid flag detected: :
L 08/08/2022 - 22:01:15: [admin-flatfile.smx] (line 39) Failed to bind identity STEAM_0 (method steam)
L 08/08/2022 - 22:01:15: [admin-flatfile.smx] Error(s) detected parsing addons/sourcemod/configs/admins_simple.ini
L 08/08/2022 - 22:01:15: [admin-flatfile.smx] (line 39) Invalid flag detected: :
L 08/08/2022 - 22:01:15: [admin-flatfile.smx] (line 39) Failed to bind identity STEAM_0 (method steam)
L 08/08/2022 - 22:01:15: [materialadmin.smx] Failed to retrieve groups from the database, Unknown column 'sg.maxbantime' in 'field list'
L 08/08/2022 - 22:01:15: [materialadmin.smx] Failed to retrieve admins from the database, Unknown column 'expired' in 'field list'
В описании из архива написано, что при такой ошибке не хватает пару столбцов выполните команду ниже. Но у меня эти столбцы есть. Что это может быть?
L 08/08/2022 - 00:07:31: [materialadmin.smx] plugin version 0.5.8 beta
L 08/08/2022 - 00:07:31: [materialadmin.smx] ConnectBd: lost
L 08/08/2022 - 00:07:31: [materialadmin.smx] ConnectBd: yes
L 08/08/2022 - 01:18:44: [materialadmin.smx] plugin version 0.5.8 beta
L 08/08/2022 - 01:18:44: [materialadmin.smx] ConnectBd: lost
L 08/08/2022 - 01:18:44: [materialadmin.smx] ConnectBd: yes
L 08/08/2022 - 01:19:14: [materialadmin.smx] Checking ban for: STEAM_1:0:527697885. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:0:527697885$') OR (a.`type` = 1 AND a.`ip` = '5.44.168.157')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL
L 08/08/2022 - 01:19:14: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:0:527697885'
L 08/08/2022 - 01:19:14: [materialadmin.smx] Check Mute: STEAM_1:0:527697885. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, IF (a.`immunity` >= g.`immunity`, a.`immunity`, IFNULL(g.`immunity`, 0)) AS immunity, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:527697885$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP())
L 08/08/2022 - 01:19:14: [materialadmin.smx] CheckClientMute: set HarriOKK type 0
L 08/08/2022 - 01:19:14: [materialadmin.smx] Checking ban for: STEAM_1:0:641183754. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:0:641183754$') OR (a.`type` = 1 AND a.`ip` = '90.189.141.254')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL
L 08/08/2022 - 01:19:14: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:0:641183754'
L 08/08/2022 - 01:19:14: [materialadmin.smx] Check Mute: STEAM_1:0:641183754. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, IF (a.`immunity` >= g.`immunity`, a.`immunity`, IFNULL(g.`immunity`, 0)) AS immunity, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:641183754$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP())
L 08/08/2022 - 01:19:14: [materialadmin.smx] CheckClientMute: set big pencil type 0
L 08/08/2022 - 01:19:59: [materialadmin.smx] Checking ban for: STEAM_1:1:569683485. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:1:569683485$') OR (a.`type` = 1 AND a.`ip` = '217.64.142.248')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL
L 08/08/2022 - 01:19:59: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:1:569683485'
L 08/08/2022 - 01:19:59: [materialadmin.smx] Check Mute: STEAM_1:1:569683485. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, IF (a.`immunity` >= g.`immunity`, a.`immunity`, IFNULL(g.`immunity`, 0)) AS immunity, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:1:569683485$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP())
L 08/08/2022 - 01:19:59: [materialadmin.smx] CheckClientMute: set Hanma dwarf type 0
L 08/08/2022 - 01:20:28: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:0:641183754', '90.189.141.254', 'big pencil', 1659896428)
L 08/08/2022 - 01:20:37: [materialadmin.smx] Checking ban for: STEAM_1:0:641183754. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:0:641183754$') OR (a.`type` = 1 AND a.`ip` = '90.189.141.254')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL
L 08/08/2022 - 01:20:37: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:0:641183754'
L 08/08/2022 - 01:20:37: [materialadmin.smx] Check Mute: STEAM_1:0:641183754. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, IF (a.`immunity` >= g.`immunity`, a.`immunity`, IFNULL(g.`immunity`, 0)) AS immunity, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:641183754$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP())
L 08/08/2022 - 01:20:37: [materialadmin.smx] CheckClientMute: set big pencil type 0
L 08/08/2022 - 01:22:00: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:0:641183754', '90.189.141.254', 'big pencil', 1659896520)
L 08/08/2022 - 01:22:09: [materialadmin.smx] Checking ban for: STEAM_1:0:641183754. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:0:641183754$') OR (a.`type` = 1 AND a.`ip` = '90.189.141.254')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL
L 08/08/2022 - 01:22:09: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:0:641183754'
L 08/08/2022 - 01:22:09: [materialadmin.smx] Check Mute: STEAM_1:0:641183754. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, IF (a.`immunity` >= g.`immunity`, a.`immunity`, IFNULL(g.`immunity`, 0)) AS immunity, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:641183754$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP())
L 08/08/2022 - 01:22:09: [materialadmin.smx] CheckClientMute: set big pencil type 0
L 08/08/2022 - 01:23:50: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:0:641183754', '90.189.141.254', 'big pencil', 1659896630)
L 08/08/2022 - 01:28:33: [materialadmin.smx] Checking ban for: STEAM_1:0:641183754. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:0:641183754$') OR (a.`type` = 1 AND a.`ip` = '90.189.141.254')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL
L 08/08/2022 - 01:28:33: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:0:641183754'
L 08/08/2022 - 01:28:33: [materialadmin.smx] Check Mute: STEAM_1:0:641183754. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, IF (a.`immunity` >= g.`immunity`, a.`immunity`, IFNULL(g.`immunity`, 0)) AS immunity, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:641183754$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP())
L 08/08/2022 - 01:28:33: [materialadmin.smx] CheckClientMute: set big pencil type 0
L 08/08/2022 - 01:30:00: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:0:641183754', '90.189.141.254', 'big pencil', 1659897000)
L 08/08/2022 - 01:30:18: [materialadmin.smx] Checking ban for: STEAM_1:0:641183754. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:0:641183754$') OR (a.`type` = 1 AND a.`ip` = '90.189.141.254')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL
L 08/08/2022 - 01:30:18: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:0:641183754'
L 08/08/2022 - 01:30:18: [materialadmin.smx] Check Mute: STEAM_1:0:641183754. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, IF (a.`immunity` >= g.`immunity`, a.`immunity`, IFNULL(g.`immunity`, 0)) AS immunity, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:641183754$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP())
L 08/08/2022 - 01:30:18: [materialadmin.smx] CheckClientMute: set big pencil type 0
L 08/08/2022 - 01:32:05: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:0:641183754', '90.189.141.254', 'big pencil', 1659897125)
L 08/08/2022 - 01:32:14: [materialadmin.smx] Checking ban for: STEAM_1:0:641183754. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:0:641183754$') OR (a.`type` = 1 AND a.`ip` = '90.189.141.254')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL
L 08/08/2022 - 01:32:14: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:0:641183754'
L 08/08/2022 - 01:32:14: [materialadmin.smx] Check Mute: STEAM_1:0:641183754. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, IF (a.`immunity` >= g.`immunity`, a.`immunity`, IFNULL(g.`immunity`, 0)) AS immunity, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:641183754$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP())
L 08/08/2022 - 01:32:15: [materialadmin.smx] CheckClientMute: set big pencil type 0
L 08/08/2022 - 01:38:31: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:1:569683485', '217.64.142.248', 'Hanma dwarf', 1659897511)
L 08/08/2022 - 01:40:22: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:0:641183754', '90.189.141.254', 'big pencil', 1659897622)
L 08/08/2022 - 01:40:29: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:0:527697885', '5.44.168.157', 'HarriOKK', 1659897629)
L 08/08/2022 - 01:40:52: [materialadmin.smx] plugin version 0.5.8 beta
L 08/08/2022 - 01:40:52: [materialadmin.smx] ConnectBd: lost
L 08/08/2022 - 01:40:52: [materialadmin.smx] ConnectBd: yes
L 08/08/2022 - 04:06:06: [materialadmin.smx] plugin version 0.5.8 beta
L 08/08/2022 - 04:06:06: [materialadmin.smx] ConnectBd: lost
L 08/08/2022 - 04:06:06: [materialadmin.smx] ConnectBd: yes
L 08/08/2022 - 04:06:17: [materialadmin.smx] Checking ban for: STEAM_1:0:504175119. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:0:504175119$') OR (a.`type` = 1 AND a.`ip` = '5.130.16.5')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL
L 08/08/2022 - 04:06:17: [materialadmin.smx] Check Mute: STEAM_1:0:504175119. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, IF (a.`immunity` >= g.`immunity`, a.`immunity`, IFNULL(g.`immunity`, 0)) AS immunity, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:504175119$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP())
L 08/08/2022 - 04:06:17: [materialadmin.smx] CheckClientMute: set Unicorn type 0
L 08/08/2022 - 12:54:23: [materialadmin.smx] plugin version 0.5.8 beta
L 08/08/2022 - 12:54:23: [materialadmin.smx] ConnectBd: lost
L 08/08/2022 - 12:54:23: [materialadmin.smx] ConnectBd: yes
L 08/08/2022 - 12:55:51: [materialadmin.smx] Checking ban for: STEAM_1:0:509196784. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:0:509196784$') OR (a.`type` = 1 AND a.`ip` = '37.192.167.218')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL
L 08/08/2022 - 12:55:51: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:0:509196784'
L 08/08/2022 - 12:55:51: [materialadmin.smx] Check Mute: STEAM_1:0:509196784. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, IF (a.`immunity` >= g.`immunity`, a.`immunity`, IFNULL(g.`immunity`, 0)) AS immunity, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:509196784$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP())
L 08/08/2022 - 12:55:51: [materialadmin.smx] CheckClientMute: set / type 0
L 08/08/2022 - 12:57:42: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:0:509196784', '37.192.167.218', '/', 1659938262)
L 08/08/2022 - 14:09:00: [materialadmin.smx] plugin version 0.5.8 beta
L 08/08/2022 - 14:09:00: [materialadmin.smx] ConnectBd: lost
L 08/08/2022 - 14:09:00: [materialadmin.smx] ConnectBd: yes
L 08/08/2022 - 14:09:53: [materialadmin.smx] Checking ban for: STEAM_1:0:442798692. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:0:442798692$') OR (a.`type` = 1 AND a.`ip` = '94.230.255.126')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL
L 08/08/2022 - 14:09:53: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:0:442798692'
L 08/08/2022 - 14:09:53: [materialadmin.smx] Check Mute: STEAM_1:0:442798692. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, IF (a.`immunity` >= g.`immunity`, a.`immunity`, IFNULL(g.`immunity`, 0)) AS immunity, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:442798692$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP())
L 08/08/2022 - 14:09:53: [materialadmin.smx] CheckClientMute: set Янач Лене type 0
L 08/08/2022 - 14:11:52: [materialadmin.smx] Checking ban for: STEAM_1:1:694912685. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:1:694912685$') OR (a.`type` = 1 AND a.`ip` = '2.94.228.173')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL
L 08/08/2022 - 14:11:52: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:1:694912685'
L 08/08/2022 - 14:11:52: [materialadmin.smx] Check Mute: STEAM_1:1:694912685. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, IF (a.`immunity` >= g.`immunity`, a.`immunity`, IFNULL(g.`immunity`, 0)) AS immunity, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:1:694912685$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP())
L 08/08/2022 - 14:11:52: [materialadmin.smx] CheckClientMute: set NITOOT type 0
L 08/08/2022 - 14:17:50: [materialadmin.smx] Checking ban for: STEAM_1:0:702299783. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:0:702299783$') OR (a.`type` = 1 AND a.`ip` = '176.50.212.107')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL
L 08/08/2022 - 14:17:50: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:0:702299783'
L 08/08/2022 - 14:17:50: [materialadmin.smx] Check Mute: STEAM_1:0:702299783. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, IF (a.`immunity` >= g.`immunity`, a.`immunity`, IFNULL(g.`immunity`, 0)) AS immunity, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:702299783$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP())
L 08/08/2022 - 14:17:50: [materialadmin.smx] CheckClientMute: set m3nTalityPr0blem's ?geldom? type 0
L 08/08/2022 - 14:31:41: [materialadmin.smx] Checking ban for: STEAM_1:0:711090564. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:0:711090564$') OR (a.`type` = 1 AND a.`ip` = '31.162.151.230')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL
L 08/08/2022 - 14:31:41: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:0:711090564'
L 08/08/2022 - 14:31:41: [materialadmin.smx] Check Mute: STEAM_1:0:711090564. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, IF (a.`immunity` >= g.`immunity`, a.`immunity`, IFNULL(g.`immunity`, 0)) AS immunity, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:711090564$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP())
L 08/08/2022 - 14:31:41: [materialadmin.smx] CheckClientMute: set 彡[ꜱᴀᴋᴜʀᴀᴊɪᴍᴀ type 0
L 08/08/2022 - 14:32:12: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:0:702299783', '176.50.212.107', 'm3nTalityPr0blem''s ?geldom?', 1659943932)
L 08/08/2022 - 14:32:32: [materialadmin.smx] plugin version 0.5.8 beta
L 08/08/2022 - 14:32:32: [materialadmin.smx] ConnectBd: lost
L 08/08/2022 - 14:32:32: [materialadmin.smx] ConnectBd: yes
L 08/08/2022 - 14:32:58: [materialadmin.smx] Checking ban for: STEAM_1:0:614656428. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:0:614656428$') OR (a.`type` = 1 AND a.`ip` = '185.193.199.5')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL
L 08/08/2022 - 14:32:58: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:0:614656428'
L 08/08/2022 - 14:32:58: [materialadmin.smx] Check Mute: STEAM_1:0:614656428. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, IF (a.`immunity` >= g.`immunity`, a.`immunity`, IFNULL(g.`immunity`, 0)) AS immunity, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:614656428$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP())
L 08/08/2022 - 14:32:58: [materialadmin.smx] CheckClientMute: set Sasaki type 0
L 08/08/2022 - 14:34:36: [materialadmin.smx] Checking ban for: STEAM_1:1:694652237. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:1:694652237$') OR (a.`type` = 1 AND a.`ip` = '83.234.123.149')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL
L 08/08/2022 - 14:34:36: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:1:694652237'
L 08/08/2022 - 14:34:36: [materialadmin.smx] Check Mute: STEAM_1:1:694652237. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, IF (a.`immunity` >= g.`immunity`, a.`immunity`, IFNULL(g.`immunity`, 0)) AS immunity, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:1:694652237$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP())
L 08/08/2022 - 14:34:36: [materialadmin.smx] CheckClientMute: set yebishe type 0
L 08/08/2022 - 14:35:42: [materialadmin.smx] Checking ban for: STEAM_1:0:436953102. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:0:436953102$') OR (a.`type` = 1 AND a.`ip` = '31.173.243.130')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL
L 08/08/2022 - 14:35:42: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:0:436953102'
L 08/08/2022 - 14:35:42: [materialadmin.smx] Check Mute: STEAM_1:0:436953102. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, IF (a.`immunity` >= g.`immunity`, a.`immunity`, IFNULL(g.`immunity`, 0)) AS immunity, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:436953102$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP())
L 08/08/2022 - 14:35:42: [materialadmin.smx] CheckClientMute: set _HUNTER_ type 0
L 08/08/2022 - 14:41:01: [materialadmin.smx] Create bd: client Console, target 彡[ꜱᴀᴋᴜʀᴀᴊɪᴍᴀ, Type 1, MuteType 0
L 08/08/2022 - 14:41:01: [materialadmin.smx] name do 彡[ꜱᴀᴋᴜʀᴀᴊɪᴍᴀ : posle 彡[ꜱᴀᴋᴜʀᴀᴊɪᴍᴀ
L 08/08/2022 - 14:41:01: [materialadmin.smx] create bd: INSERT INTO `sb_bans` (`type`, `ip`, `authid`, `name`, `created`, `ends`, `length`, `reason`, `aid`, `adminIp`, `sid`, `country`) VALUES (0, '31.162.151.230', 'STEAM_1:0:711090564', '彡[ꜱᴀᴋᴜʀᴀᴊɪᴍᴀ', UNIX_TIMESTAMP(), UNIX_TIMESTAMP() + 86400, 86400, '\"Banned by [VIP] VoteBan (Started by Янач Лене)\"', 0, '90.189.159.30', (SELECT `sid` FROM `sb_servers` WHERE `ip` = '90.189.159.30' AND `port` = '27070' LIMIT 1), ' ')
L 08/08/2022 - 14:41:01: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:0:711090564', '31.162.151.230', '彡[ꜱᴀᴋᴜʀᴀᴊɪᴍ', 1659944461)
L 08/08/2022 - 14:41:18: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:1:694652237', '83.234.123.149', 'yebishe', 1659944478)
L 08/08/2022 - 14:46:53: [materialadmin.smx] Checking ban for: STEAM_1:1:653474940. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:1:653474940$') OR (a.`type` = 1 AND a.`ip` = '91.105.181.154')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL
L 08/08/2022 - 14:46:53: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:1:653474940'
L 08/08/2022 - 14:46:53: [materialadmin.smx] Check Mute: STEAM_1:1:653474940. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, IF (a.`immunity` >= g.`immunity`, a.`immunity`, IFNULL(g.`immunity`, 0)) AS immunity, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:1:653474940$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP())
L 08/08/2022 - 14:46:53: [materialadmin.smx] CheckClientMute: set exp3nsive type 0
L 08/08/2022 - 14:50:51: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:1:694912685', '2.94.228.173', 'NITOOT', 1659945051)
L 08/08/2022 - 15:02:02: [materialadmin.smx] Checking ban for: STEAM_1:0:636175902. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:0:636175902$') OR (a.`type` = 1 AND a.`ip` = '176.215.100.203')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL
L 08/08/2022 - 15:02:02: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:0:636175902'
L 08/08/2022 - 15:02:02: [materialadmin.smx] Check Mute: STEAM_1:0:636175902. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, IF (a.`immunity` >= g.`immunity`, a.`immunity`, IFNULL(g.`immunity`, 0)) AS immunity, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:636175902$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP())
L 08/08/2022 - 15:02:02: [materialadmin.smx] CheckClientMute: set ya ne Qwiz! type 0
L 08/08/2022 - 15:02:06: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:0:442798692', '94.230.255.126', 'Янач Лене', 1659945726)
L 08/08/2022 - 15:02:09: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:0:436953102', '31.173.243.130', '_HUNTER_', 1659945729)
L 08/08/2022 - 15:02:10: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:1:653474940', '91.105.181.154', 'exp3nsive', 1659945730)
L 08/08/2022 - 15:02:11: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:0:614656428', '185.193.199.5', 'Sasaki', 1659945731)
L 08/08/2022 - 15:02:29: [materialadmin.smx] plugin version 0.5.8 beta
L 08/08/2022 - 15:02:29: [materialadmin.smx] ConnectBd: lost
L 08/08/2022 - 15:02:29: [materialadmin.smx] ConnectBd: yes
L 08/08/2022 - 15:31:42: [materialadmin.smx] plugin version 0.5.8 beta
L 08/08/2022 - 15:31:42: [materialadmin.smx] ConnectBd: lost
L 08/08/2022 - 15:31:42: [materialadmin.smx] ConnectBd: yes
L 08/08/2022 - 15:32:37: [materialadmin.smx] Checking ban for: STEAM_1:0:58514129. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:0:58514129$') OR (a.`type` = 1 AND a.`ip` = '37.194.217.29')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL
L 08/08/2022 - 15:32:37: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:0:58514129'
L 08/08/2022 - 15:32:37: [materialadmin.smx] Check Mute: STEAM_1:0:58514129. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, IF (a.`immunity` >= g.`immunity`, a.`immunity`, IFNULL(g.`immunity`, 0)) AS immunity, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:58514129$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP())
L 08/08/2022 - 15:32:37: [materialadmin.smx] CheckClientMute: set Squ1zzy type 0
L 08/08/2022 - 15:41:36: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:0:709609195', '37.194.88.150', 'роман блюхгенг', 1659948096)
L 08/08/2022 - 15:44:05: [materialadmin.smx] Checking ban for: STEAM_1:0:710948244. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:0:710948244$') OR (a.`type` = 1 AND a.`ip` = '128.71.104.132')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL
L 08/08/2022 - 15:44:05: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:0:710948244'
L 08/08/2022 - 15:44:05: [materialadmin.smx] Check Mute: STEAM_1:0:710948244. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, IF (a.`immunity` >= g.`immunity`, a.`immunity`, IFNULL(g.`immunity`, 0)) AS immunity, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:710948244$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP())
L 08/08/2022 - 15:44:05: [materialadmin.smx] CheckClientMute: set научите играть и type 0
L 08/08/2022 - 15:56:38: [materialadmin.smx] Checking ban for: STEAM_1:0:442798692. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:0:442798692$') OR (a.`type` = 1 AND a.`ip` = '94.230.255.126')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL
L 08/08/2022 - 15:56:38: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:0:442798692'
L 08/08/2022 - 15:56:38: [materialadmin.smx] Check Mute: STEAM_1:0:442798692. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, IF (a.`immunity` >= g.`immunity`, a.`immunity`, IFNULL(g.`immunity`, 0)) AS immunity, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:442798692$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP())
L 08/08/2022 - 15:56:38: [materialadmin.smx] CheckClientMute: set Янач Лене type 0
L 08/08/2022 - 15:58:17: [materialadmin.smx] Checking ban for: STEAM_1:0:614656428. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:0:614656428$') OR (a.`type` = 1 AND a.`ip` = '185.193.199.5')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL
L 08/08/2022 - 15:58:17: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:0:614656428'
L 08/08/2022 - 15:58:17: [materialadmin.smx] Check Mute: STEAM_1:0:614656428. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, IF (a.`immunity` >= g.`immunity`, a.`immunity`, IFNULL(g.`immunity`, 0)) AS immunity, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:614656428$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP())
L 08/08/2022 - 15:58:17: [materialadmin.smx] CheckClientMute: set Sasaki type 0
L 08/08/2022 - 16:01:38: [materialadmin.smx] Checking ban for: STEAM_1:0:706815939. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:0:706815939$') OR (a.`type` = 1 AND a.`ip` = '92.124.163.224')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL
L 08/08/2022 - 16:01:39: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:0:706815939'
L 08/08/2022 - 16:01:39: [materialadmin.smx] Check Mute: STEAM_1:0:706815939. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, IF (a.`immunity` >= g.`immunity`, a.`immunity`, IFNULL(g.`immunity`, 0)) AS immunity, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:706815939$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP())
L 08/08/2022 - 16:01:39: [materialadmin.smx] CheckClientMute: set <3 βøśś type 0
L 08/08/2022 - 16:05:00: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:0:706815939', '92.124.163.224', '<3 βøśś', 1659949500)
L 08/08/2022 - 16:05:12: [materialadmin.smx] Checking ban for: STEAM_1:0:436953102. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:0:436953102$') OR (a.`type` = 1 AND a.`ip` = '31.173.243.130')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL
L 08/08/2022 - 16:05:12: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:0:436953102'
L 08/08/2022 - 16:05:12: [materialadmin.smx] Check Mute: STEAM_1:0:436953102. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, IF (a.`immunity` >= g.`immunity`, a.`immunity`, IFNULL(g.`immunity`, 0)) AS immunity, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:436953102$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP())
L 08/08/2022 - 16:05:12: [materialadmin.smx] CheckClientMute: set _HUNTER_ type 0
L 08/08/2022 - 16:10:13: [materialadmin.smx] Checking ban for: STEAM_1:0:534117508. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:0:534117508$') OR (a.`type` = 1 AND a.`ip` = '94.230.254.35')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL
L 08/08/2022 - 16:10:13: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:0:534117508'
L 08/08/2022 - 16:10:13: [materialadmin.smx] Check Mute: STEAM_1:0:534117508. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, IF (a.`immunity` >= g.`immunity`, a.`immunity`, IFNULL(g.`immunity`, 0)) AS immunity, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:534117508$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP())
L 08/08/2022 - 16:10:13: [materialadmin.smx] CheckClientMute: set Plekikkik type 0
L 08/08/2022 - 16:13:02: [materialadmin.smx] Checking ban for: STEAM_1:1:653474940. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:1:653474940$') OR (a.`type` = 1 AND a.`ip` = '91.105.181.154')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL
L 08/08/2022 - 16:13:02: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:1:653474940'
L 08/08/2022 - 16:13:02: [materialadmin.smx] Check Mute: STEAM_1:1:653474940. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, IF (a.`immunity` >= g.`immunity`, a.`immunity`, IFNULL(g.`immunity`, 0)) AS immunity, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:1:653474940$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP())
L 08/08/2022 - 16:13:02: [materialadmin.smx] CheckClientMute: set exp3nsive type 0
L 08/08/2022 - 16:14:05: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:1:653474940', '91.105.181.154', 'exp3nsive', 1659950045)
L 08/08/2022 - 16:14:14: [materialadmin.smx] Checking ban for: STEAM_1:1:653474940. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:1:653474940$') OR (a.`type` = 1 AND a.`ip` = '91.105.181.154')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL
L 08/08/2022 - 16:14:15: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:1:653474940'
L 08/08/2022 - 16:14:15: [materialadmin.smx] Check Mute: STEAM_1:1:653474940. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, IF (a.`immunity` >= g.`immunity`, a.`immunity`, IFNULL(g.`immunity`, 0)) AS immunity, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:1:653474940$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP())
L 08/08/2022 - 16:14:15: [materialadmin.smx] CheckClientMute: set exp3nsive type 0
L 08/08/2022 - 16:14:20: [materialadmin.smx] plugin version 0.5.8 beta
L 08/08/2022 - 16:14:20: [materialadmin.smx] ConnectBd: lost
L 08/08/2022 - 16:14:20: [materialadmin.smx] ConnectBd: yes
L 08/08/2022 - 16:23:07: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:0:710948244', '128.71.104.132', 'научите играть и', 1659950587)
L 08/08/2022 - 16:24:23: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:0:58514129', '37.194.217.29', 'Squ1zzy', 1659950663)
L 08/08/2022 - 16:38:15: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:1:653474940', '91.105.181.154', 'exp3nsive', 1659951495)
L 08/08/2022 - 16:50:02: [materialadmin.smx] plugin version 0.5.8 beta
L 08/08/2022 - 16:50:02: [materialadmin.smx] ConnectBd: lost
L 08/08/2022 - 16:50:02: [materialadmin.smx] ConnectBd: yes
L 08/08/2022 - 16:59:05: [materialadmin.smx] Checking ban for: STEAM_1:0:504175119. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:0:504175119$') OR (a.`type` = 1 AND a.`ip` = '5.130.16.5')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL
L 08/08/2022 - 16:59:05: [materialadmin.smx] Check Mute: STEAM_1:0:504175119. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, IF (a.`immunity` >= g.`immunity`, a.`immunity`, IFNULL(g.`immunity`, 0)) AS immunity, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:504175119$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP())
L 08/08/2022 - 16:59:05: [materialadmin.smx] CheckClientMute: set Unicorn type 0
L 08/08/2022 - 17:06:00: [materialadmin.smx] GetMuteType:QUERY: SELECT c.`type`, IF (a.`immunity` >= g.`immunity`, a.`immunity`, IFNULL(g.`immunity`, 0)) AS immunity, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:442798692$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP())
L 08/08/2022 - 17:06:00: [materialadmin.smx] GetMuteType:Янач Лене: 0
L 08/08/2022 - 17:06:00: [materialadmin.smx] Create bd: client Unicorn, target Янач Лене, Type 5, MuteType 0
L 08/08/2022 - 17:06:00: [materialadmin.smx] name do Янач Лене : posle Янач Лене
L 08/08/2022 - 17:06:00: [materialadmin.smx] create bd: INSERT INTO `sb_comms` (`authid`, `name`, `created`, `ends`, `length`, `reason`, `aid`, `adminIp`, `sid`, `type`) VALUES ('STEAM_1:0:442798692', 'Янач Лене', UNIX_TIMESTAMP(), UNIX_TIMESTAMP() + 1800, 1800, 'попрошайка', IFNULL((SELECT aid FROM sb_admins a INNER JOIN sb_admins_servers_groups asg ON (a.aid = asg.admin_id AND asg.server_id = (SELECT `sid` FROM `sb_servers` WHERE `ip` = '90.189.159.30' AND `port` = '27070' LIMIT 1)) WHERE (a.authid REGEXP '^STEAM_[0-9]:0:504175119$')), 0), '5.130.16.5', (SELECT `sid` FROM `sb_servers` WHERE `ip` = '90.189.159.30' AND `port` = '27070' LIMIT 1), 2)
L 08/08/2022 - 17:06:31: [materialadmin.smx] GetMuteType:QUERY: SELECT c.`type`, IF (a.`immunity` >= g.`immunity`, a.`immunity`, IFNULL(g.`immunity`, 0)) AS immunity, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:442798692$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP())
L 08/08/2022 - 17:06:31: [materialadmin.smx] GetMuteType:Янач Лене: 2
L 08/08/2022 - 17:06:31: [materialadmin.smx] Create bd: client Unicorn, target Янач Лене, Type 7, MuteType 2
L 08/08/2022 - 17:06:31: [materialadmin.smx] name do Янач Лене : posle Янач Лене
L 08/08/2022 - 17:06:31: [materialadmin.smx] create bd: UPDATE `sb_comms` SET `type` = 3 , `reason` = 'Неподобающее поведение', `created` = UNIX_TIMESTAMP(), `ends` = UNIX_TIMESTAMP() + 86400, `length` = 86400, `aid` = IFNULL((SELECT aid FROM sb_admins a INNER JOIN sb_admins_servers_groups asg ON (a.aid = asg.admin_id AND asg.server_id = (SELECT `sid` FROM `sb_servers` WHERE `ip` = '90.189.159.30' AND `port` = '27070' LIMIT 1)) WHERE (a.authid REGEXP '^STEAM_[0-9]:0:504175119$')), 0), `adminIp` = '5.130.16.5', `sid` = (SELECT `sid` FROM `sb_servers` WHERE `ip` = '90.189.159.30' AND `port` = '27070' LIMIT 1) WHERE `type` = 2 AND `authid` REGEXP '^STEAM_[0-9]:0:442798692$' AND (length = '0' OR ends > UNIX_TIMESTAMP()) AND RemoveType IS NULL
L 08/08/2022 - 17:17:26: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:0:436953102', '31.173.243.130', '_HUNTER_', 1659953846)
L 08/08/2022 - 17:17:29: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:0:614656428', '185.193.199.5', 'Sasaki', 1659953849)
L 08/08/2022 - 17:17:33: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:0:534117508', '94.230.254.35', 'Plekikkik', 1659953853)
L 08/08/2022 - 17:17:36: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:0:442798692', '94.230.255.126', 'Янач Лене', 1659953856)
L 08/08/2022 - 17:17:45: [materialadmin.smx] plugin version 0.5.8 beta
L 08/08/2022 - 17:17:45: [materialadmin.smx] ConnectBd: lost
L 08/08/2022 - 17:17:45: [materialadmin.smx] ConnectBd: yes
L 08/08/2022 - 17:39:23: [materialadmin.smx] plugin version 0.5.8 beta
L 08/08/2022 - 17:39:23: [materialadmin.smx] ConnectBd: lost
L 08/08/2022 - 17:39:23: [materialadmin.smx] ConnectBd: yes
L 08/08/2022 - 17:39:35: [materialadmin.smx] Checking ban for: STEAM_1:1:627089945. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:1:627089945$') OR (a.`type` = 1 AND a.`ip` = '5.130.89.41')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL
L 08/08/2022 - 17:39:35: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:1:627089945'
L 08/08/2022 - 17:39:35: [materialadmin.smx] Check Mute: STEAM_1:1:627089945. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, IF (a.`immunity` >= g.`immunity`, a.`immunity`, IFNULL(g.`immunity`, 0)) AS immunity, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:1:627089945$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP())
L 08/08/2022 - 17:39:35: [materialadmin.smx] CheckClientMute: set йода #SYNDICATE type 0
L 08/08/2022 - 17:48:08: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:1:627089945', '5.130.89.41', 'йода #SYNDICATE', 1659955688)
L 08/08/2022 - 18:20:29: [materialadmin.smx] plugin version 0.5.8 beta
L 08/08/2022 - 18:20:29: [materialadmin.smx] ConnectBd: lost
L 08/08/2022 - 18:20:29: [materialadmin.smx] ConnectBd: yes
L 08/08/2022 - 18:59:12: [materialadmin.smx] plugin version 0.5.8 beta
L 08/08/2022 - 18:59:12: [materialadmin.smx] ConnectBd: lost
L 08/08/2022 - 18:59:12: [materialadmin.smx] ConnectBd: yes
L 08/08/2022 - 19:46:49: [materialadmin.smx] Failed to retrieve groups from the database, Unknown column 'sg.maxbantime' in 'field list'
L 08/08/2022 - 19:46:49: [materialadmin.smx] Failed to retrieve admins from the database, Unknown column 'expired' in 'field list'
L 08/08/2022 - 19:47:42: [materialadmin.smx] Failed to retrieve groups from the database, Unknown column 'sg.maxbantime' in 'field list'
L 08/08/2022 - 19:47:42: [materialadmin.smx] Failed to retrieve admins from the database, Unknown column 'expired' in 'field list'
L 08/08/2022 - 19:48:55: [materialadmin.smx] Failed to retrieve groups from the database, Unknown column 'sg.maxbantime' in 'field list'
L 08/08/2022 - 19:48:55: [materialadmin.smx] Failed to retrieve admins from the database, Unknown column 'expired' in 'field list'
L 08/08/2022 - 19:52:51: [materialadmin.smx] plugin version 0.8.6-a76ffff game 4
L 08/08/2022 - 19:52:54: [materialadmin.smx] ConnectBd: yes
L 08/08/2022 - 19:52:54: [materialadmin.smx] GroupsDone:QUERY: SELECT sg.`id`, sg.`name`, sg.`flags`, sg.`immunity`, sg.`maxbantime`, sg.`maxmutetime`, so.`type`, so.`name`, so.`access` FROM `sb_srvgroups` sg LEFT JOIN `sb_srvgroups_overrides` so ON sg.`id` = so.`group_id` ORDER BY sg.`id`, so.`id`
L 08/08/2022 - 19:52:55: [materialadmin.smx] AdminsDone:QUERY: SELECT `authid`, `srv_password`, (SELECT `name` FROM `sb_srvgroups` WHERE `name` = `srv_group`) AS `srv_group`, `srv_flags`, `user`, `immunity`, `expired`, `extraflags`, (SELECT `flags` FROM `sb_groups` WHERE `gid` = a.`gid`) AS `flags` FROM `sb_admins_servers_groups` AS asg LEFT JOIN `sb_admins` AS a ON a.`aid` = asg.`admin_id` WHERE (`expired` > UNIX_TIMESTAMP() OR `expired` = 0 OR `expired` = NULL) AND `authid` != 'STEAM_ID_SERVER' AND ((`server_id` = IFNULL ((SELECT `sid` FROM `sb_servers` WHERE `ip` = '90.189.159.30' AND `port` = '27070' LIMIT 1), 0) OR `srv_group_id` = ANY (SELECT `group_id` FROM `sb_servers_groups` WHERE `server_id` = IFNULL ((SELECT `sid` FROM `sb_servers` WHERE `ip` = '90.189.159.30' AND `port` = '27070' LIMIT 1), 0)))) GROUP BY `aid`, `authid`, `srv_password`, `srv_group`, `srv_flags`, `user`
L 08/08/2022 - 19:52:55: [materialadmin.smx] Failed to retrieve groups from the database, Unknown column 'sg.maxbantime' in 'field list'
L 08/08/2022 - 19:52:55: [materialadmin.smx] Failed to retrieve admins from the database, Unknown column 'expired' in 'field list'
L 08/08/2022 - 20:03:48: [materialadmin.smx] plugin version 0.8.6-a76ffff game 4
L 08/08/2022 - 20:03:50: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_bans` WHERE ((`type` = 0 AND `authid` REGEXP '^STEAM_[0-9]:1:627089945$') OR (`type` = 1 AND `ip` = '5.130.89.41')) LIMIT 1
L 08/08/2022 - 20:03:50: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_comms` WHERE (`authid` REGEXP '^STEAM_[0-9]:1:627089945$') LIMIT 1
L 08/08/2022 - 20:03:50: [materialadmin.smx] Checking ban for: STEAM_1:1:627089945. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:1:627089945$') OR (a.`type` = 1 AND a.`ip` = '5.130.89.41')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL LIMIT 1
L 08/08/2022 - 20:03:50: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:1:627089945'
L 08/08/2022 - 20:03:50: [materialadmin.smx] Check Mute: STEAM_1:1:627089945. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:1:627089945$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP()) LIMIT 1
L 08/08/2022 - 20:03:50: [materialadmin.smx] CheckClientMute: set йода #SYNDICATE type 0
L 08/08/2022 - 20:03:50: [materialadmin.smx] Database failure when fetching warns count for йода #SYNDICATE<3><STEAM_1:1:627089945><>: Table 'db982124.sb_warns' doesn't exist
L 08/08/2022 - 20:10:42: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_bans` WHERE ((`type` = 0 AND `authid` REGEXP '^STEAM_[0-9]:1:709688164$') OR (`type` = 1 AND `ip` = '188.162.1.144')) LIMIT 1
L 08/08/2022 - 20:10:42: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_comms` WHERE (`authid` REGEXP '^STEAM_[0-9]:1:709688164$') LIMIT 1
L 08/08/2022 - 20:10:42: [materialadmin.smx] Checking ban for: STEAM_1:1:709688164. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:1:709688164$') OR (a.`type` = 1 AND a.`ip` = '188.162.1.144')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL LIMIT 1
L 08/08/2022 - 20:10:42: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:1:709688164'
L 08/08/2022 - 20:10:42: [materialadmin.smx] Check Mute: STEAM_1:1:709688164. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:1:709688164$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP()) LIMIT 1
L 08/08/2022 - 20:10:42: [materialadmin.smx] CheckClientMute: set Hold_One type 0
L 08/08/2022 - 20:10:42: [materialadmin.smx] Database failure when fetching warns count for Hold_One<4><STEAM_1:1:709688164><>: Table 'db982124.sb_warns' doesn't exist
L 08/08/2022 - 20:18:38: [materialadmin.smx] GroupsDone:QUERY: SELECT sg.`id`, sg.`name`, sg.`flags`, sg.`immunity`, sg.`maxbantime`, sg.`maxmutetime`, so.`type`, so.`name`, so.`access` FROM `sb_srvgroups` sg LEFT JOIN `sb_srvgroups_overrides` so ON sg.`id` = so.`group_id` ORDER BY sg.`id`, so.`id`
L 08/08/2022 - 20:18:38: [materialadmin.smx] AdminsDone:QUERY: SELECT `authid`, `srv_password`, (SELECT `name` FROM `sb_srvgroups` WHERE `name` = `srv_group`) AS `srv_group`, `srv_flags`, `user`, `immunity`, `expired`, `extraflags`, (SELECT `flags` FROM `sb_groups` WHERE `gid` = a.`gid`) AS `flags` FROM `sb_admins_servers_groups` AS asg LEFT JOIN `sb_admins` AS a ON a.`aid` = asg.`admin_id` WHERE (`expired` > UNIX_TIMESTAMP() OR `expired` = 0 OR `expired` = NULL) AND `authid` != 'STEAM_ID_SERVER' AND ((`server_id` = 1 OR `srv_group_id` = ANY (SELECT `group_id` FROM `sb_servers_groups` WHERE `server_id` = 1))) GROUP BY `aid`, `authid`, `srv_password`, `srv_group`, `srv_flags`, `user`
L 08/08/2022 - 20:18:38: [materialadmin.smx] Failed to retrieve groups from the database, Unknown column 'sg.maxbantime' in 'field list'
L 08/08/2022 - 20:18:38: [materialadmin.smx] Failed to retrieve admins from the database, Unknown column 'expired' in 'field list'
L 08/08/2022 - 20:19:24: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_bans` WHERE ((`type` = 0 AND `authid` REGEXP '^STEAM_[0-9]:1:569683485$') OR (`type` = 1 AND `ip` = '217.64.142.248')) LIMIT 1
L 08/08/2022 - 20:19:24: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_comms` WHERE (`authid` REGEXP '^STEAM_[0-9]:1:569683485$') LIMIT 1
L 08/08/2022 - 20:19:24: [materialadmin.smx] Checking ban for: STEAM_1:1:569683485. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:1:569683485$') OR (a.`type` = 1 AND a.`ip` = '217.64.142.248')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL LIMIT 1
L 08/08/2022 - 20:19:24: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:1:569683485'
L 08/08/2022 - 20:19:24: [materialadmin.smx] Check Mute: STEAM_1:1:569683485. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:1:569683485$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP()) LIMIT 1
L 08/08/2022 - 20:19:24: [materialadmin.smx] CheckClientMute: set Hanma dwarf type 0
L 08/08/2022 - 20:19:24: [materialadmin.smx] Database failure when fetching warns count for Hanma dwarf<5><STEAM_1:1:569683485><>: Table 'db982124.sb_warns' doesn't exist
L 08/08/2022 - 20:19:41: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_bans` WHERE ((`type` = 0 AND `authid` REGEXP '^STEAM_[0-9]:0:614656428$') OR (`type` = 1 AND `ip` = '185.193.199.5')) LIMIT 1
L 08/08/2022 - 20:19:41: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_comms` WHERE (`authid` REGEXP '^STEAM_[0-9]:0:614656428$') LIMIT 1
L 08/08/2022 - 20:19:41: [materialadmin.smx] Checking ban for: STEAM_1:0:614656428. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:0:614656428$') OR (a.`type` = 1 AND a.`ip` = '185.193.199.5')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL LIMIT 1
L 08/08/2022 - 20:19:41: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:0:614656428'
L 08/08/2022 - 20:19:41: [materialadmin.smx] Check Mute: STEAM_1:0:614656428. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:614656428$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP()) LIMIT 1
L 08/08/2022 - 20:19:41: [materialadmin.smx] CheckClientMute: set Sasaki type 0
L 08/08/2022 - 20:19:41: [materialadmin.smx] Database failure when fetching warns count for Sasaki<6><STEAM_1:0:614656428><>: Table 'db982124.sb_warns' doesn't exist
L 08/08/2022 - 20:20:27: [materialadmin.smx] Checking ban in bd: STEAM_1:1:709688164. QUERY: SELECT c.`bid`, a.`authid` FROM `sb_bans` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND (`type` = 0 AND c.`authid` REGEXP '^STEAM_[0-9]:1:709688164$') AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP())
L 08/08/2022 - 20:20:27: [materialadmin.smx] Create bd: client 0, target 3, Type 1, MuteType 0
L 08/08/2022 - 20:20:27: [materialadmin.smx] create bd: INSERT INTO `sb_bans` (`type`, `ip`, `authid`, `name`, `created`, `ends`, `length`, `reason`, `aid`, `adminIp`, `sid`, `country`) VALUES (0, '188.162.1.144', 'STEAM_1:1:709688164', 'Hold_One', UNIX_TIMESTAMP(), UNIX_TIMESTAMP() + 0, 0, '[Little Anti-Cheat 1.7.1] Обнаружен Aimbot', 0, 'STEAM_ID_SERVER', 1, ' ')
L 08/08/2022 - 20:20:27: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:1:709688164', '188.162.1.144', 'Hold_One', 1659964827)
L 08/08/2022 - 20:21:18: [materialadmin.smx] GroupsDone:QUERY: SELECT sg.`id`, sg.`name`, sg.`flags`, sg.`immunity`, sg.`maxbantime`, sg.`maxmutetime`, so.`type`, so.`name`, so.`access` FROM `sb_srvgroups` sg LEFT JOIN `sb_srvgroups_overrides` so ON sg.`id` = so.`group_id` ORDER BY sg.`id`, so.`id`
L 08/08/2022 - 20:21:18: [materialadmin.smx] AdminsDone:QUERY: SELECT `authid`, `srv_password`, (SELECT `name` FROM `sb_srvgroups` WHERE `name` = `srv_group`) AS `srv_group`, `srv_flags`, `user`, `immunity`, `expired`, `extraflags`, (SELECT `flags` FROM `sb_groups` WHERE `gid` = a.`gid`) AS `flags` FROM `sb_admins_servers_groups` AS asg LEFT JOIN `sb_admins` AS a ON a.`aid` = asg.`admin_id` WHERE (`expired` > UNIX_TIMESTAMP() OR `expired` = 0 OR `expired` = NULL) AND `authid` != 'STEAM_ID_SERVER' AND ((`server_id` = 1 OR `srv_group_id` = ANY (SELECT `group_id` FROM `sb_servers_groups` WHERE `server_id` = 1))) GROUP BY `aid`, `authid`, `srv_password`, `srv_group`, `srv_flags`, `user`
L 08/08/2022 - 20:21:18: [materialadmin.smx] Failed to retrieve groups from the database, Unknown column 'sg.maxbantime' in 'field list'
L 08/08/2022 - 20:21:18: [materialadmin.smx] Failed to retrieve admins from the database, Unknown column 'expired' in 'field list'
L 08/08/2022 - 20:30:44: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_bans` WHERE ((`type` = 0 AND `authid` REGEXP '^STEAM_[0-9]:1:708477488$') OR (`type` = 1 AND `ip` = '100.82.188.29')) LIMIT 1
L 08/08/2022 - 20:30:44: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_comms` WHERE (`authid` REGEXP '^STEAM_[0-9]:1:708477488$') LIMIT 1
L 08/08/2022 - 20:30:44: [materialadmin.smx] Checking ban for: STEAM_1:1:708477488. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:1:708477488$') OR (a.`type` = 1 AND a.`ip` = '100.82.188.29')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL LIMIT 1
L 08/08/2022 - 20:30:44: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:1:708477488'
L 08/08/2022 - 20:30:44: [materialadmin.smx] Check Mute: STEAM_1:1:708477488. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:1:708477488$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP()) LIMIT 1
L 08/08/2022 - 20:30:44: [materialadmin.smx] CheckClientMute: set Зарежу нахуй type 0
L 08/08/2022 - 20:30:44: [materialadmin.smx] Database failure when fetching warns count for Зарежу нахуй<7><STEAM_1:1:708477488><>: Table 'db982124.sb_warns' doesn't exist
L 08/08/2022 - 20:31:35: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:1:627089945', '5.130.89.41', 'йода #SYNDICATE', 1659965495)
L 08/08/2022 - 20:32:19: [materialadmin.smx] plugin version 0.8.6-a76ffff game 4
L 08/08/2022 - 20:32:20: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_bans` WHERE ((`type` = 0 AND `authid` REGEXP '^STEAM_[0-9]:0:614656428$') OR (`type` = 1 AND `ip` = '185.193.199.5')) LIMIT 1
L 08/08/2022 - 20:32:20: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_comms` WHERE (`authid` REGEXP '^STEAM_[0-9]:0:614656428$') LIMIT 1
L 08/08/2022 - 20:32:20: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_bans` WHERE ((`type` = 0 AND `authid` REGEXP '^STEAM_[0-9]:1:569683485$') OR (`type` = 1 AND `ip` = '217.64.142.248')) LIMIT 1
L 08/08/2022 - 20:32:20: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_comms` WHERE (`authid` REGEXP '^STEAM_[0-9]:1:569683485$') LIMIT 1
L 08/08/2022 - 20:32:20: [materialadmin.smx] Database failure when fetching warns count for Sasaki<6><STEAM_1:0:614656428><>: Table 'db982124.sb_warns' doesn't exist
L 08/08/2022 - 20:32:20: [materialadmin.smx] Database failure when fetching warns count for Hanma dwarf<5><STEAM_1:1:569683485><>: Table 'db982124.sb_warns' doesn't exist
L 08/08/2022 - 20:33:13: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_bans` WHERE ((`type` = 0 AND `authid` REGEXP '^STEAM_[0-9]:1:708477488$') OR (`type` = 1 AND `ip` = '100.82.188.29')) LIMIT 1
L 08/08/2022 - 20:33:13: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_comms` WHERE (`authid` REGEXP '^STEAM_[0-9]:1:708477488$') LIMIT 1
L 08/08/2022 - 20:33:13: [materialadmin.smx] Database failure when fetching warns count for Зарежу нахуй<7><STEAM_1:1:708477488><>: Table 'db982124.sb_warns' doesn't exist
L 08/08/2022 - 20:33:25: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_bans` WHERE ((`type` = 0 AND `authid` REGEXP '^STEAM_[0-9]:1:638424571$') OR (`type` = 1 AND `ip` = '31.173.242.12')) LIMIT 1
L 08/08/2022 - 20:33:25: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_comms` WHERE (`authid` REGEXP '^STEAM_[0-9]:1:638424571$') LIMIT 1
L 08/08/2022 - 20:33:25: [materialadmin.smx] Checking ban for: STEAM_1:1:638424571. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:1:638424571$') OR (a.`type` = 1 AND a.`ip` = '31.173.242.12')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL LIMIT 1
L 08/08/2022 - 20:33:26: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:1:638424571'
L 08/08/2022 - 20:33:26: [materialadmin.smx] Check Mute: STEAM_1:1:638424571. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:1:638424571$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP()) LIMIT 1
L 08/08/2022 - 20:33:26: [materialadmin.smx] CheckClientMute: set Itachi (= type 0
L 08/08/2022 - 20:33:26: [materialadmin.smx] Database failure when fetching warns count for Itachi (=<8><STEAM_1:1:638424571><>: Table 'db982124.sb_warns' doesn't exist
L 08/08/2022 - 20:34:13: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_bans` WHERE ((`type` = 0 AND `authid` REGEXP '^STEAM_[0-9]:0:436953102$') OR (`type` = 1 AND `ip` = '31.173.243.130')) LIMIT 1
L 08/08/2022 - 20:34:13: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_comms` WHERE (`authid` REGEXP '^STEAM_[0-9]:0:436953102$') LIMIT 1
L 08/08/2022 - 20:34:13: [materialadmin.smx] Checking ban for: STEAM_1:0:436953102. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:0:436953102$') OR (a.`type` = 1 AND a.`ip` = '31.173.243.130')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL LIMIT 1
L 08/08/2022 - 20:34:13: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:0:436953102'
L 08/08/2022 - 20:34:13: [materialadmin.smx] Check Mute: STEAM_1:0:436953102. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:436953102$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP()) LIMIT 1
L 08/08/2022 - 20:34:13: [materialadmin.smx] CheckClientMute: set _HUNTER_ type 0
L 08/08/2022 - 20:34:13: [materialadmin.smx] Database failure when fetching warns count for _HUNTER_<9><STEAM_1:0:436953102><>: Table 'db982124.sb_warns' doesn't exist
L 08/08/2022 - 20:49:27: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_bans` WHERE ((`type` = 0 AND `authid` REGEXP '^STEAM_[0-9]:0:710254948$') OR (`type` = 1 AND `ip` = '5.137.97.186')) LIMIT 1
L 08/08/2022 - 20:49:27: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_comms` WHERE (`authid` REGEXP '^STEAM_[0-9]:0:710254948$') LIMIT 1
L 08/08/2022 - 20:49:27: [materialadmin.smx] Checking ban for: STEAM_1:0:710254948. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:0:710254948$') OR (a.`type` = 1 AND a.`ip` = '5.137.97.186')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL LIMIT 1
L 08/08/2022 - 20:49:27: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:0:710254948'
L 08/08/2022 - 20:49:27: [materialadmin.smx] Check Mute: STEAM_1:0:710254948. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:710254948$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP()) LIMIT 1
L 08/08/2022 - 20:49:27: [materialadmin.smx] CheckClientMute: set danGer$ type 0
L 08/08/2022 - 20:49:27: [materialadmin.smx] Database failure when fetching warns count for danGer$<10><STEAM_1:0:710254948><>: Table 'db982124.sb_warns' doesn't exist
L 08/08/2022 - 20:54:58: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_bans` WHERE ((`type` = 0 AND `authid` REGEXP '^STEAM_[0-9]:1:710370680$') OR (`type` = 1 AND `ip` = '37.113.65.21')) LIMIT 1
L 08/08/2022 - 20:54:58: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_comms` WHERE (`authid` REGEXP '^STEAM_[0-9]:1:710370680$') LIMIT 1
L 08/08/2022 - 20:54:58: [materialadmin.smx] Checking ban for: STEAM_1:1:710370680. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:1:710370680$') OR (a.`type` = 1 AND a.`ip` = '37.113.65.21')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL LIMIT 1
L 08/08/2022 - 20:54:58: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:1:710370680'
L 08/08/2022 - 20:54:58: [materialadmin.smx] Check Mute: STEAM_1:1:710370680. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:1:710370680$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP()) LIMIT 1
L 08/08/2022 - 20:54:58: [materialadmin.smx] CheckClientMute: set Shadow type 0
L 08/08/2022 - 20:54:58: [materialadmin.smx] Database failure when fetching warns count for Shadow<11><STEAM_1:1:710370680><>: Table 'db982124.sb_warns' doesn't exist
L 08/08/2022 - 20:59:00: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:0:710254948', '5.137.97.186', 'danGer$', 1659967140)
L 08/08/2022 - 21:00:13: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_bans` WHERE ((`type` = 0 AND `authid` REGEXP '^STEAM_[0-9]:0:504175119$') OR (`type` = 1 AND `ip` = '5.130.16.5')) LIMIT 1
L 08/08/2022 - 21:00:13: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_comms` WHERE (`authid` REGEXP '^STEAM_[0-9]:0:504175119$') LIMIT 1
L 08/08/2022 - 21:00:13: [materialadmin.smx] Checking ban for: STEAM_1:0:504175119. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:0:504175119$') OR (a.`type` = 1 AND a.`ip` = '5.130.16.5')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL LIMIT 1
L 08/08/2022 - 21:00:13: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:0:504175119'
L 08/08/2022 - 21:00:13: [materialadmin.smx] Check Mute: STEAM_1:0:504175119. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:504175119$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP()) LIMIT 1
L 08/08/2022 - 21:00:13: [materialadmin.smx] CheckClientMute: set Unicorn type 0
L 08/08/2022 - 21:00:13: [materialadmin.smx] Database failure when fetching warns count for Unicorn<12><STEAM_1:0:504175119><>: Table 'db982124.sb_warns' doesn't exist
L 08/08/2022 - 21:01:56: [materialadmin.smx] GroupsDone:QUERY: SELECT sg.`id`, sg.`name`, sg.`flags`, sg.`immunity`, sg.`maxbantime`, sg.`maxmutetime`, so.`type`, so.`name`, so.`access` FROM `sb_srvgroups` sg LEFT JOIN `sb_srvgroups_overrides` so ON sg.`id` = so.`group_id` ORDER BY sg.`id`, so.`id`
L 08/08/2022 - 21:01:56: [materialadmin.smx] AdminsDone:QUERY: SELECT `authid`, `srv_password`, (SELECT `name` FROM `sb_srvgroups` WHERE `name` = `srv_group`) AS `srv_group`, `srv_flags`, `user`, `immunity`, `expired`, `extraflags`, (SELECT `flags` FROM `sb_groups` WHERE `gid` = a.`gid`) AS `flags` FROM `sb_admins_servers_groups` AS asg LEFT JOIN `sb_admins` AS a ON a.`aid` = asg.`admin_id` WHERE (`expired` > UNIX_TIMESTAMP() OR `expired` = 0 OR `expired` = NULL) AND `authid` != 'STEAM_ID_SERVER' AND ((`server_id` = 1 OR `srv_group_id` = ANY (SELECT `group_id` FROM `sb_servers_groups` WHERE `server_id` = 1))) GROUP BY `aid`, `authid`, `srv_password`, `srv_group`, `srv_flags`, `user`
L 08/08/2022 - 21:01:56: [materialadmin.smx] Failed to retrieve groups from the database, Unknown column 'sg.maxbantime' in 'field list'
L 08/08/2022 - 21:01:56: [materialadmin.smx] Failed to retrieve admins from the database, Unknown column 'expired' in 'field list'
L 08/08/2022 - 21:02:40: [materialadmin.smx] GroupsDone:QUERY: SELECT sg.`id`, sg.`name`, sg.`flags`, sg.`immunity`, sg.`maxbantime`, sg.`maxmutetime`, so.`type`, so.`name`, so.`access` FROM `sb_srvgroups` sg LEFT JOIN `sb_srvgroups_overrides` so ON sg.`id` = so.`group_id` ORDER BY sg.`id`, so.`id`
L 08/08/2022 - 21:02:40: [materialadmin.smx] AdminsDone:QUERY: SELECT `authid`, `srv_password`, (SELECT `name` FROM `sb_srvgroups` WHERE `name` = `srv_group`) AS `srv_group`, `srv_flags`, `user`, `immunity`, `expired`, `extraflags`, (SELECT `flags` FROM `sb_groups` WHERE `gid` = a.`gid`) AS `flags` FROM `sb_admins_servers_groups` AS asg LEFT JOIN `sb_admins` AS a ON a.`aid` = asg.`admin_id` WHERE (`expired` > UNIX_TIMESTAMP() OR `expired` = 0 OR `expired` = NULL) AND `authid` != 'STEAM_ID_SERVER' AND ((`server_id` = 1 OR `srv_group_id` = ANY (SELECT `group_id` FROM `sb_servers_groups` WHERE `server_id` = 1))) GROUP BY `aid`, `authid`, `srv_password`, `srv_group`, `srv_flags`, `user`
L 08/08/2022 - 21:02:40: [materialadmin.smx] Failed to retrieve groups from the database, Unknown column 'sg.maxbantime' in 'field list'
L 08/08/2022 - 21:02:40: [materialadmin.smx] Failed to retrieve admins from the database, Unknown column 'expired' in 'field list'
L 08/08/2022 - 21:03:47: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_bans` WHERE ((`type` = 0 AND `authid` REGEXP '^STEAM_[0-9]:1:213592138$') OR (`type` = 1 AND `ip` = '193.0.155.228')) LIMIT 1
L 08/08/2022 - 21:03:47: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_comms` WHERE (`authid` REGEXP '^STEAM_[0-9]:1:213592138$') LIMIT 1
L 08/08/2022 - 21:03:47: [materialadmin.smx] Checking ban for: STEAM_1:1:213592138. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:1:213592138$') OR (a.`type` = 1 AND a.`ip` = '193.0.155.228')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL LIMIT 1
L 08/08/2022 - 21:03:47: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:1:213592138'
L 08/08/2022 - 21:03:47: [materialadmin.smx] Check Mute: STEAM_1:1:213592138. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:1:213592138$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP()) LIMIT 1
L 08/08/2022 - 21:03:47: [materialadmin.smx] CheckClientMute: set apmem913 type 0
L 08/08/2022 - 21:03:47: [materialadmin.smx] Database failure when fetching warns count for apmem913<13><STEAM_1:1:213592138><>: Table 'db982124.sb_warns' doesn't exist
L 08/08/2022 - 21:04:38: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:0:504175119', '5.130.16.5', 'Unicorn', 1659967478)
L 08/08/2022 - 21:05:03: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:1:710370680', '37.113.65.21', 'Shadow', 1659967503)
L 08/08/2022 - 21:05:08: [materialadmin.smx] GroupsDone:QUERY: SELECT sg.`id`, sg.`name`, sg.`flags`, sg.`immunity`, sg.`maxbantime`, sg.`maxmutetime`, so.`type`, so.`name`, so.`access` FROM `sb_srvgroups` sg LEFT JOIN `sb_srvgroups_overrides` so ON sg.`id` = so.`group_id` ORDER BY sg.`id`, so.`id`
L 08/08/2022 - 21:05:08: [materialadmin.smx] AdminsDone:QUERY: SELECT `authid`, `srv_password`, (SELECT `name` FROM `sb_srvgroups` WHERE `name` = `srv_group`) AS `srv_group`, `srv_flags`, `user`, `immunity`, `expired`, `extraflags`, (SELECT `flags` FROM `sb_groups` WHERE `gid` = a.`gid`) AS `flags` FROM `sb_admins_servers_groups` AS asg LEFT JOIN `sb_admins` AS a ON a.`aid` = asg.`admin_id` WHERE (`expired` > UNIX_TIMESTAMP() OR `expired` = 0 OR `expired` = NULL) AND `authid` != 'STEAM_ID_SERVER' AND ((`server_id` = 1 OR `srv_group_id` = ANY (SELECT `group_id` FROM `sb_servers_groups` WHERE `server_id` = 1))) GROUP BY `aid`, `authid`, `srv_password`, `srv_group`, `srv_flags`, `user`
L 08/08/2022 - 21:05:08: [materialadmin.smx] Failed to retrieve groups from the database, Unknown column 'sg.maxbantime' in 'field list'
L 08/08/2022 - 21:05:08: [materialadmin.smx] Failed to retrieve admins from the database, Unknown column 'expired' in 'field list'
L 08/08/2022 - 21:05:32: [materialadmin.smx] plugin version 0.8.6-a76ffff game 4
L 08/08/2022 - 21:05:34: [materialadmin.smx] ConnectBd: yes
L 08/08/2022 - 21:05:35: [materialadmin.smx] GroupsDone:QUERY: SELECT sg.`id`, sg.`name`, sg.`flags`, sg.`immunity`, sg.`maxbantime`, sg.`maxmutetime`, so.`type`, so.`name`, so.`access` FROM `sb_srvgroups` sg LEFT JOIN `sb_srvgroups_overrides` so ON sg.`id` = so.`group_id` ORDER BY sg.`id`, so.`id`
L 08/08/2022 - 21:05:35: [materialadmin.smx] AdminsDone:QUERY: SELECT `authid`, `srv_password`, (SELECT `name` FROM `sb_srvgroups` WHERE `name` = `srv_group`) AS `srv_group`, `srv_flags`, `user`, `immunity`, `expired`, `extraflags`, (SELECT `flags` FROM `sb_groups` WHERE `gid` = a.`gid`) AS `flags` FROM `sb_admins_servers_groups` AS asg LEFT JOIN `sb_admins` AS a ON a.`aid` = asg.`admin_id` WHERE (`expired` > UNIX_TIMESTAMP() OR `expired` = 0 OR `expired` = NULL) AND `authid` != 'STEAM_ID_SERVER' AND ((`server_id` = IFNULL ((SELECT `sid` FROM `sb_servers` WHERE `ip` = '90.189.159.30' AND `port` = '27070' LIMIT 1), 0) OR `srv_group_id` = ANY (SELECT `group_id` FROM `sb_servers_groups` WHERE `server_id` = IFNULL ((SELECT `sid` FROM `sb_servers` WHERE `ip` = '90.189.159.30' AND `port` = '27070' LIMIT 1), 0)))) GROUP BY `aid`, `authid`, `srv_password`, `srv_group`, `srv_flags`, `user`
L 08/08/2022 - 21:05:35: [materialadmin.smx] Failed to retrieve groups from the database, Unknown column 'sg.maxbantime' in 'field list'
L 08/08/2022 - 21:05:35: [materialadmin.smx] Failed to retrieve admins from the database, Unknown column 'expired' in 'field list'
L 08/08/2022 - 21:05:48: [materialadmin.smx] plugin version 0.8.6-a76ffff game 4
L 08/08/2022 - 21:05:50: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_bans` WHERE ((`type` = 0 AND `authid` REGEXP '^STEAM_[0-9]:0:504175119$') OR (`type` = 1 AND `ip` = '5.130.16.5')) LIMIT 1
L 08/08/2022 - 21:05:50: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_comms` WHERE (`authid` REGEXP '^STEAM_[0-9]:0:504175119$') LIMIT 1
L 08/08/2022 - 21:05:50: [materialadmin.smx] Checking ban for: STEAM_1:0:504175119. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:0:504175119$') OR (a.`type` = 1 AND a.`ip` = '5.130.16.5')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL LIMIT 1
L 08/08/2022 - 21:05:50: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:0:504175119'
L 08/08/2022 - 21:05:50: [materialadmin.smx] Check Mute: STEAM_1:0:504175119. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:504175119$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP()) LIMIT 1
L 08/08/2022 - 21:05:50: [materialadmin.smx] CheckClientMute: set Unicorn type 0
L 08/08/2022 - 21:05:50: [materialadmin.smx] Database failure when fetching warns count for Unicorn<3><STEAM_1:0:504175119><>: Table 'db982124.sb_warns' doesn't exist
L 08/08/2022 - 21:06:00: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_bans` WHERE ((`type` = 0 AND `authid` REGEXP '^STEAM_[0-9]:1:569683485$') OR (`type` = 1 AND `ip` = '217.64.142.248')) LIMIT 1
L 08/08/2022 - 21:06:00: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_comms` WHERE (`authid` REGEXP '^STEAM_[0-9]:1:569683485$') LIMIT 1
L 08/08/2022 - 21:06:00: [materialadmin.smx] Checking ban for: STEAM_1:1:569683485. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:1:569683485$') OR (a.`type` = 1 AND a.`ip` = '217.64.142.248')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL LIMIT 1
L 08/08/2022 - 21:06:00: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:1:569683485'
L 08/08/2022 - 21:06:00: [materialadmin.smx] Check Mute: STEAM_1:1:569683485. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:1:569683485$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP()) LIMIT 1
L 08/08/2022 - 21:06:00: [materialadmin.smx] CheckClientMute: set Hanma dwarf type 0
L 08/08/2022 - 21:06:00: [materialadmin.smx] Database failure when fetching warns count for Hanma dwarf<4><STEAM_1:1:569683485><>: Table 'db982124.sb_warns' doesn't exist
L 08/08/2022 - 21:06:09: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_bans` WHERE ((`type` = 0 AND `authid` REGEXP '^STEAM_[0-9]:0:436953102$') OR (`type` = 1 AND `ip` = '31.173.243.130')) LIMIT 1
L 08/08/2022 - 21:06:09: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_comms` WHERE (`authid` REGEXP '^STEAM_[0-9]:0:436953102$') LIMIT 1
L 08/08/2022 - 21:06:09: [materialadmin.smx] Checking ban for: STEAM_1:0:436953102. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:0:436953102$') OR (a.`type` = 1 AND a.`ip` = '31.173.243.130')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL LIMIT 1
L 08/08/2022 - 21:06:09: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:0:436953102'
L 08/08/2022 - 21:06:09: [materialadmin.smx] Check Mute: STEAM_1:0:436953102. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:436953102$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP()) LIMIT 1
L 08/08/2022 - 21:06:09: [materialadmin.smx] CheckClientMute: set _HUNTER_ type 0
L 08/08/2022 - 21:06:09: [materialadmin.smx] Database failure when fetching warns count for _HUNTER_<5><STEAM_1:0:436953102><>: Table 'db982124.sb_warns' doesn't exist
L 08/08/2022 - 21:06:10: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_bans` WHERE ((`type` = 0 AND `authid` REGEXP '^STEAM_[0-9]:1:638424571$') OR (`type` = 1 AND `ip` = '31.173.242.12')) LIMIT 1
L 08/08/2022 - 21:06:10: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_comms` WHERE (`authid` REGEXP '^STEAM_[0-9]:1:638424571$') LIMIT 1
L 08/08/2022 - 21:06:10: [materialadmin.smx] Checking ban for: STEAM_1:1:638424571. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:1:638424571$') OR (a.`type` = 1 AND a.`ip` = '31.173.242.12')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL LIMIT 1
L 08/08/2022 - 21:06:10: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:1:638424571'
L 08/08/2022 - 21:06:10: [materialadmin.smx] Check Mute: STEAM_1:1:638424571. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:1:638424571$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP()) LIMIT 1
L 08/08/2022 - 21:06:10: [materialadmin.smx] CheckClientMute: set Itachi (= type 0
L 08/08/2022 - 21:06:10: [materialadmin.smx] Database failure when fetching warns count for Itachi (=<6><STEAM_1:1:638424571><>: Table 'db982124.sb_warns' doesn't exist
L 08/08/2022 - 21:06:16: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_bans` WHERE ((`type` = 0 AND `authid` REGEXP '^STEAM_[0-9]:1:708477488$') OR (`type` = 1 AND `ip` = '100.82.188.29')) LIMIT 1
L 08/08/2022 - 21:06:16: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_comms` WHERE (`authid` REGEXP '^STEAM_[0-9]:1:708477488$') LIMIT 1
L 08/08/2022 - 21:06:16: [materialadmin.smx] Checking ban for: STEAM_1:1:708477488. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:1:708477488$') OR (a.`type` = 1 AND a.`ip` = '100.82.188.29')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL LIMIT 1
L 08/08/2022 - 21:06:16: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:1:708477488'
L 08/08/2022 - 21:06:16: [materialadmin.smx] Check Mute: STEAM_1:1:708477488. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:1:708477488$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP()) LIMIT 1
L 08/08/2022 - 21:06:17: [materialadmin.smx] CheckClientMute: set Зарежу нахуй type 0
L 08/08/2022 - 21:06:17: [materialadmin.smx] Database failure when fetching warns count for Зарежу нахуй<7><STEAM_1:1:708477488><>: Table 'db982124.sb_warns' doesn't exist
L 08/08/2022 - 21:06:35: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_bans` WHERE ((`type` = 0 AND `authid` REGEXP '^STEAM_[0-9]:0:614656428$') OR (`type` = 1 AND `ip` = '185.193.199.5')) LIMIT 1
L 08/08/2022 - 21:06:35: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_comms` WHERE (`authid` REGEXP '^STEAM_[0-9]:0:614656428$') LIMIT 1
L 08/08/2022 - 21:06:35: [materialadmin.smx] Checking ban for: STEAM_1:0:614656428. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:0:614656428$') OR (a.`type` = 1 AND a.`ip` = '185.193.199.5')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL LIMIT 1
L 08/08/2022 - 21:06:35: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:0:614656428'
L 08/08/2022 - 21:06:35: [materialadmin.smx] Check Mute: STEAM_1:0:614656428. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:614656428$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP()) LIMIT 1
L 08/08/2022 - 21:06:35: [materialadmin.smx] CheckClientMute: set Sasaki type 0
L 08/08/2022 - 21:06:35: [materialadmin.smx] Database failure when fetching warns count for Sasaki<8><STEAM_1:0:614656428><>: Table 'db982124.sb_warns' doesn't exist
L 08/08/2022 - 21:07:48: [materialadmin.smx] GroupsDone:QUERY: SELECT sg.`id`, sg.`name`, sg.`flags`, sg.`immunity`, sg.`maxbantime`, sg.`maxmutetime`, so.`type`, so.`name`, so.`access` FROM `sb_srvgroups` sg LEFT JOIN `sb_srvgroups_overrides` so ON sg.`id` = so.`group_id` ORDER BY sg.`id`, so.`id`
L 08/08/2022 - 21:07:48: [materialadmin.smx] AdminsDone:QUERY: SELECT `authid`, `srv_password`, (SELECT `name` FROM `sb_srvgroups` WHERE `name` = `srv_group`) AS `srv_group`, `srv_flags`, `user`, `immunity`, `expired`, `extraflags`, (SELECT `flags` FROM `sb_groups` WHERE `gid` = a.`gid`) AS `flags` FROM `sb_admins_servers_groups` AS asg LEFT JOIN `sb_admins` AS a ON a.`aid` = asg.`admin_id` WHERE (`expired` > UNIX_TIMESTAMP() OR `expired` = 0 OR `expired` = NULL) AND `authid` != 'STEAM_ID_SERVER' AND ((`server_id` = 1 OR `srv_group_id` = ANY (SELECT `group_id` FROM `sb_servers_groups` WHERE `server_id` = 1))) GROUP BY `aid`, `authid`, `srv_password`, `srv_group`, `srv_flags`, `user`
L 08/08/2022 - 21:07:48: [materialadmin.smx] Failed to retrieve groups from the database, Unknown column 'sg.maxbantime' in 'field list'
L 08/08/2022 - 21:07:48: [materialadmin.smx] Failed to retrieve admins from the database, Unknown column 'expired' in 'field list'
L 08/08/2022 - 21:08:05: [materialadmin.smx] GroupsDone:QUERY: SELECT sg.`id`, sg.`name`, sg.`flags`, sg.`immunity`, sg.`maxbantime`, sg.`maxmutetime`, so.`type`, so.`name`, so.`access` FROM `sb_srvgroups` sg LEFT JOIN `sb_srvgroups_overrides` so ON sg.`id` = so.`group_id` ORDER BY sg.`id`, so.`id`
L 08/08/2022 - 21:08:05: [materialadmin.smx] AdminsDone:QUERY: SELECT `authid`, `srv_password`, (SELECT `name` FROM `sb_srvgroups` WHERE `name` = `srv_group`) AS `srv_group`, `srv_flags`, `user`, `immunity`, `expired`, `extraflags`, (SELECT `flags` FROM `sb_groups` WHERE `gid` = a.`gid`) AS `flags` FROM `sb_admins_servers_groups` AS asg LEFT JOIN `sb_admins` AS a ON a.`aid` = asg.`admin_id` WHERE (`expired` > UNIX_TIMESTAMP() OR `expired` = 0 OR `expired` = NULL) AND `authid` != 'STEAM_ID_SERVER' AND ((`server_id` = 1 OR `srv_group_id` = ANY (SELECT `group_id` FROM `sb_servers_groups` WHERE `server_id` = 1))) GROUP BY `aid`, `authid`, `srv_password`, `srv_group`, `srv_flags`, `user`
L 08/08/2022 - 21:08:05: [materialadmin.smx] Failed to retrieve groups from the database, Unknown column 'sg.maxbantime' in 'field list'
L 08/08/2022 - 21:08:05: [materialadmin.smx] Failed to retrieve admins from the database, Unknown column 'expired' in 'field list'
L 08/08/2022 - 21:08:33: [materialadmin.smx] GroupsDone:QUERY: SELECT sg.`id`, sg.`name`, sg.`flags`, sg.`immunity`, sg.`maxbantime`, sg.`maxmutetime`, so.`type`, so.`name`, so.`access` FROM `sb_srvgroups` sg LEFT JOIN `sb_srvgroups_overrides` so ON sg.`id` = so.`group_id` ORDER BY sg.`id`, so.`id`
L 08/08/2022 - 21:08:33: [materialadmin.smx] AdminsDone:QUERY: SELECT `authid`, `srv_password`, (SELECT `name` FROM `sb_srvgroups` WHERE `name` = `srv_group`) AS `srv_group`, `srv_flags`, `user`, `immunity`, `expired`, `extraflags`, (SELECT `flags` FROM `sb_groups` WHERE `gid` = a.`gid`) AS `flags` FROM `sb_admins_servers_groups` AS asg LEFT JOIN `sb_admins` AS a ON a.`aid` = asg.`admin_id` WHERE (`expired` > UNIX_TIMESTAMP() OR `expired` = 0 OR `expired` = NULL) AND `authid` != 'STEAM_ID_SERVER' AND ((`server_id` = 1 OR `srv_group_id` = ANY (SELECT `group_id` FROM `sb_servers_groups` WHERE `server_id` = 1))) GROUP BY `aid`, `authid`, `srv_password`, `srv_group`, `srv_flags`, `user`
L 08/08/2022 - 21:08:33: [materialadmin.smx] Failed to retrieve groups from the database, Unknown column 'sg.maxbantime' in 'field list'
L 08/08/2022 - 21:08:33: [materialadmin.smx] Failed to retrieve admins from the database, Unknown column 'expired' in 'field list'
L 08/08/2022 - 21:11:25: [materialadmin.smx] GroupsDone:QUERY: SELECT sg.`id`, sg.`name`, sg.`flags`, sg.`immunity`, sg.`maxbantime`, sg.`maxmutetime`, so.`type`, so.`name`, so.`access` FROM `sb_srvgroups` sg LEFT JOIN `sb_srvgroups_overrides` so ON sg.`id` = so.`group_id` ORDER BY sg.`id`, so.`id`
L 08/08/2022 - 21:11:25: [materialadmin.smx] AdminsDone:QUERY: SELECT `authid`, `srv_password`, (SELECT `name` FROM `sb_srvgroups` WHERE `name` = `srv_group`) AS `srv_group`, `srv_flags`, `user`, `immunity`, `expired`, `extraflags`, (SELECT `flags` FROM `sb_groups` WHERE `gid` = a.`gid`) AS `flags` FROM `sb_admins_servers_groups` AS asg LEFT JOIN `sb_admins` AS a ON a.`aid` = asg.`admin_id` WHERE (`expired` > UNIX_TIMESTAMP() OR `expired` = 0 OR `expired` = NULL) AND `authid` != 'STEAM_ID_SERVER' AND ((`server_id` = 1 OR `srv_group_id` = ANY (SELECT `group_id` FROM `sb_servers_groups` WHERE `server_id` = 1))) GROUP BY `aid`, `authid`, `srv_password`, `srv_group`, `srv_flags`, `user`
L 08/08/2022 - 21:11:25: [materialadmin.smx] Failed to retrieve groups from the database, Unknown column 'sg.maxbantime' in 'field list'
L 08/08/2022 - 21:11:25: [materialadmin.smx] Failed to retrieve admins from the database, Unknown column 'expired' in 'field list'
L 08/08/2022 - 21:13:13: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:0:504175119', '5.130.16.5', 'Unicorn', 1659967993)
L 08/08/2022 - 21:14:55: [materialadmin.smx] GroupsDone:QUERY: SELECT sg.`id`, sg.`name`, sg.`flags`, sg.`immunity`, sg.`maxbantime`, sg.`maxmutetime`, so.`type`, so.`name`, so.`access` FROM `sb_srvgroups` sg LEFT JOIN `sb_srvgroups_overrides` so ON sg.`id` = so.`group_id` ORDER BY sg.`id`, so.`id`
L 08/08/2022 - 21:14:55: [materialadmin.smx] AdminsDone:QUERY: SELECT `authid`, `srv_password`, (SELECT `name` FROM `sb_srvgroups` WHERE `name` = `srv_group`) AS `srv_group`, `srv_flags`, `user`, `immunity`, `expired`, `extraflags`, (SELECT `flags` FROM `sb_groups` WHERE `gid` = a.`gid`) AS `flags` FROM `sb_admins_servers_groups` AS asg LEFT JOIN `sb_admins` AS a ON a.`aid` = asg.`admin_id` WHERE (`expired` > UNIX_TIMESTAMP() OR `expired` = 0 OR `expired` = NULL) AND `authid` != 'STEAM_ID_SERVER' AND ((`server_id` = 1 OR `srv_group_id` = ANY (SELECT `group_id` FROM `sb_servers_groups` WHERE `server_id` = 1))) GROUP BY `aid`, `authid`, `srv_password`, `srv_group`, `srv_flags`, `user`
L 08/08/2022 - 21:14:55: [materialadmin.smx] Failed to retrieve groups from the database, Unknown column 'sg.maxbantime' in 'field list'
L 08/08/2022 - 21:14:56: [materialadmin.smx] Failed to retrieve admins from the database, Unknown column 'expired' in 'field list'
L 08/08/2022 - 21:17:17: [materialadmin.smx] ConnectBd: lost
L 08/08/2022 - 21:17:17: [materialadmin.smx] ConnectBd: yes
L 08/08/2022 - 21:17:28: [materialadmin.smx] GroupsDone:QUERY: SELECT sg.`id`, sg.`name`, sg.`flags`, sg.`immunity`, sg.`maxbantime`, sg.`maxmutetime`, so.`type`, so.`name`, so.`access` FROM `sb_srvgroups` sg LEFT JOIN `sb_srvgroups_overrides` so ON sg.`id` = so.`group_id` ORDER BY sg.`id`, so.`id`
L 08/08/2022 - 21:17:28: [materialadmin.smx] AdminsDone:QUERY: SELECT `authid`, `srv_password`, (SELECT `name` FROM `sb_srvgroups` WHERE `name` = `srv_group`) AS `srv_group`, `srv_flags`, `user`, `immunity`, `expired`, `extraflags`, (SELECT `flags` FROM `sb_groups` WHERE `gid` = a.`gid`) AS `flags` FROM `sb_admins_servers_groups` AS asg LEFT JOIN `sb_admins` AS a ON a.`aid` = asg.`admin_id` WHERE (`expired` > UNIX_TIMESTAMP() OR `expired` = 0 OR `expired` = NULL) AND `authid` != 'STEAM_ID_SERVER' AND ((`server_id` = 1 OR `srv_group_id` = ANY (SELECT `group_id` FROM `sb_servers_groups` WHERE `server_id` = 1))) GROUP BY `aid`, `authid`, `srv_password`, `srv_group`, `srv_flags`, `user`
L 08/08/2022 - 21:17:28: [materialadmin.smx] Failed to retrieve groups from the database, Unknown column 'sg.maxbantime' in 'field list'
L 08/08/2022 - 21:17:28: [materialadmin.smx] Failed to retrieve admins from the database, Unknown column 'expired' in 'field list'
L 08/08/2022 - 21:21:33: [materialadmin.smx] ConnectBd: lost
L 08/08/2022 - 21:21:33: [materialadmin.smx] ConnectBd: yes
L 08/08/2022 - 21:21:49: [materialadmin.smx] GroupsDone:QUERY: SELECT sg.`id`, sg.`name`, sg.`flags`, sg.`immunity`, sg.`maxbantime`, sg.`maxmutetime`, so.`type`, so.`name`, so.`access` FROM `sb_srvgroups` sg LEFT JOIN `sb_srvgroups_overrides` so ON sg.`id` = so.`group_id` ORDER BY sg.`id`, so.`id`
L 08/08/2022 - 21:21:49: [materialadmin.smx] AdminsDone:QUERY: SELECT `authid`, `srv_password`, (SELECT `name` FROM `sb_srvgroups` WHERE `name` = `srv_group`) AS `srv_group`, `srv_flags`, `user`, `immunity`, `expired`, `extraflags`, (SELECT `flags` FROM `sb_groups` WHERE `gid` = a.`gid`) AS `flags` FROM `sb_admins_servers_groups` AS asg LEFT JOIN `sb_admins` AS a ON a.`aid` = asg.`admin_id` WHERE (`expired` > UNIX_TIMESTAMP() OR `expired` = 0 OR `expired` = NULL) AND `authid` != 'STEAM_ID_SERVER' AND ((`server_id` = 1 OR `srv_group_id` = ANY (SELECT `group_id` FROM `sb_servers_groups` WHERE `server_id` = 1))) GROUP BY `aid`, `authid`, `srv_password`, `srv_group`, `srv_flags`, `user`
L 08/08/2022 - 21:21:49: [materialadmin.smx] Failed to retrieve groups from the database, Unknown column 'sg.maxbantime' in 'field list'
L 08/08/2022 - 21:21:49: [materialadmin.smx] Failed to retrieve admins from the database, Unknown column 'expired' in 'field list'
L 08/08/2022 - 21:22:01: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:0:436953102', '31.173.243.130', '_HUNTER_', 1659968521)
L 08/08/2022 - 21:32:25: [materialadmin.smx] GroupsDone:QUERY: SELECT sg.`id`, sg.`name`, sg.`flags`, sg.`immunity`, sg.`maxbantime`, sg.`maxmutetime`, so.`type`, so.`name`, so.`access` FROM `sb_srvgroups` sg LEFT JOIN `sb_srvgroups_overrides` so ON sg.`id` = so.`group_id` ORDER BY sg.`id`, so.`id`
L 08/08/2022 - 21:32:25: [materialadmin.smx] AdminsDone:QUERY: SELECT `authid`, `srv_password`, (SELECT `name` FROM `sb_srvgroups` WHERE `name` = `srv_group`) AS `srv_group`, `srv_flags`, `user`, `immunity`, `expired`, `extraflags`, (SELECT `flags` FROM `sb_groups` WHERE `gid` = a.`gid`) AS `flags` FROM `sb_admins_servers_groups` AS asg LEFT JOIN `sb_admins` AS a ON a.`aid` = asg.`admin_id` WHERE (`expired` > UNIX_TIMESTAMP() OR `expired` = 0 OR `expired` = NULL) AND `authid` != 'STEAM_ID_SERVER' AND ((`server_id` = 1 OR `srv_group_id` = ANY (SELECT `group_id` FROM `sb_servers_groups` WHERE `server_id` = 1))) GROUP BY `aid`, `authid`, `srv_password`, `srv_group`, `srv_flags`, `user`
L 08/08/2022 - 21:32:25: [materialadmin.smx] Failed to retrieve groups from the database, Unknown column 'sg.maxbantime' in 'field list'
L 08/08/2022 - 21:32:25: [materialadmin.smx] Failed to retrieve admins from the database, Unknown column 'expired' in 'field list'
L 08/08/2022 - 21:32:55: [materialadmin.smx] plugin version 0.8.6-a76ffff game 4
L 08/08/2022 - 21:32:55: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_bans` WHERE ((`type` = 0 AND `authid` REGEXP '^STEAM_[0-9]:0:614656428$') OR (`type` = 1 AND `ip` = '185.193.199.5')) LIMIT 1
L 08/08/2022 - 21:32:55: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_comms` WHERE (`authid` REGEXP '^STEAM_[0-9]:0:614656428$') LIMIT 1
L 08/08/2022 - 21:32:55: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_bans` WHERE ((`type` = 0 AND `authid` REGEXP '^STEAM_[0-9]:1:708477488$') OR (`type` = 1 AND `ip` = '100.82.188.29')) LIMIT 1
L 08/08/2022 - 21:32:55: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_comms` WHERE (`authid` REGEXP '^STEAM_[0-9]:1:708477488$') LIMIT 1
L 08/08/2022 - 21:32:55: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_bans` WHERE ((`type` = 0 AND `authid` REGEXP '^STEAM_[0-9]:1:638424571$') OR (`type` = 1 AND `ip` = '31.173.242.12')) LIMIT 1
L 08/08/2022 - 21:32:55: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_comms` WHERE (`authid` REGEXP '^STEAM_[0-9]:1:638424571$') LIMIT 1
L 08/08/2022 - 21:32:55: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_bans` WHERE ((`type` = 0 AND `authid` REGEXP '^STEAM_[0-9]:1:569683485$') OR (`type` = 1 AND `ip` = '217.64.142.248')) LIMIT 1
L 08/08/2022 - 21:32:55: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_comms` WHERE (`authid` REGEXP '^STEAM_[0-9]:1:569683485$') LIMIT 1
L 08/08/2022 - 21:32:56: [materialadmin.smx] Database failure when fetching warns count for Sasaki<8><STEAM_1:0:614656428><>: Table 'db982124.sb_warns' doesn't exist
L 08/08/2022 - 21:32:56: [materialadmin.smx] Database failure when fetching warns count for Зарежу нахуй<7><STEAM_1:1:708477488><>: Table 'db982124.sb_warns' doesn't exist
L 08/08/2022 - 21:32:56: [materialadmin.smx] Database failure when fetching warns count for Itachi (=<6><STEAM_1:1:638424571><>: Table 'db982124.sb_warns' doesn't exist
L 08/08/2022 - 21:32:56: [materialadmin.smx] Database failure when fetching warns count for Hanma dwarf<4><STEAM_1:1:569683485><>: Table 'db982124.sb_warns' doesn't exist
L 08/08/2022 - 21:33:43: [materialadmin.smx] GroupsDone:QUERY: SELECT sg.`id`, sg.`name`, sg.`flags`, sg.`immunity`, sg.`maxbantime`, sg.`maxmutetime`, so.`type`, so.`name`, so.`access` FROM `sb_srvgroups` sg LEFT JOIN `sb_srvgroups_overrides` so ON sg.`id` = so.`group_id` ORDER BY sg.`id`, so.`id`
L 08/08/2022 - 21:33:43: [materialadmin.smx] AdminsDone:QUERY: SELECT `authid`, `srv_password`, (SELECT `name` FROM `sb_srvgroups` WHERE `name` = `srv_group`) AS `srv_group`, `srv_flags`, `user`, `immunity`, `expired`, `extraflags`, (SELECT `flags` FROM `sb_groups` WHERE `gid` = a.`gid`) AS `flags` FROM `sb_admins_servers_groups` AS asg LEFT JOIN `sb_admins` AS a ON a.`aid` = asg.`admin_id` WHERE (`expired` > UNIX_TIMESTAMP() OR `expired` = 0 OR `expired` = NULL) AND `authid` != 'STEAM_ID_SERVER' AND ((`server_id` = 1 OR `srv_group_id` = ANY (SELECT `group_id` FROM `sb_servers_groups` WHERE `server_id` = 1))) GROUP BY `aid`, `authid`, `srv_password`, `srv_group`, `srv_flags`, `user`
L 08/08/2022 - 21:33:43: [materialadmin.smx] Failed to retrieve groups from the database, Unknown column 'sg.maxbantime' in 'field list'
L 08/08/2022 - 21:33:43: [materialadmin.smx] Failed to retrieve admins from the database, Unknown column 'expired' in 'field list'
L 08/08/2022 - 21:33:49: [materialadmin.smx] ConnectBd: lost
L 08/08/2022 - 21:33:49: [materialadmin.smx] ConnectBd: yes
L 08/08/2022 - 21:33:56: [materialadmin.smx] GroupsDone:QUERY: SELECT sg.`id`, sg.`name`, sg.`flags`, sg.`immunity`, sg.`maxbantime`, sg.`maxmutetime`, so.`type`, so.`name`, so.`access` FROM `sb_srvgroups` sg LEFT JOIN `sb_srvgroups_overrides` so ON sg.`id` = so.`group_id` ORDER BY sg.`id`, so.`id`
L 08/08/2022 - 21:33:56: [materialadmin.smx] AdminsDone:QUERY: SELECT `authid`, `srv_password`, (SELECT `name` FROM `sb_srvgroups` WHERE `name` = `srv_group`) AS `srv_group`, `srv_flags`, `user`, `immunity`, `expired`, `extraflags`, (SELECT `flags` FROM `sb_groups` WHERE `gid` = a.`gid`) AS `flags` FROM `sb_admins_servers_groups` AS asg LEFT JOIN `sb_admins` AS a ON a.`aid` = asg.`admin_id` WHERE (`expired` > UNIX_TIMESTAMP() OR `expired` = 0 OR `expired` = NULL) AND `authid` != 'STEAM_ID_SERVER' AND ((`server_id` = 1 OR `srv_group_id` = ANY (SELECT `group_id` FROM `sb_servers_groups` WHERE `server_id` = 1))) GROUP BY `aid`, `authid`, `srv_password`, `srv_group`, `srv_flags`, `user`
L 08/08/2022 - 21:33:56: [materialadmin.smx] Failed to retrieve groups from the database, Unknown column 'sg.maxbantime' in 'field list'
L 08/08/2022 - 21:33:56: [materialadmin.smx] Failed to retrieve admins from the database, Unknown column 'expired' in 'field list'
L 08/08/2022 - 21:37:06: [materialadmin.smx] ConnectBd: lost
L 08/08/2022 - 21:37:06: [materialadmin.smx] ConnectBd: yes
L 08/08/2022 - 21:37:12: [materialadmin.smx] GroupsDone:QUERY: SELECT sg.`id`, sg.`name`, sg.`flags`, sg.`immunity`, sg.`maxbantime`, sg.`maxmutetime`, so.`type`, so.`name`, so.`access` FROM `sb_srvgroups` sg LEFT JOIN `sb_srvgroups_overrides` so ON sg.`id` = so.`group_id` ORDER BY sg.`id`, so.`id`
L 08/08/2022 - 21:37:12: [materialadmin.smx] AdminsDone:QUERY: SELECT `authid`, `srv_password`, (SELECT `name` FROM `sb_srvgroups` WHERE `name` = `srv_group`) AS `srv_group`, `srv_flags`, `user`, `immunity`, `expired`, `extraflags`, (SELECT `flags` FROM `sb_groups` WHERE `gid` = a.`gid`) AS `flags` FROM `sb_admins_servers_groups` AS asg LEFT JOIN `sb_admins` AS a ON a.`aid` = asg.`admin_id` WHERE (`expired` > UNIX_TIMESTAMP() OR `expired` = 0 OR `expired` = NULL) AND `authid` != 'STEAM_ID_SERVER' AND ((`server_id` = 1 OR `srv_group_id` = ANY (SELECT `group_id` FROM `sb_servers_groups` WHERE `server_id` = 1))) GROUP BY `aid`, `authid`, `srv_password`, `srv_group`, `srv_flags`, `user`
L 08/08/2022 - 21:37:12: [materialadmin.smx] Failed to retrieve groups from the database, Unknown column 'sg.maxbantime' in 'field list'
L 08/08/2022 - 21:37:12: [materialadmin.smx] Failed to retrieve admins from the database, Unknown column 'expired' in 'field list'
L 08/08/2022 - 21:38:41: [materialadmin.smx] GroupsDone:QUERY: SELECT sg.`id`, sg.`name`, sg.`flags`, sg.`immunity`, sg.`maxbantime`, sg.`maxmutetime`, so.`type`, so.`name`, so.`access` FROM `sb_srvgroups` sg LEFT JOIN `sb_srvgroups_overrides` so ON sg.`id` = so.`group_id` ORDER BY sg.`id`, so.`id`
L 08/08/2022 - 21:38:41: [materialadmin.smx] AdminsDone:QUERY: SELECT `authid`, `srv_password`, (SELECT `name` FROM `sb_srvgroups` WHERE `name` = `srv_group`) AS `srv_group`, `srv_flags`, `user`, `immunity`, `expired`, `extraflags`, (SELECT `flags` FROM `sb_groups` WHERE `gid` = a.`gid`) AS `flags` FROM `sb_admins_servers_groups` AS asg LEFT JOIN `sb_admins` AS a ON a.`aid` = asg.`admin_id` WHERE (`expired` > UNIX_TIMESTAMP() OR `expired` = 0 OR `expired` = NULL) AND `authid` != 'STEAM_ID_SERVER' AND ((`server_id` = 1 OR `srv_group_id` = ANY (SELECT `group_id` FROM `sb_servers_groups` WHERE `server_id` = 1))) GROUP BY `aid`, `authid`, `srv_password`, `srv_group`, `srv_flags`, `user`
L 08/08/2022 - 21:38:41: [materialadmin.smx] Failed to retrieve groups from the database, Unknown column 'sg.maxbantime' in 'field list'
L 08/08/2022 - 21:38:41: [materialadmin.smx] Failed to retrieve admins from the database, Unknown column 'expired' in 'field list'
L 08/08/2022 - 21:38:47: [materialadmin.smx] ConnectBd: lost
L 08/08/2022 - 21:38:47: [materialadmin.smx] ConnectBd: yes
L 08/08/2022 - 21:38:53: [materialadmin.smx] GroupsDone:QUERY: SELECT sg.`id`, sg.`name`, sg.`flags`, sg.`immunity`, sg.`maxbantime`, sg.`maxmutetime`, so.`type`, so.`name`, so.`access` FROM `sb_srvgroups` sg LEFT JOIN `sb_srvgroups_overrides` so ON sg.`id` = so.`group_id` ORDER BY sg.`id`, so.`id`
L 08/08/2022 - 21:38:53: [materialadmin.smx] AdminsDone:QUERY: SELECT `authid`, `srv_password`, (SELECT `name` FROM `sb_srvgroups` WHERE `name` = `srv_group`) AS `srv_group`, `srv_flags`, `user`, `immunity`, `expired`, `extraflags`, (SELECT `flags` FROM `sb_groups` WHERE `gid` = a.`gid`) AS `flags` FROM `sb_admins_servers_groups` AS asg LEFT JOIN `sb_admins` AS a ON a.`aid` = asg.`admin_id` WHERE (`expired` > UNIX_TIMESTAMP() OR `expired` = 0 OR `expired` = NULL) AND `authid` != 'STEAM_ID_SERVER' AND ((`server_id` = 1 OR `srv_group_id` = ANY (SELECT `group_id` FROM `sb_servers_groups` WHERE `server_id` = 1))) GROUP BY `aid`, `authid`, `srv_password`, `srv_group`, `srv_flags`, `user`
L 08/08/2022 - 21:38:53: [materialadmin.smx] Failed to retrieve groups from the database, Unknown column 'sg.maxbantime' in 'field list'
L 08/08/2022 - 21:38:53: [materialadmin.smx] Failed to retrieve admins from the database, Unknown column 'expired' in 'field list'
L 08/08/2022 - 21:39:30: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_bans` WHERE ((`type` = 0 AND `authid` REGEXP '^STEAM_[0-9]:0:693972341$') OR (`type` = 1 AND `ip` = '2.62.75.175')) LIMIT 1
L 08/08/2022 - 21:39:30: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_comms` WHERE (`authid` REGEXP '^STEAM_[0-9]:0:693972341$') LIMIT 1
L 08/08/2022 - 21:39:30: [materialadmin.smx] Checking ban for: STEAM_1:0:693972341. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:0:693972341$') OR (a.`type` = 1 AND a.`ip` = '2.62.75.175')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL LIMIT 1
L 08/08/2022 - 21:39:30: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:0:693972341'
L 08/08/2022 - 21:39:30: [materialadmin.smx] Check Mute: STEAM_1:0:693972341. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:693972341$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP()) LIMIT 1
L 08/08/2022 - 21:39:30: [materialadmin.smx] CheckClientMute: set zxc eblan type 0
L 08/08/2022 - 21:39:30: [materialadmin.smx] Database failure when fetching warns count for zxc eblan<9><STEAM_1:0:693972341><>: Table 'db982124.sb_warns' doesn't exist
L 08/08/2022 - 21:41:03: [materialadmin.smx] ConnectBd: lost
L 08/08/2022 - 21:41:03: [materialadmin.smx] ConnectBd: yes
L 08/08/2022 - 21:41:08: [materialadmin.smx] GroupsDone:QUERY: SELECT sg.`id`, sg.`name`, sg.`flags`, sg.`immunity`, sg.`maxbantime`, sg.`maxmutetime`, so.`type`, so.`name`, so.`access` FROM `sb_srvgroups` sg LEFT JOIN `sb_srvgroups_overrides` so ON sg.`id` = so.`group_id` ORDER BY sg.`id`, so.`id`
L 08/08/2022 - 21:41:08: [materialadmin.smx] AdminsDone:QUERY: SELECT `authid`, `srv_password`, (SELECT `name` FROM `sb_srvgroups` WHERE `name` = `srv_group`) AS `srv_group`, `srv_flags`, `user`, `immunity`, `expired`, `extraflags`, (SELECT `flags` FROM `sb_groups` WHERE `gid` = a.`gid`) AS `flags` FROM `sb_admins_servers_groups` AS asg LEFT JOIN `sb_admins` AS a ON a.`aid` = asg.`admin_id` WHERE (`expired` > UNIX_TIMESTAMP() OR `expired` = 0 OR `expired` = NULL) AND `authid` != 'STEAM_ID_SERVER' AND ((`server_id` = 1 OR `srv_group_id` = ANY (SELECT `group_id` FROM `sb_servers_groups` WHERE `server_id` = 1))) GROUP BY `aid`, `authid`, `srv_password`, `srv_group`, `srv_flags`, `user`
L 08/08/2022 - 21:41:08: [materialadmin.smx] Failed to retrieve groups from the database, Unknown column 'sg.maxbantime' in 'field list'
L 08/08/2022 - 21:41:08: [materialadmin.smx] Failed to retrieve admins from the database, Unknown column 'expired' in 'field list'
L 08/08/2022 - 21:41:30: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:0:693972341', '2.62.75.175', 'zxc eblan', 1659969690)
L 08/08/2022 - 21:43:03: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_bans` WHERE ((`type` = 0 AND `authid` REGEXP '^STEAM_[0-9]:1:643720597$') OR (`type` = 1 AND `ip` = '109.174.113.43')) LIMIT 1
L 08/08/2022 - 21:43:03: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_comms` WHERE (`authid` REGEXP '^STEAM_[0-9]:1:643720597$') LIMIT 1
L 08/08/2022 - 21:43:03: [materialadmin.smx] Checking ban for: STEAM_1:1:643720597. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:1:643720597$') OR (a.`type` = 1 AND a.`ip` = '109.174.113.43')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL LIMIT 1
L 08/08/2022 - 21:43:03: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:1:643720597'
L 08/08/2022 - 21:43:03: [materialadmin.smx] Check Mute: STEAM_1:1:643720597. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:1:643720597$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP()) LIMIT 1
L 08/08/2022 - 21:43:04: [materialadmin.smx] CheckClientMute: set чунчунмару type 0
L 08/08/2022 - 21:43:04: [materialadmin.smx] Database failure when fetching warns count for чунчунмару<10><STEAM_1:1:643720597><>: Table 'db982124.sb_warns' doesn't exist
L 08/08/2022 - 21:43:13: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_bans` WHERE ((`type` = 0 AND `authid` REGEXP '^STEAM_[0-9]:0:639762824$') OR (`type` = 1 AND `ip` = '95.104.184.30')) LIMIT 1
L 08/08/2022 - 21:43:13: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_comms` WHERE (`authid` REGEXP '^STEAM_[0-9]:0:639762824$') LIMIT 1
L 08/08/2022 - 21:43:13: [materialadmin.smx] Checking ban for: STEAM_1:0:639762824. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:0:639762824$') OR (a.`type` = 1 AND a.`ip` = '95.104.184.30')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL LIMIT 1
L 08/08/2022 - 21:43:13: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:0:639762824'
L 08/08/2022 - 21:43:13: [materialadmin.smx] Check Mute: STEAM_1:0:639762824. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:639762824$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP()) LIMIT 1
L 08/08/2022 - 21:43:13: [materialadmin.smx] CheckClientMute: set Zoom^eR type 0
L 08/08/2022 - 21:43:13: [materialadmin.smx] Database failure when fetching warns count for Zoom^eR<11><STEAM_1:0:639762824><>: Table 'db982124.sb_warns' doesn't exist
L 08/08/2022 - 21:48:08: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:1:643720597', '109.174.113.43', 'чунчунмару', 1659970088)
L 08/08/2022 - 21:48:31: [materialadmin.smx] plugin version 0.8.6-a76ffff game 4
L 08/08/2022 - 21:48:34: [materialadmin.smx] ConnectBd: yes
L 08/08/2022 - 21:48:34: [materialadmin.smx] GroupsDone:QUERY: SELECT sg.`id`, sg.`name`, sg.`flags`, sg.`immunity`, sg.`maxbantime`, sg.`maxmutetime`, so.`type`, so.`name`, so.`access` FROM `sb_srvgroups` sg LEFT JOIN `sb_srvgroups_overrides` so ON sg.`id` = so.`group_id` ORDER BY sg.`id`, so.`id`
L 08/08/2022 - 21:48:34: [materialadmin.smx] AdminsDone:QUERY: SELECT `authid`, `srv_password`, (SELECT `name` FROM `sb_srvgroups` WHERE `name` = `srv_group`) AS `srv_group`, `srv_flags`, `user`, `immunity`, `expired`, `extraflags`, (SELECT `flags` FROM `sb_groups` WHERE `gid` = a.`gid`) AS `flags` FROM `sb_admins_servers_groups` AS asg LEFT JOIN `sb_admins` AS a ON a.`aid` = asg.`admin_id` WHERE (`expired` > UNIX_TIMESTAMP() OR `expired` = 0 OR `expired` = NULL) AND `authid` != 'STEAM_ID_SERVER' AND ((`server_id` = IFNULL ((SELECT `sid` FROM `sb_servers` WHERE `ip` = '90.189.159.30' AND `port` = '27070' LIMIT 1), 0) OR `srv_group_id` = ANY (SELECT `group_id` FROM `sb_servers_groups` WHERE `server_id` = IFNULL ((SELECT `sid` FROM `sb_servers` WHERE `ip` = '90.189.159.30' AND `port` = '27070' LIMIT 1), 0)))) GROUP BY `aid`, `authid`, `srv_password`, `srv_group`, `srv_flags`, `user`
L 08/08/2022 - 21:48:34: [materialadmin.smx] Failed to retrieve groups from the database, Unknown column 'sg.maxbantime' in 'field list'
L 08/08/2022 - 21:48:34: [materialadmin.smx] Failed to retrieve admins from the database, Unknown column 'expired' in 'field list'
L 08/08/2022 - 21:48:40: [materialadmin.smx] plugin version 0.8.6-a76ffff game 4
L 08/08/2022 - 21:48:41: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_bans` WHERE ((`type` = 0 AND `authid` REGEXP '^STEAM_[0-9]:0:504175119$') OR (`type` = 1 AND `ip` = '5.130.16.5')) LIMIT 1
L 08/08/2022 - 21:48:41: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_comms` WHERE (`authid` REGEXP '^STEAM_[0-9]:0:504175119$') LIMIT 1
L 08/08/2022 - 21:48:41: [materialadmin.smx] Checking ban for: STEAM_1:0:504175119. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:0:504175119$') OR (a.`type` = 1 AND a.`ip` = '5.130.16.5')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL LIMIT 1
L 08/08/2022 - 21:48:41: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:0:504175119'
L 08/08/2022 - 21:48:41: [materialadmin.smx] Check Mute: STEAM_1:0:504175119. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:504175119$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP()) LIMIT 1
L 08/08/2022 - 21:48:41: [materialadmin.smx] CheckClientMute: set Unicorn type 0
L 08/08/2022 - 21:48:41: [materialadmin.smx] Database failure when fetching warns count for Unicorn<3><STEAM_1:0:504175119><>: Table 'db982124.sb_warns' doesn't exist
L 08/08/2022 - 21:48:46: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_bans` WHERE ((`type` = 0 AND `authid` REGEXP '^STEAM_[0-9]:1:569683485$') OR (`type` = 1 AND `ip` = '217.64.142.248')) LIMIT 1
L 08/08/2022 - 21:48:46: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_comms` WHERE (`authid` REGEXP '^STEAM_[0-9]:1:569683485$') LIMIT 1
L 08/08/2022 - 21:48:46: [materialadmin.smx] Checking ban for: STEAM_1:1:569683485. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:1:569683485$') OR (a.`type` = 1 AND a.`ip` = '217.64.142.248')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL LIMIT 1
L 08/08/2022 - 21:48:46: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:1:569683485'
L 08/08/2022 - 21:48:46: [materialadmin.smx] Check Mute: STEAM_1:1:569683485. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:1:569683485$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP()) LIMIT 1
L 08/08/2022 - 21:48:46: [materialadmin.smx] CheckClientMute: set Hanma dwarf type 0
L 08/08/2022 - 21:48:46: [materialadmin.smx] Database failure when fetching warns count for Hanma dwarf<4><STEAM_1:1:569683485><>: Table 'db982124.sb_warns' doesn't exist
L 08/08/2022 - 21:48:58: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_bans` WHERE ((`type` = 0 AND `authid` REGEXP '^STEAM_[0-9]:0:614656428$') OR (`type` = 1 AND `ip` = '185.193.199.5')) LIMIT 1
L 08/08/2022 - 21:48:58: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_comms` WHERE (`authid` REGEXP '^STEAM_[0-9]:0:614656428$') LIMIT 1
L 08/08/2022 - 21:48:58: [materialadmin.smx] Checking ban for: STEAM_1:0:614656428. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:0:614656428$') OR (a.`type` = 1 AND a.`ip` = '185.193.199.5')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL LIMIT 1
L 08/08/2022 - 21:48:58: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:0:614656428'
L 08/08/2022 - 21:48:58: [materialadmin.smx] Check Mute: STEAM_1:0:614656428. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:614656428$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP()) LIMIT 1
L 08/08/2022 - 21:48:58: [materialadmin.smx] CheckClientMute: set Sasaki type 0
L 08/08/2022 - 21:48:58: [materialadmin.smx] Database failure when fetching warns count for Sasaki<5><STEAM_1:0:614656428><>: Table 'db982124.sb_warns' doesn't exist
L 08/08/2022 - 21:49:05: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_bans` WHERE ((`type` = 0 AND `authid` REGEXP '^STEAM_[0-9]:1:708477488$') OR (`type` = 1 AND `ip` = '100.82.188.29')) LIMIT 1
L 08/08/2022 - 21:49:05: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_comms` WHERE (`authid` REGEXP '^STEAM_[0-9]:1:708477488$') LIMIT 1
L 08/08/2022 - 21:49:05: [materialadmin.smx] Checking ban for: STEAM_1:1:708477488. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:1:708477488$') OR (a.`type` = 1 AND a.`ip` = '100.82.188.29')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL LIMIT 1
L 08/08/2022 - 21:49:05: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:1:708477488'
L 08/08/2022 - 21:49:05: [materialadmin.smx] Check Mute: STEAM_1:1:708477488. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:1:708477488$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP()) LIMIT 1
L 08/08/2022 - 21:49:05: [materialadmin.smx] CheckClientMute: set Зарежу нахуй type 0
L 08/08/2022 - 21:49:05: [materialadmin.smx] Database failure when fetching warns count for Зарежу нахуй<6><STEAM_1:1:708477488><>: Table 'db982124.sb_warns' doesn't exist
L 08/08/2022 - 21:49:37: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:0:614656428', '185.193.199.5', 'Sasaki', 1659970177)
L 08/08/2022 - 21:50:14: [materialadmin.smx] ConnectBd: lost
L 08/08/2022 - 21:50:14: [materialadmin.smx] ConnectBd: yes
L 08/08/2022 - 21:50:29: [materialadmin.smx] GroupsDone:QUERY: SELECT sg.`id`, sg.`name`, sg.`flags`, sg.`immunity`, sg.`maxbantime`, sg.`maxmutetime`, so.`type`, so.`name`, so.`access` FROM `sb_srvgroups` sg LEFT JOIN `sb_srvgroups_overrides` so ON sg.`id` = so.`group_id` ORDER BY sg.`id`, so.`id`
L 08/08/2022 - 21:50:29: [materialadmin.smx] AdminsDone:QUERY: SELECT `authid`, `srv_password`, (SELECT `name` FROM `sb_srvgroups` WHERE `name` = `srv_group`) AS `srv_group`, `srv_flags`, `user`, `immunity`, `expired`, `extraflags`, (SELECT `flags` FROM `sb_groups` WHERE `gid` = a.`gid`) AS `flags` FROM `sb_admins_servers_groups` AS asg LEFT JOIN `sb_admins` AS a ON a.`aid` = asg.`admin_id` WHERE (`expired` > UNIX_TIMESTAMP() OR `expired` = 0 OR `expired` = NULL) AND `authid` != 'STEAM_ID_SERVER' AND ((`server_id` = 1 OR `srv_group_id` = ANY (SELECT `group_id` FROM `sb_servers_groups` WHERE `server_id` = 1))) GROUP BY `aid`, `authid`, `srv_password`, `srv_group`, `srv_flags`, `user`
L 08/08/2022 - 21:50:29: [materialadmin.smx] Failed to retrieve groups from the database, Unknown column 'sg.maxbantime' in 'field list'
L 08/08/2022 - 21:50:29: [materialadmin.smx] Failed to retrieve admins from the database, Unknown column 'expired' in 'field list'
L 08/08/2022 - 21:52:27: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_bans` WHERE ((`type` = 0 AND `authid` REGEXP '^STEAM_[0-9]:1:653474940$') OR (`type` = 1 AND `ip` = '91.105.181.154')) LIMIT 1
L 08/08/2022 - 21:52:27: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_comms` WHERE (`authid` REGEXP '^STEAM_[0-9]:1:653474940$') LIMIT 1
L 08/08/2022 - 21:52:27: [materialadmin.smx] Checking ban for: STEAM_1:1:653474940. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:1:653474940$') OR (a.`type` = 1 AND a.`ip` = '91.105.181.154')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL LIMIT 1
L 08/08/2022 - 21:52:27: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:1:653474940'
L 08/08/2022 - 21:52:27: [materialadmin.smx] Check Mute: STEAM_1:1:653474940. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:1:653474940$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP()) LIMIT 1
L 08/08/2022 - 21:52:27: [materialadmin.smx] CheckClientMute: set exp3nsive type 0
L 08/08/2022 - 21:52:27: [materialadmin.smx] Database failure when fetching warns count for exp3nsive<7><STEAM_1:1:653474940><>: Table 'db982124.sb_warns' doesn't exist
L 08/08/2022 - 21:54:56: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:0:504175119', '5.130.16.5', 'Unicorn', 1659970496)
L 08/08/2022 - 21:55:13: [materialadmin.smx] plugin version 0.8.6-8e1058b game 4
L 08/08/2022 - 21:55:16: [materialadmin.smx] ConnectBd: yes
L 08/08/2022 - 21:55:16: [materialadmin.smx] GroupsDone:QUERY: SELECT sg.`id`, sg.`name`, sg.`flags`, sg.`immunity`, sg.`maxbantime`, sg.`maxmutetime`, so.`type`, so.`name`, so.`access` FROM `sb_srvgroups` sg LEFT JOIN `sb_srvgroups_overrides` so ON sg.`id` = so.`group_id` ORDER BY sg.`id`, so.`id`
L 08/08/2022 - 21:55:16: [materialadmin.smx] AdminsDone:QUERY: SELECT `authid`, `srv_password`, (SELECT `name` FROM `sb_srvgroups` WHERE `name` = `srv_group`) AS `srv_group`, `srv_flags`, `user`, `immunity`, `expired`, `extraflags`, (SELECT `flags` FROM `sb_groups` WHERE `gid` = a.`gid`) AS `flags` FROM `sb_admins_servers_groups` AS asg LEFT JOIN `sb_admins` AS a ON a.`aid` = asg.`admin_id` WHERE (`expired` > UNIX_TIMESTAMP() OR `expired` = 0 OR `expired` = NULL) AND `authid` != 'STEAM_ID_SERVER' AND ((`server_id` = IFNULL ((SELECT `sid` FROM `sb_servers` WHERE `ip` = '90.189.159.30' AND `port` = '27070' LIMIT 1), 0) OR `srv_group_id` = ANY (SELECT `group_id` FROM `sb_servers_groups` WHERE `server_id` = IFNULL ((SELECT `sid` FROM `sb_servers` WHERE `ip` = '90.189.159.30' AND `port` = '27070' LIMIT 1), 0)))) GROUP BY `aid`, `authid`, `srv_password`, `srv_group`, `srv_flags`, `user`
L 08/08/2022 - 21:55:16: [materialadmin.smx] Failed to retrieve groups from the database, Unknown column 'sg.maxbantime' in 'field list'
L 08/08/2022 - 21:55:16: [materialadmin.smx] Failed to retrieve admins from the database, Unknown column 'expired' in 'field list'
L 08/08/2022 - 21:55:23: [materialadmin.smx] plugin version 0.8.6-8e1058b game 4
L 08/08/2022 - 21:55:24: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_bans` WHERE ((`type` = 0 AND `authid` REGEXP '^STEAM_[0-9]:1:569683485$') OR (`type` = 1 AND `ip` = '217.64.142.248')) LIMIT 1
L 08/08/2022 - 21:55:24: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_comms` WHERE (`authid` REGEXP '^STEAM_[0-9]:1:569683485$') LIMIT 1
L 08/08/2022 - 21:55:24: [materialadmin.smx] Checking ban for: STEAM_1:1:569683485. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:1:569683485$') OR (a.`type` = 1 AND a.`ip` = '217.64.142.248')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL LIMIT 1
L 08/08/2022 - 21:55:24: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_bans` WHERE ((`type` = 0 AND `authid` REGEXP '^STEAM_[0-9]:1:708477488$') OR (`type` = 1 AND `ip` = '100.82.188.29')) LIMIT 1
L 08/08/2022 - 21:55:24: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_comms` WHERE (`authid` REGEXP '^STEAM_[0-9]:1:708477488$') LIMIT 1
L 08/08/2022 - 21:55:24: [materialadmin.smx] Checking ban for: STEAM_1:1:708477488. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:1:708477488$') OR (a.`type` = 1 AND a.`ip` = '100.82.188.29')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL LIMIT 1
L 08/08/2022 - 21:55:24: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:1:569683485'
L 08/08/2022 - 21:55:24: [materialadmin.smx] Check Mute: STEAM_1:1:569683485. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:1:569683485$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP()) LIMIT 1
L 08/08/2022 - 21:55:24: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:1:708477488'
L 08/08/2022 - 21:55:24: [materialadmin.smx] Check Mute: STEAM_1:1:708477488. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:1:708477488$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP()) LIMIT 1
L 08/08/2022 - 21:55:24: [materialadmin.smx] CheckClientMute: set Hanma dwarf type 0
L 08/08/2022 - 21:55:24: [materialadmin.smx] CheckClientMute: set Зарежу нахуй type 0
L 08/08/2022 - 21:55:24: [materialadmin.smx] Database failure when fetching warns count for Hanma dwarf<3><STEAM_1:1:569683485><>: Table 'db982124.sb_warns' doesn't exist
L 08/08/2022 - 21:55:24: [materialadmin.smx] Database failure when fetching warns count for Зарежу нахуй<4><STEAM_1:1:708477488><>: Table 'db982124.sb_warns' doesn't exist
L 08/08/2022 - 21:55:27: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_bans` WHERE ((`type` = 0 AND `authid` REGEXP '^STEAM_[0-9]:0:504175119$') OR (`type` = 1 AND `ip` = '5.130.16.5')) LIMIT 1
L 08/08/2022 - 21:55:27: [materialadmin.smx] ma_checker: OnClientAuthorized Query SELECT COUNT(bid) FROM `sb_comms` WHERE (`authid` REGEXP '^STEAM_[0-9]:0:504175119$') LIMIT 1
L 08/08/2022 - 21:55:27: [materialadmin.smx] Checking ban for: STEAM_1:0:504175119. QUERY: SELECT a.`bid`, a.`length`, a.`created`, a.`reason`, b.`user` FROM `sb_bans` a LEFT JOIN `sb_admins` b ON a.`aid` = b.`aid` WHERE ((a.`type` = 0 AND a.`authid` REGEXP '^STEAM_[0-9]:0:504175119$') OR (a.`type` = 1 AND a.`ip` = '5.130.16.5')) AND (a.`length` = 0 OR a.`ends` > UNIX_TIMESTAMP()) AND a.`RemoveType` IS NULL LIMIT 1
L 08/08/2022 - 21:55:27: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM `offline` WHERE `auth` = 'STEAM_1:0:504175119'
L 08/08/2022 - 21:55:27: [materialadmin.smx] Check Mute: STEAM_1:0:504175119. QUERY: SELECT (c.`ends` - UNIX_TIMESTAMP()), c.`type`, c.`length`, c.`reason`, a.`authid` FROM `sb_comms` AS c LEFT JOIN `sb_admins` AS a ON a.`aid` = c.`aid` LEFT JOIN `sb_srvgroups` AS g ON g.`name` = a.`srv_group` WHERE `RemoveType` IS NULL AND c.`authid` REGEXP '^STEAM_[0-9]:0:504175119$' AND (`length` = 0 OR `ends` > UNIX_TIMESTAMP()) LIMIT 1
L 08/08/2022 - 21:55:27: [materialadmin.smx] CheckClientMute: set Unicorn type 0
L 08/08/2022 - 21:55:27: [materialadmin.smx] Database failure when fetching warns count for Unicorn<5><STEAM_1:0:504175119><>: Table 'db982124.sb_warns' doesn't exist
L 08/08/2022 - 21:55:48: [materialadmin.smx] GroupsDone:QUERY: SELECT sg.`id`, sg.`name`, sg.`flags`, sg.`immunity`, sg.`maxbantime`, sg.`maxmutetime`, so.`type`, so.`name`, so.`access` FROM `sb_srvgroups` sg LEFT JOIN `sb_srvgroups_overrides` so ON sg.`id` = so.`group_id` ORDER BY sg.`id`, so.`id`
L 08/08/2022 - 21:55:48: [materialadmin.smx] AdminsDone:QUERY: SELECT `authid`, `srv_password`, (SELECT `name` FROM `sb_srvgroups` WHERE `name` = `srv_group`) AS `srv_group`, `srv_flags`, `user`, `immunity`, `expired`, `extraflags`, (SELECT `flags` FROM `sb_groups` WHERE `gid` = a.`gid`) AS `flags` FROM `sb_admins_servers_groups` AS asg LEFT JOIN `sb_admins` AS a ON a.`aid` = asg.`admin_id` WHERE (`expired` > UNIX_TIMESTAMP() OR `expired` = 0 OR `expired` = NULL) AND `authid` != 'STEAM_ID_SERVER' AND ((`server_id` = 1 OR `srv_group_id` = ANY (SELECT `group_id` FROM `sb_servers_groups` WHERE `server_id` = 1))) GROUP BY `aid`, `authid`, `srv_password`, `srv_group`, `srv_flags`, `user`
L 08/08/2022 - 21:55:48: [materialadmin.smx] Failed to retrieve groups from the database, Unknown column 'sg.maxbantime' in 'field list'
L 08/08/2022 - 21:55:48: [materialadmin.smx] Failed to retrieve admins from the database, Unknown column 'expired' in 'field list'
L 08/08/2022 - 22:00:47: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO `offline` (`auth`, `ip`, `name`, `disc_time`) VALUES ('STEAM_1:0:504175119', '5.130.16.5', 'Unicorn', 1659970847)
L 08/08/2022 - 22:01:10: [materialadmin.smx] ConnectBd: lost
L 08/08/2022 - 22:01:10: [materialadmin.smx] ConnectBd: yes
L 08/08/2022 - 22:01:15: [materialadmin.smx] GroupsDone:QUERY: SELECT sg.`id`, sg.`name`, sg.`flags`, sg.`immunity`, sg.`maxbantime`, sg.`maxmutetime`, so.`type`, so.`name`, so.`access` FROM `sb_srvgroups` sg LEFT JOIN `sb_srvgroups_overrides` so ON sg.`id` = so.`group_id` ORDER BY sg.`id`, so.`id`
L 08/08/2022 - 22:01:15: [materialadmin.smx] AdminsDone:QUERY: SELECT `authid`, `srv_password`, (SELECT `name` FROM `sb_srvgroups` WHERE `name` = `srv_group`) AS `srv_group`, `srv_flags`, `user`, `immunity`, `expired`, `extraflags`, (SELECT `flags` FROM `sb_groups` WHERE `gid` = a.`gid`) AS `flags` FROM `sb_admins_servers_groups` AS asg LEFT JOIN `sb_admins` AS a ON a.`aid` = asg.`admin_id` WHERE (`expired` > UNIX_TIMESTAMP() OR `expired` = 0 OR `expired` = NULL) AND `authid` != 'STEAM_ID_SERVER' AND ((`server_id` = 1 OR `srv_group_id` = ANY (SELECT `group_id` FROM `sb_servers_groups` WHERE `server_id` = 1))) GROUP BY `aid`, `authid`, `srv_password`, `srv_group`, `srv_flags`, `user`
L 08/08/2022 - 22:01:15: [materialadmin.smx] Failed to retrieve groups from the database, Unknown column 'sg.maxbantime' in 'field list'
L 08/08/2022 - 22:01:15: [materialadmin.smx] Failed to retrieve admins from the database, Unknown column 'expired' in 'field list'
 
Последнее редактирование:

Hiirbeg

Участник
Сообщения
24
Реакции
0
Всем привет. Кто нибудь знает как это можно исправить?
1660213687890.png
1660213714334.png
 

ReMiX2021

Участник
Сообщения
2
Реакции
0
Здрасвуйте, у меня проблема с выдачей админок и мутов и банов (Ps. У меня все с БД нормально, пишет в консоль через команду ma_bd_connect, что подключения есть) смотрите я когда через web пытаюсь себя кикнуить то все получеться, а если я например пытаюсь себя замутить, забанить, то не получаеться, надо перезапускать сервер чтобы зарбототало, а с админками даже с перезагрузкой не работает
 

ahtohx_

Участник
Сообщения
79
Реакции
23
Подскажите пожалуйста, в чём проблема? Версия сборки последняя, стоит FastCGI (Nginx + PHP-FPM), PHP 7.4.29.
Ошибка при открытии веба.
An exception occured: [Error] Call to undefined method SessionManager::setupParameters() in /init.php on line 322
  1. include_once() in /index.php at line 38
 

Kruzya

Rust как смысл жизни
Сообщения
12,385
Реакции
10,473
  • Команда форума
  • Автор ресурса
  • #8,832
@ahtohx_, обновили не полностью. Там ещё папка includes менялась.
 

ahtohx_

Участник
Сообщения
79
Реакции
23
@ahtohx_, обновили не полностью. Там ещё папка includes менялась.
Понял, спасибо. Давно ещё хотел спросить про SMTP функцию, она рабочая? Уже давно юзаю сбма, но ни в одной не получилось её настроить. Хотя данные от почты определённо правильные.
Логи, как правило, пустые.
 

Kruzya

Rust как смысл жизни
Сообщения
12,385
Реакции
10,473
  • Команда форума
  • Автор ресурса
  • #8,834
@ahtohx_, в каких то случаях работает, в каких-то нет. Сложно сказать чем это вызвано.
 

ahtohx_

Участник
Сообщения
79
Реакции
23
@ahtohx_, в каких то случаях работает, в каких-то нет. Сложно сказать чем это вызвано.
Ок, подскажи пожалуйста. Где можно поменять данные от бд? Изменил config напрямую в дате, не помогло. Всё ещё ищет по старым.
 

Kruzya

Rust как смысл жизни
Сообщения
12,385
Реакции
10,473
  • Команда форума
  • Автор ресурса
  • #8,836
@ahtohx_, в дате лежит две конфы с данными от бд: config.php и db.php
 

gopnik9999g

Участник
Сообщения
71
Реакции
8
Подскажите какую лучше версию качать чтобы стабильно работала 1.1.5.4 или 1.1.6?
Буду использовать под новую серверную часть... А о существовании 1.1.6 вообще не знал
И почему при установке говорят что в databases нужно прописать sourcebans и sourcecomms???
Раньше же нужно было вписывать только одно materialadmin
Что-то я запутался что вписывать в databases на самом деле...
@Kruzya Выручи пожалуйста ещё раз меня бестолкового 😢
 

kilex

Участник
Сообщения
214
Реакции
3
Подскажите какую лучше версию качать чтобы стабильно работала 1.1.5.4 или 1.1.6?
Буду использовать под новую серверную часть... А о существовании 1.1.6 вообще не знал
И почему при установке говорят что в databases нужно прописать sourcebans и sourcecomms???
Раньше же нужно было вписывать только одно materialadmin
Что-то я запутался что вписывать в databases на самом деле...
@Kruzya Выручи пожалуйста ещё раз меня бестолкового 😢
нужно вписать сурс банс и сурс комс в датабейз а также материал админ, должно быть 3 секции
Сообщения автоматически склеены:

Подскажите какую лучше версию качать чтобы стабильно работала 1.1.5.4 или 1.1.6?
я использую версию 1.1.6
 

gopnik9999g

Участник
Сообщения
71
Реакции
8
нужно вписать сурс банс и сурс комс в датабейз а также материал админ, должно быть 3 секции
Сообщения автоматически склеены:


я использую версию 1.1.6
Впервые такое слышу, что нужно аж 3 секции вписывать О_О
Ты точно уверен в этом? И Базу Данных и пользователя БД также вписывать одну?
И ты точно используешь Новую серверную часть? Не старую случаем?
Не уверен в версии 1.1.6, хотелось бы услышать ответ от @Kruzya
 

kilex

Участник
Сообщения
214
Реакции
3
Впервые такое слышу, что нужно аж 3 секции вписывать О_О
Ты точно уверен в этом? И Базу Данных и пользователя БД также вписывать одну?
И ты точно используешь Новую серверную часть? Не старую случаем?
Не уверен в версии 1.1.6, хотелось бы услышать ответ от @Kruzya
крузя лайкнул меня значит я правильно сказал :)
 
Сверху Снизу