exec("CREATE TABLE IF NOT EXISTS store(id INTEGER PRIMARY KEY NOT NULL, sort_id INTEGER, added_date VARCHAR(50), description VARCHAR(50), icon VARCHAR(50), name VARCHAR(50), url VARCHAR(50), base64 VARCHAR(500), version VARCHAR(50), version_code VARCHAR(50), vidz VARCHAR(50))"); if ($db->querySingle('SELECT sort FROM users') === FALSE) { // False means the query failed $db->query("ALTER TABLE users ADD COLUMN sort text;"); $db->exec("UPDATE users SET sort='false' WHERE id='1'"); } if ($db->querySingle('SELECT sort_id FROM store') === FALSE) { // False means the query failed $db->query("ALTER TABLE store ADD COLUMN sort_id INTEGER;"); //echo $db->lastErrorMsg(); $rows = $db->query("SELECT id FROM store"); //echo $db->lastErrorMsg(); $rowid = array(); $i = 0; while($result = $rows->fetchArray()){ $rowid[$i]['sort_id'] = $result['id']; echo $rowid[$i]['sort_id']; $db->exec("UPDATE store SET sort_id='" . $rowid[$i]['sort_id'] . "' WHERE id='".$result['id']."' "); //echo $db->lastErrorMsg(); $i++; } } $db->exec("CREATE TABLE IF NOT EXISTS updates(id INTEGER PRIMARY KEY NOT NULL, version VARCHAR(50), version_code VARCHAR(50), url VARCHAR(50))"); //echo $db->lastErrorMsg(); if ($db->querySingle('SELECT version FROM updates WHERE id="1"') == NULL) { //echo '  False!  '; $db->exec("INSERT INTO updates(version,version_code,url) VALUES('2.2','22','http://www.google.com/')"); } //echo $db->lastErrorMsg(); $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"]) . '/apk/'; include ('includes/header.php'); ?>

Update Credentials