- $r = q(
- "SELECT * FROM `glink` WHERE `cid` = %d AND `uid` = %d AND `gcid` = %d AND `zcid` = %d LIMIT 1",
- intval($cid),
- intval($uid),
- intval($gcid),
- intval($zcid)
- );
-
- if (!DBA::isResult($r)) {
- q(
- "INSERT INTO `glink` (`cid`, `uid`, `gcid`, `zcid`, `updated`) VALUES (%d, %d, %d, %d, '%s') ",
- intval($cid),
- intval($uid),
- intval($gcid),
- intval($zcid),
- DBA::escape(DateTimeFormat::utcNow())
- );
- } else {
- q(
- "UPDATE `glink` SET `updated` = '%s' WHERE `cid` = %d AND `uid` = %d AND `gcid` = %d AND `zcid` = %d",
- DBA::escape(DateTimeFormat::utcNow()),
- intval($cid),
- intval($uid),
- intval($gcid),
- intval($zcid)
- );
- }
+ $condition = ['cid' => $cid, 'uid' => $uid, 'gcid' => $gcid, 'zcid' => $zcid];
+ DBA::update('glink', ['updated' => DateTimeFormat::utcNow()], $condition, true);