[angel635]

hi MindeLT


that must be added to the database?

[MindeLT]

@ lokizito

Thx for another advise, will do

@angel635

You should add connection information to addons/sourcemod/configs/database.cfg

it should be something like this(open file, and you'll see)

"default"
adress: localhost
user: your_db_user
password: your_db_password
database: database_name

[MindeLT]

Updated v4.0

[sinblaster]

is this right Mindelt?

"warn_system_public"
{
"driver" "mysql"
"host" "111.111.111.11"
"database" "xxxx"
"user" "xxxx"
"pass" "xxxx"
//"timeout" "0"
"port" "3306"
}

[MindeLT]

Originally Posted by sinblaster is this right Mindelt? "warn_system_public" { "driver" "mysql" "host" "111.111.111.11" "database" "xxxx" "user" "xxxx" "pass" "xxxx" //"timeout" "0" "port" "3306" }

it uses "default", no need of warn_system_public.

"default"
{
"driver" "mysql"
"host" "111.111.111.11"
"database" "xxxx"
"user" "xxxx"
"pass" "xxxx"
//"timeout" "0"
"port" "3306"

[sinblaster]

ahh ok thanks heaps. So out of interest as I am a little noobish, how does your plug know to go to that database and not sourcebans for instance which is in the same file??

i.e
"Databases"
{
"driver_default" "mysql"

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

"default"
{
"driver" "default"
"host" "localhost"
"database" "sourcemod"
"user" "root"
"pass" ""
//"timeout" "0"
//"port" "0"
}

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

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

"sourcebans"
{
"driver" "mysql"
"host" "111.111.11.11"
"database" "xxxxxx_xxxxxx"
"user" "xxxxxx_xxxxxx"
"pass" "xxxxxx"
//"timeout" "0"
"port" "3306"
}
{
"driver" "mysql"
"host" "111.111.111.11"
"database" "xxxxxx_warn"
"user" "xxxxxx"
"pass" "xxxxxx"
//"timeout" "0"
"port" "3306"
}
}

[zepper]

Originally Posted by MindeLT it uses "default", no need of warn_system_public. "default" { "driver" "mysql" "host" "111.111.111.11" "database" "xxxx" "user" "xxxx" "pass" "xxxx" //"timeout" "0" "port" "3306"

I THINK the "defoult" is for driver for example "mysql" and there should be a server side name for database like:

"Databases"
{
    "driver_default"        "mysql"
    
    "WARNING"
    {
        "driver"            "default"
        "host"                "db_IP"
        "database"            "db_name"
        "user"                "db_user"
        "pass"                "db_pass"
        //"timeout"            "0"
        "port"            "3306"
    }
}

[sinblaster]

thats what I believe, but I believe allot of stuff that is apparently just "A TRAP"

[MindeLT]

You dont need to add different connections, if you have MySQL running in your server, just create A TABLE, in any database you're connecting, and thats all For example, i'm runing only 1 connection to database, there is all the admin tables, web tables and etc. In the same database, just in different table you can create user_warn table.

[sinblaster]

OK so if I have 4 databases connected to the game server, ie Sourcebans and a few others I am thinking of running like VIP and stats databases for other mods. Your plug is just going to search until it finds the database with your table?