source: branches/2.0/upgrade.php @ 8154

Last change on this file since 8154 was 5233, checked in by ddtddt, 15 years ago

[Branche2] localisation hu/RU feature:1526 and feature:1527

  • Property svn:eol-style set to LF
  • Property svn:keywords set to Author Date Id Revision
File size: 11.9 KB
RevLine 
[1927]1<?php
2// +-----------------------------------------------------------------------+
[2297]3// | Piwigo - a PHP based picture gallery                                  |
4// +-----------------------------------------------------------------------+
[3046]5// | Copyright(C) 2008-2009 Piwigo Team                  http://piwigo.org |
[2297]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// +-----------------------------------------------------------------------+
[1927]23
24define('PHPWG_ROOT_PATH', './');
25
[2864]26// load config file
27$config_file = PHPWG_ROOT_PATH.'include/mysql.inc.php';
28$config_file_contents = @file_get_contents($config_file);
29if ($config_file_contents === false)
[2837]30{
[2864]31  die('Cannot load '.$config_file);
[2837]32}
[2864]33$php_end_tag = strrpos($config_file_contents, '?'.'>');
34if ($php_end_tag === false)
35{
36  die('Cannot find php end tag in '.$config_file);
37}
[2837]38
[1927]39include_once(PHPWG_ROOT_PATH.'include/functions.inc.php');
40include_once(PHPWG_ROOT_PATH.'admin/include/functions.php');
41include_once(PHPWG_ROOT_PATH.'admin/include/functions_upgrade.php');
42
43include(PHPWG_ROOT_PATH.'include/mysql.inc.php');
44include(PHPWG_ROOT_PATH . 'include/config_default.inc.php');
45@include(PHPWG_ROOT_PATH. 'include/config_local.inc.php');
46
[2096]47prepare_conf_upgrade();
[1927]48
49include_once(PHPWG_ROOT_PATH.'include/constants.php');
50define('PREFIX_TABLE', $prefixeTable);
51
52// Database connection
[2512]53mysql_connect( $cfgHote, $cfgUser, $cfgPassword ) or die ( "Could not connect to database server" );
54mysql_select_db( $cfgBase ) or die ( "Could not connect to database" );
55if ( version_compare(mysql_get_server_info(), '4.1.0', '>=')
56    and defined('DB_CHARSET') and DB_CHARSET!='' )
57{
58  pwg_query('SET NAMES "'.DB_CHARSET.'"');
59}
60
[1927]61// +-----------------------------------------------------------------------+
62// |                              functions                                |
63// +-----------------------------------------------------------------------+
64
65/**
66 * list all tables in an array
67 *
68 * @return array
69 */
70function get_tables()
71{
72  $tables = array();
[2290]73
[1927]74  $query = '
75SHOW TABLES
76;';
[2885]77  $result = pwg_query($query);
[1927]78
79  while ($row = mysql_fetch_row($result))
80  {
81    if (preg_match('/^'.PREFIX_TABLE.'/', $row[0]))
82    {
83      array_push($tables, $row[0]);
84    }
85  }
86
87  return $tables;
88}
89
90/**
91 * list all columns of each given table
92 *
93 * @return array of array
94 */
95function get_columns_of($tables)
96{
97  $columns_of = array();
98
99  foreach ($tables as $table)
100  {
101    $query = '
102DESC '.$table.'
103;';
[2885]104    $result = pwg_query($query);
[1927]105
106    $columns_of[$table] = array();
107
108    while ($row = mysql_fetch_row($result))
109    {
110      array_push($columns_of[$table], $row[0]);
111    }
112  }
113
114  return $columns_of;
115}
116
117/**
118 */
119function print_time($message)
120{
121  global $last_time;
[2290]122
[1927]123  $new_time = get_moment();
124  echo '<pre>['.get_elapsed_time($last_time, $new_time).']';
125  echo ' '.$message;
126  echo '</pre>';
127  flush();
128  $last_time = $new_time;
129}
130
131// +-----------------------------------------------------------------------+
132// |                             playing zone                              |
133// +-----------------------------------------------------------------------+
134
135// echo implode('<br>', get_tables());
136// echo '<pre>'; print_r(get_columns_of(get_tables())); echo '</pre>';
137
138// foreach (get_available_upgrade_ids() as $upgrade_id)
139// {
140//   echo $upgrade_id, '<br>';
141// }
142
143// +-----------------------------------------------------------------------+
[2820]144// |                             language                                  |
145// +-----------------------------------------------------------------------+
146if (isset($_GET['language']))
147{
148  $language = strip_tags($_GET['language']);
149}
150else
151{
152  $language = 'en_UK';
153  // Try to get browser language
154  foreach (get_languages('utf-8') as $language_code => $language_name)
155  {
156    if (substr($language_code,0,2) == @substr($_SERVER["HTTP_ACCEPT_LANGUAGE"],0,2))
157    {
158      $language = $language_code;
159      break;
160    }
161  }
162}
163
[3204]164if ('fr_FR' == $language) {
165  define('PHPWG_DOMAIN', 'fr.piwigo.org');
166}
[4189]167else if ('it_IT' == $language) {
168  define('PHPWG_DOMAIN', 'it.piwigo.org');
169}
170else if ('de_DE' == $language) {
171  define('PHPWG_DOMAIN', 'de.piwigo.org');
172}
173else if ('es_ES' == $language) {
174  define('PHPWG_DOMAIN', 'es.piwigo.org');
175}
[4758]176else if ('pl_PL' == $language) {
177  define('PHPWG_DOMAIN', 'pl.piwigo.org');
178}
179else if ('zh_CN' == $language) {
180  define('PHPWG_DOMAIN', 'cn.piwigo.org');
181}
[5233]182else if ('hu_HU' == $language) {
183  define('PHPWG_DOMAIN', 'hu.piwigo.org');
184}
185else if ('ru_RU' == $language) {
186  define('PHPWG_DOMAIN', 'ru.piwigo.org');
187}
[3204]188else {
189  define('PHPWG_DOMAIN', 'piwigo.org');
190}
191define('PHPWG_URL', 'http://'.PHPWG_DOMAIN);
192
[2837]193load_language( 'common.lang', '', array('language'=>$language, 'target_charset'=>'utf-8', 'no_fallback' => true) );
194load_language( 'admin.lang', '', array('language'=>$language, 'target_charset'=>'utf-8', 'no_fallback' => true) );
[3204]195load_language( 'install.lang', '', array('language'=>$language, 'target_charset'=>'utf-8', 'no_fallback' => true) );
[2837]196load_language( 'upgrade.lang', '', array('language'=>$language, 'target_charset'=>'utf-8', 'no_fallback' => true) );
[2820]197
[3204]198// check php version
199if (version_compare(PHP_VERSION, REQUIRED_PHP_VERSION, '<'))
200{
201  include(PHPWG_ROOT_PATH.'install/php5_apache_configuration.php');
202}
203
[2820]204// +-----------------------------------------------------------------------+
[1927]205// |                        template initialization                        |
206// +-----------------------------------------------------------------------+
207
[3204]208include( PHPWG_ROOT_PATH .'include/template.class.php');
[2820]209$template = new Template(PHPWG_ROOT_PATH.'admin/template/goto', 'roma');
[1927]210$template->set_filenames(array('upgrade'=>'upgrade.tpl'));
[3204]211$template->assign(array(
212  'RELEASE' => PHPWG_VERSION,
213  'L_UPGRADE_HELP' => sprintf(l10n('install_help'), PHPWG_URL.'/forum'),
214  )
215);
[1927]216
217// +-----------------------------------------------------------------------+
218// |                            upgrade choice                             |
219// +-----------------------------------------------------------------------+
220
[1999]221$tables = get_tables();
222$columns_of = get_columns_of($tables);
223
[2837]224// find the current release
225if (!in_array('param', $columns_of[PREFIX_TABLE.'config']))
[1927]226{
[2837]227  // we're in branch 1.3, important upgrade, isn't it?
228  if (in_array(PREFIX_TABLE.'user_category', $tables))
[1927]229  {
[2837]230    $current_release = '1.3.1';
[1927]231  }
[2837]232  else
[1927]233  {
[2837]234    $current_release = '1.3.0';
[1927]235  }
[2837]236}
237else if (!in_array(PREFIX_TABLE.'user_cache', $tables))
238{
239  $current_release = '1.4.0';
240}
241else if (!in_array(PREFIX_TABLE.'tags', $tables))
242{
243  $current_release = '1.5.0';
244}
[2861]245else if ( !in_array(PREFIX_TABLE.'plugins', $tables) )
[2837]246{
247  if (!in_array('auto_login_key', $columns_of[PREFIX_TABLE.'user_infos']))
[1927]248  {
[2837]249    $current_release = '1.6.0';
[1927]250  }
251  else
252  {
[2837]253    $current_release = '1.6.2';
[1927]254  }
255}
[2837]256else if (!in_array('md5sum', $columns_of[PREFIX_TABLE.'images']))
257{
258  $current_release = '1.7.0';
259}
260else
261{
262  die('No upgrade required, the database structure is up to date');
263}
[1927]264
265// +-----------------------------------------------------------------------+
266// |                            upgrade launch                             |
267// +-----------------------------------------------------------------------+
[2837]268$page['infos'] = array();
269$page['errors'] = array();
[2864]270$mysql_changes = array();
[1927]271
[2837]272if (isset($_POST['username']) and isset($_POST['password']))
[1927]273{
[2837]274  check_upgrade_access_rights($current_release, $_POST['username'], $_POST['password']);
275}
[2254]276
[2837]277if (isset($_POST['submit']) and check_upgrade())
278{
279  $upgrade_file = PHPWG_ROOT_PATH.'install/upgrade_'.$current_release.'.php';
[1927]280  if (is_file($upgrade_file))
281  {
282    $page['upgrade_start'] = get_moment();
283    $conf['die_on_sql_error'] = false;
284    include($upgrade_file);
285
[2864]286    // Something to add in mysql.inc.php?
287    if (!empty($mysql_changes))
288    {
289      $config_file_contents = 
290        substr($config_file_contents, 0, $php_end_tag) . "\r\n"
[2866]291        . implode("\r\n" , $mysql_changes) . "\r\n"
[2864]292        . substr($config_file_contents, $php_end_tag);
293
294      if (!@file_put_contents($config_file, $config_file_contents))
295      {
296        array_push($page['infos'],
297          l10n('in include/mysql.inc.php, before ?>, insert:') . '
[2866]298<p><textarea rows="4" cols="40">'.implode("\r\n" , $mysql_changes).'</textarea></p>'
[2864]299          );
300      }
301    }
302
[2788]303    // Plugins deactivation
304    if (in_array(PREFIX_TABLE.'plugins', $tables))
305    {
[2816]306      deactivate_non_standard_plugins();
[2788]307    }
308
[2102]309    // Create empty local files to avoid log errors
310    create_empty_local_files();
[2254]311
[1927]312    $page['upgrade_end'] = get_moment();
313
[2254]314    $template->assign(
[1927]315      'upgrade',
316      array(
[2837]317        'VERSION' => $current_release,
[1927]318        'TOTAL_TIME' => get_elapsed_time(
319          $page['upgrade_start'],
320          $page['upgrade_end']
321          ),
322        'SQL_TIME' => number_format(
323          $page['queries_time'],
324          3,
325          '.',
326          ' '
327          ).' s',
328        'NB_QUERIES' => $page['count_queries']
329        )
330      );
331
[2820]332    array_push($page['infos'],
333      l10n('perform a maintenance check')
[1927]334      );
335
[3073]336    // Save $page['infos'] in order to restore after maintenance actions
337    $page['infos_sav'] = $page['infos'];
338    $page['infos'] = array();
339
[2811]340    // c13y_upgrade plugin means "check integrity after upgrade", so it
341    // becomes useful just after an upgrade
[2809]342    $query = '
343REPLACE INTO '.PLUGINS_TABLE.'
344  (id, state)
345  VALUES (\'c13y_upgrade\', \'active\')
346;';
347    pwg_query($query);
[2891]348
349    // Delete cache data
350    invalidate_user_cache(true);
351    $template->delete_compiled_templates();
352
353    // Tables Maintenance
[3076]354    // Disabled optimization table for branch 2.0 only
355    //do_maintenance_all_tables();
[2891]356
[3073]357    // Restore $page['infos'] in order to hide informations messages from functions calles
358    // errors messages are not hide
359    $page['infos'] = $page['infos_sav'];
360
[1927]361  }
[2837]362}
363
364// +-----------------------------------------------------------------------+
365// |                          start template output                        |
366// +-----------------------------------------------------------------------+
367else
368{
369  foreach (get_languages('utf-8') as $language_code => $language_name)
[1927]370  {
[2837]371    if ($language == $language_code)
372    {
373      $template->assign('language_selection', $language_code);
374    }
375    $languages_options[$language_code] = $language_name;
[1927]376  }
[2837]377  $template->assign('language_options', $languages_options);
378
379  $template->assign('introduction', array(
380    'CURRENT_RELEASE' => $current_release,
381    'F_ACTION' => 'upgrade.php?language=' . $language));
382
383  if (!check_upgrade())
384  {
385    $template->assign('login', true);
386  }
[1927]387}
388
[2837]389if (count($page['errors']) != 0)
390{
391  $template->assign('errors', $page['errors']);
392}
393
394if (count($page['infos']) != 0)
395{
396  $template->assign('infos', $page['infos']);
397}
398
[1927]399// +-----------------------------------------------------------------------+
400// |                          sending html code                            |
401// +-----------------------------------------------------------------------+
402
403$template->pparse('upgrade');
404?>
Note: See TracBrowser for help on using the repository browser.