rendered paste body<?php //functions.php
function add_points($resources,$userid){
return false;
}
function remove_points($resources,$userid){
return false;
}
//
// Comprueba si un usario existe
//
function check_user(){
//obtenemos las cookies y o userdata
$row = checkcookies();
if($row != false){
global $user;
$user = $row;
return true;
}
return false;
}
//
// Obtiene una array de los datos de un jugador.
//
function get_userdata(){
echo "pendiente";
}
//
// Comprueba si es una direccion de email valida
//
function is_email($email){
return(preg_match("/^[-_.[:alnum:]]+@((([[:alnum:]]|[[:alnum:]][[:alnum:]-]*[[:alnum:]])\.)+(ad|ae|aero|af|ag|ai|al|am|an|ao|aq|ar|arpa|as|at|au|aw|az|ba|bb|bd|be|bf|bg|bh|bi|biz|bj|bm|bn|bo|br|bs|bt|bv|bw|by|bz|ca|cc|cd|cf|cg|ch|ci|ck|cl|cm|cn|co|com|coop|cr|cs|cu|cv|cx|cy|cz|de|dj|dk|dm|do|dz|ec|edu|ee|eg|eh|er|es|et|eu|fi|fj|fk|fm|fo|fr|ga|gb|gd|ge|gf|gh|gi|gl|gm|gn|gov|gp|gq|gr|gs|gt|gu|gw|gy|hk|hm|hn|hr|ht|hu|id|ie|il|in|info|int|io|iq|ir|is|it|jm|jo|jp|ke|kg|kh|ki|km|kn|kp|kr|kw|ky|kz|la|lb|lc|li|lk|lr|ls|lt|lu|lv|ly|ma|mc|md|mg|mh|mil|mk|ml|mm|mn|mo|mp|mq|mr|ms|mt|mu|museum|mv|mw|mx|my|mz|na|name|nc|ne|net|nf|ng|ni|nl|no|np|nr|nt|nu|nz|om|org|pa|pe|pf|pg|ph|pk|pl|pm|pn|pr|pro|ps|pt|pw|py|qa|re|ro|ru|rw|sa|sb|sc|sd|se|sg|sh|si|sj|sk|sl|sm|sn|so|sr|st|su|sv|sy|sz|tc|td|tf|tg|th|tj|tk|tm|tn|to|tp|tr|tt|tv|tw|tz|ua|ug|uk|um|us|uy|uz|va|vc|ve|vg|vi|vn|vu|wf|ws|ye|yt|yu|za|zm|zw)$|(([0-9][0-9]?|[0-1][0-9][0-9]|[2][0-4][0-9]|[2][5][0-5])\.){3}([0-9][0-9]?|[0-1][0-9][0-9]|[2][0-4][0-9]|[2][5][0-5]))$/i",$email));
}
//
// Sirve para leer las cookies.
//
function checkcookies(){
global $lang,$game_config,$ugamela_root_path,$phpEx;
//mas adelante esta variable formara parte de la $game_config
includeLang('cookies');
include($ugamela_root_path.'config.'.$phpEx);
$row = false;
if (isset($_COOKIE[$game_config['COOKIE_NAME']]))
{
// Formato de la cookie:
// {ID} {USERNAME} {PASSWORDHASH} {REMEMBERME}
$theuser = explode(" ",$_COOKIE[$game_config['COOKIE_NAME']]);
$query = doquery("SELECT * FROM {{table}} WHERE username='{$theuser[1]}'", "users");
if (mysql_num_rows($query) != 1)
{
message($lang['cookies']['Error1']);
}
$row = mysql_fetch_array($query);
if ($row["id"] != $theuser[0])
{
message($lang['cookies']['Error2']);
}
if (md5($row["password"]."--".$dbsettings["secretword"]) !== $theuser[2])
{
message($lang['cookies']['Error3']);
}
// Si llegamos hasta aca... quiere decir que la cookie es valida,
// entonces escribimos una nueva.
$newcookie = implode(" ",$theuser);
if($theuser[3] == 1){ $expiretime = time()+31536000;}else{ $expiretime = 0;}
setcookie ($game_config['COOKIE_NAME'], $newcookie, $expiretime, "/", "", 0);
doquery("UPDATE {{table}} SET onlinetime=".time().", user_lastip='{$_SERVER['REMOTE_ADDR']}' WHERE id='{$theuser[0]}' LIMIT 1", "users");
}
unset($dbsettings);
return $row;
}
//
// Funcion de parce
//
function parsetemplate($template, $array){
foreach($array as $a => $b) {
$template = str_replace("{{$a}}", $b, $template);
}
return $template;
}
//
//
//
function gettemplate($templatename){ //OpenGame .. $skinname = 'FinalWars'
global $ugamela_root_path;
$filename = $ugamela_root_path . TEMPLATE_DIR . TEMPLATE_NAME . '/' . $templatename . ".tpl";
return ReadFromFile($filename);
}
// to get the language texts
function includeLang($filename,$ext='.mo'){
global $ugamela_root_path,$lang;
include($ugamela_root_path."language/".DEFAULT_LANG.'/'.$filename.$ext);
}
//
// Leer y Guardar archivos
//
function ReadFromFile($filename){
$f = @fopen($filename,"r");
$content = @fread($f,filesize($filename));
@fclose($f);
return $content;
}
function SaveToFile($filename,$content){
$f = fopen($filename,"w");
fputs($f,"$content");
fclose($f);
}
//**************************************************************************
//
// FUNCIONES PARA REVISAR!!!!!!!!!!
//
//**************************************************************************
function message($mes,$title='Error',$dest = "",$time = "3"){
$parse['color'] = $color;
$parse['title'] = $title;
$parse['mes'] = $mes;
$page .= parsetemplate(gettemplate('message_body'), $parse);
display($page,$title,false,(($dest!='')?"<meta http-equiv=\"refresh\" content=\"$time;URL=javascript:self.location='$dest';\">":''));
}
function display($page,$title = '',$topnav = true,$metatags=''){
global $link,$game_config,$debug,$user;
echo_head($title,$metatags);
if($topnav){ echo_topnav();}
echo "<center>\n$page\n</center>\n";
//Muestra los datos del debuger.
if($user['authlevel']==1||$user['authlevel']==3){
if($game_config['debug']==1) $debug->echo_log();
}
echo echo_foot();
if(isset($link)) mysql_close();
die();
}
function echo_foot(){
global $game_config,$lang;
$parse['copyright'] = $game_config['copyright'];
$parse['TranslationBy'] = $lang['TranslationBy'];
echo parsetemplate(gettemplate('overall_footer'), $parse);
}
function CheckUserExist($user){
global $lang,$link;
if(!$user){
if(isset($link)) mysql_close();
error($lang['Please_Login'],$lang['Error']);
}
}
function pretty_time($seconds){
//Divisiones, y resto. Gracias Prody
$day = floor($seconds / (24*3600));
$hs = floor($seconds / 3600 % 24);
$min = floor($seconds / 60 % 60);
$seg = floor($seconds / 1 % 60);
$time = '';//la entrada del $time
if($day != 0){ $time .= $day.'d ';}
if($hs != 0){ $time .= $hs.'h ';}
if($min != 0){ $time .= $min.'m ';}
$time .= $seg.'s';
return $time;//regresa algo como "[[[0d] 0h] 0m] 0s"
}
function pretty_time_hour($seconds){
//Divisiones, y resto. Gracias Prody
$min = floor($seconds / 60 % 60);
$time = '';//la entrada del $time
if($min != 0){ $time .= $min.'min ';}
return $time;//regresa algo como "[[[0d] 0h] 0m] 0s"
}
function echo_topnav(){
global $user, $planetrow, $galaxyrow,$mode,$messageziel,$gid,$lang;
if(!$user){return;}
if(!$planetrow){ $planetrow = doquery("SELECT * FROM {{table}} WHERE id ={$user['current_planet']}","planets",true);} calculate_resources_planet($planetrow);//Actualizacion de rutina
//if(!$galaxyrow){ $galaxyrow = doquery("SELECT * FROM {{table}} WHERE id_planet = '".$planetrow["id"]."'","galaxy",true);}
$dpath = (!$user["dpath"]) ? DEFAULT_SKINPATH : $user["dpath"];
//-[Arrays]------------------------------------------------
$parse = $lang;
$parse['dpath'] = $dpath;
$parse['image'] = $planetrow['image'];
/*
pequeño loop para agregar todos los planetas disponibles del mismo jugador...
*/
?><script language="JavaScript" src="scripts/flotten.js"></script>
<script language="JavaScript" src="scripts/ocnt.js"></script>
<script type="text/javascript" src="scripts/jquery.js"></script>
<script type="text/javascript" src="scripts/thickbox.js"></script>
<link rel="stylesheet" href="scripts/thickbox.css" type="text/css" media="screen" />
<?
$parse['planetlist'] = '';
//pedimos todos los planetas que coincidan con el id del due�.
$planets_list = doquery("SELECT id,name,galaxy,system,planet FROM {{table}} WHERE id_owner='{$user['id']}'","planets");
while($p = mysql_fetch_array($planets_list)){
/*
Cuando alguien selecciona destruir planeta, hay un tiempo en el que se vacia el slot
del planeta, es mas que nada para dar tiempo a posible problema de hackeo o robo de cuenta.
*/
if($p["destruyed"] == 0){
//$pos_galaxy = doquery("SELECT * FROM {{table}} WHERE id_planet = {$p[id]}","galaxy",true);
$parse['planetlist'] .= "<option ";
if($p["id"] == $user["current_planet"]) $parse['planetlist'] .= 'selected="selected" ';//Se selecciona el planeta actual
$parse['planetlist'] .= "value=\"?cp={$p['id']}&mode=$mode&gid=$gid&messageziel=$messageziel&re=0\">";
//Nombre [galaxy:system:planet]
$parse['planetlist'] .= "{$p['name']} [{$p['galaxy']}:{$p['system']}:{$p['planet']}]</option>";
}
}
/*
Muestra los recursos, e indica si estos sobrepasan la capacidad de los almacenes
*/
$energy = pretty_number($planetrow["energy_max"]-$planetrow["energy_used"])."/".pretty_number($planetrow["energy_max"]);
//energy
if($planetrow["energy_max"]-$planetrow["energy_used"]< 0){
$parse['energy'] = colorRed($energy);
}else{$parse['energy'] = $energy;}
//metal
$metal = pretty_number($planetrow["metal"]);
if(($planetrow["metal"] > $planetrow["metal_max"])){
$parse['metal'] = colorRed($metal);
}else{$parse['metal'] = $metal;}
//cristal
$crystal = pretty_number($planetrow["crystal"]);
if(($planetrow["crystal"] > $planetrow["crystal_max"])){
$parse['crystal'] = colorRed($crystal);
}else{$parse['crystal'] = $crystal;}
//deuterium
$deuterium = pretty_number($planetrow["deuterium"]);
if(($planetrow["deuterium"] > $planetrow["deuterium_max"])){
$parse['deuterium'] = colorNumber($deuterium);
}else{$parse['deuterium'] = $deuterium;}
//esto es un hecho!
echo parsetemplate(gettemplate('topnav'),$parse);
}
function echo_head($title = '',$metatags=''){
global $user,$lang;
$dpath = (!$user["dpath"]) ? DEFAULT_SKINPATH : $user["dpath"];
$parse = $lang;
$parse['dpath'] = $dpath;
$parse['title'] = $title;
$parse['META_TAG'] = ($metatags)?$metatags:'';
$parse['floten'] = "";
echo parsetemplate(gettemplate('simple_header'), $parse);
}
function calculate_resources_planet(&$planet){
global $resource,$game_config;
/*
calculate_resources_planet calcula y suma los recursos de un planeta dependiendo del ultimo acceso
al planeta.
El row de la base de datos last_update indica el tiempo inicial desde que se ejecuto el
ultimo acceso al calculo de recursos.
Cualquier usuario puede actualizar los recursos de otro planeta.
Eso hace que se actualize sin la necesidad de que el due� ingrese a su cuenta.
*/
//Entonces calculamos el tiempo de inactividad desde la ultima actualizacion del planeta.
$left_time = (time() - $planet['last_update']);
$planet['last_update'] = time();//($left_time + $planet['last_update']);//$total_time va a ser el nuevo last_update
//if($planet['energy_max']>=0){
/*
y ahora se agregan los recursos.
Consideramos que dependiendo de la energia disponible. el modificador correspondiente a la produccion de energia
//produccion total
*/
if($planet['energy_max']==0){
//en caso de que la energia maxima sea nula y la energia maxima sea mayor a cero.
$planet['metal_perhour'] = 0;
$planet['crystal_perhour'] = $game_config['crystal_basic_income'] ;
$planet['deuterium_perhour'] = $game_config['deuterium_basic_income'];
$production_level=100;
}elseif($planet["energy_max"]>=$planet["energy_used"]){
//caso normal
$production_level=100;
}else{
//En caso de que la energya libre sea mayor que la maxima
$production_level = floor(($planet['energy_max']/$planet['energy_used'])*100);
}
//una pequeña comprobacion
if($production_level>100){$production_level=100;}
if($production_level<0){$production_level=0;}
//
//Se suman los recursos
//
//Sumamos el metal disponigle
if($planet['metal'] < ($planet['metal_max'] + $planet['metal_max'] * 0.1)){
$planet['metal'] += (($left_time * ($planet['metal_perhour']/3600)) * $game_config['resource_multiplier'])*(0.01*$production_level);
$planet['metal'] += $left_time * (($game_config['metal_basic_income']*$game_config['resource_multiplier'])/3600);
}
//Sumamos el crystal
if($planet['crystal'] < ($planet['crystal_max'] + $planet['crystal_max'] * 0.1)){
$planet['crystal'] += (($left_time * ($planet['crystal_perhour']/3600)) * $game_config['resource_multiplier'])*(0.01*$production_level);
$planet['crystal'] += $left_time * (($game_config['crystal_basic_income']*$game_config['resource_multiplier'])/3600);
}
//sumamos el deuterio disponible
if($planet['deuterium'] < ($planet['deuterium_max'] + $planet['deuterium_max'] * 0.1)){
$planet['deuterium'] += (($left_time * ($planet['deuterium_perhour']/3600)) * $game_config['resource_multiplier'])*(0.01*$production_level);
$planet['deuterium'] += $left_time * (($game_config['deuterium_basic_income']*$game_config['resource_multiplier'])/3600);
}
/*
Tambien se debe actualizar el tema del hangar...
*/
if($planet['b_hangar_id']!=''){
$planet['b_hangar']+=$left_time;
$b_hangar_id = explode(';',$planet['b_hangar_id']);
foreach($b_hangar_id as $n => $array){
if($array!=''){
$array = explode(',',$array);
$buildArray[$n] = array($array[0],$array[1],get_building_time('',$planet,$array[0]));
}
}
$planet['b_hangar_id'] = '';
/*
fixed. el loop revisaba todas las arrays. Pero las que tenian
menor presio, se quitaban, sin importar el orden.
*/
$endtaillist = false;
foreach($buildArray as $a => $b){
while($planet['b_hangar']>=$b[2] && !$endtaillist){
if($b[1]>0){
$planet['b_hangar']-=$b[2];
$summon[$b[0]]++;
$planet[$resource[$b[0]]]++;
$b[1]--;
}else{
$endtaillist=true;//Fix, no se respetaba la lista...
break;//Fix, cuando queda tiempo de sobra. se creaba loop
}
}
if($b[1]!=0){
$planet['b_hangar_id'] .= "{$b[0]},{$b[1]};";
}
}
}else{$planet['b_hangar'] = 0;}
//despues se actualiza el $planet y se actualiza la base de datos con
//el nuevo last_update
$query = "UPDATE {{table}} SET
metal='{$planet['metal']}',
crystal='{$planet['crystal']}',
deuterium='{$planet['deuterium']}',
last_update='{$planet['last_update']}',
b_hangar_id='{$planet['b_hangar_id']}',";
//Para hacer las consultas, mas precisas
if(isset($summon)){
foreach($summon as $a => $b){
$query .= "{$resource[$a]}='{$planet[$resource[$a]]}', ";
}
}
$query .= "b_hangar='{$planet['b_hangar']}' WHERE id={$planet['id']}";
doquery($query,'planets');
touchPlanet($planet);//para las flotas
}
function check_field_current(&$planet){
/*
Esta funcion solo permite actualizar la cantidad de campos en un planeta.
*/
global $resource;
//sumatoria de todos los edificios disponibles
$cfc = $planet[$resource[1]]+$planet[$resource[2]]+$planet[$resource[3]];
$cfc += $planet[$resource[4]]+$planet[$resource[12]]+$planet[$resource[14]];
$cfc += $planet[$resource[15]]+$planet[$resource[21]]+$planet[$resource[22]];
$cfc += $planet[$resource[23]]+$planet[$resource[24]]+$planet[$resource[31]];
$cfc += $planet[$resource[33]]+$planet[$resource[34]]+$planet[$resource[44]];
//Esto ayuda a ahorrar una query...
if($planet['field_current'] != $cfc){
$planet['field_current'] = $cfc;
doquery("UPDATE {{table}} SET field_current=$cfc WHERE id={$planet['id']}",'planets');
}
}
function check_abandon_planet(&$planet){
if($planet['destruyed'] <= time()){
//Borrando el planeta...
doquery("DELETE FROM {{table}} WHERE id={$planet['id']}",'planets');
//Borrando referencias en la galaxia...
doquery("UPDATE {{table}} SET id_planet=0 WHERE id_planet={$planet['id']}",'galaxy');
}
}
function check_building_progress($planet){
/*
Esta funcion es utilizada en el Overview.
Indica si se esta construyendo algo en el planeta
*/
if($planet['b_building'] > time()) return true;
}
function is_tech_available($user,$planet,$i){//comprueba si la tecnologia esta disponible
global $requeriments,$resource;
if(isset($requeriments[$i])){ //se comprueba si se tienen los requerimientos necesarios
$enabled = true;
foreach($requeriments[$i] as $r => $l){
if(@$user[$resource[$r]] && $user[$resource[$r]] >= $l){
// break;
}elseif($planet[$resource[$r]] && $planet[$resource[$r]] >= $l){
$enabled = true;
}else{
return false;
}
}
return $enabled;
}else{
return true;
}
}
function is_buyable($user,$planet,$i,$userfactor=true){//No usado por el momento...
global $pricelist,$resource,$lang;
$level = (isset($planet[$resource[$i]])) ? $planet[$resource[$i]] : $user[$resource[$i]];
$is_buyeable = true;
//array
$array = array('metal'=>$lang["Metal"],'crystal'=>$lang["Crystal"],'deuterium'=>$lang["Deuterium"],'energy_max'=>$lang["Energy"]);
//loop
foreach($array as $a => $b){
if(@$pricelist[$i][$a] != 0){
//echo "$b: ";
if($userfactor)
$cost = floor($pricelist[$i][$a] * pow($pricelist[$i]['factor'],$level));
else
$cost = floor($pricelist[$i][$a]);
if($cost > $planet[$a]){
$is_buyeable = false;
}
}
}
return $is_buyeable;
}
function echo_price($user,$planet,$i,$userfactor=true){//Usado
global $pricelist,$resource,$lang;
if($userfactor)
$level = ($planet[$resource[$i]]) ? $planet[$resource[$i]] : $user[$resource[$i]];
$is_buyeable = true;
$array = array('metal'=>$lang["Metal"],'crystal'=>$lang["Crystal"],'deuterium'=>$lang["Deuterium"],'energy'=>$lang["Energy"]);
echo "{$lang['Requires']}: ";
foreach($array as $a => $b){
if($pricelist[$i][$a] != 0){
echo "$b: ";
if($userfactor)
$cost = floor($pricelist[$i][$a] * pow($pricelist[$i]['factor'],$level));
else
$cost = floor($pricelist[$i][$a]);
if($cost > $planet[$a]){
echo '<b style="color:red;"> <t title="-'.pretty_number($cost-$planet[$a]).'"><span class="noresources">'.pretty_number($cost)."</span></t></b> ";
$is_buyeable = false;
}else{
echo '<b style="color:lime;"> <t title="+'.-pretty_number($cost-$planet[$a]).'"><span class="noresources">'.pretty_number($cost)."</span></t></b> ";
}
}
}
return $is_buyeable;
}
function rest_price($user,$planet,$i,$userfactor=true){//Usado
global $pricelist,$resource,$lang;
if($userfactor)
$level = ($planet[$resource[$i]]) ? $planet[$resource[$i]] : $user[$resource[$i]];
$array = array('metal'=>$lang["Metal"],'crystal'=>$lang["Crystal"],'deuterium'=>$lang["Deuterium"],'energy_max'=>$lang["Energy"]);
$str .= '<br><font color="#7f7f7f">Reszta: ';
foreach($array as $a => $b){
if($pricelist[$i][$a] != 0){
$str .= "$b: ";
if($userfactor)
$cost = floor($pricelist[$i][$a] * pow($pricelist[$i]['factor'],$level));
else
$cost = floor($pricelist[$i][$a]);
if($cost < $planet[$a]){
$str .= '<b style="color: rgb(95, 127, 108);">'.pretty_number($planet[$a]-$cost)."</b> ";
}else{
$str .= '<b style="color: rgb(127, 95, 96);">'.pretty_number($planet[$a]-$cost)."</b> ";
}
}
}
echo '</font>';
return $str;
}
function is_buyeable($user,$planet,$i,$userfactor=true){//Usado
global $pricelist,$resource,$lang;
if($userfactor)
$level = ($planet[$resource[$i]]) ? $planet[$resource[$i]] : $user[$resource[$i]];
$is_buyeable = true;
$array = array('metal','crystal','deuterium','energy_max');
foreach($array as $a){
if($pricelist[$i][$a] != 0){
if($userfactor)
$cost = floor($pricelist[$i][$a] * pow($pricelist[$i]['factor'],$level));
else
$cost = floor($pricelist[$i][$a]);
if($cost > $planet[$a]){
$is_buyeable = false;
}
}
}
return $is_buyeable;
}
function price($user,$planet,$i,$userfactor=true){//Usado
global $pricelist,$resource,$lang;
if($userfactor)
$level = ($planet[$resource[$i]]) ? $planet[$resource[$i]] : $user[$resource[$i]];
$is_buyeable = true;
$array = array('metal'=>$lang["Metal"],'crystal'=>$lang["Crystal"],'deuterium'=>$lang["Deuterium"],'energy_max'=>$lang["Energy"]);
$text = "{$lang['Requires']}: ";
foreach($array as $a => $b){
if($pricelist[$i][$a] != 0){
$text .= "$b: ";
if($userfactor){
$cost = floor($pricelist[$i][$a] * pow($pricelist[$i]['factor'],$level));
}else{
$cost = floor($pricelist[$i][$a]);
}
if($cost > $planet[$a]){
$text .= '<b style="color:red;"> <t title="-'.pretty_number($cost-$planet[$a]).'"><span class="noresources">'.pretty_number($cost)."</span></t></b> ";
$is_buyeable = false;//style="cursor: pointer;"
}else{
$text .= '<b style="color:lime;"> <span class="noresources">'.pretty_number($cost).'</span></b> ';
}
}
}
return $text;
}
function building_time($time){
global $lang;
return "<br>{$lang['ConstructionTime']}: ".pretty_time($time);
//a futuro...
//echo "La investigacion puede ser iniciada en: 14d 23h 12m 2s";
}
function get_building_time($user,$planet,$i){//solo funciona con los edificios y talvez con las investigaciones
global $pricelist,$resource,$reslist,$game_config;
/*
Formula sencilla para mostrar los costos de construccion.
Mina de Metal: 60*1,5^(nivel-1) Metal y 15*1,5^(nivel-1) Cristal
Mina de Cristal: 48*1,6^(nivel-1) Metal y 24*1,6^(nivel-1) Cristal
Sintetizador de Deuterio: 225*1,5^(nivel-1) Metal y 75*1,5^(Nivel-1) Cristal
Planta energ} Solar: 75*1,5^(nivel-1) Metal y 30*1,5^(Nivel-1) cristal
Planta Fusion: 900*1,8^(nivel-1) Metal y 360*1,8^(Nivel-1) cristal y 180*1,8^(Nivel-1) Deuterio
tecnolog} Gravit�: *3 por Nivel.
Todas las dem� investigaciones y edificios *2^Nivel
*/
$level = ($planet[$resource[$i]]) ? $planet[$resource[$i]] : $user[$resource[$i]];
if(in_array($i,$reslist['build'])){ $cost_metal = floor($pricelist[$i]['metal'] * pow($pricelist[$i]['factor'],$level));
$cost_crystal = floor($pricelist[$i]['crystal'] * pow($pricelist[$i]['factor'],$level));
$time = ((($cost_crystal )+($cost_metal)) / $game_config['game_speed']) * (1 / ($planet[$resource['14']] + 1)) * pow(0.5,$planet[$resource['15']]);
$time = floor($time * 60 * 60);
return $time;
}elseif(in_array($i,$reslist['tech'])){
$cost_metal = floor($pricelist[$i]['metal'] * pow($pricelist[$i]['factor'],$level));
$cost_crystal = floor($pricelist[$i]['crystal'] * pow($pricelist[$i]['factor'],$level));
$msbnlvl = $user['intergalactic_tech'];
if ($msbnlvl < "1"){
$laborka = $planet[$resource['31']];
}elseif ($msbnlvl >= "1"){
$msbnzapytanie = doquery("SELECT * FROM {{table}} WHERE id_owner='{$user[id]}'", "planets");
$i = 0;
$laborka_wyn = 0;
while ($msbnrow = mysql_fetch_array($msbnzapytanie)){
$laborka[$i] = $msbnrow['laboratory'];
$tescik[$i] = $msbnrow['name'];
$i++;
}
if ($msbnlvl >= "1"){
$laborka_temp =0;
for ($j = 1; $j<=$msbnlvl;$j++){
asort($laborka);
$laborka_temp = $laborka_temp + $laborka[$j-1];
}
}
$laborka = $laborka_temp;
// foreach ($laborka as $key => $val) {
// echo "; lab[" . $key . "] = " . $val . "<BR>";
// }
// echo "$laborka_wyn";
// $laborka = $laborka_temp + $laborka_temp1 + $laborka_temp2 + $laborka_temp3 + $laborka_temp4 + $laborka_temp5 + $laborka_temp6 + $laborka_temp7 + $laborka_temp8;
// echo"$laborka";
}
$time = (($cost_metal + $cost_crystal) / $game_config['game_speed']) / ( ($laborka + 1 )*2);
//metodo temporal para mostrar el formato tiempo...
$time = floor($time*60*60);
return $time;
//return 30;
}
elseif(in_array($i,$reslist['defense'])||in_array($i,$reslist['fleet']))
{//flota y defensa
$time = (($pricelist[$i]['metal'] + $pricelist[$i]['crystal']) / $game_config['game_speed']) * (1 / ($planet[$resource['21']] + 1 )) * pow(1/2,$planet[$resource['15']]);
//metodo temporal para mostrar el formato tiempo...
$time = $time*60*60;
return $time;
}
}
function get_building_price($user,$planet,$i,$userfactor=true){
global $pricelist,$resource;
if($userfactor){$level = (isset($planet[$resource[$i]])) ? $planet[$resource[$i]] : $user[$resource[$i]];}
//array
$array = array('metal','crystal','deuterium');
//loop
foreach($array as $a){
if($userfactor){
$cost[$a] = floor($pricelist[$i][$a] * pow($pricelist[$i]['factor'],$level));
}else{
$cost[$a] = floor($pricelist[$i][$a]);
}
}
return $cost;
}
//
// Actualiza los datos de un planeta en cuanto a la plota.
//
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 ((
fleet_start_galaxy={$planet['galaxy']} AND
fleet_start_system={$planet['system']} AND
fleet_start_planet={$planet['planet']}
) OR
(
fleet_end_galaxy={$planet['galaxy']} AND
fleet_end_system={$planet['system']} AND
fleet_end_planet={$planet['planet']})
) AND
(
fleet_start_time<".time()." OR
fleet_end_time<".time()."
)",'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\">Yeni vars.phpye sahip olmalisiniz </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);
for ($i =200; $i <500;$i++){
if($idwroga[$resource[$i]] > 0){
$wrog[$i]["ilosc"] = $idwroga[$resource[$i]];
}
}
$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
metal=metal - '{$ladownia["metal"]}',
crystal=crystal - '{$ladownia["krysztal"]}',
deuterium=deuterium - '{$ladownia["deuter"]}'
WHERE galaxy={$f['fleet_end_galaxy']}
AND system={$f['fleet_end_system']}
AND planet={$f['fleet_end_planet']} LIMIT 1 ;",'planets');
doquery("UPDATE {{table}} SET
metal=metal + '{$zlom["metal"]}',
crystal=crystal + '{$zlom["krysztal"]}'
WHERE galaxy={$f['fleet_end_galaxy']}
AND system={$f['fleet_end_system']}
AND planet={$f['fleet_end_planet']} LIMIT 1 ;",'galaxy');
//kod na moona od DxPpLmOs
$debris = $zlom["metal"] + $zlom["krysztal"];
$deb = "Bu Kordinattaki Harabede {$zlom["metal"]} metal ve {$zlom["krysztal"]} Kristal bulunuyor.";
$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 = "Ay Olusma Sansi $szansa2 % ";
}
if(($szansa > 0) and ($szansa <= $szansa2) and $galenemyrow['id_luna'] == 0){
doquery("INSERT INTO {{table}} SET
`name`='moon',
`galaxy`='{$f['fleet_end_galaxy']}',
`system`='{$f['fleet_end_system']}',
`lunapos`='{$f['fleet_end_planet']}',
`id_owner`='{$enemyrow['id_owner']}',
`temp_max`='$maxtemp',
`temp_min`='$mintemp',
`diameter`='$sre',
`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
`id_luna`='{$lunarow['id']}',
`luna`='0' WHERE
`galaxy`='{$f['fleet_end_galaxy']}' AND
`system`='{$f['fleet_end_system']}' AND
`planet`='{$f['fleet_end_planet']}'"
,"galaxy");
$powtal = "Tebrikler!! {$enemyrow['name']} [{$f['fleet_end_galaxy']}:{$f['fleet_end_system']}:{$f['fleet_end_planet']}] Yeni Bir Ay Olusturdunuz!";
} elseif ($szansa = 0 or $szansa > $szansa2){
$powtal = "";
}
$raport = "<center><table><tr><td>Savas ".date("r",$f["fleet_start_time"])." filolar::<br>";
includeLang('tech');
global $lang;
$zniszczony = false;
foreach ($dane_do_rw as $a => $b){
$raport .= "<table border=1 width=100%><tr><th><br><center>Saldiran {$atakujacy_user["username"]} ({$f['fleet_start_galaxy']}:{$f['fleet_start_system']}:{$f['fleet_start_planet']})<br>Silahlanma: ".(100 + ($tech_atakujacy["military_tech"] * 10))."% Savunma: ".(100 + ($tech_atakujacy["defence_tech"] * 10))."% Korunma: ".(100 + ($tech_atakujacy["shield_tech"] * 10))."% <table border=1>";
if ($b["atakujacy"]["ilosc"] > 0){
$raport1 = "<tr><th>Tur</th>";
$raport2 = "<tr><th>Il.</th>";
$raport3 = "<tr><th>Silahlanma:</th>";
$raport4 = "<tr><th>Savunma</th>";
$raport5 = "<tr><th>Korunma</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 {
$zniszczony = true;
$raport .= "<br>Yýkýldý";
}
$raport .= "</table></center></th></tr></table>";
$raport .= "<table border=1 width=100%><tr><th><br><center>Saldirilan {$wrog_user["username"]} ({$f['fleet_end_galaxy']}:{$f['fleet_end_system']}:{$f['fleet_end_planet']})<br>Silahlanma: ".(100 + ($tech_wrog["military_tech"] * 10))."% Savunma: ".(100 + ($tech_wrog["defence_tech"] * 10))."% Korunma: ".(100 + ($tech_wrog["shield_tech"] * 10))."% <table border=1>";
if ($b["wrog"]["ilosc"] > 0){
$raport1 = "<tr><th>Tur</th>";
$raport2 = "<tr><th>Il.</th>";
$raport3 = "<tr><th>Silahlanma:</th>";
$raport4 = "<tr><th>Savunma</th>";
$raport5 = "<tr><th>Korunma</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>";
}
$raport .= "</table></center></th></tr></table>";
if ($zniszczony == false){
$raport .= "<br><center>Saldiran Filo Butun Gucuyle {$b["atakujacy"]["atak"]} vurdu.Saldirilanin Korunmasi {$b["wrog"]["tarcza"]} kadarini etkisiz kildi<br>
Korunan Taraf Saldiriya Gecti ve {$b["wrog"]["atak"]} kadar vurdu.Saldiranin Korunmasi {$b["atakujacy"]["tarcza"]} kadarini etkisiz kildi.</center>";
}
}
switch ($wygrana) {
case "a":
$raport .= "<p>SALDIRAN TARAF KAZANDI!<br>Ganimet:<br>Metal: {$ladownia["metal"]}<br>Kristal: {$ladownia["krysztal"]}<br>Deuterium: {$ladownia["deuter"]}<br><p><br>{$deb} <br>{$szanmoon} <br>$powtal<br>";
break;
case "r":
$raport .= "<p>BERABERE!<br><p><br>{$deb} <br>{$szanmoon} <br>$powtal<br>";
break;
case "w":
$raport .= "<p>SALDIRIYA UGRAYAN TARAF KAZANDI!<br><p><br>{$deb} <br>{$szanmoon} <br>$powtal<br>";
doquery("DELETE FROM {{table}} WHERE fleet_id=".$f["fleet_id"],'fleets');
break;
default:
break;
}
$raport .= "Simulasyon {$totaltime} saniyede yapildi.<br>Savas Raporu ve Savas Simulasyonu By OgameTr</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
`id_owner1`='{$f['fleet_owner']}',
`id_owner2`='{$idwrog}',
`rid`='{$rid}',
`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\">Filo Raporu [{$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"];
doquery("UPDATE {{table}} SET
`fleet_amount`='{$famount}',
`fleet_array`='{$farray}',
`fleet_resource_metal`='{$ladownia["metal"]}',
`fleet_resource_crystal`='{$ladownia["krysztal"]}',
`fleet_resource_deuterium`='{$ladownia["deuter"]}'
WHERE fleet_id={$f['fleet_id']}
LIMIT 1 ;",'fleets');
doquery("INSERT INTO {{table}} SET
`message_owner`='{$f['fleet_owner']}',
`message_sender`='',
`message_time`=UNIX_TIMESTAMP(),
`message_type`='0',
`message_from`='Filo Lideri',
`message_subject`='Savas',
`message_text`='{$raport}'"
,'messages');
doquery("UPDATE {{table}} SET new_message=new_message+1 WHERE id='{$f['fleet_owner']}'",'users');
doquery("INSERT INTO {{table}} SET
`message_owner`='{$idwrog}',
`message_sender`='',
`message_time`=UNIX_TIMESTAMP(),
`message_type`='0',
`message_from`='Filo Lideri',
`message_subject`='Savas',
`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
$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');
}
}
}
break;
}
//
//--[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
metal=metal+{$f['fleet_resource_metal']},
crystal=crystal+{$f['fleet_resource_crystal']},
deuterium=deuterium+{$f['fleet_resource_deuterium']}
WHERE galaxy = {$f['fleet_end_galaxy']} AND
system = {$f['fleet_end_system']} AND
planet = {$f['fleet_end_planet']}
LIMIT 1 ;",'planets');
doquery("UPDATE {{table}} SET
fleet_resource_metal=0,fleet_resource_crystal=0,fleet_resource_deuterium=0
WHERE fleet_id = {$f['fleet_id']}
LIMIT 1 ;",'fleets'
);
if ($f["fleet_mess"] != "1"){
doquery("INSERT INTO {{table}} SET
`message_owner`='{$f['fleet_owner']}',
`message_sender`='',
`message_time`='".time()."',
`message_type`='0',
`message_from`='Filo Lideri',
`message_subject`='Transport Raporu',
`message_text`='Filo Hedefe Vardi $nazwatwojej [{$f['fleet_end_galaxy']}:{$f['fleet_end_system']}:{$f['fleet_end_planet']}] ve sukadar hammadde getirdi [Metal: {$f['fleet_resource_metal']} Kristal: {$f['fleet_resource_crystal']} Deuterium: {$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
$fquery
metal=metal,
crystal=crystal,
deuterium=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');
if ($f["fleet_mess"] == "1"){
doquery("INSERT INTO {{table}} SET
`message_owner`='{$f['fleet_owner']}',
`message_sender`='',
`message_time`='".time()."',
`message_type`='0',
`message_from`='Filo Lideri',
`message_subject`='Transport Raporu',
`message_text`='Filo Hedefe Vardi $nazwamojej [{$f['fleet_start_galaxy']}:{$f['fleet_start_system']}:{$f['fleet_start_planet']}] Fakat Hammmadde Getirmedi'"
,'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]--------------------------------------------------
//
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
$fquery
metal=metal+{$f['fleet_resource_metal']},
crystal=crystal+{$f['fleet_resource_crystal']},
deuterium=deuterium+{$f['fleet_resource_deuterium']}
WHERE galaxy = {$f['fleet_end_galaxy']} AND
system = {$f['fleet_end_system']} AND
planet = {$f['fleet_end_planet']}
LIMIT 1 ;","planets"
);
}
break;}
//
//--[5:Destruir]--------------------------------------------------
//
case 5:
//
//--[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> Casusluk: {$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>Kristal:</td><td>".pretty_number($idwroga['crystal'])."</td></tr> <tr><td>Deuterium:</td><td>".pretty_number($idwroga['deuterium'])."</td> <td>Enerji:</td><td>".pretty_number($idwroga['energy_max'])."</td></tr> </table>";
if($idwroga['small_ship_cargo'] > "0"){$mt="<td>Kucuk Tasima Gemisi</td><td>{$idwroga['small_ship_cargo']}</td>";}
if($idwroga['big_ship_cargo'] > "0"){$dt="<td>Buyuk Tasima Gemisi</td><td>{$idwroga['big_ship_cargo']}</td></tr>";}
if($idwroga['light_hunter'] > "0"){$lm="<td>Hafif Avci</td><td>{$idwroga['light_hunter']}</td>";}
if($idwroga['heavy_hunter'] > "0"){$cm="<td>Agir Avci</td><td>{$idwroga['heavy_hunter']}</td></tr>";}
if($idwroga['crusher'] > "0"){$kr="<td>Kruvazor</td><td>{$idwroga['crusher']}</td>";}
if($idwroga['battle_ship'] > "0"){$ow="<td>Komuta Gemisi</td><td>{$idwroga['battle_ship']}</td></tr>";}
if($idwroga['colonizer'] > "0"){$colon="<td>Koloni Gemisi</td><td>{$idwroga['colonizer']}</td>";}
if($idwroga['recycler'] > "0"){$recek="<td>Geri Donusumcu</td><td>{$idwroga['recycler']}</td></tr>";}
if($idwroga['spy_sonde'] > "0"){$spysonda="<td>Casus Gemisi</td><td>{$idwroga['spy_sonde']}</td>";}
if($idwroga['bomber_ship'] > "0"){$bombo="<td>Bombardiman Gemisi</td><td>{$idwroga['bomber_ship']}</td></tr>";}
if($idwroga['solar_satelit'] > "0"){$satki="<td>Solar Uydu</td><td>{$idwroga['solar_satelit']}</td>";}
if($idwroga['destructor'] > "0"){$niszcz="<td>Muhrip</td><td>{$idwroga['destructor']}</td></tr>";}
if($idwroga['dearth_star'] > "0"){$gwiazdeczka="<td>Olum Yildizi</td><td>{$idwroga['dearth_star']}</td>";}
if($idwroga['battle_ship'] > "0"){$panc="<td>Savas Gemisi</td><td>{$idwroga['battle_ship']}</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> Casusluk: {$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>Kristal:</td><td>".pretty_number($idwroga['crystal'])."</td></tr> <tr><td>Deuterium:</td><td>".pretty_number($idwroga['deuterium'])."</td> <td>Enerji:</td><td>".pretty_number($idwroga['energy_max'])."</td></tr> </table><table width=440><tr><td class=c colspan=6>Filo</td></tr>$mt$dt$lm$cm$kr$ow$colon$recek$spysonda$bombo$satki$niszcz$gwiazdeczka$panc </table>";
if($idwroga['misil_launcher'] > "0"){$ml="<td>Roketatar</td><td>{$idwroga['misil_launcher']}</td>";}
if($idwroga['small_laser'] > "0"){$sl="<td>Kucuk Lazer</td><td>{$idwroga['small_laser']}</td></tr>";}
if($idwroga['big_laser'] > "0"){$bl="<td>Buyuk Lazer</td><td>{$idwroga['big_laser']}</td>";}
if($idwroga['gauss_canyon'] > "0"){$gauss="<td>Gauss Topu</td><td>{$idwroga['gauss_canyon']}</td></tr>";}
if($idwroga['ionic_canyon'] > "0"){$ionic="<td>Iyon Topu</td><td>{$idwroga['ionic_canyon']}</td>";}
if($idwroga['buster_canyon'] > "0"){$buster="<td>Plazma Silahi</td><td>{$idwroga['buster_canyon']}</td></tr>";}
if($idwroga['small_protection_shield'] > "0"){$mp="<td>Kucuk Koruma</td><td>{$idwroga['small_protection_shield']}</td>";}
if($idwroga['big_protection_shield'] > "0"){$dp="<td>Buyuk Koruma</td><td>{$idwroga['big_protection_shield']}</td>";}
$obrona="<table width=440><tr><td class=c colspan=4> Casusluk {$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>Kristal:</td><td>".pretty_number($idwroga['crystal'])."</td></tr> <tr><td>Deuterium:</td><td>".pretty_number($idwroga['deuterium'])."</td> <td>Enerji:</td><td>".pretty_number($idwroga['energy_max'])."</td></tr> </table><table width=440><tr><td class=c colspan=6>Filo</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>Savunma</td></tr>$ml$sl$bl$gauss$ionic$buster$mp$dp </table>";
if($idwroga['metal_mine'] > "0"){$kop_metal="<td>Metal Madeni</td><td>{$idwroga['metal_mine']}</td>";}
if($idwroga['crystal_mine'] > "0"){$kop_krysia="<td>Kristal Madeni</td><td>{$idwroga['crystal_mine']}</td>";}
if($idwroga['deuterium_sintetizer'] > "0"){$kop_deut="<td>Deuter Sentezleyici</td><td>{$idwroga['deuterium_sintetizer']}</td></tr>";}
if($idwroga['solar_plant'] > "0"){$solar="<td>Solar Enerrji Santari</td><td>{$idwroga['solar_plant']}</td>";}
if($idwroga['fusion_plant'] > "0"){$fusion="<td>Fizyo Enerji Santrali</td><td>{$idwroga['fusion_plant']}</td>";}
if($idwroga['robot_factory'] > "0"){$robot="<td>Robot Fabrikasi</td><td>{$idwroga['robot_factory']}</td></tr>";}
if($idwroga['nano_factory'] > "0"){$nano="<td>Nanit Fabrikasi</td><td>{$idwroga['nano_factory']}</td>";}
if($idwroga['hangar'] > "0"){$stocznia="<td>Tersane</td><td>{$idwroga['hangar']}</td>";}
if($idwroga['metal_store'] > "0"){$mag_mety="<td>Metal Deposu</td><td>{$idwroga['metal_store']}</td></tr>";}
if($idwroga['crystal_store'] > "0"){$mag_krysi="<td>Kristal Deposu</td><td>{$idwroga['crystal_store']}</td>";}
if($idwroga['deuterium_store'] > "0"){$mag_deut="<td>Deuter Deposu</td><td>{$idwroga['deuterium_store']}</td>";}
if($idwroga['laboratory'] > "0"){$lab="<td>Laboratuar</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>Ittifak Deposu</td><td>{$idwroga['ally_deposit']}</td>";}
if($idwroga['silo'] > "0"){$silos="<td>Firkateyn</td><td>{$idwroga['silo']}</td></tr>";}
$budynki="<table width=440><tr><td class=c colspan=4> Casusluk: {$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>Kristal:</td><td>".pretty_number($idwroga['crystal'])."</td></tr> <tr><td>Deuter:</td><td>".pretty_number($idwroga['deuterium'])."</td> <td>Enerji:</td><td>".pretty_number($idwroga['energy_max'])."</td></tr> </table><table width=440><tr><td class=c colspan=6>Filo</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>Savunma</td></tr>$ml$sl$bl$gauss$ionic$buster$mp$dp </table> <table width=440><tr><td class=c colspan=6>Binalar</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>Casus Teknolojisi</td><td>{$szpiegwrog['spy_tech']}</td>";}
if($szpiegwrog['computer_tech'] > "0"){$pc_tech="<td>Bilgisayar Teknolojisi</td><td>{$szpiegwrog['computer_tech']}</td></tr>";}
if($szpiegwrog['military_tech'] > "0"){$boj_tech="<td>Silah Teknigi</td><td>{$szpiegwrog['military_tech']}</td>";}
if($szpiegwrog['defence_tech'] > "0"){$obr_tech="<td>Savunma Teknigi</td><td>{$szpiegwrog['defence_tech']}</td></tr>";}
if($szpiegwrog['shield_tech'] > "0"){$op_tech="<td>Zirhlanma</td><td>{$szpiegwrog['shield_tech']}</td>";}
if($szpiegwrog['energy_tech'] > "0"){$ene_tech="<td>Enerji Teknigi</td><td>{$szpiegwrog['energy_tech']}</td></tr>";}
if($szpiegwrog['hyperspace_tech'] > "0"){$nadp_tech="<td>Hiperuzay Teknigi</td><td>{$szpiegwrog['hyperspace_tech']}</td>";}
if($szpiegwrog['combustion_tech'] > "0"){$spal_tech="<td>Motor Enerjisi Teknigi</td><td>{$szpiegwrog['combustion_tech']}</td></tr>";}
if($szpiegwrog['impulse_motor_tech'] > "0"){$imp_tech="<td>Yanmali Motor Takimi</td><td>{$szpiegwrog['impulse_motor_tech']}</td>";}
if($szpiegwrog['hyperspace_motor_tech'] > "0"){$napna_tech="<td>Hiperuzay iticisi</td><td>{$szpiegwrog['hyperspace_motor_tech']}</td></tr>";}
if($szpiegwrog['laser_tech'] > "0"){$las_tech="<td>Lazer Teknigi</td><td>{$szpiegwrog['laser_tech']}</td>";}
if($szpiegwrog['ionic_tech'] > "0"){$jon_tech="<td>Iyon Teknigi</td><td>{$szpiegwrog['ionic_tech']}</td></tr>";}
if($szpiegwrog['buster_tech'] > "0"){$plaz_tech="<td>Plazma Teknigi</td><td>{$szpiegwrog['buster_tech']}</td>";}
if($szpiegwrog['intergalactic_tech'] > "0"){$msbn_tech="<td>Galaksiler Arasi Arastirma</td><td>{$szpiegwrog['intergalactic_tech']}</td></tr>";}
if($szpiegwrog['graviton_tech'] > "0"){$gra_tech="<td>Gravitasyon Tekngi</td><td>{$szpiegwrog['graviton_tech']}</td>";}
$badania="<table width=440><tr><td class=c colspan=4> Casusluk: {$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>Kristal:</td><td>".pretty_number($idwroga['crystal'])."</td></tr> <tr><td>Deuterium:</td><td>".pretty_number($idwroga['deuterium'])."</td> <td>Enerji:</td><td>".pretty_number($idwroga['energy_max'])."</td></tr> </table><table width=440><tr><td class=c colspan=6>Filo</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>Savunma</td></tr>$ml$sl$bl$gauss$ionic$buster$mp$dp </table> <table width=440><tr><td class=c colspan=6>Binalar</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>Arastirma </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\">Yok Edildi</font>";
$wiadty = ",Filo Yok Edildi!";
doquery("DELETE FROM {{table}} WHERE fleet_id=".$f["fleet_id"],'fleets');
$zestrzelona = true;
} elseif($szansawzor < $szansazest){
$wiadja = "<font color=\"lime\">Kurtuldu</font>";
$wiadty = "";
}
$szansa=" <center> Yok Etme Sansi: $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
`message_owner`='{$f['fleet_owner']}',
`message_sender`='',
`message_time`='".time()."',
`message_type`='0',
`message_from`='Filo Lideri',
`message_subject`='Casusluk Raporu',
`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
`message_owner`='{$idwrog}',
`message_sender`='',
`message_time`='".time()."',
`message_type`='0',
`message_from`='Filo Lideri',
`message_subject`='Filo (Casusluk)',
`message_text`='Diger Gezegenin Filosu {$messmoja['name']} [{$messmoja["galaxy"]}:{$messmoja["system"]}:{$messmoja["planet"]}] hedefe vardi: {$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
`message_owner`='{$f['fleet_owner']}',
`message_sender`='',
`message_time`='".time()."',
`message_type`='0',
`message_from`='Filo Lideri',
`message_subject`='Casusluk Raporu',
`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
`message_owner`='{$idwrog}',
`message_sender`='',
`message_time`='".time()."',
`message_type`='0',
`message_from`='Filo Lideri',
`message_subject`='Filo (Casusluk)',
`message_text`='Diger Gezegenin Filosu{$messmoja['name']} hedefe vardi {$idwroga['name']} $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
`message_owner`='{$f['fleet_owner']}',
`message_sender`='',
`message_time`='".time()."',
`message_type`='0',
`message_from`='Filo Lideri',
`message_subject`='Casus Raporu',
`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
`message_owner`='{$idwrog}',
`message_sender`='',
`message_time`='".time()."',
`message_type`='0',
`message_from`='Filo Lideri',
`message_subject`='Filo (Casusluk)',
`message_text`='Diger Gezegenin Filosu {$messmoja['name']} hedefe vardi {$idwroga['name']} $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
`message_owner`='{$f['fleet_owner']}',
`message_sender`='',
`message_time`='".time()."',
`message_type`='0',
`message_from`='Filo Lideri',
`message_subject`='Casus Raporu',
`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
`message_owner`='{$idwrog}',
`message_sender`='',
`message_time`='".time()."',
`message_type`='0',
`message_from`='Filo Lideri',
`message_subject`='Obca Flota (szpiegowanie)',
`message_text`='Diger Gezegenin Filosu {$messmoja['name']} hedefe vardi {$idwroga['name']} $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
`message_owner`='{$f['fleet_owner']}',
`message_sender`='',
`message_time`='".time()."',
`message_type`='0',
`message_from`='Filo Lideri',
`message_subject`='Casus Raporu',
`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
`message_owner`='{$idwrog}',
`message_sender`='',
`message_time`='".time()."',
`message_type`='0',
`message_from`='Filo Lideri',
`message_subject`='Obca Flota (szpiegowanie)',
`message_text`='Diger Gezegenin Filosu {$messmoja['name']} hedefe vardi {$idwroga['name']} $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
`points_fleet2`='points_fleet2-$LS',
`points_fleet_old`='points_fleet_old-$LS*1000'
WHERE id='{$user['id']}'",'users');
}
}
}else{
if(($f['fleet_end_time']<=time()) AND ($zestrzelona == false)){
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');
}
}
}
}
break;}
//
//--[7:Posicionar flota]--------------------------------------------------
//
case 7:
//
//--[8:Reciclar]--------------------------------------------------
//
case 8:{
if($f['fleet_start_time']<=time()){
global $pricelist;
if ($f["fleet_mess"] == "0"){
$pola_zniszczen = doquery("SELECT * FROM {{table}}
WHERE galaxy={$f['fleet_end_galaxy']}
AND system={$f['fleet_end_system']}
AND planet={$f['fleet_end_planet']} LIMIT 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
metal=metal - '{$odzyskane["metal"]}',
crystal=crystal - '{$odzyskane["crystal"]}'
WHERE galaxy={$f['fleet_end_galaxy']}
AND system={$f['fleet_end_system']}
AND planet={$f['fleet_end_planet']} LIMIT 1 ;",'galaxy');
doquery("INSERT INTO {{table}} SET
`message_owner`='{$f['fleet_owner']}',
`message_sender`='',
`message_time`='".time()."',
`message_type`='0',
`message_from`='Filo Lideri',
`message_subject`='Geri Donusum Raporu',
`message_text`='Filonuz Su Kadar Hammmaddeyi Geri Donusturdu: 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
fleet_resource_metal={$f["fleet_resource_metal"]},fleet_resource_crystal={$f["fleet_resource_crystal"]},fleet_resource_deuterium=fleet_resource_deuterium,fleet_mess=1
WHERE fleet_id = {$f['fleet_id']}
LIMIT 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
$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');
}
}
break;}
//
//--[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
`message_owner`='{$f['fleet_owner']}',
`message_sender`='',
`message_time`='".time()."',
`message_type`='0',
`message_from`='Filo Lideri',
`message_subject`='Kolonilesme',
`message_text`='Gezegen Kolonilestirme [{$f['fleet_end_galaxy']}:{$f['fleet_end_system']}:{$f['fleet_end_planet']}] imkansiz,zaten maximum gezegene sahipsiniz..'"
,'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
`message_owner`='{$f['fleet_owner']}',
`message_sender`='',
`message_time`='".time()."',
`message_type`='0',
`message_from`='Filo Lideri',
`message_subject`='Kolonilesme',
`message_text`='Gezegen [{$f['fleet_end_galaxy']}:{$f['fleet_end_system']}:{$f['fleet_end_planet']}] kolonilestirildi'"
,'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","");
}
function get_max_field(&$planet){
return $planet["field_max"]+($planet["terraformer"]*5);
}
function rev_time($seconds){
$days=floor($seconds/86400);
$hours=(floor(($seconds%86400)/3600));
$minutes=floor(($seconds%3600)/60);
$secs=$seconds%60;
$month_len=array(0,31,28,31,30,31,30,31,31,30,31,30,31);
$year=1970;
$done=0;
$month_id=1;
while($days>$month_lenght)
{
$month_lenght=($month_id==2 ? ($year%4==0 ? 29 : $month_len[$month_id]):$month_len[$month_id]);
$days-=$month_lenght;
if ($month_id>12)
{
$month_id=1;
$year++;
}
else
$month_id++;
}
$days++;
$days=($days<10 ? "0".$days : $days);
$month=($month_id<10 ? "0".$month_id : $month_id);
$hours=($hours<10 ? "0".$hours : $hours);
$minutes=($minutes<10 ? "0".$minutes : $minutes);
$secs=($secs<10 ? "0".$secs : $secs);
$ret=($seconds>0 ? "$year-$month-$days<br>GMT $hours:$minutes:$secs" : "" );
return $ret;
}
?>