<?

  error_reporting(E_ALL);
  ini_set('display_errors', '1');

  include("config.php");

  if( !isset($_GET['p']) ) $p="home";
  else $p = $_GET['p'];

  if( !isset($_GET['l']) ) $lang="de";
  else $lang = $_GET['l'];

  // Connect to database
  mysql_connect(DB_HOST, DB_USERNAME, DB_PASSWORD) or die(mysql_error());
  mysql_select_db(DB_NAME) or die(mysql_error());

  // retrieve value from symbol list
  $query = "SELECT * FROM publishing_photo_pages WHERE title_". $lang . " = '" . $p."'";

  $sql_data = mysql_query($query) or die(mysql_error() );
  $n = mysql_num_rows($sql_data);
  $result = mysql_fetch_array( $sql_data );

  $page = file_get_contents('1_header-bg.html');
  $script = file_get_contents('javascript.html');
  
  $page = str_replace("TITLE",$result["heading1_".$lang],$page);
  // Build Menu
  $query = "SELECT * FROM `publishing_photo_pages_header_menu` WHERE title_".$lang." IS NOT NULL AND type='TL'
            AND (`end_date` IS NULL OR end_date > now() ) ORDER BY link_nr";
  $sql_data2 = mysql_query($query) or die(mysql_error() );

  $page_m = file_get_contents('9.7 menu_line.html');
  $box = ""; $i=1;
  while ($result2 = mysql_fetch_array( $sql_data2 )) {
        if ($i==1) { // menu title
          $page = str_replace("menu_title_text",$result2["title_".$lang],$page);
        } else {
          $line = str_replace("menu_title",$result2["title_".$lang],$page_m);
          $line = str_replace("key#",$i,$line);
          $line = str_replace("header_link",$_SERVER['PHP_SELF']."?p=".$result2["link_title_".$lang]."&l=".$lang,$line);
          $box = $box . $line ."\n";
        }
        $i++;
  }
  
/*  
  $page = str_replace("menu_line",$box,$page);
  $page = str_replace("#home",$_SERVER['PHP_SELF']."?p=home&l=".$lang,$page);
  if ($lang == "de") {
    $page = str_replace("[DE][EN]","English",$page);
    $page = str_replace("#language",$_SERVER['PHP_SELF']."?p=". $result["title_en"] ."&l=en",$page);
  } else {
    $page = str_replace("[DE][EN]","Deutsch",$page);
    $page = str_replace("#language",$_SERVER['PHP_SELF']."?p=". $result["title_de"] ."&l=de",$page);
  }
*/  
  
  // check umlaute
  $page = str_replace("ä", "&auml;",$page);
  $page = str_replace("ö", "&ouml;",$page);
  $page = str_replace("ü", "&uuml;",$page);
  $page = str_replace("Ä", "&Auml;",$page);
  $page = str_replace("Ö", "&Ouml;",$page);
  $page = str_replace("Ü", "&Uuml;",$page);
  
  echo $page;
  // end build menu
  
  if ($n!=1) {
  
      //echo $result['heading1_de'];
      $page = file_get_contents('6_sub2_page-bg.html');
      $page = str_replace("picture_line","",$page);
      $page = str_replace("Heading 1","Sorry",$page);
      $page = str_replace("Heading 2","page not available",$page);
      $page = str_replace("1st 3 words","",$page);
      $page = str_replace("paragraph 1","",$page);

      // links
      $page = str_replace("Heading Links","",$page);
      for ($i=1;$i<=8;$i++) {
        $page = str_replace("Link ".$i,"",$page);
        $page = str_replace("Link_URL".$i,"",$page);
      }
      echo $page;

  } else {
    $type = $result['type'];
    $pic_line = file_get_contents('9.8 picture_line.html');

    if ($type == "M") {   // Main front page

      //echo $result['heading1_de'];
      $page = file_get_contents('4_main_page-bg.html');

      // scope 1
      $query = "SELECT  `heading1_".$lang."`, `heading2_".$lang."` FROM `publishing_photo_pages` WHERE `title_".$lang."` = '".$result["home_scope1_title_".$lang]."'";
      $sql_data2 = mysql_query($query) or die(mysql_error() );
      if ($result2 = mysql_fetch_array( $sql_data2 )) {
        $page = str_replace("Scope 1",$result2["heading1_".$lang],$page);
        $page = str_replace("description scope 1",$result2["heading2_".$lang],$page);
        $page = str_replace("#scope1_ref",$_SERVER['PHP_SELF']."?p=".$result["home_scope1_title_".$lang]."&l=".$lang,$page);
      }
      
      // scope 2
      $query = "SELECT  `heading1_".$lang."`, `heading2_".$lang."` FROM `publishing_photo_pages` WHERE `title_".$lang."` = '".$result["home_scope2_title_".$lang]."'";
      $sql_data2 = mysql_query($query) or die(mysql_error() );
      if ($result2 = mysql_fetch_array( $sql_data2 )) {
        $page = str_replace("Scope 2",$result2["heading1_".$lang],$page);
        $page = str_replace("description scope 2",$result2["heading2_".$lang],$page);
        $page = str_replace("#scope2_ref",$_SERVER['PHP_SELF']."?p=".$result["home_scope2_title_".$lang]."&l=".$lang,$page);
      }

      // scope 3
      $query = "SELECT  `heading1_".$lang."`, `heading2_".$lang."` FROM `publishing_photo_pages` WHERE `title_".$lang."` = '".$result["home_scope3_title_".$lang]."'";
      $sql_data2 = mysql_query($query) or die(mysql_error() );
      if ($result2 = mysql_fetch_array( $sql_data2 )) {
        $page = str_replace("Scope 3",$result2["heading1_".$lang],$page);
        $page = str_replace("description scope 3",$result2["heading2_".$lang],$page);
        $page = str_replace("#scope3_ref",$_SERVER['PHP_SELF']."?p=".$result["home_scope3_title_".$lang]."&l=".$lang,$page);
      }
      
      $query = "SELECT `heading1_".$lang."`, `heading2_".$lang."`, `picture`, `title_".$lang."`, `3word_".$lang."`, `content_".$lang."`, `pic_title_".$lang."` FROM `publishing_photo_pages` WHERE topstory_nr IS NOT NULL ORDER BY topstory_nr";
      $sql_data2 = mysql_query($query) or die(mysql_error() );
      $n2 = mysql_num_rows($sql_data2);
	  
      // update Latest Top Paragraphs
      $page_p = file_get_contents('9.0 front_paragraph.html');
      $box = "";
      while ($result2 = mysql_fetch_array( $sql_data2 )) {
        if ($box == "") { // 1st paragraph
          $page = str_replace("Top Heading 1",$result2['heading1_'.$lang],$page);
          $page = str_replace("Top Heading 2",$result2['heading2_'.$lang],$page);
        }
      
        if ($result2['picture']) {
          $line = str_replace("picture_line",$pic_line,$page_p);
          $line = str_replace("picture2",$result2['picture'],$line);
          $line = str_replace("pic_title",$result2['pic_title_'.$lang],$line);
        } else {
          $line = str_replace("picture_line","",$page_p);
        }

        $line = str_replace("First part (3 words)",$result2["3word_".$lang],$line);
        $line = str_replace("Top Description (370 characters)",substr($result2["content_".$lang], 0, PARAGRAPH_LEN),$line);
	    $line = str_replace("JAVASCRIPT",$script ,$line); // check if javascript
        $line = str_replace("topstory_link",$_SERVER['PHP_SELF']."?p=".$result2["title_".$lang]."&l=".$lang,$line);
        if (strlen($result2["content_".$lang]) < PARAGRAPH_LEN)  {
          $line = str_ireplace("more...","",$line);
        }
        $box = $box . $line ."\n";
      }
      $page = str_replace("TopParagraph",$box,$page);

    }   // end ($type == "M")

    if ($type == "2C") {
    
      //echo $result['heading1_de'];
      $page = file_get_contents('6_sub2_page-bg.html');
      if ($result['picture']) {
        $page = str_replace("picture_line",$pic_line,$page);
        $page = str_replace("picture2",$result['picture'],$page);
        $page = str_replace("pic_title",$result['pic_title_'.$lang],$page);
      } else {
        $page = str_replace("picture_line","",$page);
      }
        
      $page = str_replace("Heading 1",$result["heading1_".$lang],$page);
      $page = str_replace("Heading 2",$result["heading2_".$lang],$page);
      $page = str_replace("1st 3 words",$result["3word_".$lang],$page);
      
      $content_str = $result["content_".$lang];
      if ($result["content_uses_list"]) {
        // check list elements
        $content_str = str_ireplace("<ul>","<table>",$content_str);
        $content_str = str_ireplace("<li>",'<tr><td valign="top"><b>&bull;</b></td><td>',$content_str);
        $content_str = str_ireplace("</li>","</td></tr>",$content_str);
        $content_str = str_ireplace("</ul>","</table>",$content_str);
      } else {
        $content_str = nl2br($result["content_".$lang]);
      }
      if ($result['pic_title_'.$lang]!="") {
        if ($lang == "de") $content_str .= "<br><i>Bildlegende: ";
        if ($lang == "en") $content_str .= "<br><i>Picture caption: ";
        $content_str .= nl2br($result['pic_title_'.$lang]) . "</i>";
      }
      $content_str = str_replace("JAVASCRIPT",$script ,$content_str); // check if javascript
      $page = str_replace("paragraph 1",$content_str,$page);
      
      // links
      $page = str_replace("Heading Links",$result["link_title_".$lang],$page);
      for ($i=1;$i<=8;$i++) {
        $page = str_replace("Link ".$i,$result["link_desc".$i."_".$lang],$page);
        $page = str_replace("Link_URL".$i,$_SERVER['PHP_SELF']."?p=".$result["link_ref".$i."_".$lang]."&l=".$lang,$page);
      }
      
    }   // end ($type == "2C")

    // print main page

    // update Latest Update
    $page_u = file_get_contents('9.1 update_box.html');
    $cat = $result['category'];

    if ($type == "2C") $query = "SELECT `date`, `title_".$lang."`, `heading1_".$lang."` FROM `publishing_photo_pages` WHERE `category` = '".$cat."' and (`end_date` >= '".date("Y-m-d")."' OR `end_date` IS NULL) and length(`title_".$lang."`)>4 ORDER BY date DESC"; 
    if ($type == "M") $query = "SELECT `date`, `title_".$lang."`, `heading1_".$lang."` FROM `publishing_photo_pages` WHERE length(`title_".$lang."`)>4 and (`end_date` >= '".date("Y-m-d")."' OR `end_date` IS NULL) ORDER BY date DESC";
	
    $sql_data2 = mysql_query($query) or die(mysql_error() );
    $n2 = mysql_num_rows($sql_data2);
    $m = min ($n2,MAX_UPDATES); $box = "";
    for ($i=1;$i<=$m;$i++) {
        $result2 = mysql_fetch_array( $sql_data2 );
        $date_str = $result2["date"];
        $line = str_replace("Date 1"," ".date('M-Y' ,strtotime( $date_str ))." ",$page_u);
        $line = str_replace("Update 1",$result2["heading1_".$lang],$line);
        $line = str_replace("update_link_1",$_SERVER['PHP_SELF']."?p=".$result2["title_".$lang]."&l=".$lang,$line);
        $box = $box . "\n".$line;
    }
    $page = str_replace("UpdateBox",$box,$page);

    // check umlaute
    $page = str_replace("ä", "&auml;",$page);
    $page = str_replace("ö", "&ouml;",$page);
    $page = str_replace("ü", "&uuml;",$page);
    $page = str_replace("Ä", "&Auml;",$page);
    $page = str_replace("Ö", "&Ouml;",$page);
    $page = str_replace("Ü", "&Uuml;",$page);

    echo $page;

  }  // end valid page
  
  // footer
  
  $page = file_get_contents('7_bg2.html');
  if ($result["title_left_".$lang]!='' or $result["title_mid_".$lang]!='' or $result["title_right_".$lang]!='') {
    // left

    $query = "SELECT  `picture2`, `pic_title_".$lang."`, `heading1_".$lang."`, `heading2_".$lang."`, `3word_".$lang."`, `content_".$lang."` FROM `publishing_photo_pages` WHERE `title_".$lang."` = '".$result["title_left_".$lang]."'";
    $sql_data2 = mysql_query($query) or die(mysql_error() );
    if ($result2 = mysql_fetch_array( $sql_data2 )) {
      if ($result2["picture2"]) $page = str_replace("homepage_06.jpg",$result2["picture2"],$page);
      $page = str_replace("Title 2 L",$result2["heading1_".$lang],$page);
      $page = str_replace("Title 3 L",$result2["heading2_".$lang],$page);
      $page = str_replace("pic_title_l",$result2["pic_title_".$lang],$page);
      
      $page = str_replace("Left part (3 words)",$result2["3word_".$lang],$page);
      $page = str_replace("Top Description L (155 characters)",substr($result2["content_".$lang], 0, FOOTER_LEN),$page);
      $page = str_replace("link_L",$_SERVER['PHP_SELF']."?p=".$result["title_left_".$lang]."&l=".$lang,$page);

    }
    // mid
    $query = "SELECT `picture2`, `pic_title_".$lang."`, `heading1_".$lang."`, `heading2_".$lang."`, `3word_".$lang."`, `content_".$lang."` FROM `publishing_photo_pages` WHERE `title_".$lang."` = '".$result["title_mid_".$lang]."'";
    $sql_data2 = mysql_query($query) or die(mysql_error() );
    if ($result2 = mysql_fetch_array( $sql_data2 )) {
      if ($result2["picture2"]) $page = str_replace("homepage_07.jpg",$result2["picture2"],$page);
      $page = str_replace("Title 2 M",$result2["heading1_".$lang],$page);
      $page = str_replace("Title 3 M",$result2["heading2_".$lang],$page);
      $page = str_replace("pic_title_m",$result2["pic_title_".$lang],$page);

      $page = str_replace("Mid part (3 words)",$result2["3word_".$lang],$page);
      $page = str_replace("Top Description M (155 characters)",substr($result2["content_".$lang], 0, FOOTER_LEN),$page);
      $page = str_replace("link_M",$_SERVER['PHP_SELF']."?p=".$result["title_mid_".$lang]."&l=".$lang,$page);

    }
    // right
    $query = "SELECT  `picture2`, `pic_title_".$lang."`, `heading1_".$lang."`, `heading2_".$lang."`, `3word_".$lang."`, `content_".$lang."` FROM `publishing_photo_pages` WHERE `title_".$lang."` = '".$result["title_right_".$lang]."'";
    $sql_data2 = mysql_query($query) or die(mysql_error() );
    if ($result2 = mysql_fetch_array( $sql_data2 )) {
      if ($result2["picture2"]) $page = str_replace("homepage_08.jpg",$result2["picture2"],$page);
      $page = str_replace("Title 2 R",$result2["heading1_".$lang],$page);
      $page = str_replace("Title 3 R",$result2["heading2_".$lang],$page);
      $page = str_replace("pic_title_r",$result2["pic_title_".$lang],$page);

      $page = str_replace("Right part (3 words)",$result2["3word_".$lang],$page);
      $page = str_replace("Top Description R (155 characters)",substr($result2["content_".$lang], 0, FOOTER_LEN),$page);
      $page = str_replace("link_R",$_SERVER['PHP_SELF']."?p=".$result["title_right_".$lang]."&l=".$lang,$page);

    }

    // check umlaute
    $page = str_replace("ä", "&auml;",$page);
    $page = str_replace("ö", "&ouml;",$page);
    $page = str_replace("ü", "&uuml;",$page);
    $page = str_replace("Ä", "&Auml;",$page);
    $page = str_replace("Ö", "&Ouml;",$page);
    $page = str_replace("Ü", "&Uuml;",$page);
    echo $page;
  }
  
  $query = "SELECT * FROM `publishing_photo_pages_header_menu` WHERE title_".$lang." IS NOT NULL AND type='FL' ORDER BY link_nr";
  $sql_data2 = mysql_query($query) or die(mysql_error() );
/*
  $page_m = file_get_contents('8_footer-bg.html');
  $i=1;
  while ($result2 = mysql_fetch_array( $sql_data2 )) {
      $page_m = str_replace("footer_".$i,$result2["title_".$lang],$page_m);
      $page_m = str_replace("link_".$i,$_SERVER['PHP_SELF']."?p=".$result2["link_title_".$lang]."&l=".$lang,$page_m);
      $i++;
  }
  echo $page_m;
*/
?>