diff options
Diffstat (limited to 'install/db/123-database.php')
| -rw-r--r-- | install/db/123-database.php | 218 |
1 files changed, 218 insertions, 0 deletions
diff --git a/install/db/123-database.php b/install/db/123-database.php new file mode 100644 index 000000000..af3c21234 --- /dev/null +++ b/install/db/123-database.php @@ -0,0 +1,218 @@ +<?php +// +-----------------------------------------------------------------------+ +// | Piwigo - a PHP based photo gallery | +// +-----------------------------------------------------------------------+ +// | Copyright(C) 2008-2012 Piwigo Team http://piwigo.org | +// | Copyright(C) 2003-2008 PhpWebGallery Team http://phpwebgallery.net | +// | Copyright(C) 2002-2003 Pierrick LE GALL http://le-gall.net/pierrick | +// +-----------------------------------------------------------------------+ +// | This program is free software; you can redistribute it and/or modify | +// | it under the terms of the GNU General Public License as published by | +// | the Free Software Foundation | +// | | +// | This program is distributed in the hope that it will be useful, but | +// | WITHOUT ANY WARRANTY; without even the implied warranty of | +// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU | +// | General Public License for more details. | +// | | +// | You should have received a copy of the GNU General Public License | +// | along with this program; if not, write to the Free Software | +// | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, | +// | USA. | +// +-----------------------------------------------------------------------+ + +if (!defined('PHPWG_ROOT_PATH')) +{ + die('Hacking attempt!'); +} + +$upgrade_description = 'convert 2.3 resize settings into 2.4 derivative settings'; + +include_once(PHPWG_ROOT_PATH.'include/constants.php'); + +$dbconf = array(); +$conf_orig = $conf; +load_conf_from_db(); +$dbconf = $conf; +$conf = $conf_orig; + +// +// Piwigo 2.3 "HD resize" settings become "original resize" settings in Piwigo 2.4 +// + +if ($dbconf['upload_form_hd_keep']) +{ + if ($dbconf['upload_form_hd_resize']) + { + conf_update_param('original_resize', 'true'); + conf_update_param('original_resize_maxwidth', $dbconf['upload_form_hd_maxwidth']); + conf_update_param('original_resize_maxheight', $dbconf['upload_form_hd_maxheight']); + conf_update_param('original_resize_quality', $dbconf['upload_form_hd_quality']); + } +} +else +{ + // The user has decided to remove the high quality. In Piwigo 2.4, this + // setting does not exists anymore, but we can simulate it by an original + // resize with 2.3 websize dimensions + conf_update_param('original_resize', 'true'); + + conf_update_param( + 'original_resize_maxwidth', + is_numeric($dbconf['upload_form_websize_maxwidth']) ? $dbconf['upload_form_websize_maxwidth'] : 800 + ); + + conf_update_param( + 'original_resize_maxheight', + is_numeric($dbconf['upload_form_websize_maxheight']) ? $dbconf['upload_form_websize_maxheight'] : 600 + ); + + conf_update_param('original_resize_quality', $dbconf['upload_form_hd_quality']); +} + +$types = ImageStdParams::get_default_sizes(); + +// +// Piwigo 2.3 "thumbnail" becomes "thumb" size in Piwigo 2.4 +// + +$thumb_width_min = 128; // the default value in Piwigo 2.3 +$thumb_width_max = 300; // slightly bigger than XXS default maxwidth +$thumb_height_min = 96; // the default value in Piwigo 2.3 +$thumb_height_max = 300; // slightly bigger than XXS default maxheight + +$thumb_is_square = false; +if ($dbconf['upload_form_thumb_crop']) +{ + if ($dbconf['upload_form_thumb_maxwidth'] == $dbconf['upload_form_thumb_maxheight']) + { + $thumb_is_square = true; + } +} + +if ($dbconf['upload_form_thumb_maxwidth'] < $thumb_width_min) +{ + $dbconf['upload_form_thumb_maxwidth'] = $thumb_width_min; +} + +if ($dbconf['upload_form_thumb_maxwidth'] > $thumb_width_max) +{ + $dbconf['upload_form_thumb_maxwidth'] = $thumb_width_max; +} + +if ($dbconf['upload_form_thumb_maxheight'] < $thumb_height_min) +{ + $dbconf['upload_form_thumb_maxheight'] = $thumb_height_min; +} + +if ($dbconf['upload_form_thumb_maxheight'] > $thumb_height_max) +{ + $dbconf['upload_form_thumb_maxheight'] = $thumb_height_max; +} + +if ($thumb_is_square) +{ + $dbconf['upload_form_thumb_maxheight'] = $dbconf['upload_form_thumb_maxwidth']; +} + +$size = array($dbconf['upload_form_thumb_maxwidth'], $dbconf['upload_form_thumb_maxheight']); + +$thumb = new DerivativeParams( + new SizingParams( + $size, + $dbconf['upload_form_thumb_crop'] ? 1 : 0, + $dbconf['upload_form_thumb_crop'] ? $size : null + ) + ); + +$types[IMG_THUMB] = $thumb; + +// slightly enlarge XSS to be bigger than thumbnail size (but smaller than XS) +if ($dbconf['upload_form_thumb_maxwidth'] >= $types[IMG_XXSMALL]->sizing->ideal_size[0] + or $dbconf['upload_form_thumb_maxheight'] >= $types[IMG_XXSMALL]->sizing->ideal_size[1]) +{ + $xxs_maxwidth = $types[IMG_XXSMALL]->sizing->ideal_size[0]; + if ($dbconf['upload_form_thumb_maxwidth'] >= $xxs_maxwidth) + { + $xxs_maxwidth = 350; + } + + $xxs_maxheight = $types[IMG_XXSMALL]->sizing->ideal_size[1]; + if ($dbconf['upload_form_thumb_maxheight'] >= $xxs_maxheight) + { + $xxs_maxheight = 310; + } + + $xxs = new DerivativeParams(new SizingParams(array($xxs_maxwidth, $xxs_maxheight))); + + $types[IMG_XXSMALL] = $xxs; +} + +// +// Piwigo 2.3 "websize" becomes "medium" size in Piwigo 2.4 +// + +// if there was no "websize resize" on Piwigo 2.3, we can't take the resize +// settings into account, we keep the default settings of Piwigo 2.4. +if ($dbconf['upload_form_websize_resize']) +{ + $medium_width_min = 577; // default S maxwidth + 1 pixel + $medium_width_max = 1007; // default L maxwidth - 1 pixel + $medium_height_min = 433; // default S maxheight + 1 pixel + $medium_height_max = 755; // default L maxheight - 1 pixel + + // width + if (!is_numeric($dbconf['upload_form_websize_maxwidth'])) // sometimes maxwidth="false" + { + $dbconf['upload_form_websize_maxwidth'] = $medium_width_max; + } + + if ($dbconf['upload_form_websize_maxwidth'] < $medium_width_min) + { + $dbconf['upload_form_websize_maxwidth'] = $medium_width_min; + } + + if ($dbconf['upload_form_websize_maxwidth'] > $medium_width_max) + { + $dbconf['upload_form_websize_maxwidth'] = $medium_width_max; + } + + // height + if (!is_numeric($dbconf['upload_form_websize_maxheight'])) // sometimes maxheight="false" + { + $dbconf['upload_form_websize_maxheight'] = $medium_height_max; + } + + if ($dbconf['upload_form_websize_maxheight'] < $medium_height_min) + { + $dbconf['upload_form_websize_maxheight'] = $medium_height_min; + } + + if ($dbconf['upload_form_websize_maxheight'] > $medium_height_max) + { + $dbconf['upload_form_websize_maxheight'] = $medium_height_max; + } + + $medium = new DerivativeParams( + new SizingParams( + array( + $dbconf['upload_form_websize_maxwidth'], + $dbconf['upload_form_websize_maxheight'] + ) + ) + ); + + $types[IMG_MEDIUM] = $medium; +} + +// +// Save derivative new settings +// + +ImageStdParams::set_and_save($types); + +pwg_query('DELETE FROM '.CONFIG_TABLE.' WHERE param = \'disabled_derivatives\''); +clear_derivative_cache(); + +echo "\n".$upgrade_description."\n"; +?>
\ No newline at end of file |