#
# HLstats Game Support file for Counter-Strike 1.6
# ----------------------------------------------------
#
# To install, type:
#
#    mysql hlstats < gamesupport_cstrike.sql
#


#
# Game Definition
#
INSERT IGNORE INTO hlstats_Games VALUES ('cstrike','Counter-Strike','0','0');


#
# Awards
#
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'O','cstrike','Defused_The_Bomb','Top Defuser','bomb defusions',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'O','cstrike','Planted_The_Bomb','Top Demolitionist','bomb plantings',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'O','cstrike','Rescued_A_Hostage','Top Hostage Rescuer','hostages rescued',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'O','cstrike','Assassinated_The_VIP','Top Assassin','assassinations',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','cstrike','elite','Dual Berretta Elites','kills with elite',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','cstrike','knife','Knife Maniac','knifings',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','cstrike','awp','AWP','snipings with awp',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','cstrike','p90','P90','kills with p90',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','cstrike','deagle','Desert Eagle','kills with deagle',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','cstrike','m3','Shotgun','kills with m3 shotgun',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','cstrike','usp','USP Master','kills with usp',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','cstrike','m4a1','Colt M4A1 Carbine','kills with m4a1',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','cstrike','glock18','Glock','kills with glock18',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','cstrike','ak47','AK47','kills with ak47',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','cstrike','famas','Fusil Automatique','kills with famas',NULL,NULL);
INSERT IGNORE INTO hlstats_Awards VALUES (NULL,'W','cstrike','galil','Galil','kills with galil',NULL,NULL);


#
# Player Actions
#
INSERT IGNORE INTO hlstats_Actions VALUES (NULL,'cstrike','Begin_Bomb_Defuse_Without_Kit',0,0,'CT','Start Defusing the Bomb Without a Defuse Kit','1','0','0','0');   
INSERT IGNORE INTO hlstats_Actions VALUES (NULL,'cstrike','Begin_Bomb_Defuse_With_Kit',0,0,'CT','Start Defusing the Bomb With a Defuse Kit','1','0','0','0'); 
INSERT IGNORE INTO hlstats_Actions VALUES (NULL,'cstrike','Assassinated_The_VIP',10,0,'TERRORIST','Assassinate the VIP','1','0','0','0');
INSERT IGNORE INTO hlstats_Actions VALUES (NULL,'cstrike','Planted_The_Bomb',15,2,'TERRORIST','Plant the Bomb','1','0','0','0');
INSERT IGNORE INTO hlstats_Actions VALUES (NULL,'cstrike','Defused_The_Bomb',15,0,'CT','Defuse the Bomb','1','0','0','0');
INSERT IGNORE INTO hlstats_Actions VALUES (NULL,'cstrike','Touched_A_Hostage',2,0,'CT','Touch a Hostage','1','0','0','0');
INSERT IGNORE INTO hlstats_Actions VALUES (NULL,'cstrike','Rescued_A_Hostage',5,1,'CT','Rescue a Hostage','1','0','0','0');
INSERT IGNORE INTO hlstats_Actions VALUES (NULL,'cstrike','Killed_A_Hostage',-25,1,'CT','Kill a Hostage','1','0','0','0');
INSERT IGNORE INTO hlstats_Actions VALUES (NULL,'cstrike','Became_VIP',1,0,'CT','Become the VIP','1','0','0','0');
INSERT IGNORE INTO hlstats_Actions VALUES (NULL,'cstrike','Spawned_With_The_Bomb',2,0,'TERRORIST','Spawn with the Bomb','1','0','0','0');
INSERT IGNORE INTO hlstats_Actions VALUES (NULL,'cstrike','Got_The_Bomb',2,0,'TERRORIST','Pick up the Bomb','1','0','0','0');
INSERT IGNORE INTO hlstats_Actions VALUES (NULL,'cstrike','Dropped_The_Bomb',-2,0,'TERRORIST','Drop the Bomb','1','0','0','0');


#
# Team Actions
#
INSERT IGNORE INTO hlstats_Actions VALUES (NULL,'cstrike','CTs_Win',0,2,'CT','All Terrorists eliminated','0','0','1','0');
INSERT IGNORE INTO hlstats_Actions VALUES (NULL,'cstrike','Terrorists_Win',0,2,'TERRORIST','All Counter-Terrorists eliminated','0','0','1','0');
INSERT IGNORE INTO hlstats_Actions VALUES (NULL,'cstrike','All_Hostages_Rescued',0,10,'CT','Counter-Terrorists rescued all the hostages','0','0','1','0');
INSERT IGNORE INTO hlstats_Actions VALUES (NULL,'cstrike','Target_Bombed',0,10,'TERRORIST','Terrorists bombed the target','0','0','1','0');
INSERT IGNORE INTO hlstats_Actions VALUES (NULL,'cstrike','VIP_Assassinated',0,6,'TERRORIST','Terrorists assassinated the VIP','0','0','1','0');
INSERT IGNORE INTO hlstats_Actions VALUES (NULL,'cstrike','Bomb_Defused',0,6,'CT','Counter-Terrorists defused the bomb','0','0','1','0');
INSERT IGNORE INTO hlstats_Actions VALUES (NULL,'cstrike','VIP_Escaped',0,10,'CT','VIP escaped','0','0','1','0');


#
# Teams
#
INSERT IGNORE INTO hlstats_Teams VALUES (NULL,'cstrike','TERRORIST','Terrorist','0');
INSERT IGNORE INTO hlstats_Teams VALUES (NULL,'cstrike','CT','Counter-Terrorist','0');
INSERT IGNORE INTO hlstats_Teams VALUES (NULL,'cstrike','SPECTATOR','Spectator','0');


#
# Weapons
#
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'cstrike','knife','Bundeswehr Advanced Combat Knife',1.80);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'cstrike','usp','H&K USP .45 Tactical',1.50);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'cstrike','glock18','Glock 18 Select Fire',1.50);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'cstrike','deagle','Desert Eagle .50AE',1.50);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'cstrike','p228','Sig Sauer P-228',1.50);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'cstrike','m3','Benelli M3 Super 90 Combat',1.40);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'cstrike','xm1014','Benelli/H&K M4 Super 90 XM1014',1.40);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'cstrike','mp5navy','H&K MP5-Navy',1.25);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'cstrike','tmp','Steyr Tactical Machine Pistol',1.25);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'cstrike','p90','FN P90',1.25);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'cstrike','m4a1','Colt M4A1 Carbine',1.00);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'cstrike','ak47','Kalashnikov AK-47',1.00);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'cstrike','sg552','Sig Sauer SG-552 Commando',1.00);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'cstrike','scout','Steyr Scout',1.60);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'cstrike','awp','Arctic Warfare Magnum (Police)',1.40);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'cstrike','g3sg1','H&K G3/SG1 Sniper Rifle',1.40);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'cstrike','m249','M249 PARA Light Machine Gun',0.80);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'cstrike','grenade','High Explosive Grenade',1.80);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'cstrike','elite','Dual Beretta 96G Elite',1.50);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'cstrike','aug','Steyr Aug',1.00);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'cstrike','mac10','Ingram MAC-10',1.25);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'cstrike','fiveseven','FN Five-Seven',1.50);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'cstrike','ump45','H&K UMP45',1.25);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'cstrike','sg550','Sig SG-550 Sniper',1.70);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'cstrike','famas','Fusil Automatique',1.00);
INSERT IGNORE INTO hlstats_Weapons VALUES (NULL,'cstrike','galil','Galil',1.00);