Hi,
Is there a way I can delete multiple galleries by Source URL, right now I see we only have feature to delete by slug or gallery ID. The problem is I have a list of Source URL's from tubes that I want to delete across multiple sites. I tried to delete directly from database using mysql command like this:
DELETE FROM `rot_gallery_info` WHERE `rot_gallery_info`.`source_url` = "https://www.xvideos.com/embedframe/XXXXXX" ;
This only deletes from rot_gallery_info table but thumbs do not get deleted. Can you please guide me on how I can achieve this as I have list of over 5000 galleries on many sites that I need to delete by Source URL. Need to do this fast.
Regards,
Delete Galleries By Source URL
Re: Delete Galleries By Source URL
Hi,
if you want to do it in DB you have to do like
update `rot_gallery_info`
set gallery_status = 'to_delete'
WHERE `rot_gallery_info`.`source_url` = "https://www.xvideos.com/embedframe/XXXXXX" ;
and the script will do the rest
if you want to do it in DB you have to do like
update `rot_gallery_info`
set gallery_status = 'to_delete'
WHERE `rot_gallery_info`.`source_url` = "https://www.xvideos.com/embedframe/XXXXXX" ;
and the script will do the rest
Don't forget to run script update
Re: Delete Galleries By Source URL
Hi,
Thanks for your reply. If I do this manually for 5000+ galleries on each site by running commands in DB it can take a long time. Is it possible for you to add Bulk delete by source url as feature in script? Would appreciate if you can add this.
Thanks for your reply. If I do this manually for 5000+ galleries on each site by running commands in DB it can take a long time. Is it possible for you to add Bulk delete by source url as feature in script? Would appreciate if you can add this.
Re: Delete Galleries By Source URL
Sure,
1. rotation -special - Delete galleries by URL
or
2. create a list and add it as
Import set
type = deletion
and the script will check that list let's say every X hours and delete listed galleries
1. rotation -special - Delete galleries by URL
or
2. create a list and add it as
Import set
type = deletion
and the script will check that list let's say every X hours and delete listed galleries
Don't forget to run script update
Re: Delete Galleries By Source URL
Hi,
Thanks. For 1. and 2. will this work if I only have list with Source URL's?
Thanks. For 1. and 2. will this work if I only have list with Source URL's?
Re: Delete Galleries By Source URL
Hi,
Thanks. It worked with 2. using list with only Source URL's,.
Thanks. It worked with 2. using list with only Source URL's,.