query('SELECT * ' . "\r\n\t\t\t\t" . ' FROM vpn ' . "\r\n\t\t\t\t" . ' WHERE id=\'' . $_GET['update'] . '\''); $row1 = $res1->fetchArray(); $id = $row1['id']; $vpn_country = $row1['vpn_country']; $vpn_state = $row1['vpn_state']; $vpn_config = $row1['vpn_config']; $vpn_status = $row1['vpn_status']; $username = $row1['username']; $password = $row1['password']; if (isset($_POST['submit'])) { $db1->exec('UPDATE vpn SET vpn_country=\'' . $_POST['vpn_country'] . '\', ' . "\r\n\t\t\t\t\t\t\t\t" . 'vpn_state=\'' . $_POST['vpn_state'] . '\',' . "\r\n\t\t\t\t\t\t\t\t" . 'vpn_config=\'' . $_POST['vpn_config'] . '\',' . "\r\n\t\t\t\t\t\t\t\t" . 'vpn_status=\'' . $_POST['vpn_status'] . '\',' . "\r\n\t\t\t\t\t\t\t\t" . 'username=\'' . $_POST['username'] . '\',' . "\r\n\t\t\t\t\t\t\t\t" . 'password=\'' . $_POST['password'] . '\'' . "\r\n\t\t\t\t\t\t" . ' WHERE ' . "\r\n\t\t\t\t\t\t\t" . ' id=\'' . $_POST['id'] . '\''); $db1->close(); header('Location: vpn.php'); } include 'includes/header.php'; $id = $row1['id']; $vpn_country = $row1['vpn_country']; $vpn_state = $row1['vpn_state']; $vpn_config = $row1['vpn_config']; $vpn_status = $row1['vpn_status']; $user = $row1['username']; $pass = $row1['password']; echo ' ' . "\n"; echo '

' . "\n"; echo "\n"; if (isset($_GET['message'])) { echo $_GET['message']; } if (isset($_GET['m'])) { echo $_GET['m']; } echo ' ' . "\n"; echo '

Update VPN

' . "\n"; echo ' ' . "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo '

Update VPN Details

' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo "\t\t\t\t" . ' ' . "\t" . '

' . "\n"; echo '

' . "\n"; echo ' ' . "\n"; echo ' Country Code' . "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo ' ' . "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo ' ' . "\n"; echo ' State / Region ' . "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo ' ' . "\n"; echo ' Status' . "\n"; echo ' ' . "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo ' ' . "\n"; echo ' URL' . "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo ' ' . "\n"; echo ' Username' . "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo ' ' . "\n"; echo ' Password' . "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo "\n"; echo '

' . "\n"; echo ' ' . "\n"; echo '

' . "\n"; echo '

' . "\n"; echo '

'; echo '

'; echo '

'; echo '

'; include 'includes/footer.php'; require 'includes/appsnscripts.php'; echo '' . "\n"; ?>