Delete al images but member specific...

[MoreBloodWine]

How can I delete all images posted by a specific member ?

[MoreBloodWine]

I found the list files thing but I dont wana have to delete a ton of pictures one by one ;-/

[SMFHacks]

No easy way you would have to go though the database.

in the gallery_pic table delele all pictures where the id_member = the member id.

Highly recommend making database backups before altering information in the database.

[MoreBloodWine]

No easy way you would have to go though the database.

in the gallery_pic table delele all pictures where the id_member = the member id.

Highly recommend making database backups before altering information in the database.

Any chance on a future update where multiome deletions could be done by say a checkbox method like with posts and stuff.

[MoreBloodWine]

No easy way you would have to go though the database.

in the gallery_pic table delele all pictures where the id_member = the member id.

Highly recommend making database backups before altering information in the database.

The id of the member is 44

Coul you write a query for me to run please, would make this alot easier.

Edit: *Points up to his last reply...*

[SMFHacks]

DELETE FROM smf_gallery_pic where ID_MEMBER = 44

[MoreBloodWine]

DELETE FROM smf_gallery_pic where ID_MEMBER = 44

Thx, now that just means that I have to delete the physical pictures themselves.

Edit: Before I run this and make a mess of things is there a way to make that query category specific ?

Basicaly all I want to do is delete all pictures by member 44 but ONLY in category 2

[mashby]

DELETE FROM smf_gallery_pic where ID_MEMBER = 44 AND ID_CAT = 2

[MoreBloodWine]

DELETE FROM smf_gallery_pic where ID_MEMBER = 44 AND ID_CAT = 2

Worked like a charm, Ty ;-)