<?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();
  
      if ($this->useDB)\; \{$key = $this->getSmartSetKey($tags, $tagMode,$sort);
        $sql\; =\; "SELECT\; COUNT(*)\; FROM\; smartset\; WHERE\; sset\_key\; =\; \text{'}$key'";
        $res\; =\; mysql\_query($sql, $this->getConnection())\; or\; die("Invalid\; query:\; "\; .$sql);
  
        if ($row\; =\; mysql\_fetch\_array($res))
        {
          $count\; =$row[0];
          if ($count\; ==\; 0)\; \{$this->populateSmartSet($tags,$tagMode, $sort);\; \}\; \}$sql = "SELECT * FROM smartset, photo"
          . " WHERE sset_photo_id = photo_id"
          . " AND sset_key = '$key\text{'}\; 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($ret, $photo);\; \}\; \}\; else\; \{$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{'};\; \}$geoPhotos = array();
      if ($this->useDB)\; \{$bounds = explode(",", $bbox);$sql = "SELECT * FROM photo WHERE photo_accuracy > 0"
          . " AND photo_latitude >= " . bounds[3] 
          . " AND photo_longitude >= " . bounds[2];
  
        $res\; =\; mysql\_query($sql, $this->getConnection())\; or\; die("Invalid\; query:\; "\; .$sql);
  
        while($row\; =\; mysql\_fetch\_assoc($res))
        {
          $photo\; =$this->buildPhotoFromRow($row);\; array\_push($geoPhotos, $photo);\; \}\; \}\; else\; \{$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());\; \}$geoPhotos = $p[\text{'}photo\text{'}];\; \}\; return$geoPhotos;
    }
    
    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++;\; \}\; \}\; function\; buildPhotoFromRow($row)
    {
      $photo\; =\; array();$photo['id'] = $row[\text{'}photo\_id\text{'}];$photo['secret'] = $row[\text{'}photo\_secret\text{'}];$photo['server'] = $row[\text{'}photo\_server\text{'}];$photo['owner'] = $row[\text{'}photo\_owner\text{'}];$photo['ownername'] = $row[\text{'}photo\_owner\_name\text{'}];$photo['title'] = $row[\text{'}photo\_title\text{'}];$photo['ispublic'] = $row[\text{'}photo\_is\_public\text{'}];$photo['isfriend'] = $row[\text{'}photo\_is\_friend\text{'}];$photo['isfamily'] = $row[\text{'}photo\_is\_family\text{'}];$photo['dateupload'] = $row[\text{'}photo\_date\_upload\text{'}];$photo['datetaken'] = $row[\text{'}photo\_date\_taken\text{'}];$photo['datetakengranularity'] = $row[\text{'}photo\_date\_taken\_granularity\text{'}];$photo['latitude'] = $row[\text{'}photo\_latitude\text{'}];$photo['longitude'] = $row[\text{'}photo\_longitude\text{'}];$photo['accuracy'] = $row[\text{'}photo\_accuracy\text{'}];\; return$photo;
    }
  
    function getPhoto($id)\; \{$photo = NULL;
      if ($this->useDB)\; \{$sql = "SELECT * FROM photo WHERE photo_id = '" 
          . mysql_escape_string($id)\; .\; "\text{'}";$res = mysql_query($sql,$this->getConnection()) 
          or die("Invalid query: " . $sql);\; if\; ($row = mysql_fetch_assoc($res))\; \{$photo = $this->buildPhotoFromRow($row); 
        }
      }
  
      return $photo;\; \}\; function\; getNextPhoto($photo, $key\; =\; NULL)\; \{$nextPhoto = NULL;
      $sql\; =\; "";\; if\; ($this->useDB)
      {
        if (empty($key))\; \{$// Get from recent photos
          date = $photo[\text{'}dateupload\text{'}];$sql = "select * from photo"
            . " where photo_date_upload > $date"\; .\; "\; order\; by\; photo\_date\_upload\; limit\; 1";\; \}\; else\; \{$// Get from smart set
          // First find index for current photo
          photoId = $photo[\text{'}id\text{'}];$indexSql = "select sset_index from smartset "
            . " where sset_key = '" . mysql_escape_string($key)\; .\; "\text{'}"\; .\; "\; and\; sset\_photo\_id\; =\; \text{'}$photoId'";
          $res\; =\; mysql\_query($indexSql, $this->getConnection())\; or\; die("Invalid\; query:\; "\; .$indexSql);
  
          if ($row\; =\; mysql\_fetch\_array($res))
          {
            $index\; =$row[0];
  
            $sql\; =\; "select\; *\; from\; smartset,\; photo"\; .\; "\; where\; sset\_photo\_id\; =\; photo\_id"\; .\; "\; and\; sset\_key\; =\; \text{'}"\; .\; mysql\_escape\_string($key) . "'"
              . " and sset_index > $index"\; .\; "\; order\; by\; sset\_index\; limit\; 1";\; \}\; \}\; if\; (!empty($sql))
        {
          $res\; =\; mysql\_query($sql, $this->getConnection())\; or\; die("Invalid\; query:\; "\; .$sql);
          if ($row\; =\; mysql\_fetch\_assoc($res))
          {
            $nextPhoto\; =$this->buildPhotoFromRow($row);\; \}\; \}\; \}\; return$nextPhoto;
    }
  
    function getPreviousPhoto($photo,$key = NULL)
    {
      $prevPhoto\; =\; NULL;$sql = "";
  
      if ($this->useDB)\; \{\; if\; (empty($key))
        {
          // Get from recent photos
          $date\; =$photo['dateupload'];
          date"
            . " order by photo_date_upload desc limit 1";
        }
        else
        {
          // Get from smart set
          // First find index for current photo
          $photoId\; =$photo['id'];
          $indexSql\; =\; "select\; sset\_index\; from\; smartset\; "\; .\; "\; where\; sset\_key\; =\; \text{'}"\; .\; mysql\_escape\_string($key) . "'"
            . " and sset_photo_id = '$photoId\text{'}";$res = mysql_query($indexSql,$this->getConnection())
            or die("Invalid query: " . $indexSql);\; if\; ($row = mysql_fetch_array($res))\; \{$index = $row[0];$sql = "select * from smartset, photo"
              . " where sset_photo_id = photo_id"
              . " and sset_key = '" . mysql_escape_string(index"
              . " order by sset_index desc limit 1";
          }
        }
  
        if (!empty($sql))\; \{$res = mysql_query($sql,$this->getConnection())
            or die("Invalid query: " . $sql);\; if\; ($row = mysql_fetch_assoc($res))\; \{$prevPhoto = $this->buildPhotoFromRow($row);
          }
        }
      }
  
      return $prevPhoto;\; \}\; function\; getSmartSetKey($tags, $tagMode,$sort)
    {
      $s\; =$tags . ":" . $tagmode\; .\; ":"\; .$sort;
      return md5($s);\; \}\; function\; populateSmartSet($tags, $tagMode,$sort)
    {
      set_time_limit(240);
      $key\; =$this->getSmartSetKey($tags,$tagMode, $sort);$keepGoing = 1;
      $page\; =\; 1;$n = 0;
      while ($keepGoing)\; \{$args = array(
          'user_id' => $this->nsid,\; \text{'}sort\text{'}\; =>$sort,
          'page' => $page,\; \text{'}tags\text{'}\; =>$tags,
          'tag_mode' => $tagMode,\; \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;
        }
  
        q = "INSERT INTO smartset" 
          . " (sset_key, sset_photo_id, sset_index)" 
          . " VALUES" 
          . " ('\%s', '\%s', \%d)";
  
        foreach($p[\text{'}photo\text{'}]\; as$photo)
        {
          $sql\; =\; sprintf($q, $key,$photo['id'], $n);\; mysql\_query($sql, $this->getConnection())\; or\; die("Invalid\; query:\; "\; .$sql);
          $n++;\; \}$page++;
      }    
    }
  
  }
  
  ?>