$query = "SELECT COUNT(*) FROM {$note_table} WHERE post_id='{$id}' AND id='{$note_id}'"; $result = $db->query($query); $row = $result->fetch_assoc(); if ($row['COUNT(*)'] == 1) { $result->free_result(); $query = "DELETE FROM {$note_table} WHERE post_id='{$id}' AND id='{$note_id}'"; $db->query($query); $query = "DELETE FROM {$note_history_table} WHERE post_id='{$id}' AND id='{$note_id}'"; $db->query($query); $cache->destroy("cache/" . $id . "/post.cache"); print $note_id; } } else { if (isset($_GET['removepost']) && $_GET['removepost'] == 1) { $image = new image(); if ($image->removeimage($id) == true) { $cache->destroy_page_cache("cache/" . $id); $query = "SELECT id FROM {$post_table} WHERE id < {$id} ORDER BY id DESC LIMIT 1"; $result = $db->query($query); $row = $result->fetch_assoc(); $prev_id = $row['id']; $result->free_result(); $query = "SELECT id FROM {$post_table} WHERE id > {$id} ORDER BY id ASC LIMIT 1"; $result = $db->query($query); $row = $result->fetch_assoc(); $next_id = $row['id']; $date = date("Ymd"); if (is_dir("{$main_cache_dir}" . "" . "cache/" . $prev_id) && "{$main_cache_dir}" . "" . "cache/" . $prev_id != "{$main_cache_dir}" . "" . "cache/") { $cache->destroy_page_cache("cache/" . $prev_id); } if (is_dir("{$main_cache_dir}" . "" . "cache/" . $next_id) && "{$main_cache_dir}" . "" . "cache/" . $next_id != "{$main_cache_dir}" . "" . "cache/") {
$sql_query = "SELECT id,tags,title from {$post_table} WHERE {$where_clause};"; if ($debug) { echo "<strong>SQL query:</strong><br/>{$sql_query}<br/><br/>"; } if ($results = $db->query($sql_query)) { $tag_obj = new tag(); $user = new user(); $cache = new cache(); $image = new image(); echo "Query returned " . $results->num_rows . " rows<br/>"; $post = $results->fetch_assoc(); while (!is_null($post)) { if ($debug || isset($_GET['display_ids'])) { echo "ID: '" . $post['id'] . "' Title: '" . $post['title'] . "'<br/> Tags: " . $post['tags'] . "<br/><br/>"; } else { if ($image->removeimage($post['id']) == true) { $delete_count++; echo "<span style=\"color: rgb(0, 255, 0);\">Image " . $post['id'] . " successfully deleted!</span><br/>"; //copied the rest from remove.php $cache->destroy_page_cache("cache/" . $post['id']); $query = "SELECT id FROM {$post_table} WHERE id < " . $post['id'] . " ORDER BY id DESC LIMIT 1"; if ($result = $db->query($query)) { $row = $result->fetch_assoc(); $prev_id = $row['id']; $result->free_result(); } else { echo "<strong>No previous ID, Cannot remove image from cache!</strong><br/>\r\n\t\t\t\t\t\tHere's the query: {$query}<br/>\r\n\t\t\t\t\t\tand here's the error(" . $db->errno . "): " . $db->error . "<br/><br/>"; $post = $results->fetch_assoc(); continue; } $query = "SELECT id FROM {$post_table} WHERE id > " . $post['id'] . " ORDER BY id ASC LIMIT 1";