<?php
/**
* by Nicolae Vartolomei <me@nvartolomei.com>
*
* Flickr crowler.
*/
set_time_limit(0);
ignore_user_abort(TRUE);
define("LIB_DIR", realpath(dirname(__FILE__) . "/../lib/"));
define("API_KEY", "nu va arat");
define("API_SECRET", "asta tot nu va arat");
require_once LIB_DIR . "/phpFlickr.php";
$flickr = new phpFlickr(API_KEY, API_SECRET);
$dbServer = mysql_connect("localhost", "nvartol_root", "nish asta nu va arat! :P");
mysql_select_db("nvartol_main", $dbServer);
/**
* Get id's
*/
$users = array();
$result = mysql_query("SELECT userId, flickrId FROM flickrUsers");
while($data = mysql_fetch_array($result)) {
$users[] = $data;
}
/**
* Get views
*/
$userCount = count($users);
for ($i = 0; $i < $userCount; $i++) {
$photos = $flickr->people_getPublicPhotos($users[$i]["flickrId"]);
$totalViews = 0;
foreach($photos['photos']['photo'] as $photo) {
$info = $flickr->photos_getInfo($photo['id']);
$totalViews += $info['views'];
}
$users[$i]["views"] = $totalViews;
}
/**
* Store stats in database
*/
for ($i = 0; $i < $userCount; $i++) {
$q = "INSERT INTO flickrVisits (userId, updatedAt, visits) VALUES('" . $users[$i]["userId"] . "', NOW(), '" . $users[$i]["views"] . "')";
mysql_query($q);
}