All the code
<?php
ini_set('display_errors', 1);
error_reporting(E_ALL);
require_once('./forum/SSI.php');
require_once('./mysql_connect.php');
$username = $context['user']['name'];
$userteamcheck = "SELECT * FROM smf_members WHERE memberName='$username'" or trigger_error("Query: $userteamcheck\n<br />MySQL Error: ". mysql_error());
$userteamcheck2 = mysql_query ($userteamcheck);
while ($userteamcheck3 = mysql_fetch_assoc($userteamcheck2)) {
$teamnamme = $userteamcheck3['team'];
$ownercheck = "SELECT * FROM aacl_team WHERE teamname='$teamnamme'" or trigger_error("Query: $ownercheck\n<br />MySQL Error: ". mysql_error());
$ownercheck2 = mysql_query ($ownercheck);
while ($ownercheck3 = mysql_fetch_assoc($ownercheck2)) {
$ownerofteam = $ownercheck3['owner'];
$eu2 = $ownercheck3['eu2'];
$eu4 = $ownercheck3['eu4'];
$eu6 = $ownercheck3['eu6'];
$eu8 = $ownercheck3['eu8'];
$eu12 = $ownercheck3['eu12'];
$aeu2 = $ownercheck3['aeu2'];
$aeu4 = $ownercheck3['aeu4'];
$aeu6 = $ownercheck3['aeu6'];
$aeu8 = $ownercheck3['aeu8'];
$aeu12 = $ownercheck3['aeu12'];
$ladderstatus2 = $ownercheck3['eu2p'];
$ladderstatus4 = $ownercheck3['eu4p'];
$ladderstatus6 = $ownercheck3['eu6p'];
$ladderstatus8 = $ownercheck3['eu8p'];
$ladderstatus12 = $ownercheck3['eu12p'];
$id = $ownercheck3['id'];
if ($ownerofteam != $username){
echo 'You are not leader/captain of this team. <BR><BR><FORM><INPUT TYPE="button" VALUE="Back" onClick="history.go(-1);return true;"> </FORM><BR><BR>
';
require_once('includes/footer.html');
exit();
}else{
/////////////////////////////////// Team Mangament ////////////////////////////////////////////
if ($eu2 == 0){
$seu2 = '<font color=\'red\'>Not Joined</font>';
}else{
$seu2 = "$ladderstatus2 Points";
}
if ($eu4 == 0){
$seu4 = '<font color=\'red\'>Not Joined</font>';
}else{
$seu4 = "$ladderstatus4 Points";
}
if ($eu6 == 0){
$seu6 = '<font color=\'red\'>Not Joined</font>';
}else{
$seu6 = "$ladderstatus6 Points";
}
if ($eu8 == 0){
$seu8 = '<font color=\'red\'>Not Joined</font>';
}else{
$seu8 = "$ladderstatus8 Points";
}
if ($eu12 == 0){
$seu12 = '<font color=\'red\'>Not Joined</font>';
}else{
$seu12 = "$ladderstatus12 Points";
}
}}}
/////////////////////////////////////////////////////// Challenge //////////////////////////////
if(isset($_POST['challengebutton2'])){
$ladderd = $_POST['ladderd'];
$ladder = in_array($ladderd, array('eu2', 'eu4', 'eu6', 'eu8'))
? 'a' . $ladderd
: 'aeu12';
$p = 'p';
$currentpointsp = "$ladderd$p";
$fetchpoints = "SELECT * FROM aacl_team WHERE teamname='$teamnamme'" or trigger_error("Query: $fetchpoints\n<br />MySQL Error: ". mysql_error());
$fetchpoints2 = mysql_query ($fetchpoints);
while ($fetchpoints3 = mysql_fetch_assoc($fetchpoints2)) {
$currentpoints = $fetchpoints3["$currentpointsp"];
echo "
<form action=\"manage_team.php\" method=\"post\">
<table align='center' border='2' bordercolor='005DB3'>
<tr>
<td background='Untitled.gif'><center>Select a team</center></td>
</tr>
<tr>
<td bgcolor=\"FFFFFF\">Team:
<select name=\"cteam\">";
$fetchmorepoints = "SELECT * FROM aacl_team WHERE $ladder='0' AND $currentpointsp <= $currentpoints AND teamname != '$teamnamme'" or trigger_error("Query: $fetchmorepoints\n<br />MySQL Error: ". mysql_error());
$fetchmorepoints2 = mysql_query ($fetchmorepoints);
while ($fetchmorepoints3 = mysql_fetch_assoc($fetchmorepoints2)) {
$morepointteam = $fetchmorepoints3['teamname'];
$morepointteamid = $fetchmorepoints3['id'];
echo "<option value='" . $morepointteamid . "'>" . $morepointteam . "</option>";
}
$fetchlesspoints = "SELECT * FROM aacl_team WHERE $ladder='0' AND $currentpointsp >= $currentpoints AND teamname != '$teamnamme'" or trigger_error("Query: $fetchlesspoints\n<br />MySQL Error: ". mysql_error());
$fetchlesspoints2 = mysql_query ($fetchlesspoints);
while ($fetchlesspoints3 = mysql_fetch_assoc($fetchlesspoints2)) {
$lesspointteam = $fetchlesspoints3['teamname'];
$lesspointteamid = $fetchlesspoints3['id'];
echo "<option value='" . $lesspointteamid . "'>" . $lesspointteam . "</option>";
}
echo" </select>
<div align=\"center\"><input type=\"submit\" name=\"finishchallenge\" value=\"Finish\" /> </div>
<input type=\"hidden\" name=\"finishchallenge2\" valuev=\"TRUE\" />
</td>
</tr>
</table>
</form>
";
require_once('includes/footer.html');
//$query2 = "INSERT INTO aacl_comms (teamname, username, text, datetime) VALUES ($teamnamme, $username, $randomtime, $randomdate)";
// $result2 = mysql_query ($query2) or trigger_error("Query: $query1\n<br />MySQL Error: " . mysql_error());
}}
////////////////////////////
///////// Finish is pressed
////////////////////////////
//$teamchallengedropdown = $_POST['cteam'];
if(isset($_POST['finishchallenge2'])){
srand((double)microtime()*1000000);
$arry_txt=preg_split("/--NEXT--/",join('',file("maps.txt")));
$randommap = $arry_txt[rand(0,sizeof($arry_txt)-1)];
srand((double)microtime()*1000000);
$arry_txt=preg_split("/--NEXT--/",join('',file("times.txt")));
$randomtime = $arry_txt[rand(0,sizeof($arry_txt)-1)];
$randomdate = date('l j F Y', strtotime('+' . rand(4,10) . ' days'));
$query1 = "INSERT INTO aacl_match (`team`, `ladder`, `time`, `date`, `map`) VALUES ('$teamnamme', '$ladder', '$randomtime', '$randomdate', '$randommap')";
$result1 = mysql_query ($query1) or trigger_error("Query: $query1\n<br />MySQL Error: " . mysql_error());
$dbid = (mysql_insert_id());
echo "
completed
<BR><BR><FORM><INPUT TYPE=\"button\" VALUE=\"Back\" onClick=\"history.go(-2);return true\"> </FORM>
";
require_once('includes/footer.html');
exit();
}
?>
<table align="left" border="2" bordercolor="005DB3">
<tr>
<td background="Untitled.gif"><center>EU ladder managment</center></td>
</tr>
<tr>
<td bgcolor="FFFFFF">
<b>EU 2v2:</b> <?php if($eu2 == 0){ echo"<a href='jeu2.php?id=$id'>Join Ladder</a>"; } else { echo"<a href='qeu2.php?id=$id'>Quit Ladder</a>"; }?><BR>
<b>EU 4v4:</b> <?php if($eu4 == 0){ echo"<a href='jeu4.php?id=$id'>Join Ladder</a>"; } else { echo"<a href='qeu4.php?id=$id'>Quit Ladder</a>";}?><BR>
<b>EU 6v6:</b> <?php if($eu6 == 0){ echo"<a href='jeu6.php?id=$id'>Join Ladder</a>"; } else { echo"<a href='qeu6.php?id=$id'>Quit Ladder</a>"; }?><BR>
<b>EU 8v8:</b> <?php if($eu8 == 0){ echo"<a href='jeu8.php?id=$id'>Join Ladder</a>"; } else { echo"<a href='qeu8.php?id=$id'>Quit Ladder</a>"; }?><BR>
<b>EU 12v12:</b> <?php if($eu12 == 0){ echo"<a href='jeu12.php?id=$id'>Join Ladder</a>"; } else { echo"<a href='qeu12.php?id=$id'>Quit Ladder</a>"; }?>
<BR>
</td>
</tr>
<table align="right" border="2" bordercolor="005DB3">
<tr>
<td background="Untitled.gif"><center>Your team ladder status</center></td>
</tr>
<tr>
<td bgcolor="FFFFFF"><b>EU 2v2:</b> <?php echo "$seu2"; ?>
<BR>
<b>EU 4v4:</b> <?php echo "$seu4"; ?>
<BR>
<b>EU 6v6:</b> <?php echo "$seu6"; ?>
<BR>
<b>EU 8v8:</b> <?php echo "$seu8"; ?>
<BR>
<b>EU 12v12:</b> <?php echo "$seu12"; ?>
</td>
</tr>
</table>
<form action="manage_team.php" method="post">
<table align="center" border="2" bordercolor="005DB3">
<tr>
<td background="untitled.gif"><center>Challenge Team</center></td>
</tr>
<tr>
<td bgcolor="FFFFFF">Ladder: <select name="ladderd">
<?php if($eu2 == 1 && $aeu2 == 0){
echo '
<option value="eu2">EU 2v2</option>
'; }
if($eu4 == 1 && $aeu4 == 0){
echo '
<option value="eu4">EU 4v4</option>
'; }
if($eu6 == 1 && $aeu6 == 0){
echo '
<option value="eu6">EU 6v6</option>
'; }
if($eu8 == 1 && $aeu8 == 0){
echo '
<option value="eu8">EU 8v8</option>
'; }
if($eu12 == 1 && $aeu12 == 0){
echo '
<option value="eu12">EU 12v12</option>
'; }
?>
</select>
<BR> <div align="center"><input type="submit" name="challengebutton" value="Next" /> </div>
<input type="hidden" name="challengebutton2" value="TRUE" />
</td>
</tr>
</table>
</form>
<BR><BR><BR><BR><BR><BR><BR>
<?php
require_once('includes/footer.html');
?>