Classement

'0') { $return = $hours.' h '.$mins.' min'; } else { $return = $hours.' h '; } } else { $return = round(($seconds / 86400), 0).' jours'; } return $return; } // Connexion mySQL $mysql['host'] = 'localhost'; $mysql['user'] = 'teestat'; $mysql['pass'] = ''; $mysql['db'] = 'teestat'; $link = mysql_connect($mysql['host'], $mysql['user'], $mysql['pass']) or die("Impossible de se connecter"); mysql_select_db($mysql['db']) or die("Impossible d'accéder ´ la base de données."); // Top efficacite $query = "SELECT * FROM teewars_player WHERE ptime > 60 AND points > 2 AND deaths > 0"; $result = mysql_query($query); $n = 0; while ($line = mysql_fetch_assoc($result)) { $players[$n]['name'] = $line['name']; $players[$n]['eff'] = round(( 3600 * $line['points'] / $line['ptime'] ), 0); $players[$n]['res'] = round(( ( 100 * $line['points'] / $line['deaths'] ) / ( ($line['points'] / $line['deaths']) + 1) ), 0); $players[$n]['kills'] = $line['points']; $players[$n]['deaths'] = $line['deaths']; $players[$n]['ptime'] = $line['ptime']; $n++; } if(is_array($players)) { $array = array('name', 'res', 'eff', 'kills', 'deaths', 'ptime'); if(isset($_GET['o']) && in_array($_GET['o'], $array)) { $key = $_GET['o']; } else { $key = $array['2']; } if($key == 'name') { $order = 'asc'; } else { $order = 'desc'; } $players = array_sort($players, $key, $order); $players = array_chunk($players, 10); $players = $players['0']; } else { $players[]['name'] = 'Pas de données.'; } echo ''."\n"; foreach($players as $rang => $player) { echo ''."\n"; } echo '

#	Nom	Résistance	Efficacité	Tués	Mort	Temps de jeu
'.($rang+1).'.	'.$player['name'].'	'.$player['res'].' %	'.$player['eff'].'	'.$player['kills'].'	'.$player['deaths'].'	'.data_unit($player['ptime']).'

'; // Deconnexion mySQL mysql_free_result($result); mysql_close($link); ?>