albertlast / SMF2.1

			$smcFunc['db_free_result']($result);

			// Do we need to delete what we have?

			if ($fix_errors && !empty($to_remove) && in_array('missing_thumbnail_parent', $to_fix))

				$smcFunc['db_query']('', '

					DELETE FROM {db_prefix}attachments

					WHERE id_attach IN ({array_int:to_remove})

						AND attachment_type = {int:attachment_type}',

					array(

						'to_remove' => $to_remove,

						'attachment_type' => 3,

					)

				);

			pauseAttachmentMaintenance($to_fix, $thumbnails);

		}

			$smcFunc['db_free_result']($result);

			// Do we need to delete what we have?

			if ($fix_errors && !empty($to_remove) && in_array('avatar_no_member', $to_fix))

				$smcFunc['db_query']('', '

					DELETE FROM {db_prefix}attachments

					WHERE id_attach IN ({array_int:to_remove})

						AND id_member != {int:no_member}

						AND id_msg = {int:no_msg}',

					array(

						'to_remove' => $to_remove,

						'no_member' => 0,

						'no_msg' => 0,

					)

				);

			pauseAttachmentMaintenance($to_fix, $thumbnails);

		}

			$smcFunc['db_free_result']($result);

			// Do we need to delete what we have?

			if ($fix_errors && !empty($to_remove) && in_array('attachment_no_msg', $to_fix))

				$smcFunc['db_query']('', '

					DELETE FROM {db_prefix}attachments

					WHERE id_attach IN ({array_int:to_remove})

						AND id_member = {int:no_member}

						AND attachment_type IN ({array_int:attach_thumb})',

					array(

						'to_remove' => $to_remove,

						'no_member' => 0,

						'attach_thumb' => array(0,3),

					)

				);

			pauseAttachmentMaintenance($to_fix, $thumbnails);

		}