function flickr_contacts_get_contact($user_id, $contact_id) { $user = users_get_by_id($user_id); $cluster_id = $user['cluster_id']; $enc_user = AddSlashes($user_id); $enc_contact = AddSlashes($contact_id); $sql = "SELECT * FROM FlickrContacts WHERE user_id='{$enc_user}' AND contact_id='{$enc_contact}'"; $rsp = db_fetch_users($cluster_id, $sql); return db_single($rsp); }
function flickr_faves_count_for_user(&$user, $more = array()) { $defaults = array('viewer_id' => 0); $more = array_merge($defaults, $more); $cluster_id = $user['cluster_id']; $enc_user = AddSlashes($user['id']); # TO DO: perms $sql = "SELECT COUNT(photo_id) AS cnt FROM FlickrFaves WHERE user_id='{$enc_user}' {$extra}"; $row = db_single(db_fetch_users($cluster_id, $sql)); return $row['cnt']; }
function flickr_push_photos_for_subscription(&$sub, $older_than = null) { $user = users_get_by_id($sub['user_id']); $cluster = $user['cluster_id']; $enc_sub = AddSlashes($sub['id']); # TO DO: indexes $sql = "SELECT * FROM FlickrPushPhotos WHERE subscription_id='{$enc_sub}'"; if ($older_than) { $enc_older = AddSlashes($older_than); $sql .= " AND created > '{$enc_older}'"; } $sql .= " ORDER BY created DESC"; $rsp = db_fetch_users($cluster, $sql); $photos = array(); foreach ($rsp['rows'] as $row) { $photo = json_decode($row['photo_data'], 'as hash'); $photo['created'] = $row['created']; $photo['display_url'] = str_replace("_s.jpg", ".jpg", $photo['thumb_url']); $photos[] = $photo; } $rsp['rows'] = $photos; return $rsp; }
function flickr_push_subscriptions_for_user(&$user) { $cache_key = "flickr_push_subscriptions_user_{$user['id']}"; $cache = cache_get($cache_key); if ($cache['ok']) { return $cache['data']; } $cluster_id = $user['cluster_id']; $enc_user = AddSlashes($user['id']); $sql = "SELECT * FROM FlickrPushSubscriptions WHERE user_id='{$enc_user}'"; $rsp = db_fetch_users($cluster_id, $sql); if ($rsp['ok']) { cache_set($cache_key, $rsp, "cache locally"); } return $rsp; }
function sheets_counts_for_user(&$user, $viewer_id = 0) { $cache_key = "sheets_counts_for_user_{$user['id']}"; if ($user['id'] != $viewer_id) { $cache_key .= "_public"; } $cache = cache_get($cache_key); if ($cache['ok']) { return $cache['data']; } # $enc_id = AddSlashes($user['id']); if ($viewer_id == $user['id']) { $sql = "SELECT COUNT(id) AS count_sheets, SUM(count_dots) AS count_dots FROM Sheets WHERE user_id='{$enc_id}'"; } else { $sql = "SELECT COUNT(id) AS count_sheets, SUM(count_dots_public) AS count_dots FROM Sheets WHERE user_id='{$enc_id}' AND count_dots_public > 0"; } # $row = db_single(db_fetch_users($user['cluster_id'], $sql)); if ($row) { cache_set($cache_key, $row, 'cache locally'); } return $row; }
function dots_count_dots_for_sheet(&$sheet) { $cache_key = "dots_count_for_sheet_{$sheet['id']}"; $cache = cache_get($cache_key); if ($cache['ok']) { return $cache['data']; } # $user = users_get_by_id($sheet['user_id']); $enc_id = AddSlashes($sheet['id']); $sql = "SELECT COUNT(id) AS count_total FROM Dots WHERE sheet_id='{$enc_id}'"; $rsp = db_fetch_users($user['cluster_id'], $sql); $row = db_single($rsp); $count_total = $row['count_total']; $sql = "SELECT COUNT(id) AS count_public FROM Dots WHERE sheet_id='{$enc_id}'"; $sql = _dots_where_public_sql($sql); $rsp = db_fetch_users($user['cluster_id'], $sql); $row = db_single($rsp); $count_public = $row['count_public']; $rsp = array('total' => $count_total, 'public' => $count_public); cache_set($cache_key, $rsp, 'cache locally'); return $rsp; }
function privatesquare_checkins_get_by_foursquare_id(&$user, $id) { $cluster_id = $user['cluster_id']; $enc_user = AddSlashes($user['id']); $enc_id = AddSlashes($id); $sql = "SELECT * FROM PrivatesquareCheckins WHERE user_id='{$enc_user}' AND checkin_id='{$enc_id}'"; return db_single(db_fetch_users($cluster_id, $sql)); }
function flickr_photos_archives_days_for_user(&$user, $year, $month, $more = array()) { $cluster_id = $user['cluster_id']; $enc_user = AddSlashes($user['id']); list($start, $end) = dates_utils_between($year, $month); $enc_start = AddSlashes($start); $enc_end = AddSlashes($end); $date_col = $more['context'] == 'posted' ? 'dateupload' : 'datetaken'; $sql = "SELECT DISTINCT(DATE_FORMAT({$date_col}, '%d')) AS day FROM FlickrPhotos WHERE user_id='{$enc_user}'"; $sql .= " AND `{$date_col}` BETWEEN '{$enc_start}' AND '{$enc_end}'"; $sql .= " ORDER BY `{$date_col}` ASC"; $rsp = db_fetch_users($cluster_id, $sql); $days = array(); if ($rsp['ok']) { foreach ($rsp['rows'] as $r) { $days[] = $r['day']; } } sort($days); return $days; }
function flickr_photos_get_bookends(&$photo, $more = array()) { $defaults = array('viewer_id' => 0); $more = array_merge($defaults, $more); $user = users_get_by_id($photo['user_id']); $cluster_id = $user['cluster_id']; $enc_id = AddSlashes($photo['id']); $enc_user = AddSlashes($photo['user_id']); if ($perms = flickr_photos_permissions_photos_where($user['id'], $more['viewer_id'])) { $str_perms = implode(",", $perms); $extra = " AND perms IN ({$str_perms})"; } # TO DO: INDEXES $sql = "SELECT * FROM FlickrPhotos WHERE user_id = '{$enc_user}' AND id < '{$enc_id}' {$extra} ORDER BY id DESC LIMIT 1"; $rsp = db_fetch_users($cluster_id, $sql); $before = $rsp['rows']; # TO DO: INDEXES $sql = "SELECT * FROM FlickrPhotos WHERE user_id='{$enc_user}' AND id > '{$enc_id}' {$extra} ORDER BY id ASC LIMIT 1"; $rsp = db_fetch_users($cluster_id, $sql); $after = $rsp['rows']; return array('ok' => 1, 'before' => $before, 'after' => $after); }