hlstatsx/sql/Upgrade 1.5.3 - 1.5.4/upgrade_hlxcomm_153_154.sql

INSERT IGNORE INTO `hlstats_Actions` (`game`, `code`, `reward_player`, `reward_team`, `team`, `description`, `for_PlayerActions`, `for_PlayerPlayerActions`, `for_TeamActions`, `for_WorldActions`) VALUES
('bg2', 'kill_streak_2', 1, 0, '', 'Double Kill (2 kills)', '1', '', '', ''),
('bg2', 'kill_streak_3', 2, 0, '', 'Triple Kill (3 kills)', '1', '', '', ''),
('bg2', 'kill_streak_4', 3, 0, '', 'Domination (4 kills)', '1', '', '', ''),
('bg2', 'kill_streak_5', 4, 0, '', 'Rampage (5 kills)', '1', '', '', ''),
('bg2', 'kill_streak_6', 5, 0, '', 'Mega Kill (6 kills)', '1', '', '', ''),
('bg2', 'kill_streak_7', 6, 0, '', 'Ownage (7 kills)', '1', '', '', ''),
('bg2', 'kill_streak_8', 7, 0, '', 'Ultra Kill (8 kills)', '1', '', '', ''),
('bg2', 'kill_streak_9', 8, 0, '', 'Killing Spree (9 kills)', '1', '', '', ''),
('bg2', 'kill_streak_10', 9, 0, '', 'Monster Kill (10 kills)', '1', '', '', ''),
('bg2', 'kill_streak_11', 10, 0, '', 'Unstoppable (11 kills)', '1', '', '', ''),
('bg2', 'kill_streak_12', 11, 0, '', 'God Like (12+ kills)', '1', '', '', ''),
('sgtls', 'kill_streak_2', 1, 0, '', 'Double Kill (2 kills)', '1', '', '', ''),
('sgtls', 'kill_streak_3', 2, 0, '', 'Triple Kill (3 kills)', '1', '', '', ''),
('sgtls', 'kill_streak_4', 3, 0, '', 'Domination (4 kills)', '1', '', '', ''),
('sgtls', 'kill_streak_5', 4, 0, '', 'Rampage (5 kills)', '1', '', '', ''),
('sgtls', 'kill_streak_6', 5, 0, '', 'Mega Kill (6 kills)', '1', '', '', ''),
('sgtls', 'kill_streak_7', 6, 0, '', 'Ownage (7 kills)', '1', '', '', ''),
('sgtls', 'kill_streak_8', 7, 0, '', 'Ultra Kill (8 kills)', '1', '', '', ''),
('sgtls', 'kill_streak_9', 8, 0, '', 'Killing Spree (9 kills)', '1', '', '', ''),
('sgtls', 'kill_streak_10', 9, 0, '', 'Monster Kill (10 kills)', '1', '', '', ''),
('sgtls', 'kill_streak_11', 10, 0, '', 'Unstoppable (11 kills)', '1', '', '', ''),
('sgtls', 'kill_streak_12', 11, 0, '', 'God Like (12+ kills)', '1', '', '', ''),
('sgtls', 'Goa\'uld_Win', 5, 0, '', 'Goa\'uld Won Round', '', '', '1', ''),
('sgtls', 'Tau\'ri_Win', 5, 0, '', 'Tau\'ri Won Round', '', '', '1', ''),
('dystopia', 'kill_streak_2', 1, 0, '', 'Double Kill (2 kills)', '1', '', '', ''),
('dystopia', 'kill_streak_3', 2, 0, '', 'Triple Kill (3 kills)', '1', '', '', ''),
('dystopia', 'kill_streak_4', 3, 0, '', 'Domination (4 kills)', '1', '', '', ''),
('dystopia', 'kill_streak_5', 4, 0, '', 'Rampage (5 kills)', '1', '', '', ''),
('dystopia', 'kill_streak_6', 5, 0, '', 'Mega Kill (6 kills)', '1', '', '', ''),
('dystopia', 'kill_streak_7', 6, 0, '', 'Ownage (7 kills)', '1', '', '', ''),
('dystopia', 'kill_streak_8', 7, 0, '', 'Ultra Kill (8 kills)', '1', '', '', ''),
('dystopia', 'kill_streak_9', 8, 0, '', 'Killing Spree (9 kills)', '1', '', '', ''),
('dystopia', 'kill_streak_10', 9, 0, '', 'Monster Kill (10 kills)', '1', '', '', ''),
('dystopia', 'kill_streak_11', 10, 0, '', 'Unstoppable (11 kills)', '1', '', '', ''),
('dystopia', 'kill_streak_12', 11, 0, '', 'God Like (12+ kills)', '1', '', '', ''),
('dystopia', 'Capture Guard Post', 2, 0, '', 'Capture Guard Post', '1', '', '', ''),
('dystopia', 'Capture Interior Spawn', 2, 0, '', 'Capture Interior Spawn', '1', '', '', ''),
('dystopia', 'Capture Internal Spawn', 2, 0, '', 'Capture Internal Spawn', '1', '', '', ''),
('dystopia', 'Capture The Docks', 2, 0, '', 'Capture The Docks', '1', '', '', ''),
('dystopia', 'Capture the Inner Base', 2, 0, '', 'Capture the Inner Base', '1', '', '', ''),
('dystopia', 'Capture the Spawn', 2, 0, '', 'Capture the Spawn', '1', '', '', ''),
('dystopia', 'Cut Entrance Spawn Power', 2, 0, '', 'Cut Entrance Spawn Power', '1', '', '', ''),
('dystopia', 'Defend Interior Spawn', 2, 0, '', 'Defend Interior Spawn', '1', '', '', ''),
('dystopia', 'Defend Middle Spawn', 2, 0, '', 'Defend Middle Spawn', '1', '', '', ''),
('dystopia', 'Defend Security JIP', 2, 0, '', 'Defend Security JIP', '1', '', '', ''),
('dystopia', 'Destroy Broadcast Server', 2, 0, '', 'Destroy Broadcast Server', '1', '', '', ''),
('dystopia', 'Destroy Cooling Access Door', 2, 0, '', 'Destroy Cooling Access Door', '1', '', '', ''),
('dystopia', 'Destroy Cooling Tank', 2, 0, '', 'Destroy Cooling Tank', '1', '', '', ''),
('dystopia', 'Destroy The Bulkhead', 2, 0, '', 'Destroy The Bulkhead', '1', '', '', ''),
('dystopia', 'Destroy The Core', 2, 0, '', 'Destroy The Core', '1', '', '', ''),
('dystopia', 'Destroy the Firewall', 2, 0, '', 'Destroy the Firewall', '1', '', '', ''),
('dystopia', 'Destroy the Reactor', 2, 0, '', 'Destroy the Reactor', '1', '', '', ''),
('dystopia', 'Destroy Transformer', 2, 0, '', 'Destroy Transformer', '1', '', '', ''),
('dystopia', 'Enable Auxilary Power Feed', 2, 0, '', 'Enable Auxilary Power Feed', '1', '', '', ''),
('dystopia', 'Enable The 4-Point Override', 2, 0, '', 'Enable The 4-Point Override', '1', '', '', ''),
('dystopia', 'Escort Hostage', 2, 0, '', 'Escort Hostage', '1', '', '', ''),
('dystopia', 'Hack Middle Spawn', 2, 0, '', 'Hack Middle Spawn', '1', '', '', ''),
('dystopia', 'Hack Spawn Controls', 2, 0, '', 'Hack Spawn Controls', '1', '', '', ''),
('dystopia', 'Hack the Perimeter', 2, 0, '', 'Hack the Perimeter', '1', '', '', ''),
('dystopia', 'Inject The Virus', 2, 0, '', 'Inject The Virus', '1', '', '', ''),
('dystopia', 'Launch Missile', 2, 0, '', 'Launch Missile', '1', '', '', ''),
('dystopia', 'Locate profile', 2, 0, '', 'Locate profile', '1', '', '', ''),
('dystopia', 'Maintain Power Routing', 2, 0, '', 'Maintain Power Routing', '1', '', '', ''),
('dystopia', 'Open And Destroy Data Stores / Establish An Uplink', 2, 0, '', 'Open And Destroy Data Stores / Establish An Uplink', '1', '', '', ''),
('dystopia', 'Redirect Laser', 2, 0, '', 'Redirect Laser', '1', '', '', ''),
('dystopia', 'Reroute Power To Control Room', 2, 0, '', 'Reroute Power To Control Room', '1', '', '', ''),
('dystopia', 'Shut Down Security', 2, 0, '', 'Shut Down Security', '1', '', '', ''),
('dystopia', 'Shutdown The Production Line', 2, 0, '', 'hutdown The Production Line', '1', '', '', ''),
('dystopia', 'Smash Data Storage', 2, 0, '', 'Smash Data Storage', '1', '', '', ''),
('dystopia', 'Turn Power Offline', 2, 0, '', 'Turn Power Offline', '1', '', '', ''),
('l4d', 'cr0wned', 0, 0, '', 'Cr0wned (killed witch with single headshot)', '1', '', '', ''),
('l4d', 'hunter_punter', 0, 0, '', 'Hunter Punter (melee a Hunter mid-jump)', '1', '', '', ''),
('l4d', 'tounge_twister', 0, 0, '', 'Tounge Twister (kill a Smoker while he is dragging you)', '1', '', '', ''),
('l4d', 'protect_teammate', 0, 0, '', 'Protected Teammate', '1', '', '', ''),
('l4d', 'no_death_on_tank', 0, 0, '', 'No survivors died/incapped from tank', '1', '', '', ''),
('l4d', 'killed_all_survivors', 0, 0, '', 'Killed all survivors', '1', '', '', '');


INSERT IGNORE INTO `hlstats_Awards` (`awardType`, `game`, `code`, `name`, `verb`) VALUES
('O', 'l4d', 'hunter_punter', 'Hunter Punter', 'hunter punts'),
('O', 'l4d', 'protect_teammate', 'Protector', 'hunter punts'),
('W', 'fof', 'shotgun', 'Winchester Shotgun', 'kills with the Winchester'),
('W', 'bg2', 'brownbess', 'Brown Bess', 'kills with Brown Bess'),
('W', 'bg2', 'brownbess_bayonet', 'Brown Bess - Bayonet', 'kills with Brown Bess Bayonet'),
('W', 'bg2', 'charleville', 'Charleville', 'kills with Charleville'),
('W', 'bg2', 'charleville_bayonet', 'Charleville - Bayonet', 'kills with Charleville Bayonet'),
('W', 'bg2', 'hirschf', 'Hirschfaenger', 'kills with Hirschfaenger'),
('W', 'bg2', 'jaeger', 'Jaeger Rifle', 'kills with Jaeger Rifle'),
('W', 'bg2', 'knife', 'Knife', 'kills with Knife'),
('W', 'bg2', 'pennsylvania', 'Pennsylvania', 'kills with Pennsylvania'),
('W', 'bg2', 'pistol_a', 'British Pistol', 'kills with British Pistol'),
('W', 'bg2', 'pistol_b', 'American Pistol', 'kills with American Pistol'),
('W', 'bg2', 'sabre_a', 'British Sabre', 'kills with British Sabre'),
('W', 'bg2', 'sabre_b', 'American Sabre', 'kills with American Sabre'),
('W', 'bg2', 'mostkills', 'Most Kills', 'kills'),
('W', 'bg2', 'latency', 'Best Latency', 'ms average connection'),
('W', 'sgtls', 'mostkills', 'Most Kills', 'kills'),
('W', 'sgtls', 'latency', 'Best Latency', 'ms average connection'),
('W', 'sgtls', 'p90', 'FN Herstal P-90 Red Dot / FN-H P-90RD', 'kills'),
('W', 'sgtls', 'pistol', 'Beretta M92F-s', 'kills'),
('W', 'sgtls', 'knife', 'Combat Knife', 'kills'),
('W', 'sgtls', 'staff_blast', 'Staff Weapon', 'kills'),
('W', 'sgtls', 'p90D', 'FN Herstal P-90 w/ Disruptor', 'kills'),
('W', 'sgtls', 'hdevice', 'Hand Device / Ribbon Device', 'kills'),
('W', 'sgtls', 'tac_pulse', 'Tac (turrent)', 'kills'),
('W', 'sgtls', 'tac_projectile', 'Tac (bomb)', 'kills'),
('W', 'sgtls', 'c4_charge', 'C4', 'kills'),
('W', 'sgtls', 'grenade_projectile', 'M67 Frag Grenade', 'kills'),
('W', 'sgtls', 'g36', 'H&K G-36', 'kills'),
('W', 'sgtls', 'kull_blast', 'Kull Warrior Staff Device', 'kills'),
('W', 'sgtls', 'suicide_bomb', 'Goa\'uld Suicide Bomb', 'kills'),
('W', 'sgtls', 'kullblaster', 'Kull Warrior Staff Device (blast)', 'kills'),
('W', 'sgtls', 'staff', 'Staff Weapon Melee', 'kills'),
('W', 'sgtls', 'zat_blast', 'Zat', 'kills'),
('W', 'sgtls', 'awp', 'AWP Rifle', 'kills'),
('W', 'sgtls', 'grenade', 'M67 Frag Grenade', 'kills'),
('W', 'sgtls', 'zat', 'Zat (splash)', 'kills'),
('W', 'sgtls', 'tac', 'Tac (splash)', 'kills'),
('O', 'dystopia', 'Capture Guard Post', 'Capture Guard Post', 'captures'),
('O', 'dystopia', 'Capture Interior Spawn', 'Capture Interior Spawn', 'captures'),
('O', 'dystopia', 'Capture Internal Spawn', 'Capture Internal Spawn', 'captures'),
('O', 'dystopia', 'Capture The Docks', 'Capture The Docks', 'captures'),
('O', 'dystopia', 'Capture the Inner Base', 'Capture the Inner Base', 'captures'),
('O', 'dystopia', 'Capture the Spawn', 'Capture the Spawn', 'captures'),
('O', 'dystopia', 'Cut Entrance Spawn Power', 'Cut Entrance Spawn Power', 'power cuts'),
('O', 'dystopia', 'Defend Interior Spawn', 'Defend Interior Spawn', 'defenses'),
('O', 'dystopia', 'Defend Middle Spawn', 'Defend Middle Spawn', 'defenses'),
('O', 'dystopia', 'Defend Security JIP', 'Defend Security JIP', 'defenses'),
('O', 'dystopia', 'Destroy Broadcast Server', 'Destroy Broadcast Server', 'destructions'),
('O', 'dystopia', 'Destroy Cooling Access Door', 'Destroy Cooling Access Door', 'destructions'),
('O', 'dystopia', 'Destroy Cooling Tank', 'Destroy Cooling Tank', 'destructions'),
('O', 'dystopia', 'Destroy The Bulkhead', 'Destroy The Bulkhead', 'destructions'),
('O', 'dystopia', 'Destroy The Core', 'Destroy The Core', 'destructions'),
('O', 'dystopia', 'Destroy the Firewall', 'Destroy the Firewall', 'destructions'),
('O', 'dystopia', 'Destroy the Reactor', 'Destroy the Reactor', 'destructions'),
('O', 'dystopia', 'Destroy Transformer', 'Destroy Transformer', 'destructions'),
('O', 'dystopia', 'Enable Auxilary Power Feed', 'Enable Auxilary Power Feed', 'power feed enablings'),
('O', 'dystopia', 'Enable The 4-Point Override', 'Enable The 4-Point Override', '4-point override enablings'),
('O', 'dystopia', 'Escort Hostage', 'Escort Hostage', 'escorts'),
('O', 'dystopia', 'Hack Middle Spawn', 'Hack Middle Spawn', 'hacks'),
('O', 'dystopia', 'Hack Spawn Controls', 'Hack Spawn Controls', 'hacks'),
('O', 'dystopia', 'Hack the Perimeter', 'Hack the Perimeter', 'hacks'),
('O', 'dystopia', 'Inject The Virus', 'Inject The Virus', 'injections'),
('O', 'dystopia', 'Launch Missile', 'Launch Missile', 'launches'),
('O', 'dystopia', 'Locate profile', 'Locate profile', 'locations'),
('O', 'dystopia', 'Maintain Power Routing', 'Maintain Power Routing', 'maintenances'),
('O', 'dystopia', 'Open And Destroy Data Stores / Establish An Uplink', 'Open And Destroy Data Stores / Establish An Uplink', 'times'),
('O', 'dystopia', 'Redirect Laser', 'Redirect Laser', 'redirections'),
('O', 'dystopia', 'Reroute Power To Control Room', 'Reroute Power To Control Room', 'reroutings'),
('O', 'dystopia', 'Shut Down Security', 'Shut Down Security', 'shutdowns'),
('O', 'dystopia', 'Shutdown The Production Line', 'hutdown The Production Line', 'shutdowns'),
('O', 'dystopia', 'Smash Data Storage', 'Smash Data Storage', 'smashings'),
('O', 'dystopia', 'Turn Power Offline', 'Turn Power Offline', 'times'),
('W', 'dystopia', 'bonuspoints', 'Most Bonus Points', 'bonus points'),
('W', 'dystopia', 'latency', 'Best Latency', 'ms average connection'),
('W', 'dystopia', 'Light Katana', 'Light Katana', 'kills'),
('W', 'dystopia', 'Medium Katana', 'Medium Katana', 'kills'),
('W', 'dystopia', 'Fatman Fist', 'Fatman Fist', 'kills'),
('W', 'dystopia', 'Machine Pistol', 'Machine Pistol', 'kills'),
('W', 'dystopia', 'Shotgun', 'Shotgun', 'kills'),
('W', 'dystopia', 'Laser Rifle', 'Laser Rifle', 'kills'),
('W', 'dystopia', 'BoltGun', 'Bolt Gun', 'kills'),
('W', 'dystopia', 'SmartLock Pistols', 'Smartlock Pistols', 'kills'),
('W', 'dystopia', 'Assault Rifle', 'Assault Rifle', 'kills'),
('W', 'dystopia', 'Grenade Launcher', 'Grenade Launcher', 'kills'),
('W', 'dystopia', 'MK-808 Rifle', 'MK-808 Rifle', 'kills'),
('W', 'dystopia', 'Tesla Rifle', 'Tesla Rifle', 'kills'),
('W', 'dystopia', 'Rocket Launcher', 'Rocket Launcher', 'kills'),
('W', 'dystopia', 'Minigun', 'Minigun', 'kills'),
('W', 'dystopia', 'Ion Cannon', 'Ion Cannon', 'kills'),
('W', 'dystopia', 'Basilisk', 'Basilisk', 'kills'),
('W', 'dystopia', 'Frag Grenade', 'Frag Grenade', 'kills'),
('W', 'dystopia', 'EMP Grenade', 'EMP Grenade', 'kills'),
('W', 'dystopia', 'Spider Grenade', 'Spider Grenade', 'kills'),
('W', 'dystopia', 'Cortex Bomb', 'Cortex Bomb', 'kills'),
('W', 'dystopia', 'Leg Boosters', 'Leg Boosters', 'kills'),
('W', 'dystopia', 'Trap', 'Trap', 'kills'),
('W', 'dystopia', 'Turret', 'Turret', 'kills');

ALTER TABLE `hlstats_Clans`
ADD COLUMN `mapregion` varchar(128) NOT NULL default '';

ALTER TABLE `hlstats_Events_Admin`
CHANGE `message` `message` varchar(255) NOT NULL default '';

INSERT IGNORE INTO `hlstats_Games` (`code`, `name`, `realgame`, `hidden`) VALUES
('bg2', 'Battle Grounds 2', 'bg2', '1'),
('sgtls', 'Stargate: The Last Stand', 'sgtls', '1'),
('dystopia', 'Dystopia', 'dystopia', '1');

UPDATE `hlstats_Games_Defaults` SET `value` = 0 WHERE `parameter` = 'DisplayResultsInBrowser' AND `code` IN ('ges','insmod');

INSERT IGNORE INTO `hlstats_Games_Defaults` (`code`, `parameter`, `value`) VALUES
('bg2', 'DisplayResultsInBrowser', '1'),
('bg2', 'GameEngine', '3'),
('bg2', 'AddressPort', '0.0.0.0:27015'),
('bg2', 'Admins', ''),
('bg2', 'AutoBanRetry', '0'),
('bg2', 'AutoTeamBalance', '0'),
('bg2', 'BonusRoundIgnore', '0'),
('bg2', 'BonusRoundTime', '0'),
('bg2', 'BroadCastEvents', '1'),
('bg2', 'BroadCastPlayerActions', '1'),
('bg2', 'DefaultDisplayEvents', '1'),
('bg2', 'EnablePublicCommands', '1'),
('bg2', 'GameType', '0'),
('bg2', 'HLStatsURL', 'http://yoursite.com/hlstats'),
('bg2', 'IgnoreBots', '1'),
('bg2', 'MinimumPlayersRank', '0'),
('bg2', 'MinPlayers', '4'),
('bg2', 'PlayerEvents', '1'),
('bg2', 'ShowStats', '1'),
('bg2', 'SkillMode', '0'),
('bg2', 'SuicidePenalty', '5'),
('bg2', 'SwitchAdmins', '0'),
('bg2', 'TKPenalty', '25'),
('bg2', 'TrackServerLoad', '1'),
('bg2', 'ConnectAnnounce', '1'),
('bg2', 'UpdateHostname', '1'),
('sgtls', 'DisplayResultsInBrowser', '1'),
('sgtls', 'GameEngine', '3'),
('sgtls', 'AddressPort', '0.0.0.0:27015'),
('sgtls', 'Admins', ''),
('sgtls', 'AutoBanRetry', '0'),
('sgtls', 'AutoTeamBalance', '0'),
('sgtls', 'BonusRoundIgnore', '0'),
('sgtls', 'BonusRoundTime', '0'),
('sgtls', 'BroadCastEvents', '1'),
('sgtls', 'BroadCastPlayerActions', '1'),
('sgtls', 'DefaultDisplayEvents', '1'),
('sgtls', 'EnablePublicCommands', '1'),
('sgtls', 'GameType', '0'),
('sgtls', 'HLStatsURL', 'http://yoursite.com/hlstats'),
('sgtls', 'IgnoreBots', '1'),
('sgtls', 'MinimumPlayersRank', '0'),
('sgtls', 'MinPlayers', '4'),
('sgtls', 'PlayerEvents', '1'),
('sgtls', 'ShowStats', '1'),
('sgtls', 'SkillMode', '0'),
('sgtls', 'SuicidePenalty', '5'),
('sgtls', 'SwitchAdmins', '0'),
('sgtls', 'TKPenalty', '25'),
('sgtls', 'TrackServerLoad', '1'),
('sgtls', 'ConnectAnnounce', '1'),
('sgtls', 'UpdateHostname', '1'),
('dystopia', 'DisplayResultsInBrowser', '1'),
('dystopia', 'GameEngine', '2'),
('dystopia', 'AddressPort', '0.0.0.0:27015'),
('dystopia', 'Admins', ''),
('dystopia', 'AutoBanRetry', '0'),
('dystopia', 'AutoTeamBalance', '0'),
('dystopia', 'BonusRoundIgnore', '0'),
('dystopia', 'BonusRoundTime', '0'),
('dystopia', 'BroadCastEvents', '1'),
('dystopia', 'BroadCastPlayerActions', '1'),
('dystopia', 'DefaultDisplayEvents', '1'),
('dystopia', 'EnablePublicCommands', '1'),
('dystopia', 'GameType', '0'),
('dystopia', 'HLStatsURL', 'http://yoursite.com/hlstats'),
('dystopia', 'IgnoreBots', '1'),
('dystopia', 'MinimumPlayersRank', '0'),
('dystopia', 'MinPlayers', '4'),
('dystopia', 'PlayerEvents', '1'),
('dystopia', 'ShowStats', '1'),
('dystopia', 'SkillMode', '0'),
('dystopia', 'SuicidePenalty', '5'),
('dystopia', 'SwitchAdmins', '0'),
('dystopia', 'TKPenalty', '25'),
('dystopia', 'TrackServerLoad', '1'),
('dystopia', 'ConnectAnnounce', '1'),
('dystopia', 'UpdateHostname', '1'),
('bg2', 'PlayerEventsCommandOSD', ''),
('hl2mp', 'PlayerEventsCommandOSD', '');

INSERT IGNORE INTO `hlstats_Games_Supported` (`code`, `name`) VALUES
('bg2', 'Battle Grounds 2'),
('sgtls', 'Stargate: The Last Stand'),
('dystopia', 'Dystopia');

DELETE FROM `hlstats_Options` WHERE `keyname` = 'dbversion';

INSERT IGNORE INTO `hlstats_Options` (`keyname`, `value`, `opttype`) VALUES
('dbversion', '4', 2),
('version', '1.5.4', 1),
('showqueries','1',2);

INSERT IGNORE INTO `hlstats_Options_Choices` (`keyname`, `value`, `text`, `isDefault`) VALUES
('showqueries', '0', 'No', 1),
('showqueries', '1', 'Yes', 0),
('google_map_region', 'EUROPE', 'Europe', 0);

ALTER TABLE `hlstats_Players`
ADD COLUMN  `blockavatar` int(1) unsigned NOT NULL default '0';

INSERT IGNORE INTO `hlstats_Ranks` (`image`, `minKills`, `maxKills`, `rankName`, `game`) VALUES
('recruit', 0, 49, 'Recruit', 'bg2'),
('private', 50, 99, 'Private', 'bg2'),
('private-first-class', 100, 199, 'Private First Class', 'bg2'),
('lance-corporal', 200, 299, 'Lance Corporal', 'bg2'),
('corporal', 300, 399, 'Corporal', 'bg2'),
('sergeant', 400, 499, 'Sergeant', 'bg2'),
('staff-sergeant', 500, 599, 'Staff Sergeant', 'bg2'),
('gunnery-sergeant', 600, 699, 'Gunnery Sergeant', 'bg2'),
('master-sergeant', 700, 799, 'Master Sergeant', 'bg2'),
('first-sergeant', 800, 899, 'First Sergeant', 'bg2'),
('master-chief', 900, 999, 'Master Chief', 'bg2'),
('sergeant-major', 1000, 1199, 'Sergeant Major', 'bg2'),
('ensign', 1200, 1399, 'Ensign', 'bg2'),
('third-lieutenant', 1400, 1599, 'Third Lieutenant', 'bg2'),
('second-lieutenant', 1600, 1799, 'Second Lieutenant', 'bg2'),
('first-lieutenant', 1800, 1999, 'First Lieutenant', 'bg2'),
('captain', 2000, 2249, 'Captain', 'bg2'),
('group-captain', 2250, 2499, 'Group Captain', 'bg2'),
('senior-captain', 2500, 2749, 'Senior Captain', 'bg2'),
('lieutenant-major', 2750, 2999, 'Lieutenant Major', 'bg2'),
('major', 3000, 3499, 'Major', 'bg2'),
('group-major', 3500, 3999, 'Group Major', 'bg2'),
('lieutenant-commander', 4000, 4499, 'Lieutenant Commander', 'bg2'),
('commander', 4500, 4999, 'Commander', 'bg2'),
('group-commander', 5000, 5749, 'Group Commander', 'bg2'),
('lieutenant-colonel', 5750, 6499, 'Lieutenant Colonel', 'bg2'),
('colonel', 6500, 7249, 'Colonel', 'bg2'),
('brigadier', 7250, 7999, 'Brigadier', 'bg2'),
('brigadier-general', 8000, 8999, 'Brigadier General', 'bg2'),
('major-general', 9000, 9999, 'Major General', 'bg2'),
('lieutenant-general', 10000, 12499, 'Lieutenant General', 'bg2'),
('general', 12500, 14999, 'General', 'bg2'),
('commander-general', 15000, 17499, 'Commander General', 'bg2'),
('field-vice-marshal', 17500, 19999, 'Field Vice Marshal', 'bg2'),
('field-marshal', 20000, 22499, 'Field Marshal', 'bg2'),
('vice-commander-of-the-army', 22500, 24999, 'Vice Commander of the Army', 'bg2'),
('commander-of-the-army', 25000, 27499, 'Commander of the Army', 'bg2'),
('high-commander', 27500, 29999, 'High Commander', 'bg2'),
('supreme-commander', 30000, 34999, 'Supreme Commander', 'bg2'),
('terminator', 35000, 9999999, 'Terminator', 'bg2'),
('recruit', 0, 49, 'Recruit', 'sgtls'),
('private', 50, 99, 'Private', 'sgtls'),
('private-first-class', 100, 199, 'Private First Class', 'sgtls'),
('lance-corporal', 200, 299, 'Lance Corporal', 'sgtls'),
('corporal', 300, 399, 'Corporal', 'sgtls'),
('sergeant', 400, 499, 'Sergeant', 'sgtls'),
('staff-sergeant', 500, 599, 'Staff Sergeant', 'sgtls'),
('gunnery-sergeant', 600, 699, 'Gunnery Sergeant', 'sgtls'),
('master-sergeant', 700, 799, 'Master Sergeant', 'sgtls'),
('first-sergeant', 800, 899, 'First Sergeant', 'sgtls'),
('master-chief', 900, 999, 'Master Chief', 'sgtls'),
('sergeant-major', 1000, 1199, 'Sergeant Major', 'sgtls'),
('ensign', 1200, 1399, 'Ensign', 'sgtls'),
('third-lieutenant', 1400, 1599, 'Third Lieutenant', 'sgtls'),
('second-lieutenant', 1600, 1799, 'Second Lieutenant', 'sgtls'),
('first-lieutenant', 1800, 1999, 'First Lieutenant', 'sgtls'),
('captain', 2000, 2249, 'Captain', 'sgtls'),
('group-captain', 2250, 2499, 'Group Captain', 'sgtls'),
('senior-captain', 2500, 2749, 'Senior Captain', 'sgtls'),
('lieutenant-major', 2750, 2999, 'Lieutenant Major', 'sgtls'),
('major', 3000, 3499, 'Major', 'sgtls'),
('group-major', 3500, 3999, 'Group Major', 'sgtls'),
('lieutenant-commander', 4000, 4499, 'Lieutenant Commander', 'sgtls'),
('commander', 4500, 4999, 'Commander', 'sgtls'),
('group-commander', 5000, 5749, 'Group Commander', 'sgtls'),
('lieutenant-colonel', 5750, 6499, 'Lieutenant Colonel', 'sgtls'),
('colonel', 6500, 7249, 'Colonel', 'sgtls'),
('brigadier', 7250, 7999, 'Brigadier', 'sgtls'),
('brigadier-general', 8000, 8999, 'Brigadier General', 'sgtls'),
('major-general', 9000, 9999, 'Major General', 'sgtls'),
('lieutenant-general', 10000, 12499, 'Lieutenant General', 'sgtls'),
('general', 12500, 14999, 'General', 'sgtls'),
('commander-general', 15000, 17499, 'Commander General', 'sgtls'),
('field-vice-marshal', 17500, 19999, 'Field Vice Marshal', 'sgtls'),
('field-marshal', 20000, 22499, 'Field Marshal', 'sgtls'),
('vice-commander-of-the-army', 22500, 24999, 'Vice Commander of the Army', 'sgtls'),
('commander-of-the-army', 25000, 27499, 'Commander of the Army', 'sgtls'),
('high-commander', 27500, 29999, 'High Commander', 'sgtls'),
('supreme-commander', 30000, 34999, 'Supreme Commander', 'sgtls'),
('terminator', 35000, 9999999, 'Terminator', 'sgtls'),
('recruit', 0, 49, 'Recruit', 'dystopia'),
('private', 50, 99, 'Private', 'dystopia'),
('private-first-class', 100, 199, 'Private First Class', 'dystopia'),
('lance-corporal', 200, 299, 'Lance Corporal', 'dystopia'),
('corporal', 300, 399, 'Corporal', 'dystopia'),
('sergeant', 400, 499, 'Sergeant', 'dystopia'),
('staff-sergeant', 500, 599, 'Staff Sergeant', 'dystopia'),
('gunnery-sergeant', 600, 699, 'Gunnery Sergeant', 'dystopia'),
('master-sergeant', 700, 799, 'Master Sergeant', 'dystopia'),
('first-sergeant', 800, 899, 'First Sergeant', 'dystopia'),
('master-chief', 900, 999, 'Master Chief', 'dystopia'),
('sergeant-major', 1000, 1199, 'Sergeant Major', 'dystopia'),
('ensign', 1200, 1399, 'Ensign', 'dystopia'),
('third-lieutenant', 1400, 1599, 'Third Lieutenant', 'dystopia'),
('second-lieutenant', 1600, 1799, 'Second Lieutenant', 'dystopia'),
('first-lieutenant', 1800, 1999, 'First Lieutenant', 'dystopia'),
('captain', 2000, 2249, 'Captain', 'dystopia'),
('group-captain', 2250, 2499, 'Group Captain', 'dystopia'),
('senior-captain', 2500, 2749, 'Senior Captain', 'dystopia'),
('lieutenant-major', 2750, 2999, 'Lieutenant Major', 'dystopia'),
('major', 3000, 3499, 'Major', 'dystopia'),
('group-major', 3500, 3999, 'Group Major', 'dystopia'),
('lieutenant-commander', 4000, 4499, 'Lieutenant Commander', 'dystopia'),
('commander', 4500, 4999, 'Commander', 'dystopia'),
('group-commander', 5000, 5749, 'Group Commander', 'dystopia'),
('lieutenant-colonel', 5750, 6499, 'Lieutenant Colonel', 'dystopia'),
('colonel', 6500, 7249, 'Colonel', 'dystopia'),
('brigadier', 7250, 7999, 'Brigadier', 'dystopia'),
('brigadier-general', 8000, 8999, 'Brigadier General', 'dystopia'),
('major-general', 9000, 9999, 'Major General', 'dystopia'),
('lieutenant-general', 10000, 12499, 'Lieutenant General', 'dystopia'),
('general', 12500, 14999, 'General', 'dystopia'),
('commander-general', 15000, 17499, 'Commander General', 'dystopia'),
('field-vice-marshal', 17500, 19999, 'Field Vice Marshal', 'dystopia'),
('field-marshal', 20000, 22499, 'Field Marshal', 'dystopia'),
('vice-commander-of-the-army', 22500, 24999, 'Vice Commander of the Army', 'dystopia'),
('commander-of-the-army', 25000, 27499, 'Commander of the Army', 'dystopia'),
('high-commander', 27500, 29999, 'High Commander', 'dystopia'),
('supreme-commander', 30000, 34999, 'Supreme Commander', 'dystopia'),
('terminator', 35000, 9999999, 'Terminator', 'dystopia');

INSERT IGNORE INTO `hlstats_Roles` (`game`, `code`, `name`, `hidden`) VALUES
('dystopia','1','Light','0'),
('dystopia','2','Medium','0'),
('dystopia','3','Heavy','0');

UPDATE `hlstats_Servers_Config` SET `value` = 0 WHERE `parameter` = 'DisplayResultsInBrowser' AND `serverId` IN (SELECT `serverId` FROM `hlstats_Servers` WHERE `game` IN (SELECT `code` FROM `hlstats_Games` WHERE `realgame` IN ('ges','insmod')));

INSERT IGNORE INTO `hlstats_Teams` (`game`, `code`, `name`, `hidden`, `playerlist_bgcolor`, `playerlist_color`, `playerlist_index`) VALUES
('bg2','British','The British','','#FFD5D5','#FF2D2D',2),
('bg2','Americans','The Americans','','#D2E8F7','#0080C0',1),
('sgtls','Goa\'uld','Goa\'uld','','#FFD5D5','#FF2D2D',2),
('sgtls','Tau\'ri','Tau\'ri','','#D2E8F7','#0080C0',1),
('dystopia','Punks','Punks','','#FFD5D5','#FF2D2D',2),
('dystopia','Corps','Corps','','#D2E8F7','#0080C0',1);

INSERT IGNORE INTO `hlstats_Weapons` (`game`, `code`, `name`, `modifier`) VALUES
('fof', 'shotgun', 'Winchester Shotgun', 1),
('bg2', 'brownbess', 'Brown Bess', 1),
('bg2', 'brownbess_bayonet', 'Brown Bess - Bayonet', 1),
('bg2', 'charleville', 'Charleville', 1),
('bg2', 'charleville_bayonet', 'Charleville - Bayonet', 1),
('bg2', 'hirschf', 'Hirschfaenger', 1),
('bg2', 'jaeger', 'Jaeger Rifle', 1),
('bg2', 'knife', 'Knife', 2),
('bg2', 'pennsylvania', 'Pennsylvania', 1),
('bg2', 'pistol_a', 'British Pistol', 1.5),
('bg2', 'pistol_b', 'American Pistol', 1.5),
('bg2', 'sabre_a', 'British Sabre', 1),
('bg2', 'sabre_b', 'American Sabre', 1),
('sgtls', 'p90', 'FN Herstal P-90 Red Dot / FN-H P-90RD', 1),
('sgtls', 'pistol', 'Beretta M92F-s', 1),
('sgtls', 'knife', 'Combat Knife', 1),
('sgtls', 'staff_blast', 'Staff Weapon', 1),
('sgtls', 'p90D', 'FN Herstal P-90 w/ Disruptor', 1),
('sgtls', 'hdevice', 'Hand Device / Ribbon Device', 1),
('sgtls', 'tac_pulse', 'Tac (turrent)', 1),
('sgtls', 'tac_projectile', 'Tac (bomb)', 1),
('sgtls', 'c4_charge', 'C4', 1),
('sgtls', 'grenade_projectile', 'M67 Frag Grenade', 1),
('sgtls', 'g36', 'H&K G-36', 1),
('sgtls', 'kull_blast', 'Kull Warrior Staff Device', 1),
('sgtls', 'suicide_bomb', 'Goa\'uld Suicide Bomb', 1),
('sgtls', 'kullblaster', 'Kull Warrior Staff Device (blast)', 1),
('sgtls', 'staff', 'Staff Weapon Melee', 1),
('sgtls', 'zat_blast', 'Zat', 1),
('sgtls', 'awp', 'AWP Rifle', 1),
('sgtls', 'grenade', 'M67 Frag Grenade', 1),
('sgtls', 'zat', 'Zat (splash)', 1),
('sgtls', 'tac', 'Tac (splash)', 1),
('dystopia', 'Light Katana', 'Light Katana', 1),
('dystopia', 'Medium Katana', 'Medium Katana', 1),
('dystopia', 'Fatman Fist', 'Fatman Fist', 1),
('dystopia', 'Machine Pistol', 'Machine Pistol', 1),
('dystopia', 'Shotgun', 'Shotgun', 1),
('dystopia', 'Laser Rifle', 'Laser Rifle', 1),
('dystopia', 'BoltGun', 'Bolt Gun', 1),
('dystopia', 'SmartLock Pistols', 'Smartlock Pistols', 1),
('dystopia', 'Assault Rifle', 'Assault Rifle', 1),
('dystopia', 'Grenade Launcher', 'Grenade Launcher', 1),
('dystopia', 'MK-808 Rifle', 'MK-808 Rifle', 1),
('dystopia', 'Tesla Rifle', 'Tesla Rifle', 1),
('dystopia', 'Rocket Launcher', 'Rocket Launcher', 1),
('dystopia', 'Minigun', 'Minigun', 1),
('dystopia', 'Ion Cannon', 'Ion Cannon', 1),
('dystopia', 'Basilisk', 'Basilisk', 1),
('dystopia', 'Frag Grenade', 'Frag Grenade', 1),
('dystopia', 'EMP Grenade', 'EMP Grenade', 1),
('dystopia', 'Spider Grenade', 'Spider Grenade', 1),
('dystopia', 'Cortex Bomb', 'Cortex Bomb', 1),
('dystopia', 'Leg Boosters', 'Leg Boosters', 1),
('dystopia', 'Trap', 'Trap', 1),
('dystopia', 'Turret', 'Turret', 1);