--- a/fhiiqm/ma_tel_ed.php Fri Dec 20 15:19:32 2013 +0100
+++ b/fhiiqm/ma_tel_ed.php Fri Jan 17 08:50:55 2014 +0100
@@ -292,7 +292,8 @@
if ($ma['email'])
{
if (strpos($ma['email'],"@") > 0) $ma['email'] = $ma['email']; else $ma['email'] = $ma['email'] . "@fhi-berlin.mpg.de";
- }
+ }
+ $aktiv = $ma['fhi'];
foreach ($ma as &$elem) if (!$elem) $elem = null; // NULL-Eintrag in Leerfelder
if ($pid) //UPDATE
{
@@ -307,7 +308,7 @@
aktiv = ?,
userid = ?
WHERE persknr = $pid");
- $stmt -> bind_param('ssssiis',$ma['name'],$ma['vname'],$ma['titel'],$ma['email'],$ma['abtm'], $ma['fhi'], $userid);
+ $stmt -> bind_param('ssssiis',$ma['name'],$ma['vname'],$ma['titel'],$ma['email'],$ma['abtm'], $aktiv, $userid);
// echo "UPDATE: ". var_dump($stmt);
$result = $stmt -> execute();
if ($stmt->error) echo "error UPDATE Mitarbeiter: " . $stmt->error . "<br><br>\n";
@@ -317,7 +318,7 @@
$sql = "SELECT MAX(persknr) FROM Mitarbeiter WHERE persknr < 9500";
$pid = $dbc -> querySingleItem($sql) + 1;
$stmt -> prepare ("INSERT INTO Mitarbeiter (persknr, nachname, vorname, titel,email,abt_tel,aktiv,userid) VALUES (?,?,?,?,?,?,?,?)");
- $stmt -> bind_param('issssiis',$pid,$ma['name'],$ma['vname'],$ma['titel'],$ma['email'],$ma['abt'][0], $ma['fhi'], $userid);
+ $stmt -> bind_param('issssiis',$pid,$ma['name'],$ma['vname'],$ma['titel'],$ma['email'],$ma['abt'][0], $aktiv, $userid);
$result = $stmt -> execute();
if ($stmt->error) echo "error INSERT Mitarbeiter: " . $stmt->error . "<br><br>\n";
$ma['abtm'] = $ma['abt'][0];