From c55dbbc995e152af3f2c88662101b0643d2e171a Mon Sep 17 00:00:00 2001
From: vdigital <vdigital@piwigo.org>
Date: Fri, 23 May 2008 22:38:14 +0000
Subject: Removed file/folder

git-svn-id: http://piwigo.org/svn/trunk@2358 68402e56-0260-453c-a942-63ccdbb3a9ee
---
 BSF/install/upgrade_1.6.2.php | 346 ------------------------------------------
 1 file changed, 346 deletions(-)
 delete mode 100644 BSF/install/upgrade_1.6.2.php

(limited to 'BSF/install/upgrade_1.6.2.php')

diff --git a/BSF/install/upgrade_1.6.2.php b/BSF/install/upgrade_1.6.2.php
deleted file mode 100644
index af5789b1c..000000000
--- a/BSF/install/upgrade_1.6.2.php
+++ /dev/null
@@ -1,346 +0,0 @@
-<?php
-// +-----------------------------------------------------------------------+
-// | Piwigo - a PHP based picture gallery                                  |
-// +-----------------------------------------------------------------------+
-// | Copyright(C) 2008      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 ('This page cannot be loaded directly, load upgrade.php');
-}
-else
-{
-  if (!defined('PHPWG_IN_UPGRADE') or !PHPWG_IN_UPGRADE)
-  {
-    die ('Hacking attempt!');
-  }
-}
-
-$queries = array(
-"
-ALTER TABLE `".PREFIX_TABLE."categories`
-  ADD COLUMN `permalink` varchar(64) default NULL
-;",
-
-"
-ALTER TABLE `".PREFIX_TABLE."categories`
-  ADD COLUMN `image_order` varchar(128) default NULL
-;",
-
-"
-ALTER TABLE `".PREFIX_TABLE."categories`
-  ADD UNIQUE `categories_i3` (`permalink`)
-;",
-
-"
-ALTER TABLE `".PREFIX_TABLE."groups`
-  ADD COLUMN `is_default` enum('true','false') NOT NULL default 'false'
-;",
-
-"
-RENAME TABLE `".PREFIX_TABLE."history` TO `".PREFIX_TABLE."history_backup`
-;",
-
-"
-CREATE TABLE `".PREFIX_TABLE."history` (
-  `id` int(10) unsigned NOT NULL auto_increment,
-  `date` date NOT NULL default '0000-00-00',
-  `time` time NOT NULL default '00:00:00',
-  `year` smallint(4) NOT NULL default '0',
-  `month` tinyint(2) NOT NULL default '0',
-  `day` tinyint(2) NOT NULL default '0',
-  `hour` tinyint(2) NOT NULL default '0',
-  `user_id` smallint(5) NOT NULL default '0',
-  `IP` varchar(15) NOT NULL default '',
-  `section` enum('categories','tags','search','list','favorites','most_visited','best_rated','recent_pics','recent_cats') default NULL,
-  `category_id` smallint(5) default NULL,
-  `tag_ids` varchar(50) default NULL,
-  `image_id` mediumint(8) default NULL,
-  `summarized` enum('true','false') default 'false',
-  `image_type` enum('picture','high','other') default NULL,
-  PRIMARY KEY  (`id`),
-  KEY `history_i1` (`summarized`)
-) TYPE=MyISAM
-;",
-
-"
-ALTER TABLE `".PREFIX_TABLE."image_category`
-  DROP INDEX `image_category_i1`
-;",
-
-"
-ALTER TABLE `".PREFIX_TABLE."image_category`
-  ADD INDEX `image_category_i1` (`category_id`)
-;",
-
-"
-ALTER TABLE `".PREFIX_TABLE."image_category`
-  DROP INDEX `image_category_i2`
-;",
-
-"
-ALTER TABLE `".PREFIX_TABLE."images`
-  ADD COLUMN `high_filesize` mediumint(9) unsigned default NULL
-;",
-
-"
-ALTER TABLE `".PREFIX_TABLE."user_infos`
-  CHANGE COLUMN `language`
-    `language` varchar(50) NOT NULL default 'en_UK.iso-8859-1'
-;",
-
-"
-ALTER TABLE `".PREFIX_TABLE."user_infos`
-  DROP COLUMN `auto_login_key`
-;",
-
-"
-ALTER TABLE `".PREFIX_TABLE."user_infos`
-  ADD COLUMN `show_nb_hits` enum('true','false') NOT NULL default 'false'
-;",
-
-"
-ALTER TABLE `".PREFIX_TABLE."user_mail_notification`
-  DROP INDEX `uidx_check_key`
-;",
-
-"
-ALTER TABLE `".PREFIX_TABLE."user_mail_notification`
-  ADD UNIQUE `user_mail_notification_ui1` (`check_key`)
-;",
-
-"
-CREATE TABLE `".PREFIX_TABLE."history_summary` (
-  `id` varchar(13) NOT NULL default '',
-  `year` smallint(4) NOT NULL default '0',
-  `month` tinyint(2) default NULL,
-  `day` tinyint(2) default NULL,
-  `hour` tinyint(2) default NULL,
-  `nb_pages` int(11) default NULL,
-  PRIMARY KEY  (`id`)
-) TYPE=MyISAM
-;",
-
-"
-CREATE TABLE `".PREFIX_TABLE."old_permalinks` (
-  `cat_id` smallint(5) unsigned NOT NULL default '0',
-  `permalink` varchar(64) NOT NULL default '',
-  `date_deleted` datetime NOT NULL default '0000-00-00 00:00:00',
-  `last_hit` datetime default NULL,
-  `hit` int(10) unsigned NOT NULL default '0',
-  PRIMARY KEY  (`permalink`)
-) TYPE=MyISAM
-;",
-
-"
-CREATE TABLE `".PREFIX_TABLE."plugins` (
-  `id` varchar(64) binary NOT NULL default '',
-  `state` enum('inactive','active') NOT NULL default 'inactive',
-  `version` varchar(64) NOT NULL default '0',
-  PRIMARY KEY  (`id`)
-) TYPE=MyISAM
-;",
-
-"
-CREATE TABLE `".PREFIX_TABLE."user_cache_categories` (
-  `user_id` smallint(5) NOT NULL default '0',
-  `cat_id` smallint(5) unsigned NOT NULL default '0',
-  `max_date_last` datetime default NULL,
-  `count_images` mediumint(8) unsigned default '0',
-  `count_categories` mediumint(8) unsigned default '0',
-  PRIMARY KEY  (`user_id`,`cat_id`)
-) TYPE=MyISAM
-;",
-
-"
-CREATE TABLE `".PREFIX_TABLE."ws_access` (
-  `id` smallint(5) unsigned NOT NULL auto_increment,
-  `name` varchar(32) NOT NULL default '',
-  `access` varchar(255) default NULL,
-  `start` datetime default NULL,
-  `end` datetime default NULL,
-  `request` varchar(255) default NULL,
-  `limit` smallint(5) unsigned default NULL,
-  `comment` varchar(255) default NULL,
-  PRIMARY KEY  (`id`),
-  UNIQUE KEY `ws_access_ui1` (`name`)
-) TYPE=MyISAM COMMENT='Access for Web Services'
-;",
-
-"
-INSERT INTO ".PREFIX_TABLE."config
-  (param,value,comment)
-  VALUES
-  ('show_nb_hits', 'false', 'Show hits count under thumbnails')
-;",
-
-"
-INSERT INTO ".PREFIX_TABLE."config
-  (param,value,comment)
-  VALUES
-  ('history_admin','false','keep a history of administrator visits on your website')
-;",
-
-"
-INSERT INTO ".PREFIX_TABLE."config
-  (param,value,comment)
-  VALUES
-  ('history_guest','true','keep a history of guest visits on your website')
-;",
-
-"
-INSERT INTO ".PREFIX_TABLE."config
-  (param,value,comment)
-  VALUES
-  ('allow_user_registration','true','allow visitors to register?')
-;",
-
-"
-INSERT INTO ".PREFIX_TABLE."config
-  (param,value,comment)
-  VALUES
-  ('secret_key', MD5(RAND()), 'a secret key specific to the gallery for internal use')
-;",
-
-"
-INSERT INTO ".PREFIX_TABLE."config
-  (param,value,comment)
-  VALUES
-  ('nbm_send_html_mail','true','Send mail on HTML format for notification by mail')
-;",
-
-"
-INSERT INTO ".PREFIX_TABLE."config
-  (param,value,comment)
-  VALUES
-  ('nbm_send_recent_post_dates','true','Send recent post by dates for notification by mail')
-;",
-
-"
-INSERT INTO ".PREFIX_TABLE."config
-  (param,value,comment)
-  VALUES
-  ('email_admin_on_new_user','false','Send an email to theadministrators when a user registers')
-;",
-
-"
-INSERT INTO ".PREFIX_TABLE."config
-  (param,value,comment)
-  VALUES
-  ('email_admin_on_comment','false','Send an email to the administrators when a valid comment is entered')
-;",
-
-"
-INSERT INTO ".PREFIX_TABLE."config
-  (param,value,comment)
-  VALUES
-  ('email_admin_on_comment_validation','false','Send an email to the administrators when a comment requires validation')
-;",
-
-"
-INSERT INTO ".PREFIX_TABLE."config
-  (param,value,comment)
-  VALUES
-  ('email_admin_on_picture_uploaded','false','Send an email to the administrators when a picture is uploaded')
-;",
-
-"
-UPDATE ".PREFIX_TABLE."user_cache
-  SET need_update = 'true'
-;",
-
-);
-
-foreach ($queries as $query)
-{
-  pwg_query($query);
-}
-
-$replacements = array(
-  array('&#039;', '\''),
-  array('&quot;', '"'),
-  array('&lt;',   '<'),
-  array('&gt;',   '>'),
-  array('&amp;',  '&') // <- this must be the last one
-  );
-
-foreach ($replacements as $replacement)
-{
-    $query = '
-UPDATE '.PREFIX_TABLE.'comments
-  SET content = REPLACE(content, "'.
-  addslashes($replacement[0]).
-  '", "'.
-  addslashes($replacement[1]).
-  '")
-;';
-    pwg_query($query);
-}
-
-load_conf_from_db();
-
-$query = "
-UPDATE ".USER_INFOS_TABLE."
-SET
-  template = '".$conf['default_template']."',
-  nb_image_line = ".$conf['nb_image_line'].",
-  nb_line_page = ".$conf['nb_line_page'].",
-  language = '".$conf['default_language']."',
-  maxwidth = ".
-  (empty($conf['default_maxwidth']) ? "NULL" : $conf['default_maxwidth']).
-  ",
-  maxheight = ".
-  (empty($conf['default_maxheight']) ? "NULL" : $conf['default_maxheight']).
-  ",
-  recent_period = ".$conf['recent_period'].",
-  expand = '".boolean_to_string($conf['auto_expand'])."',
-  show_nb_comments = '".boolean_to_string($conf['show_nb_comments'])."',
-  show_nb_hits = '".boolean_to_string($conf['show_nb_hits'])."',
-  enabled_high = '".boolean_to_string(
-    (isset($conf['newuser_default_enabled_high']) ?
-      $conf['newuser_default_enabled_high'] : true)
-    ).
-  "'
-WHERE
-  user_id = ".$conf['default_user_id'].";";
-pwg_query($query);
-
-$query = "
-DELETE FROM ".CONFIG_TABLE."
-WHERE
-  param IN
-(
-  'default_template',
-  'nb_image_line',
-  'nb_line_page',
-  'default_language',
-  'default_maxwidth',
-  'default_maxheight',
-  'recent_period',
-  'auto_expand',
-  'show_nb_comments',
-  'show_nb_hits'
-)
-;";
-pwg_query($query);
-
-// now we upgrade from 1.7.0
-// include_once(PHPWG_ROOT_PATH.'install/upgrade_1.7.0.php');
-?>
-- 
cgit v1.2.3