| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243 | 
							- <?php
 
- namespace Lychee\Modules;
 
- use ZipArchive;
 
- use Imagick;
 
- final class Photo {
 
- 	private $photoIDs = null;
 
- 	public static $validTypes = array(
 
- 		IMAGETYPE_JPEG,
 
- 		IMAGETYPE_GIF,
 
- 		IMAGETYPE_PNG
 
- 	);
 
- 	public static $validExtensions = array(
 
- 		'.jpg',
 
- 		'.jpeg',
 
- 		'.png',
 
- 		'.gif'
 
- 	);
 
- 	/**
 
- 	 * @return boolean Returns true when successful.
 
- 	 */
 
- 	public function __construct($photoIDs) {
 
- 		// Init vars
 
- 		$this->photoIDs = $photoIDs;
 
- 		return true;
 
- 	}
 
- 	/**
 
- 	 * Creats new photo(s).
 
- 	 * Exits on error.
 
- 	 * Use $returnOnError if you want to handle errors by your own.
 
- 	 * @return boolean Returns true when successful.
 
- 	 */
 
- 	public function add(array $files, $albumID = 0, $returnOnError = false) {
 
- 		// Check permissions
 
- 		if (hasPermissions(LYCHEE_UPLOADS)===false||
 
- 			hasPermissions(LYCHEE_UPLOADS_BIG)===false||
 
- 			hasPermissions(LYCHEE_UPLOADS_THUMB)===false) {
 
- 				Log::error(Database::get(), __METHOD__, __LINE__, 'An upload-folder is missing or not readable and writable');
 
- 				if ($returnOnError===true) return false;
 
- 				Response::error('An upload-folder is missing or not readable and writable!');
 
- 		}
 
- 		// Call plugins
 
- 		Plugins::get()->activate(__METHOD__, 0, func_get_args());
 
- 		switch($albumID) {
 
- 			case 's':
 
- 				// s for public (share)
 
- 				$public  = 1;
 
- 				$star    = 0;
 
- 				$albumID = 0;
 
- 				break;
 
- 			case 'f':
 
- 				// f for starred (fav)
 
- 				$star    = 1;
 
- 				$public  = 0;
 
- 				$albumID = 0;
 
- 				break;
 
- 			case 'r':
 
- 				// r for recent
 
- 				$public  = 0;
 
- 				$star    = 0;
 
- 				$albumID = 0;
 
- 				break;
 
- 			default:
 
- 				$star   = 0;
 
- 				$public = 0;
 
- 				break;
 
- 		}
 
- 		// Only process the first photo in the array
 
- 		$file = $files[0];
 
- 		// Check if file exceeds the upload_max_filesize directive
 
- 		if ($file['error']===UPLOAD_ERR_INI_SIZE) {
 
- 			Log::error(Database::get(), __METHOD__, __LINE__, 'The uploaded file exceeds the upload_max_filesize directive in php.ini');
 
- 			if ($returnOnError===true) return false;
 
- 			Response::error('The uploaded file exceeds the upload_max_filesize directive in php.ini!');
 
- 		}
 
- 		// Check if file was only partially uploaded
 
- 		if ($file['error']===UPLOAD_ERR_PARTIAL) {
 
- 			Log::error(Database::get(), __METHOD__, __LINE__, 'The uploaded file was only partially uploaded');
 
- 			if ($returnOnError===true) return false;
 
- 			Response::error('The uploaded file was only partially uploaded!');
 
- 		}
 
- 		// Check if writing file to disk failed
 
- 		if ($file['error']===UPLOAD_ERR_CANT_WRITE) {
 
- 			Log::error(Database::get(), __METHOD__, __LINE__, 'Failed to write photo to disk');
 
- 			if ($returnOnError===true) return false;
 
- 			Response::error('Failed to write photo to disk!');
 
- 		}
 
- 		// Check if a extension stopped the file upload
 
- 		if ($file['error']===UPLOAD_ERR_EXTENSION) {
 
- 			Log::error(Database::get(), __METHOD__, __LINE__, 'A PHP extension stopped the file upload');
 
- 			if ($returnOnError===true) return false;
 
- 			Response::error('A PHP extension stopped the file upload!');
 
- 		}
 
- 		// Check if the upload was successful
 
- 		if ($file['error']!==UPLOAD_ERR_OK) {
 
- 			Log::error(Database::get(), __METHOD__, __LINE__, 'Upload contains an error (' . $file['error'] . ')');
 
- 			if ($returnOnError===true) return false;
 
- 			Response::error('Upload failed!');
 
- 		}
 
- 		// Verify extension
 
- 		$extension = getExtension($file['name']);
 
- 		if (!in_array(strtolower($extension), self::$validExtensions, true)) {
 
- 			Log::error(Database::get(), __METHOD__, __LINE__, 'Photo format not supported');
 
- 			if ($returnOnError===true) return false;
 
- 			Response::error('Photo format not supported!');
 
- 		}
 
- 		// Verify image
 
- 		$type = @exif_imagetype($file['tmp_name']);
 
- 		if (!in_array($type, self::$validTypes, true)) {
 
- 			Log::error(Database::get(), __METHOD__, __LINE__, 'Photo type not supported');
 
- 			if ($returnOnError===true) return false;
 
- 			Response::error('Photo type not supported!');
 
- 		}
 
- 		// Generate id
 
- 		$id = generateID();
 
- 		// Set paths
 
- 		$tmp_name   = $file['tmp_name'];
 
- 		$photo_name = md5($id) . $extension;
 
- 		$path       = LYCHEE_UPLOADS_BIG . $photo_name;
 
- 		// Calculate checksum
 
- 		$checksum = sha1_file($tmp_name);
 
- 		if ($checksum===false) {
 
- 			Log::error(Database::get(), __METHOD__, __LINE__, 'Could not calculate checksum for photo');
 
- 			if ($returnOnError===true) return false;
 
- 			Response::error('Could not calculate checksum for photo!');
 
- 		}
 
- 		// Check if image exists based on checksum
 
- 		if ($checksum===false) {
 
- 			$checksum = '';
 
- 			$exists   = false;
 
- 		} else {
 
- 			$exists = $this->exists($checksum);
 
- 			if ($exists!==false) {
 
- 				$photo_name = $exists['photo_name'];
 
- 				$path       = $exists['path'];
 
- 				$path_thumb = $exists['path_thumb'];
 
- 				$medium     = ($exists['medium']==='1' ? 1 : 0);
 
- 				$exists     = true;
 
- 			}
 
- 		}
 
- 		if ($exists===false) {
 
- 			// Import if not uploaded via web
 
- 			if (!is_uploaded_file($tmp_name)) {
 
- 				if (!@copy($tmp_name, $path)) {
 
- 					Log::error(Database::get(), __METHOD__, __LINE__, 'Could not copy photo to uploads');
 
- 					if ($returnOnError===true) return false;
 
- 					Response::error('Could not copy photo to uploads!');
 
- 				} else @unlink($tmp_name);
 
- 			} else {
 
- 				if (!@move_uploaded_file($tmp_name, $path)) {
 
- 					Log::error(Database::get(), __METHOD__, __LINE__, 'Could not move photo to uploads');
 
- 					if ($returnOnError===true) return false;
 
- 					Response::error('Could not move photo to uploads!');
 
- 				}
 
- 			}
 
- 		} else {
 
- 			// Photo already exists
 
- 			// Check if the user wants to skip duplicates
 
- 			if (Settings::get()['skipDuplicates']==='1') {
 
- 				Log::notice(Database::get(), __METHOD__, __LINE__, 'Skipped upload of existing photo because skipDuplicates is activated');
 
- 				if ($returnOnError===true) return false;
 
- 				Response::warning('This photo has been skipped because it\'s already in your library.');
 
- 			}
 
- 		}
 
- 		// Read infos
 
- 		$info = $this->getInfo($path);
 
- 		// Use title of file if IPTC title missing
 
- 		if ($info['title']==='') $info['title'] = substr(basename($file['name'], $extension), 0, 30);
 
- 		if ($exists===false) {
 
- 			// Set orientation based on EXIF data
 
- 			if ($file['type']==='image/jpeg'&&isset($info['orientation'])&&$info['orientation']!=='') {
 
- 				$adjustFile = $this->adjustFile($path, $info);
 
- 				if ($adjustFile!==false) $info = $adjustFile;
 
- 				else Log::notice(Database::get(), __METHOD__, __LINE__, 'Skipped adjustment of photo (' . $info['title'] . ')');
 
- 			}
 
- 			// Set original date
 
- 			if ($info['takestamp']!==''&&$info['takestamp']!==0) @touch($path, $info['takestamp']);
 
- 			// Create Thumb
 
- 			if (!$this->createThumb($path, $photo_name, $info['type'], $info['width'], $info['height'])) {
 
- 				Log::error(Database::get(), __METHOD__, __LINE__, 'Could not create thumbnail for photo');
 
- 				if ($returnOnError===true) return false;
 
- 				Response::error('Could not create thumbnail for photo!');
 
- 			}
 
- 			// Create Medium
 
- 			if ($this->createMedium($path, $photo_name, $info['width'], $info['height'])) $medium = 1;
 
- 			else $medium = 0;
 
- 			// Set thumb url
 
- 			$path_thumb = md5($id) . '.jpeg';
 
- 		}
 
- 		// Save to DB
 
- 		$values = array(LYCHEE_TABLE_PHOTOS, $id, $info['title'], $photo_name, $info['description'], '', $info['type'], $info['width'], $info['height'], $info['size'], $info['iso'], $info['aperture'], $info['make'], $info['model'], $info['shutter'], $info['focal'], $info['takestamp'], $path_thumb, $albumID, $public, $star, $checksum, $medium);
 
- 		$query  = Database::prepare(Database::get(), "INSERT INTO ? (id, title, url, description, tags, type, width, height, size, iso, aperture, make, model, shutter, focal, takestamp, thumbUrl, album, public, star, checksum, medium) VALUES ('?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?')", $values);
 
- 		$result = Database::execute(Database::get(), $query, __METHOD__, __LINE__);
 
- 		if ($result===false) {
 
- 			if ($returnOnError===true) return false;
 
- 			Response::error('Could not save photo in database!');
 
- 		}
 
- 		// Call plugins
 
- 		Plugins::get()->activate(__METHOD__, 1, func_get_args());
 
- 		return true;
 
- 	}
 
- 	/**
 
- 	 * @return array|false Returns a subset of a photo when same photo exists or returns false on failure.
 
- 	 */
 
- 	private function exists($checksum, $photoID = null) {
 
- 		// Exclude $photoID from select when $photoID is set
 
- 		if (isset($photoID)) $query = Database::prepare(Database::get(), "SELECT id, url, thumbUrl, medium FROM ? WHERE checksum = '?' AND id <> '?' LIMIT 1", array(LYCHEE_TABLE_PHOTOS, $checksum, $photoID));
 
- 		else                 $query = Database::prepare(Database::get(), "SELECT id, url, thumbUrl, medium FROM ? WHERE checksum = '?' LIMIT 1", array(LYCHEE_TABLE_PHOTOS, $checksum));
 
- 		$result = Database::execute(Database::get(), $query, __METHOD__, __LINE__);
 
- 		if ($result===false) return false;
 
- 		if ($result->num_rows===1) {
 
- 			$result = $result->fetch_object();
 
- 			$return = array(
 
- 				'photo_name' => $result->url,
 
- 				'path'       => LYCHEE_UPLOADS_BIG . $result->url,
 
- 				'path_thumb' => $result->thumbUrl,
 
- 				'medium'     => $result->medium
 
- 			);
 
- 			return $return;
 
- 		}
 
- 		return false;
 
- 	}
 
- 	/**
 
- 	 * @return boolean Returns true when successful.
 
- 	 */
 
- 	private function createThumb($url, $filename, $type, $width, $height) {
 
- 		// Call plugins
 
- 		Plugins::get()->activate(__METHOD__, 0, func_get_args());
 
- 		// Quality of thumbnails
 
- 		$thumbQuality = 90;
 
- 		// Size of the thumbnail
 
- 		$newWidth  = 200;
 
- 		$newHeight = 200;
 
- 		$photoName = explode('.', $filename);
 
- 		$newUrl    = LYCHEE_UPLOADS_THUMB . $photoName[0] . '.jpeg';
 
- 		$newUrl2x  = LYCHEE_UPLOADS_THUMB . $photoName[0] . '@2x.jpeg';
 
- 		// Create thumbnails with Imagick
 
- 		if(extension_loaded('imagick')&&Settings::get()['imagick']==='1') {
 
- 			// Read image
 
- 			$thumb = new Imagick();
 
- 			$thumb->readImage($url);
 
- 			$thumb->setImageCompressionQuality($thumbQuality);
 
- 			$thumb->setImageFormat('jpeg');
 
- 			// Copy image for 2nd thumb version
 
- 			$thumb2x = clone $thumb;
 
- 			// Create 1st version
 
- 			$thumb->cropThumbnailImage($newWidth, $newHeight);
 
- 			$thumb->writeImage($newUrl);
 
- 			$thumb->clear();
 
- 			$thumb->destroy();
 
- 			// Create 2nd version
 
- 			$thumb2x->cropThumbnailImage($newWidth*2, $newHeight*2);
 
- 			$thumb2x->writeImage($newUrl2x);
 
- 			$thumb2x->clear();
 
- 			$thumb2x->destroy();
 
- 		} else {
 
- 			// Create image
 
- 			$thumb   = imagecreatetruecolor($newWidth, $newHeight);
 
- 			$thumb2x = imagecreatetruecolor($newWidth*2, $newHeight*2);
 
- 			// Set position
 
- 			if ($width<$height) {
 
- 				$newSize     = $width;
 
- 				$startWidth  = 0;
 
- 				$startHeight = $height/2 - $width/2;
 
- 			} else {
 
- 				$newSize     = $height;
 
- 				$startWidth  = $width/2 - $height/2;
 
- 				$startHeight = 0;
 
- 			}
 
- 			// Create new image
 
- 			switch($type) {
 
- 				case 'image/jpeg': $sourceImg = imagecreatefromjpeg($url); break;
 
- 				case 'image/png':  $sourceImg = imagecreatefrompng($url); break;
 
- 				case 'image/gif':  $sourceImg = imagecreatefromgif($url); break;
 
- 				default:           Log::error(Database::get(), __METHOD__, __LINE__, 'Type of photo is not supported');
 
- 				                   return false;
 
- 				                   break;
 
- 			}
 
- 			// Create thumb
 
- 			fastImageCopyResampled($thumb, $sourceImg, 0, 0, $startWidth, $startHeight, $newWidth, $newHeight, $newSize, $newSize);
 
- 			imagejpeg($thumb, $newUrl, $thumbQuality);
 
- 			imagedestroy($thumb);
 
- 			// Create retina thumb
 
- 			fastImageCopyResampled($thumb2x, $sourceImg, 0, 0, $startWidth, $startHeight, $newWidth*2, $newHeight*2, $newSize, $newSize);
 
- 			imagejpeg($thumb2x, $newUrl2x, $thumbQuality);
 
- 			imagedestroy($thumb2x);
 
- 			// Free memory
 
- 			imagedestroy($sourceImg);
 
- 		}
 
- 		// Call plugins
 
- 		Plugins::get()->activate(__METHOD__, 1, func_get_args());
 
- 		return true;
 
- 	}
 
- 	/**
 
- 	 * Creates a smaller version of a photo when its size is bigger than a preset size.
 
- 	 * Photo must be big enough and Imagick must be installed and activated.
 
- 	 * @return boolean Returns true when successful.
 
- 	 */
 
- 	private function createMedium($url, $filename, $width, $height) {
 
- 		// Excepts the following:
 
- 		// (string) $url = Path to the photo-file
 
- 		// (string) $filename = Name of the photo-file
 
- 		// (int) $width = Width of the photo
 
- 		// (int) $height = Height of the photo
 
- 		// Call plugins
 
- 		Plugins::get()->activate(__METHOD__, 0, func_get_args());
 
- 		// Set to true when creation of medium-photo failed
 
- 		$error = false;
 
- 		// Size of the medium-photo
 
- 		// When changing these values,
 
- 		// also change the size detection in the front-end
 
- 		$newWidth  = 1920;
 
- 		$newHeight = 1080;
 
- 		// Check permissions
 
- 		if (hasPermissions(LYCHEE_UPLOADS_MEDIUM)===false) {
 
- 			// Permissions are missing
 
- 			Log::notice(Database::get(), __METHOD__, __LINE__, 'Skipped creation of medium-photo, because uploads/medium/ is missing or not readable and writable.');
 
- 			$error = true;
 
- 		}
 
- 		// Is photo big enough?
 
- 		// Is Imagick installed and activated?
 
- 		if (($error===false)&&
 
- 			($width>$newWidth||$height>$newHeight)&&
 
- 			(extension_loaded('imagick')&&Settings::get()['imagick']==='1')) {
 
- 			$newUrl = LYCHEE_UPLOADS_MEDIUM . $filename;
 
- 			// Read image
 
- 			$medium = new Imagick();
 
- 			$medium->readImage($url);
 
- 			// Adjust image
 
- 			$medium->scaleImage($newWidth, $newHeight, true);
 
- 			// Save image
 
- 			try { $medium->writeImage($newUrl); }
 
- 			catch (ImagickException $err) {
 
- 				Log::notice(Database::get(), __METHOD__, __LINE__, 'Could not save medium-photo (' . $err->getMessage() . ')');
 
- 				$error = true;
 
- 			}
 
- 			$medium->clear();
 
- 			$medium->destroy();
 
- 		} else {
 
- 			// Photo too small or
 
- 			// Medium is deactivated or
 
- 			// Imagick not installed
 
- 			$error = true;
 
- 		}
 
- 		// Call plugins
 
- 		Plugins::get()->activate(__METHOD__, 1, func_get_args());
 
- 		if ($error===true) return false;
 
- 		return true;
 
- 	}
 
- 	/**
 
- 	 * Rotates and flips a photo based on its EXIF orientation.
 
- 	 * @return array|false Returns an array with the new orientation, width, height or false on failure.
 
- 	 */
 
- 	public function adjustFile($path, array $info) {
 
- 		// Excepts the following:
 
- 		// (string) $path = Path to the photo-file
 
- 		// (array) $info = ['orientation', 'width', 'height']
 
- 		// Call plugins
 
- 		Plugins::get()->activate(__METHOD__, 0, func_get_args());
 
- 		$swapSize = false;
 
- 		if (extension_loaded('imagick')&&Settings::get()['imagick']==='1') {
 
- 			switch ($info['orientation']) {
 
- 				case 3:
 
- 					$rotateImage = 180;
 
- 					break;
 
- 				case 6:
 
- 					$rotateImage = 90;
 
- 					$swapSize    = true;
 
- 					break;
 
- 				case 8:
 
- 					$rotateImage = 270;
 
- 					$swapSize    = true;
 
- 					break;
 
- 				default:
 
- 					return false;
 
- 					break;
 
- 			}
 
- 			if ($rotateImage!==0) {
 
- 				$image = new Imagick();
 
- 				$image->readImage($path);
 
- 				$image->rotateImage(new ImagickPixel(), $rotateImage);
 
- 				$image->setImageOrientation(1);
 
- 				$image->writeImage($path);
 
- 				$image->clear();
 
- 				$image->destroy();
 
- 			}
 
- 		} else {
 
- 			$newWidth  = $info['width'];
 
- 			$newHeight = $info['height'];
 
- 			$sourceImg = imagecreatefromjpeg($path);
 
- 			switch ($info['orientation']) {
 
- 				case 2:
 
- 					// mirror
 
- 					// not yet implemented
 
- 					return false;
 
- 					break;
 
- 				case 3:
 
- 					$sourceImg = imagerotate($sourceImg, -180, 0);
 
- 					break;
 
- 				case 4:
 
- 					// rotate 180 and mirror
 
- 					// not yet implemented
 
- 					return false;
 
- 					break;
 
- 				case 5:
 
- 					// rotate 90 and mirror
 
- 					// not yet implemented
 
- 					return false;
 
- 					break;
 
- 				case 6:
 
- 					$sourceImg = imagerotate($sourceImg, -90, 0);
 
- 					$newWidth  = $info['height'];
 
- 					$newHeight = $info['width'];
 
- 					$swapSize  = true;
 
- 					break;
 
- 				case 7:
 
- 					// rotate -90 and mirror
 
- 					// not yet implemented
 
- 					return false;
 
- 					break;
 
- 				case 8:
 
- 					$sourceImg = imagerotate($sourceImg, 90, 0);
 
- 					$newWidth  = $info['height'];
 
- 					$newHeight = $info['width'];
 
- 					$swapSize  = true;
 
- 					break;
 
- 				default:
 
- 					return false;
 
- 					break;
 
- 			}
 
- 			// Recreate photo
 
- 			$newSourceImg = imagecreatetruecolor($newWidth, $newHeight);
 
- 			imagecopyresampled($newSourceImg, $sourceImg, 0, 0, 0, 0, $newWidth, $newHeight, $newWidth, $newHeight);
 
- 			imagejpeg($newSourceImg, $path, 100);
 
- 			// Free memory
 
- 			imagedestroy($sourceImg);
 
- 			imagedestroy($newSourceImg);
 
- 		}
 
- 		// Call plugins
 
- 		Plugins::get()->activate(__METHOD__, 1, func_get_args());
 
- 		// SwapSize should be true when the image has been rotated
 
- 		// Return new dimensions in this case
 
- 		if ($swapSize===true) {
 
- 			$swapSize       = $info['width'];
 
- 			$info['width']  = $info['height'];
 
- 			$info['height'] = $swapSize;
 
- 		}
 
- 		return $info;
 
- 	}
 
- 	/**
 
- 	 * Rurns photo-attributes into a front-end friendly format. Note that some attributes remain unchanged.
 
- 	 * @return array Returns photo-attributes in a normalized structure.
 
- 	 */
 
- 	public static function prepareData(array $data) {
 
- 		// Excepts the following:
 
- 		// (array) $data = ['id', 'title', 'tags', 'public', 'star', 'album', 'thumbUrl', 'takestamp', 'url']
 
- 		// Init
 
- 		$photo = null;
 
- 		// Set unchanged attributes
 
- 		$photo['id']     = $data['id'];
 
- 		$photo['title']  = $data['title'];
 
- 		$photo['tags']   = $data['tags'];
 
- 		$photo['public'] = $data['public'];
 
- 		$photo['star']   = $data['star'];
 
- 		$photo['album']  = $data['album'];
 
- 		// Parse urls
 
- 		$photo['thumbUrl'] = LYCHEE_URL_UPLOADS_THUMB . $data['thumbUrl'];
 
- 		$photo['url']      = LYCHEE_URL_UPLOADS_BIG . $data['url'];
 
- 		// Use takestamp as sysdate when possible
 
- 		if (isset($data['takestamp'])&&$data['takestamp']!=='0') {
 
- 			// Use takestamp
 
- 			$photo['cameraDate'] = '1';
 
- 			$photo['sysdate']    = date('d F Y', $data['takestamp']);
 
- 		} else {
 
- 			// Use sysstamp from the id
 
- 			$photo['cameraDate'] = '0';
 
- 			$photo['sysdate']    = date('d F Y', substr($data['id'], 0, -4));
 
- 		}
 
- 		return $photo;
 
- 	}
 
- 	/**
 
- 	 * @return array|false Returns an array with information about the photo or false on failure.
 
- 	 */
 
- 	public function get($albumID) {
 
- 		// Excepts the following:
 
- 		// (string) $albumID = Album which is currently visible to the user
 
- 		// Check dependencies
 
- 		Validator::required(isset($this->photoIDs), __METHOD__);
 
- 		// Call plugins
 
- 		Plugins::get()->activate(__METHOD__, 0, func_get_args());
 
- 		// Get photo
 
- 		$query  = Database::prepare(Database::get(), "SELECT * FROM ? WHERE id = '?' LIMIT 1", array(LYCHEE_TABLE_PHOTOS, $this->photoIDs));
 
- 		$photos = Database::execute(Database::get(), $query, __METHOD__, __LINE__);
 
- 		if ($photos===false) return false;
 
- 		// Get photo object
 
- 		$photo = $photos->fetch_assoc();
 
- 		// Photo not found?
 
- 		if ($photo===null) {
 
- 			Log::error(Database::get(), __METHOD__, __LINE__, 'Could not find specified photo');
 
- 			return false;
 
- 		}
 
- 		// Parse photo
 
- 		$photo['sysdate'] = date('d M. Y', substr($photo['id'], 0, -4));
 
- 		if (strlen($photo['takestamp'])>1) $photo['takedate'] = date('d M. Y', $photo['takestamp']);
 
- 		// Parse medium
 
- 		if ($photo['medium']==='1') $photo['medium'] = LYCHEE_URL_UPLOADS_MEDIUM . $photo['url'];
 
- 		else                        $photo['medium'] = '';
 
- 		// Parse paths
 
- 		$photo['url']      = LYCHEE_URL_UPLOADS_BIG . $photo['url'];
 
- 		$photo['thumbUrl'] = LYCHEE_URL_UPLOADS_THUMB . $photo['thumbUrl'];
 
- 		if ($albumID!='false') {
 
- 			// Only show photo as public when parent album is public
 
- 			// Check if parent album is not 'Unsorted'
 
- 			if ($photo['album']!=='0') {
 
- 				// Get album
 
- 				$query  = Database::prepare(Database::get(), "SELECT public FROM ? WHERE id = '?' LIMIT 1", array(LYCHEE_TABLE_ALBUMS, $photo['album']));
 
- 				$albums = Database::execute(Database::get(), $query, __METHOD__, __LINE__);
 
- 				if ($albums===false) return false;
 
- 				// Get album object
 
- 				$album = $albums->fetch_assoc();
 
- 				// Photo not found?
 
- 				if ($photo===null) {
 
- 					Log::error(Database::get(), __METHOD__, __LINE__, 'Could not find specified album');
 
- 					return false;
 
- 				}
 
- 				// Parse album
 
- 				$photo['public'] = ($album['public']==='1' ? '2' : $photo['public']);
 
- 			}
 
- 			$photo['original_album'] = $photo['album'];
 
- 			$photo['album']          = $albumID;
 
- 		}
 
- 		// Call plugins
 
- 		Plugins::get()->activate(__METHOD__, 1, func_get_args());
 
- 		return $photo;
 
- 	}
 
- 	/**
 
- 	 * Reads and parses information and metadata out of a photo.
 
- 	 * @return array Returns an array of photo information and metadata.
 
- 	 */
 
- 	public function getInfo($url) {
 
- 		// Functions returns information and metadata of a photo
 
- 		// Excepts the following:
 
- 		// (string) $url = Path to photo-file
 
- 		// Returns the following:
 
- 		// (array) $return
 
- 		// Call plugins
 
- 		Plugins::get()->activate(__METHOD__, 0, func_get_args());
 
- 		$iptcArray = array();
 
- 		$info      = getimagesize($url, $iptcArray);
 
- 		// General information
 
- 		$return['type']   = $info['mime'];
 
- 		$return['width']  = $info[0];
 
- 		$return['height'] = $info[1];
 
- 		// Size
 
- 		$size = filesize($url)/1024;
 
- 		if ($size>=1024) $return['size'] = round($size/1024, 1) . ' MB';
 
- 		else $return['size'] = round($size, 1) . ' KB';
 
- 		// IPTC Metadata Fallback
 
- 		$return['title']       = '';
 
- 		$return['description'] = '';
 
- 		// IPTC Metadata
 
- 		if(isset($iptcArray['APP13'])) {
 
- 			$iptcInfo = iptcparse($iptcArray['APP13']);
 
- 			if (is_array($iptcInfo)) {
 
- 				$temp = @$iptcInfo['2#105'][0];
 
- 				if (isset($temp)&&strlen($temp)>0) $return['title'] = $temp;
 
- 				$temp = @$iptcInfo['2#120'][0];
 
- 				if (isset($temp)&&strlen($temp)>0) $return['description'] = $temp;
 
- 				$temp = @$iptcInfo['2#005'][0];
 
- 				if (isset($temp)&&strlen($temp)>0&&$return['title']==='') $return['title'] = $temp;
 
- 			}
 
- 		}
 
- 		// EXIF Metadata Fallback
 
- 		$return['orientation'] = '';
 
- 		$return['iso']         = '';
 
- 		$return['aperture']    = '';
 
- 		$return['make']        = '';
 
- 		$return['model']       = '';
 
- 		$return['shutter']     = '';
 
- 		$return['focal']       = '';
 
- 		$return['takestamp']   = 0;
 
- 		// Read EXIF
 
- 		if ($info['mime']=='image/jpeg') $exif = @exif_read_data($url, 'EXIF', 0);
 
- 		else $exif = false;
 
- 		// EXIF Metadata
 
- 		if ($exif!==false) {
 
- 			if (isset($exif['Orientation'])) $return['orientation'] = $exif['Orientation'];
 
- 			else if (isset($exif['IFD0']['Orientation'])) $return['orientation'] = $exif['IFD0']['Orientation'];
 
- 			$temp = @$exif['ISOSpeedRatings'];
 
- 			if (isset($temp)) $return['iso'] = $temp;
 
- 			$temp = @$exif['COMPUTED']['ApertureFNumber'];
 
- 			if (isset($temp)) $return['aperture'] = $temp;
 
- 			$temp = @$exif['Make'];
 
- 			if (isset($temp)) $return['make'] = trim($temp);
 
- 			$temp = @$exif['Model'];
 
- 			if (isset($temp)) $return['model'] = trim($temp);
 
- 			$temp = @$exif['ExposureTime'];
 
- 			if (isset($temp)) $return['shutter'] = $exif['ExposureTime'] . ' s';
 
- 			$temp = @$exif['FocalLength'];
 
- 			if (isset($temp)) {
 
- 				if (strpos($temp, '/')!==FALSE) {
 
- 					$temp = explode('/', $temp, 2);
 
- 					$temp = $temp[0] / $temp[1];
 
- 					$temp = round($temp, 1);
 
- 					$return['focal'] = $temp . ' mm';
 
- 				}
 
- 				$return['focal'] = $temp . ' mm';
 
- 			}
 
- 			$temp = @$exif['DateTimeOriginal'];
 
- 			if (isset($temp)) $return['takestamp'] = strtotime($temp);
 
- 		}
 
- 		// Call plugins
 
- 		Plugins::get()->activate(__METHOD__, 1, func_get_args());
 
- 		return $return;
 
- 	}
 
- 	/**
 
- 	 * Starts a download of a photo.
 
- 	 * @return resource|boolean Sends a ZIP-file or returns false on failure.
 
- 	 */
 
- 	public function getArchive() {
 
- 		// Check dependencies
 
- 		Validator::required(isset($this->photoIDs), __METHOD__);
 
- 		// Call plugins
 
- 		Plugins::get()->activate(__METHOD__, 0, func_get_args());
 
- 		// Get photo
 
- 		$query  = Database::prepare(Database::get(), "SELECT title, url FROM ? WHERE id = '?' LIMIT 1", array(LYCHEE_TABLE_PHOTOS, $this->photoIDs));
 
- 		$photos = Database::execute(Database::get(), $query, __METHOD__, __LINE__);
 
- 		if ($photos===false) return false;
 
- 		// Get photo object
 
- 		$photo = $photos->fetch_object();
 
- 		// Photo not found?
 
- 		if ($photo===null) {
 
- 			Log::error(Database::get(), __METHOD__, __LINE__, 'Could not find specified photo');
 
- 			return false;
 
- 		}
 
- 		// Get extension
 
- 		$extension = getExtension($photo->url);
 
- 		if ($extension===false) {
 
- 			Log::error(Database::get(), __METHOD__, __LINE__, 'Invalid photo extension');
 
- 			return false;
 
- 		}
 
- 		// Illicit chars
 
- 		$badChars = array_merge(
 
- 			array_map('chr', range(0,31)),
 
- 			array("<", ">", ":", '"', "/", "\\", "|", "?", "*")
 
- 		);
 
- 		// Parse title
 
- 		if ($photo->title=='') $photo->title = 'Untitled';
 
- 		// Escape title
 
- 		$photo->title = str_replace($badChars, '', $photo->title);
 
- 		// Set headers
 
- 		header("Content-Type: application/octet-stream");
 
- 		header("Content-Disposition: attachment; filename=\"" . $photo->title . $extension . "\"");
 
- 		header("Content-Length: " . filesize(LYCHEE_UPLOADS_BIG . $photo->url));
 
- 		// Send file
 
- 		readfile(LYCHEE_UPLOADS_BIG . $photo->url);
 
- 		// Call plugins
 
- 		Plugins::get()->activate(__METHOD__, 1, func_get_args());
 
- 		return true;
 
- 	}
 
- 	/**
 
- 	 * Sets the title of a photo.
 
- 	 * @return boolean Returns true when successful.
 
- 	 */
 
- 	public function setTitle($title = 'Untitled') {
 
- 		// Check dependencies
 
- 		Validator::required(isset($this->photoIDs), __METHOD__);
 
- 		// Call plugins
 
- 		Plugins::get()->activate(__METHOD__, 0, func_get_args());
 
- 		// Set title
 
- 		$query  = Database::prepare(Database::get(), "UPDATE ? SET title = '?' WHERE id IN (?)", array(LYCHEE_TABLE_PHOTOS, $title, $this->photoIDs));
 
- 		$result = Database::execute(Database::get(), $query, __METHOD__, __LINE__);
 
- 		// Call plugins
 
- 		Plugins::get()->activate(__METHOD__, 1, func_get_args());
 
- 		if ($result===false) return false;
 
- 		return true;
 
- 	}
 
- 	/**
 
- 	 * Sets the description of a photo.
 
- 	 * @return boolean Returns true when successful.
 
- 	 */
 
- 	public function setDescription($description) {
 
- 		// Check dependencies
 
- 		Validator::required(isset($this->photoIDs), __METHOD__);
 
- 		// Call plugins
 
- 		Plugins::get()->activate(__METHOD__, 0, func_get_args());
 
- 		// Set description
 
- 		$query  = Database::prepare(Database::get(), "UPDATE ? SET description = '?' WHERE id IN ('?')", array(LYCHEE_TABLE_PHOTOS, $description, $this->photoIDs));
 
- 		$result = Database::execute(Database::get(), $query, __METHOD__, __LINE__);
 
- 		// Call plugins
 
- 		Plugins::get()->activate(__METHOD__, 1, func_get_args());
 
- 		if ($result===false) return false;
 
- 		return true;
 
- 	}
 
- 	/**
 
- 	 * Toggles the star property of a photo.
 
- 	 * @return boolean Returns true when successful.
 
- 	 */
 
- 	public function setStar() {
 
- 		// Check dependencies
 
- 		Validator::required(isset($this->photoIDs), __METHOD__);
 
- 		// Call plugins
 
- 		Plugins::get()->activate(__METHOD__, 0, func_get_args());
 
- 		// Init vars
 
- 		$error = false;
 
- 		// Get photos
 
- 		$query  = Database::prepare(Database::get(), "SELECT id, star FROM ? WHERE id IN (?)", array(LYCHEE_TABLE_PHOTOS, $this->photoIDs));
 
- 		$photos = Database::execute(Database::get(), $query, __METHOD__, __LINE__);
 
- 		if ($photos===false) return false;
 
- 		// For each photo
 
- 		while ($photo = $photos->fetch_object()) {
 
- 			// Invert star
 
- 			$star = ($photo->star==0 ? 1 : 0);
 
- 			// Set star
 
- 			$query  = Database::prepare(Database::get(), "UPDATE ? SET star = '?' WHERE id = '?'", array(LYCHEE_TABLE_PHOTOS, $star, $photo->id));
 
- 			$result = Database::execute(Database::get(), $query, __METHOD__, __LINE__);
 
- 			if ($result===false) $error = true;
 
- 		}
 
- 		// Call plugins
 
- 		Plugins::get()->activate(__METHOD__, 1, func_get_args());
 
- 		if ($error===true) return false;
 
- 		return true;
 
- 	}
 
- 	/**
 
- 	 * Checks if photo or parent album is public.
 
- 	 * @return integer 0 = Photo private and parent album private
 
- 	 *                 1 = Album public, but password incorrect
 
- 	 *                 2 = Photo public or album public and password correct
 
- 	 */
 
- 	public function getPublic($password) {
 
- 		// Check dependencies
 
- 		Validator::required(isset($this->photoIDs), __METHOD__);
 
- 		// Call plugins
 
- 		Plugins::get()->activate(__METHOD__, 0, func_get_args());
 
- 		// Get photo
 
- 		$query  = Database::prepare(Database::get(), "SELECT public, album FROM ? WHERE id = '?' LIMIT 1", array(LYCHEE_TABLE_PHOTOS, $this->photoIDs));
 
- 		$photos = Database::execute(Database::get(), $query, __METHOD__, __LINE__);
 
- 		if ($photos===false) return 0;
 
- 		// Get photo object
 
- 		$photo = $photos->fetch_object();
 
- 		// Photo not found?
 
- 		if ($photo===null) {
 
- 			Log::error(Database::get(), __METHOD__, __LINE__, 'Could not find specified photo');
 
- 			return false;
 
- 		}
 
- 		// Check if public
 
- 		if ($photo->public==='1') {
 
- 			// Photo public
 
- 			return 2;
 
- 		} else {
 
- 			// Check if album public
 
- 			$album = new Album($photo->album);
 
- 			$agP   = $album->getPublic();
 
- 			$acP   = $album->checkPassword($password);
 
- 			// Album public and password correct
 
- 			if ($agP===true&&$acP===true) return 2;
 
- 			// Album public, but password incorrect
 
- 			if ($agP===true&&$acP===false) return 1;
 
- 		}
 
- 		// Call plugins
 
- 		Plugins::get()->activate(__METHOD__, 1, func_get_args());
 
- 		// Photo private
 
- 		return 0;
 
- 	}
 
- 	/**
 
- 	 * Toggles the public property of a photo.
 
- 	 * @return boolean Returns true when successful.
 
- 	 */
 
- 	public function setPublic() {
 
- 		// Check dependencies
 
- 		Validator::required(isset($this->photoIDs), __METHOD__);
 
- 		// Call plugins
 
- 		Plugins::get()->activate(__METHOD__, 0, func_get_args());
 
- 		// Get public
 
- 		$query  = Database::prepare(Database::get(), "SELECT public FROM ? WHERE id = '?' LIMIT 1", array(LYCHEE_TABLE_PHOTOS, $this->photoIDs));
 
- 		$photos = Database::execute(Database::get(), $query, __METHOD__, __LINE__);
 
- 		if ($photos===false) return false;
 
- 		// Get photo object
 
- 		$photo = $photos->fetch_object();
 
- 		// Photo not found?
 
- 		if ($photo===null) {
 
- 			Log::error(Database::get(), __METHOD__, __LINE__, 'Could not find specified photo');
 
- 			return false;
 
- 		}
 
- 		// Invert public
 
- 		$public = ($photo->public==0 ? 1 : 0);
 
- 		// Set public
 
- 		$query  = Database::prepare(Database::get(), "UPDATE ? SET public = '?' WHERE id = '?'", array(LYCHEE_TABLE_PHOTOS, $public, $this->photoIDs));
 
- 		$result = Database::execute(Database::get(), $query, __METHOD__, __LINE__);
 
- 		// Call plugins
 
- 		Plugins::get()->activate(__METHOD__, 1, func_get_args());
 
- 		if ($result===false) return false;
 
- 		return true;
 
- 	}
 
- 	/**
 
- 	 * Sets the parent album of a photo.
 
- 	 * @return boolean Returns true when successful.
 
- 	 */
 
- 	function setAlbum($albumID) {
 
- 		// Check dependencies
 
- 		Validator::required(isset($this->photoIDs), __METHOD__);
 
- 		// Call plugins
 
- 		Plugins::get()->activate(__METHOD__, 0, func_get_args());
 
- 		// Set album
 
- 		$query  = Database::prepare(Database::get(), "UPDATE ? SET album = '?' WHERE id IN (?)", array(LYCHEE_TABLE_PHOTOS, $albumID, $this->photoIDs));
 
- 		$result = Database::execute(Database::get(), $query, __METHOD__, __LINE__);
 
- 		// Call plugins
 
- 		Plugins::get()->activate(__METHOD__, 1, func_get_args());
 
- 		if ($result===false) return false;
 
- 		return true;
 
- 	}
 
- 	/**
 
- 	 * Sets the tags of a photo.
 
- 	 * @return boolean Returns true when successful.
 
- 	 */
 
- 	public function setTags($tags) {
 
- 		// Excepts the following:
 
- 		// (string) $tags = Comma separated list of tags with a maximum length of 1000 chars
 
- 		// Check dependencies
 
- 		Validator::required(isset($this->photoIDs), __METHOD__);
 
- 		// Call plugins
 
- 		Plugins::get()->activate(__METHOD__, 0, func_get_args());
 
- 		// Parse tags
 
- 		$tags = preg_replace('/(\ ,\ )|(\ ,)|(,\ )|(,{1,}\ {0,})|(,$|^,)/', ',', $tags);
 
- 		$tags = preg_replace('/,$|^,|(\ ){0,}$/', '', $tags);
 
- 		// Set tags
 
- 		$query  = Database::prepare(Database::get(), "UPDATE ? SET tags = '?' WHERE id IN (?)", array(LYCHEE_TABLE_PHOTOS, $tags, $this->photoIDs));
 
- 		$result = Database::execute(Database::get(), $query, __METHOD__, __LINE__);
 
- 		// Call plugins
 
- 		Plugins::get()->activate(__METHOD__, 1, func_get_args());
 
- 		if ($result===false) return false;
 
- 		return true;
 
- 	}
 
- 	/**
 
- 	 * Duplicates a photo.
 
- 	 * @return boolean Returns true when successful.
 
- 	 */
 
- 	public function duplicate() {
 
- 		// Check dependencies
 
- 		Validator::required(isset($this->photoIDs), __METHOD__);
 
- 		// Call plugins
 
- 		Plugins::get()->activate(__METHOD__, 0, func_get_args());
 
- 		// Init vars
 
- 		$error = false;
 
- 		// Get photos
 
- 		$query  = Database::prepare(Database::get(), "SELECT id, checksum FROM ? WHERE id IN (?)", array(LYCHEE_TABLE_PHOTOS, $this->photoIDs));
 
- 		$photos = Database::execute(Database::get(), $query, __METHOD__, __LINE__);
 
- 		if ($photos===false) return false;
 
- 		// For each photo
 
- 		while ($photo = $photos->fetch_object()) {
 
- 			// Generate id
 
- 			$id = generateID();
 
- 			// Duplicate entry
 
- 			$values = array(LYCHEE_TABLE_PHOTOS, $id, LYCHEE_TABLE_PHOTOS, $photo->id);
 
- 			$query  = Database::prepare(Database::get(), "INSERT INTO ? (id, title, url, description, tags, type, width, height, size, iso, aperture, make, model, shutter, focal, takestamp, thumbUrl, album, public, star, checksum) SELECT '?' AS id, title, url, description, tags, type, width, height, size, iso, aperture, make, model, shutter, focal, takestamp, thumbUrl, album, public, star, checksum FROM ? WHERE id = '?'", $values);
 
- 			$result = Database::execute(Database::get(), $query, __METHOD__, __LINE__);
 
- 			if ($result===false) $error = true;
 
- 		}
 
- 		if ($error===true) return false;
 
- 		return true;
 
- 	}
 
- 	/**
 
- 	 * Deletes a photo with all its data and files.
 
- 	 * @return boolean Returns true when successful.
 
- 	 */
 
- 	public function delete() {
 
- 		// Check dependencies
 
- 		Validator::required(isset($this->photoIDs), __METHOD__);
 
- 		// Call plugins
 
- 		Plugins::get()->activate(__METHOD__, 0, func_get_args());
 
- 		// Init vars
 
- 		$error = false;
 
- 		// Get photos
 
- 		$query  = Database::prepare(Database::get(), "SELECT id, url, thumbUrl, checksum FROM ? WHERE id IN (?)", array(LYCHEE_TABLE_PHOTOS, $this->photoIDs));
 
- 		$photos = Database::execute(Database::get(), $query, __METHOD__, __LINE__);
 
- 		if ($photos===false) return false;
 
- 		// For each photo
 
- 		while ($photo = $photos->fetch_object()) {
 
- 			// Check if other photos are referring to this images
 
- 			// If so, only delete the db entry
 
- 			if ($this->exists($photo->checksum, $photo->id)===false) {
 
- 				// Get retina thumb url
 
- 				$thumbUrl2x = explode(".", $photo->thumbUrl);
 
- 				$thumbUrl2x = $thumbUrl2x[0] . '@2x.' . $thumbUrl2x[1];
 
- 				// Delete big
 
- 				if (file_exists(LYCHEE_UPLOADS_BIG . $photo->url)&&!unlink(LYCHEE_UPLOADS_BIG . $photo->url)) {
 
- 					Log::error(Database::get(), __METHOD__, __LINE__, 'Could not delete photo in uploads/big/');
 
- 					$error = true;
 
- 				}
 
- 				// Delete medium
 
- 				if (file_exists(LYCHEE_UPLOADS_MEDIUM . $photo->url)&&!unlink(LYCHEE_UPLOADS_MEDIUM . $photo->url)) {
 
- 					Log::error(Database::get(), __METHOD__, __LINE__, 'Could not delete photo in uploads/medium/');
 
- 					$error = true;
 
- 				}
 
- 				// Delete thumb
 
- 				if (file_exists(LYCHEE_UPLOADS_THUMB . $photo->thumbUrl)&&!unlink(LYCHEE_UPLOADS_THUMB . $photo->thumbUrl)) {
 
- 					Log::error(Database::get(), __METHOD__, __LINE__, 'Could not delete photo in uploads/thumb/');
 
- 					$error = true;
 
- 				}
 
- 				// Delete thumb@2x
 
- 				if (file_exists(LYCHEE_UPLOADS_THUMB . $thumbUrl2x)&&!unlink(LYCHEE_UPLOADS_THUMB . $thumbUrl2x)) {
 
- 					Log::error(Database::get(), __METHOD__, __LINE__, 'Could not delete high-res photo in uploads/thumb/');
 
- 					$error = true;
 
- 				}
 
- 			}
 
- 			// Delete db entry
 
- 			$query  = Database::prepare(Database::get(), "DELETE FROM ? WHERE id = '?'", array(LYCHEE_TABLE_PHOTOS, $photo->id));
 
- 			$result = Database::execute(Database::get(), $query, __METHOD__, __LINE__);
 
- 			if ($result===false) $error = true;
 
- 		}
 
- 		// Call plugins
 
- 		Plugins::get()->activate(__METHOD__, 1, func_get_args());
 
- 		if ($error===true) return false;
 
- 		return true;
 
- 	}
 
- }
 
- ?>
 
 
  |