<?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)\; \{$recentPhotos = array();
      if ($this->useDB)\; \{$sql = "SELECT * FROM photo ORDER BY photo_date_upload DESC LIMIT $n";$res = mysql_query($sql,$this->getConnection())
          or die("Invalid query: " . $sql);\; while($row = mysql_fetch_assoc($res))\; \{$photo = $this->buildPhotoFromRow($row);
         array_push($recentPhotos,$photo);
       }
      }
      else
      {
        $args\; =\; array(\; \text{'}user\_id\text{'}\; =>$this->nsid,
          'sort' => 'date-posted-desc',
          'page' => 1, 
          'per_page' => $n,\; \text{'}extras\text{'}\; =>\; \text{'}owner\_name\text{'}\; );$p = $this->flickr->photos\_search($args);
        if ($this->flickr->getErrorCode())\; \{\; echo\; ("Error\; fetching\; photos:\; "\; .$this->flickr->getErrorMsg());
        }
  
        $recentPhotos\; =$p['photo'];
      }
  
      return $recentPhotos;\; \}\; 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\; .\; \text{'}?title=\text{'}\; .\; urlencode($title) . '&tags=' . urlencode(n&tagMode=sort";
      // Get image to display
      $photos\; =$this->getSmartSet(1, $tags,$tagMode, $sort);\; if\; (is\_array($photos) && count($photos)\; >\; 0)\; \{$photo = $photos[0];$img = 'http://static.flickr.com/' . $photo[\text{'}server\text{'}]\; .\; \text{'}/\text{'}\; .$photo['id'] 
          . '_' . $photo[\text{'}secret\text{'}]\; .\; \text{'}\_s.jpg\text{'};$s .= "<a href=\"$url\backslash ">$<img src=\"img\" /></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(\; \text{'}user\_id\text{'}\; =>$this->nsid,
        'sort' => $sort,\; \text{'}page\text{'}\; =>\; 1,\; \text{'}per\_page\text{'}\; =>$n,
        'extras' => 'owner_name'
      );
  
      if (!empty($tags))\; \{$args['tags'] = $tags;$args['tag_mode'] = $tagMode;\; \}$p = $this->flickr->photos\_search($args);
      if ($this->flickr->getErrorCode())\; \{\; echo\; ("Error\; fetching\; photos:\; "\; .$this->flickr->getErrorMsg());
      }
  
      if (is_array(p['photo']) > 0)
      {
        $ret\; =$p['photo'];
      }
  
      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['user']['nsid']);
    }
    
    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 = '-180, -90, 180, 90';
      }
  
      $args\; =\; array(\; \text{'}user\_id\text{'}\; =>$this->nsid,
        'sort' => 'interestingness-desc',
        'bbox' => $bbox,\; \text{'}extras\text{'}\; =>\; \text{'}geo\text{'},\; \text{'}per\_page\text{'}\; =>\; 500,\; );$p = $this->flickr->photos\_search($args);
      if ($this->flickr->getErrorCode())\; \{\; echo\; ("Error\; fetching\; photos\; with\; GeoData:\; "\; .$this->flickr->getErrorMsg());
      }
  
      return $p[\text{'}photo\text{'}];\; \}\; 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"\; .\; "\; (\text{'}$\%s', '\%s', \%d, '\%s', '\%s', \%d, \%d, \%d, '\%s', \%d, \%d, '\%s',"
        . " \%f, \%f, \%d)";
  
      keepGoing = 1;
      $page\; =\; 1;\; while\; ($keepGoing)
      {
        $args\; =\; array(\; \text{'}user\_id\text{'}\; =>$this->nsid,
          'sort' => 'date-posted-desc',
          'page' => $page,\; \text{'}per\_page\text{'}\; =>\; 500,\; \text{'}extras\text{'}\; =>\; \text{'}date\_upload,\; date\_taken,\; owner\_name,\; geo\text{'}\; );$p = $this->flickr->photos\_search($args);
        if ($this->flickr->getErrorCode())\; \{\; echo\; ("Error\; fetching\; photos:\; "\; .$this->flickr->getErrorMsg());
        }
  
        if (count($p[\text{'}photo\text{'}])\; ==\; 0)\; \{$// no more photos
          break;
        }
  
        foreach(p['photo'] as $photo)\; \{$sql = sprintf($q,$photo['id'], $photo[\text{'}secret\text{'}],$photo['server'], 
            $photo[\text{'}owner\text{'}],\; mysql\_escape\_string($photo['ownername']), 
            $photo[\text{'}ispublic\text{'}],$photo['isfriend'], $photo[\text{'}isfamily\text{'}],$photo['datetaken'], $photo[\text{'}datetakengranularity\text{'}],$photo['dateupload'],
            mysql_escape_string($photo[\text{'}title\text{'}]),$photo['latitude'], 
            $photo[\text{'}longitude\text{'}],$photo['accuracy']);
  
          mysql_query($sql,$this->getConnection()) 
            or die("Invalid query: " . $sql);\; \}$page++;
      }
    }
  
    function buildPhotoFromRow($row)\; \{$photo = array();
  
      $photo[\text{'}id\text{'}]\; =$row['photo_id'];
      $photo[\text{'}secret\text{'}]\; =$row['photo_secret'];
      $photo[\text{'}server\text{'}]\; =$row['photo_server'];
      $photo[\text{'}owner\text{'}]\; =$row['photo_owner'];
      $photo[\text{'}ownername\text{'}]\; =$row['photo_owner_name'];
      $photo[\text{'}title\text{'}]\; =$row['photo_title'];
      $photo[\text{'}ispublic\text{'}]\; =$row['photo_is_public'];
      $photo[\text{'}isfriend\text{'}]\; =$row['photo_is_friend'];
      $photo[\text{'}isfamily\text{'}]\; =$row['photo_is_family'];
      $photo[\text{'}dateupload\text{'}]\; =$row['photo_date_upload'];
      $photo[\text{'}datetaken\text{'}]\; =$row['photo_date_taken'];
      $photo[\text{'}datetakengranularity\text{'}]\; =$row['photo_date_taken_granularity'];
      $photo[\text{'}latitude\text{'}]\; =$row['photo_latitude'];
      $photo[\text{'}longitude\text{'}]\; =$row['photo_longitude'];
      $photo[\text{'}accuracy\text{'}]\; =$row['photo_accuracy'];
  
      return $photo;\; \}\; \}\; ?>$