. // 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.'user.php'); $globals['ads'] = true; $page_size = 20; $offset=(get_current_page()-1)*$page_size; $items = array(_('usuario'), _('karma'), _('noticias'), _('noticias publicadas'), _('comentarios'), _('votos últimos 4 meses')); // Warn, empty() return true even if sortby=0 if ( !strlen($_GET['sortby']) > 0) { $sortby = 1; } else { $sortby = intval($_GET['sortby']); if($sortby < 0 || $sortby > 3) $sortby = 1; } switch ($sortby) { case 0: $select = "SELECT user_id "; $from_where = " FROM users "; $order_by = " ORDER BY user_login "; break; case 1: $select = "SELECT user_id "; $from_where = " FROM users "; $order_by = " ORDER BY user_karma DESC "; break; case 2: $select = "SELECT user_id, count(*) as count "; $from_where = " FROM links, users WHERE link_author=user_id GROUP BY link_author"; $order_by = " ORDER BY count DESC "; break; case 3: $select = "SELECT user_id, count(*) as count "; $from_where = " FROM links, users WHERE link_status = 'published' AND link_author=user_id GROUP BY link_author"; $order_by = " ORDER BY count DESC "; break; case 4: $select = "SELECT user_id, count(*) as count "; $from_where = " FROM comments, users WHERE comment_user_id=user_id GROUP BY comment_user_id"; $order_by = " ORDER BY count DESC "; break; case 5: $select = "SELECT user_id, count(*) as count "; $from_where = " FROM votes, users WHERE vote_type='links' and vote_user_id=user_id GROUP BY vote_user_id"; $order_by = " ORDER BY count DESC "; break; } // Sort by votes do_header(_('usuarios')); do_banner_top(); echo '

' . "\n"; echo '

'._('estadísticas de usuarios').'

'; echo ''; // Print headers for($i=0; $i'; if($i==$sortby) echo ''.$items[$i].''; elseif ($i <= 3) { // Don't show order by votes or comment // Too much CPU and disk IO consuption echo ''.$items[$i].''; } else { echo $items[$i]; } echo ''; } echo ''; $user = new User; $rows = $db->get_var("SELECT count(*) as count $from_where"); $users = $db->get_results("$select $from_where $order_by LIMIT $offset,$page_size"); if ($users) { foreach($users as $dbuser) { $user->id=$dbuser->user_id; $user->read(); $user->all_stats(); echo ''; echo ''; echo ''; echo ''; if($user->total_links>0) echo ''; else echo ''; echo ''; echo ''; echo ''; } } echo "

'.$user->username.'

'.$user->karma.'

'.$user->total_links.'

'.$user->published_links.' ('.intval($user->published_links/$user->total_links*100).'%)

'.$user->published_links.' (-)

'.$user->total_comments.'

'.$user->total_votes.'

\n\n"; do_pages($rows, $page_size, false); do_footer(); ?>