Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.6 > vBulletin 3.6 Add-ons
Reload this Page Forum Display Enhancements - vBi-Gallery for vB 3.6.X
FAQ Community Calendar Today's Posts Search

Reply
Page 7 of 32 « First 56 7 8917 Last »
 
Thread Tools
vBi-Gallery for vB 3.6.X Details »»
vBi-Gallery for vB 3.6.X
Version: 1.30, by Harald_T Harald_T is offline
Developer Last Online: Jan 2012 Show Printable Version Email this Page
Category: Forum Display Enhancements - Version: 3.6.2 Rating:
Released: 10-07-2006 Last Update: Never Installs: 200
DB Changes Uses Plugins Template Edits
Code Changes  
No support by the author.

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.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #62  
Old 10-16-2006, 04:10 PM
Harald_T Harald_T is offline
 
Join Date: Aug 2003
Location: Kleve, Germany
Posts: 531
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
@Hades: I don't have much freetime, as i have a job and a family also. The problem with the permissions. Give guests the permission to download attachments, this should help.

As soon as i get the time for it, i will update the FAQ on the first page.

If you get messages displaying that there missing columns in the SQL-Database try to reinstall the product (and overwrite the old version). Or check out for sure, that you have the rights to run queries.
Reply With Quote
  #63  
Old 10-16-2006, 04:17 PM
Antiblank Antiblank is offline
 
Join Date: May 2005
Location: PDX
Posts: 61
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Tried overwriting the product again, every other product I have installs/upgrades fine. But as soon as I enable the gallery again the boards totally break and all I get is:

Code:
Database error in vBulletin 3.6.2:

Invalid SQL:
SELECT gallery, threadid, firstpostid, thread.title, attachmentid, attachment.dateline FROM attachment, thread, forum
WHERE gallery='1'AND thread.featured!='1' AND  thread.forumid=forum.forumid AND thread.firstpostid = attachment.postid AND attachment.dateline < 1161018334 ORDER BY RAND() LIMIT 5;

MySQL Error  : Unknown column 'thread.featured' in 'where clause'
Error Number : 1054
Reply With Quote
  #64  
Old 10-16-2006, 04:20 PM
Antiblank Antiblank is offline
 
Join Date: May 2005
Location: PDX
Posts: 61
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
By the way, the 3.5.4 Version of this Hack lists itself on the post as version 1.23. Where here on this thread you list the version as 1.30 for 3.6.2 vBulletin. But when I upgrade with the download here on this thread the product lists itself in the Product manager section as 1.23:

vBI-Gallery 1.23 A gallery-system integrated in the forum
Reply With Quote
  #65  
Old 10-16-2006, 04:46 PM
Hades-1 Hades-1 is offline
 
Join Date: May 2004
Posts: 114
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
well can u please tell me how to show the image at original size not 3x to large???
Reply With Quote
  #66  
Old 10-16-2006, 05:10 PM
Harald_T Harald_T is offline
 
Join Date: Aug 2003
Location: Kleve, Germany
Posts: 531
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Edit "gallery-attachment"-Template

Replace it with:

Code:
<a href="attachment.php?$session[sessionurl]attachmentid=$attachment[attachmentid]&amp;d=$attachment[dateline]"<if condition="$show['newwindow']"> target="_blank"</if>>

<if condition="$attachment[filename]!=$vboptions[gal_feat_name]">
<img class="thumbnail" src="attachment.php?$session[sessionurl]attachmentid=$attachment[attachmentid]&amp;stc=1&amp;thumb=0&amp;d=$attachment[thumbnail_dateline]" border="0" align="center"></a>
&nbsp;<if condition="$show['br']"><br /><br /></if>
</if>
Reply With Quote
  #67  
Old 10-16-2006, 05:21 PM
Harald_T Harald_T is offline
 
Join Date: Aug 2003
Location: Kleve, Germany
Posts: 531
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
@Antiblank:

Try this one. Replace the code for random_thumbs in the plugin "gallery_images_forumhome" with this one:

Code:
if ($vbulletin->options['show_random']) {
$random_thumbs = $db->query_read("SELECT gallery, threadid, firstpostid, ". TABLE_PREFIX . "thread.title,". TABLE_PREFIX . "thread.featured, 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 5");

while ($rand_gallery = $db->fetch_array($random_thumbs))
{
eval('$random_gallery .= "' . fetch_template('gallery_randompictures') . '";');
}
Reply With Quote
  #68  
Old 10-16-2006, 06:35 PM
Antiblank Antiblank is offline
 
Join Date: May 2005
Location: PDX
Posts: 61
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by Harald_T
@Antiblank:

Try this one. Replace the code for random_thumbs in the plugin "gallery_images_forumhome" with this one:
...

Nearly perfect thank you for the help. The only issue now is that on my forum home page, I see a header section at the top for Random Images from the gallery, but no images appear there. But the layout is showing correctly in the gallery forum as well as on the members profile pages. So for those you get my mightest thanks. Glad to be able to turn that much back on again.
Reply With Quote
  #69  
Old 10-16-2006, 06:49 PM
Antiblank Antiblank is offline
 
Join Date: May 2005
Location: PDX
Posts: 61
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Now I'm starting to feel bad about posting but maybe this is related to my other issue. I just went to my forum manager and tried to update the settings on my gallery forum. (I also tried updating any of our forums and the error is along the same lines).

Code:
Database error in vBulletin 3.6.2:

Invalid SQL:
UPDATE forum SET
	title_clean = 'Refridgerator of Joy',
	title = 'Refridgerator of Joy',
	description_clean = '',
	description = '',
	link = '',
	displayorder = 1,
	parentid = 31,
	daysprune = -1,
	defaultsortfield = 'lastpost',
	defaultsortorder = 'desc',
	showprivate = 0,
	newpostemail = '',
	newthreademail = '',
	### Bitfield: forum.options ###
		options = IF(options & 8, options - 8, options),
		options = IF(options & 16, options - 16, options),
		options = IF(options & 32, options - 32, options),
		options = IF(options & 32768, options - 32768, options),
		options = IF(options & 8192, options, options + 8192),
		options = IF(options & 4, options, options + 4),
		options = IF(options & 1, options, options + 1),
		options = IF(options & 2, options, options + 2),
		options = IF(options & 16384, options, options + 16384),
		options = IF(options & 256, options - 256, options),
		options = IF(options & 64, options, options + 64),
		options = IF(options & 128, options, options + 128),
		options = IF(options & 512, options, options + 512),
		options = IF(options & 1024, options, options + 1024),
		options = IF(options & 2048, options, options + 2048),
		options = IF(options & 4096, options, options + 4096),
		options = IF(options & 65536, options, options + 65536),
	styleid = 0,
	password = '',
	gallery = '1',
	gallery_cat = '0',
	gal_thumbs = 0,
	gal_statusicon = ''
WHERE forumid = 32;

MySQL Error  : Unknown column 'gallery_cat' in 'field list'
The bit:

Code:
MySQL Error  : Unknown column 'gallery_cat' in 'field list'
appears for every forum in the error after I try to save any settings.
Reply With Quote
  #70  
Old 10-16-2006, 08:41 PM
Harald_T Harald_T is offline
 
Join Date: Aug 2003
Location: Kleve, Germany
Posts: 531
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
The altering on the table "forums" is missing for the gallery_cat. Did you check your config-file if you are able to run a query? Normally this shouldn't, but you never know.

Otherwise run the query in your admin-cp.

Code:
ALTER TABLE forum ADD gallery_cat TINYINT( 4 ) NOT NULL
Be sure to set the the prefix for the table forum, if you have so. E.g. vb_forum
Reply With Quote
  #71  
Old 10-16-2006, 10:51 PM
Antiblank Antiblank is offline
 
Join Date: May 2005
Location: PDX
Posts: 61
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by Harald_T
The altering on the table "forums" is missing for the gallery_cat. Did you check your config-file if you are able to run a query? Normally this shouldn't, but you never know.

Otherwise run the query in your admin-cp.

Code:
ALTER TABLE forum ADD gallery_cat TINYINT( 4 ) NOT NULL
Be sure to set the the prefix for the table forum, if you have so. E.g. vb_forum
I added that in as it was missing and tried again, now it seems I'm missing another. This is leading me to believe that perhaps none of the sql queries were made. Yet I have a gallery set up on my site, it was there and seeming to run fine before this upgrade.

New Error:
Code:
Database error in vBulletin 3.6.2:

Invalid SQL:
UPDATE forum SET
	title_clean = 'Refridgerator of Joy',
	title = 'Refridgerator of Joy',
	description_clean = '',
	description = '',
	link = '',
	displayorder = 1,
	parentid = 31,
	daysprune = -1,
	defaultsortfield = 'lastpost',
	defaultsortorder = 'desc',
	showprivate = 0,
	newpostemail = '',
	newthreademail = '',
	### Bitfield: forum.options ###
		options = IF(options & 8, options - 8, options),
		options = IF(options & 16, options - 16, options),
		options = IF(options & 32, options - 32, options),
		options = IF(options & 32768, options - 32768, options),
		options = IF(options & 8192, options, options + 8192),
		options = IF(options & 4, options, options + 4),
		options = IF(options & 1, options, options + 1),
		options = IF(options & 2, options, options + 2),
		options = IF(options & 16384, options, options + 16384),
		options = IF(options & 256, options - 256, options),
		options = IF(options & 64, options, options + 64),
		options = IF(options & 128, options, options + 128),
		options = IF(options & 512, options, options + 512),
		options = IF(options & 1024, options, options + 1024),
		options = IF(options & 2048, options, options + 2048),
		options = IF(options & 4096, options, options + 4096),
		options = IF(options & 65536, options, options + 65536),
	styleid = 0,
	password = '',
	gallery = '1',
	gallery_cat = '0',
	gal_thumbs = 1,
	gal_statusicon = ''
WHERE forumid = 32;

MySQL Error  : Unknown column 'gal_thumbs' in 'field list'
Reply With Quote
Reply
Page 7 of 32 « First 56 7 8917 Last »

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT. The time now is 01:17 AM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05005 seconds
  • Memory Usage 2,323KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (8)bbcode_code
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 
Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete