<tr>
<td width="150">Planetname:</td>
<td width="650"><? echo $playerdata['planetname'];?></td>
</tr>
<tr>
<td width="150">Universe location:</td>
<td width="650">
<?
$xyz = getXYZ($playerdata['id']);
echo $xyz[0].':'.$xyz[1].':'.$xyz[2];
?>
</td>
</tr>
<tr>
<td width="150">Alliance name & tag:</td>
<td width="650"><?echo getAllianceName($playerdata['id']).' - '.getAllianceTag($playerdata['id']);?></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
<td width="4" background="img/border/R.gif"> </td>
</tr>
<tr>
<td width="2%" valign="top"><img border="0" src="img/border/L_O.gif" width="20" height="15"></td>
<td width="100%" background="img/border/O.gif" colspan="2"> </td>
<td width="3%" valign="top"><img border="0" src="img/border/R_O.gif" width="20" height="15"></td>
</tr>
</table>
<br><br>
$time_diff = $currenttime - $logintime;
if ($time_diff > 300) { $status = null; }
else { $status = '*'; }
} else {
$status = null;
}
$name_color = "#FFFFFF";
if ($rec_playerdata['id'] == $rec_galaxydata['moc_id']) { $name_color = "#FF00FF"; }
if ($rec_playerdata['id'] == $rec_galaxydata['mow_id']) { $name_color = "#FF0000"; }
if ($rec_playerdata['id'] == $rec_galaxydata['moe_id']) { $name_color = "#FFFF00"; }
if ($rec_playerdata['id'] == $rec_galaxydata['commander_id']) { $name_color = "#0000FF"; }
?>
<tr>
<td align="center"><? echo $x; ?>:<? echo $y; ?>:<? echo $z; ?></td>
<td align="center"><? echo getAllianceTag($rec_playerdata['id']);?></td>
<td align="right" width="177"><a href="main.php?mod=main&act=mail&do=compose&x=<?php
echo $x;
?>
&y=<?php
echo $y;
?>
&z=<?php
echo $z;
?>
"><font color="<?echo $name_color;?>"><? echo stripslashes($rec_playerdata[rulername]); ?></font></a></td>
<td align="center" width="6"><a href="main.php?mod=main&act=mail&do=compose&x=<?php
echo $x;
?>
&y=<?php
echo $y;
<?
/* Getting top 100 users. */
$sql_gettop = "SELECT `id`, `rulername`, `planetname`, `roid_steel` , `roid_crystal`, `roid_erbium`, `roid_unused`, `score` FROM $table[players] ORDER BY `score` DESC LIMIT 30";
$res_gettop = mysql_query($sql_gettop);
mysql_query("TRUNCATE TABLE $table[universe]");
while ($rec_gettop = mysql_fetch_array($res_gettop)) {
$player_id = $rec_gettop['id'];
$score = $rec_gettop['score'];
$rulername = $rec_gettop['rulername'];
$planetname = $rec_gettop['planetname'];
$tag = getAllianceTag($rec_gettop['id']);
$asteroids = $rec_gettop['roid_steel'] + $rec_gettop['roid_crystal'] + $rec_gettop['roid_erbium'] + $rec_gettop['roid_unused'];
$sql_newtop = "INSERT INTO $table[universe] (`player_id`, `rulername`, `planetname`, `tag`, `score`, `asteroids`) VALUES ('$player_id', '$rulername', '$planetname', '$tag', '$score', '$asteroids')";
mysql_query($sql_newtop);
}
/* Getting top 10 galaxies. */
$galaxytop = array(array());
$sql_topgalaxy = "SELECT `id` FROM $table[galaxy]";
$res_topgalaxy = mysql_query($sql_topgalaxy);
$i = 0;
while ($rec_topgalaxy = mysql_fetch_array($res_topgalaxy)) {
$galaxytop[$i]['id'] = 0;
$galaxytop[$i]['score'] = 0;
$galaxytop[$i]['asteroids'] = 0;
$sql_galaxyplayers = "SELECT `roid_steel`, `roid_crystal`, `roid_erbium`, `roid_unused`, `score` FROM $table[players] WHERE `galaxy_id` = '$rec_topgalaxy[id]'";
$res_galaxyplayers = mysql_query($sql_galaxyplayers);
while ($rec_galaxyplayers = mysql_fetch_array($res_galaxyplayers)) {
$num_totalroids += $rec_totalmembers['roid_erbium'];
$num_totalroids += $rec_totalmembers['roid_unused'];
$num_totalscore += $rec_totalmembers['score'];
}
?>
<tr>
<td width="150">Alliance name:</td>
<td width="250"><?php
echo getAllianceName($playerdata['id']);
?>
</td>
</tr>
<tr>
<td width="150">Alliance tag:</td>
<td width="250"><?php
echo getAllianceTag($playerdata['id']);
?>
</td>
</tr>
<tr>
<td width="150">Alliance commander:</td>
<td width="250"><?php
echo getRulernameById(getAllianceCommander($alliance_id));
?>
of <?php
echo getPlanetnameById(getAllianceCommander($alliance_id));
?>
</td>
</tr>
<tr>
<td width="150">Alliance sub commander:</td>
