Плагин банит по несколько раз

Question

Плагин банит по несколько раз

fr0nch opened this issue 5 years ago · 19 comments

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

fr0nch commented 5 years ago

ок

Answer 1 · 2019-09-22T18:55:03.000Z

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

Answer 2 · 2019-09-22T18:58:09.000Z

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

Answer 3 · 2019-09-22T19:02:02.000Z

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

Answer 4 · 2019-09-22T19:04:51.000Z

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

Answer 5 · 2019-09-23T06:26:15.000Z

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

Answer 6 · 2019-09-23T07:25:27.000Z

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

Answer 7 · 2019-09-24T10:04:15.000Z

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

Answer 8 · 2019-09-24T13:34:31.000Z

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

Answer 9 · 2019-09-25T16:52:49.000Z

Наконец-то я поймал тот баг.
Теперь даже ещё 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, ' ')

Answer 10 · 2019-09-25T16:56:07.000Z

ну это баг

Answer 11 · 2019-09-25T16:57:45.000Z

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

Answer 12 · 2019-09-25T17:05:59.000Z

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

Answer 13 · 2019-09-25T17:07:57.000Z

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

Answer 14 · 2019-09-25T17:53:04.000Z

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

Answer 15 · 2019-09-25T17:54:25.000Z

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

Answer 16 · 2019-09-25T18:00:26.000Z

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

Answer 17 · 2019-09-25T18:01:52.000Z

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

Answer 18 · 2019-09-25T18:02:25.000Z

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