[titan_rw]

Originally Posted by ldoh0112 so.. this is possible or impossible? If possible, how?

Yes, I think it's possible, but as already stated, getting the core (guts) of it working first is higher priority.

Plus most people will only have stats from one gametype.

Here's an example on our current l4d2 db.

mysql> select count(name) from players;
+-------------+
| count(name) |
+-------------+
| 3998 |
+-------------+
1 row in set (0.02 sec)

mysql> select count(name) from players where playtime > 10 and playtime_versus > 10;
+-------------+
| count(name) |
+-------------+
| 9 |
+-------------+
1 row in set (0.03 sec)

Only 9 people out of almost 4,000 have more than 10 minutes in both coop, and vs. The two server admins are two of those 9 because of testing.

[ldoh0112]

but some people
made that

[harmgsn]

mysql> select count(name) from players;
+-------------+
| count(name) |
+-------------+
|        4029 |
+-------------+
1 row in set (0.00 sec)

mysql> select count(name) from players where playtime_versus != 0 and playtime != 0;
+-------------+
| count(name) |
+-------------+
|          19 |
+-------------+
1 row in set (0.01 sec)


mysql> select count(name) from players where playtime_versus != 0 and playtime = 0;
+-------------+
| count(name) |
+-------------+
|        2035 |
+-------------+
1 row in set (0.01 sec)



mysql> select count(name) from players where playtime != 0 and playtime_versus = 0;
+-------------+
| count(name) |
+-------------+
|        1976 |
+-------------+
1 row in set (0.02 sec)

So yeah, the majority are one or the other, but not both.

Oh, and some other fun with numbers:

mysql> select (SUM(headshots) / SUM(kills))*100 from players;
+-----------------------------------+
| (SUM(headshots) / SUM(kills))*100 |
+-----------------------------------+
|                           11.1474 |
+-----------------------------------+
1 row in set (0.02 sec)

mysql> select ((SUM(points) / SUM(playtime))) from players;
+---------------------------------+
| ((SUM(points) / SUM(playtime))) |
+---------------------------------+
|                         12.9006 |
+---------------------------------+
1 row in set (0.01 sec)

Basically... 11.14% of all kills are a headshot and on average people are earning 12.9 points per minute.

[ldoh0112]

well..
how pounce rank?

[Downtown1]

Plugins should only use zip/tar/bz2/gz for compressed packages. No 7z/rar please.

[harmgsn]

Titan and I confirmed that this *DOES* work with the prior databases from the original plugin. Run the updatetables.php and then drop the new plugin in place. Make sure that you update all of the web files too.

[muukis]

Originally Posted by Downtown1 Plugins should only use zip/tar/bz2/gz for compressed packages. No 7z/rar please.

The 7z contains a comparison report from two different versions of the plugin, a feature in Beyond Compare application. The file compressed in the 7z is one HTML-file of a size little less than 2MB. 7z is by far the best text compressor, so I'd use it in this case... but will of course change it if it's against forum rules or common practice. The file itself is not very usable to most, because it's just a comparison report and not many are interested of those.

The only reason I uploaded a comparison report is because I hoped people would get in to the code a lot easier and would see what the plugin is doing. Seeing the process and modification I have done. Then hopefully someday coming out to do something for the cause - fixing bugs and other issues, and customizations like I am doing.

[muukis]

Originally Posted by harmgsn I'll let muukis figure that one out ;)

Well... it was just a copy&paste error. The InvalidGameMode() returned true on realism, when it was supposed to return false, of course...

[muukis]

This is again PURE TEST VERSION. Realism mode hopefully works this time better.

I modified the gametype field name to gamemode, as it was supposed to be. This version also implements lot of stats collecting features to L4D2 new special infected. It should also be able to give a Jockey award from driving a survivor off the ledge. All external damage from the common infected is forwarded to the new specials like it was done to the first specials.

EDIT: Included realism web templates.
EDIT: Bugfix.
EDIT: Removed attachment.

[muukis]

Updated first post. Functionality may still be flawed, but in general it works.