- q(
- "INSERT INTO `gcontact` (`name`, `nick`, `addr` , `network`, `url`, `nurl`, `photo`, `created`, `updated`, `location`, `about`, `hide`, `generation`)
- VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', %d, %d)",
- DBA::escape($contact["name"]),
- DBA::escape($contact["nick"]),
- DBA::escape($contact["addr"]),
- DBA::escape($contact["network"]),
- DBA::escape($contact["url"]),
- DBA::escape(Strings::normaliseLink($contact["url"])),
- DBA::escape($contact["photo"]),
- DBA::escape(DateTimeFormat::utcNow()),
- DBA::escape(DateTimeFormat::utcNow()),
- DBA::escape($contact["location"]),
- DBA::escape($contact["about"]),
- intval($contact["hide"]),
- intval($contact["generation"])
- );
-
- $condition = ['nurl' => Strings::normaliseLink($contact["url"])];
+ $fields = ['name' => $contact['name'], 'nick' => $contact['nick'] ?? '', 'addr' => $contact['addr'] ?? '', 'network' => $contact['network'],
+ 'url' => $contact['url'], 'nurl' => Strings::normaliseLink($contact['url']), 'photo' => $contact['photo'],
+ 'created' => DateTimeFormat::utcNow(), 'updated' => DateTimeFormat::utcNow(), 'location' => $contact['location'],
+ 'about' => $contact['about'], 'hide' => $contact['hide'], 'generation' => $contact['generation']];
+
+ DBA::insert('gcontact', $fields);
+
+ $condition = ['nurl' => Strings::normaliseLink($contact['url'])];