phpBB.de

Code: Alles auswählen

Als stats.php abspeichern. (In dem folgenden Code "user_feld" 4x mit der Bezeichnung von diesem Feld, das du zählen möchtest, ersetzen.) 
Code: 
<?php 
define('IN_PHPBB', true); 
$phpbb_root_path = './'; 
include($phpbb_root_path . 'extension.inc'); 
include($phpbb_root_path . 'common.'.$phpEx); 

$userdata = session_pagestart($user_ip, PAGE_INDEX); 
init_userprefs($userdata); 

$page_title = 'Stats'; 
include($phpbb_root_path . 'includes/page_header.'.$phpEx); 

$template->set_filenames(array( 
   'body' => 'stats_body.tpl') 
); 

$sql = "SELECT user_feld, count(*) AS amount FROM ". USERS_TABLE ." 
           WHERE user_feld <> '' 
           GROUP BY user_feld ORDER BY amount DESC"; 
if( !($result = $db->sql_query($sql)) ) 
{ 
   message_die(GENERAL_ERROR, 'Couldn\'t retrieve users data', '', __LINE__, __FILE__, $sql); 
} 
$stats_count = $db->sql_numrows($result); 
$stats_data = $db->sql_fetchrowset($result); 

$total_users = get_db_stat('usercount'); 

for( $i = 0; $i < $stats_count; $i++ ) 
{ 
   $row_class = ( $i%2 ) ? $theme['td_class2'] : $theme['td_class1']; 

   $percent = round(($stats_data[$i]['amount'] / $total_users) * 100,2); 

   $template->assign_block_vars('stats', array( 
      'RANK' => $i+1, 
      'ROW_CLASS' => $row_class, 
      'ENTRY' => $stats_data[$i]['user_feld'], 
      'AMOUNT' => $stats_data[$i]['amount'], 
      'PERCENT' => $percent, 
   )); 
} 

$template->pparse('body'); 
include($phpbb_root_path . 'includes/page_tail.'.$phpEx); 
?> 

Als stats_body.tpl abspeichern.. 
Code: 
<table border="0" cellpadding="4" cellspacing="1" class="forumline" width="50%" align="center"> 
  <tr>    
        <th width="5%">#</th>    
        <th>Eintrag</th> 
        <th width="5%">Anzahl</th> 
        <th>Prozent</th> 
  </tr> 
  <!-- BEGIN stats --> 
  <tr> 
        <td class="{stats.ROW_CLASS}" align="center"><span class="gen">{stats.RANK}</span></td> 
        <td class="{stats.ROW_CLASS}" align="center"><span class="gen">{stats.ENTRY}</span></td> 
        <td class="{stats.ROW_CLASS}" align="right"><span class="gen">{stats.AMOUNT}</span>&nbsp;</td>    
        <td class="{stats.ROW_CLASS}">&nbsp;<img src="templates/subSilver/images/cellpic3.gif" width="{stats.PERCENT}%" height="12" /> 
                                        <span class="gen">{stats.PERCENT}%</span></td>    
  </tr> 
  <!-- END stats --> 
  <tr> 
        <td class="catBottom" colspan="4">&nbsp;</td> 
  </tr> 
</table>