modify_class_write2db.php

<?php
   require_once 'include/head.php';

   // delay normaly short (given from config)
   // but if there is a special message, the message should be read, so put the delay few seconds higher
   $redirecting_delay = REDIRECTING_DELAY;

   // read mandatory values  
   $class_id = $_POST['class_id'];
   $config_class = $_POST['config_class'];
   $friendly_name = $_POST['friendly_name'];
   $nav_visible = $_POST['nav_visible'];
   $ordering = $_POST['ordering'];
   $out_file = $_POST['out_file'];
   $nagios_object = $_POST['nagios_object'];

   // process non-mandatory values
   if(isset($_POST['new_group'])){
      $new_group = $_POST['new_group'];
   }else{
      $new_group = "";
   }


// New group or selected user/admin Group
   if(isset($_POST['nav_privs'])){
      $nav_privs = $_POST['nav_privs'];
        if ( $new_group != "" ){
            $grouping = $new_group;
        }else{
            if ($nav_privs == "user"){
               if(isset($_POST['selectusergroup'])){
                  $grouping = $_POST['selectusergroup'];
               }else{
                  $grouping = "";
               }
            }elseif ($nav_privs == "admin"){
               if(isset($_POST['selectadmingroup'])){
                  $grouping = $_POST['selectadmingroup'];
               }else{
                  $grouping = "";
               }
            }
        }
   }else{
      // Should never come in this part...
      $nav_privs = "";
      $grouping  = "";
   }



   if(isset($_POST['nav_links'])){
      $nav_links = $_POST['nav_links'];
   }else{
      $nav_links = "";
   }

   if( ( $_POST['old_nav_privs'] != $nav_privs  OR $_POST['old_group'] != $grouping ) OR ($class_id == "new") ){
        $query = "SELECT MAX(ordering)+1 FROM ConfigClasses WHERE grouping = '$grouping' AND nav_privs = '$nav_privs'";
        $ordering = db_handler($query, "getOne", "Get MAX ordering of coresponding group");
        if ($ordering == NULL){
            $ordering = 0;
        }
   }

   // if class type select is disabled, no value will come, so get the one which is already set.
   // this happens only on modifying
   if(isset($_POST['class_type'])){
      $class_type = $_POST['class_type'];
   }else{
      $class_type = db_templates("lookup_ConfigClasses", "class_type", $class_id);
   }
    

    # Check mandatory fields
    $mandatory = array("config_class" => "Class name", "friendly_name" => "Friendly Name");
    $write2db = check_mandatory($mandatory,$_POST);




    if ($write2db == "yes"){

        if ($class_id == "new"){
            $title = "Add class";
            // Generate navigation link string
            $nav_links = 'Show::overview.php?class='.$config_class.';;Add::handle_item.php?item='.$config_class;
            // Make insert (adding class)
            $query = "INSERT INTO ConfigClasses (config_class, friendly_name, nav_visible, grouping, nav_links, nav_privs, class_type, ordering, out_file, nagios_object)
                        VALUES ('$config_class', '$friendly_name', '$nav_visible', '$grouping', '$nav_links', '$nav_privs', '$class_type', '$ordering', '$out_file', '$nagios_object')";
            $action = "created";
        }else{
            $title = "Modify class";
           // UPDATE ConfigAttrs
            $action = "modified";
           $query = "UPDATE ConfigClasses
            SET
                config_class = '$config_class',
                friendly_name = '$friendly_name',
                nav_visible = '$nav_visible',
                grouping = '$grouping',
                nav_links = '$nav_links',
                nav_privs = '$nav_privs',
                class_type = '$class_type',
                ordering = '$ordering',
                out_file = '$out_file',
                nagios_object = '$nagios_object'
            WHERE
                id_class = $class_id
            ";
       }
        
       $result = db_handler($query, "result", "$action Entry");
       if($result){
            echo "<h2>$title</h2>Successfully $action class &quot;$config_class&quot;";
            history_add($action, "Class", $config_class);

            // Go to next page without pressing the button
            echo '<meta http-equiv="refresh" content="'.$redirecting_delay.'; url='.$_SESSION["go_back_page_ok"].'">';

            NConf_DEBUG::set('<a href="'.$_SESSION["go_back_page_ok"].'"> [ this page ] </a>', 'INFO', "<br>redirecting to");

       }else{
          echo "<h2>Failed to $action attribute &quot;$config_class&quot;</h2>";
       }


    }else{

        if ( isset($_SESSION["cache"]["modify_class"]) ) unset($_SESSION["cache"]["modify_class"]);

        if ( NConf_DEBUG::status('ERROR') ) {
            echo NConf_DEBUG::show_debug('ERROR', TRUE, $_SESSION["go_back_page"]);

            // Cache
            foreach ($_POST as $key => $value) {
                if ($key == "selectusergroup"){
                    $_SESSION["cache"]["modify_class"][$class_id]["grouping"] = $value;
                }elseif ($key == "selectadmingroup"){
                    $_SESSION["cache"]["modify_class"][$class_id]["grouping"] = $value;
                }else{
                    $_SESSION["cache"]["modify_class"][$class_id][$key] = $value;
                }
            }
        }else{
            echo NConf_DEBUG::show_debug('INFO', TRUE);
        }
    }

   mysql_close($dbh);
   require_once 'include/foot.php';
?>