Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+- Forum Stats

Members
Total Members: 4255
Latest: andreios
New This Month: 3
New This Week: 1
New Today: 0
Stats
Total Posts: 43259
Total Topics: 7518
Most Online Today: 177
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 186
Total: 186

Author Topic: Delete al images but member specific...  (Read 7325 times)

0 Members and 1 Guest are viewing this topic.

Offline MoreBloodWine

  • Member
  • *
  • Posts: 48
    • View Profile
Delete al images but member specific...
« on: July 27, 2008, 05:32:07 pm »
How can I delete all images posted by a specific member ?

Offline MoreBloodWine

  • Member
  • *
  • Posts: 48
    • View Profile
Re: Delete al images but member specific...
« Reply #1 on: July 27, 2008, 05:45:47 pm »
I found the list files thing but I dont wana have to delete a ton of pictures one by one ;-/

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16436
    • View Profile
Re: Delete al images but member specific...
« Reply #2 on: July 27, 2008, 06:09:18 pm »
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.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline MoreBloodWine

  • Member
  • *
  • Posts: 48
    • View Profile
Re: Delete al images but member specific...
« Reply #3 on: July 27, 2008, 10:34:24 pm »
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.

Offline MoreBloodWine

  • Member
  • *
  • Posts: 48
    • View Profile
Re: Delete al images but member specific...
« Reply #4 on: August 01, 2008, 09:19:18 pm »
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...*

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16436
    • View Profile
Re: Delete al images but member specific...
« Reply #5 on: August 01, 2008, 09:22:39 pm »
DELETE FROM smf_gallery_pic where ID_MEMBER = 44
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline MoreBloodWine

  • Member
  • *
  • Posts: 48
    • View Profile
Re: Delete al images but member specific...
« Reply #6 on: August 09, 2008, 10:06:59 pm »
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
« Last Edit: August 09, 2008, 10:11:24 pm by MoreBloodWine »

Offline mashby

  • Jr. Member
  • **
  • Posts: 81
    • View Profile
    • ChopPix.com
Re: Delete al images but member specific...
« Reply #7 on: August 09, 2008, 10:32:59 pm »
DELETE FROM smf_gallery_pic where ID_MEMBER = 44 AND ID_CAT = 2

Offline MoreBloodWine

  • Member
  • *
  • Posts: 48
    • View Profile
Re: Delete al images but member specific...
« Reply #8 on: August 10, 2008, 12:18:36 am »
DELETE FROM smf_gallery_pic where ID_MEMBER = 44 AND ID_CAT = 2
Worked like a charm, Ty ;-)

 

Related Topics

  Subject / Started by Replies Last post
2 Replies
2810 Views
Last post August 06, 2011, 02:35:04 pm
by Dylert
0 Replies
3286 Views
Last post January 02, 2012, 04:11:54 pm
by Vincent Volmer
2 Replies
3726 Views
Last post January 23, 2013, 12:01:58 am
by SauloA
7 Replies
6201 Views
Last post February 17, 2014, 06:36:26 pm
by shuban
2 Replies
3417 Views
Last post December 19, 2014, 08:08:57 am
by Jonas1975

+- Recent Topics

No thumbnails on new uploads by SMFHacks
March 27, 2024, 02:10:41 pm

Display the Contact Page for guests by SMFHacks
March 27, 2024, 10:55:43 am

is it possible to add support for odysee.com by fvlog19
March 21, 2024, 08:47:51 am

Request for admin notification by davejo
March 10, 2024, 01:31:59 am

I need help with torrent upload by Ineedsmfhelp
March 09, 2024, 10:01:13 pm

an idea for new mod (( content type with different display )) by SMFHacks
February 27, 2024, 01:36:27 pm

[Mod] RSS Feed Poster by SMFHacks
February 27, 2024, 11:57:18 am

find duplicate pictures by fvlog19
February 14, 2024, 02:22:40 pm

Error uploading video. by SMFHacks
February 08, 2024, 02:04:16 pm

Gallery icon as last added image by fvlog19
February 01, 2024, 01:04:56 pm

Powered by EzPortal