exec("CREATE TABLE IF NOT EXISTS messages(id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, message VARCHAR(100), userid TEXT, status TEXT, expire TEXT)"); $db = new SQLite3('./api/vpn_config.db'); $db->exec("CREATE TABLE IF NOT EXISTS vpnconfig(id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, userid text, vpn_appid TEXT, vpn_country TEXT, vpn_state TEXT, vpn_config VARCHAR(150), vpn_status TEXT, auth_type TEXT, auth_embedded TEXT, username VARCHAR(150), password VARCHAR(150), vdate TEXT)"); $db = new SQLite3('./api/.db.db'); $res = $db->query("SELECT * FROM users WHERE id='1'"); $row = $res->fetchArray(); if (isset($_POST['submit'])) { $db->exec("UPDATE users SET username='" . $_POST['username'] . "', password='" . $_POST['password'] . "' WHERE id='1' "); session_start(); session_regenerate_id(); $_SESSION['loggedin'] = true; $_SESSION['name'] = $_POST['username']; header("Location: user_update.php?"); } $user = $row['username']; $pass = $row['password']; $lurl = (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] !== 'off' ? 'https' : 'http') . '://' . $_SERVER['HTTP_HOST'] . dirname($_SERVER["PHP_SELF"]) . '/api/'; $jsonData = file_get_contents("./api/main.json"); $arrayData = json_decode($jsonData, true); $replacementData = array('app' => array('backupurl' => $lurl, 'logurl' => $lurl)); $newArrayData = array_replace_recursive($arrayData, $replacementData); $newJsonData = json_encode($newArrayData, JSON_PRETTY_PRINT); file_put_contents("./api/main.json", $newJsonData); include ('includes/header.php'); ?>

Update Credentials