exec("CREATE TABLE IF NOT EXISTS boxbrvpn(id INTEGER PRIMARY KEY,vpn_country TEXT ,vpn_config TEXT,vpn_file_name TEXT)"); $sql = "SELECT COUNT(id) AS total FROM boxbrvpn"; $result = $db1->query($sql); $rownew = $result->fetchArray(); $totaleview = $rownew["total"]; $total_pages = ceil($rownew["total"] / $results_per_page); $res1 = $db1->query("SELECT * FROM boxbrvpn ORDER by id DESC LIMIT " . $start_from . ", " . $results_per_page); if (isset($_GET["delete"])) { $res1 = $db1->query("SELECT * FROM boxbrvpn WHERE id=" . $_GET["delete"]); $row_del = $res1->fetchArray(); $file_to_delete = $row_del["vpn_file_name"]; $file_to_delete = "vpn/" . $file_to_delete; unlink($file_to_delete); $db1->exec("DELETE FROM boxbrvpn WHERE id=" . $_GET["delete"]); $db1->close(); $msg = "Deleted, OVPN Stored File."; header("Location: vpn.php?messageE=" . $msg); } require "includes/header.php"; echo "\n
\n
\n
\n
\n
\n
\n \n"; if (isset($_GET["messageA"])) { echo "

" . $_GET["messageA"] . "

"; } if (isset($_GET["messageE"])) { echo "

" . $_GET["messageE"] . "

"; } if (isset($_GET["messageS"])) { echo "

" . $_GET["messageS"] . "

"; } echo "
\n \n
\n
\n\t\t\t\t\t\t\t
\n \t\t\t\t

  Virtual Private Network

\n \t\t\t
\n
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t \t\t\t\t\t\t\n \t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\n\t\t\t\n\t\t\t\t\n\t\t\t\t \n \n\t\t\t\t \n \n \n"; while ($row1 = $res1->fetchArray()) { $id = $row1["id"]; $vpn_country = $row1["vpn_country"]; $vpn_config = $row1["vpn_file_name"]; $vpn_country = "./assets/images/flags/" . strtolower($vpn_country) . ".png"; echo " \n \n"; echo " " . "\n"; echo " " . "\n"; echo " " . "\n"; echo "\t\t\t\t\n\t\t\t\n"; } echo "\t\t\t
CountryFile NameDelete
\"image\"/" . $vpn_config . "
\n\t\t
\n"; if ($results_per_page < $totaleview) { for ($i = 1; $i <= $total_pages; $i++) { echo "Page " . $i . " "; } } echo "\n\n


"; require "includes/functions.php"; echo "\n"; ?>