You can install this over the original Player Stats.
- Prepare your MySQL database to accept connections from your web site and game server.
- Download web stats (l4d_stats_web.zip) and extract it to your website. PHP support required!
- Rename config_example.php to config.php and edit it.
- 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.
- Delete both createtable.php and updatetable.php files.
- Add full read and write access to everyone for the website file /templates/awards_cache.html.
- [OPTIONAL] Download l4d_stats.txt to /addons/sourcemod/gamedata. If you don't download this, your Rank Vote will be disabled.
- Edit your databases.cfg file at /addons/sourcemod/config. Insert "l4dstats" entry with a valid connection info to your Custom Player Stats database.
- 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:13
4: [l4d_stats.smx] Failed to update encoding to UTF8: near "SET": syntax error
L 04/14/2010 - 12:13
4: [SM] Native "PrintToConsole" reported: Client index 18284786 is invalid
L 04/14/2010 - 12:13
4: [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 !!