<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Web management</title>
<link rel="stylesheet" href="styles.css" type="text/css">
<?php include 'codes.php';?>
</head>
<body text="#000000" style="margin:0">
      <?php
$id = mysql_real_escape_string(stripslashes($_REQUEST['id']));
$category_id = mysql_real_escape_string(stripslashes($_REQUEST['category_id']));
$room_id = mysql_real_escape_string(stripslashes($_REQUEST['room_id']));	  
$name = mysql_real_escape_string(stripslashes($_REQUEST['name']));
$name_en = mysql_real_escape_string(stripslashes($_REQUEST['name_en']));
$name_de = mysql_real_escape_string(stripslashes($_REQUEST['name_de']));
$name_fr = mysql_real_escape_string(stripslashes($_REQUEST['name_fr']));
$name_it = mysql_real_escape_string(stripslashes($_REQUEST['name_it']));
$name_es = mysql_real_escape_string(stripslashes($_REQUEST['name_es']));
$name_ru = mysql_real_escape_string(stripslashes($_REQUEST['name_ru']));
$name_zh = mysql_real_escape_string(stripslashes($_REQUEST['name_zh']));
$publish = mysql_real_escape_string(stripslashes($_REQUEST['publish']));	  
$priority = mysql_real_escape_string(stripslashes($_REQUEST['priority']));	  

if  (isset($_POST['submit'])) {
	$sql="UPDATE specs SET category_id='$category_id', room_id='$room_id', name='$name', name_en='$name_en', name_de='$name_de', name_fr='$name_fr', name_it='$name_it', name_es='$name_es', name_ru='$name_ru', name_zh='$name_zh', publish='$publish', priority='$priority' WHERE id='$id'";
	$result = mysql_query($sql);	
?>

<meta http-equiv="refresh" content="0;URL=all-specs.php?roomid=<?php echo $room_id?>">
<?php
} else {	
			$result = mysql_query("SELECT * FROM specs WHERE id='$id'",$dbh);
			$myrow=mysql_fetch_array($result); 
			$id=$myrow['id'];
			$category_id=$myrow['category_id'];
			$room_id=$myrow['room_id'];
			$name=$myrow['name'];
			$name_en=$myrow['name_en'];
			$name_de=$myrow['name_de'];
			$name_fr=$myrow['name_fr'];
            $name_it=$myrow['name_it'];
            $name_es=$myrow['name_es'];
            $name_ru=$myrow['name_ru'];
			$name_zh=$myrow['name_zh'];
			$publish=$myrow['publish'];
			$priority=$myrow['priority'];

?>

<table width="980" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td><div><img src="img/frame-edit.png" width="180" height="37" alt=""></div>
<div class="frame">

<form name="forma" method="post" action="<?php echo htmlentities($_SERVER['PHP_SELF']); ?>" enctype="multipart/form-data">
  <input type="hidden" name="id" value="<?php echo $id ?>">
  <table width="100%" border="0" cellspacing="0" cellpadding="4" class="text">
          <tr>
            <td width="20">&nbsp;</td> 
            <td width="200">Κατηγορία 
              </td>
            <td> 
              <select name="category_id" class="forms">
                <?php
			$sql = "SELECT * FROM specscategories ORDER BY priority";
			$result = mysql_query($sql);
			while ($myrow=mysql_fetch_array($result)) {
				$catid=$myrow['id'];
				$category=$myrow['category'];
?>
                <?php
	if ($catid == $category_id ) {
?>
                <option value="<?php echo $catid ?>" selected> 
                <?php echo $category ?>
                <?php } else { ?>
                <option value="<?php echo $catid ?>"> 
                <?php echo $category ?>
                </option>
                <?php 
				}
				}
?>
              </select>
            </td>
          </tr>
          <tr>
            <td>&nbsp;</td>
            <td>Καταχώρηση</td>
            <td>
              <select name="room_id" class="forms">
                <?php
			$sql = "SELECT * FROM rooms ORDER BY priority";
			$result = mysql_query($sql);
			while ($myrow=mysql_fetch_array($result)) {
				$roomid=$myrow['id'];
				$room=$myrow['name'];
?>
                <?php
	if ($roomid == $room_id ) {
?>
                <option value="<?php echo $roomid ?>" selected> 
                <?php echo $room ?>
                <?php } else { ?>
                <option value="<?php echo $roomid ?>"> 
                <?php echo $room ?>
                </option>
                <?php 
				}
				}
?>
              </select>
            </td>
          </tr>
          <?php if ($lang1==1) { ?>
    <tr>
      <td width="20"><img src="img/lang1.png" width="16" height="16" alt=""></td> 
      <td width="200">Κείμενο 
        </td>
      <td><textarea name="name" rows="6" class="mceEditor"><?php echo $name ?></textarea>
        </td>
    </tr>
    <?php } ?>
    <?php if ($lang2==1) { ?>
    <tr>
      <td><img src="img/lang2.png" width="16" height="16" alt=""></td> 
      <td>Κείμενο </td>
      <td><textarea name="name_en" rows="6" class="mceEditor"><?php echo $name_en ?></textarea>
        </td>
      </tr>
      <?php } ?>
    <?php if ($lang3==1) { ?>
    <tr>
      <td><img src="img/lang3.png" width="16" height="16" alt=""></td>
      <td>Κείμενο </td>
      <td><textarea name="name_de" rows="6" class="mceEditor"><?php echo $name_de ?></textarea></td>
    </tr>
      <?php } ?>
    <?php if ($lang4==1) { ?>
    <tr>
      <td><img src="img/lang4.png" width="16" height="16" alt=""></td>
      <td>Κείμενο </td>
      <td><textarea name="name_fr" rows="6" class="mceEditor"><?php echo $name_fr ?></textarea></td>
    </tr>
      <?php } ?>
    <?php if ($lang5==1) { ?>
    <tr>
      <td><img src="img/lang5.png" width="16" height="16" alt=""></td>
      <td>Κείμενο </td>
      <td><textarea name="name_it" rows="6" class="mceEditor"><?php echo $name_it ?></textarea></td>
    </tr>
      <?php } ?>
    <?php if ($lang6==1) { ?>
    <tr>
      <td><img src="img/lang6.png" width="16" height="16" alt=""></td>
      <td>Κείμενο </td>
      <td><textarea name="name_es" rows="6" class="mceEditor"><?php echo $name_es ?></textarea></td>
    </tr>
      <?php } ?>
    <?php if ($lang7==1) { ?>
    <tr>
      <td><img src="img/lang7.png" width="16" height="16" alt=""></td>
      <td>Κείμενο </td>
      <td><textarea name="name_ru" rows="6" class="mceEditor"><?php echo $name_ru ?></textarea></td>
    </tr>
      <?php } ?>
      <?php if ($lang8==1) { ?>
    <tr>
      <td><img src="img/lang8.png" width="16" height="16" alt=""></td>
      <td>Κείμενο </td>
      <td><textarea name="name_zh" rows="6" class="mceEditor"><?php echo $name_zh ?></textarea></td>
    </tr>
      <?php } ?>
          <tr>
            <td>&nbsp;</td>
            <td>Δημοσίευση στο site?</td>
            <td> 
              <select name="publish" class="forms">
          <?php if ($publish==yes) { ?>
          <option value="yes" selected>yes</option>
          <option value="no">no</option>
          <?php }else{?> 
          <option value="no" selected>no</option>
          <option value="yes">yes</option>
          <?php } ?>
</select>
              </td>
          </tr>
          <tr>
            <td>&nbsp;</td>
            <td>Αριθμός προτεραιότητας</td>
            <td>
              <input type="text" name="priority" size="20" maxlength="11" value="<?php echo $priority ?>" class="forms">
            </td>
          </tr>
        </table>

  <div align="center" style="padding:5px">
   <input type="submit" name="submit" value="Καταχώρηση" class="button">
        <input type="reset" name="reset" value="Επαναφορά" class="button">  </div>
</form>  
</div>
<div align="right"><a href="all-specs.php?roomid=<?php echo $room_id?>" class="links">μεταφορά στην Λίστα</a></div></td>
  </tr>
</table><?php include 'menudown.php';?>
<?php } ?>
</body>
</html>
