vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Gallery for vBulletin 3.5.X (https://vborg.vbsupport.ru/showthread.php?t=92875)

GuaRRand 06-01-2006 09:04 PM

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!! :D

Bernd 06-02-2006 07:42 AM

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') . '";');
}

This returns a blank page on thread view without an error message. Basically I want to add some additional information to the user postbit information, such as a link to the user's profile if he\she has uploaded gallery images. Why does this return a blank page upon thread view? Any help would be appreciated.

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.

Harald_T 06-02-2006 03:09 PM

@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.

Bernd 06-02-2006 03:41 PM

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.

imported_magjr 06-03-2006 05:25 AM

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.

camuca 06-03-2006 07:25 AM

Go and configure Usergroup permissions via the UserCP for usergroups => What needs to be configured?

Thanks

TwinHawksClub 06-03-2006 07:04 PM

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.

TwinHawksClub 06-03-2006 08:20 PM

Quote:

Originally Posted by TwinHawksClub
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.

Here's a link to the Gallery: http://www.twinhawksclub.com/forums/forumdisplay.php?f=

I just don't know what I didn't do correct.

Harald_T 06-03-2006 09:41 PM

You didn't set the id of your gallery in the gallery-options, IMHO.

TwinHawksClub 06-03-2006 10:43 PM

Quote:

Originally Posted by Harald_T
You didn't set the id of your gallery in the gallery-options, IMHO.

There are no gallery options. The only proof that I have that I am installing the hack, is that it has a link in the navbar.


All times are GMT. The time now is 08:24 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02432 seconds
  • Memory Usage 1,752KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete