prepare($sql);
$stmt->bind_param('s', $chrURL);
$stmt->execute();
$stmt->store_result();
stmt_bind_assoc($stmt, $row);
$stmt->fetch();
$idPage = $row['idPage']; // set the idPage as a global variable
}else{ //if chrURL is not set then try and locate the $idPage in the query string.
//t the idPAge global variable
if($_REQUEST['idPage']){
$idPage = $_REQUEST['idPage'];
}else{
$idPage = 1;
}
}
$sql = "select * from general";
$stmt = $mysqli->prepare($sql);
$stmt->execute();
$stmt->store_result();
stmt_bind_assoc($stmt, $row);
$stmt->fetch();
$chrSchoolName = $row['chrSchoolName'];
// ---------------------------------------- //
//load page specific data
$sql = "select * from pages where idPage=?";
$sql2 = "select * from pages where idPage=".$idPage;
//echo $sql2;
$stmt = $mysqli->prepare($sql);
$stmt->bind_param('i', $idPage);
$stmt->execute();
$stmt->store_result();
stmt_bind_assoc($stmt, $row);
$stmt->fetch();
$idPage = $row['idPage'];
$idPageType = $row['idPageType'];
$chrURL= $row['chrURL'];
$urlRedirect= $row['urlRedirect'];
$chrShortTitle= $row['chrShortTitle'];
$chrLongTitle= $row['chrLongTitle'];
$idPageType= $row['idPageType'];
$chrPageLink= $row['chrPageLink'];
$txtDescription= $row['txtDescription'];
$intNavigation= $row['intNavigation'];
$txtSummary= $row['txtSummary'];
$txtBody= $row['txtBody'];
$intOrder= $row['intOrder'];
$idParent = $row['idParent'];
$intLive= $row['intLive'];
$dtTimestamp = $row['dtTimestamp'];
$idLayout = $row['idLayout'];
$intSecure = $row['intSecure'];
$chrPassword = $row['chrPassword'];
$txtJavascript = $row['txtJavascript'];
$chrAuthor = $row['chrAuthor'];
$txtKeywords = $row['txtKeywords'];
$txtCSS = $row['txtCSS'];
$txtJavascript = $row['txtJavascript'];
// ---------------------------------------- //
function stmt_bind_assoc (&$stmt, &$out) {
$data = mysqli_stmt_result_metadata($stmt);
$fields = array();
$out = array();
$fields[0] = $stmt;
$count = 1;
while($field = mysqli_fetch_field($data)) {
$fields[$count] = &$out[$field->name];
$count++;
}
call_user_func_array('mysqli_stmt_bind_result', $fields);
}
function check_empty($str){
if($str == ""){
return "No Data";
}else{
return $str;
}
}
//this function builds the subMenu links, replacing the idPage for the chrURL (seo) when set in the CMS
function subMenuLinks($idPage, $idParent){
include("./includes/connect_mysql.php");
$html =''.PHP_EOL;
return $html;
}
function getAddress($chrURL, $idPage){
// echo $idPage.'|'.$chrURL;
$chrURL = './'.$chrURL;
if($chrURL!=''){
if($chrURL==strstr($chrURL, 'http://')||strpos($chrURL, 'html')>0){
$chrURLReturn = $chrURL;
}else{
if(!strstr($chrURL, '.html')){
$chrURLReturn = '/'.$chrURL.'.html';
}else{
$chrURLReturn = '/'.$chrURL.'.html';
}
}
}else{
$chrURLReturn = '/page.php?idPage='.$idPage;
}
return $chrURLReturn;
}
function getContactDetails(){
include("./includes/connect_mysql.php");
$sql = "select * from general";
$idSection = 1;
$stmt = $mysqli->prepare($sql);
$stmt->execute();
$stmt->store_result();
stmt_bind_assoc($stmt, $row);
$stmt->fetch();
$chrSchoolName = $row['chrSchoolName'];
$chrCopyright = $row['chrCopyright'];
$txtAddress = $row['txtAddress'];
$chrCity = $row['chrCity'];
$chrCounty = $row['chrCounty'];
$chrPostCode = $row['chrPostCode'];
$chrTelephone = $row['chrTelephone'];
$chrEmail = $row['chrEmail'];
$chrFax = $row['chrFax'];
$chrContactEmail = $row['chrContactEmail'];
$srcLogo = $row['srcLogo'];
$html .= "T: ".$chrTelephone."
";
//$html .= "Fax ".$chrFax."
";
$html .= "E: ".$chrEmail."
";
$html .= " ".$chrCopyright."
";
//$html .= $txtAddress;
return $html;
}
function getHeaderDetails(){
include("./includes/connect_mysql.php");
$sql = "select * from general";
$idSection = 1;
$stmt = $mysqli->prepare($sql);
$stmt->execute();
$stmt->store_result();
stmt_bind_assoc($stmt, $row);
$stmt->fetch();
$chrCompanyName = $row['chrCompanyName'];
$chrCopyright = $row['chrCopyright'];
$txtAddress = $row['txtAddress'];
$chrCity = $row['chrCity'];
$chrCounty = $row['chrCounty'];
$chrPostCode = $row['chrPostCode'];
$chrTelephone = $row['chrTelephone'];
$chrEmail = $row['chrEmail'];
$chrFax = $row['chrFax'];
$chrContactEmail = $row['chrContactEmail'];
$srcLogo = $row['srcLogo'];
$chrTagLine = $row['chrTagLine'];
$html .= "
";
$html .= "
";
$html .= "
$txtAddress
$chrCity
$chrPostCode
$chrCompanyName
";
$html .= " ";
return $html;
}
function getRootNavigation($idPage, $idParent){
//$idParent = 52;
include("./includes/connect_mysql.php");
$sql = "select * from pages where idParent=1 and idMenu=1 and idPage!=1 and intLive=1 order by intPageOrder";
//echo $sql;
$idSection = 1;
$stmt = $mysqli->prepare($sql);
$stmt->execute();
$stmt->store_result();
stmt_bind_assoc($stmt, $row);
$html="".PHP_EOL;
return $html;
}
function getSubNavigationItems($idPage){
include("./includes/connect_mysql.php");
$sql = "select * from pages where idParent=$idPage order by intPageOrder".PHP_EOL;
// echo $sql."
";
$idSection = 1;
$stmt = $mysqli->prepare($sql);
$stmt->execute();
$stmt->store_result();
stmt_bind_assoc($stmt, $row);
$html.="".PHP_EOL;
return $html;
}
function getSubSubNavigationItems($idPage){
include("./includes/connect_mysql.php");
$sql = "select * from pages where idParent=$idPage order by intPageOrder".PHP_EOL;
// echo $sql."
";
$idSection = 1;
$stmt = $mysqli->prepare($sql);
$stmt->execute();
$stmt->store_result();
stmt_bind_assoc($stmt, $row);
$html.="".PHP_EOL;
while($stmt->fetch())
{
if($row['idPage']==$GLOBALS['idPageLive']){
if(strpos($row['chrURL'], 'tp://')>0){
$html .='- '.stripslashes($row['chrShortTitle']).'';
}else{
$html .='
- '.stripslashes($row['chrShortTitle']).'';
}
$html .= getSubSubNavigationItems($row['idPage']);
}else{
if(strpos($row['chrURL'], 'tp://')>0){
$html .='
- '.stripslashes($row['chrShortTitle']).'';
}else{
$html .='
- '.stripslashes($row['chrShortTitle']).'';
}
$html .= getSubSubNavigationItems($row['idPage']);
}
}
$html.="
".PHP_EOL;
return $html;
}
function getMenuItems($idMenu){
include("./includes/connect_mysql.php");
$sql = 'select * from pages where idMenu = ? and intNavigation=1 order by intPageOrder';
$sql2 = 'select * from pages where idMenu = '.$idMenu.' and intNavigation=1';
// echo $sql2;
$stmt = $mysqli->prepare($sql);
$stmt->bind_param('i', $idMenu);
$stmt->execute();
$stmt->store_result();
stmt_bind_assoc($stmt, $row);
$flag=0;
$html = "";
$stmt->close();
return $html;
}
function getStaffPage($idStaffGroup=1){
include("./includes/connect_mysql.php");
$sql = 'select * from staffGroups_st';
//echo $sql;
$stmt = $mysqli->prepare($sql);
//$stmt->bind_param('i', $idPageTypeLayout);
$stmt->execute();
$stmt->store_result();
stmt_bind_assoc($stmt, $row);
$flag=0;
$html = "";
$html .="";
$stmt->close();
$sql = 'select * from staff join staff_assets on staff_assets.idStaff = staff.idStaff join assets on assets.idAsset = staff_assets.idAsset where idStaffGroup = 1';
$stmt = $mysqli->prepare($sql);
//$stmt->bind_param('i', $idStaffGroup);
$stmt->execute();
$stmt->store_result();
stmt_bind_assoc($stmt, $row);
$flag=0;
while($stmt->fetch()){
$html .= "
";
if($row['srcFileName']){
$html .= "
![](/resources/".$row[)
";
}else{
$html .= "
";
}
$html .= "
".$row['chrFullName']."
".$row['chrStaffRole']."
";
}
$stmt->close();
$html .= "
";
$html .= "
Events List
";
while($stmt->fetch()){
if($flag == 0){
$html .= "
".$row['chrLongTitle']."";
$html .= "
".date('d/m/y', strtotime($row['dtStartDate']))." - ".date('d/m/y', strtotime($row['dtClosingDate']))."";
$flag=1;
}else{
$html .= "
".$row['chrLongTitle']."";
$html .= "
".date('d/m/y', strtotime($row['dtStartDate']))." - ".date('d/m/y', strtotime($row['dtClosingDate']))."";
}
}
$html .= "
";
$stmt->close();
// $sql = 'select * from events join event_assets on eventAssets.idEvent = events.idEvent join assets on assets.idAsset = eventAssets.idAsset';
if($_REQUEST['idEvent']){
$sql = 'select * from events where idEvent=?';
$stmt = $mysqli->prepare($sql);
$stmt->bind_param('i', $_REQUEST['idEvent']);
$stmt->execute();
$stmt->store_result();
stmt_bind_assoc($stmt, $row);
$flag=0;
}else{
$sql = 'select * from events order by dtStartDate limit 0,1';
$stmt = $mysqli->prepare($sql);
//$stmt->bind_param('i', $idGovernorGroup);
$stmt->execute();
$stmt->store_result();
stmt_bind_assoc($stmt, $row);
$flag=0;
}
while($stmt->fetch()){
$html .= "
";
$html .= "
".stripslashes($row['chrLongTitle'])."
";
$html .= "
".stripslashes($row['chrLocation'])."
";
$html .= "
".date('l jS F, Y', strtotime($row['dtStartDate']))." - ".date('l jS F, Y', strtotime($row['dtClosingDate']))."
";
$html .= "
".stripslashes(str_replace("../", "/", $row['txtBody']))."
";
if($row['chrContactName']){
$contact .= "
Contact Name:".$row['chrContactName']."
";
}
if($row['chrContactEmail']){
$contact .= "
";
}
if($row['chrContactTelephone']){
$contact .= "
Tel:".$row['chrContactTelephone']."
";
}
if($row['chrLink']){
$contact .= "
";
}
if($contact){
$html .= "
Contact Details
".$contact;
}
$html .= "
";
}
$stmt->close();
$html .= "
";
$html .= "
News Stories
";
while($stmt->fetch()){
$html .= "
";
}
$html .= "
";
$stmt->close();
if($_REQUEST['idNews']){
$sql = 'select * from news where idNews = ?';
//echo $sql;
$stmt = $mysqli->prepare($sql);
$stmt->bind_param('i', $_REQUEST['idNews']);
$stmt->execute();
$stmt->store_result();
stmt_bind_assoc($stmt, $row);
$flag=0;
}else{
$sql = 'select * from news limit 0,1';
//echo $sql;
$stmt = $mysqli->prepare($sql);
//$stmt->bind_param('i', $idPageTypeLayout);
$stmt->execute();
$stmt->store_result();
stmt_bind_assoc($stmt, $row);
$flag=0;
}
$flag=0;
while($stmt->fetch()){
$html .= "
".stripslashes($row['chrLongTitle'])."
";
//$html .= "
".$row['chrLocation']."
";
$html .= "
".date('l, jS F, Y', strtotime($row['dtTimestamp']))."
";
$html .= "
".stripslashes(str_replace("../", "/", $row['txtBody']))."
";
if($row['chrFullName']){
$contact .= "
Name:".$row['chrFullName']."
";
}
if($row['chrEmail']){
$contact .= "
";
}
if($row['chrTelephone']){
$contact .= "
Tel:".$row['chrTelephone']."
";
}
if($row['chrLink']){
$contact .= "
";
}
}
if($contact){
$html .= "
Contact Details
".$contact;
}
$stmt->close();
$html .= "
";
$stmt->close();
$sql = 'select * from governor join governor_assets on governor_assets.idgovernor = governor.idgovernor join assets on assets.idAsset = governor_assets.idAsset where idGovernorGroup = 1';
$stmt = $mysqli->prepare($sql);
//$stmt->bind_param('i', $idGovernorGroup);
$stmt->execute();
$stmt->store_result();
stmt_bind_assoc($stmt, $row);
$flag=0;
while($stmt->fetch()){
$html .= "
";
if($row['srcFileName']){
$html .= "
";
}else{
$html .= "
";
}
$html .= "
".$row['chrFullName']."
".$row['chrGovernorRole']."
";
}
$stmt->close();
$html .= "
';
if($row['chrLink']==""){
if($row['chrLink']!=""){
$txtBody .= '
'.$row['chrAlt'].'
'.PHP_EOL;
}
}else{
if($row['chrLink']!=""){
$txtBody .= '
'.$row['chrAlt'].'
'.PHP_EOL;
}
}
// $txtBody .= "
![](\"./resources/".$row['srcFileName']."\")
".PHP_EOL;
$txtBody .= "
'.$row['chrShortTitle'].'
'.truncateString(str_replace(array("\n", "\t", "\r"), '', trim($txtSummary)), 130).'
Read More';
$txtBody .= $row['txtBody'];
$txtBody .= '
';
}
$html = "";
// echo $html;
return $html;
}
function getQuickLinksGroup($idBodyText, $target, $idPageObject){
include("./includes/connect_mysql.php");
$sql = 'select * from quick_links_groups where idQuickLinksGroup=?';
$stmt = $mysqli->prepare($sql);
$stmt->bind_param('i', $idBodyText);
$stmt->execute();
$stmt->store_result();
stmt_bind_assoc($stmt, $row);
$flag=0;
$counter=1;
$html = "";
while($stmt->fetch()){
$linksBody = getQuickLinksDetail($row['idQuickLinksGroup']);
}
$html = "";
return $html;
}
function getParentLinks($idParent, $target, $idPageObject, $idPage){
include("./includes/connect_mysql.php");
$sql = 'select * from pages where idParent = ? and idPage !=1 order by intPageOrder';
$stmt = $mysqli->prepare($sql);
$stmt->bind_param('i', $idParent);
$stmt->execute();
$stmt->store_result();
stmt_bind_assoc($stmt, $row);
$flag=0;
$counter=1;
$html = "";
$html .= '';
while($stmt->fetch()){
if (strpos($row['chrURL'],'tp://') !== false) {
$html .= "
".$row['chrShortTitle']."".PHP_EOL;
//$html .= getChildLinks($row['idPage'], $row['idPage']);
}else{
if($idPage==$row['idPage']){
$html .= "
".$row['chrShortTitle']."".PHP_EOL;
$html .= getChildLinks($row['idParent'], $row['idPage']);
}else{
$html .= "
".$row['chrShortTitle']."".PHP_EOL;
}
}
}
$html .= "
';
while($stmt->fetch()){
if (strpos($row['chrURL'],'tp://') !== false) {
$html .= "
".$row['chrShortTitle']."".PHP_EOL;
}else{
if($idParent==$row['idPage']){
$html .= "
".$row['chrShortTitle']."".PHP_EOL;
$html .= getChildLinks($idPage, $idParent);
}else{
$html .= "
".$row['chrShortTitle']."".PHP_EOL;
}
}
}
$html .= "
'.$row['chrShortTitle'].'
'.truncateString(str_replace(array("\n", "\t", "\r"), '', trim($row['txtSummary'])), 130).'
Read More'.$row['chrShortTitle'].'
'.truncateString(str_replace(array("\n", "\t", "\r"), '', trim($row['txtSummary'])), 110).'
Read More...'.$dtTimestamp.'
';
$html .= ''.$chrShortTitle.'
';
$html .= ''.str_replace(array("\n", "\t", "\r"), '', trim($txtSummary)).'
';
$html .= 'Read More..';
}
$stmt->close();
$data = "";
$html = "";
return $html;
}
function getNewsFeature2($idCarousel, $target, $idPageObject){
include("./includes/connect_mysql.php");
$sql = 'select * from news where intFeatured=1 order by dtRelease desc limit 0,2';
//echo $sql;
$stmt = $mysqli->prepare($sql);
// $stmt->bind_param('i', $idCarousel);
$stmt->execute();
$stmt->store_result();
stmt_bind_assoc($stmt, $row);
$flag=0;
while($stmt->fetch()){
$idNews = $row['idNews'];
$chrShortTitle= $row['chrShortTitle'];
$txtSummary= $row['txtSummary'];
$dtTimestamp= date('j-m-Y', strtotime($row['dtTimestamp']));
$html .= ''.str_replace(array("\n", "\t", "\r"), '', trim($txtSummary)).'
';
$html .= 'Read More..';
}
$stmt->close();
$data = "Today is ".date("D F jS, Y")."News
".$html."
View all.. ";
$html = "";
return $html;
}
function getBannerObject($idCarousel, $target, $idPageObject){
//echo $idPageObject;
include("./includes/connect_mysql.php");
$sql = 'select * from carousel where idCarousel=?';
//echo $idCarousel.$sql;
$stmt = $mysqli->prepare($sql);
$stmt->bind_param('i', $idCarousel);
$stmt->execute();
$stmt->store_result();
stmt_bind_assoc($stmt, $row);
$flag=0;
while($stmt->fetch()){
$idcarousel = $row['idCarousel'];
$chrTitle= $row['chrTitle'];
$txtDescription= $row['txtDescription'];
$intWidth= $row['intWidth'];
$intHeight= $row['intHeight'];
$intAutoScrollDelay= $row['intAutoScrollDelay'];
$dtCreated= $row['dtCreated'];
$intLive= $row['intLive'];
}
$stmt->close();
$sql = 'select * from carousel_assets join assets on carousel_assets.idAsset = assets.idAsset join asset_types on assets.idAssetType = asset_types.idAssetType join asset_file_type on asset_types.idAssetFileType = asset_file_type.idAssetFileType where idcarousel = ? and chrAssetFileType ="Banner"';
// $sql = 'select * from carousel_assets join assets on carouselAssets.idAsset = Assets.idAsset where idCarousel=?';
//echo $sql;
$stmt = $mysqli->prepare($sql);
$stmt->bind_param('i', $idCarousel);
$stmt->execute();
$stmt->store_result();
stmt_bind_assoc($stmt, $row);
$flag=0;
$counter=1;
while($stmt->fetch()){
$html .= "";
if($row['chrAlt']){
$html .= "".stripslashes($row['chrAlt'])."";
}
$html .= "";
$links .= "";
$style .= "
".PHP_EOL;
$counter++;
// echo $counter;
}
$html = '';
$style .= '
';
$carouselJS = "
";
return $style.$carouselJS;
}
function getBannerObjectDraggable($idCarousel, $target, $idPageObject){
//echo $idPageObject;
include("./includes/connect_mysql.php");
$sql = 'select * from carousel where idCarousel=?';
//echo $idCarousel.$sql;
$stmt = $mysqli->prepare($sql);
$stmt->bind_param('i', $idCarousel);
$stmt->execute();
$stmt->store_result();
stmt_bind_assoc($stmt, $row);
$flag=0;
while($stmt->fetch()){
$idcarousel = $row['idCarousel'];
$chrTitle= $row['chrTitle'];
$txtDescription= $row['txtDescription'];
$intWidth= $row['intWidth'];
$intHeight= $row['intHeight'];
$intAutoScrollDelay= $row['intAutoScrollDelay'];
$dtCreated= $row['dtCreated'];
$intLive= $row['intLive'];
}
$stmt->close();
$sql = 'select * from carousel_assets join assets on carousel_assets.idAsset = assets.idAsset join asset_types on assets.idAssetType = asset_types.idAssetType join asset_file_type on asset_types.idAssetFileType = asset_file_type.idAssetFileType where idcarousel = ? and chrAssetFileType ="Banner" limit 0,1';
// $sql = 'select * from carousel_assets join assets on carouselAssets.idAsset = Assets.idAsset where idCarousel=?';
// echo $sql2;
$stmt = $mysqli->prepare($sql);
$stmt->bind_param('i', $idCarousel);
$stmt->execute();
$stmt->store_result();
stmt_bind_assoc($stmt, $row);
$flag=0;
$counter=1;
while($stmt->fetch()){
$html .= "";
}
return $html;
}
function getDraggableCarousel($idCarousel){
//echo $idPageObject;
include("./includes/connect_mysql.php");
$sql = 'select * from carousel where idCarousel=?';
//echo $idCarousel.$sql;
$stmt = $mysqli->prepare($sql);
$stmt->bind_param('i', $idCarousel);
$stmt->execute();
$stmt->store_result();
stmt_bind_assoc($stmt, $row);
$flag=0;
while($stmt->fetch()){
$idcarousel = $row['idCarousel'];
$chrTitle= $row['chrTitle'];
$txtDescription= $row['txtDescription'];
$intWidth= $row['intWidth'];
$intHeight= $row['intHeight'];
$intAutoScrollDelay= $row['intAutoScrollDelay'];
$dtCreated= $row['dtCreated'];
$intLive= $row['intLive'];
}
$stmt->close();
$sql = 'select * from carousel_assets join assets on carousel_assets.idAsset = assets.idAsset join asset_types on assets.idAssetType = asset_types.idAssetType join asset_file_type on asset_types.idAssetFileType = asset_file_type.idAssetFileType where idcarousel = ? and chrAssetFileType ="Banner" limit 0,1';
$stmt = $mysqli->prepare($sql);
$stmt->bind_param('i', $idCarousel);
$stmt->execute();
$stmt->store_result();
stmt_bind_assoc($stmt, $row);
$flag=0;
$counter=1;
while($stmt->fetch()){
$html .= "";
}
return $html;
}
?>