myaccount.php

vpn虚拟专用网络的一个开源搭建工具

<?php
include('login.php');
include('head.php');
include('lib/conf.php');

$conn = mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db($dbname);
$query = "SELECT * FROM `USERS` where id='$uid'";
$result = mysql_query($query)
or die("<br>Invalid query: $query\n<BR>\n" . mysql_error());
$rowA = mysql_fetch_array($result);
echo "		<div id=\"maincontent\">
			<div class=\"item\">
				<h2 class=\"title\">.: ".$rowA['name']." :.</h2>";
$new_hash=md5($rowA['email'].$hidden_hash_var);
$query = "SELECT * FROM `MEMB` where hash='$new_hash' AND confirmed='0'";
$result = mysql_query($query)
or die("<p align=\"left\">Invalid query: $query\n</p>\n" . mysql_error());
$rowCount = mysql_num_rows($result);
if ($rowCount != "0") echo "<p align=\"left\"><b>This is the list of communities that you have still to confirm:</b></p>
<ul>";
for($a=0;$a<$rowCount;$a++) {
	$row = mysql_fetch_array($result);
	$query1 = "SELECT * FROM `COMM` where id='".$row['id1']."'";
	$result1 = mysql_query($query1)
	or die("<p align=\"left\">Invalid query: $query1\n</p>\n" . mysql_error());
	$row1 = mysql_fetch_array($result1);
	print("<li><a href=\"index.php?pag=info&comm=".$row1['name']."\">".$row1['name']."</a></li>");
}
echo "</ul>";
$query = "SELECT * FROM `MEMB` where id='$uid' AND confirmed='1'";
$result = mysql_query($query)
or die("<p align=\"left\">Invalid query: $query\n</p>\n" . mysql_error());
$rowCount = mysql_num_rows($result);
if ($rowCount != "0") echo "<p align=\"left\"><b>This is the list of communities that member you are:</b></p>
<ul>";
for($a=0;$a<$rowCount;$a++) {
	$row = mysql_fetch_array($result);
	
	$admin=0;
	$query1 = "SELECT * FROM COMM WHERE id='".$row['id1']."' AND uname_admin = '$user_name'";
	$result1 = mysql_query($query1)
	or die("<br>Invalid query: $query\n<BR>\n" . mysql_error());
	$fetch_em = mysql_fetch_array($result1);
	$numrows = mysql_num_rows($result1);
	if($numrows != "0") $admin=1;

	$query2 = "SELECT * FROM `COMM` where id='".$row['id1']."'";
	$result2 = mysql_query($query2)
	or die("<p align=\"left\">Invalid query: $query1\n</p>\n" . mysql_error());
	$row1 = mysql_fetch_array($result2);
	echo "<li><a href=\"index.php?pag=info&comm=".$row1['name']."\">".$row1['name']."</a> ";
	if ($admin==1) echo "- Administrator";
	echo "</li>";
}
//mysql_close($conn);
echo "</ul>
			</div>
		</div>";
include('foot.php');
?>