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

[jesus likes pie]

I'm quite confused...

So I've done everything but the part that isnt working too hot is making the forums...

I did this:

MADE new forum and made it a category, with display order 0 and is "acting as gallery" I then made a child forum (parent is the category that I had made) and left it as display order 1 (still cant be seen cause parent is 0), acts as gallery, and has 4 rows.

When I click on the link to go there it says "Sorry! This forum is not accepting new posts."

Whats going on?

[shardex]

I am trying to convert the original hack to 3.5 and am having trouble with this code in the forumdisplay.php:

PHP Code:

$sql_threads = "SELECT $votequery $previewfield    thread.threadid, thread.title AS threadtitle, ".
         "thread.forumid, pollid, open, replycount, postusername, postuserid, ".
         "thread.iconid AS threadiconid, $lastpost_info, thread.dateline, ".
         "IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, ".
         "sticky, votetotal, thread.attach,    hiddencount ".
         iif($displaythumbs == true, ", MIN(attachment.attachmentid) AS attachmentid ").
         iif($vbulletin->options['threadsubscribed'] AND $vbulletin->userinfo['userid'], ", NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed").
         iif($deljoin, ", deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason").
         iif($vbulletin->options['threadmarking'] AND $vbulletin->userinfo['userid'], ', threadread.readtime AS threadread'). 
            "$hook_query_fields ".
            "FROM " . TABLE_PREFIX . "thread AS thread ".
            "$deljoin ".            
        iif($vbulletin->options['threadsubscribed'] AND $vbulletin->userinfo['userid'], " LEFT JOIN " . TABLE_PREFIX . "subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = " . $vbulletin->userinfo['userid'] . ")").
            iif($vbulletin->options['threadmarking'] AND $vbulletin->userinfo['userid'], " LEFT JOIN " . TABLE_PREFIX . "threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = " . $vbulletin->userinfo['userid'] . ")").
            "$previewjoin ".
            "$tachyjoin ".
            "$hook_query_joins ".
        iif($displaythumbs == true, "LEFT JOIN ".TABLE_PREFIX."attachment as attachment ON(attachment.postid = thread.firstpostid) ").
        "WHERE thread.threadid IN (0$ids) $hook_query_where ".
        "ORDER BY sticky DESC, $sqlsortfield $sqlsortorder ";
    $threads = $db->query_read($sql_threads);
    unset($limitothers, $delthreadlimit, $deljoin,$datecut, $votequery, $sqlsortfield, $sqlsortorder, $threadids); 


I am basically trying to follow the original format but adapt it for 3.5 since there is a bit if a difference in the $sql_threads variable. I figure you have overcome this and so I was wondering if you could help me out?

Cheers,

[Harald_T]

Originally Posted by jesus likes pie

I'm quite confused...

So I've done everything but the part that isnt working too hot is making the forums...

I did this:

MADE new forum and made it a category, with display order 0 and is "acting as gallery" I then made a child forum (parent is the category that I had made) and left it as display order 1 (still cant be seen cause parent is 0), acts as gallery, and has 4 rows.

When I click on the link to go there it says "Sorry! This forum is not accepting new posts."


Whats going on?

You don't need to set "Act as gallery" for the category. It isn't neccessary.
Your error sounds like you set the forum closed or something like this.

@Shardex: Do you try to convert my old gallery-hack or the thumbnail-hack? The code looks like the one for the thumbnail-hack from Delphy (i've made also an conversion for the thumbnail-on-forum-display-hack to 3.5).

[Vizionz]

how do i change it to show only 4 thumbnails instead of 5

[Harald_T]

I assume you mean on the Forumhome-Page?

Change the code for the plugin "latest_gallery_images" Hook->forumhome_complete to:

// #################### Latest Gallery-Additions #######################
// fetch the permissions for each forum
global $vbulletin;


$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() ." ORDER BY ". TABLE_PREFIX . "attachment.dateline DESC LIMIT 4");

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

That's it.

[Harald_T]

Originally Posted by Vizionz

if i missed something sorry but how can i change the thumbnails shown on forum and how to make that a closeable table. *note i guess i found out how just editing the rows thought that was for the main gallery page and how many rows down it goes ..

okay now with that how many pictures will actually go in there will it just keep going and going and going. or is this script have pages so like 20 to 40 pictures per page ? if not should be next addition

How many Thumbs are shown on one page is depending on how many threads are displayed on one page. You find this option in the vBulletin-Options under "Forum-Display-Options"->Maximum Displayed Threads Before Page Split. If you set it by 10 then only 10 thumbs per page will be shown (but only 10 threads also). I'm thinking of making this separate for the gallery.

[Vizionz]

thats horrible then so that means no matter what it will keep showing thumbs ?
so your page is gonna scroll all crazy. or you will have to have like 950 pages of posts for a big topic this should be a main concern to make this hack worth anything

[Harald_T]

It's not meant for the posts of a thread, but for the amount on threads displayed on your forumdisplay.

For example: If you set "Maximum Displayed Threads Before Page Split" to 100, then in your normal forums will be 100 threads shown, before page breaks. In the gallery there will be shown 100 thumbs. Depending on the number of rows, you've set in the gallery-options, the page won't be so long. If you set it to e. g. 5 rows, there will be 20 coloumns on the page.

But as i said, i'm thinking of making this independend from the forum.

[jesus likes pie]

Originally Posted by Harald_T

But as i said, i'm thinking of making this independend from the forum.

That would be very good.


As for Vizionz, you may notice that each forum (not thread) has pages (if well, its an active forum). So a forum looks like a thread, except that instead of posts, you get threads. And after X amount of threads, a new page is made.

[Harald_T]

@jesus: Did you check your settings for your category? I've looked at your forum, and it could be one of the other hacks that ist "shooting" between.