<?


   

  include("../include/conf.php");
  include("{$root}include/config.php");
  require_once("./sql/SqlConfiguration.class.php");
  require_once("./sql/SqlDatabase.class.php");
  require_once("./sql/ArticlesTableRow.class.php");
  require_once("./sql/ArticlesTable.class.php");
  require_once("./sql/CategoriesTableRow.class.php");
  require_once("./sql/CategoriesTable.class.php");

  $SUBMIT_FORM_VARS = array_merge($HTTP_POST_VARS,$HTTP_GET_VARS);      

  $wcCategory = 0;
  if (isset($SUBMIT_FORM_VARS["wcCategory"])){
    $wcCategory = $SUBMIT_FORM_VARS["wcCategory"];
  }

  $wcHeadlines = 2;
  if (isset($SUBMIT_FORM_VARS["wcHeadlines"])){
    $wcHeadlines = $SUBMIT_FORM_VARS["wcHeadlines"];
  }

  $wcBackground = "#ffffff";
  if (isset($SUBMIT_FORM_VARS["wcBackground"])){
    $wcBackground = $SUBMIT_FORM_VARS["wcBackground"];
  }

  $wcTableWidth = 200;
  if (isset($SUBMIT_FORM_VARS["wcTableWidth"])){
    $wcTableWidth = $SUBMIT_FORM_VARS["wcTableWidth"];
  }

  $atFont = "arial";
  if (isset($SUBMIT_FORM_VARS["atFont"])){
    $atFont = $SUBMIT_FORM_VARS["atFont"];
  }

  $atFontSize = 3;
  if (isset($SUBMIT_FORM_VARS["atFontSize"])){
    $atFontSize = $SUBMIT_FORM_VARS["atFontSize"];
  }

  $atFontColor = "#000099";
  if (isset($SUBMIT_FORM_VARS["atFontColor"])){
    $atFontColor = $SUBMIT_FORM_VARS["atFontColor"];
  }

  $atFontBold = "Yes";
  if (isset($SUBMIT_FORM_VARS["atFontBold"])){
    $atFontBold = $SUBMIT_FORM_VARS["atFontBold"];
  }

  $atFontItalic = "No";
  if (isset($SUBMIT_FORM_VARS["atFontItalic"])){
    $atFontItalic = $SUBMIT_FORM_VARS["atFontItalic"];
  }

  
  if (isset($SUBMIT_FORM_VARS["adShowDate"])){
    $adShowDate = $SUBMIT_FORM_VARS["adShowDate"];
  }
  else{
    $adShowDate = "Yes";
  }
  
  $adFont = "arial";
  if (isset($SUBMIT_FORM_VARS["adFont"])){
    $adFont = $SUBMIT_FORM_VARS["adFont"];
  }

  $adFontSize = 1;
  if (isset($SUBMIT_FORM_VARS["adFontSize"])){
    $adFontSize = $SUBMIT_FORM_VARS["adFontSize"];
  }

  $adFontColor = "#666666";
  if (isset($SUBMIT_FORM_VARS["adFontColor"])){
    $adFontColor = $SUBMIT_FORM_VARS["adFontColor"];
  }

  $adFontBold = "No";
  if (isset($SUBMIT_FORM_VARS["adFontBold"])){
    $adFontBold = $SUBMIT_FORM_VARS["adFontBold"];
  }

  $adFontItalic = "Yes";
  if (isset($SUBMIT_FORM_VARS["adFontItalic"])){
    $adFontItalic = $SUBMIT_FORM_VARS["adFontItalic"];
  }

  $adFontUnderline = "No";
  if (isset($SUBMIT_FORM_VARS["adFontUnderline"])){
    $adFontUnderline = $SUBMIT_FORM_VARS["adFontUnderline"];
  }

  $asShowSummary = "Yes";
  if (isset($SUBMIT_FORM_VARS["asShowSummary"])){
    $asShowSummary = $SUBMIT_FORM_VARS["asShowSummary"];
  }

  $asFont = "arial";
  if (isset($SUBMIT_FORM_VARS["asFont"])){
    $asFont = $SUBMIT_FORM_VARS["asFont"];
  }

  $asFontSize = 2;
  if (isset($SUBMIT_FORM_VARS["asFontSize"])){
    $asFontSize = $SUBMIT_FORM_VARS["asFontSize"];
  }

  $asFontColor = "#000000";
  if (isset($SUBMIT_FORM_VARS["asFontColor"])){
    $asFontColor = $SUBMIT_FORM_VARS["asFontColor"];
  }

  $asFontBold = "No";
  if (isset($SUBMIT_FORM_VARS["asFontBold"])){
    $asFontBold = $SUBMIT_FORM_VARS["asFontBold"];
  }

  $asFontItalic = "No";
  if (isset($SUBMIT_FORM_VARS["asFontItalic"])){
    $asFontItalic = $SUBMIT_FORM_VARS["asFontItalic"];
  }

  $asFontUnderline = "No";
  if (isset($SUBMIT_FORM_VARS["asFontUnderline"])){
    $asFontUnderline = $SUBMIT_FORM_VARS["asFontUnderline"];
  }

  $rows = $articlesTable->selectByCategoryId($wcHeadlines,$wcCategory);
  
  if (count($rows) > 0){
  
    $result = "<table bgcolor='" . $wcBackground . "' width='" . $wcTableWidth . "' border='0'>";
    
    for ($i=0; $i<count($rows); $i++){

      if ($showFriendlyURL=='friendly')
      {
       $SEfriendly = $rows[$i]->SEfriendly;
       if (empty($SEfriendly)) $SEfriendly = $rows[$i]->id;
       $friendlyURL = $categoriesTable->friendly_path($rows[$i]->category_id) . $SEfriendly . ".html";
      } else $friendlyURL = 'index.php?news=' . $rows[$i]->id;

      $result = $result . "<tr><td bgcolor='" . $wcBackground . "'> <br>";
//      $result = $result . "<a href='" . $url . 'index.php?news=' . $rows[$i]->id . "' target='_blank'>";
      $result = $result . "<a href='" . $url . $friendlyURL . "' target='_blank'>";
      if ($atFontBold == "Yes"){
        $result = $result . "<b>";
      }
      if ($atFontItalic == "Yes"){
        $result = $result . "<i>";
      }
      $result = $result . "<font color='" . $atFontColor . "' face='" . $atFont . "' size='" . $atFontSize . "'>";
      $result = $result . $rows[$i]->title;
      $result = mb_convert_encoding($result, 'cp1251', 'utf-8');
      $result = $result . "<br></font>";
      if ($atFontItalic == "Yes"){
        $result = $result . "</i>";
      }
      if ($atFontBold == "Yes"){
        $result = $result . "</b>";
      }
      
      $result = $result . "</a>"; 
      $result = $result . "</td></tr>";

      if ($adShowDate == "Yes"){
        $result = $result . "<tr><td bgcolor='" . $wcBackground . "'>";
        if ($adFontBold == "Yes"){
          $result = $result . "<b>";
        }
        if ($adFontItalic == "Yes"){
          $result = $result . "<i>";
        }
        if ($adFontUnderline == "Yes"){
          $result = $result . "<u>";
        }
        $result = $result . "<font color='" . $adFontColor . "' face='" . $adFont . "' size='" . $adFontSize . "'>";
        $result = $result . $articlesTable->toAmericanDate($rows[$i]->created);
        $result = $result . "<br></font>";
        if ($adFontUnderline == "Yes"){
          $result = $result . "</u>";
        }
        if ($atFontItalic == "Yes"){
          $result = $result . "</i>";
        }
        if ($atFontBold == "Yes"){
          $result = $result . "</b>";
        }
        $result = $result . "</td></tr>";
      }      

      if ($asShowSummary == "Yes"){
        $result = $result . "<tr><td bgcolor='" . $wcBackground . "'>";
        if ($asFontBold == "Yes"){
          $result = $result . "<b>";
        }
        if ($asFontItalic == "Yes"){
          $result = $result . "<i>";
        }
        if ($asFontUnderline == "Yes"){
          $result = $result . "<u>";
        }
        $result = $result . "<font color='" . $asFontColor . "' face='" . $asFont . "' size='" . $asFontSize . "'>";
        $result = $result . $rows[$i]->body;
        $result = mb_convert_encoding($result, 'cp1251', 'utf-8');   
        $result = $result . "<br></font>";
        if ($asFontUnderline == "Yes"){
          $result = $result . "</u>";
        }
        if ($asFontItalic == "Yes"){
          $result = $result . "</i>";
        }
        if ($asFontBold == "Yes"){
          $result = $result . "</b>";
        }
        $result = $result . "</td></tr>";
      }      
      
    }
    $result = $result . "</table>";
/*
    include_once("{$root}include/lang/{$default_language}.php");
    if (!empty($lng_charset))
        header('Content-Type: text/html; charset='.$lng_charset);
*/

    $result = rawurlencode($result);

    if (isset($SUBMIT_FORM_VARS["preview"]))
    {
       echo "<script language='JavaScript'>";
       echo " document.writeln(unescape('" . $result . "'));";
       echo "</script>";

    }  else
       echo " document.writeln(unescape('" . $result . "'));";

  }    
  

?>