. // It's licensed under the AFFERO GENERAL PUBLIC LICENSE unless stated otherwise. // You can get copies of the licenses here: // http://www.affero.org/oagpl.html // AFFERO GENERAL PUBLIC LICENSE is also included in the file called "COPYING". include('config.php'); include(mnminclude.'html1.php'); include(mnminclude.'link.php'); include(mnminclude.'comment.php'); $globals['ads'] = true; do_header(_('mejores comentarios en 24 horas')); do_banner_top(); echo '
'."\n"; do_sidebar(); echo '
'; do_tabs('main', _('+ comentarios'), true); echo '

'._('comentarios más valorados 24 horas').'

'; $last_link = 0; $counter = 0; $comment = new Comment; $link = new Link; echo '
'; $min_date = date("Y-m-d H:00:00", time() - 86000); // about 24 hours $comments = $db->get_results("SELECT comment_id, link_id FROM comments, links WHERE comment_date > '$min_date' and link_id=comment_link_id ORDER BY comment_karma desc, link_id asc limit 25"); if ($comments) { foreach ($comments as $dbcomment) { $link->id=$dbcomment->link_id; $comment->id = $dbcomment->comment_id; $link->read(); $comment->read(); if ($last_link != $link->id) { if ($counter % 12 == 5) // AdSense do_banner_story(); //$link->print_summary('short'); echo '

'; echo ''. $link->title. ''; echo '

'; } echo '
    '; $comment->print_summary($link, 2000, false); if ($last_link != $link->id) { $last_link = $link->id; $counter++; } echo "
\n"; } } echo '
'; echo '
'; do_footer(); ?>