function lvfs_admin_remove($db, $auth_master, $auth_vendor) { $success = True; $uri = 'result.php?'; # check auth key if (!lvfs_check_auth_master($db, $auth_master)) { $success = False; $uri = $uri . 'authkey=False&'; } # only disable if we passed all tests if ($success == True) { $query = "UPDATE users SET state = 0 WHERE guid = ?;"; if (!($stmt = $db->prepare($query))) { die("failed to prepare: " . $db->error); } $stmt->bind_param("s", $auth_vendor); if (!$stmt->execute()) { die("failed to execute: " . $stmt->error); } $stmt->close(); } return $uri . 'result=' . $success; }
function lvfs_admin_remove($db, $auth_master, $auth_vendor, $downloaddir) { $success = True; $uri = 'result.php?'; # check auth key if (!lvfs_check_auth_master($db, $auth_master)) { $success = False; $uri = $uri . 'authkey=False&'; } # check vendor key exists if (!lvfs_check_exists($db, $auth_master)) { $success = False; $uri = $uri . 'authkey=False&'; } # delete user if ($success == True) { $query = "DELETE FROM users WHERE guid = ?;"; if (!($stmt = $db->prepare($query))) { die("failed to prepare: " . $db->error); } $stmt->bind_param("s", $auth_vendor); if (!$stmt->execute()) { die("failed to execute: " . $stmt->error); } $stmt->close(); } # delete files $query = "SELECT filename FROM firmware WHERE vendor_key = ?;"; if (!($stmt = $db->prepare($query))) { die("failed to prepare: " . $db->error); } $stmt->bind_param("s", $auth_vendor); if (!$stmt->execute()) { die("failed to execute: " . $stmt->error); } $stmt->bind_result($fn); while ($stmt->fetch()) { unlink($downloaddir . $fn); } $stmt->close(); # delete history if ($success == True) { $query = "DELETE FROM firmware WHERE vendor_key = ?;"; if (!($stmt = $db->prepare($query))) { die("failed to prepare: " . $db->error); } $stmt->bind_param("s", $auth_vendor); if (!$stmt->execute()) { die("failed to execute: " . $stmt->error); } $stmt->close(); } return $uri . 'result=' . $success; }