The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
All Albums Details »» | |||||||||||||||||||||||||||||
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):
Download Now
Screenshots
Supporters / CoAuthors Show Your Support
|
Благодарность от: | ||
matrex722 |
Comments |
#362
|
|||
|
|||
Just tried to upgrade and got the following error:
XML Error: Empty document at Line 1 |
#363
|
|||
|
|||
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 "); |
#364
|
||||
|
||||
First the db error if you search, second phrase the Submit button on the search, please. Thanks Abe.
|
#365
|
|||
|
|||
Quote:
Search worked for me as well. |
#366
|
|||
|
|||
Quote:
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... |
#367
|
||||
|
||||
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 |
#368
|
||||
|
||||
Next version.
|
#369
|
||||
|
||||
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. |
#370
|
||||
|
||||
Quote:
|
#371
|
||||
|
||||
Version 2.5 (10/24/08):
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|