Delete Galleries By Source URL

Post Reply
tubeman
Posts: 534
Joined: Sat Mar 02, 2013 11:33 am

Delete Galleries By Source URL

Post by tubeman »

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,
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Delete Galleries By Source URL

Post by admin »

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
Don't forget to run script update
tubeman
Posts: 534
Joined: Sat Mar 02, 2013 11:33 am

Re: Delete Galleries By Source URL

Post by tubeman »

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.
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Delete Galleries By Source URL

Post by admin »

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
Don't forget to run script update
tubeman
Posts: 534
Joined: Sat Mar 02, 2013 11:33 am

Re: Delete Galleries By Source URL

Post by tubeman »

Hi,
Thanks. For 1. and 2. will this work if I only have list with Source URL's?
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Delete Galleries By Source URL

Post by admin »

What list do you have?
Don't forget to run script update
tubeman
Posts: 534
Joined: Sat Mar 02, 2013 11:33 am

Re: Delete Galleries By Source URL

Post by tubeman »

Hi,
Thanks. It worked with 2. using list with only Source URL's,.
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Delete Galleries By Source URL

Post by admin »

great )
Don't forget to run script update
Post Reply