Forum Display Enhancements - vBi-Gallery for vB 3.6.X

This is the 3.6.X-Version of my vBi-Gallery for vBulletin.

It's an update to this hack:

https://vborg.vbsupport.ru/showthread.php?t=92875

This gallery-system integrates completly into vB, because it's a modification of the forum itself and uses the attachment-system of vb.

Therefore, it's neccessary to be sure, that the attachment-system is working and it's possible to create thumbs. Otherwise, the gallery won't work.

Btw, I want to thank all the people here, which are using this gallery.

[rknight111]

I also noticed that some new users that go on the board, the pics dont show up just an X, how could I make it so the pics will always show up on the gallery header. If not I would like to turven it off for non registered users and once they register the gallery and header all show up??

What should be the setting for jpg, I set it a few times but it goes back to 97kb

[freecodevn]

I've tried to hack this module and I found out the reason why I 'm not successed as follows:
a, In a successful case:
This forum was hacked successfully, the album display correctly so if you get the direct link of the picture like this
http://mottamlong.com/forum/attachme...1&d=1162350851 and you paste this link to new IE explore the image display correctly.
b, unsuccessful case:
But the image cannot display if I extract the image link forum my forum like this http://www.lhstrungquoc.com/forums/a...&stc=1&thumb=1 and paste it into the new IE explorer.
I suppose that this error caused by my forum attachment system, but I dont know how to solve it.
Any one can help me?
Many thank!

[FMCS]

After the mod was installed we noticed that the forum became horribly slow so I changed the 'gallery_images_forumhome' bit to the following:

PHP Code:

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

if (isset($forumid) == false)
{

$gal_num_rows = $vbulletin->options['gal_num_rows'];

if ($vbulletin->options['show_latest']==1)
{

// fetch latest pics
$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 random pics

if ($vbulletin->options['show_random']==1)
{
$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') . '";');
}
}

} 


the added bits are 'if (isset($forumid) == false)' so the thumbs aren't attempted to load on other pages than forumhome. (got a big speed-increase on the forums after doing this)

also added 'if ($vbulletin->options['show_random']==1)' and 'if ($vbulletin->options['show_latest']==1)' bits to get rid of redundant sqlqueries.

Hope this is of any use to people

[Necrosaro420]

Can this be set up so each user has their each individual section to upload their own pictures?

[Harald_T]

Originally Posted by FMCS

After the mod was installed we noticed that the forum became horribly slow so I changed the 'gallery_images_forumhome' bit to the following:

PHP Code:

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

if (isset($forumid) == false)
{

$gal_num_rows = $vbulletin->options['gal_num_rows'];

if ($vbulletin->options['show_latest']==1)
{

// fetch latest pics
$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 random pics

if ($vbulletin->options['show_random']==1)
{
$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') . '";');
}
}

} 


the added bits are 'if (isset($forumid) == false)' so the thumbs aren't attempted to load on other pages than forumhome. (got a big speed-increase on the forums after doing this)

also added 'if ($vbulletin->options['show_random']==1)' and 'if ($vbulletin->options['show_latest']==1)' bits to get rid of redundant sqlqueries.

Hope this is of any use to people

Thanks. You're right, i forgot to add the options for random and latest thumbs. And thanks for the hint regarding the forumid.

[Harald_T]

Originally Posted by Necrosaro420

Can this be set up so each user has their each individual section to upload their own pictures?

You could create a forum for each of your users. Depends of course, how many users should have such a section and how many users are on your board.

I was working on a routine, which creates a little gallery in your member-profile. Yet it didn't worked right. I have to rethink the routines...

[VBUsers]

i have a problem , i want my site to look like this attachment but i get this instead

http://www.talkgfx.com/forumdisplay.php?f=20

[VBUsers]

edit: i also seem to have a little german in the template

http://www.talkgfx.com/showthread.php?t=24

Nur f?r Mitglieder! = Only for members!

also no forums show for me here

http://www.talkgfx.com/forumdisplay.php?f=19

[Harald_T]

Originally Posted by AR Forums

i have a problem , i want my site to look like this attachment but i get this instead

http://www.talkgfx.com/forumdisplay.php?f=20

In the gallery-options you have one option where you can define the alternative-layout.

[VBUsers]

Originally Posted by Harald_T

In the gallery-options you have one option where you can define the alternative-layout.

but the width isnt right. its not long enough.

see here
http://www.talkgfx.com/forumdisplay.php?f=20