vpn proses

<?php
session_start();
if($_SESSION['group_name'] <> 'Administrator'){
	echo '<meta http-equiv="Refresh" Content="0; URL=../../id/error">';
	exit;
}
?>

<?php

if ($_POST['submit']) {

	print_r($_POST);
	var_dump($_post);

	$nourut = $_POST['nourut'];
	$user_username = $_SESSION['user_username'];
	$name = $_POST['name'];
	$password = $_POST['password'];
	$profile = $_POST['profile'];
	$local = $_POST['local'];
	$remote = $_POST['remote'];
	$quotadownload = $_POST['quotadownload'];
	$quotaupload = $_POST['quotaupload'];
	$dateregistration = date('Y-m-d');
	$jangka = $_POST['jangka'];
	$dateend = date('Y-m-d', strtotime('+'.$jangka.' month', strtotime($dateregistration)));
	$billing_status = $_POST['billing_status'];

	require_once("../../connection.php");
	require_once('../../routeros_api.class.php');

	$tw_status_vpn = $db->prepare("SELECT * FROM tw_status_vpn ORDER BY status_vpn_id");
	$tw_status_vpn->execute();
	while($d = $tw_status_vpn->fetch(PDO::FETCH_ASSOC)){

		$API = new RouterosAPI();

		$API->debug = false;

		if ($API->connect($d['status_ip'], $d['status_login'], $d['status_password']

	)) {
			$API->comm("/ppp/secret/add", array(

				"name" => "$name",
				"password" => "$password",
				"profile" => "$profile",
				"limit-bytes-in" => "$quotadownload",
				"limit-bytes-out" => "$quotaupload",
				"disabled" => "no",

			));
	}
}

$tw_user_vpn = $db->prepare("UPDATE tw_user_vpn INNER JOIN tw_billing ON (tw_user_vpn.nourut = tw_billing.nourut) SET tw_user_vpn.user_username = :user_username, tw_user_vpn.name = :name, tw_user_vpn.password = :password, tw_user_vpn.profile = :profile, tw_user_vpn.local = :local, tw_user_vpn.remote = :remote, tw_user_vpn.quotadownload = :quotadownload, tw_user_vpn.quotaupload = :quotaupload, tw_user_vpn.dateregistration = NOW(), tw_user_vpn.dateend = :dateend, tw_user_vpn.jangka = :jangka, tw_billing.billing_status = :billing_status WHERE tw_user_vpn.nourut = :nourut AND tw_billing.nourut = :nourut");
$tw_user_vpn->BindParam(':nourut', $nourut);
$tw_user_vpn->BindParam(':user_username',$user_username);
$tw_user_vpn->BindParam(':name',$name);
$tw_user_vpn->BindParam(':password',$password);
$tw_user_vpn->BindParam(':profile',$profile);
$tw_user_vpn->BindParam(':local',$local);
$tw_user_vpn->BindParam(':remote',$remote);
$tw_user_vpn->BindParam(':quotadownload',$quotadownload);
$tw_user_vpn->BindParam(':quotaupload',$quotaupload);
$tw_user_vpn->BindParam(':dateend',$dateend);
$tw_user_vpn->BindParam(':jangka',$jangka);
$tw_user_vpn->BindParam(':billing_status',$billing_status);

$tw_user_vpn->execute();

var_dump($tw_user_vpn->errorInfo());
exit;

} else {
	echo "!!!";
}

?>