[LordTurbat]

You can install this over the original Player Stats.

1. Prepare your MySQL database to accept connections from your web site and game server.
2. Download web stats (l4d_stats_web.zip) and extract it to your website. PHP support required!
3. Rename config_example.php to config.php and edit it.
4. Execute one of the below (use a web browser)
   • createtable.php if you are creating completely new database
   • updatetable.php if you are updating a previous version of Player Stats database.
5. Delete both createtable.php and updatetable.php files.
6. Add full read and write access to everyone for the website file /templates/awards_cache.html.
7. [OPTIONAL] Download l4d_stats.txt to /addons/sourcemod/gamedata. If you don't download this, your Rank Vote will be disabled.
8. Edit your databases.cfg file at /addons/sourcemod/config. Insert "l4dstats" entry with a valid connection info to your Custom Player Stats database.
9. Download compiled plugin (l4d_stats.smx) to /addons/sourcemod/plugins.

ok i have done this all but still not working my databese loke like this :

"Databases"
{
"driver_default" "mysql"

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

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

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


"l4dstats"
{
"driver" "sqlite"
"host" "localhost"
"database" "mysql"
"user" "root"
"pass" ""
//"port" ""
and i have this error



L 04/14/2010 - 12:134: [l4d_stats.smx] Failed to update encoding to UTF8: near "SET": syntax error
L 04/14/2010 - 12:134: [SM] Native "PrintToConsole" reported: Client index 18284786 is invalid
L 04/14/2010 - 12:134: [SM] Displaying call stack trace for plugin "l4d_stats.smx":



and now i have try like this :
"Databases"
{
"driver_default" "mysql"

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

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

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


"l4dstats"
{
"driver" "mysql"
"host" "localhost"
"database" "mysql"
"user" "root"
"pass" ""
//"port" ""

and have this error :

L 04/14/2010 - 13:57:59: [SM] Line 45: Section beginning without a matching ending
L 04/14/2010 - 13:57:59: -------- Mapchange to c4m1_milltown_a --------
L 04/14/2010 - 13:57:59: Error log file session closed.
L 04/14/2010 - 13:57:59: [SM] Unable to load plugin "l4d2scores.smx": Native "GameConfGetAddress" was not found
L 04/14/2010 - 13:57:59: [SM] Native "PrintToConsole" reported: Client index 18284786 is invalid
L 04/14/2010 - 13:57:59: [SM] Displaying call stack trace for plugin "l4d_stats.smx":


so now i dont hnow what else to do ! to make it work already !!

[muukis]

Originally Posted by LordTurbat and have this error : L 04/14/2010 - 13:57:59: [SM] Line 45: Section beginning without a matching ending L 04/14/2010 - 13:57:59: -------- Mapchange to c4m1_milltown_a -------- L 04/14/2010 - 13:57:59: Error log file session closed. L 04/14/2010 - 13:57:59: [SM] Unable to load plugin "l4d2scores.smx": Native "GameConfGetAddress" was not found L 04/14/2010 - 13:57:59: [SM] Native "PrintToConsole" reported: Client index 18284786 is invalid L 04/14/2010 - 13:57:59: [SM] Displaying call stack trace for plugin "l4d_stats.smx": so now i dont hnow what else to do ! to make it work already !!

Your error message is missing relevant information. Do this:

1. Delete error logs.
2. Restart game server.
3. Post the one error log file generated from after the restart as an attachment to this thread.

... and I or someone here will take a look.

[LordTurbat]

ok this is it :


L 04/14/2010 - 18:46:45: SourceMod error session started
L 04/14/2010 - 18:46:45: Info (map "") (file "errors_20100414.log")
L 04/14/2010 - 18:46:45: [SM] Detected parse error(s) in file "C:\L4D2\left4dead2\left4dead2\addons\sourcem od\configs\databases.cfg"
L 04/14/2010 - 18:46:45: [SM] Line 45: Section beginning without a matching ending
L 04/14/2010 - 18:46:46: Error log file session closed.
L 04/14/2010 - 18:46:46: SourceMod error session started
L 04/14/2010 - 18:46:46: Info (map "c4m1_milltown_a") (file "errors_20100414.log")
L 04/14/2010 - 18:46:46: [SM] Native "PrintToConsole" reported: Client index 10748066 is invalid
L 04/14/2010 - 18:46:46: [SM] Displaying call stack trace for plugin "l4d_stats.smx":
L 04/14/2010 - 18:46:46: [SM] [0] Line 5960, /home/groups/alliedmodders/forums/files/5/2/0/8/2/59013.attach:oFastQuery()
L 04/14/2010 - 18:46:46: [SM] [1] Line 1354, /home/groups/alliedmodders/forums/files/5/2/0/8/2/59013.attach::ConnectDB()
L 04/14/2010 - 18:46:46: [SM] [2] Line 564, /home/groups/alliedmodders/forums/files/5/2/0/8/2/59013.attach::OnPluginStart()
L 04/14/2010 - 18:46:52: [SM] Detected parse error(s) in file "C:\L4D2\left4dead2\left4dead2\addons\sourcem od\configs\databases.cfg"
L 04/14/2010 - 18:46:52: [SM] Line 45: Section beginning without a matching ending
L 04/14/2010 - 18:46:52: Error log file session closed.
L 04/14/2010 - 18:46:53: SourceMod error session started
L 04/14/2010 - 18:46:53: Info (map "c4m1_milltown_a") (file "errors_20100414.log")
L 04/14/2010 - 18:46:53: [SM] Native "PrintToConsole" reported: Client index 16777281 is invalid
L 04/14/2010 - 18:46:53: [SM] Displaying call stack trace for plugin "l4d_stats.smx":
L 04/14/2010 - 18:46:53: [SM] [0] Line 5960, /home/groups/alliedmodders/forums/files/5/2/0/8/2/59013.attach:oFastQuery()
L 04/14/2010 - 18:46:53: [SM] [1] Line 1354, /home/groups/alliedmodders/forums/files/5/2/0/8/2/59013.attach::ConnectDB()
L 04/14/2010 - 18:46:53: [SM] [2] Line 564, /home/groups/alliedmodders/forums/files/5/2/0/8/2/59013.attach::OnPluginStart()

[muukis]

Originally Posted by LordTurbat L 04/14/2010 - 18:46:45: [SM] Detected parse error(s) in file "C:\L4D2\left4dead2\left4dead2\addons\sourcem od\configs\databases.cfg" L 04/14/2010 - 18:46:45: [SM] Line 45: Section beginning without a matching ending

This part is the first thing you need address to... For each opening curly bracket ('{') there has to be an ending curly bracket ('}'). To make things even more difficult for you, there is a syntax in the file that you have to follow. Examine the original sourcemod databases.cfg a while to learn the syntax (it's in there and it's easy), then apply the changes you need. It really is not very difficult, but you can't just throw words in the file.

[LordTurbat]

like this ? :

"l4dstats"
'{'
"driver" "mysql"
"host" "localhost"
"database" "mysql"
"user" "root"
"pass" ""
//"port" ""
'}'

or like this :

"l4dstats"
{
"driver" "mysql"
"host" "localhost"
"database" "mysql"
"user" "root"
"pass" ""
//"port" ""
}

[muukis]

Originally Posted by LordTurbat like this ? : "l4dstats" '{' "driver" "mysql" "host" "localhost" "database" "mysql" "user" "root" "pass" "" //"port" "" '}' or like this : "l4dstats" { "driver" "mysql" "host" "localhost" "database" "mysql" "user" "root" "pass" "" //"port" "" }

Did you examine the syntax at all? It's the latter without the quotes.

[LordTurbat]

yes i have but now i have this error

iL 04/15/2010 - 17:53:43: [SM] Unable to load plugin "clientprefs.smx": Required extension "Client Preferences" file("clientprefs.ext") not running
L 04/15/2010 - 17:53:43: [SM] Unable to load plugin "l4d2scores.smx": Native "GameConfGetAddress" was not found
L 04/15/2010 - 17:53:43: [SM] Unable to load plugin "l4d_stats.smx": Required extension "Client Preferences" file("clientprefs.ext") not running

and i have tipe :

sm exts load clientprefs... but not working

il go try nwe sourcemode versions

[LordTurbat]

il go loke on google if i fiend someting...

[LordTurbat]

ok done whit clientpres ! but now i have this :

[SM] Displaying call stack trace for plugin "l4d_stats.smx":

what now

[kwski43]

Originally Posted by LordTurbat ok done whit clientpres ! but now i have this : [SM] Displaying call stack trace for plugin "l4d_stats.smx": what now

and what after that?