- q("UPDATE `contact` SET `url` = '%s', `nurl` = '%s', `addr` = '%s', `alias` = '%s', `batch` = '%s', `notify` = '%s', `poll` = '%s', `poco` = '%s', `name` = '%s', `nick` = '%s' WHERE `id` = %d",
+ // make sure to not overwrite existing values with blank entries
+ foreach ($ret AS $key => $val) {
+ if (isset($r[0][$key]) AND ($r[0][$key] != "") AND ($val == ""))
+ $ret[$key] = $r[0][$key];
+
+ if (isset($r[0][$key]) AND ($ret[$key] != $r[0][$key]))
+ $update = true;
+ }
+
+ if (!$update)
+ return true;
+
+ q("UPDATE `contact` SET `url` = '%s', `nurl` = '%s', `addr` = '%s', `alias` = '%s', `batch` = '%s', `notify` = '%s', `poll` = '%s', `poco` = '%s' WHERE `id` = %d",