rendered paste body<?php //functions.php
/*******************************************************************************************************
*
* german UGamela
* http://ugamela-forum.pheelgood.net
* UGamela basescripts from Perberos @2006 (all rights reversed)
*
*
*******************************************************************************************************/
/*
/* Urlaubmodus Check
/*****/
function check_urlaubmodus($user) {
if($user['urlaubs_modus']==1){
message("Tatil Modundasiniz!",$title=$user['username'],$dest = "",$time = "3");
}
}
/*
/* 24h Urlaubmodus Check
/*****/
function check_urlaubmodus_time() {
global $user,$game_config;
if($game_config['urlaubs_modus_erz']==1){
$begrenzung=86400; //24x60x60= 24h
$urlaub_modus_time = $user['urlaubs_modus_time'];
$urlaub_modus_time_soll = $urlaub_modus_time+$begrenzung;
$time_jetzt = time();
if($user['urlaubs_modus']==1 && $urlaub_modus_time_soll>$time_jetzt){
$soll_datum=date("d.m.Y",$urlaub_modus_time_soll);
$soll_uhrzeit=date("H:i:s",$urlaub_modus_time_soll);
message("Tatil Modundasiniz !<br>Tatil Modu tarihi $soll_datum $soll_uhrzeit<br> Ayarlardan degistirdikten sonra aktif veya pasif olur.","Tatil Modu");
}
}
}
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() {
return '';
}
//
// 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;}
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 parsetemplate($template, $array)
{ // Funcion de parce
return preg_replace('#\{([a-z0-9\-_]*?)\}#Ssie', '( ( isset($array[\'\1\']) ) ? $array[\'\1\'] : \'\' );', $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);
*/
// Edit by MoF
// file_get_contents spart Performance
$content = @file_get_contents($filename);
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'] = '';
$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'] = colorRed($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, $notouch='false'){
global $resource,$game_config,$planetrow;
if ($planetrow['planet_type'] == 3) {
$game_config['metal_basic_income'] = 0;
$game_config['crystal_basic_income'] = 0;
$game_config['deuterium_basic_income'] = 0;
}
/*
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');
}
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()) {
if ($planet['b_building_id'] == 41) {
$current = intval($planetrow['field_current']+1);
$max = intval($planetrow['field_max']+4);
doquery("UPDATE {{table}} SET field_current='".$current."', field_max='".$max."' WHERE id='".$planetrow['id']."';","planets");
}
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">Restant: ';
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.
*/
$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;
$fleetquery = doquery("SELECT * FROM {{table}} WHERE ((
fleet_start_galaxy={$planet['galaxy']} AND
fleet_start_system={$planet['system']} AND
fleet_start_planet={$planet['planet']} AND
fleet_start_type={$planet['planet_type']}
) OR
(
fleet_end_galaxy={$planet['galaxy']} AND
fleet_end_system={$planet['system']} AND
fleet_end_planet={$planet['planet']}) AND
fleet_end_type={$planet['planet_type']}
) AND
(
fleet_start_time<".time()." OR
fleet_end_time<".time()."
)",'fleets'
);
while($f = mysql_fetch_array($fleetquery)){
switch($f["fleet_mission"]){
case 1:{
if($f['fleet_start_time']<=time()){
unset($fleet,$atakujacy,$wrog,$walka);
if ($f['fleet_mess'] ==0){
global $user,$pricelist;
if (!isset($pricelist[202]["sd"])){
message("<font color=\"red\">Vars.php dosyasinda hata olustu adminle temasa gecin!</font>","Hata","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"]);
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');
$debris = $zlom["metal"] + $zlom["krysztal"];
$deb = "Saldiran taraf {$zlom["atakujacy"]} unite.<br />Savunan taraf {$zlom["wrog"]} unite.<br /> {$zlom["metal"]} Metal Unitesi ve {$zlom["krysztal"]} kristal unitesi gezegende 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 = mt_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`='Lune',
`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`='$size',
`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");
doquery("INSERT INTO {{table}} SET
`name`='LUNE',
`id_owner`='".$idwroga['id_owner']."',
`galaxy`='{$f['fleet_end_galaxy']}',
`system`='{$f['fleet_end_system']}',
`planet`='{$f['fleet_end_planet']}',
`last_update`='".time()."',
`planet_type`='3',
`image`='mond',
`diameter`='".$size."',
`field_max`='1',
`temp_min`='".$maxtemp."',
`temp_max`='".$mintemp."',
`metal`='0',
`metal_perhour`='0',
`metal_max`='100000',
`crystal`='0',
`crystal_perhour`='0',
`crystal_max`='100000',
`deuterium`='0',
`deuterium_perhour`='0',
`deuterium_max`='100000'"
,'planets');
$powtal = "Gezegen etrafinda ay olusturur {$enemyrow['name']} [{$f['fleet_end_galaxy']}:{$f['fleet_end_system']}:{$f['fleet_end_planet']}] !<br /><br />";
} elseif ($szansa = 0 or $szansa > $szansa2){
$powtal = "";
}
$raport = "<center><table><tr><td>Filolar hareket ediyor".date("r",$f["fleet_start_time"])." :<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>Saldiran {$atakujacy_user["username"]} ({$f['fleet_start_galaxy']}:{$f['fleet_start_system']}:{$f['fleet_start_planet']})<br />Silah: ".(100 + ($tech_atakujacy["military_tech"] * 10))."% Savunma: ".(100 + ($tech_atakujacy["defence_tech"] * 10))."% Defans: ".(100 + ($tech_atakujacy["shield_tech"] * 10))."% <table border=1>";
if ($b["atakujacy"]["ilosc"] > 0){
$raport1 = "<tr><th>Tip</th>";
$raport2 = "<tr><th>Sayi</th>";
$raport3 = "<tr><th>Silah</th>";
$raport4 = "<tr><th>Savunma</th>";
$raport5 = "<tr><th>Defans</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 />Détruit!";
}
$raport .= "</table></center></th></tr></table>";
$raport .= "<table border=1 width=100%><tr><th><br /><center>Savunan {$wrog_user["username"]} ({$f['fleet_end_galaxy']}:{$f['fleet_end_system']}:{$f['fleet_end_planet']})<br />Silah: ".(100 + ($tech_wrog["military_tech"] * 10))."% Savunma: ".(100 + ($tech_wrog["defence_tech"] * 10))."% Defans: ".(100 + ($tech_wrog["shield_tech"] * 10))."% <table border=1>";
if ($b["wrog"]["ilosc"] > 0){
$raport1 = "<tr><th>Tip</th>";
$raport2 = "<tr><th>Sayi</th>";
$raport3 = "<tr><th>Silah</th>";
$raport4 = "<tr><th>Savunma</th>";
$raport5 = "<tr><th>Defans</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 />Yok Edildi!";
}
$raport .= "</table></center></th></tr></table>";
if (($zniszczony == false) and !($a == 8)){
$raport .= "<br /><center>Saldiran filo tum gucuyle hedefe saldirdi{$b["atakujacy"]["atak"]} . Savunan tarafin defansi {$b["wrog"]["tarcza"]} etkisiz kildi.<br />
Filo defansi saldiri ile ayni{$b["wrog"]["atak"]} . Koruma kalkani saldiryi{$b["atakujacy"]["tarcza"]} etkisiz kildi.</center>";
}
}
switch ($wygrana) {
case "a":
$raport .= "<p>Saldiran Kazandi!<br />Ganimet <br />{$ladownia["metal"]} metal unite, {$ladownia["krysztal"]} kristal ve {$ladownia["deuter"]} deuterium.<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>Savunan 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 olusturuldu</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
`time`=UNIX_TIMESTAMP(),
`id_owner1`='{$f['fleet_owner']}',
`id_owner2`='{$idwrog}',
`rid`='{$rid}',
`a_zestrzelona`='{$a_zestrzelona}',
`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 href=\"rw.php?raport=".$rid."&keepThis=true&TB_iframe=true&height=400&width=500\" target=\"_blank\"><font color=\"red\">Rapport de combat [{$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`='3',
`message_from`='Filo Komutani',
`message_subject`='Savas Raporu',
`message_text`='{$raport}'"
,'messages');
doquery("UPDATE {{table}} SET new_message=new_message+1 WHERE id='{$f['fleet_owner']}'",'users');
doquery("UPDATE {{table}} SET mnl_attaque=mnl_attaque+1 WHERE id='{$f['fleet_owner']}'",'users');
doquery("INSERT INTO {{table}} SET
`message_owner`='{$idwrog}',
`message_sender`='',
`message_time`=UNIX_TIMESTAMP(),
`message_type`='3',
`message_from`='Kontrol Kulesi',
`message_subject`='Filo Raporu',
`message_text`='{$raport}'"
,'messages');
doquery("UPDATE {{table}} SET new_message=new_message+1 WHERE id='{$idwrog}'",'users');
doquery("UPDATE {{table}} SET mnl_attaque=mnl_attaque+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()){
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;
}
case 3:{
// $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']} AND
planet_type = {$f['fleet_end_type']}
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`='Komutan',
`message_time`='".time()."',
`message_type`='5',
`message_from`='General',
`message_subject`='Filo Geri Dondurme',
`message_text`='Filo gemilerinden bazilari geri dondu [{$f['fleet_end_galaxy']}:{$f['fleet_end_system']}:{$f['fleet_end_planet']}]. Filo {$f['fleet_resource_metal']} metal, {$f['fleet_resource_crystal']} kristal {$f['fleet_resource_deuterium']} deuterium getirdi'"
,'messages');
doquery("UPDATE {{table}} SET new_message=new_message+1 WHERE id='{$f['fleet_owner']}'",'users');
doquery("UPDATE {{table}} SET mnl_transport=mnl_transport+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']} AND
planet_type = {$f['fleet_start_type']}
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`='5',
`message_from`='General',
`message_subject`='Filo Geri Dondurme',
`message_text`='Filo gemilerinden bazilari geri dondu [{$f['fleet_start_galaxy']}:{$f['fleet_start_system']}:{$f['fleet_start_planet']}]. Fakat hammadde getirmedi.'"
,'messages');
doquery("UPDATE {{table}} SET new_message=new_message+1 WHERE id='{$f['fleet_owner']}'",'users');
doquery("UPDATE {{table}} SET mnl_transport=mnl_transport+1 WHERE id='{$f['fleet_owner']}'",'users');
doquery("UPDATE {{table}} SET fleet_mess='2' WHERE fleet_id=".$f["fleet_id"],'fleets');
}
}
}
break;}
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']} AND
planet_type = {$f['fleet_end_type']}
LIMIT 1 ;","planets"
);
}
break;}
case 5:
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>Matières premières sur {$idwroga['name']} [{$idwroga['galaxy']}:{$idwroga['system']}:{$idwroga['planet']}] le ".gmdate("d-m-Y H:i:s",time())."</td></tr>";
$surka="<table width=440><tr><td class=c colspan=4>Hammmadde {$idwroga['name']} <a href=\"galaxy.php?g={$idwroga["galaxy"]}&s={$idwroga["system"]}\">[{$idwroga["galaxy"]}:{$idwroga["system"]}:{$idwroga["planet"]}]</a> le ".gmdate("d-m-Y H:i:s",time()+2*60*60)."</td></tr><tr><td>Titane:</td><td>".pretty_number($idwroga['metal'])."</td><td>Or:</td><td>".pretty_number($idwroga['crystal'])."</td></tr> <tr><td>Hydrogéne:</td><td>".pretty_number($idwroga['deuterium'])."</td> <td>Energie:</td><td>".pretty_number($idwroga['energy_max'])."</td></tr> </table>";
if($idwroga['small_ship_cargo'] > "0"){$mt="<td>Kucuk Nakliye Gemisi</td><td>{$idwroga['small_ship_cargo']}</td>";}
if($idwroga['big_ship_cargo'] > "0"){$dt="<td>Buyuk Nakliye 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 Sondasi</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['battleship'] > "0"){$panc="<td>Firkateyn</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>Hammadde {$idwroga['name']} <a href=\"galaxy.php?g={$idwroga["galaxy"]}&s={$idwroga["system"]}\">[{$idwroga["galaxy"]}:{$idwroga["system"]}:{$idwroga["planet"]}]</a> le ".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$apac$supernova </table>";
if($idwroga['misil_launcher'] > "0"){$ml="<td>Roket Atar</td><td>{$idwroga['misil_launcher']}</td>";}
if($idwroga['small_laser'] > "0"){$sl="<td>Hafif Lazer</td><td>{$idwroga['small_laser']}</td></tr>";}
if($idwroga['big_laser'] > "0"){$bl="<td>Agir 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 Atici</td><td>{$idwroga['buster_canyon']}</td></tr>";}
if($idwroga['small_protection_shield'] > "0"){$mp="<td>Kucuk Kalkan Kubbesi</td><td>{$idwroga['small_protection_shield']}</td>";}
if($idwroga['big_protection_shield'] > "0"){$dp="<td>Buyuk Kalkan Kubbesi</td><td>{$idwroga['big_protection_shield']}</td>";}
$obrona="<table width=440><tr><td class=c colspan=4>Hammadde {$idwroga['name']} <a href=\"galaxy.php?g={$idwroga["galaxy"]}&s={$idwroga["system"]}\">[{$idwroga["galaxy"]}:{$idwroga["system"]}:{$idwroga["planet"]}]</a> le ".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$apac$supernova </table> <table width=440><tr><td class=c colspan=4>Défenses</td></tr>$ml$sl$bl$gauss$ionic$buster$mp$dp$black_canon </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>Deuterium Sentezleyici</td><td>{$idwroga['deuterium_sintetizer']}</td></tr>";}
if($idwroga['solar_plant'] > "0"){$solar="<td>Solar Enerji Santrali</td><td>{$idwroga['solar_plant']}</td>";}
if($idwroga['fusion_plant'] > "0"){$fusion="<td>Termik 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>Uzay Tersanesi</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>Deuterim Deposu</td><td>{$idwroga['deuterium_store']}</td>";}
if($idwroga['laboratory'] > "0"){$lab="<td>Bilimsel Arastirma Merkezi</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>Roket Silosu</td><td>{$idwroga['silo']}</td></tr>";}
$budynki="<table width=440><tr><td class=c colspan=4>Hammadde {$idwroga['name']} <a href=\"galaxy.php?g={$idwroga["galaxy"]}&s={$idwroga["system"]}\">[{$idwroga["galaxy"]}:{$idwroga["system"]}:{$idwroga["planet"]}]</a> le ".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$apac$supernova </table> <table width=440><tr><td class=c colspan=4>Defans</td></tr>$ml$sl$bl$gauss$ionic$buster$mp$dp$black_canon </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>Casusluk Teknigi</td><td>{$szpiegwrog['spy_tech']}</td>";}
if($szpiegwrog['computer_tech'] > "0"){$pc_tech="<td>Bilgisayar Teknigi</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>Koruyucu Kalkan Teknigi</td><td>{$szpiegwrog['defence_tech']}</td></tr>";}
if($szpiegwrog['shield_tech'] > "0"){$op_tech="<td>Uzay Gemilerinin Zirhlandirilmasi</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>Impulus Motor Takimi</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>Hammadde {$idwroga['name']} <a href=\"galaxy.php?g={$idwroga["galaxy"]}&s={$idwroga["system"]}\">[{$idwroga["galaxy"]}:{$idwroga["system"]}:{$idwroga["planet"]}]</a> le ".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$apac$supernova </table> <table width=440><tr><td class=c colspan=4>Defans</td></tr>$ml$sl$bl$gauss$ionic$buster$mp$dp$black_canon </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$elec_tech$las_tech$jon_tech$plaz_tech$msbn_tech$gra_tech$black_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;
if($szansamax > 100){
$szansamax = 100;
}
$szansawzor = rand(0, $szansamax);
$szansazest = rand(0, 100);
if($szansawzor >= $szansazest){
$wiadja = "<font color=\"red\"></font>";
$wiadty = "";
doquery("DELETE FROM {{table}} WHERE fleet_id=".$f["fleet_id"],'fleets');
$zestrzelona = true;
} elseif($szansawzor < $szansazest){
$wiadja = "";
$wiadty = "";
}
$szansa=" <center>Filoyu 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("UPDATE {{table}} SET mnl_spy=mnl_spy+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`='Kontrol Kulesi',
`message_subject`='Casusluk Raporu',
`message_text`='Dusman Filosu {$messmoja['name']} <a href=\"galaxy.php?g={$messmoja["galaxy"]}&s={$messmoja["system"]}\">[{$messmoja["galaxy"]}:{$messmoja["system"]}:{$messmoja["planet"]}]</a> gezegeninin etrafinda goruldu {$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 mnl_spy=mnl_spy+1 WHERE id='{$f['fleet_owner']}'",'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("UPDATE {{table}} SET mnl_spy=mnl_spy+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`='Kontrol Kulesi',
`message_subject`='Casusluk Raporu',
`message_text`='Yabanci bir filo {$messmoja['name']} <a href=\"galaxy.php?g={$messmoja["galaxy"]}&s={$messmoja["system"]}\">[{$messmoja["galaxy"]}:{$messmoja["system"]}:{$messmoja["planet"]}]</a> gezegeninin etrafinda goruldu {$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 mnl_spy=mnl_spy+1 WHERE id='{$f['fleet_owner']}'",'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`='Casusluk Raporu',
`message_text`='$obrona<br /> $szansa'"
,'messages');
doquery("UPDATE {{table}} SET new_message=new_message+1 WHERE id='{$f['fleet_owner']}'",'users');
doquery("UPDATE {{table}} SET mnl_spy=mnl_spy+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`='Kontrol Kulesi',
`message_subject`='Casusluk Raporu',
`message_text`='Yabanci bir filo {$messmoja['name']} <a href=\"galaxy.php?g={$messmoja["galaxy"]}&s={$messmoja["system"]}\">[{$messmoja["galaxy"]}:{$messmoja["system"]}:{$messmoja["planet"]}]</a> gezegeninin etrafinda goruldu {$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 mnl_spy=mnl_spy+1 WHERE id='{$f['fleet_owner']}'",'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`='Casusluk Raporu',
`message_text`='$budynki<br /> $szansa'"
,'messages');
doquery("UPDATE {{table}} SET new_message=new_message+1 WHERE id='{$f['fleet_owner']}'",'users');
doquery("UPDATE {{table}} SET mnl_spy=mnl_spy+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`='Kontrol Kulesi',
`message_subject`='Casusluk Raporu',
`message_text`='Yabanci fir filo {$messmoja['name']} <a href=\"galaxy.php?g={$messmoja["galaxy"]}&s={$messmoja["system"]}\">[{$messmoja["galaxy"]}:{$messmoja["system"]}:{$messmoja["planet"]}]</a> gezegeninin etrafinda goruldu {$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 mnl_spy=mnl_spy+1 WHERE id='{$f['fleet_owner']}'",'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`='Casusluk Raporu',
`message_text`='$badania<br /> $szansa'"
,'messages');
doquery("UPDATE {{table}} SET new_message=new_message+1 WHERE id='{$f['fleet_owner']}'",'users');
doquery("UPDATE {{table}} SET mnl_spy=mnl_spy+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`='Kontrol Kulesi',
`message_subject`='Casusluk Raporu',
`message_text`='Yabanci bir filo{$messmoja['name']} [{$messmoja["galaxy"]}:{$messmoja["system"]}:{$messmoja["planet"]}] gezegeninin etrafinda goruldu {$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 mnl_spy=mnl_spy+1 WHERE id='{$f['fleet_owner']}'",'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;}
case 7:
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`='4',
`message_from`='Filo',
`message_subject`='Gezinti Raporu',
`message_text`='Bu Kadar {$odzyskane["metal"]} metal ve {$odzyskane["crystal"]} kristal topladiniz.'"
,'messages');
doquery("UPDATE {{table}} SET new_message=new_message+1 WHERE id='{$f['fleet_owner']}'",'users');
doquery("UPDATE {{table}} SET mnl_exploit=mnl_exploit+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;}
case 9:{
$limit_planet=9;
$ilosc=mysql_result(doquery("SELECT count(208) FROM {{table}} WHERE id_owner='{$f['fleet_owner']}' AND planet_type = 1",'planets'),0);
$ilune=mysql_result(doquery("SELECT count(208) FROM {{table}} WHERE id_owner='{$f['fleet_owner']}' AND planet_type = 3",'planets'),0);
if($ilosc>=$limit_planet || $ilune>=$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 Raporu',
`message_text`='Filo [{$f['fleet_end_galaxy']}:{$f['fleet_end_system']}:{$f['fleet_end_planet']}], kordinatlara ulasti, fakat kolonilesme imkansiz zaten 9 gezegeniniz var'"
,'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 Raporu',
`message_text`='Filo [{$f['fleet_end_galaxy']}:{$f['fleet_end_system']}:{$f['fleet_end_planet']}], kordinatlarina ulasti, filo liderleri gezegene yerlesme islemlerini baslatti. '"
,'messages');
}else{
echo "";
}
/*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"
);
}*/
break;}
case 15:
{
if($f['fleet_start_time']<=time()){
$farray = explode(";", $f['fleet_array']); //Boucle pour séparer ce qu'il y a comme vaisseaux dans la table fleet
foreach ($farray as $Item =>$Group)
{if ( $Group != '') { $Class = explode (",", $Group);
$TypeVaisseau = $Class[0]; $NbreVaisseau = $Class[1];
if($Class[0] == 202) //Combien de vaisseaux de chaque type, servira au calcul de probabilité et au gain ou perte.
{$nb_pt = $Class[1];
}
if($Class[0] == 203)
{$nb_gt = $Class[1];
}
if($Class[0] == 204)
{$nb_cl = $Class[1];
}
if($Class[0] == 205)
{$nb_clr = $Class[1];
}
if($Class[0] == 206)
{$nb_cruise = $Class[1];
}
if($Class[0] == 207)
{$nb_vb = $Class[1];
}
if($Class[0] == 208)
{$nb_colo = $Class[1];
}
if($Class[0] == 209)
{$nb_rc = $Class[1];
}
if($Class[0] == 210)
{$nb_spy = $Class[1];
}
if($Class[0] == 211)
{$nb_bomb = $Class[1];
}
if($Class[0] == 213)
{$nb_des = $Class[1];
}
if($Class[0] == 214)
{$nb_rip = $Class[1];
}
if($Class[0] == 215)
{$nb_traq = $Class[1];
}
} }
} //Fin de la boucle de récup des vaisseaux
$nb_vaisseaux = $f['fleet_amount']; //On récupère le nombre total de vaisseaux
$capacite_recup = $nb_pt * 5000 + $nb_gt * 25000 ; //On calcul les ressources maximum qui peuvent être récupéré
//Maintenant on calcul en points toute la flotte
$total_points = ( $nb_pt ) + ($nb_gt * 1.5 ) + ($nb_cl * 0.5 )+ ($nb_clr * 1.5) + ($nb_cruise * 2 )+ ($nb_vb * 2.5 ) + ($nb_colo * 0.5 )+ ($nb_rc) + ($nb_spy * 0.01) + ($nb_bomb * 3) + ($nb_rip * 5) + ($nb_traq * 3);
$hasard = rand(1,10); //On choisis un nombre entre 1 et 10 compris
//En fonction de ce nombre on va pouvoir gérer les conditions d'expéditions
if($hasard < 3) //Destruction de la flotte envoyé
{
doquery("DELET FROM {{table}} WHERE fleet_id=".$f["fleet_id"],'fleets');
doquery("INSERT INTO {{table}} SET
`message_owner`='{$f['fleet_owner']}',
`message_sender`='',
`message_time`='".time()."',
`message_type`='4',
`message_from`='Gezgin',
`message_subject`='Gezgin Raporu ',
`message_text`='Filo kara delige takildi ve tamamen yok oldu !'"
,'messages');
doquery("UPDATE {{table}} SET new_message=new_message+1 WHERE id='{$f['fleet_owner']}'",'users');
}
if($hasard >= 3 && $hasard < 6) //Gain de ressource
{
$capacite_recup_mini = $capacite_recup - 5000;
$capacite_recup_maxi = $capacite_recup + 5000;
$capacite_recup_total = rand($capacite_recup_mini,$capacite_recup_maxi);
$metal_recup = $capacite_recup_total / 2;
$cristal_recup = $capacite_recup_total / 4;
$deut_recup = $capacite_recup_total / 6;
doquery("UPDATE {{table}} SET
metal= metal + {$metal_recup},
crystal= crystal + {$cristal_recup},
deuterium= deuterium + {$deut_recup}
WHERE galaxy = {$f['fleet_start_galaxy']} AND
system = {$f['fleet_start_system']} AND
planet = {$f['fleet_start_planet']} AND
planet_type = {$f['fleet_start_type']}
LIMIT 1 ;",'planets');
doquery("INSERT INTO {{table}} SET
`message_owner`='{$f['fleet_owner']}',
`message_sender`='',
`message_time`='".time()."',
`message_type`='4',
`message_from`='Gezgin',
`message_subject`='Gezgin Raporu ',
`message_text`='Filo hic ayak basilmamis bir gezegen kesfetti! <br> Gezginleriniz yanlarinda $metal_recup metal, $cristal_recup kristal $deut_recup deuterium getirdiler'"
,'messages');
doquery("UPDATE {{table}} SET new_message=new_message+1 WHERE id='{$f['fleet_owner']}'",'users');
}
if($hasard >= 6 && $hasard < 8) //Aucun gain mais aucune perte
{
doquery("INSERT INTO {{table}} SET
`message_owner`='{$f['fleet_owner']}',
`message_sender`='',
`message_time`='".time()."',
`message_type`='4',
`message_from`='Gezgin',
`message_subject`='Gezgin Raporu',
`message_text`='Gezginleriniz gezegende iseyarar birsey bulamadilar ama sizin icin supernova veya krater resimleri cekmisler'"
,'messages');
doquery("UPDATE {{table}} SET new_message=new_message+1 WHERE id='{$f['fleet_owner']}'",'users');
}
if($hasard == 9 || $hasard == 10) //Gain de Vaisseaux
{
$nb_vaisseaux_recup = $total_points / $nb_vaisseaux;
$vrecup = $nb_vaisseaux_recup;
//Mise a 0 des gains de vaisseaux
$recup_pt = 0;
$recup_gt = 0;
$recup_cl = 0;
$recup_clr = 0;
$recup_cruise = 0;
$recup_vb = 0 ;
$recup_colo = 0;
$recup_rc = 0;
$recup_spy = 0;
$recup_bomb = 0;
$recup_des = 0;
$recup_rip = 0;
$recup_traq = 0;
//Gain de Vaisseaux en fonction de $vrecup
if($nb_pt > 0){
$recup_pt = $vrecup * 1;
}
if($nb_gt > 0){
$recup_gt = $vrecup * 1 ;
}
if($nb_gt > 0){
$recup_gt = $vrecup * 0.5 ;
}
if($nb_cl > 0){
$recup_cl = $vrecup * 1 ;
}
if($nb_clr > 0){
$recup_clr = $vrecup * 0.5 ;
}
if($nb_cruise > 0){
$recup_cruise = $vrecup * 0.25 ;
}
if($nb_vb > 0){
$recup_vb = $vrecup * 0.125 ;
}
if($nb_colo > 0){
$recup_colo = $vrecup * 0.5 ;
}
if($nb_rc > 0){
$recup_rc = $vrecup * 1 ;
}
if($nb_spy > 0){
$recup_spy = $vrecup * 1 ;
}
if($nb_bomb > 0){
$recup_bomb = $vrecup * 0.0625 ;
}
if($nb_des > 0){
$recup_des = $vrecup * 0.0625 ;
}
if($nb_rip > 0){
$recup_rip = $vrecup * 0.03125 ;
}
if($nb_traq > 0){
$recup_traq = $vrecup * 0.0625 ;
}
//On va passer les valurs des vaisseaux gagné en entier pour ne pas avoir 1.5 rip par exemple et en int pour ne pas avoir un gain enormissime
$recup_pt = intval($recup_pt);
$recup_gt = intval($recup_gt);
$recup_cl = intval($recup_cl);
$recup_clr = intval($recup_clr);
$recup_cruise = intval($recup_cruise);
$recup_vb = intval($recup_vb);
$recup_colo = intval($recup_colo);
$recup_rc = intval($recup_rc);
$recup_spy = intval($recup_spy);
$recup_bomb = intval($recup_bomb);
$recup_des = intval($recup_des);
$recup_rip = intval($recup_rip);
$recup_traq = intval($recup_traq);
//Maintenant on ajoute tout ça à la planete
doquery("UPDATE {{table}} SET
small_ship_cargo = small_ship_cargo + {$recup_pt},
big_ship_cargo = big_ship_cargo + {$recup_gt},
light_hunter=light_hunter+ {$recup_cl},
heavy_hunter=heavy_hunter+ {$recup_clr},
crusher=crusher+ {$recup_cruise},
battle_ship=battle_ship+ {$recup_vb},
colonizer=colonizer+ {$recup_colo},
recycler=recycler+ {$recup_rc},
spy_sonde=spy_sonde+ {$recup_spy},
bomber_ship=bomber_ship+ {$recup_bomb},
destructor=destructor+ {$recup_des},
dearth_star=dearth_star+ {$recup_rip},
battleship=battleship+ {$recup_traq}
WHERE galaxy = {$f['fleet_start_galaxy']} AND
system = {$f['fleet_start_system']} AND
planet = {$f['fleet_start_planet']}
LIMIT 1 ;",'planets');
//Le petit message et c'est fini
doquery("INSERT INTO {{table}} SET
`message_owner`='{$f['fleet_owner']}',
`message_sender`='',
`message_time`='".time()."',
`message_type`='4',
`message_from`='Gezgin',
`message_subject`='Gezgin Raporu ',
`message_text`='Gezginleriniz mukemmel halde hic bozulmamis baska gezegenlere ait araclar buldular<br>
Bulunan Gemiler : <br>
Kucuk Nakliye Gemisi = $recup_pt <br>
Buyuk Nakliye Gemisi = $recup_gt<br>
Hafif Avci = $recup_cl<br>
Agir Avci = $recup_clr<br>
Kruvazor = $recup_cruise<br>
Komuta Gemisi = $recup_vb<br>
Koloni Gemisi = $recup_colo<br>
Geri Donusumcu = $recup_rc<br>
Casus Sondasi = $recup_spy<br>
Bombardiman Gemisi = $recup_bomb<br>
Muhrip = $recup_des<br>
Olum Yildizi = $recup_rip<br>
Firkateyn = $recup_traq<br>
'"
,'messages');
doquery("UPDATE {{table}} SET new_message=new_message+1 WHERE id='{$f['fleet_owner']}'",'users');
}
}
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;
}
function check_abandon_luna ($lunarow) {
if (($lunarow['destruyed']+172800) <= time() && $lunarow['destruyed'] != 0) {
$query = doquery("DELETE FROM {{table}} WHERE id = '".$lunarow['id']."'", 'lunas');
}
}
?>