<?php
  session_start();
  include("connect.php");


  function newid(){
    $sql=mysql_query("SELECT MAX(id) as maxid FROM db_users_ete1");
    $query=mysql_fetch_assoc($sql);
    return $query[maxid]+1;
  }


    // Přidání nového uživatele
    if($_GET[action]== add){
       // CHECK THIS TRANS
        //$user = $_POST[user];
        //$pass = $_POST[pass];
        //$level = $_POST[level];
        //echo "$user";
        //echo "$pass";
        //echo "$level";
         $query="INSERT INTO db_users_ete1
                  VALUES (
                          '.newid(db_users_ete1).',
                          '$_POST[user]',
                          '$_POST[pass]',
                          '$_POST[level]'
                        )";
          $result=pg_query($query);
    }

    // Úprava stávajícího uživatele
    if($_GET[action]==edit){
      // CHECK THIS TRANS
        //$user = $_POST[user];
        //$pass = $_POST[pass];
        //$level = $_POST[level];
        //echo "$user";
        //echo "$pass";
        //echo "$level";
      pg_query("UPDATE db_users_ete1
                SET name = '$_POST[user]',
                    pass = '$_POST[pass]',
                    level = '$_POST[level]'
                WHERE id = '$_GET[id]'
                ");
    }

    // Smazani uživatele
    if($_GET[action]==del){
      pg_query("DELETE FROM db_users_ete1
                WHERE id = '$_GET[id]'
              ");
    }

   //editace_sdeleni
    if($_GET[action]==sdeleni){
      pg_query("UPDATE db_sdeleni_edu
                SET sdeleni ='$_POST[sdeleni]'
                WHERE id = 1
              ");
    }
  // free memory
     pg_free_result($result);

     // close connection
     pg_close($dbh);
  header ("Location: ".$_SERVER["HTTP_REFERER"]);
  exit;







    ?>