Raised This Month: $27 Target: $400

Player Ban stuck in sqlite file?

Post New Thread Reply   
Thread Tools Display Modes
Author Message
AlliedModders Donor
Join Date: Feb 2013
Location: Denmark
Old 03-01-2020 , 10:38   Player Ban stuck in sqlite file?
Reply With Quote #1


I have a player who was faulsly banned by an admin, and we have issues unbanning him.

We had a hacker on, with weird symbols, so our admin wanted to ban him, but there was another player on the server with weird symbols too, so both players were just squares on the admin menu.

The admin then banned the wrong player because there was a 50/50 chance of him finding the correct one. (Yes he could've written status in console and ban the ID).

Now the player that was wrongly banned, never appeared on Sourcebans. He's also only banned from that 1 server (We run multiple servers connected with the same sourcebans).

I managed to find his steam ID inside "listid", then i found his id and did "removeid", and then to update the list "writeid".

Now when i did this, the player could connect to the server, but as soon as map changes, he's banned again.

Asherkin on SM Discord pointed out to me, that SourceBans might overwrite the caching of this, which is good information, but it does not help me much.

I then went to my server terminal and searched my entire system for this players' steam ID.
In there i found that his steam ID could be found in 2 sqlite files from sourcebans.

I cannot open/read these sqlite files, and i don't know how to remove him from the list.
He never appeared on our Sourcebans dashboard, and his steamID cannot be found in the SQL database.

I'm currently stuck at this point, and i just want to grant this player his freedom once again.

Last edited by BReeZ; 03-01-2020 at 10:39.
BReeZ is offline
Great Tester of Whatever
Join Date: Dec 2016
Location: US
Old 03-02-2020 , 10:10   Re: Player Ban stuck in sqlite file?
Reply With Quote #2

You can open them using any sqlite tools, or simply remove and purge them and sourcebans will re-create those files again.

Fingerprint: 91CC4E84AE4BFA89F2E431DD462F405E7D61ED35

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

Github: https://github.com/rumblefrog

RumbleFrog is offline

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:35.

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