All Albums

[Abe1]

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 (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=172215)!
You will get an email when a new version is released.

[7lanet]

thanks
this demo ^_^

http://www.7lanet.com/vb/all_albums.php

^_^

[romanticyao]

demo or screens?

[romanticyao]

works great, thanx

[7lanet]

this demo ^_^

http://www.7lanet.com/vb/all_albums.php

[Abe1]

demo or screens?
No need for one. Same as now just show all.

[Zaiaku]

Looks pretty good, although the demo is super bright that is almost blinded me. :)

[Syria BoY]

Good work Thanks Abe1 :)

[Hornstar]

Thanks, this was exactly what I was waiting for :)

[rolandogomez]

Perfect! Installed!

[Barakat]

yap perfect!!!!!

[KURTZ]

this demo ^_^

http://www.7lanet.com/vb/all_albums.php

eheheh not many understands arabic ... :P

[Cornie]

which me is still missing is the user name with the albums

[ThePulse]

This mod is great :D would also love for it to show which member the album comes from

[Adem GEN?]

Thanks
very good

Display username to albums title

[D|ver]

really great mod!
yep, displaying the username would be nice :)

[FleaBag]

Thanks Abe!

[ChurchMedia]

Cool and easy! I'd like to hide the private albums, though. Good work!

[7lanet]

eheheh not many understands arabic ... :P

There is no problem
Go to the last page
, Change the language to English
This is not difficult

[4seasonz]

very nice mod , thanks a lot

[rolandogomez]

Cool and easy! I'd like to hide the private albums, though. Good work!

Have to agree, change it where private albums are not shown and a link to the user's profile of the owner of the album. Thanks, rg.

[Adem GEN?]

// navbar and final output
$navbits = construct_navbits(array(
'album_all.php' . $vbulletin->session->vars['sessionurl_q'] => construct_phrase($vbphrase['xs_profile'], $userinfo['username']),
'' => $vbphrase['albums']
));
eval('$navbar = "' . fetch_template('navbar') . '";');
eval('print_output("' . fetch_template('album_list') . '");');
?>


Not files album_all.php

[RvG2]

// navbar and final output
$navbits = construct_navbits(array(
'album_all.php' . $vbulletin->session->vars['sessionurl_q'] => construct_phrase($vbphrase['xs_profile'], $userinfo['username']),
'' => $vbphrase['albums']
));
eval('$navbar = "' . fetch_template('navbar') . '";');
eval('print_output("' . fetch_template('album_list') . '");');
?>

what this code is all about? :)

[Abe1]

// navbar and final output
$navbits = construct_navbits(array(
'album_all.php' . $vbulletin->session->vars['sessionurl_q'] => construct_phrase($vbphrase['xs_profile'], $userinfo['username']),
'' => $vbphrase['albums']
));
eval('$navbar = "' . fetch_template('navbar') . '";');
eval('print_output("' . fetch_template('album_list') . '");');
?>


Not files album_all.php
Just updated the php file to fix it.

[Abe1]

Have to agree, change it where private albums are not shown and a link to the user's profile of the owner of the album. Thanks, rg.
I wanted to just get this hack out right now. I will do more research into it now so permissions are kept.

[Sychev_S]

I wanted to just get this hack out right now. I will do more research into it now so permissions are kept.

You sure made a lot of people happy. Very usefull hack! Thank you so much!

[Alfa1]

This error was on page 4 of your demo:
Forbidden

You don't have permission to access /vb/all_albums.php on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

[Abe1]

Version 1.1 (03/06/08):
PHP file only.
Doesn't show albums that a user can't view.

[Brandon Sheley]

nice hack, now no need for the gallery script :D

* Brandon Sheley installs for later

[Savage702]

Can it be made to show who the owner of each album in the list is?

[furst]

Thanks, this is exactly what I was looking for.

[Alfa1]

nice hack, now no need for the gallery script :D
It is getting close to this. With this hack, we have member albums covered. If we can get topic albums sorted somehow, then we are set.

[Abe1]

Can it be made to show who the owner of each album in the list is?
I would have to start making this into a whole product. Not sure if i'll do or not.

[rolandogomez]

This script is working great, but for some reason all my number of photos in the "Pictures" column has reset to zero. http://www.shotcritic.com/forums/all_albums.php Any ideas? Thanks, rg.

[maidos]

i would love to have the feature so pp lcan see the username

[maidos]

please delete this reply

[D|ver]

This script is working great, but for some reason all my number of photos in the "Pictures" column has reset to zero. http://www.shotcritic.com/forums/all_albums.php Any ideas? Thanks, rg.
same problem here. error appears now after the upgrade to beta 6

[Abe1]

Version 1.2 (03/09/08):
PHP file only.
Fixed Image count if you have vb3.7.0 Beta 6.

[rolandogomez]

Perfect, fixed my counter problems with Beta 6. All good, for demo, see here: http://www.shotcritic.com/forums/all_albums.php Thanks, rg sends!

[Adem GEN?]

Thanks

[JazzleBug]

Good stuff. Super simple, but good stuff. Thanks!

[furst]

It would be nice if the Add Album button was on all_albums.php too.

[KingAdora]

Great script, would also love to see the 'add' link included, and also be able to see the username for the album - which clicks to the user profile.

Great job, keep it up :D

[7lanet]

Can you add another established by the Photo Album Members of the Home of the Forum?

[katilkuzu]

Can you add another established by the Photo Album Members of the Home of the Forum?

yeah really good idea, i need also something like

[BBF]

thanks for this one :)

only one little problem:

change


$navbits = construct_navbits(array(
'all_albums.php' . $vbulletin->session->vars['sessionurl_q'] => construct_phrase($vbphrase['xs_profile'], $userinfo['username']),
'' => $vbphrase['albums']
));


to:


$navbits = construct_navbits(array(
'all_albums.php' . $vbulletin->session->vars['sessionurl_q'] => construct_phrase($vbphrase['xs_albums'], $userinfo['username']),
'' => $vbphrase['albums']
));

[rolandogomez]

thanks for this one :)

only one little problem:

change


$navbits = construct_navbits(array(
'all_albums.php' . $vbulletin->session->vars['sessionurl_q'] => construct_phrase($vbphrase['xs_profile'], $userinfo['username']),
'' => $vbphrase['albums']
));


to:


$navbits = construct_navbits(array(
'all_albums.php' . $vbulletin->session->vars['sessionurl_q'] => construct_phrase($vbphrase['xs_albums'], $userinfo['username']),
'' => $vbphrase['albums']
));


What does this do? Do we have to change this in the php file? Thanks, rg.

[Abe1]

thanks for this one :)

only one little problem:

change


$navbits = construct_navbits(array(
'all_albums.php' . $vbulletin->session->vars['sessionurl_q'] => construct_phrase($vbphrase['xs_profile'], $userinfo['username']),
'' => $vbphrase['albums']
));


to:


$navbits = construct_navbits(array(
'all_albums.php' . $vbulletin->session->vars['sessionurl_q'] => construct_phrase($vbphrase['xs_albums'], $userinfo['username']),
'' => $vbphrase['albums']
));

Thanks. Will be in next version.

[Enclave]

What does this do? Do we have to change this in the php file? Thanks, rg.

No you don't have to, that is in the product!

[Spingo]

It's not too difficult to customise this add-on to provide User Names with each Album, but as the Author has said, these modiications turn the mod into more of a "product" than simply adding a simple PHP file. I have done the following modifications in order to accomplish this on one of my sites (and the author may feel free to use any of this code to provide this feature if he/she so wishes):

In all_albums.php, change:
$albums = $db->query_read("
SELECT album.*,
picture.pictureid, picture.extension, picture.idhash,
picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height,
FROM " . TABLE_PREFIX . "album AS album
LEFT JOIN " . TABLE_PREFIX . "picture AS picture ON (album.coverpictureid = picture.pictureid AND picture.thumbnail_filesize > 0)
WHERE album.state IN ('" . implode("', '", $state) . "')
ORDER BY album.lastpicturedate DESC
LIMIT $start, $perpage
");
to:
$albums = $db->query_read("
SELECT album.*,
picture.pictureid, picture.extension, picture.idhash,
picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height,
user.username
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) . "')
ORDER BY album.lastpicturedate DESC
LIMIT $start, $perpage
");
Next, change:
eval('$albumbits .= "' . fetch_template('albumbit') . '";');

to:
eval('$albumbits .= "' . fetch_template('all_albumbit') . '";');

and then, change:
eval('print_output("' . fetch_template('album_list') . '");');

to:
eval('print_output("' . fetch_template('all_album_list') . '");');


Next, go into Style Manager in the admincp and copy the contents of the albumbit template into a new template and call it all_albumbit. Then copy the contents of the album_list template into a new template called all_album_list. For there, you can edit these two new templates to add a User Name column. For instance, in all_album_list, I have changed:
<tr>
<td class="thead">Thumbnail</td>
<td class="thead" width="80%">$vbphrase[album_title]</td>
<td class="thead" width="5%" align="center">$vbphrase[pictures]</td>
<td class="thead" width="15%" nowrap="nowrap">$vbphrase[last_picture]</td>
</tr>
to:
<tr>
<td class="thead">Thumbnail</td>
<td class="thead" width="80%">$vbphrase[album_title]</td>
<td class="thead">Author</td>
<td class="thead" width="5%" align="center">$vbphrase[pictures]</td>
<td class="thead" width="15%" nowrap="nowrap">$vbphrase[last_picture]</td>
</tr>
and in all_albumbit, I have changed:
<div class="smallfont">
$album[description_html]
<if condition="$show['personalalbum']"><span class="shade">$albumtype</span></if>
</div>
</td>
<td class="alt1" valign="middle" align="center">$album[picturecount]</td>
<td class="alt2" valign="middle" nowrap="nowrap">

to:
<div class="smallfont">
$album[description_html]
<if condition="$show['personalalbum']"><span class="shade">$albumtype</span></if>
</div>
</td>
<td class="alt2" valign="middle" align="center">
$album[username]
</td>
<td class="alt1" valign="middle" align="center">$album[picturecount]</td>
<td class="alt2" valign="middle" nowrap="nowrap">


After some tidying up with the class tags (so as to make the colour alternate as intended, I have a pretty good looking result, as shown in the attachment.

Of course, you could customise the order of the columns if you'd like, or even add avatars to the user name without too much difficulty.

I should say that I whipped this mod up in about 15 minutes - so the usual caveat applies - I take no responsibility if something goes awry and it's possible that the code in all_almbums.php after my modifications could require some additional optimisation (specifically, I have not benchmarked what impact my additional JOIN has on the SQL side of things).

Enjoy.

[AWMGolfer]

Works great!! Thank you!!

[ChurchMedia]

Thanks, Spingo! I'd like to make the albums as full featured as possible since I run a community that does graphics for a living. I hope to see an album search mod sometime (I'm too lazy to write one).

This is a great mod to a great mod! :)

[rolandogomez]

Cool Spingo! Now how do we make the user's name link to their profile (grin) That would be cool. And to that, if when selecting an album to view, add the album owner's name and link too along with when viewing a photo, something, like "go to user's profile" or "go to all albums by X user." Especially for us non-php types. Thanks, rg sends!

[Spingo]

Well, you can quickly link to the profile of the album author by editing the all_albumbit template and changing:
$album[username]
to:
<a href="member.php?$session[sessionurl]u=$album[userid]">$album[username]</a>

You can tweak the template a bit more if you want to link to other albums by that user - it's the same as above but in this case, you'd link to album.php instead of member.php.

I'm currently fiddling with getting avatars to display too, but I might have to come back to this later as I'm about to head out...

[rolandogomez]

Well, you can quickly link to the profile of the album author by editing the all_albumbit template and changing:
$album[username]
to:
<a href="member.php?session[sessionurl]u=$album[userid]">$album[username]</a>

You can tweak the template a bit more if you want to link to other albums by that user - it's the same as above but in this case, you'd link to album.php instead of member.php.

I'm currently fiddling with getting avatars to display too, but I might have to come back to this later as I'm about to head out...

The rest worked, but this change too me to a page that said, "This user has not registered and therefore does not have a profile to view." on every username I clicked on, the url shows up like this, http://www.shotcritic.com/forums/member.php?session[sessionurl]u=25 and for some reason that don't look right.

So I played, as I don't know what I'm doing, what I found worked was this code,
<a href="member.php?u=$album[userid]">$album[username]'s<br> Profile</a><hr noshade width="50">
<a href="album.php?u=$album[userid]"> Albums</a>

Which generates this page on my site, http://www.shotcritic.com/forums/all_albums.php

I would like to know how to "de-link" the user's name so only the "Profile" and "Albums" links are visible and I'd like to color the font too for the album owner's name (username) I just am not that good as I'm no coder, this was pure luck.

No what would be cool, when folks click on the albums' names and it takes you to that album, if on that page, the albums.php page, that would have that album owners name and link to their profile.

Thanks, rg sends!

[Savage702]

Thank you so much Spingo!! Awesome additions!!!

[Spingo]

The rest worked, but this change too me to a page that said, "This user has not registered and therefore does not have a profile to view."

I have edited the above post with the all important but missing "$" before "session".

[rolandogomez]

I have edited the above post with the all important but missing "$" before "session".

So I don't screw it up, what do I change in this code
<a href="member.php?u=$album[userid]">$album[username]'s<br> Profile</a><hr noshade width="50">
<a href="album.php?u=$album[userid]"> Albums</a>
so I can keep the user's profile and albums links, also how do I de-link the user's name itself, i.e.,

User's Name (not link)
Profile (linked as in my URL below)
____

Albums (linked as in my URL below)

See how this code displays it on my site now,
http://www.shotcritic.com/forums/all_albums.php

Thanks, rg sends!

[Abe1]

Version 2.0 (03/15/08):
Product MUST be installed now.
Shows username
Phrases are normal now.

[Adem GEN?]

Thanks

[7lanet]

Thank you, my dear, for this achievement
Have a suggestion:

Non-appearance of albums that do not contain images
Album governing option introduced a vertical or horizontal
And making the most of each row album seems nicer appearance .

[antiekeradio]

very cool! gives the albums functionality in 3.7 a functional boost!

install went easy, works 100%. top plugin.

[rolandogomez]

Does anyone know how we can add album views? And even how many times a photo has been viewed? Thanks, rg sends!

[Savage702]

I'd like to know if there is a way to view if a photo has comments in an album, rather than having to look at each picture to see comments. Album views like Rolando said too... heck, Picture views too...

[TaBaTaN]

really nice, installed
_________________
http://www.netplay.com.ar

[bryanb]

Thanks Abe1!! Great mod! My members were asking for something like this just today, and here it is. :)

Non-appearance of albums that do not contain images.

I'd like to know if there is a way to view if a photo has comments in an album, rather than having to look at each picture to see comments.

These would be most helpful. Also, Is there a way to sort these by user name? That would be great too.

Looks like we want to keep you busy :D

[Abe1]

I'll see what I can do guys.

[theOZer]

Running vB3.7.0 RC1.
Installed My Albums V2.0.
When I click on 'All Albums' off the navbar, I do indeed see all user albums but under the Pictures columns all have 0 (zero) pictures.

[SgtTechHead]

Running vB3.7.0 RC1.
Installed My Albums V2.0.
When I click on 'All Albums' off the navbar, I do indeed see all user albums but under the Pictures columns all have 0 (zero) pictures.

This is due to the file "all_albums.php" checking for the version of vBulletin. This code in particular:

if (version_compare($vbulletin->options['templateversion'], '3.7.0 Alpha 6', '<'))
{
$album['picturecount'] = vb_number_format($album['picturecount']);
}
else
{
$album['picturecount'] = vb_number_format($album['visible']);
}

I commented the following lines out of that section so that it only uses "vb_number_format($album['visible'])":

// if (version_compare($vbulletin->options['templateversion'], '3.7.0 Alpha 6', '<'))
// {
// $album['picturecount'] = vb_number_format($album['picturecount']);
// }
// else
// {
$album['picturecount'] = vb_number_format($album['visible']);
// }

I assume the version check was there because the field names were changing from version to version. My fix may not be pretty, but it does work :)

[Abe1]

This is due to the file "all_albums.php" checking for the version of vBulletin. This code in particular:

if (version_compare($vbulletin->options['templateversion'], '3.7.0 Alpha 6', '<'))
{
$album['picturecount'] = vb_number_format($album['picturecount']);
}
else
{
$album['picturecount'] = vb_number_format($album['visible']);
}

I commented the following lines out of that section so that it only uses "vb_number_format($album['visible'])":

// if (version_compare($vbulletin->options['templateversion'], '3.7.0 Alpha 6', '<'))
// {
// $album['picturecount'] = vb_number_format($album['picturecount']);
// }
// else
// {
$album['picturecount'] = vb_number_format($album['visible']);
// }

I assume the version check was there because the field names were changing from version to version. My fix may not be pretty, but it does work :)
I came up with a better way. Check my new update in a few min.

[Abe1]

Version 2.1 (03/19/08):
PHP file only.
Fixed Image count if you have vb3.7.0 RC 1.

[SgtTechHead]

I came up with a better way. Check my new update in a few min.

Thanks for the update ;)

[Gemma]

Thanks for the update :)

[theOZer]

Abe1,
V2.1 in vB370RC1 nows shows the picture counts. Thank you!
This mod adds a valuable feature to vB370. I'm glad you wrote it.
I look forward to any and all further embellishment you may make to this mod.
~OZ

[MrToasty]

Installed when you first released, and I'm very impressed with the timely updates through the beta stages. You rock! :)

[Abe1]

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.

[Zebra]

Great, fast update! Works good..

[Adem GEN?]

Thanks

[furst]

Nice update. Thanks for adding the add button.

This may be outside the scope of what you have planned for this mod, but is there any chance of adding a top stats-esque box near the top that would show a certain number of the most recent comments in all albums? I feel that there is a need to highlight the activity that goes on in the albums, as currently only the album owner is made aware of new comments.

[TaBaTaN]

updated. Thank you.
Very nice hack

[cheat-master30]

You mispelt instructions. But I'll try updating with the new version, since the old one now for some reason says that all albums have 0 images.

Edit: That fixed it. Then had to disable the plugin to stop the automatic link in the navbar.

[nerofix]

How about an amount of total picturecomments of each album, would that be a possible idea?

[gwerzal]

Thank you very much. Just what i needed.

Why don't vbulletin put these features in as standard.

[Abe1]

Why don't vbulletin put these features in as standard.

No clue. I wish they did.

[user02934123123]

This looks a great modification, and works well.

A question: Is there a way to remove it from the template hook in the navbar? I'd very much like to use the hack, but don't want it displayed as a main option in the navbar / toolbar. How can I detach it from this location, and insert it elsewhere by adding HTML code to a template at the location I'd like it?

Thanks in advance.

[RvG2]

No clue. I wish they did.

I guess this is the reason why there's vbulletin.org :)

[jeddah_eyes]

thank you brother

http://www.dm3ty.net/vb/all_albums.php

[tounet]

Thank you for the mods it is a very good idea. :up:

But you must change the product.xml and let the user save the link in the navbar only one because the styles are not all same it's a bug

Yours Tounet

[Koroku]

Absolutely loving this hack... should be a main feature. :)

[nightbloom]

This is a great mod. ^^ It should be stock but thank goodness you guys are here making the obvious (and the not-s-obvious) a reality.

[Abe1]

Thank you for the mods it is a very good idea. :up:

But you must change the product.xml and let the user save the link in the navbar only one because the styles are not all same it's a bug

Yours Tounet
Only if you are using a custom template from before vb 3.6.6. You should make sure your templates are up-to-date. All coders are using the template hooks now. No more manual edits.

[Mark.B]

I have mixed feelings on template hooks. They are great for stock boards but I have had to comment some of mine out of the templates so that I have full control over where in the navbar the links appear. For example, I didn't want blog and project tools next to each other, and they both use the same template hook.

[Abe1]

I have mixed feelings on template hooks. They are great for stock boards but I have had to comment some of mine out of the templates so that I have full control over where in the navbar the links appear. For example, I didn't want blog and project tools next to each other, and they both use the same template hook.
Then just remove all the code from the template that I add and move it where you want.

[hrk]

simple n sweet.
thanks!

[Mark.B]

Then just remove all the code from the template that I add and move it where you want.
Oh yes...there's no problem....my apologies. Your mod is working fine for me.

I was just making a general comment on template hooks. :D

[Forum Lover]

Marked as Installed

[furst]

It would be nice if for the next update it said something other than

Unknown Location
/all_albums.php

in Who's Online.

[extremesanity]

It would be nice if for the next update it said something other than

Unknown Location
/all_albums.php

in Who's Online.You can most likely fix this by using the method Lionel originally devised as explained by me here:

http://www.vbadvanced.com/forum/showthread.php?p=116486#post116486

[buro9]

What about making the table headers sortable?

Scenarios:

1) I want to find a specific gallery from last year, not sure what it's called but I know that there's an immense number of pictures in there, if only I could order by the number of pictures in the gallery, descending.

2) Can't recall the users name, but started with E I think... if only I could order by the owner so that I could browse through the galleries owned by users starting with an E.

[Nikke]

Is this really phrased? Tried changing the All Albums phrase but nothing happened...

[buro9]

I noticed that too... edit the plugin that was installed as part of the product.

[baghdad4ever]

thanks

[BraindGee]

Is there any change there could be an option added to show all pictures from all albums?

i.e. the top one link on all_albums could be "show all" and this allows you to just view all images from all ablums in one place..

ta

[madmax1228]

Running 3.7 RC 3. I am new.....I can not see the link in my nav bar. any suggestions?

This is my first hack so take it easy on me. I do have a custom theme and wonder if that may cause some additional links.

[madmax1228]

Just had to tweak it a bit.....now she's running well....I really like it!

[Abe1]

Is there any change there could be an option added to show all pictures from all albums?

i.e. the top one link on all_albums could be "show all" and this allows you to just view all images from all ablums in one place..

ta
Would need to edit the album.php then.

[Abe1]

Is this really phrased? Tried changing the All Albums phrase but nothing happened...
Recheck which phrase to change.

[yaoren]

I just upgraded to VB 3.7.0 RC 4 and with that they recommended using php 5. I did this previously when I tried using another mod but when switched your hack doesn't work at all. It allows the link in the navbar but when you click on an image a white page shows up. Also when I have your hack installed and upgraded to php5 it blocks me out of viewing user info. Says they are not registered and such.

I've currently disabled the hack and everything is back to normal while on php5. Any suggestions?

[Abe1]

I just upgraded to VB 3.7.0 RC 4 and with that they recommended using php 5. I did this previously when I tried using another mod but when switched your hack doesn't work at all. It allows the link in the navbar but when you click on an image a white page shows up. Also when I have your hack installed and upgraded to php5 it blocks me out of viewing user info. Says they are not registered and such.

I've currently disabled the hack and everything is back to normal while on php5. Any suggestions?
I would have to see the page on your site in order to figure out what was wrong.

[madmax1228]

Upgrade to RC4 went well. Albums intact.:)

[swa]

i'm getting the following problem with rc4
Your submission could not be processed because a security token was missing or mismatched.

If this occurred unexpectedly, please inform the administrator and describe the action you performed before you received this error.

this happens after a new user signs up.

[cookiepants]

Just what I was looking for, thank you!!!

[cookiepants]

One thing I've had trouble with, it says I don't have permission to view that page. Where to I give permissions? I don't see it in UserGroups or in Options.

Thanks!

[Abe1]

i'm getting the following problem with rc4
Your submission could not be processed because a security token was missing or mismatched.

If this occurred unexpectedly, please inform the administrator and describe the action you performed before you received this error.

this happens after a new user signs up.
One problem, this page doesn't have any forms. Do you have a screen shot of before you get that error?

[Abe1]

One thing I've had trouble with, it says I don't have permission to view that page. Where to I give permissions? I don't see it in UserGroups or in Options.

Thanks!
Don't know anything about that. There should be no such error.

[cookiepants]

This is what I see when I'm logged in as an Admin:

[redlabour]

Please make the Navbar Link phrased and add a Option to use a own Path.

[bongwater]

installed, LIVE LINK (http://www.ravelinks.com/forums/all_albums.php)

[SavvyPirates]

This is great! Thanks.

I agree that we need the ability to edit the navbar link. I use vBadvanced and it is not in the same folder as my forum so the link on the navbar won't work on that page.

I managed to get it to work by editing the XML product file to make that link my fully qualified URL to the all album page and re-importing the product and it's all good now.

Other than that, it was a cinch to install and get working!

[Marvin Hlavac]

I'm installation # 308. Thanks. I just found out about this add-in 10 minutes ago over at vbulletin.com.

[Marvin Hlavac]

One question, if I may. I don't use the default vBulletin style, but rather I use vBSEO Style, which comes with light green navbar. All the text in that navbar is black - but the All Albums font is white.

* Is there a way for me to change the font to black color;

* or, alternatively, if color change would be difficult, how could I turn off the All Albums text in the navbar? (I could then insert my own text there, or anywhere else.)

[Marvin Hlavac]

I'm not sure if my approach was the correct one, but I managed to change the font color the following way:


$template_hook["navbar_buttons_left"] .= '<td class="vbmenu_control"><a href="all_albums.php' . $session[sessionurl_q] . '"><font color="black">All Albums</font></a></td>';

[justchil]

This is great! Thanks.

I agree that we need the ability to edit the navbar link. I use vBadvanced and it is not in the same folder as my forum so the link on the navbar won't work on that page.

I managed to get it to work by editing the XML product file to make that link my fully qualified URL to the all album page and re-importing the product and it's all good now.

Other than that, it was a cinch to install and get working!

Ditto!

For those who also need this and need help:

product-abe1_all_albums.xml

find:

<phpcode><![CDATA[$template_hook["navbar_buttons_left"] .= '<td class="vbmenu_control"><a href="all_albums.php' . $session[sessionurl_q] . '">All Albums</a></td>';]]></phpcode>

replace: (don't forget to update the domain/link to suit your needs)

<phpcode><![CDATA[$template_hook["navbar_buttons_left"] .= '<td class="vbmenu_control"><a href="http://www.yourdomain.com/forums/all_albums.php' . $session[sessionurl_q] . '">Gallery</a></td>';]]></phpcode>

You can also change the "All Albums" using this method. If you've already installed don't forget to "allow overwrite" when you import it again. I agree a phrase would be better :D

Cheers!:up:

[alluidh]

Thank you

[jazde86]

Why you didn't youse a phrase at the navbar entry? Please fix this in next version. Thanks.

[ayaam]

Why you didn't youse a phrase at the navbar entry? Please fix this in next version. Thanks.

yes , please

let's us to traslate it to arabic or to other lang :)

http://ayaam.com/vb

[storpappa]

1) upload the 'upload via ftp' folder
does not exist in the download which was located in the insructions - the first T is silent :) (funny way of saying typo)

[jazde86]

It's in every Add-on from him. ;)

Happy Birthday Abe1. :D

[thepub]

I installed and see nothing in my navbar :confused:

[abulean]

Very nice

[Abe1]

Happy Birthday Abe1. :D

Thanks :)

[DawnsWebDesigns]

You can also go to plugin manager & click on All Albums & change all albums to gallery.

Thanks for this wonderful mod.

[DarkFaCe]

thanks Installed

[Fox Mc Cloud]

Possibility to add link to the quick links instead of navbar would be nice :D

[Abe1]

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

[justchil]

Outstanding work Abe1! *updates*

[furst]

Nice update, thanks.

[jazde86]

:) Wonderful update, thank you. :up:

[meolangthang]

Thank you

[VB-STYLE]

Thank you so much

Can you add new option to show in the top or down of all album page the
most 4 or 5 albums viewes?

[storpappa]

update installed - thanks. BTW - in the Insturctions (you sneaked that one in not in the updated fixes ), you removed WHERE to put the .php file. Keep that in, it will save a lot of common questions

[texterted]

Installed great! Many thanks for the update, keep up the good work :)

[Marvin Hlavac]

I just received email notification about the availability of the new version. I installed it - Thanks - keep up the good work!

[tilt2k]

Good update. Can you also add more sort options? Like album id

[madmax1228]

+100000 Thanks!

[Abe1]

Good update. Can you also add more sort options? Like album id
No. The id does not get shown in the list. If i had the creation date, then i can sort by that. creation date and id would be the same sort.

[Kinneas]

Thanks for the update. Very good mod :)

[storpappa]

Anyone plugged this into the home page on vBAdvanced yet? Its great on the forums, but would be great to see on the home home page :)

[bryanb]

Great update! Thanks!

Quick question (hopefully not a stupid one) - I can't get this to turn off for banned members. I have banned members' Albums still visible. I've checked the banned member's user group, and everything is turned off. Any way to do this?

[Dory-Art]

thanks :)

[Abe1]

Great update! Thanks!

Quick question (hopefully not a stupid one) - I can't get this to turn off for banned members. I have banned members' Albums still visible. I've checked the banned member's user group, and everything is turned off. Any way to do this?
I'm not sure. It uses vb to check the permission if the user viewing the all album page can view that album or not. You may be able to see it but your regular members cannot.

[Traxdata]

Great work!

btw, "Description" for this product is missed in ACP -> Installed Products.

[aggiefan]

outstanding mod.... the only thing its missing that i would like to see added (which im sure has been requested) is a search engine or somehow get the vbulletin search engine to work with it.

[BoredOutOfMyMin]

This is what I see when I'm logged in as an Admin:

This happens if you are on http://www.yousite.com/forums and you link to instead to http://yousite.com/forums

- server level redirects fix this.:D

I love the pink skin!

[bryanb]

I'm not sure. It uses vb to check the permission if the user viewing the all album page can view that album or not. You may be able to see it but your regular members cannot.

Still having the problem. A banned member's albums are visible in "All Albums" whether it's me viewing them, unregistered or registered users. They are still there.

In the User Group manager, everything is shut off for banned members. I tried editing the individual's user profile. But there was nothing pertaining to Albums. :confused:

Shouldn't there be a function that turns off Albums for banned/suspended members? If there is, I can't seem to find it.

If anyone has any ideas - I'd like to hear them.

[Leo Brazil]

I don't know if this was already mentioned here but I have to edit the XML file to traslate the word "All Albuns" for translation.
I mean, even translating all Vb Phrases "All Albuns" on Navibar was still in English. I realised that this function was not Vb phrased on this file.

Marked as installed and working great.

[MichiBeck]

Great mod, installed!

Is it possible to limit the displayed length of the album description?

[droid101]

CMPS Portal Navbar link doesn't work, even when adding all_albums.php to the navbar replacement list in the vbAdvanced settings.

Am I missing something?

[ayaam]

thanks , updating ...

[Fred.]

How can i make all albums visible for guests?

I have set Usergroup manager --> Unregistered / Not Logged In --> User Album Permissions --> Can View Albums Users without this permission will still be able to see picture in public and profile album if they know the exact URL.

To YES

And wen i try to view the albums as guest i get the login screen... :confused:

[Marvin Hlavac]

This may be beyond the intended scope of the add-on, but I'll ask anyway.

I'm looking for a function that would automatically add a link to the member's album in each of the member's posting, if the member does have an album. The link should be placed in a post, somewhere near member's name, or near his/her post count.

Would it be possible to add such functionality, or does anyone know an add-on that enables such functionality?

Thanks.

[Henkou]

thanks for good job, marked as installed

[Fred.]

Is it possible to view all albums as guest?

i try to acces all albums as a guest, but i get the login screen.

[GTRyan]

Great hack, does this limit the amount of galleries shown on a page anywhere?

[Abe1]

Is it possible to view all albums as guest?

i try to acces all albums as a guest, but i get the login screen.
It all depends on permission. They have to be able to view albums and they have to be able to view other albums and other albums have to let them view albums.

[SuperGLS]

Very good. Installed.

[kennn]

CMPS Portal Navbar link doesn't work, even when adding all_albums.php to the navbar replacement list in the vbAdvanced settings.

Am I missing something?

I'm having this same problem. Both the All Albums link on the main navbar and the All Albums link on the Quick Links menu are pointing to www.domain.com/all_albums.php instead of www.domain.com/forums/all_albums.php. Like the above poster, I've tried add all_albums.php to the navbar replacement list but no go.

Short of a fix, is there some place I can hard code this?

Thanks! Love this mod!

[Allan]

French language (add description in product) ;)

Translator: Allan

[pewa]

Great add-on!

I tried to add the "all_albums.php" as a PHP Page in vB CMPS but the page ends up showing nothing.. any idea?

[kennn]

I ended up adding a redirect to my .htaccess file and that does the trick for now until a fix comes along.

Redirect /all_albums.php http://www.domain.com/forums/all_albums.php

[Fred.]

It all depends on permission. They have to be able to view albums and they have to be able to view other albums and other albums have to let them view albums.

Thanks
Finally i found it.

For all other users that want to show albums to guests
You have to set

General Permissions --> Can View Member Info
to YES
and User Album Permissions --> Can View Albums
to YES

:)

[xorex]

Great hack !!

russian translate attachment

installed

abe1 update first post please

[pewa]

This works great!

One problem, like I said earlier.. when I try to add a PHP Page in VbAdvanced CMPS I end upp getting this:

[goddess_dix]

I'm looking for a function that would automatically add a link to the member's album in each of the member's posting, if the member does have an album. The link should be placed in a post, somewhere near member's name, or near his/her post count.

But members can have multiple ablums and it looks like it calls albums by id, not by user, so you'd need a query in order to call all albums by a user, and then you'd have to figure out what to display for it - how to pick which album to link.

you might be able to dig in the code for this mod and the page that displays it to reverse engineer it so it pulls all albums from the poster, if you felt strongly about that functionality.

[Marvin Hlavac]

Most members of my forum will never have albums. Those who do, however, I would like to somehow make it known (in each of their post) that this particular member has album(s). There could be a small picture/link if the member has album(s).

It may/or may not be possible to do :-(

[NeverBored]

But members can have multiple ablums and it looks like it calls albums by id, not by user, so you'd need a query in order to call all albums by a user, and then you'd have to figure out what to display for it - how to pick which album to link.

you might be able to dig in the code for this mod and the page that displays it to reverse engineer it so it pulls all albums from the poster, if you felt strongly about that functionality.
album.php?u=USERID lists a users albums

There may be a if conditional to display a link in postbit. I don't know off the top of my head. Quick fix would be just include the link for all users. Wouldn't hurt anything, and could possibly in a way encourage people to upload to their albums.

[Howell]

Maybe use this?

https://vborg.vbsupport.ru/showthread.php?t=168428

[bryanb]

I'm still having a problem with banned member's albums still showing.

In my forum, banned members are not allowed to have albums.

In a banned user's member profile - the albums are not viewable except for admin/moderators. No one else can view them. But in the "forums/all_albums.php file", they are viewable by everyone under the sun. How can I have this corrected?

I've uninstalled and reinstalled the newest version 2.3 - running on the latest 3.7 vbull, and it's still showing banned members - and any member not allowed to have an album. Please help!

[Marvin Hlavac]

Maybe use this?

https://vborg.vbsupport.ru/showthread.php?t=168428


Thanks for the link. Unfortunately, the problem with that implementation is that it creates a link to albums for everyone - even for those who have no albums at all.

Nevertheless, I did subscribe to the thread, hoping a solution will be discovered.

[fLoCkE]

Thank you!

[lazytown]

Awesome mod - Thanks!!!

-vissa

[DDIG]

Whould this not be better? I use vbGallery, which re-uses the navbar template. Only the relative path then becomes ./gallery/all_albums.php which is incorrect off course.

To fix this I added the $vbpoptions[bbdir] before all_albums.php in template album_all_navbar_link

<td class="vbmenu_control"><a href="$vbpoptions[bbdir]/all_albums.php$session[sessionurl_q]">$vbphrase[all_albums]</a></td>

The all_albums.php should not be in / but in /forums if you have vBulletin installed in /forums.

I also use vbPortal which onfortunately cannot use the template hook. So in order to have it work for vbPortal as well, I added the code below to vbp_navbar template:

<tr><td class="vbmenu_option"><a href="$vbpoptions[bbdir]/all_albums.php">$vbphrase[all_albums]</a></td></tr>

just below this code:

<tr><td class="vbmenu_option"><a href="$vbpoptions[bbdir]/album.php?$session[sessionurl]u=$bbuserinfo[userid]">$vbphrase[pictures_and_albums]</a></td></tr>
</if>

This way it works in vbportal and vbgallery as well. Hope this can be of help

[thc]

French language (add description in product) ;)

Translator: Allan

merci abe1 et allan

[Trooper247]

Installed. Thanks a lot

[Silvio]

ty sir, great hack! *installed

How is possible to remove all album link on navbar depending on usergroup privileges?
I mean example : guest can't see link wile registered users yes.

ty for help

[PGAmerica]

This works beautifully. However, how do I make it so "private albums" do not show. Can this be an ACP option?

It seems that 3 other people want this as well.

[edenx]

Should add an option to sort albums depending on LAST POST or LAST COMMENT

[bryanb]

I'm still having a problem with banned member's albums still showing.

In my forum, banned members are not allowed to have albums.

In a banned user's member profile - the albums are not viewable except for admin/moderators. No one else can view them. But in the "forums/all_albums.php file", they are viewable by everyone under the sun. How can I have this corrected?

I've uninstalled and reinstalled the newest version 2.3 - running on the latest 3.7 vbull, and it's still showing banned members - and any member not allowed to have an album. Please help!

Has anyone had a chance to look into this? Isn't anyone else having this problem, or is it me? :D

[VB-STYLE]

Thank you so much

Can you add new option to show in the top or down of all album page the
most 4 or 5 albums viewes?
...
:o

[Smiry Kin's]

Doesnt look too bad,

Live Preview

http://www.xentoo.com/albums/

[xyzmary2001]

Whould this not be better? I use vbGallery, which re-uses the navbar template. Only the relative path then becomes ./gallery/all_albums.php which is incorrect off course.
The all_albums.php should not be in / but in /forums if you have vBulletin installed in /forums.

I also use vbPortal which onfortunately cannot use the template hook. So in order to have it work for vbPortal as well, I added the code below to vbp_navbar template:

This way it works in vbportal and vbgallery as well. Hope this can be of help
jkoyybvio

[DDIG]

I am a very beginner and I do have this "small" problem with the navbar. Still, I do not have any idea where to find the vbp_navbar and what exactly to do. Please, explain to me... I am sorry to be a nuisance, but...
vbp_navbar is a vbPortal template, if you don't have vbPortal CMS installed you can ignore this. If you do have vbPortal the change is needed in order to add the all_albums link to vbPortal navbar as well.

The $vbpoptions[bbdir] prefix is needed if you use vbGallery, otherwise the vbGallery navbar link points to the wrong directory. If you don't use vbGallery you can ignore this too.

[xyzmary2001]

I have portal and I have all albums. Still, I have no idea where to find the template.

[DDIG]

When you open vBulletin Admin CP, go to Styles and Templates - Style Manager, select the style you use, click on the < > button, expand All Template Groups (< >), there you should be able to find the vbp_ templates if you have vbPortal installed.

But I see you use vbAdvanced, in which case I don't know the template names (don't know if it is needed in that case too).

[bryanb]

....Bryanb, have you tried on vBulletin Options - User Profile Options - to see if "all albums" is active? Then, if it is, go to UserGroups manager and give persmissions to every group, by Edit Usergroup. There you cand find the option regarding the permissions to have or see albums. Hope this will work, I solved the problem this way.
No that's not it. Banned users are not allowed to have albums - they can't even access the forum. The problem is that their albums remain active. Everyone who can view albums can see the banned users' listed on the all_albums.php file.

I had to go in and manually delete these albums.

For a wish list item - it would be nice to have an enable/disable user group ID as an option for the administration panel. Thanks!

[droid101]

Hey... I added all_albums.php to that little nifty list in the vbAdvanced settings so that the navbar link will work on the home page, but it doesn't seem to be working.

It works for all the other junk I have up there... any thoughts?

[bertwrld]

Would it be possible to add an option to select how many albums per page to show?

[PHILIPS-08]

thanx good mod i installed

[popular]

how bout adding a hit count?

[trilogy33]

Installed, works fine under 3.7.0 BUT...
Now my vBGarage 3.5.0 has vanished from the navbar, erm..help please :confused:

EDIT: No worries. Have simply move the vBGarage link elsewhere. :)

[Charles_1]

how bout adding a hit count?
I am curious about this option too - to show number of views of each picture (it is quite basic feature for album with pictures, becouse everyone is curios about how often are his pictures/photos viewed).

[Deepdog009]

Nice setup... Keep the ball rolling...:up:

[Mike Corrigan]

Thanks for this great product

Hey... I added all_albums.php to that little nifty list in the vbAdvanced settings so that the navbar link will work on the home page, but it doesn't seem to be working.

It works for all the other junk I have up there... any thoughts?


I have the same problem. The navbar link on the vbadvanced page is still pointing to my root directory instead of where my forum is.

I'm using redirects as a temp fix.

[Sea Shepherd]

I love it when things are so easy to install.
Thanks guys.

[kevcj]

This is a wonderful add-on, thank you!!!!

[almera]

Great add-on! Is there any way to syndicate picture comments into a small feed on the all_albums page?

[Lift for Life]

Easy to install and a very nice addition.

Thanks (INSTALLED!)

Lift

[anantthakor]

I want to change the colour of Navbar link, how can i ?

[RaceJunkie]

How do i change the name of the link All Albums to Profile Albums?

Edit: Uninstaled until Vb_Advanced link fixed

[Ultimate Killer]

Nice job, thanks.

[Smiry Kin's]

Search "All Albums" ? i changed mine to Albums..

search in the "Phrase Manager"

[Alfa1]

Here's an idea, that I posted in the feature request forum:

Album categories: use vb's album system as yoursite's image gallery.
Abe1 has shown us with his All Albums hack (https://vborg.vbsupport.ru/showthread.php?t=172215&highlight=all+albums) how user albums can be used to create an image gallery based upon members. i.e. the main page will show all available member albums. This is one step away from becoming a real image gallery:

Image gallery categories.

If user albums would have categories associated with them, then:
- admins would create appropriate categories
- users would have to select a category for their albums (drop down)
- a main page with the categories could be created.
- under these categories one would see all albums associated with that category.

If anyone thinks this is doable and wants to do this, then your efforts will be highly valued by me and many other vb admins.

Abe1; do you think this is possible?
Would you be interested in expanding your software with these features?

[beanymonster]

installed - thanks

Any ideas on how to fix the navbar link in cmps? that is the only thing spoiling a great mod.

[OsideRida06]

Just change the link in your navbar to the actual url. http://www.yourdomain.com/forums/all_albums.php. Or what ever it is.

[beanymonster]

Just change the link in your navbar to the actual url. http://www.yourdomain.com/forums/all_albums.php. Or what ever it is.


forgive my ignorance - I cannot find where to do this. I have searched the navbar template and there is nothing there. Cannot find this option anywhere else either.

thank you for any help

[rootnik]

Installed and Nominated. This is just about the first thing my user's asked for after I upgraded to 3.7.

Note - I had to manually place the link in my quicklinks. This is probably because my quicklinks div code is in my header template (not in the navbar template).

[OsideRida06]

Installed. Thanks for the great mod!

[BoYagoob]

installed .. thanks a lot :)

[Alfa1]

Is there a way to exclude profile albums?

[EvilJohn]

Installed. Thank you. Casted a vote for you too. :)

[Lemmi540iat]

hi, big thx for the mod!!!

i have 2 problems:

1.) my english is so crap
2.) i see only everytime 1 album from 5 in my forum :-(

i need ALL albums on the site, not 1 in 1 site.

can anyone help me please?

sorry for my bad english

greets lemmi

[Gokhan Tekin]

Thanks .
good.

[LWS]

excellent!! this is exaclty what i was looking for. thanks for this ;)

[Ov3rrun]

Hi Abe, is there possible to:

1. write bb code on description albums (i want to write urls on it)?
2. configure what photo show on album cover

Thanks, nice mod.

[trilogy33]

Could someone else please test this under 3.7.1 PL1 installed a few hours ago?
I'm getting the dreaded "An error occurred while attempting to log you out. Click here to log out."
Is there something in the Navbar template that could have been altered?

Many thanks

[PGAmerica]

Could someone else please test this under 3.7.1 PL1 installed a few hours ago?

This working on my 3.7.1 PL! site at http://www.traprunner.com (http://www.traprunner.com/forums/all_albums.php).

[trilogy33]

This working on my 3.7.1 PL! site at http://www.traprunner.com (http://www.traprunner.com/forums/all_albums.php).

Thank you.
This seems to have now "self fixed", don't ask me how... :)
w.e.i.r.d.

[Abe1]

Hi Abe, is there possible to:

1. write bb code on description albums (i want to write urls on it)?
2. configure what photo show on album cover

Thanks, nice mod.
Only vb allows it.

[ArnyVee]

Thanks Abe!

This is an awesome hack. Now, I just have to figure out how to limit these folks from posting so many pics! :D

[Sinan COSKUN]

Thanks
very good

installed ;)

[pewa]

Thanks
Finally i found it.

For all other users that want to show albums to guests
You have to set

General Permissions --> Can View Member Info
to YES
and User Album Permissions --> Can View Albums
to YES

:)

Is there a way to make guest able to see All Albums without permissions to se members info?

[KuJoe]

I can't for the life of me figure out how to fix the link on my vBAdvanced page, I added all_albums.php to the Navbar Replacements area but no luck. Any ideas?

[Kahuna900]

I fixed the vbadvanced navbar linking problem by editing the "product-abe1_all_albums.xml" file.

Just replace all instances of "<a href="all_albums.php" with "<a href="/forums/all_albums.php".

Then I re-installed the product utilizing the overwrite option.

[Kahuna900]

Great mod!

I only have one request. Show only the albums that are not empty.

[Kahuna900]

Okay, I added the following to both SELECT statements located in all_albums.php:

AND album.visible > 0

Now it doesn't show any empty albums!

[Ov3rrun]

Only vb allows it.

Thanks, but VB only have the option "Allowed BB Code Tags in Picture Comments" not bb code on description albums.

Actually its unable to add bb code or html on description albums.

[Smiry Kin's]

I fixed the vbadvanced navbar linking problem by editing the "product-abe1_all_albums.xml" file.

Just replace all instances of "<a href="all_albums.php" with "<a href="/forums/all_albums.php".

Then I re-installed the product utilizing the overwrite option.
Did you even edit the Header Replacements or Navbar Replacements?

[ctfortner]

love it, thanks. installed

[ohsuria]

nice addon.
thanks and installed in 3.7.2 :)

[ProtoPC]

Okay, I added the following to both SELECT statements located in all_albums.php:

AND album.visible > 0

Now it doesn't show any empty albums!

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

[TrIn@dOr]

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

Thanks in advance.

[ProtoPC]

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 (http://www.cywire.com/index.php?option=com_wrapper&Itemid=180) is a link to it.

[CPB123]

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]

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