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.

[J105C]

Marked as Installed, thank you!

[Floris]

The mod is for ALL albums .. so the answer should be no.
But having opt-in to not show private albums, would be nice in the next version.

[J105C]

Is there any way possible that you could "sticky" certain albums?

[Koolvin]

I get this error,

PHP Code:

Database error in vBulletin 3.8.2:

Invalid SQL:

        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  : Saturday, April 18th 2009 @ 08:37:00 PM
Error Date    : Saturday, April 18th 2009 @ 08:37:00 PM
Script        : /forums/all_albums.php
Referrer      : 
IP Address    : 
Username      : 
Classname     : vB_Database
MySQL Version : 5.0.67-community 


[hn74]

Pefrect ..

thank u so much

[remixss]

thnx alot

[Koolvin]

Originally Posted by Koolvin

I get this error,

PHP Code:

Database error in vBulletin 3.8.2:

Invalid SQL:

        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  : Saturday, April 18th 2009 @ 08:37:00 PM
Error Date    : Saturday, April 18th 2009 @ 08:37:00 PM
Script        : /forums/all_albums.php
Referrer      : 
IP Address    : 
Username      : 
Classname     : vB_Database
MySQL Version : 5.0.67-community 


I thought this add-on was supported?

[Lynne]

Originally Posted by Koolvin

I thought this add-on was supported?

Did you import the xml file and set a value for sortfield and sortorder in the vboptions area?

(Also, if you look, you'll see the developer hasn't been online since March. Personal life always takes precedence over forum life.)

[Koolvin]

yes of course, - re-downloaded and re-installed - its now working...

just a suggestion - should we include the MD5 sum for all files that way we can verify the downloads havn't been corrupted.

Thanks.

[Lynne]

Originally Posted by Koolvin

yes of course, - re-downloaded and re-installed - its now working...

just a suggestion - should we include the MD5 sum for all files that way we can verify the downloads havn't been corrupted.

Thanks.

I'd guess there are a large number of users here who wouldn't have a clue what to do with an md5 file - and they are probably the ones who would need to know what to do with it!