Ask a question about user upload image usage on the site

If someone publishes an article with a picture of the thumbnail image will be saved on the server at the same time the picture
The URL is saved in the Picture field in the article table

And the URL of the picture will also be saved in the attachment table a copy of the tag is in use

When the user publishes an article with pictures. Upload a picture, but do not want this picture and want to delete this picture

When you click Delete Image, you will Mark the image in the attachment table.

This time, the background scan once. If there is no picture in use, delete it physically and remove it from the attachment table.

Is that how you clean up the useless pictures?

Another problem is that if a user uploads a picture in an online editor , it's inserted directly into the editor. If the user presses the DELETE key to erase it, I don't know how he deleted it.

Reply content:

If someone publishes an article with a picture of the thumbnail image will be saved on the server at the same time the picture
The URL is saved in the Picture field in the article table

And the URL of the picture will also be saved in the attachment table a copy of the tag is in use

When the user publishes an article with pictures. Upload a picture, but do not want this picture and want to delete this picture

When you click Delete Image, you will Mark the image in the attachment table.

This time, the background scan once. If there is no picture in use, delete it physically and remove it from the attachment table.

Is that how you clean up the useless pictures?

Another problem is that if a user uploads a picture in an online editor , it's inserted directly into the editor. If the user presses the DELETE key to erase it, I don't know how he deleted it.

Deleting the article, delete the file directly, do not have to wait for regular processing.
When editing an article, when the Update table, the regular check the contents of the number of pictures (Find your editor to insert the text of the image rule, is an IMG or markdown), and the attachment table contrast, inconsistent deletion.

