|
| 1 |
|
| 2 |
|
| 3 |
|
| 4 |
|
| 5 |
|
| 6 |
|
7 |
|
maxgala;
// Tabelle aufstellen
for ($j=1;$j<500;$j++) {
$galaxiearray[$j] = 0; // Datumstempel auf 0 setzen
$userarray[$j] = "unknown";
}
$query = "SELECT g.system, UNIX_TIMESTAMP(CONVERT_TZ(g.last_update, '+00:00', '".$_SESSION['s_timezone_offset']."')) as gtimestamp, DATE_FORMAT(CONVERT_TZ(g.last_update, '+00:00', '".$_SESSION['s_timezone_offset']."'), '%d. %m. %Y - %H:%i:%s') as glastupdate, u.username FROM $dbtablename g LEFT JOIN $utablename u ON (g.user_id=u.id) WHERE g.galaxy='$page' AND g.planet='1'";
$res = mysql_query($query) or die(mysql_error());
while ($line = mysql_fetch_object($res)) {
$galaxiearray[$line->system] = $line->gtimestamp;
$userarray[$line->system] = $line->username." ".STATUS_ON." ".$line->glastupdate;
}
echo "| ".USER_GALAXY.": \n";
draw_pagenumbers($page,$maxgala,1,$_SERVER['PHP_SELF'],"page");
echo " | \n";
$tablestring = "";
for ($j=1;$j<=50;$j++) {
$tablestring .= "\n";
for ($i=0;$i<10;$i++) {
if ($j+$i*50 == 500) {
$tablestring .= "| | \n";
break;
}
$title = $userarray[$j+$i*50];
if ($galaxiearray[$j+$i*50] == 0) $tablestring .= "$page:".($j+$i*50)." | \n"; // noch kein Eintrag
elseif ($galaxiearray[$j+$i*50] < (time() - 86400*30)) $tablestring .= "$page:".($j+$i*50)." | \n"; // 1 Monat und mehr
elseif ($galaxiearray[$j+$i*50] < (time() - 86400*14)) $tablestring .= "$page:".($j+$i*50)." | \n"; // 2-4 Wochen
elseif ($galaxiearray[$j+$i*50] < (time() - 86400*7)) $tablestring .= "$page:".($j+$i*50)." | \n"; // 1-2 Wochen
elseif ($galaxiearray[$j+$i*50] < (time() - 86400*4)) $tablestring .= "$page:".($j+$i*50)." | \n"; // 4-7 Tage
elseif ($galaxiearray[$j+$i*50] < (time() - 86400*2)) $tablestring .= "$page:".($j+$i*50)." | \n"; // 2-4 Tage
else $tablestring .= "$page:".($j+$i*50)." | \n";
}
$tablestring .= " \n";
}
$tablestring .=" \n";
echo "| $tablestring | ";
echo " |