php4 mit MySQL 5.1.3-alpha

#1

php4 mit MySQL 5.1.3-alpha

10.12.2005, 15:40

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.

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'>  </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 " Keine Incomings"; } else { @mysql_free_result($result); echo " Flotten Daten (Incoming)"; // 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'>".$line['ships']." +?Ships from[img]".$userlisteracedisplay."[/img]".$line['cluster_from'].".".$line['galaxy_from'].".".$line['planet_from']."".$herrscher."attacking[img]".$userlisteracedisplay2."[/img]".$line['cluster_to'].".".$line['galaxy_to'].".".$line['planet_to']."ETA ".$neweta." h( ".$line['battletime']." h attack )($zielzeit)"; echo ""; if($line['unit'] == 1) { echo "[url=".chr(34)."]U[/url]"; } else { echo ""; } echo ""; echo ""; if($line['news'] == 1) { echo "[url=".chr(34)."]N[/url]"; } else { echo ""; } echo ""; echo ""; if($line['mili'] == 1) { echo "[url=".chr(34)."]M[/url]"; } else { echo ""; } echo ""; echo "[i](Scanned)[/i]</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'>".$homeships." Ships from[img]".$userlisteracedisplay."[/img]".$prevfleetcoord."(Home Defense)defending[img]".$userlisteracedisplay."[/img]".$prevfleetcoord."ETA 0 h( ? h defend )(00.00.00 - 00 Uhr)</div>"; } echo "<div id='fleetsummary' class='fleet'>Summary at $prevfleetcoord$countattoutvs$countdefout</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)."'>".$line['ships']." +".$flstealther."Ships from[img]$userlisteracedisplay[/img]".$line['cluster_from'].".".$line['galaxy_from'].".".$line['planet_from']."".$line['player']."".$line['status']."[img]$userlisteracedisplay2[/img]".$line['cluster_to'].".".$line['galaxy_to'].".".$line['planet_to']."[ [b]".$line['battlehour']."[/b] / ".$line['battletime']." ] hours of ".$line['status']."($battlezielzeit)"; } 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)."'>".$line['ships']." +".$flstealther."Ships from[img]$userlisteracedisplay[/img]".$line['cluster_from'].".".$line['galaxy_from'].".".$line['planet_from']."".$line['player']."".$modus."[img]$userlisteracedisplay2[/img]".$line['cluster_to'].".".$line['galaxy_to'].".".$line['planet_to']."[ [b]".$battlehour."[/b] / ".$battletime." ] hours of ".$modus."($battlezielzeit)"; } else { echo "<div id='fleetdata' class='fleet ".substr($modus, 0, 3)."'>".$line['ships']." +".$flstealther."Ships from[img]$userlisteracedisplay[/img]".$line['cluster_from'].".".$line['galaxy_from'].".".$line['planet_from']."".$line['player']."".$modus."[img]$userlisteracedisplay2[/img]".$line['cluster_to'].".".$line['galaxy_to'].".".$line['planet_to']."ETA ".$etatime." h( ".$battletime." h ".substr($modus, 0, -3)." )($zielzeit)"; } } $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 ""; if($line2['time'] != null || $line2['time'] != '') { echo "[url=".chr(34)."]U[/url]"; } else { echo ""; } echo ""; @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 ""; if($line2['time'] != null || $line2['time'] != '') { echo "[url=".chr(34)."]N[/url]"; } else { echo ""; } echo ""; @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 ""; if($line2['time'] != null || $line2['time'] != '') { echo "[url=".chr(34)."]M[/url]"; } else { echo ""; } echo ""; @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 ""; if($line2['time'] != null || $line2['time'] != '') { echo "[url=".chr(34)."]R[/url]"; } else { echo ""; } echo ""; @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 ""; if($line2['time'] != null || $line2['time'] != '') { echo "[url=".chr(34)."]T[/url]"; } else { echo ""; } echo ""; @mysql_free_result($query2); if($moderator==1){ echo "<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>"; } else { echo ""; } 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'>".$homeships." Ships from[img]".$userlisteracedisplay."[/img]".$prevfleetcoord."(Home Defense)defending[img]".$userlisteracedisplay."[/img]".$prevfleetcoord."ETA 0 h( ? h defend )(00.00.00 - 00 Uhr)</div>"; } echo "<div id='fleetsummary' class='fleet'>Summary at $newfleetcoord$countattoutvs$countdefout</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 " Keine Outgoings"; sqldis($link, $result); } else { @mysql_free_result($result); echo " Flotten Daten (Outgoing)"; $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'>[img]".$userlisteracedisplay."[/img]".$homeships." Ships from".$line2['cluster_from'].".".$line2['galaxy_from'].".".$line2['planet_from']."".$line3['herrschername']."defending".$prevfleetcoord."ETA ".$eta." h( ".$line2['battletime']." h defend )($zielzeit)$unit$news$mili</div>"; } /* DEV */ //elseif(0 - $eta > $line2['battletime']) { /* Do nothing */ } /* else { $battlehour = 0 - $eta; echo "<div id='fleetdata' class='fleet def'>[img]".$userlisteracedisplay."[/img]".$homeships." Ships from".$line2['cluster_from'].".".$line2['galaxy_from'].".".$line2['planet_from']."".$line3['herrschername']."defending".$prevfleetcoord."[ [b]".$battlehour."[/b] / ".$line2['battletime']." ] hours of defending($battlezielzeit)$unit$news$mili</div>"; } } } @mysql_free_result($result2); */ if($countattout=="") { $countattout = 0; } if($countdefout=="") { $countdefout = 0; } if($prevfleetcoord!="" && $displayfleet == 1) { echo "<div id='fleetsummary' class='fleet'>Summary at $prevfleetcoord$countattoutvs$countdefout</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)."'>".$line['ships']." +".$flstealther."Ships from[img]$userlisteracedisplay[/img]".$line['cluster_from'].".".$line['galaxy_from'].".".$line['planet_from']."".$line['player']."".$line['status']."[img]$userlisteracedisplay2[/img]".$line['cluster_to'].".".$line['galaxy_to'].".".$line['planet_to']."[ [b]".$line['battlehour']."[/b] / ".$line['battletime']." ] hours of ".$modus."($battlezielzeit)"; } 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)."'>".$line['ships']." +".$flstealther."Ships from[img]$userlisteracedisplay[/img]".$line['cluster_from'].".".$line['galaxy_from'].".".$line['planet_from']."".$line['player']."".$line['status']."[img]$userlisteracedisplay2[/img]".$line['cluster_to'].".".$line['galaxy_to'].".".$line['planet_to']."ETA ".$etatime." hSNEAK-FLIGHT($zielzeit)"; } 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)."'>".$line['ships']." +".$flstealther."Ships from[img]$userlisteracedisplay[/img]".$line['cluster_from'].".".$line['galaxy_from'].".".$line['planet_from']."".$line['player']."".$modus."[img]$userlisteracedisplay2[/img]".$line['cluster_to'].".".$line['galaxy_to'].".".$line['planet_to']."ETA ".$line['eta']." hWaiting for Jump($zielzeit)"; } 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)."'>".$line['ships']." +".$flstealther."Ships from[img]$userlisteracedisplay[/img]".$line['cluster_from'].".".$line['galaxy_from'].".".$line['planet_from']."".$line['player']."".$modus."[img]$userlisteracedisplay2[/img]".$line['cluster_to'].".".$line['galaxy_to'].".".$line['planet_to']."[ [b]".$battlehour."[/b] / ".$battletime." ] hours of ".$modus."($battlezielzeit)"; } else { echo "<div id='fleetdata' class='fleet ".substr($modus, 0, 3)."'>".$line['ships']." +".$flstealther."Ships from[img]$userlisteracedisplay[/img]".$line['cluster_from'].".".$line['galaxy_from'].".".$line['planet_from']."".$line['player']."".$modus."[img]$userlisteracedisplay2[/img]".$line['cluster_to'].".".$line['galaxy_to'].".".$line['planet_to']."ETA ".$etatime." h( ".$combattime." h ".substr($modus, 0, -3)." )($zielzeit)"; } } } 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)."'>".$line['ships']." +".$flstealther."Ships from[img]$userlisteracedisplay[/img]".$line['cluster_from'].".".$line['galaxy_from'].".".$line['planet_from']."".$line['player']."".$modus."[img]$userlisteracedisplay2[/img]".$line['cluster_to'].".".$line['galaxy_to'].".".$line['planet_to']."[ [b]".$battlehour."[/b] / ".$battletime." ] hours of ".$modus."($battlezielzeit)"; } else { echo "<div id='fleetdata' class='fleet ".substr($modus, 0, 3)."'>".$line['ships']." +".$flstealther."Ships from[img]$userlisteracedisplay[/img]".$line['cluster_from'].".".$line['galaxy_from'].".".$line['planet_from']."".$line['player']."".$modus."[img]$userlisteracedisplay2[/img]".$line['cluster_to'].".".$line['galaxy_to'].".".$line['planet_to']."ETA ".$etatime." h( ".$battletime." h ".substr($modus, 0, -3)." )($zielzeit)"; } } $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 ""; if($line2['time'] != null || $line2['time'] != '') { echo "[url=".chr(34)."]U[/url]"; } else { echo ""; } echo ""; @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 ""; if($line2['time'] != null || $line2['time'] != '') { echo "[url=".chr(34)."]N[/url]"; } else { echo ""; } echo ""; @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 ""; if($line2['time'] != null || $line2['time'] != '') { echo "[url=".chr(34)."]M[/url]"; } else { echo ""; } echo ""; @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 ""; if($line2['time'] != null || $line2['time'] != '') { echo "[url=".chr(34)."]R[/url]"; } else { echo ""; } echo ""; @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 ""; if($line2['time'] != null || $line2['time'] != '') { echo "[url=".chr(34)."]T[/url]"; } else { echo ""; } echo ""; @mysql_free_result($query2); if($moderator==1){ echo "<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>"; } else { echo ""; } echo "</div>"; } // displayfleet } // while loop if($displayfleet == 0 && $displaygala != 'inc') { if($countattout=="") { $countattout = 0; } if($countdefout=="") { $countdefout = 0; } echo "<div id='fleetsummary' class='fleet'>Summary at $newfleetcoord$countattoutvs$countdefout</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);
Stichworte: -
#2

10.12.2005, 18:40

Bitte noch etwas mehr Code. Drei Seiten mehr sollten wohl genügen. Wenn sich das Board wegen der Länge weigert, ruhig über mehrere Postings verteilen :-S

vermutlich: http://dev.mysql.com/doc/refman/5.0/en/old-client.html
php4 ist in diesem Fall dann der "old client"
Kommentar
#3

10.12.2005, 18:47

@Bruchpilot
Du willst doch wohl nicht behaupten, dass dir die gut 1000 Zeile Quellcode einfach zu viel sind, um die mal eben durchzulesen, oder? Das verstehe ich aber echt nicht.

Gruß
phpfan
Kommentar
#4

10.12.2005, 18:52

Kommt immer auf den Code an

In diesem Fall sage ich nur: http://www.php.net/manual/en/language.types.array.php

Array do's and don'ts
Why is $foo[bar] wrong?

You should always use quotes around a string literal array index. For example, use $foo['bar'] and not $foo[bar]. But why is $foo[bar] wrong? You might have seen the following syntax in old scripts:
...
Kommentar
#5

10.12.2005, 19:42

PHP-Code:

echo " Gesamte Flottenbewegungen"; echo " "; foreach($totals as $key => $value) { $totalincatt = $value[inc][att][ships] + $value[inc][att][stealth]; $totalincdef = $value[inc][def][ships] + $value[inc][def][stealth]; $totaloutatt = $value[out][att][ships] + $value[out][att][stealth]; $totaloutdef = $value[out][def][ships] + $value[out][def][stealth]; $supertotal[inc][att][ships] += $value[inc][att][ships]; $supertotal[inc][att][stealth] += $value[inc][att][stealth]; $supertotal[inc][def][ships] += $value[inc][def][ships]; $supertotal[inc][def][stealth] += $value[inc][def][stealth]; $supertotal[out][att][ships] += $value[out][att][ships]; $supertotal[out][att][stealth] += $value[out][att][stealth]; $supertotal[out][def][ships] += $value[out][def][ships]; $supertotal[out][def][stealth] += $value[out][def][stealth]; echo "<div id='galaview' class='style'>"; echo "<div id='left'>Gala $key</div>"; echo "<div id='right'>"; echo "Attacker Incoming into Galaxy:$totalincatt[".$value[inc][att][ships]." +".$value[inc][att][stealth]."] Attacker Outgoing from Galaxy:$totaloutatt[".$value[out][att][ships]." +".$value[out][att][stealth]."] Defender Incoming into Galaxy:$totalincdef[".$value[inc][def][ships]." +".$value[inc][def][stealth]."] Defender Outgoing from Galaxy:$totaloutdef[".$value[out][def][ships]." +".$value[out][def][stealth]."] </div>"; echo "</div>"; } } // else if(count($totals) > 1) { $supertotalincatt = $supertotal[inc][att][ships] + $supertotal[inc][att][stealth]; $supertotalincdef = $supertotal[inc][def][ships] + $supertotal[inc][def][stealth]; $supertotaloutatt = $supertotal[out][att][ships] + $supertotal[out][att][stealth]; $supertotaloutdef = $supertotal[out][def][ships] + $supertotal[out][def][stealth]; // Final echo "<div id='galaview' class='style'>"; echo "<div id='left'>Ally Summary</div>"; echo "<div id='right'> Attacker Incoming into Ally:$supertotalincatt[".$supertotal[inc][att][ships]." +".$supertotal[inc][att][stealth]."] Attacker Outgoing from Ally:$supertotaloutatt[".$supertotal[out][att][ships]." +".$supertotal[out][att][stealth]."] Defender Incoming into Ally:$supertotalincdef[".$supertotal[inc][def][ships]." +".$supertotal[inc][def][stealth]."] Defender Outgoing from Ally:$supertotaloutdef[".$supertotal[out][def][ships]." +".$supertotal[out][def][stealth]."] </div>"; echo "</div>"; } //////////////////////// END MODULE ////////////////////////// /////////////////////////////////////////////////////////////// ?>

So das ist alles gewesen von der einen php datei
insgesamt habe ich 33 php datein aber die muss ich hier nicht alle posten. Ich hoffe das man daraus vieleicht erkennen kann woran das liegen könnte.

evtl kann ich noch nen test zugang legen oder am besten über TS² schildern was ich für ein problem habe.

Wer Intresse hat mir zu Helfen kann mich gerne eine igm schicken und dort die ip bekommen für den TS² zugang.

Gruß Nightwalker
Kommentar
#6

10.12.2005, 19:56

Ja, bitte nicht mehr Code - das war die Aussage.

Ich hoffe das man daraus vieleicht erkennen kann woran das liegen könnte.

evtl kann ich noch nen test zugang legen oder am besten über TS² schildern was ich für ein problem habe.

Die beiden Sahcen hast Du schon abgearbeitet?

Vermutlich: http://dev.mysql.com/doc/refman/5.0/en/old-client.html
php4 ist in diesem Fall dann der "old client"

In diesem Fall sage ich nur: http://www.php.net/manual/en/language.types.array.php
Kommentar

Vorherige Weiter

Ankündigung

php4 mit MySQL 5.1.3-alpha

Neue Werbung 2019

php4 mit MySQL 5.1.3-alpha

Kommentar

Kommentar

Kommentar

Kommentar

Kommentar