Instant Image Gallery - 5 minute install

[x3n0]

A simple user image attachment gallery that requires a single script upload, 2 template creations, and 1 phrase creation.

Live demo:

http://www.zeewaterforum.org/forums/gallery.php?pp=10&page=2&showthumbs=1&userid=359

Step 1: Upload gallery.php to your forum home directory.

Step 2: Create a new global phrase named "gallery" with the text "Click to view {1}'s image gallery" or something similar.

Step 4: Create a template called "gallery" and past the following code into it:


<form action="gallery.php" method="post">

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<thead>
<tr>
<td class="tcat" colspan="4">
<if condition="$show['attachquota']">
<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('attachinfo')"><img id="collapseimg_attachinfo" src="$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_attachinfo].gif" alt="$vbphrase[attachment_statistics]" border="0" /></a>
</if>
<phrase 1="$username">$vbphrase[attachments_posted_by_x]</phrase>
</td>
</tr>
</thead>
<if condition="$show['attachquota']">
<tbody id="collapseobj_attachinfo" style="$vbcollapse[collapseobj_attachinfo]">
<tr>
<td class="panelsurround" align="center" colspan="4">
<div class="panel">
<div style="width:$stylevar[formwidth_usercp]" align="$stylevar[left]">
<fieldset class="fieldset">
<legend>$vbphrase[attachment_statistics]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0" width="100%">
<tr>
<td><phrase 1="$attachsum" 2="$totalattachments">$vbphrase[currently_using_x_to_store_y_attachments]</phrase></td>
</tr>
<if condition="$show['attachlimit']">
<tr>
<td>
<table style="border:2px groove" cellpadding="0" cellspacing="1" border="0" width="100%">
<tr>
<if condition="$show['currentattachsize']"><td width="$attachsize" style="background-color:red; font-size:10px" title="<phrase 1="$attachsum">$vbphrase[current_attachment_total_x]</phrase>">&nbsp;</td></if>
<if condition="$show['totalattachsize']"><td width="$totalsize" style="background-color:green; font-size:10px" title="<phrase 1="$attachlimit">$vbphrase[maximum_attachment_storage_x]</phrase>">&nbsp;</td></if>
</tr>
</table>
</td>
</tr>
</if>
</table>
</fieldset>
</div>
</div>
</td>
</tr>
</tbody>
</if>
<tbody>
<tr align="center">
<td class="thead">$vbphrase[attachment]</td>
<td class="thead">$vbphrase[title]</td>
<if condition="$show['deleteoption']">
<td class="thead">$vbphrase[date]</td>
<td class="thead" style="padding:0px"><input name="allbox" type="checkbox" value="Check All" title="$vbphrase[check_uncheck_all]" onclick="checkall(this.form);" /></td>
<else />
<td class="thead" colspan="2">$vbphrase[date]</td>
</if>

</tr>
<if condition="$show['thumbnails']"><col align="center"></col></if>

$template[gallerybits]

<tr>
<td class="tfoot" colspan="4" align="$stylevar[right]">
<span class="smallfont" style="float:$stylevar[left]">
<if condition="$show['thumbnails']">
<a href="gallery.php?pp=$perpage&amp;page=$pagenumber&amp;userid=$u serid"><strong>$vbphrase[hide_thumbnails]</strong></a>
<else />
<a href="gallery.php?pp=$perpage&amp;page=$pagenumber&amp;showthumb s=1&amp;userid=$userid"><strong>$vbphrase[show_thumbnails]</strong></a>
</if>
</span>
<if condition="$show['deleteoption']">
<input type="hidden" name="perpage" value="$perpage" />
<input type="hidden" name="pagenumber" value="$pagenumber" />
<input type="hidden" name="showthumbs" value="$showthumbs" />
<input type="hidden" name="do" value="deleteattachments" />
<input type="hidden" name="userid" value="$userid" />
<input type="submit" class="button" value="$vbphrase[delete_selected]" />
</if>
</td>
</tr>
</tbody>
</table>

</form>

<if condition="$pagenav">
<table cellpadding="0" cellspacing="0" border="0" width="100%" style="margin-top:3px">
<tr valign="top">
<td align="$stylevar[right]">$pagenav</td>
</tr>
</table>
</if>


Step 4: Create a new template called "gallerybits" and paste the following code in it:


<tr>
<td class="alt2">
<div>
<if condition="$showthumbs">
<a href="attachment.php?$session[sessionurl]attachmentid=$post[attachmentid]" target="attachment"><img src="attachment.php?$session[sessionurl]attachmentid=$post[attachmentid]&amp;stc=1&amp;thumb=1" border="0" /></a>
<else />
<img class="inlineimg" src="$stylevar[imgdir_attach]/$post[attachmentextension].gif" alt="$post[attachmentextension]" /> <a href="attachment.php?$session[sessionurl]attachmentid=$post[attachmentid]" target="attachment">$post[filename]</a>
</if>
</div>
<div class="smallfont">$post[size], <phrase 1="$post[counter]">$vbphrase[x_downloads]</phrase></div>
</td>
<td class="alt1">
<div class="smallfont">
<div><strong>$vbphrase[thread]</strong>: <a href="showthread.php?$session[sessionurl]t=$post[p_threadid]">$post[t_title]</a></div>
<div><strong>$vbphrase[post]</strong>: <a href="showthread.php?$session[sessionurl]p=$post[postid]#post$post[postid]">$post[p_title]</a></div>
</div>
</td>
<td class="alt2">
<if condition="$show['inprogress']">
<em>$vbphrase[in_progress]</em>
<else />
<div class="smallfont">$post[postdate] <if condition="!$show['detailedtime']"><span class="time">$post[posttime]</span></if></div>
</if>
</td>
<if condition="$show['deletebox']">
<td class="alt1" align="center" style="padding:0px"><input type="checkbox" name="deletebox[$post[attachmentid]]" value="yes" /></td>
<else />
<td class="alt1" align="center">&nbsp;</td>
</if>
</tr>


Step 5: Call the script passing the "userid" variable of the users gallery you wish to view.

Example - I simply added the following code to my postbit template:


<a href="gallery.php?userid=$post[userid]&pp=10&showthumbs=1" target="new"><img class="inlineimg" src="$stylevar[imgdir_button]/gallery.gif" alt="<phrase 1="$post[username]">$vbphrase[gallery]</phrase>" border="0" /></a>


This allows the user to link to the gallery from anyone's posts. Then I uploaded the image to my button image directory. I've included an image you can use.

This even shows the location in Who's Online with no modifications necessary. Uploading/delete capabilities should be a simple addon, I'm working on it now.

Edit: Completely redone with it's own templates because it didn't like using vB's templates (hard coded URLs).

Edit: Changed template conditional making this 3.0.3 friendly.

Edit: Typo mysteriously appears in source making code fubar. Code revised and reuploaded.

[Tim Wheatley]

It's a thread attachments viewer you mean?

I'm confused. ;)

[x3n0]

Yes, attachments by user.

[Dennis01]

It says at all users they have no attachments to show?

Edit: Could it be this does not work if the attachments are stored in a filesystem instead of the database?

[x3n0]

Works for me and I store in the filesystem. The majority of our users have no attachments.

[Dennis01]

what kind of phrase did you make?

[x3n0]

Global

[Dennis01]

still no luck, is the storage folder name relevant?

[x3n0]

No, not relevant. Once you've uploaded the script just try calling the script by pasting:

http://www.YourForumUrl.com/YourPath/gallery.php?userid=1

Into your browser. Substituting a userid with known attachments and your forum path. BTW, I havent tested this on 3.0.3.

Be sure to download the fixed script I just uploaded. Fixed a minor fubar I made.

[Dennis01]

the same problem, I dont know if its of any help but an example you can find on http://www.zeewaterforum.org/forums/showthread.php?t=1053&page=3&pp=20 the lil icon is under the avatars.

btw im running on 3.0.3 :ermm:

[Dennis01]

Updated script down and uploaded, still no luck.

[x3n0]

If you give me the url I'll take a look.

Edit, just saw the URL - looking now.

[x3n0]

I tried a user with known attachments:

http://www.zeewaterforum.org/forums/gallery.php?userid=379

Are "Unregistered" users permitted to view and download attachments from your forum? Do you have thumbnails enabled?

The script ran and the page loaded, just without any attachments showing. Must be some difference with 3.0.3's queries or variables or perhaps I don't have the permissions. I will look into it this evening and get back to you.

BTW, I keep live reef aquariums too. I like your forum, too bad I can't read it ;) I used to post at Albert Thiel's site quite often.

[Dennis01]

Thank you very much... And for reef aquariums, you (at least i assume your an american) have reefcentral.com !!!! Almost as nice :bandit:

[x3n0]

I'm German, living in the US.

I also don't support George Bush's actions. ;)

[Dennis01]

Than you have the even better sites as http://www.meeresaquaristik.de/foren/ and korallenriff.de
Im from holland (dunno if you recognized the language) and for marineanimals I drive often to Germany, more shops better choise and prices ;)

Ill check back tomorrownight,

thanks in advance

[x3n0]

I've been known to drive to Holland for the coffee shops! ;)

[Highlander]

dont works, it shows 73 pages of attahcments but says NO ATTACHMENT AVAILABLE .. have the filesystem and version 3.0.0

Link:
http://spieleplanet.com/board/gallery.php?userid=1&pp=10&showthumbs=1

nothing showing up

[Neal-UK]

Well i've installed this and even though I have attachments posted in the forum, it says I haven't with this mod.

Everything has been done correctly.

[x3n0]

I don't get it..... This is the same code vB uses to view attachments in the control panel. Can you guys see attachments from your control panel?

[Dennis01]

Yep.

[x3n0]

OK I'm pulling my hair out on this. I'm going to not smoke any pot tonight and see if I can figure this out. Bear with me guys. Has anyone else other than me have this working?

[x3n0]

OK I made some changes to the script. I took out some of the conditionals I had intended on using for attachment deletion functions. New version has been uploaded. Give it another try.

[Dennis01]

Stil nothing m8.. but hey, go easy on yer hair.. we dont want to be guilty on you being bold :o

[Reeve of shinra]

This has promise. Keep up the good work!

[x3n0]

OK guys I've attached a debug script to this post. If you could download this and run it just like you would the gallery script (pass it a 'userid') it will generate some output before loading the HTML. Example:

Just copy and paste the debug output up here and hopefully I'll be able to figure this out.

[Reeve of shinra]

:) okay, no prob

[Dennis01]

:squareeyed:

[x3n0]

OK guys. All your variables look good so I'm assuming the problem lies in the fact that I used vBs templates. I've updated the first post with all the new info and scripts.

P. S. - Lets do everybody a favor and delete the debug output from those posts because it's messing up the sizing bad.

[Dennis01]

Almost there! The attachments are showing now but als files and not as picutures, any ideas?

http://www.zeewaterforum.org/forums/gallery.php?userid=359&pp=10&showthumbs=1

[x3n0]

Yes I was watching and refreshing it as you were installing. It seems you do not have thumbnails enabled on your forums. Without thumbnails enabled you'll only get links in the gallery page.

[Dennis01]

they are (where) enabled already as you can see on http://www.zeewaterforum.org/forums/showthread.php?t=1053&page=3&pp=20

They are set at 600 px however

[x3n0]

Dennis, I sent you a PM. Could be a difference between 3.0.0 and 3.0.3. See the PM and we'll figure it out.

[Reeve of shinra]

Same problem here as Dennis but yeah, getting close. (I am also on vb3.0.3 -- there were some comments in the vbarticles hack some time ago about the change from 3.0.1 to 3.0.3.)

http://www.shinraonline.com/board/gallery.php?userid=1189

[x3n0]

Looks to me like this should work on both 3.0.0 and 3.0.3

I've tracked it down to the conditional statement in the gallerybits template.


<if condition="$show['thumbnail']">
<a href="attachment.php?$session[sessionurl]attachmentid=$post[attachmentid]" target="attachment"><img src="attachment.php?$session[sessionurl]attachmentid=$post[attachmentid]&amp;stc=1&amp;thumb=1" border="0" /></a>
<else />
<img class="inlineimg" src="$stylevar[imgdir_attach]/$post[attachmentextension].gif" alt="$post[attachmentextension]" /> <a href="attachment.php?$session[sessionurl]attachmentid=$post[attachmentid]" target="attachment">$post[filename]</a>
</if>



I've verified that we can pull thumbnails from 3.0.3:

Thumb off:
http://www.shinraonline.com/board/attachment.php?attachmentid=11789
Thumb on:

http://www.shinraonline.com/board/attachment.php?attachmentid=11789&thumb=1

But for some reason you guys aren't satisfying the condition <if condition="$show['thumbnail']">

Ironically all of this code is straight out of the attachment templates on the user control panel.

I can see that the "gallery" template is parsing the thumbnail variable correctly because the links are being centered in the table by this conditional:


<if condition="$show['thumbnails']"><col align="center"></col></if>


Immediately after that conditional is evaluated in the "gallery" template, we call the "gallerybits" template to populate the table with attachments. The variable obviously isn't being passed correctly.

Why does it work on my forums?!?!?!

I'm still trying to work it out guys. Thanks for all the beta testing. We really need a hack like this. Bear with me - I'm still a n00b.

[x3n0]

Hmm... could this be the culprit?

https://vborg.vbsupport.ru/showthread.php?&threadid=68495

http://www.vbulletin.com/forum/showpost.php?p=697599&postcount=4

[x3n0]

OK, I think I figured it out. Instead of passing an array for the conditional in "gallerybits" I changed it to an INT variable.

In the "gallerybits" template on line 4.

Replace the conditional:

<if condition="$show['thumbnail']">

With:

<if condition="$showthumbs">

I've edited the change into the first post. Hope this works so I can get on with the image editing, uploading, etc functions.

[Reeve of shinra]

I used the updated gallerybits template but its still a no go for me. (I didnt re-upload gallery.php though - did I need to?)

[Reeve of shinra]

Okay, I got it to work (?) by removing this from the gallerybits template. Its a little screwy with first few attachments.

http://www.shinraonline.com/board/gallery.php?&userid=1189&pp=10&showthumbs=0&page=1



<if condition="$showthumbs">
<a href="attachment.php?$session[sessionurl]attachmentid=$post[attachmentid]" target="attachment"><img src="attachment.php?$session[sessionurl]attachmentid=$post[attachmentid]&amp;stc=1&amp;thumb=1" border="0" /></a>
<else />



</if>

[x3n0]

The problem is now you are stuck in thumbnail mode and the "Hide" link on the bottom of the table doesn't work correctly.

[Dennis01]

OK, I think I figured it out. Instead of passing an array for the conditional in "gallerybits" I changed it to a INT variable.

In the "gallerybits" template on line 4.

Replace the conditional:

<if condition="$show['thumbnail']">

With:

<if condition="$showthumbs">

I've edited the change into the first post. Hope this works so I can get on with the image editing, uploading, etc functions.



This did the trick for me, it now works great!!!
http://www.zeewaterforum.org/forums/gallery.php?pp=10&page=2&showthumbs=1&userid=359

Thank you very much x3n0 for putting in all the time and trouble, I think this hack is a great addon and is at least exactly what I was looking for!!!

[x3n0]

Wonderful!

So I assume we can consider this hack as working under 3.0.0 and 3.0.3?

Thanks for bearing with me during my fumblings with the coding of this hack and I also thank those of you who helped and debugged this using your precious forums. I was just tired of waiting 7 months since RC1 came out for a simple free gallery to be made available.

I'm taking a break for tonight. I'm kind of burnt out from staring at code.

Next I'm going to concentrate on a deletion function, a renaming function, custom user folders, and the ability for the owner and admins to remove an attachment without physically deleting the attachment.

[vau7]

I dont have an use for this Hack but you have some beatiful buds over there ;)

[x3n0]

Thank you vau7, some of the best ganja in the world is grown by our members - primarily for medicinal distribution at or near cost. Our way of beating the black market street dealer and keeping sick folks out of illegal situations.

Remember, unlike alcohol, cannabis has never claimed a single life. Cannabis is a natural relaxant, anti-depressant, and appetite stimulant with no side effects. Why is cannabis illegal almost everywhere when drugs like elavil, prozac, oxycontin, and ritalin are messing up people's minds legally?

[Geographic2]

Very nice x3n0.

MyGanjaGrow is looking nice BTW. :) Very good job.

You should check out the talkerbot hack x, I have a feeling Myganjagrower's would find it interesting. :) Overgrow the world @ MGG everybody. ;)

How far do you plan on going with this as far as features?
Will be installing and playing around with this one.

[Reeve of shinra]

Possible bug found, maybe someone else can verify.

If you create a post without a title and attach a pic to it, it wont show up correctly using this file.

[x3n0]

Could you explain in greater detail? I don't quite understand what you mean.

VB won't allow a thread to be started without a title/subject and any reply posts don't require a title - the gallery is designed to show the thread title link in the gallerybits alongside the thumbnail. This method seems to work nicely and is keeping in form with the rest of vBulletin. No post title = 'N/A' in the gallerybits.

[Reeve of shinra]

Odd... okay nevermind. I rebuilt thumbnail attachments and it seemed to fix the problem I was having. Sorry for the false alarm although I dont know why it did that.

[Annunu1]

Step 2: Create a new global phrase named "gallery" with the text "Click to view {1}'s image gallery" or something similar.

Can you explain this more? I don't understand how to do this.

thanks

[x3n0]

Admin Control Panel > Languages & Phrases > Phrase Manager >

Click the "Add New Phrase" button. You will see the following screen. Make sure the Phrase type is set to global. Paste the phrase into the text box as shown in the screenshot. Click save. All Done!

[SVTBlackLight01]

It's working great on 3.0.3 here!

http://www.modernengineuity.com/forums/gallery.php?userid=1

[x3n0]

Great! Glad to hear it's working well.

Don't forget to click "Install" ;)

[kyrnel]

Working great!
One question, though. Is there a way to only make the link show up in the postbit popup menu if the user belongs to a specific group that is allowed to post images?

I mean, I have over 25,000 members and only about 150 are able to post images.
Is there a simple conditional to determine if a user is a member of a specific (or a list) of groups?

Thx

[kyrnel]

Nevermind.. I found it on vbulletin.com.

Here is the code if anyone is interested.
With this, you can make it only display the link if the member belongs to a group with permission to post attachments.

<if condition="is_member_of($post, 44) OR $post[usergroupid] == 26"> link </if>

You can expand this. The first condition checks for secondary usergroup, the second for primary usergroup.

[x3n0]

Darn it, you answered your own question before I could! ;)

[Ber|Art]

Thx! man this works great :)

[khaleel]

Is there a newb version of the instructions ? And is it an actually GALLERY or just an attachment viewer?

[x3n0]

View attachments by specific userid - a user gallery.

I've stopped working on this particular script in favor of a full packaged gallery solution - complete with file transfer and management functions, rename, delete, and templated layouts. I'm also working to circumvent the full size inline MIME view - in favor of a skinnable full size view with styles integrated and editable captions, navigation, and banners. Hopefully I'll have something usable soon. I just need enough spare time to get my misfiring ADHD throttled medulla focused on the task.

[Lord Brar]

:D Just what I was looking for!!!! I will install it in a day or two!

[x3n0]

<a href="http://69.35.153.254/forums/gallery.php?userid=1&showthumbs=1" target="_blank">vBulletin 3.0.3 Gallery</a> A greatly expanded version - Full size images in your CSS, Image Captions, Flash Animations, and much more! Sneak peek, coming soon!

[Lord Brar]

:P So, I should be waiting for it ;) BTW will it be a paid add-on or would you be generous enough to release it free???

[ambrosious]

Where in postbit do I add that bit of code?

[x3n0]

I will not support this hack if it's being used to conceal weapons of mass destruction or for bombing the crade of civilization.

We haven't decided if well be charging for the Gallery Hack or not. We will probably offer several different versions of the hack, a free version without support or installer software and a low priced (about $30 version with additional features, support, and a few different CSS styles thrown in for good measure. That's about all I can say about contract software here so as not to be a rule breaker. Try CalSat.net if you need solutions we can't discuss in a public forum.

[lasto]

lo m8 is there anyway to OMIT certain types of attachements from this.Not everyone uploads pics all the time and when testing it - rars which im using to test show up as red x`s so would like it if rars and zips etc where ommited from the gallery

is this possible ?? would be neat if could

or is their a solution to stop zips and rars from showing up as red x`s

or an even better one - let this just show attachments from certain sections

Lot of or`s aint there :)
but i got loads of red x`s so any help would be helpful

[leeman]

I only get red X's ....

Links and all works but the thuimbs only show red X ... :(

[lasto]

run attachments updater m8 in the admin cp maybe thats it - hacks works fine for me - i get red x`s if people have posted zips or rars in ttheir post so does anyone know how to fix this ?

[ryancooper]

I get the following error???

Database error in vBulletin 3.0.0 Release Candidate 3:

Invalid SQL:
SELECT COUNT(*) AS total,
SUM(filesize) AS sum
FROM attachment AS attachment
LEFT JOIN post AS post ON (post.postid = attachment.postid)
LEFT JOIN thread AS thread ON (post.threadid = thread.threadid)
LEFT JOIN deletionlog AS deletionlog ON(attachment.postid = deletionlog.primaryid AND type = 'post')
WHERE attachment.userid = 2
AND ((forumid IN(0Array,1,101,100,2,3,4,15,16,22,29,23,6,24,30,3 1,32,33,35,34,39,41,40,42,43,4 4,36,37,38,45,46,47,54,55,56,48,49,50,51,52,53,57, 58,59,60,61,62,63,64,65,66,67, 68,69,70,71,72,73,74,75,76,77,78,79,80,85,86,87,81 ,82,83,95,96,97,88,89,90,91,92 ,93,94,5,13,7,8,9,14,21,10,11,98,99) AND thread.visible = 1 AND post.visible = 1 AND deletionlog.primaryid IS NULL) OR attachment.postid = 0)

mysql error: Unknown column '0Array' in 'where clause'

mysql error number: 1054

[x3n0]

I highlighted the error.

I get the following error???

Database error in vBulletin 3.0.0 Release Candidate 3:

Invalid SQL:
SELECT COUNT(*) AS total,
SUM(filesize) AS sum
FROM attachment AS attachment
LEFT JOIN post AS post ON (post.postid = attachment.postid)
LEFT JOIN thread AS thread ON (post.threadid = thread.threadid)
LEFT JOIN deletionlog AS deletionlog ON(attachment.postid = deletionlog.primaryid AND type = 'post')
WHERE attachment.userid = 2
AND ((forumid IN(0Array,1,101,100,2,3,4,15,16,22,29,23,6,24,30,3 1,32,33,35,34,39,41,40,42,43,44,36,37,38,45,46,47, 54,55,56,48,49,50,51,52,53,57,58,59,60,61,62,63,64 ,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,8 5,86,87,81,82,83,95,96,97,88,89,90,91,92,93,94,5,1 3,7,8,9,14,21,10,11,98,99) AND thread.visible = 1 AND post.visible = 1 AND deletionlog.primaryid IS NULL) OR attachment.postid = 0)

mysql error: Unknown column '0Array' in 'where clause'

mysql error number: 1054

[ryancooper]

I highlighted the error.
Thanks. I am just a beginner so can you tell me how to fix it?

[x3n0]

Thank's for catching that! A simple typo. My copy doesn't have it and it's from the same archive. Odd... Must have snuck in there somehow! I've highlighted in this snippet of offending code:


$attachments = $DB_site->query_first("
SELECT COUNT(*) AS total,
SUM(filesize) AS sum
FROM " . TABLE_PREFIX . "attachment AS attachment
LEFT JOIN " . TABLE_PREFIX . "post AS post ON (post.postid = attachment.postid)
LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (post.threadid = thread.threadid)
LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(attachment.postid = deletionlog.primaryid AND type = 'post')
WHERE attachment.userid = $userid
AND ((forumid IN(0$forumids) AND thread.visible = 1 AND post.visible = 1 AND deletionlog.primaryid IS NULL) " . iif($userid==$bbuserinfo['userid'], "OR attachment.postid = 0") . ")
");

[n_i_t_r_o_u_s]

this is a great hack, is it possible to port it to 3.0.6?

here's the error i get when calling it up:

Database error in vBulletin 3.0.6:


Invalid SQL:
SELECT thread.forumid, post.postid, post.threadid AS p_threadid, post.title AS p_title, post.dateline AS p_dateline, attachment.attachmentid,
thread.title AS t_title, attachment.filename, attachment.counter, attachment.filesize AS size, IF(thumbnail = '', 0, 1) AS hasthumbnail,
user.username, thread.open, attachment.userid
FROM wwwtoke_attachment AS attachment
LEFT JOIN wwwtoke_post AS post ON (post.postid = attachment.postid)
LEFT JOIN wwwtoke_thread AS thread ON (post.threadid = thread.threadid)
LEFT JOIN wwwtoke_deletionlog AS deletionlog ON(attachment.postid = deletionlog.primaryid AND type = 'post')
LEFT JOIN wwwtoke_user AS user ON (attachment.userid = user.userid)
WHERE attachment.userid = 1
AND ((forumid IN (,3,4,7,11,9,33,5,6,31,8,12,10,32,30,16,18,17,29,1 ,2,19,20,34,13,14,15,21,22,23,24,25,26,27,28) AND thread.visible = 1 AND post.visible = 1 AND deletionlog.primaryid IS NULL) OR attachment.postid = 0)
ORDER BY attachment.attachmentid DESC
LIMIT 0, 10

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '3,4,7,11,9,33,5,6,31,8,12,10,32,30,16,18,17,29,1, 2,19,20,34,13,

mysql error number: 1064

[gldtn]

This would be nice if you could get it to work like this: http://www.overgrow.com/edge/gallery.php

[Joe Pimms]

this is a great hack, is it possible to port it to 3.0.6?

here's the error i get when calling it up:

Database error in vBulletin 3.0.6:


Invalid SQL:
SELECT thread.forumid, post.postid, post.threadid AS p_threadid, post.title AS p_title, post.dateline AS p_dateline, attachment.attachmentid,
thread.title AS t_title, attachment.filename, attachment.counter, attachment.filesize AS size, IF(thumbnail = '', 0, 1) AS hasthumbnail,
user.username, thread.open, attachment.userid
FROM wwwtoke_attachment AS attachment
LEFT JOIN wwwtoke_post AS post ON (post.postid = attachment.postid)
LEFT JOIN wwwtoke_thread AS thread ON (post.threadid = thread.threadid)
LEFT JOIN wwwtoke_deletionlog AS deletionlog ON(attachment.postid = deletionlog.primaryid AND type = 'post')
LEFT JOIN wwwtoke_user AS user ON (attachment.userid = user.userid)
WHERE attachment.userid = 1
AND ((forumid IN (,3,4,7,11,9,33,5,6,31,8,12,10,32,30,16,18,17,29,1 ,2,19,20,34,13,14,15,21,22,23,24,25,26,27,28) AND thread.visible = 1 AND post.visible = 1 AND deletionlog.primaryid IS NULL) OR attachment.postid = 0)
ORDER BY attachment.attachmentid DESC
LIMIT 0, 10

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '3,4,7,11,9,33,5,6,31,8,12,10,32,30,16,18,17,29,1, 2,19,20,34,13,

mysql error number: 1064
i get the same type of error to here is my error :
Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT thread.forumid, post.postid, post.threadid AS p_threadid, post.title AS p_title, post.dateline AS p_dateline, attachment.attachmentid,
thread.title AS t_title, attachment.filename, attachment.counter, attachment.filesize AS size, IF(thumbnail = '', 0, 1) AS hasthumbnail,
user.username, thread.open, attachment.userid
FROM attachment AS attachment
LEFT JOIN post AS post ON (post.postid = attachment.postid)
LEFT JOIN thread AS thread ON (post.threadid = thread.threadid)
LEFT JOIN deletionlog AS deletionlog ON(attachment.postid = deletionlog.primaryid AND type = 'post')
LEFT JOIN user AS user ON (attachment.userid = user.userid)
WHERE attachment.userid = 1
AND ((forumid IN (,1,2) AND thread.visible = 1 AND post.visible = 1 AND deletionlog.primaryid IS NULL) OR attachment.postid = 0)
ORDER BY attachment.attachmentid DESC
LIMIT 0, 10

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '1,2) AND thread.visible = 1 AND post.visible = 1 AND deletionlo

mysql error number: 1064

[lairnoc]

I tried to implement it in 3.0.7 on http://www.lairnoc.com but i get this error as well
Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT COUNT(*) AS total,
SUM(filesize) AS sum
FROM attachment AS attachment
LEFT JOIN post AS post ON (post.postid = attachment.postid)
LEFT JOIN thread AS thread ON (post.threadid = thread.threadid)
LEFT JOIN deletionlog AS deletionlog ON(attachment.postid = deletionlog.primaryid AND type = 'post')
WHERE attachment.userid = 11
AND ((forumid IN (,1,11,10,17,9,8,21,19,20,13) AND thread.visible = 1 AND post.visible = 1 AND deletionlog.primaryid IS NULL) )

mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1,11,10,17,9,8,21,19,20,13) AND thread.visible = 1 AND post.visi

mysql error number: 1064

Date: Thursday 31st of March 2005 07:41:40 PM
Script: http://www.lairnoc.com/gallery.php?userid=11&pp=10&showthumbs=1
Referer: http://www.lairnoc.com/showthread.php?t=73
Username: lairnoc
IP Address: 83.118.3.72


If anyone could help me fix it i would love it...

[Marco van Herwaarden]

To solve this problem, edit your gallery.php.

Find:
$attachments = $DB_site->query_first("Add before $forumids = substr($forumids, 1);

[lairnoc]

thnx marco

[Allan]

Thanks w3n0 for this hack, very nice ;)

and thanks MarcoH64, work perfectly with 3.0.7 :)

~~~~~~~~~~~~~~~~~~~
Click install ;)
~~~~~~~~~~~~~~~~~~~

[VanAusdal]

I really like the idea of this hack but I have done everything this thread advises but I am still getiint the above mentions sql error. Mine looks like this:

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT COUNT(*) AS total,
SUM(filesize) AS sum
FROM attachment AS attachment
LEFT JOIN post AS post ON (post.postid = attachment.postid)
LEFT JOIN thread AS thread ON (post.threadid = thread.threadid)
LEFT JOIN deletionlog AS deletionlog ON(attachment.postid = deletionlog.primaryid AND type = 'post')
WHERE attachment.userid = 1585
AND ((forumid IN (,9,31,32,29,10,26,28,11,12,13,14,16,17,18,19,20,2 1,22,1,2,3,4,5,7,8,6,15,23,30,24,25) AND thread.visible = 1 AND post.visible = 1 AND deletionlog.primaryid IS NULL) )

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '9,31,32,29,10,26,28,11,12,13,14,16,17,18,19,20,21 ,22,1,2,3,4,5,

mysql error number: 1064

Date: Thursday 05th of May 2005 11:44:13 PM
Script: http://www.creativexpress.com/community/xpressions/gallery.php?userid=1585&pp=10&showthumbs=1
Referer: http://www.creativexpress.com/community/xpressions/showthread.php?threadid=1054
Username: admin
IP Address: 71.36.64.19


Please help!!

[Allan]

I really like the idea of this hack but I have done everything this thread advises but I am still getiint the above mentions sql error. Mine looks like this:

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT COUNT(*) AS total,
SUM(filesize) AS sum
FROM attachment AS attachment
LEFT JOIN post AS post ON (post.postid = attachment.postid)
LEFT JOIN thread AS thread ON (post.threadid = thread.threadid)
LEFT JOIN deletionlog AS deletionlog ON(attachment.postid = deletionlog.primaryid AND type = 'post')
WHERE attachment.userid = 1585
AND ((forumid IN (,9,31,32,29,10,26,28,11,12,13,14,16,17,18,19,20,2 1,22,1,2,3,4,5,7,8,6,15,23,30,24,25) AND thread.visible = 1 AND post.visible = 1 AND deletionlog.primaryid IS NULL) )

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '9,31,32,29,10,26,28,11,12,13,14,16,17,18,19,20,21 ,22,1,2,3,4,5,

mysql error number: 1064

Date: Thursday 05th of May 2005 11:44:13 PM
Script: http://www.creativexpress.com/community/xpressions/gallery.php?userid=1585&pp=10&showthumbs=1
Referer: http://www.creativexpress.com/community/xpressions/showthread.php?threadid=1054
Username: admin
IP Address: 71.36.64.19


Please help!!


https://vborg.vbsupport.ru/showpost.php?p=633928&postcount=76 , no ?

[Marco van Herwaarden]

If you do like i recommended, it is impossible you still get this error.

[VanAusdal]

I did as you recomended but maybe I am doing it wrong here is what my code looks like:

$forumids = substr($forumids, 1);
$attachments = $DB_site->query_first("
SELECT COUNT(*) AS total,
SUM(filesize) AS sum
FROM " . TABLE_PREFIX . "attachment AS attachment
LEFT JOIN " . TABLE_PREFIX . "post AS post ON (post.postid = attachment.postid)
LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (post.threadid = thread.threadid)
LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(attachment.postid = deletionlog.primaryid AND type = 'post')
WHERE attachment.userid = $userid
AND ((forumid IN ($forumids) AND thread.visible = 1 AND post.visible = 1 AND deletionlog.primaryid IS NULL) " . iif($userid==$bbuserinfo['userid'], "OR attachment.postid = 0") . ")
");

Am I supposed to replace the line of:
$forumids .= ",$forumid";

with:
$forumids = substr($forumids, 1);

I am not really sure where I am supposed to add this line or if it is supposed to replace another line. I have tried it both ways and still get the error.

[VanAusdal]

Thank you for your help it appears to be working now. I dont know what was up sorry to have bothered you!

Cam