[urus]

Originally Posted by Jedi I'm seeing the same thing, except with a twist. When I issue a temp ban (10 minutes), the ban shows up once in the ban list. However, when the ban expires, the ban then shows up 3 times in the ban list (as expired on each one).

Yes. I have it too.
I add logging function and created 30 seconds timer for test:
CreateTimer(30.0, PruneBans);

It seems like timer for prune bans started three or four times !!!

START SERVER

L 12/25/2007 - 11:34:29: [sourcebans_RC2_42.smx] [SourceBans] PruneBans timer was created
L 12/25/2007 - 11:34:29: [sourcebans_RC2_42.smx] SELECT authid, srv_password , srv_group, srv_flags, user, immunity  FROM sb_admins_servers_groups AS asg LEFT JOIN sb_admins AS a ON a.aid = asg.admin_id WHERE (server_id = (SELECT `sid` FROM `sb_servers` WHERE `ip` = 'xxxx AND `port` = 'xxxxx' LIMIT 0,1)  OR srv_group_id = ANY (    SELECT group_id    FROM sb_servers_groups    WHERE server_id = (SELECT `sid` FROM `sb_servers` WHERE `ip` = 'xxxxxxxx' AND `port` = 'xxx' LIMIT 0,1))) GROUP BY aid, authid, srv_password, srv_group, srv_flags, user
L 12/25/2007 - 11:34:29: [sourcebans_RC2_42.smx] [SourceBans] PruneBans timer was created
L 12/25/2007 - 11:34:29: [sourcebans_RC2_42.smx] [SourceBans] PruneBans timer was created
L 12/25/2007 - 11:34:29: [sourcebans_RC2_42.smx] [SourceBans] PruneBans timer was created
L 12/25/2007 - 11:34:29: [sourcebans_RC2_42.smx] Unknown group ""
L 12/25/2007 - 11:34:59: [sourcebans_RC2_42.smx] [SourceBans] Prune Bans executed (by timer) INSERT INTO _banhistory
L 12/25/2007 - 11:34:59: [sourcebans_RC2_42.smx] [SourceBans] Prune Bans executed (by timer) INSERT INTO _banhistory
L 12/25/2007 - 11:34:59: [sourcebans_RC2_42.smx] [SourceBans] Prune Bans executed (by timer) INSERT INTO _banhistory
L 12/25/2007 - 11:34:59: [sourcebans_RC2_42.smx] [SourceBans] Prune Bans executed (by timer) INSERT INTO _banhistory
L 12/25/2007 - 11:34:59: [sourcebans_RC2_42.smx] [SourceBans] Prune Bans executed (by timer) DELETE FROM _bans
L 12/25/2007 - 11:34:59: [sourcebans_RC2_42.smx] [SourceBans] Prune Bans executed (by timer) DELETE FROM _bans
L 12/25/2007 - 11:35:00: [sourcebans_RC2_42.smx] [SourceBans] Prune Bans executed (by timer) DELETE FROM _bans
L 12/25/2007 - 11:35:00: [sourcebans_RC2_42.smx] [SourceBans] Prune Bans executed (by timer) DELETE FROM _bans

MANUAL  MAP CHANGE

L 12/25/2007 - 11:41:06: [sourcebans_RC2_42.smx] [SourceBans] PruneBans timer was created
L 12/25/2007 - 11:41:06: [sourcebans_RC2_42.smx] [SourceBans] PruneBans timer was created
L 12/25/2007 - 11:41:06: [sourcebans_RC2_42.smx] [SourceBans] PruneBans timer was created
L 12/25/2007 - 11:41:06: [sourcebans_RC2_42.smx] SELECT authid, srv_password , srv_group, srv_flags, user, immunity  FROM sb_admins_servers_groups AS asg LEFT JOIN sb_admins AS a ON a.aid = asg.admin_id WHERE (server_id = (SELECT `sid` FROM `sb_servers` WHERE `ip` = 'xxxxxx' AND `port` = 'xx' LIMIT 0,1)  OR srv_group_id = ANY (    SELECT group_id    FROM sb_servers_groups    WHERE server_id = (SELECT `sid` FROM `sb_servers` WHERE `ip` = 'xxxxxxx AND `port` = 'xxxxxxxx' LIMIT 0,1))) GROUP BY aid, authid, srv_password, srv_group, srv_flags, user
L 12/25/2007 - 11:41:08: [sourcebans_RC2_42.smx] Unknown group ""
L 12/25/2007 - 11:41:38: [sourcebans_RC2_42.smx] [SourceBans] Prune Bans executed (by timer) INSERT INTO _banhistory
L 12/25/2007 - 11:41:38: [sourcebans_RC2_42.smx] [SourceBans] Prune Bans executed (by timer) INSERT INTO _banhistory
L 12/25/2007 - 11:41:38: [sourcebans_RC2_42.smx] [SourceBans] Prune Bans executed (by timer) INSERT INTO _banhistory
L 12/25/2007 - 11:41:38: [sourcebans_RC2_42.smx] [SourceBans] Prune Bans executed (by timer) DELETE FROM _bans
L 12/25/2007 - 11:41:38: [sourcebans_RC2_42.smx] [SourceBans] Prune Bans executed (by timer) DELETE FROM _bans
L 12/25/2007 - 11:41:39: [sourcebans_RC2_42.smx] [SourceBans] Prune Bans executed (by timer) DELETE FROM _bans

[Olly]

Originally Posted by urus Yes. I have it too. I add logging function and created 30 seconds timer for test: CreateTimer(30.0, PruneBans); It seems like timer for prune bans started three or four times !!! START SERVER L 12/25/2007 - 11:34:29: [sourcebans_RC2_42.smx] [SourceBans] PruneBans timer was created L 12/25/2007 - 11:34:29: [sourcebans_RC2_42.smx] SELECT authid, srv_password , srv_group, srv_flags, user, immunity FROM sb_admins_servers_groups AS asg LEFT JOIN sb_admins AS a ON a.aid = asg.admin_id WHERE (server_id = (SELECT `sid` FROM `sb_servers` WHERE `ip` = 'xxxx AND `port` = 'xxxxx' LIMIT 0,1) OR srv_group_id = ANY ( SELECT group_id FROM sb_servers_groups WHERE server_id = (SELECT `sid` FROM `sb_servers` WHERE `ip` = 'xxxxxxxx' AND `port` = 'xxx' LIMIT 0,1))) GROUP BY aid, authid, srv_password, srv_group, srv_flags, user L 12/25/2007 - 11:34:29: [sourcebans_RC2_42.smx] [SourceBans] PruneBans timer was created L 12/25/2007 - 11:34:29: [sourcebans_RC2_42.smx] [SourceBans] PruneBans timer was created L 12/25/2007 - 11:34:29: [sourcebans_RC2_42.smx] [SourceBans] PruneBans timer was created L 12/25/2007 - 11:34:29: [sourcebans_RC2_42.smx] Unknown group "" L 12/25/2007 - 11:34:59: [sourcebans_RC2_42.smx] [SourceBans] Prune Bans executed (by timer) INSERT INTO _banhistory L 12/25/2007 - 11:34:59: [sourcebans_RC2_42.smx] [SourceBans] Prune Bans executed (by timer) INSERT INTO _banhistory L 12/25/2007 - 11:34:59: [sourcebans_RC2_42.smx] [SourceBans] Prune Bans executed (by timer) INSERT INTO _banhistory L 12/25/2007 - 11:34:59: [sourcebans_RC2_42.smx] [SourceBans] Prune Bans executed (by timer) INSERT INTO _banhistory L 12/25/2007 - 11:34:59: [sourcebans_RC2_42.smx] [SourceBans] Prune Bans executed (by timer) DELETE FROM _bans L 12/25/2007 - 11:34:59: [sourcebans_RC2_42.smx] [SourceBans] Prune Bans executed (by timer) DELETE FROM _bans L 12/25/2007 - 11:35:00: [sourcebans_RC2_42.smx] [SourceBans] Prune Bans executed (by timer) DELETE FROM _bans L 12/25/2007 - 11:35:00: [sourcebans_RC2_42.smx] [SourceBans] Prune Bans executed (by timer) DELETE FROM _bans MANUAL MAP CHANGE L 12/25/2007 - 11:41:06: [sourcebans_RC2_42.smx] [SourceBans] PruneBans timer was created L 12/25/2007 - 11:41:06: [sourcebans_RC2_42.smx] [SourceBans] PruneBans timer was created L 12/25/2007 - 11:41:06: [sourcebans_RC2_42.smx] [SourceBans] PruneBans timer was created L 12/25/2007 - 11:41:06: [sourcebans_RC2_42.smx] SELECT authid, srv_password , srv_group, srv_flags, user, immunity FROM sb_admins_servers_groups AS asg LEFT JOIN sb_admins AS a ON a.aid = asg.admin_id WHERE (server_id = (SELECT `sid` FROM `sb_servers` WHERE `ip` = 'xxxxxx' AND `port` = 'xx' LIMIT 0,1) OR srv_group_id = ANY ( SELECT group_id FROM sb_servers_groups WHERE server_id = (SELECT `sid` FROM `sb_servers` WHERE `ip` = 'xxxxxxx AND `port` = 'xxxxxxxx' LIMIT 0,1))) GROUP BY aid, authid, srv_password, srv_group, srv_flags, user L 12/25/2007 - 11:41:08: [sourcebans_RC2_42.smx] Unknown group "" L 12/25/2007 - 11:41:38: [sourcebans_RC2_42.smx] [SourceBans] Prune Bans executed (by timer) INSERT INTO _banhistory L 12/25/2007 - 11:41:38: [sourcebans_RC2_42.smx] [SourceBans] Prune Bans executed (by timer) INSERT INTO _banhistory L 12/25/2007 - 11:41:38: [sourcebans_RC2_42.smx] [SourceBans] Prune Bans executed (by timer) INSERT INTO _banhistory L 12/25/2007 - 11:41:38: [sourcebans_RC2_42.smx] [SourceBans] Prune Bans executed (by timer) DELETE FROM _bans L 12/25/2007 - 11:41:38: [sourcebans_RC2_42.smx] [SourceBans] Prune Bans executed (by timer) DELETE FROM _bans L 12/25/2007 - 11:41:39: [sourcebans_RC2_42.smx] [SourceBans] Prune Bans executed (by timer) DELETE FROM _bans

Hmmmmm, thanks for making that log, looks like there is a handle that keeps getting created over and over

[Nolongerinthegame]

I am now getting the old " Query failed! Column 'sid' cannot be null" when banning someone on the server using RC2 42

[Gweedo]

Originally Posted by Jedi I'm seeing the same thing, except with a twist. When I issue a temp ban (10 minutes), the ban shows up once in the ban list. However, when the ban expires, the ban then shows up 3 times in the ban list (as expired on each one). Any ideas?

After a little more looking this is what I am seeing also. The bans only show up three times after they expire.

[Olly]

Ok, for all of you wondering about the future about SourceBans, you may be interested in this...

Originally Posted by SteamBans The Steambans team would like to wish all our friends, players, partners and affiliates a merry Christmas and great Happy Holidays. Right now our developers team is working very hard on the new Steambans system that will be ready somewhere in the beginning of 2008. The new system will include a whole 'Olly'bunch of changes and optimizations and to give you a little taste of what's coming, here are some of the new features: New site layout, design and structure for easy nagivation Implementation of the Sourcebans system which includes your own custom banlist and admin management functionality (SourceMod) Revised plugin with enhanced features and functionality (more details soon) Multiple servers worldwide for faster access (thanks to TechConnect, Evolans, Killercreation and NuclearFallout) Ofcourse there is way more to come but for most things we just want to wait until they are completely implemented and ready to be used. The developers team would love to hear suggestions so we can make the new system as good as possible, please click here to post your ideas. For now, stay tuned cause 2008 is going to be a big year for Steambans!

From: http://steambans.com/news.php?id=1523

;)


I am not sure yet if i will continue to support the 'standalone' version (The one currently available to download) but if enough people request it, then hopefully I can keep it going.

The main idea behind this is, all of your bans for your servers will be stored on SteamBans servers, and also admin permissions. Think of it like a copy of SourceBans that is hosted by SteamBans.com. With the system like this, you wont need to worry about hosting, installing, and, setting up the system, and also any bugs found will be able to be instantly applied to everyone. The idea is that this wont be just a SourceBans that is hosted for you, it will be integrated with the rest of the whole website, so that it can give more features.

One feature i would like to mention that we have planned is, if say one player is banned on x amount of servers for something like mic spamming, then if the ban count of the user goes past a threshold then that player will be banned on all servers that are connected to SteamBans that have enabled that option.

So there will be lots more possibilities for us to create doing this.

As the post says, if you have any suggestions, then please post them here:

http://www.steambans.com/forums.php?fid=10&tid=6722


Merry Xmas
Olly

[Gweedo]

I personally would like to see SourceBans reach at least a finished state. It's a very good ban/admin management solution for people who prefer to host their own stuff and more importantly prefer not to use a community ban system.

[Manni]

Yes, it would be nice, to have a good working standalone SoourceBans.
What is, if people don't want to install this steambans thing, they can't use such a good banlist? That would be crap.

Some more bugs to fix and then it's ready i guess?

[PubGamer Probationer]

+ 1 for standalone , it seems like its not far off being complete with its current set of features. Seems like a shame to let it die . I'm really not keen on someone else hosting my stuff.

Keep up the good work Olly *please*

[SaintK]

+100 for standalone, i really don't want a system like Steambans attached to my servers.

[doa]

I am a big fan of Sourcebans, and really like the way we nowadays can administrate our bans across all our servers. I do use SteamBans as well, and am happy to let them live their own lifes becuase I dont want to place our bans and admin permission in anyone elses hands.

Lets hope Olly continues to develop and support Sourcebans as a standalone product.
At the same time I would also like to thank Olly for Sourcebans and all work he put into it so far.