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 '
  • '; } ?>