Файл: data/klani.dat.php
Строк: 261
<?
print '<div class="spiski"><div class="zagolovok">Кланы</div><div class="line"></div><ul>';
if (isset($_GET['vstupit']))
{
$querywse1 = "SELECT * FROM `klan` where `id`='" . mysql_real_escape_string($_GET['rowt']) .
"' " ;
$sqlwse1 = mysql_query($querywse1) or die(mysql_error()) ;
$row01 = mysql_fetch_array($sqlwse1) ;
$rowt = htmlspecialchars($_GET['rowt']) ;
$rowt = mysql_real_escape_string($rowt) ;
$query = "SELECT COUNT(*) AS `counter`
FROM `klan`where `rekrut`='" . mysql_real_escape_string($opredelenie) .
"'" ;
$sql = mysql_query($query) or die(mysql_error()) ;
$row = mysql_fetch_assoc($sql) ;
$queryr = "SELECT *
FROM `table1` WHERE `klan`='" . mysql_real_escape_string($row01['name']) .
"' " ;
$sqlr = mysql_query($queryr) or die(mysql_error()) ;
$rowr = mysql_num_rows($sqlr);
if($rowr>=25){
print "<div class="style_mess_no">В клане превышено количество людей!</div>" ;
exitt($row, $opredelenie) ;
;}
if ($row['counter'] >= 1)
{
print "<div class="style_mess_no">Вы уже состоите в Рекрутах</div>" ;
exitt($row, $opredelenie) ;
}
;
$query000 = "SELECT * FROM `table1` WHERE `name`='" . mysql_real_escape_string($opredelenie) .
"'" ;
$sql000 = mysql_query($query000) or die(mysql_error()) ;
$row000 = mysql_fetch_assoc($sql000) ;
$o = strlen($row000['klan']) ;
if ($o > 1)
{
print "<div class="style_mess_no">Вы уже состоите в клане!</div>" ;
exitt($row, $opredelenie) ;
}
$time=(($rowr*3600)/3)+time();
print "<div class="style_mess_yes">Вы подали заявку на вступление в клан" . htmlspecialchars($row01['name']) .
" .! Вас смогут принять только через $rowr часов!</div>" ;
mysql_query("UPDATE `klan` SET `rekrut` = '" . mysql_real_escape_string($opredelenie) .
"' ,`time_rekrut`='$time' WHERE `id` ='" . mysql_real_escape_string($rowt) . "' LIMIT 1 ;") ;
exitt($row, $opredelenie) ;
;
}
if (!isset($_GET['rowt']))
{
$querywse = "SELECT * FROM `klan` ORDER BY `klan`.`reting` DESC " ;
$sqlwse = mysql_query($querywse) or die(mysql_error()) ;
$i = 0 ;
while ($row0 = mysql_fetch_array($sqlwse))
{$reting=0;
///////////////////////////////////
$queryr = "SELECT *
FROM `table1` WHERE `klan`='" . mysql_real_escape_string($row0['name']) .
"' " ;
$sqlr = mysql_query($queryr) or die(mysql_error()) ;
$rowr = mysql_num_rows($sqlr);
/////////////////////////////////////////////////////////
$i++ ;
print '<li>
';
echo "$i. <a href=88.php?go=klani&rowt=" . htmlspecialchars($row0['id']) .
" ><font color=green> <b>" . htmlspecialchars($row0['name']) .
" </font></b></a> </left> (" . htmlspecialchars($rowr) .
") р. [" . htmlspecialchars($row0['reting']) .
" ]" ;
print "</li>" ;
}
;
}
else
{
$rowt = htmlspecialchars($_GET['rowt']) ;
$rowt = mysql_real_escape_string($rowt) ;
$querywse = "SELECT * FROM `klan` where `id`='" . mysql_real_escape_string($rowt) .
"'" ;
$sqlwse = mysql_query($querywse) or die(mysql_error()) ;
$rowse = mysql_fetch_array($sqlwse) ;
print "<div class="chat_conteiner"><strong>Клан:</strong><font color=blue> " ;
print $rowt5 = htmlspecialchars($rowse['name']) ;
print "</font><br>
<strong>Глава:</strong><font color=red> " . htmlspecialchars($rowse['glava']) . "</font><br>
<strong>Зам.:</strong> <font color=blue> " . htmlspecialchars($rowse['zam1']) . "</font><br>" ;
if (!$rowse['rekrut'] == 0)
{
print "
<strong>Рекрут: </strong><font color=green> " . htmlspecialchars($rowse['rekrut']) .
"</font></div>" ;
}
else
{
print "<strong>Рекрут: </strong> <a href=88.php?go=klani&vstupit=1&rowt=$rowt>Вступить</a></div>" ;
}
if(!isset($_GET['ob'])){ print "<br><div class="chat_conteiner"><strong>Девиз:</strong><br><font color=green> " . htmlspecialchars($rowse['deviz']) .
"</font><br>
<strong>Описание: </strong><br><font color=red> " . htmlspecialchars($rowse['opisanie']) .
"</font><br>
<strong>Правила:</strong> <br> <font color=blue>" . htmlspecialchars($rowse['pravila']) .
"</font><br>
</div>
<li><a href=88.php?go=klani&rowt=$rowt&ob>Доска Обьявлений</a></li>" ;}
if($rowse['name']==$row['klan']){
if(isset($_GET['ob'])){print"<li><strong>Доска обьявлений клана</strong></li>"
;
$nums = 10;
if (isset($_GET['page']))
{
htmlspecialchars($_GET['page']) ;
$page = intval($_GET['page']) ;
}
else
{
$page = 1 ;
}
$query = "SELECT COUNT(*) AS `counter`
FROM `ob_klan` where `id_klan`='" . mysql_real_escape_string($rowt) .
"' " ;
$sql = mysql_query($query) or die(mysql_error()) ;
$row = mysql_fetch_assoc($sql) ;
$elements = $row['counter'] ;
$pages = ceil($elements / $nums) ;
if ($page < 1)
{
$page = 1 ;
} elseif ($page > $pages)
{
$page = $pages ;
}
$start = ($page - 1) * $nums ;
// когда у нас в таблице нет записей
if ($start < 0) $start = 0 ;
$query = "SELECT *
FROM `ob_klan`WHERE `id_klan`='" . mysql_real_escape_string($rowt) .
"'ORDER BY `time` DESC
LIMIT " . mysql_real_escape_string($start) . ", " .
mysql_real_escape_string($nums) . "" ;
$sql = mysql_query($query) or die(mysql_error()) ;
$n = mysql_num_rows($sql) ;
if ($n == 0)
{
print "<div class="style_mess_no">Обьявлений нет!" ;
exitt($row, $opredelenie) ;
}
$ii = 0 ;
while ($row = mysql_fetch_assoc($sql))
{
$ii++ ;
if ($row['odeto'] !== '1')
{
echo "<li> ".$row['text']."</li>
" ;
}
}
// далее нам надо прицепить листалку
echo('<li>');
$neighbours = 6 ;
$left_neighbour = $page - $neighbours ;
if ($left_neighbour < 1) $left_neighbour = 1 ;
$right_neighbour = $page + $neighbours ;
if ($right_neighbour > $pages) $right_neighbour = $pages ;
if ($page > 1)
{
print ' <a href="?go=rukzak&page=1">начало</a> ... <a href="?go=rukzak&page=' . ($page -
1) . '"><сюда</a> ' ;
}
for ($i = $left_neighbour; $i <= $right_neighbour; $i++)
{
if ($i != $page)
{
print ' <a href="?go=rukzak&page=' . $i . '">' . $i . '</a> ' ;
}
else
{
// выбранная страница
print ' <b>' . $i . '</b> ' ;
}
}
if ($page < $pages)
{
print ' <a href="?go=rukzak&page=' . ($page + 1) .
'">туда></a> ... <a href="?go=rukzak&page=' . $pages . '">конец</a> ' ;
}
echo('<li>');
exitt($row,$opredelenie);
;}
}
$nums = 40 ;
if (isset($_GET['page']))
{
htmlspecialchars($_GET['page']) ;
$page = intval($_GET['page']) ;
}
else
{
$page = 1 ;
}
$query = "SELECT COUNT(*) AS `counter`
FROM `table1` where `klan`='" . mysql_real_escape_string($rowt5) .
"'" ;
$sql = mysql_query($query) or die(mysql_error()) ;
$row = mysql_fetch_assoc($sql) ;
$elements = $row['counter'] ;
$pages = ceil($elements / $nums) ;
if ($page < 1)
{
$page = 1 ;
} elseif ($page > $pages)
{
$page = $pages ;
}
$start = ($page - 1) * $nums ;
if ($start < 0) $start = 0 ;
$query = "SELECT *
FROM `table1` WHERE `klan`='" . mysql_real_escape_string($rowt5) .
"' ORDER BY `lvl` DESC
LIMIT " . mysql_real_escape_string($start) . ", " .
mysql_real_escape_string($nums) . "" ;
$sql = mysql_query($query) or die(mysql_error()) ;
print "<li><strong>Состав клана</strong></li>";
while ($row = mysql_fetch_assoc($sql))
{
if($row['klan_status']==0){$klan_status="";}
if($row['klan_status']==1){$klan_status="Казначей";}
if($row['klan_status']==2){$klan_status="Любимчик клана";}
if($row['klan_status']==3){$klan_status="Старейшина";}
if($row['klan_status']==4){$klan_status="Воин";}
if($row['klan_status']==5){$klan_status="Рыцарь";}
if($row['klan_status']==6){$klan_status="Предводитель";}
if($row['klan_status']==7){$klan_status="Гладиатор";}
if($row['klan_status']==8){$klan_status="Палач";}
if($row['klan_status']==9){$klan_status="Магистр";}
if($row['klan_status']==10){$klan_status="Воительница";}
if($row['klan_status']==11){$klan_status="Послушница";}
if($row['klan_status']==12){$klan_status="Рекрут";}
if($row['klan_status']==13){$klan_status="Советник";}
if($row['klan_status']==14){$klan_status="Верховный ";}
if($row['klan_status']==15){$klan_status="Главнокомандующий";}
if($row['klan_status']==16){$klan_status="Послушник";}
if($row['klan_status']==17){$klan_status="Монах";}
if($row['klan_status']==18){$klan_status="Монах-рыцарь";}
if($row['klan_status']==19){$klan_status="Ученик";}
if($row['klan_status']==20){$klan_status="Оруженосец";}
if($row['klan_status']==21){$klan_status="Алхимик";}
if($row['klan_status']==22){$klan_status="Оружейник";}
if($row['klan_status']==23){$klan_status="Травник";}
if($row['klan_status']==24){$klan_status="Рудокоп";}
if($row['klan_status']==25){$klan_status="Кузнец";}
if($row['klan_status']==26){$klan_status="Старатель";}
if($row['klan_status']==27){$klan_status="Охотник";}
if($row['klan_status']==28){$klan_status="Потрошитель";}
if($row['klan_status']==29){$klan_status="Ювелир";}
if($row['klan_status']==30){$klan_status="Укротитель";}
if($row['klan_status']==31){$klan_status="Артфизик";}
if($row['klan_status']==32){$klan_status="Скорняк";}
if($row['klan_status']==33){$klan_status="Диггер";}
if($row['klan_status']==34){$klan_status="Бездельник";}
$kl = $row['pod_klas'] ;
$pasttt = time() - 300 ; if ($row['timme'] > $pasttt){$st="<font color=green>[on]</font>";}
else{$st="<font color=red>[off]</font>";}
echo "<li><a href=88.php?go=pessonag&row=" . htmlspecialchars($row['name']) .
" ><font color=green> <b>" . htmlspecialchars($row['name']) .
" </font></b></a> (" . htmlspecialchars($row['lvl']) . "лвл $kl) $klan_status $st</li>" ;
}
if ($rowse['glava'] == $opredelenie)
{
print "<li><a href=88.php?go=klanpanel1&klan=" . htmlspecialchars($rowse['id']) .
">Панель главы</a></strong></li>" ;
}
if ($rowse['zam1'] == $opredelenie)
{
print "<li><a href=88.php?go=klanpanel1&klan=" . htmlspecialchars($rowse['id']) .
">Панель зама</a></li>" ;
}
;
}
exitt($row,$opredelenie);
?>