Ticket #5092: zpravy_o_cinnosti.php

<?
if ($pristup AND ($access_login_menu_options[$menu_options]) OR ($row_groups_login[id] == 1)) {
  $skins = array("kama", "office2003", "v2");
  $skin = $skins[0];
  
  $key = "Upravit";
  $tran_upravit = text_by_lang($pg_link, $key, $lang);
  
  if ($zpravy_o_cinnosti == "Odeslat") {
    $text = strtr($editorcontents, $trans_windows_1250_to_iso_8859_2);
    
    if ($odbor_zpravy_o_cinnosti_id == 0) {
      $query = "INSERT INTO odbor_zpravy_o_cinnosti (typ, text_$lang) VALUES ('$odbor_typ', '$text')";
      //print $query.NL;
      pg_query($pg_link, $query);
    } else {
      $query = "UPDATE odbor_zpravy_o_cinnosti SET text_$lang='$text' WHERE id='$odbor_zpravy_o_cinnosti_id'";
      pg_query($pg_link, $query);
    }
  }
  
  $query = "SELECT * FROM odbor_zpravy_o_cinnosti WHERE typ='$odbor_typ'";
  //print $query.NL;
  $result = pg_query($pg_link, $query);
  $rows = pg_num_rows($result);
  if ($rows == 0) {
    $odbor_zpravy_o_cinnosti_id = 0;
    
    $editorcontents = "";
  } else {
    $row = pg_fetch_array($result);
    
    $odbor_zpravy_o_cinnosti_id = $row[id];
    
    $editorcontents_lang = "text_".$lang;
    $editorcontents = $row[$editorcontents_lang];
  }
  
  print "<table width=100%>\n";
  print "  <tr>\n";
  print "    <td width=100%></td>\n";
  print "    <td><button onClick='document.zpravy_o_cinnosti_modify.submit()' title='$tran_upravit' style='cursor:pointer;cursor:hand'><img src='obr/record_modify.gif' class='button'></button></td>\n";
  print "  </tr>\n";
  print "</table>\n";
  
  print "<form method='post' name='zpravy_o_cinnosti_modify'>\n";
  print "<input type='hidden' name='lang' value='$lang'>\n";
  print "<input type='hidden' name='menu_id' value='$menu_id'>\n";
  print "<input type='hidden' name='page' value='$page'>\n";
  print "<input type='hidden' name='odbor_zpravy_o_cinnosti_id' value='$odbor_zpravy_o_cinnosti_id'>\n";
  print "<input type='hidden' name='zpravy_o_cinnosti' value='modify'>\n";
  print "</form>\n";
  
  if ($zpravy_o_cinnosti == "modify") {
    print "<table border=0>\n";
    print "  <form method='post'>\n";
    print "  <input type='hidden' name='lang' value='$lang'>\n";
    print "  <input type='hidden' name='menu_id' value='$menu_id'>\n";
    print "  <input type='hidden' name='page' value='$page'>\n";
    print "  <input type='hidden' name='odbor_zpravy_o_cinnosti_id' value='$odbor_zpravy_o_cinnosti_id'>\n";
    print "  <input type='hidden' name='zpravy_o_cinnosti' value='Odeslat'>\n";
    print "  <tr>\n";
    print "    <td><textarea id='editorcontents' name='editorcontents'>$editorcontents</textarea></td>\n";
    print "  </tr>\n";
    print "  </form>\n";
    print "</table>\n";
    
    session_start();
    $_SESSION['IsAuthorized'] = true;
    
    print "<script type='text/javascript'>\n";
    print "  var editor;\n";
    print "  function createEditor() {\n";
    print "    editor = CKEDITOR.replace('editorcontents',\n";
    print "             {       \n";
    print "               skin : '$skin',\n";
    print "               height : 600,\n";
    print "               language : '$lang',\n";
    print "               filebrowserBrowseUrl : '/ckfinder/ckfinder.html?currentFolder=/$odbor_typ/',\n";
    print "               filebrowserImageBrowseUrl : '/ckfinder/ckfinder.html?type=Images&currentFolder=/$odbor_typ/',\n";
    print "               filebrowserFlashBrowseUrl : '/ckfinder/ckfinder.html?type=Flash&currentFolder=/$odbor_typ/',\n";
    print "               filebrowserUploadUrl : '/ckfinder/core/connector/php/connector.php?command=QuickUpload&type=Files&currentFolder=/$odbor_typ/',\n";
    print "               filebrowserImageUploadUrl : '/ckfinder/core/connector/php/connector.php?command=QuickUpload&type=Images&currentFolder=/$odbor_typ/',\n";
    print "               filebrowserFlashUploadUrl : '/ckfinder/core/connector/php/connector.php?command=QuickUpload&type=Flash&currentFolder=/$odbor_typ/'\n";
    print "             });\n";
    print "  }\n";
    print "  createEditor();\n";
    print "</script>\n";
  } else {
    print "<table>\n";
    print "  <tr>\n";
    print "    <td>$editorcontents</td>\n";
    print "  </tr>\n";
    print "</table>\n";
  }
} else {
  print "<table>\n";
  print "  <tr>\n";
  print "    <td>$editorcontents</td>\n";
  print "  </tr>\n";
  print "</table>\n";
}
?>