<?php
ini_set("display_errors", E_ALL);
error_reporting(E_ALL);
include_once "../lib/config.php";
include_once "../lib/FlickrHA.php";
include_once "../lib/FlickrPhotoHA.php";
include_once "../lib/FlickrDB.php";
$flickr = new FlickrHA($config->flickr->apiKey, $config->flickr->secret, $config->flickr->tokenKey, $config->flickr->tokenSecret);
$flickrDB = new FlickrDB($flickr, $config->db);
require_once '../lib/Mustache/Autoloader.php';
Mustache_Autoloader::register();
$engine = new Mustache_Engine();
function getImageRatio($width, $height)
{
$width = intval($width);
$height = intval($height);
if (!$width || !$height) {
return "3-2";
}
$ratio = $width / $height;
if ($ratio === 1 || $ratio > 1 && $ratio < 1.1 || $ratio < 1 && $ratio > 0.9) {
return "1-1";
}
if ($ratio > 1) {
$diff_3_2 = abs($ratio - 3 / 2);
$diff_4_3 = abs($ratio - 4 / 3);
$diff_16_9 = abs($ratio - 16 / 9);
if ($diff_4_3 < $diff_3_2 && $diff_4_3 < $diff_16_9) {
$diff = $diff_4_3 / (4 / 3);
$ret = "4-3";
public function savePhoto($setId, $photo, $originalSource, $xlSource)
{
$this->_connectDB();
//$this->deletePhoto($setId,$photo);
$sql = "INSERT INTO images (set_id,id,secret,server,farm,original_width,original_height,size_ratio, sizes,comments,original_source,xl_source,added) VALUES (";
$width = $photo->width;
$height = $photo->height;
$size_ratio = $height === 0 || $width === 0 ? 0 : $width / $height;
$sql .= $this->db->quote($setId);
$sql .= "," . $this->db->quote($photo->id);
$sql .= "," . $this->db->quote($photo->secret);
$sql .= "," . $this->db->quote($photo->server);
$sql .= "," . $this->db->quote($photo->farm);
$sql .= "," . $width;
$sql .= "," . $height;
$sql .= "," . $size_ratio;
$sql .= "," . $photo->sizes;
$sql .= "," . $this->db->quote($photo->comments);
$sql .= "," . $this->db->quote($originalSource);
$sql .= "," . $this->db->quote($xlSource);
$sql .= ", NOW()";
$sql .= ")";
//echo "d:".$sql;
$ret = $this->db->insert($sql);
//var_dump($ret);
if (!$ret) {
return FlickrDB::createErrorObject("error:" . $this->db->error . ",sql:" . $sql);
}
return $ret;
}
</head>
<body>
<?php
ini_set("display_errors", E_ALL);
error_reporting(E_ALL);
$apiKey = "e9c2d11b4b0c9861766632f00320b128";
$secret = "25e5fcd971be9bb9";
$tokenKey = "72157631808364528-6b6d2e85e9679674";
$tokenSecret = "27c1b928d9306c59";
include_once "../lib/config.php";
include_once "../lib/FlickrHA.php";
include_once "../lib/FlickrPhotoHA.php";
include_once "../lib/FlickrDB.php";
$flickr = new FlickrHA($config->flickr->apiKey, $config->flickr->secret, $config->flickr->tokenKey, $config->flickr->tokenSecret);
$flickrDB = new FlickrDB($flickr, $config->db);
$setName = isset($_REQUEST["setName"]) ? $_REQUEST["setName"] : false;
if (!$setName || !$config->sets[$setName]) {
die("no set");
}
echo "<p>Delete old...</p>";
$flickrDB->deleteSetPhotos($config->sets[$setName]->setId);
echo "<p>Getting images for set " . $setName . "...</p>";
#$setId = "72157663923690755";
$json = $flickr->getSetPhotos($config->sets[$setName]->setId);
$i = 0;
foreach ($json->photoset->photo as $photo) {
set_time_limit(20);
echo "<div>";
echo "<img src=\"" . FlickrPhotoHA::getUrl($photo, FlickrPhotoHA::SIZE_SMALL_240_SHORT) . "\" />";
$sizes = $flickr->getPhotoSize($photo);
