source: branches/1.4/upgrade.php @ 27558

Last change on this file since 27558 was 682, checked in by plg, 19 years ago
  • in install.php, use the temporary variable $prefixeTable for inclusion of file include/constants.php
  • security check in upgrade.php : no upgrade possible if constant PHPWG_INSTALLED is defined
  • Property svn:eol-style set to native
  • Property svn:keywords set to Author Date Id Revision
File size: 7.2 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-2005 PhpWebGallery Team - http://phpwebgallery.net |
6// +-----------------------------------------------------------------------+
7// | branch        : BSF (Best So Far)
8// | file          : $RCSfile$
9// | last update   : $Date: 2005-01-08 23:56:59 +0000 (Sat, 08 Jan 2005) $
10// | last modifier : $Author: plg $
11// | revision      : $Revision: 682 $
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('IN_UPGRADE', true);
29define('PHPWG_ROOT_PATH', './');
30
31include_once(PHPWG_ROOT_PATH.'include/functions.inc.php');
32include_once(PHPWG_ROOT_PATH.'admin/include/functions.php');
33include(PHPWG_ROOT_PATH.'include/template.php');
34
35include(PHPWG_ROOT_PATH.'include/mysql.inc.php');
36// Is PhpWebGallery already installed ?
37if (defined('PHPWG_INSTALLED'))
38{
39  $message = 'PhpWebGallery is already installed. In include/mysql.inc.php,
40remove line
41<pre style="background-color:lightgray">
42define(\'PHPWG_INSTALLED\', true);
43</pre>
44if you want to upgrade';
45  die($message);
46}
47
48include_once(PHPWG_ROOT_PATH.'include/constants.php');
49define('PREFIX_TABLE', $prefixeTable);
50
51$conf['show_queries'] = false;
52
53// Database connection
54mysql_connect( $cfgHote, $cfgUser, $cfgPassword )
55or die ( "Could not connect to database server" );
56mysql_select_db( $cfgBase )
57or die ( "Could not connect to database" );
58// +-----------------------------------------------------------------------+
59// |                            tricky output                              |
60// +-----------------------------------------------------------------------+
61echo '<!-- This is an HTML comment given in order to make IE outputs';
62echo ' the code.'."\n";
63echo ' Indeed, IE doesn\'t start to send output until a limit';
64echo ' of XXX bytes '."\n";
65echo str_repeat( ' ', 80 )."\n";
66echo str_repeat( ' ', 80 )."\n";
67echo str_repeat( ' ', 80 )."\n";
68echo '-->'."\n";
69flush();
70// +-----------------------------------------------------------------------+
71// |                              functions                                |
72// +-----------------------------------------------------------------------+
73
74/**
75 * loads an sql file and executes all queries
76 *
77 * Before executing a query, $replaced is... replaced by $replacing. This is
78 * useful when the SQL file contains generic words. Drop table queries are
79 * not executed.
80 *
81 * @param string filepath
82 * @param string replaced
83 * @param string replacing
84 * @return void
85 */
86function execute_sqlfile($filepath, $replaced, $replacing)
87{
88  $sql_lines = file($filepath);
89  $query = '';
90  foreach ($sql_lines as $sql_line)
91  {
92    $sql_line = trim($sql_line);
93    if (preg_match('/(^--|^$)/', $sql_line))
94    {
95      continue;
96    }
97    $query.= ' '.$sql_line;
98    // if we reached the end of query, we execute it and reinitialize the
99    // variable "query"
100    if (preg_match('/;$/', $sql_line))
101    {
102      $query = trim($query);
103      $query = str_replace($replaced, $replacing, $query);
104      // we don't execute "DROP TABLE" queries
105      if (!preg_match('/^DROP TABLE/i', $query))
106      {
107        mysql_query($query);
108      }
109      $query = '';
110    }
111  }
112}
113// +-----------------------------------------------------------------------+
114// |                        template initialization                        |
115// +-----------------------------------------------------------------------+
116$template = setup_style('default');
117$template->set_filenames(array('upgrade'=>'upgrade.tpl'));
118$template->assign_vars(array('RELEASE'=>PHPWG_VERSION));
119// +-----------------------------------------------------------------------+
120// |                          versions upgradable                          |
121// +-----------------------------------------------------------------------+
122$versions = array();
123$path = PHPWG_ROOT_PATH.'install';
124if ($contents = opendir($path))
125{
126  while (($node = readdir($contents)) !== false)
127  {
128    if (is_file($path.'/'.$node)
129        and preg_match('/^upgrade_(.*?)\.php$/', $node, $match))
130    {
131      array_push($versions, $match[1]);
132    }
133  }
134}
135natcasesort($versions);
136// +-----------------------------------------------------------------------+
137// |                            upgrade choice                             |
138// +-----------------------------------------------------------------------+
139if (!isset($_GET['version']))
140{
141  $template->assign_block_vars('choices', array());
142  foreach ($versions as $version)
143  {
144    $template->assign_block_vars(
145      'choices.choice',
146      array(
147        'URL' => PHPWG_ROOT_PATH.'upgrade.php?version='.$version,
148        'VERSION' => $version
149        ));
150  }
151}
152// +-----------------------------------------------------------------------+
153// |                            upgrade launch                             |
154// +-----------------------------------------------------------------------+
155else
156{
157  $upgrade_file = $path.'/upgrade_'.$_GET['version'].'.php';
158  if (is_file($upgrade_file))
159  {
160    $page['upgrade_start'] = get_moment();
161    include($upgrade_file);
162    $page['upgrade_end'] = get_moment();
163
164    $template->assign_block_vars(
165      'upgrade',
166      array(
167        'VERSION' => $_GET['version'],
168        'TOTAL_TIME' => get_elapsed_time($page['upgrade_start'],
169                                         $page['upgrade_end']),
170        'SQL_TIME' => number_format($page['queries_time'], 3, '.', ' ').' s',
171        'NB_QUERIES' => $page['count_queries']
172        ));
173
174    if (!isset($infos))
175    {
176      $infos = array();
177    }
178    array_push(
179      $infos,
180      '[security] delete files "upgrade.php", "install.php" and "install"
181directory');
182   
183    $template->assign_block_vars('upgrade.infos', array());
184   
185    foreach ($infos as $info)
186    {
187      $template->assign_block_vars('upgrade.infos.info',
188                                   array('CONTENT' => $info));
189    }
190  }
191  else
192  {
193    die('Hacking attempt');
194  }
195}
196// +-----------------------------------------------------------------------+
197// |                          sending html code                            |
198// +-----------------------------------------------------------------------+
199$template->pparse('upgrade');
200?>
Note: See TracBrowser for help on using the repository browser.