if ($result) {
// Success
$_SESSION["message"] = "Video successfully added!";
} else {
// Failure
$_SESSION["message"] = "Video failed to add!";
}
redirect_to("index.php?redirect=videos");
} else {
$_SESSION["message"] = "Ruh-roh! There was an error";
}
} else {
if (isset($_GET["deleteid"]) && $admin) {
// User is deleting a song.
$deleteid = $_GET["deleteid"];
remove_from_table($deleteid, $active_page, $active_page);
} else {
if (isset($_GET["movedirection"]) && $admin) {
// We're moving a songs position instead.
$moveid = $_GET["moveid"];
$directiontomove = $_GET["movedirection"];
$destinationid = $moveid + $directiontomove;
// Check to see if move is performable.
$query = "SELECT * FROM videos";
$result = mysqli_query($connection, $query);
$numentries = mysqli_num_rows($result);
$redirectlink = $active_page . ".php";
if ($destinationid < 1) {
// ID is too low.
$_SESSION["message"] = "Cannot move this video up!";
redirect_to("index.php?redirect=videos");
confirm_query($result);
// 4 - Inserting deleted song
$query = "INSERT INTO songs (";
$query .= " id, songcode";
$query .= ") VALUES (";
$query .= " {$movesongid}, '{$deletedsong['songcode']}'";
$query .= ")";
$result = mysqli_query($connection, $query);
confirm_query($result);
// Finished.
$_SESSION["message"] = "Song positions updated!";
redirect_to("index.php?redirect=songs");
}
// Delete a song.
if (isset($_GET["deleteid"]) && $admin) {
remove_from_table($_GET["deleteid"], $active_page, $active_page);
$_SESSION["message"] = "Song removed!";
}
?>
<?php
if (isset($_SESSION["message"])) {
generate_prompt("Notification", message(), 'songs');
echo "<script type=\"text/javascript\">prompt_popup('songs');</script>";
} else {
if (isset($_SESSION["errors"])) {
generate_prompt("Notification", errors(), 'songs');
echo "<script type=\"text/javascript\">prompt_popup('songs');</script>";
}
}
