vb.org Archive - Gallery for vBulletin 3.5.X

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)

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 ???

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

Code:

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

Code:

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

}

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

O.k., removed the problem.

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

ive left them on so you can see

Quote:

Originally Posted by Harald_T

O.k., removed the problem.

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

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

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.

:confused: :cross-eyed: :confused:

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.

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

when i have this option set to YES

PHP Code:


		
			
Gallery-Category?       Yes  No

this is the error i get when clicking on the forum/gallery

any ideas?

Can you make it so its also compatible with VBadvanced?

@skooby: To create a category, just make a new forum, and set the option "Act as a forum" to "No". That's all.

@Cheesegrits: Normally it should work with moderated pictures as well, as it's using the normal attachment-system of vB. I'm not 100% sure, as i never tested, to be honest.

@aky: Which error?

@GuaRRand: I made a solution for it. Search this thread, it's posted somewhere. I don't support vBadvanced directly, cause i'm not a fan of this product so much.

@DucatiJeff: You needed four days and don't get it to run? Why you didn't contacted me? I'm sure, i could have help you out your probs. So if you want to give it another try, contact me via pm.

Ok, another question :D
(maybe somewhere in the 68 pages, but havent found it yet...)

1. Can you make it so that the "topics" you make when uploading an image, doesnt show up on "new posts" (or recent/active topics).
As it is now, i upload 10 images and it pushes al my regular recent topics to the bottom of the list.

Oh, and it doesnt seem to register the images in the membersprofile (and i looked over the coding twice...i dont think i put it in wrong)

I uploaded the button and it doesn't show like here

https://vborg.vbsupport.ru/attachmen...8&d=1122323356

How/Where do I add comments?

And in the member profile I see the table:
"Latest gallery-submission of:: Happy"

But no picture.

Quote:

Originally Posted by GuaRRand

Nvm the member profile thing i had. found ur updated XML already ;)

SO that leaves question #1. how to get the gallery "topics" to NOT show on the recent threads view

[edit]: i also noticed that, if i create a SECURE gallery forum (only for logged in users or some other specific usergroup), it'll still show those pics on the forumhome...
Can it be made so that the forum home also follows the usergroup permissions???

@Mastar: This is only the Lastest-Gallery-Addition-Box for your Forumhome. If you go to the gallery, you should find the button.

@GuaRRand: This is a good point. I'll see, if i can find a solution for it.

i have done everything but when i click on the upload button...it just looks like the regular thread form???

edit..never mind :) my mistake.

Quote:

Originally Posted by gamelandz

i have done everything but when i click on the upload button...it just looks like the regular thread form???

That ist normal, yes. I haven't figured out yet, how to change that form into a new one only for the gallery. It's on my list, but not yet.

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

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.

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

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.

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.

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

Thanks

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.

Quote:

Originally Posted by TwinHawksClub

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.

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

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.

The gallery options are under vbulletin options in your admin control panel. You can specify one forum id there for the navbar button\hyperlink.

Quote:

Originally Posted by Bernd

The gallery options are under vbulletin options in your admin control panel. You can specify one forum id there for the navbar button\hyperlink.

They aren't, that's what i'm saying. If you were in the Admin CP, you'd have no idea that a Gallery has been installed unless you looked at the Plug-in Manager.

The gallery edit options are in the Vbul options

Quote:

Originally Posted by imported_magjr

The gallery edit options are in the Vbul options

...lol...
not here...
http://i2.photobucket.com/albums/y47...tt/admincp.jpg
and not here..
http://i2.photobucket.com/albums/y47...t/admin_cp.jpg

I will send the forumdisplay.php file to someone if they will check it and see if anything is wrong.

Did you import the plugin?

Quote:

Originally Posted by Harald_T

Did you import the plugin?

You gotta be kidding me.

I apologize if I was harsh in tone in any of my posts.

I selected it to upload, and then filled in the fields in the box below, and hit "Save". :doh:

That would be my problem, it didn't upload the XML file, but it showed the 'product'.

I now see the settings for it on the vBulletin options.

Quote:

Originally Posted by TwinHawksClub

One last thing. It is still saying this... http://www.twinhawksclub.com/forums/....php?f=Gallery

Did you fill in th number of the category in the option?

Quote:

Originally Posted by Harald_T

Did you fill in th number of the category in the option?

Nope, check it now though.

It doesn't matter whether I put 70 or 71, it still takes you to 70. (which won't load)

I changed 70's settings to act as forum, and still no luck. I've tried setting them opposite each other and with different combinations (act as gallery, gallery-category), and changed the ID field in the Gallery settings, but still not luck.

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03183 seconds Memory Usage 1,849KB 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 (3)bbcode_code_printable (1)bbcode_php_printable (10)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (40)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
Messages: