<?php

include ("../inc/config.php");
echo'<title>LB Install</title>
<link rel="stylesheet" type="text/css" href="../css/style.css">';
error_reporting(0);
$DBPrefix = DBPrefix;

$cSQL="CREATE TABLE IF NOT EXISTS {$DBPrefix}admin (
  `language` varchar(10) NOT NULL,
  `clanname` varchar(50) NOT NULL,
  `vip` varchar(30) NOT NULL,
  `kills` int(1) NOT NULL,
  `deaths` int(1) NOT NULL,
  `time` int(1) NOT NULL,
  `round` int(1) NOT NULL,
  `dogtags` int(1) NOT NULL,
  `kd` int(1) NOT NULL,
  `points` int(1) NOT NULL,
  `rank` int(1) NOT NULL,
  `progress` int(1) NOT NULL,
  `banner` varchar(100) NOT NULL,
  `error_report` int(1) NOT NULL,
  `vip_color` varchar(10) NOT NULL,
  `platform` varchar(10) NOT NULL,
  `max_players` int(2) NOT NULL,
  `LBUpdateTime` varchar(60) NOT NULL,
  `LBUpdateDate` varchar(60) NOT NULL,
  `stylesettings` varchar(10) NOT NULL,
  `general_box` int(1) NOT NULL,
  `team` int(1) NOT NULL,
  `progress_box` int(1) NOT NULL,
  `ribbons_box` int(1) NOT NULL,
  `medals_box` int(1) NOT NULL,
  `coop_box` int(1) NOT NULL,
  `score_box` int(1) NOT NULL,
  `weapons_box` int(1) NOT NULL,
  `gamemodus_box` int(1) NOT NULL,
  `vehicle_box` int(1) NOT NULL,
  `weapon_box` int(1) NOT NULL,
  `specializations` int(1) NOT NULL,
  `HistoryInsert` int(1) NOT NULL,
  `History` int(1) NOT NULL,
  `box_equipment` int(1) NOT NULL,
  `ident` varchar(500) NOT NULL,
  `secretkey` varchar(500) NOT NULL,
  `autoupdateEnabled` int(1) NOT NULL,
  `inaktivTime` int(11) NOT NULL,
  `stars_box` int(1) NOT NULL,
  `sigID` varchar(60) NOT NULL,
  `unlocks_box` int(1) NOT NULL,
  `clanhompage` VARCHAR( 500 ) NOT NULL,
  `serviceStars` INT( 1 ) NOT NULL,
  `assignments` INT( 1 ) NOT NULL,
  `defaultSort` VARCHAR( 255 ) NOT NULL DEFAULT 'points',
  `dogtag_stats` INT( 1 ) NOT NULL,
  `clantag` VARCHAR( 255 ) NOT NULL,
  `playerOnline` INT( 11 ) NOT NULL,
  `battlereports` INT( 1 ) NOT NULL,
  `playerOnlineView` INT( 1 ) NOT NULL,
  `OnlinePlayers` VARCHAR( 255 ) NOT NULL,
  `max_Reports` INT( 11 ) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;";

if(mysql_query($cSQL)){
$admin = 'Table created Admins<img src="../img/tick.png" border="0" /><br>';
}else{
$admin = 'Table not created '.mysql_error().'<img src="../img/cross.png" border="0" /><br>';
}


$cSQL ="INSERT INTO {$DBPrefix}admin (`language`, `clanname`, `vip`, `kills`, `deaths`, `time`, `round`, `dogtags`, `kd`, `points`, `rank`, `progress`, `banner`, `error_report`, `vip_color`, `platform`, `max_players`, `LBUpdateTime`, `LBUpdateDate`, `stylesettings`, `general_box`, `team`, `progress_box`, `ribbons_box`, `medals_box`, `coop_box`, `score_box`, `weapons_box`, `gamemodus_box`) VALUES
('german', 'eGamers of Tomorrow', 'Trial Member', 1, 1, 1, 1, 1, 1, 1, 1, 1, 'http://eot-clan.net/bf3leaderboard', 1, '#E07C02', 'pc', 30, '18:44:34', '03.11.2011', 'acp', 1, 1, 1, 1, 1, 1, 1, 0, 1);";

if(mysql_query($cSQL)){
$admin_insert = 'Table Insert<img src="../img/tick.png" border="0" /><br>';
}else{
$admin_insert = 'Table not Insert '.mysql_error().'<img src="../img/cross.png" border="0" /><br>';
}

$cSQL="CREATE TABLE IF NOT EXISTS {$DBPrefix}coop (
  `stats_pid` int(11) NOT NULL,
  `coop_kills` int(11) NOT NULL,
  `coop_headshots` int(11) NOT NULL,
  `coop_mdrevives` int(11) NOT NULL,
  `coop_killassists` int(11) NOT NULL,
  `coop_vehicledestroyed` int(11) NOT NULL,
  `coop_avengerkills` int(11) NOT NULL,
  `coop_saviorkills` int(11) NOT NULL,
  `coop_score` int(11) NOT NULL,
  `coop_indscore` int(11) NOT NULL,
  `level1_easy_score` int(11) NOT NULL,
  `level1_medium_score` int(11) NOT NULL,
  `level1_hard_score` int(11) NOT NULL,
  `level1_easy_count` int(11) NOT NULL,
  `level1_medium_count` int(11) NOT NULL,
  `level1_hard_count` int(11) NOT NULL,
  `level1_easy_date` int(11) NOT NULL,
  `level1_medium_date` int(11) NOT NULL,
  `level1_hard_date` int(11) NOT NULL,
  `level3_easy_score` int(11) NOT NULL,
  `level3_medium_score` int(11) NOT NULL,
  `level3_hard_score` int(11) NOT NULL,
  `level3_easy_count` int(11) NOT NULL,
  `level3_medium_count` int(11) NOT NULL,
  `level3_hard_count` int(11) NOT NULL,
  `level3_easy_date` int(11) NOT NULL,
  `level3_medium_date` int(11) NOT NULL,
  `level3_hard_date` int(11) NOT NULL,
  `level6_easy_score` int(11) NOT NULL,
  `level6_medium_score` int(11) NOT NULL,
  `level6_hard_score` int(11) NOT NULL,
  `level6_easy_count` int(11) NOT NULL,
  `level6_medium_count` int(11) NOT NULL,
  `level6_hard_count` int(11) NOT NULL,
  `level6_easy_date` int(11) NOT NULL,
  `level6_medium_date` int(11) NOT NULL,
  `level6_hard_date` int(11) NOT NULL,
  `level7_easy_score` int(11) NOT NULL,
  `level7_medium_score` int(11) NOT NULL,
  `level7_hard_score` int(11) NOT NULL,
  `level7_easy_count` int(11) NOT NULL,
  `level7_medium_count` int(11) NOT NULL,
  `level7_hard_count` int(11) NOT NULL,
  `level7_easy_date` int(11) NOT NULL,
  `level7_medium_date` int(11) NOT NULL,
  `level7_hard_date` int(11) NOT NULL,
  `level9_easy_score` int(11) NOT NULL,
  `level9_medium_score` int(11) NOT NULL,
  `level9_hard_score` int(11) NOT NULL,
  `level9_easy_count` int(11) NOT NULL,
  `level9_medium_count` int(11) NOT NULL,
  `level9_hard_count` int(11) NOT NULL,
  `level9_easy_date` int(11) NOT NULL,
  `level9_medium_date` int(11) NOT NULL,
  `level9_hard_date` int(11) NOT NULL,
  `level10_easy_score` int(11) NOT NULL,
  `level10_medium_score` int(11) NOT NULL,
  `level10_hard_score` int(11) NOT NULL,
  `level10_easy_count` int(11) NOT NULL,
  `level10_medium_count` int(11) NOT NULL,
  `level10_hard_count` int(11) NOT NULL,
  `level10_easy_date` int(11) NOT NULL,
  `level10_medium_date` int(11) NOT NULL,
  `level10_hard_date` int(11) NOT NULL,
  PRIMARY KEY (`stats_pid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;";

if(mysql_query($cSQL)){
$coop = 'Table created COOP<img src="../img/tick.png" border="0" /><br>';
}else{
$coop = 'Table not created '.mysql_error().'<img src="../img/cross.png" border="0" /><br>';
}

$cSQL="CREATE TABLE IF NOT EXISTS {$DBPrefix}gamemodes (
  `stats_pid` int(11) NOT NULL,
  `losses_cq` int(11) NOT NULL,
  `wins_cq` int(11) NOT NULL,
  `losses_rush` int(11) NOT NULL,
  `wins_rush` int(11) NOT NULL,
  `losses_sqr` int(11) NOT NULL,
  `wins_sqr` int(11) NOT NULL,
  `losses_teamdm` int(11) NOT NULL,
  `wins_teamdm` int(11) NOT NULL,
  `losses_squaddm` int(11) NOT NULL,
  `wins_squaddm` int(11) NOT NULL,
  PRIMARY KEY (`stats_pid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;";

if(mysql_query($cSQL)){
$game = 'Table created Gamemodes<img src="../img/tick.png" border="0" /><br>';
}else{
$game = 'Table not created '.mysql_error().'<img src="../img/cross.png" border="0" /><br>';
}

$cSQL="CREATE TABLE IF NOT EXISTS {$DBPrefix}generalStats (
  `pid` int(11) NOT NULL AUTO_INCREMENT,
  `rank` int(11) NOT NULL,
  `soldiername` varchar(60) NOT NULL,
  `points` int(11) NOT NULL,
  `kills` int(11) NOT NULL,
  `deaths` int(11) NOT NULL,
  `playtime` int(11) NOT NULL,
  `rounds` int(11) NOT NULL,
  `dogtags` int(11) NOT NULL,
  `last_update` int(11) NOT NULL,
  `vip_member` int(1) NOT NULL,
  `team` int(11) NOT NULL,
  `longesths` float NOT NULL,
  `headshots` int(11) NOT NULL,
  `language` varchar(20) NOT NULL,
  `country_name` varchar(20) NOT NULL,
  `objective` int(11) NOT NULL,
  `general` int(11) NOT NULL,
  `squad` int(11) NOT NULL,
  `aunlock` int(11) NOT NULL,
  `vehicleaa` int(11) NOT NULL,
  `vehicleah` int(11) NOT NULL,
  `vehicleall` int(11) NOT NULL,
  `vehicleifv` int(11) NOT NULL,
  `vehiclejet` int(11) NOT NULL,
  `vehiclembt` int(11) NOT NULL,
  `vehiclesh` int(11) NOT NULL,
  `wins` int(11) NOT NULL,
  `losses` int(11) NOT NULL,
  `shots` int(11) NOT NULL,
  `hits` int(11) NOT NULL,
  `vehicledestroyassist` int(11) NOT NULL,
  `vehicledestroyed` int(11) NOT NULL,
  `revives` int(11) NOT NULL,
  `killassists` int(11) NOT NULL,
  `resupplies` int(11) NOT NULL,
  `heals` int(11) NOT NULL,
  `repairs` int(11) NOT NULL,
  `elo` int(11) NOT NULL,
  `elo_games` int(11) NOT NULL,
  `killstreakbonus` int(11) NOT NULL,
  `avengerkills` int(11) NOT NULL,
  `saviorkills` int(11) NOT NULL,
  `assault` int(11) NOT NULL,
  `recon` int(11) NOT NULL,
  `support` int(11) NOT NULL,
  `engineer` int(11) NOT NULL,
  `nextrank` int(11) NOT NULL,
  `rankscore` int(11) NOT NULL,
  `award` int(11) NOT NULL,
  `bonus` int(11) NOT NULL,
  `damagaassists` int(11) NOT NULL,
  `date_insert_bf3s` int(11) NOT NULL,
  `date_check_bf3s` int(11) NOT NULL,
  `date_update_bf3s` int(11) NOT NULL,
  `HistoryUpdate` int(11) NOT NULL,
  `battlelogurl` varchar(255) NOT NULL,
  `bf3statsurl` varchar(255) NOT NULL,
  `playerupdate` int(11) NOT NULL,
  `invisible` varchar(20) NOT NULL,
  `serviceStar_a` INT NOT NULL ,
  `serviceStar_s` INT NOT NULL ,
  `serviceStar_e` INT NOT NULL ,
  `serviceStar_r` INT NOT NULL ,
  `suppression` INT NOT NULL ,
  `nemesisstreak` INT NOT NULL ,
  `nemesiskills` INT NOT NULL ,
  `mcomdest` INT NOT NULL ,
  `mcomdefkills` INT NOT NULL ,
  `flagcaps` INT NOT NULL ,
  `flagdef` INT NOT NULL ,
  `longesthandhs` INT NOT NULL,
  `status` INT (1) NOT NULL ,
  `vehicleahStar` INT NOT NULL,
  `vehicleshStar` INT NOT NULL,
  `vehiclejetStar` INT NOT NULL,
  `vehiclembtStar` INT NOT NULL,
  `vehicleaaStar` INT NOT NULL,
  `vehicleifvStar` INT NOT NULL,
  `dogtagsStats` longtext NOT NULL,
  `is_online`  INT (1) NOT NULL,
  `lastServerID` varchar(255) NOT NULL,
  `lastServerName` varchar(255) NOT NULL,
  `lastServer_uTime`  INT (15) NOT NULL ,
  `gravatarMD5` varchar(255) NOT NULL,
  `lastBattlereport`  INT (15) NOT NULL ,
  `battlelogID`  INT (11) NOT NULL ,
  `lastPlayingTime`  INT (15) NOT NULL ,
  `veteran` varchar(255) NOT NULL,
  `Pplatform`  INT (1) NOT NULL ,
  `persona` varchar(255) NOT NULL,
  `expansion` VARCHAR( 255 ) NOT NULL,
   PRIMARY KEY (`pid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;";

if(mysql_query($cSQL)){
$Stats = 'Table created GeneralStats<img src="../img/tick.png" border="0" /><br>';
}else{
$Stats = 'Table not created '.mysql_error().'<img src="../img/cross.png" border="0" /><br>';
}


$cSQL="CREATE TABLE IF NOT EXISTS {$DBPrefix}login (
  `id` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(150) NOT NULL,
  `passwort` varchar(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;";

if(mysql_query($cSQL)){
$login = 'Table created Login<img src="../img/tick.png" border="0" /><br>';
}else{
$login = 'Table not created '.mysql_error().'<img src="../img/cross.png" border="0" /><br>';
}


$cSQL="INSERT INTO {$DBPrefix}login (`id`, `username`, `passwort`) VALUES
(1, 'admin', '21232f297a57a5a743894a0e4a801fc3');";

if(mysql_query($cSQL)){
$insertA = 'Admin Insert<img src="../img/tick.png" border="0" /><br>';
}else{
$insertA = 'Table not created '.mysql_error().'<img src="../img/cross.png" border="0" /><br>';
}


$cSQL="CREATE TABLE IF NOT EXISTS {$DBPrefix}medals (
  `stats_pid` int(11) NOT NULL,
  `m1_count` int(11) NOT NULL,
  `m1_date` int(11) NOT NULL,
  `m1_curr` int(11) NOT NULL,
  `m1_needed` int(11) NOT NULL,
  `m2_count` int(11) NOT NULL,
  `m2_date` int(11) NOT NULL,
  `m2_curr` int(11) NOT NULL,
  `m2_needed` int(11) NOT NULL,
  `m3_count` int(11) NOT NULL,
  `m3_date` int(11) NOT NULL,
  `m3_curr` int(11) NOT NULL,
  `m3_needed` int(11) NOT NULL,
  `m4_count` int(11) NOT NULL,
  `m4_date` int(11) NOT NULL,
  `m4_curr` int(11) NOT NULL,
  `m4_needed` int(11) NOT NULL,
  `m5_count` int(11) NOT NULL,
  `m5_date` int(11) NOT NULL,
  `m5_curr` int(11) NOT NULL,
  `m5_needed` int(11) NOT NULL,
  `m6_count` int(11) NOT NULL,
  `m6_date` int(11) NOT NULL,
  `m6_curr` int(11) NOT NULL,
  `m6_needed` int(11) NOT NULL,
  `m7_count` int(11) NOT NULL,
  `m7_date` int(11) NOT NULL,
  `m7_curr` int(11) NOT NULL,
  `m7_needed` int(11) NOT NULL,
  `m8_count` int(11) NOT NULL,
  `m8_date` int(11) NOT NULL,
  `m8_curr` int(11) NOT NULL,
  `m8_needed` int(11) NOT NULL,
  `m9_count` int(11) NOT NULL,
  `m9_date` int(11) NOT NULL,
  `m9_curr` int(11) NOT NULL,
  `m9_needed` int(11) NOT NULL,
  `m10_count` int(11) NOT NULL,
  `m10_date` int(11) NOT NULL,
  `m10_curr` int(11) NOT NULL,
  `m10_needed` int(11) NOT NULL,
  `m11_count` int(11) NOT NULL,
  `m11_date` int(11) NOT NULL,
  `m11_curr` int(11) NOT NULL,
  `m11_needed` int(11) NOT NULL,
  `m12_count` int(11) NOT NULL,
  `m12_date` int(11) NOT NULL,
  `m12_curr` int(11) NOT NULL,
  `m12_needed` int(11) NOT NULL,
  `m13_count` int(11) NOT NULL,
  `m13_date` int(11) NOT NULL,
  `m13_curr` int(11) NOT NULL,
  `m13_needed` int(11) NOT NULL,
  `m14_count` int(11) NOT NULL,
  `m14_date` int(11) NOT NULL,
  `m14_curr` int(11) NOT NULL,
  `m14_needed` int(11) NOT NULL,
  `m15_count` int(11) NOT NULL,
  `m15_date` int(11) NOT NULL,
  `m15_curr` int(11) NOT NULL,
  `m15_needed` int(11) NOT NULL,
  `m16_count` int(11) NOT NULL,
  `m16_date` int(11) NOT NULL,
  `m16_curr` int(11) NOT NULL,
  `m16_needed` int(11) NOT NULL,
  `m17_count` int(11) NOT NULL,
  `m17_date` int(11) NOT NULL,
  `m17_curr` int(11) NOT NULL,
  `m17_needed` int(11) NOT NULL,
  `m18_count` int(11) NOT NULL,
  `m18_date` int(11) NOT NULL,
  `m18_curr` int(11) NOT NULL,
  `m18_needed` int(11) NOT NULL,
  `m19_count` int(11) NOT NULL,
  `m19_date` int(11) NOT NULL,
  `m19_curr` int(11) NOT NULL,
  `m19_needed` int(11) NOT NULL,
  `m20_count` int(11) NOT NULL,
  `m20_date` int(11) NOT NULL,
  `m20_curr` int(11) NOT NULL,
  `m20_needed` int(11) NOT NULL,
  `m21_count` int(11) NOT NULL,
  `m21_date` int(11) NOT NULL,
  `m21_curr` int(11) NOT NULL,
  `m21_needed` int(11) NOT NULL,
  `m22_count` int(11) NOT NULL,
  `m22_date` int(11) NOT NULL,
  `m22_curr` int(11) NOT NULL,
  `m22_needed` int(11) NOT NULL,
  `m23_count` int(11) NOT NULL,
  `m23_date` int(11) NOT NULL,
  `m23_curr` int(11) NOT NULL,
  `m23_needed` int(11) NOT NULL,
  `m24_count` int(11) NOT NULL,
  `m24_date` int(11) NOT NULL,
  `m24_curr` int(11) NOT NULL,
  `m24_needed` int(11) NOT NULL,
  `m25_count` int(11) NOT NULL,
  `m25_date` int(11) NOT NULL,
  `m25_curr` int(11) NOT NULL,
  `m25_needed` int(11) NOT NULL,
  `m26_count` int(11) NOT NULL,
  `m26_date` int(11) NOT NULL,
  `m26_curr` int(11) NOT NULL,
  `m26_needed` int(11) NOT NULL,
  `m27_count` int(11) NOT NULL,
  `m27_date` int(11) NOT NULL,
  `m27_curr` int(11) NOT NULL,
  `m27_needed` int(11) NOT NULL,
  `m28_count` int(11) NOT NULL,
  `m28_date` int(11) NOT NULL,
  `m28_curr` int(11) NOT NULL,
  `m28_needed` int(11) NOT NULL,
  `m29_count` int(11) NOT NULL,
  `m29_date` int(11) NOT NULL,
  `m29_curr` int(11) NOT NULL,
  `m29_needed` int(11) NOT NULL,
  `m30_count` int(11) NOT NULL,
  `m30_date` int(11) NOT NULL,
  `m30_curr` int(11) NOT NULL,
  `m30_needed` int(11) NOT NULL,
  `m31_count` int(11) NOT NULL,
  `m31_date` int(11) NOT NULL,
  `m31_curr` int(11) NOT NULL,
  `m31_needed` int(11) NOT NULL,
  `m32_count` int(11) NOT NULL,
  `m32_date` int(11) NOT NULL,
  `m32_curr` int(11) NOT NULL,
  `m32_needed` int(11) NOT NULL,
  `m33_count` int(11) NOT NULL,
  `m33_date` int(11) NOT NULL,
  `m33_curr` int(11) NOT NULL,
  `m33_needed` int(11) NOT NULL,
  `m34_count` int(11) NOT NULL,
  `m34_date` int(11) NOT NULL,
  `m34_curr` int(11) NOT NULL,
  `m34_needed` int(11) NOT NULL,
  `m35_count` int(11) NOT NULL,
  `m35_date` int(11) NOT NULL,
  `m35_curr` int(11) NOT NULL,
  `m35_needed` int(11) NOT NULL,
  `m36_count` int(11) NOT NULL,
  `m36_date` int(11) NOT NULL,
  `m36_curr` int(11) NOT NULL,
  `m36_needed` int(11) NOT NULL,
  `m37_count` int(11) NOT NULL,
  `m37_date` int(11) NOT NULL,
  `m37_curr` int(11) NOT NULL,
  `m37_needed` int(11) NOT NULL,
  `m38_count` int(11) NOT NULL,
  `m38_date` int(11) NOT NULL,
  `m38_curr` int(11) NOT NULL,
  `m38_needed` int(11) NOT NULL,
  `m39_count` int(11) NOT NULL,
  `m39_date` int(11) NOT NULL,
  `m39_curr` int(11) NOT NULL,
  `m39_needed` int(11) NOT NULL,
  `m40_count` int(11) NOT NULL,
  `m40_date` int(11) NOT NULL,
  `m40_curr` int(11) NOT NULL,
  `m40_needed` int(11) NOT NULL,
  `m41_count` int(11) NOT NULL,
  `m41_date` int(11) NOT NULL,
  `m41_curr` int(11) NOT NULL,
  `m41_needed` int(11) NOT NULL,
  `m42_count` int(11) NOT NULL,
  `m42_date` int(11) NOT NULL,
  `m42_curr` int(11) NOT NULL,
  `m42_needed` int(11) NOT NULL,
  `m43_count` int(11) NOT NULL,
  `m43_date` int(11) NOT NULL,
  `m43_curr` int(11) NOT NULL,
  `m43_needed` int(11) NOT NULL,
  `m44_count` int(11) NOT NULL,
  `m44_date` int(11) NOT NULL,
  `m44_curr` int(11) NOT NULL,
  `m44_needed` int(11) NOT NULL,
  `m45_count` int(11) NOT NULL,
  `m45_date` int(11) NOT NULL,
  `m45_curr` int(11) NOT NULL,
  `m45_needed` int(11) NOT NULL,
  `m46_needed` int(11) NOT NULL,
  `m46_count` int(11) NOT NULL,
  `m46_date` int(11) NOT NULL,
  `m46_curr` int(11) NOT NULL,
  `m47_needed` int(11) NOT NULL,
  `m47_count` int(11) NOT NULL,
  `m47_date` int(11) NOT NULL,
  `m47_curr` int(11) NOT NULL,
  `m48_needed` int(11) NOT NULL,
  `m48_count` int(11) NOT NULL,
  `m48_date` int(11) NOT NULL,
  `m48_curr` int(11) NOT NULL,
  `m49_needed` int(11) NOT NULL,
  `m49_count` int(11) NOT NULL,
  `m49_date` int(11) NOT NULL,
  `m49_curr` int(11) NOT NULL,
  `m50_needed` int(11) NOT NULL,
  `m50_count` int(11) NOT NULL,
  `m50_date` int(11) NOT NULL,
  `m50_curr` int(11) NOT NULL,
  PRIMARY KEY (`stats_pid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;";

if(mysql_query($cSQL)){
$medals = 'Table created Medals<img src="../img/tick.png" border="0" /><br>';
}else{
$medals = 'Table not created '.mysql_error().'<img src="../img/cross.png" border="0" /><br>';
}

$cSQL="CREATE TABLE IF NOT EXISTS {$DBPrefix}ribbons (
 `stats_pid` int(11) NOT NULL,
  `r1_count` int(11) NOT NULL,
  `r1_date` int(11) NOT NULL,
  `r2_count` int(11) NOT NULL,
  `r2_date` int(11) NOT NULL,
  `r3_count` int(11) NOT NULL,
  `r3_date` int(11) NOT NULL,
  `r4_count` int(11) NOT NULL,
  `r4_date` int(11) NOT NULL,
  `r5_count` int(11) NOT NULL,
  `r5_date` int(11) NOT NULL,
  `r6_count` int(11) NOT NULL,
  `r6_date` int(11) NOT NULL,
  `r7_count` int(11) NOT NULL,
  `r7_date` int(11) NOT NULL,
  `r8_count` int(11) NOT NULL,
  `r8_date` int(11) NOT NULL,
  `r9_count` int(11) NOT NULL,
  `r9_date` int(11) NOT NULL,
  `r10_count` int(11) NOT NULL,
  `r10_date` int(11) NOT NULL,
  `r11_count` int(11) NOT NULL,
  `r11_date` int(11) NOT NULL,
  `r12_count` int(11) NOT NULL,
  `r12_date` int(11) NOT NULL,
  `r13_count` int(11) NOT NULL,
  `r13_date` int(11) NOT NULL,
  `r14_count` int(11) NOT NULL,
  `r14_date` int(11) NOT NULL,
  `r15_count` int(11) NOT NULL,
  `r15_date` int(11) NOT NULL,
  `r16_count` int(11) NOT NULL,
  `r16_date` int(11) NOT NULL,
  `r17_count` int(11) NOT NULL,
  `r17_date` int(11) NOT NULL,
  `r18_count` int(11) NOT NULL,
  `r18_date` int(11) NOT NULL,
  `r19_count` int(11) NOT NULL,
  `r19_date` int(11) NOT NULL,
  `r20_count` int(11) NOT NULL,
  `r20_date` int(11) NOT NULL,
  `r21_count` int(11) NOT NULL,
  `r21_date` int(11) NOT NULL,
  `r22_count` int(11) NOT NULL,
  `r22_date` int(11) NOT NULL,
  `r23_count` int(11) NOT NULL,
  `r23_date` int(11) NOT NULL,
  `r24_count` int(11) NOT NULL,
  `r24_date` int(11) NOT NULL,
  `r25_count` int(11) NOT NULL,
  `r25_date` int(11) NOT NULL,
  `r26_count` int(11) NOT NULL,
  `r26_date` int(11) NOT NULL,
  `r27_count` int(11) NOT NULL,
  `r27_date` int(11) NOT NULL,
  `r28_count` int(11) NOT NULL,
  `r28_date` int(11) NOT NULL,
  `r29_count` int(11) NOT NULL,
  `r29_date` int(11) NOT NULL,
  `r30_count` int(11) NOT NULL,
  `r30_date` int(11) NOT NULL,
  `r31_count` int(11) NOT NULL,
  `r31_date` int(11) NOT NULL,
  `r32_count` int(11) NOT NULL,
  `r32_date` int(11) NOT NULL,
  `r33_count` int(11) NOT NULL,
  `r33_date` int(11) NOT NULL,
  `r34_count` int(11) NOT NULL,
  `r34_date` int(11) NOT NULL,
  `r35_count` int(11) NOT NULL,
  `r35_date` int(11) NOT NULL,
  `r36_count` int(11) NOT NULL,
  `r36_date` int(11) NOT NULL,
  `r37_count` int(11) NOT NULL,
  `r37_date` int(11) NOT NULL,
  `r38_count` int(11) NOT NULL,
  `r38_date` int(11) NOT NULL,
  `r39_count` int(11) NOT NULL,
  `r39_date` int(11) NOT NULL,
  `r40_count` int(11) NOT NULL,
  `r40_date` int(11) NOT NULL,
  `r41_count` int(11) NOT NULL,
  `r41_date` int(11) NOT NULL,
  `r42_count` int(11) NOT NULL,
  `r42_date` int(11) NOT NULL,
  `r43_count` int(11) NOT NULL,
  `r43_date` int(11) NOT NULL,
  `r44_count` int(11) NOT NULL,
  `r44_date` int(11) NOT NULL,
  `r45_count` int(11) NOT NULL,
  `r45_date` int(11) NOT NULL,
  PRIMARY KEY (`stats_pid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;";

if(mysql_query($cSQL)){
$ribbons = 'Table created Ribbons<img src="../img/tick.png" border="0" /><br>';
}else{
$ribbons = 'Table not created '.mysql_error().'<img src="../img/cross.png" border="0" /><br>';
}



$cSQL="CREATE TABLE IF NOT EXISTS {$DBPrefix}style (
 `background_image` varchar(20) NOT NULL,
  `body_font_color` varchar(10) NOT NULL,
  `background_color` varchar(10) NOT NULL,
  `font_size` varchar(10) NOT NULL,
  `link_color` varchar(10) NOT NULL,
  `link_color_hover` varchar(10) NOT NULL,
  `bod_div_background` varchar(20) NOT NULL,
  `border_div` varchar(10) NOT NULL,
  `shadow_color` varchar(10) NOT NULL,
  `table_default_font_size` varchar(10) NOT NULL,
  `table_border_color` varchar(10) NOT NULL,
  `td_head_background` varchar(20) NOT NULL,
  `font_size_td` varchar(10) NOT NULL,
  `hover_back` varchar(10) NOT NULL,
  `kd_positiv` varchar(10) NOT NULL,
  `kd_negativ` varchar(10) NOT NULL,
  `progress_border` varchar(10) NOT NULL,
  `object` varchar(20) NOT NULL,
  `progress_size_background` varchar(10) NOT NULL,
  `html_tooltip_color` varchar(10) NOT NULL,
  `tabs_font` varchar(30) NOT NULL,
  `tabs_border` varchar(30) NOT NULL,
  `tabs_color` varchar(30) NOT NULL,
  `tabs_background` varchar(60) NOT NULL,
  `tabs_visited` varchar(30) NOT NULL,
  `tabs_hover` varchar(30) NOT NULL,
  `tabs_selected` varchar(60) NOT NULL,
  `td_font_style` varchar(20) NOT NULL,
  `td_font_weight` varchar(20) NOT NULL,
  `result_border` varchar(20) NOT NULL,
  `input_button_back` varchar(60) NOT NULL,
  `input_button_color` varchar(20) NOT NULL,
  `input_button_back_hover` varchar(60) NOT NULL,
  `input_button_color_hover` varchar(20) NOT NULL,
  `input_button_size` varchar(20) NOT NULL,
  `input_button_back_size_hover` varchar(20) NOT NULL,
  `tooltip_border` varchar(20) NOT NULL,
  `tooltip_size` varchar(20) NOT NULL,
  `IndexDivWidth` 	int(11) NOT NULL,			
	`IndexTableWidth` 	int(11) NOT NULL,		
	`IndexBanner` 	int(11) NOT NULL,	
	`IndexRankIcon` 	int(11) NOT NULL,		
	`IndexLineHeight` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;";

if(mysql_query($cSQL)){
$style = 'Table created Style<img src="../img/tick.png" border="0" /><br>';
}else{
$style = 'Table not created '.mysql_error().'<img src="../img/cross.png" border="0" /><br>';
}

$cSQL="INSERT INTO {$DBPrefix}style (`background_image`, `body_font_color`, `background_color`, `font_size`, `link_color`, `link_color_hover`, `bod_div_background`, `border_div`, `shadow_color`, `table_default_font_size`, `table_border_color`, `td_head_background`, `font_size_td`, `hover_back`, `kd_positiv`, `kd_negativ`, `progress_border`, `object`, `progress_size_background`, `html_tooltip_color`, `tabs_font`, `tabs_border`, `tabs_color`, `tabs_background`, `tabs_visited`, `tabs_hover`, `tabs_selected`, `td_font_style`, `td_font_weight`, `result_border`, `input_button_back`, `input_button_color`, `input_button_back_hover`, `input_button_color_hover`, `input_button_size`, `input_button_back_size_hover`, `tooltip_border`, `tooltip_size` , `IndexDivWidth`, `IndexTableWidth`, `IndexBanner`, `IndexRankIcon`, `IndexLineHeight`) VALUES
('../img/bf3_bg.jpg', '#FFF', '#0A0A0A', '12px', '#888888', '#F88613', '../img/body.png', '#E8E8E8', '#5C5B5B', '10px', '#303030', '../img/head.png', '10px', '#151515', '#00FF00', '#FF0000', '#555555', '../img/bg_object.jpg', '#008FC4', '#FFFFFF', 'bold 12px Verdana', '1px solid #303030', '#008FC4', '#FFF url(../img/ajaxtabs/shade.gif) top left repeat-x', '#008FC4', '#008FC4', 'url(../img/ajaxtabs/shadeactive.gif)', 'italic', 'bold', '1px solid #303030', 'url(../img/button.png)', '#FFF', 'url(../img/button_h.png)', '#E07C02', '100px', '100px', '4px solid #000', '250px', '830', '814', '800', '20', '25');";

if(mysql_query($cSQL)){
$styleinsert = 'Table Style insert<img src="../img/tick.png" border="0" /><br>';
}else{
$styleinsert = 'Table not created '.mysql_error().'<img src="../img/cross.png" border="0" /><br>';
}


$cSQL="CREATE TABLE IF NOT EXISTS {$DBPrefix}team (
  `stats_pid` int(11) NOT NULL,
  `time_us` int(11) NOT NULL,
  `assault_us` int(11) NOT NULL,
  `recon_us` int(11) NOT NULL,
  `support_us` int(11) NOT NULL,
  `engineer_us` int(11) NOT NULL,
  `time_ru` int(11) NOT NULL,
  `assault_ru` int(11) NOT NULL,
  `recon_ru` int(11) NOT NULL,
  `support_ru` int(11) NOT NULL,
  `engineer_ru` int(11) NOT NULL,
  PRIMARY KEY  (`stats_pid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;";

if(mysql_query($cSQL)){
$team = 'Table created Team<img src="../img/tick.png" border="0" /><br>';
}else{
$team = 'Table not created '.mysql_error().'<img src="../img/cross.png" border="0" /><br>';
}



$cSQL="CREATE TABLE IF NOT EXISTS {$DBPrefix}weapons (
  `stats_pid` int(11) NOT NULL,
  `arAEK_time` int(11) NOT NULL,
  `arAEK_kills` int(11) NOT NULL,
  `arAEK_shots` int(11) NOT NULL,
  `arAEK_hits` int(11) NOT NULL,
  `arAEK_headshots` int(11) NOT NULL,
  `arAK74_time` int(11) NOT NULL,
  `arAK74_kills` int(11) NOT NULL,
  `arAK74_headshots` int(11) NOT NULL,
  `arAK74_hits` int(11) NOT NULL,
  `arAK74_shots` int(11) NOT NULL,
  `arAN94_time` int(11) NOT NULL,
  `arAN94_kills` int(11) NOT NULL,
  `arAN94_headshots` int(11) NOT NULL,
  `arAN94_hits` int(11) NOT NULL,
  `arAN94_shots` int(11) NOT NULL,
  `arF2_time` int(11) NOT NULL,
  `arF2_kills` int(11) NOT NULL,
  `arF2_headshots` int(11) NOT NULL,
  `arF2_hits` int(11) NOT NULL,
  `arF2_shots` int(11) NOT NULL,
  `arG3_time` int(11) NOT NULL,
  `arG3_kills` int(11) NOT NULL,
  `arG3_headshots` int(11) NOT NULL,
  `arG3_hits` int(11) NOT NULL,
  `arG3_shots` int(11) NOT NULL,
  `arKH_time` int(11) NOT NULL,
  `arKH_kills` int(11) NOT NULL,
  `arKH_headshots` int(11) NOT NULL,
  `arKH_hits` int(11) NOT NULL,
  `arKH_shots` int(11) NOT NULL,
  `arM16_time` int(11) NOT NULL,
  `arM16_kills` int(11) NOT NULL,
  `arM16_headshots` int(11) NOT NULL,
  `arM16_hits` int(11) NOT NULL,
  `arM16_shots` int(11) NOT NULL,
  `arM416_time` int(11) NOT NULL,
  `arM416_kills` int(11) NOT NULL,
  `arM416_headshots` int(11) NOT NULL,
  `arM416_hits` int(11) NOT NULL,
  `arM416_shots` int(11) NOT NULL,
  `caA91_time` int(11) NOT NULL,
  `caA91_kills` int(11) NOT NULL,
  `caA91_headshots` int(11) NOT NULL,
  `caA91_hits` int(11) NOT NULL,
  `caA91_shots` int(11) NOT NULL,
  `caAKS_time` int(11) NOT NULL,
  `caAKS_kills` int(11) NOT NULL,
  `caAKS_headshots` int(11) NOT NULL,
  `caAKS_hits` int(11) NOT NULL,
  `caAKS_shots` int(11) NOT NULL,
  `caG36_time` int(11) NOT NULL,
  `caG36_kills` int(11) NOT NULL,
  `caG36_headshots` int(11) NOT NULL,
  `caG36_hits` int(11) NOT NULL,
  `caG36_shots` int(11) NOT NULL,
  `caM4_time` int(11) NOT NULL,
  `caM4_kills` int(11) NOT NULL,
  `caM4_headshots` int(11) NOT NULL,
  `caM4_hits` int(11) NOT NULL,
  `caM4_shots` int(11) NOT NULL,
  `caSCAR_time` int(11) NOT NULL,
  `caSCAR_kills` int(11) NOT NULL,
  `caSCAR_headshots` int(11) NOT NULL,
  `caSCAR_hits` int(11) NOT NULL,
  `caSCAR_shots` int(11) NOT NULL,
  `caSG553_time` int(11) NOT NULL,
  `caSG553_kills` int(11) NOT NULL,
  `caSG553_headshots` int(11) NOT NULL,
  `caSG553_hits` int(11) NOT NULL,
  `caSG553_shots` int(11) NOT NULL,
  `mgM240_time` int(11) NOT NULL,
  `mgM240_kills` int(11) NOT NULL,
  `mgM240_headshots` int(11) NOT NULL,
  `mgM240_hits` int(11) NOT NULL,
  `mgM240_shots` int(11) NOT NULL,
  `mgM249_time` int(11) NOT NULL,
  `mgM249_kills` int(11) NOT NULL,
  `mgM249_headshots` int(11) NOT NULL,
  `mgM249_hits` int(11) NOT NULL,
  `mgM249_shots` int(11) NOT NULL,
  `mgM27_time` int(11) NOT NULL,
  `mgM27_kills` int(11) NOT NULL,
  `mgM27_headshots` int(11) NOT NULL,
  `mgM27_hits` int(11) NOT NULL,
  `mgM27_shots` int(11) NOT NULL,
  `mgM60_time` int(11) NOT NULL,
  `mgM60_kills` int(11) NOT NULL,
  `mgM60_headshots` int(11) NOT NULL,
  `mgM60_hits` int(11) NOT NULL,
  `mgM60_shots` int(11) NOT NULL,
  `mgPech_time` int(11) NOT NULL,
  `mgPech_kills` int(11) NOT NULL,
  `mgPech_headshots` int(11) NOT NULL,
  `mgPech_hits` int(11) NOT NULL,
  `mgPech_shots` int(11) NOT NULL,
  `mgRPK_time` int(11) NOT NULL,
  `mgRPK_kills` int(11) NOT NULL,
  `mgRPK_headshots` int(11) NOT NULL,
  `mgRPK_hits` int(11) NOT NULL,
  `mgRPK_shots` int(11) NOT NULL,
  `mgT88_time` int(11) NOT NULL,
  `mgT88_kills` int(11) NOT NULL,
  `mgT88_headshots` int(11) NOT NULL,
  `mgT88_hits` int(11) NOT NULL,
  `mgT88_shots` int(11) NOT NULL,
  `pG17S_time` int(11) NOT NULL,
  `pG17S_kills` int(11) NOT NULL,
  `pG17S_headshots` int(11) NOT NULL,
  `pG17S_hits` int(11) NOT NULL,
  `pG17S_shots` int(11) NOT NULL,
  `pG17_time` int(11) NOT NULL,
  `pG17_kills` int(11) NOT NULL,
  `pG17_headshots` int(11) NOT NULL,
  `pG17_hits` int(11) NOT NULL,
  `pG17_shots` int(11) NOT NULL,
  `pg18S_time` int(11) NOT NULL,
  `pg18S_kills` int(11) NOT NULL,
  `pg18S_headshots` int(11) NOT NULL,
  `pg18S_hits` int(11) NOT NULL,
  `pg18S_shots` int(11) NOT NULL,
  `pg18_time` int(11) NOT NULL,
  `pg18_kills` int(11) NOT NULL,
  `pg18_headshots` int(11) NOT NULL,
  `pg18_hits` int(11) NOT NULL,
  `pg18_shots` int(11) NOT NULL,
  `pM1911L_time` int(11) NOT NULL,
  `pM1911L_kills` int(11) NOT NULL,
  `pM1911L_headshots` int(11) NOT NULL,
  `pM1911L_hits` int(11) NOT NULL,
  `pM1911L_shots` int(11) NOT NULL,
  `pM1911_time` int(11) NOT NULL,
  `pM1911_kills` int(11) NOT NULL,
  `pM1911_headshots` int(11) NOT NULL,
  `pM1911_hits` int(11) NOT NULL,
  `pM1911_shots` int(11) NOT NULL,
  `pM1911S_time` int(11) NOT NULL,
  `pM1911S_kills` int(11) NOT NULL,
  `pM1911S_headshots` int(11) NOT NULL,
  `pM1911S_hits` int(11) NOT NULL,
  `pM1911S_shots` int(11) NOT NULL,
  `pM1911T_time` int(11) NOT NULL,
  `pM1911T_kills` int(11) NOT NULL,
  `pM1911T_headshots` int(11) NOT NULL,
  `pM1911T_hits` int(11) NOT NULL,
  `pM1911T_shots` int(11) NOT NULL,
  `pM412_time` int(11) NOT NULL,
  `pM412_kills` int(11) NOT NULL,
  `pM412_headshots` int(11) NOT NULL,
  `pM412_hits` int(11) NOT NULL,
  `pM412_shots` int(11) NOT NULL,
  `pM9F_time` int(11) NOT NULL,
  `pM9F_kills` int(11) NOT NULL,
  `pM9F_headshots` int(11) NOT NULL,
  `pM9F_hits` int(11) NOT NULL,
  `pM9F_shots` int(11) NOT NULL,
  `pM9S_time` int(11) NOT NULL,
  `pM9S_kills` int(11) NOT NULL,
  `pM9S_headshots` int(11) NOT NULL,
  `pM9S_hits` int(11) NOT NULL,
  `pM9S_shots` int(11) NOT NULL,
  `pM9_time` int(11) NOT NULL,
  `pM9_kills` int(11) NOT NULL,
  `pM9_headshots` int(11) NOT NULL,
  `pM9_hits` int(11) NOT NULL,
  `pM9_shots` int(11) NOT NULL,
  `pM93R_time` int(11) NOT NULL,
  `pM93R_kills` int(11) NOT NULL,
  `pM93R_headshots` int(11) NOT NULL,
  `pM93R_hits` int(11) NOT NULL,
  `pM93R_shots` int(11) NOT NULL,
  `pMP443L_time` int(11) NOT NULL,
  `pMP443L_kills` int(11) NOT NULL,
  `pMP443L_headshots` int(11) NOT NULL,
  `pMP443L_hits` int(11) NOT NULL,
  `pMP443L_shots` int(11) NOT NULL,
  `pMP443S_time` int(11) NOT NULL,
  `pMP443S_kills` int(11) NOT NULL,
  `pMP443S_headshots` int(11) NOT NULL,
  `pMP443S_hits` int(11) NOT NULL,
  `pMP443S_shots` int(11) NOT NULL,
  `pMP443_time` int(11) NOT NULL,
  `pMP443_kills` int(11) NOT NULL,
  `pMP443_headshots` int(11) NOT NULL,
  `pMP443_hits` int(11) NOT NULL,
  `pMP443_shots` int(11) NOT NULL,
  `pTaurS_time` int(11) NOT NULL,
  `pTaurS_kills` int(11) NOT NULL,
  `pTaurS_headshots` int(11) NOT NULL,
  `pTaurS_hits` int(11) NOT NULL,
  `pTaurS_shots` int(11) NOT NULL,
  `pTaur_time` int(11) NOT NULL,
  `pTaur_kills` int(11) NOT NULL,
  `pTaur_headshots` int(11) NOT NULL,
  `pTaur_hits` int(11) NOT NULL,
  `pTaur_shots` int(11) NOT NULL,
  `sg870_time` int(11) NOT NULL,
  `sg870_kills` int(11) NOT NULL,
  `sg870_headshots` int(11) NOT NULL,
  `sg870_hits` int(11) NOT NULL,
  `sg870_shots` int(11) NOT NULL,
  `sgDAO_time` int(11) NOT NULL,
  `sgDAO_kills` int(11) NOT NULL,
  `sgDAO_headshots` int(11) NOT NULL,
  `sgDAO_hits` int(11) NOT NULL,
  `sgDAO_shots` int(11) NOT NULL,
  `sgM1014_time` int(11) NOT NULL,
  `sgM1014_kills` int(11) NOT NULL,
  `sgM1014_headshots` int(11) NOT NULL,
  `sgM1014_hits` int(11) NOT NULL,
  `sgM1014_shots` int(11) NOT NULL,
  `sgSaiga_time` int(11) NOT NULL,
  `sgSaiga_kills` int(11) NOT NULL,
  `sgSaiga_headshots` int(11) NOT NULL,
  `sgSaiga_hits` int(11) NOT NULL,
  `sgSaiga_shots` int(11) NOT NULL,
  `sgUSAS_time` int(11) NOT NULL,
  `sgUSAS_kills` int(11) NOT NULL,
  `sgUSAS_headshots` int(11) NOT NULL,
  `sgUSAS_hits` int(11) NOT NULL,
  `sgUSAS_shots` int(11) NOT NULL,
  `smMP7_time` int(11) NOT NULL,
  `smMP7_kills` int(11) NOT NULL,
  `smMP7_headshots` int(11) NOT NULL,
  `smMP7_hits` int(11) NOT NULL,
  `smMP7_shots` int(11) NOT NULL,
  `smP90_time` int(11) NOT NULL,
  `smP90_kills` int(11) NOT NULL,
  `smP90_headshots` int(11) NOT NULL,
  `smP90_hits` int(11) NOT NULL,
  `smP90_shots` int(11) NOT NULL,
  `smPDR_time` int(11) NOT NULL,
  `smPDR_kills` int(11) NOT NULL,
  `smPDR_headshots` int(11) NOT NULL,
  `smPDR_hits` int(11) NOT NULL,
  `smPDR_shots` int(11) NOT NULL,
  `smPP2000_time` int(11) NOT NULL,
  `smPP2000_kills` int(11) NOT NULL,
  `smPP2000_headshots` int(11) NOT NULL,
  `smPP2000_hits` int(11) NOT NULL,
  `smPP2000_shots` int(11) NOT NULL,
  `smUMP_time` int(11) NOT NULL,
  `smUMP_kills` int(11) NOT NULL,
  `smUMP_headshots` int(11) NOT NULL,
  `smUMP_hits` int(11) NOT NULL,
  `smUMP_shots` int(11) NOT NULL,
  `smVAL_time` int(11) NOT NULL,
  `smVAL_kills` int(11) NOT NULL,
  `smVAL_headshots` int(11) NOT NULL,
  `smVAL_hits` int(11) NOT NULL,
  `smVAL_shots` int(11) NOT NULL,
  `srM39_time` int(11) NOT NULL,
  `srM39_kills` int(11) NOT NULL,
  `srM39_headshots` int(11) NOT NULL,
  `srM39_hits` int(11) NOT NULL,
  `srM39_shots` int(11) NOT NULL,
  `srM40_time` int(11) NOT NULL,
  `srM40_kills` int(11) NOT NULL,
  `srM40_headshots` int(11) NOT NULL,
  `srM40_hits` int(11) NOT NULL,
  `srM40_shots` int(11) NOT NULL,
  `srM98_time` int(11) NOT NULL,
  `srM98_kills` int(11) NOT NULL,
  `srM98_headshots` int(11) NOT NULL,
  `srM98_hits` int(11) NOT NULL,
  `srM98_shots` int(11) NOT NULL,
  `srMK11_time` int(11) NOT NULL,
  `srMK11_kills` int(11) NOT NULL,
  `srMK11_headshots` int(11) NOT NULL,
  `srMK11_hits` int(11) NOT NULL,
  `srMK11_shots` int(11) NOT NULL,
  `srSKS_time` int(11) NOT NULL,
  `srSKS_kills` int(11) NOT NULL,
  `srSKS_headshots` int(11) NOT NULL,
  `srSKS_hits` int(11) NOT NULL,
  `srSKS_shots` int(11) NOT NULL,
  `srSV98_time` int(11) NOT NULL,
  `srSV98_kills` int(11) NOT NULL,
  `srSV98_headshots` int(11) NOT NULL,
  `srSV98_hits` int(11) NOT NULL,
  `srSV98_shots` int(11) NOT NULL,
  `srSVD_time` int(11) NOT NULL,
  `srSVD_kills` int(11) NOT NULL,
  `srSVD_headshots` int(11) NOT NULL,
  `srSVD_hits` int(11) NOT NULL,
  `srSVD_shots` int(11) NOT NULL,
  `wahUSG_time` int(11) NOT NULL,
  `wahUSG_kills` int(11) NOT NULL,
  `wahUSG_headshots` int(11) NOT NULL,
  `wahUSG_hits` int(11) NOT NULL,
  `wahUSG_shots` int(11) NOT NULL,
  `wasK_time` int(11) NOT NULL,
  `wasK_kills` int(11) NOT NULL,
  `wasK_headshots` int(11) NOT NULL,
  `wasK_hits` int(11) NOT NULL,
  `wasK_shots` int(11) NOT NULL,
  `wLAAFIM_time` int(11) NOT NULL,
  `wLAAFIM_kills` int(11) NOT NULL,
  `wLAAFIM_headshots` int(11) NOT NULL,
  `wLAAFIM_hits` int(11) NOT NULL,
  `wLAAFIM_shots` int(11) NOT NULL,
  `wLAAIGL_time` int(11) NOT NULL,
  `wLAAIGL_kills` int(11) NOT NULL,
  `wLAAIGL_headshots` int(11) NOT NULL,
  `wLAAIGL_hits` int(11) NOT NULL,
  `wLAAIGL_shots` int(11) NOT NULL,
  `wLATJAV_time` int(11) NOT NULL,
  `wLATJAV_kills` int(11) NOT NULL,
  `wLATJAV_headshots` int(11) NOT NULL,
  `wLATJAV_hits` int(11) NOT NULL,
  `wLATJAV_shots` int(11) NOT NULL,
  `wLATRPG_time` int(11) NOT NULL,
  `wLATRPG_kills` int(11) NOT NULL,
  `wLATRPG_headshots` int(11) NOT NULL,
  `wLATRPG_hits` int(11) NOT NULL,
  `wLATRPG_shots` int(11) NOT NULL,
  `wLATSMAW_time` int(11) NOT NULL,
  `wLATSMAW_kills` int(11) NOT NULL,
  `wLATSMAW_headshots` int(11) NOT NULL,
  `wLATSMAW_hits` int(11) NOT NULL,
  `wLATSMAW_shots` int(11) NOT NULL,
  `wahUGL_time` int(11) NOT NULL,
  `wahUGL_kills` int(11) NOT NULL,
  `wahUGL_shots` int(11) NOT NULL,
  `wahUGL_hits` int(11) NOT NULL,
  `wahUGL_headshots` int(11) NOT NULL,
  `arFAMAS_time` INT NOT NULL,  
  `arFAMAS_kills` INT NOT NULL, 
  `arFAMAS_shots` INT NOT NULL, 
  `arFAMAS_hits` INT NOT NULL, 
  `arFAMAS_headshots` INT NOT NULL, 
  `arL85A2_time` INT NOT NULL, 
  `arL85A2_kills` INT NOT NULL,  
  `arL85A2_shots` INT NOT NULL, 
  `arL85A2_hits` INT NOT NULL,  
  `arL85A2_headshots` INT NOT NULL, 
  `caHK53_time` INT NOT NULL,  
  `caHK53_kills` INT NOT NULL,  
  `caHK53_shots` INT NOT NULL,  
  `caHK53_headshots` INT NOT NULL,  
  `caHK53_hits` INT NOT NULL,  
  `caQBZ95B_time` INT NOT NULL,  
  `caQBZ95B_kills` INT NOT NULL,  
  `caQBZ95B_shots` INT NOT NULL,  
  `caQBZ95B_headshots` INT NOT NULL,  
  `caQBZ95B_hits` INT NOT NULL,  
  `mgQBB95_time` INT NOT NULL,  
  `mgQBB95_kills` INT NOT NULL, 
  `mgQBB95_shots` INT NOT NULL, 
  `mgQBB95_headshots` INT NOT NULL,  
  `mgQBB95_hits` INT NOT NULL,  
  `mgMG36_time` INT NOT NULL,  
  `mgMG36_kills` INT NOT NULL,  
  `mgMG36_shots` INT NOT NULL,  
  `mgMG36_headshots` INT NOT NULL,  
  `mgMG36_hits` INT NOT NULL,  
  `srQBU88_time` INT NOT NULL,  
  `srQBU88_kills` INT NOT NULL, 
  `srQBU88_headshots` INT NOT NULL, 
  `srQBU88_hits` INT NOT NULL, 
  `srQBU88_shots` INT NOT NULL,  
  `srL96_time` INT NOT NULL,  
  `srL96_kills` INT NOT NULL,  
  `srL96_headshots` INT NOT NULL,  
  `srL96_hits` INT NOT NULL,  
  `srL96_shots` INT NOT NULL, 
  `smPP19_time` INT NOT NULL, 
  `smPP19_kills` INT NOT NULL, 
  `smPP19_headshots` INT NOT NULL,  
  `smPP19_hits` INT NOT NULL,  
  `smPP19_shots` INT NOT NULL,  
  `sgJackH_time` INT NOT NULL, 
  `sgJackH_kills` INT NOT NULL, 
  `sgJackH_headshots` INT NOT NULL,  
  `sgJackH_hits` INT NOT NULL,  
  `sgJackH_shots` INT NOT NULL,
  `arAUG_time` INT NOT NULL,
  `arAUG_kills` INT NOT NULL,  
  `arAUG_shots` INT NOT NULL,  
  `arAUG_hits` INT NOT NULL,  
  `arAUG_headshots` INT NOT NULL,  
  `arSCARL_time` INT NOT NULL,  
  `arSCARL_kills` INT NOT NULL,  
  `arSCARL_shots` INT NOT NULL,  
  `arSCARL_hits` INT NOT NULL,  
  `arSCARL_headshots` INT NOT NULL,  
  `mgL86A1_time` INT NOT NULL,  
  `mgL86A1_kills` INT NOT NULL,  
  `mgL86A1_shots` INT NOT NULL, 
  `mgL86A1_hits` INT NOT NULL,  
  `mgL86A1_headshots` INT NOT NULL,  
  `mgLSAT_time` INT NOT NULL,  
  `mgLSAT_kills` INT NOT NULL,  
  `mgLSAT_shots` INT NOT NULL,  
  `mgLSAT_hits` INT NOT NULL,  
  `mgLSAT_headshots` INT NOT NULL,  
  `caACR_time` INT NOT NULL,  
  `caACR_kills` INT NOT NULL,  
  `caACR_shots` INT NOT NULL,  
  `caACR_hits` INT NOT NULL,  
  `caACR_headshots` INT NOT NULL,  
  `caMTAR21_time` INT NOT NULL,  
  `caMTAR21_kills` INT NOT NULL,  
  `caMTAR21_shots` INT NOT NULL,  
  `caMTAR21_hits` INT NOT NULL,  
  `caMTAR21_headshots` INT NOT NULL,  
  `srHK417_time` INT NOT NULL,  
  `srHK417_kills` INT NOT NULL,  
  `srHK417_shots` INT NOT NULL,  
  `srHK417_hits` INT NOT NULL,  
  `srHK417_headshots` INT NOT NULL,  
  `srJNG90_time` INT NOT NULL,  
  `srJNG90_kills` INT NOT NULL,  
  `srJNG90_shots` INT NOT NULL,  
  `srJNG90_hits` INT NOT NULL,  
  `srJNG90_headshots` INT NOT NULL,  
  `sgSPAS12_time` INT NOT NULL,  
  `sgSPAS12_kills` INT NOT NULL,  
  `sgSPAS12_shots` INT NOT NULL,  
  `sgSPAS12_hits` INT NOT NULL,  
  `sgSPAS12_headshots` INT NOT NULL,  
  `smM5K_time` INT NOT NULL,  
  `smM5K_kills` INT NOT NULL,  
  `smM5K_shots` INT NOT NULL,  
  `smM5K_hits` INT NOT NULL,  
  `smM5K_headshots` INT NOT NULL,
  PRIMARY KEY  (`stats_pid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;";

if(mysql_query($cSQL)){
$weapons = 'Table created Weapons<img src="../img/tick.png" border="0" /><br>';
}else{
$weapons = 'Table not created '.mysql_error().'<img src="../img/cross.png" border="0" /><br>';
}


$cSQL="CREATE TABLE IF NOT EXISTS {$DBPrefix}vehicles (
  `stats_pid` int(11) NOT NULL,
  `aa9k22_time` int(11) NOT NULL,
  `aa9k22_kills` int(11) NOT NULL,
  `aaLAV_time` int(11) NOT NULL,
  `aaLAV_kills` int(11) NOT NULL,
  `ahAH1Z_time` int(11) NOT NULL,
  `ahAH1Z_kills` int(11) NOT NULL,
  `ahMi28_time` int(11) NOT NULL,
  `ahMi28_kills` int(11) NOT NULL,
  `atTOW_time` int(11) NOT NULL,
  `atTOW_kills` int(11) NOT NULL,
  `ifvBMP_time` int(11) NOT NULL,
  `ifvBMP_kills` int(11) NOT NULL,
  `ifvLAV_time` int(11) NOT NULL,
  `ifvLAV_kills` int(11) NOT NULL,
  `jaA10_time` int(11) NOT NULL,
  `jaA10_kills` int(11) NOT NULL,
  `jaSU25_time` int(11) NOT NULL,
  `jaSU25_kills` int(11) NOT NULL,
  `jfF18_time` int(11) NOT NULL,
  `jfF18_kills` int(11) NOT NULL,
  `jfSu35_time` int(11) NOT NULL,
  `jfSu35_kills` int(11) NOT NULL,
  `mbtM1A_time` int(11) NOT NULL,
  `mbtM1A_kills` int(11) NOT NULL,
  `mbtT90_time` int(11) NOT NULL,
  `mbtT90_kills` int(11) NOT NULL,
  `saaCRAM_time` int(11) NOT NULL,
  `saaCRAM_kills` int(11) NOT NULL,
  `saaPant_time` int(11) NOT NULL,
  `saaPant_kills` int(11) NOT NULL,
  `shAH6_time` int(11) NOT NULL,
  `shAH6_kills` int(11) NOT NULL,
  `shz11_time` int(11) NOT NULL,
  `shz11_kills` int(11) NOT NULL,
  `sKorn_time` int(11) NOT NULL,
  `sKorn_kills` int(11) NOT NULL,
  `trAAV_time` int(11) NOT NULL,
  `trAAV_kills` int(11) NOT NULL,
  `trHum_time` int(11) NOT NULL,
  `trHum_kills` int(11) NOT NULL,
  `trITV_time` int(11) NOT NULL,
  `trITV_kills` int(11) NOT NULL,
  `trKA60_time` int(11) NOT NULL,
  `trKA60_kills` int(11) NOT NULL,
  `trRIB_time` int(11) NOT NULL,
  `trRIB_kills` int(11) NOT NULL,
  `trUH1_time` int(11) NOT NULL,
  `trUH1_kills` int(11) NOT NULL,
  `trVDV_time` int(11) NOT NULL,
  `trVDV_kills` int(11) NOT NULL,
  `trVod_time` int(11) NOT NULL,
  `trVod_kills` int(11) NOT NULL,
  `trDpv_time` INT NOT NULL ,
  `trDpv_kills` INT NOT NULL ,
  `trSkid_time` INT NOT NULL ,
  `trSkid_kills` INT NOT NULL ,
  `jfx1F35JSF_time` INT NOT NULL ,
  `jfx1F35JSF_kills` INT NOT NULL,
  `ifvBTR90_time` INT NOT NULL ,
  `ifvBTR90_kills` INT NOT NULL,
  `aa9k22_destroys` INT NOT NULL,  
  `aaLAV_destroys` INT NOT NULL,  
  `ahAH1Z_destroys` INT NOT NULL,  
  `ahMi28_destroys` INT NOT NULL,  
  `atTOW_destroys` INT NOT NULL,  
  `ifvBMP_destroys` INT NOT NULL, 
  `ifvLAV_destroys` INT NOT NULL, 
  `jaA10_destroys` INT NOT NULL,  
  `jaSU25_destroys` INT NOT NULL, 
  `jfF18_destroys` INT NOT NULL,  
  `jfSu35_destroys` INT NOT NULL,  
  `mbtM1A_destroys` INT NOT NULL,  
  `mbtT90_destroys` INT NOT NULL,  
  `saaCRAM_destroys` INT NOT NULL, 
  `saaPant_destroys` INT NOT NULL,  
  `shAH6_destroys` INT NOT NULL,  
  `shz11_destroys` INT NOT NULL,  
  `sKorn_destroys` INT NOT NULL,  
  `trAAV_destroys` INT NOT NULL,  
  `trHum_destroys` INT NOT NULL,  
  `trITV_destroys` INT NOT NULL,  
  `trKA60_destroys` INT NOT NULL, 
  `trRIB_destroys` INT NOT NULL,  
  `trUH1_destroys` INT NOT NULL,  
  `trVDV_destroys` INT NOT NULL,  
  `trVod_destroys` INT NOT NULL,  
  `trSkid_destroys` INT NOT NULL,  
  `trDpv_destroys` INT NOT NULL,  
  `ifvBTR90_destroys` INT NOT NULL,  
  `jfx1F35JSF_destroys` INT NOT NULL,
  PRIMARY KEY  (`stats_pid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;";

if(mysql_query($cSQL)){
$vehicles = 'Table created Vehicles<img src="../img/tick.png" border="0" /><br>';
}else{
$vehicles = 'Table not created '.mysql_error().'<img src="../img/cross.png" border="0" /><br>';
}

$cSQL="CREATE TABLE IF NOT EXISTS {$DBPrefix}equipment (
  `stats_pid` int(11) NOT NULL,
  `seqRad_time` int(11) NOT NULL,
  `seqRad_kills` int(11) NOT NULL,
  `seqRad_spawns` int(11) NOT NULL,
  `waeM67_kills` int(11) NOT NULL,
  `waeM67_time` int(11) NOT NULL,
  `waeM67_headshots` int(11) NOT NULL,
  `waeM67_hits` int(11) NOT NULL,
  `waeM67_shots` int(11) NOT NULL,
  `wasDef_time` int(11) NOT NULL,
  `wasDef_kills` int(11) NOT NULL,
  `wasDef_revives` int(11) NOT NULL,
  `wasDef_headshots` int(11) NOT NULL,
  `wasDef_hits` int(11) NOT NULL,
  `wasDef_shots` int(11) NOT NULL,
  `waeC4_time` int(11) NOT NULL,
  `waeC4_kills` int(11) NOT NULL,
  `waeC4_headshots` int(11) NOT NULL,
  `waeC4_hits` int(11) NOT NULL,
  `waeC4_shots` int(11) NOT NULL,
  `seqUGS_time` int(11) NOT NULL,
  `seqUGS_kills` int(11) NOT NULL,
  `seqUGS_spots` int(11) NOT NULL,
  `waeMine_time` int(11) NOT NULL,
  `waeMine_kills` int(11) NOT NULL,
  `waeMine_headshots` int(11) NOT NULL,
  `waeMine_hits` int(11) NOT NULL,
  `waeMine_shots` int(11) NOT NULL,
  `waeClay_time` int(11) NOT NULL,
  `waeClay_kills` int(11) NOT NULL,
  `waeClay_headshots` int(11) NOT NULL,
  `waeClay_hits` int(11) NOT NULL,
  `waeClay_shots` int(11) NOT NULL,
  `seqEOD_time` int(11) NOT NULL,
  `seqEOD_kills` int(11) NOT NULL,
  `seqSOF_time` int(11) NOT NULL,
  `seqSOF_kills` int(11) NOT NULL,
  `waeMort_time` int(11) NOT NULL,
  `waeMort_kills` int(11) NOT NULL,
  `waeMort_headshots` int(11) NOT NULL,
  `waeMort_shots` int(11) NOT NULL,
  `waeMort_hits` int(11) NOT NULL,
  `seqMAV_time` int(11) NOT NULL,
  `seqMAV_kills` int(11) NOT NULL,
  `seqMAV_spots` int(11) NOT NULL,
  `wasRT_time` INT NOT NULL ,
  `wasRT_kills` INT NOT NULL ,
  `wasRT_hits` INT NOT NULL ,
  `wasRT_shots` INT NOT NULL ,
  `wasRT_headshots` INT NOT NULL,
  PRIMARY KEY  (`stats_pid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
";


if(mysql_query($cSQL)){
$equipment = 'Table created Equipment<img src="../img/tick.png" border="0" /><br>';
}else{
$equipment = 'Table not created '.mysql_error().'<img src="../img/cross.png" border="0" /><br>';
}

$cSQL="CREATE TABLE IF NOT EXISTS {$DBPrefix}stars (
  `stats_pid` int(11) NOT NULL,
  `arAEK_date` int(11) NOT NULL,
  `arAK74_date` int(11) NOT NULL,
  `arAN94_date` int(11) NOT NULL,
  `arF2_date` int(11) NOT NULL,
  `arG3_date` int(11) NOT NULL,
  `arKH_date` int(11) NOT NULL,
  `arM16_date` int(11) NOT NULL,
  `arM416_date` int(11) NOT NULL,
  `caA91_date` int(11) NOT NULL,
  `caAKS_date` int(11) NOT NULL,
  `caG36_date` int(11) NOT NULL,
  `caM4_date` int(11) NOT NULL,
  `caSCAR_date` int(11) NOT NULL,
  `caSG553_date` int(11) NOT NULL,
  `mgM240_date` int(11) NOT NULL,
  `mgM249_date` int(11) NOT NULL,
  `mgM27_date` int(11) NOT NULL,
  `mgM60_date` int(11) NOT NULL,
  `mgPech_date` int(11) NOT NULL,
  `mgRPK_date` int(11) NOT NULL,
  `mgT88_date` int(11) NOT NULL,
  `pG17S_date` int(11) NOT NULL,
  `pG17_date` int(11) NOT NULL,
  `pg18S_date` int(11) NOT NULL,
  `pg18_date` int(11) NOT NULL,
  `pM1911L_date` int(11) NOT NULL,
  `pM1911_date` int(11) NOT NULL,
  `pM1911S_date` int(11) NOT NULL,
  `pM1911T_date` int(11) NOT NULL,
  `pM412_date` int(11) NOT NULL,
  `pM9F_date` int(11) NOT NULL,
  `pM9S_date` int(11) NOT NULL,
  `pM9_date` int(11) NOT NULL,
  `pM93R_date` int(11) NOT NULL,
  `pMP443L_date` int(11) NOT NULL,
  `pMP443S_date` int(11) NOT NULL,
  `pMP443_date` int(11) NOT NULL,
  `pTaurS_date` int(11) NOT NULL,
  `pTaur_date` int(11) NOT NULL,
  `sg870_date` int(11) NOT NULL,
  `sgDAO_date` int(11) NOT NULL,
  `sgM1014_date` int(11) NOT NULL,
  `sgSaiga_date` int(11) NOT NULL,
  `sgUSAS_date` int(11) NOT NULL,
  `smMP7_date` int(11) NOT NULL,
  `smP90_date` int(11) NOT NULL,
  `smPDR_date` int(11) NOT NULL,
  `smPP2000_date` int(11) NOT NULL,
  `smUMP_date` int(11) NOT NULL,
  `smVAL_date` int(11) NOT NULL,
  `srM39_date` int(11) NOT NULL,
  `srM40_date` int(11) NOT NULL,
  `srM98_date` int(11) NOT NULL,
  `srMK11_date` int(11) NOT NULL,
  `srSKS_date` int(11) NOT NULL,
  `srSV98_date` int(11) NOT NULL,
  `srSVD_date` int(11) NOT NULL,
  `wahUSG_date` int(11) NOT NULL,
  `wasK_date` int(11) NOT NULL,
  `wLAAFIM_date` int(11) NOT NULL,
  `wLAAIGL_date` int(11) NOT NULL,
  `wLATJAV_date` int(11) NOT NULL,
  `wLATRPG_date` int(11) NOT NULL,
  `wLATSMAW_date` int(11) NOT NULL,
  `arAEK_count` int(11) NOT NULL,
  `arAK74_count` int(11) NOT NULL,
  `arAN94_count` int(11) NOT NULL,
  `arF2_count` int(11) NOT NULL,
  `arG3_count` int(11) NOT NULL,
  `arKH_count` int(11) NOT NULL,
  `arM16_count` int(11) NOT NULL,
  `arM416_count` int(11) NOT NULL,
  `caA91_count` int(11) NOT NULL,
  `caAKS_count` int(11) NOT NULL,
  `caG36_count` int(11) NOT NULL,
  `caM4_count` int(11) NOT NULL,
  `caSCAR_count` int(11) NOT NULL,
  `caSG553_count` int(11) NOT NULL,
  `mgM240_count` int(11) NOT NULL,
  `mgM249_count` int(11) NOT NULL,
  `mgM27_count` int(11) NOT NULL,
  `mgM60_count` int(11) NOT NULL,
  `mgPech_count` int(11) NOT NULL,
  `mgRPK_count` int(11) NOT NULL,
  `mgT88_count` int(11) NOT NULL,
  `pG17S_count` int(11) NOT NULL,
  `pG17_count` int(11) NOT NULL,
  `pg18S_count` int(11) NOT NULL,
  `pg18_count` int(11) NOT NULL,
  `pM1911L_count` int(11) NOT NULL,
  `pM1911_count` int(11) NOT NULL,
  `pM1911S_count` int(11) NOT NULL,
  `pM1911T_count` int(11) NOT NULL,
  `pM412_count` int(11) NOT NULL,
  `pM9F_count` int(11) NOT NULL,
  `pM9S_count` int(11) NOT NULL,
  `pM9_count` int(11) NOT NULL,
  `pM93R_count` int(11) NOT NULL,
  `pMP443L_count` int(11) NOT NULL,
  `pMP443S_count` int(11) NOT NULL,
  `pMP443_count` int(11) NOT NULL,
  `pTaurS_count` int(11) NOT NULL,
  `pTaur_count` int(11) NOT NULL,
  `sg870_count` int(11) NOT NULL,
  `sgDAO_count` int(11) NOT NULL,
  `sgM1014_count` int(11) NOT NULL,
  `sgSaiga_count` int(11) NOT NULL,
  `sgUSAS_count` int(11) NOT NULL,
  `smMP7_count` int(11) NOT NULL,
  `smP90_count` int(11) NOT NULL,
  `smPDR_count` int(11) NOT NULL,
  `smPP2000_count` int(11) NOT NULL,
  `smUMP_count` int(11) NOT NULL,
  `smVAL_count` int(11) NOT NULL,
  `srM39_count` int(11) NOT NULL,
  `srM40_count` int(11) NOT NULL,
  `srM98_count` int(11) NOT NULL,
  `srMK11_count` int(11) NOT NULL,
  `srSKS_count` int(11) NOT NULL,
  `srSV98_count` int(11) NOT NULL,
  `srSVD_count` int(11) NOT NULL,
  `wahUSG_count` int(11) NOT NULL,
  `wasK_count` int(11) NOT NULL,
  `wLAAFIM_count` int(11) NOT NULL,
  `wLAAIGL_count` int(11) NOT NULL,
  `wLATJAV_count` int(11) NOT NULL,
  `wLATRPG_count` int(11) NOT NULL,
  `wLATSMAW_count` int(11) NOT NULL,
  `arAEK_curr` int(11) NOT NULL,
  `arAK74_curr` int(11) NOT NULL,
  `arAN94_curr` int(11) NOT NULL,
  `arF2_curr` int(11) NOT NULL,
  `arG3_curr` int(11) NOT NULL,
  `arKH_curr` int(11) NOT NULL,
  `arM16_curr` int(11) NOT NULL,
  `arM416_curr` int(11) NOT NULL,
  `caA91_curr` int(11) NOT NULL,
  `caAKS_curr` int(11) NOT NULL,
  `caG36_curr` int(11) NOT NULL,
  `caM4_curr` int(11) NOT NULL,
  `caSCAR_curr` int(11) NOT NULL,
  `caSG553_curr` int(11) NOT NULL,
  `mgM240_curr` int(11) NOT NULL,
  `mgM249_curr` int(11) NOT NULL,
  `mgM27_curr` int(11) NOT NULL,
  `mgM60_curr` int(11) NOT NULL,
  `mgPech_curr` int(11) NOT NULL,
  `mgRPK_curr` int(11) NOT NULL,
  `mgT88_curr` int(11) NOT NULL,
  `pG17S_curr` int(11) NOT NULL,
  `pG17_curr` int(11) NOT NULL,
  `pg18S_curr` int(11) NOT NULL,
  `pg18_curr` int(11) NOT NULL,
  `pM1911L_curr` int(11) NOT NULL,
  `pM1911_curr` int(11) NOT NULL,
  `pM1911S_curr` int(11) NOT NULL,
  `pM1911T_curr` int(11) NOT NULL,
  `pM412_curr` int(11) NOT NULL,
  `pM9F_curr` int(11) NOT NULL,
  `pM9S_curr` int(11) NOT NULL,
  `pM9_curr` int(11) NOT NULL,
  `pM93R_curr` int(11) NOT NULL,
  `pMP443L_curr` int(11) NOT NULL,
  `pMP443S_curr` int(11) NOT NULL,
  `pMP443_curr` int(11) NOT NULL,
  `pTaurS_curr` int(11) NOT NULL,
  `pTaur_curr` int(11) NOT NULL,
  `sg870_curr` int(11) NOT NULL,
  `sgDAO_curr` int(11) NOT NULL,
  `sgM1014_curr` int(11) NOT NULL,
  `sgSaiga_curr` int(11) NOT NULL,
  `sgUSAS_curr` int(11) NOT NULL,
  `smMP7_curr` int(11) NOT NULL,
  `smP90_curr` int(11) NOT NULL,
  `smPDR_curr` int(11) NOT NULL,
  `smPP2000_curr` int(11) NOT NULL,
  `smUMP_curr` int(11) NOT NULL,
  `smVAL_curr` int(11) NOT NULL,
  `srM39_curr` int(11) NOT NULL,
  `srM40_curr` int(11) NOT NULL,
  `srM98_curr` int(11) NOT NULL,
  `srMK11_curr` int(11) NOT NULL,
  `srSKS_curr` int(11) NOT NULL,
  `srSV98_curr` int(11) NOT NULL,
  `srSVD_curr` int(11) NOT NULL,
  `wahUSG_curr` int(11) NOT NULL,
  `wasK_curr` int(11) NOT NULL,
  `wLAAFIM_curr` int(11) NOT NULL,
  `wLAAIGL_curr` int(11) NOT NULL,
  `wLATJAV_curr` int(11) NOT NULL,
  `wLATRPG_curr` int(11) NOT NULL,
  `wLATSMAW_curr` int(11) NOT NULL,
  `arAEK_needed` int(11) NOT NULL,
  `arAK74_needed` int(11) NOT NULL,
  `arAN94_needed` int(11) NOT NULL,
  `arF2_needed` int(11) NOT NULL,
  `arG3_needed` int(11) NOT NULL,
  `arKH_needed` int(11) NOT NULL,
  `arM16_needed` int(11) NOT NULL,
  `arM416_needed` int(11) NOT NULL,
  `caA91_needed` int(11) NOT NULL,
  `caAKS_needed` int(11) NOT NULL,
  `caG36_needed` int(11) NOT NULL,
  `caM4_needed` int(11) NOT NULL,
  `caSCAR_needed` int(11) NOT NULL,
  `caSG553_needed` int(11) NOT NULL,
  `mgM240_needed` int(11) NOT NULL,
  `mgM249_needed` int(11) NOT NULL,
  `mgM27_needed` int(11) NOT NULL,
  `mgM60_needed` int(11) NOT NULL,
  `mgPech_needed` int(11) NOT NULL,
  `mgRPK_needed` int(11) NOT NULL,
  `mgT88_needed` int(11) NOT NULL,
  `pG17S_needed` int(11) NOT NULL,
  `pG17_needed` int(11) NOT NULL,
  `pg18S_needed` int(11) NOT NULL,
  `pg18_needed` int(11) NOT NULL,
  `pM1911L_needed` int(11) NOT NULL,
  `pM1911_needed` int(11) NOT NULL,
  `pM1911S_needed` int(11) NOT NULL,
  `pM1911T_needed` int(11) NOT NULL,
  `pM412_needed` int(11) NOT NULL,
  `pM9F_needed` int(11) NOT NULL,
  `pM9S_needed` int(11) NOT NULL,
  `pM9_needed` int(11) NOT NULL,
  `pM93R_needed` int(11) NOT NULL,
  `pMP443L_needed` int(11) NOT NULL,
  `pMP443S_needed` int(11) NOT NULL,
  `pMP443_needed` int(11) NOT NULL,
  `pTaurS_needed` int(11) NOT NULL,
  `pTaur_needed` int(11) NOT NULL,
  `sg870_needed` int(11) NOT NULL,
  `sgDAO_needed` int(11) NOT NULL,
  `sgM1014_needed` int(11) NOT NULL,
  `sgSaiga_needed` int(11) NOT NULL,
  `sgUSAS_needed` int(11) NOT NULL,
  `smMP7_needed` int(11) NOT NULL,
  `smP90_needed` int(11) NOT NULL,
  `smPDR_needed` int(11) NOT NULL,
  `smPP2000_needed` int(11) NOT NULL,
  `smUMP_needed` int(11) NOT NULL,
  `smVAL_needed` int(11) NOT NULL,
  `srM39_needed` int(11) NOT NULL,
  `srM40_needed` int(11) NOT NULL,
  `srM98_needed` int(11) NOT NULL,
  `srMK11_needed` int(11) NOT NULL,
  `srSKS_needed` int(11) NOT NULL,
  `srSV98_needed` int(11) NOT NULL,
  `srSVD_needed` int(11) NOT NULL,
  `wahUSG_needed` int(11) NOT NULL,
  `wasK_needed` int(11) NOT NULL,
  `wLAAFIM_needed` int(11) NOT NULL,
  `wLAAIGL_needed` int(11) NOT NULL,
  `wLATJAV_needed` int(11) NOT NULL,
  `wLATRPG_needed` int(11) NOT NULL,
  `wLATSMAW_needed` int(11) NOT NULL,
  `wahUGL_date` int(11) NOT NULL,
  `wahUGL_curr` int(11) NOT NULL,
  `wahUGL_count` int(11) NOT NULL,
  `wahUGL_needed` int(11) NOT NULL,
  `arFAMAS_needed` INT NOT NULL,  
  `arL85A2_needed` INT NOT NULL,  
  `caHK53_needed` INT NOT NULL,  
  `caQBZ95B_needed` INT NOT NULL,  
  `mgQBB95_needed` INT NOT NULL,  
  `mgMG36_needed` INT NOT NULL,  
  `srQBU88_needed` INT NOT NULL,  
  `srL96_needed` INT NOT NULL,  
  `smPP19_needed` INT NOT NULL,  
  `sgJackH_needed` INT NOT NULL,  
  `arFAMAS_date` INT NOT NULL,  
  `arL85A2_date` INT NOT NULL,  
  `caHK53_date` INT NOT NULL,  
  `caQBZ95B_date` INT NOT NULL,  
  `mgQBB95_date` INT NOT NULL,  
  `mgMG36_date` INT NOT NULL,  
  `srQBU88_date` INT NOT NULL,  
  `srL96_date` INT NOT NULL,  
  `smPP19_date` INT NOT NULL,  
  `sgJackH_date` INT NOT NULL,  
  `arFAMAS_count` INT NOT NULL,  
  `arL85A2_count` INT NOT NULL,  
  `caHK53_count` INT NOT NULL,  
  `caQBZ95B_count` INT NOT NULL,  
  `mgQBB95_count` INT NOT NULL,  
  `mgMG36_count` INT NOT NULL,  
  `srQBU88_count` INT NOT NULL, 
  `srL96_count` INT NOT NULL,  
  `smPP19_count` INT NOT NULL,  
  `sgJackH_count` INT NOT NULL,  
  `arFAMAS_curr` INT NOT NULL,  
  `arL85A2_curr` INT NOT NULL,  
  `caHK53_curr` INT NOT NULL,  
  `caQBZ95B_curr` INT NOT NULL,  
  `mgQBB95_curr` INT NOT NULL,  
  `mgMG36_curr` INT NOT NULL,  
  `srQBU88_curr` INT NOT NULL,  
  `srL96_curr` INT NOT NULL,  
  `smPP19_curr` INT NOT NULL,  
  `sgJackH_curr` INT NOT NULL,
  `arAUG_date` INT NOT NULL,  
  `arAUG_curr` INT NOT NULL,  
  `arAUG_count` INT NOT NULL, 
  `arAUG_needed` INT NOT NULL,  
  `arSCARL_date` INT NOT NULL,  
  `arSCARL_curr` INT NOT NULL,  
  `arSCARL_count` INT NOT NULL,  
  `arSCARL_needed` INT NOT NULL,  
  `mgL86A1_date` INT NOT NULL,  
  `mgL86A1_curr` INT NOT NULL,  
  `mgL86A1_count` INT NOT NULL,  
  `mgL86A1_needed` INT NOT NULL,  
  `mgLSAT_date` INT NOT NULL,  
  `mgLSAT_curr` INT NOT NULL,  
  `mgLSAT_count` INT NOT NULL,  
  `mgLSAT_needed` INT NOT NULL,  
  `caACR_date` INT NOT NULL,  
  `caACR_curr` INT NOT NULL,  
  `caACR_count` INT NOT NULL,  
  `caACR_needed` INT NOT NULL,  
  `caMTAR21_date` INT NOT NULL,  
  `caMTAR21_curr` INT NOT NULL,  
  `caMTAR21_count` INT NOT NULL,  
  `caMTAR21_needed` INT NOT NULL,  
  `srHK417_date` INT NOT NULL,  
  `srHK417_curr` INT NOT NULL,  
  `srHK417_count` INT NOT NULL,  
  `srHK417_needed` INT NOT NULL,  
  `srJNG90_date` INT NOT NULL,  
  `srJNG90_curr` INT NOT NULL,  
  `srJNG90_count` INT NOT NULL,  
  `srJNG90_needed` INT NOT NULL,  
  `sgSPAS12_date` INT NOT NULL,  
  `sgSPAS12_curr` INT NOT NULL,  
  `sgSPAS12_count` INT NOT NULL,  
  `sgSPAS12_needed` INT NOT NULL,  
  `smM5K_date` INT NOT NULL,  
  `smM5K_curr` INT NOT NULL,  
  `smM5K_count` INT NOT NULL,  
  `smM5K_needed` INT NOT NULL,
  PRIMARY KEY  (`stats_pid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
";
if(mysql_query($cSQL)){
$stars = 'Table created Stars<img src="../img/tick.png" border="0" /><br>';
}else{
$stars = 'Table not created '.mysql_error().'<img src="../img/cross.png" border="0" /><br>';
}


$cSQL="CREATE TABLE IF NOT EXISTS {$DBPrefix}assignments (
  `stats_pid` int(11) NOT NULL,
  `xpma01_count` int(11) NOT NULL,
  `xpma01_date` int(11) NOT NULL,
  `xpma01_criteria1` int(11) NOT NULL,
  `xpma01_criteria2` int(11) NOT NULL,
  `xpma02_count` int(11) NOT NULL,
  `xpma02_date` int(11) NOT NULL,
  `xpma02_criteria1` int(11) NOT NULL,
  `xpma02_criteria2` int(11) NOT NULL,
  `xpma02_criteria3` int(11) NOT NULL,
  `xpma03_count` int(11) NOT NULL,
  `xpma03_date` int(11) NOT NULL,
  `xpma03_criteria1` int(11) NOT NULL,
  `xpma03_criteria2` int(11) NOT NULL,
  `xpma04_count` int(11) NOT NULL,
  `xpma04_date` int(11) NOT NULL,
  `xpma04_criteria1` int(11) NOT NULL,
  `xpma04_criteria2` int(11) NOT NULL,
  `xpma04_criteria3` int(11) NOT NULL,
  `xpma05_count` int(11) NOT NULL,
  `xpma05_date` int(11) NOT NULL,
  `xpma05_criteria1` int(11) NOT NULL,
  `xpma05_criteria2` int(11) NOT NULL,
  `xpma06_count` int(11) NOT NULL,
  `xpma06_date` int(11) NOT NULL,
  `xpma06_criteria1` int(11) NOT NULL,
  `xpma06_criteria2` int(11) NOT NULL,
  `xpma06_criteria3` int(11) NOT NULL,
  `xpma07_count` int(11) NOT NULL,
  `xpma07_date` int(11) NOT NULL,
  `xpma07_criteria1` int(11) NOT NULL,
  `xpma07_criteria2` int(11) NOT NULL,
  `xpma08_count` int(11) NOT NULL,
  `xpma08_date` int(11) NOT NULL,
  `xpma08_criteria1` int(11) NOT NULL,
  `xpma08_criteria2` int(11) NOT NULL,
  `xpma08_criteria3` int(11) NOT NULL,
  `xpma09_count` int(11) NOT NULL,
  `xpma09_date` int(11) NOT NULL,
  `xpma09_criteria1` int(11) NOT NULL,
  `xpma09_criteria2` int(11) NOT NULL,
  `xpma09_criteria3` int(11) NOT NULL,
  `xpma10_count` int(11) NOT NULL,
  `xpma10_date` int(11) NOT NULL,
  `xpma10_criteria1` int(11) NOT NULL,
  `xpma10_criteria2` int(11) NOT NULL,
  `xpma10_criteria3` int(11) NOT NULL,
  `xpma10_criteria4` int(11) NOT NULL,
  `xpma10_criteria5` int(11) NOT NULL,
  `xp2prema01_count` INT NOT NULL,
  `xp2prema01_date` INT NOT NULL,  
  `xp2prema01_criteria1` INT NOT NULL, 
  `xp2prema01_criteria2` INT NOT NULL,  
  `xp2prema01_criteria3` INT NOT NULL,  
  `xp2prema02_count` INT NOT NULL,  
  `xp2prema02_date` INT NOT NULL,  
  `xp2prema02_criteria1` INT NOT NULL,  
  `xp2prema02_criteria2` INT NOT NULL,  
  `xp2prema03_count` INT NOT NULL,  
  `xp2prema03_date` INT NOT NULL,  
  `xp2prema03_criteria1` INT NOT NULL,  
  `xp2prema03_criteria2` INT NOT NULL,  
  `xp2prema03_criteria3` INT NOT NULL,  
  `xp2prema04_count` INT NOT NULL,  
  `xp2prema04_date` INT NOT NULL,  
  `xp2prema04_criteria1` INT NOT NULL,  
  `xp2prema04_criteria2` INT NOT NULL,  
  `xp2prema04_criteria3` INT NOT NULL,  
  `xp2prema05_count` INT NOT NULL,  
  `xp2prema05_date` INT NOT NULL,  
  `xp2prema05_criteria1` INT NOT NULL,  
  `xp2prema05_criteria2` INT NOT NULL,  
  `xp2prema05_criteria3` INT NOT NULL,  
  `xp2prema05_criteria4` INT NOT NULL,  
  `xp2prema05_criteria5` INT NOT NULL,
  `xp2prema06_count` INT NOT NULL,
  `xp2prema06_date` INT NOT NULL,  
  `xp2prema06_criteria1` INT NOT NULL, 
  `xp2prema06_criteria2` INT NOT NULL,  
  `xp2prema06_criteria3` INT NOT NULL, 
  `xp2prema07_count` INT NOT NULL,
  `xp2prema07_date` INT NOT NULL,  
  `xp2prema07_criteria1` INT NOT NULL, 
  `xp2prema07_criteria2` INT NOT NULL,  
  `xp2prema07_criteria3` INT NOT NULL, 
  `xp2prema08_count` INT NOT NULL,
  `xp2prema08_date` INT NOT NULL,  
  `xp2prema08_criteria1` INT NOT NULL, 
  `xp2prema08_criteria2` INT NOT NULL,  
  `xp2prema08_criteria3` INT NOT NULL, 
  `xp2prema09_count` INT NOT NULL,
  `xp2prema09_date` INT NOT NULL,  
  `xp2prema09_criteria1` INT NOT NULL, 
  `xp2prema09_criteria2` INT NOT NULL,  
  `xp2prema09_criteria3` INT NOT NULL,
  `xp2prema10_count` INT NOT NULL,
  `xp2prema10_date` INT NOT NULL,  
  `xp2prema10_criteria1` INT NOT NULL, 
  `xp2prema10_criteria2` INT NOT NULL,  
  `xp2prema10_criteria3` INT NOT NULL, 
  `xp2prema10_criteria4` INT NOT NULL, 
  `xp2ma01_count` INT NOT NULL,  
  `xp2ma01_date` INT NOT NULL,  
  `xp2ma01_criteria1` INT NOT NULL,  
  `xp2ma01_criteria2` INT NOT NULL,  
  `xp2ma02_count` INT NOT NULL,  
  `xp2ma02_date` INT NOT NULL,  
  `xp2ma02_criteria1` INT NOT NULL,  
  `xp2ma02_criteria2` INT NOT NULL,  
  `xp2ma03_count` INT NOT NULL,  
  `xp2ma03_date` INT NOT NULL,  
  `xp2ma03_criteria1` INT NOT NULL,  
  `xp2ma03_criteria2` INT NOT NULL,  
  `xp2ma04_count` INT NOT NULL,  
  `xp2ma04_date` INT NOT NULL,  
  `xp2ma04_criteria1` INT NOT NULL,  
  `xp2ma04_criteria2` INT NOT NULL,  
  `xp2ma05_count` INT NOT NULL,  
  `xp2ma05_date` INT NOT NULL,  
  `xp2ma05_criteria1` INT NOT NULL,  
  `xp2ma05_criteria2` INT NOT NULL,  
  `xp2ma06_count` INT NOT NULL,  
  `xp2ma06_date` INT NOT NULL,  
  `xp2ma06_criteria1` INT NOT NULL,  
  `xp2ma06_criteria2` INT NOT NULL,  
  `xp2ma07_count` INT NOT NULL,  
  `xp2ma07_date` INT NOT NULL,  
  `xp2ma07_criteria1` INT NOT NULL,  
  `xp2ma07_criteria2` INT NOT NULL,  
  `xp2ma08_count` INT NOT NULL,  
  `xp2ma08_date` INT NOT NULL,  
  `xp2ma08_criteria1` INT NOT NULL,  
  `xp2ma08_criteria2` INT NOT NULL,  
  `xp2ma09_count` INT NOT NULL,  
  `xp2ma09_date` INT NOT NULL,  
  `xp2ma09_criteria1` INT NOT NULL,  
  `xp2ma09_criteria2` INT NOT NULL,  
  `xp2ma10_count` INT NOT NULL,  
  `xp2ma10_date` INT NOT NULL,  
  `xp2ma10_criteria1` INT NOT NULL,  
  `xp2ma10_criteria2` INT NOT NULL,
  PRIMARY KEY  (`stats_pid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;";

if(mysql_query($cSQL)){
$assignments = 'Table created Assignments<img src="../img/tick.png" border="0" /><br>';
}else{
$assignments = 'Table not created '.mysql_error().'<img src="../img/cross.png" border="0" /><br>';
}


$cSQL="CREATE TABLE IF NOT EXISTS {$DBPrefix}ServerHistory (
  `stats_pid` int(11) NOT NULL,
  `ServerName` varchar(255) NOT NULL,
  `ServerID` varchar(255) NOT NULL,
  `FirstVisit` int(15) NOT NULL,
  `LastVisit` int(15) NOT NULL,
  `serverStatus` int(1) NOT NULL default '1',
  `checkS` int(11) NOT NULL,
  `dateLastCheck` int(15) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;";


if(mysql_query($cSQL)){
$sHistory = 'Table created ServerHistory<img src="../img/tick.png" border="0" /><br>';
}else{
$sHistory = 'Table not created '.mysql_error().'<img src="../img/cross.png" border="0" /><br>';
}

$cSQL="CREATE TABLE IF NOT EXISTS {$DBPrefix}battlereports (
  `stats_pid` int(11) NOT NULL,
  `ServerName` varchar(255) NOT NULL,
  `ReportID` int(15) NOT NULL,
  `ServerMap` varchar(50) NOT NULL,
  `CreatetAt` int(15) NOT NULL,
  `gameMode` int(2) NOT NULL,
  `winStatus` int(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;";


if(mysql_query($cSQL)){
$reports = 'Table created Battlereports<img src="../img/tick.png" border="0" /><br>';
}else{
$reports = 'Table not created '.mysql_error().'<img src="../img/cross.png" border="0" /><br>';
}


$cSQL="
CREATE TABLE IF NOT EXISTS {$DBPrefix}battlereportsDetails (
  `ReportID` int(15) NOT NULL,
  `stats_pid` int(11) NOT NULL,
  `status` int(1) NOT NULL,
  `bestKills` varchar(255) NOT NULL,
  `bestRecon` varchar(255) NOT NULL,
  `awardscore` varchar(255) NOT NULL,
  `support` varchar(255) NOT NULL,
  `assault` varchar(255) NOT NULL,
  `engineer` varchar(255) NOT NULL,
  `accuracy` varchar(255) NOT NULL,
  `jetcrew` varchar(255) NOT NULL,
  `helicrew` varchar(255) NOT NULL,
  `vehiclecrew` varchar(255) NOT NULL,
  `duration` int(15) NOT NULL,
  `ticket1` int(11) NOT NULL,
  `ticket2` int(11) NOT NULL,
  `ticket3` int(11) NOT NULL,
  `ticket4` int(11) NOT NULL,
  `playersTeam1` mediumtext NOT NULL,
  `playersTeam2` mediumtext NOT NULL,
  `playersTeam3` mediumtext NOT NULL,
  `playersTeam4` mediumtext NOT NULL,
  `winner` int(1) NOT NULL,
  `Servername` varchar(255) NOT NULL,
  `map` varchar(60) NOT NULL,
  `mapMode` int(2) NOT NULL,
  `topWeapon` varchar(255) NOT NULL,
  `uWeapons` mediumtext NOT NULL,
  `uVehiclespecs` mediumtext NOT NULL,
  `uSoldierspecializations` mediumtext NOT NULL,
  `uGadgets` mediumtext NOT NULL,
  `awards` mediumtext NOT NULL,
  `uWeaponaddons` mediumtext NOT NULL,
  `elo` varchar(255) NOT NULL,
  `topVehicle` varchar(255) NOT NULL,
  `rankSpanPreviousScore` int(11) NOT NULL,
  `pointsNeededNext` int(11) NOT NULL,
  `pointsNeededcurr` int(11) NOT NULL,
  `rankSpanIncrementScore` int(11) NOT NULL,
  `intData` mediumtext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
";


if(mysql_query($cSQL)){
$reportsD = 'Table created Battlereports Details<img src="../img/tick.png" border="0" /><br>';
}else{
$reportsD = 'Table not created '.mysql_error().'<img src="../img/cross.png" border="0" /><br>';
}


?>
	<html>
		<head>
			<title>SQL Table created</title>
		</head>
		<table class="defaultUpdate" cellspacing="0" cellpadding="0" style="background:#0A0A0A;filter: alpha(opacity=80); opacity: 0.85; -moz-opacity: 0.85;margin:auto;">
			<tr>
				<td class="head" colspan="5">Tables createt</td>
			</tr>
			<tr>
				<td class="result">
					<span>
						<br /><br /><?php echo $admin ?>
						<br /><?php echo $admin_insert ?>
						<br /><?php echo $coop ?>
						<br /><?php echo $game ?>
						<br /><?php echo $Stats ?>
						<br /><?php echo $login ?>
						<br /><?php echo $insertA ?>
						<br /><?php echo $medals ?>
						<br /><?php echo $style ?>
						<br /><?php echo $ribbons ?>
						<br /><?php echo $styleinsert ?>
						<br /><?php echo $team ?>
						<br /><?php echo $weapons ?>
						<br /><?php echo $vehicles ?>
						<br /><?php echo $equipment ?>
						<br /><?php echo $stars ?>
						<br /><?php echo $assignments ?>
						<br /><?php echo $sHistory ?>
						<br /><?php echo $reports ?>
						<br /><?php echo $reportsD ?>
					</span>
				</td>
			</tr>
		</table>
	</html>
<?php	