Help : customise block in the sidebare

[kh99]

Try this for the code:

global $vbulletin;

$bestphoto =$vbulletin->db->query_first("SELECT * FROM vb_ratemyphoto_photos WHERE approved=1 AND hidden=0 

AND rating>0 ORDER BY rating DESC, votes DESC LIMIT 1");
    $besttitle = htmlspecialchars_uni($bestphoto["title"]);
    $bestphotoname = $bestphoto["logo"];
    $bestvotes = $bestphoto["votes"];
    $bestrating = $bestphoto["rating"];
        $templater = vB_Template::create('block-photo');
        $templater->register('besttitle', $besttitle);
    $templater->register('bestphotoname', $bestphotoname);
        $templater->register('bestvotes', $bestvotes);
    $templater->register('bestrating', $bestrating);
    $templater->register('bestuserid', $bestphoto[userid]);
    $templater->register('bestusername', $bestphoto[username]);    
    $templater->register('catid', $catid);
    return $templater->render();