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

[wezoo]

i know

can you display random images and latest images, in the same way as the featured ?

for example, no border, no name, no info, just an image that links to the thread



ohhh Harald, dunno if you know but on my profile, latest images are actualy thumbnails rather than images ???

[Harald_T]

@Wez: Oh, this is a little bug. Change the code of the template "gallery_memberpictures" to:

<if condition="$gallery[filename]!=$vboptions[gal_feat_name]">
<td align="center">
<table class="tborder" align="center">
<tr>
<td class="thead" height="100" width="120" align="center">
<a HREF="attachment.php?attachmentid=$gallery[attachmentid]">
<img src="attachment.php?attachmentid=$gallery[attachmentid]&stc=1&thumb=1" border=0 align="center"></a>
</td>
</tr>
<tr>
<td valign="center" align="center" width="120" height="40">
<br />
<a href="showthread.php?t=$gallery[threadid]">
$gallery[title]
</a>
</td>
</tr>
</table>
</td>
</if>

Change the code of the plugin "gallery_memberprofile_images" to:

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

$thumbs = $db->query_read("SELECT gallery, userid, threadid, filename, firstpostid, ". TABLE_PREFIX . "thread.title, attachmentid, ". TABLE_PREFIX . "attachment.dateline FROM ". TABLE_PREFIX . "attachment, ". TABLE_PREFIX . "thread, ". TABLE_PREFIX . "forum
WHERE gallery='1' AND userid=$userinfo[userid]
 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.dateline DESC LIMIT $gal_member_num_rows");

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

[wezoo]

Harald, doesnt seem to have done anything ?
check out my homepage, also getting thumbs in the random images

[Harald_T]

O.k., removed the problem.

[wezoo]

Thanks Harald
still there on the home page when i turn on random images...?

ive left them on so you can see

[Bernd]

Originally Posted by Harald_T

O.k., removed the problem.

Please do post fixes for other people to see. Thank you.

[Harald_T]

@Bernd: I edited my post. See there for the neccessary changes.

[DucatiJeff]

Wow - I worked for 4 days on this and could not get it to work properly. I think very specific installation instructions are needed. When I went to uninstall the gallery1.23.xml file then decided to reinstall it - I shut down my entire site and received the following warning via Email:

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT thread.featured, threadid, firstpostid, thread.title, MAX(attachment.attachmentid)AS attachmentid, attachment.dateline FROM attachment, thread, forum
WHERE thread.featured='1' AND thread.forumid=forum.forumid AND thread.firstpostid = attachment.postid AND attachment.dateline < 1149121375
GROUP BY thread.threadid
ORDER BY attachment.attachmentid DESC LIMIT;

MySQL Error : You have an error in your SQL syntax near '' at line 4
Error Number : 1064
Date : Wednesday, May 31st 2006 @ 08:22:55 PM

Obviously I felt a sudden rush of panic. I uninstalled the product and my forums returned to normal. I guess I will purchase a product rather than risk all of the work I have put into my forums.

:cross-eyed:

[skooby]

When you say

1. First of all, create a category and call it "Gallery" (or anything else, if you like). Please remember the ID of this category, it's needed.

Where exactly do I go to create the new category? Sorry but this is a 68 page thread, so I'm sure the answer is in here somewhere but I couldn't find it.

[cheesegrits]

I've scanned all 67 pages of this thread and read the available documentation, but I still need to ask an obvious question ...

Can Gallery forums be moderated, such that all uploaded images need to be approved before they get displayed? I run an ISP in Alabama, and obviously I need to maintain tight control over the images that get uploaded!

TIA for any answers,

-- hugh