Recent Attachments

[MindTrix]

Hack Author: MindTrix
Email: slimshadyandd12@hotmail.com


Description:

Simply adds a box to your forumhome page displaying the 5 most recent attachments and linking to them.

Credits:

Thanks go to assassingod for his incredible help and patients with me. He truely deserves his Mod spot so i would like to say thank you, And sorry for beeing such a pain. And thank you to Boofo who moaned at me for beeing a slacker and giving up easily :p Cheers Mate!!

Screenshot and installation text file attached. (Sorry for the poor HTML i am useless with the stuff)

(15/2/04 Update -- If you have Kentaurus brilliant Attachments In Private Messages hack installed you need to do this fix he posted here

https://vborg.vbsupport.ru/showpost.php?p=476245&postcount=113

To stop PM attachments showing on forumhome.

[colicab-d]

be amazing if this showed thumbs of the pics :p with an icon for other files :D

[MindTrix]

Yeah i thought the same to be honest. Guess thats something to aim too get done :)

[Princeton]

You can use the attachment id to fetch a thumbnail of file (for images) ... use and if statement to display thumbs (look into functions_showthread to add more functionality to your hack)

however, you will also have to think about permissions...

[MindTrix]

Thanks for the advice ill get right on it

[MindTrix]

First post updated. Attachments now show up as thumbnails. Hope that is better :p

[NuclioN]

Great addon. :) Is it possible to stretch the thumbnails in a horizontal block so you can put it under or above the navbar as in the photoposthack where the latest images are displayed in a similar way?

[*arie]

wow thanks.

LOL @ the latest pics in the attachment. :rolleyes:

[NuclioN]

Horizontal display:

recent_attachments:

<a href="attachment.php?attachmentid=$recentattachment[attachmentid]" target="_blank">
<img src="attachment.php?attachmentid=$recentattachment[attachmentid]" alt="$recentattachment[filename]" width="62" height="62" border="0"></a> <img src="./spacer.gif" height="0" width="90" border="0">

Under $navbar:


<table class="tcat" cellpadding="0" cellspacing="0" border="0" width="100%" align="center" valign="top">
<tr><td>
$latestattachments
</td></tr></table>

well..this is not 100% proper code but it looks ok on our forum. Untill it is better coded this is an option. :) You can upload a transparant spacer gif to the right dir. and force the space between the thumbnails in the desired width. Keep also in mind that altough it is a thumb the images have the full kb load on the forumhome.

[colicab-d]

hey thnx dark blue thats handy ;) cause we run a small arts community so this hack is a god send :D

*wonders if an external version showing the last attachment on vbindex etc would be poss :D

[MindTrix]

Thanks for that Nuclion!!

Colicab-d, what version of vbindex?

[gmarik]

Please, make a 2 and 3 and 4 row mode, so it would be more comact - will you?
Thanks, man - you're only 18, but what you code is really fine.

[colicab-d]

latest version mindtrix mate :D

also i know this a bi to ask but.... would it be also possible to show say the latest x attachments, but with only from x forum id :p (if u can accomplish it by mysql ur a god)

[memobug]

Is it possible to illustrate what this hack does using photographs of people with their clothes on not having sex?

[assassingod]

MindTrix, could you please upload a non-pornographic attachment please - thanks.

[MindTrix]

My bad :p Didnt realise to be honest, New screenshot uploaded (and they was not pornographic pictures if you saw them in full size)

[Oblivion Knight]

Just noticed by visiting your forum that the attachment thumbnails are broken. Is this because I'm a guest? If so, is this default behaviour of the mod?

If it is, instead of displaying the latest attachments box, you may well just want to hide them from guests all together.. Lots of red x's don't exactly attract guests to registering. Just a suggestion.!

[MindTrix]

Sorry i didnt think of that, or try it, Try this

replace the code in the php file with


if ($bbuserinfo['usergroupid']!= 0) {
//Start recent attachments by Trix
$trix = $DB_site->query("SELECT attachmentid, dateline, filename FROM attachment WHERE dateline < " . TIME() ." ORDER BY dateline DESC LIMIT 5");

while ($recentattachment = $DB_site->fetch_array($trix))
{
eval('$latestattachments .= "' . fetch_template('recent_attachments') . '";');
}
//End recent attachments by Trix
}



Its just a rough guess but i assume it will work

[Boofo]

Or you could use:

if ($bbuserinfo['userid'])

[MindTrix]

In the php file?

[Boofo]

In place of this in your code above. ;)

if ($bbuserinfo['usergroupid']!= 0)

[MindTrix]

I thought you would need to check it against 0

[assassingod]

If you use

if ($bbuserinfo['userid'])


It still checks for 0 which is unregistered users. (I think anyway)

So that won't work.

[MindTrix]

Ahh right, thanks for that

[Boofo]

Steve, you're wrong. What that basically does is ask whether the user has a userid number. Unregsitered users don't. So, yes, it will work. ;)

[assassingod]

I'll admit when i'm wrong (And I was):p

I'll know next time hehe

[Boofo]

That's ok, buddy. You're not alone. ;)

[MindTrix]

Heck i dont even know what php is

[Erwin]

What would make this hack very useful is if you could make it so that it shows the latest attachments WITHIN a specific forum or subforums. :)

[MindTrix]

Guess thats what i need to aim for now then huh :) Thanks for the advice Erwin ill try

[Allan]

Very Nice , thank MindTrix :)

but, would this be possible to add has this hack the option " contract" (collapse) like origin in Vbulletin ?

[Geographic2]

Your making us download fullsize pictures for 62x62 or 50x50 display... so in other words on my forum it's sending 1mb photos for display in a format that could do it in 8000 bytes...

Here's the easy easy easy fix:

In recent_attachments template:

Change this:

<img src='attachment.php?attachmentid=$recentattachment[attachmentid]' alt='$recentattachment[filename]' width="50" height="50">


to:

<img src='attachment.php?attachmentid=$recentattachment[attachmentid]&thumb=1' alt='$recentattachment[filename]' width="50" height="50">


Much more efficient. Now you download the thumbnail size photo rather than the fullsize version to be resized in the users browser.

Also consider using only 1 width or height value rather than both
this will allow the ratio between height and width to be maintained
since not all images are perfectly square.

Nice hack.

Clickin install. ;)

[MindTrix]

Thanks mate :) HTML is not my strong point, i hate it. Thank you for the fix and install click :)

[Geographic2]

I agree HTML is stupid. :)

[mhobelsb]

Hello,

great Idea with the attachments...
Would it be possible to show tumbs of attachments in the Forumdisplay? I mean instead of a thread icon show a thumbnail of the attachment inside. So the user can see what is waiting for him inside the post. *G*

would really love that.

thanks

Martin

[NuclioN]

What would make this hack very useful is if you could make it so that it shows the latest attachments WITHIN a specific forum or subforums. :)

Or the latest attachments on forumhome OUT of a specific subforum

[NuclioN]

Is it possible to show a 'no thumbnail' image or a default image when someone post a zip, exe etc. file? I've seen it in the forumdisplay attachment addon so maybe it is possible with this to.

[VanAusdal]

Is there any way to get the href to point to the originating thread rather than the image. I would like my users to be able to go to the thread by clicking the image.

Thanks! Great hack by the way!

[VanAusdal]

anybody know a way that this could be done? I have tried everything that I can think of. I have tried a number of things but it seems to pull the most recent thread and the the thread that is associated with the image. I can't seem to wrap my head around this.

[NuclioN]

Yep, i'm also looking for a solution to link the image to the thread it whas placed in. :)

[Marco van Herwaarden]

showthread.php?t=$recentattachment[threadid]'or something like that probably.

[NuclioN]

No that's not it. :) Attachments are showing up but links to nowhere

[darkon]

I worked on the problem to build a link to the posting/thread including the attachment.

I still have to figure out where in the database the "Postcount"-number is stored.. until then i have built a workaround.

In index.php you have to replace the code from the original-hack with this:

//Start recent attachments by Trix
$trix = $DB_site->query("SELECT attachmentid, a.dateline, filename, a.postid, threadid FROM " . TABLE_PREFIX . "attachment a JOIN ".TABLE_PREFIX."post b ON a.postid=b.postid WHERE a.dateline < " . TIME() ." ORDER BY a.dateline DESC LIMIT 3");

And in the recent_attachments template:

<tr>
<td class="alt2">

<div align="center"><a href="attachment.php?attachmentid=$recentattachment[attachmentid]">
<img src='attachment.php?attachmentid=$recentattachment[attachmentid]&thumb=1' alt='$recentattachment[filename]' width="70">
</a></div>
<br> Attachment number $recentattachment[attachmentid]<br/>
<a href="showthread.php?t=$recentattachment[threadid]">In this thread</a><br/>
<a href="showpost.php?p=$recentattachment[postid]">In this posting</a><br/>
</td>
</tr>

(i have included the block into a sidebar on the forumhome)

Take a look at http://www.infam.net/forum/index.php


Hopefully someone could help me to figure out how to get the postcount...

[VanAusdal]

Great!! Thank you for taking the time to work this out!!!!!

[Borimikan]

is there possibility to change the background color of the recent atachment box?

and there is a fix to be able to use this hack in Firefox and IE with no displaying errors?

Thanks advanced!

[Borimikan]

there is some posibility to change the background color of the recents attachments box? or maybe the letters colors!!

[Gutspiller]

How would I get the latest attachments to appear on a non-vb page though?