how to delete photos with SQL query?

[Dashizna]

[Note: remember to include site URL, ZC version, list of plugins, PHP version, etc ... read the Posting Tips shown above for information to include in your post here. And, remove this comment before actually posting!]

Is it possible to be able to delete photos from our server with a SQL code?

We have alot of products and photos and when we have to delete just a few from a product its very hard to load all the photos and find them and delete them. We are looking for a simpler way to do this

thanks

[mesnitu]

Not sure if there is a plugin to do that.
And it's a bit difficult to guess what images are product images or not.

By in theory, one has to create a list of all products images from products table.
All the rest would be deleted if not present in that list.
However, there may be images, that are not from old products, and still in use for something else.
Only if they are / were in a specific folder that you know, that only product images live there.

[Design75]

Edo a search for obsolete images in the plugin section.

[Dashizna]

Not sure if there is a plugin to do that.
And it's a bit difficult to guess what images are product images or not.

By in theory, one has to create a list of all products images from products table.
All the rest would be deleted if not present in that list.
However, there may be images, that are not from old products, and still in use for something else.
Only if they are / were in a specific folder that you know, that only product images live there.

We have the names of the images we want to delete.

[mc12345678]

For what it's worth, the deletion of the actual files would not be done by a sql query. The database (affected by sql queries) contains the path to the file(s), not the files themselves.

Design75 though referenced a plugin though I have a feeling that the thought was the missing images plugin:https://www.zen-cart.com/downloads.php?do=file&id=1887

I searched for obsolete images and then tried just images and went through 6 pages of downloads without finding something that seemed to do the reverse of the missing images plugin.

In absence of a plugin, you could delete the images by referencing them from a product and then in the admin request the image be deleted from the server, or manually through ftp, cPanel, a script that perhaps has the remove command before the file and it's path, etc... but not by a sql command. :)

[Dashizna]

For what it's worth, the deletion of the actual files would not be done by a sql query. The database (affected by sql queries) contains the path to the file(s), not the files themselves.

Design75 though referenced a plugin though I have a feeling that the thought was the missing images plugin:https://www.zen-cart.com/downloads.php?do=file&id=1887

I searched for obsolete images and then tried just images and went through 6 pages of downloads without finding something that seemed to do the reverse of the missing images plugin.

In absence of a plugin, you could delete the images by referencing them from a product and then in the admin request the image be deleted from the server, or manually through ftp, cPanel, a script that perhaps has the remove command before the file and it's path, etc... but not by a sql command. :)

Well i usually use filezilla to delete images. but there are so many that it won't load them all. As for going into our cpanel and doing it. thats really time consuming and takes a very long time to load all the images in a browser.

here is an example of what we are trying to do

on this item https://ad-discountperformance.com/i...ucts_id=279281

i need to delete just 3 of the sub images there.

i don't want to do what we were doing is rename the ones we want and reupload more to the server.

[mc12345678]

How precisely do you know the image and path?

You could create a php file, would suggest placing it in the admin so that it can't be accessed easily from the internet.

<?php
require 'includes/application_top.php';

if (!IS_ADMIN_FLAG) {
 die('Illegal Access');
}

$delete_photos = array(
'path/file1',
'path/file2',
'path/file3'
);

foreach ($delete_photos as $photo) {
 unlink($photo);
}

Now, that assumes a full path.

If your information is say based on being in the store's images directory, where you have say: attributes/prod1.jpg as the path, then:

unlink($photo);

Could instead be:

unlink(DIR_FS_CATALOG_IMAGES . $photo);

The generation of the array list should be relatively easy. Paste all of the paths, one per line. Add an apostrophe/single quote at the beginning of each. Add an apostrophe and comma at the end of each (may need to delete the last comma). Save the file with a known name.

Login to your admin. Change index.php or whatever file is displayed at the end of the url to the filename just created and access the file. You will get a white page, but

[Dashizna]

How precisely do you know the image and path?

You could create a php file, would suggest placing it in the admin so that it can't be accessed easily from the internet.

<?php
require 'includes/application_top.php';

if (!IS_ADMIN_FLAG) {
 die('Illegal Access');
}

$delete_photos = array(
'path/file1',
'path/file2',
'path/file3'
);

foreach ($delete_photos as $photo) {
 unlink($photo);
}

Now, that assumes a full path.

If your information is say based on being in the store's images directory, where you have say: attributes/prod1.jpg as the path, then:

unlink($photo);

Could instead be:

unlink(DIR_FS_CATALOG_IMAGES . $photo);

The generation of the array list should be relatively easy. Paste all of the paths, one per line. Add an apostrophe/single quote at the beginning of each. Add an apostrophe and comma at the end of each (may need to delete the last comma). Save the file with a known name.

Login to your admin. Change index.php or whatever file is displayed at the end of the url to the filename just created and access the file. You will get a white page, but

Hmm i have no clue on where to start with creating a PHP file.
Ask for the file path we can just right click on the image and save the image address to that image.

ill attempt this tomorrow when i have some time though and see if i can get that working.

[torvista]

I searched for obsolete images and then tried just images and went through 6 pages of downloads without finding something that seemed to do the reverse of the missing images plugin.

I would have liked to add that to the missing images plugin, but I thought about it and it seemed like I would have to actually write new code so I decided to do some real work instead.
So, there is no other mod out there that could be resurrected/updated to check for orphan images?

[mesnitu]

I would have liked to add that to the missing images plugin, but I thought about it and it seemed like I would have to actually write new code so I decided to do some real work instead.
So, there is no other mod out there that could be resurrected/updated to check for orphan images?

Yesterday I've checked your plugin then I saw that for this purpose wouldn't do this job.
But, how to know the images to delete ?
Let's take a example of the banners, or attributes ( never use them, but I guess this images are also in the images folders), or something else.
The "only" way, is to create some "exclude" folders... I guess...
Else, if is not linked to a database product, will be deleted.

Once I posted in code suggestions
That or I'm seeing this wrong, or if one uploads a image, and then cancels the edit, the image is not deleted.
Over time, is very easy a lot of space occupied with this canceled posts images.