[muukis]

Originally Posted by xmagicboyx i did these steps - [OPTIONAL] Download l4d_stats.txt to /addons/sourcemod/gamedata. If you don't download this, your Rank Vote will be disabled. i do it Edit your databases.cfg file at /addons/sourcemod/config. Insert "l4dstats" entry with a valid connection info to your Custom Player Stats database. and i not do it i dont know what need to do where write l4dstats? which info? i beginner at SourceMod and i dont know what is datebase help me please Download compiled plugin (l4d_stats.smx) to /addons/sourcemod/plugins. i do it so only in step 2 i dont know what to do with the datebase file, after i did steps 1 and 3 the plugin not work in game and i guess becuase i not edit the datebase file

HERE is an example of that file. You too must do something like that to your databases.cfg file.

[Nitrous]

Hello all

I have been trying to set this up on my server, my server is hosted by gameservers and my web host is a free host, it supports everything needed, i have managed to setup the web side of the mod, database created with no errors, site is located at http://l4dstats.me12.co.cc but everytime i alter the database.cfg my server times out, as the host i have tried the above address and me12.co.cc and me12.megabyet.net to no avail, i think it is something to do with the server address i put in remote mysql via cpanel, as i could not put the port number for my server any suggestions?

[xmagicboyx]

still not work...

i replace all my datebase.cfg with it -

"Databases" { "driver_default" "mysql" "default" { "driver" "default" "host" "localhost" "database" "sourcemod" "user" "*****" "pass" "*****" //"timeout" "0" //"port" "0" } "storage-local" { "driver" "sqlite" "database" "sourcemod-local" } "clientprefs" { "driver" "sqlite" "host" "localhost" "database" "clientprefs-sqlite" "user" "*****" "pass" "*****" //"timeout" "0" //"port" "0" } "l4dstats" { "driver" "mysql" "host" "rizingspirit.clanservers.com" "database" "c712674_l4dstats" "user" "*****" "pass" "*****" } }

[crazytina]

Originally Posted by xmagicboyx still not work... i replace all my datebase.cfg with it -

this is my informations .. wont work if you use this .. you need your owne


"l4dstats"
{
"driver" "mysql"
"host" "rizingspirit.clanservers.com"
"database" "c712674_l4dstats"
"user" "*****"
"pass" "*****"
}

[xmagicboyx]

i dont know what to write which information and where i can see my information.. i really dont know nohting about the datebase.cfg...

*and i dont have a dedicated server i open my server with command console

[MarshalZCC]

What's the easiest way to remove a single player from the statistics, who is not online? This player is banned, so I won't be able to use the menu option that removes a player who is online.

[muukis]

Originally Posted by MarshalZCC What's the easiest way to remove a single player from the statistics, who is not online? This player is banned, so I won't be able to use the menu option that removes a player who is online.

Execute query: delete from players where steamid = 'INSERT PLAYER STEAMID HERE';

[tythefox]

I'm having trouble getting this working. My database.cfg file is as follows:

"Databases"
{

    "driver_default"        "mysql"
    
    "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"
    }

    "l4dstats"
    {
        "driver"            "mysql"
        "host"                "tythefox.xfactorservers.com"
        "database"            "tythefox_l4dstats"
        "user"                "tythefox_dbstats"
        "pass"                "******"
        "port"                "3306"
    }
}

I followed the instructions to get the remote SQL access allowed via the cPanel, and everything looks right. However, when I fire up my server I get

L 03/20/2010 - 23:11:00: [l4d_stats.smx] Failed to connect to database: [2003]: Can't connect to MySQL server on 'tythefox.xfactorservers.com' (10060)
L 03/20/2010 - 23:11:00: [SM] Plugin encountered error 25: Call was aborted
L 03/20/2010 - 23:11:00: [SM] Native "SetFailState" reported: Connecting to database failed. Read error log for further details.
L 03/20/2010 - 23:11:00: [SM] Displaying call stack trace for plugin "l4d_stats.smx":
L 03/20/2010 - 23:11:00: [SM]   [0]  Line 566, /home/groups/alliedmodders/forums/files/5/2/0/8/2/59013.attach::OnPluginStart()

What gives? The RemoteSQL option wouldn't be there if it wasn't enabled, right? I placed the wildcard appropriately, so I don't see why it isn't working. I'm honestly starting to get pissed off, if you can tell me a free MySQL host that performs the required operations, I'd be grateful. '

Thanks.

[muukis]

Originally Posted by tythefox I'm having trouble getting this working. My database.cfg file is as follows: "Databases" { "driver_default" "mysql" "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" } "l4dstats" { "driver" "mysql" "host" "tythefox.xfactorservers.com" "database" "tythefox_l4dstats" "user" "tythefox_dbstats" "pass" "******" "port" "3306" } } I followed the instructions to get the remote SQL access allowed via the cPanel, and everything looks right. However, when I fire up my server I get L 03/20/2010 - 23:11:00: [l4d_stats.smx] Failed to connect to database: [2003]: Can't connect to MySQL server on 'tythefox.xfactorservers.com' (10060) L 03/20/2010 - 23:11:00: [SM] Plugin encountered error 25: Call was aborted L 03/20/2010 - 23:11:00: [SM] Native "SetFailState" reported: Connecting to database failed. Read error log for further details. L 03/20/2010 - 23:11:00: [SM] Displaying call stack trace for plugin "l4d_stats.smx": L 03/20/2010 - 23:11:00: [SM] [0] Line 566, /home/groups/alliedmodders/forums/files/5/2/0/8/2/59013.attach::OnPluginStart() What gives? The RemoteSQL option wouldn't be there if it wasn't enabled, right? I placed the wildcard appropriately, so I don't see why it isn't working. I'm honestly starting to get pissed off, if you can tell me a free MySQL host that performs the required operations, I'd be grateful. ' Thanks.

Do you have a console access to your server that hosts your game server? Telnet/shell (Linux) or remote desktop (Win)? You could test your connection from your game server to your db server using the console access, to make sure the username/password, the IP and the port are properly set. You cannot test this properly just by using your Remote SQL client... I think.

[tythefox]

Originally Posted by muukis Do you have a console access to your server that hosts your game server? Telnet/shell (Linux) or remote desktop (Win)? You could test your connection from your game server to your db server using the console access, to make sure the username/password, the IP and the port are properly set. You cannot test this properly just by using your Remote SQL client... I think.

I don't have access to this kind of feature. Is there any free host out there that can accommodate this addon?