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.

[TheLab]

Originally Posted by Abe1

Add a search? Maybe I'll try.

Hi Sorry to bother but did you find any time on getting on this?

Thanks.

[Abe1]

Version 2.4 (10/24/08):

• Added Search

Also, I had decided to give support and update this hack again since it's a shame so far of how vb's version of "all albums" look and it's features.

[CPB123]

Originally Posted by Abe1

Also, I had decided to give support and update this hack again since it's a shame so far of how vb's version of "all albums" look and it's features.

Very cool THANKS!

[texterted]

Nice one Abe1, thanks for the update and the continued support of this mod!

Cheers to theOZer for his helpful reply earlier too

[Cocko]

Originally Posted by Cocko

As I have seen equal questions here before but can't find right answers -
I would like to choose the usergroups (IDs) in ACP and only these useralbums
are listed in all albums or the opposite choose usergroups which are not listed.

Maybe it is only a small snippet?
Thanx.

Originally Posted by Abe1

Version 2.4 (10/24/08):
Also, I had decided to give support and update this hack again since it's a shame so far of how vb's version of "all albums" look and it's features.

Thanx a lot for update and support, Abe1.
Thats a good moment to ask again, maybe there is a chance for our requests.

Nominated MOTM

[ArnyVee]

Thanks! Looks good!

Is there anyway to put a little something like "Search the Albums" next to the field?

[LanciaStratos]

Thanks very much for continuing to support this add-on. vBulletin wouldn't be anywhere it is today without obvious features like this being implemented by the community. Great work.

[TsirhCitna]

Just tried the new search and got a SQL error.

PHP Code:

Database error in vBulletin 3.7.3:

Invalid SQL:

        SELECT COUNT(*) AS total
        FROM vb3_album
        WHERE state IN ('public', 'private', 'profile') AND (album.title LIKE '%waterfall%' OR album.description LIKE '%waterfall%');

MySQL Error   : Unknown column 'album.title' in 'where clause'
Error Number  : 1054
Request Date  : Friday, October 24th 2008 @ 02:58:22 PM
Error Date    : Friday, October 24th 2008 @ 02:58:22 PM
Script        : http://www.tenstones.net/forums/all_albums.php
Referrer      : http://www.tenstones.net/forums/albums.html
IP Address    : 70.61.229.26
Username      : Bob
Classname     : vB_Database
MySQL Version : 5.0.67-log 


[furst]

Hey Abe1, I was hoping to combine this hack with yours, but unfortunately the other hack doesn't work properly when placed on the all_albums.php page (the tables show up, but the cells are all empty) and the author isn't answering support questions. You ever thought of adding something like that to the top of albums page? It would really bring the discussion within the albums into a more visible area and would be good for growth and activity.

[ElForro]

I'm having the same problem as TsirhCitna

Database error in vBulletin 3.7.3:

Invalid SQL:

		SELECT COUNT(*) AS total
		FROM foro_album
		WHERE state IN ('public', 'private', 'profile') AND (album.title LIKE '%something%' OR album.description LIKE '%something%');

MySQL Error   : Unknown table 'album' in where clause
Error Number  : 1109
Request Date  : Friday, October 24th 2008 @ 06:17:43 PM
Error Date    : Friday, October 24th 2008 @ 06:17:43 PM
Script        : http://mediosregistrados.com/foro/all_albums.php?s=&sort=lastpicturedate&order=desc&page=1&query=something
Referrer      : http://mediosregistrados.com/foro/all_albums.php
IP Address    : 190.244.168.11
Username      : ElBarto
Classname     : vb_database
MySQL Version : 4.1.11-log

Maybe some TABLE_PREFIX is missing?