source: trunk/upgrade.php @ 15950

Last change on this file since 15950 was 15680, checked in by plg, 12 years ago

feature 2632: add a test on upgrade.php, if a remote site is detected downgrade to 2.3.4

  • Property svn:eol-style set to LF
File size: 14.0 KB
Line 
1<?php
2// +-----------------------------------------------------------------------+
3// | Piwigo - a PHP based photo gallery                                    |
4// +-----------------------------------------------------------------------+
5// | Copyright(C) 2008-2012 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
24define('PHPWG_ROOT_PATH', './');
25
26// load config file
27include(PHPWG_ROOT_PATH . 'include/config_default.inc.php');
28@include(PHPWG_ROOT_PATH. 'local/config/config.inc.php');
29defined('PWG_LOCAL_DIR') or define('PWG_LOCAL_DIR', 'local/');
30
31$config_file = PHPWG_ROOT_PATH.PWG_LOCAL_DIR.'config/database.inc.php';
32$config_file_contents = @file_get_contents($config_file);
33if ($config_file_contents === false)
34{
35  die('Cannot load '.$config_file);
36}
37$php_end_tag = strrpos($config_file_contents, '?'.'>');
38if ($php_end_tag === false)
39{
40  die('Cannot find php end tag in '.$config_file);
41}
42
43include($config_file);
44
45// $conf is not used for users tables - define cannot be re-defined
46define('USERS_TABLE', $prefixeTable.'users');
47include_once(PHPWG_ROOT_PATH.'include/constants.php');
48define('PREFIX_TABLE', $prefixeTable);
49define('UPGRADES_PATH', PHPWG_ROOT_PATH.'install/db');
50
51include_once(PHPWG_ROOT_PATH.'include/functions.inc.php');
52include_once(PHPWG_ROOT_PATH.'admin/include/functions.php');
53
54// +-----------------------------------------------------------------------+
55// |                              functions                                |
56// +-----------------------------------------------------------------------+
57
58/**
59 * list all tables in an array
60 *
61 * @return array
62 */
63function get_tables()
64{
65  $tables = array();
66
67  $query = '
68SHOW TABLES
69;';
70  $result = pwg_query($query);
71
72  while ($row = pwg_db_fetch_row($result))
73  {
74    if (preg_match('/^'.PREFIX_TABLE.'/', $row[0]))
75    {
76      array_push($tables, $row[0]);
77    }
78  }
79
80  return $tables;
81}
82
83/**
84 * list all columns of each given table
85 *
86 * @return array of array
87 */
88function get_columns_of($tables)
89{
90  $columns_of = array();
91
92  foreach ($tables as $table)
93  {
94    $query = '
95DESC '.$table.'
96;';
97    $result = pwg_query($query);
98
99    $columns_of[$table] = array();
100
101    while ($row = pwg_db_fetch_row($result))
102    {
103      array_push($columns_of[$table], $row[0]);
104    }
105  }
106
107  return $columns_of;
108}
109
110/**
111 */
112function print_time($message)
113{
114  global $last_time;
115
116  $new_time = get_moment();
117  echo '<pre>['.get_elapsed_time($last_time, $new_time).']';
118  echo ' '.$message;
119  echo '</pre>';
120  flush();
121  $last_time = $new_time;
122}
123
124// +-----------------------------------------------------------------------+
125// |                             playing zone                              |
126// +-----------------------------------------------------------------------+
127
128// echo implode('<br>', get_tables());
129// echo '<pre>'; print_r(get_columns_of(get_tables())); echo '</pre>';
130
131// foreach (get_available_upgrade_ids() as $upgrade_id)
132// {
133//   echo $upgrade_id, '<br>';
134// }
135
136// +-----------------------------------------------------------------------+
137// |                             language                                  |
138// +-----------------------------------------------------------------------+
139include(PHPWG_ROOT_PATH . 'admin/include/languages.class.php');
140$languages = new languages('utf-8');
141
142if (isset($_GET['language']))
143{
144  $language = strip_tags($_GET['language']);
145
146  if (!in_array($language, array_keys($languages->fs_languages)))
147  {
148    $language = PHPWG_DEFAULT_LANGUAGE;
149  }
150}
151else
152{
153  $language = 'en_UK';
154  // Try to get browser language
155  foreach ($languages->fs_languages as $language_code => $fs_language)
156  {
157    if (substr($language_code,0,2) == @substr($_SERVER["HTTP_ACCEPT_LANGUAGE"],0,2))
158    {
159      $language = $language_code;
160      break;
161    }
162  }
163}
164
165if ('fr_FR' == $language) {
166  define('PHPWG_DOMAIN', 'fr.piwigo.org');
167}
168else if ('it_IT' == $language) {
169  define('PHPWG_DOMAIN', 'it.piwigo.org');
170}
171else if ('de_DE' == $language) {
172  define('PHPWG_DOMAIN', 'de.piwigo.org');
173}
174else if ('es_ES' == $language) {
175  define('PHPWG_DOMAIN', 'es.piwigo.org');
176}
177else if ('pl_PL' == $language) {
178  define('PHPWG_DOMAIN', 'pl.piwigo.org');
179}
180else if ('zh_CN' == $language) {
181  define('PHPWG_DOMAIN', 'cn.piwigo.org');
182}
183else if ('hu_HU' == $language) {
184  define('PHPWG_DOMAIN', 'hu.piwigo.org');
185}
186else if ('ru_RU' == $language) {
187  define('PHPWG_DOMAIN', 'ru.piwigo.org');
188}
189else if ('nl_NL' == $language) {
190  define('PHPWG_DOMAIN', 'nl.piwigo.org');
191}
192else {
193  define('PHPWG_DOMAIN', 'piwigo.org');
194}
195define('PHPWG_URL', 'http://'.PHPWG_DOMAIN);
196
197load_language( 'common.lang', '', array('language'=>$language, 'target_charset'=>'utf-8', 'no_fallback' => true) );
198load_language( 'admin.lang', '', array('language'=>$language, 'target_charset'=>'utf-8', 'no_fallback' => true) );
199load_language( 'install.lang', '', array('language'=>$language, 'target_charset'=>'utf-8', 'no_fallback' => true) );
200load_language( 'upgrade.lang', '', array('language'=>$language, 'target_charset'=>'utf-8', 'no_fallback' => true) );
201
202// check php version
203if (version_compare(PHP_VERSION, REQUIRED_PHP_VERSION, '<'))
204{
205  include(PHPWG_ROOT_PATH.'install/php5_apache_configuration.php');
206}
207
208// +-----------------------------------------------------------------------+
209// |                          database connection                          |
210// +-----------------------------------------------------------------------+
211include_once(PHPWG_ROOT_PATH.'admin/include/functions_upgrade.php');
212include(PHPWG_ROOT_PATH .'include/dblayer/functions_'.$conf['dblayer'].'.inc.php');
213
214upgrade_db_connect();
215pwg_db_check_charset();
216
217list($dbnow) = pwg_db_fetch_row(pwg_query('SELECT NOW();'));
218define('CURRENT_DATE', $dbnow);
219
220// +-----------------------------------------------------------------------+
221// |                        template initialization                        |
222// +-----------------------------------------------------------------------+
223
224$template = new Template(PHPWG_ROOT_PATH.'admin/themes', 'clear');
225$template->set_filenames(array('upgrade'=>'upgrade.tpl'));
226$template->assign(array(
227  'RELEASE' => PHPWG_VERSION,
228  'L_UPGRADE_HELP' => sprintf(l10n('Need help ? Ask your question on <a href="%s">Piwigo message board</a>.'), PHPWG_URL.'/forum'),
229  )
230);
231
232// +-----------------------------------------------------------------------+
233// | Remote sites are not compatible with Piwigo 2.4+                      |
234// +-----------------------------------------------------------------------+
235
236$has_remote_site = false;
237
238$query = 'SELECT galleries_url FROM '.SITES_TABLE.';';
239$result = pwg_query($query);
240while ($row = pwg_db_fetch_assoc($result))
241{
242  if (url_is_remote($row['galleries_url']))
243  {
244    $has_remote_site = true;
245  }
246}
247
248if ($has_remote_site)
249{
250  include_once(PHPWG_ROOT_PATH.'admin/include/updates.class.php');
251  include_once(PHPWG_ROOT_PATH.'admin/include/pclzip.lib.php');
252
253  $page['errors'] = array();
254  $step = 3;
255  updates::upgrade_to('2.3.4', $step, false);
256
257  if (!empty($page['errors']))
258  {
259    echo '<ul>';
260    foreach ($page['errors'] as $error)
261    {
262      echo '<li>'.$error.'</li>';
263    }
264    echo '</ul>';
265  }
266
267  exit();
268}
269
270// +-----------------------------------------------------------------------+
271// |                            upgrade choice                             |
272// +-----------------------------------------------------------------------+
273
274$tables = get_tables();
275$columns_of = get_columns_of($tables);
276
277// find the current release
278if (!in_array('param', $columns_of[PREFIX_TABLE.'config']))
279{
280  // we're in branch 1.3, important upgrade, isn't it?
281  if (in_array(PREFIX_TABLE.'user_category', $tables))
282  {
283    $current_release = '1.3.1';
284  }
285  else
286  {
287    $current_release = '1.3.0';
288  }
289}
290else if (!in_array(PREFIX_TABLE.'user_cache', $tables))
291{
292  $current_release = '1.4.0';
293}
294else if (!in_array(PREFIX_TABLE.'tags', $tables))
295{
296  $current_release = '1.5.0';
297}
298else if ( !in_array(PREFIX_TABLE.'plugins', $tables) )
299{
300  if (!in_array('auto_login_key', $columns_of[PREFIX_TABLE.'user_infos']))
301  {
302    $current_release = '1.6.0';
303  }
304  else
305  {
306    $current_release = '1.6.2';
307  }
308}
309else if (!in_array('md5sum', $columns_of[PREFIX_TABLE.'images']))
310{
311  $current_release = '1.7.0';
312}
313else if (!in_array(PREFIX_TABLE.'themes', $tables))
314{
315  $current_release = '2.0.0';
316}
317else if (!in_array('added_by', $columns_of[PREFIX_TABLE.'images']))
318{
319  $current_release = '2.1.0';
320}
321else if (!in_array('rating_score', $columns_of[PREFIX_TABLE.'images']))
322{
323  $current_release = '2.2.0';
324}
325else if (!in_array('coi', $columns_of[PREFIX_TABLE.'images']))
326{
327  $current_release = '2.3.0';
328}
329else
330{
331  die('No upgrade required, the database structure is up to date');
332}
333
334// +-----------------------------------------------------------------------+
335// |                            upgrade launch                             |
336// +-----------------------------------------------------------------------+
337$page['infos'] = array();
338$page['errors'] = array();
339$mysql_changes = array();
340
341check_upgrade_access_rights();
342
343if ((isset($_POST['submit']) or isset($_GET['now']))
344  and check_upgrade())
345{
346  $upgrade_file = PHPWG_ROOT_PATH.'install/upgrade_'.$current_release.'.php';
347  if (is_file($upgrade_file))
348  {
349    $page['upgrade_start'] = get_moment();
350    $conf['die_on_sql_error'] = false;
351    include($upgrade_file);
352    conf_update_param('piwigo_db_version', get_branch_from_version(PHPWG_VERSION));
353
354    // Something to add in database.inc.php?
355    if (!empty($mysql_changes))
356    {
357      $config_file_contents = 
358        substr($config_file_contents, 0, $php_end_tag) . "\r\n"
359        . implode("\r\n" , $mysql_changes) . "\r\n"
360        . substr($config_file_contents, $php_end_tag);
361
362      if (!@file_put_contents($config_file, $config_file_contents))
363      {
364        array_push(
365          $page['infos'],
366          sprintf(
367            l10n('In <i>%s</i>, before <b>?></b>, insert:'),
368            PWG_LOCAL_DIR.'config/database.inc.php'
369            )
370          .'<p><textarea rows="4" cols="40">'
371          .implode("\r\n" , $mysql_changes).'</textarea></p>'
372          );
373      }
374    }
375
376    // Plugins deactivation
377    if (in_array(PREFIX_TABLE.'plugins', $tables))
378    {
379      deactivate_non_standard_plugins();
380    }
381
382    deactivate_non_standard_themes();
383    deactivate_templates();
384
385    $page['upgrade_end'] = get_moment();
386
387    $template->assign(
388      'upgrade',
389      array(
390        'VERSION' => $current_release,
391        'TOTAL_TIME' => get_elapsed_time(
392          $page['upgrade_start'],
393          $page['upgrade_end']
394          ),
395        'SQL_TIME' => number_format(
396          $page['queries_time'],
397          3,
398          '.',
399          ' '
400          ).' s',
401        'NB_QUERIES' => $page['count_queries']
402        )
403      );
404
405    array_push($page['infos'],
406      l10n('Perform a maintenance check in [Administration>Tools>Maintenance] if you encounter any problem.')
407      );
408
409    // Save $page['infos'] in order to restore after maintenance actions
410    $page['infos_sav'] = $page['infos'];
411    $page['infos'] = array();
412
413    // c13y_upgrade plugin means "check integrity after upgrade", so it
414    // becomes useful just after an upgrade
415    $query = '
416REPLACE INTO '.PLUGINS_TABLE.'
417  (id, state)
418  VALUES (\'c13y_upgrade\', \'active\')
419;';
420    pwg_query($query);
421
422    // Delete cache data
423    invalidate_user_cache(true);
424    $template->delete_compiled_templates();
425
426    // Tables Maintenance
427    do_maintenance_all_tables();
428
429    // Restore $page['infos'] in order to hide informations messages from functions calles
430    // errors messages are not hide
431    $page['infos'] = $page['infos_sav'];
432
433  }
434}
435
436// +-----------------------------------------------------------------------+
437// |                          start template output                        |
438// +-----------------------------------------------------------------------+
439else
440{
441  if (!defined('PWG_CHARSET'))
442  {
443    define('PWG_CHARSET', 'utf-8');
444  }
445
446  include_once(PHPWG_ROOT_PATH.'admin/include/languages.class.php');
447  $languages = new languages();
448 
449  foreach ($languages->fs_languages as $language_code => $fs_language)
450  {
451    if ($language == $language_code)
452    {
453      $template->assign('language_selection', $language_code);
454    }
455    $languages_options[$language_code] = $fs_language['name'];
456  }
457  $template->assign('language_options', $languages_options);
458
459  $template->assign('introduction', array(
460    'CURRENT_RELEASE' => $current_release,
461    'F_ACTION' => 'upgrade.php?language=' . $language));
462
463  if (!check_upgrade())
464  {
465    $template->assign('login', true);
466  }
467}
468
469if (count($page['errors']) != 0)
470{
471  $template->assign('errors', $page['errors']);
472}
473
474if (count($page['infos']) != 0)
475{
476  $template->assign('infos', $page['infos']);
477}
478
479// +-----------------------------------------------------------------------+
480// |                          sending html code                            |
481// +-----------------------------------------------------------------------+
482
483$template->pparse('upgrade');
484?>
Note: See TracBrowser for help on using the repository browser.