NewServer

NewServer copied to clipboard

Перейду к суте проблем, materialadmin проработал 20 дней без проблем, после он начал чем-то страдать, когда банишь человека пплагин банит его по неск раз и в базе забаненный указывается так же неск раз. Как это можно пофиксить? P.S. Я никаких настроек не изменял в плагине, и не редактировал код. Скрины: https://prntscr.com/p9i1z9 https://prntscr.com/p9i22y https://prntscr.com/p9i25j

SourceSleuth включен? Мб он шалит.

У меня меня вообще нет SourceSleuth. Плагин банит именно по id

Он встроен в плагин, потому он есть. Он может быть либо включен, либо выключен. И настраивается это в конфиге.

SourceSleuth в конфиге стоит на 0

Так и как мне пофиксить это?

Есть возможность скомпилировать плагин с отладкой? Хочется увидеть, что плагин в этот момент делает. Какие именно запросы шлет.

Что мне сделать чтобы он с отладкой скомпилился?

https://github.com/SB-MaterialAdmin/NewServer/blob/master/addons/sourcemod/scripting/include/materialadmin.inc#L34 Сюда единичку прописать вместо нуля.

Наконец-то я поймал тот баг. Теперь даже ещё 1 проблема, плагин как-то перебанивает аккаунты без ID Вот лог

L 09/25/2019 - 19:34:53: [materialadmin.smx] Checking ban for: STEAM_1:0:513912533. 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:513912533$') OR (a.type = 1 AND a.ip = '95.153.135.158')) AND (a.length = 0 OR a.ends > UNIX_TIMESTAMP()) AND a.RemoveType IS NULL LIMIT 1 L 09/25/2019 - 19:34:53: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM offline WHERE auth = 'STEAM_1:0:513912533' L 09/25/2019 - 19:34:53: [materialadmin.smx] Check Mute: STEAM_1:0:513912533. 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:513912533$' AND (length = 0 OR ends > UNIX_TIMESTAMP()) LIMIT 1 L 09/25/2019 - 19:34:53: [materialadmin.smx] CheckClientMute: set ⚡💥VENOM⚡💥 type 0 L 09/25/2019 - 19:35:03: [materialadmin.smx] Checking ban for: STEAM_1:0:168177012. 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:168177012$') OR (a.type = 1 AND a.ip = '85.115.248.200')) AND (a.length = 0 OR a.ends > UNIX_TIMESTAMP()) AND a.RemoveType IS NULL LIMIT 1 L 09/25/2019 - 19:35:03: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM offline WHERE auth = 'STEAM_1:0:168177012' L 09/25/2019 - 19:35:03: [materialadmin.smx] Check Mute: STEAM_1:0:168177012. 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:168177012$' AND (length = 0 OR ends > UNIX_TIMESTAMP()) LIMIT 1 L 09/25/2019 - 19:35:03: [materialadmin.smx] CheckClientMute: set @13_suicide_boys_12 type 0 L 09/25/2019 - 19:35:09: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO offline (auth, ip, name, disc_time) VALUES ('STEAM_1:0:499031571', '128.69.112.20', 'omerзителен cs.money', 1569429309) L 09/25/2019 - 19:35:36: [materialadmin.smx] Checking ban for: STEAM_1:0:515174330. 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:515174330$') OR (a.type = 1 AND a.ip = '47.8.128.226')) AND (a.length = 0 OR a.ends > UNIX_TIMESTAMP()) AND a.RemoveType IS NULL LIMIT 1 L 09/25/2019 - 19:35:36: [materialadmin.smx] DelOflineInfo:QUERY: DELETE FROM offline WHERE auth = 'STEAM_1:0:515174330' L 09/25/2019 - 19:35:36: [materialadmin.smx] Check Mute: STEAM_1:0:515174330. 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:515174330$' AND (length = 0 OR ends > UNIX_TIMESTAMP()) LIMIT 1 L 09/25/2019 - 19:35:36: [materialadmin.smx] CheckClientMute: set RtxVenom type 0 L 09/25/2019 - 19:35:43: [materialadmin.smx] Checking ban in bd: STEAM_ID_SERVER. 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]:SERVER$') AND (length = 0 OR ends > UNIX_TIMESTAMP()) L 09/25/2019 - 19:35:43: [materialadmin.smx] Checking ban in bd: STEAM_ID_SERVER. 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]:SERVER$') AND (length = 0 OR ends > UNIX_TIMESTAMP()) L 09/25/2019 - 19:35:43: [materialadmin.smx] Checking ban in bd: STEAM_ID_SERVER. 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]:SERVER$') AND (length = 0 OR ends > UNIX_TIMESTAMP()) L 09/25/2019 - 19:35:43: [materialadmin.smx] Checking ban in bd: STEAM_ID_SERVER. 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]:SERVER$') AND (length = 0 OR ends > UNIX_TIMESTAMP()) L 09/25/2019 - 19:35:43: [materialadmin.smx] Create bd: client 0, target 12, Type 1, MuteType 0 L 09/25/2019 - 19:35:43: [materialadmin.smx] create bd: INSERT INTO sb_bans (type, ip, authid, name, created, ends, length, reason, aid, adminIp, sid, country) VALUES (0, '95.153.135.158', 'STEAM_1:0:513912533', '⚡VENOM⚡', UNIX_TIMESTAMP(), UNIX_TIMESTAMP() + 0, 0, '[HotGuard] Фейковые Приседания', 0, 'STEAM_ID_SERVER', 2, ' ') L 09/25/2019 - 19:35:43: [materialadmin.smx] Checking ban in bd: STEAM_ID_SERVER. 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]:SERVER$') AND (length = 0 OR ends > UNIX_TIMESTAMP()) L 09/25/2019 - 19:35:43: [materialadmin.smx] Checking ban in bd: STEAM_ID_SERVER. 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]:_SERVER$') AND (length = 0 OR ends > UNIX_TIMESTAMP()) L 09/25/2019 - 19:35:43: [materialadmin.smx] SetOflineInfo:QUERY: INSERT INTO offline (auth, ip, name, disc_time) VALUES ('STEAM_1:0:513912533', '95.153.135.158', '⚡💥VENOM⚡💥', 1569429343) L 09/25/2019 - 19:35:43: [materialadmin.smx] Create bd: client 0, target 12, Type 1, MuteType 0 L 09/25/2019 - 19:35:43: [materialadmin.smx] create bd: INSERT INTO sb_bans (type, ip, authid, name, created, ends, length, reason, aid, adminIp, sid, country) VALUES (0, '95.153.135.158', 'STEAM_ID_SERVER', '⚡💥VENOM⚡💥', UNIX_TIMESTAMP(), UNIX_TIMESTAMP() + 0, 0, '[HotGuard] Фейковые Приседания', 0, 'STEAM_ID_SERVER', 2, ' ') L 09/25/2019 - 19:35:43: [materialadmin.smx] Create bd: client 0, target 12, Type 1, MuteType 0 L 09/25/2019 - 19:35:43: [materialadmin.smx] create bd: INSERT INTO sb_bans (type, ip, authid, name, created, ends, length, reason, aid, adminIp, sid, country) VALUES (0, '95.153.135.158', 'STEAM_ID_SERVER', '⚡💥VENOM⚡💥', UNIX_TIMESTAMP(), UNIX_TIMESTAMP() + 0, 0, '[HotGuard] Фейковые Приседания', 0, 'STEAM_ID_SERVER', 2, ' ') L 09/25/2019 - 19:35:43: [materialadmin.smx] Create bd: client 0, target 12, Type 1, MuteType 0 L 09/25/2019 - 19:35:43: [materialadmin.smx] create bd: INSERT INTO sb_bans (type, ip, authid, name, created, ends, length, reason, aid, adminIp, sid, country) VALUES (0, '95.153.135.158', 'STEAM_ID_SERVER', '⚡💥VENOM⚡💥', UNIX_TIMESTAMP(), UNIX_TIMESTAMP() + 0, 0, '[HotGuard] Фейковые Приседания', 0, 'STEAM_ID_SERVER', 2, ' ') L 09/25/2019 - 19:35:43: [materialadmin.smx] Create bd: client 0, target 12, Type 1, MuteType 0 L 09/25/2019 - 19:35:43: [materialadmin.smx] create bd: INSERT INTO sb_bans (type, ip, authid, name, created, ends, length, reason, aid, adminIp, sid, country) VALUES (0, '', '', '', UNIX_TIMESTAMP(), UNIX_TIMESTAMP() + 0, 0, 'Нет причины', 0, 'STEAM_ID_SERVER', 2, ' ') L 09/25/2019 - 19:35:43: [materialadmin.smx] Create bd: client 0, target 12, Type 1, MuteType 0 L 09/25/2019 - 19:35:43: [materialadmin.smx] create bd: INSERT INTO sb_bans (type, ip, authid, name, created, ends, length, reason, aid, adminIp, sid, country) VALUES (0, '', '', '', UNIX_TIMESTAMP(), UNIX_TIMESTAMP() + 0, 0, 'Нет причины', 0, 'STEAM_ID_SERVER', 2, ' ')

ну это баг

Так он очень часто появляется. Просто засоряет всё. Не просто так же.

У меня такого нет. Стоит все последнее.

Гениально писать сюда, что у тебя всё последнее и такого нет xD

а что нельзя лол

Не в этом смысл.

смысл есть везде

Ты 10 заповедей читал? Там что-то об этом сказано? Что ты до меня докопался!

На следующий раз, лог пожалуйста файлом прикладывайте. На Гитхабе можно файлы аттачить.

ок