thecase Posted August 26, 2008 Share Posted August 26, 2008 Hi, This is my code <?php require_once('./forum/SSI.php'); if ($context['user']['is_guest']) { echo 'You need to be logged in.'; exit(); } else { 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 //////////////////////////////////////////// $seu2 = ($eu2 == 0) ? '<font color=\'red\'>Not Joined</font>' : "$ladderstatus2 Points"; $seu4 = ($eu4 == 0) ? '<font color=\'red\'>Not Joined</font>' : "$ladderstatus4 Points"; $seu6 = ($eu6 == 0) ? '<font color=\'red\'>Not Joined</font>' : "$ladderstatus6 Points"; $seu8 = ($eu8 == 0) ? '<font color=\'red\'>Not Joined</font>' : "$ladderstatus8 Points"; $seu12 = ($eu12 == 0) ? '<font color=\'red\'>Not Joined</font>' : "$ladderstatus12 Points"; }}} /////////////////////////////////////////////////////// Challenge ////////////////////////////// if(isset($_POST['challengebutton2'])){ $ladderd = $_POST['ladderd']; $ladder = in_array($ladderd, array('eu2', 'eu4', 'eu6', 'eu8')) ? 'a' . $ladderd : 'aeu12'; if (isset ($ladder)) $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'); }} ///////// Finish is pressed //////////////////////////// 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')); $teamchallengedropdown = $_POST['cteam']; $query1 = "INSERT INTO aacl_match (`team`, `ladder`, `time`, `date`, `map`, `teamchallenged`) VALUES ('$teamnamme', '$ladder', '$randomtime', '$randomdate', '$randommap', '$teamchallengedropdown')"; $result1 = mysql_query ($query1) or trigger_error("Query: $query1\n<br />MySQL Error: " . mysql_error()); $dbid = (mysql_insert_id()); //$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()); 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'); ?> The problem is when I check the query1 ($query1) to see if it all worked the ladder is blank so $ladder is not working bellow the if(isset($_POST['finishchallenge2'])){ But if I echo $ladder above it works fine. Any ideas? Thanks Link to comment https://forums.phpfreaks.com/topic/121413-carry-variable-over-after-if/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.