function touchPlanet(&$planet)
{
global $resource;
/*
No solo actualiza los recursos, tambien checkea los movimientos de flotas.
Pero solo los que le pertenecen. Checkeando los datos de los tiempos con
un pequeño loop si es necesario hacerlo.
*/
//por el momento vamos a resolver el problema de las flotas y la teoria
//de la lista sabana...
//primero, sabemos que tenemos una tabla especial. fleet.
//es cuestion de solo pedir los datos en cuanto al planeta.
//relacion comienzo y destino. y separarlo con el tiempo
doquery("LOCK TABLE {{table}}lunas WRITE, {{table}}rw WRITE, {{table}}errors WRITE, {{table}}messages WRITE, {{table}}fleets WRITE, {{table}}planets WRITE, {{table}}galaxy WRITE ,{{table}}users WRITE", "");
//doquery("LOCK TABLE {{table}} WRITE","fleets");
$fleetquery = doquery("SELECT * FROM {{table}} WHERE ((\n\t\tfleet_start_galaxy={$planet['galaxy']} AND\n\t\tfleet_start_system={$planet['system']} AND\n\t\tfleet_start_planet={$planet['planet']}\n\t\t) OR\n\t\t(\n\t\t\tfleet_end_galaxy={$planet['galaxy']} AND\n\t\t\tfleet_end_system={$planet['system']} AND\n\t\t\tfleet_end_planet={$planet['planet']})\n\t\t) AND\n\t\t(\n\t\tfleet_start_time<" . time() . " OR\n\t\tfleet_end_time<" . time() . "\n\t\t)", 'fleets');
//una vez que se cumple el requerimiento se realiza el loop de la muerte...
while ($f = mysql_fetch_array($fleetquery)) {
//no tengo idea de como seguir...
//depende del tipo de mision, se efectuan diferentes eventos.
switch ($f["fleet_mission"]) {
//
//--[1:Atacar]--------------------------------------------------
//
case 1:
if ($f['fleet_start_time'] <= time()) {
if ($f['fleet_mess'] == 0) {
global $user, $pricelist;
if (!isset($pricelist[202]["sd"])) {
message("<font color=\"red\">A vars.php kto podmieni?</font>", "error", "fleet." . $phpEx, 2);
}
$idwroga = doquery("SELECT * FROM {{table}} WHERE galaxy={$f['fleet_end_galaxy']} AND system={$f['fleet_end_system']} AND planet={$f['fleet_end_planet']}", 'planets', true);
$idwrog = $idwroga['id_owner'];
$atakujacy_user = doquery("SELECT * FROM {{table}} WHERE id={$f['fleet_owner']}", 'users', true);
$wrog_user = doquery("SELECT * FROM {{table}} WHERE id={$idwroga['id_owner']}", 'users', true);
$tech_wrog = doquery("SELECT `military_tech`, `defence_tech`, `shield_tech` FROM {{table}} WHERE id={$idwrog}", 'users', true);
$tech_atakujacy = doquery("SELECT `military_tech`, `defence_tech`, `shield_tech` FROM� {{table}} WHERE id={$f["fleet_owner"]}", 'users', true);
$jest_wrog = false;
for ($i = 200; $i < 500; $i++) {
if ($idwroga[$resource[$i]] > 0) {
$wrog[$i]["ilosc"] = $idwroga[$resource[$i]];
$jest_wrog = true;
}
}
$fleet = explode(";", $f['fleet_array']);
foreach ($fleet as $a => $b) {
if ($b != '') {
$a = explode(",", $b);
$atakujacy[$a[0]]["ilosc"] = $a[1];
}
}
global $phpEx, $ugamela_root_path, $pricelist;
include_once $ugamela_root_path . 'includes/ataki.' . $phpEx;
$mtime = microtime();
$mtime = explode(" ", $mtime);
$mtime = $mtime[1] + $mtime[0];
$starttime = $mtime;
$walka = walka($atakujacy, $wrog, $tech_atakujacy, $tech_wrog);
$mtime = microtime();
$mtime = explode(" ", $mtime);
$mtime = $mtime[1] + $mtime[0];
$endtime = $mtime;
$totaltime = $endtime - $starttime;
$atakujacy = $walka["atakujacy"];
$wrog = $walka["wrog"];
$wygrana = $walka["wygrana"];
$dane_do_rw = $walka["dane_do_rw"];
$zlom = $walka["zlom"];
$farray = "";
$famount = 0;
$pojemosc = 0;
foreach ($atakujacy as $a => $b) {
$pojemosc = $pojemosc + $pricelist[$a]["capacity"] * $b["ilosc"];
$farray .= "{$a},{$b["ilosc"]};";
$famount = $famount + $b["ilosc"];
}
$pojemosc = $pojemosc - $f["fleet_resource_metal"] - $f["fleet_resource_crystal"] - $f["fleet_resource_deuterium"];
$fquery = "";
if (!is_null($wrog)) {
foreach ($wrog as $a => $b) {
$fquery .= "{$resource[$a]}={$b["ilosc"]}, ";
}
}
$ladownia["metal"] = 0;
$ladownia["krysztal"] = 0;
$ladownia["deuter"] = 0;
if ($wygrana == "a") {
if ($pojemosc > 0) {
$metal = $idwroga["metal"] / 2;
$krysztal = $idwroga["crystal"] / 2;
$deuter = $idwroga["deuterium"] / 2;
if ($metal > $pojemosc / 3) {
$ladownia["metal"] = $pojemosc / 3;
$pojemosc = $pojemosc - $ladownia["metal"];
} else {
$ladownia["metal"] = $metal;
$pojemosc = $pojemosc - $ladownia["metal"];
}
if ($krysztal > $pojemosc / 2) {
$ladownia["krysztal"] = $pojemosc / 2;
$pojemosc = $pojemosc - $ladownia["krysztal"];
} else {
$ladownia["krysztal"] = $krysztal;
$pojemosc = $pojemosc - $ladownia["krysztal"];
}
if ($deuter > $pojemosc) {
$ladownia["deuter"] = $pojemosc;
$pojemosc = $pojemosc - $ladownia["deuter"];
} else {
$ladownia["deuter"] = $deuter;
$pojemosc = $pojemosc - $ladownia["deuter"];
}
}
}
$ladownia["metal"] = round($ladownia["metal"]);
$ladownia["krysztal"] = round($ladownia["krysztal"]);
$ladownia["deuter"] = round($ladownia["deuter"]);
//przeniesienie surowcow z planety do ladowni
doquery("UPDATE {{table}} SET {$fquery}\n\t\t\t\t\t\tmetal=metal - '{$ladownia["metal"]}',\n\t\t\t\t\t\tcrystal=crystal - '{$ladownia["krysztal"]}',\n\t\t\t\t\t\tdeuterium=deuterium - '{$ladownia["deuter"]}'\n\t\t\t\t\t\tWHERE galaxy={$f['fleet_end_galaxy']} \n\t\t\t\t\t\tAND system={$f['fleet_end_system']} \n\t\t\t\t\t\tAND planet={$f['fleet_end_planet']}\tLIMIT 1 ;", 'planets');
doquery("UPDATE {{table}} SET \n\t\t\t\t\t\tmetal=metal + '{$zlom["metal"]}',\n\t\t\t\t\t\tcrystal=crystal + '{$zlom["krysztal"]}'\n\t\t\t\t\t\tWHERE galaxy={$f['fleet_end_galaxy']} \n\t\t\t\t\t\tAND system={$f['fleet_end_system']} \n\t\t\t\t\t\tAND planet={$f['fleet_end_planet']}\tLIMIT 1 ;", 'galaxy');
//kod na moona od DxPpLmOs
$debris = $zlom["metal"] + $zlom["krysztal"];
$deb = "Agresor straci� ��cznie {$zlom["atakujacy"]} jednostek.<br>Obro�ca straci� ��cznie {$zlom["wrog"]} jednostek. <br> Na tych wsp�rz�dnych znajduje si� teraz {$zlom["metal"]} metalu i {$zlom["krysztal"]} kryszta�u.";
$szansa2 = $debris / 100000;
$enemyrow = doquery("SELECT * FROM {{table}} WHERE galaxy={$f['fleet_end_galaxy']} AND system={$f['fleet_end_system']} AND planet={$f['fleet_end_planet']}", 'planets', true);
$galenemyrow = doquery("SELECT * FROM {{table}} WHERE galaxy={$f['fleet_end_galaxy']} AND system={$f['fleet_end_system']} AND planet={$f['fleet_end_planet']}", 'galaxy', true);
$maxtemp = $enemyrow['temp_max'] - rand(10, 45);
$mintemp = $enemyrow['temp_min'] - rand(10, 45);
$sre = rand(4000, 10000);
if ($debris > 2000000) {
$szansa2 = 20;
}
if ($debris < 100000) {
$szansa = 0;
$szanmoon = "";
} elseif ($debris >= 100000) {
$szansa = rand(1, 100);
$szanmoon = "Szansa na powstanie ksi�yca wynosi {$szansa2} % ";
}
if ($szansa > 0 and $szansa <= $szansa2 and $galenemyrow['id_luna'] == 0) {
doquery("INSERT INTO {{table}} SET\n\t\t\t\t\t\t\t`name`='moon',\n\t\t\t\t\t\t\t`galaxy`='{$f['fleet_end_galaxy']}',\n\t\t\t\t\t\t\t`system`='{$f['fleet_end_system']}',\n\t\t\t\t\t\t\t`lunapos`='{$f['fleet_end_planet']}',\n\t\t\t\t\t\t\t`id_owner`='{$enemyrow['id_owner']}',\n\t\t\t\t\t\t\t`temp_max`='{$maxtemp}',\n\t\t\t\t\t\t\t`temp_min`='{$mintemp}',\n\t\t\t\t\t\t\t`diameter`='{$sre}',\n\t\t\t\t\t\t\t`id_luna`='{$f['fleet_start_time']}'", "lunas");
$lunarow = doquery("SELECT * FROM {{table}} WHERE galaxy={$f['fleet_end_galaxy']} AND system={$f['fleet_end_system']} AND lunapos={$f['fleet_end_planet']}", 'lunas', true);
doquery("UPDATE {{table}} SET \n\t\t\t\t\t\t\t`id_luna`='{$lunarow['id']}', \n\t\t\t\t\t\t\t`luna`='0' WHERE \n\t\t\t\t\t\t\t`galaxy`='{$f['fleet_end_galaxy']}' AND \n\t\t\t\t\t\t\t`system`='{$f['fleet_end_system']}' AND \n\t\t\t\t\t\t\t`planet`='{$f['fleet_end_planet']}'", "galaxy");
$powtal = "Gratulacje!!! z od�amk�w statk�w kr���cych woko�o planety {$enemyrow['name']} [{$f['fleet_end_galaxy']}:{$f['fleet_end_system']}:{$f['fleet_end_planet']}] zacz�� formowa� si� naturalny satelita";
} elseif ($szansa = 0 or $szansa > $szansa2) {
$powtal = "";
}
$raport = "<center><table><tr><td> Starcie z " . date("r", $f["fleet_start_time"]) . " nast�puj�cych flot::<br>";
includeLang('tech');
global $lang;
$zniszczony = false;
$a_zestrzelona = 0;
foreach ($dane_do_rw as $a => $b) {
$raport .= "<table border=1 width=100%><tr><th><br><center>Agresor {$atakujacy_user["username"]} ({$f['fleet_start_galaxy']}:{$f['fleet_start_system']}:{$f['fleet_start_planet']})<br>Bro�: " . (100 + $tech_atakujacy["military_tech"] * 10) . "% Tarcza: " . (100 + $tech_atakujacy["defence_tech"] * 10) . "% Os�ona: " . (100 + $tech_atakujacy["shield_tech"] * 10) . "% <table border=1>";
if ($b["atakujacy"]["ilosc"] > 0) {
$raport1 = "<tr><th>Typ</th>";
$raport2 = "<tr><th>Il.</th>";
$raport3 = "<tr><th>Uzbrojenie:</th>";
$raport4 = "<tr><th>Tarcza</th>";
$raport5 = "<tr><th>Os�ona</th>";
foreach ($b["atakujacy"] as $c => $d) {
if (is_numeric($c)) {
if ($d["ilosc"] > 0) {
$raport1 .= "<th>{$lang["tech"][$c]}</th>";
$raport2 .= "<th>{$d["ilosc"]}</th>";
$raport3 .= "<th>" . round($d["atak"] / $d["ilosc"]) . "</th>";
$raport4 .= "<th>" . round($d["tarcza"] / $d["ilosc"]) . "</th>";
$raport5 .= "<th>" . round($d["obrona"] / $d["ilosc"]) . "</th>";
}
}
}
$raport1 .= "</tr>";
$raport2 .= "</tr>";
$raport3 .= "</tr>";
$raport4 .= "</tr>";
$raport5 .= "</tr>";
$raport .= $raport1 . $raport2 . $raport3 . $raport4 . $raport5;
} else {
if ($a == 2) {
$a_zestrzelona = 1;
}
$zniszczony = true;
$raport .= "<br>Zniszczony";
}
$raport .= "</table></center></th></tr></table>";
$raport .= "<table border=1 width=100%><tr><th><br><center>Obronca {$wrog_user["username"]} ({$f['fleet_end_galaxy']}:{$f['fleet_end_system']}:{$f['fleet_end_planet']})<br>Bro�: " . (100 + $tech_wrog["military_tech"] * 10) . "% Tarcza: " . (100 + $tech_wrog["defence_tech"] * 10) . "% Os�ona: " . (100 + $tech_wrog["shield_tech"] * 10) . "% <table border=1>";
if ($b["wrog"]["ilosc"] > 0) {
$raport1 = "<tr><th>Typ</th>";
$raport2 = "<tr><th>Il.</th>";
$raport3 = "<tr><th>Uzbrojenie:</th>";
$raport4 = "<tr><th>Tarcza</th>";
$raport5 = "<tr><th>Os�ona</th>";
foreach ($b["wrog"] as $c => $d) {
if (is_numeric($c)) {
if ($d["ilosc"] > 0) {
$raport1 .= "<th>{$lang["tech"][$c]}</th>";
$raport2 .= "<th>{$d["ilosc"]}</th>";
$raport3 .= "<th>" . round($d["atak"] / $d["ilosc"]) . "</th>";
$raport4 .= "<th>" . round($d["tarcza"] / $d["ilosc"]) . "</th>";
$raport5 .= "<th>" . round($d["obrona"] / $d["ilosc"]) . "</th>";
}
}
}
$raport1 .= "</tr>";
$raport2 .= "</tr>";
$raport3 .= "</tr>";
$raport4 .= "</tr>";
$raport5 .= "</tr>";
$raport .= $raport1 . $raport2 . $raport3 . $raport4 . $raport5;
} else {
$zniszczony = true;
$raport .= "<br>Zniszczony";
}
$raport .= "</table></center></th></tr></table>";
if ($zniszczony == false and !($a == 8)) {
$raport .= "<br><center>Flota agresora strzeli�a z ca�kowit� si�� {$b["atakujacy"]["atak"]} w obro�c�. Tarcza obroncy przyjela {$b["wrog"]["tarcza"]}<br>\n\t\t\t\t\t\t\t\tFlota obro�cy strzeli�a z ca�kowit� si�� {$b["wrog"]["atak"]} w agresora.Tarcza agresora przyjela {$b["atakujacy"]["tarcza"]}</center>";
}
}
switch ($wygrana) {
case "a":
$raport .= "<p>Agresor wygra� bitw�!<br>Przejal:<br>Metal: {$ladownia["metal"]}<br>Kryszta�: {$ladownia["krysztal"]}<br>Deuter: {$ladownia["deuter"]}<br><p><br>{$deb} <br>{$szanmoon} <br>{$powtal}<br>";
break;
case "r":
$raport .= "<p>Remis!<br><p><br>{$deb} <br>{$szanmoon} <br>{$powtal}<br>";
break;
case "w":
$raport .= "<p>Obronca wygral bitwe!<br><p><br>{$deb} <br>{$szanmoon} <br>{$powtal}<br>";
doquery("DELETE FROM {{table}} WHERE fleet_id=" . $f["fleet_id"], 'fleets');
break;
default:
break;
}
$raport .= "Symulacja trwala {$totaltime} sekund<br>Battle report and battle simulation by jacekowski</table>";
//echo $raport;
$dpath = !$user["dpath"] ? DEFAULT_SKINPATH : $user["dpath"];
//$raport = "<html><head><link rel=\"stylesheet\" type=\"text/css\" href=\"".$dpath."/formate.css\"><meta http-equiv=\"content-type\" content=\"text/html; charset=iso-8859-2\" /> </head><body><center><table width=\"99%\"><tr><td>".$raport."</td></tr></table></center></body></html>";
$rid = md5($raport);
doquery("INSERT INTO {{table}} SET \n\t\t\t\t\t\t`time`=UNIX_TIMESTAMP(),\n\t\t\t\t\t\t`id_owner1`='{$f['fleet_owner']}',\n\t\t\t\t\t\t`id_owner2`='{$idwrog}',\n\t\t\t\t\t\t`rid`='{$rid}',\n\t\t\t\t\t\t`a_zestrzelona`='{$a_zestrzelona}',\n\t\t\t\t\t\t`raport`='" . mysql_escape_string($raport) . "'", 'rw');
//$raport = "<a class=\"thickbox\" href=\"rw.php?raport=".$rid."&keepThis=true&TB_iframe=true&height=400&width=500\">Raport</a>";
$raport = "<a class=\"thickbox\" href=\"rw.php?raport=" . $rid . "&keepThis=true&TB_iframe=true&height=400&width=500\"><font color=\"red\">Raport wojenny [{$f['fleet_end_galaxy']}:{$f['fleet_end_system']}:{$f['fleet_end_planet']}] (V:{$zlom["wrog"]},A:{$zlom["atakujacy"]})</font></a>";
$ladownia["metal"] = $ladownia["metal"] + $f["fleet_resource_metal"];
$ladownia["krysztal"] = $ladownia["krysztal"] + $f["fleet_resource_crystal"];
$ladownia["deuter"] = $ladownia["deuter"] + $f["fleet_resource_deuterium"];
$f["fleet_resource_metal"] = $ladownia["metal"];
$f["fleet_resource_crystal"] = $ladownia["krysztal"];
$f["fleet_resource_deuterium"] = $ladownia["deuter"];
doquery("UPDATE {{table}} SET \n\t\t\t\t\t\t`fleet_amount`='{$famount}', \n\t\t\t\t\t\t`fleet_array`='{$farray}',\n\t\t\t\t\t\t`fleet_resource_metal`='{$ladownia["metal"]}', \n\t\t\t\t\t\t`fleet_resource_crystal`='{$ladownia["krysztal"]}',\n\t\t\t\t\t\t`fleet_resource_deuterium`='{$ladownia["deuter"]}'\n\t\t\t\t\t\tWHERE fleet_id={$f['fleet_id']} \n\t\t\t\t\t\tLIMIT 1 ;", 'fleets');
doquery("INSERT INTO {{table}} SET \n\t\t\t\t\t\t`message_owner`='{$f['fleet_owner']}',\n\t\t\t\t\t\t`message_sender`='',\n\t\t\t\t\t\t`message_time`=UNIX_TIMESTAMP(),\n\t\t\t\t\t\t`message_type`='0',\n\t\t\t\t\t\t`message_from`='Dow�dztwo Floty',\n\t\t\t\t\t\t`message_subject`='Walka',\n\t\t\t\t\t\t`message_text`='{$raport}'", 'messages');
doquery("UPDATE {{table}} SET new_message=new_message+1 WHERE id='{$f['fleet_owner']}'", 'users');
doquery("INSERT INTO {{table}} SET \n\t\t\t\t\t\t`message_owner`='{$idwrog}',\n\t\t\t\t\t\t`message_sender`='',\n\t\t\t\t\t\t`message_time`=UNIX_TIMESTAMP(),\n\t\t\t\t\t\t`message_type`='0',\n\t\t\t\t\t\t`message_from`='Dow�dztwo Floty',\n\t\t\t\t\t\t`message_subject`='Walka',\n\t\t\t\t\t\t`message_text`='{$raport}'", 'messages');
doquery("UPDATE {{table}} SET new_message=new_message+1 WHERE id='{$idwrog}'", 'users');
doquery("UPDATE {{table}} SET fleet_mess='1' WHERE fleet_id=" . $f["fleet_id"], 'fleets');
}
if ($f['fleet_end_time'] <= time()) {
if (!is_null($atakujacy)) {
$fquery = "";
foreach ($atakujacy as $a => $b) {
$fquery .= "{$resource[$a]}={$resource[$a]} + {$b["ilosc"]}, ";
}
} else {
$fquery = "";
$fleet = explode(";", $f['fleet_array']);
foreach ($fleet as $a => $b) {
if ($b != '') {
$a = explode(",", $b);
$fquery .= "{$resource[$a[0]]}={$resource[$a[0]]} + {$a[1]}, \n";
}
}
}
doquery("DELETE FROM {{table}} WHERE fleet_id=" . $f["fleet_id"], 'fleets');
if (!($wygrana == "w")) {
doquery("UPDATE {{table}} SET\n\t\t\t\t\t\t\t{$fquery}\n\t\t\t\t\t\t\tmetal=metal + {$f['fleet_resource_metal']},\n\t\t\t\t\t\t\tcrystal=crystal + {$f['fleet_resource_crystal']},\n\t\t\t\t\t\t\tdeuterium=deuterium + {$f['fleet_resource_deuterium']}\n\t\t\t\t\t\t\tWHERE galaxy = {$f['fleet_start_galaxy']} AND\n\t\t\t\t\t\t\tsystem = {$f['fleet_start_system']} AND\n\t\t\t\t\t\t\tplanet = {$f['fleet_start_planet']}\n\t\t\t\t\t\t\tLIMIT 1 ;", 'planets');
doquery("INSERT INTO {{table}} SET\n\t\t\t\t\t\t\t`message_owner`='{$f['fleet_owner']}',\n\t\t\t\t\t\t\t`message_sender`='',\n\t\t\t\t\t\t\t`message_time`='{$f['fleet_end_time']}',\n\t\t\t\t\t\t\t`message_type`='0',\n\t\t\t\t\t\t\t`message_from`='Flottenkommando',\n\t\t\t\t\t\t\t`message_subject`='Flottenankunft',\n\t\t\t\t\t\t\t`message_text`='Eine Flotte ist von einem Angriff zur�ck gekommen. Es wurden {$f['fleet_resource_metal']} Metall, {$f['fleet_resource_crystal']} Kristall, {$f['fleet_resource_deuterium']} Deuterium auf deinem Planeten gutgeschrieben. '", 'messages');
doquery("UPDATE {{table}} SET new_message=new_message+1 WHERE id='{$f['fleet_owner']}'", 'users');
}
}
}
break;
//
//--[3:Transportar]--------------------------------------------------
//
//
//--[3:Transportar]--------------------------------------------------
//
case 3:
//bug...
//ARGHH!!! ok, transportar implica enviar solo recursos y volver.
//no es necesario revisar la flota.
//comprobamos el primer viaje :)
// $metal=$f['fleet_resource_metal'];
// $cristal=$f['fleet_resource_crystal'];
// $deuterium=$f['fleet_resource_deuterium'];
$messmojax = doquery("SELECT * FROM {{table}} WHERE galaxy={$f['fleet_start_galaxy']} AND system={$f['fleet_start_system']} AND planet={$f['fleet_start_planet']}", 'planets', true);
$messtwojax = doquery("SELECT * FROM {{table}} WHERE galaxy={$f['fleet_end_galaxy']} AND system={$f['fleet_end_system']} AND planet={$f['fleet_end_planet']}", 'planets', true);
$nazwamojej = $messmojax['name'];
$nazwatwojej = $messtwojax['name'];
if ($f['fleet_start_time'] <= time()) {
doquery("UPDATE {{table}} SET\n\t\t\t\t\t\tmetal=metal+{$f['fleet_resource_metal']},\n\t\t\t\t\t\tcrystal=crystal+{$f['fleet_resource_crystal']},\n\t\t\t\t\t\tdeuterium=deuterium+{$f['fleet_resource_deuterium']}\n\t\t\t\t\t\tWHERE galaxy = {$f['fleet_end_galaxy']} AND\n\t\t\t\t\t\tsystem = {$f['fleet_end_system']} AND\n\t\t\t\t\t\tplanet = {$f['fleet_end_planet']}\n\t\t\t\t\t\tLIMIT 1 ;", 'planets');
doquery("UPDATE {{table}} SET\n\t\t\t\t\t\tfleet_resource_metal=0,fleet_resource_crystal=0,fleet_resource_deuterium=0\n\t\t\t\t\t\tWHERE fleet_id = {$f['fleet_id']}\n\t\t\t\t\t\tLIMIT 1 ;", 'fleets');
if ($f["fleet_mess"] != "1") {
doquery("INSERT INTO {{table}} SET\n\t\t\t\t\t\t`message_owner`='{$f['fleet_owner']}',\n\t\t\t\t\t\t`message_sender`='',\n\t\t\t\t\t\t`message_time`='" . time() . "',\n\t\t\t\t\t\t`message_type`='0',\n\t\t\t\t\t\t`message_from`='Dow�dztwo floty',\n\t\t\t\t\t\t`message_subject`='Raport Transportu',\n\t\t\t\t\t\t`message_text`='Flota dotar�a do planety {$nazwatwojej} [{$f['fleet_end_galaxy']}:{$f['fleet_end_system']}:{$f['fleet_end_planet']}] i dostarczy�a surowce [Metal: {$f['fleet_resource_metal']} Kryszta�: {$f['fleet_resource_crystal']} Deuter: {$f['fleet_resource_deuterium']}]'", 'messages');
doquery("UPDATE {{table}} SET new_message=new_message+1 WHERE id='{$f['fleet_owner']}'", 'users');
doquery("UPDATE {{table}} SET fleet_mess='1' WHERE fleet_id=" . $f["fleet_id"], 'fleets');
}
if ($f['fleet_end_time'] <= time()) {
$fquery = "";
$fleet = explode(";", $f['fleet_array']);
foreach ($fleet as $a => $b) {
if ($b != '') {
$a = explode(",", $b);
$fquery .= "{$resource[$a[0]]}={$resource[$a[0]]} + {$a[1]}, \n";
}
}
doquery("UPDATE {{table}} SET\n\t\t\t\t\t\t\t{$fquery}\n\t\t\t\t\t\t\tmetal=metal,\n\t\t\t\t\t\t\tcrystal=crystal,\n\t\t\t\t\t\t\tdeuterium=deuterium\n\t\t\t\t\t\t\tWHERE galaxy = {$f['fleet_start_galaxy']} AND\n\t\t\t\t\t\t\tsystem = {$f['fleet_start_system']} AND\n\t\t\t\t\t\t\tplanet = {$f['fleet_start_planet']}\n\t\t\t\t\t\t\tLIMIT 1 ;", 'planets');
doquery("DELETE FROM {{table}} WHERE fleet_id=" . $f["fleet_id"], 'fleets');
if ($f["fleet_mess"] == "1") {
doquery("INSERT INTO {{table}} SET\n\t\t\t\t `message_owner`='{$f['fleet_owner']}',\n\t\t\t\t `message_sender`='',\n\t\t\t\t `message_time`='" . time() . "',\n\t\t\t\t `message_type`='0',\n\t\t\t\t `message_from`='Dow�dztwo floty',\n\t\t\t\t `message_subject`='Raport Transportu',\n\t\t\t\t `message_text`='Flota wr�ci�a na planet� {$nazwamojej} [{$f['fleet_start_galaxy']}:{$f['fleet_start_system']}:{$f['fleet_start_planet']}] bez surowc�w'", 'messages');
doquery("UPDATE {{table}} SET new_message=new_message+1 WHERE id='{$f['fleet_owner']}'", 'users');
doquery("UPDATE {{table}} SET fleet_mess='2' WHERE fleet_id=" . $f["fleet_id"], 'fleets');
}
}
}
break;
//
//--[4:Desplazar:Stacjonuj]--------------------------------------------------
//
//
//--[4:Desplazar:Stacjonuj]--------------------------------------------------
//
case 4:
if ($f['fleet_start_time'] <= time()) {
$fquery = "";
$fleet = explode(";", $f['fleet_array']);
foreach ($fleet as $a => $b) {
if ($b != '') {
$a = explode(",", $b);
$fquery .= $resource[$a[0]] . "=" . $resource[$a[0]] . " + " . $a[1] . ", \n";
}
}
doquery("DELETE FROM {{table}} WHERE fleet_id=" . $f["fleet_id"], 'fleets');
doquery("UPDATE {{table}} SET\n\t\t\t\t\t\t{$fquery}\n\t\t\t\t\t\tmetal=metal+{$f['fleet_resource_metal']},\n\t\t\t\t\t\tcrystal=crystal+{$f['fleet_resource_crystal']},\n\t\t\t\t\t\tdeuterium=deuterium+{$f['fleet_resource_deuterium']}\n\t\t\t\t\t\tWHERE galaxy = {$f['fleet_end_galaxy']} AND\n\t\t\t\t\t\tsystem = {$f['fleet_end_system']} AND\n\t\t\t\t\t\tplanet = {$f['fleet_end_planet']}\n\t\t\t\t\t\tLIMIT 1 ;", "planets");
}
break;
//
//--[5:Destruir]--------------------------------------------------
//
//
//--[5:Destruir]--------------------------------------------------
//
case 5:
//
//--[6:Espiar]--------------------------------------------------
//
//
//--[6:Espiar]--------------------------------------------------
//
case 6:
if ($f['fleet_start_time'] <= time()) {
$zestrzelona = false;
$szpiegja = doquery("SELECT * FROM {{table}} WHERE id={$f['fleet_owner']}", 'users', true);
$idwroga = doquery("SELECT * FROM {{table}} WHERE galaxy={$f['fleet_end_galaxy']} AND system={$f['fleet_end_system']} AND planet={$f['fleet_end_planet']}", 'planets', true);
$messmoja = doquery("SELECT * FROM {{table}} WHERE galaxy={$f['fleet_start_galaxy']} AND system={$f['fleet_start_system']} AND planet={$f['fleet_start_planet']}", 'planets', true);
$szpieg = $szpiegja['spy_tech'];
$idwrog = $idwroga['id_owner'];
$szpiegwrog = doquery("SELECT * FROM {{table}} WHERE id={$idwrog}", 'users', true);
$szpiegwroga = $szpiegwrog['spy_tech'];
$pozT = $szpieg;
$pozW = $szpiegwroga;
$fleet = explode(";", $f['fleet_array']);
$fquery = "";
foreach ($fleet as $a => $b) {
if ($b != '') {
$a = explode(",", $b);
$fquery .= "{$resource[$a[0]]}={$resource[$a[0]]} + {$a[1]}, \n";
if ($a[0] == "210") {
$LS = $a[1];
$debs = doquery("SELECT * FROM {{table}} WHERE galaxy={$f['fleet_end_galaxy']} AND system={$f['fleet_end_system']} AND planet={$f['fleet_end_planet']}", 'galaxy', true);
$debsc = $debs['crystal'];
$debss = 0;
$debss = $LS * 300;
//$all="<table width=400><tr><td class=c colspan=4> Surowce na {$idwroga['name']}[{$idwroga['galaxy']}:{$idwroga['system']}:{$idwroga['planet']}]".gmdate("d-m-Y H:i:s",time())."</td></tr>";
$surka = "<table width=440><tr><td class=c colspan=4> Surowce na {$idwroga['name']}[{$idwroga['galaxy']}:{$idwroga['system']}:{$idwroga['planet']}]" . gmdate("d-m-Y H:i:s", time() + 2 * 60 * 60) . "</td></tr><tr><td>Metal:</td><td>" . pretty_number($idwroga['metal']) . "</td><td>Kryszta�:</td><td>" . pretty_number($idwroga['crystal']) . "</td></tr> <tr><td>Deuter:</td><td>" . pretty_number($idwroga['deuterium']) . "</td> <td>Energia:</td><td>" . pretty_number($idwroga['energy_max']) . "</td></tr> </table>";
if ($idwroga['small_ship_cargo'] > "0") {
$mt = "<td>Ma�y Transporter</td><td>{$idwroga['small_ship_cargo']}</td>";
}
if ($idwroga['big_ship_cargo'] > "0") {
$dt = "<td>Du�y Transporter</td><td>{$idwroga['big_ship_cargo']}</td></tr>";
}
if ($idwroga['light_hunter'] > "0") {
$lm = "<td>Lekki My�liwiec</td><td>{$idwroga['light_hunter']}</td>";
}
if ($idwroga['heavy_hunter'] > "0") {
$cm = "<td>Ci�ki My�liwiec</td><td>{$idwroga['heavy_hunter']}</td></tr>";
}
if ($idwroga['crusher'] > "0") {
$kr = "<td>Kr��ownik</td><td>{$idwroga['crusher']}</td>";
}
if ($idwroga['battle_ship'] > "0") {
$ow = "<td>Okr�t Wojenny</td><td>{$idwroga['battle_ship']}</td></tr>";
}
if ($idwroga['colonizer'] > "0") {
$colon = "<td>Kolonizator</td><td>{$idwroga['colonizer']}</td>";
}
if ($idwroga['recycler'] > "0") {
$recek = "<td>Recykler</td><td>{$idwroga['recycler']}</td></tr>";
}
if ($idwroga['spy_sonde'] > "0") {
$spysonda = "<td>Sonda Szpiegowska</td><td>{$idwroga['spy_sonde']}</td>";
}
if ($idwroga['bomber_ship'] > "0") {
$bombo = "<td>Bombowiec</td><td>{$idwroga['bomber_ship']}</td></tr>";
}
if ($idwroga['solar_satelit'] > "0") {
$satki = "<td>Satelita S�oneczny</td><td>{$idwroga['solar_satelit']}</td>";
}
if ($idwroga['destructor'] > "0") {
$niszcz = "<td>Niszczyciel</td><td>{$idwroga['destructor']}</td></tr>";
}
if ($idwroga['dearth_star'] > "0") {
$gwiazdeczka = "<td>Gwiazda �mierci</td><td>{$idwroga['dearth_star']}</td>";
}
if ($idwroga['battleship'] > "0") {
$panc = "<td>Pancernik</td><td>{$idwroga['battleship']}</td></tr>";
}
//if($idwroga['silo'] > "0"){$silos="<td>Silos Rakietowy</td><td>{$idwroga['silo']}</td></tr>";}
$floty = "<table width=440><tr><td class=c colspan=4> Surowce na {$idwroga['name']}[{$idwroga['galaxy']}:{$idwroga['system']}:{$idwroga['planet']}]" . gmdate("d-m-Y H:i:s", time() + 2 * 60 * 60) . "</td></tr><tr><td>Metal:</td><td>" . pretty_number($idwroga['metal']) . "</td><td>Kryszta�:</td><td>" . pretty_number($idwroga['crystal']) . "</td></tr> <tr><td>Deuter:</td><td>" . pretty_number($idwroga['deuterium']) . "</td> <td>Energia:</td><td>" . pretty_number($idwroga['energy_max']) . "</td></tr> </table><table width=440><tr><td class=c colspan=6>Floty</td></tr>{$mt}{$dt}{$lm}{$cm}{$kr}{$ow}{$colon}{$recek}{$spysonda}{$bombo}{$satki}{$niszcz}{$gwiazdeczka}{$panc} </table>";
if ($idwroga['misil_launcher'] > "0") {
$ml = "<td>Wyrzutnia Rakiet</td><td>{$idwroga['misil_launcher']}</td>";
}
if ($idwroga['small_laser'] > "0") {
$sl = "<td>Lekkie Dzia�o Laserowe</td><td>{$idwroga['small_laser']}</td></tr>";
}
if ($idwroga['big_laser'] > "0") {
$bl = "<td>Cie�kie Dzia�o Laserowe</td><td>{$idwroga['big_laser']}</td>";
}
if ($idwroga['gauss_canyon'] > "0") {
$gauss = "<td>Dzia�o Gaussa</td><td>{$idwroga['gauss_canyon']}</td></tr>";
}
if ($idwroga['ionic_canyon'] > "0") {
$ionic = "<td>Dzia�o Jonowe</td><td>{$idwroga['ionic_canyon']}</td>";
}
if ($idwroga['buster_canyon'] > "0") {
$buster = "<td>Wyrzutnia Plazmy</td><td>{$idwroga['buster_canyon']}</td></tr>";
}
if ($idwroga['small_protection_shield'] > "0") {
$mp = "<td>Ma�a Pow�oka Ochronna</td><td>{$idwroga['small_protection_shield']}</td>";
}
if ($idwroga['big_protection_shield'] > "0") {
$dp = "<td>Du�a Pow�oka Ochronna</td><td>{$idwroga['big_protection_shield']}</td>";
}
$obrona = "<table width=440><tr><td class=c colspan=4> Surowce na {$idwroga['name']}[{$idwroga['galaxy']}:{$idwroga['system']}:{$idwroga['planet']}]" . gmdate("d-m-Y H:i:s", time() + 2 * 60 * 60) . "</td></tr><tr><td>Metal:</td><td>" . pretty_number($idwroga['metal']) . "</td><td>Kryszta�:</td><td>" . pretty_number($idwroga['crystal']) . "</td></tr> <tr><td>Deuter:</td><td>" . pretty_number($idwroga['deuterium']) . "</td> <td>Energia:</td><td>" . pretty_number($idwroga['energy_max']) . "</td></tr> </table><table width=440><tr><td class=c colspan=6>Floty</td></tr>{$mt}{$dt}{$lm}{$cm}{$kr}{$ow}{$colon}{$recek}{$spysonda}{$bombo}{$satki}{$niszcz}{$gwiazdeczka}{$panc} </table> <table width=440><tr><td class=c colspan=4>Obrona</td></tr>{$ml}{$sl}{$bl}{$gauss}{$ionic}{$buster}{$mp}{$dp} </table>";
if ($idwroga['metal_mine'] > "0") {
$kop_metal = "<td>Kopalnia metalu</td><td>{$idwroga['metal_mine']}</td>";
}
if ($idwroga['crystal_mine'] > "0") {
$kop_krysia = "<td>Kopalnia kryszta�u</td><td>{$idwroga['crystal_mine']}</td>";
}
if ($idwroga['deuterium_sintetizer'] > "0") {
$kop_deut = "<td>Ekstraktor Deuteru</td><td>{$idwroga['deuterium_sintetizer']}</td></tr>";
}
if ($idwroga['solar_plant'] > "0") {
$solar = "<td>Elektrownia S�oneczna</td><td>{$idwroga['solar_plant']}</td>";
}
if ($idwroga['fusion_plant'] > "0") {
$fusion = "<td>Elektrownia Fuzyjna</td><td>{$idwroga['fusion_plant']}</td>";
}
if ($idwroga['robot_factory'] > "0") {
$robot = "<td>Fabryka Robot�w</td><td>{$idwroga['robot_factory']}</td></tr>";
}
if ($idwroga['nano_factory'] > "0") {
$nano = "<td>Fabryka Nanit�w</td><td>{$idwroga['nano_factory']}</td>";
}
if ($idwroga['hangar'] > "0") {
$stocznia = "<td>Stocznia</td><td>{$idwroga['hangar']}</td>";
}
if ($idwroga['metal_store'] > "0") {
$mag_mety = "<td>Magazyn Metalu</td><td>{$idwroga['metal_store']}</td></tr>";
}
if ($idwroga['crystal_store'] > "0") {
$mag_krysi = "<td>Magazyn Kryszta�u</td><td>{$idwroga['crystal_store']}</td>";
}
if ($idwroga['deuterium_store'] > "0") {
$mag_deut = "<td>Magazyn Deuteru</td><td>{$idwroga['deuterium_store']}</td>";
}
if ($idwroga['laboratory'] > "0") {
$lab = "<td>Laboratorium</td><td>{$idwroga['laboratory']}</td></tr>";
}
if ($idwroga['terraformer'] > "0") {
$tetra = "<td>Terraformer</td><td>{$idwroga['terraformer']}</td>";
}
if ($idwroga['ally_deposit'] > "0") {
$allydepo = "<td>Depozyt Sojuszniczy</td><td>{$idwroga['ally_deposit']}</td>";
}
if ($idwroga['silo'] > "0") {
$silos = "<td>Silos Rakietowy</td><td>{$idwroga['silo']}</td></tr>";
}
$budynki = "<table width=440><tr><td class=c colspan=4> Surowce na {$idwroga['name']}[{$idwroga['galaxy']}:{$idwroga['system']}:{$idwroga['planet']}]" . gmdate("d-m-Y H:i:s", time() + 2 * 60 * 60) . "</td></tr><tr><td>Metal:</td><td>" . pretty_number($idwroga['metal']) . "</td><td>Kryszta�:</td><td>" . pretty_number($idwroga['crystal']) . "</td></tr> <tr><td>Deuter:</td><td>" . pretty_number($idwroga['deuterium']) . "</td> <td>Energia:</td><td>" . pretty_number($idwroga['energy_max']) . "</td></tr> </table><table width=440><tr><td class=c colspan=6>Floty</td></tr>{$mt}{$dt}{$lm}{$cm}{$kr}{$ow}{$colon}{$recek}{$spysonda}{$bombo}{$satki}{$niszcz}{$gwiazdeczka}{$panc} </table> <table width=440><tr><td class=c colspan=4>Obrona</td></tr>{$ml}{$sl}{$bl}{$gauss}{$ionic}{$buster}{$mp}{$dp} </table> <table width=440><tr><td class=c colspan=6>Budynki</td></tr></tr>{$kop_metal}{$kop_krysia}{$kop_deut}{$solar}{$fusion}{$robot}{$nano}{$stocznia}{$mag_mety}{$mag_krysi}{$mag_deut}{$lab}{$tetra}{$allydepo}{$silos}</table>";
if ($szpiegwrog['spy_tech'] > "0") {
$spy_tech = "<td>Technologia Szpiegowska</td><td>{$szpiegwrog['spy_tech']}</td>";
}
if ($szpiegwrog['computer_tech'] > "0") {
$pc_tech = "<td>Technologia Komputerowa</td><td>{$szpiegwrog['computer_tech']}</td></tr>";
}
if ($szpiegwrog['military_tech'] > "0") {
$boj_tech = "<td>Technologia Bojowa</td><td>{$szpiegwrog['military_tech']}</td>";
}
if ($szpiegwrog['defence_tech'] > "0") {
$obr_tech = "<td>Technologia Obronna</td><td>{$szpiegwrog['defence_tech']}</td></tr>";
}
if ($szpiegwrog['shield_tech'] > "0") {
$op_tech = "<td>Opancerzenie</td><td>{$szpiegwrog['shield_tech']}</td>";
}
if ($szpiegwrog['energy_tech'] > "0") {
$ene_tech = "<td>Technologia Energetyczna</td><td>{$szpiegwrog['energy_tech']}</td></tr>";
}
if ($szpiegwrog['hyperspace_tech'] > "0") {
$nadp_tech = "<td>Technologia Nadprzestrzenna</td><td>{$szpiegwrog['hyperspace_tech']}</td>";
}
if ($szpiegwrog['combustion_tech'] > "0") {
$spal_tech = "<td>Nap�d Spalinowy</td><td>{$szpiegwrog['combustion_tech']}</td></tr>";
}
if ($szpiegwrog['impulse_motor_tech'] > "0") {
$imp_tech = "<td>Nap�d Impulsowy</td><td>{$szpiegwrog['impulse_motor_tech']}</td>";
}
if ($szpiegwrog['hyperspace_motor_tech'] > "0") {
$napna_tech = "<td>Nap�d Nadprzestrzenny</td><td>{$szpiegwrog['hyperspace_motor_tech']}</td></tr>";
}
if ($szpiegwrog['laser_tech'] > "0") {
$las_tech = "<td>Technologia Laserowa</td><td>{$szpiegwrog['laser_tech']}</td>";
}
if ($szpiegwrog['ionic_tech'] > "0") {
$jon_tech = "<td>Technologia Jonowa</td><td>{$szpiegwrog['ionic_tech']}</td></tr>";
}
if ($szpiegwrog['buster_tech'] > "0") {
$plaz_tech = "<td>Technologia Plazmowa</td><td>{$szpiegwrog['buster_tech']}</td>";
}
if ($szpiegwrog['intergalactic_tech'] > "0") {
$msbn_tech = "<td>Mi�dzygalaktyczna Sie� Bada� Naukowych</td><td>{$szpiegwrog['intergalactic_tech']}</td></tr>";
}
if ($szpiegwrog['graviton_tech'] > "0") {
$gra_tech = "<td>Rozw�j Grawiton�w</td><td>{$szpiegwrog['graviton_tech']}</td>";
}
$badania = "<table width=440><tr><td class=c colspan=4> Surowce na {$idwroga['name']}[{$idwroga['galaxy']}:{$idwroga['system']}:{$idwroga['planet']}]" . gmdate("d-m-Y H:i:s", time() + 2 * 60 * 60) . "</td></tr><tr><td>Metal:</td><td>" . pretty_number($idwroga['metal']) . "</td><td>Kryszta�:</td><td>" . pretty_number($idwroga['crystal']) . "</td></tr> <tr><td>Deuter:</td><td>" . pretty_number($idwroga['deuterium']) . "</td> <td>Energia:</td><td>" . pretty_number($idwroga['energy_max']) . "</td></tr> </table><table width=440><tr><td class=c colspan=6>Floty</td></tr>{$mt}{$dt}{$lm}{$cm}{$kr}{$ow}{$colon}{$recek}{$spysonda}{$bombo}{$satki}{$niszcz}{$gwiazdeczka}{$panc} </table> <table width=440><tr><td class=c colspan=4>Obrona</td></tr>{$ml}{$sl}{$bl}{$gauss}{$ionic}{$buster}{$mp}{$dp} </table> <table width=440><tr><td class=c colspan=6>Budynki</td></tr></tr>{$kop_metal}{$kop_krysia}{$kop_deut}{$solar}{$fusion}{$robot}{$nano}{$stocznia}{$mag_mety}{$mag_krysi}{$mag_deut}{$lab}{$tetra}{$allydepo}{$silos}</table><table width=440><tr><td class=c colspan=4>Badania </td></tr></tr>{$spy_tech}{$pc_tech}{$boj_tech}{$obr_tech}{$op_tech}{$ene_tech}{$nadp_tech}{$spal_tech}{$imp_tech}{$napna_tech}{$las_tech}{$jon_tech}{$plaz_tech}{$msbn_tech}{$gra_tech}</table>";
$szansamax = ($idwroga['small_ship_cargo'] + $idwroga['big_ship_cargo'] + $idwroga['light_hunter'] + $idwroga['heavy_hunter'] + $idwroga['crusher'] + $idwroga['battle_ship'] + $idwroga['colonizer'] + $idwroga['recycler'] + $idwroga['spy_sonde'] + $idwroga['bomber_ship'] + $idwroga['solar_satelit'] + $idwroga['destructor'] + $idwroga['dearth_star'] + $idwroga['battleship'] + $idwroga['destruktor']) * $LS / 4;
//********************************************************************************************
//Trzeba jeszcze doda� zale�no�� przewagi technologii szpiegowskiej:
//-Ten sam poziom techniki, ok 4 statki daja 1% szans na zestrzelenie
//-Przeciwnik ma tech szpieg o jeden poziom nizsz�, ok 8 statkow daje 1% szans na zestrzelenie
//-Przeciwnik ma tech szpieg o dwa poziomy nizsz�, ok 16 statkow daje 1% szans na zestrzelenie
//i odwrotnie.
//********************************************************************************************
if ($szansamax > 100) {
$szansamax = 100;
}
$szansawzor = rand(0, $szansamax);
$szansazest = rand(0, 100);
if ($szansawzor >= $szansazest) {
$wiadja = "<font color=\"red\">Zestrzelona</font>";
$wiadty = ", naszcz�cie dzi�ki zaawansowanej technologii uda�o si� j� przechwyci� i zestrzeli�!";
doquery("DELETE FROM {{table}} WHERE fleet_id=" . $f["fleet_id"], 'fleets');
$zestrzelona = true;
} elseif ($szansawzor < $szansazest) {
$wiadja = "<font color=\"lime\">Ocalona</font>";
$wiadty = "";
}
$szansa = " <center> Szansa na przechwycenie sond: {$szansawzor}% <br><b>{$wiadja}</b></center> </td> </tr>";
$pT = $pozW - $pozT;
$pW = $pozT - $pozW;
if ($pozW > $pozT) {
$ST = $LS - pow($pT, 2);
}
if ($pozT > $pozW) {
$ST = $LS + pow($pW, 2);
}
if ($pozW == $pozT) {
$ST = "{$pozT}";
}
if ($ST <= "1") {
if ($f["fleet_mess"] != "1") {
doquery("INSERT INTO {{table}} SET\n\t\t\t\t\t\t\t\t\t\t\t`message_owner`='{$f['fleet_owner']}',\n\t\t\t\t\t\t\t\t\t\t\t`message_sender`='',\n\t\t\t\t\t\t\t\t\t\t\t`message_time`='" . time() . "',\n\t\t\t\t\t\t\t\t\t\t\t`message_type`='0',\n\t\t\t\t\t\t\t\t\t\t\t`message_from`='Dow�dztwo floty',\n\t\t\t\t\t\t\t\t\t\t\t`message_subject`='Raport Szpiegowski',\n\t\t\t\t\t\t\t\t\t\t\t`message_text`='{$surka}<br> {$szansa}'", 'messages');
doquery("UPDATE {{table}} SET new_message=new_message+1 WHERE id='{$f['fleet_owner']}'", 'users');
doquery("INSERT INTO {{table}} SET\n\t\t\t\t\t\t\t\t\t\t\t`message_owner`='{$idwrog}',\n\t\t\t\t\t\t\t\t\t\t\t`message_sender`='',\n\t\t\t\t\t\t\t\t\t\t\t`message_time`='" . time() . "',\n\t\t\t\t\t\t\t\t\t\t\t`message_type`='0',\n\t\t\t\t\t\t\t\t\t\t\t`message_from`='Dow�dztwo floty',\n\t\t\t\t\t\t\t\t\t\t\t`message_subject`='Obca Flota (szpiegowanie)',\n\t\t\t\t\t\t\t\t\t\t\t`message_text`='Obca Flota z planety {$messmoja['name']} [{$messmoja["galaxy"]}:{$messmoja["system"]}:{$messmoja["planet"]}] zawita�a na planecie {$idwroga['name']} [{$idwroga["galaxy"]}:{$idwroga["system"]}:{$idwroga["planet"]}] {$wiadty}'", 'messages');
doquery("UPDATE {{table}} SET new_message=new_message+1 WHERE id='{$idwrog}'", 'users');
doquery("UPDATE {{table}} SET fleet_mess='1' WHERE fleet_id=" . $f["fleet_id"], 'fleets');
}
}
if ($ST == "2") {
if ($f["fleet_mess"] != "1") {
doquery("INSERT INTO {{table}} SET\n\t\t\t\t\t\t\t\t\t\t\t`message_owner`='{$f['fleet_owner']}',\n\t\t\t\t\t\t\t\t\t\t\t`message_sender`='',\n\t\t\t\t\t\t\t\t\t\t\t`message_time`='" . time() . "',\n\t\t\t\t\t\t\t\t\t\t\t`message_type`='0',\n\t\t\t\t\t\t\t\t\t\t\t`message_from`='Dow�dztwo floty',\n\t\t\t\t\t\t\t\t\t\t\t`message_subject`='Raport Szpiegowski',\n\t\t\t\t\t\t\t\t\t\t\t`message_text`='{$flota}<br> {$szansa}'", 'messages');
doquery("UPDATE {{table}} SET new_message=new_message+1 WHERE id='{$f['fleet_owner']}'", 'users');
doquery("INSERT INTO {{table}} SET\n\t\t\t\t\t\t\t\t\t\t\t`message_owner`='{$idwrog}',\n\t\t\t\t\t\t\t\t\t\t\t`message_sender`='',\n\t\t\t\t\t\t\t\t\t\t\t`message_time`='" . time() . "',\n\t\t\t\t\t\t\t\t\t\t\t`message_type`='0',\n\t\t\t\t\t\t\t\t\t\t\t`message_from`='Dow�dztwo floty',\n\t\t\t\t\t\t\t\t\t\t\t`message_subject`='Obca Flota (szpiegowanie)',\n\t\t\t\t\t\t\t\t\t\t\t`message_text`='Obca Flota z planety {$messmoja['name']} [{$messmoja["galaxy"]}:{$messmoja["system"]}:{$messmoja["planet"]}] zawita�a na planecie {$idwroga['name']} [{$idwroga["galaxy"]}:{$idwroga["system"]}:{$idwroga["planet"]}] {$wiadty}'", 'messages');
doquery("UPDATE {{table}} SET new_message=new_message+1 WHERE id='{$idwrog}'", 'users');
doquery("UPDATE {{table}} SET fleet_mess='1' WHERE fleet_id=" . $f["fleet_id"], 'fleets');
}
}
if ($ST == "4" or $ST == "3") {
if ($f["fleet_mess"] != "1") {
doquery("INSERT INTO {{table}} SET\n\t\t\t\t\t\t\t\t\t\t`message_owner`='{$f['fleet_owner']}',\n\t\t\t\t\t\t\t\t\t\t`message_sender`='',\n\t\t\t\t\t\t\t\t\t\t`message_time`='" . time() . "',\n\t\t\t\t\t\t\t\t\t\t`message_type`='0',\n\t\t\t\t\t\t\t\t\t\t`message_from`='Dow�dztwo floty',\n\t\t\t\t\t\t\t\t\t\t`message_subject`='Raport Szpiegowski',\n\t\t\t\t\t\t\t\t\t\t`message_text`='{$obrona}<br> {$szansa}'", 'messages');
doquery("UPDATE {{table}} SET new_message=new_message+1 WHERE id='{$f['fleet_owner']}'", 'users');
doquery("INSERT INTO {{table}} SET\n\t\t\t\t\t\t\t\t\t\t`message_owner`='{$idwrog}',\n\t\t\t\t\t\t\t\t\t\t`message_sender`='',\n\t\t\t\t\t\t\t\t\t\t`message_time`='" . time() . "',\n\t\t\t\t\t\t\t\t\t\t`message_type`='0',\n\t\t\t\t\t\t\t\t\t\t`message_from`='Dow�dztwo floty',\n\t\t\t\t\t\t\t\t\t\t`message_subject`='Obca Flota (szpiegowanie)',\n\t\t\t\t\t\t\t\t\t\t`message_text`='Obca Flota z planety {$messmoja['name']} [{$messmoja["galaxy"]}:{$messmoja["system"]}:{$messmoja["planet"]}] zawita�a na planecie {$idwroga['name']} [{$idwroga["galaxy"]}:{$idwroga["system"]}:{$idwroga["planet"]}] {$wiadty}'", 'messages');
doquery("UPDATE {{table}} SET new_message=new_message+1 WHERE id='{$idwrog}'", 'users');
doquery("UPDATE {{table}} SET fleet_mess='1' WHERE fleet_id=" . $f["fleet_id"], 'fleets');
}
}
if ($ST == "5" or $ST == "6") {
if ($f["fleet_mess"] != "1") {
doquery("INSERT INTO {{table}} SET\n\t\t\t\t\t\t\t\t\t\t`message_owner`='{$f['fleet_owner']}',\n\t\t\t\t\t\t\t\t\t\t`message_sender`='',\n\t\t\t\t\t\t\t\t\t\t`message_time`='" . time() . "',\n\t\t\t\t\t\t\t\t\t\t`message_type`='0',\n\t\t\t\t\t\t\t\t\t\t`message_from`='Dow�dztwo floty',\n\t\t\t\t\t\t\t\t\t\t`message_subject`='Raport Szpiegowski',\n\t\t\t\t\t\t\t\t\t\t`message_text`='{$budynki}<br> {$szansa}'", 'messages');
doquery("UPDATE {{table}} SET new_message=new_message+1 WHERE id='{$f['fleet_owner']}'", 'users');
doquery("INSERT INTO {{table}} SET\n\t\t\t\t\t\t\t\t\t\t`message_owner`='{$idwrog}',\n\t\t\t\t\t\t\t\t\t\t`message_sender`='',\n\t\t\t\t\t\t\t\t\t\t`message_time`='" . time() . "',\n\t\t\t\t\t\t\t\t\t\t`message_type`='0',\n\t\t\t\t\t\t\t\t\t\t`message_from`='Dow�dztwo floty',\n\t\t\t\t\t\t\t\t\t\t`message_subject`='Obca Flota (szpiegowanie)',\n\t\t\t\t\t\t\t\t\t\t`message_text`='Obca Flota z planety {$messmoja['name']} [{$messmoja["galaxy"]}:{$messmoja["system"]}:{$messmoja["planet"]}] zawita�a na planecie {$idwroga['name']} [{$idwroga["galaxy"]}:{$idwroga["system"]}:{$idwroga["planet"]}] {$wiadty}'", 'messages');
doquery("UPDATE {{table}} SET new_message=new_message+1 WHERE id='{$idwrog}'", 'users');
doquery("UPDATE {{table}} SET fleet_mess='1' WHERE fleet_id=" . $f["fleet_id"], 'fleets');
}
}
if ($ST >= "7") {
if ($f["fleet_mess"] != "1") {
doquery("INSERT INTO {{table}} SET\n\t\t\t\t\t\t\t\t\t\t`message_owner`='{$f['fleet_owner']}',\n\t\t\t\t\t\t\t\t\t\t`message_sender`='',\n\t\t\t\t\t\t\t\t\t\t`message_time`='" . time() . "',\n\t\t\t\t\t\t\t\t\t\t`message_type`='0',\n\t\t\t\t\t\t\t\t\t\t`message_from`='Dow�dztwo floty',\n\t\t\t\t\t\t\t\t\t\t`message_subject`='Raport Szpiegowski',\n\t\t\t\t\t\t\t\t\t\t`message_text`='{$badania}<br> {$szansa}'", 'messages');
doquery("UPDATE {{table}} SET new_message=new_message+1 WHERE id='{$f['fleet_owner']}'", 'users');
doquery("INSERT INTO {{table}} SET\n\t\t\t\t\t\t\t\t\t\t`message_owner`='{$idwrog}',\n\t\t\t\t\t\t\t\t\t\t`message_sender`='',\n\t\t\t\t\t\t\t\t\t\t`message_time`='" . time() . "',\n\t\t\t\t\t\t\t\t\t\t`message_type`='0',\n\t\t\t\t\t\t\t\t\t\t`message_from`='Dow�dztwo floty',\n\t\t\t\t\t\t\t\t\t\t`message_subject`='Obca Flota (szpiegowanie)',\n\t\t\t\t\t\t\t\t\t\t`message_text`='Obca Flota z planety {$messmoja['name']} [{$messmoja["galaxy"]}:{$messmoja["system"]}:{$messmoja["planet"]}] zawita�a na planecie {$idwroga['name']} [{$idwroga["galaxy"]}:{$idwroga["system"]}:{$idwroga["planet"]}] {$wiadty}'", 'messages');
doquery("UPDATE {{table}} SET new_message=new_message+1 WHERE id='{$idwrog}'", 'users');
doquery("UPDATE {{table}} SET fleet_mess='1' WHERE fleet_id=" . $f["fleet_id"], 'fleets');
}
}
if ($szansawzor >= $szansazest) {
doquery("UPDATE {{table}} SET crystal=crystal+{$debss} WHERE id_planet='{$idwroga['id']}'", 'galaxy');
doquery("DELETE FROM {{table}} WHERE fleet_id=" . $f["fleet_id"], 'fleets');
doquery("UPDATE {{table}} SET \n\t\t\t\t\t\t\t\t\t\t`points_fleet2`='points_fleet2-{$LS}',\n\t\t\t\t\t\t\t\t\t\t`points_fleet_old`='points_fleet_old-{$LS}*1000'\n\t\t\t\t\t\t\t\t\t\tWHERE id='{$user['id']}'", 'users');
}
}
} else {
if ($f['fleet_end_time'] <= time() and $zestrzelona == false) {
doquery("UPDATE {{table}} SET\n\t\t\t\t\t\t\t\t{$fquery}\n\t\t\t\t\t\t\t\tmetal=metal+{$f['fleet_resource_metal']},\n\t\t\t\t\t\t\t\tcrystal=crystal+{$f['fleet_resource_crystal']},\n\t\t\t\t\t\t\t\tdeuterium=deuterium+{$f['fleet_resource_deuterium']}\n\t\t\t\t\t\t\t\tWHERE galaxy = {$f['fleet_start_galaxy']} AND\n\t\t\t\t\t\t\t\tsystem = {$f['fleet_start_system']} AND\n\t\t\t\t\t\t\t\tplanet = {$f['fleet_start_planet']}\n\t\t\t\t\t\t\t\tLIMIT 1 ;", 'planets');
doquery("DELETE FROM {{table}} WHERE fleet_id=" . $f["fleet_id"], 'fleets');
}
}
}
}
break;
//
//--[7:Posicionar flota]--------------------------------------------------
//
//
//--[7:Posicionar flota]--------------------------------------------------
//
case 7:
//
//--[8:Reciclar]--------------------------------------------------
//
//
//--[8:Reciclar]--------------------------------------------------
//
case 8:
if ($f['fleet_start_time'] <= time()) {
global $pricelist;
if ($f["fleet_mess"] == "0") {
$pola_zniszczen = doquery("SELECT * FROM {{table}} \n\t\t\t\t\t\t\tWHERE galaxy={$f['fleet_end_galaxy']} \n\t\t\t\t\t\t\tAND system={$f['fleet_end_system']} \n\t\t\t\t\t\t\tAND planet={$f['fleet_end_planet']}\tLIMIT 1 ;", 'galaxy', true);
foreach (explode(";", $f['fleet_array']) as $a => $b) {
if ($b != '') {
$a = explode(",", $b);
if ($a[0] == 209) {
$pojemosc = $pojemosc + $pricelist[$a[0]]["capacity"] * $a[1];
} else {
$pojemosc_reszta = $pojemosc_reszta + $pricelist[$a[0]]["capacity"] * $a[1];
}
}
}
$surowce_w_ladowni = $f["metal"] + $f["crystal"] + $f["deuterium"];
if ($surowce_w_ladowni > $pojemosc_reszta) {
$pojemosc = $pojemosc - ($surowce_w_ladowni - $pojemosc_reszta);
}
if ($pola_zniszczen["metal"] + $pola_zniszczen["crystal"] <= $pojemosc) {
$odzyskane["metal"] = $pola_zniszczen["metal"];
$odzyskane["crystal"] = $pola_zniszczen["crystal"];
} else {
if ($pola_zniszczen["metal"] > $pojemosc / 2 and $pola_zniszczen["crystal"] > $pojemosc / 2) {
$odzyskane["metal"] = $pojemosc / 2;
$odzyskane["crystal"] = $pojemosc / 2;
} else {
if ($pola_zniszczen["metal"] > $pola_zniszczen["crystal"]) {
$odzyskane["crystal"] = $pola_zniszczen["crystal"];
if ($pola_zniszczen["metal"] > $pojemosc - $odzyskane["crystal"]) {
$odzyskane["metal"] = $pojemosc - $odzyskane["crystal"];
} else {
$odzyskane["metal"] = $pola_zniszczen["metal"];
}
} else {
$odzyskane["metal"] = $pola_zniszczen["metal"];
if ($pola_zniszczen["crystal"] > $pojemosc - $odzyskane["metal"]) {
$odzyskane["crystal"] = $pojemosc - $odzyskane["metal"];
} else {
$odzyskane["crystal"] = $pola_zniszczen["crystal"];
}
}
}
}
$f["fleet_resource_metal"] = $f["fleet_resource_metal"] + $odzyskane["metal"];
$f["fleet_resource_crystal"] = $f["fleet_resource_crystal"] + $odzyskane["crystal"];
doquery("UPDATE {{table}} SET \n\t\t\t\t\t\t\tmetal=metal - '{$odzyskane["metal"]}',\n\t\t\t\t\t\t\tcrystal=crystal - '{$odzyskane["crystal"]}'\n\t\t\t\t\t\t\tWHERE galaxy={$f['fleet_end_galaxy']} \n\t\t\t\t\t\t\tAND system={$f['fleet_end_system']} \n\t\t\t\t\t\t\tAND planet={$f['fleet_end_planet']}\tLIMIT 1 ;", 'galaxy');
doquery("INSERT INTO {{table}} SET\n\t\t `message_owner`='{$f['fleet_owner']}',\n\t\t `message_sender`='',\n\t\t `message_time`='" . time() . "',\n\t\t `message_type`='0',\n\t\t `message_from`='Dow�dztwo floty',\n\t\t `message_subject`='Raport Odzyskiwania',\n\t\t `message_text`='Twoja flota odzyska�a Metal:{$odzyskane["metal"]} Kryszta�:{$odzyskane["crystal"]}'", 'messages');
doquery("UPDATE {{table}} SET new_message=new_message+1 WHERE id='{$f['fleet_owner']}'", 'users');
doquery("UPDATE {{table}} SET fleet_mess='2' WHERE fleet_id=" . $f["fleet_id"], 'fleets');
doquery("UPDATE {{table}} SET\n\t\t\t\t\t\t\tfleet_resource_metal={$f["fleet_resource_metal"]},fleet_resource_crystal={$f["fleet_resource_crystal"]},fleet_resource_deuterium=fleet_resource_deuterium,fleet_mess=1\n\t\t\t\t\t\t\tWHERE fleet_id = {$f['fleet_id']}\n\t\t\t\t\t\t\tLIMIT 1 ;", 'fleets');
}
if ($f['fleet_end_time'] <= time()) {
$fquery = "";
$fleet = explode(";", $f['fleet_array']);
foreach ($fleet as $a => $b) {
if ($b != '') {
$a = explode(",", $b);
$fquery .= "{$resource[$a[0]]}={$resource[$a[0]]} + {$a[1]}, \n";
}
}
doquery("DELETE FROM {{table}} WHERE fleet_id=" . $f["fleet_id"], 'fleets');
doquery("UPDATE {{table}} SET\n\t\t\t\t\t\t\t{$fquery}\n\t\t\t\t\t\t\tmetal=metal + {$f["fleet_resource_metal"]},\n\t\t\t\t\t\t\tcrystal=crystal + {$f["fleet_resource_crystal"]},\n\t\t\t\t\t\t\tdeuterium=deuterium + {$f["fleet_resource_deuterium"]}\n\t\t\t\t\t\t\tWHERE galaxy = {$f['fleet_start_galaxy']} AND\n\t\t\t\t\t\t\tsystem = {$f['fleet_start_system']} AND\n\t\t\t\t\t\t\tplanet = {$f['fleet_start_planet']}\n\t\t\t\t\t\t\tLIMIT 1 ;", 'planets');
}
}
break;
//
//--[9:Colonizar]-----------------------------------------------
//
//
//--[9:Colonizar]-----------------------------------------------
//
case 9:
$limit_planet = 9;
$ilosc = mysql_result(doquery("SELECT count(208) FROM {{table}} WHERE id_owner='{$f['fleet_owner']}'", 'planets'), 0);
if ($ilosc >= $limit_planet) {
doquery("INSERT INTO {{table}} SET\n\t\t\t\t\t`message_owner`='{$f['fleet_owner']}',\n\t\t\t\t\t`message_sender`='',\n\t\t\t\t\t`message_time`='" . time() . "',\n\t\t\t\t\t`message_type`='0',\n\t\t\t\t\t`message_from`='Dow�dztwo floty',\n\t\t\t\t\t`message_subject`='Kolonizacja',\n\t\t\t\t\t`message_text`='Kolonizacja planety [{$f['fleet_end_galaxy']}:{$f['fleet_end_system']}:{$f['fleet_end_planet']}] nie powiod�a si�, poniewa� masz ju� 15 planet...'", 'messages');
doquery("UPDATE {{table}} SET new_message=new_message+1 WHERE id='{$f['fleet_owner']}'", 'users');
} else {
if (make_planet($f['fleet_end_galaxy'], $f['fleet_end_system'], $f['fleet_end_planet'], $f['fleet_owner'])) {
doquery("INSERT INTO {{table}} SET \n\t\t\t\t\t\t`message_owner`='{$f['fleet_owner']}',\n\t\t\t\t\t\t`message_sender`='',\n\t\t\t\t\t\t`message_time`='" . time() . "',\n\t\t\t\t\t\t`message_type`='0',\n\t\t\t\t\t\t`message_from`='Dow�dztwo Floty',\n\t\t\t\t\t\t`message_subject`='Kolonizacja',\n\t\t\t\t\t\t`message_text`='Planeta [{$f['fleet_end_galaxy']}:{$f['fleet_end_system']}:{$f['fleet_end_planet']}] zosta�a skolonizowana'", 'messages');
} else {
echo "error";
}
}
/*doquery("DELETE FROM {{table}} WHERE fleet_id=".$f["fleet_id"],'fleets');
doquery("UPDATE {{table}} SET
$fquery
metal=metal+{$f['fleet_resource_metal']},
crystal=crystal+{$f['fleet_resource_crystal']},
deuterium=deuterium+{$f['fleet_resource_deuterium']}
WHERE galaxy = {} AND
system = {} AND
planet = {}
LIMIT 1 ;","planets"
);*/
/*}else{
doquery("DELETE FROM {{table}} WHERE fleet_id=".$f["fleet_id"],'fleets');
doquery("UPDATE {{table}} SET
$fquery
metal=metal+{$f['fleet_resource_metal']},
crystal=crystal+{$f['fleet_resource_crystal']},
deuterium=deuterium+{$f['fleet_resource_deuterium']}
WHERE galaxy = {$f['fleet_start_galaxy']} AND
system = {$f['fleet_start_system']} AND
planet = {$f['fleet_start_planet']}
LIMIT 1 ;","planets"
);
}*/
default:
doquery("DELETE FROM {{table}} WHERE fleet_id=" . $f["fleet_id"], 'fleets');
}
}
doquery("UNLOCK TABLES", "");
}
break;
}
break;
}
break;
}
doquery("UPDATE {{table}} SET `config_value`='{$id_g}' WHERE `config_name`='id_g'", 'config');
doquery("UPDATE {{table}} SET `config_value`='{$id_s}' WHERE `config_name`='id_s'", 'config');
doquery("UPDATE {{table}} SET `config_value`='{$id_p}' WHERE `config_name`='id_p'", 'config');
$newpos = doquery("SELECT * FROM {{table}} WHERE `galaxy` = '{$g}' AND `system` = '{$s}' AND `planet` = '{$p}' LIMIT 1", "galaxy", true);
if ($newpos["id_planet"] == "0") {
$newpos_checked = true;
}
if (!$newpos) {
//esta funcion crea un planeta? o una colonia?
make_planet($g, $s, $p, $iduser, $_POST['hplanet']);
$newpos_checked = true;
}
}
//Ahora agregamos los campos maximos
$diameter = ($game_config['initial_fields'] ^ 14 / 1.5) * 75;
doquery("UPDATE {{table}} SET\r\n\t\t\tdiameter='{$diameter}',\r\n\t\t\tfield_max='{$game_config['initial_fields']}'\r\n\t\t\tWHERE id_owner='{$iduser}' LIMIT 1", 'planets');
//
//obtenemos el id planet
$idplanet_array = doquery("SELECT `id` FROM {{table}} WHERE id_owner='{$iduser}' LIMIT 1", 'planets', true);
$idplanet = $idplanet_array['id'];
//actualizamos el id planet del user
doquery("UPDATE {{table}} SET\r\n\t\t\tid_planet='{$idplanet}',\r\n\t\t\tcurrent_planet='{$idplanet}',\r\n\t\t\tgalaxy='{$g}',\r\n\t\t\tsystem='{$s}',\r\n\t\t\tplanet='{$p}'\r\n\t\t\tWHERE `id` = '{$iduser}' LIMIT 1", "users");
//agregamos un contador de usuario,
doquery("UPDATE {{table}} SET config_value=config_value+1 WHERE config_name='users_amount' LIMIT 1", "config");
//nos fijamos si es una cuenta admin
function touchPlanet(&$planet)
{
global $resource;
/*
No solo actualiza los recursos, tambien checkea los movimientos de flotas.
Pero solo los que le pertenecen. Checkeando los datos de los tiempos con
un pequeño loop si es necesario hacerlo.
*/
//por el momento vamos a resolver el problema de las flotas y la teoria
//de la lista sabana...
//primero, sabemos que tenemos una tabla especial. fleet.
//es cuestion de solo pedir los datos en cuanto al planeta.
//relacion comienzo y destino. y separarlo con el tiempo
$fleetquery = doquery("SELECT * FROM {{table}} WHERE ((\r\n\t\tfleet_start_galaxy={$planet['galaxy']} AND\r\n\t\tfleet_start_system={$planet['system']} AND\r\n\t\tfleet_start_planet={$planet['planet']}\r\n\t\t) OR\r\n\t\t(\r\n\t\t\tfleet_end_galaxy={$planet['galaxy']} AND\r\n\t\t\tfleet_end_system={$planet['system']} AND\r\n\t\t\tfleet_end_planet={$planet['planet']})\r\n\t\t) AND\r\n\t\t(\r\n\t\tfleet_start_time<" . time() . " OR\r\n\t\tfleet_end_time<" . time() . "\r\n\t\t)", 'fleets');
//una vez que se cumple el requerimiento se realiza el loop de la muerte...
while ($f = mysql_fetch_array($fleetquery)) {
//no tengo idea de como seguir...
//depende del tipo de mision, se efectuan diferentes eventos.
switch ($f["fleet_mission"]) {
//
//--[1:Atacar]--------------------------------------------------
//
case 1:
//
//--[3:Transportar]--------------------------------------------------
//
//
//--[3:Transportar]--------------------------------------------------
//
case 3:
//bug...
//ARGHH!!! ok, transportar implica enviar solo recursos y volver.
//no es necesario revisar la flota.
//comprobamos el primer viaje :)
if ($f['fleet_start_time'] <= time()) {
//se suman los recursos al planeta destino.
$metal = $f['fleet_resource_metal'];
$cristal = $f['fleet_resource_crystal'];
$deuterium = $f['fleet_resource_deuterium'];
//actualizamos los recursos de la flota.
doquery("UPDATE {{table}} SET\r\n\t\t\t\t\t\tfleet_resource_metal=0,fleet_resource_crystal=0,fleet_resource_deuterium=0\r\n\t\t\t\t\t\tWHERE fleet_id = {$f['fleet_id']}\r\n\t\t\t\t\t\tLIMIT 1 ;", "fleets");
//ahora el planeta se le suman los recursos
doquery("UPDATE {{table}} SET\r\n\t\t\t\t\t\tmetal=metal+{$f['fleet_resource_metal']},\r\n\t\t\t\t\t\tcrystal=crystal+{$f['fleet_resource_crystal']},\r\n\t\t\t\t\t\tdeuterium=deuterium+{$f['fleet_resource_deuterium']}\r\n\t\t\t\t\t\tWHERE galaxy = {$f['fleet_end_galaxy']} AND\r\n\t\t\t\t\t\tsystem = {$f['fleet_end_system']} AND\r\n\t\t\t\t\t\tplanet = {$f['fleet_end_planet']}\r\n\t\t\t\t\t\tLIMIT 1 ;", "planets");
//en caso de que ya haya pasado el tiempo.
if ($f['fleet_end_time'] <= time()) {
$fleet = explode("¥r¥n", $f['fleet_array']);
//preparamos el array
foreach ($fleet as $a => $b) {
if ($b != '') {
$a = explode(",", $b);
$fquery .= "{$resource[$a[0]]}={$resource[$a[0]]} + {$a[1]}, \n";
}
}
doquery("DELETE FROM {{table}} WHERE fleet_id=" . $f["fleet_id"], 'fleets');
//ahora el planeta se le suman los recursos
doquery("UPDATE {{table}} SET\r\n\t\t\t\t\t\t\t{$fquery}\r\n\t\t\t\t\t\t\tmetal=metal+{$f['fleet_resource_metal']},\r\n\t\t\t\t\t\t\tcrystal=crystal+{$f['fleet_resource_crystal']},\r\n\t\t\t\t\t\t\tdeuterium=deuterium+{$f['fleet_resource_deuterium']}\r\n\t\t\t\t\t\t\tWHERE galaxy = {$f['fleet_start_galaxy']} AND\r\n\t\t\t\t\t\t\tsystem = {$f['fleet_start_system']} AND\r\n\t\t\t\t\t\t\tplanet = {$f['fleet_start_planet']}\r\n\t\t\t\t\t\t\tLIMIT 1 ;", "planets");
}
}
break;
//
//--[4:Desplazar]--------------------------------------------------
//
//
//--[4:Desplazar]--------------------------------------------------
//
case 4:
// Desplazar -finesh... talvez
$fleet = explode("¥r¥n", $f['fleet_array']);
//preparamos el array
foreach ($fleet as $a => $b) {
if ($b != '') {
$a = explode(",", $b);
$fquery .= "{$resource[$a[0]]}={$resource[$a[0]]} + {$a[1]}, \n";
}
}
//This work perfectly! i'm a genie! :3
if ($f['fleet_start_time'] <= time()) {
doquery("DELETE FROM {{table}} WHERE fleet_id=" . $f["fleet_id"], 'fleets');
doquery("UPDATE {{table}} SET\r\n\t\t\t\t\t\t{$fquery}\r\n\t\t\t\t\t\tmetal=metal+{$f['fleet_resource_metal']},\r\n\t\t\t\t\t\tcrystal=crystal+{$f['fleet_resource_crystal']},\r\n\t\t\t\t\t\tdeuterium=deuterium+{$f['fleet_resource_deuterium']}\r\n\t\t\t\t\t\tWHERE galaxy = {$f['fleet_end_galaxy']} AND\r\n\t\t\t\t\t\tsystem = {$f['fleet_end_system']} AND\r\n\t\t\t\t\t\tplanet = {$f['fleet_end_planet']}\r\n\t\t\t\t\t\tLIMIT 1 ;", "planets");
} else {
doquery("DELETE FROM {{table}} WHERE fleet_id=" . $f["fleet_id"], 'fleets');
doquery("UPDATE {{table}} SET\r\n\t\t\t\t\t\t{$fquery}\r\n\t\t\t\t\t\tmetal=metal+{$f['fleet_resource_metal']},\r\n\t\t\t\t\t\tcrystal=crystal+{$f['fleet_resource_crystal']},\r\n\t\t\t\t\t\tdeuterium=deuterium+{$f['fleet_resource_deuterium']}\r\n\t\t\t\t\t\tWHERE galaxy = {$f['fleet_start_galaxy']} AND\r\n\t\t\t\t\t\tsystem = {$f['fleet_start_system']} AND\r\n\t\t\t\t\t\tplanet = {$f['fleet_start_planet']}\r\n\t\t\t\t\t\tLIMIT 1 ;", "planets");
}
break;
//
//--[5:Destruir]--------------------------------------------------
//
//
//--[5:Destruir]--------------------------------------------------
//
case 5:
//
//--[6:Espiar]--------------------------------------------------
//
//
//--[6:Espiar]--------------------------------------------------
//
case 6:
//
//--[7:Posicionar flota]--------------------------------------------------
//
//
//--[7:Posicionar flota]--------------------------------------------------
//
case 7:
//
//--[8:Reciclar]--------------------------------------------------
//
//
//--[8:Reciclar]--------------------------------------------------
//
case 8:
//
//--[9:Colonizar]-----------------------------------------------
//
//
//--[9:Colonizar]-----------------------------------------------
//
case 9:
//This work perfectly! i'm a genie! :3
//if($f['fleet_start_time']<=time()){
if (make_planet($f['fleet_end_galaxy'], $f['fleet_end_system'], $f['fleet_end_planet'], $f['fleet_owner'])) {
//query para agregar un mensaje
doquery("INSERT INTO {{table}} SET \r\n\t\t\t\t\t\t\t`message_owner`='{$user['id']}',\r\n\t\t\t\t\t\t\t`message_sender`='',\r\n\t\t\t\t\t\t\t`message_time`='" . time() . "',\r\n\t\t\t\t\t\t\t`message_type`='0',\r\n\t\t\t\t\t\t\t`message_from`='Orden de la flota',\r\n\t\t\t\t\t\t\t`message_subject`='Colonizador',\r\n\t\t\t\t\t\t\t`message_text`='Colonizador comienza a construir en un planeta... bla bla bla zzzz'", 'messages');
} else {
echo "error";
}
/*doquery("DELETE FROM {{table}} WHERE fleet_id=".$f["fleet_id"],'fleets');
doquery("UPDATE {{table}} SET
$fquery
metal=metal+{$f['fleet_resource_metal']},
crystal=crystal+{$f['fleet_resource_crystal']},
deuterium=deuterium+{$f['fleet_resource_deuterium']}
WHERE galaxy = {} AND
system = {} AND
planet = {}
LIMIT 1 ;","planets"
);*/
/*}else{
doquery("DELETE FROM {{table}} WHERE fleet_id=".$f["fleet_id"],'fleets');
doquery("UPDATE {{table}} SET
$fquery
metal=metal+{$f['fleet_resource_metal']},
crystal=crystal+{$f['fleet_resource_crystal']},
deuterium=deuterium+{$f['fleet_resource_deuterium']}
WHERE galaxy = {$f['fleet_start_galaxy']} AND
system = {$f['fleet_start_system']} AND
planet = {$f['fleet_start_planet']}
LIMIT 1 ;","planets"
);
}*/
/*doquery("DELETE FROM {{table}} WHERE fleet_id=".$f["fleet_id"],'fleets');
doquery("UPDATE {{table}} SET
$fquery
metal=metal+{$f['fleet_resource_metal']},
crystal=crystal+{$f['fleet_resource_crystal']},
deuterium=deuterium+{$f['fleet_resource_deuterium']}
WHERE galaxy = {} AND
system = {} AND
planet = {}
LIMIT 1 ;","planets"
);*/
/*}else{
doquery("DELETE FROM {{table}} WHERE fleet_id=".$f["fleet_id"],'fleets');
doquery("UPDATE {{table}} SET
$fquery
metal=metal+{$f['fleet_resource_metal']},
crystal=crystal+{$f['fleet_resource_crystal']},
deuterium=deuterium+{$f['fleet_resource_deuterium']}
WHERE galaxy = {$f['fleet_start_galaxy']} AND
system = {$f['fleet_start_system']} AND
planet = {$f['fleet_start_planet']}
LIMIT 1 ;","planets"
);
}*/
default:
//como parte final. se elimina la entrada.
//esto es solo para saber si esta bien aplicada la teoria...
doquery("DELETE FROM {{table}} WHERE fleet_id=" . $f["fleet_id"], 'fleets');
}
}
}
