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;
}
