Ejemplo n.º 1
0
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;
}
Ejemplo n.º 2
0
<?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));