function addtoServer($time, $date, $location)
{
$status = isPublic();
$user = $_SESSION['user'];
mysql_query("INSERT INTO list(time_posted, date_posted, file_location, user, status) VALUES ('{$time}', '{$date}', '{$location}', '{$user}', '{$status}')") or die("Could not insert image into data base" . mysql_error());
}
$dbname = "dev";
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$error = false;
$error_message = "";
$data = json_decode(file_get_contents('php://input'), true);
$user = $data["username"];
$channelname = $data["channelname"];
$channelowner = $data["channelowner"];
if (isAdmin($conn, $user) || isOwner($conn, $user, $channelname, $channelowner) || isModerator($conn, $user, $channelname, $channelowner)) {
$moderators = getModerators($conn, $channelname, $channelowner);
$viewers = getViewers($conn, $channelname, $channelowner);
$banned = getBanned($conn, $channelname, $channelowner);
$public = isPublic($conn, $channelname, $channelowner);
} else {
$error = true;
$error_message = "You do not have permission access settings for this channel";
}
$conn->close();
$response = array('error' => $error, 'error_message' => $error_message, 'moderators' => $moderators, 'viewers' => $viewers, 'banned' => $banned, 'public' => $public);
echo json_encode($response);
function getModerators($conn, $channelname, $channelowner)
{
$stmt = $conn->prepare("SELECT cm_username FROM channelmods WHERE cm_chname=? AND cm_chowner=?");
$stmt->bind_param("ss", $channelname, $channelowner);
$stmt->execute();
$stmt->bind_result($username);
$users = [];
while ($stmt->fetch()) {
