Hi,
ich bin neu hier und muss gestehen das ich absolut keine Ahnung habe von php bzw Linux.
Mein problem besteht darin das ich mein linux einen Update verpasst hatte sprich php4 standart von yast aus Installiert und phpmyadmin bzw MySQL 5.1.3-alpha von hand mit dieser gz usw...
Jetzt habe ich aber eine Page am laufen die auch sichtbar ist nur wenn man jetzt mit strg+c was kopiert aus einer hompage und das in meinen eingabefeld einfügen möchte macht er das wohl nur er gibt die nicht richtig aus.
Laut Install anleitung steht folgendes:
Requirements:
- MySQL 4.x (functionality not checked on versions minor than 4.0)
- PHP 4.3.x (preferable the latest working)
meine Frage ist jetzt ist meine sql zu neu wenn ja was müste man bei die php`s ändern damit die laufen.
um einen besseren verständniss zu bekommen kann ich auch ein zugang erstellen in der page wo dieser fehler ist.
einfach eine igm an mich.
hier mal ein schnipsel aus einer php datei vieleicht kann das ja helfen und ich brauche nur was ändern was identisch währe mit den anderen php datein.
ich bin neu hier und muss gestehen das ich absolut keine Ahnung habe von php bzw Linux.
Mein problem besteht darin das ich mein linux einen Update verpasst hatte sprich php4 standart von yast aus Installiert und phpmyadmin bzw MySQL 5.1.3-alpha von hand mit dieser gz usw...
Jetzt habe ich aber eine Page am laufen die auch sichtbar ist nur wenn man jetzt mit strg+c was kopiert aus einer hompage und das in meinen eingabefeld einfügen möchte macht er das wohl nur er gibt die nicht richtig aus.
Laut Install anleitung steht folgendes:
Requirements:
- MySQL 4.x (functionality not checked on versions minor than 4.0)
- PHP 4.3.x (preferable the latest working)
meine Frage ist jetzt ist meine sql zu neu wenn ja was müste man bei die php`s ändern damit die laufen.
um einen besseren verständniss zu bekommen kann ich auch ein zugang erstellen in der page wo dieser fehler ist.
einfach eine igm an mich.
hier mal ein schnipsel aus einer php datei vieleicht kann das ja helfen und ich brauche nur was ändern was identisch währe mit den anderen php datein.
PHP-Code:
<?php
$currenthour = mktime (date("H"),0,0,date("m"),date("d"),date("Y"));
$thishour = mktime(strftime("%H", $time),0,0,strftime("%m", $time),strftime("%d", $time),strftime("%y", $time));
$link = sqlcon();
/* Fleet Cleanup */
$query = "SELECT * FROM fleetdata;";
$result = @mysql_query($query);
while($line = @mysql_fetch_array($result, MYSQL_ASSOC))
{
$totaltime = $line['eta'] + $line['battletime'] + $line['combattime'];
$endtime = ($line['time'] + ($totaltime * 3600));
if($time > $endtime)
{
if($onetimer != 1) { $onetimer = 1; echo "Cleaning"; }
$query = "DELETE FROM fleetdata WHERE flightmode='".$line['flightmode']."' AND ships='".$line['ships']."' AND stealth='".$line['stealth']."' AND cluster_from='".$line['cluster_from']."' AND galaxy_from='".$line['galaxy_from']."' AND planet_from='".$line['planet_from']."' AND player='".$line['player']."' AND cluster_to='".$line['cluster_to']."' AND galaxy_to='".$line['galaxy_to']."' AND planet_to='".$line['planet_to']."' AND time='".$line['time']."';";
@mysql_query($query);
echo ".";
}
}
$query = "SELECT * FROM fleetscans;";
$result = @mysql_query($query);
while($line = @mysql_fetch_array($result, MYSQL_ASSOC))
{
$totaltime = $line['eta'] + $line['battletime'] + $line['combattime'];
$endtime = ($line['time'] + ($totaltime * 3600));
if($time > $endtime)
{
if($onetimer != 1) { $onetimer = 1; echo "Cleaning"; }
//$query = "DELETE FROM fleetscans WHERE unit='".$line['unit']."' AND news='".$line['news']."' AND mili='".$line['mili']."' AND ships='".$line['ships']."' AND time='".$line['time']."' AND cluster_from='".$line['cluster_from']."' AND galaxy_from='".$line['galaxy_from']."' AND planet_from='".$line['planet_from']."' AND fleet='".$line['fleet']."' AND battletype='".$line['battletype']."' AND cluster_to='".$line['cluster_to']."' AND galaxy_to='".$line['galaxy_to']."' AND planet_to='".$line['planet_to']."' AND eta='".$line['eta']."' AND battletime='".$line['battletime']."' AND cloaking='".$line['cloaking']."';";
$query = "DELETE FROM fleetscans WHERE cluster_from='".$line['cluster_from']."' AND galaxy_from='".$line['galaxy_from']."' AND planet_from='".$line['planet_from']."' AND fleet='".$line['fleet']."';";
@mysql_query($query);
echo ".";
}
}
/* Fleet Cleanup */
sqldis($link, $result);
if(isset($_GET['removeflin']) && $moderator == 1)
{
$link = sqlcon();
$remdet = explode(";", $_GET['removeflin']);
$query = "DELETE FROM fleetdata WHERE flightmode='0' AND ships='".$remdet[0]."' AND stealth='".$remdet[1]."' AND cluster_from='".$remdet[2]."' AND galaxy_from='".$remdet[3]."' AND planet_from='".$remdet[4]."' AND player='".base64_decode($remdet[5])."' AND cluster_to='".$remdet[6]."' AND galaxy_to='".$remdet[7]."' AND planet_to='".$remdet[8]."' AND time='".$remdet[9]."';";
@mysql_query($query);
$query = "DELETE FROM fleetscans WHERE cluster_from='".$remdet[2]."' AND galaxy_from='".$remdet[3]."' AND planet_from='".$remdet[4]."' AND cluster_to='".$remdet[6]."' AND galaxy_to='".$remdet[7]."' AND planet_to='".$remdet[8]."' AND time='".$remdet[9]."';";
@mysql_query($query);
$query = "INSERT INTO adminlogs VALUES ('".(time()+$gozeit)."', '".$_SESSION['authusername']."', 'FLEET INC Delete ".$remdet[0].";".$remdet[1].";".$remdet[2].";".$remdet[3].";".$remdet[4].";".base64_decode($remdet[5]).";".$remdet[6].";".$remdet[7].";".$remdet[8].";".$remdet[9]."');";
@mysql_query($query);
sqldis($link, $result);
echo "
Removed Fleet Data!
";
updatedb("fleetdata");
updatedb("adminlogs");
}
if(isset($_GET['removeflout']) && $moderator == 1)
{
$link = sqlcon();
$remdet = explode(";", $_GET['removeflout']);
$query = "DELETE FROM fleetdata WHERE flightmode='1' AND ships='".$remdet[0]."' AND stealth='".$remdet[1]."' AND cluster_from='".$remdet[2]."' AND galaxy_from='".$remdet[3]."' AND planet_from='".$remdet[4]."' AND player='".base64_decode($remdet[5])."' AND cluster_to='".$remdet[6]."' AND galaxy_to='".$remdet[7]."' AND planet_to='".$remdet[8]."' AND time='".$remdet[9]."';";
@mysql_query($query);
$query = "DELETE FROM fleetscans WHERE cluster_from='".$remdet[2]."' AND galaxy_from='".$remdet[3]."' AND planet_from='".$remdet[4]."' AND cluster_to='".$remdet[6]."' AND galaxy_to='".$remdet[7]."' AND planet_to='".$remdet[8]."' AND time='".$remdet[9]."';";
@mysql_query($query);
$query = "INSERT INTO adminlogs VALUES ('".(time()+$gozeit)."', '".$_SESSION['authusername']."', 'FLEET OUT Delete ".$remdet[0].";".$remdet[1].";".$remdet[2].";".$remdet[3].";".$remdet[4].";".base64_decode($remdet[5]).";".$remdet[6].";".$remdet[7].";".$remdet[8].";".$remdet[9]."');";
@mysql_query($query);
sqldis($link, $result);
echo "
Removed Fleet Data!
";
updatedb("fleetdata");
updatedb("adminlogs");
}
//////////////////////// LOAD MODULE //////////////////////////
////////////////// process fleet db storage ///////////////////
///////////////////////////////////////////////////////////////
?>
<script language='JavaScript'>
<!--
function popup(scan, timeage, coordinate, xw, xh, xs) {
window.open('<?php echo $filename; ?>.php?do='+scan+'&popup=scan&age='+timeage+'&show='+coordinate, 'scanfenster', 'toolbar=0,location=0,directories=0,status=0,menubar=0,scrollbars='+xs+',resizable=0,width='+xw+',height='+xh+',top=0,left=0');
}
//-->
</script>
<?php
$timeout2d = mktime (date("H"),date("i"),0,date("m"),date("d")-2,date("Y")) + $gozeit;
$link = sqlcon();
$query = "SELECT * FROM fleetdata LIMIT 0,1;";
$result = @mysql_query($query);
$line = @mysql_fetch_array($result, MYSQL_ASSOC);
if($line['time'] != null || $line['time'] != '')
{
echo "
Display Fleetmovement from Gala: ";
$query2 = "SELECT * FROM fleetdata;";
$result2 = @mysql_query($query2);
while ($line2 = @mysql_fetch_array($result2, MYSQL_ASSOC))
{
if($line2['flightmode'] == 0)
{
$flgala = $line2['cluster_to'].".".$line2['galaxy_to'];
}
else {
$flgala = $line2['cluster_from'].".".$line2['galaxy_from'];
}
if(!@in_array($flgala, $fl_gala)) {
$fl_gala[] = $flgala; }
}
@mysql_free_result($result2);
echo "[url='".$filename.".php?view=tactics&do=fleet&displaygala=inc']Inc[/url]";
echo "[url='".$filename.".php?view=tactics&do=fleet&displaygala=out']Out[/url]";
for($i=0;$i<count($fl_gala);$i++)
{
echo "[url='".$filename.".php?view=tactics&do=fleet&displaygala=$fl_gala[$i]']".$fl_gala[$i]."[/url]";
}
echo "
";
}
sqldis($link, $result);
$incomings = 0;
$link = sqlcon();
/* ------------------------------------------------------------------- */
/* ------------------------------------------------------------------- */
/* ------------------------------------------------------------------- */
$tempsql = "CREATE TEMPORARY TABLE IF NOT EXISTS `fleetcombo` (
`flightmode` enum('0','1') NOT NULL default '0',
`time` int(11) NOT NULL default '0',
`ships` int(11) NOT NULL default '0',
`stealth` int(11) default NULL,
`cluster_from` tinyint(2) NOT NULL default '0',
`galaxy_from` tinyint(2) NOT NULL default '0',
`planet_from` tinyint(2) NOT NULL default '0',
`player` varchar(120) NOT NULL default '(undefined)',
`status` enum('attacking','defending') default NULL,
`cluster_to` tinyint(2) NOT NULL default '0',
`galaxy_to` tinyint(2) NOT NULL default '0',
`planet_to` tinyint(2) NOT NULL default '0',
`eta` tinyint(2) default NULL,
`combattime` tinyint(1) default NULL,
`flighttype` enum('waiting','sneak') default NULL,
`battlehour` tinyint(1) default NULL,
`battletime` tinyint(1) default NULL,
`unit` tinyint(1) default NULL,
`news` tinyint(1) default NULL,
`mili` tinyint(1) default NULL,
`cloaking` enum('0','1') default NULL,
`fleet` enum('1','2','3') default NULL,
`battletype` enum('Attack','Defend','Return') default NULL,
`rasse_from` enum('trill','trillA','pred','atta','attaF','attaP') default NULL,
`rasse_to` enum('trill','trillA','pred','atta','attaF','attaP') default NULL,
PRIMARY KEY ( `flightmode`, `time`, `ships`, `cluster_from`, `galaxy_from`, `planet_from`, `cluster_to`, `galaxy_to`, `planet_to` )
) TYPE=MyISAM;";
$query = @mysql_query($tempsql);
/**********************************/
$query = "SELECT fleetdata.*,globalplayers.rasse AS rasse_from FROM fleetdata,globalplayers WHERE fleetdata.cluster_from=globalplayers.cluster AND fleetdata.galaxy_from=globalplayers.galaxy AND fleetdata.planet_from=globalplayers.planet AND flightmode = '0';";
$result = mysql_query($query);
while($line = mysql_fetch_array($result, MYSQL_ASSOC))
{
$query2 = "SELECT rasse AS rasse_to FROM globalplayers WHERE ".$line['cluster_to']."=cluster AND ".$line['galaxy_to']."=galaxy AND ".$line['planet_to']."=planet;";
$result2 = mysql_query($query2);
$line2 = mysql_fetch_array($result2, MYSQL_ASSOC);
mysql_free_result($result2);
//$player = preg_replace('@ - @', ' ', $line['player']);
$query = "INSERT INTO fleetcombo VALUES ('".$line['flightmode']."','".$line['time']."','".$line['ships']."','".$line['stealth']."','".$line['cluster_from']."','".$line['galaxy_from']."','".$line['planet_from']."','".$line['player']."','".$line['status']."','".$line['cluster_to']."','".$line['galaxy_to']."','".$line['planet_to']."','".$line['eta']."','".$line['combattime']."','".$line['flighttype']."','".$line['battlehour']."','".$line['battletime']."',null,null,null,null,null,null,'".$line['rasse_from']."','".$line2['rasse_to']."');";
mysql_query($query);
}
mysql_free_result($result);
/**********************************/
$query = "SELECT fleetdata.*,globalplayers.rasse AS rasse_from FROM fleetdata,globalplayers WHERE fleetdata.cluster_from=globalplayers.cluster AND fleetdata.galaxy_from=globalplayers.galaxy AND fleetdata.planet_from=globalplayers.planet AND flightmode = '1';";
$result = mysql_query($query);
while($line = mysql_fetch_array($result, MYSQL_ASSOC))
{
$store = 1;
if($line['status'] == 'defending')
{
$query2 = "SELECT * FROM fleetcombo WHERE ships='".$line['ships']."' AND cluster_from='".$line['cluster_from']."' AND galaxy_from='".$line['galaxy_from']."' AND planet_from='".$line['planet_from']."' AND cluster_to='".$line['cluster_to']."' AND galaxy_to='".$line['galaxy_to']."' AND planet_to='".$line['planet_to']."';";
$result2 = mysql_query($query2);
$line2 = mysql_fetch_array($result2, MYSQL_ASSOC);
mysql_free_result($result2);
if($line2['time'] != null)
{
$store = 0;
}
}
if($store == 1)
{
$inally = 0;
if($line['status'] == 'defending')
{
$politic = "SELECT id FROM politicstats WHERE cluster='".$line['cluster_to']."' AND galaxy='".$line['galaxy_to']."';";
$result2 = mysql_query($politic);
$line2 = mysql_fetch_array($result2, MYSQL_ASSOC);
mysql_free_result($result2);
if($line2['id'] != null) { $inally++; }
$politic = "SELECT id FROM politicstats WHERE cluster='".$line['cluster_from']."' AND galaxy='".$line['galaxy_from']."';";
$result2 = mysql_query($politic);
$line2 = mysql_fetch_array($result2, MYSQL_ASSOC);
mysql_free_result($result2);
if($line2['id'] != null) { $inally++; }
}
if($inally == 2) { $line['flightmode'] = 0; }
$query2 = "SELECT rasse AS rasse_to FROM globalplayers WHERE ".$line['cluster_to']."=cluster AND ".$line['galaxy_to']."=galaxy AND ".$line['planet_to']."=planet;";
$result2 = mysql_query($query2);
$line2 = mysql_fetch_array($result2, MYSQL_ASSOC);
mysql_free_result($result2);
//$player = preg_replace('@ - @', ' ', $line['player']);
$query = "INSERT INTO fleetcombo VALUES ('".$line['flightmode']."','".$line['time']."','".$line['ships']."','".$line['stealth']."','".$line['cluster_from']."','".$line['galaxy_from']."','".$line['planet_from']."','".$line['player']."','".$line['status']."','".$line['cluster_to']."','".$line['galaxy_to']."','".$line['planet_to']."','".$line['eta']."','".$line['combattime']."','".$line['flighttype']."','".$line['battlehour']."','".$line['battletime']."',null,null,null,null,null,null,'".$line['rasse_from']."','".$line2['rasse_to']."');";
mysql_query($query);
}
}
mysql_free_result($result);
/**********************************/
$query = "SELECT fleetscans.*,globalplayers.rasse AS rasse_from,globalplayers.herrschername FROM fleetscans,globalplayers WHERE fleetscans.cluster_from=globalplayers.cluster AND fleetscans.galaxy_from=globalplayers.galaxy AND fleetscans.planet_from=globalplayers.planet;";
$result = mysql_query($query);
while($line = mysql_fetch_array($result, MYSQL_ASSOC))
{
$politic = "SELECT id FROM politicstats WHERE cluster='".$line['cluster_to']."' AND galaxy='".$line['galaxy_to']."';";
$result2 = mysql_query($politic);
$line2 = mysql_fetch_array($result2, MYSQL_ASSOC);
mysql_free_result($result2);
$query3 = "SELECT rasse AS rasse_to FROM globalplayers WHERE ".$line['cluster_to']."=cluster AND ".$line['galaxy_to']."=galaxy AND ".$line['planet_to']."=planet;";
$result3 = mysql_query($query3);
$line3 = mysql_fetch_array($result3, MYSQL_ASSOC);
mysql_free_result($result3);
// Prüfe ob Flotteninc bereits vorhanden sind
$query4 = "SELECT * FROM fleetcombo WHERE cluster_to='".$line['cluster_to']."' AND galaxy_to='".$line['galaxy_to']."' AND planet_to='".$line['planet_to']."' AND cluster_from='".$line['cluster_from']."' AND galaxy_from='".$line['galaxy_from']."' AND planet_from='".$line['planet_from']."' AND ships='".$line['ships']."';";
$result4 = mysql_query($query4);
$line4 = mysql_fetch_array($result4, MYSQL_ASSOC);
mysql_free_result($result4);
if($line4['flightmode'] == null && $line4['flightmode'] == '')
{
if($line2['id'] != null && $line2['id'] != '')
{
$query = "INSERT INTO fleetcombo VALUES ('0','".$line['time']."','".$line['ships']."',null,'".$line['cluster_from']."','".$line['galaxy_from']."','".$line['planet_from']."','".$line['herrschername']."',null,'".$line['cluster_to']."','".$line['galaxy_to']."','".$line['planet_to']."','".$line['eta']."',null,null,null,'".$line['battletime']."','".$line['unit']."','".$line['news']."','".$line['mili']."','".$line['cloaking']."','".$line['fleet']."','".$line['battletype']."','".$line['rasse_from']."','".$line3['rasse_to']."');";
}
else
{
$query = "INSERT INTO fleetcombo VALUES ('1','".$line['time']."','".$line['ships']."',null,'".$line['cluster_from']."','".$line['galaxy_from']."','".$line['planet_from']."','".$line['herrschername']."',null,'".$line['cluster_to']."','".$line['galaxy_to']."','".$line['planet_to']."','".$line['eta']."',null,null,null,'".$line['battletime']."','".$line['unit']."','".$line['news']."','".$line['mili']."','".$line['cloaking']."','".$line['fleet']."','".$line['battletype']."','".$line['rasse_from']."','".$line3['rasse_to']."');";
}
mysql_query($query);
}
}
mysql_free_result($result);
/* ------------------------------------------------------------------- */
/* ------------------------------------------------------------------- */
/* ------------------------------------------------------------------- */
/*
echo "<hr>";
$query = "SELECT * FROM fleetcombo ORDER BY flightmode,cluster_from,galaxy_from,planet_from ASC;";
$result = mysql_query($query);
while($line = mysql_fetch_array($result, MYSQL_ASSOC))
{
print_r($line);
echo "
";
}
mysql_free_result($result);
echo "<hr>";
*/
/* ------------------------------------------------------------------- */
/* ------------------------------------------------------------------- */
/* ------------------------------------------------------------------- */
$query = "SELECT * FROM fleetcombo WHERE flightmode='0' LIMIT 0,1;";
$result = @mysql_query($query);
$line = @mysql_fetch_array($result, MYSQL_ASSOC);
$query2 = "SELECT time FROM fleetcombo WHERE battletype='Attack' ORDER BY time DESC LIMIT 0,1;";
$result2 = @mysql_query($query2);
$line2 = @mysql_fetch_array($result2, MYSQL_ASSOC);
if($line2['time'] > $timeout2d) { $incomings = 1; }
mysql_free_result($result2);
if($line['time'] == null || $line['time'] == '' && $incomings == 0)
{
echo "
<font size=+1>Keine Incomings</font>";
}
else
{
@mysql_free_result($result);
echo "
<font size=+1>Flotten Daten (Incoming)</font>";
// Check Incoming from Scan (no Fleetdata)
if($displaygala != 'out')
{
$query = "SELECT * FROM fleetcombo ORDER BY cluster_to,galaxy_to,planet_to ASC;";
$result = @mysql_query($query);
while($line = @mysql_fetch_array($result, MYSQL_ASSOC))
{
$correction = strftime("%H", $line['time']);
$correction = $correction + $line['eta'] + $line['combattime'];
$correctiontime = mktime($correction,0,0,strftime("%m", $line['time']),strftime("%d", $line['time']),strftime("%y", $line['time']));
if($correctiontime > $thishour && $line['battletype'] == 'Attack')
{
// Zeigt nur neue Fleetdaten
$query2 = "SELECT * FROM fleetcombo WHERE flightmode='0' AND cluster_from='".$line['cluster_from']."' AND galaxy_from='".$line['galaxy_from']."' AND planet_from='".$line['planet_from']."' AND cluster_to='".$line['cluster_to']."' AND galaxy_to='".$line['galaxy_to']."' AND planet_to='".$line['planet_to']."';";
$result2 = @mysql_query($query2);
$line2 = @mysql_fetch_array($result2, MYSQL_ASSOC);
if($line2['time'] == '' || $line2['time'] == null)
{
$correction = strftime("%H", $line['time']);
$correction = $correction + $line['eta'];
$correctiontime = mktime($correction,0,0,strftime("%m", $line['time']),strftime("%d", $line['time']),strftime("%y", $line['time']));
$neweta = strftime("%H", ($correctiontime - $thishour));
if(ereg("([0]{1})", $neweta[0])) { $neweta = substr($neweta, 1); } // delete leading 0
$neweta--; // Time Loss Correction
$zielzeit = strftime ("%d.%m.%y - %H Uhr", $correctiontime);
$userlisteracedisplay = "bg_empty.gif";
if($line['rasse_from'] != null)
{
$userlisteracedisplay = "bg_".$line['rasse_from'].".gif";
}
$userlisteracedisplay2 = "bg_empty.gif";
if($line['rasse_to'] != null)
{
$userlisteracedisplay2 = "bg_".$line['rasse_from'].".gif";
}
if($line['player'] == '') { $herrscher = '[i](Unknown)[/i]'; }
else { $herrscher = $line['player']; }
echo "<div id='fleetdata' class='fleet att'><span class='ships'>".$line['ships']." <font class='stealth'>+?</font></span><span class='text1'>Ships from</span><span>[img]".$userlisteracedisplay."[/img]</span><span class='coords'>".$line['cluster_from'].".".$line['galaxy_from'].".".$line['planet_from']."</span><span class='name'>".$herrscher."</span><span class='text2'>attacking</span><span>[img]".$userlisteracedisplay2."[/img]</span><span class='coords'>".$line['cluster_to'].".".$line['galaxy_to'].".".$line['planet_to']."</span><span class='eta'>ETA ".$neweta." h</span><span class='battle'>( ".$line['battletime']." h attack )</span><span class='time'>($zielzeit)</span>";
echo "<span class='link scan'>";
if($line['unit'] == 1)
{
echo "[url=".chr(34)."]U[/url]";
}
else { echo ""; }
echo "</span>";
echo "<span class='link scan'>";
if($line['news'] == 1)
{
echo "[url=".chr(34)."]N[/url]";
}
else { echo ""; }
echo "</span>";
echo "<span class='link scan'>";
if($line['mili'] == 1)
{
echo "[url=".chr(34)."]M[/url]";
}
else { echo ""; }
echo "</span>";
echo "</span><span class='link scan'></span><span class='link scan'></span><span class='transp'>[i](Scanned)[/i]</span></div>";
}
@mysql_free_result($result2);
}
}
@mysql_free_result($result);
}
$query = "SELECT * FROM fleetcombo WHERE flightmode='0' ORDER BY cluster_to,galaxy_to,planet_to,eta,cluster_from,galaxy_from,planet_from ASC;";
$result = @mysql_query($query);
while($line = @mysql_fetch_array($result, MYSQL_ASSOC))
{
$prevfleetcoord = $newfleetcoord;
$newfleetcoord = $line['cluster_to'].".".$line['galaxy_to'].".".$line['planet_to'];
if(isset($displaygala) && $displaygala=="".$line['cluster_to'].".".$line['galaxy_to']."") { $displayfleet = 1; }
elseif(isset($displaygala) && $displaygala=='inc') { $displayfleet = 1; }
if(!isset($displaygala)) { $displayfleet = 1; }
if($prevfleetcoord!=$newfleetcoord) { $dodisplay = 1;}
else { $dodisplay = 0; }
if($dodisplay==1)
{
if($countattout=="") { $countattout = 0; }
if($countdefout=="") { $countdefout = 0; }
if($prevfleetcoord!="" && $displayfleet == 1) {
// Check Home Defense
$homecoords = explode(".", $prevfleetcoord);
$query2 = "SELECT * FROM galafleetsum WHERE cluster='".$homecoords[0]."' AND galaxy='".$homecoords[1]."';";
$result2 = @mysql_query($query2);
$line2 = @mysql_fetch_array($result2, MYSQL_ASSOC);
@mysql_free_result($result2);
$homeships = $line2[$homecoords[2].'_pos'];
$query2 = "SELECT * FROM fleetcombo WHERE flightmode='1' AND cluster_from='".$homecoords[0]."' AND galaxy_from='".$homecoords[1]."' AND planet_from='".$homecoords[2]."';";
$result2 = @mysql_query($query2);
while($line2 = @mysql_fetch_array($result2, MYSQL_ASSOC))
{
if($line2['stealth'] != -1) { $homeships -= $line2['stealth']; }
$homeships -= $line2['ships'];
}
if($homeships > 0)
{
$query3 = "SELECT * FROM globalplayers WHERE cluster='".$homecoords[0]."' AND galaxy='".$homecoords[1]."' AND planet='".$homecoords[2]."';";
$result3 = @mysql_query($query3);
$line3 = @mysql_fetch_array($result3, MYSQL_ASSOC);
@mysql_free_result($result3);
$userlisteracedisplay = "bg_empty.gif";
if($line3['rasse'] != null)
{
$userlisteracedisplay = "bg_".$line3['rasse'].".gif";
}
$countdefout += $homeships;
echo "<div id='fleetdata' class='fleet def'><span class='ships'>".$homeships." </span><span class='text1'>Ships from</span><span>[img]".$userlisteracedisplay."[/img]</span><span class='coords'>".$prevfleetcoord."</span><span class='name'>(Home Defense)</span><span class='text2'>defending</span><span>[img]".$userlisteracedisplay."[/img]</span><span class='coords'>".$prevfleetcoord."</span><span class='eta'>ETA 0 h</span><span class='battle'>( ? h defend )</span><span class='time'>(00.00.00 - 00 Uhr)</span><span class='link scan'></span><span class='link scan'></span><span class='link scan'></span><span class='link scan'></span><span class='link scan'></span><span class='transp'></span></div>";
}
echo "<div id='fleetsummary' class='fleet'><span class='text'>Summary at $prevfleetcoord</span><span class='att zahl'>$countattout</span><span>vs</span><span class='def zahl'>$countdefout</span></div>";
}
unset($countattout, $countdefout);
}
if($displayfleet==1) {
$displayfleet = 0;
$correction = strftime("%H", $line['time']);
$correction = $correction + $line['eta'];
$correctiontime = mktime($correction,0,0,strftime("%m", $line['time']),strftime("%d", $line['time']),strftime("%y", $line['time']));
$zielzeit = strftime ("%d.%m.%y - %H Uhr", $correctiontime);
if($prevfleetcoord!=$newfleetcoord) { echo "<div id='fleetspacer'></div>"; }
// Count Ships
if($line['status'] == 'attacking')
{
if($line['stealth'] == -1) { $stealther = 0; }
else { $stealther = $line['stealth']; }
$countattout += $line['ships'] + $stealther;
}
else {
if($line['stealth'] == -1) { $stealther = 0; }
else { $stealther = $line['stealth']; }
$countdefout += $line['ships'] + $stealther;
}
// Check Stealther
if($line['stealth'] == -1) { $stealther = 0; $flstealther = "?"; }
else { $stealther = $line['stealth']; $flstealther = $line['stealth']; }
$fleetsum = $line['ships'] + $stealther;
// Check Battle or Eta
if ($line['battletime'] != 0 && $line['battlehour'] != 0)
{
$scanbattletime = $line['battletime'];
}
else {
$scanbattletime = $line['combattime'];
}
// Correct Virtual Ship Count from Scans
$query2 = "SELECT * FROM fleetcombo WHERE cluster_from='".$line['cluster_from']."' AND galaxy_from='".$line['galaxy_from']."' AND planet_from='".$line['planet_from']."' AND battletime='".$scanbattletime."' AND battletype='Attack' AND cluster_to='".$line['cluster_to']."' AND galaxy_to='".$line['galaxy_to']."' AND planet_to='".$line['planet_to']."';";
$result2 = @mysql_query($query2);
while($line2 = @mysql_fetch_array($result2, MYSQL_ASSOC))
{
if($line2['cloaking'] == 1)
{
$line2['ships'] -= $line['ships'] - $line['stealther'];
if($flstealther == '?') { $flstealther = $line2['ships'].' +'.$flstealther; }
else { $flstealther += $line2['ships']; }
$countattout += $line2['ships'];
}
else {
$line2['ships'] -= $line['ships'] - $line['stealther'];
if($flstealther == '?') { $flstealther = $line2['ships']; }
else { $flstealther += $line2['ships']; }
$countattout += $line2['ships'];
}
}
@mysql_free_result($result2);
// Set Race Icon
$userlisteracedisplay = "bg_empty.gif";
if($line['rasse_from'] != null)
{
$userlisteracedisplay = "bg_".$line['rasse_from'].".gif";
}
$userlisteracedisplay2 = "bg_empty.gif";
if($line['rasse_to'] != null)
{
$userlisteracedisplay2 = "bg_".$line['rasse_to'].".gif";
}
if ($line['battletime'] != 0 && $line['battlehour'] != 0)
{
$battlecorrection = $line['battletime'] + 1;
$battlecorrectiontime = mktime($correction+$battlecorrection,0,0,strftime("%m", $line['time']),strftime("%d", $line['time']),strftime("%y", $line['time']));
$battlezielzeit = strftime ("%d.%m.%y - %H Uhr", $battlecorrectiontime);
echo "<div id='fleetdata' class='fleet ".substr($line['status'], 0, -6)."'><span class='ships'>".$line['ships']." <font class='stealth'>+".$flstealther."</font></span><span class='text1'>Ships from</span><span>[img]$userlisteracedisplay[/img]</span><span class='coords'>".$line['cluster_from'].".".$line['galaxy_from'].".".$line['planet_from']."</span><span class='name'>".$line['player']."</span><span class='text2'>".$line['status']."</span><span>[img]$userlisteracedisplay2[/img]</span><span class='coords'>".$line['cluster_to'].".".$line['galaxy_to'].".".$line['planet_to']."</span><span class='inbattle'>[ [b]".$line['battlehour']."[/b] / ".$line['battletime']." ] hours of ".$line['status']."</span><span class='time'>($battlezielzeit)</span>";
}
else {
$starthour = mktime(strftime("%H", $line['time']),0,0,strftime("%m", $line['time']),strftime("%d", $line['time']),strftime("%y", $line['time']));
$arrivaltime = $starthour + ($line['eta'] * 3600);
$etatime = ( $arrivaltime - $thishour ) / 3600;
$finaltime = $arrivaltime + (($line['combattime'] + $line['battletime'])*3600);
if($line['status'] != null) { $modus = $line['status']; }
else { $modus = strtolower($line['battletype'])."ing"; }
if($line['combattime'] != null && $line['combattime'] > 0) { $battletime = $line['combattime']; }
else { $battletime = $line['battletime']; }
if($time > $arrivaltime)
{
$battlehour = ( ( $thishour - $arrivaltime ) / 3600 ) + 1;
$battlecorrection = $line['battletime']+$line['combattime'];
$battlecorrectiontime = mktime($correction+$battlecorrection,0,0,strftime("%m", $line['time']),strftime("%d", $line['time']),strftime("%y", $line['time']));
$battlezielzeit = strftime ("%d.%m.%y - %H Uhr", $battlecorrectiontime);
echo "<div id='fleetdata' class='fleet ".substr($modus, 0, 3)."'><span class='ships'>".$line['ships']." <font class='stealth'>+".$flstealther."</font></span><span class='text1'>Ships from</span><span>[img]$userlisteracedisplay[/img]</span><span class='coords'>".$line['cluster_from'].".".$line['galaxy_from'].".".$line['planet_from']."</span><span class='name'>".$line['player']."</span><span class='text2'>".$modus."</span><span>[img]$userlisteracedisplay2[/img]</span><span class='coords'>".$line['cluster_to'].".".$line['galaxy_to'].".".$line['planet_to']."</span><span class='inbattle'>[ [b]".$battlehour."[/b] / ".$battletime." ] hours of ".$modus."</span><span class='time'>($battlezielzeit)</span>";
}
else
{
echo "<div id='fleetdata' class='fleet ".substr($modus, 0, 3)."'><span class='ships'>".$line['ships']." <font class='stealth'>+".$flstealther."</font></span><span class='text1'>Ships from</span><span>[img]$userlisteracedisplay[/img]</span><span class='coords'>".$line['cluster_from'].".".$line['galaxy_from'].".".$line['planet_from']."</span><span class='name'>".$line['player']."</span><span class='text2'>".$modus."</span><span>[img]$userlisteracedisplay2[/img]</span><span class='coords'>".$line['cluster_to'].".".$line['galaxy_to'].".".$line['planet_to']."</span><span class='eta'>ETA ".$etatime." h</span><span class='battle'>( ".$battletime." h ".substr($modus, 0, -3)." )</span><span class='time'>($zielzeit)</span>";
}
}
$query2 = "SELECT time FROM unitscans WHERE cluster='".$line['cluster_from']."' AND galaxy='".$line['galaxy_from']."' AND planet='".$line['planet_from']."';";
$result2 = @mysql_query($query2);
$line2 = @mysql_fetch_array($result2, MYSQL_ASSOC);
echo "<span class='link scan'>";
if($line2['time'] != null || $line2['time'] != '')
{
echo "[url=".chr(34)."]U[/url]";
}
else { echo ""; }
echo "</span>";
@mysql_free_result($query2);
$query2 = "SELECT time FROM newsscans WHERE cluster='".$line['cluster_from']."' AND galaxy='".$line['galaxy_from']."' AND planet='".$line['planet_from']."';";
$result2 = @mysql_query($query2);
$line2 = @mysql_fetch_array($result2, MYSQL_ASSOC);
echo "<span class='link scan'>";
if($line2['time'] != null || $line2['time'] != '')
{
echo "[url=".chr(34)."]N[/url]";
}
else { echo ""; }
echo "</span>";
@mysql_free_result($query2);
$query2 = "SELECT time FROM miliscans WHERE cluster='".$line['cluster_from']."' AND galaxy='".$line['galaxy_from']."' AND planet='".$line['planet_from']."';";
$result2 = @mysql_query($query2);
$line2 = @mysql_fetch_array($result2, MYSQL_ASSOC);
echo "<span class='link scan'>";
if($line2['time'] != null || $line2['time'] != '')
{
echo "[url=".chr(34)."]M[/url]";
}
else { echo ""; }
echo "</span>";
@mysql_free_result($query2);
$query2 = "SELECT time FROM roidscans WHERE cluster='".$line['cluster_from']."' AND galaxy='".$line['galaxy_from']."' AND planet='".$line['planet_from']."';";
$result2 = @mysql_query($query2);
$line2 = @mysql_fetch_array($result2, MYSQL_ASSOC);
echo "<span class='link scan'>";
if($line2['time'] != null || $line2['time'] != '')
{
echo "[url=".chr(34)."]R[/url]";
}
else { echo ""; }
echo "</span>";
@mysql_free_result($query2);
$query2 = "SELECT time FROM techscans WHERE cluster='".$line['cluster_from']."' AND galaxy='".$line['galaxy_from']."' AND planet='".$line['planet_from']."';";
$result2 = @mysql_query($query2);
$line2 = @mysql_fetch_array($result2, MYSQL_ASSOC);
echo "<span class='link scan'>";
if($line2['time'] != null || $line2['time'] != '')
{
echo "[url=".chr(34)."]T[/url]";
}
else { echo ""; }
echo "</span>";
@mysql_free_result($query2);
if($moderator==1){
echo "<span class='remove'><a href=\"".$filename.".php?view=tactics&do=fleet&removeflin=".$line['ships'].";".$line['stealth'].";".$line['cluster_from'].";".$line['galaxy_from'].";".$line['planet_from'].";".base64_encode($line['player']).";".$line['cluster_to'].";".$line['galaxy_to'].";".$line['planet_to'].";".$line['time']."\">remove</a></span>";
}
else { echo "<span class='transp'></span>"; }
echo "</div>";
} // displayfleet
} // while loop
if($displayfleet == 0 && $displaygala != 'out')
{
if($countattout=="") { $countattout = 0; }
if($countdefout=="") { $countdefout = 0; }
// Check Home Defense
$homecoords = explode(".", $newfleetcoord);
$query2 = "SELECT * FROM galafleetsum WHERE cluster='".$homecoords[0]."' AND galaxy='".$homecoords[1]."';";
$result2 = @mysql_query($query2);
$line2 = @mysql_fetch_array($result2, MYSQL_ASSOC);
@mysql_free_result($result2);
$homeships = $line2[$homecoords[2].'_pos'];
$query2 = "SELECT * FROM fleetcombo WHERE flightmode='1' AND cluster_from='".$homecoords[0]."' AND galaxy_from='".$homecoords[1]."' AND planet_from='".$homecoords[2]."';";
$result2 = @mysql_query($query2);
while($line2 = @mysql_fetch_array($result2, MYSQL_ASSOC))
{
if($line2['stealth'] != -1) { $homeships -= $line2['stealth']; }
$homeships -= $line2['ships'];
}
if($homeships > 0)
{
$query3 = "SELECT * FROM globalplayers WHERE cluster='".$homecoords[0]."' AND galaxy='".$homecoords[1]."' AND planet='".$homecoords[2]."';";
$result3 = @mysql_query($query3);
$line3 = @mysql_fetch_array($result3, MYSQL_ASSOC);
@mysql_free_result($result3);
$userlisteracedisplay = "bg_empty.gif";
if($line3['rasse'] != null)
{
$userlisteracedisplay = "bg_".$line3['rasse'].".gif";
}
$countdefout += $homeships;
echo "<div id='fleetdata' class='fleet def'><span class='ships'>".$homeships." </span><span class='text1'>Ships from</span><span>[img]".$userlisteracedisplay."[/img]</span><span class='coords'>".$prevfleetcoord."</span><span class='name'>(Home Defense)</span><span class='text2'>defending</span><span>[img]".$userlisteracedisplay."[/img]</span><span class='coords'>".$prevfleetcoord."</span><span class='eta'>ETA 0 h</span><span class='battle'>( ? h defend )</span><span class='time'>(00.00.00 - 00 Uhr)</span><span class='link scan'></span><span class='link scan'></span><span class='link scan'></span><span class='link scan'></span><span class='link scan'></span><span class='transp'></span></div>";
}
echo "<div id='fleetsummary' class='fleet'><span class='text'>Summary at $newfleetcoord</span><span class='att zahl'>$countattout</span><span>vs</span><span class='def zahl'>$countdefout</span></div>";
unset($countattout, $countdefout);
}
} // else show incoming
////////////////////////////////////////////////////////////////////////////////////////////////
unset($dodisplay);
unset($newfleetcoord);
unset($prevfleetcoord);
////////////////////////////////////////////////////////////////////////////////////////////////
$query = "SELECT * FROM fleetcombo WHERE flightmode='1' LIMIT 0,1;";
$result = @mysql_query($query);
$line = @mysql_fetch_array($result, MYSQL_ASSOC);
if($line['time'] == null || $line['time'] == '')
{
echo "
<font size=+1>Keine Outgoings</font>";
sqldis($link, $result);
}
else
{
@mysql_free_result($result);
echo "
<font size=+1>Flotten Daten (Outgoing)</font>";
$query = "SELECT * FROM fleetcombo WHERE flightmode='1' ORDER BY cluster_to,galaxy_to,planet_to,cluster_from,galaxy_from,planet_from ASC;";
$result = @mysql_query($query);
while($line = @mysql_fetch_array($result, MYSQL_ASSOC))
{
$prevfleetcoord = $newfleetcoord;
$newfleetcoord = $line['cluster_to'].".".$line['galaxy_to'].".".$line['planet_to'];
if(isset($displaygala) && $displaygala=="".$line['cluster_to'].".".$line['galaxy_to']."") { $displayfleet = 1; }
elseif(isset($displaygala) && $displaygala=='out') { $displayfleet = 1; }
if(!isset($displaygala)) { $displayfleet = 1; }
if($prevfleetcoord!=$newfleetcoord) { $dodisplay = 1;}
else { $dodisplay = 0; }
if($dodisplay==1)
{
/* // Check Enemy Defense
$homecoords = explode(".", $prevfleetcoord);
$query2 = "SELECT * FROM fleetcombo WHERE cluster_to='".$homecoords[0]."' AND galaxy_to='".$homecoords[1]."' AND planet_to='".$homecoords[2]."';";
// $result2 = @mysql_query($query2);
while($line2 = @mysql_fetch_array($result2, MYSQL_ASSOC))
{
$homeships = $line2['ships'];
$countdefout += $homeships;
if($homeships > 0)
{
$query3 = "SELECT * FROM globalplayers WHERE cluster='".$homecoords[0]."' AND galaxy='".$homecoords[1]."' AND planet='".$homecoords[2]."';";
$result3 = @mysql_query($query3);
$line3 = @mysql_fetch_array($result3, MYSQL_ASSOC);
@mysql_free_result($result3);
switch($line3['rasse'])
{
case 'trill':
$userlisteracedisplay = "bg_trill.gif";
break;
case 'trillA':
$userlisteracedisplay = "bg_trillA.gif";
break;
case 'pred':
$userlisteracedisplay = "bg_pred.gif";
break;
case 'atta':
$userlisteracedisplay = "bg_atta.gif";
break;
case 'attaF':
$userlisteracedisplay = "bg_attaF.gif";
break;
case 'attaP':
$userlisteracedisplay = "bg_attaP.gif";
break;
default:
$userlisteracedisplay = "bg_empty.gif";
break;
}
$unit = "";
$news = "";
$mili = "";
if($line2['unit'] == 1)
{
$unit = "[url=".chr(34)."]U[/url]";
}
if($line2['news'] == 1)
{
$news = "[url=".chr(34)."]N[/url]";
}
if($line2['mili'] == 1)
{
$mili = "[url=".chr(34)."]M[/url]";
}
$correction = strftime("%H", $line2['time']);
$correction = $correction + $line2['eta'];
$correctiontime = mktime($correction,0,0,strftime("%m", $line2['time']),strftime("%d", $line2['time']),strftime("%y", $line2['time']));
$eta = ($correctiontime - $thishour) / 3600;
$zielzeit = strftime ("%d.%m.%y - %H Uhr", $correctiontime);
$battlezielzeit = strftime ("%d.%m.%y - %H Uhr", $correctiontime + ($line2['battletime'] * 3600));
if($eta > 0)
{
echo "<div id='fleetdata' class='fleet def'><span>[img]".$userlisteracedisplay."[/img]</span><span class='ships'>".$homeships." </span><span class='text1'>Ships from</span><span class='coords'>".$line2['cluster_from'].".".$line2['galaxy_from'].".".$line2['planet_from']."</span><span class='name'>".$line3['herrschername']."</span><span class='text2'>defending</span><span class='coords'>".$prevfleetcoord."</span><span class='eta'>ETA ".$eta." h</span><span class='battle'>( ".$line2['battletime']." h defend )</span><span class='time'>($zielzeit)</span><span class='link scan'>$unit</span><span class='link scan'>$news</span><span class='link scan'>$mili</span><span class='link scan'></span><span class='link scan'></span><span class='transp'></span></div>";
}
/* DEV */ //elseif(0 - $eta > $line2['battletime']) { /* Do nothing */ }
/* else {
$battlehour = 0 - $eta;
echo "<div id='fleetdata' class='fleet def'><span>[img]".$userlisteracedisplay."[/img]</span><span class='ships'>".$homeships." </span><span class='text1'>Ships from</span><span class='coords'>".$line2['cluster_from'].".".$line2['galaxy_from'].".".$line2['planet_from']."</span><span class='name'>".$line3['herrschername']."</span><span class='text2'>defending</span><span class='coords'>".$prevfleetcoord."</span><span class='inbattle'>[ [b]".$battlehour."[/b] / ".$line2['battletime']." ] hours of defending</span><span class='time'>($battlezielzeit)</span><span class='link scan'>$unit</span><span class='link scan'>$news</span><span class='link scan'>$mili</span><span class='link scan'></span><span class='link scan'></span><span class='transp'></span></div>";
}
}
}
@mysql_free_result($result2);
*/
if($countattout=="") { $countattout = 0; }
if($countdefout=="") { $countdefout = 0; }
if($prevfleetcoord!="" && $displayfleet == 1) {
echo "<div id='fleetsummary' class='fleet'><span class='text'>Summary at $prevfleetcoord</span><span class='att zahl'>$countattout</span><span>vs</span><span class='def zahl'>$countdefout</span></div>";
}
unset($countattout, $countdefout);
}
if($displayfleet==1) {
$displayfleet = 0;
$correction = strftime("%H", $line['time']);
$correction = $correction + $line['eta'] +0;
if($line['flighttype'] == 'waiting') { $correction++; }
$correctiontime = mktime($correction,0,0,strftime("%m", $line['time']),strftime("%d", $line['time']),strftime("%y", $line['time']));
$zielzeit = strftime ("%d.%m.%y - %H Uhr", $correctiontime);
if($prevfleetcoord!=$newfleetcoord) { echo "<div id='fleetspacer'></div>"; }
if($line['status'] == 'attacking')
{
if($line['stealth'] == -1) { $stealther = 0; }
else { $stealther = $line['stealth']; }
$countattout += $line['ships'] + $stealther;
}
else {
if($line['stealth'] == -1) { $stealther = 0; }
else { $stealther = $line['stealth']; }
$countdefout += $line['ships'] + $stealther;
}
if($line['stealth'] == -1) { $stealther = 0; $flstealther = "?"; }
else { $stealther = $line['stealth']; $flstealther = $line['stealth']; }
$fleetsum = $line['ships'] + $stealther;
// Set Race Icon
$userlisteracedisplay = "bg_empty.gif";
if($line['rasse_from'] != null)
{
$userlisteracedisplay = "bg_".$line['rasse_from'].".gif";
}
$userlisteracedisplay2 = "bg_empty.gif";
if($line['rasse_to'] != null)
{
$userlisteracedisplay2 = "bg_".$line['rasse_to'].".gif";
}
/*
$attdeff = 1;
$deffatt = 1;
$politic = "SELECT id FROM politicstats WHERE cluster='".$line['cluster_from']."' AND galaxy='".$line['galaxy_from']."';";
$result2 = mysql_query($politic);
$line2 = mysql_fetch_array($result2, MYSQL_ASSOC);
mysql_free_result($result2);
if($line2['id'] == null)
{
$attdeff = -1;
}
$politic = "SELECT id FROM politicstats WHERE cluster='".$line['cluster_to']."' AND galaxy='".$line['galaxy_to']."';";
$result2 = mysql_query($politic);
$line2 = mysql_fetch_array($result2, MYSQL_ASSOC);
mysql_free_result($result2);
if($line2['id'] == null)
{
$deffatt = -1;
}
if($attdeff == 1 && $deffatt == 1) { $modus = 'defending'; }
elseif($attdeff == 1 && $deffatt == -1) { $modus = 'attacking'; }
elseif($attdeff == -1 && $deffatt == 1) { $modus = 'attacking'; }
elseif($attdeff == -1 && $deffatt == -1) { $modus = 'defending'; }
*/
if($line['status'] != null) { $modus = $line['status']; }
else { $modus = strtolower($line['battletype'])."ing"; }
if ($line['battletime'] != 0 && $line['battlehour'] != 0)
{
$battlecorrection = $line['battletime'] + 1;
$battlecorrectiontime = mktime($correction+$battlecorrection,0,0,strftime("%m", $line['time']),strftime("%d", $line['time']),strftime("%y", $line['time']));
$battlezielzeit = strftime ("%d.%m.%y - %H Uhr", $battlecorrectiontime);
echo "<div id='fleetdata' class='fleet ".substr($modus, 0, 3)."'><span class='ships'>".$line['ships']." <font class='stealth'>+".$flstealther."</font></span><span class='text1'>Ships from</span><span>[img]$userlisteracedisplay[/img]</span><span class='coords'>".$line['cluster_from'].".".$line['galaxy_from'].".".$line['planet_from']."</span><span class='name'>".$line['player']."</span><span class='text2'>".$line['status']."</span><span>[img]$userlisteracedisplay2[/img]</span><span class='coords'>".$line['cluster_to'].".".$line['galaxy_to'].".".$line['planet_to']."</span><span class='inbattle'>[ [b]".$line['battlehour']."[/b] / ".$line['battletime']." ] hours of ".$modus."</span><span class='time'>($battlezielzeit)</span>";
}
elseif($line['flighttype'] == 'sneak')
{
$starthour = mktime(strftime("%H", $line['time']),0,0,strftime("%m", $line['time']),strftime("%d", $line['time']),strftime("%y", $line['time'])) + 3600;
$arrivaltime = $starthour + ($line['eta'] * 3600);
$etatime = (( $arrivaltime - $thishour ) / 3600 ) - 1;
echo "<div id='fleetdata' class='fleet ".substr($modus, 0, 3)."'><span class='ships'>".$line['ships']." <font class='stealth'>+".$flstealther."</font></span><span class='text1'>Ships from</span><span>[img]$userlisteracedisplay[/img]</span><span class='coords'>".$line['cluster_from'].".".$line['galaxy_from'].".".$line['planet_from']."</span><span class='name'>".$line['player']."</span><span class='text2'>".$line['status']."</span><span>[img]$userlisteracedisplay2[/img]</span><span class='coords'>".$line['cluster_to'].".".$line['galaxy_to'].".".$line['planet_to']."</span><span class='eta'>ETA ".$etatime." h</span><span class='sneak'>SNEAK-FLIGHT</span><span class='time'>($zielzeit)</span>";
}
elseif($line['flighttype'] == 'waiting')
{
$starthour = mktime(strftime("%H", $line['time']),0,0,strftime("%m", $line['time']),strftime("%d", $line['time']),strftime("%y", $line['time'])) + 3600;
if($thishour < $starthour)
{
echo "<div id='fleetdata' class='fleet ".substr($modus, 0, 3)."'><span class='ships'>".$line['ships']." <font class='stealth'>+".$flstealther."</font></span><span class='text1'>Ships from</span><span>[img]$userlisteracedisplay[/img]</span><span class='coords'>".$line['cluster_from'].".".$line['galaxy_from'].".".$line['planet_from']."</span><span class='name'>".$line['player']."</span><span class='text2'>".$modus."</span><span>[img]$userlisteracedisplay2[/img]</span><span class='coords'>".$line['cluster_to'].".".$line['galaxy_to'].".".$line['planet_to']."</span><span class='eta'>ETA ".$line['eta']." h</span><span class='jump'>Waiting for Jump</span><span class='time'>($zielzeit)</span>";
}
else
{
$arrivaltime = $starthour + ($line['eta'] * 3600);
$etatime = ( $arrivaltime - $thishour ) / 3600;
switch($line['status'])
{
case 'attacking':
if($time > $arrivaltime) { $battletime = '3'; }
else { $combattime = '3'; }
break;
case 'defending':
if($time > $arrivaltime) { $battletime = '6'; }
else { $combattime = '6'; }
break;
}
$finaltime = $arrivaltime + (($combattime + $battletime)*3600);
if($time > $arrivaltime)
{
$battlehour = ( $thishour - $arrivaltime ) / 3600;
$battlecorrection = $line['battletime']+$line['combattime'];
$battlecorrectiontime = mktime($correction+$battlecorrection,0,0,strftime("%m", $line['time']),strftime("%d", $line['time']),strftime("%y", $line['time']));
$battlezielzeit = strftime ("%d.%m.%y - %H Uhr", $battlecorrectiontime);
echo "<div id='fleetdata' class='fleet ".substr($modus, 0, 3)."'><span class='ships'>".$line['ships']." <font class='stealth'>+".$flstealther."</font></span><span class='text1'>Ships from</span><span>[img]$userlisteracedisplay[/img]</span><span class='coords'>".$line['cluster_from'].".".$line['galaxy_from'].".".$line['planet_from']."</span><span class='name'>".$line['player']."</span><span class='text2'>".$modus."</span><span>[img]$userlisteracedisplay2[/img]</span><span class='coords'>".$line['cluster_to'].".".$line['galaxy_to'].".".$line['planet_to']."</span><span class='inbattle'>[ [b]".$battlehour."[/b] / ".$battletime." ] hours of ".$modus."</span><span class='time'>($battlezielzeit)</span>";
}
else
{
echo "<div id='fleetdata' class='fleet ".substr($modus, 0, 3)."'><span class='ships'>".$line['ships']." <font class='stealth'>+".$flstealther."</font></span><span class='text1'>Ships from</span><span>[img]$userlisteracedisplay[/img]</span><span class='coords'>".$line['cluster_from'].".".$line['galaxy_from'].".".$line['planet_from']."</span><span class='name'>".$line['player']."</span><span class='text2'>".$modus."</span><span>[img]$userlisteracedisplay2[/img]</span><span class='coords'>".$line['cluster_to'].".".$line['galaxy_to'].".".$line['planet_to']."</span><span class='eta'>ETA ".$etatime." h</span><span class='battle'>( ".$combattime." h ".substr($modus, 0, -3)." )</span><span class='time'>($zielzeit)</span>";
}
}
}
else {
$starthour = mktime(strftime("%H", $line['time']),0,0,strftime("%m", $line['time']),strftime("%d", $line['time']),strftime("%y", $line['time']));
$arrivaltime = $starthour + ($line['eta'] * 3600);
$etatime = ( $arrivaltime - $thishour ) / 3600;
$finaltime = $arrivaltime + (($line['combattime'] + $line['battletime'])*3600);
if($line['combattime'] != null && $line['combattime'] > 0) { $battletime = $line['combattime']; }
else { $battletime = $line['battletime']; }
if($time > $arrivaltime)
{
$battlehour = ( ( $thishour - $arrivaltime ) / 3600 ) + 1;
$battlecorrection = $line['battletime']+$line['combattime'];
$battlecorrectiontime = mktime($correction+$battlecorrection,0,0,strftime("%m", $line['time']),strftime("%d", $line['time']),strftime("%y", $line['time']));
$battlezielzeit = strftime ("%d.%m.%y - %H Uhr", $battlecorrectiontime);
echo "<div id='fleetdata' class='fleet ".substr($modus, 0, 3)."'><span class='ships'>".$line['ships']." <font class='stealth'>+".$flstealther."</font></span><span class='text1'>Ships from</span><span>[img]$userlisteracedisplay[/img]</span><span class='coords'>".$line['cluster_from'].".".$line['galaxy_from'].".".$line['planet_from']."</span><span class='name'>".$line['player']."</span><span class='text2'>".$modus."</span><span>[img]$userlisteracedisplay2[/img]</span><span class='coords'>".$line['cluster_to'].".".$line['galaxy_to'].".".$line['planet_to']."</span><span class='inbattle'>[ [b]".$battlehour."[/b] / ".$battletime." ] hours of ".$modus."</span><span class='time'>($battlezielzeit)</span>";
}
else
{
echo "<div id='fleetdata' class='fleet ".substr($modus, 0, 3)."'><span class='ships'>".$line['ships']." <font class='stealth'>+".$flstealther."</font></span><span class='text1'>Ships from</span><span>[img]$userlisteracedisplay[/img]</span><span class='coords'>".$line['cluster_from'].".".$line['galaxy_from'].".".$line['planet_from']."</span><span class='name'>".$line['player']."</span><span class='text2'>".$modus."</span><span>[img]$userlisteracedisplay2[/img]</span><span class='coords'>".$line['cluster_to'].".".$line['galaxy_to'].".".$line['planet_to']."</span><span class='eta'>ETA ".$etatime." h</span><span class='battle'>( ".$battletime." h ".substr($modus, 0, -3)." )</span><span class='time'>($zielzeit)</span>";
}
}
$query2 = "SELECT time FROM unitscans WHERE cluster='".$line['cluster_to']."' AND galaxy='".$line['galaxy_to']."' AND planet='".$line['planet_to']."';";
$result2 = @mysql_query($query2);
$line2 = @mysql_fetch_array($result2, MYSQL_ASSOC);
echo "<span class='link scan'>";
if($line2['time'] != null || $line2['time'] != '')
{
echo "[url=".chr(34)."]U[/url]";
}
else { echo ""; }
echo "</span>";
@mysql_free_result($query2);
$query2 = "SELECT time FROM newsscans WHERE cluster='".$line['cluster_from']."' AND galaxy='".$line['galaxy_from']."' AND planet='".$line['planet_from']."';";
$result2 = @mysql_query($query2);
$line2 = @mysql_fetch_array($result2, MYSQL_ASSOC);
echo "<span class='link scan'>";
if($line2['time'] != null || $line2['time'] != '')
{
echo "[url=".chr(34)."]N[/url]";
}
else { echo ""; }
echo "</span>";
@mysql_free_result($query2);
$query2 = "SELECT time FROM miliscans WHERE cluster='".$line['cluster_to']."' AND galaxy='".$line['galaxy_to']."' AND planet='".$line['planet_to']."';";
$result2 = @mysql_query($query2);
$line2 = @mysql_fetch_array($result2, MYSQL_ASSOC);
echo "<span class='link scan'>";
if($line2['time'] != null || $line2['time'] != '')
{
echo "[url=".chr(34)."]M[/url]";
}
else { echo ""; }
echo "</span>";
@mysql_free_result($query2);
$query2 = "SELECT time FROM roidscans WHERE cluster='".$line['cluster_to']."' AND galaxy='".$line['galaxy_to']."' AND planet='".$line['planet_to']."';";
$result2 = @mysql_query($query2);
$line2 = @mysql_fetch_array($result2, MYSQL_ASSOC);
echo "<span class='link scan'>";
if($line2['time'] != null || $line2['time'] != '')
{
echo "[url=".chr(34)."]R[/url]";
}
else { echo ""; }
echo "</span>";
@mysql_free_result($query2);
$query2 = "SELECT time FROM techscans WHERE cluster='".$line['cluster_to']."' AND galaxy='".$line['galaxy_to']."' AND planet='".$line['planet_to']."';";
$result2 = @mysql_query($query2);
$line2 = @mysql_fetch_array($result2, MYSQL_ASSOC);
echo "<span class='link scan'>";
if($line2['time'] != null || $line2['time'] != '')
{
echo "[url=".chr(34)."]T[/url]";
}
else { echo ""; }
echo "</span>";
@mysql_free_result($query2);
if($moderator==1){
echo "<span class='remove'><a href=\"".$filename.".php?view=tactics&do=fleet&removeflout=".$line['ships'].";".$line['stealth'].";".$line['cluster_from'].";".$line['galaxy_from'].";".$line['planet_from'].";".base64_encode($line['player']).";".$line['cluster_to'].";".$line['galaxy_to'].";".$line['planet_to'].";".$line['time']."\">remove</a></span>";
}
else { echo "<span class='transp'></span>"; }
echo "</div>";
} // displayfleet
} // while loop
if($displayfleet == 0 && $displaygala != 'inc')
{
if($countattout=="") { $countattout = 0; }
if($countdefout=="") { $countdefout = 0; }
echo "<div id='fleetsummary' class='fleet'><span class='text'>Summary at $newfleetcoord</span><span class='att zahl'>$countattout</span><span>vs</span><span class='def zahl'>$countdefout</span></div>";
unset($countattout, $countdefout);
}
}
sqldis($link, $result);
//////////////////////// END MODULE //////////////////////////
///////////////////////////////////////////////////////////////
//////////////////////// LOAD MODULE //////////////////////////
///////////////dynamic gala fleet calculation /////////////////
///////////////////////////////////////////////////////////////
// Process Gala Databases
$link = sqlcon();
$query = "SELECT * FROM fleetdata LIMIT 0,1;";
$result = @mysql_query($query);
$line = @mysql_fetch_array($result, MYSQL_ASSOC);
if($line['time'] == null || $line['time'] == '')
{
sqldis($link, $result);
}
else
{
@mysql_free_result($result);
$query = "SELECT * FROM fleetdata ORDER BY cluster_from,galaxy_from,planet_from ASC;";
$result = @mysql_query($query);
while($line = @mysql_fetch_array($result, MYSQL_ASSOC))
{
if($line['status'] == 'attacking')
{
if($line['stealth'] == -1) { $stealther = 0; }
else { $stealther = $line['stealth']; }
}
else {
if($line['stealth'] == -1) { $stealther = 0; }
else { $stealther = $line['stealth']; }
}
switch($line['flightmode'])
{
case 0:
switch($line['status'])
{
case 'attacking':
$totals[$line['cluster_to'].".".$line['galaxy_to']][inc][att][ships] += $line['ships'];
$totals[$line['cluster_to'].".".$line['galaxy_to']][inc][att][stealth] += $stealther;
break;
case 'defending':
$totals[$line['cluster_to'].".".$line['galaxy_to']][inc][def][ships] += $line['ships'];
$totals[$line['cluster_to'].".".$line['galaxy_to']][inc][def][stealth] += $stealther;
break;
}
break;
case 1:
switch($line['status'])
{
case 'attacking':
$totals[$line['cluster_from'].".".$line['galaxy_from']][out][att][ships] += $line['ships'];
$totals[$line['cluster_from'].".".$line['galaxy_from']][out][att][stealth] += $stealther;
break;
case 'defending':
$totals[$line['cluster_from'].".".$line['galaxy_from']][out][def][ships] += $line['ships'];
$totals[$line['cluster_from'].".".$line['galaxy_from']][out][def][stealth] += $stealther;
break;
}
break;
}
}
sqldis($link, $result);
Kommentar