<?php

	// Duplicatr v1.0
	// http://www.command-tab.com/index.php/duplicatr/
	
	// by Collin Allen
	// collin@command-tab.com
	// www.command-tab.com
	
	// TO DO:
	// - Fix the 500 photos limitation (by doing multiple requests, one for each page of 500)
	// - Write code to store and retrieve the dates this script is run, and only update the changed bits
	// - Work around possible browser timeout issues if the web service is running slow one day (suggestions welcome!)
	// - Make installation a little easier
	
	// Installation issues?  Feature requests?  Bugs?  Email me.  collin@command-tab.com
	
	
	/* 
	
	# Table structure:
	# ------------------------------------------------------------
	
	DROP TABLE IF EXISTS `flickr`;
	
	CREATE TABLE `flickr` (
	  `photo_id` int(11) default NULL,
	  `secret` text,
	  `server` int(11) default NULL,
	  `title` text,
	  `description` text,
	  `ispublic` int(11) default '0',
	  `posted` datetime default NULL,
	  `taken` datetime default NULL,
	  `tags` text,
	  `comments` int(11) default NULL,
	  `photopage` text
	) TYPE=MyISAM;
	
	# ------------------------------------------------------------
	
	*/
	
	
	// *** START CONFIGURING ***
	
		// Fill out either your Flickr User ID or the email address you registered with
		$user_id	= ''; // Mine is: command-tab
		$email		= '';
		
		// Fill in the details for your MySQL database
		$db_host	= 'localhost'; // You probably won't need to change this
		$db_user	= '';
		$db_passwd	= '';
		$db_name	= '';
	
	// *** END CONFIGURING ***
	
	
	$db = mysql_connect($db_host,$db_user,$db_passwd) or die("Could not connect to database.");
	mysql_select_db($db_name) or die("Could not select database.");
	
	
	// The Flickr API key for *this* project (free at flickr.com/services).  No need to change/steal this ;)
	$api_key = '5acbcfd9c2393f283d55836273a231ef';
	
	
	// Find out NSID from User ID or email
	// User ID first, since it's one less API hit to do it this way
	if($user_id != '')
	{
		// Look up NSID by User ID 
		$nsid = findByUsername($user_id);
		if(!$nsid)
			die('The Flickr User ID you entered is not valid.  Please double-check it, or use your email address instead.');
	}
	elseif($email != '')
	{
		// Look up NSID by email
		$nsid = findByEmail($email);
		if(!$nsid)
			die('The email address you entered was not found.  Try another, or simply fill in your Flickr User ID.');
	}
	else
	{
		// Both are empty
		die('You must enter a Flickr User ID or email address to continue.');
	}
	
	
	// Request photos and match the id, secret, server, title, and tags
	$photos_xml = file_get_contents('http://www.flickr.com/services/rest/?method=flickr.photos.search&api_key='.$api_key.'&user_id='.$nsid.'&per_page=500&min_upload_date='.mktime(0,0,0,1,1,2004).'&max_upload_date='.date('U')); // Flickr launched Feb 10, 2004

	// If everything matches, add each to the database
	if(preg_match_all('/id="(\d+)".*secret="(\w+)".*server="(\d+)".*title="([^\"]+)"/',$photos_xml,$matches))
	{
		echo 'Backing up';
		
		// Figure out how many we have to deal with
		$total_photos = count($matches[0]);
		
		// Loop through each photo: grab the tags, format the INSERT statement, etc.
		for($i=0; $i<$total_photos; $i++)
		{
			$photo_id	= $matches[1][$i];
			$secret		= $matches[2][$i];
			$server		= $matches[3][$i];
			$title		= $matches[4][$i];
			
			$info		= getInfo($photo_id,$secret);
			
			$query		= mysql_query('INSERT INTO `flickr` (`photo_id`,`secret`,`server`,`title`,`description`,`ispublic`,`posted`,`taken`,`tags`,`comments`,`photopage`) VALUES ('.$photo_id.',"'.$secret.'",'.$server.',"'.$title.'","'.$info['description'].'",'.$info['ispublic'].',"'.$info['posted'].'","'.$info['taken'].'","'.$info['tags'].'",'.$info['comments'].',"'.$info['photopage'].'");',$db);
			if($query)
				echo '.';
		}
		
		echo " done!";
	}
	
	
	// Look up an NSID given a Flickr User ID
	function findByUsername($user_id)
	{
		global $api_key;
		$nsid_xml = file_get_contents('http://www.flickr.com/services/rest/?method=flickr.people.findByUsername&api_key='.$api_key.'&username='.$user_id);
		if(preg_match_all('/nsid="([^"]+)">/',$nsid_xml,$found))
			return $found[1][0];
		else
			return false;
	}
	
	
	// Look up an NSID given an email
	function findByEmail($email)
	{
		global $api_key;
		$nsid_xml = file_get_contents('http://www.flickr.com/services/rest/?method=flickr.people.findByEmail&api_key='.$api_key.'&find_email='.$email);
		if(preg_match_all('/username>([^<]+)<\/username>/',$nsid_xml,$found))
			return findByUsername($found[1][0]);
		else
			return false;
	}
	
	
	// Get info for a given photo ID
	function getInfo($photo_id,$secret)
	{
		global $api_key;
		$info_xml = file_get_contents('http://www.flickr.com/services/rest/?method=flickr.photos.getInfo&api_key='.$api_key.'&photo_id='.$photo_id.'&secret='.$secret);
		
		preg_match_all('/description>([^<]+)<\/description>/',$info_xml,$description_array);
		$info['description'] = mysql_real_escape_string(html_entity_decode($description_array[1][0]));
		
		preg_match_all('/ispublic="(\d)"/',$info_xml,$ispublic_array);
		$info['ispublic'] = $ispublic_array[1][0];
		
		preg_match_all('/lastupdate="(\d+)"/',$info_xml,$posted_array);
		$info['posted'] = date('Y-m-d H:i:s',$posted_array[1][0]);
		
		preg_match_all('/taken="([^"]+)"/',$info_xml,$taken_array);
		$info['taken'] = $taken_array[1][0];
		
		preg_match_all('/comments>(\d+)<\/comments>/',$info_xml,$comments_array);
		$info['comments'] = mysql_real_escape_string(html_entity_decode($comments_array[1][0]));
		
		preg_match_all('/photopage">([^<]+)<\/url>/',$info_xml,$photopage_array);
		$info['photopage'] = $photopage_array[1][0];
		
		preg_match_all('/">(\w+)<\/tag>/',$info_xml,$tags_array);
		$info['tags'] = mysql_real_escape_string(html_entity_decode(implode($tags_array[1],' ')));
		
		return $info;
	}


?>