Файл: group/group.php
Строк: 77
<?php
require_once '../includes/sys.php';
require_once '../includes/header.php';
switch ($_GET['act']) {
default:
$id = abs(intval($_GET['id']));
// $public = mysql_query("SELECT * FROM `publ` WHERE `id` = '$id'");
$p_peoples = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `publ_enter` WHERE `id_publ` = '$id'"), 0);
$p_people=$p_peoples+1;
$publ_r = mysql_query("SELECT * FROM `publ` WHERE `id` = '$id'");
while ($publ = mysql_fetch_assoc($publ_r)) {
$p_enter = mysql_fetch_assoc(mysql_query("SELECT * FROM `publ_enter` WHERE `id_publ` = '$id' AND `id_user` = '$u[id]'"));
$p_adm = mysql_fetch_assoc(mysql_query("SELECT * FROM `publ_adm` WHERE `id_publ` = '$id' and `access` = '2'"));
if($u['id']==$publ['id_user'] and $p_adm['id_user']!=$u['id']){mysql_query("INSERT INTO `publ_adm` (`id_user`, `id_publ`, `access`) VALUES ('$u[id]', '$id', '2')");}
echo '</div></div></div></div></div><div class="row370"><img src="http://zvirus.ru/img/exp.png"><b>'.$publ['name_publ'].'</b><br></div><div class="row370">'.$publ['desc'].'</div><div class="row370"><small>Всего: '.$p_people.' подписчиков<br>Создатель: '.login($publ['id_user']).'</small></div>';
if($u['id']==$p_enter['id_user'] or $u['id']==$publ['id_user']){echo '<div class="row452"><font color="green">Вы состоите в данной групперовке</font>';}else{
echo '<div class="row"><a href="?act=ent&id='.$id.'"><img src="/img/k.png" width="15"> Вступить в групперовку</a></div>';}
if($u['id']==$p_enter['id_user']){echo '</div><div class="row"><a href="?act=ext&id='.$id.'"><img src="/img/k.png" width="15"> Выйти из групперовки</a></div>';}
/*if($u['id']==$publ['id_user']){echo '</div><div class="menu111">- <a href="admin.php?id='.$id.'">Управление группой</a></div>';}*/
echo "</div><div class='row'>";
$zakl1_r=mysql_query("SELECT * FROM `publ_enter` WHERE `id_publ` = '$id' ORDER BY `time` DESC LIMIT 4");
while ($zakl = mysql_fetch_assoc($zakl1_r)) {
echo ' '.username($zakl['id_user'], 2).'';
}
echo '</div></div>';
echo "</div><div class='row'>Адрес сервера ***/s2</div>";
tp('Стена');
if($u['id']==$p_enter['id_user'] or $u['id']==$publ['id_user']){
echo "<div class='row452'>";
echo bbpanel('form', 'text').'</div>
<div class="row"><form name="form" action="?act=add&id='.$id.'" method="post">
<textarea name="text" cols="" rows="3"></textarea>
<input name="" type="submit" value="Добавить">
</form></div>';}
}
$total = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `publ_book` WHERE `id_publ` = '$id'"), 0);
if ($total > 0) {
$pages = ceil($total / $config['onpage']);
$page = intval($_GET['p']) ? abs($_GET['p']) : 1;
if ($page > $pages or $page == 0) {
$page = 1;
}
$begin = ($page - 1) * $config['onpage'];
navig($page, '?', $pages);
$book_r = mysql_query("SELECT * FROM `publ_book` WHERE `id_publ` = '$id' ORDER BY `time` DESC LIMIT ".$begin.", ".$config['onpage']."");
while ($book = mysql_fetch_assoc($book_r)) {
if (!isset($num) ) $num = 1;
$num++;
echo '<div class="row452">';
///////////////////////////////flowap
$id = abs(intval($_GET['id']));
$publ_r = mysql_query("SELECT * FROM `publ` WHERE `id` = '$id'");
while ($publ = mysql_fetch_assoc($publ_r)) {
///////////////////////////////
echo ' <a href="/other/profile.php?id='.$book['id_user'].'">'.username($book['id_user'], 2).'</a> ';
echo ' '.online(date('d.m.y, H:i', $book['time']), $book['id_user']).' ';
if($u['id']==$publ['id_user']) {echo '<a href="?act=reply&id='.$book['id'].'">Удл</a>';}
echo '</div><div class="row">'.bb($book['msg']);
echo "</div>";
echo '</div>';
}}
navig($page, '?', $pages);
} else {
echo '</div><div class="row">Стенка ещё пуста. Будь первым!</div>';
}
break;
case 'del':
if($u['id']==$publ['id_user']) {
$id = abs(intval($_GET['id']));
$msg_r = mysql_query("SELECT `id` FROM $type WHERE `id` = '$id'");
if (mysql_num_rows($msg_r)) {
mysql_query("DELETE FROM `voting` WHERE `type` = '$type' and `id_for` = '$id'");
mysql_query("DELETE FROM $type WHERE `id` = '$id'");
}
}
redirect('?');
break;
case 'add':
$id = abs(intval($_GET['id']));
if ($_POST['text']) {
$text = check($_POST['text']);
mysql_query("INSERT INTO `publ_book` SET `id_user` = '$u[id]', `msg` = '$text', `id_publ` = '$id', `time` = '".time()."'");
$_SESSION['antispam'] = time() + $config['antispam'];
header('location: ?id='.$id.'');
} else {
header('location: ?');
}
break;
case 'ent':
$id = abs(intval($_GET['id']));
$publ = mysql_fetch_assoc(mysql_query("SELECT * FROM `publ` WHERE `id` = '$id'"));
$p_enter = mysql_fetch_assoc(mysql_query("SELECT * FROM `publ_enter` WHERE `id_publ` = '$id'"));
if($u['id']==$p_enter['id_user'] or $u['id']==$publ['id_user']){echo '<br>Вы уже состоите в этой группе.';}else{
mysql_query("INSERT INTO `publ_enter` (`id_user`, `id_publ`, `time`) VALUES ('$u[id]', '$id', '".time()."')");
header('location: ?id='.$id.'');
}
break;
case 'ext':
$id = abs(intval($_GET['id']));
$p_enter = mysql_fetch_assoc(mysql_query("SELECT * FROM `publ_enter` WHERE `id_publ` = '$id' AND `id_user` = '$u[id]'"));
if($u['id']!=$p_enter['id_user']){echo '<br>Вы не состоите в этой группе.';}else{
mysql_query("DELETE FROM `publ_enter` WHERE `id_publ` = '$id' and `id_user` = '$u[id]'");
header('location: ?id='.$id.'');
break;
}
}
require_once '../includes/tail.php';
?>