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);
