displaying attachments?

[Beowolf]

I am building a script which pulls posts from X forum and displays them, etc.. That all works fine, but I need to know how to display attachments - specifically, how do decode them or whatever. I know how to check to see if the post has any attachments associated with it, and pull those rows from the attachments table, but the filename / path / hash stuff are encrypted or something. Any help? Thanks!

[Borgs8472]

You could start by installing the [ attachment ] id [ / attachment ] BB code for starters

[Beowolf]

Hmm I can't find that BB Code here...

I foudn this:

PHP Code:

// check for attachments
if ($post['attach'])
{
    $attachments = $DB_site->query("
        SELECT filename, filesize, visible, attachmentid, counter, postid, IF(thumbnail_filesize > 0, 1, 0) AS hasthumbnail, thumbnail_filesize
        FROM " . TABLE_PREFIX . "attachment
        WHERE postid = $postid
        ORDER BY dateline
    ");
    while ($attachment = $DB_site->fetch_array($attachments))
    {
        $post['attachments']["$attachment[attachmentid]"] = $attachment;
    }
} 

But I don't know what to do next.