query("SELECT * FROM {$table_name}"); //submit new if (!file_exists('vpn')) { mkdir('vpn', 511, true); } if (isset($_POST['submit'])) { Submit('sub_new', $db, $table_name); echo ""; } //delete row if (isset($_GET['delete'])) { Submit('sub_del', $db, $table_name); echo ""; } function Submit($sub_type, $db, $table_name){ if ($sub_type == 'sub_new') { $target_dir = 'vpn/'; $target_file = basename($_FILES['fileToUpload']['name']); $gtg = 1; $ft = strtolower(pathinfo($target_file, PATHINFO_EXTENSION)); $file_path = (isset($_SERVER['HTTPS']) && ($_SERVER['HTTPS'] !== 'off') ? 'https' : 'http') . '://' . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . '/vpn/'; if (file_exists($target_dir .$target_file)) { unlink($target_dir .$target_file); } if ($_POST['type'] == 'file') { if ($_FILES["fileToUpload"]["size"] > 500000) { echo '

Sorry, your file is too large.

'; $gtg = 0; } if ($ft != 'ovpn') { echo '

Sorry, only OVPN files are allowed.

'; $gtg = 0; } if ($gtg != 0) { if (move_uploaded_file($_FILES['fileToUpload']['tmp_name'], $target_dir .$target_file)) { $file_name = htmlspecialchars(basename($_FILES['fileToUpload']['name'])); } $stmt = $db->prepare("INSERT INTO $table_name (vpn_country, vpn_file_name, username, password) VALUES (?,?,?,?)"); $stmt->bindParam(1, $_POST['vpn_country']); $stmt->bindParam(2, $file_name); $stmt->bindParam(3, $_POST['username']); $stmt->bindParam(4, $_POST['password']); $stmt->execute(); } } if ($_POST['type'] == 'url') { $path = pathinfo($_POST['ovpn_url']); $ovpn_in = file_get_contents($_POST['ovpn_url']); file_put_contents($target_dir.'/'.$path['basename'], $ovpn_in); $file_name = $path['basename']; $stmt = $db->prepare("INSERT INTO $table_name (vpn_country, vpn_file_name, username, password) VALUES (?,?,?,?)"); $stmt->bindParam(1, $_POST['vpn_country']); $stmt->bindParam(2, $file_name); $stmt->bindParam(3, $_POST['username']); $stmt->bindParam(4, $_POST['password']); $stmt->execute(); } }else if ($sub_type == 'sub_del') { $arr = $db->query("SELECT * FROM {$table_name} WHERE id=".sanitize($_GET['delete'])); $del = $arr->fetchArray(); $ftd = $del['vpn_file_name']; $ftd = 'vpn/' . $ftd; unlink($ftd); $stmt = $db->prepare('DELETE FROM '.$table_name.' WHERE id=?'); $stmt->bindParam(1, sanitize($_GET['delete'])); $stmt->execute(); } } ?>

OVPN

Upload OVPN

Location

Select OVPN Source

OVPN URL

OVPN File

Only input user/pass if your App has the VPN mod otherwire it wont work

Embedded Username

Embedded Password

OVPN's

New OVPN

fetchArray()) {?>

Index	Location	File Name	Username	Password	Delete