GameProfile.php | searchcode

/View/GameProfile.php

https://bitbucket.org/onlinechessportal/onlinechessgameportal
PHP | 686 lines | 611 code | 68 blank | 7 comment | 21 complexity | 53b712bfa39303248f782e1051198d7e MD5 | raw file
Possible License(s): LGPL-2.1

<?php



require '../Model/Connect.php';

require '../Control/RegisterLogic.php';

require '../Control/LoginLogic.php';

require '../Control/SendNotification.php';

require '../Control/CreateClubLogic.php';

require '../Control/DBCreate.php';



	ob_start();

	$UserNm=$_SESSION['username'];

    $Role = $_SESSION['role'];  

	$PlayerID= $_SESSION['playerID'];  

    if(isset($_GET['id'])) {

        $SearchName = $_GET['id'];//full name

        $SearchID = GetSearchID($SearchName);//user name

		$Player2ID=GetPlayerID2($SearchID);

    } else {

        $SearchID = $UserNm;

		$Player2ID=GetPlayerID2($SearchID);

    }

    

    function GetSearchID($SearchName) {

        $GetID = "SELECT mp_username FROM memberprofile WHERE mp_fullname = '".$SearchName."' ";

        $ResultID = mysql_query($GetID);

    	if ($ResultID) {

    		$rows = mysql_num_rows($ResultID); 

    		while($info = mysql_fetch_assoc( $ResultID)) {

    			return $info['mp_username'];

    		}

		}

    }

	

	function GetPlayerID2($SearchID) {

		$GetPID = "SELECT us_id FROM user WHERE us_username = '".$SearchID."' ";

        $ResultPID = mysql_query($GetPID);

    	if ($ResultPID) {

    		$rows = mysql_num_rows($ResultPID); 

    		while($info = mysql_fetch_assoc( $ResultPID)) {

    			return $info['us_id'];

    		}

		}

	}

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title>Online Chess Portal </title>

<!-- CSS Files -->

<link rel="stylesheet" href="css/preview.css" />

<link rel="stylesheet" href="css/screen.css" />

<link href="css/reset.css" rel="stylesheet" type="text/css" />

<link href="css/style.css" rel="stylesheet" type="text/css" />

<link rel="stylesheet" type="text/css" href="css/superfish.css" media="screen" />

<style type="text/css">

.sf-sub-indicator {

	behavior: url(css/iepngfix.htc)

}

;

</style>



<style type="text/css">



.accordion {

	width: 100%;

	border-bottom: solid 1px #c4c4c4;

}

.accordion h3 {

	background: #e9e7e7 url(images/arrow-square.gif) no-repeat right -51px;

	padding: 7px 15px;

	margin: 0;

	font: bold 120%/100% Arial, Helvetica, sans-serif;

	border: solid 1px #c4c4c4;

	border-bottom: none;

	cursor: pointer;

}

.accordion h3:hover {

	background-color: #e3e2e2;

}

.accordion h3.active {

	background-position: right 5px;

}

.accordion p {

	background: #f7f7f7;

	margin: 0;

	padding: 10px 15px 20px;

	border-left: solid 1px #c4c4c4;

	border-right: solid 1px #c4c4c4;

}

</style>



<link rel="stylesheet" href="css/legend.css" />

<!-- End of CSS Files -->

<!-- Javascript Files -->

<script type="text/javascript" src=".javascript/image.js"></script>

<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js" type="text/javascript"></script>

<script type="text/javascript" src="javascript/jquery.cycle.all.js"></script>

<script type="text/javascript" src="javascript/superfish.js"></script>

<script type="text/javascript" src="javascript/dd.min.js"></script>

<script type="text/javascript" src="javascript/popup-window.js"></script>

<script type="text/javascript" src="javascript/jquery-1.6.2.js"></script>

<script type="text/javascript" src="javascript/jquery.form.js"></script>

<script type="text/javascript" src="js/jquery.js"></script>



<script type="text/javascript">

$(document).ready(function(){

	

	$(".accordion h3:first").addClass("active");

	$(".accordion p:not(:first)").hide();



	$(".accordion h3").click(function(){

		$(this).next("p").slideToggle("slow")

		.siblings("p:visible").slideUp("slow");

		$(this).toggleClass("active");

		$(this).siblings("h3").removeClass("active");

	});



});

</script>



<script>

	$(function() {

		$( "#accordion" ).accordion({

			collapsible: true

		});

	});

	</script>



<script type="text/javascript">

//<![CDATA[



		$(document).ready(function()

		{

			$('#slider').cycle({

					fx: 'shuffle',

					speed: 2000,

					timeout: 4000

			});



			var ie6 = $.browser.msie && /MSIE 6.0/.test(navigator.userAgent);

		

			if (!ie6)

			{

				$('ul.sf-menu').superfish({ 

					delay:       1000,                            // one second delay on mouseout 

					animation:   {opacity:'show',height:'show'},  // fade-in and slide-down animation 

					speed:       'normal'                         // faster animation speed 

				}); 			

			}

			else

			{

				DD_belatedPNG.fix('#topbar, img, a, .commentbubble, .infobubble, .view-all, #category-picture1, #category-picture2, #category-picture3, #footer');

			}

		}); 

		//]]>



	</script>	

<!-- End of Javascript Files -->

</head>

<body>

<?php

if(!empty($SearchID)) {

    $Sql = "SELECT * FROM memberprofile where mp_username = '$SearchID'";

    } else {

$Sql = "SELECT mp_imagename FROM memberprofile where mp_username = '$UserNm'";

} 



if ($Result = mysql_query($Sql)) {

	//echo $UserNm;

	$Rows = mysql_num_rows($Result);

	if ($Rows > 0) {

		while($Info = mysql_fetch_assoc( $Result )) {

			$Imagename=$Info['mp_imagename'];

		}

	}

}

	

//$_POST['lblFullName']=$FulName;

?>



<!-- Wrapper -->

<div id="wrapper">

	<div id="topbar">

		<div id="topbar"> <img src="images/icon1.png" alt="logo" width="42" height="41" class="logo" id='test' /><img src="images/logo.gif" alt="logo" width="322"  height="41" class="logo1" id='test' /> 

		

			<div id="secnav">

				<ul>

				<li class="noimg"> <a href="../Control/LogoutLogic.php?Reason=Normal">SIGN OUT</a> </li>

			</ul>

			</div>

			

			<div class="menu">

				<ul class="sf-menu">

				

        <li> <a  class="on" href="Home_Login.php">HOME</a></li>	

        			

        <li> <a href="MemberProfile.php"><?php 

				$result = mysql_query("SELECT mp_fullname FROM memberprofile WHERE mp_username='".$_SESSION['username']."' ");

				$row = mysql_fetch_array($result);

				echo $row['mp_fullname']?></a> </li>

                

		<li> <a href="SearchClub.php">Clubs</a> </li>

        		

        <li> <a href="Inbox.php">Messages</a> </li>

			</ul>

		

			</div> </div><!-- menu end-->

	

	<div id="content" >

	<div class="froms">

    <form id="formMain" action="" method="post">

    

	</strong><div id="apDiv1">

	  <label for="txtNick"></label>

	</div>

	<div align="center" style="background-image:url(images/mygameprof1.jpg);width:100%;height:150px")">

	  <div align="center">

	    <h5> <font size="25" color="#000000">

	      <?php if($SearchID==$UserNm) {

						$result = mysql_query ("SELECT `mp_fullname` FROM `memberprofile` WHERE `mp_username`= '".$_SESSION['username']."' ");

						$row = mysql_fetch_array($result);

						echo $row ['mp_fullname'];

				} else {

					echo $SearchName;

				}?>

	     </font><img src="UserImages/<?php echo $Imagename ?>" alt="" name="image1" width="150px" height="150px" id="image1" align="right"/></h5>

	  </div>

	</div>

    </p>

    <p> <label class="content"><strong>

          <h1>

          <h1>Game Summary

          </h1>

          </h1>

          <hr/></strong></label>

     </p>

    <table border="2" width="100%">

     

      <tr>

        <td colspan="2"></td>

        <td><h2><strong>             <label class="content">           </strong> </h2>          <div align="center">            

            <h2><strong><font size="5" >White</font></strong></h2>

          </div>          </td>

        <td><h2><strong>             <label class="content">           </strong> </h2>          <div align="center">            

          <h2><strong><font size="5" >Black</font></strong></h2>

        </div></td>

        <td>&nbsp;</td>

      </tr>

      <tr>

        <td width="21%">&nbsp;</td>

        <td width="25%"><h2><strong><font size="5" >             <br>

          <label class="content"><font size="5" ><strong>Played Total Games</strong></font></label>

        </font></td>

        <td width="15%"><div align="center">          <strong><font size="5" color="#990000">             <br>

            <?php 

		$result = mysql_query ("SELECT COUNT(`ga_whiteplayer`) AS cnt FROM `games`  WHERE `ga_whiteplayer`= $Player2ID ");

		$row = mysql_fetch_array($result);

		echo $row ['cnt']?>           

            <br>

          </font></strong>        </div></td>

        <td width="15%"><div align="center">          <strong><font size="5" color="#990000">             <br>

            <?php 

		$result = mysql_query ("SELECT COUNT(`ga_blackplayer`) AS bcnt FROM `games` WHERE `ga_blackplayer`=$Player2ID ");

		$row = mysql_fetch_array($result);

		echo $row ['bcnt']?>           

            <br>

          </font></strong>        </div></td>

        <td width="24%">&nbsp;</td>

      </tr>

      <tr>

        <td width="21%">&nbsp;</td>

        <td width="25%"><h2><strong><font size="5" >             <br>

          <label class="content"><font size="5" ><strong>Win Games</strong></font></label>

        </font></td>

        <td width="15%"><div align="center">          <strong><font size="5" color="#990000">             <br>

            <?php 

		$result = mysql_query ("SELECT COUNT(`ga_whiteplayer`) AS cnt FROM  `games` WHERE `ga_whiteplayer`=$Player2ID AND `ga_gamemessage`='checkMate' AND  `ga_messagefrom` =  'white'");

		$row = mysql_fetch_array($result);

		echo $row ['cnt']?>           

            <br>

          </font></strong>        </div></td>

        <td width="15%"><div align="center">          <strong><font size="5" color="#990000">             <br>

            <?php 

		$result = mysql_query ("SELECT COUNT(`ga_blackplayer`) AS cnt FROM  `games` WHERE `ga_blackplayer` =$Player2ID AND `ga_gamemessage`='checkMate' AND  `ga_messagefrom` =  'black'");

		$row = mysql_fetch_array($result);

		echo $row ['cnt']?>           

            <br>

          </font></strong>        </div></td>

        <td width="24%">&nbsp;</td>

      </tr>

      <tr>

        <td width="21%">&nbsp;</td>

        <td width="25%"><h2><strong><font size="5" >             <br>

          <label class="content"><font size="5" ><strong>Lose Games</strong></font></label>

        </font></td>

        <td width="15%"><div align="center">          <strong><font size="5" color="#990000">             <br>

            <?php 

		$result = mysql_query ("SELECT COUNT(`ga_whiteplayer`) AS wcnt FROM `games` WHERE `ga_whiteplayer` =$Player2ID AND `ga_gamemessage`='checkMate' AND  `ga_messagefrom` =  'black'");

		$row = mysql_fetch_array($result);

		//echo $row;

		echo $row ['wcnt']?>           

            <br>

          </font></strong>        </div></td>

        <td width="15%"><div align="center">          <strong><font size="5" color="#990000">             <br>

            <?php 

		$result = mysql_query ("SELECT COUNT(`ga_blackplayer`) AS cnt FROM `games` WHERE `ga_blackplayer`=$Player2ID AND `ga_gamemessage`='checkMate' AND  `ga_messagefrom` =  'white'");

		$row = mysql_fetch_array($result);

		echo $row['cnt']?>           

            <br>

          </font></strong>        </div></td>

        <td width="24%">&nbsp;</td>

      </tr>

      <tr>

        <td width="21%">&nbsp;</td>

        <td width="25%"><h2><strong><font size="5" >             <br>

          <label class="content"><font size="5" ><strong>Draw Games</strong></font></label>

        </font></td>

        <td width="15%"><div align="center">          <strong><font size="5" color="#990000">             <br>

            <?php 

		$result = mysql_query ("SELECT COUNT(`ga_whiteplayer`) AS cnt FROM  `games` WHERE  `ga_whiteplayer`=$Player2ID AND `ga_gamemessage`='draw' AND  `ga_messagefrom` =  'white'");

		$row = mysql_fetch_array($result);

		echo $row['cnt']?>           

            <br>

          </font></strong>        </div></td>

        <td width="15%"><div align="center">          <strong><font size="5" color="#990000">             <br>

            <?php 

		$result = mysql_query ("SELECT COUNT(  `ga_blackplayer` ) AS cnt FROM  `games` WHERE  `ga_blackplayer`=$Player2ID AND `ga_gamemessage`='draw' AND  `ga_messagefrom` =  'black'");

		$row = mysql_fetch_array($result);

		echo $row['cnt']?>           

            <br>

          </font></strong>        </div></td>

        <td width="24%">&nbsp;</td>

      </tr>

      <tr>

        <td width="21%">&nbsp;</td>

        <td width="25%"><h2><strong><font size="5" >             <br>

          <label class="content"><font size="5" ><strong>Invited Games</strong></font></label>

        </font></td>

        <td width="15%"><div align="center">          <strong><font size="5" color="#990000">             <br>

            <?php 

		$result = mysql_query ("SELECT COUNT(`ga_whiteplayer`) AS cnt FROM  `games` WHERE  `ga_whiteplayer`=$Player2ID AND `ga_gamemessage`='playerInvited' AND  `ga_messagefrom` =  'white'");

		$row = mysql_fetch_array($result);

		echo $row['cnt']?>           

            <br>

          </font></strong>        </div></td>

        <td width="15%"><div align="center">          <strong><font size="5" color="#990000">             <br>

            <?php 

		$result = mysql_query ("SELECT COUNT(  `ga_blackplayer` ) AS cnt FROM  `games` WHERE  `ga_blackplayer`=$Player2ID AND `ga_gamemessage`='playerInvited' AND  `ga_messagefrom` =  'black'");

		$row = mysql_fetch_array($result);

		echo $row['cnt']?>           

            <br>

          </font></strong>        </div></td>

        <td width="24%">&nbsp;</td>

      </tr>

      <tr>

        <td width="21%">&nbsp;</td>

        <td width="25%"><h2><strong><font size="5" >             <br>

          <label class="content"><font size="5" ><strong>Received Game Invitations</strong></font></label>

        </font></td>

        <td width="15%"><div align="center">          <strong><font size="5" color="#990000">             <br>

            <?php 

		$result = mysql_query ("SELECT COUNT(`ga_whiteplayer`) AS cnt FROM  `games` WHERE  `ga_whiteplayer`=$Player2ID AND `ga_gamemessage`='playerInvited' AND  `ga_messagefrom` =  'black'");

		$row = mysql_fetch_array($result);

		echo $row['cnt']?>           

            <br>

          </font></strong>        </div></td>

        <td width="15%"><div align="center">          <strong><font size="5" color="#990000">             <br>

            <?php 

		$result = mysql_query ("SELECT COUNT(  `ga_blackplayer` ) AS cnt FROM  `games` WHERE  `ga_blackplayer`=$Player2ID AND `ga_gamemessage`='playerInvited' AND  `ga_messagefrom` =  'white'");

		$row = mysql_fetch_array($result);

		echo $row['cnt']?>           

            <br>

          </font></strong>        </div></td>

        <td width="24%">&nbsp;</td>

      </tr>

      <tr>

        <td width="21%">&nbsp;</td>

        <td width="25%"><h2><strong><font size="5" >             <br>

          <label class="content"><font size="5" ><strong>Recieved Invitations Declined</strong></font></label>

        </font></td>

        <td width="15%"><div align="center">          <strong><font size="5" color="#990000">             <br>

            <?php 

		$result = mysql_query ("SELECT COUNT(`ga_whiteplayer`) AS cnt FROM  `games` WHERE  `ga_whiteplayer`=$Player2ID AND `ga_gamemessage`='inviteDeclined' AND  `ga_messagefrom` =  'black'");

		$row = mysql_fetch_array($result);

		echo $row['cnt']?>           

            <br>

          </font></strong>        </div></td>

        <td width="15%"><div align="center">          <strong><font size="5" color="#990000">             <br>

            <?php 

		$result = mysql_query ("SELECT COUNT(  `ga_blackplayer` ) AS cnt FROM  `games` WHERE  `ga_blackplayer`=$Player2ID AND `ga_gamemessage`='inviteDeclined' AND  `ga_messagefrom` =  'white'");

		$row = mysql_fetch_array($result);

		echo $row['cnt']?>           

            <br>

          </font></strong>        </div></td>

        <td width="24%">&nbsp;</td>

      </tr>

      <tr>

        <td width="21%">&nbsp;</td>

        <td width="25%"><h2><strong><font size="5" >             <br>

          <label class="content"><font size="5" ><strong>Sent Invitations Declined</strong></font></label>

        </font></td>

        <td width="15%"><div align="center">          <strong><font size="5" color="#990000">             <br>

            <?php 

		$result = mysql_query ("SELECT COUNT(`ga_whiteplayer`) AS cnt FROM  `games` WHERE  `ga_whiteplayer`=$Player2ID AND `ga_gamemessage`='inviteDeclined' AND  `ga_messagefrom` =  'white'");

		$row = mysql_fetch_array($result);

		echo $row['cnt']?>           

            <br>

          </font></strong>        </div></td>

        <td width="15%"><div align="center">          <strong><font size="5" color="#990000">             <br>

            <?php 

		$result = mysql_query ("SELECT COUNT(  `ga_blackplayer` ) AS cnt FROM  `games` WHERE  `ga_blackplayer`=$Player2ID AND `ga_gamemessage`='inviteDeclined' AND  `ga_messagefrom` =  'black'");

		$row = mysql_fetch_array($result);

		echo $row['cnt']?>           

            <br>

          </font></strong>        </div></td>

        <td width="24%">&nbsp;</td>

      </tr>

    </table>

    <p>

    </p>

    

    <table border="0" width="100%">

      <tr>

        <td colspan="2" style="background-color:#6FF"><h5 align="center"><strong><font size="10">Winning Rate </font></strong><strong><font size="10">

          <?php 

		$result = mysql_query ("SELECT (

       (SELECT COUNT(`ga_gameid`) FROM games WHERE (`ga_whiteplayer`=$Player2ID AND `ga_gamemessage`='checkMate' AND `ga_messagefrom`='white') OR (`ga_blackplayer` = $Player2ID AND `ga_gamemessage`='checkMate' AND `ga_messagefrom`='black'))/

       (SELECT COUNT(`ga_gameid`) FROM games WHERE `ga_whiteplayer`=$Player2ID OR `ga_blackplayer` = $Player2ID))*100 as winningrate");

		$row = mysql_fetch_array($result);

		echo $row ['winningrate']?>

          </font></strong><strong><font size="10">%</font></strong></h5></td>

      </tr>

      <tr>

        <td width="49%">&nbsp;</td>

        <td width="51%">&nbsp;</td>

      </tr>

    </table>

    <table border="0" width="100%">

      <tr>

        <td><label class="content"><strong>

          <h1><hr/>

            </h1>

          <h1>Game History</h1>

          <hr/></strong></label>

          <table border="0" width="100%">

            <tr>

              <td colspan="2">&nbsp;</td>

              <td colspan="3" width="75%">

                <div>

                  <h2><font color="#0000CC">As White</font><hr/></h2>

                  <?php

                  $Result = mysql_query("SELECT `ga_gameid`,  `ga_blackplayer`,`mp_fullname`,`ga_gamemessage`, `ga_messagefrom`, `ga_datecreated` FROM `games` ,`user`,`memberprofile` WHERE `ga_whiteplayer`=$Player2ID AND `ga_blackplayer`=`user`.`us_id` AND `user`.`us_username`=`memberprofile`.`mp_username` ");

				  echo "<table width='100%'  table border='2' style='border:#999999'>";

				  $QueryNumRows = mysql_num_rows($Result);

				  if ($QueryNumRows == 0) {

        				echo '<script language="javascript">alert("No History as white player")</script>';

    			  } else {?>

                  <tr><th>Game ID</th>	

                    <th>Black Player</th>

                    <th>Status</th>

                    <th>Status From</th>

                    <th>Date</th>

                    </tr>

                    

                    <?php

					  while($row = mysql_fetch_assoc($Result)){ 

					      $ga_gameid=$row['ga_gameid'];

						  $mp_fullname=$row['mp_fullname'];

						  $ga_gamemessage=$row['ga_gamemessage'];

						  $ga_messagefrom=$row['ga_messagefrom'];

						  $ga_datecreated=$row['ga_datecreated']; 

						  

						echo "<tr>";

						  echo "<td>" .$ga_gameid . "<input name='from' type='hidden' value=". $ga_gameid ." /></td>";

						  echo "<td>" .$mp_fullname . "<input name='message' type='hidden' value=". $mp_fullname ." /></td>";

						  echo "<td>" .$ga_gamemessage . "<input name='from' type='hidden' value=". $ga_gamemessage ." /></td>";

						  echo "<td>" .$ga_messagefrom . "<input name='message' type='hidden' value=". $ga_messagefrom ." /></td>";

						  echo "<td>" .$ga_datecreated . "<input name='message' type='hidden' value=". $ga_datecreated ." /></td>";

						echo "</tr>";

					   }

				  }

					   echo "</table>";

				  

                  ?>

                    <!--------------------------------------------------------------------------------------------------->

                    

                    

                    <h2>&nbsp;</h2>

                  <h2>&nbsp;</h2>

                  <h2><font color="#0000CC">As Black</font>

                    <hr/>

                    </h2>

                  <?php

                  $Result = mysql_query("SELECT `ga_gameid`,  `ga_whiteplayer`,`mp_fullname`, `ga_gamemessage`, `ga_messagefrom`, `ga_datecreated` FROM `games`,`user`,`memberprofile` WHERE `ga_blackplayer`=$Player2ID AND `ga_whiteplayer`=`user`.`us_id` AND `user`.`us_username`=`memberprofile`.`mp_username` ");

				  echo "<table width='100%'  table border='2' style='border:#999999'>";

				  $QueryNumRows = mysql_num_rows($Result);

				  if ($QueryNumRows == 0) {

        				echo '<script language="javascript">alert("No History as white player")</script>';

    			  } else {?>

                  <tr><th>Game ID</th>	

                    <th>White Player</th>

                    <th>Status</th>

                    <th>Status From</th>

                    <th>Date</th>

                    </tr>

                    <?php

					  while($row = mysql_fetch_assoc($Result)){ 

					      $ga_gameid=$row['ga_gameid'];

						  $mp_fullname=$row['mp_fullname'];

						  $ga_gamemessage=$row['ga_gamemessage'];

						  $ga_messagefrom=$row['ga_messagefrom'];

						  $ga_datecreated=$row['ga_datecreated'];

						  //$formatteddt=date("Y-m-d",$ga_datecreated);

						  //echo $ga_datecreated;

						  

						  

                        echo "<tr>";

						  echo "<td>" .$ga_gameid . "<input name='from' type='hidden' value=". $ga_gameid ." /></td>";

						  echo "<td>" .$mp_fullname . "<input name='message' type='hidden' value=". $mp_fullname ." /></td>";

						  echo "<td>" .$ga_gamemessage . "<input name='from' type='hidden' value=". $ga_gamemessage ." /></td>";

						  echo "<td>" .$ga_messagefrom . "<input name='message' type='hidden' value=". $ga_messagefrom ." /></td>";

						  echo "<td>" .$ga_datecreated . "<input name='message' type='hidden' value=". $ga_datecreated ." /></td>";

						echo "</tr>";

					   }

				  }

					   echo "</table>";

				  

                  ?>    

                    

                    </div></td>

              <td colspan="2">&nbsp;</td>

              </tr>

            </table></td>

      </tr>

    </table>

    </form></div>

	</div>

	

	<div id="sidebar">	

    <li> 

          <!--------------------------------------------------------------->

          <h2>Play </h2>

          <ul>

            <li class="noimg"> <a href="thumnailtest.php" >Play Game</a> </li>          

          </ul>

     </li>		

	<?php if($Role != 'Member') { ?>    

     <li> 

          <!--------------------------------------------------------------->

           <h2>Tournaments </h2>

          <ul>

                  <!-- <li class="noimg"> <a href="CreateTourna.php" >Create Tournaments</a> </li>-->

                  <li class="noimg"> <a class="content" href="#" onclick="popup_show('popup_createTournament', 'popup_drag1', 'popup_exit1', 'screen-center', 0, 0);">Create New Tour</a> </li>

              

          

          </ul>

     </li>

     <?php } ?>

     

     <li> 

          <!--------------------------------------------------------------->

          <h2>Recent Tournaments </h2>

          <ul>

              <?php

            $sql=" SELECT to_tournamentname,to_id,to_creator FROM tournament";

            $result =mysql_query($sql);

            while ($data=mysql_fetch_assoc($result)){

            ?>

             <li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a class="content" href="ViewTourna.php?TourID=<?php echo $data['to_id'] ?>&Creator=<?php echo $data['to_creator'] ?> "><?php echo $data['to_tournamentname']?></a></li>

            <?php } ?>

              

          

          </ul>

     </li>

        

	

	</div>

	

	

  <!-- topbar-->

  <div class="clear"></div>

 <div id="footers"> 

      



<div style="float:right"><div class="fotterlast">

	<a href="#" title="About Us">About Us</a>

	|

	<a href="#" title="Terms of Service">Terms of Service</a>

	|

	<a href="#" title="Privacy Statement">Privacy</a>

	|

	<a href="Contact.php" title="Contac Us">Contac Us</a>

	</div></div>



	  <div style="float:Left"><div class="fotterlastdesing">Design by SEP_WE_05 Team.</div></div>

				

	</div>



</div></div>



<!-- ***** Popup Window **************************************************** -->

<!--create Tournament-->



<div class="sample_popup"     id="popup_createTournament" style="display: none;">



<div class="menu_form_header" id="popup_drag">

<img class="menu_form_exit"   id="popup_exit" src="images/form_exit.png" alt="exit" />

&nbsp;&nbsp;&nbsp;Create New Private Tournament

</div>



<div class="menu_form_body">

<form action="" method="post">

	   <div>&nbsp;</div>

       <table>

           <tr>

               <td><div align="left"><font color="#000000" class="content" >Tournament ID&nbsp;</font></td>

               <td><input type="text" name="TourID" /></div></td>

           </tr>

           <tr>

               <td><div align="left"><font color="#000000" class="content">Tournament Name&nbsp;</font></td>

               <td><input type="text" name="TourName" /></div></td>

           </tr>

           <tr>

               <td><div align="left"><font color="#000000" class="content">From&nbsp;</font></td>

               <td><input type="text" name="TourFrom" /></div></td>

           </tr>

           <tr>

               <td><div align="left"><font color="#000000" class="content">To&nbsp;</font></td>

               <td><input type="text" name="TourTo" /></div></td>

           </tr>

           <tr>

               <td><div align="left"><font color="#000000" class="content">Tournament Type&nbsp;</font></td>

               <td><input type="text" name="TourType" /></div></td>

           </tr>

           <tr>

               <td><div align="left"><font color="#000000" class="content">Max Paticipants&nbsp;</font></td>

               <td><input type="text" name="TourMax" /></div></td>

           </tr>

       </table>

            <div >&nbsp;</div>

			

	         <div align="left"></div>

	         <div align="center"></div>

	         <div >&nbsp;

	           <div align="right">

			   <label>

	           <input type="submit" name="Submit" value="Create" class="Buttonview" />

	           </label>

	           

	           </div>

	         </div>		 

	   </form>

</form>

</div> </div>



<!--Edit Nick-->



<div class="sample_popup"     id="popup_editNick" style="display: none;">



<div class="menu_form_header" id="popup_drag1">

<img class="menu_form_exit"   id="popup_exit1" src="images/form_exit.png" alt="exit" />

&nbsp;&nbsp;&nbsp;Edit Nick Name

</div>



<div class="menu_form_body">

<form action="" method="post">

	   <div>&nbsp;</div>

       

            <div >&nbsp;</div>

			

	         <div align="left"></div>

	         <div align="center"></div>

	         <div >&nbsp;

	           <div align="right">

			   <label>

	           <input type="submit" name="Submit" value="Update" class="Buttonview" />

	           </label>

	           

	           </div>

	         </div>		 

	   </form>

</form>

</div> </div>

</body>

</html>