[muukis]

Originally Posted by WolfGang Someone tell me how I can create my own web for this? I'd have the SQL dump file install, but the only thing I have left is the website. I know the web is OPTIONAL but I want to try something new out. Someone please help on this?

The SQL dump is not up-to-date as of yet and I am truly sorry for it. I'll try to look up some time to start doing something for the stats again.

[Kahl_Drogo]

Ok THX work but another error :



My CFG :

<?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 = "xxx";
$mysql_db = "xxx";
$mysql_user = "fxxx";
$mysql_password = "xxx";
$mysql_tableprefix = "xxx";

// 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 = "";

// 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("<NAME>", "<ADDRESS>[:<PORT>]");
// Examples:
//   $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 = 0;

// 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 = 0;

// 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 = 100;
$award_minheadshots = 100;
$award_minpoints = 1000;

// How many top players would you like to show on the awards page on each award?
// Note! You should set this value to at least 1.
$award_display_players = 3;

// 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 install.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 install.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 = "x";

// 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 = 1;

/*
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;

// Show/hide link for the timed maps (also disables the page for parameterless use)
$timedmaps_show_all = False;

// Allow reading of player Steam profile (overrides all avatar related if set to False)
// Warning! Setting value to true can slow loading of some pages.
$steam_profile_read = True;

// Show/hide player avatars (overrides all other avatar related if set to False)
$players_avatars_show = True;

// Show/hide online player avatars
// Warning! Setting value to true will slow down the index page some, depending how
// many players are currently online.
$players_online_avatars_show = true;

// Number of players to show additional info at Top 10 -players list (set to 0 to disable)
// Shows player avatar and some other information.
// Warning! Setting a number higher than 0 (zero) will slow every page load a little.
$top10players_additional_info = 10;

// Show Message Of The Day in each page
$show_motd = True;
?>

[Stargate75]

L 07/30/2012 - 20:51:01: [SM] MEMORY LEAK DETECTED IN PLUGIN (file "l4d_stats.sm
x")
L 07/30/2012 - 20:51:01: [SM] Unloading plugin to free 16040 handles.
L 07/30/2012 - 20:51:01: [SM] Contact the author(s) of this plugin to correct th
is error.

[noctua]

Rly nice plugin!
But muukis, how i remove the player-multiplier?

Like: survival
1 player online = 50 points for killing a tank
5 players online = 250 points for killing a tank

thats not fair
how do i remove the multiplier?

thx

[SyNiK4L]

Originally Posted by Stargate75 L 07/30/2012 - 20:51:01: [SM] MEMORY LEAK DETECTED IN PLUGIN (file "l4d_stats.sm x") L 07/30/2012 - 20:51:01: [SM] Unloading plugin to free 16040 handles. L 07/30/2012 - 20:51:01: [SM] Contact the author(s) of this plugin to correct th is error.

Ya running it for me just crashes the server all together on player join.

[muukis]

Originally Posted by Stargate75 L 07/30/2012 - 20:51:01: [SM] MEMORY LEAK DETECTED IN PLUGIN (file "l4d_stats.sm x") L 07/30/2012 - 20:51:01: [SM] Unloading plugin to free 16040 handles. L 07/30/2012 - 20:51:01: [SM] Contact the author(s) of this plugin to correct th is error.

Looks awful! I've got to look into that...

Originally Posted by noctua Rly nice plugin! But muukis, how i remove the player-multiplier? Like: survival 1 player online = 50 points for killing a tank 5 players online = 250 points for killing a tank thats not fair how do i remove the multiplier? thx

That certainly looks like a bug. It probably should be the other way around, and that is 1 player online = 250 and 5 players online = 50?

Originally Posted by SyNiK4L Ya running it for me just crashes the server all together on player join.

I have not had time for good times for such a long time, I don't know if the plugin has gone rogue? Someone running the plugin could verify this to you if I don't get to do that first.

[muukis]

Originally Posted by Kahl_Drogo Ok THX work but another error : My CFG : <?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 = "xxx"; $mysql_db = "xxx"; $mysql_user = "fxxx"; $mysql_password = "xxx"; $mysql_tableprefix = "xxx"; // 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 = ""; // 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("<NAME>", "<ADDRESS>[:<PORT>]"); // Examples: // $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 = 0; // 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 = 0; // 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 = 100; $award_minheadshots = 100; $award_minpoints = 1000; // How many top players would you like to show on the awards page on each award? // Note! You should set this value to at least 1. $award_display_players = 3; // 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 install.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 install.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 = "x"; // 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 = 1; /* 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; // Show/hide link for the timed maps (also disables the page for parameterless use) $timedmaps_show_all = False; // Allow reading of player Steam profile (overrides all avatar related if set to False) // Warning! Setting value to true can slow loading of some pages. $steam_profile_read = True; // Show/hide player avatars (overrides all other avatar related if set to False) $players_avatars_show = True; // Show/hide online player avatars // Warning! Setting value to true will slow down the index page some, depending how // many players are currently online. $players_online_avatars_show = true; // Number of players to show additional info at Top 10 -players list (set to 0 to disable) // Shows player avatar and some other information. // Warning! Setting a number higher than 0 (zero) will slow every page load a little. $top10players_additional_info = 10; // Show Message Of The Day in each page $show_motd = True; ?>

Can't really say for sure. Can you post the link of the image shown above? I'd like to see how is it malformed.

[Mr. Man]

Hey muukis,

If you want an example of a stat-tracker with a fairly large data size, here's mine: http://176.31.208.74/l4d2stats/

[kwski43]

Hi again muukis
I recently installed your plugin and webstats, and now after leaving server running for some time and gathering some player stats it starts to show errors:

L 08/05/2012 - 13:10:55: [l4d_stats.smx] GetClientRankRankChange Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Error appear whenever plugin should show player rank.

[el_psycho]

Originally Posted by muukis Can't really say for sure. Can you post the link of the image shown above? I'd like to see how is it malformed.

Hey muukis, this looks like the problem i was having a while back with the google maps images, to which i posted my solution in this post.

Kahl_Drogo seems to have followed those instructions since i see this line in his config.php

$googlemaps_apikey = "x";

maybe he made a mistake in the index.php in which i changed this line:

$googlemaps = "http://maps.google.com/maps/api/staticmap?key=" . $googlemaps_apikey;

to this:

$googlemaps = "http://maps.googleapis.com/maps/api/staticmap?";

So, if he doesnt care about the maps he can simply remove the "x" from $googlemaps_apikey in config.php and he will have no maps, or he can double check that other line in index.php and make sure its right.

BTW muukis, did you look at any of this? you never gave confirmation.