Файл: titwar.ru/func/funczdan/1_rat_cita/ratusha/sosedi.php
Строк: 58
<?php
echo TIT.'<b><u>Соседи:</u></b>'.D;
////////////////////////////
$ctet = mysql_fetch_array(mysql_query("SELECT * FROM users WHERE id='$user[id]'"));
$ctetnomer = mysql_fetch_array(mysql_query("SELECT * FROM map WHERE name='$ctet[1]'"));
$sosed_zapad1 = mysql_fetch_array(mysql_query("SELECT * FROM users WHERE id='$ctetnomer[6]'"));
///////////////////////////
ECHO B;
$a = mysql_query("SELECT * FROM map WHERE id < '$ctetnomer2[0]' ORDER BY id DESC, id asc LIMIT 0 , 5");
while ($east = mysql_fetch_array($a))
{
$userses= mysql_fetch_array(mysql_query("SELECT * FROM users WHERE id='$east[id_user]'"));
$clanes = mysql_fetch_array(mysql_query("SELECT * FROM clan WHERE id='$userses[clan]'"));
$infoclanes= ' <b>'.$clanes['name'].'</b>';
$poiskwar = mysql_num_rows(mysql_query("SELECT * FROM wars WHERE id_cover='$east[id_user]' AND id_att='$user[id]'"));
if($poiskwar != 0)
{
$inform1='[враг]';
}
else
{
$inform1='';
}
$poiskwar11 = mysql_num_rows(mysql_query("SELECT * FROM wars WHERE id_cover='$user[id]' AND id_att='$east[id_user]'"));
if($poiskwar11 != 0)
{
$inform11='[враг]';
}
else
{
$inform11='';
}
if ($userses['storona'] == '1'){$storona = ''.$russtorona.'';}
if ($userses['storona'] == '2'){$storona = ''.$shastorona.'';}
echo '<a href="../inf.php?id=',$east['id_user'],'&mod=',$east['id'],'&zapad=1'.$ssilki2.'">',$east['strana'],'</a> '.$storona.' '.$infoclanes.' '.$inform1.' '.$inform11.'<br>';
}
$b = mysql_query("SELECT * FROM map WHERE id > '$ctetnomer[0]' LIMIT 0 , 5");
while ($west = mysql_fetch_array($b))
{
$userses= mysql_fetch_array(mysql_query("SELECT * FROM users WHERE id='$west[id_user]'"));
$clanes = mysql_fetch_array(mysql_query("SELECT * FROM clan WHERE id='$userses[clan]'"));
$infoclanes= ' <b>'.$clanes['name'].'</b>';
$poiskwar2 = mysql_num_rows(mysql_query("SELECT * FROM wars WHERE id_cover='$user[id]' AND id_att='$west[id_user]'"));
if($poiskwar2 != 0)
{
$inform2='[враг]';
}
else
{
$inform2='';
}
$poiskwar22 = mysql_num_rows(mysql_query("SELECT * FROM wars WHERE id_cover='$west[id_user]' AND id_att='$user[id]'"));
if($poiskwar22 != 0)
{
$inform22='[враг]';
}
else
{
$inform22='';
}
if ($userses['storona'] == '1'){$storona = ''.$russtorona.'';}
if ($userses['storona'] == '2'){$storona = ''.$shastorona.'';}
echo '<a href="../inf.php?id=',$west['id_user'],'&mod=',$west['id'],'&vostok=1'.$ssilki2.'">',$west['strana'],'</a>'.$storona.''.$infoclanes.' '.$inform2.' '.$inform22.'<br>';
}
ECHO D;
?>