get( 'count', 5 );
$linkcomt = $params->get( 'linkcomt', yes );
$showuser = $params->get( 'showuser', yes );
$cbint = $params->get( 'cbint', no );
$date_format = $params->get( 'dateformat', M.d );
$diconsize = $params->get( 'diconsize', 16 );
$database->setQuery("SELECT id, (CASE menutype WHEN 'mainmenu' THEN 1 WHEN 'topmenu' THEN 2 WHEN 'othermenu' THEN 3 ELSE 99 END) menorder"
." FROM #__menu WHERE link = 'index.php?option=com_remository' AND published=1 ORDER BY menorder");
$Itemid = $database->LoadResult();
$query = "SELECT #__downloads_reviews.itemid, #__downloads_reviews.userid, #__downloads_reviews.comment, #__downloads_reviews.date, #__users.username"
. "\n FROM #__downloads_reviews"
. "\n LEFT JOIN #__users ON #__users.id = #__downloads_reviews.userid"
. "\n ORDER BY date DESC"
. "\n LIMIT $count"
;
$database->setQuery($query);
$rows = $database->loadObjectList();
echo $database->getErrorMsg();
if ($diconsize) $dateurl = "
";
else $dateurl = '';
foreach($rows as $row) {
$datetext = date($date_format, strtotime($row->date));
if ($cbint == 'yes') $commenter = "$row->username";
else $commenter = "$row->username";
if ($linkcomt == 'yes') echo '';
else echo ''.$row->comment.'
';
if ($showuser == 'yes') echo 'Posted by: '.$commenter.'
';
if (strtolower($date_format) != 'none') echo "".$dateurl.$datetext.'
';
echo "";
}