WB 2.08.x

 * @author          Ryan Djurovich (2004-2009), WebsiteBaker Project

	/**

	 *

	 *

	 * @param mixed $lang

	 * @param mixed $level

	 * @param mixed $parent

	 * @return

	 */

	public function GetLanguagesPages ( $lang, $level, $parent ) {

		global $database;

        $page = array();

        $sql =

        'SELECT `language`,`visibility`,`viewing_groups`,`viewing_users`,`language`,`position`, '.

        '`page_id`,`level`,`parent`,`root_parent`,`page_code`,`link` '.

        'FROM `'.TABLE_PREFIX.'pages` '.

        'WHERE `level`=\''.$level.'\' '.

          'AND `language`=\''.$lang['language'].'\' '.

          'AND `visibility`!=\'none\' '.

          'AND `visibility`!=\'hidden\' '.

          'AND `parent`=\''.$parent.'\' '.

          'AND `root_parent`=`page_id` '.

        'ORDER BY `position`';

        if($oPage = $database->query($sql))

        {

            $page = $oPage->fetchRow(MYSQL_ASSOC);

        }

        return $page;

	}

	/**

	 *

	 *

	 * @return

	 */

	public function GetLanguagesInUsed (  ) {

		global $database;

        $retVal = '';

        $page = array();

        $sql =

        'SELECT DISTINCT `language` '.

        'FROM `'.TABLE_PREFIX.'pages` '.

        'WHERE `level`= \'0\' '.

          'AND `visibility`!=\'none\' '.

          'AND `visibility`!=\'hidden\' '.

       'ORDER BY `position`';

        if($oRes = $database->query($sql))

        {

            while($lang = $oRes->fetchRow(MYSQL_ASSOC))

            {

                $page = $this->GetLanguagesPages ( $lang, 0, 0 );

                if(!$this->page_is_visible($page)) {continue;}

                $retVal .= $page['language'].',';

            }

        }

        return trim($retVal,',');

	}

/*

 * @param string $type: 'locked'(default)  or 'new'

 * @return void: terminates application

 * @description: 'locked' >> Show maintenance screen and terminate, if system is locked

 *               'new' >> Show 'new site under construction'(former print_under_construction)

 */

	public function ShowMaintainScreen($type = 'locked')

	{

		global $database, $MESSAGE;

		$CHECK_BACK = $MESSAGE['GENERIC_PLEASE_CHECK_BACK_SOON'];

		$BE_PATIENT = '';

		$LANGUAGE   = strtolower((isset($_SESSION['LANGUAGE']) ? $_SESSION['LANGUAGE'] : LANGUAGE ));

		$show_screen = false;

		if($type == 'locked')

		{

			$curr_user = (intval(isset($_SESSION['USER_ID']) ? $_SESSION['USER_ID'] : 0) ) ;

			if( (defined('SYSTEM_LOCKED') && (int)SYSTEM_LOCKED == 1) && ($curr_user != 1))

			{

				header($_SERVER['SERVER_PROTOCOL'].' 503 Service Unavailable');

	// first kick logged users out of the system

		// delete all remember keys from table 'user' except user_id=1

				$sql  = 'UPDATE `'.TABLE_PREFIX.'users` SET `remember_key`=\'\' ';

				$sql .= 'WHERE `user_id`<>1';

				$database->query($sql);

		// delete remember key-cookie if set

				if (isset($_COOKIE['REMEMBER_KEY'])) {

					setcookie('REMEMBER_KEY', '', time() - 3600, '/');

				}

		// overwrite session array

				$_SESSION = array();

		// delete session cookie if set

				if (ini_get("session.use_cookies")) {

					$params = session_get_cookie_params();

					setcookie(session_name(), '', time() - 42000, $params["path"],

						$params["domain"], $params["secure"], $params["httponly"]

					);

				}

		// delete the session itself

				session_destroy();

				$PAGE_TITLE = $MESSAGE['GENERIC_WEBSITE_LOCKED'];

				$BE_PATIENT = $MESSAGE['GENERIC_BE_PATIENT'];

				$PAGE_ICON  = 'system';

				$show_screen = true;

			}

		} else {

			header($_SERVER['SERVER_PROTOCOL'].' 503 Service Unavailable');

			$PAGE_TITLE = $MESSAGE['GENERIC_WEBSITE_UNDER_CONSTRUCTION'];

			$PAGE_ICON  = 'negative';

			$show_screen = true;

		}

		if($show_screen)

		{

            $sMaintanceFile = $this->correct_theme_source('maintance.htt');

    		if(file_exists($sMaintanceFile))

    		{

                $tpl = new Template(dirname( $sMaintanceFile ));

    		    $tpl->set_file( 'page', 'maintance.htt' );

    		    $tpl->set_block( 'page', 'main_block', 'main' );

    			if(defined('DEFAULT_CHARSET'))

    			{

    				$charset=DEFAULT_CHARSET;

    			} else {

    				$charset='utf-8';

    			}

    		    $tpl->set_var( 'PAGE_TITLE', $MESSAGE['GENERIC_WEBSITE_UNDER_CONSTRUCTION'] );

    	 	    $tpl->set_var( 'CHECK_BACK', $MESSAGE['GENERIC_PLEASE_CHECK_BACK_SOON'] );

    	 	    $tpl->set_var( 'CHARSET', $charset );

    	 	    $tpl->set_var( 'WB_URL', WB_URL );

    	 	    $tpl->set_var( 'BE_PATIENT', $BE_PATIENT );

    	 	    $tpl->set_var( 'THEME_URL', THEME_URL );

    			$tpl->set_var( 'PAGE_ICON', $PAGE_ICON);

    			$tpl->set_var( 'LANGUAGE', strtolower(LANGUAGE));

    		    $tpl->parse( 'main', 'main_block', false );

    		    $tpl->pparse( 'output', 'page' );

                exit();

    		} else {

    		 require_once(WB_PATH.'/languages/'.DEFAULT_LANGUAGE.'.php');

    		echo '<!DOCTYPE html PUBLIC "-W3CDTD XHTML 1.0 TransitionalEN" "http:www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

    		<head><title>'.$MESSAGE['GENERIC_WEBSITE_UNDER_CONSTRUCTION'].'</title>

    		<style type="text/css"><!-- body{ font-family: Verdana, Arial, Helvetica, sans-serif;font-size: 12px; background-image: url("'.WB_URL.'/templates/'.DEFAULT_THEME.'/images/background.png");background-repeat: repeat-x; background-color: #A8BCCB; text-align: center; }

    		h1 { margin: 0; padding: 0; font-size: 18px; color: #000; text-transform: uppercase;}--></style></head><body>

    		<br /><h1>'.$MESSAGE['GENERIC_WEBSITE_UNDER_CONSTRUCTION'].'</h1><br />

    		'.$MESSAGE['GENERIC_PLEASE_CHECK_BACK_SOON'].'</body></html>';

    		}

    		flush();

            exit();

		}

	}