be_member.php

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

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

$idcomm = $_GET["idcomm"];

$conn = mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db($dbname);

$member=0;

$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 id = '$idcomm'";
$result = mysql_query($query)
or die("<br>Invalid query: $query\n<BR>\n" . mysql_error());
$row = mysql_fetch_array($result);

if (($row['type_comm']==PUB) && ($member==0)) {

	// ip_num generator
	$query ="SELECT * FROM `COMM` WHERE id='$idcomm'";
	$result=mysql_query($query)
	or die("<br>Invalid query: $query\n<BR>\n" . mysql_error());
	$row = mysql_fetch_array ($result);
	
	$ipnet = $row["subnet"];
	$mask = $row["netmask"];
	$host = $row["tot_usr"]+1;
	$ip = ip2long($ipnet);
	$nm = ip2long($mask);
	$nw = ($ip & $nm);
	$bc = $nw | (~$nm);
	$broadcast_addr = long2ip($bc);
	$ip_num=CalculateIPRange($ipnet, $broadcast_addr, $host);
	
	// joining
	$query = "SELECT `email` FROM `USERS` WHERE `user_name` LIKE '$user_name'";
	$result = mysql_query($query)
	or die("<br>Invalid query: $query\n<BR>\n" . mysql_error());
	$row = mysql_fetch_row ($result);
	$email = $row[0];
	$hash=md5($email.$hidden_hash_var);
	$query = "INSERT INTO `MEMB` (`id`, `id1`, `ip_num`, `confirmed`, `hash`) VALUES ('$uid', '$idcomm', '$ip_num', '1', '$hash');";
	mysql_query($query)
	or die("<br>Invalid query: $query\n<BR>\n" . mysql_error());
	
	//update the number of the subscribed users
	$query="UPDATE `COMM` SET tot_usr='$host' WHERE id='$idcomm'";
	mysql_query($query)
	or die("<br>Invalid query: $query\n<BR>\n" . mysql_error());
	//mysql_close($conn);
}	
redirect("index.php?pag=myaccount");
?>