// register the PHITE globals
global $PHITE_vars;
// includes for mysql
include("../vadmin/conf.php");
// open database connection
$connection = mysql_connect($host, $contentuser, $contentpass) or die ("Unable to connect!");
// select database
mysql_select_db($db) or die ("Unable to select database!");
// generate and execute query
$query = "SELECT * FROM content WHERE id ='$_REQUEST[id]'";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
// get resultset as object
$row = mysql_fetch_object($result);
// print details
if ($row) {
// remove underscores from query for back button
$s = @$_REQUEST['page'];
$p = str_replace("_", " ", $s);
$t = @$_REQUEST['subpage'];
$sub = str_replace("_", " ", $t);
$z = @$_REQUEST['section'];
$sect = str_replace("_", " ", $z);
// create a back button
if ($_REQUEST['sectionid'] == "4a") {
echo ("
Back to $p | ");
include "../vadmin/includes/courseareas/duchy.php";
echo ("

");
echo ("
");
} elseif (isset($_REQUEST['page']) && isset($_REQUEST['subpage']) && ($_REQUEST['page'] !== 'shared') && ($_REQUEST['subpage'] !== '_Written_Directions')) {
echo ("
");
}
// stop content showing on course info pages
if ($_REQUEST['pagetype'] !== "3" && $_REQUEST['pagetype'] !== "4" && $_REQUEST['pagetype'] !== "5") {
echo "
$row->title
";
if ($_REQUEST['skin'] !== '_PrintFriendly') {// drop in the pics using this script
//echo "
";
include '../templates/content/contentpic.php';
//echo "
";
}
// now the rest of the content
if ($row->timestamp < '2005-08-24 10:22:47') {
echo "
" . nl2br(stripslashes($row->para1)) . "
";
} else {
echo "
" .stripslashes($row->para1). "
";
}
if ($row->timestamp < '2005-08-24 10:22:47') {
if(strlen($row->para2) > "3") { echo "
" . nl2br($row->para2) . "
";}
if ($row->hr2) { echo "
"; }
if(strlen($row->para3) > "3") { echo "
" . nl2br($row->para3) . "
";}
if ($row->hr3) { echo "
"; }
if(strlen($row->para4) > "3") { echo "
" . nl2br($row->para4) . "
";}
if ($row->hr4) { echo "
"; }
if(strlen($row->para5) > "3") { echo "
" . nl2br($row->para5) . "
";}
if ($row->hr5) { echo "
"; }
if(strlen($row->para6) > "3") { echo "
" . nl2br($row->para6) . "
";}
if ($row->hr6) { echo "
"; }
if(strlen($row->para7) > "3") { echo "
" . nl2br($row->para7) . "
";}
if ($row->hr7) { echo "
"; }
if(strlen($row->para8) > "3") { echo "
" . nl2br($row->para8) . "
";}
if ($row->hr8) { echo "
"; }
if(strlen($row->para9) > "3") { echo "
" . nl2br($row->para9) . "
";}
}
}
if ($_REQUEST['sectionid'] == '4a') {
include '../templates/content/profiles.php';
}
// if all else fails show this error!
} else {
echo "
Sorry, due to technical problems the content of this page is offline. Please try again soon.
";
}
// close database connection
// mysql_close($connection);
?>