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

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


Post New Thread Reply   
 
Thread Tools Display Modes
muukis
Veteran Member
Join Date: Apr 2009
Old 01-27-2010 , 06:43   Re: [L4D & L4D2] Custom Player Stats v1.4B46
Reply With Quote #81

Quote:
Originally Posted by Woonan View Post
didn't noticed any problem
just a little modification and it tracks by name
There is a chance of SQL injection in this. Just by changing every GetClientAuthString with GetClientName you can get in to trouble. Might be usable for LANs and with friends.
__________________
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
Woonan
Junior Member
Join Date: Dec 2009
Old 01-27-2010 , 07:34   Re: [L4D & L4D2] Custom Player Stats v1.4B46
Reply With Quote #82

well, it's not hard to correct
personally I don't care about sql injections, my database has no important data
and I think it would be great addition for your plugin to track by name
if you make an option to chose name ip or steamid
Woonan is offline
chunXray
Member
Join Date: Jul 2009
Old 01-27-2010 , 09:16   Re: [L4D & L4D2] Custom Player Stats v1.4B46
Reply With Quote #83

timed maps not work for me
in updatetable.php, it says
Specified key was too long; max key length is 1000 bytes
chunXray is offline
muukis
Veteran Member
Join Date: Apr 2009
Old 01-27-2010 , 14:58   Re: [L4D & L4D2] Custom Player Stats v1.4B46
Reply With Quote #84

Quote:
Originally Posted by chunXray View Post
timed maps not work for me
in updatetable.php, it says
Specified key was too long; max key length is 1000 bytes
Read THIS.

Edit: Try the attached script and tell me if it works for you?
Attached Files
File Type: zip updatetable.zip (3.2 KB, 225 views)
__________________
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.

Last edited by muukis; 01-27-2010 at 15:20.
muukis is offline
eargosedown
Member
Join Date: Jan 2010
Old 01-27-2010 , 18:18   Re: [L4D & L4D2] Custom Player Stats v1.4B46
Reply With Quote #85

Any chance of a chat command that will display the rank/session data in chat?

ie: !playerstats.
results in:
<player name> is rank X of X. With X kills (X by headshot.)
eargosedown is offline
muukis
Veteran Member
Join Date: Apr 2009
Old 01-28-2010 , 04:18   Re: [L4D & L4D2] Custom Player Stats v1.4B61
Reply With Quote #86

Uploaded new version. This is a minor update only.

Quite a lot of you (that gave feedback) were hoping for LAN support and here it is - Hopefully! I have not tested it (this I leave for you), but it should be OK.

There are some new features and bugfixes. Read more at the first post.
__________________
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.

Last edited by muukis; 01-28-2010 at 06:49.
muukis is offline
jonthekiller
New Member
Join Date: Jan 2010
Old 01-28-2010 , 07:01   Re: [L4D & L4D2] Custom Player Stats v1.4B61
Reply With Quote #87

hi,

Thanks for your plugin.

I use left 4 dead 2 and I have a problem with web stats. I have this message on my web site :

Code:
Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 100

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 110

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 100

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 100

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 110

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 100

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 100

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 110

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 100

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 100

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 110

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 100

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 100

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 110

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 100

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 100

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 110

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 100

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 100

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 110

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 100

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 110

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 100

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 110

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 100

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 110

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 100

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 110

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 100

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 110

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 100

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 110

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 160

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 100

Notice:  Undefined variable: game_version in C:\Program  Files\EasyPHP 2.0b1\www\l4d_stats_web\common.php on line 110
Here my config file :

PHP Code:
<?php
/*
================================================
LEFT 4 DEAD PLAYER RANK
Copyright (c) 2009 Mitchell Sleeper
Originally developed for WWW.F7LANS.COM
================================================
Configuration file - "config.php"
================================================
*/

// MySQL information for L4D Stats DB
$mysql_server "127.0.0.1";
$mysql_db "l4d2";
$mysql_user "****";
$mysql_password "****";

// Heading for the stats page.
$site_name "****";

// Game server address (adds a Steam connection link over the site name)
// Leave empty if no link is added
// Usage: "l4d2.mysite.net:27016" or "123.0.0.234"
$site_address "****";

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

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

// 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
$lastonlineformat "M d, Y g:ia";

/*
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;
?>
Thanks for your help.
jonthekiller is offline
GrossKopf
Senior Member
Join Date: Jun 2007
Old 01-28-2010 , 08:10   Re: [L4D & L4D2] Custom Player Stats v1.4B61
Reply With Quote #88

Quote:
Originally Posted by muukis View Post
Uploaded new version. This is a minor update only.

Quite a lot of you (that gave feedback) were hoping for LAN support and here it is - Hopefully! I have not tested it (this I leave for you), but it should be OK.

There are some new features and bugfixes. Read more at the first post.
Do we just have to upload the plugin to update or are there updates on the webserver side too?
GrossKopf is offline
muukis
Veteran Member
Join Date: Apr 2009
Old 01-28-2010 , 08:32   Re: [L4D & L4D2] Custom Player Stats v1.4B61
Reply With Quote #89

Quote:
Originally Posted by GrossKopf View Post
Do we just have to upload the plugin to update or are there updates on the webserver side too?
The plugin is enough if for some reason of your own you don't want to update the webstats. There are no new statistical information to be shared, but there are some improvements and bugfixes in the new webstats that you might want to download. In general, it will not hurt to update webstats everytime there is a new release, but if you have customizations in your scripts, you might want to reconsider if updating is needed everytime.
__________________
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
muukis
Veteran Member
Join Date: Apr 2009
Old 01-28-2010 , 08:53   Re: [L4D & L4D2] Custom Player Stats v1.4B61
Reply With Quote #90

FYI, here's list of most of the modifications I did to webstats:
  • Added Zombies Killed to the page headers. Multiple updated scripts including style.css.
  • Added PPM to server.php and server.tpl. The formula for the calculated PPM is players total score divided with map playtime, and not players total score divided by players total playtime.
  • Minor tweaks to support IE better.
  • Fixed bug in players Survivor Kills tooltip.
  • Fixed bug with playerlist.php not showing the Scavenge stats properly.
  • Fixed some Rank Awards values.
  • Timed Maps to take Steam ID as parameter.
  • Added Timed Maps link in Players stats.
  • Configurable time display (config_example.php).
__________________
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
Reply


Thread Tools
Display Modes

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 03:00.


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