123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244 |
- <?php
- namespace Lychee\Modules;
- final class Settings extends Module {
- private static $cache = null;
- public static function get() {
- if (self::$cache) return self::$cache;
- # Execute query
- $query = Database::prepare(Database::get(), "SELECT * FROM ?", array(LYCHEE_TABLE_SETTINGS));
- $settings = Database::get()->query($query);
- # Add each to return
- while ($setting = $settings->fetch_object()) $return[$setting->key] = $setting->value;
- # Convert plugins to array
- $return['plugins'] = explode(';', $return['plugins']);
- self::$cache = $return;
- return $return;
- }
- private static function set($key, $value, $row = false) {
- if ($row===false) {
- $query = Database::prepare(Database::get(), "UPDATE ? SET value = '?' WHERE `key` = '?'", array(LYCHEE_TABLE_SETTINGS, $value, $key));
- } elseif ($row===true) {
- # Do not prepare $value because it has already been escaped or is a true statement
- $query = Database::prepare(Database::get(), "UPDATE ? SET value = '$value' WHERE `key` = '?'", array(LYCHEE_TABLE_SETTINGS, $key));
- } else {
- return false;
- }
- $result = Database::get()->query($query);
- if (!$result) return false;
- return true;
- }
- public static function setLogin($oldPassword = '', $username, $password) {
- # Check dependencies
- self::dependencies(isset($oldPassword, $username, $password));
- if ($oldPassword===self::get()['password']||self::get()['password']===crypt($oldPassword, self::get()['password'])) {
- # Save username
- if (self::setUsername($username)!==true) exit('Error: Updating username failed!');
- # Save password
- if (self::setPassword($password)!==true) exit('Error: Updating password failed!');
- return true;
- }
- exit('Error: Current password entered incorrectly!');
- }
- private static function setUsername($username) {
- # Check dependencies
- self::dependencies(isset($username));
- # Hash username
- $username = getHashedString($username);
- # Execute query
- # Do not prepare $username because it is hashed and save
- # Preparing (escaping) the username would destroy the hash
- if (self::set('username', $username, true)===false) {
- Log::error(__METHOD__, __LINE__, Database::get()->error);
- return false;
- }
- return true;
- }
- private static function setPassword($password) {
- # Check dependencies
- self::dependencies(isset($password));
- # Hash password
- $password = getHashedString($password);
- # Do not prepare $password because it is hashed and save
- # Preparing (escaping) the password would destroy the hash
- if (self::set('password', $password, true)===false) {
- Log::error(__METHOD__, __LINE__, Database::get()->error);
- return false;
- }
- return true;
- }
- public static function setDropboxKey($dropboxKey) {
- # Check dependencies
- self::dependencies(isset($dropboxKey));
- if (strlen($dropboxKey)<1||strlen($dropboxKey)>50) {
- Log::notice(__METHOD__, __LINE__, 'Dropbox key is either too short or too long');
- return false;
- }
- if (self::set('dropboxKey', $dropboxKey)===false) {
- Log::error(__METHOD__, __LINE__, Database::get()->error);
- return false;
- }
- return true;
- }
- public static function setSortingPhotos($type, $order) {
- # Check dependencies
- self::dependencies(isset($type, $order));
- $sorting = 'ORDER BY ';
- # Set row
- switch ($type) {
- case 'id': $sorting .= 'id';
- break;
- case 'title': $sorting .= 'title';
- break;
- case 'description': $sorting .= 'description';
- break;
- case 'public': $sorting .= 'public';
- break;
- case 'type': $sorting .= 'type';
- break;
- case 'star': $sorting .= 'star';
- break;
- case 'takestamp': $sorting .= 'takestamp';
- break;
- default: exit('Error: Unknown type for sorting!');
- }
- $sorting .= ' ';
- # Set order
- switch ($order) {
- case 'ASC': $sorting .= 'ASC';
- break;
- case 'DESC': $sorting .= 'DESC';
- break;
- default: exit('Error: Unknown order for sorting!');
- }
- # Do not prepare $sorting because it is a true statement
- # Preparing (escaping) the sorting would destroy it
- # $sorting is save and can't contain user-input
- if (self::set('sortingPhotos', $sorting, true)===false) {
- Log::error(__METHOD__, __LINE__, Database::get()->error);
- return false;
- }
- return true;
- }
- public static function setSortingAlbums($type, $order) {
- # Check dependencies
- self::dependencies(isset($type, $order));
- $sorting = 'ORDER BY ';
- # Set row
- switch ($type) {
- case 'id': $sorting .= 'id';
- break;
- case 'title': $sorting .= 'title';
- break;
- case 'description': $sorting .= 'description';
- break;
- case 'public': $sorting .= 'public';
- break;
- default: exit('Error: Unknown type for sorting!');
- }
- $sorting .= ' ';
- # Set order
- switch ($order) {
- case 'ASC': $sorting .= 'ASC';
- break;
- case 'DESC': $sorting .= 'DESC';
- break;
- default: exit('Error: Unknown order for sorting!');
- }
- # Do not prepare $sorting because it is a true statement
- # Preparing (escaping) the sorting would destroy it
- # $sorting is save and can't contain user-input
- if (self::set('sortingAlbums', $sorting, true)===false) {
- Log::error(__METHOD__, __LINE__, Database::get()->error);
- return false;
- }
- return true;
- }
- }
- ?>
|