source: branches/2.0/upgrade_feed.php @ 5014

Last change on this file since 5014 was 3046, checked in by plg, 15 years ago

Administration: happy new year 2009, all PHP headers updated.

  • Property svn:eol-style set to LF
  • Property svn:keywords set to Author Date Id Revision
File size: 4.2 KB
Line 
1<?php
2// +-----------------------------------------------------------------------+
3// | Piwigo - a PHP based picture gallery                                  |
4// +-----------------------------------------------------------------------+
5// | Copyright(C) 2008-2009 Piwigo Team                  http://piwigo.org |
6// | Copyright(C) 2003-2008 PhpWebGallery Team    http://phpwebgallery.net |
7// | Copyright(C) 2002-2003 Pierrick LE GALL   http://le-gall.net/pierrick |
8// +-----------------------------------------------------------------------+
9// | This program is free software; you can redistribute it and/or modify  |
10// | it under the terms of the GNU General Public License as published by  |
11// | the Free Software Foundation                                          |
12// |                                                                       |
13// | This program is distributed in the hope that it will be useful, but   |
14// | WITHOUT ANY WARRANTY; without even the implied warranty of            |
15// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU      |
16// | General Public License for more details.                              |
17// |                                                                       |
18// | You should have received a copy of the GNU General Public License     |
19// | along with this program; if not, write to the Free Software           |
20// | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, |
21// | USA.                                                                  |
22// +-----------------------------------------------------------------------+
23
24//check php version
25if (version_compare(PHP_VERSION, '5', '<'))
26{
27  die('Piwigo requires PHP 5 or above.');
28}
29
30define('PHPWG_ROOT_PATH', './');
31
32include_once(PHPWG_ROOT_PATH.'include/functions.inc.php');
33include_once(PHPWG_ROOT_PATH.'admin/include/functions.php');
34include_once(PHPWG_ROOT_PATH.'admin/include/functions_upgrade.php');
35include(PHPWG_ROOT_PATH.'include/mysql.inc.php');
36include(PHPWG_ROOT_PATH . 'include/config_default.inc.php');
37@include(PHPWG_ROOT_PATH. 'include/config_local.inc.php');
38
39// +-----------------------------------------------------------------------+
40// | Check Access and exit when it is not ok                               |
41// +-----------------------------------------------------------------------+
42
43if (!$conf['check_upgrade_feed'])
44{
45  die("upgrade feed is not active");
46}
47
48prepare_conf_upgrade();
49
50define('PREFIX_TABLE', $prefixeTable);
51define('UPGRADES_PATH', PHPWG_ROOT_PATH.'install/db');
52
53// +-----------------------------------------------------------------------+
54// |                         Database connection                           |
55// +-----------------------------------------------------------------------+
56
57mysql_connect($cfgHote, $cfgUser, $cfgPassword) or die("Could not connect to database server");
58mysql_select_db($cfgBase) or die("Could not connect to database");
59if ( version_compare(mysql_get_server_info(), '4.1.0', '>=')
60    and defined('DB_CHARSET') and DB_CHARSET!='' )
61{
62  pwg_query('SET NAMES "'.DB_CHARSET.'"');
63}
64
65
66// +-----------------------------------------------------------------------+
67// |                              Upgrades                                 |
68// +-----------------------------------------------------------------------+
69
70// retrieve already applied upgrades
71$query = '
72SELECT id
73  FROM '.PREFIX_TABLE.'upgrade
74;';
75$applied = array_from_query($query, 'id');
76
77// retrieve existing upgrades
78$existing = get_available_upgrade_ids();
79
80// which upgrades need to be applied?
81$to_apply = array_diff($existing, $applied);
82
83echo '<pre>';
84echo count($to_apply).' upgrades to apply';
85
86foreach ($to_apply as $upgrade_id)
87{
88  unset($upgrade_description);
89
90  echo "\n\n";
91  echo '=== upgrade '.$upgrade_id."\n";
92
93  // include & execute upgrade script. Each upgrade script must contain
94  // $upgrade_description variable which describe briefly what the upgrade
95  // script does.
96  include(UPGRADES_PATH.'/'.$upgrade_id.'-database.php');
97
98  // notify upgrade
99  $query = '
100INSERT INTO '.PREFIX_TABLE.'upgrade
101  (id, applied, description)
102  VALUES
103  (\''.$upgrade_id.'\', NOW(), \''.$upgrade_description.'\')
104;';
105  pwg_query($query);
106}
107
108echo '</pre>';
109?>
Note: See TracBrowser for help on using the repository browser.