Social Group and Album Enhancements - All Albums

All Albums 2.5

This hack lets you view an index of all user albums on one page. Looks like a user's index but just has all users instead of just one.

You have to upload the all_albums.php file to your root vBulletin folder. This is the file that you have to access to see all the albums.

ENJOY!

Version 1.1 (03/06/08):

• PHP file only.
• Doesn't show albums that a user can't view.

Version 1.2 (03/09/08):

• PHP file only.
• Fixed Image count if you have vb3.7.0 Beta 6.

Version 2.0 (03/15/08):

• Product MUST be installed now.
• Shows username
• Phrases are normal now.

Version 2.1 (03/19/08):

• PHP file only.
• Fixed Image count if you have vb3.7.0 RC 1.

Version 2.2 (03/21/08):

• Cache Templates
• Fixed some issues with extra queries running.
• Added "Add Album" links.
• album_all_album_list template updated.
• File updated.

Version 2.3 (05/05/08):

• Changed definition of THIS_SCRIPT to all_albums
• Link in navbar is now phrase along with a template.
• all_albums phrase switched to global phrase
• Added all albums link to navbits when on an album page.
• Added who's online location.
• Added sort
• New option: Default Sortfield
• New option: Default Sortorder
• Added link to quick links.
• New option: Show Navbar Link
• New Option: Show Quick-Links Link
• New Option: Show Link in Navbits of Albums

Version 2.4 (10/24/08):

• Added Search

Version 2.5 (10/24/08):

• Added Search text right near search box
• Fixed a prefix bug when using search.
• If a user knows that to put into a URL to do a search, if search is turned off, it will not work.

MAKE SURE YOU CLICK INSTALL!
You will get an email when a new version is released.

[gonzek]

Hi,

anybody knows something about hack like this for vb 4.x?

[SiteTalkZone]

Originally Posted by gonzek

Hi,

anybody knows something about hack like this for vb 4.x?

yes here https://vborg.vbsupport.ru/showthread.php?t=237931

good luck

[Alfa1]

After upgrading to vb3.8.7 and php 5.3.8, I get the same error as floggerss:

Originally Posted by floggerss

I get this errror

SELECT album.*,
> picture.pictureid, picture.extension, picture.idhash,
> picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height,
> user.*
> FROM album AS album
> LEFT JOIN picture AS picture ON (album.coverpictureid = picture.pictureid AND picture.thumbnail_filesize > 0)
> LEFT JOIN user AS user ON (album.userid = user.userid)
> WHERE album.state IN ('public', 'private', 'profile')
> ORDER BY
> LIMIT 0, 10;
>
> MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 10' at line 10
> Error Number : 1064
> Request Date : Sunday, February 13th 2011 @ 02:35:14 PM
> Error Date : Sunday, February 13th 2011 @ 02:35:15 PM
> Script : http://stylers.com.ar/all_albums.php
> Referrer :

Does anyone have a fix?

[BirdOPrey5]

The problem is the SQL statement is missing something after "ORDER BY" it should be ORDER BY _field_name_ of some sort, not sure what off hand though.

[jskoh]

hi, can manually insert the script. one of my template isnt showing the "All album" on the nav bar. where and what should i add on the template?

[accludetuner]

Originally Posted by BirdOPrey5

The problem is the SQL statement is missing something after "ORDER BY" it should be ORDER BY _field_name_ of some sort, not sure what off hand though.

There are sort options:

PHP Code:

ORDER BY $sortname $sortorder 


The issue I noticed is that I was getting this error because of malformed URLs. Every time I received this invalid SQL error, the URL had the "?language=" added at the end of the URL - /forum/all_albums.php?language=af

Not sure if that helps some of you with this error.

-P

[LenBoyer]

I am verified on the board, and not showing up as unregistered. Any Ideas?

Len

LenBoyer, you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

[mykkal]

can we get thumbnails & descriptions?