Total Kills with mySQL

Sonic7145 · **Plugin Info:**

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?)

**Hawk552** · 01-08-2006 , 14:59

SQL seems a bit of a sledgehammer to kill a fly, unless you have like 10,000 people on your server a day.

Maybe integrate an option to use vault / SQL?

Otherwise, great idea.

EDIT: also, you can read from the SQL file in AMXX, the cvars attached to it, or whatever. You should implement cvars in some way though, as about 90% of server admins with AMXX don't know how to compile a plugin.

Sonic7145 · 01-08-2006 , 15:01

Quote:

Originally Posted by Hawk552

Maybe integrate an option to use vault / SQL?

Otherwise, great idea.

EDIT: also, you can read from the SQL file in AMXX, the cvars attached to it, or whatever. You should implement cvars in some way though, as about 90% of server admins with AMXX don't know how to compile a plugin.

Thanks =)
Great suggestions - if it's approved I'll try and make those available in the next version.

Styles · 01-08-2006 , 15:58

I dont know.. isant this kinda ike ranks? just that it only logs kils in a mysql table instead of a file?

Sonic7145 · 01-08-2006 , 16:10

I've never seen the Rank plugin, but this doesn't rank the players - it simply displays the user their statistics, and logs information for the server admin.