Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 28 Mar 2011, 12:07
Chadi's Avatar
Chadi Chadi is offline
 
Join Date: May 2004
Mass Delete User Albums

How do I mass delete all user albums in 3.8?
__________________
...............................
Talk Jesus Forums: Christian Chat
games . chat . gallery . bible . videos
Reply With Quote
  #2  
Old 09 Apr 2011, 12:00
Chadi's Avatar
Chadi Chadi is offline
 
Join Date: May 2004
Can someone please help?
__________________
...............................
Talk Jesus Forums: Christian Chat
games . chat . gallery . bible . videos
Reply With Quote
  #3  
Old 10 Apr 2011, 22:19
CRDeveloper's Avatar
CRDeveloper CRDeveloper is offline
 
Join Date: Aug 2009
Real name: Pablo X.
I need to do it on vb 4 too!
Reply With Quote
  #4  
Old 18 Apr 2011, 18:37
Chadi's Avatar
Chadi Chadi is offline
 
Join Date: May 2004
Anyone? Thanks
__________________
...............................
Talk Jesus Forums: Christian Chat
games . chat . gallery . bible . videos
Reply With Quote
  #5  
Old 18 Apr 2011, 21:01
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
Warning: try this at your own risk - back up your database first. There is no "are you sure you want to do this message". You have been warned.

I only did one test to see if this worked at all (on vb 3.8.3 - I have no idea if this will work for vb4), but here it is: make a plugin using hook location admin_maintenance and this code:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


Then when you're sure you're ready to try it, type in the url [your forum]/admincp/misc.php?do=deleteallalbums .

You probably now want to delete or at least disable that plugin.

ETA: for anyone who feels like confirming it's legit - I used the code from the file album.php, the "do == killalbum" section that gets called when a user deletes an album. The first query I got from fetch_albuminfo() in includes/functions_album.php (but I removed the WHERE for the userid).

Last edited by kh99; 18 Apr 2011 at 23:35.
Reply With Quote
  #6  
Old 18 Apr 2011, 21:59
Chadi's Avatar
Chadi Chadi is offline
 
Join Date: May 2004
Thanks for your help. Can any coder here confirm this plugin looks legit?
__________________
...............................
Talk Jesus Forums: Christian Chat
games . chat . gallery . bible . videos
Reply With Quote
  #7  
Old 12 Oct 2013, 14:51
paulgee paulgee is offline
 
Join Date: Nov 2006
albums

there is an easier way?

if you don't want albums at all just switch them off i.e.
in vboptions > user profile options > enabled profile features

then back up your database............

to remove all existing albums use phpmyadmin, locate usually VB# albums and select it then click empty on you phpadmin panel.

you can do this with album images as well.

doing this saved me tons of space in my database and stopped spammers using the albums area as a spamming tool.

Regards
Paul
Reply With Quote
  #8  
Old 29 Aug 2015, 17:45
yotsume's Avatar
yotsume yotsume is offline
 
Join Date: Jan 2007
In VB 37x I need a way to delete orphaned albums of users that were deleted who had created albums. When these users were deleted their albums remain and can NOT be accessed but their thumbnails show up.

I would rather keep albums of current members...

UPDATE: Silly me! The solution is way too simple. Just use phpmyadmin and delete the tables in vb_album related to the orphaned User IDs. PROBLEM SOLVED!
__________________
Yotsume
Kaydev Media Productions
Check out my mods
:
EYO-AIM, FlashChat Combo-Module for vBadvanced 3.6x or 3.7x

Last edited by yotsume; 29 Aug 2015 at 18:29. Reason: Found my own solution.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 06:00.

Layout Options | Width: Wide Color: