[dacomb]

I would be cool if you could add a Kills Per Hour stat similar to the one listed on the steam stats page...

Just an idea... PPM isn't really the same...

[banz]

Originally Posted by dacomb I would be cool if you could add a Kills Per Hour stat similar to the one listed on the steam stats page... Just an idea... PPM isn't really the same...

Yeah, thats would be nice^^

[eargosedown]

How do I update the l4d_stats.cfg with the new cvars?

[iNFiNiTeX]

"LAN Support Explained:

When playing in LAN (sv_lan = 1) the stats are recorded with IP as player identity. Warning! This feature is highly unreliable because IP addresses are not necessarily static and individual. The webstats don't fully support the IP based stats and some links may not work as specified."

I don't understand why you would use IP for LAN. LAN IP's are not static and are easily shared. Usernames on the otherhand are much more unique in a small LAN setting, and will never be shared.

GetClientRankAuthString(client, String:auth[], maxlength)
{
    GetClientAuthString(client, auth, maxlength);

    if (StrEqual(auth, "STEAM_ID_LAN", false))
        GetClientIP(client, auth, maxlength);
}

Is this the only code which forces the plugin to use IP tracking if sv_lan 1 is set? In which case, would changing "GetClientIP" to "GetClientName" force it to use nameid instead?

[NaRyan]

Would it be possible to add a cvar to not log stats for players that have over x amount of Unicode characters in their name?

Due to the usual ugly all Unicode names that players use.
They end up looking a right mess in the stats.
For e.g This player

I don't mind players using Unicode for some parts of their name.
Since I am in the UK I do get a lot of other European players on my server.
Who use Unicode letters as it's the correct way to spell their name.

It's the players that use all Unicode just to make some stupid "graphical" looking name, that I dislike.

Edit:
Just noticed in the MySQL admin page that it is set to:
MySQL charset: UTF-8 Unicode (utf8)
MySQL connection collation: utf-8_unicode_ci

The MySQL connection collation one can be changed, is there a correct Unicode one to set that too?

oops just noticed that the Name was set to utf-8_general_ci.
Is that correct?

Also does the $dbtimemod = not accept -1 as a valid number?
As the times shown on my stats page are 1 hour ahead of "real time".
I have no idea what is off (time wise), be it Game server, Database, or Website.

[chunXray]

Originally Posted by muukis Read THIS. Edit: Try the attached script and tell me if it works for you?

THANKS FOR THAT, it works

however, i got this warning after create timedmaps table

Duplicate column name 'difficulty'

updatetable.php #996

$alter_maps = "ALTER TABLE `timedmaps` ADD COLUMN `difficulty` INT(1) UNSIGNED NOT NULL;";
if (mysql_query($alter_maps)) echo "<font color=\"darkgreen\">Timed Maps table altered successfully!</font><br />\n"; else echo "<font color=\"darkred\">" . mysql_error() . "</font><br />\n";

[muukis]

Originally Posted by chunXray Duplicate column name 'difficulty'

That is nothing you should worry about. It's not an error in this context.

You can run the updatetable.php as many times you like and it only is supposed to do changes that are needed. It is saying that this change is not needed because there is already a field named as 'difficulty'.

[dacomb]

I'm getting some odd buffer overflow notices in the console log when I restart my server. I posted up a restart with l4dstats enabled and disabled...

I'm using the latest version and gamedata file and web package.

Any idea why this might be happening?

[muukis]

Originally Posted by NaRyan Would it be possible to add a cvar to not log stats for players that have over x amount of Unicode characters in their name? Due to the usual ugly all Unicode names that players use. They end up looking a right mess in the stats. For e.g This player

I don't like the idea. What would you have me to do - Remove the rest of the unicode characters? Because changing them to a-zA-Z is impossible. In overall this would make things too tricky, imho. Explain to me better what would you have me do and I'll consider it, OK?

Originally Posted by NaRyan It's the players that use all Unicode just to make some stupid "graphical" looking name, that I dislike.

Exactly. I don't like them either, but there's nothing we can do about it.

Originally Posted by NaRyan Just noticed in the MySQL admin page that it is set to: MySQL charset: UTF-8 Unicode ( utf8 ) MySQL connection collation: utf-8_unicode_ci The MySQL connection collation one can be changed, is there a correct Unicode one to set that too? oops just noticed that the Name was set to utf-8_general_ci. Is that correct? Also does the $dbtimemod = not accept -1 as a valid number? As the times shown on my stats page are 1 hour ahead of "real time". I have no idea what is off (time wise), be it Game server, Database, or Website.

I have a feeling that your webserver is configured differently than mine, since my website shows the unicode correctly. I'll probably need to add the encoding to the web pages... not sure if it's there already?

You should be able to set negative values to the $dbtimemod. It effects the Last Online time hour value. And before you ask, NO, it does not sum these values so that time can be negative (if a players last online time is Jan 21, 2010 01am.)

[muukis]

Originally Posted by dacomb I'm getting some odd buffer overflow notices in the console log when I restart my server. I posted up a restart with l4dstats enabled and disabled... I'm using the latest version and gamedata file and web package. Any idea why this might be happening?

Sorry, I don't know what's wrong there. Maybe someone with more knowledge on SourcePawn?