function api_privatesquare_venues_checkin()
{
$venue_id = post_str("venue_id");
$status_id = post_int32("status_id");
if (!$venue_id) {
api_output_error(999, "Missing venue ID");
}
if (!isset($status_id)) {
api_output_error(999, "Missing status ID");
}
$fsq_user = foursquare_users_get_by_user_id($GLOBALS['cfg']['user']['id']);
$checkin = array('user_id' => $GLOBALS['cfg']['user']['id'], 'venue_id' => $venue_id, 'status_id' => $status_id);
# where am I?
$venue = foursquare_venues_get_by_venue_id($venue_id);
if (!$venue) {
$rsp = foursquare_venues_archive_venue($venue_id);
if ($rsp['ok']) {
$venue = $rsp['venue'];
}
}
if ($venue) {
$checkin['locality'] = $venue['locality'];
$checkin['latitude'] = $venue['latitude'];
$checkin['longitude'] = $venue['longitude'];
}
# check to see if we're checking in to 4sq too
if ($broadcast = post_str("broadcast")) {
$method = 'checkins/add';
$args = array('oauth_token' => $fsq_user['oauth_token'], 'venueId' => $venue_id, 'broadcast' => $broadcast);
$more = array('method' => 'POST');
$rsp = foursquare_api_call($method, $args, $more);
if ($rsp['ok']) {
$checkin['checkin_id'] = $rsp['rsp']['checkin']['id'];
}
# on error, then what?
}
if ($GLOBALS['cfg']['enable_feature_weather_tracking']) {
loadlib("weather_google");
$rsp = weather_google_conditions($checkin['latitude'], $checkin['longitude']);
if ($rsp['ok']) {
$conditions = $rsp['conditions'];
$conditions['source'] = $rsp['source'];
$checkin['weather'] = json_encode($conditions);
}
}
$rsp = privatesquare_checkins_create($checkin);
if (!$rsp['ok']) {
api_output_error(999, "Check in failed");
}
$out = array('checkin' => $rsp['checkin']);
api_output_ok($out);
}
function _set_latlon($row, $more = array())
{
$user = users_get_by_id($row['user_id']);
$venue_id = $row['venue_id'];
$venue = foursquare_venues_get_by_venue_id($venue_id);
if (!$venue) {
$venue = foursquare_venues_archive_venue($venue_id);
}
if (!$venue) {
echo "can not sort out venue data for '{$venue_id}'\n";
return;
}
$lat = $venue['latitude'];
$lon = $venue['longitude'];
$update = array('latitude' => AddSlashes($lat), 'longitude' => AddSlashes($lon));
$enc_id = $row['id'];
$where = "id='{$enc_id}'";
$cluster_id = $user['cluster_id'];
$rsp = db_update_users($cluster_id, 'PrivatesquareCheckins', $update, $where);
echo "{$venue_id} : {$lat}, {$lon} {$where}: {$rsp['ok']}\n";
}
function sync_user($fsq_user, $more = array())
{
$user = users_get_by_id($fsq_user['user_id']);
if (!$user['sync_foursquare']) {
echo "'{$user['username']}' has not opted in to foursquare syncing, skipping...\n";
return;
}
echo "sync checkins for '{$user['username']}' : {$user['sync_foursquare']}\n";
$status_map = privatesquare_checkins_status_map("string keys");
$method = 'users/self/checkins';
$count = null;
$offset = 0;
$limit = 250;
while (!isset($count) || $offset < $count) {
$args = array('oauth_token' => $fsq_user['oauth_token'], 'limit' => $limit, 'offset' => $offset);
# only sync updates since the user signed up for privatesquare
# > 1 (or "2") would mean pull in all a users' checkins.
# see also: account_foursquare_sync.php
if ($user['sync_foursquare'] == 1) {
$args['afterTimestamp'] = $user['created'];
}
$rsp = foursquare_api_call($method, $args);
if (!isset($count)) {
$count = $rsp['rsp']['checkins']['count'];
}
$count_items = count($rsp['rsp']['checkins']['items']);
# As of 20120218 if you pass a date filter to the API it
# still returns the count for the total number of checkins
# without the date filter. I love that... (20120218/straup)
if (!$count_items) {
break;
}
foreach ($rsp['rsp']['checkins']['items'] as $fsq_checkin) {
if (privatesquare_checkins_get_by_foursquare_id($user, $fsq_checkin['id'])) {
continue;
}
$checkin = array('user_id' => $user['id'], 'checkin_id' => $fsq_checkin['id'], 'venue_id' => $fsq_checkin['venue']['id'], 'created' => $fsq_checkin['createdAt'], 'status_id' => $status_map['i am here'], 'latitude' => $fsq_checkin['location']['lat'], 'longitude' => $fsq_checkin['location']['lng']);
$venue = foursquare_venues_get_by_venue_id($checkin['venue_id']);
if (!$venue) {
$rsp = foursquare_venues_archive_venue($checkin['venue_id']);
if (!$rsp['ok']) {
echo "failed to archive venue '{$checkin['venue_id']}' : {$rsp['error']}\n";
echo "skipping...\n";
continue;
}
$venue = $rsp['venue'];
}
if ($venue) {
$checkin['locality'] = $venue['locality'];
$checkin['latitude'] = $venue['latitude'];
$checkin['longitude'] = $venue['longitude'];
}
$rsp = privatesquare_checkins_create($checkin);
if (!$rsp['ok']) {
echo "failed to archive checkin: {$rsp['error']}\n";
continue;
}
echo "archived 4sq checkin {$checkin['checkin_id']} with privatesquare ID: {$rsp['checkin']['id']}\n";
}
# do stuff here...
$offset += $limit;
}
}
