*/
function get_page_link( $id )
{
global $database;
$sql = 'SELECT `link` FROM `'.TABLE_PREFIX.'pages` WHERE `page_id` = '.intval($id);
$link = $database->get_one( $sql );
return $link;
}
}
//function to highlight search results
if(!function_exists('search_highlight')) {
/**
*
* @staticvar boolean $string_ul_umlaut
* @staticvar boolean $string_ul_regex
* @param string $foo
* @param array $arr_string
* @return string
*/
function search_highlight($foo='', $arr_string=array()) {
require_once(WB_PATH.'/framework/functions.php');
static $string_ul_umlaut = FALSE;
static $string_ul_regex = FALSE;
if($string_ul_umlaut === FALSE || $string_ul_regex === FALSE) {
require(WB_PATH.'/search/search_convert.php');
}
$foo = entities_to_umlauts($foo, 'UTF-8');
array_walk($arr_string, create_function('&$v,$k','$v = preg_quote($v, \'~\');'));
$search_string = implode("|", $arr_string);
$string = str_replace($string_ul_umlaut, $string_ul_regex, $search_string);
// the highlighting
// match $string, but not inside , , or HTML-Tags
// Also droplet tags are now excluded from highlighting.
// split $string into pieces - "cut away" styles, scripts, comments, HTML-tags and eMail-addresses
// we have to cut and as well.
// for HTML-Tags use <(?:[^<]|<.*>)*> which will match strings like
$matches = preg_split("~(\[\[.*\]\]||||||<(?:[^<]|<.*>)*>|\b[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,8}\b)~iUs",$foo,-1,(PREG_SPLIT_DELIM_CAPTURE|PREG_SPLIT_NO_EMPTY));
if(is_array($matches) && $matches != array()) {
$foo = "";
foreach($matches as $match) {
if($match{0}!="<" && !preg_match('/^[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,8}$/i', $match) && !preg_match('~\[\[.*\]\]~', $match)) {
$match = str_replace(array('<', '>', '&', '"', ''', ' '), array('<', '>', '&', '"', '\'', "\xC2\xA0"), $match);
$match = preg_replace('~('.$string.')~ui', '_span class=_highlight__$1_/span_',$match);
$match = str_replace(array('&', '<', '>', '"', '\'', "\xC2\xA0"), array('&', '<', '>', '"', ''', ' '), $match);
$match = str_replace(array('_span class=_highlight__', '_/span_'), array('', ''), $match);
}
$foo .= $match;
}
}
if(DEFAULT_CHARSET != 'utf-8') {
$foo = umlauts_to_entities($foo, 'UTF-8');
}
return $foo;
}
}
if (!function_exists('page_menu')) {
/**
* Old menu generator
* @deprecated from WB 2.8.x and up
* @global $wb
* @param $parent
* @param $menu_number
* @param $item_template
* @param $menu_header
* @param $menu_footer
* @param $default_class
* @param $current_class
* @param $recurse
*/
function page_menu($parent = 0, $menu_number = 1, $item_template = '[a] [menu_title] [/a]', $menu_header = '', $default_class = ' class="menu_default"', $current_class = ' class="menu_current"', $recurse = LEVEL) {
global $wb;
$wb->menu_number=$menu_number;
$wb->menu_item_template=$item_template;
$wb->menu_item_footer='';
$wb->menu_parent = $parent;
$wb->menu_header = $menu_header;
$wb->menu_footer = $menu_footer;
$wb->menu_default_class = $default_class;
$wb->menu_current_class = $current_class;
$wb->menu_recurse = $recurse+2;
$wb->menu();
unset($wb->menu_parent);
unset($wb->menu_number);
unset($wb->menu_item_template);
unset($wb->menu_item_footer);
unset($wb->menu_header);
unset($wb->menu_footer);
unset($wb->menu_default_class);
unset($wb->menu_current_class);
unset($wb->menu_start_level);
unset($wb->menu_collapse);
unset($wb->menu_recurse);
}
}
if (!function_exists('show_menu')) {
/**
* Old menu generator
* @deprecated from WB 2.8.x and up
* @global $wb
* @param $menu_number
* @param $start_level
* @param $recurse
* @param $collapse
* @param $item_template
* @param $item_footer
* @param $menu_header
* @param $menu_footer
* @param $default_class
* @param $current_class
* @param $parent
*/
function show_menu($menu_number = NULL, $start_level=NULL, $recurse = NULL, $collapse = NULL, $item_template = NULL, $item_footer = NULL, $menu_header = NULL, $menu_footer = NULL, $default_class = NULL, $current_class = NULL, $parent = NULL) {
global $wb;
if (isset($menu_number))
$wb->menu_number=$menu_number;
if (isset($start_level))
$wb->menu_start_level=$start_level;
if (isset($recurse))
$wb->menu_recurse=$recurse;
if (isset($collapse))
$wb->menu_collapse=$collapse;
if (isset($item_template))
$wb->menu_item_template=$item_template;
if (isset($item_footer))
$wb->menu_item_footer=$item_footer;
if (isset($menu_header))
$wb->menu_header=$menu_header;
if (isset($menu_footer))
$wb->menu_footer=$menu_footer;
if (isset($default_class))
$wb->menu_default_class=$default_class;
if (isset($current_class))
$wb->menu_current_class=$current_class;
if (isset($parent))
$wb->menu_parent=$parent;
$wb->menu();
unset($wb->menu_recurse);
unset($wb->menu_parent);
unset($wb->menu_start_level);
}
}
if (!function_exists('page_content')) {
/**
*
* @global array $TEXT
* @global array $MENU
* @global array $HEADING
* @global array $MESSAGE
* @global array $globals several global vars
* @global datadase $database
* @global wb $wb
* @global string $global_name
* @param int $block
* @return void
*/
function page_content($block = 1) {
// Get outside objects
global $TEXT,$MENU,$HEADING,$MESSAGE;
global $globals;
global $database;
global $wb;
$admin = $wb;
if ($wb->page_access_denied==true) {
echo $MESSAGE['FRONTEND_SORRY_NO_VIEWING_PERMISSIONS'];
return;
}
if ($wb->page_no_active_sections==true) {
echo $MESSAGE['FRONTEND_SORRY_NO_ACTIVE_SECTIONS'];
return;
}
if(isset($globals) AND is_array($globals)) {
foreach($globals AS $global_name) {
global $$global_name;
}
}
// Make sure block is numeric
if (($block = intval($block)) == 0 ) { $block = 1;}
// Include page content
if (!defined('PAGE_CONTENT') OR $block!=1)
{
$page_id = intval($wb->page_id);
if (($wb instanceof frontend) && !$wb->page_is_visible($wb->page)) { // SOLVED dw2015
return ;
}
// First get all sections for this page
$sql = 'SELECT `section_id`, `module`, `publ_start`, `publ_end` ';
$sql .= 'FROM `'.TABLE_PREFIX.'sections` ';
$sql .= 'WHERE `page_id`='.$page_id.' AND `block`='.$block.' ';
$sql .= 'ORDER BY `position`';
if( !($query_sections = $database->query($sql)) ) { return; }
// If none were found, check if default content is supposed to be shown
if($query_sections->numRows() == 0) {
if($wb->default_block_content == 'none') { return; }
if (is_numeric($wb->default_block_content)) {
$page_id = $wb->default_block_content;
} else {
$page_id = $wb->default_page_id;
}
$sql = 'SELECT `section_id`, `module`, `publ_start`, `publ_end` ';
$sql .= 'FROM `'.TABLE_PREFIX.'sections` ';
$sql .= 'WHERE `page_id`='.$page_id.' AND `block`='.$block.' ';
$sql .= 'ORDER BY `position`';
if( !($query_sections = $database->query($sql)) ) { return; }
// Still no cotent found? Give it up, there's just nothing to show!
if($query_sections->numRows() == 0) { return; }
}
// Loop through them and include their module file
while($section = $query_sections->fetchRow(MYSQLI_ASSOC)) {
// skip this section if it is out of publication-date
$now = time();
if( !(($now<=$section['publ_end'] || $section['publ_end']==0) && ($now>=$section['publ_start'] || $section['publ_start']==0)) ) {
continue;
}
$section_id = $section['section_id'] ;
$module = $section['module'] ;
// check if module exists - feature: write in errorlog
if(is_readable(WB_PATH.'/modules/'.$module.'/view.php')) {
// fetch content -- this is where to place possible output-filters (before highlighting)
ob_start() ; // fetch original content
$sSectionIdPrefix = (defined('SEC_ANCHOR') && SEC_ANCHOR != '') ? SEC_ANCHOR : 'Sec' ;
require (WB_PATH.'/modules/'.$module.'/view.php') ;
$content = ob_get_clean() ;
if($content != '') {
$sBeforeContent = ($sSectionIdPrefix == 'none') ? '' : "\n".'
'."\n" ;
$sAfterContent = ($sSectionIdPrefix == 'none') ? '' : "\n".'
'."\n" ;
$content = $sBeforeContent.$content.$sAfterContent ;
}
} else {
continue;
}
// highlights searchresults
if (isset($_GET['searchresult']) && is_numeric($_GET['searchresult'])
&& !isset($_GET['nohighlight'])
&& isset($_GET['sstring'])
&& !empty($_GET['sstring'])
) {
$arr_string = explode(" ", $_GET['sstring']);
if($_GET['searchresult']==2) { // exact match
$arr_string[0] = str_replace("_", " ", $arr_string[0]);
}
echo search_highlight($content, $arr_string);
} else {
echo $content;
}
}
} else { // Searchresults! But also some special pages,
// e.g. guestbook (add entry), news (add comment) uses this
ob_start(); // fetch original content
require(PAGE_CONTENT);
$content = ob_get_clean();
// Apply Filters
if(function_exists('OutputFilterApi')) {
$content = OutputFilterApi('OpF?arg=special', $content);
}
echo $content;
}
}
}
if (!function_exists('show_content')) {
function show_content($block=1) {
page_content($block);
}
}
if (!function_exists('show_breadcrumbs'))
{
function show_breadcrumbs($sep = ' » ',$level = 0, $links = true, $depth = -1, $title = '', $print=true)
{
global $wb,$database,$MENU;
$retVal = '';
$page_id = $wb->page_id;
$title = (trim($title) == '') ? $MENU['BREADCRUMB'] : $title;
if ($page_id != 0)
{
$counter = 0;
// get links as array
$bread_crumbs = $wb->page_trail;
$count = sizeof($bread_crumbs);
// level can't be greater than sum of links
$level = ($count <= $level ) ? $count-1 : $level;
// set level from which to show, delete indexes in array
$crumbs = array_slice($bread_crumbs, $level );
$depth = ($depth <= 0) ? sizeof($crumbs) : $depth;
// if empty array, set orginal links
$crumbs = (!empty($crumbs)) ? $crumbs : $wb->page_trail;
$total_crumbs = ( ($depth <= 0) || ($depth > sizeof($crumbs)) ) ? sizeof($crumbs) : $depth;
$retVal .= '
'.PHP_EOL.'
'.$title.''.PHP_EOL;
// print_r($crumbs);
foreach ($crumbs as $temp)
{
if($counter == $depth) { break; }
// set links and separator
$sql = 'SELECT * FROM `'.TABLE_PREFIX.'pages` WHERE `page_id`='.(int)$temp;
$query_menu = $database->query($sql);
$page = $query_menu->fetchRow();
$show_crumb = (($links == true) && ($temp != $page_id))
? '
'.$page['menu_title'].''.PHP_EOL
: '
'.$page['menu_title'].''.PHP_EOL;
// Permission
switch ($page['visibility'])
{
case 'none' :
case 'hidden' :
// if show, you know there is an error in a hidden page
$retVal .= $show_crumb.' ';
break;
default :
$retVal .= $show_crumb;
break;
}
if ( ( $counter <> $total_crumbs-1 ) )
{
$retVal .= '
'.$sep.''.PHP_EOL;
}
$counter++;
}
$retVal .= "
".PHP_EOL;
if ($print) { print $retVal;} else {return $retVal;}
}
}
}
// Function for page title
if (!function_exists('page_title')) {
function page_title($spacer = ' - ', $template = '[WEBSITE_TITLE][SPACER][PAGE_TITLE]') {
$vars = array('[WEBSITE_TITLE]', '[PAGE_TITLE]', '[MENU_TITLE]', '[SPACER]');
$values = array(WEBSITE_TITLE, PAGE_TITLE, MENU_TITLE, $spacer);
echo str_replace($vars, $values, $template);
}
}
// Function for page description
if (!function_exists('page_description')) {
function page_description() {
global $wb;
if ($wb->page_description!='') {
echo $wb->page_description;
} else {
echo WEBSITE_DESCRIPTION;
}
}
}
// Function for page keywords
if (!function_exists('page_keywords')) {
function page_keywords() {
global $wb;
if ($wb->page_keywords!='') {
echo $wb->page_keywords;
} else {
echo WEBSITE_KEYWORDS;
}
}
}
// Function for page header
if (!function_exists('page_header')) {
function page_header($date_format = 'Y') {
echo WEBSITE_HEADER;
}
}
// Function for page footer
if (!function_exists('page_footer')) {
function page_footer($date_format = 'Y') {
global $starttime;
$vars = array('[YEAR]', '[PROCESS_TIME]');
$processtime=array_sum(explode(" ",microtime()))-$starttime;
$values = array(gmdate($date_format),$processtime);
echo str_replace($vars, $values, WEBSITE_FOOTER);
}
}
/* ------------------------------------------------------------------------------------------------ */
// begin register_frontend_files
/* ------------------------------------------------------------------------------------------------ */
function register_frontend_LoadOnFly ($bInsert=true)
{
static $bSriptLoaded=false;
$sLoadOnFly = '';
if ($bInsert&&!$bSriptLoaded){
$sLoadOnFly .= "\t".''."\n";
$sLoadOnFly .= "\t".''."\n";
$bSriptLoaded = true;
}
return $sLoadOnFly;
}
function register_frontend_ScriptVars ($bInsert=true)
{
static $bSriptLoaded=false;
$sScriptVars = '';
if ($bInsert&&!$bSriptLoaded){
$sScriptVars .= "\t"."\n";
$bSriptLoaded = true;
}
return $sScriptVars;
}
function bind_jquery ($file_id='jquery')
{
$jquery_links = '';
/* include the Javascript jquery api */
if( $file_id == 'jquery' && file_exists(WB_PATH .'/include/jquery/jquery-min.js'))
{
$jquery_links .= "\t".''."\n";
$jquery_links .= "\t".''."\n";
$jquery_links .= "\t".''."\n";
/* workout to insert ui.css and theme */
$jquery_theme = WB_PATH.'/modules/jquery/jquery_theme.js';
$jquery_links .= (file_exists($jquery_theme)
? "\t".''."\n"
: "\t".''."\n");
/* workout to insert plugins functions, set in templatedir */
$jquery_frontend_file = TEMPLATE_DIR.'/jquery_frontend.js';
$jquery_links .= (file_exists(str_replace( WB_URL, WB_PATH, $jquery_frontend_file))
? "\t".''
: '');
}
return $jquery_links;
}
// Function to add optional module Javascript or CSS stylesheets into the section of the frontend
if(!function_exists('register_frontend_modfiles'))
{
function register_frontend_modfiles($file_id="css", $bOutput=true)
{
global $wb, $database, $include_head_link_css, $include_head_links, $page_id;
$page_id = (@$page_id?:$wb->page_id);
$aFilterSettings = getOutputFilterSettings();
// sanity check of parameter passed to the function
$file_id = strtolower($file_id);
$aAllowedAction = array( 'css', 'script', 'js', 'jquery', 'javascript' );
if (!in_array($file_id, $aAllowedAction)) { return false; }
// define default baselink and filename for optional module javascript and stylesheet files
$head_links = "";
$base_file = '';
$base_link = '';
switch ($file_id)
{
case 'css':
$base_link = "\t".'
'."\n";
$base_file = "frontend.css";
if(!empty($include_head_link_css))
{
$head_links .= !strpos($head_links, $include_head_link_css) ? $include_head_link_css : '';
$include_head_link_css = '';
}
break;
case 'jquery':
/*----------------------------------------------------------------------------------------------*/
$key = preg_replace('=^.*?filter([^\.\/\\\\]+)(\.[^\.]+)?$=is', '\1', 'filterScriptVars.php');
$bLoadScriptVars = (isset($aFilterSettings[$key])&&$aFilterSettings[$key] ?false:true);
$base_link .= register_frontend_ScriptVars($bLoadScriptVars);
/*----------------------------------------------------------------------------------------------*/
$key = preg_replace('=^.*?filter([^\.\/\\\\]+)(\.[^\.]+)?$=is', '\1', 'filterLoadOnFly.php');
$bLoadOnFly = (isset($aFilterSettings[$key])&&$aFilterSettings[$key] ?false:true);
$base_link .= register_frontend_LoadOnFly($bLoadOnFly);
/*----------------------------------------------------------------------------------------------*/
$key = preg_replace('=^.*?filter([^\.\/\\\\]+)(\.[^\.]+)?$=is', '\1', 'filterJquery.php');
$bLoadJquery = (isset($aFilterSettings[$key])&&$aFilterSettings[$key] ?false:true);
if ($bLoadJquery) {
$base_link .= bind_jquery($file_id);
}
break;
case 'js':
$base_file = "frontend.js";
$key = preg_replace('=^.*?filter([^\.\/\\\\]+)(\.[^\.]+)?$=is', '\1', 'filterFrontendJs.php');
$bLoadFrontendJs = (isset($aFilterSettings[$key])&&$aFilterSettings[$key] ?false:true);
if ($bLoadFrontendJs) {
$base_link .= "\t".'';
if (!empty($include_head_links))
{
$head_links .= !strpos($head_links, $include_head_links) ? $include_head_links."\n" : '';
$include_head_links = '';
}
}
break;
case 'script_old':
break;
default:
break;
}
if( $file_id != 'jquery_old')
{
// gather information for all models embedded on actual page
$sql = 'SELECT `module` FROM `'.TABLE_PREFIX.'sections` '
. 'WHERE `page_id` = '.(int)$page_id;
if( ($oModules = $database->query($sql)) )
{
while($row = $oModules->fetchRow( MYSQLI_ASSOC ))
{
// check if page module directory contains a frontend.js or frontend.css file
if(file_exists(WB_PATH ."/modules/" .$row['module'] ."/$base_file"))
{
// create link with frontend.js or frontend.css source for the current module
$tmp_link = str_replace("{MODULE_DIRECTORY}", $row['module'], $base_link);
// define constant indicating that the register_frontent_files was invoked
if($file_id == 'css')
{
if(!defined('MOD_FRONTEND_CSS_REGISTERED')) define('MOD_FRONTEND_CSS_REGISTERED', true);
} else {
if(!defined('MOD_FRONTEND_JAVASCRIPT_REGISTERED')) define('MOD_FRONTEND_JAVASCRIPT_REGISTERED', true);
}
// ensure that frontend.js or frontend.css is only added once per module type
if( $tmp_link && strpos($head_links, $tmp_link) === false)
{
$head_links .= $tmp_link;
}
};
}
}
}
if ($bOutput) { print $head_links."\n";} else {return $head_links."\n";}
}
}
// Function to add optional module Javascript into the section of the frontend
if(!function_exists('register_frontend_modfiles_body'))
{
function register_frontend_modfiles_body($file_id="js", $print=true)
{
// sanity check of parameter passed to the function
$file_id = strtolower($file_id);
$aAllowedAction = array( 'css', 'js', 'jquery', 'javascript' );
if(!in_array($file_id, $aAllowedAction)) { return false; }
// define constant indicating that the register_frontent_files was invoked
if(!defined('MOD_FRONTEND_BODY_JAVASCRIPT_REGISTERED')) define('MOD_FRONTEND_BODY_JAVASCRIPT_REGISTERED', true);
global $wb, $database, $include_body_links;
// define default baselink and filename for optional module javascript files
$body_links = "";
/* include the Javascript jquery api */
$body_links .= bind_jquery($file_id);
if($file_id !== "css" && $file_id == "js" && $file_id !== "jquery")
{
$base_link = "\t".'';
$base_file = "frontend_body.js";
// ensure that frontend_body.js is only added once per module type
if(!empty($include_body_links))
{
if(strpos($body_links, $include_body_links) === false)
{
$body_links .= $include_body_links;
}
$include_body_links = '';
}
// gather information for all models embedded on actual page
$page_id = $wb->page_id;
$sql = 'SELECT `module` FROM `'.TABLE_PREFIX.'sections` ';
$sql .= 'WHERE `page_id` = '.(int)$page_id.' AND `module`<>\'wysiwyg\'';
if( ($query_modules = $database->query($sql)) )
{
while($row = $query_modules->fetchRow(MYSQLI_ASSOC))
{
// check if page module directory contains a frontend_body.js file
if(file_exists(WB_PATH ."/modules/" .$row['module'] ."/$base_file"))
{
// create link with frontend_body.js source for the current module
$tmp_link = str_replace("{MODULE_DIRECTORY}", $row['module'], $base_link);
// define constant indicating that the register_frontent_files_body was invoked
if(!defined('MOD_FRONTEND_BODY_JAVASCRIPT_REGISTERED')) { define('MOD_FRONTEND_BODY_JAVASCRIPT_REGISTERED', true);}
// ensure that frontend_body.js is only added once per module type
if(strpos($body_links, $tmp_link) === false)
{
$body_links .= $tmp_link;
}
}
}
}
}
if ($print) { print $body_links."\n";} else {return $body_links."\n";}
// print $body_links."\n"; ;
}
}
function moveCssToHead($content) {
return OutputFilterApi('CssToHead', $sContent);
}