The Arcive of Official vBulletin Modifications Site.

All Albums · **Released**: 03-05-2008

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.

abrecher · #**362** 10-24-2008, 07:18 PM

Just tried to upgrade and got the following error:

XML Error: Empty document at Line 1

ProtoPC · #**363** 10-24-2008, 07:34 PM

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

jazde86 · #**364** 10-24-2008, 07:40 PM

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

abrecher · #**365** 10-24-2008, 07:43 PM

Quote:

Originally Posted by abrecher

Just tried to upgrade and got the following error:

XML Error: Empty document at Line 1

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

Search worked for me as well.

ElForro · #**366** 10-24-2008, 08:08 PM

Quote:

Originally Posted by ProtoPC

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

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

redlabour · #**367** 10-24-2008, 08:12 PM

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

Abe1 · #**368** 10-24-2008, 08:12 PM

Quote:

Originally Posted by ArnyVee

Thanks! Looks good!

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

Next version.

imedic · #**369** 10-24-2008, 08:21 PM

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.

Abe1 · #**370** 10-24-2008, 08:22 PM

Quote:

Originally Posted by 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

Fixed in a version about to come out.

Abe1 · #**371** 10-24-2008, 08:27 PM

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.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05845 seconds Memory Usage 2,361KB Queries Executed 29 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)bbcode_php (4)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (4)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (11)post_thanks_box (1)post_thanks_box_bit (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit (11)post_thanks_postbit_info (10)postbit (2)postbit_attachment (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start fetch_musername post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end post_thanks_function_fetch_thanks_bit_start post_thanks_function_show_thanks_date_start post_thanks_function_show_thanks_date_end post_thanks_function_fetch_thanks_bit_end post_thanks_function_fetch_post_thanks_template_start post_thanks_function_fetch_post_thanks_template_end postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_attachment postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

Благодарность от:
matrex722

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!