Project

General

Profile

1 1457 Luisehahne
<?php
2
/**
3 1866 Luisehahne
 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
4 1457 Luisehahne
 *
5 1866 Luisehahne
 * This program is free software: you can redistribute it and/or modify
6
 * it under the terms of the GNU General Public License as published by
7
 * the Free Software Foundation, either version 3 of the License, or
8
 * (at your option) any later version.
9 1457 Luisehahne
 *
10 1866 Luisehahne
 * This program is distributed in the hope that it will be useful,
11
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
12
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
13
 * GNU General Public License for more details.
14
 *
15
 * You should have received a copy of the GNU General Public License
16
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
17 1457 Luisehahne
 */
18
19 1866 Luisehahne
/**
20
 *
21
 *
22 1875 Luisehahne
 * @category     Core
23 1935 darkviper
 * @package      Core_service
24 1875 Luisehahne
 * @subpackage   upgrade-script
25
 * @author       Dietmar Wöllbrink <dietmar.woellbrink@websitebaker.org>
26 1866 Luisehahne
 * @author       Werner v.d.Decken <wkl@isteam.de>
27
 * @copyright    Werner v.d.Decken <wkl@isteam.de>
28
 * @license      http://www.gnu.org/licenses/gpl.html   GPL License
29
 * @version      0.0.1
30
 * @revision     $Revision$
31
 * @link         $HeadURL$
32
 * @lastmodified $Date$
33
 * @since        File available since 17.01.2013
34
 * @deprecated
35
 * @description  xyz
36
 */
37 1785 Luisehahne
// Include config file
38
$config_file = realpath('config.php');
39
if(file_exists($config_file) && !defined('WB_URL'))
40
{
41 1813 Luisehahne
	require($config_file);
42 1870 Luisehahne
43 1785 Luisehahne
}
44 1920 Luisehahne
//require_once(WB_PATH.'/framework/class.admin.php');
45
if(!class_exists('admin', false)){ include(WB_PATH.'/framework/class.admin.php'); }
46
$admin = new admin('Addons', 'modules', false, false);
47
48 1870 Luisehahne
// solved wrong pages_directory value before creating access files
49 1871 Luisehahne
$sql  = 'SELECT `value` FROM `'.TABLE_PREFIX.'settings` '
50
      . 'WHERE `name`=\'pages_directory\'';
51
$sPagesDirectory = WbDatabase::getInstance()->get_one($sql);
52
$sTmp = trim($sPagesDirectory, '/');
53
$sTmp = ($sTmp == '' ? '' : '/'.$sTmp);
54
if($sTmp != $sPagesDirectory) {
55
 $sql = 'UPDATE `'.TABLE_PREFIX.'settings` '
56
      . 'SET `value` = \''.$sTmpDir.'\' '
57
      . 'WHERE `name`=\'pages_directory\' ';
58
 WbDatabase::getInstance()->query($sql);
59 1870 Luisehahne
}
60 1484 Luisehahne
require_once(WB_PATH.'/framework/functions.php');
61 1684 Luisehahne
// require_once(WB_PATH.'/framework/Database.php');
62 1484 Luisehahne
63 1677 Luisehahne
$oldVersion  = 'Version '.WB_VERSION;
64 1689 darkviper
$oldVersion .= (defined('WB_SP') ? WB_SP : '');
65 1688 Luisehahne
$oldRevision = (defined('WB_REVISION') ? ' Revision ['.WB_REVISION.'] ' : '') ;
66 1677 Luisehahne
$newVersion  = 'Version '.VERSION;
67 1689 darkviper
$newVersion .= (defined('SP') ? SP : '');
68 1688 Luisehahne
$newRevision = (defined('REVISION') ? ' Revision ['.REVISION.'] ' : '');
69 1457 Luisehahne
70 1765 Luisehahne
$bDebugModus = false;
71
72 1677 Luisehahne
// set addition settings if not exists, otherwise upgrade will be breaks
73
if(!defined('WB_SP')) { define('WB_SP',''); }
74
if(!defined('WB_REVISION')) { define('WB_REVISION',''); }
75 1457 Luisehahne
// database tables including in WB package
76 1765 Luisehahne
$aPackage = array (
77 1457 Luisehahne
    'settings','groups','addons','pages','sections','search','users',
78 1889 Luisehahne
    'mod_captcha_control','mod_jsadmin','mod_menu_link','mod_output_filter','mod_wrapper','mod_wysiwyg'
79 1457 Luisehahne
);
80
81 1484 Luisehahne
$OK            = ' <span class="ok">OK</span> ';
82
$FAIL          = ' <span class="error">FAILED</span> ';
83
$DEFAULT_THEME = 'wb_theme';
84 1677 Luisehahne
85 1671 Luisehahne
$stepID = 0;
86 1883 Luisehahne
$filesRemove = array();
87 1765 Luisehahne
$aFilesToRemove = array();
88 1532 Luisehahne
$dirRemove = array(
89 1484 Luisehahne
/*
90
			'[TEMPLATE]/allcss/',
91
			'[TEMPLATE]/blank/',
92
			'[TEMPLATE]/round/',
93
			'[TEMPLATE]/simple/',
94
*/
95 1641 Luisehahne
			'[ADMIN]/themes/',
96 1484 Luisehahne
		 );
97 1866 Luisehahne
//
98
	$filesRemove['0'] = array(
99 1484 Luisehahne
100 1525 Luisehahne
			'[ADMIN]/preferences/details.php',
101
			'[ADMIN]/preferences/email.php',
102 1666 Luisehahne
			'[ADMIN]/preferences/password.php',
103 1684 Luisehahne
			'[ADMIN]/pages/settings2.php',
104 1813 Luisehahne
			'[ADMIN]/users/users.php',
105 1883 Luisehahne
			'[ADMIN]/groups/add.php',
106
			'[ADMIN]/groups/groups.php',
107
			'[ADMIN]/groups/save.php',
108 1866 Luisehahne
			'[ADMIN]/skel/themes/htt/groups.htt',
109 1525 Luisehahne
110 1684 Luisehahne
			'[FRAMEWORK]/class.msg_queue.php',
111 1689 darkviper
			'[FRAMEWORK]/class.logfile.php',
112 1785 Luisehahne
			'[MODULES]/droplets/js/mdcr.js',
113 1684 Luisehahne
114 1532 Luisehahne
		 );
115 1866 Luisehahne
	$aFilesToRemove = array_merge($filesRemove['0']);
116 1532 Luisehahne
117 1866 Luisehahne
// deleting files below only from less 2.8.4 stable
118 1883 Luisehahne
if(version_compare(WB_VERSION, '2.8.4', '<'))
119 1866 Luisehahne
{
120 1671 Luisehahne
	$filesRemove['1'] = array(
121 1532 Luisehahne
122 1529 Luisehahne
			'[TEMPLATE]/argos_theme/templates/access.htt',
123
			'[TEMPLATE]/argos_theme/templates/addons.htt',
124
			'[TEMPLATE]/argos_theme/templates/admintools.htt',
125
			'[TEMPLATE]/argos_theme/templates/error.htt',
126
			'[TEMPLATE]/argos_theme/templates/groups.htt',
127
			'[TEMPLATE]/argos_theme/templates/groups_form.htt',
128
			'[TEMPLATE]/argos_theme/templates/languages.htt',
129
			'[TEMPLATE]/argos_theme/templates/languages_details.htt',
130
			'[TEMPLATE]/argos_theme/templates/login.htt',
131
			'[TEMPLATE]/argos_theme/templates/login_forgot.htt',
132
			'[TEMPLATE]/argos_theme/templates/media.htt',
133
			'[TEMPLATE]/argos_theme/templates/media_browse.htt',
134
			'[TEMPLATE]/argos_theme/templates/media_rename.htt',
135
			'[TEMPLATE]/argos_theme/templates/modules.htt',
136
			'[TEMPLATE]/argos_theme/templates/modules_details.htt',
137
			'[TEMPLATE]/argos_theme/templates/pages.htt',
138
			'[TEMPLATE]/argos_theme/templates/pages_modify.htt',
139
			'[TEMPLATE]/argos_theme/templates/pages_sections.htt',
140
			'[TEMPLATE]/argos_theme/templates/pages_settings.htt',
141
			'[TEMPLATE]/argos_theme/templates/preferences.htt',
142
			'[TEMPLATE]/argos_theme/templates/setparameter.htt',
143
			'[TEMPLATE]/argos_theme/templates/settings.htt',
144
			'[TEMPLATE]/argos_theme/templates/start.htt',
145
			'[TEMPLATE]/argos_theme/templates/success.htt',
146
			'[TEMPLATE]/argos_theme/templates/templates.htt',
147
			'[TEMPLATE]/argos_theme/templates/templates_details.htt',
148
			'[TEMPLATE]/argos_theme/templates/users.htt',
149
			'[TEMPLATE]/argos_theme/templates/users_form.htt',
150
151
			'[TEMPLATE]/wb_theme/templates/access.htt',
152
			'[TEMPLATE]/wb_theme/templates/addons.htt',
153
			'[TEMPLATE]/wb_theme/templates/admintools.htt',
154
			'[TEMPLATE]/wb_theme/templates/error.htt',
155
			'[TEMPLATE]/wb_theme/templates/groups.htt',
156
			'[TEMPLATE]/wb_theme/templates/groups_form.htt',
157
			'[TEMPLATE]/wb_theme/templates/languages.htt',
158
			'[TEMPLATE]/wb_theme/templates/languages_details.htt',
159
			'[TEMPLATE]/wb_theme/templates/login.htt',
160
			'[TEMPLATE]/wb_theme/templates/login_forgot.htt',
161
			'[TEMPLATE]/wb_theme/templates/media.htt',
162
			'[TEMPLATE]/wb_theme/templates/media_browse.htt',
163
			'[TEMPLATE]/wb_theme/templates/media_rename.htt',
164
			'[TEMPLATE]/wb_theme/templates/modules.htt',
165
			'[TEMPLATE]/wb_theme/templates/modules_details.htt',
166
			'[TEMPLATE]/wb_theme/templates/pages.htt',
167
			'[TEMPLATE]/wb_theme/templates/pages_modify.htt',
168
			'[TEMPLATE]/wb_theme/templates/pages_sections.htt',
169
			'[TEMPLATE]/wb_theme/templates/pages_settings.htt',
170
			'[TEMPLATE]/wb_theme/templates/preferences.htt',
171
			'[TEMPLATE]/wb_theme/templates/setparameter.htt',
172
			'[TEMPLATE]/wb_theme/templates/settings.htt',
173
			'[TEMPLATE]/wb_theme/templates/start.htt',
174
			'[TEMPLATE]/wb_theme/templates/success.htt',
175
			'[TEMPLATE]/wb_theme/templates/templates.htt',
176
			'[TEMPLATE]/wb_theme/templates/templates_details.htt',
177
			'[TEMPLATE]/wb_theme/templates/users.htt',
178 1866 Luisehahne
			'[TEMPLATE]/wb_theme/templates/users_form.htt'
179 1525 Luisehahne
		 );
180 1765 Luisehahne
181 1866 Luisehahne
	$aFilesToRemove = array_merge($aFilesToRemove,$filesRemove['1']);
182 1765 Luisehahne
183 1671 Luisehahne
}
184 1677 Luisehahne
/* display a status message on the screen **************************************
185
 * @param string $message: the message to show
186
 * @param string $class:   kind of message as a css-class
187
 * @param string $element: witch HTML-tag use to cover the message
188
 * @return void
189
 */
190 1765 Luisehahne
function status_msg($message, $class='check', $element='div')
191 1677 Luisehahne
{
192
	// returns a status message
193
	$msg  = '<'.$element.' class="'.$class.'">';
194
	$msg .= '<strong>'.strtoupper(strtok($class, ' ')).'</strong>';
195
	$msg .= $message.'</'.$element.'>';
196
	echo $msg;
197
}
198
199 1772 Luisehahne
/**
200
 * add_modify_field_in_database()
201
 *
202
 * @param mixed $sTable
203
 * @param mixed $sField
204
 * @param mixed $sDescription
205
 * @return
206
 */
207
function add_modify_field_in_database($sTable,$sField,$sDescription){
208 1889 Luisehahne
	global $OK,$FAIL,$bDebugModus;
209
	$database=WbDatabase::getInstance();
210 1866 Luisehahne
	$aDebugMessage = array();
211 1772 Luisehahne
	if(!$database->field_exists($sTable,$sField)) {
212
		$aDebugMessage[] = "<span>Adding field $sField to $sTable table</span>";
213
		$aDebugMessage[] = ($database->field_add($sTable, $sField, $sDescription) ? " $OK<br />" : " $FAIL!<br />");
214
	} else {
215
		$aDebugMessage[] = "<span>Modify field $sField to $sTable table</span>";
216
		$aDebugMessage[] = ($database->field_modify($sTable, $sField, $sDescription) ? " $OK<br />" : " $FAIL!<br />");
217
	}
218 1866 Luisehahne
	if($bDebugModus) {
219
		echo implode(PHP_EOL,$aDebugMessage);
220
	}
221
return;
222 1457 Luisehahne
}
223
224 1671 Luisehahne
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
225 1457 Luisehahne
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
226
<head>
227
<title>Upgrade script</title>
228
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
229
<style type="text/css">
230 1684 Luisehahne
html { overflow-y: scroll; /* Force firefox to always show room for a vertical scrollbar */ }
231 1457 Luisehahne
232
body {
233
	margin:0;
234
	padding:0;
235
	border:0;
236
	background: #EBF7FC;
237
	color:#000;
238
	font-family: 'Trebuchet MS', Verdana, Arial, Helvetica, Sans-Serif;
239
	font-size: small;
240
	height:101%;
241
}
242
243
#container {
244 1765 Luisehahne
	min-width:48em;
245
    width: 70%;
246 1866 Luisehahne
	background: #A8BCCB url(<?php echo WB_URL; ?>/templates/wb_theme/images/background.png) repeat-x;
247 1457 Luisehahne
	border:1px solid #000;
248
	color:#000;
249
	margin:2em auto;
250 1765 Luisehahne
	padding:0 20px;
251 1457 Luisehahne
	min-height: 500px;
252
	text-align:left;
253
}
254 1765 Luisehahne
.page {
255
	width:100%;
256
    overflow: hidden;
257
}
258
.content {
259
    padding: 10px;
260
}
261 1457 Luisehahne
p { line-height:1.5em; }
262
263 1532 Luisehahne
form {
264
	display: inline-block;
265
	line-height: 20px;
266
	vertical-align: baseline;
267
}
268
input[type="submit"].restart {
269
	background-color: #FFDBDB;
270
	font-weight: bold;
271
}
272
273 1457 Luisehahne
h1,h2,h3,h4,h5,h6 {
274
	font-family: Verdana, Arial, Helvetica, sans-serif;
275 1765 Luisehahne
	color: #26527D;
276 1457 Luisehahne
	margin-top: 1.0em;
277
	margin-bottom: 0.1em;
278
}
279
280
h1 { font-size:150%; }
281
h2 { font-size: 130%; border-bottom: 1px #CCC solid; }
282 1765 Luisehahne
h3 { font-size: 110%; font-weight: bold; }
283 1457 Luisehahne
284 1765 Luisehahne
textarea {
285
	width:100%;
286 1866 Luisehahne
	border: 2px groove #0F1D44;
287
	padding: 2px;
288
	color: #000;
289
	font-weight: normal;
290 1765 Luisehahne
}
291 1457 Luisehahne
.ok, .error { font-weight:bold; }
292
.ok { color:green; }
293
.error { color:red; }
294
.check { color:#555; }
295
296 1765 Luisehahne
span.ok,
297
span.error {
298
    margin-left: 0em;
299
}
300
301 1457 Luisehahne
.warning {
302
	background:#FFDBDB;
303 1765 Luisehahne
	padding:1em;
304 1457 Luisehahne
	margin-top:0.5em;
305 1765 Luisehahne
	border: 1px solid #DB0909;
306 1457 Luisehahne
}
307
.info {
308 1765 Luisehahne
	background:#C7F4C7;
309
	padding:1em;
310 1457 Luisehahne
	margin-top:0.5em;
311 1765 Luisehahne
	border: 1px solid #277A29;
312 1457 Luisehahne
}
313
314
</style>
315
</head>
316
<body>
317
<div id="container">
318 1765 Luisehahne
<div class="page">
319 1866 Luisehahne
<img src="<?php echo WB_URL; ?>/templates/wb_theme/images/logo.png" alt="WebsiteBaker Project" />
320 1765 Luisehahne
<div class="content">
321 1457 Luisehahne
<h1>WebsiteBaker Upgrade</h1>
322
<?php
323 1525 Luisehahne
	if( version_compare( WB_VERSION, '2.7', '<' )) {
324 1920 Luisehahne
		status_msg('<br />It is not possible to upgrade from WebsiteBaker Versions before 2.7.<br />For upgrading to version '.VERSION.' you must upgrade first to v.2.7 at least!!!', 'warning', 'div');
325 1457 Luisehahne
		echo "</div>
326 1866 Luisehahne
		</div>
327
		</div>
328 1457 Luisehahne
		</body>
329
		</html>
330
		";
331
		exit();
332
	}
333 1920 Luisehahne
if($admin->get_user_id()!=1){
334
	status_msg('<br /><h3>WebsiteBaker upgrading is not possible!<br />Before upgrading to Revision '.REVISION.' you have to login as System-Administrator!</h3>', 'warning', 'div');
335
        echo '<br /><br />';
336
// delete remember key of current user from database
337
//if (isset($_SESSION['USER_ID']) && isset($database)) {
338
//	$table = TABLE_PREFIX . 'users';
339
//	$sql = "UPDATE `$table` SET `remember_key` = '' WHERE `user_id` = '" . (int) $_SESSION['USER_ID'] . "'";
340
//	$database->query($sql);
341
//}
342 1532 Luisehahne
343 1920 Luisehahne
// delete remember key cookie if set
344 1935 darkviper
if (isset($_COOKIE['REMEMBER_KEY']) && !headers_sent() ) {
345 1920 Luisehahne
	setcookie('REMEMBER_KEY', '', time() - 3600, '/');
346
}
347
348
// delete most critical session variables manually
349
$_SESSION['USER_ID'] = null;
350
$_SESSION['GROUP_ID'] = null;
351
$_SESSION['GROUPS_ID'] = null;
352
$_SESSION['USERNAME'] = null;
353
$_SESSION['PAGE_PERMISSIONS'] = null;
354
$_SESSION['SYSTEM_PERMISSIONS'] = null;
355
// overwrite session array
356
$_SESSION = array();
357
// delete session cookie if set
358 1935 darkviper
if (isset($_COOKIE[session_name()]) && !headers_sent()) {
359 1920 Luisehahne
    setcookie(session_name(), '', time() - 42000, '/');
360
}
361
// delete the session itself
362
session_destroy();
363
status_msg('<br /><h3>After login as System-Adminstrator you have to start upgrade-script.php again!</h3>', 'info', 'div');
364
        echo '<br /><br />';
365
        if(defined('ADMIN_URL')) {
366
        	echo '<form action="'.ADMIN_URL.'/index.php" method="post">';
367
        	echo '&nbsp;<input name="backend_send" type="submit" value="Kick me to the Login" />';
368
        	echo '</form>';
369
        }
370
echo "<br /><br /></div>
371
	</div>
372
	</div>
373
	</body>
374
	</html>
375
	";
376
	exit();
377
}
378
379 1457 Luisehahne
?>
380 1765 Luisehahne
<p class="info">This script upgrades an existing WebsiteBaker <strong> <?php echo $oldRevision; ?></strong> installation to the <strong> <?php echo $newRevision ?> </strong>.<br />The upgrade script alters the existing WB database to reflect the changes introduced with WB 2.8.x</p>
381 1457 Luisehahne
382
<?php
383 1870 Luisehahne
384 1457 Luisehahne
/**
385
 * Check if disclaimer was accepted
386
 */
387 1765 Luisehahne
$bDebugModus = false;
388
$bDebugModus = ( (isset($_POST['debug_confirmed']) && $_POST['debug_confirmed'] == 'debug') ? true : false);
389 1457 Luisehahne
if (!(isset($_POST['backup_confirmed']) && $_POST['backup_confirmed'] == 'confirmed')) { ?>
390
<h2>Step 1: Backup your files</h2>
391 1785 Luisehahne
<h5 class="warning">It is highly recommended to <strong>create a manual backup</strong> of the entire <strong class="error"><?php echo  PAGES_DIRECTORY ?>/</strong> folder and the <strong>MySQL database</strong> before proceeding.</h5>
392
<p><strong class="error">Note: </strong>The upgrade script alters some settings of your existing database!!! You need to confirm the disclaimer before proceeding.</p>
393 1457 Luisehahne
394 1866 Luisehahne
<form action="<?php echo $_SERVER['SCRIPT_NAME'];?>" method="post">
395 1765 Luisehahne
<textarea cols="92" rows="5">DISCLAIMER: The WebsiteBaker upgrade script is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. One needs to confirm that a manual backup of the <?php echo  PAGES_DIRECTORY ?>/ folder (including all files and subfolders contained in it) and backup of the entire WebsiteBaker MySQL database was created before you can proceed.</textarea>
396
<br /><br /><input name="backup_confirmed" type="checkbox" value="confirmed" />&nbsp;<strong>I confirm that a manual backup of the <?php echo  PAGES_DIRECTORY ?>/ folder and the MySQL database was created.</strong>
397
<br /><br /><input name="debug_confirmed" type="checkbox" value="debug" />&nbsp;<strong>Here you can get more details during running upgrade.</strong>
398 1457 Luisehahne
<br /><br /><input name="send" type="submit" value="Start upgrade script" />
399
</form>
400
<br />
401
402
<?php
403 1765 Luisehahne
	status_msg('<strong> Notice:</strong><br />You need to confirm that you have created a manual backup of the '.PAGES_DIRECTORY.'/ directory and the MySQL database before you can proceed.', 'warning', 'div');
404 1866 Luisehahne
	echo "<br /><br /></div>
405
	</div>
406
	</div>
407
	</body>
408
	</html>";
409 1457 Luisehahne
	exit();
410
}
411
412
/**********************************************************
413 1765 Luisehahne
 *  - check tables coming with WebsiteBaker
414 1457 Luisehahne
 */
415 1889 Luisehahne
	$aMissingTables = UpgradeHelper::existsAllTables($aPackage);
416
	if( sizeof($aMissingTables) == 0){
417 1894 Luisehahne
        echo '<h4 style="margin-left:0;">NOTICE: '.sizeof($aPackage).' total tables included in package are successfully installed into your database `'.$database->DbName.'` '.$OK.'</h4>';
418 1889 Luisehahne
    } else {
419 1765 Luisehahne
        status_msg('<strong>:</strong><br />can\'t run Upgrade, missing tables', 'warning', 'div');
420
        echo '<h4>Missing required tables. You can install them in backend->addons->modules.<br />';
421
        echo 'Or if you uploaded per FTP install possible by backend->addons->modules->advanced.<br />';
422 1866 Luisehahne
        echo 'First rename or delete the upgrade-script.php, so the script can\'t start automatically by backend<br />';
423 1889 Luisehahne
        echo 'After installing missing tables upload and run again upgrade-script.php<br /><br /></h4>';
424
        echo '<h4 class="warning">';
425
        echo 'Missing required tables.<br /><br />';
426
        echo 'TABLE `'.implode('` missing! '.$FAIL.'<br />TABLE `',$aMissingTables).'` missing! '.$FAIL;
427
        echo '<br /><br /></h4>';
428 1765 Luisehahne
        echo '<br /><br />';
429
        if(isset($_SERVER['SCRIPT_NAME'])) {
430
        	echo '<form action="'.$_SERVER['SCRIPT_NAME'].'/">';
431
        	echo '&nbsp;<input type="submit" value="Start upgrade again" />';
432
        	echo '</form>';
433
        }
434
        if(defined('ADMIN_URL')) {
435 1866 Luisehahne
        	echo '<form action="'.ADMIN_URL.'/index.php" method="post">';
436
        	echo '&nbsp;<input name="backend_send" type="submit" value="kick me to the Backend" />';
437 1457 Luisehahne
        	echo '</form>';
438
        }
439
        echo "<br /><br /></div>
440 1765 Luisehahne
        </div>
441
        </div>
442 1457 Luisehahne
        </body>
443 1866 Luisehahne
        </html>";
444 1765 Luisehahne
445 1894 Luisehahne
		exit();
446
	}
447 1457 Luisehahne
448 1765 Luisehahne
echo '<h3>Step '.(++$stepID).': Setting default_theme</h3>';
449 1768 Luisehahne
$aDebugMessage = array();
450 1894 Luisehahne
	/**********************************************************
451
	 *  - Adding field default_theme to settings table
452
	 */
453
	$aDebugMessage[] = '<div style="margin-left:2em;">';
454
	$aDebugMessage[] = "<br /><span><strong>Adding default_theme to settings table</strong></span>";
455
	// db_update_key_value('settings', 'default_theme', $DEFAULT_THEME);
456
	$cfg = array(
457 1920 Luisehahne
		'default_theme' => $DEFAULT_THEME
458 1894 Luisehahne
	);
459
	$aDebugMessage[] = (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");
460
	$aDebugMessage[] = '</div>';
461 1457 Luisehahne
462 1768 Luisehahne
if($bDebugModus) {
463 1894 Luisehahne
	echo implode(PHP_EOL,$aDebugMessage);
464 1765 Luisehahne
}
465 1768 Luisehahne
$aDebugMessage = array();
466 1889 Luisehahne
echo'<h3>Step '.(++$stepID).': Updating core table included in package</h3>';
467 1894 Luisehahne
	/**********************************************************
468
	 *  - Adding field sec_anchor to settings table
469
	 */
470
	echo '<div style="margin-left:2em;">';
471
	echo "<h4>Adding/updating entries on table settings</h4>";
472
	$aDebugMessage[] = "<span>Adding/updating sec_anchor to settings table</span>";
473
	$cfg = array(
474 1920 Luisehahne
		'sec_anchor' => defined( 'SEC_ANCHOR' )&& (SEC_ANCHOR!='') ? SEC_ANCHOR : 'Sec'
475 1894 Luisehahne
	);
476
	$aDebugMessage[] = (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");
477 1457 Luisehahne
478 1894 Luisehahne
	/**********************************************************
479
	 *  - Adding redirect timer to settings table
480
	 */
481
	$aDebugMessage[] = "<span>Adding/updating redirect timer to settings table</span>";
482
	$cfg = array(
483
		'redirect_timer' => defined('REDIRECT_TIMER')&& (REDIRECT_TIMER!='') ? REDIRECT_TIMER : '1500'
484
	);
485
	$aDebugMessage[] = (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");
486 1484 Luisehahne
487 1894 Luisehahne
	/**********************************************************
488
	 *  - Adding default_time_formatr to settings table
489
	 */
490
	$aDebugMessage[] = "<span>Adding/updating default_time_format to settings table</span>";
491
	$cfg = array(
492
		'default_time_format' => defined('DEFAULT_TIME_FORMAT')&& (DEFAULT_TIME_FORMAT!='') ? DEFAULT_TIME_FORMAT : 'h:i A'
493
	);
494
	$aDebugMessage[] = (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");
495 1889 Luisehahne
496 1894 Luisehahne
	/**********************************************************
497
	 *  - Adding rename_files_on_upload to settings table
498
	 */
499
	$aDebugMessage[] = "<span>Adding/Updating rename_files_on_upload to settings table</span>";
500
	$cfg = array(
501
	    'rename_files_on_upload' => (defined('RENAME_FILES_ON_UPLOAD')&& (RENAME_FILES_ON_UPLOAD!='') ? RENAME_FILES_ON_UPLOAD : 'ph.*?,cgi,pl,pm,exe,com,bat,pif,cmd,src,asp,aspx,js')
502
	);
503
	if( version_compare( WB_VERSION, '2.8.2', '<' )) {
504
		$cfg = array(
505
		    'rename_files_on_upload' => 'ph.*?,cgi,pl,pm,exe,com,bat,pif,cmd,src,asp,aspx,js'
506
		);
507
	}
508
	$aDebugMessage[] = (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");
509 1457 Luisehahne
510 1894 Luisehahne
	/**********************************************************
511
	 *  - Adding mediasettings to settings table
512
	 */
513
	$aDebugMessage[] = "<span>Adding/updating mediasettings to settings table</span>";
514
	$cfg = array(
515
		'mediasettings' => (defined('MEDIASETTINGS')&& (MEDIASETTINGS!='') ? MEDIASETTINGS : ''),
516
	);
517 1671 Luisehahne
518 1894 Luisehahne
	$aDebugMessage[] = (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");
519 1671 Luisehahne
520 1894 Luisehahne
	/**********************************************************
521
	 *  - Adding fingerprint_with_ip_octets to settings table
522
	 */
523
	$aDebugMessage[] = "<span>Adding/updating fingerprint_with_ip_octets to settings table</span>";
524
	$cfg = array(
525
		'fingerprint_with_ip_octets' => (defined('FINGERPRINT_WITH_IP_OCTETS') ? FINGERPRINT_WITH_IP_OCTETS : '2'),
526
		'secure_form_module' => (defined('SECURE_FORM_MODULE') ? SECURE_FORM_MODULE : '')
527
	);
528 1671 Luisehahne
529 1894 Luisehahne
	$aDebugMessage[] = (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");
530 1671 Luisehahne
531 1894 Luisehahne
	/**********************************************************
532
	 *  - Adding page_icon_dir to settings table
533
	 */
534
	$aDebugMessage[] = "<span>Adding/updating page_icon_dir to settings table</span>";
535
	$cfg = array(
536
		'page_icon_dir' => (defined('PAGE_ICON_DIR')&& (PAGE_ICON_DIR!='') ? PAGE_ICON_DIR : '/templates/*/title_images'),
537
	);
538 1731 Luisehahne
539 1894 Luisehahne
	$aDebugMessage[] = (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");
540
	/**********************************************************
541
	 *  - Adding page_extended to settings table
542
	 */
543
	$aDebugMessage[] = "<span>Adding/updating page_extendet to settings table</span>";
544
	$cfg = array(
545
		'page_extendet' => (defined('PAGE_EXTENDET') ? PAGE_EXTENDET : 'true'),
546
	);
547 1745 Luisehahne
548 1894 Luisehahne
	$aDebugMessage[] = (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");
549 1457 Luisehahne
550 1894 Luisehahne
	/**********************************************************
551
	 *  - Adding wbmail_signature to settings table
552
	 */
553
	$aDebugMessage[] = "<span>Adding/updating wbmail_signature to settings table</span>";
554
	$cfg = array(
555
		'wbmail_signature' => (defined('WBMAIL_SIGNATURE')&& (WBMAIL_SIGNATURE!='') ? WBMAIL_SIGNATURE : '')
556
	);
557 1671 Luisehahne
558 1894 Luisehahne
	$aDebugMessage[] = (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");
559 1765 Luisehahne
560 1894 Luisehahne
	/**********************************************************
561
	 *  - Adding confirmed_registration to settings table
562
	 */
563
	$aDebugMessage[] = "<span>Adding/updating confirmed_registration to settings table</span>";
564
	$cfg = array(
565
		'confirmed_registration' => (defined('CONFIRMED_REGISTRATION') ? CONFIRMED_REGISTRATION : '0')
566
	);
567 1765 Luisehahne
568 1894 Luisehahne
	$aDebugMessage[] = (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");
569 1765 Luisehahne
570 1894 Luisehahne
	/**********************************************************
571
	 *  - Adding dev_infos to settings table
572
	 */
573
	$aDebugMessage[] = "<span>Adding/updating dev_infos to settings table</span>";
574
	$cfg = array(
575
		'dev_infos' => (defined('DEV_INFOS') ? DEV_INFOS : 'false')
576
	);
577 1765 Luisehahne
578 1768 Luisehahne
    $aDebugMessage[] = (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");
579 1765 Luisehahne
580 1930 darkviper
	/**********************************************************
581
	 *  - Adding password settings to settings table
582
	 */
583
	$aDebugMessage[] = "<span>Adding/updating password settings to settings table</span>";
584
	$cfg = array();
585
	$cfg['password_crypt_loops'] = (defined('PASSWORD_CRYPT_LOOPS') ? PASSWORD_CRYPT_LOOPS : '12');
586
	$cfg['password_hash_type'] = (defined('PASSWORD_HASH_TYPES') ? PASSWORD_HASH_TYPES : 'false');
587
	$cfg['password_length'] = (defined('PASSWORD_LENGTH') ? PASSWORD_LENGTH : '10');
588
	$cfg['password_use_types'] = (defined('PASSWORD_USE_TYPES') ? PASSWORD_USE_TYPES : (int)0xFFFF);
589
    $aDebugMessage[] = (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");
590
591 1768 Luisehahne
if($bDebugModus) {
592
    echo implode(PHP_EOL,$aDebugMessage);
593 1765 Luisehahne
}
594 1768 Luisehahne
echo '</div>';
595 1765 Luisehahne
596 1768 Luisehahne
$aDebugMessage = array();
597 1772 Luisehahne
if(version_compare(WB_REVISION, REVISION, '<='))
598 1671 Luisehahne
{
599 1894 Luisehahne
	echo '<div style="margin-left:2em;">';
600 1671 Luisehahne
	/**********************************************************
601
	 *  - Update search no results database filed to create
602
	 *  valid XHTML if search is empty
603
	 */
604
	if (version_compare(WB_VERSION, '2.8', '<'))
605
	{
606 1894 Luisehahne
		echo "<h4>Adding/updating fields on table search</h4>";
607
		echo "Updating database field `no_results` on search table: ";
608
		$search_no_results = addslashes('<tr><td><p>[TEXT_NO_RESULTS]</p></td></tr>');
609
		$sql  = 'UPDATE `'.TABLE_PREFIX.'search` ';
610 1671 Luisehahne
		$sql .= 'SET `value`=\''.$search_no_results.'\' ';
611
		$sql .= 'WHERE `name`=\'no_results\'';
612 1894 Luisehahne
		echo ($database->query($sql)) ? " $OK<br />" : " $FAIL!<br />";
613 1671 Luisehahne
	}
614 1760 Luisehahne
615 1894 Luisehahne
	$aDebugMessage = array();
616
	echo "<h4>Adding/updating field on table pages</h4>";
617 1671 Luisehahne
	/**********************************************************
618
	 *  - Add field "page_trail" to table "pages"
619
	 */
620
	$table_name = TABLE_PREFIX.'pages';
621
	$field_name = 'page_trail';
622
	$description = "VARCHAR( 255 ) NOT NULL DEFAULT ''";
623 1889 Luisehahne
	add_modify_field_in_database($table_name,$field_name,$description);
624 1671 Luisehahne
625
	/**********************************************************
626 1894 Luisehahne
	 *  - Add field "page_icon" to table "pages"
627
	 */
628 1671 Luisehahne
	$table_name = TABLE_PREFIX.'pages';
629
	$field_name = 'page_icon';
630 1684 Luisehahne
	$description = "VARCHAR( 512 ) NOT NULL DEFAULT '' AFTER `page_title`";
631 1894 Luisehahne
	add_modify_field_in_database($table_name,$field_name,$description);
632 1666 Luisehahne
633 1671 Luisehahne
	/**********************************************************
634
	 *  - Add field "page_code" to table "pages"
635
	 */
636
	$table_name = TABLE_PREFIX.'pages';
637
	$field_name = 'page_code';
638
	$description = "INT NOT NULL DEFAULT '0' AFTER `language`";
639 1894 Luisehahne
	add_modify_field_in_database($table_name,$field_name,$description);
640 1671 Luisehahne
641
	/**********************************************************
642 1894 Luisehahne
	 *  - Add field "menu_icon_0" to table "pages"
643
	 */
644 1671 Luisehahne
	$table_name = TABLE_PREFIX.'pages';
645
	$field_name = 'menu_icon_0';
646 1684 Luisehahne
	$description = "VARCHAR( 512 ) NOT NULL DEFAULT '' AFTER `menu_title`";
647 1894 Luisehahne
	add_modify_field_in_database($table_name,$field_name,$description);
648 1666 Luisehahne
649 1671 Luisehahne
	/**********************************************************
650
	 *  - Add field "menu_icon_1" to table "pages"
651 1894 Luisehahne
	 */
652 1671 Luisehahne
	$table_name = TABLE_PREFIX.'pages';
653
	$field_name = 'menu_icon_1';
654 1684 Luisehahne
	$description = "VARCHAR( 512 ) NOT NULL DEFAULT '' AFTER `menu_icon_0`";
655 1894 Luisehahne
	add_modify_field_in_database($table_name,$field_name,$description);
656 1666 Luisehahne
657 1671 Luisehahne
	/**********************************************************
658 1684 Luisehahne
	 *  - Add field "tooltip" to table "pages"
659 1894 Luisehahne
	 */
660 1684 Luisehahne
	$table_name = TABLE_PREFIX.'pages';
661
	$field_name = 'tooltip';
662
	$description = "VARCHAR( 512 ) NOT NULL DEFAULT '' AFTER `menu_icon_1`";
663 1894 Luisehahne
	add_modify_field_in_database($table_name,$field_name,$description);
664 1684 Luisehahne
665
	/**********************************************************
666 1671 Luisehahne
	 *  - Add field "admin_groups" to table "pages"
667 1894 Luisehahne
	 */
668 1671 Luisehahne
	$table_name = TABLE_PREFIX.'pages';
669
	$field_name = 'admin_groups';
670
	$description = "VARCHAR( 512 ) NOT NULL DEFAULT '1'";
671 1894 Luisehahne
	add_modify_field_in_database($table_name,$field_name,$description);
672 1671 Luisehahne
673
	/**********************************************************
674
	 *  - Add field "admin_users" to table "pages"
675
	 */
676
	$table_name = TABLE_PREFIX.'pages';
677
	$field_name = 'admin_users';
678
	$description = "VARCHAR( 512 ) NOT NULL DEFAULT ''";
679 1894 Luisehahne
	add_modify_field_in_database($table_name,$field_name,$description);
680 1671 Luisehahne
681
	/**********************************************************
682
	 *  - Add field "viewing_groups" to table "pages"
683
	 */
684
	$table_name = TABLE_PREFIX.'pages';
685
	$field_name = 'viewing_groups';
686
	$description = "VARCHAR( 512 ) NOT NULL DEFAULT '1'";
687 1894 Luisehahne
	 add_modify_field_in_database($table_name,$field_name,$description);
688 1671 Luisehahne
689
	/**********************************************************
690
	 *  - Add field "viewing_users" to table "pages"
691
	 */
692
	$table_name = TABLE_PREFIX.'pages';
693
	$field_name = 'viewing_users';
694
	$description = "VARCHAR( 512 ) NOT NULL DEFAULT ''";
695 1894 Luisehahne
	add_modify_field_in_database($table_name,$field_name,$description);
696 1755 Luisehahne
697 1768 Luisehahne
	/**********************************************************
698 1894 Luisehahne
	 *  - Add field "custom01" to table "pages"
699
	 */
700 1768 Luisehahne
	$table_name = TABLE_PREFIX.'pages';
701
	$field_name = 'custom01';
702
	$description = "VARCHAR( 255 ) NOT NULL DEFAULT '' ";
703 1894 Luisehahne
	add_modify_field_in_database($table_name,$field_name,$description);
704 1760 Luisehahne
705 1768 Luisehahne
	/**********************************************************
706 1894 Luisehahne
	 *  - Add field "custom02" to table "pages"
707
	 */
708 1768 Luisehahne
	$table_name = TABLE_PREFIX.'pages';
709
	$field_name = 'custom02';
710
	$description = "VARCHAR( 255 ) NOT NULL DEFAULT '' ";
711 1894 Luisehahne
	add_modify_field_in_database($table_name,$field_name,$description);
712 1768 Luisehahne
713 1894 Luisehahne
	if($bDebugModus) {
714
		echo implode(PHP_EOL,$aDebugMessage);
715
	}
716 1772 Luisehahne
717 1866 Luisehahne
	$aDebugMessage = array();
718
	/**********************************************************
719 1894 Luisehahne
	 * modify wrong strucre on table sections
720
	 * wrong structure let crash wb
721
	 */
722 1765 Luisehahne
	echo "<h4>Change field structure on table sections</h4>";
723
	$table_name = TABLE_PREFIX.'sections';
724
	$description = "VARCHAR( 255 ) NOT NULL DEFAULT ''";
725 1772 Luisehahne
	$aDebugMessage[] = "<span>Modify field module on sections table</span>";
726
	$aDebugMessage[] = ($database->field_modify($table_name, 'module', $description) ? " $OK<br />" : " $FAIL!<br />");
727
	$aDebugMessage[] = "<span>Modify field block on sections table</span>";
728 1889 Luisehahne
	$description = "int(11) NOT NULL DEFAULT '1'";
729 1772 Luisehahne
	$aDebugMessage[] = ($database->field_modify($table_name, 'block', $description) ? " $OK<br />" : " $FAIL!<br />");
730 1889 Luisehahne
	$description = "int(11) NOT NULL DEFAULT '0'";
731 1772 Luisehahne
	$aDebugMessage[] = "<span>Modify field publ_start on sections table</span>";
732
	$aDebugMessage[] = ($database->field_modify($table_name, 'publ_start', $description) ? " $OK<br />" : " $FAIL!<br />");
733
	$aDebugMessage[] = "<span>Modify field publ_end on sections table</span>";
734
	$aDebugMessage[] = ($database->field_modify($table_name, 'publ_end', $description) ? " $OK<br />" : " $FAIL!<br />");
735 1755 Luisehahne
736 1894 Luisehahne
	if($bDebugModus) {
737
		echo implode(PHP_EOL,$aDebugMessage);
738
	}
739
	echo '</div>';
740 1890 Luisehahne
}
741 1772 Luisehahne
742 1890 Luisehahne
if(version_compare(WB_REVISION, REVISION, '<='))
743
{
744 1894 Luisehahne
	$aDebugMessage = array();
745
	echo '<h3>Step '.(++$stepID).': Updating structure in table users/groups</h3>';
746 1789 Luisehahne
	/**********************************************************
747 1890 Luisehahne
	 * Modify Administrator on groups table
748
	 */
749
	echo '<div style="margin-left:2em;">';
750 1893 Luisehahne
	echo "<h4>Updating Administrator group permissions on table groups</h4>";
751 1789 Luisehahne
	$aDebugMessage[] = "<span>Modify Administrator on groups table</span>";
752 1866 Luisehahne
	$sModulePermissions = '';
753
	$sTemplatePermissions = '';
754 1789 Luisehahne
	$sSystemPermissions  = 'access,addons,admintools,admintools_view,groups,groups_add,groups_delete,groups_modify,groups_view,';
755
	$sSystemPermissions .= 'languages,languages_install,languages_uninstall,languages_view,media,media_create,media_delete,media_rename,media_upload,media_view,';
756
	$sSystemPermissions .= 'modules,modules_advanced,modules_install,modules_uninstall,modules_view,pages,pages_add,pages_add_l0,pages_delete,pages_intro,pages_modify,pages_settings,pages_view,';
757
	$sSystemPermissions .= 'preferences,preferences_view,settings,settings_advanced,settings_basic,settings_view,templates,templates_install,templates_uninstall,templates_view,users,users_add,users_delete,users_modify,users_view';
758
759
	$sql  = 'UPDATE `'.TABLE_PREFIX.'groups` ';
760
	$sql .= 'SET `name` = \'Administrators\', ';
761
	$sql .= '`system_permissions` = \''.$sSystemPermissions.'\', ';
762
	$sql .= '`module_permissions` = \''.$sModulePermissions.'\', ';
763
	$sql .= '`template_permissions` = \''.$sTemplatePermissions.'\' ';
764
	$sql .= 'WHERE `group_id` = \'1\' ';
765 1894 Luisehahne
	$aDebugMessage[] = ($database->query($sql)) ? " $OK<br />" : " $FAIL!<br />";
766
	if( ($admin->is_authenticated() == true) && ($admin->ami_group_member('1') ) ) {
767
	    $_SESSION['SYSTEM_PERMISSIONS'] = array_merge($_SESSION['SYSTEM_PERMISSIONS'], explode(',', $sSystemPermissions));
768
	}
769 1789 Luisehahne
770 1894 Luisehahne
	if($bDebugModus) {
771
		echo implode(PHP_EOL,$aDebugMessage);
772
	}
773
	echo '</div>';
774 1890 Luisehahne
	$aDebugMessage = array();
775
	/**********************************************************
776 1894 Luisehahne
	 *   `confirm_code` VARCHAR(32) NOT NULL DEFAULT '',
777
	 *   `confirm_timeout` INT(11) NOT NULL DEFAULT '0',
778
	 */
779 1890 Luisehahne
	echo '<div style="margin-left:2em;">';
780
	echo "<h4>Change field structure on table users</h4>";
781
	$table_name = TABLE_PREFIX.'users';
782
	$field_name = 'confirm_code';
783
	$description = "VARCHAR( 32 ) NOT NULL DEFAULT '' AFTER `password` ";
784 1894 Luisehahne
	add_modify_field_in_database($table_name,$field_name,$description);
785 1671 Luisehahne
786 1890 Luisehahne
	$table_name = TABLE_PREFIX.'users';
787
	$field_name = 'confirm_timeout';
788
	$description = "INT(11) NOT NULL DEFAULT '0' AFTER `confirm_code` ";
789 1894 Luisehahne
	add_modify_field_in_database($table_name,$field_name,$description);
790 1890 Luisehahne
791 1894 Luisehahne
	if($bDebugModus) {
792
	    echo implode(PHP_EOL,$aDebugMessage);
793
	}
794
	echo '</div>';
795 1893 Luisehahne
796 1894 Luisehahne
	$aDebugMessage = array();
797
	/**********************************************************
798
	* Updating group_id in table users
799
	*/
800 1890 Luisehahne
	echo '<div style="margin-left:2em;">';
801 1893 Luisehahne
	echo "<h4>Updating users groups permissions on table groups</h4>";
802 1894 Luisehahne
	    $aUsers = array();
803 1813 Luisehahne
		// Get existing values
804
        $sql  = 'SELECT * FROM `'.TABLE_PREFIX.'users` ' ;
805
        $sql .= 'WHERE `user_id` != 1 ';
806
        if($oUser = $database->query($sql)){
807
            $iTotalUsers = $oUser->numRows();
808
            while($Users = $oUser->fetchRow(MYSQL_ASSOC)) {
809
                $aUsers[$Users['user_id']]['groups_id'] = $Users['groups_id'];
810
                $aUsers[$Users['user_id']]['display_name'] = $Users['display_name'];
811
            }
812
        } else {
813
            $aDebugMessage[] = $database->is_error()==false ? " $OK<br />" : " $FAIL!<br />";
814
        }
815
        foreach($aUsers AS $user_id => $value){
816
                // choose group_id from groups_id - workaround for still remaining calls to group_id (to be cleaned-up)
817 1815 Luisehahne
                $aGroups_id = explode(',', $aUsers[$user_id]['groups_id']);
818
                $groups_id = $aUsers[$user_id]['groups_id'];
819 1813 Luisehahne
                $group_id = 0;
820
                //if user is in administrator-group, get this group else just get the first one
821 1815 Luisehahne
                if($admin->is_group_match($aGroups_id,'1')) { $group_id = 1; $groups_id = '1'; } else { $group_id = intval($aGroups_id[0]); }
822 1813 Luisehahne
                $sMessage = "<span>Updating group_id ".$TEXT['DISPLAY_NAME']." " .$aUsers[$user_id]['display_name']."</span>";
823
                $sql  = 'UPDATE `'.TABLE_PREFIX.'users` ';
824 1815 Luisehahne
                $sql .= 'SET `group_id`  = '.$group_id.', ';
825 1817 Luisehahne
                $sql .=     '`groups_id` = \''.$groups_id.'\' ';
826 1813 Luisehahne
                $sql .= 'WHERE `user_id` = '.intval($user_id);
827
                if($oRes = $database->query($sql)){  }
828
                $aDebugMessage[] = $database->is_error()==false ? $sMessage." $OK<br />" : $sMessage." $FAIL!<br />";
829
        }
830
        unset($aUsers);
831 1894 Luisehahne
	$aDebugMessage[] = '</div>';
832 1813 Luisehahne
833 1894 Luisehahne
	if($bDebugModus) {
834
	// $aDebugMessage[] =
835
	    echo implode(PHP_EOL,$aDebugMessage);
836
	}else {
837
	    echo '<span><strong>'.$iTotalUsers.' users updating the groups</strong></span>'." $OK<br />";
838
	    echo '</div>';
839
	}
840 1813 Luisehahne
}
841
842
$aDebugMessage = array();
843 1866 Luisehahne
echo '<h3>Step '.(++$stepID).': Updating access and protected files in folders</h3>';
844 1765 Luisehahne
845
echo '<div style="margin-left:2em;">';
846 1894 Luisehahne
	/**********************************************************
847
	* upgrade media directory index protect files
848
	*/
849
	$dir = (WB_PATH.MEDIA_DIRECTORY);
850
	echo '<h4>Upgrade media directory '.MEDIA_DIRECTORY.'/ index.php protect files</h4>';
851
	$aDebugMessage = rebuildFolderProtectFile($dir);
852
	if( sizeof( $aDebugMessage ) ){
853
		echo '<span><strong>Upgrade '.sizeof( $aDebugMessage ).' directory '.MEDIA_DIRECTORY.'/ protect files</strong></span>'." $OK<br />";
854
	} else {
855
		echo '<span><strong>Upgrade directory '.MEDIA_DIRECTORY.'/ protect files</strong></span>'." $FAIL!<br />";
856
		echo implode ('<br />',$aDebugMessage);
857
	}
858 1677 Luisehahne
859 1866 Luisehahne
    $aDebugMessage = array();
860 1765 Luisehahne
    /**********************************************************
861
     * upgrade pages directory index access files
862
     */
863
	echo '<h4>Upgrade pages directory '.PAGES_DIRECTORY.'/  protect and access files</h4>';
864 1677 Luisehahne
865 1765 Luisehahne
    /**********************************************************
866
     *  - Reformat/rebuild all existing access files
867
     */
868
    $sPagePath = (defined('PAGES_DIRECTORY') && (PAGES_DIRECTORY != '') ? PAGES_DIRECTORY : '');
869
    $msg = rebuild_all_accessfiles();
870 1920 Luisehahne
	$dir = (WB_PATH.PAGES_DIRECTORY);
871
//	$aDebugMessage = rebuildFolderProtectFile($dir);
872 1866 Luisehahne
	echo '<strong>'.implode ('<br />',$msg).'</strong>';
873 1765 Luisehahne
    echo '</div>';
874 1866 Luisehahne
875 1883 Luisehahne
	/* *****************************************************************************
876
	 * - check for deprecated / never needed files
877
	 */
878
	$iLoaded = sizeof($aFilesToRemove);
879
	if($iLoaded) {
880
		echo '<h3>Step '.(++$stepID).': Remove deprecated and outdated files</h3>';
881
		$iFailed = 0;
882
		$iFound = 0;
883
		$searches = array(
884
			'[ADMIN]',
885
			'[MEDIA]',
886
			'[PAGES]',
887
			'[FRAMEWORK]',
888
			'[MODULES]',
889
			'[TEMPLATE]'
890
		);
891
		$replacements = array(
892
			'/'.substr(ADMIN_PATH, strlen(WB_PATH)+1),
893
			MEDIA_DIRECTORY,
894
			PAGES_DIRECTORY,
895
			'/framework',
896
			'/modules',
897
			'/templates'
898
		);
899 1677 Luisehahne
900 1532 Luisehahne
		$msg = '';
901 1883 Luisehahne
		echo '<div style="margin-left:2em;">';
902
		echo '<h4>Search '.$iLoaded.' deprecated and outdated files</h4>';
903
		foreach( $aFilesToRemove as $file )
904
		{
905 1532 Luisehahne
			$file = str_replace($searches, $replacements, $file);
906 1765 Luisehahne
			if( is_writable(WB_PATH.'/'.$file) ) {
907 1883 Luisehahne
				$iFound++;
908 1588 darkviper
				// try to unlink file
909 1765 Luisehahne
				if(!unlink(WB_PATH.$file)) {
910 1883 Luisehahne
					$iFailed++;
911 1801 Luisehahne
				}
912 1484 Luisehahne
			}
913 1883 Luisehahne
			if( is_readable(WB_PATH.'/'.$file) ) {
914
				// save in err-list, if failed
915
				$msg .= $file.'<br />';
916
			}
917
		}
918
		$iRemove = $iFound-$iFailed;
919
		echo '<strong>Remove '.$iRemove.' from '.$iFound.' founded</strong> ';
920
		echo ($iFailed == 0) ? $OK : $FAIL;
921
		echo '</div>';
922 1532 Luisehahne
923
		if($msg != '')
924
		{
925
			$msg = '<br /><br />Following files are deprecated, outdated or a security risk and
926
				    can not be removed automatically.<br /><br />Please delete them
927
					using FTP and restart upgrade-script!<br /><br />'.$msg.'<br />';
928 1889 Luisehahne
			status_msg($msg, 'error warning', 'div');
929 1532 Luisehahne
			echo '<p style="font-size:120%;"><strong>WARNING: The upgrade script failed ...</strong></p>';
930
931
			echo '<form action="'.$_SERVER['SCRIPT_NAME'].'">';
932
			echo '&nbsp;<input name="send" type="submit" value="Restart upgrade script" />';
933
			echo '</form>';
934 1866 Luisehahne
			echo "<br /><br /></div>
935
			</div>
936
			</div>
937
			</body>
938
			</html>";
939 1532 Luisehahne
			exit;
940
		}
941 1889 Luisehahne
	}
942 1484 Luisehahne
943 1532 Luisehahne
944 1883 Luisehahne
	/**********************************************************
945
	 * - check for deprecated / never needed files
946
	 */
947
	$iLoaded = sizeof($dirRemove);
948
	if($iLoaded) {
949
		echo '<h3>Step  '.(++$stepID).': Remove deprecated and outdated folders</h3>';
950
		$iFailed = 0;
951
		$iFound = 0;
952 1588 darkviper
		$searches = array(
953
			'[ADMIN]',
954
			'[MEDIA]',
955
			'[PAGES]',
956
			'[TEMPLATE]'
957
		);
958
		$replacements = array(
959
			substr(ADMIN_PATH, strlen(WB_PATH)+1),
960
			MEDIA_DIRECTORY,
961
			PAGES_DIRECTORY,
962
			'/templates',
963
		);
964
		$msg = '';
965 1883 Luisehahne
		echo '<div style="margin-left:2em;">';
966
		echo '<h4>Search '.$iLoaded.' deprecated and outdated folders</h4>';
967 1588 darkviper
		foreach( $dirRemove as $dir ) {
968
			$dir = str_replace($searches, $replacements, $dir);
969
			$dir = WB_PATH.'/'.$dir;
970
			if( is_dir( $dir )) {
971 1883 Luisehahne
				$iFound++;
972 1588 darkviper
			// try to delete dir
973 1641 Luisehahne
				if(!is_writable( $dir ) || !rm_full_dir($dir)) {
974 1588 darkviper
				// save in err-list, if failed
975 1883 Luisehahne
					$iFailed++;
976 1588 darkviper
				}
977 1525 Luisehahne
			}
978 1883 Luisehahne
			if( is_readable(WB_PATH.'/'.$dir) ) {
979
				$msg .= str_replace(WB_PATH,'',$dir).'<br />';
980
			}
981 1525 Luisehahne
		}
982 1883 Luisehahne
983
		$iRemove = $iFound-$iFailed;
984
		echo '<strong>Remove '.$iRemove.' from '.$iFound.' founded</strong> ';
985
		echo ($iFailed == 0) ? $OK : $FAIL;
986
		echo '</div>';
987 1765 Luisehahne
988 1588 darkviper
		if($msg != '') {
989 1641 Luisehahne
			$msg = '<br /><br />Following directories are deprecated, outdated or a security risk and
990 1588 darkviper
					can not be removed automatically.<br /><br />Please delete them
991
					using FTP and restart upgrade-script!<br /><br />'.$msg.'<br />';
992
			status_msg($msg, 'error warning', 'div');
993
			echo '<p style="font-size:120%;"><strong>WARNING: The upgrade script failed ...</strong></p>';
994
			echo '<form action="'.$_SERVER['SCRIPT_NAME'].'">';
995
			echo '&nbsp;<input name="send" type="submit" value="Restart upgrade script" />';
996
			echo '</form>';
997 1866 Luisehahne
			echo "<br /><br /></div>
998
			</div>
999
			</div>
1000
			</body>
1001
			</html>";
1002 1588 darkviper
			exit;
1003
		}
1004 1883 Luisehahne
1005
1006 1525 Luisehahne
	}
1007 1532 Luisehahne
1008 1883 Luisehahne
	/**********************************************************
1009
	 * upgrade modules if newer version is available
1010
	 * $aModuleList list of proofed modules
1011
	 */
1012 1894 Luisehahne
	$aModuleList = array(
1013 1920 Luisehahne
	              'captcha_control','code','droplets','form','jsadmin',
1014
	              'menu_link','news','output_filter','wrapper','wysiwyg','MultiLingual');
1015 1866 Luisehahne
	if(sizeof($aModuleList))
1016
	{
1017 1890 Luisehahne
		echo '<h3>Step '.(++$stepID).': Upgrade proofed modules</h3>';
1018 1866 Luisehahne
		foreach($aModuleList as $sModul) {
1019
			if(file_exists(WB_PATH.'/modules/'.$sModul.'/upgrade.php')) {
1020
				$currModulVersion = get_modul_version ($sModul, false);
1021
				$newModulVersion =  get_modul_version ($sModul, true);
1022
				if((version_compare($currModulVersion, $newModulVersion) <= 0)) {
1023 1883 Luisehahne
					echo '<div style="margin-left:2em;">';
1024 1866 Luisehahne
					echo '<h4>'.'Upgrade module \''.$sModul.'\' version '.$newModulVersion.'</h4>';
1025
					require(WB_PATH.'/modules/'.$sModul.'/upgrade.php');
1026 1883 Luisehahne
					echo '</div>';
1027 1866 Luisehahne
				}
1028 1588 darkviper
			}
1029
		}
1030 1525 Luisehahne
	}
1031 1765 Luisehahne
1032 1883 Luisehahne
	/**********************************************************
1033
	 * Reformat/rebuild all existing moules access files
1034
	 * $aModuleList list of modules
1035
	 */
1036
	$aModuleList = array('bakery','topics','news');
1037 1866 Luisehahne
	if(sizeof($aModuleList))
1038
	{
1039
		echo '<h3>Step '.(++$stepID).': Create/Reorg Accessfiles from modules</h3>';
1040
		foreach($aModuleList as $sModul) {
1041
			$aReturnMsg = array();
1042
			$sModulReorg = 'm_'.$sModul.'_Reorg';
1043
			if(class_exists($sModulReorg)) {
1044
				$sModulVersion =  get_modul_version ($sModul, true);
1045
				echo '<div style="margin-left:2em;">';
1046
				echo '<h4>'.'Create/Reorg Accesfiles for module \''.$sModul.'\' version '.$sModulVersion.'</h4>';
1047
				$oReorg = new $sModulReorg();
1048
				$aReturnMsg = $oReorg->execute(); // show details
1049 1881 Luisehahne
				if(is_array($aReturnMsg)) {
1050 1866 Luisehahne
					foreach($aReturnMsg as $title) {
1051
					echo '<strong>'.$title.'</strong><br />';
1052
					}
1053
				}
1054
				echo '</div>';
1055
			}
1056
		}
1057
	}
1058 1525 Luisehahne
/**********************************************************
1059 1457 Luisehahne
 *  - Reload all addons
1060
 */
1061
1062 1765 Luisehahne
	echo '<h3>Step '.(++$stepID).' : Reload all addons database entry (no upgrade)</h3><br />';
1063 1883 Luisehahne
	echo '<div style="margin-left:2em;">';
1064
	$iFound = 0;
1065
	$iLoaded = 0;
1066 1588 darkviper
	////delete modules
1067
	//$database->query("DELETE FROM ".TABLE_PREFIX."addons WHERE type = 'module'");
1068
	// Load all modules
1069
	if( ($handle = opendir(WB_PATH.'/modules/')) ) {
1070
		while(false !== ($file = readdir($handle))) {
1071 1769 Luisehahne
			if($file != '' && substr($file, 0, 1) != '.' && is_dir(WB_PATH.'/modules/'.$file) ) {
1072 1889 Luisehahne
				$iFound++;
1073 1765 Luisehahne
				$iLoaded = load_module(WB_PATH.'/modules/'.$file ) ? $iLoaded+1 : $iLoaded;
1074 1889 Luisehahne
// 	upgrade_module($file, true);
1075 1588 darkviper
			}
1076 1457 Luisehahne
		}
1077 1588 darkviper
		closedir($handle);
1078 1457 Luisehahne
	}
1079 1866 Luisehahne
	echo '<strong><span>'.$iLoaded.' Modules reloaded,</span> found '.$iFound.' directories in folder /modules/</strong><br />';
1080 1457 Luisehahne
1081 1889 Luisehahne
	$iFound = 0;
1082
	$iLoaded = 0;
1083 1588 darkviper
	////delete templates
1084
	//$database->query("DELETE FROM ".TABLE_PREFIX."addons WHERE type = 'template'");
1085
	// Load all templates
1086
	if( ($handle = opendir(WB_PATH.'/templates/')) ) {
1087
		while(false !== ($file = readdir($handle))) {
1088
			if($file != '' AND substr($file, 0, 1) != '.' AND $file != 'index.php') {
1089 1769 Luisehahne
1090 1889 Luisehahne
				$iFound++;
1091 1765 Luisehahne
				$iLoaded = (load_template(WB_PATH.'/templates/'.$file)==true) ? $iLoaded+1 : $iLoaded;
1092 1769 Luisehahne
1093 1588 darkviper
			}
1094 1457 Luisehahne
		}
1095 1588 darkviper
		closedir($handle);
1096 1457 Luisehahne
	}
1097 1866 Luisehahne
	echo '<strong><span>'.$iLoaded.' Templates reloaded,</span> found '.$iFound.' directories in folder /templates/</strong><br />';
1098 1457 Luisehahne
1099 1889 Luisehahne
	$iFound = 0;
1100
	$iLoaded = 0;
1101 1588 darkviper
	////delete languages
1102
	//$database->query("DELETE FROM ".TABLE_PREFIX."addons WHERE type = 'language'");
1103
	// Load all languages
1104
	if( ($handle = opendir(WB_PATH.'/languages/')) ) {
1105
		while(false !== ($file = readdir($handle))) {
1106 1769 Luisehahne
			if($file != '' AND (preg_match('#^([A-Z]{2}.php)#', basename($file)))) {
1107 1889 Luisehahne
				$iFound++;
1108 1765 Luisehahne
				$iLoaded = load_language(WB_PATH.'/languages/'.$file) ? $iLoaded+1 : $iLoaded;
1109 1588 darkviper
			}
1110 1457 Luisehahne
		}
1111 1588 darkviper
		closedir($handle);
1112 1457 Luisehahne
	}
1113 1866 Luisehahne
	echo '<strong><span>'.$iLoaded.' Languages reloaded,</span> found '.$iFound.' files in folder /languages/</strong><br />';
1114 1889 Luisehahne
	echo '</div>';
1115 1457 Luisehahne
1116
/**********************************************************
1117 1671 Luisehahne
 *  - install new droplets
1118
	$drops = (!in_array ( "mod_droplets", $all_tables)) ? "<br />Install droplets<br />" : "<br />Upgrade droplets<br />";
1119
	echo $drops;
1120
	$file_name = (!in_array ( "mod_droplets", $all_tables) ? "install.php" : "upgrade.php");
1121
	require_once (WB_PATH."/modules/droplets/".$file_name);
1122
********************************************************** */
1123
1124
/**********************************************************
1125 1457 Luisehahne
 *  - End of upgrade script
1126
 */
1127 1588 darkviper
	if(!defined('DEFAULT_THEME')) { define('DEFAULT_THEME', $DEFAULT_THEME); }
1128
	if(!defined('THEME_PATH')) { define('THEME_PATH', WB_PATH.'/templates/'.DEFAULT_THEME);}
1129 1532 Luisehahne
/**********************************************************
1130
 *  - Set Version to new Version
1131
 */
1132 1765 Luisehahne
echo '<h3>Step '.(++$stepID).': Update database version number </h3>';
1133
echo '<div style="margin-left:2em;">';
1134 1457 Luisehahne
1135 1671 Luisehahne
$cfg = array(
1136
	'wb_version' => VERSION,
1137
	'wb_revision' => REVISION,
1138
	'wb_sp' => SP
1139
);
1140 1883 Luisehahne
echo '<br /><span><strong>Set WebsiteBaker version number to '.VERSION.' '.SP.' '.' Revision ['.REVISION.'] : </strong></span>';
1141 1671 Luisehahne
echo (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");
1142 1765 Luisehahne
echo '</div>';
1143 1671 Luisehahne
1144 1765 Luisehahne
echo '<p style="font-size:140%;"><strong>Congratulations: The upgrade script is finished ...</strong></p>';
1145
status_msg('<strong>:</strong><br />Please delete the file <strong>upgrade-script.php</strong> via FTP before proceeding.', 'warning', 'div');
1146
// show buttons to go to the backend or frontend
1147
echo '<br />';
1148 1532 Luisehahne
1149 1765 Luisehahne
if(defined('WB_URL')) {
1150
	echo '<form action="'.WB_URL.'/">';
1151
	echo '&nbsp;<input type="submit" value="kick me to the Frontend" />';
1152
	echo '</form>';
1153
}
1154
if(defined('ADMIN_URL')) {
1155
	echo '<form action="'.ADMIN_URL.'/">';
1156
	echo '&nbsp;<input type="submit" value="kick me to the Backend" />';
1157
	echo '</form>';
1158
}
1159 1457 Luisehahne
1160 1765 Luisehahne
echo "<br /><br /></div>
1161
</div>
1162
</div>
1163
</body>
1164
</html>
1165
";
1166
exit();