Файл: sosedi.php
Строк: 64
<?
include'dobavka/head.php';
include'dobavka/conf.php';
include'dobavka/sess.php';
include'dobavka/tabl.php';
echo"<b>Соседи</b><br/>";
//////////////////////////////////////////////////////
$ss1 = mysql_fetch_array(mysql_query("SELECT * FROM gos WHERE strana='$nik' ORDER BY `gos`.`datareg` DESC"));
$ss2 = mysql_query("SELECT * FROM gos WHERE datareg < '$ss1[3]' ORDER BY datareg DESC, datareg asc LIMIT 0 , 10");
while ($west = mysql_fetch_array($ss2))
{
$p1=$west['strana'];$p3=$west['id'];$p3=($p3*237)+24;$p2=$west['datareg'];$p4=time();$p5=$p4-$p2;$kl=$west['klan'];
////////////////////////////////////
$sec1=$p5;
$hou1=floor($sec1/3600);
$sec1-=$hou1*3600;
$min1=floor($sec1/60);
$sec1-=$min1*60;
////////////////////////////////////
$sd2=mysql_fetch_array(mysql_query("SELECT id FROM voiny WHERE strana1='$p1' AND strana='$nik'"));
$sd3=mysql_fetch_array(mysql_query("SELECT id FROM soyuz WHERE strana2='$p1' AND strana1='$nik'"));
$sd4=mysql_fetch_array(mysql_query("SELECT id,name FROM klan WHERE id='$kl'"));
if($sd2['id']>0){
echo'<a href="domm/k_centr/index.php?kc=sos1&zh='.$p3.'&der='.$key.'">'.$p1.'</a>';echo"($hou1 час.$min1 мин.)";
if($sd4['id']>0){echo"<font color=green>$sd4[name]</font>";}else{}
echo'{враг}<br/>';
}else{
echo'<a href="domm/k_centr/index.php?kc=sos1&zh='.$p3.'&der='.$key.'">'.$p1.'</a>';echo"($hou1 час.$min1 мин.)";
if($sd4['id']>0){echo"<font color=green>$sd4[name]</font>";}else{}
if($sd3['id']>0){echo'{союзник}<br/>';}else{echo'<br/>';}
}
}
$ss2 = mysql_query("SELECT * FROM gos WHERE datareg > '$ss1[3]' ORDER BY datareg LIMIT 0 , 10");
while ($east = mysql_fetch_array($ss2))
{
$p1=$east['strana'];$p3=$east['id'];$p3=($p3*237)+24;$p2=$east['datareg'];$p4=time();$p5=$p4-$p2;$kl=$east['klan'];
//////////////////////////////////
$sec1=$p5;
$hou1=floor($sec1/3600);
$sec1-=$hou1*3600;
$min1=floor($sec1/60);
$sec1-=$min1*60;
//////////////////////////////////
$sd2=mysql_fetch_array(mysql_query("SELECT id FROM voiny WHERE strana1='$p1' AND strana='$nik'"));
$sd3=mysql_fetch_array(mysql_query("SELECT id FROM soyuz WHERE strana2='$p1' AND strana1='$nik'"));
$sd4=mysql_fetch_array(mysql_query("SELECT id,name FROM klan WHERE id='$kl'"));
if($sd2['id']>0){
echo'<a href="domm/k_centr/index.php?kc=sos1&zh='.$p3.'&der='.$key.'">'.$p1.'</a>';echo"($hou1 час.$min1 мин.)";
if($sd4['id']>0){echo"<font color=green>$sd4[name]</font>";}else{}
echo'{враг}<br/>';
}else{
echo'<a href="domm/k_centr/index.php?kc=sos1&zh='.$p3.'&der='.$key.'">'.$p1.'</a>';echo"($hou1 час.$min1 мин.)";
if($sd4['id']>0){echo"<font color=green>$sd4[name]</font>";}else{}
if($sd3['id']>0){echo'{союзник}<br/>';}else{echo'<br/>';}
}
}
/////////////////////////////////////////////////////
include_once("dobavka/foot.php");
?>