"sys_edit = now()");
foreach ($mask['edit'] as $field => $info) {
- if ($info['required'] === true && empty($_POST[$field]))
+ if ($info['required'] === true && !strlen($_POST[$field]))
return array('error' => sprintf('Pflichtfeld %s nicht ausgefüllt', $info['name']),
'errormsg' => 'Pflichtfelder nicht ausgefüllt');
$update[] = sprintf("%s=%s", $field, format_decimal($_POST[$field]));
} elseif ($info['type'] == 'passwd') {
if (!empty($_POST[$field]))
- $update[] = sprintf("%s='%s'", $field, pg_escape_string(passwd($_SESSION['sys']['login'],$_POST[$field])));
+ $update[] = sprintf("%s='%s'", $field,
+ pg_escape_string(passwd(empty($_POST['login'])?$_SESSION['sys']['login']:$_POST['login'],
+ $_POST[$field])));
} else {
if (empty($_POST[$field]) && $info['null'] === true)
$update[] = sprintf("%s=NULL", $field);
function insert($mask)
{
+ if (array_key_exists('insert', $mask))
+ return $mask['insert']($mask);
+
$fields = array('sys_user','sys_edit');
$values = array("'".pg_escape_string($_SESSION['sys']['login'])."'", 'now()');
foreach ($mask['edit'] as $field => $info) {
- if ($info['required'] === true && empty($_POST[$field]))
+ if ($info['required'] === true && !strlen($_POST[$field]))
return array('error' => sprintf('Pflichtfeld %s nicht ausgefüllt', $info['name']),
'errormsg' => 'Pflichtfelder nicht ausgefüllt');
} elseif ($info['type'] == 'passwd') {
if (!empty($_POST[$field])) {
$fields[] = $field;
- $values[] = sprintf("'%s'", pg_escape_string(passwd($_SESSION['sys']['login'],$_POST[$field])));
+ $values[] = sprintf("'%s'", pg_escape_string(passwd(empty($_POST['login'])?$_SESSION['sys']['login']:$_POST['login'],
+ $_POST[$field])));
}
} else {
$fields[] = $field;
while (preg_match('/\{([^\}]*)\}/', $sql, $matches))
$sql = str_replace('{'.$matches[1].'}', $_POST[$matches[1]], $sql);
- return array('info' => query_db($sql));
-}
-
-function format_ajax($data)
-{
- header('Content-type: application/json; charset=UTF-8');
- echo json_encode($data);
- exit;
+ return array('info' => query_db($sql),
+ 'parameter' => $_POST);
}
if (empty($_POST['func']))