You donot have a rite to approve users";
exit();
}
//extracting user information
$query = "SELECT * FROM users where username=\"$accountid\"";
$result = sqlite3_query($handle, $query) or die("Error in query: ".sqlite3_error($handle));
if (($row = sqlite3_fetch_array($result)) == '') {
echo "
Not a valid account id
";
exit();
}
$name = $row["name"];
$email = $row["email"];
$website = $row["website"];
$desc = $row["description"];
if($row["approved"] == "true") {
$query = "SELECT * FROM approval where approved=\"$accountid\"";
$result = sqlite3_query($handle, $query) or die("Error in query: ".sqlite3_error($handle));
$row = sqlite3_fetch_array($result);
echo " Already $accountid is approved by ".$row["approvedby"]."...
";
exit();
}
?>