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)

cn_de 01-14-2006 08:42 PM

Quote:

Originally Posted by Harald_T
Das Query ?ndert die Datenbank, die Lage des Forums ist daf?r irrelevant.

eben ist nicht das Verzeichnis ein Problem, sondern hat man von Anfang an ?berhaupt keine Tabelle names "forum" vordefiniert. Sehen Sie bitte folgende Fehlermeldung "Table 'dbxxxxxxxxxxxx.forum' doesn't exist".

LBSources 01-14-2006 08:59 PM

Quote:

Originally Posted by Larrysw
like I said in a erly post you can make it not display all attachments by editing the forumdisply_query and replace with the fowling code:

PHP Code:

 if ($foruminfo['gallery']=='1'

$gallery true

  

if (
$gallery==true

    
$hook_query_fields .= ", attachment.thumbnail_filesize AS thumbsize , MIN(attachment.attachmentid) AS attachmentid ";  
    
$hook_query_joins .= "LEFT JOIN " TABLE_PREFIX "attachment as attachment ON(attachment.postid = thread.firstpostid) ";  
    
$hook_query_where .= "GROUP BY thread.threadid ";  



Was this directed to me in my question of other file types?

LBSources 01-14-2006 08:59 PM

Quote:

Originally Posted by Harald_T
I've included the code for the next version. This will also be included int the query for the last_images and random_images.

Oh, i don't know when it will be released, atm.

youve included the code for the other file types or for 3.5.3?


Thanks..

Lenny :)

LBSources 01-14-2006 09:18 PM

Harald.. mind taking a look at my forum and may clue me in as to what might cause this? http://www.technetinsiders.net/forumdisplay.php?f=102

i just noticed this.. thanks in advance..

Lenny :(

Well .. i included an image. i should add that the random images on the forumhome are still displaying properly.

Harald_T 01-15-2006 08:30 AM

@LB-Sources: Did you update your forum? If so, be sure to do the file-edit again.
And no, the reply was mentioned to LarrySW, for the posibility to upload more then one attach-file.

@cn-de: Die Fehlermeldung erscheint eigentlich immer dann, wenn das Prefix für die Tabelle "forum" fehlt. Ich möchte wetten, das Du ein Prefix für Dein Forum verwendest, richtig?

Ich hoffe übrigens in der nächsten Version einen Installer programmiert zu haben, der das Query selbständig durchführt.

For english users: I hope to include in the next version an XML-Version which will make it possible to run the database-query via the product.

cn_de 01-15-2006 10:11 AM

richtig, das Prefix für die Tabellen lautet "vbb", hast du einen Vorschlag? Danke!

Harald_T 01-15-2006 11:05 AM

Schreib in den Query anstelle "forum" einfach "vbb_forum".

Nebenbei, VBulletin wird ?blicherweise vb abgek?rzt... :D *?hem*

cn_de 01-15-2006 11:49 AM

Quote:

Originally Posted by Harald_T
Schreib in den Query anstelle "forum" einfach "vbb_forum".

Nebenbei, VBulletin wird ?blicherweise vb abgek?rzt... :D *?hem*

meinst du, soll es nicht "vbbforum" sein?
-------------------------------------
Naja, das "vBulletin chinese" hat es immer "VBB" genannt, offiziell.
Weiss ich auch nicht warum. Und nun nennen ?ber Millionen auf die Erde es dann "VBB". Vielleicht soll das vB mit dem vB-chinese Team mal reden, um Schadenersatz zu verlangen. :ermm:
-------------------------------------
Dankesch?n nochmals.

natralis 01-15-2006 12:20 PM

Looks very nice
Gonna try it out :)

Great job m8

[high]* natralis clicks install[/high]

LBSources 01-15-2006 02:23 PM

Quote:

Originally Posted by Harald_T
@LB-Sources: Did you update your forum? If so, be sure to do the file-edit again.

oddly enough .. when i recently moved hosts.. i found myself editing the old files on the old host servers.. LMAO.. hahaha! damn my age is showing..

thanks harald and i cant wait until the next release..

Lenny :)

Harald_T 01-15-2006 03:14 PM

Quote:

Originally Posted by cn_de
meinst du, soll es nicht "vbbforum" sein?
-------------------------------------
Naja, das "vBulletin chinese" hat es immer "VBB" genannt, offiziell.
Weiss ich auch nicht warum. Und nun nennen ?ber Millionen auf die Erde es dann "VBB". Vielleicht soll das vB mit dem vB-chinese Team mal reden, um Schadenersatz zu verlangen. :ermm:
-------------------------------------
Dankesch?n nochmals.


Nene, sollte nur ein Joke sein.

Aber obwohl, das mit dem Schadensersatz, das w?re zu ?berl... Ach nee, lieber nicht! :D

Lamby1973 01-16-2006 09:13 AM

Hiya, got a little bit of a problem with the mod.

Ive installed it as per instructions asked.... But when ive gone to test it out, non of the pictures show up...just blank....

Any ideas? Attached screenshot...

DrewM 01-16-2006 10:18 AM

I would make sure php thumbs are turened on then i would try re-installing the hack.

Lamby1973 01-16-2006 11:09 AM

How would i do that then?

Lamby1973 01-16-2006 03:06 PM

Its actually red X's that im getting....its just firefox doesnt show the Red X lol

Any help?

Am im doing right by using the Attachments to upload the picutures arent i? Nothings changed lol :D

tuanluu 01-16-2006 06:54 PM

maitance rebuil all thumbnails

ACP --> image setting turn on your GD or image ..

Harald_T 01-16-2006 07:55 PM

I would suggest this, too. Or check also, if your vB generates Thumbnails for your attachment-files. Look at the graphics-settings of your VB and the settings for your attachment.

Lamby1973 01-17-2006 07:28 AM

Thanks!

Got it working now!! Cheers!

ConKien 01-22-2006 02:54 AM

Quote:

Originally Posted by Harald_T
I would suggest this, too. Or check also, if your vB generates Thumbnails for your attachment-files. Look at the graphics-settings of your VB and the settings for your attachment.

Harald_T, somehow when I edit the thread, it did not let me edit the content inside textarea, it just show the Title of the thread. Do you have any idea why is that?

Thanks,
CK

Harald_T 01-22-2006 07:17 AM

Wait for the next update. The normal edit-function is missing atm.

antropus 01-29-2006 01:04 AM

Hi,
I installed both gallery and attachment as forum thumbnails and now when I try to access the gallery forum I'm getting this error message:

Quote:

Database error in vBulletin 3.5.3:

Invalid SQL:

SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
post.pagetext AS preview,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
thread.lastpost, lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach , attachment.attachmentid AS attachmentid , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
FROM vb3_thread AS thread
LEFT JOIN vb3_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
LEFT JOIN vb3_subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1)

LEFT JOIN vb3_post AS post ON(post.postid = thread.firstpostid)
LEFT JOIN vb3_attachment as attachment ON(attachment.postid = thread.firstpostid)

LEFT JOIN vb3_attachment as attachment ON (attachment.postid = thread.firstpostid)
WHERE thread.threadid IN (0,9053,9052)
ORDER BY sticky DESC, thread.lastpost DESC;

MySQL Error : Not unique table/alias: 'attachment'
Error Number : 1066
Date : Saturday, January 28th 2006 @ 09:48:46 PM
Script : http://www.3d4all.org/foruns/forumdisplay.php?f=116
Referrer : http://www.3d4all.org/foruns/index.php
IP Address : 24.127.131.174
Username : A_t_o_s
Classname : vb_database
Any thoughts?
Thanks

Harald_T 01-29-2006 07:59 AM

You have a double instruction of LEFT JOIN in your Query.

ScottC20 01-29-2006 09:38 AM

Would it be possible to configure the gallery so as when you are uploading a new picture, it will not let you continue unless a picture is uploaded. Some of my users forget to upload or post a hot link to somewhere like photobucket where their pics are uploaded already.

Chadwiggles 01-30-2006 10:53 PM

Fixed my original problem. Now how can I change the info to English?

pastry 01-31-2006 05:01 AM

I want to change it from the coders language to mine own.. anybody want to give me a hand and tell me how to do this ? :banana:

DrewM 01-31-2006 09:27 AM

Quote:

Originally Posted by Chadwiggles
Fixed my original problem. Now how can I change the info to English?

Go to Languages & Phrases then just chang the gallary phares.

Adyum 01-31-2006 01:42 PM

I don't see any gallery phrases there.

DrewM 01-31-2006 07:09 PM

Search for the fowling phares:
$vbphrase[gal_user]
$vbphrase[gal_comments]
$vbphrase[gal_views]
$vbphrase[gal_show_pic_size]
$vbphrase[gal_posted_by]
$vbphrase[gal_posted_date]
$vbphrase[gal_comments]
and change them to engilsh this is the fastested way.

Harald_T 01-31-2006 08:58 PM

Just to let you know:

ATM i'm very busy on programming an special calculation-application, which has to be finished end february (it's a paid job). So please be patient.

Adyum 01-31-2006 10:06 PM

Thank you , it is much easy to read now :D. One last question. I am using it on my site (lostgurus.com) and I can not get the thumbnail to work. What do I need to post in my thread to get a thumb nail?

Thanks,
Adyum

DrewM 02-01-2006 07:42 PM

In vboptions under Message Attachment.

Annie^.^ 02-08-2006 07:08 PM

Is there a possibility to add this in users profile also?

Harald_T 02-08-2006 09:16 PM

I'm thinking of integrating some kind of this in one of the next versions.

Annie^.^ 02-08-2006 10:28 PM

thanks.... would you know when that might be? ^___^

prettyboi 02-09-2006 09:14 AM

Can someone please tell me how to run a querie?

DrewM 02-09-2006 09:41 AM

Look in the install closer.

ConKien 02-15-2006 03:09 AM

Quote:

Originally Posted by Harald_T
For inserting the missing Edit-Button:

In the template "gallery_postbit" find

<br />
<hr>

insert after the <br /> the following code:

<if condition="$post['editlink']">
<a href="$post[editlink]" name="vB::QuickEdit::$post[postid]"><img src="$stylevar[imgdir_button]/edit.gif" alt="$vbphrase[edit_delete_message]" border="0" /></a>
</if>

Now the edit-button is back again.

Thanks Harald_T, that would show the Edit button, but when you click on Edit, it's only let you edit the Title, not the contents inside the textarea.

Is there a quick fix for that Harald?

Harald_T 02-15-2006 04:50 PM

I've checked this, and the code is the same in my gallery. When you click edit you are able to edit the textarea. Also you could change the attachment for the posting. Sure that the user-rights are o.k.?

ConKien 02-15-2006 05:09 PM

Quote:

Originally Posted by Harald_T
I've checked this, and the code is the same in my gallery. When you click edit you are able to edit the textarea. Also you could change the attachment for the posting. Sure that the user-rights are o.k.?

Ok, I did not add the code you post above for showing the edit button. I used the Thread Tools -> Edit Thread option and maybe that's why!

Thanks Harald_T!

ScottC20 02-21-2006 08:58 AM

How's this coming along then?


All times are GMT. The time now is 11:19 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.03122 seconds
  • Memory Usage 1,830KB
  • 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_php_printable
  • (11)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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