[jungjunghoo]

I can't sql admin

Why ?

Table 'smwa.sb_admins' doesn't exist

like this....

I'm using sourceban system and here is my database.cfg

thank you

 
 
"Databases"
{
 "driver_default"  "mysql"
 
 "sourcebans"
 {
  "driver"   "mysql"
  "host"    "localhost"
  "database"   "sb"
  "user"    "root"
  "pass"    "pass"
  //"timeout"   "0"
  "port"   "3306"
 }
 
 "smwa"
 {
  "driver"   "mysql"
  "host"    "localhost"
  "database"   "smwa"
  "user"    "root"
  "pass"    "pass"
  //"timeout"   "0"
  "port"   "3306"
 }
 
 "chatlogs"
 {
  "driver"   "mysql"
  "host"    "localhost"
  "database"   "smwa"
  "user"    "root"
  "pass"    "pass"
  //"timeout"   "0"
  "port"   "3306"
 }
 
 
 "storage-local"
 {
  "driver"   "sqlite"
  "database"   "sourcemod-local"
 }
}

[Jumpman]

Is it possible to make the system so when you ban a player you can se what server the player is banned on ?

[excalibur]

Check your PM HSFighter, you got a security bug in your code

[HSFighter]

Dear Community,

the version "2.2 Beta B" of the Sourcemod Webadmin is finish.

This version includes mostly fixes and some new futures.
Download and Changelog in the first post.

It is strongly recommended that users of older versions
(older than 2.2 Beta B) update as soon as possible.
I resolved an important security issue.

[excalibur]

;)

[daleGEND]

Does this integrate with Sourcebans at all? Unfortunately I cannot move away from SB easily, but would like for it to be controllable in one location. I see options asking for the database information, but where is it?

Edit: Bug Report
If you click on the "Go to page" links for Extended Comms, it doesn't go to the right page, it goes back to the plugin listing page. This is because it's missing the plugin name variable in the URL.

[HSFighter]

Originally Posted by daleGEND Does this integrate with Sourcebans at all? Unfortunately I cannot move away from SB easily, but would like for it to be controllable in one location. I see options asking for the database information, but where is it? Edit: Bug Report If you click on the "Go to page" links for Extended Comms, it doesn't go to the right page, it goes back to the plugin listing page. This is because it's missing the plugin name variable in the URL.

Thank you for the Feedback.

You can use Webadmin for admins and Sourcebans for Bans to.
You need only disable the ingame admin part of Sourcebans,
and install the SQL-Admins from AlliedModders LLC.
I use Sourcebans and Sourcemod-Webadmin together on my Servers.

The Database settings for SB in the Webadmin it's using to import Ban to the SQL-Ban-Plugin.
But i will add a Sourcebans-Admin Import/export function to the next version.

[Acidpimp]

I keep getting this error when setting up your script.. FYI i have set up the sql part on sourcemod and i am pretty computer literate.

Notice:  Undefined variable: x in /home/kr3w/public_html/webmin/setup.php on line 177

Query: CREATE TABLE sm_servers( id int(10) PRIMARY KEY auto_increment,
ip varchar(15) NOT NULL default '',
port int(10) NOT NULL default '',
name varchar(200) default NULL,
UNIQUE KEY (ip,port)) 

Antwort: Invalid default value for 'port'

Above is the only thing i still dont understand but i got it working by manually adding the stuff to mysql and putting the default port value to 27015(hope this is okay).....

Okay the script works as far as adding admins to the Database, but when i add a sever to the list the status says offline and i cannot manage the plugins on the server. i would like to be able to fully use the plugin if you can please get back to me asap

While installing Sourcebans i had an issue with the servers not responding on there as well.. figured out you gotta have your web host open the ports for you so the server can respond... everything works wonderfully now in case anyone else has this issue refer to the sourcebans article about it...

http://sourcebans.net/faq/which-ports-does-sourcebans-webpanel-require-be-open

!!!SOLVED!!!

[v1uuu]

Don't know if i downloaded the right version, but the chatlog of the new version is buggy for me.
When i try to open the chatlog in the Webinterface it says that the function "MysqlBansToArray" cannot be called. In the older versions the mentioned function was in function.php, but in the latest version it's not there anymore. It worked fine after i copied the function from the older php file to the latest file. Maybe you forgot to add the function or something.

EDIT: Just tried to view MySQL Bans in the WebInterface and then i got an error that MysqlBansToArray can't be declared a second time. Therefore it should work for both plugins if you cut the function from mysqlbans.php and paste it into function.php.

The function should look like this:

PHP Code:

 function MysqlBansToArray($table, $steamid){

 //define bans-array
  $bans = array();
  //Set startvalue of counter
  $x = 0;
  // Read Sourcebans banlist
  if ($steamid == ""){
    $sql = "SELECT * FROM ".$table."";
  }else{
    $sql = "SELECT * FROM ".$table." WHERE steam_id = '".$steamid."'";
  }
  $result = mysql_query($sql) OR die(mysql_error());
  if(mysql_num_rows($result)){
    while($row = mysql_fetch_assoc($result)){
      // Count bans-array key
      $x++;
      //apply MySQL-Bans banlistdata to array
      $bans['name'][$x] = $row['player_name'];
      $bans['steam'][$x] = $row['steam_id'];
      $bans['ip'][$x] = $row['ipaddr'];
      $bans['length'][$x] = $row['ban_length'] * 60;
      $bans['date'][$x] = strtotime($row['timestamp']);
      $bans['reason'][$x] = $row['ban_reason'];
      $bans['admin'][$x] = $row['banned_by'];
     }    
  }
  $bans['count'] = $x;
  return $bans;
 } 


[excalibur]

same here, used the same fix as you did