Raised This Month: $ Target: $400
 0% 

Total Kills with mySQL


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Plugin Info:     Modification:   ALL        Category:   Statistical        Approver:   v3x (159)
Sonic7145
Member
Join Date: Jul 2005
Location: USA
Old 01-08-2006 , 14:55   Total Kills with mySQL
Reply With Quote #1

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?)
Attached Files
File Type: sma Get Plugin or Get Source (totalkills_sql.sma - 3756 views - 3.1 KB)

Last edited by Sonic7145; 12-22-2007 at 11:45. Reason: Adding to "To-Do" list.
Sonic7145 is offline
 



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 10:42.


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