Social Group and Album Enhancements - [Scandal's] vBGallery

Description
Turn your vBulletin Album system to an organized Gallery. Watch presentation!

The basic idea of Scandal's vBGallery is to organize vBulletin Albums AND forum attachments (pictures) to a section with lots of functions (categories, search, latest objects, statistics, menus etc).
Designed for vBulletin 4.2.0 (otherwise you must add the navbar links manually).



Features:
- Categories system for Albums (like Forums for threads)
- Five (5) levels of subcategories allowed
- Album, picture and comment search
- Who browsing Gallery (= Gallery Home, Albums, Pictures)
- Gallery statistics
- Forum attachments gallery (with ability to act it as category)
- Pages: latest pictures - latest albums - latest comments (with feature to turn them to "All")
- "My Comments" feature (display all user comments)
- My Pictures/Albums in "this" category
- Ability to set custom statusicons to categories
- Notifications to users with "uncategorized" albums to move them
- Ability to hide empty categories (= with 0 albums)
- Admincp environment
- No annoying copyright info

Language Packs:
- Deutsch (Sie) - Deutsch (Du)


Installation:
1. Upload all files of folder "upload" to your forum root.
2. Import *xml product.
3. (Important) Open template album_edit and find:

<fieldset class="blockrow">

add below:

<vb:if condition="$vboptions['sc_gallery_onoff']">
{vb:raw formdata.catid}
</vb:if>

Done!

Upgrade:
1. FIRST OF ALL: Upload and replace all files of folder "upload" to your forum root.
2. THEN: Import XML product with "Allow Overwrite" to YES.

Who can view vBGallery;
Access to vBGallery has all members who belongs to usergroups with "Can View Albums" to YES.

What if I decide to turn off or uninstall vBGallery;
You are back to Albums without data lose (except the category of each Album - function of this hack).

How could I change the size of Gallery's thumbnails?
vBGallery use the thumbnail size you have set via admincp. To change it go to:
Admincp > Options > Message Attachment Options
... and set your value to "Thumbnail Size"
... afterwards you must rebuild attachment thumbnails at: Maintenance > General Update Tools > Rebuild Attachment Thumbnails

How to install navbar links (for vBulletin 4.0.X - 4.1.X)
Read this post

*Links (for vBulletin 4.0.X - 4.1.X)
::Screenshot::::..
GALLERY:
->/gallery.php

My Stuff:
(My Albums)-> /album.php
(Add Album)-> /album.php?do=addalbum
(My Comments)->/gallery.php?do=mycomments
(Pending Albums)->/gallery.php?do=pending

(Latest Pictures)->/gallery.php?do=latestpictures
(Latest Albums)->/gallery.php?do=latestalbums
(Latest Comments)->/gallery.php?do=latestcomments
(Search)->/gallery.php?do=search


Changelog:
v1.0 first release (beta)
v1.2 second release
- New layout choice for galleridisplay: Grid layout with feature to change the width of albumbits via admincp
- Integration of vBulletin's sidebar with Gallery Home (admin can enable or disable it on admincp)
- New feature: flood check and character limit check for the search engine
- Improved breadcrumb (add category name to navbit) ("Gallery > {category name} > Member List > {username} > Albums > {album name}" )
- "Inverse pyramid like" statistics for categories [a main category "has" the albums of its subcategories - like forum statistics (threads/posts) works for subforums]
- New feature: admin can enable/disable the view of empty categories (= categories with 0 Albums)
- New feature: admin can enable/disable the use of search engine by guests
- Building of Gallery Statistics by cronjob (= refresh every one hour). Very important for server performance.
- 1 bug fixed
v1.5 third release
- Classic layout abolished
- New: Notification feature = users with Albums in category "Uncategorized" auto-notified by the system to move them to a subject category (pending albums)
- New feature: admin can set if he want him users to display Albums or Pictures when open the categories.
- New: menus "Browse Albums" & "Browse Pictures" on Gallery Display (user can navigate the albums/pictures in the category)
- New: My albums/pictures in "this" category feature
- Admincp environment improved (List Albums)
- 3 bugs fixed
v1.6 fourth release
- Galleryhome: fixed the view of description for header categories
- New feature: ability to add custom statusicons to categories (screenshot)
- 1 phrase undefined variable fix
- pending albums: 1 bug fixed
v2.0 fifth release
- New feature: forum pictures attachment gallery (with ability to turn it as gallery category)
- search feature for attachment gallery
- 1 phrase issue fixed
- 1 bug fixed
v2.1
- better attachments gallery popup

Developer's notice: I give support only for code errors, not for style problems.

Tested on vBulletin 4.2.0

[Alfa1]

Does your addon provide for albums that are already existent? For example my board has hundreds of existing albums. How do these get into the gallery?
Maybe show the gallery owners a notification that they need to update their albums?

Another issue is that many albums have no thumb, making the album gallery empty.

Does your addon provide a function to browse all pictures in a category, without having to open up member albums?

Please consider to add some enhancements to image viewing and album browsing. vbulletin looks really outdated and lacks simple functionality. Its miles behind facebook, G+, flickr and even xenforo. I think a nice jquery image viewer with comments on the side would make a world of difference.

[Manoel J?nior]

Originally Posted by Alfa1

Does your addon provide for albums that are already existent? For example my board has hundreds of existing albums. How do these get into the gallery?
Maybe show the gallery owners a notification that they need to update their albums?

Another issue is that many albums have no thumb, making the album gallery empty.

Does your addon provide a function to browse all pictures in a category, without having to open up member albums?

Please consider to add some enhancements to image viewing and album browsing. vbulletin looks really outdated and lacks simple functionality. Its miles behind facebook, G+, flickr and even xenforo. I think a nice jquery image viewer with comments on the side would make a world of difference.

Very interesting!! Me too.

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

After the update is coming in my email an error database:

Database error in vBulletin 4.2.0:

Invalid SQL:

                               SELECT sc_gallery.title
                               FROM sc_gallery AS sc_gallery
                               WHERE catid =;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3
Error Number  : 1064
Request Date  : Saturday, June 16th 2012 @ 08:35:50 PM
Error Date    : Saturday, June 16th 2012 @ 08:35:51 PM
Script        : xxx/forum/album.php?u=2835&albumid=613
Referrer      :
IP Address    : 66.249.73.81
Username      : N?o Registrado(s)
Classname     : vB_Database_MySQLi
MySQL Version :

How to fix?

[Scandal]

Originally Posted by Manoel J?nior

After the update is coming in my email an error database:

Database error in vBulletin 4.2.0:

Invalid SQL:

                               SELECT sc_gallery.title
                               FROM sc_gallery AS sc_gallery
                               WHERE catid =;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3
Error Number  : 1064
Request Date  : Saturday, June 16th 2012 @ 08:35:50 PM
Error Date    : Saturday, June 16th 2012 @ 08:35:51 PM
Script        : xxx/forum/album.php?u=2835&albumid=613
Referrer      :
IP Address    : 66.249.73.81
Username      : N?o Registrado(s)
Classname     : vB_Database_MySQLi
MySQL Version :

How to fix?

Are you sure that there is an album in your database with ID 613?
1. Try to open the following page (replace "xxx" with your site domain):
http://www.xxx/forum/album.php?u=2835&albumid=613
Do you receive database error or any other message?
2. Go to admincp > Maintenance > Execute SQL Query
... and run the query:

SELECT *
FROM album
WHERE albumid=613

... and tell me the returning results.

I believe that there isn't an album with id 613 to your database (the guest who view this database error was a google bot). I send you on PM a plugin change, so you'll never receive this db error again.

[Scandal]

Originally Posted by Alfa1

1.Does your addon provide for albums that are already existent? For example my board has hundreds of existing albums. How do these get into the gallery?
2. Maybe show the gallery owners a notification that they need to update their albums?

3. Another issue is that many albums have no thumb, making the album gallery empty.

4. Does your addon provide a function to browse all pictures in a category, without having to open up member albums?

5. Please consider to add some enhancements to image viewing and album browsing. vbulletin looks really outdated and lacks simple functionality. Its miles behind facebook, G+, flickr and even xenforo. I think a nice jquery image viewer with comments on the side would make a world of difference.

1. All the already existent Albums when you install vBGallery, goes to the category "Uncategorized". I want to notice that vBGallery displays only the non empty (=0 pictures) and non private Albums to registered users (admins can see private albums).
So, after a new installation of this hack, you should move the existent Albums to the categories you like 1-1.
Finally on admincp there is the tool List Albums (I will improve it to next releases).

2. Cool idea! I'll keep it in mind, I'll try to add notification system for this reason.

3. I think that albums with no thumb are the empty albums. vBGallery doen't display empty Albums. When an empty Album gets a picture, vBGallery shows it. If you have non empty Albums with no thumbnails, maybe you should run the script "Maintenance > General Update Tools > Rebuild Attachment Thumbnails".

4. hmm no I think it is very easy to build a function page for this, so stay tuned for the next release!

5. It is not on my priorities to change the layout of picture viewer but I'll think about it.

[Scandal]

Originally Posted by Leica.Robbiani

Hi there,

gallery.php gives back a blank page on vb4.0.6.

Best regards

L.R.

Originally Posted by Front Range 4x4

Blank page on 4.1.12 too.

Are you sure that you have complete the upload of gallery.php to your server?
Try to re-upload it and tell us the result.

[Leica.Robbiani]

Hi there,

Originally Posted by Scandal

Are you sure that you have complete the upload of gallery.php to your server?

Yes I am.

Originally Posted by Scandal

Try to re-upload it and tell us the result.

I've downloaded the latest version and did an upgrade. Same result, a blank page. My vB is just Forum, not Suite. Maybe this will be a problem, some other mods (not yours) are also not working correctly with vbf.

On my localhost with vbs4.2.0 the gallery is working. But after installing there I see in the stats:

Albums: 1 Pictures: 1 Comments: 1 Disk Space: 1 Bytes

This is not correct, I have no album and no picture.

Best regards

L.R.

[Scandal]

Originally Posted by Leica.Robbiani

1. I've downloaded the latest version and did an upgrade. Same result, a blank page. My vB is just Forum, not Suite. Maybe this will be a problem, some other mods (not yours) are also not working correctly with vbf.

2. On my localhost with vbs4.2.0 the gallery is working. But after installing there I see in the stats:

Albums: 1 Pictures: 1 Comments: 1 Disk Space: 1 Bytes

This is not correct, I have no album and no picture.

Best regards

L.R.

1. I install vBGallery v1.2 to a fresh vB4.2.0 Forum (not Suite) in a localhost and works fine except of the statistics (see below). Can you send me via PM a list of the hacks you are using on your forum? Also, can you detect any difference between your normal site and your localhost site?*
- Finally, try the following: go to vBGallery Options (admincp) and try to turn off Statistics and Active Users, then try to open the gallery page. Does it open?

2. I detect the problem with the stats. The problem was that if the script recognize "0" disk space, returns '' (null) and stops before build the stats. This happening only in sites with 0 disk space (=not one uploaded picture).
If you want to fix the stats problem on your localhost:
- upload at least one "test" picture
- go to admincp > Scheduled Tasks > Scheduled Task Manager
... and run the task "vBGallery by Scandal - build stats"
vBGallery v1.5 will fix this problem.

*I try to detect the problem with the blank page. :erm:

[Alfa1]

Originally Posted by Scandal

1. All the already existent Albums when you install vBGallery, goes to the category "Uncategorized". I want to notice that vBGallery displays only the non empty (=0 pictures) and non private Albums to registered users (admins can see private albums).
So, after a new installation of this hack, you should move the existent Albums to the categories you like 1-1.

For big boards it would be very unhandy to change each album 1 by 1. Especially if there is only 1 admin, like on my sites.

Originally Posted by Scandal

Finally on admincp there is the tool List Albums (I will improve it to next releases).

Great.

Originally Posted by Scandal

If you have non empty Albums with no thumbnails, maybe you should run the script "Maintenance > General Update Tools > Rebuild Attachment Thumbnails".

Unfortunately that does not resolve it.

Originally Posted by Scandal

5. It is not on my priorities to change the layout of picture viewer but I'll think about it.

I'm currently using Photopost Pro alongside vb albums. The main benefit of PP is some basic functionality that vbalbums do not yet have. I would love to have only 1 gallery solution.

Please consider to add an importer for images, & albums from photopost and photoplog. Photoplog has been abandoned. Many people use photopost pro. You could make the importer a pro feature.

Will there be a vb3 version?

[Leica.Robbiani]

Hi scandal,

can you detect any difference between your normal site and your localhost site?*

Thanks a lot for your hints, but nothing did work on my localhost. The "build stats" script stucks.

Just please give me a little time to install it on my test directory on my server. My localhost is a Windoze system, my server runs with Linux. Maybe there will be a difference, this wouldn't be the first time.

Normally first I install mods on my localhost, when they work there I install them in my test directory on the server, only if they work there I install them on the production site.

Please don't get upset.

Best regards

L.R.

[sandboa]

Would love to see permission ability