AlliedModders - [L4D] PounceRecord 1.1

AlliedModders (https://forums.alliedmods.net/index.php)

- Plugins (https://forums.alliedmods.net/forumdisplay.php?f=108)

- - [L4D] PounceRecord 1.1 (https://forums.alliedmods.net/showthread.php?t=97947)

[L4D] PounceRecord 1.1

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:

Code:

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:

Code:

    "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.

Re: [L4D] PounceRecord 1.2

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

Code:

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.