I am currently attempting to modify the following hack:

http://www.vbulletin.org/forum/showthread.php?t=98651

Basically this hack shows the first attachment of the first post of the thread on the forumdisplay page. This would be great because I have a PROJECTS area that I would like to be able to show the LATEST PROGESS on the forumdisplay page.

I'm currently trying to modify this hack to show the LAST ATACHMENT, from the LATEST POST of the THREAD STARTER. Ignoring all other attachments posted by other users to the thread.

The XML file reads like this: (orginal) -

if you change the MIN to a MAX is simply shows the LAST POST from the very first post of the thread.. not exactly what I'm looking for.

Would any VB Guru be willing to give me alittle guideance?

Aceman

what do you want to do then? Show the latest attachment submitted by the thread starter on the thread bit?

I want to show the last attachment made to the thread by the thread starter on the forumdisplay page. Ignoring any attachment made by other users. This hack in it's native format shows the FIRST attachment to the thread. And it works great.. I just want to modify that.

And I can't figure out how to modify the xml to show the correct thumbnail of the last attachment posted to teh thread my the thread's starter.

Aceman

ah so by attachment do you mean thumbnail not file.

this could work:

Database error when you change first to last in the line you changed of that code.

$hook_query_joins .= "LEFT JOIN " . TABLE_PREFIX . "attachment as attachment ON(attachment.postid = thread.firstpostid) "

$hook_query_joins .= "LEFT JOIN " . TABLE_PREFIX . "attachment as attachment ON(attachment.postid = thread.lastpostid) " <-- Database Error when you use this.

http://www.scifi-meshes.com/forums/forumdisplay.php?f=9 <--- shows the working UNMODIFIED version of this hack which merely shows the first attached image on the forumdisplay.

Where are my uber coders out there?!

Was Boofo helping you with this earlier? lol Sounds awfully familiar...

Anyway, this is what I told him:

Because there is no way to tell the threadID in the attachment table, you could either go the path of extreme inefficiency, store the threadid in the attachment table, or store the last attachmentID that you want in the thread table. After you do any of these last two options, it should make things much simpler.

The cheap-o solution I offered him earlier (which you didn't like) was to simply change the MIN to a MAX, but that limits the attachments to the first postid.

I can't offer much more help at this point, too busy. I should have some time this weekend if you are still stumped.

--

edit: after actually reading the other post in the thread... add a lastpostid field to the database. Have it update whenever it updates the last poster. The only downside of this way is if the last post has no attachment it won't work.

__________________


vBlogetin: an advanced blogging tool for vBulletin
>> Beta 3 released with SE-Friendly URLs!

The lastpostid has already been added in vB 3.6.0.. just a little fyi.