<tr>
<td>
<input type="checkbox" name="enable_notifications" <?php
echo $notifications ? "checked=\"checked\"" : "";
?>
/>
<label for="enable_notifications" class="form-nrequired">Receieve notifications when this users reply to this thread</label></td>
</tr>
<?php
}
?>
</tbody>
</table>
</form>
<?php
if (discussion_topic_module_access($topic_record["cdtopic_parent"], "view-post")) {
$query = "\n\t\t\t\t\t\t\t\t\tSELECT a.*, b.`forum_title`, CONCAT_WS(' ', c.`firstname`, c.`lastname`) AS `poster_fullname`, c.`username` AS `poster_username`\n\t\t\t\t\t\t\t\t\tFROM `community_discussion_topics` AS a\n\t\t\t\t\t\t\t\t\tLEFT JOIN `community_discussions` AS b\n\t\t\t\t\t\t\t\t\tON a.`cdiscussion_id` = b.`cdiscussion_id`\n\t\t\t\t\t\t\t\t\tLEFT JOIN `" . AUTH_DATABASE . "`.`user_data` AS c\n\t\t\t\t\t\t\t\t\tON a.`proxy_id` = c.`id`\n\t\t\t\t\t\t\t\t\tWHERE a.`proxy_id` = c.`id`\n\t\t\t\t\t\t\t\t\tAND a.`community_id` = " . $db->qstr($COMMUNITY_ID) . "\n\t\t\t\t\t\t\t\t\tAND b.`cpage_id` = " . $db->qstr($PAGE_ID) . " \n\t\t\t\t\t\t\t\t\tAND a.`cdtopic_id` = " . $db->qstr($topic_record["cdtopic_parent"]) . "\n\t\t\t\t\t\t\t\t\tAND a.`topic_active` = '1'\n\t\t\t\t\t\t\t\t\tAND b.`forum_active` = '1'";
$result = $db->GetRow($query);
if ($result) {
?>
<br />
<h2>Original Post: <small><?php
echo html_encode($result["topic_title"]);
?>
</small></h2>
<table class="discussions posts" style="width: 100%" cellspacing="0" cellpadding="0" border="0">
<colgroup>
<col style="width: 30%" />
<col style="width: 70%" />
</colgroup>
<tr>
* @author Developer: Matt Simpson <*****@*****.**>
* @author Developer: James Ellis <*****@*****.**>
* @copyright Copyright 2010 Queen's University. All Rights Reserved.
*
*/
if (!defined("COMMUNITY_INCLUDED") || !defined("IN_DISCUSSIONS")) {
exit;
} elseif (!$COMMUNITY_LOAD) {
exit;
}
if ($RECORD_ID) {
$query = "\tSELECT * FROM `community_discussion_topics` as a\n\t\t\t\t\t\tLEFT JOIN `community_discussions` as b\n\t\t\t\t\t\tON a.`cdiscussion_id` = b.`cdiscussion_id`\n\t\t\t\t\t\tWHERE a.`cdtopic_id` = " . $db->qstr($RECORD_ID) . " \n\t\t\t\t\t\tAND b.`cpage_id` = " . $db->qstr($PAGE_ID) . " \n\t\t\t\t\t\tAND a.`community_id` = " . $db->qstr($COMMUNITY_ID);
$topic_record = $db->GetRow($query);
if ($topic_record) {
if ((int) $topic_record["topic_active"]) {
if (discussion_topic_module_access($RECORD_ID, "delete-post")) {
/**
* Get a list of all replies, so we can deactivate those in
* history as well.
*/
$topic_ids = array();
$topic_ids[] = $RECORD_ID;
$query = "SELECT `cdtopic_id` FROM `community_discussion_topics` WHERE `cdtopic_parent` = " . $db->qstr($RECORD_ID) . " AND `community_id` = " . $db->qstr($COMMUNITY_ID);
$results = $db->GetAll($query);
if ($results) {
foreach ($results as $result) {
if ($topic_id = (int) $result["cdtopic_id"]) {
$topic_ids[] = $topic_id;
}
}
}
?>
</a><?php
}
?>
</td>
<td style="border-bottom: none">
<div style="float: left">
<span class="content-small"><strong>Replied:</strong> <?php
echo date(DEFAULT_DATE_FORMAT, $result["updated_date"]);
?>
</span>
</div>
<div style="float: right">
<?php
echo discussion_topic_module_access($result["cdtopic_id"], "edit-post") ? " (<a class=\"action\" href=\"" . COMMUNITY_URL . $COMMUNITY_URL . ":" . $PAGE_URL . "?section=edit-post&id=" . $result["cdtopic_id"] . "\">edit</a>)" : "";
echo discussion_topic_module_access($result["cdtopic_id"], "delete-post") ? " (<a class=\"action\" href=\"javascript:postDelete('" . $result["cdtopic_id"] . "', 'reply')\">delete</a>)" : "";
?>
</div>
</td>
</tr>
<tr>
<td colspan="2" class="content">
<a name="post-<?php
echo (int) $result["cdtopic_id"];
?>
"></a>
<?php
echo $result["topic_description"];
if ($result["release_date"] != $result["updated_date"]) {
echo "<div class=\"content-small\" style=\"margin-top: 15px\">\n";
echo "\t<strong>Last updated:</strong> " . date(DEFAULT_DATE_FORMAT, $result["updated_date"]) . " by " . ($result["proxy_id"] == $result["updated_by"] ? html_encode($result["poster_fullname"]) : html_encode(get_account_data("firstlast", $result["updated_by"]))) . ".";
<tr>
<td>
<input type="checkbox" name="enable_notifications" <?php
echo $notifications ? "checked=\"checked\"" : "";
?>
/>
<label for="enable_notifications" class="form-nrequired">Receieve notifications when this users reply to this thread</label></td>
</tr>
<?php
}
?>
</tbody>
</table>
</form>
<?php
if (discussion_topic_module_access($RECORD_ID, "view-post")) {
?>
<br />
<h2>Original Post: <small><?php
echo html_encode($topic_record["topic_title"]);
?>
</small></h2>
<table class="discussions posts" style="width: 100%" cellspacing="0" cellpadding="0" border="0">
<colgroup>
<col style="width: 30%" />
<col style="width: 70%" />
</colgroup>
<tr>
<td style="border-bottom: none; border-right: none"><span class="content-small">By:</span> <?php
if (defined('COMMUNITY_DISCUSSIONS_ANON') && COMMUNITY_DISCUSSIONS_ANON && !$COMMUNITY_ADMIN && isset($topic_record["anonymous"]) && $topic_record["anonymous"]) {
?>
