[msleeper]

War Tracker + Enforcer

This plugin tracks Soldier vs. Demoman deaths for the War. This information is tracked very basically into the "default" MySQL database. Whenever a Soldier kills a Demoman or vice versa, it adds 1 to the death count.

The plugin also is capable of enforcing player classes. Classes can be enforced to Soldier and Demo mixed, or Red Demo/Blu Soldier only. Note: I highly recommend non-team switching maps if you use the latter, since people will complain GREATLY when they are forced to swap teams to the class they dislike/do not support!

I am not providing any web interface at this time for the stats, though I may in the future. You can check your War Stats in real-time by typing:

!warstats in chat
/warstats in chat
sm_warstats in console

Anyone who wants to develop this further, please do. It should be very easy to get the kill stats using a PHP script for your website!

Installation
Installation is incredibly easy, install the plugin in your /addons/sourcemod/plugins/ directory and refresh your plugin list, or change map.

Configuration
A config file will automatically be generated in /cfg/sourcemod/ when the plugin is first ran.

sm_wartrack_trackdeaths - Enable/disable kill tracking
sm_wartrack_enforcemode - Class enforcement option. 0 = disabled, 1 = Demos and Soldiers only, 2 = Red Demos and Blu Soldiers.
sm_wartrack_roundannounce = Enable/disable round start announcement.

Use this SQL to create your table.

PHP Code:

CREATE TABLE IF NOT EXISTS `sm_wartrack` (
  `name` varchar(255) NOT NULL,
  `value` int(11) NOT NULL,
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
INSERT INTO `sm_wartrack` (`name`, `value`) VALUES
('soldier_deaths', 0),
('demoman_deaths', 0); 


[msleeper]

Recommended maplist for enforcemode 2:

PHP Code:

cp_badlands
cp_fastlane
cp_granary
cp_well
cp_yukon_final
cp_castle4
ctf_2fort
ctf_sawmill
ctf_turbine
ctf_well
koth_garbage_day
koth_harvest_event
koth_lighthouse_rc5
koth_nucleus
koth_oilfield
koth_sawmill
koth_viaduct
koth_waste
tc_hydro 


Note: cp_castle4 does change teams so you should make a map config for enforcemode 1.

[msleeper]

Updated to 1.1, added sm_warstats command to show chat output of tracked kills.

[LordVader!]

Great job!


One request can you add the ability for the plugin to display the current war stats every x minutes? Maybe in the hint area of the screen?

I'm going to install this on all of my servers and it would be nice to have the stats displayed periodically without the need to use a command.

[MjrNuT]

Originally Posted by msleeper I am not providing any web interface at this time for the stats, though I may in the future. You can check your War Stats in real-time by typing:

Thanks for the plugin.

I don't know how much work it would be for this, but maybe something to easily incorporate to already existing stats plugins w/ web tracking already, like TF2 Stats that was updated by DarthNinja?

http://forums.alliedmods.net/showthread.php?t=109006

I'm not meaning you provide for all stats loggers existing, but if there was a general script one could take to implement, if that makes any sense as I'm just quite alien to code.


Now for what I guess is fundamental question here as I'm just not seeing it.

I see you've provided the script for creating the table.

Thus, how does the plugin know to put the data in such a table? databases.cfg entry?

Sorry for the n00b-ish.

[Nightbox]

L 12/12/2009 - 12:00:37: [SM] Native "IsClientConnected" reported: Client index 0 is invalid
L 12/12/2009 - 12:00:37: [SM] Displaying call stack trace for plugin "wartrack.smx":
L 12/12/2009 - 12:00:37: [SM]   [0]  Line 180, /home/groups/alliedmodders/forums/files/3/7/5/2/1/55074.attach::cmd_WarStats()

Any idea?

[msleeper]

Originally Posted by MjrNuT I don't know how much work it would be for this, but maybe something to easily incorporate to already existing stats plugins w/ web tracking already, like TF2 Stats that was updated by DarthNinja? [. . .] Thus, how does the plugin know to put the data in such a table? databases.cfg entry?

You can request your favorite stat tracking to add some sort of web interface or web output for this. As I said it should be extremely simple for someone with even the most basic of PHP knowledge. I will post a quick and dirty example here soon.

The plugin uses the "default" database in the databases.cfg. Presumably this is the same one you use for web admin, SourceBans, etc. If not, just go ahead and modify your "default" database with the right information. Conversely, you can change which database it uses by editing this line:

PHP Code:

    db = SQL_Connect("default", true, Error, sizeof(Error)); 


At lines 154 and 184.

Originally Posted by LordVader! One request can you add the ability for the plugin to display the current war stats every x minutes? Maybe in the hint area of the screen?

I will add in a global announcement on Round Start when I...

Originally Posted by Nightbox L 12/12/2009 - 12:00:37: [SM] Native "IsClientConnected" reported: Client index 0 is invalid L 12/12/2009 - 12:00:37: [SM] Displaying call stack trace for plugin "wartrack.smx": L 12/12/2009 - 12:00:37: [SM] [0] Line 180, /home/groups/alliedmodders/forums/files/3/7/5/2/1/55074.attach::cmd_WarStats() Any idea?

Fix this up. It's a harmless error but I'll go ahead and fix it.

[Broseph]

Can you use this to display kills in a message?

[Nightbox]

"t's a harmless error"

typing !warstats shows nothing

[msleeper]

Originally Posted by Broseph Can you use this to display kills in a message?

What do you mean?

Originally Posted by Nightbox "t's a harmless error" typing !warstats shows nothing

Did you create the table using the SQL I posted? The table needs to exsit before this will work.