function discuss($id_discuss) { $res_dis = $this->q("\n\t\t\tSELECT `discuss`.`title` 'title', `group`.`id_group` 'id_group', `group`.`title` 'grp_ttl' \n\t\t\tFROM `discuss`, `group` \n\t\t\tWHERE `id_discuss`=" . $id_discuss . " AND `group`.`id_group`=`discuss`.`id_group`"); $row_dis = mysql_fetch_assoc($res_dis); $header = "<span class=header1>Дискуссия</span>"; $f = ""; if (isset($_SESSION['id_user'])) { if ($_SESSION['rights'] < 100) { $f = " (`type`='private' AND (" . $_SESSION['id_user'] . " IN (\n\t\t\t\t\t\t\t\t \t\t\tSELECT `id_user` FROM `group_member` WHERE `group_member`.`id_group`=`group`.`id_group` AND `group_member`.`connected`='yes') OR \n\t\t\t\t\t\t\t\t \t\t\t" . $_SESSION['id_user'] . "= `group`.`id_author`) ) OR"; } else { $f = " (`type`='private') OR "; } } $res_post = $this->q("SELECT `id_post`, `posttext`, DATE_FORMAT(`pubdate`, '%e.%m.%Y %k:%i:%s') 'pubdate', `id_album`,\n\t\t\t\t\t\t\t\t\t `photo`.`id_photo`, `user`.`name` 'author', `photo`.`id_user` 'idauthor', `type`, `maxi`,\n\t\t\t\t\t\t\t\t\t DATE_FORMAT(`shootdate`, '%e.%m.%Y') 'made', `group`.`id_group` 'id_group', `group`.`id_author` 'group_author' \n\t\t\t\t\t\t\t FROM `post` \n\t\t\t\t\t\t\t LEFT JOIN `photo` ON `photo`.`id_photo` = `post`.`id_photo` \n\t\t\t\t\t\t\t LEFT JOIN `user` ON `user`.`id_user`=`photo`.`id_user`\n\t\t\t\t\t\t\t LEFT JOIN `discuss` ON `discuss`.`id_discuss` = `post`.`id_discuss`\n\t\t\t\t\t\t\t LEFT JOIN `group` ON `group`.`id_group` = `discuss`.`id_group`\n\t\t\t\t\t\t\t WHERE `post`.`id_discuss`=" . $id_discuss . " AND \n\t\t\t\t\t\t\t \t(" . $f . " (`type` = 'public') OR (`type` = 'public_reg') )\n\t\t\t\t\t\t\t ORDER BY `id_post` DESC"); $i = 1; if (mysql_num_rows($res_post)) { while ($row_post = mysql_fetch_assoc($res_post)) { $comments_query = "SELECT `id_dis_comment`, `dis_comment`.`comment_txt` 'commenttxt', u.`name` 'user',\n\t\t\t \t IF(u.`hideemail`='checked', '', u.`email`) AS email, \n\t\t\t\t\t\t\t DATE_FORMAT(`dis_comment`.`date`, '%e.%m.%Y<font size=1> %k:%i:%s</font>') 'date',\n\t\t\t\t\t\t\t u.`id_user` 'id_user', `avatar`, INET_NTOA(`dis_comment`.`ip`) 'ip_comment' \n\t\t\t\t\t\t FROM `dis_comment` \n\t\t\t\t\t\t LEFT JOIN `user` u ON `dis_comment`.`id_user` = u.`id_user`\n\t\t\t\t\t\t WHERE `dis_comment`.`id_post`=" . $row_post['id_post'] . " ORDER BY `dis_comment`.`date` ASC"; $comments = $this->q($comments_query); if (mysql_num_rows($comments)) { $body_com = ""; while ($row_comments = mysql_fetch_assoc($comments)) { $avatar = empty($row_comments['avatar']) ? "<img src='images/anonym.gif'>" : "<a href='index.php?go=profile&id_user="******"'>\n\t\t\t\t\t<img src='images/" . $row_comments['avatar'] . "' border=0></a>"; if ($_SESSION['rights'] == 100 or $_SESSION['gr_rights'] > 49) { $del_post = '<a href="handler.php?handle=del_comment&id_dis_comment=' . $row_comments['id_dis_comment'] . '" class=link>удалить комментарий</a>'; $body_com .= sh_comments_body($row_comments['id_user'], $row_comments['user'], $avatar, $row_comments['email'], $row_comments['date'], $row_comments['commenttxt'], $row_comments['ip_comment'], $row_post['id_photo'], $row_comments['id_dis_comment'], 0, $del_post); } else { $body_com .= sh_comments_body($row_comments['id_user'], $row_comments['user'], $avatar, $row_comments['email'], $row_comments['date'], $row_comments['commenttxt'], $row_comments['ip_comment'], $row_post['id_photo'], $row_comments['id_dis_comment'], 0, $del_post); } } } else { $body_com = ""; } $posts[$row_post['id_post']] = new post($row_post['id_post'], $row_post['id_photo'], $row_post['posttext'], $row_post['maxi'], $row_post['id_album'], $row_post['idauthor'], $row_post['author'], $row_post['made'], $row_dis['id_group'], sh_comments($body_com, $id_post, true)); } $add_post = ''; if (isset($_SESSION['id_user'])) { $mem = mysql_num_rows($this->q("SELECT `id_user` FROM `group_member` WHERE `id_user`=" . $_SESSION['id_user'] . " AND `connected`='yes' AND `id_group`=" . $row_dis['id_group'])); $auth = mysql_num_rows($this->q("SELECT `id_group` FROM `group` WHERE `id_author`=" . $_SESSION['id_user'] . " AND `id_group`=" . $row_dis['id_group'])); $su = $_SESSION['rights'] == 100 ? true : false; if ($mem or $auth or $su) { $add_post = '<span class=cin> » </span> <a href="index.php?go=add_post&id_discuss=' . $id_discuss . '&id_group=' . $row_dis['id_group'] . '" class=link>добавить пост</a>'; } } $html = ' <td colspan="7" height=51 align="left" valign="middle"> <a href="index.php?go=group&id_group=' . $row_dis['id_group'] . '" class=link title="группа">' . $row_dis['grp_ttl'] . '</a> <span class=cin> » </span> <span class="cur">' . $row_dis['title'] . '</span>' . $add_post . '</td> </tr>'; } $discuss = new section($header, 4, 4); $html .= ' <tr bgcolor="#EFEFEF"> <td height="1" bgcolor="#EFEFEF" width="24"></td> <td bgcolor="#EFEFEF" width="60"></td> <td bgcolor="#EFEFEF" width="10"></td> <td bgcolor="#EFEFEF" width="345"></td> <td bgcolor="#EFEFEF" width="118"></td> <td bgcolor="#EFEFEF" width="118"></td> <td bgcolor="#EFEFEF" width="20"></td> <td bgcolor="#EFEFEF" width="31"></td> </tr> <tr bgcolor="#EFEFEF"> <td width="24" valign=top><p></p></td>'; $add_commlink = ''; if ($_SESSION['rights'] == 100 or $this->membership($row_dis['id_group'])) { if (is_array($posts)) { foreach ($posts as $id_post => $post) { $add_commlink[$id_post] = '<a href="index.php?go=post_comm&id_post=' . $id_post . '" class=link>Добавить комментарий</a>'; } } } $discuss->add_post_array($html, $posts, $add_commlink); $con = new content($discuss); $this->set_content($con); }