| 0,0 → 1,325 |
|---|
| <?php |
| |
| /** |
| * IO class. |
| * @license http://opensource.org/licenses/gpl-license.php GNU General Public License |
| * @copyright (c)2003-2005 Tamlyn Rhodes |
| * @version $Id: io_csv.class.php,v 1.34 2006/06/25 00:13:56 tamlyn Exp $ |
| */ |
| |
| //include the base IO class |
| require_once dirname(__FILE__)."/io.class.php"; |
| |
| /** |
| * Class used to read and write data to and from CSV files. |
| * @see sgIO_iifn |
| * @package singapore |
| * @author Tamlyn Rhodes <tam at zenology dot co dot uk> |
| * @copyright (c)2003, 2004 Tamlyn Rhodes |
| */ |
| class sgIO_csv extends sgIO |
| { |
| //constructor provided by parent class |
| |
| /** |
| * Name of IO backend. |
| */ |
| function getName() |
| { |
| return "CSV"; |
| } |
| |
| /** |
| * Version of IO backend. |
| */ |
| function getVersion() |
| { |
| return "$Revision: 1.34 $"; |
| } |
| |
| /** |
| * Author of IO backend. |
| */ |
| function getAuthor() |
| { |
| return "Tamlyn Rhodes"; |
| } |
| |
| /** |
| * Brief description of IO backend and it's requirements. |
| */ |
| function getDescription() |
| { |
| return "Uses comma separated value files. Does not require a database."; |
| } |
| |
| /** |
| * Fetches gallery info for the specified gallery and immediate children. |
| * @param string gallery id |
| * @param string language code spec for this request (optional) |
| * @param int number of levels of child galleries to fetch (optional) |
| * @return sgGallery the gallery object created |
| */ |
| function &getGallery($galleryId, &$parent, $getChildGalleries = 1, $language = null) |
| { |
| $gal =& new sgGallery($galleryId, $parent); |
| |
| if($language == null) { |
| $translator =& Translator::getInstance(); |
| $language = $translator->language; |
| } |
| |
| //try to open language specific metadata |
| $fp = @fopen($this->config->base_path.$this->config->pathto_galleries.$galleryId."/metadata.$language.csv","r"); |
| |
| //if fail then try to open generic metadata |
| if(!$fp) |
| $fp = @fopen($this->config->base_path.$this->config->pathto_galleries.$galleryId."/metadata.csv","r"); |
| if($fp) { |
| |
| while($temp[] = fgetcsv($fp,2048)); |
| fclose($fp); |
| |
| list( |
| $gal->filename, |
| $gal->thumbnail, |
| $gal->owner, |
| $gal->groups, |
| $gal->permissions, |
| $gal->categories, |
| $gal->name, |
| $gal->artist, |
| $gal->email, |
| $gal->copyright, |
| $gal->desc, |
| $gal->summary, |
| $gal->date |
| ) = $temp[1]; |
| |
| |
| //only fetch individual images if child galleries are required |
| if($getChildGalleries) { |
| for($i=0;$i<count($temp)-3;$i++) { |
| $gal->images[$i] =& new sgImage($temp[$i+2][0], $gal, $this->config); |
| list(, |
| $gal->images[$i]->thumbnail, |
| $gal->images[$i]->owner, |
| $gal->images[$i]->groups, |
| $gal->images[$i]->permissions, |
| $gal->images[$i]->categories, |
| $gal->images[$i]->name, |
| $gal->images[$i]->artist, |
| $gal->images[$i]->email, |
| $gal->images[$i]->copyright, |
| $gal->images[$i]->desc, |
| $gal->images[$i]->location, |
| $gal->images[$i]->date, |
| $gal->images[$i]->camera, |
| $gal->images[$i]->lens, |
| $gal->images[$i]->film, |
| $gal->images[$i]->darkroom, |
| $gal->images[$i]->digital |
| ) = $temp[$i+2]; |
| |
| //get image size and type |
| list( |
| $gal->images[$i]->width, |
| $gal->images[$i]->height, |
| $gal->images[$i]->type |
| ) = @GetImageSize($gal->images[$i]->realPath()); |
| } |
| //otherwise just fill in empty images |
| } else if(count($temp) > 3) { |
| for($i=0;$i<count($temp)-3;$i++) |
| $gal->images[$i] =& new sgImage($temp[$i+2][0], $gal); |
| } |
| |
| } else |
| //no metadata found so use iifn method implemented in superclass |
| return parent::getGallery($galleryId, $parent, $getChildGalleries, $language); |
| |
| //discover child galleries |
| $dir = Singapore::getListing($this->config->base_path.$this->config->pathto_galleries.$galleryId."/"); |
| if($getChildGalleries) |
| //but only fetch their info if required too |
| foreach($dir->dirs as $gallery) |
| $gal->galleries[] = $this->getGallery($galleryId."/".$gallery, $gal, $getChildGalleries-1, $language); |
| else |
| //otherwise just copy their names in so they can be counted |
| $gal->galleries = $dir->dirs; |
| |
| return $gal; |
| } |
| |
| /** |
| * Stores gallery information. |
| * @param sgGallery instance of gallery object to be stored |
| */ |
| function putGallery($gal) { |
| $dataFile = $this->config->base_path.$this->config->pathto_galleries.$gal->id."/metadata.csv"; |
| @chmod($dataFile, octdec($this->config->file_mode)); |
| $fp = @fopen($dataFile,"w"); |
| if(!$fp) |
| return false; |
| |
| $success = (bool) fwrite($fp,"filename,thumbnail,owner,group(s),permissions,catergories,image name,artist name,artist email,copyright,image description,image location,date taken,camera info,lens info,film info,darkroom manipulation,digital manipulation"); |
| $success &= (bool) fwrite($fp,"\n\"". |
| $gal->filename.'",,'. |
| $gal->owner.','. |
| $gal->groups.','. |
| $gal->permissions.','. |
| $gal->categories.',"'. |
| str_replace('"','""',$gal->name).'","'. |
| str_replace('"','""',$gal->artist).'","'. |
| str_replace('"','""',$gal->email).'","'. |
| str_replace('"','""',$gal->copyright).'","'. |
| str_replace('"','""',$gal->desc).'","'. |
| str_replace('"','""',$gal->summary).'","'. |
| str_replace('"','""',$gal->date).'"' |
| ); |
| |
| for($i=0;$i<count($gal->images);$i++) |
| $success &= (bool) fwrite($fp,"\n\"". |
| $gal->images[$i]->id.'",,'. |
| //$gal->images[$i]->thumbnail.','. |
| $gal->images[$i]->owner.','. |
| $gal->images[$i]->groups.','. |
| $gal->images[$i]->permissions.','. |
| $gal->images[$i]->categories.',"'. |
| str_replace('"','""',$gal->images[$i]->name).'","'. |
| str_replace('"','""',$gal->images[$i]->artist).'","'. |
| str_replace('"','""',$gal->images[$i]->email).'","'. |
| str_replace('"','""',$gal->images[$i]->copyright).'","'. |
| str_replace('"','""',$gal->images[$i]->desc).'","'. |
| str_replace('"','""',$gal->images[$i]->location).'","'. |
| str_replace('"','""',$gal->images[$i]->date).'","'. |
| str_replace('"','""',$gal->images[$i]->camera).'","'. |
| str_replace('"','""',$gal->images[$i]->lens).'","'. |
| str_replace('"','""',$gal->images[$i]->film).'","'. |
| str_replace('"','""',$gal->images[$i]->darkroom).'","'. |
| str_replace('"','""',$gal->images[$i]->digital).'"' |
| ); |
| $success &= (bool) fclose($fp); |
| |
| return $success; |
| } |
| |
| /** |
| * Fetches hit data from file. |
| * @param sgGallery gallery object to load hits into |
| */ |
| function getHits(&$gal) { |
| |
| $fp = @fopen($this->config->base_path.$this->config->pathto_galleries.$gal->id."/hits.csv","r"); |
| |
| if($fp) { |
| flock($fp, LOCK_SH); |
| while($temp[] = fgetcsv($fp,255)); |
| flock($fp, LOCK_UN); |
| fclose($fp); |
| } else $temp = array(); |
| |
| if(isset($temp[0])) |
| list( |
| , |
| $gal->hits, |
| $gal->lasthit |
| ) = $temp[0]; |
| |
| for($i=0;$i<count($temp)-2;$i++) { |
| if(isset($gal->images[$i]) && $temp[$i+1][0] == $gal->images[$i]->id) |
| list( |
| , |
| $gal->images[$i]->hits, |
| $gal->images[$i]->lasthit |
| ) = $temp[$i+1]; |
| else |
| foreach($gal->images as $key => $img) |
| if($temp[$i+1][0] == $img->id) |
| list( |
| , |
| $gal->images[$key]->hits, |
| $gal->images[$key]->lasthit |
| ) = $temp[$i+1]; |
| |
| } |
| |
| return true; |
| } |
| |
| /** |
| * Stores gallery hits. |
| * @param sgGallery gallery object to store |
| */ |
| function putHits($gal) { |
| $logfile = $this->config->base_path.$this->config->pathto_galleries.$gal->id."/hits.csv"; |
| if(!file_exists($logfile) && !@touch($logfile)) return false; |
| @chmod($logfile, octdec($this->config->file_mode)); |
| $fp = @fopen($logfile,"r+"); |
| if(!$fp) return false; |
| |
| flock($fp, LOCK_EX); |
| ftruncate($fp, 0); |
| fwrite($fp, '"'. |
| $gal->id.'",'. |
| $gal->hits.','. |
| $gal->lasthit |
| ); |
| |
| foreach($gal->images as $img) |
| fwrite($fp, "\n\"". |
| $img->id.'",'. |
| $img->hits.','. |
| $img->lasthit |
| ); |
| flock($fp, LOCK_UN); |
| fclose($fp); |
| return true; |
| } |
| |
| /** |
| * Fetches all registered users. |
| */ |
| function getUsers() { |
| $fp = fopen($this->config->base_path.$this->config->pathto_data_dir."users.csv.php","r"); |
| |
| //strip off description line |
| fgetcsv($fp,1024); |
| |
| for($i=0;$entry = fgetcsv($fp,1000,",");$i++) { |
| $users[$i] = new sgUser(null,null); |
| list( |
| $users[$i]->username, |
| $users[$i]->userpass, |
| $users[$i]->permissions, |
| $users[$i]->groups, |
| $users[$i]->email, |
| $users[$i]->fullname, |
| $users[$i]->description, |
| $users[$i]->stats |
| ) = $entry; |
| } |
| |
| fclose($fp); |
| return $users; |
| } |
| |
| /** |
| * Stores all registered users. |
| * @param array an array of sgUser objects representing the users to store |
| */ |
| function putUsers($users) { |
| $fp = fopen($this->config->base_path.$this->config->pathto_data_dir."users.csv.php","w"); |
| if(!$fp) return false; |
| |
| $success = (bool) fwrite($fp,"<?php die(\"The contents of this file are hidden\"); ?>username,md5(pass),permissions,group(s),email,name,description,stats\n"); |
| for($i=0;$i<count($users);$i++) |
| $success &= (bool) fwrite($fp,$users[$i]->username.",".$users[$i]->userpass.",".$users[$i]->permissions.",\"".$users[$i]->groups."\",\"".$users[$i]->email."\",\"".$users[$i]->fullname."\",\"".$users[$i]->description."\",\"".$users[$i]->stats."\"\n"); |
| |
| fclose($fp); |
| return $success; |
| } |
| |
| } |
| |
| ?> |