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:
- These forums are browsed by helpful members just like you who volunteer their time to assist you. Please keep that in mind when asking questions.
- Invisionize staff does not officially provide support for Invision Power Board. You may see a staff person helping from time to time but please keep in mind they are also volunteering their time when posting in this forum.
  |
|
[RESOLVED]How to delete all avatars and photos from DB?
|
 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 |
 |
 
|
|
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. |
|
|
|
|
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! 
|
|
|
|
|
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. |
|
|
|
|
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.
Topic closed. -------------------- |
|
|
|
|
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:
|
Lo-Fi Version | Time is now: 16th March 2010 - 11:49 PM |