<?php
  
  class FlickrGallery extends FlickrAuthenticator
  {
    var $nsid\; =\; \text{'}50317659@N00\text{'};\; var$connection = 0;  
  
    var $useDB\; =\; 1;\; var$dbhost;
    var $dbname;\; var$dbuser;
    var $dbpasswd;\; function\; FlickrGallery()\; \{\; global$flickrApiKey;
      global $flickrApiSecret;$this->FlickrAuthenticator($flickrApiKey,$flickrApiSecret);
  
      global $dbhost;\; global$dbname;
      global $dbuser;\; global$dbpasswd; 
  
      $this->dbhost\; =$dbhost;
      $this->dbname\; =$dbname;
      $this->dbuser\; =$dbuser;
      $this->dbpasswd\; =$dbpasswd;
    }
  
    function findRecentPhotos($n\; =\; 20)\; \{$args = array(
      'user_id' => $this->nsid,\; \text{'}sort\text{'}\; =>\; \text{'}date-posted-desc\text{'},\; \text{'}page\text{'}\; =>\; 1,\; \text{'}per\_page\text{'}\; =>$n
       );
  
      $p\; =$this->flickr->photos_search($args);\; if\; ($this->flickr->getErrorCode())
      {
        echo ("Error fetching photos: " . $this->flickr->getErrorMsg());\; \}\; return$p['photo'];
    }
    
    function getPhotoInfo($id)\; \{$p = $this->flickr->photos\_getInfo($id);
      if ($this->flickr->getErrorCode())\; \{\; echo\; ("Error\; getting\; photo\; info:\; "\; .$this->flickr->getErrorMsg());
      }
  
      return $p;\; \}\; function\; showSmartSetThumbnail($linkPage, $title\; =\; "Set",$n = 20, $tags\; =\; "",$tagMode = "all", $sort\; =\; "date-posted-desc")\; \{$s = "";
      $url\; =$linkPage . '?title=' . urlencode(tags) 
        . "&n=tagMode&sort=$sort";$// Get image to display
      photos = $this->getSmartSet(1,$tags, $tagMode,$sort);
  
      if (is_array(photos) > 0)
      {
        $photo\; =$photos[0];
        $img\; =\; \text{'}http://static.flickr.com/\text{'}.$photo['server'] . '/' . $photo[\text{'}id\text{'}]\; .\; \text{'}\_\text{'}\; .$photo['secret'] . '_s.jpg';
        url\"><img src=\"$img\backslash "\; />$</a>";
        s .= "<p class=\"smart-set-caption\">" . $title\; .\; "$</p>";
      }
      return s;
    }
  
    function getSmartSet($n\; =\; 20,$tags = "", $tagMode\; =\; "all",$sort = "date-posted-desc")
    {
      $ret\; =\; array();$args = array(
        'user_id' => $this->nsid,\; \text{'}sort\text{'}\; =>$sort,
        'page' => 1,
        'per_page' => $n,\; \text{'}extras\text{'}\; =>\; \text{'}owner\_name\text{'}\; );\; if\; (!empty($tags))
      {
        $args[\text{'}tags\text{'}]\; =$tags;
        $args[\text{'}tag\_mode\text{'}]\; =$tagMode;
      }
  
      $p\; =$this->flickr->photos_search($args);\; if\; ($this->flickr->getErrorCode())
      {
        echo ("Error fetching photos: " . $this->flickr->getErrorMsg());\; \}\; if\; (is\_array($p['photo']) && count($p[\text{'}photo\text{'}])\; >\; 0)\; \{$ret = $p[\text{'}photo\text{'}];\; \}\; return$ret;
    }
  
    function setMeta($id,$title, $description)\; \{$this->flickr->photos_setMeta($id,$title, $description);\; if\; ($this->flickr->getErrorCode())
      {
        echo ("Error setting metadata: " . $this->flickr->getErrorMsg());\; \}\; \}\; function\; checkAuthenticatedUser()\; \{\; return\; ($this->nsid == $this->auth[\text{'}user\text{'}][\text{'}nsid\text{'}]);\; \}\; function\; setTags($id, $tags)\; \{$this->flickr->photos_setTags($id,$tags);
  
      if ($this->flickr->getErrorCode())\; \{\; echo\; ("Error\; setting\; tags:\; "\; .$this->flickr->getErrorMsg());
      }
    }
  
    function uploadPhoto($file,$title = null, $description\; =\; null,$tags = null, 
      $isPublic\; =\; null,$isFriend = null, $isFamily\; =\; null)\; \{$id = $this->flickr->sync\_upload($file, $title,$description, $tags,$isPublic,
        $isFriend,$isFamily);
  
      if ($this->flickr->getErrorCode())\; \{\; echo\; ("Error\; uploading\; photo:\; "\; .$this->flickr->getErrorMsg());
      }
  
      return $id;\; \}\; function\; replacePhoto($file, $photoId)\; \{$id = $this->flickr->replace($file, $photoId);\; if\; ($this->flickr->getErrorCode())
      {
        echo ("Error replacing photo: " . $this->flickr->getErrorMsg());\; \}\; return$id;
    }
  
    function getWithGeoData($bbox\; =\; NULL)\; \{\; if\; ($bbox == NULL)
      {
        $bbox\; =\; \text{'}-180,\; -90,\; 180,\; 90\text{'};\; \}$args = array(
        'user_id' => $this->nsid,\; \text{'}sort\text{'}\; =>\; \text{'}interestingness-desc\text{'},\; \text{'}bbox\text{'}\; =>$bbox,
        'extras' => 'geo',
        'per_page' => 500,
        );
  
      $p\; =$this->flickr->photos_search($args);\; if\; ($this->flickr->getErrorCode())
      {
        echo ("Error fetching photos with GeoData: " . $this->flickr->getErrorMsg());\; \}\; return$p['photo'];
    }
    
    function getConnection()
    {
      if (empty($this->connection))\; \{$this->connection = mysql_connect($this->dbhost,$this->dbuser, $this->dbpasswd);\; if\; (!$this->connection)
        {
          die ("Cannot connect to database server: " . $this->dbhost);\; \}$ret = mysql_select_db($this->dbname,$this->connection);
  
        if (!$ret)\; \{\; die\; ("Cannot\; access\; database\; "\; .$this->dbname . " on " . $this->dbhostname);\; \}\; \}\; return$this->connection;
    }
  
    function flushDBPhotos()
    {
      $sql\; =\; "DELETE\; FROM\; photo";\; mysql\_query($sql, $this->getConnection())\; or\; die("Invalid\; query:\; "\; .$sql); 
    }
  
    function populateDBPhotos()
    {
      $this->flushDBPhotos();\; set\_time\_limit(240);$q = "INSERT INTO photo" 
        . " (photo_id, photo_secret, photo_server, photo_owner, photo_owner_name,"
        . " photo_is_public, photo_is_friend, photo_is_family,"
        . " photo_date_taken, photo_date_taken_granularity, photo_date_upload,"
        . " photo_title, photo_latitude, photo_longitude, photo_accuracy)"
        . " VALUES" 
        . " ('\%s', '\%s', \%d, '\%s', '\%s', \%d, \%d, \%d, '\%s', \%d, \%d, '\%s',"
        . " \%f, \%f, \%d)";
  
      $keepGoing\; =\; 1;$page = 1;
      while ($keepGoing)\; \{$args = array(
          'user_id' => $this->nsid,\; \text{'}sort\text{'}\; =>\; \text{'}date-posted-desc\text{'},\; \text{'}page\text{'}\; =>$page, 
          'per_page' => 500,
          'extras' => 'date_upload, date_taken, owner_name, geo'
        );
  
        $p\; =$this->flickr->photos_search($args);\; if\; ($this->flickr->getErrorCode())
        {
          echo ("Error fetching photos: " . $this->flickr->getErrorMsg());\; \}\; if\; (count($p['photo']) == 0)
        {
          // no more photos
          break;
        }
  
        foreach($p[\text{'}photo\text{'}]\; as$photo)
        {
          $sql\; =\; sprintf($q, $photo[\text{'}id\text{'}],$photo['secret'], $photo[\text{'}server\text{'}],$photo['owner'], mysql_escape_string($photo[\text{'}ownername\text{'}]),$photo['ispublic'], $photo[\text{'}isfriend\text{'}],$photo['isfamily'], 
            $photo[\text{'}datetaken\text{'}],$photo['datetakengranularity'], 
            $photo[\text{'}dateupload\text{'}],\; mysql\_escape\_string($photo['title']), $photo[\text{'}latitude\text{'}],$photo['longitude'], $photo[\text{'}accuracy\text{'}]);\; mysql\_query($sql, $this->getConnection())\; or\; die("Invalid\; query:\; "\; .$sql);
        }
        $page++;\; \}\; \}\; \}\; ?>$