Lines Matching refs:query
302 $query = "UPDATE calendars SET calendarcolor = ? ".
304 $res = $sqlite->query($query, $color, $calid);
350 $query = "UPDATE calendars SET displayname = ?, description = ? WHERE id = ?";
351 $res = $sqlite->query($query, $name, $description, $calid);
370 $query = "UPDATE calendars SET displayname = ? WHERE id = ?";
371 $res = $sqlite->query($query, $calid, $name);
393 $query = "UPDATE calendars SET description = ? WHERE id = ?";
394 $res = $sqlite->query($query, $calid, $description);
416 $query = "UPDATE calendars SET timezone = ? WHERE id = ?";
417 $res = $sqlite->query($query, $calid, $timezone);
450 $sqlite->query("BEGIN TRANSACTION");
452 $query = "DELETE FROM calendarsettings WHERE userid = ?";
453 $sqlite->query($query, $userid);
457 $query = "INSERT INTO calendarsettings (userid, key, value) VALUES (?, ?, ?)";
458 $res = $sqlite->query($query, $userid, $key, $value);
462 $sqlite->query("COMMIT TRANSACTION");
506 $query = "SELECT key, value FROM calendarsettings WHERE userid = ?";
507 $res = $sqlite->query($query, $userid);
539 $query = "SELECT calid FROM pagetocalendarmapping WHERE page = ?";
540 $res = $sqlite->query($query, $id);
563 $query = "SELECT calid, page FROM pagetocalendarmapping";
564 $res = $sqlite->query($query);
647 …$query = "INSERT INTO calendars (principaluri, displayname, uri, description, components, transpar…
649 …$res = $sqlite->query($query, $values[0], $values[1], $values[2], $values[3], $values[4], $values[…
654 $query = "SELECT id FROM calendars WHERE principaluri = ? AND displayname = ? AND ".
656 $res = $sqlite->query($query, $values[0], $values[1], $values[2], $values[3]);
662 $query = "INSERT INTO pagetocalendarmapping (page, calid) VALUES (?, ?)";
663 $res = $sqlite->query($query, $id, $row['id']);
689 …$query = "INSERT INTO calendarobjects (calendarid, uri, calendardata, lastmodified, etag, size, co…
690 $res = $sqlite->query($query,
724 …$query = "UPDATE calendarobjects SET calendardata = ?, lastmodified = ?, etag = ?, size = ?, compo…
725 $res = $sqlite->query($query,
863 …$query = "INSERT INTO calendarobjects (calendarid, uri, calendardata, lastmodified, componenttype,…
864 $res = $sqlite->query($query, $calid, $uri, $eventStr, $now->getTimestamp(), 'VEVENT',
890 …$query = "SELECT id, principaluri, calendarcolor, displayname, uri, description, components, trans…
891 $res = $sqlite->query($query, $calid);
907 $query = "SELECT disabled FROM calendars WHERE id = ?";
908 $res = $sqlite->query($query, $calid);
932 $query = "UPDATE calendars SET disabled = 1 WHERE id = ?";
933 $res = $sqlite->query($query, $calid);
954 $query = "UPDATE calendars SET disabled = 0 WHERE id = ?";
955 $res = $sqlite->query($query, $calid);
990 $query = "SELECT calendardata, componenttype, uid FROM calendarobjects WHERE calendarid = ?";
996 $query .= " AND lastoccurence > ".$sqlite->quote_string($startTs->getTimestamp());
1001 $query .= " AND firstoccurence < ".$sqlite->quote_string($endTs->getTimestamp());
1031 $res = $sqlite->query($query, $calid);
1166 … $query = "SELECT calendardata, calendarid, componenttype, uri FROM calendarobjects WHERE uid = ?";
1167 $res = $sqlite->query($query, $uid);
1185 …$query = "SELECT id, uri, lastmodified, etag, calendarid, size, componenttype FROM calendarobjects…
1186 $res = $sqlite->query($query, $calid);
1204 …$query = "SELECT id, uri, lastmodified, etag, calendarid, size, calendardata, componenttype FROM c…
1205 $res = $sqlite->query($query, $calid, $uri);
1224 …$query = "SELECT id, uri, lastmodified, etag, calendarid, size, calendardata, componenttype FROM c…
1226 $query .= implode(',', array_fill(0, count($uris), '?'));
1227 $query .= ')';
1230 $res = $sqlite->query($query, $vals);
1251 … $query = "SELECT calendardata, uid, componenttype, uri FROM calendarobjects WHERE calendarid = ?";
1252 $res = $sqlite->query($query, $calid);
1376 $query = "UPDATE calendarobjects SET calendardata = ?, lastmodified = ?, ".
1378 $res = $sqlite->query($query, $eventStr, $now->getTimestamp(), $dtStart->getTimestamp(),
1402 $query = "DELETE FROM calendarobjects WHERE calendarid = ? AND uri = ?";
1403 $res = $sqlite->query($query, $calid, $uri);
1438 $query = "DELETE FROM calendarobjects WHERE uid = ?";
1439 $res = $sqlite->query($query, $uid);
1511 … $query = "INSERT INTO calendarchanges (uri, synctoken, calendarid, operation) VALUES(?, ?, ?, ?)";
1512 $res = $sqlite->query($query, $uri, $currentToken, $calid, $operationCode);
1516 $query = "UPDATE calendars SET synctoken = ? WHERE id = ?";
1517 $res = $sqlite->query($query, $currentToken, $calid);
1585 $query = "SELECT url FROM calendartoprivateurlmapping WHERE calid = ?";
1586 $res = $sqlite->query($query, $calid);
1591 $query = "INSERT INTO calendartoprivateurlmapping (url, calid) VALUES(?, ?)";
1592 $res = $sqlite->query($query, $url, $calid);
1618 $query = "SELECT calid FROM calendartoprivateurlmapping WHERE url = ?";
1619 $res = $sqlite->query($query, $url);
1816 $query = "SELECT uri, calendardata FROM calendarobjects WHERE calendarid = ?";
1820 $query = "SELECT uri FROM calendarobjects WHERE calendarid = ?";
1829 $query .= " AND componenttype = ?";
1835 $query .= " AND lastoccurence > ?";
1840 $query .= " AND firstoccurence < ?";
1844 $res = $sqlite->query($query, $values);
1921 …$query = "SELECT uri, operation FROM calendarchanges WHERE synctoken >= ? AND synctoken < ? AND ca…
1922 if ($limit > 0) $query .= " LIMIT " . (int)$limit;
1925 $res = $sqlite->query($query, $syncToken, $currentToken, $calid);
1959 $query = "SELECT uri FROM calendarobjects WHERE calendarid = ?";
1960 $res = $sqlite->query($query);