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.

[TrIn@dOr]

Perhaps "$vbphrase[pictures]" is not defined in phrases section?

Thanks in advance.

[ProtoPC]

Originally Posted by TrIn@dOr

Perhaps "$vbphrase[pictures]" is not defined in phrases section?

Thanks in advance.

Not sure if this reply was for me...but my Pictures phrase variable and definition is listed in Phrases.

I would love it to have emtpy albums to not show...somehow.

Here is a link to it.

[CPB123]

Originally Posted by ProtoPC

Where exactly in the two Select statements?...I added it at the end on both and got an error, ie:

$albumcount = $db->query_first("
SELECT COUNT(*) AS total
FROM " . TABLE_PREFIX . "album
WHERE state IN ('" . implode("', '", $state) . "')
AND album.visible > 0
");

I don't think you add that line to the end of the second SELECT statement (you do the first however, and it seems you have correctly done it based on your posted example) - here's how I did mine, on the first SELECT statement I did it just like yours, on the next one I added it right after the WHERE line and before the ORDER line as this made the most sense to me and lo and behold it worked on the first try. See if this helps:

SELECT album.*,
picture.pictureid, picture.extension, picture.idhash,
picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height,
user.*
FROM " . TABLE_PREFIX . "album AS album
LEFT JOIN " . TABLE_PREFIX . "picture AS picture ON (album.coverpictureid = picture.pictureid AND picture.thumbnail_filesize > 0)
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (album.userid = user.userid)
WHERE album.state IN ('" . implode("', '", $state) . "')
AND album.visible > 0
ORDER BY $sortname $sortorder
LIMIT $start, $perpage
");

[ProtoPC]

I still get the error:

MySQL Error : Unknown column 'album.visible' in 'where clause'

[CPB123]

Is that the same error you had before? I'm using this mod on 3.7.2 and the album.visible hack worked just fine, its just another condition thrown into the query. Are you able to access your forum database and see if there is a column called 'visible' in your table named 'album'?

[ProtoPC]

in table vb_album there is a column named visible.

All Columns:
albumid userid createdate lastpicturedate visible moderation title description state coverpictureid

Error Message emailed to me:

Invalid SQL:

SELECT COUNT(*) AS total
FROM vb_album
WHERE state IN ('public', 'private', 'profile')
AND album.visible > 0;

MySQL Error : Unknown column 'album.visible' in 'where clause'
Error Number : 1054

--------------------Added to---------------

$albumcount = $db->query_first("
SELECT COUNT(*) AS total
FROM " . TABLE_PREFIX . "album
WHERE state IN ('" . implode("', '", $state) . "')
AND album.visible > 0
");

------------And--------------

$albums = $db->query_read("
SELECT album.*,
picture.pictureid, picture.extension, picture.idhash,
picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height,
user.*
FROM " . TABLE_PREFIX . "album AS album
LEFT JOIN " . TABLE_PREFIX . "picture AS picture ON (album.coverpictureid = picture.pictureid AND picture.thumbnail_filesize > 0)
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (album.userid = user.userid)
WHERE album.state IN ('" . implode("', '", $state) . "')
AND album.visible > 0
ORDER BY $sortname $sortorder
LIMIT $start, $perpage
");

[CPB123]

Okay I think you're getting closer - since you have a table prefix of vb_ try this

$albumcount = $db->query_first("
SELECT COUNT(*) AS total
FROM " . TABLE_PREFIX . "album
WHERE state IN ('" . implode("', '", $state) . "')
AND vb_album.visible > 0
");

but leave the second SELECT statement as album.visible don't change that one to vb_album.visible and see what happens

[ProtoPC]

Originally Posted by CPB123

Okay I think you're getting closer - since you have a table prefix of vb_ try this

$albumcount = $db->query_first("
SELECT COUNT(*) AS total
FROM " . TABLE_PREFIX . "album
WHERE state IN ('" . implode("', '", $state) . "')
AND vb_album.visible > 0
");

but leave the second SELECT statement as album.visible don't change that one to vb_album.visible and see what happens

Thank you! That fixed it.

[CPB123]

woohoo! glad to help, ProtoPC.

[Smiry Kin's]

One of the most usful addons, altho this should have been default with vbulletin, go copyright it and make them pay you to use it.