include '../include.php'; if ($posting) { error_debug("handling bb post"); format_post_bits("isAdmin,temporary"); $id = db_enter("bulletin_board_topics", "title |description isAdmin temporary"); db_query("UPDATE bulletin_board_topics SET threadDate = GETDATE() WHERE id = " . $id); if ($_POST["isAdmin"] == "'1'") { //send admin email //get topic $r = db_grab("SELECT \n\t\t\t\tt.title,\n\t\t\t\tt.description,\n\t\t\t\tu.userID,\n\t\t\t\tISNULL(u.nickname, u.firstname) firstname,\n\t\t\t\tu.lastname,\n\t\t\t\tt.createdOn\n\t\t\t\tFROM bulletin_board_topics t\n\t\t\t\tJOIN intranet_users u ON t.createdBy = u.userID\n\t\t\t\tWHERE t.id = " . $id); //construct email $message = drawEmailHeader(); $message .= drawServerMessage("<b>Note</b>: This is an Administration/Human Resources topic from the <a href='http://" . $server . "/bulletin_board/'>Intranet Bulletin Board</a>. For more information, please contact the <a href='mailto:hrpayroll@seedco.org'>Human Resources Department</a>."); $message .= '<table class="center">'; $message .= drawHeaderRow("Email", 2); $message .= drawThreadTop($r["title"], $r["description"], $r["userID"], $r["firstname"] . " " . $r["lastname"], $r["createdOn"]); $message .= '</table>' . drawEmailFooter(); $headers = "MIME-Version: 1.0\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; $headers .= "From: " . $_josh["email_default"] . "\r\n"; //get addresses & send $users = db_query("SELECT email FROM intranet_users WHERE isactive = 1"); while ($u = db_fetch($users)) { mail($u["email"], $r["title"], $message, $headers); } } syndicateBulletinBoard(); url_change(); } drawTop(); echo drawSyndicateLink("bb");
?> </a></td> </tr> <?php } ?> </table> </td> </tr> <?php } ?> </form> <?php $editurl = $page['is_admin'] ? "ticket-edit.php?id=" . $_GET["id"] : false; echo drawThreadTop($r["title"], $r["description"], $r["created_user"], $r["first"] . " " . $r["last"], $r["created_date"], $editurl); $result = db_query("SELECT\r\n\t\t\t\t\tu.id,\r\n\t\t\t\t\tf.message,\r\n\t\t\t\t\tISNULL(u.nickname, u.firstname) first,\r\n\t\t\t\t\tu.lastname last,\r\n\t\t\t\t\tf.created_date,\r\n\t\t\t\t\tf.is_admin\r\n\t\t\t\tFROM helpdesk_tickets_followups\tf\r\n\t\t\t\tJOIN users\t\t\tu ON f.created_user\t= u.id\r\n\t\t\t\tWHERE f.ticketID = " . $_GET['id'] . "\r\n\t\t\t\tORDER BY f.created_date"); while ($r = db_fetch($result)) { if ($r['is_admin'] && !$page['is_admin']) { continue; } echo drawThreadComment($r["message"], $r["id"], $r["first"] . " " . $r["last"], $r["created_date"], $r["is_admin"]); } echo drawThreadCommentForm(true); echo '</table>'; ?> <table class="left" cellspacing="1"> <?php echo drawHeaderRow("Attach Document", 2); ?> <form enctype="multipart/form-data" action="<?php