Raised This Month: $52 Target: $400
 13% 

Problem between the connection of database and gameserver plugin


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Geicher
Junior Member
Join Date: May 2015
Old 10-24-2015 , 08:35   Problem between the connection of database and gameserver plugin
Reply With Quote #1

Hey,

today I installed sourcebans on one of my servers, the connection between the webpanel and the database is working just fine.
Entering a ban there writes in the database correctly, however when I ban a user with the sb_ban command ingame he will be banned, but just until the server restarts and there is nothing written in the database!
Same goes the other way round, if I enter a ban in the webpanel the gameserver won't apply that ban! (It seems to me like there is no connection between the gameserver and the database)



Interestingly I can't find any logfiles in my /sourcemod/logs folder which makes it really hard for me to find the reason for this problem.



I'd appreciate some help and hope to find a solution so I can use this awesome plugin



Here is my databases.cfg & sourcebans.cfg:


Quote:
"Databases"
{
"driver_default" "mysql"

// When specifying "host", you may use an IP address, a hostname, or a socket file path

"sourcebans"
{
"driver" "mysql"
"host" "localhost"
"database" "sourcebans_db"
"user" "root"
"pass" "********"
//"timeout" "0"
"port" "3306"
}

"storage-local"
{
"driver" "sqlite"
"database" "sourcemod-local"
}

"clientprefs"
{
"driver" "sqlite"
"host" "localhost"
"database" "clientprefs-sqlite"
"user" "root"
"pass" ""
//"timeout" "0"
//"port" "0"
}
}


And this is my sourcebans.cfg

Quote:
/**
* SourceBans Configuration File
*
* @author GameConnect
* @version 2.0.0
* @copyright SourceBans (C)2007-2013 GameConnect.net. All rights reserved.
* @package SourceBans
* @link http://www.sourcebans.net
*/

"SourceBans"
{
"Config"
{
// Website address to tell where the player to go for unban, etc
"Website" "contact [email protected]"

// Allow or disallow admins access to sm_addban command
"Addban" "1"

// Allow or disallow admins access to sm_unban command
"Unban" "1"

// The table prefix you set while installing the webpanel. Default: "sb_"
"DatabasePrefix" "sb_"

// How many seconds to wait before retrying when a players ban fails to be checked. Min = 15.0 Max = 60.0
"RetryTime" "45.0"

// How often should we process the failed ban queue in minutes
"ProcessQueueTime" "5"

// Require the admin to login once into the webpanel
"RequireSiteLogin" "0"

// If your game server is behind NAT or -ip is not set on startup,
// enter the public IP address or hostname of your game server below
"ServerIP" "myserverip"
}

/*
* Menu options for ban times
*/
"BanTimes"
{
"Permanent"
{
"flags" ""
"length" "0"
}
"10 Minutes"
{
"flags" ""
"length" "10"
}
"30 Minutes"
{
"flags" ""
"length" "30"
}
"1 Hour"
{
"flags" ""
"length" "60"
}
"4 Hours"
{
"flags" ""
"length" "240"
}
"1 Day"
{
"flags" ""
"length" "1440"
}
"1 Week"
{
"flags" ""
"length" "10080"
}
}

/*
* Menu options for if a reason isn't supplied in a ban
* Without a supplied reason the ban will never be written to the database
*/
"BanReasons"
{
"1" "Hacking"
"2" "General Exploit of Game/Map/Server"
"3" "Team Killing"
"4" "Team Flashing"
"5" "Spamming Mic/Chat"
"6" "Inappropriate Spray"
"7" "Inappropriate Language"
"8" "Inappropriate Name"
"9" "Ignoring Admins"
"0" "Team Stacking"
"11" "Own Reason"
}

/*
* Submenu options for when "Hacking" is selected
* If "Hacking" removed from the menu above this will not be accessible
*/
"HackingReasons"
{
"1" "Aimbot"
"2" "Anti Recoil"
"3" "Wallhack"
"4" "Spinhack"
"5" "Speedhack"
"6" "Multi-Hack"
"7" "No Smoke"
"8" "No Flash"
}
}
Geicher 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 17:14.


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