<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>
$res_totalmembers = mysql_query($sql_totalmembers); $num_totalmembers = mysql_num_rows($res_totalmembers); $num_totalroids = 0; $num_totalscore = 0; while ($rec_totalmembers = mysql_fetch_array($res_totalmembers)) { $num_totalroids += $rec_totalmembers['roid_steel']; $num_totalroids += $rec_totalmembers['roid_crystal']; $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)); ?>