[disconnect81]

Which ports on the webserver/sql server, need to be open for this to work? just 27015?

[Nolongerinthegame]

UPDATE:

i managed to remove all references to sb_banhistory in my sql file (and obviously not creating the table). And i successfully reimported the sourcebans database


what happens is if i ban someone i get this sql error which i got before

www.dragonrock.org/sourcebans.jpg

Why is still refering to sb_banhistory when i have the latest versions of sourcebans? and theres no tables created in the sql or database called sb_banhistory. Zilch

But the people on the banlist are still blocked on the server

[DJ Tsunami]

There are still some left over references to sb_banhistory apparently, which we'll need to remove. Disconnect81 also reported this, but thanks anyway. It will be fixed soon.

[ShadowMoses]

Just thought I would try to help out on the banhistory references.

includes/system-functions.php
On line 647 in the function PruneBans()

PHP Code:

function PruneBans()
{
    $res = $GLOBALS['db']->Execute("INSERT INTO `".DB_PREFIX."_banhistory` (`Type` , `RemovedOn` , `RemovedBy` , `IP` , `AuthId` , `Name` , `Created` , `Ends` , `Length` , `Reason` , `AdminId` , `AdminIp` , `SId`) 
                                     SELECT 'E', UNIX_TIMESTAMP(), '0', `ip` , `authid` , `name` , `Created` , `Ends` , `Length` , `Reason` , `aid` , `adminIp` , `sid` FROM `".DB_PREFIX."_bans` WHERE `Length` != '0' AND `Ends` < UNIX_TIMESTAMP()");    
    if($res)
    {
        $GLOBALS['db']->Execute("DELETE FROM `".DB_PREFIX."_bans` WHERE `Length` != '0' AND `Ends` < UNIX_TIMESTAMP()");
        return true;
    }
    return false;
} 


Hope this helps.

Regards,

Shadow

[disconnect81]

So I have this all set up, but I am having a problem with banning. It seems that when someone is banned from inside the server, they are added to the banned_id.cfg as well as the database. When i remove the ban using the webpage, the ban in the banned_id.cfg remains in place, thus keeping the person banned.

FYI, I did remove basebans.smx

[Guntrip]

I've got the web panel installed and configured, but I'm having trouble with the plugin itself, and when sourcemod tries to load it it produces this error:

"[SM] Unable to load plugin "sourcebans.smx": Native "SQL_EscapeString" was not found."

Is there something I've missed out or not configured? I couldn't find any other reference to the problem from anyone else.

Cheers.

[PhO3n1X]

I have installed latest Sourcebans version, webpanel and plugin works fine. But:
1) When ban expires (or get unbanned) it don't removes from server, it still say that this ID banned, only when I restart server player can join again.
2) In server list all servers are visible, but don't show Player who play on it. It say "Retreiving players..."
3) Ban reason that writes in Cyrillic don't displays correctly (i think Banned players names don't displays too)
4) If player banned, and try to connect to server, message with link on my site displays only 2 times, after 3 tries it say that this ID banned (can I do that it displays link all time)

[ShadowMoses]

In your addons/sourcemod/configs/sourcebans/sourcebans.cfg make sure you have put the correct ServerID in your config. Also if you have -ip on your startup you must change AutoAddServer to 1 and put your serverIP and ServerPort in your config as well.

I have noticed a problem with the dark theme not displaying things correctly also, so make sure you are using the default theme. For example, the OS and VAC do not show up on dark theme. Under admin/servers the ServerID does not show up which you need that to put in you cfg.

Try that and let us know.

[ShadowMoses]

For the server ID in the dark theme add this to
themes/sourcebans_dark/page_admin_servers_list.tpl

Add new line after <tr> on line 11:

<td class="front-module-header" height='16'><strong>ID</strong></td>

Add new line after <tr id="sid_{$server.sid}"> on line 20

<td style="border-bottom: solid 1px #ccc" height='16'>{$server.sid}</td>

Haven't found the other problems with the theme yet.

[r3dh3adkid]

So i'm stuck on the installation guide thing. I get to the part where i'm creating the table I assume and I get an error and nothing shows for the error or on the page for that matter :-/

Error
 		
		There was an error creating the table structure. Please read the message above to help debug the problem.
 		[OK]

I get that at the top of the SoureBans text and then the only thing that shows below the
Table installation


header is the OK button plus all of the Automated text at the bottem.



any suggestions?