<?php session_start(); include_once '../classes/TestProjektSmarty.class_subdir.php'; require_once("../config.inc.php"); $templatename = substr(basename($_SERVER['PHP_SELF']),0,-3)."html"; $smarty = new SmartyAdmin(); require_once("../language/german.inc.php"); require_once("../config/func_cryption.php"); if (isset($_GET['action'])) { $action = $_GET['action']; } else { $action = ''; } if ($action == '') { $query1 = "SELECT pid, beschreibung, wert FROM dvm_parameter ORDER BY sort ASC"; $result1 = $db->query($query1) or die("Cannot execute query1"); $result_ct = $db->query("SELECT count(*) Anz FROM dvm_tanpool where verw_dat = '0000-00-00 00:00:00'"); $row_ct = $result_ct->fetch_array(); $smarty->assign('parameter_anzahltan', "$row_ct[Anz]"); while ($row1 = $result1->fetch_array()) { # Passwort für die Praxisstellen wird verschlüsselt gespeichert if(!isset($zaehler) or $zaehler == 1){ $zaehler = 0; }else{ $zaehler = 1; } $row1['zaehler'] = $zaehler; $table_data1[] = $row1; } $smarty->assign('table_data1', $table_data1); } if($action == 'save'){ $query2 = "SELECT pid FROM dvm_parameter ORDER BY pid ASC"; $result2 = $db->query( $query2) or die ("Cannot execute query2"); while ($row2 = $result2->fetch_array()){ $pid = $row2['pid']; $pid_value = $_POST[$pid]; $sql1 = $db->query( "UPDATE dvm_parameter SET wert = '$pid_value' WHERE pid = $pid " ); } if(!$sql1){ $error = TRUE; $error_reason .= "Fehler beim Update [dvm_parameter]<br>"; }else{ $error = FALSE; $smarty->assign('parameter_inserterr', "2"); echo "<meta http-equiv=\"refresh\" content=\"2; URL=".$_SERVER['PHP_SELF'] ."?\">"; } if($error){ $smarty->assign('parameter_inserterr', "1"); $smarty->assign('parameter_reason', "$error_reason"); // Kein Mailversand } // Ende IF : Insert hat geklappt } $smarty->assign('action', "$action"); $smarty->display("$template/admin/$templatename"); ?>