';
$query = "SELECT DATE_FORMAT(CONVERT_TZ(MAX(last_update), '+00:00', '".$_SESSION['s_timezone_offset']."'), '%d. %m. %Y - %H:%i:%s') as glast_update FROM $dbtablename WHERE user_id='".$userid."'";
$res = mysql_query($query) or die(mysql_error());
$line = mysql_fetch_object($res);
if (!empty($line->glast_update)) {
$last_galaxyupdate = $line->glast_update;
} else {
$last_galaxyupdate = "";
}
echo '
| '.USERINFO_TITLE.' |
| '.USERINFO_DETAIL.': |
'.$line->username.' |
| '.USERINFO_INGAME.': | '.$line->ingame.' |
| '.USERINFO_EMAIL.': | '.$line->email.' |
| '.USERINFO_ALLYTAG.': | '.$line->allytag.' |
| '.USERINFO_STYLEPATH.': | '.$line->stylepath.' |
| '.USERINFO_STATUS.': | '.$status.' |
| '.USERINFO_LOGINS.': | '.$line->logins.' |
| '.USERINFO_LASTLOGIN.': | '.$lastlogin.' | | '.USERINFO_LAST_GALAXYUPDATE.': | '.$last_galaxyupdate.' |
|
';
$query = "SELECT galaxy,count(*) as anzahl FROM $dbtablename WHERE user_id=$userid AND planet='1' GROUP BY galaxy ORDER BY galaxy";
$res = mysql_query($query) or die(mysql_error());
if (mysql_num_rows($res) == 0) {
echo ''."\n";
} else {
echo ''."\n";
while ($line = mysql_fetch_object($res)) {
echo ''."\n";
}
}
echo "| '.USERINFO_DATA.' |
| '.USERINFO_NODATA.' | | '.USERINFO_GALAXY.' | '.USERINFO_SYSTEMS.' | | '.$line->galaxy.' | '.$line->anzahl.' |
|
';
$query = "SELECT *,DATE_FORMAT(CONVERT_TZ(logintime, '+00:00', '".$_SESSION['s_timezone_offset']."'), '%d. %m. %Y - %H:%i:%s') as logintime_formated FROM $iptablename WHERE userid='$userid' ORDER BY logintime DESC";
$res = mysql_query($query) or die(mysql_error());
if (mysql_num_rows($res) == 0) {
echo '
';
} else {
echo ''."\n";
while ($line = mysql_fetch_object($res)) {
echo ''."\n";
}
}
echo "| '.USERINFO_IP.' |
| '.USERINFO_NOLOGIN.' | | '.USERINFO_IP.' | '.USERINFO_LOGINTIME.' | | '.$line->ip.' | '.$line->logintime_formated.' |
|