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