Only execute change query if something is changed

diff --git a/src/InfoCon/account/update.wml b/src/InfoCon/account/update.wml
index 849e62b..dc60852 100644 (file)
--- a/src/InfoCon/account/update.wml
+++ b/src/InfoCon/account/update.wml
@@ -22,14 +22,17 @@
     for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
       $row = pg_fetch_array ($sth, $nr);
 
-      $query = sprintf ("UPDATE account_names SET name='%s',display=%d,sys_user='%s',sys_edit=now() WHERE blz_kto = '%s'",
-                       $_POST['name_' . $row['blz_kto']],
-                       $_POST['display_' . $row['blz_kto']] ? 1 : 0,
-                       $_SERVER['REMOTE_USER'],
-                       $row['blz_kto']);
-
-      pg_exec ($dbh, $query);
-      $output = "Kontoinformationen aktualisiert.";      
+      if ($_POST['name_' . $row['blz_kto']] != $row['name'] ||
+         ($_POST['display_' . $row['blz_kto']] ? 1 : 0) != $row['display']) {
+       $query = sprintf ("UPDATE account_names SET name='%s',display=%d,sys_user='%s',sys_edit=now() WHERE blz_kto = '%s'",
+                         $_POST['name_' . $row['blz_kto']],
+                         $_POST['display_' . $row['blz_kto']] ? 1 : 0,
+                         $_SERVER['REMOTE_USER'],
+                         $row['blz_kto']);
+
+       pg_exec ($dbh, $query);
+       $output = "Kontoinformationen aktualisiert.";      
+      }
     }
   } elseif ($_POST[formtype] == "newaccount") {
     if (isset($_POST['blz']) && isset($_POST['kto']) && isset($_POST['name'])) {