PHP/MySQL | Тот же форум:)
БЕЛАЗ
256218733, Отписал в ЛС
CreepMatis
37861047, Дело в том, что он выборки то и не делает... Также у всех показывает... Не пойму, в чём ошибка(
AП
156709843, код показывай
Dizzy221
Код всего форума:
<?
include './system/common.php';
include './system/functions.php';
include './system/user.php';
if(!$user) {
header('location: /');
exit;
}
$sub = _string(_num($_GET['sub']));
$topic = _string(_num($_GET['topic']));
if(!$sub && !$topic) {
$title = 'Форум';
include './system/h.php';
?>
<div class='title'><?=$title?></div>
<div class='line'></div>
<?
$count = mysql_result(mysql_query('SELECT COUNT(*) FROM `clan_forum_sub`'),0);
if($count > 0) {
if($_GET['create'] == true && $user['access'] == 2) {
$name = _string($_POST['name']);
$access = _string(_num($_POST['access']));
if($name) {
mysql_query('INSERT INTO `clan_forum_sub` (`name`,
`access`) VALUES ("'.$name.'",
"'.$access.'")');
header('location: /clanclan_forum/');
}
?>
<div class='content'>
<form action='/clan_forum/?create=true' method='post'>
Название раздела:<br/>
<input name='name'/><br/>
Создавать топики могут:<br/>
<select name='access'>
<option value='0'>все</option>
<option value='1'>модераторы</option>
<option value='2'>администраторы</option>
</select><br/>
<input type='submit' value='Создать'/>
</form>
</div>
<div class='line'></div>
<?
}
$id = _string(_num($_GET['id']));
if($id && $user['access'] == 2) {
$i = mysql_query('SELECT * FROM `clan_forum_sub` WHERE `id` = "'.$id.'"');
$i = mysql_fetch_array($i);
if(!$i) {
header('location: /clan_forum/');
exit;
}
$name = _string($_POST['name']);
if($name) {
mysql_query('UPDATE `clan_forum_sub` SET `name` = "'.$name.'" WHERE `id` = "'.$i['id'].'"');
header('location: /clan_forum/?adm=true');
}
?>
<div class='content'>
<form action='/clan_forum/?adm=true&id=<?=$i['id']?>' method='post'>
Название раздела:<br/>
<input name='name' value='<?=$i['name']?>'/> <input type='submit' value='Сохранить'/>
</form>
</div>
<div class='line'></div>
<?
if($_GET['delete'] == true) {
$q = mysql_query('SELECT * FROM `clan_forum_topic` WHERE `sub` = "'.$i['id'].'"');
while($row = mysql_fetch_array($q)) {
mysql_query('DELETE FROM `clan_forum_comments` WHERE `topic` = "'.$row['id'].'"');
}
mysql_query('DELETE FROM `clan_forum_topic` WHERE `sub` = "'.$i['id'].'"');
mysql_query('DELETE FROM `clan_forum_sub` WHERE `id` = "'.$i['id'].'"');
header('location: /clan_forum/?adm=true');
}
}
?>
<div class='list'>
<?
$q = mysql_query('SELECT * FROM `clan_forum_sub`');
while($row = mysql_fetch_array($q)) {
$i++;
?>
<li>
<?
if($_GET['adm'] == true && $user['access'] == 2) {
?>
<span style='float: right;'>( <a href='/clan_forum/?adm=true&id=<?=$row['id']?>&delete=true'>Удалить</a> | <a href='/clan_forum/?adm=true&id=<?=$row['id']?>'>Редактировать</a> )</span>
<?
}
?>
<? $forum = mysql_query('SELECT * FROM `clan_forum_topic`'); $id_clan = mysql_query('SELECT * FROM `clans` WHERE `id` = "'.$i['id'].'"'); $id_clan = mysql_fetch_array($id_clan); if($forum[clan_id] == $clan_id){ ?><a href='/clan_forum/sub/<?=$row['id'] ?>/'><img src='/images/icon/section.png' alt='*'/><?=$row['name'] ?></a></li><?} ?>
<?
}
?>
<li <?=($_GET['adm'] == true ? '':'class=\'no_b\'')?>>
<?
if($user['access'] == 2) {
?>
<a href=''><a href='/clan_forum/<?=($_GET['adm'] == true ? '':'?adm=true')?>' <?=($_GET['adm'] == true ? 'style=\'color: #909090;\'':'')?>><img src='/images/icon/arrow.png' alt='*'/> Управление форумом</a></a>
<?
if($_GET['adm'] == true) {
?>
<li class='no_b'><a href='/clan_forum/?create=true'><img src='/images/icon/arrow.png' alt='*'/> Создать раздел</a></li>
<?
}
}
?>
</li>
</div>
<?
}
else
{
?>
<div class='content'><font color='#909090'></font></div>
<?
}
include './system/f.php';
}
elseif($sub) {
$sub = mysql_query('SELECT * FROM `clan_forum_sub` WHERE `id` = "'.$sub.'"');
$sub = mysql_fetch_array($sub);
if(!$sub) {
header('location: /clan_forum');
exit;
}
if($_GET['create'] == true && $user['access'] >= $sub['access']) {
$title = 'Новый топик';
include './system/h.php';
?>
<div class='title'><?=$title?></div>
<div class='line'></div>
<?
if($user['save'] == 1) {
$name = _string($_POST['name']);
$text = _string($_POST['text']);
if($name && $text) {
if($user['level'] > 4) {
mysql_query('INSERT INTO `clan_forum_topic` (`sub`,
`name`,
`user`,
`text`,
`time`) VALUES ("'.$sub['id'].'",
"'.$name.'",
<?
include './system/common.php';
include './system/functions.php';
include './system/user.php';
if(!$user) {
header('location: /');
exit;
}
$sub = _string(_num($_GET['sub']));
$topic = _string(_num($_GET['topic']));
if(!$sub && !$topic) {
$title = 'Форум';
include './system/h.php';
?>
<div class='title'><?=$title?></div>
<div class='line'></div>
<?
$count = mysql_result(mysql_query('SELECT COUNT(*) FROM `clan_forum_sub`'),0);
if($count > 0) {
if($_GET['create'] == true && $user['access'] == 2) {
$name = _string($_POST['name']);
$access = _string(_num($_POST['access']));
if($name) {
mysql_query('INSERT INTO `clan_forum_sub` (`name`,
`access`) VALUES ("'.$name.'",
"'.$access.'")');
header('location: /clanclan_forum/');
}
?>
<div class='content'>
<form action='/clan_forum/?create=true' method='post'>
Название раздела:<br/>
<input name='name'/><br/>
Создавать топики могут:<br/>
<select name='access'>
<option value='0'>все</option>
<option value='1'>модераторы</option>
<option value='2'>администраторы</option>
</select><br/>
<input type='submit' value='Создать'/>
</form>
</div>
<div class='line'></div>
<?
}
$id = _string(_num($_GET['id']));
if($id && $user['access'] == 2) {
$i = mysql_query('SELECT * FROM `clan_forum_sub` WHERE `id` = "'.$id.'"');
$i = mysql_fetch_array($i);
if(!$i) {
header('location: /clan_forum/');
exit;
}
$name = _string($_POST['name']);
if($name) {
mysql_query('UPDATE `clan_forum_sub` SET `name` = "'.$name.'" WHERE `id` = "'.$i['id'].'"');
header('location: /clan_forum/?adm=true');
}
?>
<div class='content'>
<form action='/clan_forum/?adm=true&id=<?=$i['id']?>' method='post'>
Название раздела:<br/>
<input name='name' value='<?=$i['name']?>'/> <input type='submit' value='Сохранить'/>
</form>
</div>
<div class='line'></div>
<?
if($_GET['delete'] == true) {
$q = mysql_query('SELECT * FROM `clan_forum_topic` WHERE `sub` = "'.$i['id'].'"');
while($row = mysql_fetch_array($q)) {
mysql_query('DELETE FROM `clan_forum_comments` WHERE `topic` = "'.$row['id'].'"');
}
mysql_query('DELETE FROM `clan_forum_topic` WHERE `sub` = "'.$i['id'].'"');
mysql_query('DELETE FROM `clan_forum_sub` WHERE `id` = "'.$i['id'].'"');
header('location: /clan_forum/?adm=true');
}
}
?>
<div class='list'>
<?
$q = mysql_query('SELECT * FROM `clan_forum_sub`');
while($row = mysql_fetch_array($q)) {
$i++;
?>
<li>
<?
if($_GET['adm'] == true && $user['access'] == 2) {
?>
<span style='float: right;'>( <a href='/clan_forum/?adm=true&id=<?=$row['id']?>&delete=true'>Удалить</a> | <a href='/clan_forum/?adm=true&id=<?=$row['id']?>'>Редактировать</a> )</span>
<?
}
?>
<? $forum = mysql_query('SELECT * FROM `clan_forum_topic`'); $id_clan = mysql_query('SELECT * FROM `clans` WHERE `id` = "'.$i['id'].'"'); $id_clan = mysql_fetch_array($id_clan); if($forum[clan_id] == $clan_id){ ?><a href='/clan_forum/sub/<?=$row['id'] ?>/'><img src='/images/icon/section.png' alt='*'/><?=$row['name'] ?></a></li><?} ?>
<?
}
?>
<li <?=($_GET['adm'] == true ? '':'class=\'no_b\'')?>>
<?
if($user['access'] == 2) {
?>
<a href=''><a href='/clan_forum/<?=($_GET['adm'] == true ? '':'?adm=true')?>' <?=($_GET['adm'] == true ? 'style=\'color: #909090;\'':'')?>><img src='/images/icon/arrow.png' alt='*'/> Управление форумом</a></a>
<?
if($_GET['adm'] == true) {
?>
<li class='no_b'><a href='/clan_forum/?create=true'><img src='/images/icon/arrow.png' alt='*'/> Создать раздел</a></li>
<?
}
}
?>
</li>
</div>
<?
}
else
{
?>
<div class='content'><font color='#909090'></font></div>
<?
}
include './system/f.php';
}
elseif($sub) {
$sub = mysql_query('SELECT * FROM `clan_forum_sub` WHERE `id` = "'.$sub.'"');
$sub = mysql_fetch_array($sub);
if(!$sub) {
header('location: /clan_forum');
exit;
}
if($_GET['create'] == true && $user['access'] >= $sub['access']) {
$title = 'Новый топик';
include './system/h.php';
?>
<div class='title'><?=$title?></div>
<div class='line'></div>
<?
if($user['save'] == 1) {
$name = _string($_POST['name']);
$text = _string($_POST['text']);
if($name && $text) {
if($user['level'] > 4) {
mysql_query('INSERT INTO `clan_forum_topic` (`sub`,
`name`,
`user`,
`text`,
`time`) VALUES ("'.$sub['id'].'",
"'.$name.'",
Стр.: 1, 2