Location: PHPKode > projects > MyVPN OpenVPN Web Config > http_doc/admin/info_user.php
<?
include('secret_include.php');
include('../lib/conf.php');

$user_name = $_GET["user_name"];
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>

<head>
<title>Info page of user <? echo $row['user_name'] ?></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" type="text/css" href="style.css">
</head>

<body>

<div align="center">
	<div id="header-space">
		<div id="header">
			Admin Pages</div>
	</div>
	<div id="links-space">
		<a href="index.php">Home</a> &middot; <a href="users.php">Users</a> &middot; <a href="comm.php">Community</a> &middot; <a href="logout.php">LogOut</a></div>
	<div id="content-space">
		<div class="news-header">
			This are all community where <? echo $row['user_name'] ?> is subscribed:</div>
		<div class="entry">
			<div align="center">
				<table id="table1" border="0" cellpadding="5" width="600">
<?
	$conn = mysql_connect($dbhost,$dbuser,$dbpass);
	mysql_select_db($dbname,$conn);

	$query ="SELECT COMM.id,COMM.name,COMM.description,COMM.tot_usr,COMM.max_usr,COMM.uname_admin,COMM.status FROM USERS,MEMB,COMM WHERE USERS.id=MEMB.id AND MEMB.id1=COMM.id AND USERS.user_name='$user_name'";
	$result = mysql_query($query)
	or die("<br>Invalid query: $query\n<BR>\n" . mysql_error());
	while ($row = mysql_fetch_array($result)) {
?>					<tr>
						<td colspan="2"><hr></td>
					</tr>
					<tr>
						<td rowspan="3">Id: <? echo $row['id'] ?><br />
				Name: <? echo $row['name'] ?><br />
				Description: <? echo $row['description'] ?><br />
				Total Users: <? echo $row['tot_usr'] ?><br />
				Max Users: <? echo $row['max_usr'] ?><br />
				Admin's UserName: <? echo $row['uname_admin'] ?><br />
				Community status: <?
				if ($row['status'] == "1") echo "Enable";
				else echo "Disable"; ?></td>
						<td><a href="info_comm.php?name=<? echo $row['name'] ?>">
						<img src="img/info.gif" border="0" height="16" width="16"> 
						Which users</a></td>
					</tr>
					<tr>
						<td><a href="status.php?table=COMM&id=<? echo $row['id'] ?>&status=0">
						<img src="img/drop.gif" border="0" height="16" width="16"> 
						Disable</a></td>
					</tr>
					<tr>
						<td><a href="status.php?table=COMM&id=<? echo $row['id'] ?>&status=1">
						<img src="img/accept.gif" border="0" height="18" width="18"> 
						Enable</a></td>
					</tr>
<?
		}
mysql_close($conn);
?>				</table>
			</div>
		</div>
	</div>
	<div id="foot-space"> &copy; MyVPN Admin</div>
</div>

</body>

</html>
Return current item: MyVPN OpenVPN Web Config