source: branches/1.6/upgrade_feed.php @ 8528

Last change on this file since 8528 was 1075, checked in by rub, 18 years ago

Step 4 improvement issue 0000301:

o Correction lock categories and is_admin (functions with parameters now)
o Cannot use check_status with upgrade.php and upgrade_feed.php => New function check_upgrade use in upgrade*.php (new functionality for upgrade_feed.php)
o upgrade_feed.php is showed only for administrator user

File size: 3.9 KB
Line 
1<?php
2// +-----------------------------------------------------------------------+
3// | PhpWebGallery - a PHP based picture gallery                           |
4// | Copyright (C) 2002-2003 Pierrick LE GALL - pierrick@phpwebgallery.net |
5// | Copyright (C) 2003-2006 PhpWebGallery Team - http://phpwebgallery.net |
6// +-----------------------------------------------------------------------+
7// | branch        : BSF (Best So Far)
8// | file          : $RCSfile$
9// | last update   : $Date: 2005-09-21 00:04:57 +0200 (mer, 21 sep 2005) $
10// | last modifier : $Author: plg $
11// | revision      : $Revision: 870 $
12// +-----------------------------------------------------------------------+
13// | This program is free software; you can redistribute it and/or modify  |
14// | it under the terms of the GNU General Public License as published by  |
15// | the Free Software Foundation                                          |
16// |                                                                       |
17// | This program is distributed in the hope that it will be useful, but   |
18// | WITHOUT ANY WARRANTY; without even the implied warranty of            |
19// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU      |
20// | General Public License for more details.                              |
21// |                                                                       |
22// | You should have received a copy of the GNU General Public License     |
23// | along with this program; if not, write to the Free Software           |
24// | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, |
25// | USA.                                                                  |
26// +-----------------------------------------------------------------------+
27
28define('PHPWG_ROOT_PATH', './');
29
30include_once(PHPWG_ROOT_PATH.'include/functions.inc.php');
31include_once(PHPWG_ROOT_PATH.'admin/include/functions.php');
32include_once(PHPWG_ROOT_PATH.'admin/include/functions_upgrade.php');
33include(PHPWG_ROOT_PATH.'include/template.php');
34include(PHPWG_ROOT_PATH.'include/mysql.inc.php');
35
36// +-----------------------------------------------------------------------+
37// | Check Access and exit when it is not ok                               |
38// +-----------------------------------------------------------------------+
39check_upgrade();
40
41define('PREFIX_TABLE', $prefixeTable);
42define('UPGRADES_PATH', PHPWG_ROOT_PATH.'install/db');
43
44// +-----------------------------------------------------------------------+
45// |                         Database connection                           |
46// +-----------------------------------------------------------------------+
47
48mysql_connect($cfgHote, $cfgUser, $cfgPassword)
49or die("Could not connect to database server");
50mysql_select_db($cfgBase)
51or die("Could not connect to database");
52
53// +-----------------------------------------------------------------------+
54// |                              Upgrades                                 |
55// +-----------------------------------------------------------------------+
56
57// retrieve already applied upgrades
58$query = '
59SELECT id
60  FROM '.PREFIX_TABLE.'upgrade
61;';
62$applied = array_from_query($query, 'id');
63
64// retrieve existing upgrades
65$existing = get_available_upgrade_ids();
66
67// which upgrades need to be applied?
68$to_apply = array_diff($existing, $applied);
69
70echo '<pre>';
71echo count($to_apply).' upgrades to apply';
72
73foreach ($to_apply as $upgrade_id)
74{
75  unset($upgrade_description);
76 
77  echo "\n\n";
78  echo '=== upgrade '.$upgrade_id."\n";
79
80  // include & execute upgrade script. Each upgrade script must contain
81  // $upgrade_description variable which describe briefly what the upgrade
82  // script does.
83  include(UPGRADES_PATH.'/'.$upgrade_id.'-database.php');
84
85  // notify upgrade
86  $query = '
87INSERT INTO '.PREFIX_TABLE.'upgrade
88  (id, applied, description)
89  VALUES
90  (\''.$upgrade_id.'\', NOW(), \''.$upgrade_description.'\')
91;';
92  pwg_query($query);
93}
94
95echo '</pre>';
96?>
Note: See TracBrowser for help on using the repository browser.