$from_time = '"'.date("Y-m-d H:00:00", $globals['now'] - $globals['time_enabled_comments']).'"';
$from_where = "FROM links WHERE link_date > $from_time and link_status='published' and link_category in (".$globals['meta_categories'].") ";
//$from_where = "FROM links WHERE link_status='published' and link_category in (".$globals['meta_categories'].") ";
print_index_tabs(7); // Show "personal" as default
break;
case '_friends':
$from_time = '"'.date("Y-m-d H:00:00", $globals['now'] - 86400*4).'"';
$from_where = "FROM links, friends WHERE link_date > $from_time and link_status='published' and friend_type='manual' and friend_from = $current_user->user_id and friend_to=link_author and friend_value > 0";
print_index_tabs(1); // Friends
break;
default:
print_index_tabs(0); // All
$from_where = "FROM links WHERE link_status='published' ";
}
} else {
print_index_tabs(0); // No other view
$from_where = "FROM links WHERE link_status='published' ";
}
do_mnu_categories_horizontal($_REQUEST['category']);
/*** SIDEBAR ****/
echo '<div id="sidebar">';
do_banner_right();
if ($globals['show_popular_published']) do_best_stories();
do_best_sites();
do_categories_cloud('published');
if ($page < 2) {
do_best_comments();
}
do_vertical_tags('published');
echo '<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />' . "\n";
echo '<link rel="stylesheet" href="css/wiistyle.css" type="text/css" />';
echo "<title>Menéame - Wii edition</title>\n";
echo '<meta name="generator" content="meneame" />' . "\n";
echo '</head>' . "\n";
echo '<body id="home"><a name="top"></a>' . "\n";
echo '<div id="header">' . "\n";
echo '<h1>Menéame</h1>' . "\n";
echo '</div>' . "\n";
meta_get_current();
// NOTA: Esta lista debería ir dentro de #container, no aquí
if ($globals['meta_current'] > 0) {
$from_where = "FROM links WHERE link_status='published' and link_category in (" . $globals['meta_categories'] . ") ";
print_index_tabs();
} else {
print_index_tabs(0);
$from_where = "FROM links WHERE link_status='published' ";
}
echo '<div id="container">';
$links = $db->get_col("SELECT link_id {$from_where} order by link_date desc LIMIT {$page_size}");
if ($links) {
foreach ($links as $link_id) {
$link->id = $link_id;
$link->read();
echo '<div class="news-summary"><div class="news-body">';
echo '<div class="news-shakeit"><div class="mnm-published">' . $link->votes . '</div><div class="menealo">meneos</div></div>';
echo '<h2 class="title">' . $link->title . '</h2>';
echo '<p>' . $link->to_html($link->content);
echo ' <a href="' . htmlspecialchars($link->url) . '">' . _('Ver noticia') . ' ></a></p>';
echo '<p class="news-submitted"><img src="' . get_avatar_url($link->author, $link->avatar, 40) . '" class="senderimg" width="40" height="40" alt="avatar de ' . $link->username . '" />';
echo ' ' . _('por') . ' <strong>' . $link->username . '</strong> ';
