<?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 * FROM FantasyDB WHERE iCupID = $cup ORDER BY iID";
	$sql = $DB->query($query);
	echo "<plaintext>";
	while ($row = $sql->fetch_assoc()){
		$name = $row['sName'];
		$id = $row['iID'];
		$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";
		echo "
<div class='toccolours mw-collapsible mw-collapsed' style='width:720px'>
'''$name'''
<div class='mw-collapsible-content'>
{{sq ff start}}";
		$sql2 = $DB->query($query);
		$bench = false;
		while($row2 = $sql2->fetch_assoc()){
			if ($row2['bStart'] == 0 && !$bench){
				$bench = true;
				echo "
{{sq ff mid}}";
			}
			echo "
{{sq ff ";
			if($row2['sMedal'])
				echo strtolower($row2['sMedal']) . " ";
			echo "player |team=" . $row2['sTeam'] . " |pos=" . $row2['sRegPos'] . " |name=" . $row2['sName'];

			$sql3 = $DB->query("SELECT * FROM PerformanceDB WHERE iPlayerID=" . $row2['iPlayerID']);
			$points = 0;
			$playedFull = false;
			$rating = 0;
			$motmr = 20;
			$played = false;
			$tempP = 0;
			while($performance = $sql3->fetch_assoc()){
				$tempP = 0;
				$sql3 = $DB->query("SELECT * FROM MatchDB WHERE iID=" . $performance['iMatchID']);
				$played = true;
				while($match = $sql3->fetch_assoc()){
					$sql4 = $DB->query("SELECT dRating FROM PerformanceDB WHERE iMatchID=" . $match['iID'] . " AND bMotM = 1");
					while ($motm = $sql4->fetch_assoc()){
						$motmr = $motm['dRating'];
					}
					$sql5 = $DB->query("SELECT * FROM EventDB INNER JOIN PlayerDB ON EventDB.iPlayerID = PlayerDB.iID WHERE iMatchID=" . $match['iID']);
					$ag = 0;
					$agd = 0;
					while($event = $sql5->fetch_assoc()){
						if ($event['iPlayerID'] == $row2['iPlayerID']){
							if($event['iType'] == 1 || $event['iType'] == 4){
								if($row2['iOrder'] >= 10){
									$tempP += 4; //4 points for a forward scoring a goal
								} else if ($row2['iOrder'] >= 5){
									$tempP += 5; //5 points for a midfielder scoring a goal
								} else {
									$tempP += 6; //6 points for a defender or goalkeeper scoring a goal
								}
							} else if ($event['iType'] == 2){
								$tempP += 3; //3 points for a goal assist
							} else if ($event['iType'] == 9){
								if($row2['iOrder'] > 1)
									$tempP -= 2; //-2 points for a missed penalty
							} else if ($event['iType'] == 10){
								if($row2['iOrder'] == 1 && $event['dRegTime'] >= $performance['iSubOn'] && $event['dRegTime'] <= $performance['iSubOff']){
									$tempP += 5; //5 points for a GK saving a penalty
								} else {
									$tempP -= 2; //-2 points for a saved penalty
								}
							} else if ($event['iType'] == 3){
								$tempP -= 2; //-2 points for an own goal
							} else if ($event['iType'] == 5){
								$tempP -= 1; //-1 point for a yellow card
							} else if ($event['iType'] == 6){
								$tempP -= 3; //-3 points for a straight red
							} else if ($event['iType'] == 8){
								$tempP -= 4; //-4 points for a red resulting from 2 yellows
							}
						}
						if ((($event['iType'] == 1 || $event['iType'] == 4) && $event['sTeam'] != $row2['sTeam']) || ($event['iType'] == 3 && $event['sTeam'] == $row2['sTeam'])){
							$ag++;
							if ($event['dRegTime'] >= $performance['iSubOn'] && $event['dRegTime'] <= $performance['iSubOff']){
								$agd++;
							}
						}
					}
				}
				if ($ag == 0){
					if ($row2['iOrder'] < 5){
						if ($performance['iSubOff'] - $performance['iSubOn'] >= 60){
							$tempP += 4; //4 points for a defender or goalkeeper p
						} else {
							$tempP += 3;
						}
					} else if ($row2['iOrder'] < 10 && $performance['iSubOff'] - $performance['iSubOn'] >= 60){
						$tempP +=1;
					}
				}
				if ($agd >= 2 && $row2['iOrder'] < 5){
					$tempP -= floor($agd / 2);
				}
				if ($performance['dRating'] > 0){
					$tempP += floor($performance['dRating'] - 4);
				}
				if ($performance['iSaves']>0){
					$tempP += floor($performance['iSaves'] / 2);
				}
				$rating = $performance['dRating'];
				if ($performance['bMotM']){
					$tempP += 3;
				} else if($rating >= $motmr){
					$tempP += 2;
				} else if($rating + 0.5 >= $motmr){
					$tempP += 1;
				}
				$points += $tempP;
			}
			if ($row2['iCap'] == 1)
				echo " {{vice-captain}}";
			if ($row2['iCap'] == 2)
				echo " {{captain}}";
			if ($row2['iCap'] > 0)
				$points *= 2;
			echo " |lastscore=$tempP |totalscore=$points }}";
		}
		echo "
{{sq ff end}}</div>
</div>";
	}
} 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>