############################################################## 
## 
## MOD Title:        ADR Stats On Index 
## 
## MOD Author:        aUsTiN => austin_inc@hotmail.com 
## 
## MOD Description:       Adds stats for your x most active ADR players + stats on your index page. 
## 
## MOD Version:           1.0.3 
## 
## MOD Help:        http://phpbb-tweaks.com 
## 
## Installation Level:    Easy 
## 
## Installation Time:     1 Minute 
## 
## Files To Edit:         2 
## 
##           index.php 
##           templates/*/index_body.tpl 
## 
############################################################## 
############################################################## 
## 
## Author Notes: 
## 
############################################################## 
## 
## MOD History: 
## 
##   Jun 05th 2004 - Version 1.0.0 
##         - Beta Released 
## 
##   Nov 23rd 2004 - Version 1.0.3 
##      - Final Released 
## 
############################################################## 
## 
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD 
## 
############################################################## 
## 
##   Definitions: 
## 
##      Root: Folder your config.php is located 
## 
############################################################## 

----------------------------------- 
----[ OPEN ]----------------------- 
----------------------------------- 

Root/index.php 

----------------------------------- 
----[ FIND ]----------------------- 
----------------------------------- 

   // 
   // Okay, let's build the index 
   // 

----------------------------------- 
----[ BEFORE, ADD ]---------------- 
----------------------------------- 

#======================================================================= | 
#==== Start: == ADR Stats on Index ===================================== | 
#==== v1.0.3 =========================================================== | 
#==== 
define("ADR_CHARACTERS_TABLE", $table_prefix .'adr_characters'); 
$adr_limiter = "5"; # Change This To Show More Than Five Members 

   $template -> assign_block_vars('adr_top', array(          
      'L_ADR_MAIN_USERNAME'      => "Owner:", 
      'L_ADR_MAIN_CHAR_NAME'   => "Name:", 
      'L_ADR_MAIN_CHAR_WINS'   => "Wins:", 
      'L_ADR_MAIN_CHAR_LOSSES'   => "Losses:", 
      'L_ADR_MAIN_CHAR_FLEES'   => "Flees:", 
      'L_ADR_MAIN_CHAR_HP'      => "HP:", 
      'L_ADR_MAIN_CHAR_MP'      => "MP:", 
      'L_ADR_MAIN_CHAR_TOTAL'   => "Total Battles:", 
      'L_ADR_MAIN_CHAR_TITLE'   => "Top ". $adr_limiter ." ADR Active Players") 
         ); 

   $q = "SELECT username, user_id 
          FROM  ". USERS_TABLE .""; 
   if ( !($r = $db->sql_query($q)) ) 
      {    
   message_die(GENERAL_ERROR, 'Error Selecting Top '. $adr_limiter .' Adr Names!', "Error"); 
      } 
   $adr_users = $db -> sql_fetchrowset($r); 
   $adr_count = $db -> sql_numrows($r); 
          
   $q = "SELECT *, SUM(character_victories + character_defeats + character_flees) as most_active 
          FROM  ". ADR_CHARACTERS_TABLE ." 
          GROUP BY character_id 
          ORDER BY most_active DESC 
          LIMIT 0, $adr_limiter"; 
   if ( !($r = $db->sql_query($q)) ) 
      { 
   message_die(GENERAL_ERROR, 'Error Selecting Top '. $adr_limiter .' Adr Users!', "Error"); 
      } 
        
   while($row = $db->sql_fetchrow($r)) 
      { 
   $adr_main_char_id      = $row['character_id']; 
   $adr_main_char_name      = $row['character_name']; 
   $adr_main_char_wins      = number_format($row['character_victories']); 
   $adr_main_char_losses   = number_format($row['character_defeats']); 
   $adr_main_char_flees   = number_format($row['character_flees']); 
   $adr_main_char_hp      = number_format($row['character_hp']); 
   $adr_main_char_hp_max   = number_format($row['character_hp_max']); 
   $adr_main_char_mp      = number_format($row['character_mp']); 
   $adr_main_char_mp_max   = number_format($row['character_mp_max']); 
    
      for($a = 0; $a < $adr_count; $a++) 
         { 
         if ($adr_users[$a]['user_id'] == $adr_main_char_id) 
            { 
         $adr_main_char_username = $adr_users[$a]['username']; 
            } 
         }    
    
   $template -> assign_block_vars('adr', array(    
      'ADR_MAIN_USERNAME'      => '<a href="profile.'. $phpEx .'?mode=viewprofile&u='. $adr_main_char_id .'&sid='. $userdata['session_id'] .'">'. $adr_main_char_username .'</a>', 
      'ADR_MAIN_CHAR_NAME'   => '<a href="adr_character.'. $phpEx .'?u='. $adr_main_char_id .'&sid='. $userdata['session_id'] .'">'. $adr_main_char_name .'</a>', 
      'ADR_MAIN_CHAR_WINS'   => $adr_main_char_wins, 
      'ADR_MAIN_CHAR_LOSSES'   => $adr_main_char_losses, 
      'ADR_MAIN_CHAR_FLEES'   => $adr_main_char_flees, 
      'ADR_MAIN_CHAR_HP'      => $adr_main_char_hp, 
      'ADR_MAIN_CHAR_HP_MAX'   => $adr_main_char_hp_max, 
      'ADR_MAIN_CHAR_MP'      => $adr_main_char_mp, 
      'ADR_MAIN_CHAR_MP_MAX'   => $adr_main_char_mp_max, 
      'ADR_MAIN_CHAR_TOTAL'   => number_format($row['character_victories'] + $row['character_defeats'] + $row['character_flees']))
         );          
      }                      
#==== 
#==== Author: aUsTiN [austin@phpbb-amod.com] [http://phpbb-amod.com] === | 
#==== End: ==== ADR Stats On Index ===================================== |    
#======================================================================= | 

----------------------------------- 
----[ CLOSE & SAVE ]--------------- 
----------------------------------- 

----------------------------------- 
----[ OPEN ]----------------------- 
----------------------------------- 

Root/templates/*/index_body.tpl 

----------------------------------- 
----[ FIND ]----------------------- 
----------------------------------- 

For this, just goto the last line of the file, so its displayed on the bottom... 

----------------------------------- 
----[ ADD ]------------------------ 
----------------------------------- 

<!-- Start ADR Mod On Main Page By aUsTiN --> 
<!-- BEGIN adr_top --> 
<br /> 
<table width="90%" cellspacing="0" border="0" align="center" cellpadding="2" class="forumline"> 
   <tr> 
        <th align="center" valign="middle" colspan="8" class="catHead"> 
             {adr_top.L_ADR_MAIN_CHAR_TITLE}    
      </th> 
   </tr> 
   <tr> 
      <th align="center" valign="middle" nowrap="nowrap" width="15%" class="catHead"> 
         {adr_top.L_ADR_MAIN_CHAR_NAME}    
      </th> 
      <th align="center" valign="middle" nowrap="nowrap" width="15%" class="catHead"> 
         {adr_top.L_ADR_MAIN_USERNAME}    
      </th> 
      <th align="center" valign="middle" nowrap="nowrap" width="7%" class="catHead"> 
         {adr_top.L_ADR_MAIN_CHAR_WINS}    
      </th> 
      <th align="center" valign="middle" nowrap="nowrap" width="7%" class="catHead"> 
         {adr_top.L_ADR_MAIN_CHAR_LOSSES}    
      </th> 
      <th align="center" valign="middle" nowrap="nowrap" width="7%" class="catHead"> 
         {adr_top.L_ADR_MAIN_CHAR_FLEES}    
      </th> 
      <th align="center" valign="middle" nowrap="nowrap" width="10%" class="catHead"> 
         {adr_top.L_ADR_MAIN_CHAR_HP} 
      </th> 
      <th align="center" valign="middle" nowrap="nowrap" width="10%" class="catHead"> 
         {adr_top.L_ADR_MAIN_CHAR_MP} 
      </th> 
      <th align="center" valign="middle" nowrap="nowrap" width="7%" class="catHead"> 
         {adr_top.L_ADR_MAIN_CHAR_TOTAL}    
      </th>                                    
   </tr> 
<!-- END adr_top -->          
<!-- BEGIN adr --> 
   <tr> 
      <td align="left" class="row1"> 
         <span class="genmed"> 
            {adr.ADR_MAIN_CHAR_NAME}    
         </span> 
      </td> 
      <td align="left" class="row2"> 
         <span class="genmed"> 
            {adr.ADR_MAIN_USERNAME}    
         </span> 
      </td> 
      <td align="left" class="row1"> 
         <span class="genmed"> 
            {adr.ADR_MAIN_CHAR_WINS}    
         </span> 
      </td> 
      <td align="left" class="row2"> 
         <span class="genmed"> 
            {adr.ADR_MAIN_CHAR_LOSSES}    
         </span> 
      </td> 
      <td align="left" class="row1"> 
         <span class="genmed"> 
            {adr.ADR_MAIN_CHAR_FLEES}    
         </span> 
      </td> 
      <td align="left" class="row2"> 
         <span class="genmed"> 
            {adr.ADR_MAIN_CHAR_HP} / {adr.ADR_MAIN_CHAR_HP_MAX} 
         </span> 
      </td> 
      <td align="left" class="row1"> 
         <span class="genmed"> 
            {adr.ADR_MAIN_CHAR_MP} / {adr.ADR_MAIN_CHAR_MP_MAX} 
         </span> 
      </td> 
      <td align="left" class="row2"> 
         <span class="genmed"> 
            {adr.ADR_MAIN_CHAR_TOTAL}    
         </span> 
      </td>                                    
   </tr> 
<!-- END adr --> 
   <tr> 
      <th align="center" valign="middle" colspan="8"> 
      </th> 
   </tr>      
</table> 
<br> 
<!-- End ADR Mod On Main Page By aUsTiN --> 

----------------------------------- 
----[ CLOSE & SAVE ]--------------- 
----------------------------------- 

EoM