Getting the last post of a specific topic

[Jorim]

:up: Yeah, it works :banana:

Thanks guys

[edit] (interesting option this...)

++++, it isn't working at all I looked at the wrong page, very stupid...

$news stays empty

[Marco van Herwaarden]

Lol, sorry but that query is totally wrong.
thread.lastpost is a timestamp, not a postid.

Use the following, this should work (if 7348 is an existing threadid):

PHP Code:

$getnews = $DB_site->query_first(" 
        SELECT * 
        FROM " . TABLE_PREFIX . "post AS post 
        WHERE post.threadid=7348
        AND post.visible = 1
        ORDER BY post.dateline DESC
        LIMIT 1");  
print_r($getnews); 


[Jorim]

That's not funny but everything works now. Thank you very very mutch!

I've got one final question and then I'l shut up I'd like te have the attachement aswel.

Will this work:

PHP Code:

$news = $DB_site->query_first("  
        SELECT pagetext, attach 
        FROM " . TABLE_PREFIX . "post AS post  
        WHERE post.threadid=884 
        AND post.visible = 1 
        ORDER BY post.dateline DESC 
        LIMIT 1"); 


Or do I have to use extra query's for that ??

[Marco van Herwaarden]

No, that will not work.

'attach' will not contain the attachment data. How to retrieve the attachment data depends on how your attachments are stored (database/filesystem), but is much more complicated then just a query.

[Jorim]

I thought so. Is it possible to get the attachement of that specific post and can you help me?

Thanks again

[Marco van Herwaarden]

Previous reply updated.

[Jorim]

Originally Posted by MarcoH64

Previous reply updated.

I'm using the normal settings of vBulletin I guess that's with the database. I've got a few table's with attachement information...

This query works, but the part to display the image that's attached (that's what I want) won't. What do I wrong??? :ermm:

PHP Code:

$news = $DB_site->query_first("  
        SELECT post.pagetext, post.postid
        FROM " . TABLE_PREFIX . "post AS post
        WHERE post.threadid=884
        ORDER BY post.dateline DESC
        LIMIT 1");

$attach = $DB_site->query_first("  
        SELECT attachment.filename, attachment.filesize, attachment.visible, attachmentid, counter 
        FROM " . TABLE_PREFIX . "attachment AS attachment
        WHERE attachment.postid = {$news['postid']}");
        
//$attachment['attachmentextension'] = file_extension($attach['filename']);
//$attachment['filename'] = $attach['filename'];
//$attachment['attachmentid'] = $attach['attachmentid'];
//$attachment['filesize'] = vb_number_format($attach['filesize'], 1, true);
//$attachment['counter'] = $attach['counter'];
//eval('$attachment = "' . fetch_template('postbit_attachment') . '";');
//$attachment = str_replace('"attachment.php', '"' . $vboptions['bburl'] . '/attachment.php', $attachment);
$attachment = '<a href="' . $vboptions['bburl'] . '/attachment.php?' . $session['sessionurl'] . 'attachmentid=' . $attach['attachmentid'] . '" target="_blank"><img border="0" src="' . $vboptions['bburl'] . '/attachment.php?' . $session['sessionurl'] . 'attachmentid=' . $attach['attachmentid'] . '&amp;stc=1&amp;thumb=1" /></a>'; 


Fixed it

Thanks everybody for your help! :up:

PHP Code:

$news = $DB_site->query_first("  
        SELECT post.pagetext, post.postid
        FROM " . TABLE_PREFIX . "post AS post
        WHERE post.threadid=884
        ORDER BY post.dateline DESC
        LIMIT 1");

$attach = $DB_site->query_first("  
        SELECT attachment.filename, attachment.filesize, attachment.visible, attachmentid, counter 
        FROM " . TABLE_PREFIX . "attachment AS attachment
        WHERE attachment.postid = {$news['postid']}");
        
$attachment['attachmentextension'] = file_extension($attach['filename']);
$attachment['filename'] = $attach['filename'];
$attachment['attachmentid'] = $attach['attachmentid'];
$attachment['filesize'] = vb_number_format($attach['filesize'], 1, true);
$attachment['counter'] = $attach['counter'];
eval('$attachment = "' . fetch_template('postbit_attachmentimage') . '";');
$attachment = str_replace('"attachment.php', '"' . $vboptions['bburl'] . '/attachment.php', $attachment);