Raised This Month: $202 Target: $400
 50% 

[L4D] PounceRecord 1.1


Post New Thread Reply   
 
Thread Tools Display Modes
Author
n0limit
Senior Member
Join Date: May 2009
Plugin ID:
1022
Plugin Version:
1.1
Plugin Category:
General Purpose
Plugin Game:
Left 4 Dead
Plugin Dependencies:
    Servers with this Plugin:
    1 
    Plugin Description:
    PounceRecord records each pounce to a central database, which can be displayed via web or in-game
    Old 07-21-2009 , 11:18   [L4D] PounceRecord 1.1
    Reply With Quote #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.
    Attached Files
    File Type: sp Get Plugin or Get Source (pouncerecord.sp - 2301 views - 4.5 KB)

    Last edited by n0limit; 07-25-2009 at 12:06. Reason: Updated to 1.1
    n0limit is offline
    Icettiflow
    Senior Member
    Join Date: Jan 2009
    Old 07-21-2009 , 11:20   Re: [L4D] PounceRecord 1.2
    Reply With Quote #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.
    Attached Files
    File Type: zip l4dpouncerecord1.2.zip (43.4 KB, 531 views)

    Last edited by Icettiflow; 07-23-2009 at 13:54. Reason: Updated to 1.2
    Icettiflow is offline
    lekzero
    Member
    Join Date: Jul 2009
    Old 07-21-2009 , 13:14   Re: [L4D] PounceRecord 1.0
    Reply With Quote #3

    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.

    Last edited by lekzero; 07-21-2009 at 14:51.
    lekzero is offline
    savagekid
    Senior Member
    Join Date: Apr 2009
    Location: Canada
    Old 07-21-2009 , 13:16   Re: [L4D] PounceRecord 1.0
    Reply With Quote #4

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

    Use Coupon Code "GLOBAL50" To Get 50% Off Every Month.
    savagekid is offline
    Send a message via MSN to savagekid
    Icettiflow
    Senior Member
    Join Date: Jan 2009
    Old 07-21-2009 , 13:17   Re: [L4D] PounceRecord 1.0
    Reply With Quote #5

    Updated. Try again.
    Icettiflow is offline
    lekzero
    Member
    Join Date: Jul 2009
    Old 07-21-2009 , 14:51   Re: [L4D] PounceRecord 1.0
    Reply With Quote #6

    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.

    Last edited by lekzero; 07-21-2009 at 23:30.
    lekzero is offline
    Whosat
    Senior Member
    Join Date: Nov 2007
    Location: Singapore
    Old 07-22-2009 , 04:34   Re: [L4D] PounceRecord 1.0
    Reply With Quote #7

    No, the .DS_Store file is not important. You may skip it.
    __________________
    Whosat is offline
    Icettiflow
    Senior Member
    Join Date: Jan 2009
    Old 07-22-2009 , 08:00   Re: [L4D] PounceRecord 1.0
    Reply With Quote #8

    Quote:
    Originally Posted by Whosat View Post
    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.
    Icettiflow is offline
    lekzero
    Member
    Join Date: Jul 2009
    Old 07-22-2009 , 14:42   Re: [L4D] PounceRecord 1.0
    Reply With Quote #9

    If someone is able to use a free web host (PHP and MYSQL) that running with this plugin let me know please.
    lekzero is offline
    Whosat
    Senior Member
    Join Date: Nov 2007
    Location: Singapore
    Old 07-22-2009 , 18:08   Re: [L4D] PounceRecord 1.0
    Reply With Quote #10

    Quote:
    Originally Posted by Icettiflow View Post
    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.
    __________________
    Whosat 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 15:48.


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