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'); } } }