source: trunk/admin/include/functions_upgrade.php @ 5196

Last change on this file since 5196 was 5196, checked in by plg, 14 years ago

increase copyright year to 2010

  • Property svn:eol-style set to LF
File size: 6.6 KB
Line 
1<?php
2// +-----------------------------------------------------------------------+
3// | Piwigo - a PHP based picture gallery                                  |
4// +-----------------------------------------------------------------------+
5// | Copyright(C) 2008-2010 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
24function check_upgrade()
25{
26  if (defined('PHPWG_IN_UPGRADE'))
27  {
28    return PHPWG_IN_UPGRADE;
29  }
30  return false;
31}
32
33// concerning upgrade, we use the default tables
34function prepare_conf_upgrade()
35{
36  global $prefixeTable;
37
38  // $conf is not used for users tables
39  // define cannot be re-defined
40  define('CATEGORIES_TABLE', $prefixeTable.'categories');
41  define('COMMENTS_TABLE', $prefixeTable.'comments');
42  define('CONFIG_TABLE', $prefixeTable.'config');
43  define('FAVORITES_TABLE', $prefixeTable.'favorites');
44  define('GROUP_ACCESS_TABLE', $prefixeTable.'group_access');
45  define('GROUPS_TABLE', $prefixeTable.'groups');
46  define('HISTORY_TABLE', $prefixeTable.'history');
47  define('HISTORY_SUMMARY_TABLE', $prefixeTable.'history_summary');
48  define('IMAGE_CATEGORY_TABLE', $prefixeTable.'image_category');
49  define('IMAGES_TABLE', $prefixeTable.'images');
50  define('SESSIONS_TABLE', $prefixeTable.'sessions');
51  define('SITES_TABLE', $prefixeTable.'sites');
52  define('USER_ACCESS_TABLE', $prefixeTable.'user_access');
53  define('USER_GROUP_TABLE', $prefixeTable.'user_group');
54  define('USERS_TABLE', $prefixeTable.'users');
55  define('USER_INFOS_TABLE', $prefixeTable.'user_infos');
56  define('USER_FEED_TABLE', $prefixeTable.'user_feed');
57  define('WAITING_TABLE', $prefixeTable.'waiting');
58  define('RATE_TABLE', $prefixeTable.'rate');
59  define('USER_CACHE_TABLE', $prefixeTable.'user_cache');
60  define('USER_CACHE_CATEGORIES_TABLE', $prefixeTable.'user_cache_categories');
61  define('CADDIE_TABLE', $prefixeTable.'caddie');
62  define('UPGRADE_TABLE', $prefixeTable.'upgrade');
63  define('SEARCH_TABLE', $prefixeTable.'search');
64  define('USER_MAIL_NOTIFICATION_TABLE', $prefixeTable.'user_mail_notification');
65  define('TAGS_TABLE', $prefixeTable.'tags');
66  define('IMAGE_TAG_TABLE', $prefixeTable.'image_tag');
67  define('PLUGINS_TABLE', $prefixeTable.'plugins');
68  define('OLD_PERMALINKS_TABLE', $prefixeTable.'old_permalinks');
69}
70
71// Deactivate all non-standard plugins
72function deactivate_non_standard_plugins()
73{
74  global $page;
75
76  $standard_plugins = array(
77    'add_index',
78    'admin_advices',
79    'admin_multi_view',
80    'c13y_upgrade',
81    'event_tracer',
82    'language_switch',
83    'LocalFilesEditor'
84    );
85
86  $query = '
87SELECT id
88FROM '.PREFIX_TABLE.'plugins
89WHERE state = "active"
90AND id NOT IN ("' . implode('","', $standard_plugins) . '")
91;';
92
93  $result = pwg_query($query);
94  $plugins = array();
95  while ($row = pwg_db_fetch_assoc($result))
96  {
97    array_push($plugins, $row['id']);
98  }
99
100  if (!empty($plugins))
101  {
102    $query = '
103UPDATE '.PREFIX_TABLE.'plugins
104SET state="inactive"
105WHERE id IN ("' . implode('","', $plugins) . '")
106;';
107    pwg_query($query);
108
109    array_push($page['infos'],
110      l10n('As a precaution, following plugins have been deactivated. You must check for plugins upgrade before reactiving them:').'<p><i>'.implode(', ', $plugins).'</i></p>');
111  }
112}
113
114// Check access rights
115function check_upgrade_access_rights($current_release, $username, $password)
116{
117  global $conf, $page;
118
119  if(!@get_magic_quotes_gpc())
120  {
121    $username = pwg_db_real_escape_string($username);
122  }
123
124  if (version_compare($current_release, '2.0', '<'))
125  {
126    $username = utf8_decode($username);
127    $password = utf8_decode($password);
128  }
129
130  if (version_compare($current_release, '1.5', '<'))
131  {
132    $query = '
133SELECT password, status
134FROM '.USERS_TABLE.'
135WHERE username = "'.$username.'"
136;';
137  }
138  else
139  {
140    $query = '
141SELECT u.password, ui.status
142FROM '.USERS_TABLE.' AS u
143INNER JOIN '.USER_INFOS_TABLE.' AS ui
144ON u.'.$conf['user_fields']['id'].'=ui.user_id
145WHERE '.$conf['user_fields']['username'].'="'.$username.'"
146;';
147  }
148  $row = pwg_db_fetch_assoc(pwg_query($query));
149
150  if (!isset($conf['pass_convert']))
151  {
152    $conf['pass_convert'] = create_function('$s', 'return md5($s);');
153  }
154
155  if ($row['password'] != $conf['pass_convert']($password))
156  {
157    array_push($page['errors'], l10n('Invalid password!'));
158  }
159  elseif ($row['status'] != 'admin' and $row['status'] != 'webmaster')
160  {
161    array_push($page['errors'], l10n('You do not have access rights to run upgrade'));
162  }
163  else
164  {
165    define('PHPWG_IN_UPGRADE', true);
166  }
167}
168
169/**
170 * which upgrades are available ?
171 *
172 * @return array
173 */
174function get_available_upgrade_ids()
175{
176  $upgrades_path = PHPWG_ROOT_PATH.'install/db';
177
178  $available_upgrade_ids = array();
179
180  if ($contents = opendir($upgrades_path))
181  {
182    while (($node = readdir($contents)) !== false)
183    {
184      if (is_file($upgrades_path.'/'.$node)
185          and preg_match('/^(.*?)-database\.php$/', $node, $match))
186      {
187        array_push($available_upgrade_ids, $match[1]);
188      }
189    }
190  }
191  natcasesort($available_upgrade_ids);
192
193  return $available_upgrade_ids;
194}
195
196
197/**
198 * returns true if there are available upgrade files
199 */
200function check_upgrade_feed()
201{
202  // retrieve already applied upgrades
203  $query = '
204SELECT id
205  FROM '.UPGRADE_TABLE.'
206;';
207  $applied = array_from_query($query, 'id');
208
209  // retrieve existing upgrades
210  $existing = get_available_upgrade_ids();
211
212  // which upgrades need to be applied?
213  return (count(array_diff($existing, $applied)) > 0);
214}
215
216?>
Note: See TracBrowser for help on using the repository browser.