How to convert DB vbb3 to vbb4

[Easy5s.net]

Here is code for VB3, how it can be work with VB4 damaged because the database of completely different vbb4 and it does not have postid.

$postid = $newpost['postid'];
$attachs = $vbulletin->db->query_read("
SELECT dateline, filename, attachmentid
FROM " . TABLE_PREFIX . "attachment
WHERE postid = $postid
ORDER BY attachmentid
");


sorry my bad english.

[kh99]

I think you want something like this:

$contenttypeid = vB_Types::instance()->getContentTypeID('vBForum_Post');
$postid = $newpost['postid'];
$attachs = $vbulletin->db->query_read("
SELECT dateline, filename, attachmentid
FROM " . TABLE_PREFIX . "attachment
WHERE contenttypeid = $contenttypeid AND contentid = $postid
ORDER BY attachmentid
");