function delete_images($image_ids, $delfromserver = 1) { global $site_db, $lang, $ids; if (empty($image_ids)) { echo $lang['no_search_results']; return false; } $error_log = array(); echo "<br />"; $sql = "SELECT image_id, cat_id, user_id, image_name, image_media_file, image_thumb_file\n FROM " . IMAGES_TABLE . "\n WHERE image_id IN ({$image_ids})"; $image_result = $site_db->query($sql); while ($image_row = $site_db->fetch_array($image_result)) { $sql = "DELETE FROM " . IMAGES_TABLE . "\n WHERE image_id = " . $image_row['image_id']; if ($site_db->query($sql)) { echo "<b>" . $lang['image_delete_success'] . "</b> " . $image_row['image_name'] . " (ID: " . $image_row['image_id'] . ")<br />\n"; $ids[] = $image_row['image_id']; } else { $error_log[] = "<b>" . $lang['image_delete_error'] . "</b> " . $image_row['image_name'] . " (ID: " . $image_row['image_id'] . ")<br />"; } if ($delfromserver) { if (!is_remote($image_row['image_media_file']) && !is_local_file($image_row['image_media_file'])) { if (@unlink(MEDIA_PATH . "/" . $image_row['cat_id'] . "/" . $image_row['image_media_file'])) { echo " " . $lang['file_delete_success'] . " (" . $image_row['image_media_file'] . ")<br />\n"; } else { $error_log[] = "<b>" . $lang['file_delete_error'] . " (" . $image_row['image_media_file'] . ")<br />"; } } if (!empty($image_row['image_thumb_file']) && !is_remote($image_row['image_thumb_file']) && !is_local_file($image_row['image_thumb_file'])) { if (@unlink(THUMB_PATH . "/" . $image_row['cat_id'] . "/" . $image_row['image_thumb_file'])) { echo " " . $lang['thumb_delete_success'] . " (" . $image_row['image_thumb_file'] . ")<br />\n"; } else { $error_log[] = "<b>" . $lang['thumb_delete_error'] . " (" . $image_row['image_thumb_file'] . ")<br />\n"; } } if (@unlink(MEDIA_PATH . "/" . $image_row['cat_id'] . "/big/" . $image_row['image_media_file'])) { echo " " . $lang['file_delete_success'] . " (big/" . $image_row['image_media_file'] . ")<br />\n"; } else { echo " No Original Found <br />\n"; } } if (!empty($user_table_fields['user_comments'])) { $sql = "SELECT user_id\n FROM " . COMMENTS_TABLE . "\n WHERE image_id = " . $image_row['image_id'] . " AND user_id <> " . GUEST; $result = $site_db->query($sql); while ($row = $site_db->fetch_array($result)) { $sql = "UPDATE " . USERS_TABLE . "\n SET " . get_user_table_field("", "user_comments") . " = " . get_user_table_field("", "user_comments") . " - 1\n WHERE " . get_user_table_field("", "user_id") . " = " . $row['user_id']; $site_db->query($sql); } } $sql = "DELETE FROM " . COMMENTS_TABLE . "\n WHERE image_id = " . $image_row['image_id']; if ($site_db->query($sql)) { echo $lang['comments_delete_success'] . "<br />\n"; } else { $error_log[] = "<b>" . $lang['comments_delete_success'] . "</b> " . $image_row['image_name'] . ", (ID: " . $image_row['image_id'] . ")<br />\n"; } echo "<br />\n"; } remove_searchwords($image_ids); return $error_log; }
if (isset($HTTP_POST_VARS[$key]) && isset($table_fields[$key])) { $additional_sql .= ", {$key} = '" . un_htmlspecialchars(trim($HTTP_POST_VARS[$key])) . "'"; } } } $sql = "UPDATE " . IMAGES_TABLE . "\n SET image_name = '{$image_name}', image_description = '{$image_description}', image_keywords = '{$image_keywords}'" . $additional_sql . "\n WHERE image_id = {$image_id}"; $result = $site_db->query($sql); if ($result) { include ROOT_PATH . 'includes/search_utils.php'; $search_words = array(); foreach ($search_match_fields as $image_column => $match_column) { if (isset($HTTP_POST_VARS[$image_column])) { $search_words[$image_column] = stripslashes($HTTP_POST_VARS[$image_column]); } } remove_searchwords($image_id); add_searchwords($image_id, $search_words); $msg = $lang['image_edit_success']; } else { $msg = $lang['image_edit_error']; } } else { $action = "editimage"; $sendprocess = 1; } } if ($action == "editimage") { if (!$image_id || $config['user_edit_image'] != 1 && $user_info['user_level'] != ADMIN) { redirect($url); } $additional_sql = "";
function delete_images($image_ids, $delfromserver = 1) { global $site_db, $lang; if (empty($image_ids)) { echo $lang['no_search_results']; return false; } $error_log = array(); echo "<br />"; $sql = "SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_media_file, i.image_thumb_file, l.lightbox_image_ids\n FROM " . IMAGES_TABLE . " i\n LEFT JOIN " . LIGHTBOXES_TABLE . " l ON (l.user_id = i.user_id)\n WHERE i.image_id IN ({$image_ids})"; $image_result = $site_db->query($sql); while ($image_row = $site_db->fetch_array($image_result)) { if ($image_row['user_id'] != GUEST) { $lightbox_array = explode(" ", $image_row['lightbox_image_ids']); foreach ($lightbox_array as $key => $val) { if ($val == $image_row['image_id']) { unset($lightbox_array[$key]); } } $lightbox_image_ids = trim(implode(" ", $lightbox_array)); $sql = "UPDATE " . LIGHTBOXES_TABLE . "\n SET lightbox_image_ids = '" . $lightbox_image_ids . "'\n WHERE user_id = " . $image_row['user_id']; $site_db->query($sql); } $sql = "DELETE FROM " . IMAGES_TABLE . "\n WHERE image_id = " . $image_row['image_id']; if ($site_db->query($sql)) { echo "<b>" . $lang['image_delete_success'] . "</b> " . format_text($image_row['image_name'], 2) . " (ID: " . $image_row['image_id'] . ")<br />\n"; } else { $error_log[] = "<b>" . $lang['image_delete_error'] . "</b> " . format_text($image_row['image_name'], 2) . " (ID: " . $image_row['image_id'] . ")<br />"; } if ($delfromserver) { if (!is_remote($image_row['image_media_file']) && !is_local_file($image_row['image_media_file'])) { if (@unlink(MEDIA_PATH . "/" . $image_row['cat_id'] . "/" . $image_row['image_media_file'])) { echo " " . $lang['file_delete_success'] . " (" . $image_row['image_media_file'] . ")<br />\n"; } else { $error_log[] = "<b>" . $lang['file_delete_error'] . " (" . $image_row['image_media_file'] . ")<br />"; } } if (!empty($image_row['image_thumb_file']) && !is_remote($image_row['image_thumb_file']) && !is_local_file($image_row['image_thumb_file'])) { if (@unlink(THUMB_PATH . "/" . $image_row['cat_id'] . "/" . $image_row['image_thumb_file'])) { echo " " . $lang['thumb_delete_success'] . " (" . $image_row['image_thumb_file'] . ")<br />\n"; } else { $error_log[] = "<b>" . $lang['thumb_delete_error'] . " (" . $image_row['image_thumb_file'] . ")<br />\n"; } } } if (!empty($user_table_fields['user_comments'])) { $sql = "SELECT user_id\n FROM " . COMMENTS_TABLE . "\n WHERE image_id = " . $image_row['image_id'] . " AND user_id <> " . GUEST; $result = $site_db->query($sql); while ($row = $site_db->fetch_array($result)) { $sql = "UPDATE " . USERS_TABLE . "\n SET " . get_user_table_field("", "user_comments") . " = " . get_user_table_field("", "user_comments") . " - 1\n WHERE " . get_user_table_field("", "user_id") . " = " . $row['user_id']; $site_db->query($sql); } } $sql = "DELETE FROM " . COMMENTS_TABLE . "\n WHERE image_id = " . $image_row['image_id']; if ($site_db->query($sql)) { echo $lang['comments_delete_success'] . "<br />\n"; } else { $error_log[] = "<b>" . $lang['comments_delete_success'] . "</b> " . format_text($image_row['image_name'], 2) . ", (ID: " . $image_row['image_id'] . ")<br />\n"; } echo "<br />\n"; } remove_searchwords($image_ids); return $error_log; }
function delete_users($user_ids, $delcomments = 1, $delimages = 1) { global $site_db, $lang, $user_table_fields; if (empty($user_ids)) { echo $lang['no_search_results']; return false; } $error_log = array(); echo "<br />"; $sql = "SELECT " . get_user_table_field("", "user_id") . get_user_table_field(", ", "user_name") . "\n FROM " . USERS_TABLE . "\n WHERE " . get_user_table_field("", "user_id") . " IN ({$user_ids})"; $user_result = $site_db->query($sql); $image_ids_sql = ""; while ($user_row = $site_db->fetch_array($user_result)) { $user_id = $user_row[$user_table_fields['user_id']]; $user_name = $user_row[$user_table_fields['user_name']]; $sql = "DELETE FROM " . GROUP_MATCH_TABLE . "\n WHERE user_id = {$user_id}"; $site_db->query($sql); $sql = "SELECT group_id\n FROM " . GROUPS_TABLE . "\n WHERE group_name = '" . addslashes($user_name) . "' AND group_type = " . GROUPTYPE_SINGLE; if ($groups_row = $site_db->query_firstrow($sql)) { $sql = "DELETE FROM " . GROUPS_TABLE . "\n WHERE group_id = " . $groups_row['group_id'] . " AND group_type = " . GROUPTYPE_SINGLE; $site_db->query($sql); $sql = "DELETE FROM " . GROUP_ACCESS_TABLE . "\n WHERE group_id = " . $groups_row['group_id']; $site_db->query($sql); } $sql = "DELETE FROM " . LIGHTBOXES_TABLE . "\n WHERE user_id = {$user_id}"; $site_db->query($sql); if (!defined("USER_INTEGRATION") || defined("USER_INTEGRATION") && USER_INTEGRATION == "NONE") { $sql = "DELETE FROM " . USERS_TABLE . "\n WHERE " . get_user_table_field("", "user_id") . " = {$user_id}"; if ($site_db->query($sql)) { echo "<b>" . $lang['user_delete_success'] . "</b> " . format_text($user_name, 2) . " (ID: {$user_id})<br />\n"; } else { $error_log[] = "<b>" . $lang['user_delete_error'] . "</b> " . format_text($user_name, 2) . " (ID: {$user_id})<br />\n"; } } else { echo "<b>" . $lang['user_integration_delete_msg'] . "</b> " . format_text($user_name, 2) . " (ID: {$user_id})<br />\n"; } if ($delimages) { $sql = "SELECT image_id, cat_id, image_media_file, image_thumb_file\n FROM " . IMAGES_TABLE . "\n WHERE user_id = {$user_id}"; $result = $site_db->query($sql); while ($row = $site_db->fetch_array($result)) { if (file_exists(MEDIA_PATH . "/" . $row['cat_id'] . "/" . $row['image_media_file'])) { unlink(MEDIA_PATH . "/" . $row['cat_id'] . "/" . $row['image_media_file']); } if (file_exists(THUMB_PATH . "/" . $row['cat_id'] . "/" . $row['image_thumb_file']) && !empty($row['image_thumb_file'])) { unlink(THUMB_PATH . "/" . $row['cat_id'] . "/" . $row['image_thumb_file']); } $image_ids_sql .= ($image_ids_sql != "" ? ", " : "") . $row['image_id']; } $sql = "DELETE FROM " . IMAGES_TABLE . "\n WHERE user_id = {$user_id}"; if ($site_db->query($sql)) { echo " " . $lang['images_delete_success'] . "<br />\n"; } else { $error_log[] = $lang['images_delete_error'] . ": " . format_text($user_name, 2); } } else { //Update Images $sql = "UPDATE " . IMAGES_TABLE . "\n SET user_id = " . GUEST . "\n WHERE user_id = {$user_id}"; if ($site_db->query($sql)) { echo " " . $lang['user_images_update_success'] . "<br />\n"; } else { $error_log[] = $lang['user_images_update_error'] . ": " . format_text($user_name, 2); } } if ($delcomments) { $sql = "SELECT i.image_id, COUNT(c.comment_id) AS count\n FROM " . IMAGES_TABLE . " i\n LEFT JOIN " . COMMENTS_TABLE . " c ON c.image_id = i.image_id\n WHERE c.user_id = " . $user_id . "\n GROUP BY i.image_id"; $result = $site_db->query($sql); while ($row = $site_db->fetch_array($result)) { $sql = "UPDATE " . IMAGES_TABLE . "\n SET image_comments = image_comments - " . $row['count'] . "\n WHERE image_id = " . $row['image_id']; $site_db->query($sql); } $sql = "DELETE FROM " . COMMENTS_TABLE . "\n WHERE user_id = {$user_id}"; if ($site_db->query($sql)) { echo " " . $lang['comments_delete_success'] . "<br />\n"; } else { $error_log[] = $lang['comments_delete_error'] . ": " . format_text($user_name, 2); } } else { //Update Comments $sql = "UPDATE " . COMMENTS_TABLE . "\n SET user_id = " . GUEST . ", user_name = '{$user_name}'\n WHERE user_id = {$user_id}"; if ($site_db->query($sql)) { echo " " . $lang['user_comments_update_success'] . "<br />\n"; } else { $error_log[] = $lang['user_comments_update_error'] . ": " . format_text($user_name, 2); } } echo "<br />\n"; } include_once ROOT_PATH . 'includes/search_utils.php'; remove_searchwords($image_ids_sql); return $error_log; }
function remove_subcategories($cid = 0, $depth = 1) { global $site_db, $error_log, $lang, $category_cache; if (!isset($category_cache[$cid])) { return false; } foreach ($category_cache[$cid] as $key => $cats) { echo "<table border=\"0\" cellpadding=\"2\" cellspacing=\"0\"><tr><td>\n"; if ($depth > 1) { echo str_repeat(" ", $depth - 1) . "\n"; } echo "</td><td>\n"; $sql = "DELETE FROM " . GROUP_ACCESS_TABLE . "\n WHERE cat_id = " . $cats['cat_id']; $site_db->query($sql); $sql = "DELETE FROM " . CATEGORIES_TABLE . "\n WHERE cat_id = " . $cats['cat_id']; if ($site_db->query($sql)) { echo $lang['cat_delete_success'] . " <b>" . format_text($cats['cat_name'], 2) . "</b> (ID: " . $cats['cat_id'] . ")<br />\n"; } else { $error_log[] = $lang['cat_delete_error'] . " <b>" . format_text($cats['cat_name'], 2) . "</b> (ID: " . $cats['cat_id'] . ")"; } $sql = "SELECT image_id\n FROM " . IMAGES_TABLE . "\n WHERE cat_id = " . $cats['cat_id']; $img_result = $site_db->query($sql); $image_ids_sql = 0; while ($image_row = $site_db->fetch_array($img_result)) { $image_ids_sql .= ($image_ids_sql != "" ? ", " : "") . $image_row['image_id']; } $sql = "DELETE FROM " . IMAGES_TABLE . "\n WHERE image_id IN ({$image_ids_sql})"; if ($site_db->query($sql)) { echo "-» " . $lang['image_delete_success'] . "<br />\n"; } else { $error_log[] = $lang['image_delete_error'] . " (" . format_text($cats['cat_name'], 2) . ", ID: " . $cats['cat_id'] . ")"; } if (!empty($cats['cat_id'])) { if (remove_cat_folder(MEDIA_PATH . "/" . $cats['cat_id'])) { echo "-» " . $lang['file_delete_success'] . "<br />\n"; } else { $error_log[] = $lang['file_delete_error'] . " (" . format_text($cats['cat_name'], 2) . ", ID: " . $cats['cat_id'] . ")"; } if (remove_cat_folder(THUMB_PATH . "/" . $cats['cat_id'])) { echo "-» " . $lang['thumb_delete_success'] . "<br />\n"; } else { $error_log[] = $lang['thumb_delete_error'] . " (" . format_text($cats['cat_name'], 2) . ", ID: " . $cats['cat_id'] . ")"; } } $sql = "DELETE FROM " . COMMENTS_TABLE . "\n WHERE image_id IN ({$image_ids_sql})"; if ($site_db->query($sql)) { echo "-» " . $lang['comments_delete_success'] . "<br />\n"; } else { $error_log[] = $lang['comments_delete_error'] . " (" . format_text($cats['cat_name'], 2) . ", ID: " . $cats['cat_id'] . ")"; } remove_searchwords($image_ids_sql); echo "<br /></td></tr></table>\n"; remove_subcategories($cats['cat_id'], $depth + 1); } unset($category_cache[$cid]); return true; }
$result = $site_db->query($sql); $num_rows = $site_db->get_numrows($result); while ($row = $site_db->fetch_array($result)) { if ($cat_id) { $batchend = $row['image_id']; } printf($lang_rebuild_image, $row['image_name'], $row['image_id']); flush(); @set_time_limit(90); $search_words = array(); foreach ($search_match_fields as $image_column => $match_column) { if (isset($row[$image_column])) { $search_words[$image_column] = $row[$image_column]; } } remove_searchwords($row['image_id']); add_searchwords($row['image_id'], $search_words); echo " <b>OK</b><br />\n"; flush(); } if ($num_rows) { $sql = "SELECT cat_id\n FROM " . IMAGES_TABLE . "\n WHERE {$cat_filter} AND image_id >= " . ($batchend + 1) . $order; $num_rows = $site_db->query_firstrow($sql); } if ($num_rows) { next_step($batchend + 1, $batchsize, $autoredirect); show_text_link($lang_rebuild_back, "rebuild_searchindex.php"); } else { echo "<p><b>" . $lang_rebuild_success . "</b><p>\n"; show_text_link($lang_rebuild_back, "rebuild_searchindex.php"); $site_sess->set_session_var("rsibatchstart", 0);