<?php
session_start();
//
include("_functions.php");
echo dbconnect();
//
$sql = "SELECT tbl_notices.*, tbl_notice_types.*, tbl_icons.icon_file, tbl_employees.fname, tbl_employees.lname FROM tbl_notices, tbl_notice_types, tbl_icons, tbl_employees WHERE tbl_notices.notice_id=".$_GET["nid"]." AND tbl_notices.notice_type_id=tbl_notice_types.notice_type_id AND tbl_notices.icon_id=tbl_icons.icon_id AND tbl_employees.username=tbl_notices.username";
$result = mysql_query($sql);
$n = mysql_fetch_array($result);
//
// INCREMENT NOTICE_VIEWS
if ($_SESSION["auth_user"] != $n["username"]) quickUPDATE("UPDATE tbl_notices SET notice_views=".($n["notice_views"]+1)." WHERE notice_id=".$_GET["nid"]);
//
// INSERT OR UPDATE VIEW DATA
if (is_logged()) {
	// CHECK DB FOR ALLREAD
	$allread = get_allread();
	if (($allread === FALSE) || ($allread < $n["notice_date"])) {
		$row_exists = quickSQL("SELECT COUNT(last_access) FROM tbl_notice_visits WHERE username='".$_SESSION["auth_user"]."' AND notice_type_id=".$n["notice_type_id"]." AND notice_id=".$n["notice_id"]);
		if ($row_exists) quickUPDATE("UPDATE tbl_notice_visits SET last_access=".time()." WHERE username='".$_SESSION["auth_user"]."' AND notice_type_id=".$n["notice_type_id"]." AND notice_id=".$n["notice_id"]);
		else quickUPDATE("INSERT INTO tbl_notice_visits (username,notice_type_id,notice_id,last_access) VALUES ('".$_SESSION["auth_user"]."',".$n["notice_type_id"].",".$n["notice_id"].",".time().")");
	}
}
//
if (!zero(trim($n["notice_linkto"])) && (trim($n["notice_linkto"]) != "http://")) {
	header("Location: ".$n["notice_linkto"]);
}
$page_title = $n["notice_type_name"]." : ".strip_tags($n["notice_headline"]);
$GLOBALS["ntid"] = $n["notice_type_id"];
if (isset($_GET["sf"])) {
	$GLOBALS["breadcrumb"] = "<a href=\"/content.php?p=1\">Intranet Home</a> > <a href=\"/content.php?p=209\">Social</a> > <a href=\"/forums.php\">Discussion Forums</a> > <a href=\"/noticeboard.php?ntid=".$n["notice_type_id"]."&sf=1\">".$n["notice_type_name"]."</a> > ".(strlen(strip_tags($n["notice_headline"]))>37?substr(strip_tags($n["notice_headline"]),0,37)."...":strip_tags($n["notice_headline"]));
	$_GET["p"] = 5;
} else $_GET["p"] = $n["parent_id"];			 // SET FAUX PARENT ID

$lnav_mods = get_layout($_GET["p"],1);
$rnav_mods = get_layout($_GET["p"],3);
$lnav_mods[count($lnav_mods)] = "addthread";

include("_pagestart.php");

if (authorize($n["username"]) || check_pgroup($_SESSION["auth_user"],$n["board_admins"])) 
	$edit_btn = "<td><a href=\"notice_edit.php?nid=".$_GET["nid"].(isset($_GET["sf"])?"&sf=1":"")."\">Edit Notice</a> &nbsp; </td><td><a href=\"notice_edit.php?nid=".$_GET["nid"].(isset($_GET["sf"])?"&sf=1":"")."\"><img src=\"gui/edit.gif\" border=0></a>&nbsp;&nbsp;&nbsp;</td>";
else $edit_btn = "";
	
  
$pf = "<div style=\"float:right;\"><table border=0 cellspacing=0 cellpadding=0><tr><td><a href=\"/notice_pf.php?nid=".$n["notice_id"]."\" target=\"pf\">Print</a> &nbsp; </td><td><a href=\"/notice_pf.php?nid=".$n["notice_id"]."\" target=\"pf\"><img src=\"gui/icons/print.gif\" border=0 align=middle></a>&nbsp;&nbsp;&nbsp;</td>".$edit_btn."</tr></table></div>";


echo "<div class=\"headline\">".$n["notice_type_name"]."</div>\n";
echo "<P><div class=\"pagebody\">\n";
echo "<div class=\"stamp\" style=\"margin-bottom:0px;margin-top:3px;border:solid 1px #CCCCCC;\">".$pf."<table border=0><tr><td><img src=\"".$n["icon_file"]."\"></td><td> &nbsp; <a href=\"/profile.php?u=".$n["username"]."\">".$n["fname"]." ".$n["lname"]."</a> : ".date("l, F j, Y h:i a",$n["notice_date"])."</td></tr></table></div>\n";
echo "<div id=\"box\"><div style=\"margin:6px 12px 12px 12px\">\n";
echo "<div id=\"headline\" style=\"font-size:18px;\"><span id=\"red\">".strip_tags($n["notice_headline"])."</span></div>\n";
if ($n["notice_subhead"] != "0") echo "<P><span id=\"subhead\">".$n["notice_subhead"]."</span>\n";
if ($n["notice_body"] != "0") echo "<P>".format_body($n["notice_body"],0)."</div>\n";
echo "</div>\n";


// If Replies, display them
$thread = quickSQL("SELECT tbl_notice_types.notice_type_discuss FROM tbl_notice_types, tbl_notices WHERE tbl_notice_types.notice_type_id=tbl_notices.notice_type_id AND tbl_notices.notice_id=".$_GET["nid"]);
if ($thread == 1) showthread();

echo "</div>\n";

echo "<br><br><div class=\"pagefoot\"><a href=\"/noticeboard.php?ntid=".$n["notice_type_id"]."\">Back to ".$n["notice_type_name"]."</a></div>\n";
//echo boxfoot();


include("_pageend.php");
?>