123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255 |
- <?php
- ###
- # @name Settings Module
- # @copyright 2015 by Tobias Reich
- ###
- if (!defined('LYCHEE')) exit('Error: Direct access is not allowed!');
- class Settings extends Module {
- private $database = null;
- public function __construct($database) {
- # Init vars
- $this->database = $database;
- return true;
- }
- public function get() {
- # Check dependencies
- self::dependencies(isset($this->database));
- # Execute query
- $query = Database::prepare($this->database, "SELECT * FROM ?", array(LYCHEE_TABLE_SETTINGS));
- $settings = $this->database->query($query);
- # Add each to return
- while ($setting = $settings->fetch_object()) $return[$setting->key] = $setting->value;
- # Fallback for versions below v2.5
- if (!isset($return['plugins'])) $return['plugins'] = '';
- return $return;
- }
- public function setLogin($oldPassword = '', $username, $password) {
- # Check dependencies
- self::dependencies(isset($this->database));
- # Load settings
- $settings = $this->get();
- if ($oldPassword===$settings['password']||$settings['password']===crypt($oldPassword, $settings['password'])) {
- # Save username
- if ($this->setUsername($username)!==true) exit('Error: Updating username failed!');
- # Save password
- if ($this->setPassword($password)!==true) exit('Error: Updating password failed!');
- return true;
- }
- exit('Error: Current password entered incorrectly!');
- }
- private function setUsername($username) {
- # Check dependencies
- self::dependencies(isset($this->database));
- # 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
- $query = Database::prepare($this->database, "UPDATE ? SET value = '$username' WHERE `key` = 'username'", array(LYCHEE_TABLE_SETTINGS));
- $result = $this->database->query($query);
- if (!$result) {
- Log::error($this->database, __METHOD__, __LINE__, $this->database->error);
- return false;
- }
- return true;
- }
- private function setPassword($password) {
- # Check dependencies
- self::dependencies(isset($this->database));
- # Hash password
- $password = getHashedString($password);
- # Execute query
- # Do not prepare $password because it is hashed and save
- # Preparing (escaping) the password would destroy the hash
- $query = Database::prepare($this->database, "UPDATE ? SET value = '$password' WHERE `key` = 'password'", array(LYCHEE_TABLE_SETTINGS));
- $result = $this->database->query($query);
- if (!$result) {
- Log::error($this->database, __METHOD__, __LINE__, $this->database->error);
- return false;
- }
- return true;
- }
- public function setDropboxKey($key) {
- # Check dependencies
- self::dependencies(isset($this->database, $key));
- if (strlen($key)<1||strlen($key)>50) {
- Log::notice($this->database, __METHOD__, __LINE__, 'Dropbox key is either too short or too long');
- return false;
- }
- # Execute query
- $query = Database::prepare($this->database, "UPDATE ? SET value = '?' WHERE `key` = 'dropboxKey'", array(LYCHEE_TABLE_SETTINGS, $key));
- $result = $this->database->query($query);
- if (!$result) {
- Log::error($this->database, __METHOD__, __LINE__, $this->database->error);
- return false;
- }
- return true;
- }
- public function setSortingPhotos($type, $order) {
- # Check dependencies
- self::dependencies(isset($this->database, $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!');
- }
- # Execute query
- # 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
- $query = Database::prepare($this->database, "UPDATE ? SET value = '$sorting' WHERE `key` = 'sortingPhotos'", array(LYCHEE_TABLE_SETTINGS));
- $result = $this->database->query($query);
- if (!$result) {
- Log::error($this->database, __METHOD__, __LINE__, $this->database->error);
- return false;
- }
- return true;
- }
- public function setSortingAlbums($type, $order) {
- # Check dependencies
- self::dependencies(isset($this->database, $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!');
- }
- # Execute query
- # 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
- $query = Database::prepare($this->database, "UPDATE ? SET value = '$sorting' WHERE `key` = 'sortingAlbums'", array(LYCHEE_TABLE_SETTINGS));
- $result = $this->database->query($query);
- if (!$result) {
- Log::error($this->database, __METHOD__, __LINE__, $this->database->error);
- return false;
- }
- return true;
- }
- }
- ?>
|