Miscellany

<?php	require_once('../dbconnect.php');	require_once('functions.php');		$query = 'SELECT * FROM roster ORDER BY id ASC LIMIT 7';			if ($r = mysql_query ($query)) {		if ( $_SESSION['level_id'] < 2) {			print '';		} else {		}	print '<table width="564" border="0" cellspacing="0" cellpadding="0">			  <tr>				<td height="24" background="images/Decline_25.jpg"><table width="543" border="0" align="right" cellpadding="0" cellspacing="0">				  <tr>					<td width="417"><span class="newstitle">Roster  </span></td>					<td width="126"><span class="postedname">Counter-Strike1.6</span><span class="Postedby"> <img src="images/cs.jpg" width="19" height="18" align="absmiddle" /></span></td>					</tr>				</table></td>			  </tr>			  <tr>				<td background="images/Decline_23.jpg"><table style="text-align:center;width:564px;" border="0" align="center" cellpadding="0" cellspacing="0">				  <tr>					<td width="20" class="infotitle" style="text-align:right;">Co.</td>					<td width="90" class="infotitle">Nickname</td>					<td width="70" class="infotitle">Realname</td>					<td width="50" class="infotitle">Position</td>					<td width="124" class="infotitle">Steam_id</td>					<td width="24" class="infotitle">Profile</td>				  </tr>				  <tr>					<td colspan="5" align="center" valign="top"><table width="523" border="0" cellspacing="0" cellpadding="0">					  <tr>						<td height="10" class="Postedby">&nbsp;</td>						<td class="infostats">&nbsp;</td>						<td class="infostats">&nbsp;</td>						<td class="infostats">&nbsp;</td>						<td class="infostats">&nbsp;</td>					  </tr>';		if ( $_SESSION['level_id'] == 1) {			while ($row = mysql_fetch_array ($r)) {				print '          <tr>						            <form action="index.php?page=roster&id='. $id .'" method="post">									<td width="0" class="infostats" style="text-align:left;"><img src="images/Canada.gif" width="18" height="12" align="left" /></td>									<td width="90" class="infostats">'. $row['nickname'] .'</td>						            <td width="70" class="infostats">'. $row['real_name'] .'</td>						            <td width="50" class="infostats">'. $row['position'] .'</td>						            <td width="124" class="infostats">'. $row['steam_id'] .'</td>						            <td width="24" class="infostats"><a href="'. $row['profile'] .'">View</a></td>						          </tr>								  <tr>									<td><input name="edit" value="Edit" type="submit" /><input name="delete_roster" value="Delete" type="submit" /></td></form>								  </tr>								  <tr height="10"></tr>					';				if (isset ($_POST['delete_roster']) ) {					delete_roster($_GET['id']);					header("Location: index.php?page=roster");				}				if (isset ($_POST['edit']) ) {					edit_roster($row['id']);				}			}		} else {			while ($row = mysql_fetch_array ($r)) {				print '		          <tr>									<td width="20" class="infostats"><img src="images/Canada.gif" width="18" height="12" align="left" /></td>									<td width="90" class="infostats">'. $row['nickname'] .'</td>						            <td width="70" class="infostats">'. $row['real_name'] .'</td>						            <td width="50" class="infostats">'. $row['position'] .'</td>						            <td width="124" class="infostats">'. $row['steam_id'] .'</td>						            <td width="24" class="infostats"><a href="'. $row['profile'] .'">View</a></td>						          </tr>					';			}		}		print '						        </table></td>						        </tr>						    </table></td>						  </tr>						  <tr>						    <td><img src="images/Decline_24.jpg" width="564" height="7" /></td>						  </tr>					</table>			';		if ($_SESSION['level_id'] == 1) {					print '<br /><div align="right" style="margin-right:10px;"><form method="post" action="" ><input type="submit" value="Create New Player" name="roster_new" /></form></div>';		}				if (isset ($_POST['roster_new']) ) {			header("Location: index.php?page=admin+roster_new");		}			} else {		die(mysql_error());	}		mysql_close();	?>