function delete_story($id)
{
global $connection;
// $id is the id of a story
// First, get all chapters that are in this story
$chapter_set = get_chapters_in_story($id);
// Loop through chapters and delete them and all associated references
while ($chapter_id = mysql_fetch_array($chapter_set)) {
delete_chapter($chapter_id[0]);
}
// Finally, delete the story
$query = "DELETE FROM stories WHERE id = {$id} LIMIT 1";
$result_set = mysql_query($query, $connection);
confirm_query($result_set);
}
<?php
/* This script deletes a comic chapter or page.
*/
/*****
* Setup
*/
require_once 'panl.init.php';
/*****
* Chapter
*/
if ($_GET['delete-chapter']) {
$id = strfunc_get_id($_GET['delete-chapter']);
if ($id) {
delete_chapter($id, $db);
}
}
/*****
* Page
*/
if ($_GET['delete-page']) {
$id = strfunc_get_id($_GET['delete-page']);
if ($id) {
delete_comic_page($id, $db);
}
}
<?php
require_once "helper-functions/connection.php";
require_once "helper-functions/functions.php";
require_once "helper-functions/delete_functions.php";
if (intval($_GET['chapter']) == 0) {
redirect_to("all_stories.php");
}
// get the id of the chapter
$id = mysql_prep($_GET['chapter']);
// if the id corresponds to an actual chapter, start process
if ($chapter = get_chapter_by_id($id)) {
// Capture the parent chapter before deletion (otherwise, you won't be able to find it)
$parent = get_parent_of_chapter($chapter['id']);
$errors = array();
// Call function in functions.php
delete_chapter($id);
// If successful, redirect to the parent chapter
redirect_to("read_chapter.php?chapter={$parent['chapter_id']}&deleted=1");
}
?>
<?php
mysql_close($connection);
