if ($row[turns_used]!=0) {
$i++;
$rating=round(sqrt( abs($row[rating]) ));
if(abs($row[rating])!=$row[rating])
{
$rating=-1*$rating;
}
$curtime = TIME();
$time = $row[online];
$difftime = ($curtime - $time) / 60;
$temp_turns = $row[turns_used];
if ($temp_turns <= 0)
{
$temp_turns = 1;
}
echo NUMBER($i) . ": ".player_insignia_name($row[email])." ".$row[character_name]." (";
if ($row[ship_destroyed] == "Y" && $row[dev_escapepod] == "N") {
echo "Player Died)";
} else {
echo NUMBER($row[score]) . ")";
}
echo "<br>";
}
$res->MoveNext();
}
echo "<br>[b]Alliances[/b]<BR><br>";
$sql_query = "SELECT $dbtables[players].character_name,
COUNT(*) as number_of_members,
ROUND(SQRT(SUM(POW($dbtables[players].score,2)))) as total_score,
$dbtables[teams].id,
$dbtables[teams].team_name,
$planettypes[3]= "largeplanet.gif";
$planettypes[4]= "hugeplanet.gif";
// New ship code
// Find out what my ship is
$res = $db->Execute("SELECT * FROM $dbtables[ship_types],$dbtables[ships] WHERE $dbtables[ship_types].type_id=$dbtables[ships].type AND $dbtables[ships].player_id=$playerinfo[player_id] AND $dbtables[ships].ship_id=$playerinfo[currentship]");
$shipinfo = $res->fields;
// Mission check
include("mission.php");
?>
<table border=1 cellspacing=0 cellpadding=5 bgcolor="<? echo $color_line2; ?>" width="75%" align=center>
<tr>
<td align="center">
<font color=silver><? echo player_insignia_name($username);?>
<b>
<font color=white><? echo $playerinfo[character_name];?>
</font>
</b>
</font>
<?php echo $l_abord ?>
<b>
<font color=white>
<a href="report.php?kk=<? echo date("U")?>"><? echo $shipinfo[ship_name] ?>
</a>
</font>
</b>
<?php
$towedimage="";
if ($shipinfo[tow]>0) {
while (!$res->EOF) {
$defences[$i] = $res->fields;
$i++;
$res->MoveNext();
}
}
$num_defences = $i;
$res = $db->Execute("SELECT zone_id,zone_name FROM {$dbtables['zones']} WHERE zone_id='{$sectorinfo['zone_id']}'");
$zoneinfo = $res->fields;
// New ship code
// Find out what my ship is
$res = $db->Execute("SELECT * FROM {$dbtables['ship_types']},{$dbtables['ships']} WHERE {$dbtables['ship_types']}.type_id={$dbtables['ships']}.type AND {$dbtables['ships']}.player_id={$playerinfo['player_id']} AND {$dbtables['ships']}.ship_id={$playerinfo['currentship']}");
$shipinfo = $res->fields;
// Mission check
include "mission.php";
echo "&insignia=" . urlencode(player_insignia_name($username));
echo "&name=" . urlencode($playerinfo[character_name]);
echo "&shipname=" . urlencode($shipinfo[ship_name]);
if ($shipinfo[tow] > 0) {
$res = $db->Execute("SELECT * FROM {$dbtables['ships']},{$dbtables['ship_types']} WHERE ship_id={$shipinfo['tow']} AND type_id=type");
$towedship = $res->fields;
echo "&tow=" . urlencode($towedship[ship_name]);
}
$result = $db->Execute("SELECT * FROM {$dbtables['messages']} WHERE recp_id='" . $playerinfo[player_id] . "' AND notified='N'");
if ($result->RecordCount() > 0) {
echo "&mess=" . $result->RecordCount();
}
echo "&turns={$playerinfo['turns']}";
echo "&turns_used={$playerinfo['turns_used']}";
echo "&score={$playerinfo['score']}";
echo "§or={$playerinfo['sector']}";
/*
Load the website class auto loader into the
*/
require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/auto.php';
header("Content-type: text/html; charset=utf-8");
header("X-UA-Compatible: IE=Edge, chrome=1");
header("Cache-Control: public");
// Tell the client (and any caches) that this information can be stored in public caches.
header("Connection: Keep-Alive");
// Tell the client to keep going until it gets all data, please.
header("Vary: Accept-Encoding, Accept-Language");
header("Keep-Alive: timeout=15, max=100");
if (!isset($body_class)) {
$body_class = "bnt";
}
$signame = player_insignia_name($db, $user_ship_id);
$res = $db->Execute("SELECT character_name, ship_name FROM {$db->prefix}ships WHERE ship_id='{$user_ship_id}'");
db_op_result($db, $res, __LINE__, __FILE__, $db_logging);
$playerinfo = $res->fields;
$user_title = "{$signame} <span class='ar-user-handle'>{$playerinfo['character_name']}</span>{$l->get('l_aboard')} <span class='ar-user-shipname'><a href='report.php' target='_self'>{$playerinfo['ship_name']}</a></span>";
?>
<!DOCTYPE html>
<html lang="<?php
echo $l->get('l_lang_attribute');
?>
">
<head>
<meta charset="utf-8">
<meta name="Description" content="Xenobe Rage - A free online game - Open source, web game, with multiplayer space exploration">
<meta name="Keywords" content="Free, online, game, Open source, web game, multiplayer, space, exploration, blacknova, traders, xenobe rage, xr, xenobe">
<meta name="Rating" content="General">
$planettypes[1] = "smallplanet.gif";
$planettypes[2] = "mediumplanet.gif";
$planettypes[3] = "largeplanet.gif";
$planettypes[4] = "hugeplanet.gif";
// New ship code
// Find out what my ship is
$res = $db->Execute("SELECT * FROM {$dbtables['ship_types']},{$dbtables['ships']} WHERE {$dbtables['ship_types']}.type_id={$dbtables['ships']}.type AND {$dbtables['ships']}.player_id={$playerinfo['player_id']} AND {$dbtables['ships']}.ship_id={$playerinfo['currentship']}");
$shipinfo = $res->fields;
// Mission Check
include "mission.php";
?>
<div align="center"><img src="images/startitle.gif" width=145 height=18>
<table border=0 cellspacing=0 cellpadding=0 bgcolor="<? echo $color_line2; ?>">
<tr>
<td align="center">
<? echo player_insignia_name($username);?>
<b>
<? echo $playerinfo[character_name]."</b>".$l_abord ?>
<b> <a href="report.php?kk=<? echo date("U")?>">
<? echo $shipinfo[ship_name] ?>
</a>
<?
$towedimage="";
if ($shipinfo[tow]>0) {
$res = $db->Execute("SELECT * FROM $dbtables[ships],$dbtables[ship_types] WHERE ship_id=$shipinfo[tow] AND type_id=type");
$towedship = $res->fields;
echo " towing the <font color=white>$towedship[ship_name]</font>";
$towedimage = "<img src=\"images/$towedship[image]\" border=0 width=60 height=45>";
}
?>
</b> </td>
