Файл: gorod/zona.php
Строк: 40
<?php
define('IN_PHPBB', true);
$phpbb_root_path = '../';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
include($phpbb_root_path . 'fetchposts.'.$phpEx);
$userdata = session_pagestart($user_ip, PAGE_GENERAL);
init_userprefs($userdata);
$orig_word = array();
$replacement_word = array();
obtain_word_list($orig_word, $replacement_word);
$gconf=mysql_fetch_array(mysql_query("SELECT * FROM `phpbb_gorod_conf`"));
include($phpbb_root_path . 'includes/page_header.'.$phpEx);
if($userdata['user_active']!=1){echo 'Пройдите регистрацию!';}else{
if($gconf[0]['open']!=1){
echo '<table width="100%" cellpadding="4" cellspacing="0" border="0" class="forumline">
<tr><td class="catSides"><span class="cattitle"><center>Тюряга</center></span></td></tr>';
echo '<tr><td class="row1">';
$k_post=mysql_result(mysql_query("SELECT count(*) FROM " . BANLIST_TABLE . ""),0);
if($k_post==0){echo 'Тюрьма пока пуста!';}else{
$x=mysql_query("SELECT `ban_userid`,`ban_id` FROM " . BANLIST_TABLE . " ORDER BY `user_id` DESC LIMIT $start,$onpage");
echo 'Всего на зоне <font color="red">('.$k_post.')</font> чел<br/>';
while($row=mysql_fetch_assoc($x)){
$kto=mysql_query("SELECT ".USERS_TABLE." FROM `username` WHERE `user_id`='".$row['id_ban']."'");
$kto=mysql_fetch_assoc($kto);
$kogo=mysql_query("SELECT ".USERS_TABLE." FROM `username` WHERE `user_id`='".$row['user_id']."'");
$kogo=mysql_fetch_assoc($kogo);
echo '<hr/>Кличка: <b>'.$kogo['username'].'</b><br/>';
};
};
echo '<div class="msg"><a href="index.php">В город</a></div>';
echo '</td></tr></table>';
}
}
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
?>