/**
 * @param int $calobj_id
 * @return bool
 */
function renderCalDavEntry_calobj_id($calobj_id)
{
    $calobj_id = IntVal($calobj_id);
    q("DELETE FROM %s%sjqcalendar WHERE `calendarobject_id` = %d", CALDAV_SQL_DB, CALDAV_SQL_PREFIX, $calobj_id);
    q("DELETE FROM %s%snotifications WHERE `calendarobject_id` = %d", CALDAV_SQL_DB, CALDAV_SQL_PREFIX, $calobj_id);
    $calobj = q("SELECT * FROM %s%scalendarobjects WHERE `id` = '%d'", CALDAV_SQL_DB, CALDAV_SQL_PREFIX, $calobj_id);
    if (count($calobj) == 0) {
        return false;
    }
    $calendars = q("SELECT * FROM %s%scalendars WHERE `id`=%d", CALDAV_SQL_DB, CALDAV_SQL_PREFIX, IntVal($calobj[0]["calendar_id"]));
    renderCalDavEntry_data($calendars[0], $calobj[0]);
    return true;
}
예제 #2
0
/**
 * @param string $uri
 * @return bool
 */
function renderCalDavEntry_uri($uri)
{
    q("DELETE FROM %s%sjqcalendar WHERE `ical_uri` = '%s'", CALDAV_SQL_DB, CALDAV_SQL_PREFIX, dbesc($uri));
    q("DELETE FROM %s%snotifications WHERE `ical_uri` = '%s'", CALDAV_SQL_DB, CALDAV_SQL_PREFIX, dbesc($uri));
    $calobj = q("SELECT * FROM %s%scalendarobjects WHERE `uri` = '%s'", CALDAV_SQL_DB, CALDAV_SQL_PREFIX, dbesc($uri));
    if (count($calobj) == 0) {
        return false;
    }
    $cal = new DBClass_friendica_calendarobjects($calobj[0]);
    $calendars = q("SELECT * FROM %s%scalendars WHERE `namespace`=%d AND `namespace_id`=%d", CALDAV_SQL_DB, CALDAV_SQL_PREFIX, IntVal($cal->namespace), IntVal($cal->namespace_id));
    $calendar = new DBClass_friendica_calendars($calendars[0]);
    renderCalDavEntry_data($calendar, $cal);
    return true;
}