Total Kills with mySQL

[greenie]

Total Kills with mySQL
Version 1.1

Credits
Suicid3, for helping me get the SQL queries correct.
Hawk552, Brad, v3x for suggesting the cvars from sql.cfg.

Description
This plugin will automatically create a table when ran. When a user joins it will log their name, Steam ID, and start them with 0 frags. A red hudmessage will be displayed on the right side of the screen, showing their total kills on this server. Each time they kill, it is logged into the database, and when they return to this server, the hud message will show whatever kills they had when they left last time - and it will keep adding this game as well.

Usage
Edit sql.cfg and change the settings to match your SQL settings. The script will automatically detect them and automatically create the table. All you have to do is edit that file, compile it, and run it. =)

(Make sure SQL is running)


Things to add/fix
-If user changes name, update the SQL.
-Kill to Death Ratio, perhaps display number of deaths.
-Play a sound every x frags a client gets.
-Add a vault version, instead of using SQL
-Committing suicide results in a frag
-So does killing teammates ^

Tested on TS. (any others?)

plugin
source