[n0limit]

Description
PounceRecord records the pouncer, pounced, date and time, distance, damage, and map in which any pounce that achieved a pounce damage occurred (any pounce in which distance > z_pounce_damage_range_min). At the moment it only records the pounces, but I hope to eventually have an entire in-game system with extended pounce stats for each player and notification when a new top pounce has been achieved.

Installation
1. Create the pounces table in the database of your choice. The table SQL is as follows:

CREATE TABLE IF NOT EXISTS `pounces` (
  `ID` int(10) unsigned NOT NULL auto_increment,
  `datetime` datetime NOT NULL,
  `pouncer` varchar(64) NOT NULL,
  `pounced` varchar(64) NOT NULL,
  `distance` smallint(5) unsigned NOT NULL,
  `damage` float NOT NULL,
  `map` varchar(64) NOT NULL,
  `steamid` varchar(64) NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

You can also find a copy in Icettiflow's php package posted below.

2. Open addons\sourcemod\config\databases.cfg and add the following database:

    "PounceDB"
    {
        "driver"            "default"
        "host"                "mysqlhost
        "database"            "mypouncedatabase"
        "user"                "mysqluser"
        "pass"                "mysqlpass"
    }

3. Load the plugin. Pounces should start streaming in. If not, check the server console for any errors.

CVARS
pouncerecord_version - Current version of this plugin

CHANGES
1.1 - Fixed player names with special characters (by escaping them).
1.0 - Initial version

TODO
- In-game pounce achievements
- In-game stats (n0limit pounced Icettiflow for 25 damage. His average pounce is 27.3, and has pounced 48 people on this server.)
-In-game extended stats on request (pounces over x, favorite pounce target, your pounce bitch, your target dummy, just loads of stats can be gathered from this db).
-What else? Your recommendations will make this plugin.

Thanks
-Icettiflow, who has kindly made the php package to display the pounces and helped me with this project

Want to help?
If this plugin gets a lot of attention, it may be more than we can handle. We ask that anyone who is interested please provide any help you can give with this pawn script or PHP pages that show the data off. We're both busy guys and can only give so much time these days.

[Icettiflow]

L4D Pounce Record PHP Package

This zip file includes the required PHP files to display the pounce records on your site. To be used in conjunction with the Pounce Record plugin. See it in action HERE.

Requirements
-Webserver running PHP4 or higher
-MySQL version 4 or higher
-phpMyAdmin or SQL access to import the database

Installation
-Upload the zipped files to your webserver
-Import the included table.sql file or copy/paste the SQL in n0limit's post as a query.
-Edit the config.php to the settings you would like
-View the index.php

Thanks
n0limit - for creating the compliment to this PHP package.
msleeper - I liked his scheme for the stats page.

ToDo
-Create individual player stats page
-More sorting options for main table
-Ability to hide pounces on bots
-Make suggestions!

Update History

Version 1.0
-Initial Release

Version 1.0b
-Fixed typo.

Version 1.2
-Removed filtering based on damage/range as all results are sorted descending.
-Added the ability to filter pounces on bots
-Added the ability to round damage/range to decimal places.

[lekzero]

Thanks guys for making this plugin, but on decompress this file (l4dpouncerecord1.0b.zip) I get the following message:

That file is corrupted.

Thanks again.

Sorry about my english.

[savagekid]

Ya, I can confirm that the .zip file is corrupted.

[Icettiflow]

Updated. Try again.

[lekzero]

It's ok now. (the .zip file)

I can' t upload the file .DS_Store becouse the file has a (.) in front of his name, it makes the operation impossible, I removed the (.) and uploaded to server, but I can't rename the file to original name. It's a critical file? The MySQL, and the php page are alrelly runnig.

[Whosat]

No, the .DS_Store file is not important. You may skip it.

[Icettiflow]

Originally Posted by Whosat No, the .DS_Store file is not important. You may skip it.

That is correct. Sorry, i'm on an OSX system and it automatically adds that file to each directory sort of like windows adds the hidden .thumbs file.

I'll be sure to check the archived files when new versions are uploaded to prevent any confusion.

Thanks.

[lekzero]

If someone is able to use a free web host (PHP and MYSQL) that running with this plugin let me know please.

[Whosat]

Originally Posted by Icettiflow That is correct. Sorry, i'm on an OSX system and it automatically adds that file to each directory sort of like windows adds the hidden .thumbs file. I'll be sure to check the archived files when new versions are uploaded to prevent any confusion. Thanks.

Slightly off-topic but you can use DS_Store Cleaner.