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

[calgdsm]

Originally Posted by calgdsm

Working!!

But still a few problems.

1. Some of the titles are in German! Can i fix this?

Can i fix this the file size is in german i think i cant read it. can you tell me how to fix it.

I love the HACK great job!!

[Harald_T]

Dateigröße = Filesize. You find it in the template "gallery_threadbit". It's twice there, as much as i remember.

[seany1]

Thanks Harald worked first time, very much appriciated

is there any way to show submissions on the postbit, if not then not to worry.

again thanks for a great gallery

Seany

[Charles_1]

Originally Posted by Harald_T

@Charles_1: Can you contact me via pm?

Yes, of course. I did it already (sent PM yesterday).

[kofoid]

Originally Posted by Harald_T

@Kofoid: Try this code for the plugin: gallery_images_forumhome

// #################### Latest Gallery-Additions #######################
// fetch the permissions for each forum
// global $vbulletin;
if ($vbulletin->options['show_latest']) {
$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
if ($vbulletin->options['show_random']) {
$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 will remove two queries, if those gallery-options are not used. Tell me, if it works, and i'll build up the whole plugin this way. This is just a workaround, no final solution for this problem. But it may help a bit.

Hi there - I tried this and it adds 4 queries to my forumhome - does that sound right?

[Harald_T]

O.k., if it does so, it should be right. I'll post another code later, which will only do the queries, which are really used.

I'm working on this routine, so it will only use one query. But atm it doesn't work right.

[Harald_T]

I would suggest, if you don't need the featured-option, use this code:

// #################### Latest Gallery-Additions #######################
// fetch the permissions for each forum
// global $vbulletin;
if ($vbulletin->options['show_latest']) {
$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
if ($vbulletin->options['show_random']) {
$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') . '";');
}

}

This is only a temporarily solution, as i said, i'm writing a new code for this.

[Tanya123]

My Admins and my Super Mods can see the gallery but my Mods and registered members and custom groups cannot see them. They get red X's. I setup the permission for them to see but still nothing.

[Harald_T]

@Tanya: Can your users download attachments? Could be this.

[whoopass]

Is it possible to show the gallery on the vbportal page?