info.php

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

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

$comm = $_GET["comm"];

$conn = mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db($dbname);
if ($comm) {
	$query = "SELECT * FROM `USERS` where id='$uid'";
	$result = mysql_query($query)
	or die("<br>Invalid query: $query\n<BR>\n" . mysql_error());
	$row = mysql_fetch_array($result);
	$email = $row['email'];
	$new_hash=md5($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());
	$fetch_em = mysql_fetch_array($result);
	$numrows = mysql_num_rows($result);
	if($numrows != "0") $invited=1;

	$member=0;
	
	$query = "SELECT * FROM COMM WHERE name = '$comm'";
	$result = mysql_query($query)
	or die("<br>Invalid query: $query\n<BR>\n" . mysql_error());
	$row = mysql_fetch_array($result);
	$idcomm = $row['id'];

	$query = "SELECT * FROM MEMB WHERE id = '$uid' AND id1 = '$idcomm'";
	$result = mysql_query($query)
	or die("<br>Invalid query: $query\n<BR>\n" . mysql_error());
	$fetch_em = mysql_fetch_array($result);
	$numrows = mysql_num_rows($result);
	if($numrows != "0") $member=1;

	$query = "SELECT * FROM COMM WHERE name = '$comm' AND uname_admin = '$user_name'";
	$result = mysql_query($query)
	or die("<br>Invalid query: $query\n<BR>\n" . mysql_error());
	$fetch_em = mysql_fetch_array($result);
	$numrows = mysql_num_rows($result);
	if($numrows != "0") $admin=1;

	$query = "SELECT ip_num FROM MEMB WHERE id = '$uid' AND id1 = '$idcomm' AND confirmed = 1";
	$result = mysql_query($query)
	or die("<br>Invalid query: $query\n<BR>\n" . mysql_error());
	$row1 = mysql_fetch_array($result);
	$ip_host = $row1['ip_num'];
	
	//mysql_close($conn);

echo "		<div id=\"maincontent\">
			<div class=\"item\">
				<h2 class=\"title\">.: Community: ".$row['name']." :.</h2>";

	if ($row['status']==0) {
		echo "This community is suspended.<br>";
		exit();
	}

	if (($row['type_vpn']==CRYPT) && ($member!=1) && ($invited!=1)) {
		echo "This community is private and you are not a member of it.<br>";
		exit();
	}
if ($member==1) echo "<p align=\"left\"><b>You are a current member of this Community!</b></p>";	
else echo "<p align=\"left\"><b>You are not a member of this Community yet!</b></p>"; 
if ($invited==1) echo "<p align=\"left\"><b>You got invitation, press the botton \"Join Me\" to join!</b></p>";	
echo "<ul>
<li>Description: ".$row['description']."<br>";
if ($member==1) {
	echo "Your IP: ".$ip_host."<br>
	Subnet: ".$row['subnet']."<br>
	Netmask: ".$row['netmask']."<br>
	FileName Key: ".$row['file_key']."<br>
	IP/Host server: ".$row['host_srv']."<br>
	Port server: ".$row['port_srv']."<br>
	Total User: ".$row['tot_usr']."<br>";
	if ($row['type_comm']==NOTPUB) echo "Community Type: Private<br>";
	else echo "Community Type: Pubblic<br>";
	if ($row['type_vpn']==CRYPT) echo "Authentication: Shared Key<br>
	Key: HIDE<br>";
	else echo "Authentication: NONE<br>";
	echo "Maximum Users: ".$row['max_usr']."<br>";
	//	echo "Community Administrator: ".$row['uname_admin']."</li>";
}

// get conf
if ($member==1) {
?>
<form method="get" action="make_archive.php" name="insertForm">
<input type="hidden" name="idcomm" value="<?echo $idcomm?>">
<li><p align="left">Get OpenVPN config file: <input type="radio" value="zip" name="ext" checked>&quot;ZIP&quot; <input type="radio" value="tgz" name="ext">&quot;TAR.GZ&quot; <input type="submit" value="Get" /></p></li>
</form>
<?
}

// invite someone
if ((($row['type_vpn']=='CRYPT') && ($admin==1)) || ($row['type_vpn']=='NOTCRYPT')) {
?>
<form method="get" action="add_member.php" name="insertForm">
<input type="hidden" name="idcomm" value="<?echo $idcomm?>">
<li><p align="left">Invite Friend: <input type="text" name="email" onfocus="clearText(this)" value="write friend's email" value size="30" maxlength="30" />	<input type="submit" value="Send Invite" /></p></li>
</form>
<?
}

// join
if (($invited==1) && ($member==0)) {
?>
<form method="get" action="memb_confirm.php" name="insertForm">
<input type="hidden" name="email" value="<?echo $email?>">
<input type="hidden" name="idcomm" value="<?echo $idcomm?>">
<input type="hidden" name="hash" value="<?echo $new_hash?>">
<li><input type="submit" value="Join Me" /></p></li>
</form>
<?
}
elseif (($row['type_vpn']=='NOTCRYPT') && ($member==0)) {
?>
<form method="get" action="be_member.php" name="insertForm">
<input type="hidden" name="idcomm" value="<?echo $idcomm?>">
<li><input type="submit" value="Join Me" /></p></li>
</form>
<?
}

// ujoin
// if (($member==1) && ($admin!=1))

echo "</ul>
			</div>
		</div>";
}
include('foot.php');
?>