Just tried to upgrade and got the following error:

XML Error: Empty document at Line 1

I get this error on a search:

Database error in vBulletin 3.7.3:

Invalid SQL:

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

MySQL Error : Unknown column 'album.title' in 'where clause'
Error Number : 1054
Request Date : Friday, October 24th 2008 @ 02:37:58 PM
Error Date : Friday, October 24th 2008 @ 02:37:58 PM
Script : http://www.cywire.com/community/all_...e=1&query=test
Referrer : http://www.cywire.com/community/all_albums.php
Classname : vB_Database
MySQL Version : 5.0.67-community



Code modified:


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



And:

// fetch data and prepare data
$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 $searchwhere
ORDER BY $sortname $sortorder
LIMIT $start, $perpage
");

First the db error if you search, second phrase the Submit button on the search, please. Thanks Abe. :)

I didn't follow the install directions, my apologies. After I uploaded the php file it worked.

Search worked for me as well.

I think it still needs a TABLE_PREFIX instead of "vb_album.visible".. But I really don't know how to code PHP, so I can't help...

Next version.

Bug:

Error on Search :

Datenbankfehler in vBulletin 3.7.3:

Invalid SQL:

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

MySQL-Fehler : Unknown column 'album.title' in 'where clause'
Fehler-Nr. : 1054
Fehler-Zeit : Friday, 24.10.2008 @ 23:11:59
Datum : Friday, 24.10.2008 @ 23:11:59
Skript : http://www.politikstube.de/forum/all...uery=redlabour
Referrer : http://www.politikstube.de/forum/all_albums.php
IP-Adresse : XXXX
Benutzername : XXX
Klassenname : vB_Database_MySQLi
MySQL-Version : 5.0.67

Same bug on search after upgrade:

Database error in vBulletin 3.7.3 PL1:

Invalid SQL:

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

MySQL Error : Unknown column 'album.title' in 'where clause'
Error Number : 1054
Request Date : Saturday, October 25th 2008 @ 12:20:01 AM
Error Date : Saturday, October 25th 2008 @ 12:20:01 AM
Script : http://www.eugenol.ro/forum/all_albu...1&query=remove
Referrer : http://www.eugenol.ro/forum/all_albums.php
IP Address : .............
Username : admin
Classname : vB_Database_MySQLi
MySQL Version : 5.0.51a-community


Any chance for a picture resizer in albums? If I click a thumbnail picture it shows full size pics much bigger than the forum.

Fixed in a version about to come out.

Useless. Before you did this i just translated the Button to "Suche" (means Search in German).

Why don?t you just rename the Button to "Search" ...:confused:

No i have to translate Search (Suche) and Submit ..(Los / Go) to make a sense in translating this.

Just a Hint ...

Much better! :D

Thanks Abe!

Thanks Abe. Version 2.5 search works for me now at http://www.cywire.com/member-albums.html. Took prefix I had added out:

------------------------------------------------------

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

------------------------------------------------------


// fetch data and prepare data
$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
$searchwhere
ORDER BY $sortname $sortorder
LIMIT $start, $perpage
");


------------------------------------------------------

I will be upgrading my version soon but was wondering....

Is there any way to show only one album per user (like maybe the last album created)?
It would be nice since vbulletin doesn't have a way to limit the amount of Albums the users can have.

I think you can limit the amount of albums in your AdminCP.?

Upgraded and works fine. Thank you :)

Thanks Abe1 for the search and the update!

Though i was more looking for a "forced" search. When users will go to all_albums i ll need to have them only look up for albums with specific name. Is that possible? (by editing the php probably?)

Very nice mod.....

dont install this mod then. if you want to see just one user at time, this is how vb has it.

No no, this mod is very good.

I don't want a user at a time. I want to have my users create album with a specific name and when they click on all_albums page to search in the db only for albums called "test" for example.

Thanks :)

Edit: Actually i want this: "http://xxx/all_albums.php?s=&sort=lastpicturedate&order=desc& page=1&query=Test" but i don't want users to be able to change the attributes.

For the same reason I created this hack, I created another hack for the albums also. This time it makes the Next & Prev Links Use AJAX. It works for both vb 3.7 and vb 3.8. You can get it here: https://vborg.vbsupport.ru/showthread.php?t=194628

Excellent :)

Thanks!

It a great MOD..! Just installed 2.5.

Is there anyway to organize/change to display order of the pictures?
Now when users upload pictures to their album the first uploaded picture displays as at last in the album?
Is there any way to let the users organize the pictures?

This is exactly what I need as well!

Stupid question, but how do I upgrade? Is there a way to upgrade without loosing my translations?

This is F'ing great. Another great mod from you.

Is there any way to change the text color to "yellow"?

Just upload the xml into products using the override option.

You can click on the tile of a column, it will sort that column.

Replaced the Default'Albums and Pictures' page with this in the navbar. So much better Abe.

Why on earth the security token error issue is not corrected in the current download is beyond me -- specifically the album_all_album_list template section of the xml -- but thanx very much for the share none-the-less.

Jacquii.

Will this mean we would have to re-install "all albums?"

Is there a way to use this mod to put a picture in a post?
Users currently click the little pic button above
https://vborg.vbsupport.ru/external/2011/07/5.gif
and paste a URL.
It would make my year if you clciked that button and you uploaded a picture to an album.

The best solution is that the album or the pcitures have tags that allow you to sort by category. This would make albums a gallery and even more useful.

Abe,

I have installed 3 of your Album mods (this one, the Ajax Next/Prev, and the Click the Pic for Next) and am very happy to with them, thanks for your efforts.

Question regarding the new search feature in this mod. I note that it only seems to search the text in the album title and description. Any chance of having it also search picture descriptions?

Dexter...

would be nicer to have 3 albums in a row and then the next column with the next 3 albums...and a rating under each album would also be great!

Would be a much harder search and would give search results that a user might not realize are related to his search term.

Thanks for this great Mod! Although vB goes into the same direction with 3.8, they do not go far enough. Abe, some ideas I really would like to see in this mod:

1. A list of the top X album creators. Number should be configureable through the admin interface.

2. A top X list of the best picture uploaders. Again config through admin interface.

3. Another top X list for the most viewed pictures.

4. And finally a list of the top X commented pictures.

5. A box for a random album.

6. Finally a box for a random image.

All this boxes could be on top of everything or at the side. All should be turned on or off through admin area. Finally it would be an idea to

7. add own albums at the bottom (like vB does in 3.8).

Everybody feel free to comment. :)

ABE: any comments on my question?

I'll repeat it here without the spelling errors so I look smarter.

Is there a way to use this mod to put a picture in a post?
Users currently click the little pic button above
https://vborg.vbsupport.ru/external/2011/07/5.gifand paste a URL.
It would make my year if you clicked that button and you uploaded a picture to an album.

The best solution is that the album or the pcitures have tags that allow you to sort by category. This would make albums a gallery and even more useful. The category thing is very important for my site.

You can see what we are using now by going here and here
http://www.theringlord.org/gallery/main.php
http://www.theringlord.org/forum/

request for this hack functions, please.

Instaklled and seems to work fine with 3.7.3. Only problem I see so far is that it shows empty albums.