Ok ... a bit more for help but is it ... IMAGES_TABLE is use all over script ... no can help for this large (axcept if contract). Is very large for edit.
So bit more ...
// Step 1
In includes/constants.php file,
add:
define('USERS_IMAGES_TABLE', $table_prefix.'users_images_table');
define('USERS_IMAGES_TEMP_TABLE', $table_prefix.'users_images_temp_table');
// Step 2
In member.php file,
find:
if ($direct_upload) {
$sql = "INSERT INTO ".IMAGES_TABLE."
(cat_id, user_id, image_name, image_description, image_keywords, image_date, image_active, image_media_file, image_thumb_file, image_download_url, image_allow_comments".$additional_field_sql.")
VALUES
($cat_id, ".$user_info['user_id'].", '$image_name', '$image_description', '$image_keywords', $current_time, $image_active, '$new_name', '$new_thumb_name', '$image_download_url', $image_allow_comments".$additional_value_sql.")";
$result = $site_db->query($sql);
$image_id = $site_db->get_insert_id();
if ($result) {
add after:
$sql = "INSERT INTO ".USERS_IMAGES_TABLE."
(cat_id, user_id, image_name, image_description, image_keywords, image_date, image_active, image_media_file, image_thumb_file, image_download_url, image_allow_comments".$additional_field_sql.")
VALUES
($cat_id, ".$user_info['user_id'].", '$image_name', '$image_description', '$image_keywords', $current_time, $image_active, '$new_name', '$new_thumb_name', '$image_download_url', $image_allow_comments".$additional_value_sql.")";
$result1 = $site_db->query($sql);
find:
}
else {
$sql = "INSERT INTO ".IMAGES_TEMP_TABLE."
(cat_id, user_id, image_name, image_description, image_keywords, image_date, image_media_file, image_thumb_file, image_download_url".$additional_field_sql.")
VALUES
($cat_id, ".$user_info['user_id'].", '$image_name', '$image_description', '$image_keywords', $current_time, '$new_name', '$new_thumb_name', '$image_download_url'".$additional_value_sql.")";
$result = $site_db->query($sql);
add after:
}
else {
$sql = "INSERT INTO ".USERS_IMAGES_TEMP_TABLE."
(cat_id, user_id, image_name, image_description, image_keywords, image_date, image_media_file, image_thumb_file, image_download_url".$additional_field_sql.")
VALUES
($cat_id, ".$user_info['user_id'].", '$image_name', '$image_description', '$image_keywords', $current_time, '$new_name', '$new_thumb_name', '$image_download_url'".$additional_value_sql.")";
$result1 = $site_db->query($sql);
// Step 3
Create new SQL table (same with IMAGES_TABLE and IMAGES_TEMP_TABLE field inside) in phpmyadmin by use
your_table_prefix_users_images_table and
your_table_prefix_users_images_temp_table (change your_table_prefix with real name).
// Step 4
In details.php file,
Re-select fields with new table (USERS_IMAGES_TABLE) but from data/user ID folder and see if work.
Is all I can do for you for this ... is very large.