phpBB.de

Code: Alles auswählen

// MOST EP START 
if( $introportalmod_config['postcashbox_active'] == "1" && $introportalmod_config['topposter_active'] == "1" ) 
{ 
   $template->assign_block_vars('switch_ep_active', array()); 

   $most_posts_limit = 10; 
   $sql = "SELECT user_id, username, user_posts, user_totalpages, user_totallogon 
      FROM " . USERS_TABLE . " 
      WHERE user_id <> " . ANONYMOUS . " 
      ORDER BY user_posts DESC 
      LIMIT $most_posts_limit"; 
   if ( !($result = $db->sql_query($sql)) ) 
   { 
      message_die(GENERAL_ERROR, 'Could not obtain user/online forums information', '', __LINE__, __FILE__, $sql); 
   } 
   while ($row = $db->sql_fetchrow($result)) 
   { 
      $user_id=$row['user_id']; 
      $template->assign_block_vars("most_ep", array( 
         'USERNAME' => $row['username'], 
		 'EP' => ($row['user_posts'] * 3) + $row['user_totalpages'] + ($row['user_totallogon'] * 2),
         'U_VIEWPROFILE' => append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=$user_id")) 
      ); 
   } 
} 
// MOST EP END

Code: Alles auswählen

$sql = "SELECT user_id, username, user_posts, user_totalpages, user_totallogon, ((user_posts * 3) + user_totalpages + (user_totallogon * 2)) AS exp
      FROM " . USERS_TABLE . "
      WHERE user_id <> " . ANONYMOUS . "
      ORDER BY exp DESC
      LIMIT $most_posts_limit";