function add_point(&$C, $article_id, $woe_id)
{
$added_article = add_article($C, $article_id);
if (!$added_article) {
die_with_code(400, "Article {$article_id} does not exist?\n");
}
$place = flickr_place_info($C, $woe_id);
$q = sprintf("INSERT INTO points\n SET article_id = %d, woe_id = %d,\n latitude = %f, longitude = %f,\n place_id = %s, place_path = %s,\n place_type = %s, place_name = %s,\n visitor_id = %s, remote_addr = %s", $article_id, $place->woeid, $place->latitude, $place->longitude, $C->dbh->quoteSmart($place->place_id), $C->dbh->quoteSmart($place->place_url), $C->dbh->quoteSmart($place->place_type), $C->dbh->quoteSmart($place->name), $C->dbh->quoteSmart($C->visitor_id), $C->dbh->quoteSmart($_SERVER['REMOTE_ADDR']));
$res = $C->dbh->query($q);
if (PEAR::isError($res)) {
// it already exists, so bail out
if ($res->getCode() == DB_ERROR_ALREADY_EXISTS) {
return false;
}
die_with_code(500, "{$res->message}\n{$q}\n");
}
$q = sprintf("UPDATE articles\n SET point_count = point_count + 1\n WHERE id = %d", $article_id);
$res = $C->dbh->query($q);
if (PEAR::isError($res)) {
die_with_code(500, "{$res->message}\n{$q}\n");
}
add_log($C, "Added point article:{$article_id}, woe:{$woe_id}");
return true;
}
<?php
ini_set('include_path', ini_get('include_path') . PATH_SEPARATOR . '../lib');
require_once 'init.php';
require_once 'data.php';
$C = new Context(DB_DSN, GUARDIAN_API_KEY, FLICKR_API_KEY);
header("Content-Type: text/plain; charset=UTF-8");
//print_r(guardian_article_search($C, 'Oakland'));
//print_r(flickr_place_find($C, 'Oakland'));
print_r(flickr_place_info($C, 3534));
