<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
ini_set('memory_limit', '1024M');
error_reporting(E_ALL);

$servername = "localhost";
$username = "_North";
$password = "APTR150s";
$dbname = "4cc";
$DB = new mysqli($servername, $username, $password, $dbname);
if(!isset($_GET['cup'])){
	$cup = 39;
} else {
	$cup = $_GET['cup'];
}
if(isset($_POST['name'])){
	if(substr($_POST['players'],strlen($_POST['players'])-1) == ',')
		$_POST['players'] = substr($_POST['players'],0,strlen($_POST['players'])-1);
	$sql = $DB->prepare("INSERT INTO FantasyDB (iCupID,sName) VALUES(" . $_POST['cup'] . ", ?)");
	$sql->bind_param("s",$_POST['name']);
	$sql->execute();
	$query = "SELECT iID FROM FantasyDB ORDER BY iID DESC LIMIT 1";
	$sql = $DB->query($query);
	while ($row = $sql->fetch_assoc()){
		$id = $row['iID'];
	}
	$row2s = explode(",",$_POST['players']);
	$start = 1;
	foreach($row2s as $row2){
		if($row2 == 'b'){
			$start = 0;
		} else {
			switch(substr($row2,0,1)){
				case "c":
					$cap = 2;
					$row2 = substr($row2,1);
					break;
				case "v":
					$cap = 1;
					$row2 = substr($row2,1);
					break;
				default:
					$cap = 0;
			}
			$query = "INSERT INTO FantasyPDB (bStart,iFFID,iPlayerID,iCap) VALUES($start, $id,$row2,$cap)";
			$DB->query($query);
		}
	}
} elseif(isset($_GET['wiki'])){

	$query = "SELECT DISTINCT(CAST(dUTCTime as DATE)) AS 'ddate' FROM `MatchDB` WHERE sRound like 'Group%' AND iCupID=$cup ORDER BY ddate";
	$sql = $DB->query($query);
	$groupDays = array();
	$groupDaysC = 0;
	$tempArr = array();
	while($row = $sql->fetch_assoc()){
		if(count($tempArr)){
			$tempArr[] = $row['ddate'];
			$groupDays[$groupDaysC] = $tempArr;
			$tempArr = array();
			$groupDaysC++;
		} else {
			$tempArr[] = $row['ddate'];
		}
	}


	$sql = $DB->query("SELECT * FROM FantasyDB WHERE iCupID=$cup ORDER BY iID");
	echo "<plaintext>";
	$list = array();
	while($ff = $sql->fetch_assoc()){
		$start = array();
		$startOrder = array();
		$bench = array();
		$benchOrder = array();
		$cap = 0;
		$vice = 0;
		$id = $ff['iID'];
		$name = $ff['sName'];
		$sql2 = $DB->query("SELECT * FROM FantasyPDB INNER JOIN PlayerDB ON FantasyPDB.iPlayerID = PlayerDB.iID INNER JOIN RosterOrderLookUp ON PlayerDB.sRegPos = RosterOrderLookUp.sPos WHERE iFFID = $id ORDER BY bStart DESC, iOrder, sName");
		$total = 0;
		echo "
<div class='toccolours mw-collapsible mw-collapsed' style='width:720px'>
'''$name'''
<div class='mw-collapsible-content'>
{{sq ff start}}";
		while($ffP = $sql2->fetch_assoc()){
			switch($ffP['sRegPos']){
				case "GK":
					$pos = "GK";
					break;
				case "LB":
				case "CB":
				case "SW":
				case "SB":
				case "RB":
					$pos = "DEF";
					break;
				case "DMF":
				case "CMF":
				case "SMF":
				case "LMF":
				case "RMF":
				case "AMF":
					$pos = "MID";
					break;
				case "LWF":
				case "RWF":
				case "SS":
				case "CF":
					$pos = "FWD";
					break;
			}
			switch($ffP['sMedal']){
				case "Gold":
					$med = 3;
					break;
				case "Silver":
					$med = 2;
					break;
				case "Bronze":
					$med = 1;
					break;
				default:
					$med = 0;
					break;
			}
			if($ffP['bStart'] == 1){
				$start[$ffP['iPlayerID']] = array(0,-99,$pos,0,$med,$ffP['sRegPos'],$ffP['sTeam'],$ffP['sName']);
				$startOrder[] = $ffP['iPlayerID'];
			} else {
				$bench[$ffP['iPlayerID']] = array(0,-99,$pos,-99,$med,$ffP['sRegPos'],$ffP['sTeam'],$ffP['sName']);
				$benchOrder[] = $ffP['iPlayerID'];
			}
			if ($ffP['iCap']==1)
				$vice = $ffP['iPlayerID'];
			if ($ffP['iCap']==2)
				$cap = $ffP['iPlayerID'];
		}
		foreach($groupDays as $days){
			$capP = false;
			$viceP = false;
			foreach($start as $player=>$arr){
				$start[$player][1] = -99;
			}
			foreach($bench as $player=>$arr){
				$bench[$player][1] = -99;
				$bench[$player][3] = -99;
			}
			$sql2 = $DB->query("SELECT * FROM MatchDB WHERE iCupID=$cup AND bVoided = 1 AND dUTCTime BETWEEN '" . $days[0] . " 00:00:00' AND '" . $days[1] . " 23:59:59' ORDER BY dUTCTime");
			while($match = $sql2->fetch_assoc()){
				$sql3 = $DB->query("SELECT * FROM PerformanceDB WHERE iMatchID=" . $match['iID']);
				while($perf = $sql3->fetch_assoc()){
					if(isset($start[$perf['iPlayerID']]))
						$start[$perf['iPlayerID']][1] = $perf['iFF'] * 1;
					if(isset($bench[$perf['iPlayerID']]))
						$bench[$perf['iPlayerID']][1] = $perf['iFF'] * 1;
				}
				foreach($start as $player=>$arr){
					if($player == $cap && $start[$player][1] > -99 && !$capP){
						$start[$player][1] *= 2;
						$capP = true;
					}
				}
				foreach($bench as $player=>$arr){
					if($player == $cap && $bench[$player][1] > -99 && !$capP){
						$bench[$player][1] *= 2;
						$capP = true;
					}
				}
			}
			foreach($start as $player=>$arr){
				if($arr[1] == -99){
					foreach($bench as $player2=>$arr2){
						if($arr2[3] == -99 && $arr[2] == $arr2[2] && $arr2[4] <= $arr[4]){
							$bench[$player2][3] = $bench[$player2][1];
							break;
						}
					}
				} else {
					if(!$capP && $player == $vice && !$viceP){
						$arr[1] *= 2;
						$viceP = true;
					}
					$start[$player][0] += $arr[1];
				}
			}
			foreach($bench as $player=>$arr){
				$bench[$player][1] = $arr[3];
				if($bench[$player][1] > -99){
					if(!$capP && $player == $vice && !$viceP){
						$bench[$player][1] *= 2;
						$viceP = true;
					}
					$bench[$player][0] += $bench[$player][1];
				}
			}
		}



		foreach($startOrder as $i){
			echo "
{{sq ff ";
			if($start[$i][4] == 3)
				echo "gold ";
			if($start[$i][4] == 2)
				echo "silver ";
			if($start[$i][4] == 1)
				echo "bronze ";
			if($start[$i][4] == 0)
				echo "start ";
			echo "player |team=" . $start[$i][6] . " |pos=" . $start[$i][5] . " |name=" . $start[$i][7];
			if ($i == $vice)
				echo " {{vice-captain}}";
			if ($i == $cap)
				echo " {{captain}}";
			echo " |lastscore=0 |totalscore=" . $start[$i][0] . " }}";
			$total += $start[$i][0];
			//print_r($start[$i]);
		}
		echo "
{{sq ff mid}}";
		foreach($benchOrder as $i){
			echo "
{{sq ff ";
			if($bench[$i][4] == 3)
				echo "gold ";
			if($bench[$i][4] == 2)
				echo "silver ";
			if($bench[$i][4] == 1)
				echo "bronze ";
			echo "player |team=" . $bench[$i][6] . " |pos=" . $bench[$i][5] . " |name=" . $bench[$i][7];
			if ($i == $vice)
				echo " {{vice-captain}}";
			if ($i == $cap)
				echo " {{captain}}";
			echo " |lastscore=0 |totalscore=" . $bench[$i][0] . " }}";
			$total += $bench[$i][0];
		}
		echo "
{{sq ff end}}</div>
</div>";
	$list[$name] = $total;
	}
	arsort($list);
	$count = 0;
	foreach($list as $name=>$points){
		$count++;
		echo "
	|-
|  align='center' | <b>$count</b>
|  align='center' | [[File:increase.png]] $count
|  align='left' | $name
|  align='right' |  $points";
	}

} elseif(isset($_GET['string'])){
	$query = "SELECT * FROM FantasyDB WHERE iCupID = $cup ORDER BY iID";
	$sql = $DB->query($query);
	while ($row = $sql->fetch_assoc()){
		$id = $row['iID'];
		echo $row['sName'] . "<br>";
		$query = "SELECT * FROM FantasyPDB INNER JOIN PlayerDB ON FantasyPDB.iPlayerID = PlayerDB.iID INNER JOIN RosterOrderLookUp ON PlayerDB.sRegPos = RosterOrderLookUp.sPos WHERE iFFID = $id ORDER BY bStart DESC, iOrder, sName";
		$b = 0;
		$sql2 = $DB->query($query);
		while($row2 = $sql2->fetch_assoc()){
			if($row2['iCap']==1)
				echo "v";
			if($row2['iCap']==2)
				echo "c";
			if($row2['bStart']==0 && $b == 0){
				echo "b,";
				$b = 1;
			}
			echo $row2['iPlayerID'] . ",";
		}
		echo "<br>";
	}

}
?>
<form action='wiki.php' method='post'>
	Name <input name='name'><br>
	Players <input name='players'><br>
	Cup <input name='cup' value=39><br>
	<input type='submit'>
</form>