aboutsummaryrefslogtreecommitdiffstats
path: root/BSF/install/upgrade_1.3.0.php
diff options
context:
space:
mode:
authorvdigital <vdigital@piwigo.org>2008-05-23 22:38:14 +0000
committervdigital <vdigital@piwigo.org>2008-05-23 22:38:14 +0000
commitc55dbbc995e152af3f2c88662101b0643d2e171a (patch)
tree3862effd5384b7c39295ed6690c9ccafd1677e54 /BSF/install/upgrade_1.3.0.php
parent77fd1f51a3c5f5a52f72ef8a299fe368228e2285 (diff)
Removed file/folder
git-svn-id: http://piwigo.org/svn/trunk@2358 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'BSF/install/upgrade_1.3.0.php')
-rw-r--r--BSF/install/upgrade_1.3.0.php126
1 files changed, 0 insertions, 126 deletions
diff --git a/BSF/install/upgrade_1.3.0.php b/BSF/install/upgrade_1.3.0.php
deleted file mode 100644
index ef2d1f8f7..000000000
--- a/BSF/install/upgrade_1.3.0.php
+++ /dev/null
@@ -1,126 +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. |
-// +-----------------------------------------------------------------------+
-
-
-/**
- * Upgrade from 1.3.0 to 1.3.1
- */
-
-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 phpwebgallery_categories
- ADD COLUMN uppercats varchar(255) NOT NULL default ''
-;",
-
- "
-CREATE TABLE phpwebgallery_user_category (
- user_id smallint(5) unsigned NOT NULL default '0'
-)
-;",
-
- "
-ALTER TABLE phpwebgallery_categories
- ADD INDEX id (id)
-;",
-
- "
-ALTER TABLE phpwebgallery_categories
- ADD INDEX id_uppercat (id_uppercat)
-;",
-
- "
-ALTER TABLE phpwebgallery_image_category
- ADD INDEX category_id (category_id)
-;",
-
- "
-ALTER TABLE phpwebgallery_image_category
- ADD INDEX image_id (image_id)
-;",
- );
-
-foreach ($queries as $query)
-{
- $query = str_replace('phpwebgallery_', PREFIX_TABLE, $query);
- pwg_query($query);
-}
-// 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);
-}
-
-mass_updates(
- CATEGORIES_TABLE,
- array(
- 'primary' => array('id'),
- 'update' => array('uppercats')
- ),
- $datas
- );
-
-// now we upgrade from 1.3.1 to 1.6.0
-include_once(PHPWG_ROOT_PATH.'install/upgrade_1.3.1.php');
-?> \ No newline at end of file