From: Joey Schulze <joey@infodrom.org>
Date: Tue, 23 Apr 2013 20:21:35 +0000 (+0000)
Subject: Only execute change query if something is changed
X-Git-Url: https://git.infodrom.org/?p=infodrom.org%2Fservice.infodrom.org;a=commitdiff_plain;h=c4c2c3d96ca8f5cb34243ec1443b0654eba48723

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
--- 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'])) {