show all attachments from selected user

[ageurtse]

This mod shows all attachments submited by the selected user.


history
- v1.20 some fixes for vb 4.0.2, and tab position selection
- v1.10 Some small leftovers changed
- v1.10 RC2 added usergroup permision
- v1.10 RC1 added lightbox

Todo in next version
- information displaying when hovering over picture
- information displaying when showen in lightbox

Wish list
- add permisions <- not realy a need for me (maybe a will add this later)
- add selection box for admins to delete a attachment <- this can be done in backend.


installation,

see readme file inside the zip file.

[ageurtse]

reserved by author

[Forum Lover]

Will it be possible to put a select option so that admins can delete those if they want to? Tagged.

[ageurtse]

that is not planned, now at this moment i'm working on the upgrade of our board.
if that is done and it run's smooth'i will whatch into it.

[hakan68]

Thanks installed

[mandingo]

Some problems:

http://internetdomainnamedotcom.com/image/images/46bekijk.jpg (http://internetdomainnamedotcom.com/image/view.php?filename=46bekijk.jpg)

Then I clicked it and got an error.

Database error in vBulletin 4.0.1:

Invalid SQL:

SELECT attachment.attachmentid, attachment.contentid, attachment.userid, post.postid, post.threadid, post.visible,thread.forumid,
thread.title, thread.open
FROM vb3_attachment as attachment
LEFT JOIN vb3_post AS post ON (post.postid = attachment.contentid)
LEFT JOIN vb3_thread as thread on(post.threadid = thread.threadid)
LEFT JOIN vb3_deletionlog AS deletionlog ON(attachment.contentid = deletionlog.primaryid AND type = 'post')
WHERE attachment.userid = 1
AND (
thread.forumid IN(0,47,26,43,17,22,45,23,1,28,31,36,35,2,37,25,4, 8,13,15,20,27,39,5,33,11,24,3,6,14,29,12,34,7,18)
AND thread.visible = 1
AND post.visible = 1
AND deletionlog.primaryid IS NULL);

MySQL Error : Table 'xxxxxxx.vb3_attachment' doesn't exist
Error Number : 1146
Request Date : Saturday, January 16th 2010 @ 10:52:16 AM
Error Date : Saturday, January 16th 2010 @ 10:52:16 AM
Script : http://xxxxxxxxxxxxxxxxxx?1=&tab=AJGattach
Referrer : http://xxxxxxxxxxxxxxxxxxxxxxxxxx
IP Address : xxx.xxxx.xxxx
Username : Mitch
Classname : vB_Database
MySQL Version : 5.1.30

[ageurtse]

i found what is wrong, i'm going to work on a fix.

for now you can alter in the plugin AJGattach member profile tab the prefix before the table names.
this is in my case vb3_ you can alter this by hand as a work a round.

when i finished it i will reupload the new file.

above problem is solved

[mandingo]

:( tried update,still error and language still Dutch
Database error in vBulletin 4.0.1:

Invalid SQL:

SELECT attachment.attachmentid, attachment.contentid, attachment.userid, post.postid, post.threadid, post.visible,thread.forumid,
thread.title, thread.open
FROM vb3_attachment as attachment
LEFT JOIN vb3_post AS post ON (post.postid = attachment.contentid)
LEFT JOIN vb3_thread as thread on(post.threadid = thread.threadid)
LEFT JOIN vb3_deletionlog AS deletionlog ON(attachment.contentid = deletionlog.primaryid AND type = 'post')
WHERE attachment.userid = 125
AND (
thread.forumid IN(0,47,26,43,17,22,45,23,1,28,31,36,35,2,37,25,4, 8,13,15,20,27,39,5,33,11,24,3,6,14,29,12,34,7,18)
AND thread.visible = 1
AND post.visible = 1
AND deletionlog.primaryid IS NULL);

MySQL Error : Table 'xxxxxxxxxxx.vb3_attachment' doesn't exist
Error Number : 1146
Request Date : Saturday, January 16th 2010 @ 12:01:03 PM
Error Date : Saturday, January 16th 2010 @ 12:01:03 PM
Script : http://xxxxxxxxxxxxxxxxxxxxxxxxxx?125=&tab=AJGattach
Referrer : http://xxxxxxxxxxxxxxxxxxx/3835-Best-of-Pride-Episode-1-List-of-Fights-Shown
IP Address : xx.xxxx.xxxx.xxx.x.x.x.x
Username : Mitch
Classname : vB_Database
MySQL Version : 5.1.30

[ageurtse]

sorry, i did uploadt the wrong file

[mandingo]

Hi,it's me again.
It works!!

but:
click for screenshot (http://internetdomainnamedotcom.com/image/images/65big.jpg)

Not sure if this is a me thing or a you thing.
Sorry if i'm being a pain. :(

[ageurtse]

looks like a me thing, looks like a scaling problem.

i see that this user has dual attachments, is this right ?

[mandingo]

looks like a me thing, looks like a scaling problem.

i see that this user has dual attachments, is this right ?

Not sure what you mean.
One pic did get uploaded twice. but one of them is all blown up (as you can see)

[Sador]

Seems nice, I'm gonna try this out once it's a bit more stable. :)

[ageurtse]

@sador, oke now problem

@mandingo, yes i see, i'm already working on it.

[Zaiaku]

This needs permission since I wouldn't want everyone to be able to use this.

[ageurtse]

I write it on the wish list. At this moment i discoverd a bug. I'm trying to solve it.

[mandingo]

Looking way better,only thing now thumbnails are squished.

[ageurtse]

what do you mean by squished ? maybe a screen shot ?

[Hornstar]

This has lots of potential, just waiting for those couple of requested features and bug fixes. Tagged for when I upgrade to VB4 tho.

[mandingo]

what do you mean by squished ? maybe a screen shot ?

http://internetdomainnamedotcom.com/image/images/71squish.gif (http://internetdomainnamedotcom.com/image/view.php?filename=71squish.gif)

[ageurtse]

can you figure out what the dimensions are from that image. or maybe you could send it to me.
then i upload it again and see what is does on my board.

you have pm

[Verionia]

Yes, permissions would be nice... for admin eyes only.

[ageurtse]

i'm working on the problem mandigo point me to.
this could thake a bit of time, so keep watching this thread for the solution.

[angeljs]

This has fantastic potential, and I really need something like this. However, the thumbnails are distorted, which I assume has something to do with the sizing configuration...I can't find the template where I would change that.

This also seems to miss out certain thumbnails...I assume that's because there's also an attachment which isn't the first image in the post and the mod is trying to call that instead? (See attached image.)

Also, it would be great if when clicked the link opens in the same window and takes you to the actual post where the attachment is held rather than just the image.

I really would love to see this in it's finished form! :)

[ageurtse]

Is it possible that the white space's are not realy image's but some other kind of attachment ?

the resizing is don in a plugin. it's not realy resizing i just altered the width and height of the thumb.

i will look into it, that when the attachment is not an image it should not be displayed.

[ageurtse]

update information, i'm working on a rewrite since there are several problem's. it is now at 70% completet.

so you will have to wait a while before i release this new i hope better version.

[mandingo]

Good on ya ageurtse. :)

[sematopdemir]

Thanks

[ageurtse]

work is still in progress, stil a few thing a hope to release the beta in the next 48 hours, if my wife let me work on it :)

[ageurtse]

preview update, so you people can give me input on what is wrong and what not.

[Forum Lover]

- add selection box for admins to delete a attachment <- this can be done in backend.

How?

[ageurtse]

cp->attachment search attachment or user or whatever and then select attachment to delete.

i think this option won't be in this mod. or someone else would give me some info on how to delete a attachment.

[ageurtse]

Final update, if it is right it all works now. I hope to hear

[mandingo]

Final update, if it is right it all works now. I hope to hear

Looked great on my profile as I have attachments,but when a user has no attachments their profile page has
vBulletin Message

There are no attachments to display




and that's it. when I disabled it it showed their normal profile

[ageurtse]

i solved it here, now i'm at my work and i can't upload.
When i'm at home tonight i will update this mod. and maybee tonight i will add lightbox.

[Moondust]

Nice - it work - it´s verry good.

I need the same as "latest xx postet Pictures" in a blank Site :-)

[Moondust]

Looked great on my profile as I have attachments,but when a user has no attachments their profile page has


and that's it. when I disabled it it showed their normal profile



You have modify this Problem now ?

When you click a Username and this User has no Attachments.... you can not see the Profil.

[Moondust]

sorry, i have not see that you update yesterday.

But now... 2 other Problems. The Pictures not more on rows side by side and all Pictures no Thumbs !

[molieman]

installation,

unzip the file, and upload the files in the upload directory.
next install the plugin and your ready to go.

When you say "upload the files in the upload directory."

Where? In the root, forums directory, or where?

[Moondust]

When you say "upload the files in the upload directory."

Where? In the root, forums directory, or where?

You must not Upload this per FTP ......


....... go in your Adminpanel and upload/install.... thats all.

[molieman]

You must not Upload this per FTP ......


....... go in your Adminpanel and upload/install.... thats all.

I'm talking about the "upload" directory included in the zip file.

[mandingo]

i solved it here, now i'm at my work and i can't upload.
When i'm at home tonight i will update this mod. and maybee tonight i will add lightbox.

Let me know.:)

[Moondust]

I'm talking about the "upload" directory included in the zip file.

oh sorry.... i have this not uploaded but the Addon is working ??? Good :-)

[molieman]

Moondust, thank you. Great product btw.

Seems the last update is causing the pics to double it's size, going full width of the graphic block area (about 800X800 pix or more).

[ageurtse]

The adon is for lightbox support and the resource dir should be installed in your forums dir.

Let me hear if there are more problems

[ageurtse]

next time i send out an update message.

[molieman]

Lytebox is installed in the correct directory. Works fine everywhere else.

[Moondust]

Lytebox is installed in the correct directory. Works fine everywhere else.

sorry, what is Lytebox ? a another Plugin/Addon ?


Please repair the Filesize :-)

[molieman]

I thought your were talking about Lytebox and just misspelled it... LOL.

Light box is a product, listed here. It's product-bbr_imageresize_withblog.xml
https://vborg.vbsupport.ru/showthread.php?t=230411&highlight=lightbox

I can't find "Lightbox" and like I said, Lytebox works fine with all my other images and it seemed to have been working prior to this last update.

I would go back to the old version, except, it's deleted :(

[ageurtse]

no it's not that litebox, it's lightbox i added it by myself.
the files that has to be added are in the resource dir, just upload this dir to your forum root and that's all.

[ageurtse]

@moondust what do you mean by repear the filesize.

i'm thinking of adding file information when hovering over the thumbnail, in this fileinfo could be filesize.

[molieman]

When you say "upload the files in the upload directory."

Where? In the root, forums directory, or where?

I admire and appreciate your contribution in bringing forth this wonderful product, I love it and am grateful for it. I apologize for being a pain in the behind, but.......

That brings us back to the original question :)

Where do I upload the resource directory????

Currently I can not find a directory named "resource."

I did put it in the forum root and nothing happened.

[Moondust]

See the Attach.

1 Picture soo big, the other Pictures small.

i add in "ajgattach_showattachmentbit" width="160" height="160" />, this is better and i must not deaktivate this Product.

And the Pics not in a Row.... all 1 by 1 Down.

Sorry for my bad english.

[ageurtse]

which version of ie & windows do you have.

on my work ie8 goes right.

[molieman]

See the Attach.

1 Picture soo big, the other Pictures small.

i add in "ajgattach_showattachmentbit" width="160" height="160" />, this is better and i must not deaktivate this Product.


And the Pics not in a Row.... all 1 by 1 Down.

Sorry for my bad english.


Thank you :) :) :)

That will work for now. I hope a fix is on it's way :) :) :)

[molieman]

which version of ie & windows do you have.

on my work ie8 goes right.

I just tried it with IE8 and got the large pics :(

http://www.mycockpit.org/forums/member.php?6024-docmeister&tab=AJGattach

[ageurtse]

I will try to upload tomorow my version because there are no problems on my test board. So be patient and nowbody is a pain in the .....

[molieman]

I will try to upload tomorow my version because there are no problems on my test board. So be patient and nowbody is a pain in the .....

You're much to kind.... because I am.... well, that's what my wife tells me. :) :) :)

Thank you.

[mandingo]

I am getting the huge pictures too,had to deactivate for now.
also lightbox(or whatever) if it was there it wasnt working.
/public_html/forum/resource
everything in it's right place.

[ageurtse]

could you tell me what you have in admincp->style&templates->stylemanager->masterstyle click <<>>
double click css template
double click AJGattach.css

it looks like it's using the wrong css file.

[edit]
i think you guys don't have this template, i forget to include it in the product. if you wish to do it direct you have to include the template AJGattach in this template put the following code

#wrapper {
border:1px solid #bbb;
padding:5px;
margin-left:10px;
margin-top:10px;
float: left;
}
#image {
height:{vb:raw vboptions.AJGattach_columwidth}px;
width :{vb:raw vboptions.AJGattach_columwidth}px;
border:1px solid #bbb;
text-align: center
}

#filename {
height:17px;
width: {vb:raw vboptions.AJGattach_columwidth}px;
white-space:nowrap;
text-overflow:ellipsis;
overflow:hidden;
font-size: 7pt;
}
#description {
height:17px;
width: {vb:raw vboptions.AJGattach_columwidth}px;
white-space:nowrap;
text-overflow:ellipsis;
overflow:hidden;
font-size: 7pt;
}


#row {
clear:left;
}

tonight i will update this product, i'm verry sorry for being so stupid not including this template.

[Moondust]

i will wait of you Update... i have add the Template and all the same as bevor.

And i found no CSS

[Moondust]

oh, sorry - my Mistake not an Template.... a .css :-)

Now... it works !

[webspider]

Permissions don't appear to work.

[ageurtse]

@webspider, that is somthing i now. i hope i can work on it tonight and fix the problem.

i know what is wrong, but i have to figure out how to fix it :)

so be patient, than the permisions should work, you should then have to enter the usergroups that don't have permisions to this page.

[webspider]

Cool, thanks.

[mandingo]

Added the css and works great. just no lightbox or whatever. Looking really good.

[ageurtse]

a small update which will be released with the next update

find in the plugin manager AJGattach member profile tab and go edit it.

now search for if ($width>$height) and change it in if ($width>=$height)

now when you have square thumbnails they also will be scaled to fit the box.

[Moondust]

i see a other Problem is not fixed, User with no Attachments....

You klick on the Username and you come not to the Profil.... only print "No Attachments from this User"

[Moondust]

Thanks for this Update !

[angeljs]

This seems to be working nicely now. :)

Sorry to be a pain, but is there a way to link to the attachment post or do the attachments only link to the actual image file?

[ageurtse]

i thought it was linking to the actual post/album/group

i will look into it.

it is there, look below the attachment there you should find a link to the original post

[Forum Lover]

add selection box for admins to delete a attachment.

Still waiting for this, mate. :)

[Sador]

Nice mod, thanks.

[ndut]

error on profile display...

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/member.php(489) : eval()'d code on line 15

help me.. what to do, ??

[ageurtse]

this is the whole error message ?

i don't know what is happening!

[Leica.Robbiani]

Hi there,

error on profile display...



help me.. what to do, ??
Same for me please. It only seemes to happen when an Admin Profile is watched, also the tabs look strange in Internet Explorer.

L.R.

[Riccardo83]

I get this

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/member.php(489) : eval()'d code on line 23

when going to someones profil.

[Verionia]

When I want to go to page 2, 3, etc... this error comes up:
"This user has not registered and therefore does not have a profile to view"

[RTMdotORG]

anyway to get this for vb3.8??

[ageurtse]

currently i'm busy with other things, if someone would adopte this mod feel free te send me a message and you may alter te code freely

[yilmaz]

When I want to go to page 2, 3, etc... this error comes up:
"This user has not registered and therefore does not have a profile to view"

currently i'm busy with other things, if someone would adopte this mod feel free te send me a message and you may alter te code freely

Hello
Page and Lightbox bug fixes


I offer you the Turkish language file

DEMO (http://www.vbulletin-turko.com/1/yilmaz.html?tab=AJGattach&page=2#AJGattach)

[ka81]

4.1.8
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/member.php(515) : eval()'d code on line 15
:(

[angeljs]

Is there any way to show just the attachment images, and have those images linking to the actual thread?

[Front Range 4x4]

Nice, installed! Thank you!

[M.C.]

for some reason tab not showing in my new 4.2.1 template but OK in old 4.2 template.... any sugesstions?

fixed: was template issue... not mod