= 1) to 1.4.0 */ if (!defined('PHPWG_ROOT_PATH')) { die ('This page cannot be loaded directly, load upgrade.php'); } else { if (!defined('PHPWG_IN_UPGRADE') or !PHPWG_IN_UPGRADE) { die ('Hacking attempt!'); } } // 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' ;", " ALTER TABLE phpwebgallery_categories ADD COLUMN commentable enum('true','false') NOT NULL default 'true' ;", " ALTER TABLE phpwebgallery_categories ADD COLUMN global_rank varchar(255) default NULL ;", " ALTER TABLE phpwebgallery_categories 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 ;", " ALTER TABLE phpwebgallery_favorites 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 '' ;", " ALTER TABLE phpwebgallery_images ADD COLUMN path varchar(255) NOT NULL default '' ;", " ALTER TABLE phpwebgallery_images ADD COLUMN date_metadata_update date default NULL ;", " ALTER TABLE phpwebgallery_images ADD COLUMN average_rate float(5,2) unsigned default NULL ;", " ALTER TABLE phpwebgallery_images ADD COLUMN representative_ext varchar(4) default NULL ;", " ALTER TABLE phpwebgallery_images DROP INDEX storage_category_id ;", " ALTER TABLE phpwebgallery_images ADD INDEX images_i1 (storage_category_id) ;", " ALTER TABLE phpwebgallery_images ADD INDEX images_i2 (date_available) ;", " ALTER TABLE phpwebgallery_images ADD INDEX images_i3 (average_rate) ;", " ALTER TABLE phpwebgallery_images ADD INDEX images_i4 (hit) ;", " ALTER TABLE phpwebgallery_images 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 ;", " ALTER TABLE phpwebgallery_sites ADD UNIQUE sites_ui1 (galleries_url) ;", " DROP TABLE phpwebgallery_user_category ;", " ALTER TABLE phpwebgallery_users DROP COLUMN long_period ;", " ALTER TABLE phpwebgallery_users DROP COLUMN short_period ;", " ALTER TABLE phpwebgallery_users ADD COLUMN recent_period tinyint(3) unsigned NOT NULL default '7' ;", " ALTER TABLE phpwebgallery_users DROP INDEX username ;", " ALTER TABLE phpwebgallery_users 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); } // // check indexes // $indexes_of = array( 'categories' => array( 'categories_i2' => array( 'columns' => array('id_uppercat'), 'unique' => false, ) ), 'image_category' => array( 'image_category_i1' => array( 'columns' => array('image_id'), 'unique' => false, ), 'image_category_i2' => array( 'columns' => array('category_id'), 'unique' => false, ), ), ); foreach (array_keys($indexes_of) as $table) { $existing_indexes = array(); $query = ' SHOW INDEX FROM '.PREFIX_TABLE.$table.' ;'; $result = pwg_query($query); while ($row = mysql_fetch_array($result)) { if ($row['Key_name'] != 'PRIMARY') { if (!in_array($row['Key_name'], array_keys($indexes_of[$table]))) { $query = ' ALTER TABLE '.PREFIX_TABLE.$table.' DROP INDEX '.$row['Key_name'].' ;'; pwg_query($query); } else { array_push($existing_indexes, $row['Key_name']); } } } foreach ($indexes_of[$table] as $index_name => $index) { if (!in_array($index_name, $existing_indexes)) { $query = ' ALTER TABLE '.PREFIX_TABLE.$table.' ADD '.($index['unique'] ? 'UNIQUE' : 'INDEX').' ' .$index_name.' ('.implode(',', $index['columns']).') ;'; pwg_query($query); } } } // // insert params in new configuration table // $params = array( array( 'param' => 'prefix_thumbnail', 'value' => $save['prefix_thumbnail'], 'comment' => 'thumbnails filename prefix' ), array( 'param' => 'mail_webmaster', 'value' => $save['mail_webmaster'], 'comment' => 'webmaster mail' ), array( 'param' => 'default_language', 'value' => 'en_UK.iso-8859-1', 'comment' => 'Default gallery language' ), array( 'param' => 'default_template', 'value' => 'default', 'comment' => 'Default gallery style' ), array( 'param' => 'default_maxwidth', 'value' => '', 'comment' => 'maximum width authorized for displaying images' ), array( 'param' => 'default_maxheight', 'value' => '', 'comment' => 'maximum height authorized for the displaying images' ), array( 'param' => 'nb_comment_page', 'value' => '10', 'comment' => 'number of comments to display on each page' ), array( 'param' => 'upload_maxfilesize', 'value' => '150', 'comment' => 'maximum filesize for the uploaded pictures' ), array( 'param' => 'upload_maxwidth', 'value' => '800', 'comment' => 'maximum width authorized for the uploaded images' ), array( 'param' => 'upload_maxheight', 'value' => '600', 'comment' => 'maximum height authorized for the uploaded images' ), array( 'param' => 'upload_maxwidth_thumbnail', 'value' => '150', 'comment' => 'maximum width authorized for the uploaded thumbnails' ), array( 'param' => 'upload_maxheight_thumbnail', 'value' => '100', 'comment' => 'maximum height authorized for the uploaded thumbnails' ), array( 'param' => 'log', 'value' => 'false', 'comment' => 'keep an history of visits on your website' ), array( 'param' => 'comments_validation', 'value' => 'false', 'comment' => 'administrators validate users comments before becoming visible' ), array( 'param' => 'comments_forall', 'value' => 'false', 'comment' => 'even guest not registered can post comments' ), array( 'param' => 'mail_notification', 'value' => 'false', 'comment' => 'automated mail notification for adminsitrators' ), array( 'param' => 'nb_image_line', 'value' => '5', 'comment' => 'Number of images displayed per row' ), array( 'param' => 'nb_line_page', 'value' => '3', 'comment' => 'Number of rows displayed per page' ), array( 'param' => 'recent_period', 'value' => '7', 'comment' => 'Period within which pictures are displayed as new (in days)' ), array( 'param' => 'auto_expand', 'value' => 'false', 'comment' => 'Auto expand of the category tree' ), array( 'param' => 'show_nb_comments', 'value' => 'false', 'comment' => 'Show the number of comments under the thumbnails' ), array( 'param' => 'use_iptc', 'value' => 'false', 'comment' => 'Use IPTC data during database synchronization with files metadata' ), array( 'param' => 'use_exif', 'value' => 'false', 'comment' => 'Use EXIF data during database synchronization with files metadata' ), array( 'param' => 'show_iptc', 'value' => 'false', 'comment' => 'Show IPTC metadata on picture.php if asked by user' ), array( 'param' => 'show_exif', 'value' => 'true', 'comment' => 'Show EXIF metadata on picture.php if asked by user' ), array( 'param' => 'authorize_remembering', 'value' => 'true', 'comment' => 'Authorize users to be remembered, see $conf{remember_me_length}' ), array( 'param' => 'gallery_locked', 'value' => 'false', 'comment' => 'Lock your gallery temporary for non admin users' ), ); mass_inserts( CONFIG_TABLE, array_keys($params[0]), $params ); // refresh calculated datas update_global_rank(); update_category(); // 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); } // 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); } $page['infos'] = array_merge( $page['infos'], array( 'all sub-categories of private categories become private', '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
?>
insert
define(\'PHPWG_INSTALLED\', true);
' ) ); // now we upgrade from 1.4.0 include_once(PHPWG_ROOT_PATH.'install/upgrade_1.4.0.php'); ?>