Exemple #1
0
	$res_allianceplayers = mysql_query($sql_allianceplayers);
	while ($rec_allianceplayers = mysql_fetch_array($res_allianceplayers)) {
		$alliancetop[$i]['id'] = $rec_topalliance['id'];
		$alliancetop[$i]['total_members'] = mysql_num_rows($res_allianceplayers);
		$alliancetop[$i]['score'] += $rec_allianceplayers['score'];
		$alliancetop[$i]['asteroids'] += $rec_allianceplayers['roid_steel'] + $rec_allianceplayers['roid_crystal'] + $rec_allianceplayers['roid_erbium'] + $rec_allianceplayers['roid_unused'];
	}
	$i++;
}
$score = array();
foreach ($alliancetop as $key => $val) {
	$score[$key] = $val['score'];
}
array_multisort($score, SORT_DESC, $alliancetop);

if (count($alliancetop) <= 10) { $max_count = count($alliancetop); }
else { $max_count = 10; }
mysql_query("TRUNCATE TABLE $table[universe_alliance]");
for ($j = 0; $j < $max_count; $j++) {
	if ($alliancetop[$j]['total_members'] == 0) { continue; }
	$name = getAllianceNameById($alliancetop[$j]['id']);
	$tag = getAllianceTageById($alliancetop[$j]['id']);
	$total_members = $alliancetop[$j]['total_members'];
	$score = $alliancetop[$j]['score'];
	$asteroids = $alliancetop[$j]['asteroids'];
	$sql_newalliancetop = "INSERT INTO $table[universe_alliance] (`name`, `tag`, `total_members`, `score`, `asteroids`) 
						VALUES ('$name', '$tag', '$total_members', '$score', '$asteroids')";
	mysql_query($sql_newalliancetop) or die(mysql_error());
}
?>
Exemple #2
0
?>
&y=<?php 
echo $rec_uniscan['y'];
?>
"><?php 
echo $rec_uniscan['x'];
?>
:<?php 
echo $rec_uniscan['y'];
?>
:<?php 
echo $rec_uniscan['z'];
?>
</a></td>
								<td align="center"><?php 
echo getAllianceTageById($rec_uniscan['alliance_id']);
?>
</td>
								<td><a href="main.php?mod=main&act=mail&do=compose&x=<?php 
echo $rec_uniscan['x'];
?>
>&y=<?php 
echo $rec_uniscan['y'];
?>
&z=<?php 
echo $rec_uniscan['z'];
?>
"><?php 
echo $rec_uniscan['rulername'];
?>
 of <?php