The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
Gallery for vBulletin 3.5.X Details »» | |||||||||||||||||||||||||
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 Show Your Support
|
Comments |
#1022
|
|||
|
|||
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!! |
#1023
|
|||
|
|||
I'm trying to hook one of the queries below into postbit_display_start in a new plugin.
Code:
// #################### 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') . '";'); } 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. |
#1024
|
|||
|
|||
@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. |
#1025
|
|||
|
|||
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. |
#1026
|
|||
|
|||
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. |
#1027
|
|||
|
|||
Go and configure Usergroup permissions via the UserCP for usergroups => What needs to be configured?
Thanks |
#1028
|
||||
|
||||
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. |
#1029
|
||||
|
||||
Quote:
I just don't know what I didn't do correct. |
#1030
|
|||
|
|||
You didn't set the id of your gallery in the gallery-options, IMHO.
|
#1031
|
||||
|
||||
Quote:
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|