BeritaTREN.COM

</head>

<?
function get_list_popular($app, $type = '') {
global $apps;
if ($type == 'thumb') {
$num = 3;
}
else {
$num = 5;
}
// total
$res = sql_query("select count(*) as total from `".tb()."stories` where app='$app'");
$row = sql_fetch_array($res);
$total = $row['total'];
$res = sql_query("SELECT s.*,u.username FROM `".tb()."stories` as s LEFT JOIN `".tb()."accounts` as u ON u.id=s.uid where s.app='$app' order by s.views DESC limit $num");
if ($type == 'thumb') {
$content .= '<table width="100%"><tr>';
while ($row = sql_fetch_array($res)) {
if (!$row['thumbnail']) {
if ($app == 'music') {
$row['thumbnail'] = 'uploads/userfiles/undefined_song.gif';
}
else {
$row['thumbnail'] = 'uploads/userfiles/undefined.jpg';
}
}
$content .= '<td align="center">'.url($row['app'].'/viewstory/'.$row['id'],htmlspecialchars(utf8_substr($row['title'],20))).'<br />
<a href="'.url($row['app'].'/viewstory/'.$row['id']).'"><img class="thumb" src="'.uhome().'/'.$row['thumbnail'].'" /></a></td>';
}
$content .= '</tr></table>';
}
else {
$content .= '<ul class="simple_list">';
while ($row = sql_fetch_array($res)) {
$row['content'] = preg_replace("/\[\w+](.*)\[\/\w+]/isU","\1",$row['content']);
$row['content'] = strip_tags(utf8_substr($row['content'],90));
$content .= '<li><strong>'.url($row['app'].'/viewstory/'.$row['id'],htmlspecialchars(utf8_substr($row['title'],60))).'</strong><br /></li>';
}
$content .= '</ul>';
}
return $content;
}

?>

echo '<div class="block">
<div class="block_title">'.t('Photo albums').'</div>
<div class="block_content">'.get_list_popular('photos','thumb').'</div>
</div>';

echo '<div class="block">
<div class="block_title">'.t('Music').'</div>
<div class="block_content">'.get_list_popular('music','thumb').'</div>
</div>';

echo '<div class="block">
<div class="block_title">'.t('Videos').'</div>
<div class="block_content">'.get_list_popular('videos','thumb').'</div>
</div>';

echo '<div class="block">
<div class="block_title">'.t('Blogs').'</div>
<div class="block_content">'.get_list_popular('blogs').'</div>
</div>';