Raised This Month: $51 Target: $400
 12% 

[L4D & L4D2] Custom Player Stats v1.4B121


Post New Thread Reply   
 
Thread Tools Display Modes
muukis
Veteran Member
Join Date: Apr 2009
Old 08-06-2010 , 16:44   Re: [L4D & L4D2] Custom Player Stats v1.4B101
Reply With Quote #971

Quote:
Originally Posted by Crotan View Post
If i type in sm plugins load l4d_stats it will just return the list of plugins installed on the server

left4dead2\left4dead2\addons\sourcemod\logs\e rrors_20100805.log

Ok, hmm we had this working before on other servers and I thought I copied over the correct password for the mysql database, What's the significance of [1045]

Thanks for the continuing help

EDIT:

Doing some digging it appears my MySQL host might not like the new IP Address of this new server, and I may have to add access for it explicitly



Well The database user already has full privileges, and I'm pretty sure the password is correct, but don't know how to verify passwords from cpanel. So I'm still stumped on why it's denying access

Now im positive that the password is correct because if I change it to a wrong one in both databases.cfg and the config.cfg for the web portion a wrong password will make the web stats display out the errors.
You have to make sure that the connection from your game server to your db server is allowed. Testing does the db allow connections i.e. from your home computer does not make sure your db allows connections from the game server. Most of the free db server providers does not allow external connections. They may allow remote connections, but most of them only allow connections from local network.

Quote:
Originally Posted by LordTurbat View Post
Hi all i have it done but i have reinstal windows and i have a probleme that i dont hnow haw to fix it

http://img830.**************/i/67356577.jpg/
What i have to do ?
Enter your username and password? You have to configure your web server again. I'm sorry about the limited help, but there's not much I can help you with that without any more information about the server.
__________________
Monster Hunter

Though certainly not superhuman, the man's prowess inspires an excess of whispered rumors. But those rumors remain in the realm of speculation.
muukis is offline
LordTurbat
BANNED
Join Date: Apr 2010
Old 08-07-2010 , 06:20   Re: [L4D & L4D2] Custom Player Stats v1.4B101
Reply With Quote #972

fuck im using xampp what info shal i give you a folder maybe ? or muukis can you help my whit team viwer i hnow you will have it done in 2 or 4 min
LordTurbat is offline
muukis
Veteran Member
Join Date: Apr 2009
Old 08-07-2010 , 06:36   Re: [L4D & L4D2] Custom Player Stats v1.4B101
Reply With Quote #973

Quote:
Originally Posted by LordTurbat View Post
fuck im using xampp what info shal i give you a folder maybe ? or muukis can you help my whit team viwer i hnow you will have it done in 2 or 4 min
Couple of things you need to make sure:
  1. The IP address of the game server when the game server connects to the DB. It may be different from what you see it or use to connect the game server.
  2. Does your DB allow connections from the game server. It may allow for you to configure it so, but the server firewall may block it still. Ask your service provider if it is allowed. If it allows remote connections from the internet, set a DB login to have access from the game server IP. Doing this varies depending what tools you use. Google for help - it is filled with these sort of things.
  3. Make sure your game server stats configurations are set correctly. If you are sure you have cleared the first two steps, I can help you with the configs.
Good luck!
__________________
Monster Hunter

Though certainly not superhuman, the man's prowess inspires an excess of whispered rumors. But those rumors remain in the realm of speculation.
muukis is offline
LordTurbat
BANNED
Join Date: Apr 2010
Old 08-07-2010 , 07:16   Re: [L4D & L4D2] Custom Player Stats v1.4B101
Reply With Quote #974

well the Custom Player Stats use to work before i reinstal windows i dont hnow if that help you
LordTurbat is offline
Rul0r
New Member
Join Date: Aug 2010
Old 08-07-2010 , 14:43   Re: [L4D & L4D2] Custom Player Stats v1.4B101
Reply With Quote #975

Hello Guys,

i am new and tried to installed, as it was present on the first. But i have still problems.

i got currently 2 typ of problems:
1. for same reason the Database did not connect correctly to the game Server..
2. if i wnat to typ in "rank" oder run "sm_rankmenu", he tell me command not found...

install.php or updatetable.php works perfect. just only duplicates values disbled.
i set atributes 777 to /templates/awards_cache.html.
i sorted l4d_stats.txt to /addons/sourcemod/gamedata/l4d_stats.txt
Edit your databases.cfg file at /addons/sourcemod/config. Insert "l4dstats"
i sort (l4d_stats.smx) to /addons/sourcemod/plugins.

maybe you can help me?

Many Thanks!

Regards Rul0r

here are my settings:

databases.cfg at my l4d2 Server:

Code:
."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" "l4d2.bass-it.de"
"database" "usr_web1_8"
"user" "web1"
"pass" "......."

}
}
my config.cfg:
Code:
<?php
/*
================================================
LEFT 4 DEAD AND LEFT 4 DEAD 2 PLAYER RANK
Copyright (c) 2010 Mikko Andersson
================================================
Configuration file - "config.php"
================================================
*/

// MySQL information for L4D Stats DB
$mysql_server = "localhost";
$mysql_db = "usr_web1_8";
$mysql_user = "web1";
$mysql_password = "......";
$mysql_tableprefix = "";

// MySQL information for IP to Country DB
// Fill this information only if a separate database is used
$mysql_ip2c_server = "";
$mysql_ip2c_db = "";
$mysql_ip2c_user = "";
$mysql_ip2c_password = "";
$mysql_ip2c_tableprefix = "";

// Heading for the stats page.
$site_name = "L4d2 Bass-IT Game Server";

// Game server address (adds a Steam connection link over the site name)
// Multiple game server addresses supported (just write multiple configurations and use the correct syntax for each of them)
/* THIS LINE: DO NOT MODIFY OR REMOVE */ $game_addresses = array();
// Syntax:
   $game_addresses[] = array("Left 4 Dead 2 by Bass-IT.de", "84.200.44.252:27015");
// Examples:
//   $game_addresses[] = array("Server 1: Left 4 Dead 2", "my.site.net:27016");
//   $game_addresses[] = array("Server 2: Kill Them Zombies", "123.0.0.234");

// Supported game versions
// 0 = Support both L4D1 and L4D2
// 1 = Left 4 Dead 1 (default)
// 2 = Left 4 Dead 2
$game_version = 2;

// Template for the stats page.
// Leave empty if the default template is used.
// Usage: "mytemplate" (requires directory ./templates/mytemplate existence)
$site_template = "";

// Award definitions file
$award_file = "awards.en.php";
$award_l4d2_file = "awards.l4d2.en.php";

// Refresh interval (seconds) for the front page (index.php)
// 0 = disabled
$stats_refreshinterval = 10;

// Minimum playtime and points required to be eligible for any awards, in minutes
$award_minplaytime = 60;
$award_minpointstotal = 0;

// Minimum kills, headshots and points to be eligible for "Headshot Ratio" award
$award_minkills = 1000;
$award_minheadshots = 1000;
$award_minpoints = 1000;

// Amount of time in minutes between Awards page cache updates.
// 0 to disable cacheing
$award_cache_refresh = 60;

// Database time modifier (hours)
// 0 if the db time is the same as the websites
$dbtimemod = 0;

// Date format for player last online time
// http://www.php.net/manual/en/function.date.php
// Example: 24h - "M d, Y H:i";
$lastonlineformat = "M d, Y g:ia";

// Show player flags next to their names based on their IP
// 0 to disable
// Installation instructions:
//   1. Download and extract http://www.maxmind.com/download/geoip/database/GeoIPCountryCSV.zip to web stats root (same folder as updatetable.php)
//   2. Execute updatetable.php (use a web browser) - BE PATIENT AND WAIT FOR THE EXECUTION TO FINISH!
//   3. Delete files GeoIPCountryCSV.zip and GeoIPCountryWhois.csv when installation is successful
$showplayerflags = 1;

// Show player city name next to their flag and country name (player.php) based on their IP (has no effect when $showplayerflags = 0)
// 0 to disable
// Installation instructions:
//   1. Download latest GeoLiteCity_YYYYMMDD.zip from http://www.maxmind.com/app/geolitecity and extract the files to web stats root (same folder as updatetable.php)
//   2. Execute updatetable.php (use a web browser) - BE PATIENT AND WAIT FOR THE EXECUTION TO FINISH!
//   3. Delete files GeoLiteCity_YYYYMMDD.zip, GeoLiteCity-Blocks.csv and GeoLiteCity-Location.csv when installation is successful
$showplayercity = 1;

// Google Maps (player.php) additional URL parameters (URL postfix)
// Default: "&t=h&z=5"
//   Examples: (there is more!)
//     t => h = Satellite with labels / k = Satellite without labels / p = Terrain
//     z => Zoom factor
//     lci => com.panoramio.all = Photos / org.wikipedia.en = Wikipedia / com.youtube.all = Videos (combined with comma)
// Try out the usable parameters yourself
$googlemaps_addparam = "&t=h&z=5";

// Google Maps (index.php) API key (get yours from http://code.google.com/apis/maps/signup.html)
$googlemaps_apikey = "ABQIAAAAB8oZHNMBGFGS3xWmC9281BQ3AnLih-SUqL80ukLVw15UPtbhVBSU_-Nia3cA0XzpKGgbNTjLvrXgMQ";

// Show Google Maps (index.php) location for the first # players online (useful when web stats hosts multiple game servers)
// 0 to show all players
$googlemaps_showplayersonlinecount = 0;

// Google Maps (index.php) players online additional URL parameters (URL postfix)
// Default: "&size=600x300&maptype=satellite&sensor=false"
$googlemaps_playersonline_addparam = "&size=600x300&maptype=satellite&sensor=false";

// Google Maps (index.php) zoom when only one players online (or only server is displayed)
$googlemaps_playersonline_zoom = 3;

/*
Population CSV file. This is taken from the United States Census Bureau, you
can download a (possibly) more up-to-date file from this URL:

http://www.census.gov/popest/datasets.html

The file will be about half way down, under "Metropolitan, micropolitan, and
combined statistical area datasets", the CSV file under "Combined
statistical area population and estimated components of change". Or, check
the release thread and I can provide an exact URL for the download.

Keep in mind that the file has been drastically altered from it's original
state, including adding individual States as well as the entire US. If you
want to create your own CSV file, message me on Allied Modders and I will
help and possibly include it in a next release.
*/

$population_file = "population.usa.csv";

/*
Only display City results, and not Counties. Note: This will drastically
reduce the uniqueness of the results, cities only make up about 1/3rd of
the list. Set to True to enable. Default is False.

Also note, the minimum kills if you are using only citites needs to be
14000 or else you will get erroneous results! Default is 3000.
*/

$population_minkills = 3000;
$population_cities = False;
?>
Rul0r is offline
Inker
SourceMod Donor
Join Date: Dec 2008
Old 08-07-2010 , 18:15   Re: [L4D & L4D2] Custom Player Stats v1.4B101
Reply With Quote #976

Quick question since I'm not much of a PHP expert, but would it be possible for me to change my Awards page so it shows the top 5 players in each category instead of just the top 2?
Inker is offline
ki1418z
Junior Member
Join Date: Jul 2010
Location: Hong Kong
Old 08-08-2010 , 05:19   Re: [L4D & L4D2] Custom Player Stats v1.4B101
Reply With Quote #977

Quote:
Originally Posted by Rul0r View Post
Hello Guys,

i am new and tried to installed, as it was present on the first. But i have still problems.

i got currently 2 typ of problems:
1. for same reason the Database did not connect correctly to the game Server..
2. if i wnat to typ in "rank" oder run "sm_rankmenu", he tell me command not found...

install.php or updatetable.php works perfect. just only duplicates values disbled.
i set atributes 777 to /templates/awards_cache.html.
i sorted l4d_stats.txt to /addons/sourcemod/gamedata/l4d_stats.txt
Edit your databases.cfg file at /addons/sourcemod/config. Insert "l4dstats"
i sort (l4d_stats.smx) to /addons/sourcemod/plugins.

maybe you can help me?

Many Thanks!

Regards Rul0r

here are my settings:

databases.cfg at my l4d2 Server:

Code:
."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" "l4d2.bass-it.de"
"database" "usr_web1_8"
"user" "web1"
"pass" "......."
 
}
}
my config.cfg:
Code:
<?php
/*
================================================
LEFT 4 DEAD AND LEFT 4 DEAD 2 PLAYER RANK
Copyright (c) 2010 Mikko Andersson
================================================
Configuration file - "config.php"
================================================
*/
 
// MySQL information for L4D Stats DB
$mysql_server = "localhost";
$mysql_db = "usr_web1_8";
$mysql_user = "web1";
$mysql_password = "......";
$mysql_tableprefix = "";
 
// MySQL information for IP to Country DB
// Fill this information only if a separate database is used
$mysql_ip2c_server = "";
$mysql_ip2c_db = "";
$mysql_ip2c_user = "";
$mysql_ip2c_password = "";
$mysql_ip2c_tableprefix = "";
 
// Heading for the stats page.
$site_name = "L4d2 Bass-IT Game Server";
 
// Game server address (adds a Steam connection link over the site name)
// Multiple game server addresses supported (just write multiple configurations and use the correct syntax for each of them)
/* THIS LINE: DO NOT MODIFY OR REMOVE */ $game_addresses = array();
// Syntax:
   $game_addresses[] = array("Left 4 Dead 2 by Bass-IT.de", "84.200.44.252:27015");
// Examples:
//   $game_addresses[] = array("Server 1: Left 4 Dead 2", "my.site.net:27016");
//   $game_addresses[] = array("Server 2: Kill Them Zombies", "123.0.0.234");
 
// Supported game versions
// 0 = Support both L4D1 and L4D2
// 1 = Left 4 Dead 1 (default)
// 2 = Left 4 Dead 2
$game_version = 2;
 
// Template for the stats page.
// Leave empty if the default template is used.
// Usage: "mytemplate" (requires directory ./templates/mytemplate existence)
$site_template = "";
 
// Award definitions file
$award_file = "awards.en.php";
$award_l4d2_file = "awards.l4d2.en.php";
 
// Refresh interval (seconds) for the front page (index.php)
// 0 = disabled
$stats_refreshinterval = 10;
 
// Minimum playtime and points required to be eligible for any awards, in minutes
$award_minplaytime = 60;
$award_minpointstotal = 0;
 
// Minimum kills, headshots and points to be eligible for "Headshot Ratio" award
$award_minkills = 1000;
$award_minheadshots = 1000;
$award_minpoints = 1000;
 
// Amount of time in minutes between Awards page cache updates.
// 0 to disable cacheing
$award_cache_refresh = 60;
 
// Database time modifier (hours)
// 0 if the db time is the same as the websites
$dbtimemod = 0;
 
// Date format for player last online time
// http://www.php.net/manual/en/function.date.php
// Example: 24h - "M d, Y H:i";
$lastonlineformat = "M d, Y g:ia";
 
// Show player flags next to their names based on their IP
// 0 to disable
// Installation instructions:
//   1. Download and extract http://www.maxmind.com/download/geoip/database/GeoIPCountryCSV.zip to web stats root (same folder as updatetable.php)
//   2. Execute updatetable.php (use a web browser) - BE PATIENT AND WAIT FOR THE EXECUTION TO FINISH!
//   3. Delete files GeoIPCountryCSV.zip and GeoIPCountryWhois.csv when installation is successful
$showplayerflags = 1;
 
// Show player city name next to their flag and country name (player.php) based on their IP (has no effect when $showplayerflags = 0)
// 0 to disable
// Installation instructions:
//   1. Download latest GeoLiteCity_YYYYMMDD.zip from http://www.maxmind.com/app/geolitecity and extract the files to web stats root (same folder as updatetable.php)
//   2. Execute updatetable.php (use a web browser) - BE PATIENT AND WAIT FOR THE EXECUTION TO FINISH!
//   3. Delete files GeoLiteCity_YYYYMMDD.zip, GeoLiteCity-Blocks.csv and GeoLiteCity-Location.csv when installation is successful
$showplayercity = 1;
 
// Google Maps (player.php) additional URL parameters (URL postfix)
// Default: "&t=h&z=5"
//   Examples: (there is more!)
//     t => h = Satellite with labels / k = Satellite without labels / p = Terrain
//     z => Zoom factor
//     lci => com.panoramio.all = Photos / org.wikipedia.en = Wikipedia / com.youtube.all = Videos (combined with comma)
// Try out the usable parameters yourself
$googlemaps_addparam = "&t=h&z=5";
 
// Google Maps (index.php) API key (get yours from http://code.google.com/apis/maps/signup.html)
$googlemaps_apikey = "ABQIAAAAB8oZHNMBGFGS3xWmC9281BQ3AnLih-SUqL80ukLVw15UPtbhVBSU_-Nia3cA0XzpKGgbNTjLvrXgMQ";
 
// Show Google Maps (index.php) location for the first # players online (useful when web stats hosts multiple game servers)
// 0 to show all players
$googlemaps_showplayersonlinecount = 0;
 
// Google Maps (index.php) players online additional URL parameters (URL postfix)
// Default: "&size=600x300&maptype=satellite&sensor=false"
$googlemaps_playersonline_addparam = "&size=600x300&maptype=satellite&sensor=false";
 
// Google Maps (index.php) zoom when only one players online (or only server is displayed)
$googlemaps_playersonline_zoom = 3;
 
/*
Population CSV file. This is taken from the United States Census Bureau, you
can download a (possibly) more up-to-date file from this URL:
 
http://www.census.gov/popest/datasets.html
 
The file will be about half way down, under "Metropolitan, micropolitan, and
combined statistical area datasets", the CSV file under "Combined
statistical area population and estimated components of change". Or, check
the release thread and I can provide an exact URL for the download.
 
Keep in mind that the file has been drastically altered from it's original
state, including adding individual States as well as the entire US. If you
want to create your own CSV file, message me on Allied Modders and I will
help and possibly include it in a next release.
*/
 
$population_file = "population.usa.csv";
 
/*
Only display City results, and not Counties. Note: This will drastically
reduce the uniqueness of the results, cities only make up about 1/3rd of
the list. Set to True to enable. Default is False.
 
Also note, the minimum kills if you are using only citites needs to be
14000 or else you will get erroneous results! Default is 3000.
*/
 
$population_minkills = 3000;
$population_cities = False;
?>
1, Datebase must be called "l4d_stats"

2, You may check the port of MySQL
ki1418z is offline
LordTurbat
BANNED
Join Date: Apr 2010
Old 08-08-2010 , 06:24   Re: [L4D & L4D2] Custom Player Stats v1.4B101
Reply With Quote #978

someone plz make a youtube video tp learn us to instal this


[IMG]http://img51.**************/img51/2831/stats6.jpg[/IMG]


Quick installation guide

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! Alternatively, if you dont want or need the web stats, or if you don't have PHP or the skills to extract the queries from the install.php file, you can install the SQL dump (l4d2stats_sqldump.zip). You can skip to #7 if you decide to do the dump.
  3. Rename config_example.php to config.php and edit it.
  4. Execute install.php file.
  5. Delete install.php file.
  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.

Last edited by LordTurbat; 08-08-2010 at 06:26.
LordTurbat is offline
RasterMan
Senior Member
Join Date: Mar 2004
Location: Luton, UK
Old 08-08-2010 , 10:36   Re: [L4D & L4D2] Custom Player Stats v1.4B101
Reply With Quote #979

Sorry but i'm getting pissed off with people mass pm'ing me for help with this and other plugins!

1) If you don't understand MySQL or anything about webhosting, What the hell are you doing running game servers!
2) I run Linux gameservers/webhosting (NOT STUPID WINDOWS ones!)
3) If you can't afford a proper gameserver/webhoster, find someone who can!
4) I'm not the friggin author so go spam him not me!
__________________

Last edited by RasterMan; 08-08-2010 at 11:14.
RasterMan is offline
Send a message via MSN to RasterMan
Rul0r
New Member
Join Date: Aug 2010
Old 08-08-2010 , 12:04   Re: [L4D & L4D2] Custom Player Stats v1.4B101
Reply With Quote #980

good morning,

thanks for your reply ki1418z!

1. i am using parrallel confixx and i am unable to rename my that database.
was it possible so it like this way:

"usr_web1_8" instead of "l4dstats"
{
"driver" "mysql"
"host" "l4d2.bass-it.de"
"database" "usr_web1_8"
"user" "web1"
"pass" "*****"
//"timeout" "0"
"port" "3306"
}

2. i am using default port 3306 or.....

srv01:~# netstat -tulap | grep 3306
srv01:~# netstat -tulap | grep 9407
tcp 0 0 localhost:mysql *:* LISTEN 9407/mysqld

srv01:~# cat /etc/services | grep 3306
mysql 3306/tcp
mysql 3306/udp


thanks again for a reply.

cheers Rul0r
Rul0r is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 04:40.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode