include('config.php');
include(stdinclude.'stock.php');
include(stdinclude.'link.php');
$range_names = array( _('all'), _('today'), _('this week'), _('this month'), _('this year'));
$range_values = array(0, 86400, 604800, 2592000, 31536000);
$offset=(get_current_page()-1)*$page_size;
if(($from = check_integer('range')) && $from > 0 && $from < count($range_values) ) {
$from_time = time() - $range_values[$from];
$from_where = "FROM votes, links WHERE link_date > FROM_UNIXTIME($from_time) AND vote_link_id=link_id AND";
$time_link = "link_modified > FROM_UNIXTIME($from_time) AND";
} else $from_where = "FROM votes, links WHERE vote_link_id=link_id AND";
$from_where .= " link_status != 'discard'";
$from_where .= " GROUP BY vote_link_id";
$time_link = '';
do_header(_('the most tagged'));
do_navbar(_('stories') . ' » ' . _('statistics'));
do_google();
do_menu();
echo '
'._('stories most tagged').'
';
$order_by = " ORDER BY votes DESC ";
do_tickerbox();
echo '';
do_google_cpa();
$link = new Link;
$rows = $db->get_var("SELECT count(*) as votes $from_where $order_by");
//echo "SELECT count(*) as votes $from_where $order_by";
//$rows = $db->get_var("SELECT count(*) FROM links WHERE $time_link link_status != 'discard'");
$links = $db->get_results("SELECT link_id, count(*) as votes $from_where $order_by LIMIT $offset,$page_size");
if ($links) {
foreach($links as $dblink) {
$link->id=$dblink->link_id;
$link->read();
$link->print_summary('short');
}
}
echo '
';
//echo "ROWS: $rows: $time_link\n";
do_sidebar_top();
do_pages($rows, $page_size);
do_footer();
function do_sidebar_top() {
global $db, $dblang, $range_values, $range_names;
echo '';
}
function do_top_rss_box() {
global $globals, $range_values, $range_names;
echo '' . "\n"; // It was class="side-boxed"
echo '' . "\n";
echo '
'._('suscripciones a las más meneadas').'' . "\n";
echo '
';
echo '
';
echo '';
}
?>