// Load images
$jsonString = file_get_contents($url);
$jsonArr = json_decode($jsonString, true);
$images = $jsonArr['data'];
$cartodb = new CartoDBClient($cartodb_config);
if (!$cartodb->authorized) {
error_log("uauth");
print 'There is a problem authenticating, check the key and secret.';
exit;
}
// Find max timestamp
$response = $cartodb->runSql("SELECT MAX(timestamp) FROM instagram");
$max = array_pop($response['return']['rows'])->max;
foreach ($images as $image) {
if ($image['created_time'] > $max && isset($image['location'])) {
$location = $image['location'];
$latitude = $location['latitude'];
$longitude = $location['longitude'];
$place_name = isset($location['name']) ? $location['name'] : '';
$caption = isset($image['caption']['text']) ? $image['caption']['text'] : '';
$image_thumb = $image['images']['thumbnail']['url'];
$image_low = $image['images']['low_resolution']['url'];
$image_standard = $image['images']['standard_resolution']['url'];
if (isset($image['videos'])) {
$video_low = $image['videos']['low_resolution']['url'];
$video_standard = $image['videos']['standard_resolution']['url'];
}
$data = array('instagram_id' => "'" . $image['id'] . "'", 'the_geom' => "'SRID=4326;POINT(" . $longitude . " " . $latitude . ")'", 'type' => "'" . $image['type'] . "'", 'link' => "'" . $image['link'] . "'", 'latitude' => $latitude, 'longitude' => $longitude, 'place_id' => isset($location['id']) ? $location['id'] : 0, 'place_name' => "'" . $place_name . "'", 'tags' => "'" . implode(",", $image['tags']) . "'", 'image_thumb' => "'" . $image_thumb . "'", 'image_low' => "'" . $image_low . "'", 'image_standard' => "'" . $image_standard . "'", 'video_low' => isset($video_low) ? "'" . $video_low . "'" : "''", 'video_standard' => isset($video_standard) ? "'" . $video_standard . "'" : "''", 'created_time' => "'" . date("Y-m-d H:i:s", $image['created_time']) . "'", 'timestamp' => $image['created_time'], 'caption' => "'" . $caption . "'", 'username' => "'" . $image['user']['username'] . "'", 'user_id' => $image['user']['id'], 'json' => "'" . json_encode($image) . "'");
$response = $cartodb->insertRow('instagram', $data);
}
}
$response = $jsonArr['response'];
if (isset($response['errors'])) {
$error = $response['errors']['error'];
error_log($error['code'] . $error['text']);
print $error['description'];
exit;
}
$response = $jsonArr['response']['feedMessageResponse'];
if ($response['count'] == 1) {
$messages = array($response['messages']['message']);
} else {
$messages = $response['messages']['message'];
}
$cartodb = new CartoDBClient($cartodb_config);
if (!$cartodb->authorized) {
error_log("uauth");
print 'There is a problem authenticating, check the key and secret.';
exit;
}
// Find max timestamp
$response = $cartodb->runSql("SELECT MAX(timestamp) FROM spot");
$max = array_pop($response['return']['rows'])->max;
foreach ($messages as $message) {
if ($message['unixTime'] > $max) {
// Add if newer
$data = array('feed_id' => "'" . $feedId . "'", 'spot_id' => $message['id'], 'the_geom' => "'SRID=4326;POINT(" . $message['longitude'] . " " . $message['latitude'] . ")'", 'messenger_id' => "'" . $message['messengerId'] . "'", 'messenger_name' => "'" . $message['messengerName'] . "'", 'timestamp' => $message['unixTime'], 'message_type' => "'" . $message['messageType'] . "'", 'latitude' => $message['latitude'], 'longitude' => $message['longitude'], 'model_id' => "'" . $message['modelId'] . "'", 'show_custom_msg' => "'" . $message['showCustomMsg'] . "'", 'datetime' => "'" . date("Y-m-d H:i:s", $message['unixTime']) . "'", 'battery_state' => "'" . $message['batteryState'] . "'", 'hidden' => "'" . $message['hidden'] . "'", 'message_content' => "'" . (isset($message['messageContent']) ? $message['messageContent'] : '') . "'");
$response = $cartodb->insertRow('spot', $data);
}
}
require 'kartverket2cartodb.php';
require 'yr2cartodb.php';
