From 61f2970e221f8612e51e7802cc127819c4caa369 Mon Sep 17 00:00:00 2001 From: Andreas Unterkircher Date: Mon, 4 Jun 2007 18:32:41 +0000 Subject: initial import git-svn-id: file:///var/lib/svn/phpfspot/trunk@2 fa6a889d-dae6-447d-9e79-4ba9a3039384 --- phpfspot.class.php | 127 +++++++++++++++++++++++++++ phpfspot_cfg.php | 22 +++++ phpfspot_db.php | 247 +++++++++++++++++++++++++++++++++++++++++++++++++++++ phpfspot_img.php | 113 ++++++++++++++++++++++++ phpfspot_tmpl.php | 27 ++++++ 5 files changed, 536 insertions(+) create mode 100644 phpfspot.class.php create mode 100644 phpfspot_cfg.php create mode 100644 phpfspot_db.php create mode 100644 phpfspot_img.php create mode 100644 phpfspot_tmpl.php diff --git a/phpfspot.class.php b/phpfspot.class.php new file mode 100644 index 0000000..d040f13 --- /dev/null +++ b/phpfspot.class.php @@ -0,0 +1,127 @@ +cfg = new PHPFSPOT_CFG; + + $this->db = new PHPFSPOT_DB(&$this, $this->cfg->db); + $this->tmpl = new PHPFSPOT_TMPL(&$this); + + $this->get_tags(); + $this->get_photos(); + + if(isset($_GET['id']) && is_numeric($_GET['id'])) + $this->current_photo = $_GET['id']; + + } // __construct() + + public function __destruct() + { + + } // __destruct() + + public function show() + { + + if(isset($this->current_photo)) { + $this->tmpl->assign('image_url', 'phpfspot_img.php?idx='. $this->avail_photos[$this->current_photo] ."&width=". $this->cfg->photo_width); + } + + if($this->current_photo > 0) { + $this->tmpl->assign('previous_url', $_SERVER['PHP_SELF'] ."?mode=showphoto&id=". $this->avail_photos[$this->current_photo-1]); + } + + if($this->current_photo < count($this->avail_photos)) { + $this->tmpl->assign('next_url', $_SERVER['PHP_SELF'] ."?mode=showphoto&id=". $this->avail_photos[$this->current_photo+1]); + } + + $this->tmpl->assign('tags', $this->tags); + $this->tmpl->show("index.tpl"); + + + } // show() + + private function get_tags() + { + $result = $this->db->db_query(" + SELECT id,name + FROM tags + ORDER BY sort_priority ASC + "); + + while($row = $this->db->db_fetch_object($result)) { + + $tag_id = $row['id']; + $tag_name = $row['name']; + + $this->tags[$tag_id] = $tag_name; + + } + } // get_tags() + + private function get_photos() + { + $this->avail_photos = Array(); + $count = 0; + + $result = $this->db->db_query(" + SELECT id, name + FROM photos + ORDER BY time ASC + "); + + while($row = $this->db->db_fetch_object($result)) { + + $photo_id = $row['id']; + $photo_name = $row['name']; + + $this->photos[$photo_id] = $photo_name; + $this->avail_photos[$count] = $photo_id; + + if(!isset($this->current_photo)) + $this->current_photo = $count; + + $count++; + + } + + } // get_photos() + + public function get_photo_details($idx) + { + $result = $this->db->db_query(" + SELECT * + FROM photos + WHERE id='". $idx ."' + "); + + return $this->db->db_fetch_object($result); + + } // get_photo_details + + public function translate_path($path, $width = 0) + { + return str_replace($this->cfg->path_replace_from, $this->cfg->path_replace_to, $path); + + } // translate_path + + + +} + +?> diff --git a/phpfspot_cfg.php b/phpfspot_cfg.php new file mode 100644 index 0000000..b833b99 --- /dev/null +++ b/phpfspot_cfg.php @@ -0,0 +1,22 @@ + diff --git a/phpfspot_db.php b/phpfspot_db.php new file mode 100644 index 0000000..96648be --- /dev/null +++ b/phpfspot_db.php @@ -0,0 +1,247 @@ +parent = $parent; + $this->db_path = $db_path; + + /* We are starting disconnected */ + $this->setConnStatus(false); + + /* Connect to MySQL Database */ + $this->db_connect(); + + } // __construct() + + /** + * PHPFSPOT_DB class deconstructor + * + * This destructor will close the current database connection. + */ + public function __destruct() + { + $this->db_disconnect(); + + } // _destruct() + + /** + * PHPFSPOT_DB database connect + * + * This function will connect to the database via MDB2 + */ + private function db_connect() + { + if(($this->db = sqlite3_open($this->db_path)) === false) { + + $this->throwError("Unable to connect to database:" . $this->getLastError()); + $this->setConnStatus(false); + } + + $this->setConnStatus(true); + + } // db_connect() + + /** + * PHPFSPOT_DB database disconnect + * + * This function will disconnected an established database connection. + */ + private function db_disconnect() + { + if($this->getConnStatus()) + sqlite3_close($this->db); + + } // db_disconnect() + + /** + * PHPFSPOT_DB database query + * + * This function will execute a SQL query and return the result as + * object. + */ + public function db_query($query = "") + { + if($this->getConnStatus()) { + + if(($result = sqlite3_query($this->db, $query)) === false) + $this->trowError($this->getLastError()); + + return $result; + } + else + $this->ThrowError("Can't execute query - we are not connected!"); + + } // db_query() + + public function db_fetch_object(&$resource) + { + return sqlite3_fetch_array($resource); + + } // db_fetch_object + + /** + * PHPFSPOT_DB fetch ONE row + * + * This function will execute the given but only return the + * first result. + */ + public function db_fetchSingleRow($query = "") + { + if($this->getConnStatus()) { + + $result = $this->db_query($query); + $row = $result->fetchRow(); + return $row; + } + else + $this->ThrowError("Can't fetch row - we are not connected!"); + + } // db_fetchSingleRow() + + /** + * PHPFSPOT_DB number of affected rows + * + * This functions returns the number of affected rows but the + * given SQL query. + */ + public function db_getNumRows($query = "") + { + /* Execute query */ + $result = $this->db_query($query); + + /* Errors? */ + if(PEAR::isError($result)) + $this->throwError($result->getMessage()); + + return $result->numRows(); + + } // db_getNumRows() + + /** + * PHPFSPOT_DB get primary key + * + * This function returns the primary key of the last + * operated insert SQL query. + */ + public function db_getid() + { + /* Get the last primary key ID from execute query */ + return mysql_insert_id($this->db->connection); + + } // db_getid() + + /** + * PHPFSPOT_DB check table exists + * + * This function checks if the given table exists in the + * database + * @param string, table name + * @return true if table found otherwise false + */ + public function db_check_table_exists($table_name = "") + { + if($this->getConnStatus()) { + $result = $this->db_query("SHOW TABLES"); + $tables_in = "Tables_in_". MYSQL_DB; + + while($row = $result->fetchRow()) { + if($row->$tables_in == $table_name) + return true; + } + return false; + } + else + $this->ThrowError("Can't check table - we are not connected!"); + + } // db_check_table_exists() + + /** + * PHPFSPOT_DB get connection status + * + * This function checks the internal state variable if already + * connected to database. + */ + private function setConnStatus($status) + { + $this->is_connected = $status; + + } // setConnStatus() + + /** + * PHPFSPOT_DB set connection status + * This function sets the internal state variable to indicate + * current database connection status. + */ + private function getConnStatus() + { + return $this->is_connected; + + } // getConnStatus() + + /** + * PHPFSPOT_DB throw error + * + * This function shows up error messages and afterwards through exceptions. + */ + private function ThrowError($string) + { + if(!defined('DB_NOERROR')) { + print "

". $string ."

\n"; + try { + throw new Exception; + } + catch(Exectpion $e) { + } + } + + $this->last_error = $string; + + } // ThrowError() + + private function getLastError() + { + + return sqlite3_error_string(sqlite3_last_error($this->db)); + + } // getLastError() + +} + +?> diff --git a/phpfspot_img.php b/phpfspot_img.php new file mode 100644 index 0000000..3a2a322 --- /dev/null +++ b/phpfspot_img.php @@ -0,0 +1,113 @@ +parent = new PHPFSPOT; + $this->db = $this->parent->db; + + } // __construct() + + public function __destruct() + { + + } // __desctruct() + + public function show($idx, $width = "") + { + $details = $this->parent->get_photo_details($idx); + + foreach(Array($this->parent->cfg->thumb_width, $this->parent->cfg->photo_width) as $resolution) + $this->resize_image($this->parent->translate_path($details['directory_path']) ."/". $details['name'], $resolution); + + if($width == "") + $fullpath = $this->parent->translate_path($details['directory_path']) ."/". $details['name']; + else + $fullpath = $this->parent->translate_path($details['directory_path']) ."/thumbs/". $width ."_". $details['name']; + + + $tmp = getimagesize($fullpath); + $mime = $tmp['mime']; + + Header("Content-Type: ". $mime); + Header("Content-Length: ". filesize($fullpath)); + Header("Content-Transfer-Encoding: binary\n"); + $user_agent = strtolower ($_SERVER["HTTP_USER_AGENT"]); + Header("Content-Disposition: inline; filename=\"". $details['name'] ."\""); + Header("Accept-Ranges: bytes"); + Header("Connection: close"); + + $file = fopen($fullpath, "rb"); + fpassthru($file); + @fclose($file); + + } // show() + + public function resize_image($image, $width) + { + $src_img = @imagecreatefromjpeg($image); + + if($src_img) + { + /* grabs the height and width */ + $new_w = imagesx($src_img); + $new_h = imagesy($src_img); + + // If requested width is more then the actual image width, + // do not generate a thumbnail + + if($width >= $new_w) { + imagedestroy($src_img); + return; + } + + /* calculates aspect ratio */ + $aspect_ratio = $new_h / $new_w; + + /* sets new size */ + $new_w = $width; + $new_h = abs($new_w * $aspect_ratio); + + /* creates new image of that size */ + $dst_img = imagecreatetruecolor($new_w,$new_h); + + imagefill($dst_img, 0, 0, ImageColorAllocate($dst_img, 255, 255, 255)); + + /* copies resized portion of original image into new image */ + imagecopyresampled($dst_img,$src_img,0,0,0,0,$new_w,$new_h,imagesx($src_img),imagesy($src_img)); + + /* write down new generated file */ + + if(!file_exists(dirname($image) ."/thumbs")) + mkdir(dirname($image) ."/thumbs"); + + $newfile = dirname($image) ."/thumbs/". $width ."_". basename($image); + imagejpeg($dst_img, $newfile, 75); + + /* free your mind */ + imagedestroy($dst_img); + imagedestroy($src_img); + } + + } // resize_image() +} + +if(isset($_GET['idx']) && is_numeric($_GET['idx'])) { + + if(isset($_GET['width']) && is_numeric($_GET['width'])) + $width = $_GET['width']; + else + $width = ""; + + $img = new PHPFSPOT_IMG; + $img->show($_GET['idx'], $width); +} + +?> diff --git a/phpfspot_tmpl.php b/phpfspot_tmpl.php new file mode 100644 index 0000000..4dd24e6 --- /dev/null +++ b/phpfspot_tmpl.php @@ -0,0 +1,27 @@ +Smarty(); + $this->template_dir = $parent->cfg->base_path .'/templates'; + $this->config_dir = $parent->cfg->base_path .'/smarty_config'; + $this->compile_dir = $parent->cfg->base_path .'/templates_c'; + $this->cache_dir = $parent->cfg->base_path .'/smarty_cache'; + + } // __construct() + + public function show($template) + { + $this->display($template); + + } // show() + +} + +?> -- cgit v1.2.3-18-g5258