Gallery for vBulletin 3.5.X

Gallery-Hack:

This hack is a gallery-system for your forum.

Updated 05/25/06

New in this version 1.23:

- Alternative layout
- english phrases
- Addition for the memberprofile
- multiple picture-upload
- Featured threads

What's still to come?

- Possibility for users, to choose the different layout.
- Possibility for file-upload, not only pictures.
- Language-Pack for german users

Have fun with the hack.

For a live-demo look here:

http://www.sf-galerie.de

[GuaRRand]

BTW: Great job though!
Previously i had Menalto's Gallery 2.1 installed/integrated into VB.
And altough i luv that Gallery on its own, it sucked in combination with VB.

Your gallery is just what i needed.
Userfriendly, easily installed and ur also trying to keep up with demand(s)/wishes.

Keep it up!!

[Bernd]

I'm trying to hook one of the queries below into postbit_display_start in a new plugin.

// #################### Latest Gallery-Additions #######################
// fetch the permissions for each forum
// global $vbulletin;
$gal_num_rows = $vbulletin->options['gal_num_rows'];


$thumbs = $db->query_read("SELECT gallery, threadid, firstpostid, ". TABLE_PREFIX . "thread.title, attachmentid, ". TABLE_PREFIX . "attachment.dateline FROM ". TABLE_PREFIX . "attachment, ". TABLE_PREFIX . "thread, ". TABLE_PREFIX . "forum
WHERE gallery='1' AND ". TABLE_PREFIX . "thread.forumid=". TABLE_PREFIX . "forum.forumid AND ". TABLE_PREFIX . "thread.firstpostid = ". TABLE_PREFIX . "attachment.postid AND ". TABLE_PREFIX . "attachment.dateline < " . TIME() ."
GROUP BY ".TABLE_PREFIX ."thread.threadid
ORDER BY ". TABLE_PREFIX . "attachment.attachmentid DESC LIMIT $gal_num_rows");



while ($gallery = $db->fetch_array($thumbs))
{
eval('$latestgallery .= "' . fetch_template('gallery_latestpictures') . '";');
}

// #################### Random Gallery-Additions #######################
// fetch the permissions for each forum

$random_thumbs = $db->query_read("SELECT gallery, threadid, firstpostid, ". TABLE_PREFIX . "thread.title, attachmentid, ". TABLE_PREFIX . "attachment.dateline FROM ". TABLE_PREFIX . "attachment, ". TABLE_PREFIX . "thread, ". TABLE_PREFIX . "forum
WHERE gallery='1'AND ". TABLE_PREFIX . "thread.featured!='1' AND  ". TABLE_PREFIX . "thread.forumid=". TABLE_PREFIX . "forum.forumid AND ". TABLE_PREFIX . "thread.firstpostid = ". TABLE_PREFIX . "attachment.postid AND ". TABLE_PREFIX . "attachment.dateline < " . TIME() ." ORDER BY RAND() LIMIT $gal_num_rows");

while ($rand_gallery = $db->fetch_array($random_thumbs))
{
eval('$random_gallery .= "' . fetch_template('gallery_randompictures') . '";');
}

$top5 = $db->query_read("SELECT gallery,". TABLE_PREFIX . "thread.featured, threadid, firstpostid, ". TABLE_PREFIX . "thread.title, attachmentid, ". TABLE_PREFIX . "attachment.dateline, ". TABLE_PREFIX . "thread.views FROM ". TABLE_PREFIX . "attachment, ". TABLE_PREFIX . "thread, ". TABLE_PREFIX . "forum
WHERE gallery='1' AND ". TABLE_PREFIX . "thread.featured!='1' AND ". TABLE_PREFIX . "thread.forumid=". TABLE_PREFIX . "forum.forumid AND ". TABLE_PREFIX . "thread.firstpostid = ". TABLE_PREFIX . "attachment.postid AND ". TABLE_PREFIX . "attachment.dateline < " . TIME() ." ORDER BY ". TABLE_PREFIX . "thread.views DESC LIMIT $gal_num_rows");

while ($top_gallery = $db->fetch_array($top5))
{
eval('$top5_gallery .= "' . fetch_template('gallery_top5') . '";');
}

// featured forum

$feat_rows=$gal_feat_rows;
$featured_thumbs = $db->query_read("SELECT ". TABLE_PREFIX . "thread.featured, threadid, firstpostid, ". TABLE_PREFIX . "thread.title, MAX(". TABLE_PREFIX . "attachment.attachmentid)AS attachmentid, ". TABLE_PREFIX . "attachment.dateline FROM ". TABLE_PREFIX . "attachment, ". TABLE_PREFIX . "thread, ". TABLE_PREFIX . "forum
WHERE ". TABLE_PREFIX . "thread.featured='1' AND ". TABLE_PREFIX . "thread.forumid=". TABLE_PREFIX . "forum.forumid AND ". TABLE_PREFIX . "thread.firstpostid = ". TABLE_PREFIX . "attachment.postid AND ". TABLE_PREFIX . "attachment.dateline < " . TIME() ."
GROUP BY ".TABLE_PREFIX ."thread.threadid
ORDER BY ". TABLE_PREFIX . "attachment.attachmentid DESC LIMIT $feat_rows");



while ($featured = $db->fetch_array($featured_thumbs))
{
eval('$featured_gallery .= "' . fetch_template('gallery_featured') . '";');
}

This returns a blank page on thread view without an error message. Basically I want to add some additional information to the user postbit information, such as a link to the user's profile if he\she has uploaded gallery images. Why does this return a blank page upon thread view? Any help would be appreciated.

So far I have changed the names of the variables, which doesn't matter. Removed num-row etc. All that is needed is to check if a user has uploaded a gallery image.

[Harald_T]

@Bernd: The query is completly wrong for this case. You would have to check, if the user has posted in the gallery-forum and had uploaded there an attachment. So, something like (just an example, no reals SQL-Instruction):

If attachment.userid=post.userid and attachment.gallery="1" then...

I can have a look at this, as this is something, i wanted to release, either.

[Bernd]

IC. Darn, thought i could get away with the existing queries.
Might as well list the other ideas I had. Will post any progress I make myself.

Extend the gallery under members info with next\previous page (that way u have ur own personally gallery, which doesn't just list the last couple of images).

Featured artist link in postbit userinfo, which links to the last uploaded featured image of an artist.

Gallery link in postbit userinfo, which links to memberinfo.

That's about all I can think of.

[imported_magjr]

Is it tomorrow yet?

You said on the 29th you;d look at my issue tomorrow. It's now the third of june. I really don't want to uninstall this cause its great, but if its not going to work, it's not going to work.

[camuca]

Go and configure Usergroup permissions via the UserCP for usergroups => What needs to be configured?

Thanks

[TwinHawksClub]

The hack isn't working for me. I got to making the forum, and it didn't have the extra options below "Save". Are you supposed to upload forumdisplay.php via Binary or ASCII? I did both, and there were no extra options under "Save" both times.

Harald_T, if I change some of the instructions and elaborate more, will you change the install instructions in the zip file? I don't want any credit.

[TwinHawksClub]

Originally Posted by TwinHawksClub

The hack isn't working for me. I got to making the forum, and it didn't have the extra options below "Save". Are you supposed to upload forumdisplay.php via Binary or ASCII? I did both, and there were no extra options under "Save" both times.

Harald_T, if I change some of the instructions and elaborate more, will you change the install instructions in the zip file? I don't want any credit.

Here's a link to the Gallery: http://www.twinhawksclub.com/forums/forumdisplay.php?f=

I just don't know what I didn't do correct.

[Harald_T]

You didn't set the id of your gallery in the gallery-options, IMHO.

[TwinHawksClub]

Originally Posted by Harald_T

You didn't set the id of your gallery in the gallery-options, IMHO.

There are no gallery options. The only proof that I have that I am installing the hack, is that it has a link in the navbar.