[Mornagest]

Hello Mark, and thank you

I tried this but it still didn't work. Here's the error message :

Database error in vBulletin 4.2.2:

Invalid SQL:

    SELECT vb_attachment.*, vb_user.*, vb_post.postid, vb_post.threadid, vb_thread.title, vb_filedata.filesize
    FROM vb_vb_attachment
    INNER JOIN vb_vb_user
    ON vb_user.userid = vb_attachment.userid
    INNER JOIN vb_vb_post
    ON vb_post.postid = vb_attachment.contentid
    INNER JOIN vb_vb_thread
    ON vb_thread.threadid = vb_post.threadid
    INNER JOIN vb_vb_filedata
    ON vb_filedata.filedataid = vb_attachment.filedataid
    ORDER BY vb_attachment.dateline DESC
    LIMIT 5;

MySQL Error   : Table 'myforum.vb_vb_attachment' doesn't exist
Error Number  : 1146
Request Date  : Tuesday, December 22nd 2015 @ 08:22:03 PM
Error Date    : Tuesday, December 22nd 2015 @ 08:22:03 PM
Script        : http://www.myforum.fr/forum.php
Referrer      : http://www.myforum.fr/
IP Address    : 80.67.176.207
Username      : Mornagest
Classname     : vB_Database
MySQL Version : 5.5.46-0ubuntu0.12.04.2

So I tried by adding the vb_ prefix only for the rows (I guess "vb_attachment.*, vb_user.*, vb_post.postid, vb_post.threadid, vb_thread.title, vb_filedata.filesize" are rows in tables ?) and NOT for the tables and that works perfectly now :up:

Many many thanks to you, Mark, for your patience and receptiveness



edit : here's the final code :

global $vbulletin, $db;
$number_of_attachments = 5;
$output = '';

$last_attachments = $vbulletin->db->query_read_slave("
    SELECT vb_attachment.*, vb_user.*, vb_post.postid, vb_post.threadid, vb_thread.title, vb_filedata.filesize
    FROM " . TABLE_PREFIX . "attachment
    INNER JOIN " . TABLE_PREFIX . "user
    ON vb_user.userid = vb_attachment.userid
    INNER JOIN " . TABLE_PREFIX . "post
    ON vb_post.postid = vb_attachment.contentid
    INNER JOIN " . TABLE_PREFIX . "thread
    ON vb_thread.threadid = vb_post.threadid
    INNER JOIN " . TABLE_PREFIX . "filedata
    ON vb_filedata.filedataid = vb_attachment.filedataid
    ORDER BY vb_attachment.dateline DESC
    LIMIT " . $number_of_attachments
);

$n = 0;
while ($attachment = $db->fetch_array($last_attachments))
{
    $output .= '<div';
    if ($n++)
    {
        $output .= ' style="border-top: 1px solid #CCCCCC"';
    }
    $output .= '>Posted By: <div style="display: inline-block">' . attach_user_link($attachment) . '</div><div title="Uploaded: ' . vbdate($vbulletin->options['dateformat'], $attachment['dateline'], 1) . ' at ' . vbdate($vbulletin->options['timeformat'], $attachment['dateline']) . PHP_EOL . 'Views: ' . $attachment['counter'] . PHP_EOL . 'Size: ' . number_format($attachment['filesize']/1024,1) . ' KB">' . $attachment['filename'] . '</div><a title="Go To Post With Attachment" href="showthread.php?' . $attachment['threadid'] . '-' . str_replace(' ', '-', $attachment['title']) . '&p=' . $attachment['contentid'] . '&viewfull=1#post' . $attachment['contentid'] . '">' . $attachment['title'] . '</a></div>';
}

return $output;

function attach_user_link($user_name)
{
    global $vbulletin;
    $link = 'member.php?do=getinfo&username=' . $user_name['username'];

    if ($user_name['displaygroupid'])
    {
        $groupid = $user_name['displaygroupid'];
    }
    else
    {
        $groupid = $user_name['usergroupid'];
    }

    $open_tag = $vbulletin->usergroupcache[$groupid]['opentag'];
    $close_tag = $vbulletin->usergroupcache[$groupid]['closetag'];
    return '<a title="Go To ' . $user_name['username'] . '\'s Profile" href="' . $link . '">' . $open_tag . $user_name['username'] . $close_tag . '</a>';
}