?>
<?php
//see if there are any records in the db
//order by timestamp desc
//if there are, get the most recent record's timestamp and set it as sinceid as option in history query
$destinationsQuery = mysql_query("select foursquarecheckinid from destinations where userid=" . $_SESSION['currentUserID'] . " order by foursquarecheckinid desc");
if (mysql_num_rows($destinationsQuery) == 0) {
$sinceID = "";
} else {
$resultRow = mysql_fetch_object($destinationsQuery);
$sinceID = $resultRow->foursquarecheckinid;
}
//get recent checkins
//$venues = $foursquareObj->get_history();
$venues = $foursquareObj->get_history(array("sinceid" => $sinceID))->checkins;
//a cleaner approach: filter out 'shout-only' checkins from $venues so they don't show up in the total number of venues
$numVenues = sizeof($venues);
//echo("Number of new stops: ".$numVenues."<br />");
//if using a sinceid, ordering will be oldest to newest. if not, ordering will be newest to oldest
if ($sinceID != "") {
$venues = array_reverse($venues);
}
//insert data from foursquare into database
for ($i = 0; $i < $numVenues; $i++) {
//need to check each venue to make sure it is a legal venue
$currentVenue = $venues[$i];
if (isset($currentVenue->venue->id)) {
$currentVID = $currentVenue->venue->id;
$currentVenueCheckinTime = $currentVenue->created;
$currentVenueLongURL = "http://foursquare.com/venue/" . $currentVID;
