Raised This Month: $9 Target: $400
 2% 

issue with bans!


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
scoty
Member
Join Date: Nov 2015
Old 12-04-2019 , 16:09   issue with bans!
Reply With Quote #1

Some players are getting banned when they try to join my server but they are not in the banlist, do you guys have any idea where the problem is?
scoty is offline
asdfxD
Veteran Member
Join Date: Apr 2011
Old 12-04-2019 , 22:17   Re: issue with bans!
Reply With Quote #2

It's because of some people use special chars in their name. Change code in sourcebans main.sp

SQL_SetCharset(DB, "utf8");

=>

SQL_SetCharset(DB, "utf8mb4");

and recompile the plugin, same do with sourcebans comms.
asdfxD is offline
scoty
Member
Join Date: Nov 2015
Old 12-06-2019 , 11:22   Re: issue with bans!
Reply With Quote #3

Most banned players doesn't have any special character un their name i also tried what you suggested and they are still banned
scoty is offline
asdfxD
Veteran Member
Join Date: Apr 2011
Old 12-06-2019 , 13:24   Re: issue with bans!
Reply With Quote #4

then something other is wrong with your sb, check error logs.

Last edited by asdfxD; 12-06-2019 at 13:24.
asdfxD is offline
scoty
Member
Join Date: Nov 2015
Old 12-08-2019 , 19:00   Re: issue with bans!
Reply With Quote #5

Last error was on 12/01/2019

Quote:
L 12/01/2019 - 10:42:26: [sbpp_main.smx] Query Failed: Incorrect string value: '\xF0\x9F\xA6\xB7' for column `u10002_sourcebans`.`sb_banlog`.`name` at row 1
Edit: https://forums.alliedmods.net/showthread.php?t=320151 im almost having the same problem

Last edited by scoty; 12-08-2019 at 19:20.
scoty is offline
RumbleFrog
Great Tester of Whatever
Join Date: Dec 2016
Location: US
Old 12-08-2019 , 22:17   Re: issue with bans!
Reply With Quote #6

Are you certain the sbpp_main is even loaded and connected to the database?

Also, this belongs in https://forums.alliedmods.net/forumdisplay.php?f=152
__________________


Fingerprint: 91CC4E84AE4BFA89F2E431DD462F405E7D61ED35

Reach me @ https://keybase.io/rumblefrog

Github: https://github.com/rumblefrog

RumbleFrog is offline
scoty
Member
Join Date: Nov 2015
Old 12-10-2019 , 08:11   Re: issue with bans!
Reply With Quote #7

sbpp_main is loaded

there are still players requesting for unban but couldnt find their ban anywhere...


Edit: i just noticed that these players are getting banned for 5minutes when ever they try to connect to the server

Thats what i get when i type "listid" via console

console:
Quote:
listid
ID filter list: 14 entries
1 STEAM_1:0:802**** : 5.000 min
2 STEAM_1:0:6850*** : 5.000 min
3 STEAM_1:1:4987**** : 5.000 min
4 STEAM_1:1:228***** : 5.000 min
5 STEAM_1:0:5024**** : 5.000 min
6 STEAM_1:0:4459**** : 5.000 min
7 STEAM_1:0:233***** : 5.000 min
8 STEAM_1:0:4326**** : 5.000 min
9 STEAM_1:1:44561**** : 5.000 min
10 STEAM_1:1:5110**** : 5.000 min
11 STEAM_1:1:5110**** : 5.000 min
12 STEAM_1:1:1154**** : 5.000 min
13 STEAM_1:1:4923**** : 5.000 min
14 STEAM_1:1:5015**** : 5.000 min

and one more thing that these players couldn't join at all even when these 5minutes are expired...

Last edited by scoty; 12-10-2019 at 08:39.
scoty is offline
RumbleFrog
Great Tester of Whatever
Join Date: Dec 2016
Location: US
Old 12-10-2019 , 19:18   Re: issue with bans!
Reply With Quote #8

Are there any connection issues? Can you check if they are in the backup database in data/sqlite?
__________________


Fingerprint: 91CC4E84AE4BFA89F2E431DD462F405E7D61ED35

Reach me @ https://keybase.io/rumblefrog

Github: https://github.com/rumblefrog


Last edited by RumbleFrog; 12-10-2019 at 19:18.
RumbleFrog is offline
scoty
Member
Join Date: Nov 2015
Old 12-17-2019 , 15:28   Re: issue with bans!
Reply With Quote #9

i found these bans in the sqlite file
scoty is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 08:29.


Powered by vBulletin®
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Theme made by Freecode