diff options
Diffstat (limited to 'install/upgrade_1.3.0.php')
| -rw-r--r-- | install/upgrade_1.3.0.php | 401 |
1 files changed, 0 insertions, 401 deletions
diff --git a/install/upgrade_1.3.0.php b/install/upgrade_1.3.0.php deleted file mode 100644 index 430a14ed0..000000000 --- a/install/upgrade_1.3.0.php +++ /dev/null @@ -1,401 +0,0 @@ -<?php -// +-----------------------------------------------------------------------+ -// | PhpWebGallery - a PHP based picture gallery | -// | Copyright (C) 2002-2003 Pierrick LE GALL - pierrick@phpwebgallery.net | -// | Copyright (C) 2003-2005 PhpWebGallery Team - http://phpwebgallery.net | -// +-----------------------------------------------------------------------+ -// | branch : BSF (Best So Far) -// | file : $RCSfile$ -// | last update : $Date$ -// | last modifier : $Author$ -// | revision : $Revision$ -// +-----------------------------------------------------------------------+ -// | 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('IN_UPGRADE') or !IN_UPGRADE) -{ - die('Hacking attempt!'); -} - -$last_time = get_moment(); - -// save data before deletion -$query = ' -SELECT prefix_thumbnail, mail_webmaster - FROM '.PREFIX_TABLE.'config -;'; -$save = mysql_fetch_array(mysql_query($query)); - -$queries = array( - " -DROP TABLE phpwebgallery_config -;", - - " -CREATE TABLE phpwebgallery_config ( - param varchar(40) NOT NULL default '', - value varchar(255) default NULL, - comment varchar(255) default NULL, - PRIMARY KEY (param) -) TYPE=MyISAM COMMENT='configuration table' -;", - - " -ALTER TABLE phpwebgallery_categories - CHANGE COLUMN site_id site_id tinyint(4) unsigned default '1', - ADD COLUMN commentable enum('true','false') NOT NULL default 'true', - ADD COLUMN uppercats varchar(255) NOT NULL default '', - ADD COLUMN global_rank varchar(255) default NULL, - ADD INDEX categories_i2 (id_uppercat) -;", - - " -ALTER TABLE phpwebgallery_comments - ADD COLUMN date_temp int(11) unsigned -;", - - " -UPDATE phpwebgallery_comments - SET date_temp = date -;", - - " -ALTER TABLE phpwebgallery_comments - CHANGE COLUMN date date datetime NOT NULL default '0000-00-00 00:00:00' -;", - - " -UPDATE phpwebgallery_comments - SET date = FROM_UNIXTIME(date_temp) -;", - - " -ALTER TABLE phpwebgallery_comments - DROP COLUMN date_temp -;", - - " -ALTER TABLE phpwebgallery_favorites - DROP INDEX user_id, - ADD PRIMARY KEY (user_id,image_id) -;", - - " -ALTER TABLE phpwebgallery_history - ADD COLUMN date_temp int(11) unsigned -;", - - " -UPDATE phpwebgallery_history - SET date_temp = date -;", - - " -ALTER TABLE phpwebgallery_history - CHANGE COLUMN date date datetime NOT NULL default '0000-00-00 00:00:00' -;", - - " -UPDATE phpwebgallery_history - SET date = FROM_UNIXTIME(date_temp) -;", - - " -ALTER TABLE phpwebgallery_history - DROP COLUMN date_temp -;", - - " -ALTER TABLE phpwebgallery_history - ADD INDEX history_i1 (date) -;", - - " -ALTER TABLE phpwebgallery_image_category - ADD INDEX image_category_i1 (image_id), - ADD INDEX image_category_i2 (category_id) -;", - - " -ALTER TABLE phpwebgallery_images - CHANGE COLUMN tn_ext tn_ext varchar(4) default '', - ADD COLUMN path varchar(255) NOT NULL default '', - ADD COLUMN date_metadata_update date default NULL, - ADD COLUMN average_rate float(5,2) unsigned default NULL, - ADD COLUMN representative_ext varchar(4) default NULL, - DROP INDEX storage_category_id, - ADD INDEX images_i1 (storage_category_id), - ADD INDEX images_i2 (date_available), - ADD INDEX images_i3 (average_rate), - ADD INDEX images_i4 (hit), - ADD INDEX images_i5 (date_creation) -;", - - " -ALTER TABLE phpwebgallery_sessions - DROP COLUMN ip -;", - - " -ALTER TABLE phpwebgallery_sessions - ADD COLUMN expiration_temp int(11) unsigned -;", - - " -UPDATE phpwebgallery_sessions - SET expiration_temp = expiration -;", - - " -ALTER TABLE phpwebgallery_sessions - CHANGE COLUMN expiration expiration datetime NOT NULL default '0000-00-00 00:00:00' -;", - - " -UPDATE phpwebgallery_sessions - SET expiration = FROM_UNIXTIME(expiration_temp) -;", - - " -ALTER TABLE phpwebgallery_sessions - DROP COLUMN expiration_temp -;", - - " -ALTER TABLE phpwebgallery_sites - DROP INDEX galleries_url, - ADD UNIQUE sites_ui1 (galleries_url) -;", - - " -ALTER TABLE phpwebgallery_users - DROP COLUMN long_period, - DROP COLUMN short_period, - ADD COLUMN recent_period tinyint(3) unsigned NOT NULL default '7', - DROP INDEX username, - ADD UNIQUE users_ui1 (username) -;", - - " -CREATE TABLE phpwebgallery_rate ( - user_id smallint(5) unsigned NOT NULL default '0', - element_id mediumint(8) unsigned NOT NULL default '0', - rate tinyint(2) unsigned NOT NULL default '0', - PRIMARY KEY (user_id,element_id) -) TYPE=MyISAM -;", - - " -CREATE TABLE phpwebgallery_user_forbidden ( - user_id smallint(5) unsigned NOT NULL default '0', - need_update enum('true','false') NOT NULL default 'true', - forbidden_categories text, - PRIMARY KEY (user_id) -) TYPE=MyISAM -;", - - " -UPDATE phpwebgallery_users - SET language = 'en_UK.iso-8859-1' - , template = 'default' -;", - - " -DELETE FROM phpwebgallery_user_access -;", - - " -DELETE FROM phpwebgallery_group_access -;" - - ); - -foreach ($queries as $query) -{ - $query = str_replace('phpwebgallery_', PREFIX_TABLE, $query); - pwg_query($query); -} - -$new_time = get_moment(); -echo '<pre>['.get_elapsed_time($last_time, $new_time).']'; -echo ' Basic database structure upgrade done</pre>'; -flush(); -$last_time = $new_time; - -execute_sqlfile(PHPWG_ROOT_PATH.'install/config.sql', - 'phpwebgallery_', - PREFIX_TABLE); - -$queries = array( - " -UPDATE phpwebgallery_config - SET value = '".$save['prefix_thumbnail']."' - WHERE param = 'prefix_thumbnail' -;", - - " -UPDATE phpwebgallery_config - SET value = '".$save['mail_webmaster']."' - WHERE param = 'mail_webmaster' -;" - ); - -foreach ($queries as $query) -{ - $query = str_replace('phpwebgallery_', PREFIX_TABLE, $query); - pwg_query($query); -} - -$new_time = get_moment(); -echo '<pre>['.get_elapsed_time($last_time, $new_time).']'; -echo ' Saved configuration information restored</pre>'; -flush(); -$last_time = $new_time; - -// filling the new column categories.uppercats -$id_uppercats = array(); - -$query = ' -SELECT id, id_uppercat - FROM '.CATEGORIES_TABLE.' -;'; -$result = pwg_query($query); -while ($row = mysql_fetch_array($result)) -{ - if (!isset($row['id_uppercat']) or $row['id_uppercat'] == '') - { - $row['id_uppercat'] = 'NULL'; - } - $id_uppercats[$row['id']] = $row['id_uppercat']; -} - -$datas = array(); - -foreach (array_keys($id_uppercats) as $id) -{ - $data = array(); - $data['id'] = $id; - $uppercats = array(); - - array_push($uppercats, $id); - while (isset($id_uppercats[$id]) and $id_uppercats[$id] != 'NULL') - { - array_push($uppercats, $id_uppercats[$id]); - $id = $id_uppercats[$id]; - } - $data['uppercats'] = implode(',', array_reverse($uppercats)); - - array_push($datas, $data); -} - -$fields = array('primary' => array('id'), 'update' => array('uppercats')); -mass_updates(CATEGORIES_TABLE, $fields, $datas); - -$new_time = get_moment(); -echo '<pre>['.get_elapsed_time($last_time, $new_time).']'; -echo ' filling the new column categories.uppercats</pre>'; -flush(); -$last_time = $new_time; - -// refresh calculated datas -ordering(); -update_global_rank(); -update_category(); - -$new_time = get_moment(); -echo '<pre>['.get_elapsed_time($last_time, $new_time).']'; -echo ' Calculated data updated (categories.rank, categories.global_rank, -categories.date_last, categories.representative_picture_id, -categories.nb_images)</pre>'; -flush(); -$last_time = $new_time; - -// update calculated field "images.path" -$cat_ids = array(); - -$query = ' -SELECT DISTINCT(storage_category_id) AS unique_storage_category_id - FROM '.IMAGES_TABLE.' -;'; -$result = pwg_query($query); -while ($row = mysql_fetch_array($result)) -{ - array_push($cat_ids, $row['unique_storage_category_id']); -} -$fulldirs = get_fulldirs($cat_ids); - -foreach ($cat_ids as $cat_id) -{ - $query = ' -UPDATE '.IMAGES_TABLE.' - SET path = CONCAT(\''.$fulldirs[$cat_id].'\',\'/\',file) - WHERE storage_category_id = '.$cat_id.' -;'; - pwg_query($query); -} - -$new_time = get_moment(); -echo '<pre>['.get_elapsed_time($last_time, $new_time).']'; -echo ' new column images.path filled</pre>'; -flush(); -$last_time = $new_time; - -// all sub-categories of private categories become private -$cat_ids = array(); - -$query = ' -SELECT id - FROM '.CATEGORIES_TABLE.' - WHERE status = \'private\' -;'; -$result = pwg_query($query); -while ($row = mysql_fetch_array($result)) -{ - array_push($cat_ids, $row['id']); -} - -if (count($cat_ids) > 0) -{ - $privates = get_subcat_ids($cat_ids); - - $query = ' -UPDATE '.CATEGORIES_TABLE.' - SET status = \'private\' - WHERE id IN ('.implode(',', $privates).') -;'; - pwg_query($query); -} - -$new_time = get_moment(); -echo '<pre>['.get_elapsed_time($last_time, $new_time).']'; -echo ' all sub-categories of private categories become private</pre>'; -flush(); -$last_time = $new_time; - -$infos = array( - 'user permissions and group permissions have been erased', - - 'only thumbnails prefix and webmaster mail address have been saved from -previous configuration', - - 'in include/mysql.inc.php, before -<pre style="background-color:lightgray">?></pre> -insert -<pre style="background-color:lightgray">define(\'PHPWG_INSTALLED\', true);<pre>' - - ); - -?>
\ No newline at end of file |