Welcome Guest ( Log In | Register )

UploadScript

Check out the FREE chatroom mod for IPB 3.x

> IPB Help

IMPORTANT DISCLAIMER - PLEASE READ

You are currently in an unofficial IPB help forum where members assist other members with Invision Power Board. While you may receive help with your Invision Power Board questions in this forum it is important to note the following:

Note: Let us state again that support provided in IPB Help is provided by the kindness of others. The staff of Invisionize do not officially provide support for Invision Power Board. If you would like official support from Invision Power Services, please open a new support ticket from your Invision Power Services Customer Area page.

 
Closed TopicStart new topic
[RESOLVED]How to delete all avatars and photos from DB?
Rowantjuh
post Feb 9 2010, 07:42 AM
Post #1


Newbie
*

Group: Members
Posts: 16
Joined: 31-July 08
Member No.: 337,259
IPB Version: 2.3.x



Hello all,

One week ago I accidently lost all forum files, because of that I lost all uploaded avatars and profile photos. I have to know how to remove all av-*.jpg avatars (or all if easier) and profile photos from the DB. I already tried the "Remove orphaned uploaded avatars" and "Remove orphaned uploaded photos" tools and it didn't do what I want.

I know I'm able to remove them manually with phpmyadmin but it's pretty much work to do this one by one.

Thanks in advance!

Rowantjuh

This post has been edited by Rowantjuh: Feb 9 2010, 08:52 AM
Go to the top of the page
 
+Quote Post
villabus
post Feb 9 2010, 10:05 AM
Post #2


Too Much Free Time
******

Group: Members
Posts: 6,515
Joined: 18-March 06
Member No.: 210,884



Ok I am going with 2,3x .

In phpmyadmin use these commands:
SQL
update ibf_member_extra set avatar_location = '' , avatar_size = '', avatar_type = '' where avatar_type = 'upload';
update ibf_member_extra set photo_location = '' , photo_dimensions = '', photo_type = '' where photo_type = 'upload';


Be sure to back up the table first.


--------------------
If you feel my help was worth something you can help me. Thanks.
Make A Donation

Will do Mods & Installations. Fix PHP code or write some new code. Pm Me for pricing.

Go to the top of the page
 
+Quote Post
Rowantjuh
post Feb 9 2010, 10:14 AM
Post #3


Newbie
*

Group: Members
Posts: 16
Joined: 31-July 08
Member No.: 337,259
IPB Version: 2.3.x



Worked perfect!

Thanks a lot! cool.gif
Go to the top of the page
 
+Quote Post
villabus
post Feb 9 2010, 10:36 AM
Post #4


Too Much Free Time
******

Group: Members
Posts: 6,515
Joined: 18-March 06
Member No.: 210,884



You are welcome.


--------------------
If you feel my help was worth something you can help me. Thanks.
Make A Donation

Will do Mods & Installations. Fix PHP code or write some new code. Pm Me for pricing.

Go to the top of the page
 
+Quote Post
ssj4gogita4
post Feb 12 2010, 10:24 PM
Post #5


Squidward Tortellini
*******

Group: Members
Posts: 10,677
Joined: 19-February 05
From: Planet Vegeta
Member No.: 145,607
IPB Version: 2.3.x



Glad your question has been answered. Please feel free to open another topic if you have any other problems. smile2.gif

Topic closed.


--------------------
Go to the top of the page
 
+Quote Post

Closed TopicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



RSS Lo-Fi Version Time is now: 16th March 2010 - 11:49 PM
Invision Skins · IPB Skins