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.

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
");

I still get the error:

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

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'?

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
");

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.

woohoo! glad to help, ProtoPC. :)

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. :)

sweet

I was thinking about asking for this feature; when low and behold; here it is!

Thanks so much!

Thanks, installed on another forum!

Thanx.

Jacquii.

I would like to list all albums without the page break "Page 1 of 2" etc.
Can this be modified to fit down one page please?

TIA

EDIT: Bah!! Ignore me, found it in Options!!
Schoolboy error.

I think recent picture comments should be next!

Will be installing... This looks nice that should be a default option :p

Please add search feature for the Album

Installed but I can't get the link to show on my Navbar. Nothing in the navbar template either other than a reference to Quicklinks. Any help would be appreciated. I'm running the default template.

I can excess from Quick Links.

Installed, works great. One odd issue though; when using this with the link to it via Quick Links... on my vbAdvanced CMS homepage, it doesn't link properly to it. It is missing the /forums/ part of the url. And yes, I added all_albums.php to the Navbar Replacements field under the vBAdvanced Global Options section of the CMS's options. That should have done the trick but it didn't. My only guess is the file name containing an underscore _ in it maybe?

Just thought I'd mention this lil minor issue if you'd like to look into it then and possibly provide a resolution or alternative fix to it in the next update or something :). Great mod though so far... thanks for all the hard work put into it.

It only adds the link to your Quick Links menu.


For your homepage, I thought you had to make the edit manually in the navbar template and add /forums/ to the link.

Looking at the image provided, it shows a link on the toolbar.

https://vborg.vbsupport.ru/attachmen...1&d=1205636277

The auto-template edit only does the Quick Link edit from what I remember from install.

thanks very nice

Thank you very much, nice work

Is it me or is everytime that page loads, the user gets logged out? But when I navigate away from it, it says "Welcome, Robert" again...?

I'm stressin' out. Been searching threw the code all day..can't figure out why it's not recognizing the logged in user...?

robertpro2a: I'm going to ask the obvious.. have you tried clearing cookies, using different browsers (firefox, ie 6, ie 7) using different computers (home, work, school) to see if the behavior is reproduced across all platforms? It seems to be working fine for me.

Yeah, I have. Maybe it's an install issue...is it smart to install the entire Vbulletin package on the same server but a different sub directory...that way I can test it to see if it works? Because if it does, it may just mean that I have corrupt files on the other sub directory.

Is it possible to hide empty albums for users?
So only the creator can see his emty album.

Getting this message when trying to delete a picture

The picture deletes but we get the above error.

Yes according to VB license you can install a development version of your forum under the subdirectory "testvb" but it must be password protected (.htaccess) so only you can get to it.

How can I get the pictures to show up in the posts?
When I use the pic code inside a post, the picture only shows for users who are logged in. I want the pictures to show for visitors who are not logged in even when I set the album folder to public (not private. What am I doing wrong? How can I do this?

Thanks

I am getting this same error, but have not used this mod...i used a VB mod and the Last Picture on Forumhome mod....something is getting messed up with these mods and other people may not know becayse they are not deleting pics. Did you find a solution?

I have set the usergroup unregistered/not logged in to" can view albums", and they get the "you are not logged in" page. is there a reason for this? Plus I'd rather not have to make member info publically viewable, only the album.

THANKS, OUTSTANDING MOD!

I changed this setting for that user group as you described, and they were able to view the all_albums.php page and each of the galleries.

can someone tell me what's the use of this "Show Link in Navbits of Albums" option? I've tried on and off, see no difference.

Look at a regular album page.

Anyone know how to get the Albums feature in vBulletin to go to 'slideshow' mode like most picture sharing programs out there?

I think I have the problem solved.

Thanks!