[calorie]

// table prefix fix

$PortalNews = $vbulletin->db->query_first("
        SELECT " . TABLE_PREFIX . "thread.*, post.pagetext AS pagetext
        FROM " . TABLE_PREFIX . "thread
        LEFT JOIN " . TABLE_PREFIX . "post AS post
        ON(post.postid = " . TABLE_PREFIX . "thread.firstpostid)
        WHERE forumid = 2
        ORDER BY dateline DESC
");

// or however you want to do it

// make an array

if (is_array($vbulletin->sitenews))
{
        echo " Yes, an array. ";
}
else
{
        echo " No, not array. ";
}

$vbulletin->sitenews = unserialize($vbulletin->sitenews);

echo $vbulletin->sitenews['newstitle'];

// check out $unserialize and function register in class core