Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 4260
Latest: Verrick
New This Month: 0
New This Week: 0
New Today: 0
Stats
Total Posts: 43323
Total Topics: 7527
Most Online Today: 276
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 264
Total: 264

Author Topic: Delete al images but member specific...  (Read 7450 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: 16464
    • 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: 16464
    • 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
2931 Views
Last post August 06, 2011, 02:35:04 pm
by Dylert
0 Replies
3315 Views
Last post January 02, 2012, 04:11:54 pm
by Vincent Volmer
2 Replies
3815 Views
Last post January 23, 2013, 12:01:58 am
by SauloA
7 Replies
6416 Views
Last post February 17, 2014, 06:36:26 pm
by shuban
2 Replies
3515 Views
Last post December 19, 2014, 08:08:57 am
by Jonas1975

+- Recent Topics

Failed to open stream: File name too long by Randem
June 21, 2024, 10:40:41 am

Attachment images Upsidedown or Sideways by SMFHacks
June 18, 2024, 10:53:24 am

JSON decode error: The maximum stack depth has been exceeded by SMFHacks
June 14, 2024, 10:15:16 pm

“Insert from Gallery” by donk
June 10, 2024, 01:26:57 pm

Pretty Urls extras by SMFHacks
May 13, 2024, 10:28:54 am

Mod question by Verrick
May 11, 2024, 02:42:50 pm

i have paid but cant download ad pro. by SMFHacks
May 02, 2024, 11:29:38 pm

Please Help! by SMFHacks
April 17, 2024, 08:04:55 am

Rate own images by fvlog19
April 11, 2024, 10:56:53 am

Tidy Child Boards on 2.1.4 by SMFHacks
April 04, 2024, 03:54:12 pm

Powered by EzPortal