Project

General

Profile

1
<?php
2
/**
3
 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
4
 *
5
 * 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
 *
10
 * 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
 */
18

    
19
/**
20
 * 
21
 * 
22
 * @category     Core
23
 * @package      Core_service
24
 * @subpackage   upgrade-script
25
 * @author       Dietmar Wöllbrink <dietmar.woellbrink@websitebaker.org>
26
 * @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: 1988 $
31
 * @link         $HeadURL: svn://isteam.dynxs.de/wb-archiv/branches/2.8.x/wb/upgrade-script.php $
32
 * @lastmodified $Date: 2013-10-19 02:51:22 +0200 (Sat, 19 Oct 2013) $
33
 * @since        File available since 17.01.2013
34
 * @deprecated   
35
 * @description  xyz
36
 */
37
// --- delete fatal disturbing files before upgrade starts -------------------------------
38
$aPreDeleteFiles = array(
39
// list of files
40
	dirname(__FILE__).'/framework/PasswordHash.php'
41
);
42
if(sizeof($aPreDeleteFiles > 0))
43
{
44
// if there are files defined
45
	$sMsg = '';
46
	foreach($aPreDeleteFiles as $sFileToDelete)
47
	{
48
	// iterate the list
49
		if(file_exists($sFileToDelete))
50
		{
51
			if(!is_writeable($sFileToDelete) || !@unlink($sFileToDelete))
52
			{
53
			// notice if deleting fails
54
				$sMsg .= '<span style="color:red;">FAILED</span> deleting: '
55
				       . $sFileToDelete.'<br />'.PHP_EOL;
56
			}
57
		}
58
	}
59
	if($sMsg) {
60
	// stop script if there's an error occured
61
		$sMsg = 'Fatal error occured during initial startup.<br /><br />'.PHP_EOL.$sMsg
62
		      . '<br />'.PHP_EOL.'Please delete all of the files above manually and '
63
		      . 'then <a href="http://'.$_SERVER["HTTP_HOST"].$_SERVER["SCRIPT_NAME"].'" '
64
		      . 'title="restart">klick here to restart the upgrade-script</a>.<br />'.PHP_EOL;
65
		die($sMsg);
66
	}
67
}
68
unset($aPreDeleteFiles);
69
$sMsg = '';
70
// ---------------------------------------------------------------------------------------
71
// Include config file
72
$config_file = dirname(__FILE__).'/config.php';
73
if(file_exists($config_file) && !defined('WB_URL'))
74
{
75
	require($config_file);
76
}
77
if(!class_exists('admin', false))
78
{ 
79
	include(WB_PATH.'/framework/class.admin.php');
80
}
81
$admin = new admin('Addons', 'modules', false, false);
82
// solved wrong pages_directory value before creating access files
83
$sql  = 'SELECT `value` FROM `'.TABLE_PREFIX.'settings` '
84
      . 'WHERE `name`=\'pages_directory\'';
85
$sPagesDirectory = WbDatabase::getInstance()->get_one($sql);
86
$sTmp = trim($sPagesDirectory, '/');
87
$sTmpDir = ($sTmp == '' ? '' : '/'.$sTmp);
88
if($sTmp != $sPagesDirectory) {
89
	$sql = 'UPDATE `'.TABLE_PREFIX.'settings` '
90
		 . 'SET `value` = \''.$sTmpDir.'\' '
91
		 . 'WHERE `name`=\'pages_directory\' ';
92
	WbDatabase::getInstance()->query($sql);
93
}
94
require_once(WB_PATH.'/framework/functions.php');
95
// require_once(WB_PATH.'/framework/Database.php');
96

    
97
$oldVersion  = 'Version '.WB_VERSION;
98
$oldVersion .= (defined('WB_SP') ? WB_SP : '');
99
$oldRevision = (defined('WB_REVISION') ? ' Revision ['.WB_REVISION.'] ' : '') ;
100
$newVersion  = 'Version '.VERSION;
101
$newVersion .= (defined('SP') ? SP : '');
102
$newRevision = (defined('REVISION') ? ' Revision ['.REVISION.'] ' : '');
103

    
104
$bDebugModus = false;
105

    
106
// set addition settings if not exists, otherwise upgrade will be breaks
107
if(!defined('WB_SP')) { define('WB_SP',''); }
108
if(!defined('WB_REVISION')) { define('WB_REVISION',''); }
109
// database tables including in WB package
110
$aPackage = array (
111
    'settings','groups','addons','pages','sections','search','users',
112
    'mod_captcha_control','mod_jsadmin','mod_menu_link','mod_output_filter','mod_wrapper','mod_wysiwyg'
113
);
114

    
115
$OK            = ' <span class="ok">OK</span> ';
116
$FAIL          = ' <span class="error">FAILED</span> ';
117
$DEFAULT_THEME = 'wb_theme';
118

    
119
$stepID = 1;
120
$dirRemove = array(
121
/*
122
			'[TEMPLATE]/allcss/',
123
			'[TEMPLATE]/blank/',
124
			'[TEMPLATE]/round/',
125
			'[TEMPLATE]/simple/',
126
*/
127
			'[ADMIN]/themes/',
128
		 );
129
//
130
$aRemoveSingleFiles = array(
131
			'[ADMIN]/preferences/details.php',
132
			'[ADMIN]/preferences/email.php',
133
			'[ADMIN]/preferences/password.php',
134
			'[ADMIN]/pages/settings2.php',
135
			'[ADMIN]/users/users.php',
136
			'[ADMIN]/groups/add.php',
137
			'[ADMIN]/groups/groups.php',
138
			'[ADMIN]/groups/save.php',
139
			'[ADMIN]/skel/themes/htt/groups.htt',
140

    
141
			'[FRAMEWORK]/class.msg_queue.php',
142
			'[FRAMEWORK]/class.logfile.php',
143
			'[FRAMEWORK]/PasswordHash.php',
144
			'[MODULES]/droplets/js/mdcr.js',
145

    
146
);
147

    
148
// deleting files below only from less 2.8.4 stable
149
if(version_compare(WB_VERSION, '2.8.4', '<'))
150
{
151
	$aRemoveOldTemplates = array(
152

    
153
			'[TEMPLATE]/argos_theme/templates/access.htt',
154
			'[TEMPLATE]/argos_theme/templates/addons.htt',
155
			'[TEMPLATE]/argos_theme/templates/admintools.htt',
156
			'[TEMPLATE]/argos_theme/templates/error.htt',
157
			'[TEMPLATE]/argos_theme/templates/groups.htt',
158
			'[TEMPLATE]/argos_theme/templates/groups_form.htt',
159
			'[TEMPLATE]/argos_theme/templates/languages.htt',
160
			'[TEMPLATE]/argos_theme/templates/languages_details.htt',
161
			'[TEMPLATE]/argos_theme/templates/login.htt',
162
			'[TEMPLATE]/argos_theme/templates/login_forgot.htt',
163
			'[TEMPLATE]/argos_theme/templates/media.htt',
164
			'[TEMPLATE]/argos_theme/templates/media_browse.htt',
165
			'[TEMPLATE]/argos_theme/templates/media_rename.htt',
166
			'[TEMPLATE]/argos_theme/templates/modules.htt',
167
			'[TEMPLATE]/argos_theme/templates/modules_details.htt',
168
			'[TEMPLATE]/argos_theme/templates/pages.htt',
169
			'[TEMPLATE]/argos_theme/templates/pages_modify.htt',
170
			'[TEMPLATE]/argos_theme/templates/pages_sections.htt',
171
			'[TEMPLATE]/argos_theme/templates/pages_settings.htt',
172
			'[TEMPLATE]/argos_theme/templates/preferences.htt',
173
			'[TEMPLATE]/argos_theme/templates/setparameter.htt',
174
			'[TEMPLATE]/argos_theme/templates/settings.htt',
175
			'[TEMPLATE]/argos_theme/templates/start.htt',
176
			'[TEMPLATE]/argos_theme/templates/success.htt',
177
			'[TEMPLATE]/argos_theme/templates/templates.htt',
178
			'[TEMPLATE]/argos_theme/templates/templates_details.htt',
179
			'[TEMPLATE]/argos_theme/templates/users.htt',
180
			'[TEMPLATE]/argos_theme/templates/users_form.htt',
181

    
182
			'[TEMPLATE]/wb_theme/templates/access.htt',
183
			'[TEMPLATE]/wb_theme/templates/addons.htt',
184
			'[TEMPLATE]/wb_theme/templates/admintools.htt',
185
			'[TEMPLATE]/wb_theme/templates/error.htt',
186
			'[TEMPLATE]/wb_theme/templates/groups.htt',
187
			'[TEMPLATE]/wb_theme/templates/groups_form.htt',
188
			'[TEMPLATE]/wb_theme/templates/languages.htt',
189
			'[TEMPLATE]/wb_theme/templates/languages_details.htt',
190
			'[TEMPLATE]/wb_theme/templates/login.htt',
191
			'[TEMPLATE]/wb_theme/templates/login_forgot.htt',
192
			'[TEMPLATE]/wb_theme/templates/media.htt',
193
			'[TEMPLATE]/wb_theme/templates/media_browse.htt',
194
			'[TEMPLATE]/wb_theme/templates/media_rename.htt',
195
			'[TEMPLATE]/wb_theme/templates/modules.htt',
196
			'[TEMPLATE]/wb_theme/templates/modules_details.htt',
197
			'[TEMPLATE]/wb_theme/templates/pages.htt',
198
			'[TEMPLATE]/wb_theme/templates/pages_modify.htt',
199
			'[TEMPLATE]/wb_theme/templates/pages_sections.htt',
200
			'[TEMPLATE]/wb_theme/templates/pages_settings.htt',
201
			'[TEMPLATE]/wb_theme/templates/preferences.htt',
202
			'[TEMPLATE]/wb_theme/templates/setparameter.htt',
203
			'[TEMPLATE]/wb_theme/templates/settings.htt',
204
			'[TEMPLATE]/wb_theme/templates/start.htt',
205
			'[TEMPLATE]/wb_theme/templates/success.htt',
206
			'[TEMPLATE]/wb_theme/templates/templates.htt',
207
			'[TEMPLATE]/wb_theme/templates/templates_details.htt',
208
			'[TEMPLATE]/wb_theme/templates/users.htt',
209
			'[TEMPLATE]/wb_theme/templates/users_form.htt'
210
	);
211
}else {
212
	$aRemoveOldTemplates = array();
213
}
214
$aFilesToRemove = array_merge($aRemoveSingleFiles, $aRemoveOldTemplates);
215
unset($aRemoveSingleFiles);
216
unset($aRemoveOldTemplates);
217
/* display a status message on the screen **************************************
218
 * @param string $message: the message to show
219
 * @param string $class:   kind of message as a css-class
220
 * @param string $element: witch HTML-tag use to cover the message
221
 * @return void
222
 */
223
function status_msg($message, $class='check', $element='div')
224
{
225
	// returns a status message
226
	$msg  = '<'.$element.' class="'.$class.'">';
227
	$msg .= '<strong>'.strtoupper(strtok($class, ' ')).'</strong>';
228
	$msg .= $message.'</'.$element.'>';
229
	echo $msg;
230
}
231

    
232
/**
233
 * add_modify_field_in_database()
234
 *
235
 * @param mixed $sTable
236
 * @param mixed $sField
237
 * @param mixed $sDescription
238
 * @return
239
 */
240
function add_modify_field_in_database($sTable,$sField,$sDescription){
241
	global $OK,$FAIL,$bDebugModus;
242
	$database=WbDatabase::getInstance();
243
	$aDebugMessage = array();
244
	if(!$database->field_exists($sTable,$sField)) {
245
		$aDebugMessage[] = "<span>Adding field $sField to $sTable table</span>";
246
		$aDebugMessage[] = ($database->field_add($sTable, $sField, $sDescription) ? " $OK<br />" : " $FAIL!<br />");
247
	} else {
248
		$aDebugMessage[] = "<span>Modify field $sField to $sTable table</span>";
249
		$aDebugMessage[] = ($database->field_modify($sTable, $sField, $sDescription) ? " $OK<br />" : " $FAIL!<br />");
250
	}
251
	if($bDebugModus) {
252
		echo implode(PHP_EOL,$aDebugMessage);
253
	}
254
return;
255
}
256

    
257
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
258
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
259
<head>
260
<title>Upgrade script</title>
261
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
262
<style type="text/css">
263
html { overflow-y: scroll; /* Force firefox to always show room for a vertical scrollbar */ }
264

    
265
body {
266
	margin:0;
267
	padding:0;
268
	border:0;
269
	background: #EBF7FC;
270
	color:#000;
271
	font-family: 'Trebuchet MS', Verdana, Arial, Helvetica, Sans-Serif;
272
	font-size: small;
273
	height:101%;
274
}
275

    
276
#container {
277
	min-width:48em;
278
    width: 70%;
279
	background: #A8BCCB url(<?php echo WB_URL; ?>/templates/wb_theme/images/background.png) repeat-x;
280
	border:1px solid #000;
281
	color:#000;
282
	margin:2em auto;
283
	padding:0 20px;
284
	min-height: 500px;
285
	text-align:left;
286
}
287
.page {
288
	width:100%;
289
    overflow: hidden;
290
}
291
.content {
292
    padding: 10px;
293
}
294
p { line-height:1.5em; }
295

    
296
form {
297
	display: inline-block;
298
	line-height: 20px;
299
	vertical-align: baseline;
300
}
301
input[type="submit"].restart {
302
	background-color: #FFDBDB;
303
	font-weight: bold;
304
}
305

    
306
h1,h2,h3,h4,h5,h6 {
307
	font-family: Verdana, Arial, Helvetica, sans-serif;
308
	color: #26527D;
309
	margin-top: 1.0em;
310
	margin-bottom: 0.1em;
311
}
312

    
313
h1 { font-size:150%; }
314
h2 { font-size: 130%; border-bottom: 1px #CCC solid; }
315
h3 { font-size: 110%; font-weight: bold; }
316

    
317
textarea {
318
	width:100%;
319
	border: 2px groove #0F1D44;
320
	padding: 2px;
321
	color: #000;
322
	font-weight: normal;
323
}
324
.ok, .error { font-weight:bold; }
325
.ok { color:green; }
326
.error { color:red; }
327
.check { color:#555; }
328

    
329
span.ok,
330
span.error {
331
    margin-left: 0em;
332
}
333

    
334
.warning {
335
	background:#FFDBDB;
336
	padding:1em;
337
	margin-top:0.5em;
338
	border: 1px solid #DB0909;
339
}
340
.info {
341
	background:#C7F4C7;
342
	padding:1em;
343
	margin-top:0.5em;
344
	border: 1px solid #277A29;
345
}
346

    
347
</style>
348
</head>
349
<body>
350
<div id="container">
351
<div class="page">
352
<img src="<?php echo WB_URL; ?>/templates/wb_theme/images/logo.png" alt="WebsiteBaker Project" />
353
<div class="content">
354
<h1>WebsiteBaker Upgrade</h1>
355
<?php
356
	if( version_compare( WB_VERSION, '2.7', '<' )) {
357
		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');
358
		echo "</div>
359
		</div>
360
		</div>
361
		</body>
362
		</html>
363
		";
364
		exit();
365
	}
366
if($admin->get_user_id()!=1){
367
	status_msg('<br /><h3>WebsiteBaker upgrading is not possible!<br />Before upgrading '
368
	          .'to Revision '.REVISION.' you have to login as System-Administrator!</h3>',
369
	           'warning', 'div');
370
	echo '<br /><br />';
371
// delete remember key of current user from database
372
	//if (isset($_SESSION['USER_ID']) && isset($database)) {
373
	//	$table = TABLE_PREFIX . 'users';
374
	//	$sql = "UPDATE `$table` SET `remember_key` = '' WHERE `user_id` = '" . (int) $_SESSION['USER_ID'] . "'";
375
	//	$database->query($sql);
376
	//}
377
// delete remember key cookie if set
378
	if (isset($_COOKIE['REMEMBER_KEY']) && !headers_sent() ) {
379
		setcookie('REMEMBER_KEY', '', time() - 3600, '/');
380
	}
381
	// delete most critical session variables manually
382
	$_SESSION['USER_ID'] = null;
383
	$_SESSION['GROUP_ID'] = null;
384
	$_SESSION['GROUPS_ID'] = null;
385
	$_SESSION['USERNAME'] = null;
386
	$_SESSION['PAGE_PERMISSIONS'] = null;
387
	$_SESSION['SYSTEM_PERMISSIONS'] = null;
388
	// overwrite session array
389
	$_SESSION = array();
390
	// delete session cookie if set
391
	if (isset($_COOKIE[session_name()]) && !headers_sent()) {
392
		setcookie(session_name(), '', time() - 42000, '/');
393
	}
394
	// delete the session itself
395
	session_destroy();
396
	status_msg('<br /><h3>You have to login as System-Adminstrator start '
397
	          .'upgrade-script.php again!</h3>',
398
	           'info', 'div');
399
	echo '<br /><br />';
400
	if(defined('ADMIN_URL')) {
401
		echo '<form action="'.ADMIN_URL.'/index.php" method="post">'
402
		    .'&nbsp;<input name="backend_send" type="submit" value="Kick me to the Login" />'
403
		    .'</form>';
404
	}
405
	echo '<br /><br /></div>'
406
	    .'</div>'
407
	    .'</div>'
408
	    .'</body>'
409
	    .'</html>';
410
	exit();
411
}
412

    
413
?>
414
<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>
415

    
416
<?php
417

    
418
/**
419
 * Check if disclaimer was accepted
420
 */
421
$bDebugModus = false;
422
$bDebugModus = ( (isset($_POST['debug_confirmed']) && $_POST['debug_confirmed'] == 'debug') ? true : false);
423
if (!(isset($_POST['backup_confirmed']) && $_POST['backup_confirmed'] == 'confirmed')) { ?>
424
<h2>Step 1: Backup your files</h2>
425
<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>
426
<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>
427

    
428
<form action="<?php echo $_SERVER['SCRIPT_NAME'];?>" method="post">
429
<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>
430
<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>
431
<br /><br /><input name="debug_confirmed" type="checkbox" value="debug" />&nbsp;<strong>Here you can get more details during running upgrade.</strong>
432
<br /><br /><input name="send" type="submit" value="Start upgrade script" />
433
</form>
434
<br />
435

    
436
<?php
437
	status_msg('<strong> Notice:</strong><br />You need to confirm that you have created '
438
			  .'a manual backup of the '.PAGES_DIRECTORY.'/ directory and the MySQL '
439
	          .'database before you can proceed.',
440
	           'warning', 'div');
441
	echo '<br /><br /></div>'
442
	    .'</div>'
443
	    .'</div>'
444
	    .'</body>'
445
	    .'</html>';
446
	exit();
447
}
448

    
449
/**********************************************************
450
 *  - check tables coming with WebsiteBaker
451
 */
452
	$aMissingTables = UpgradeHelper::getMissingTables($aPackage);
453
	if( sizeof($aMissingTables) == 0){
454
        echo '<h4 style="margin-left:0;">NOTICE: '.sizeof($aPackage).' total tables '
455
		    .'included in package are successfully installed into your database `'
456
		    .$database->DbName.'` '.$OK.'</h4>';
457
    } else {
458
        status_msg('<strong>:</strong><br />can\'t run Upgrade, missing tables', 'warning', 'div');
459
        echo '<h4>Missing required tables. You can install them in backend->addons->modules.<br />'
460
            .'Or if you uploaded per FTP install possible by backend->addons->modules->advanced.<br />'
461
            .'First rename or delete the upgrade-script.php, so the script can\'t start automatically by backend<br />'
462
            .'After installing missing tables upload and run again upgrade-script.php<br /><br /></h4>'
463
            .'<h4 class="warning">'
464
            .'Missing required tables.<br /><br />'
465
            .'TABLE `'.implode('` missing! '.$FAIL.'<br />TABLE `',$aMissingTables).'` missing! '.$FAIL
466
            .'<br /><br /></h4>'
467
            .'<br /><br />';
468
        if(isset($_SERVER['SCRIPT_NAME'])) {
469
        	echo '<form action="'.$_SERVER['SCRIPT_NAME'].'/">'
470
        	    .'&nbsp;<input type="submit" value="Start upgrade again" />'
471
        	    .'</form>';
472
        }
473
        if(defined('ADMIN_URL')) {
474
        	echo '<form action="'.ADMIN_URL.'/index.php" method="post">'
475
        	    .'&nbsp;<input name="backend_send" type="submit" value="kick me to the Backend" />'
476
        	    .'</form>';
477
        }
478
        echo '<br /><br /></div>'
479
            .'</div>'
480
            .'</div>'
481
            .'</body>'
482
            .'</html>';
483
		exit();
484
	}
485

    
486
	echo '<h3>Step '.(++$stepID).': Setting default_theme</h3>';
487
	$aDebugMessage = array();
488
	/**********************************************************
489
	 *  - Adding field default_theme to settings table
490
	 */
491
	$aDebugMessage[] = '<div style="margin-left:2em;">';
492
	$aDebugMessage[] = "<span><strong>Adding default_theme to table settings</strong></span>";
493
	// db_update_key_value('settings', 'default_theme', $DEFAULT_THEME);
494
	$cfg = array(
495
		'default_theme' => $DEFAULT_THEME
496
	);
497
	$aDebugMessage[] = (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");
498
	$aDebugMessage[] = '</div>';
499

    
500
	echo implode(PHP_EOL,$aDebugMessage);
501

    
502
	$aDebugMessage = array();
503
	echo'<h3>Step '.(++$stepID).': Updating core table included in package</h3>';
504
	/**********************************************************
505
	 *  - Adding field sec_anchor to settings table
506
	 */
507
	echo '<div style="margin-left:2em;">';
508
	echo "<h4>Adding/updating entries on table settings</h4>";
509
	$aDebugMessage[] = "<span>Adding/updating sec_anchor to settings table</span>";
510
	$cfg = array(
511
		'sec_anchor' => defined( 'SEC_ANCHOR' )&& (SEC_ANCHOR!='') ? SEC_ANCHOR : 'Sec'
512
	);
513
	$bLogStatus = (db_update_key_value( 'settings', $cfg ) ? true : false );
514
	$aDebugMessage[] = ( ($bLogStatus==true ) ? " $OK<br />" : " $FAIL!<br />");
515

    
516
	/**********************************************************
517
	 *  - Adding redirect timer to settings table
518
	 */
519
	$aDebugMessage[] = "<span>Adding/updating redirect timer to settings table</span>";
520
	$cfg = array(
521
		'redirect_timer' => defined('REDIRECT_TIMER')&& (REDIRECT_TIMER!='') ? REDIRECT_TIMER : '1500'
522
	);
523
	$bLogStatus = (db_update_key_value( 'settings', $cfg ) ? true : false );
524
	$aDebugMessage[] = ( ($bLogStatus==true ) ? " $OK<br />" : " $FAIL!<br />");
525

    
526
	/**********************************************************
527
	 *  - Adding default_time_formatr to settings table
528
	 */
529
	$aDebugMessage[] = "<span>Adding/updating default_time_format to settings table</span>";
530
	$cfg = array(
531
		'default_time_format' => defined('DEFAULT_TIME_FORMAT')&& (DEFAULT_TIME_FORMAT!='') ? DEFAULT_TIME_FORMAT : 'h:i A'
532
	);
533
	$bLogStatus = (db_update_key_value( 'settings', $cfg ) ? true : false );
534
	$aDebugMessage[] = ( ($bLogStatus==true ) ? " $OK<br />" : " $FAIL!<br />");
535

    
536
	/**********************************************************
537
	 *  - Adding rename_files_on_upload to settings table
538
	 */
539
	$aDebugMessage[] = "<span>Adding/Updating rename_files_on_upload to settings table</span>";
540
	$cfg = array(
541
	    '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')
542
	);
543
	if( version_compare( WB_VERSION, '2.8.2', '<' )) {
544
		$cfg = array(
545
		    'rename_files_on_upload' => 'ph.*?,cgi,pl,pm,exe,com,bat,pif,cmd,src,asp,aspx,js'
546
		);
547
	}
548
	$bLogStatus = (db_update_key_value( 'settings', $cfg ) ? true : false );
549
	$aDebugMessage[] = ( ($bLogStatus==true ) ? " $OK<br />" : " $FAIL!<br />");
550

    
551
	/**********************************************************
552
	 *  - Adding mediasettings to settings table
553
	 */
554
	$aDebugMessage[] = "<span>Adding/updating mediasettings to settings table</span>";
555
	$cfg = array(
556
		'mediasettings' => (defined('MEDIASETTINGS')&& (MEDIASETTINGS!='') ? MEDIASETTINGS : ''),
557
	);
558
	$bLogStatus = (db_update_key_value( 'settings', $cfg ) ? true : false );
559
	$aDebugMessage[] = ( ($bLogStatus==true ) ? " $OK<br />" : " $FAIL!<br />");
560

    
561
	/**********************************************************
562
	 *  - Adding fingerprint_with_ip_octets to settings table
563
	 */
564
	$aDebugMessage[] = "<span>Adding/updating fingerprint_with_ip_octets to settings table</span>";
565
	$cfg = array(
566
		'fingerprint_with_ip_octets' => (defined('FINGERPRINT_WITH_IP_OCTETS') ? FINGERPRINT_WITH_IP_OCTETS : '2'),
567
		'secure_form_module' => (defined('SECURE_FORM_MODULE') ? SECURE_FORM_MODULE : '')
568
	);
569
	$bLogStatus = (db_update_key_value( 'settings', $cfg ) ? true : false );
570
	$aDebugMessage[] = ( ($bLogStatus==true ) ? " $OK<br />" : " $FAIL!<br />");
571

    
572
	/**********************************************************
573
	 *  - Adding page_icon_dir to settings table
574
	 */
575
	$aDebugMessage[] = "<span>Adding/updating page_icon_dir to settings table</span>";
576
	$cfg = array(
577
		'page_icon_dir' => (defined('PAGE_ICON_DIR')&& (PAGE_ICON_DIR!='') ? PAGE_ICON_DIR : '/templates/*/title_images'),
578
	);
579
	$bLogStatus = (db_update_key_value( 'settings', $cfg ) ? true : false );
580
	$aDebugMessage[] = ( ($bLogStatus==true ) ? " $OK<br />" : " $FAIL!<br />");
581
	/**********************************************************
582
	 *  - Adding page_extended to settings table
583
	 */
584
	$aDebugMessage[] = "<span>Adding/updating page_extendet to settings table</span>";
585
	$cfg = array(
586
		'page_extendet' => (defined('PAGE_EXTENDET') ? PAGE_EXTENDET : 'true'),
587
	);
588
	$bLogStatus = (db_update_key_value( 'settings', $cfg ) ? true : false );
589
	$aDebugMessage[] = ( ($bLogStatus==true ) ? " $OK<br />" : " $FAIL!<br />");
590

    
591
	/**********************************************************
592
	 *  - Adding wbmail_signature to settings table
593
	 */
594
	$aDebugMessage[] = "<span>Adding/updating wbmail_signature to settings table</span>";
595
	$cfg = array(
596
		'wbmail_signature' => (defined('WBMAIL_SIGNATURE')&& (WBMAIL_SIGNATURE!='') ? WBMAIL_SIGNATURE : '')
597
	);
598
	$bLogStatus = (db_update_key_value( 'settings', $cfg ) ? true : false );
599
	$aDebugMessage[] = ( ($bLogStatus==true ) ? " $OK<br />" : " $FAIL!<br />");
600

    
601
	/**********************************************************
602
	 *  - Adding confirmed_registration to settings table
603
	 */
604
	$aDebugMessage[] = "<span>Adding/updating confirmed_registration to settings table</span>";
605
	$cfg = array(
606
		'confirmed_registration' => (defined('CONFIRMED_REGISTRATION') ? CONFIRMED_REGISTRATION : '0')
607
	);
608
	$bLogStatus = (db_update_key_value( 'settings', $cfg ) ? true : false );
609
	$aDebugMessage[] = ( ($bLogStatus==true ) ? " $OK<br />" : " $FAIL!<br />");
610

    
611
	/**********************************************************
612
	 *  - Adding dev_infos to settings table
613
	 */
614
	$aDebugMessage[] = "<span>Adding/updating dev_infos to settings table</span>";
615
	$cfg = array(
616
		'dev_infos' => (defined('DEV_INFOS') ? DEV_INFOS : 'false')
617
	);
618
	$bLogStatus = (db_update_key_value( 'settings', $cfg ) ? true : false );
619
	$aDebugMessage[] = ( ($bLogStatus==true ) ? " $OK<br />" : " $FAIL!<br />");
620

    
621
	/**********************************************************
622
	 *  - Adding server_timezone to settings table
623
	 */
624
	$aDebugMessage[] = "<span>Adding/updating server_timezone to settings table</span>";
625
	$cfg = array(
626
		'server_timezone' => (defined('SERVER_TIMEZONE') ? SERVER_TIMEZONE : 'UTC')
627
	);
628
	$bLogStatus = (db_update_key_value( 'settings', $cfg ) ? true : false );
629
	$aDebugMessage[] = ( ($bLogStatus==true ) ? " $OK<br />" : " $FAIL!<br />");
630

    
631
	/**********************************************************
632
	 *  - Adding password settings to table settings
633
	 */
634
	$aDebugMessage[] = "<span>Adding/updating password settings to settings table</span>";
635
	$cfg = array();
636
	$cfg['password_crypt_loops'] = (defined('PASSWORD_CRYPT_LOOPS') ? PASSWORD_CRYPT_LOOPS : '12');
637
	$cfg['password_hash_type'] = (defined('PASSWORD_HASH_TYPES') ? PASSWORD_HASH_TYPES : 'false');
638
	$cfg['password_length'] = (defined('PASSWORD_LENGTH') ? PASSWORD_LENGTH : '10');
639
	$cfg['password_use_types'] = (defined('PASSWORD_USE_TYPES') ? PASSWORD_USE_TYPES : (int)0xFFFF);
640
	$bLogStatus = (db_update_key_value( 'settings', $cfg ) ? true : false );
641
	$aDebugMessage[] = ( ($bLogStatus==true ) ? " $OK<br />" : " $FAIL!<br />");
642

    
643
if($bDebugModus) {
644
    echo implode(PHP_EOL,$aDebugMessage);
645
} else {
646
        echo '<strong>Successfully upgraded</strong>'." $OK<br />";	   
647
	}
648
echo '</div>';
649

    
650
$aDebugMessage = array();
651
if(version_compare(WB_REVISION, REVISION, '<='))
652
{
653
	echo '<div style="margin-left:2em;">';
654
	/**********************************************************
655
	 *  - Update search no results database filed to create
656
	 *  valid XHTML if search is empty
657
	 */
658
	if (version_compare(WB_VERSION, '2.8', '<'))
659
	{
660
		echo "<h4>Adding/updating fields on table search</h4>";
661
		echo "Updating database field `no_results` on search table: ";
662
		$search_no_results = addslashes('<tr><td><p>[TEXT_NO_RESULTS]</p></td></tr>');
663
		$sql  = 'UPDATE `'.TABLE_PREFIX.'search` ';
664
		$sql .= 'SET `value`=\''.$search_no_results.'\' ';
665
		$sql .= 'WHERE `name`=\'no_results\'';
666
		echo ($database->query($sql)) ? " $OK<br />" : " $FAIL!<br />";
667
	}
668

    
669
	$aDebugMessage = array();
670
	echo "<h4>Adding/updating field on table pages</h4>";
671
	/**********************************************************
672
	 *  - Add field "page_trail" to table "pages"
673
	 */
674
	$table_name = TABLE_PREFIX.'pages';
675
	$field_name = 'page_trail';
676
	$description = "VARCHAR( 255 ) NOT NULL DEFAULT ''";
677
	add_modify_field_in_database($table_name,$field_name,$description);
678

    
679
	/**********************************************************
680
	 *  - Add field "page_icon" to table "pages"
681
	 */
682
	$table_name = TABLE_PREFIX.'pages';
683
	$field_name = 'page_icon';
684
	$description = "VARCHAR( 512 ) NOT NULL DEFAULT '' AFTER `page_title`";
685
	add_modify_field_in_database($table_name,$field_name,$description);
686

    
687
	/**********************************************************
688
	 *  - Add field "menu_icon_0" to table "pages"
689
	 */
690
	$table_name = TABLE_PREFIX.'pages';
691
	$field_name = 'menu_icon_0';
692
	$description = "VARCHAR( 512 ) NOT NULL DEFAULT '' AFTER `menu_title`";
693
	add_modify_field_in_database($table_name,$field_name,$description);
694

    
695
	/**********************************************************
696
	 *  - Add field "menu_icon_1" to table "pages"
697
	 */
698
	$table_name = TABLE_PREFIX.'pages';
699
	$field_name = 'menu_icon_1';
700
	$description = "VARCHAR( 512 ) NOT NULL DEFAULT '' AFTER `menu_icon_0`";
701
	add_modify_field_in_database($table_name,$field_name,$description);
702

    
703
	/**********************************************************
704
	 *  - Add field "tooltip" to table "pages"
705
	 */
706
	$table_name = TABLE_PREFIX.'pages';
707
	$field_name = 'tooltip';
708
	$description = "VARCHAR( 512 ) NOT NULL DEFAULT '' AFTER `menu_icon_1`";
709
	add_modify_field_in_database($table_name,$field_name,$description);
710

    
711
	/**********************************************************
712
	 *  - Add field "admin_groups" to table "pages"
713
	 */
714
	$table_name = TABLE_PREFIX.'pages';
715
	$field_name = 'admin_groups';
716
	$description = "VARCHAR( 512 ) NOT NULL DEFAULT '1'";
717
	add_modify_field_in_database($table_name,$field_name,$description);
718

    
719
	/**********************************************************
720
	 *  - Add field "admin_users" to table "pages"
721
	 */
722
	$table_name = TABLE_PREFIX.'pages';
723
	$field_name = 'admin_users';
724
	$description = "VARCHAR( 512 ) NOT NULL DEFAULT ''";
725
	add_modify_field_in_database($table_name,$field_name,$description);
726

    
727
	/**********************************************************
728
	 *  - Add field "viewing_groups" to table "pages"
729
	 */
730
	$table_name = TABLE_PREFIX.'pages';
731
	$field_name = 'viewing_groups';
732
	$description = "VARCHAR( 512 ) NOT NULL DEFAULT '1'";
733
	 add_modify_field_in_database($table_name,$field_name,$description);
734

    
735
	/**********************************************************
736
	 *  - Add field "viewing_users" to table "pages"
737
	 */
738
	$table_name = TABLE_PREFIX.'pages';
739
	$field_name = 'viewing_users';
740
	$description = "VARCHAR( 512 ) NOT NULL DEFAULT ''";
741
	add_modify_field_in_database($table_name,$field_name,$description);
742

    
743
	/**********************************************************
744
	 *  - Add field "custom01" to table "pages"
745
	 */
746
	$table_name = TABLE_PREFIX.'pages';
747
	$field_name = 'custom01';
748
	$description = "VARCHAR( 255 ) NOT NULL DEFAULT '' ";
749
	add_modify_field_in_database($table_name,$field_name,$description);
750

    
751
	/**********************************************************
752
	 *  - Add field "custom02" to table "pages"
753
	 */
754
	$table_name = TABLE_PREFIX.'pages';
755
	$field_name = 'custom02';
756
	$description = "VARCHAR( 255 ) NOT NULL DEFAULT '' ";
757
	add_modify_field_in_database($table_name,$field_name,$description);
758

    
759
	if($bDebugModus) {
760
		echo implode(PHP_EOL,$aDebugMessage);
761
	} else {
762
        echo '<strong>Successfully upgraded</strong>'." $OK<br />";	   
763
	}
764

    
765
	$aDebugMessage = array();
766
	/**********************************************************
767
	 * modify wrong strucre on table sections
768
	 * wrong structure let crash wb
769
	 */
770
	echo "<h4>Change field structure on table sections</h4>";
771
	$table_name = TABLE_PREFIX.'sections';
772
	$description = "VARCHAR( 255 ) NOT NULL DEFAULT ''";
773
	$aDebugMessage[] = "<span>Modify field module on sections table</span>";
774
	$aDebugMessage[] = ($database->field_modify($table_name, 'module', $description) ? " $OK<br />" : " $FAIL!<br />");
775
	$aDebugMessage[] = "<span>Modify field block on sections table</span>";
776
	$description = "int(11) NOT NULL DEFAULT '1'";
777
	$aDebugMessage[] = ($database->field_modify($table_name, 'block', $description) ? " $OK<br />" : " $FAIL!<br />");
778
	$description = "int(11) NOT NULL DEFAULT '0'";
779
	$aDebugMessage[] = "<span>Modify field publ_start on sections table</span>";
780
	$aDebugMessage[] = ($database->field_modify($table_name, 'publ_start', $description) ? " $OK<br />" : " $FAIL!<br />");
781
	$aDebugMessage[] = "<span>Modify field publ_end on sections table</span>";
782
	$aDebugMessage[] = ($database->field_modify($table_name, 'publ_end', $description) ? " $OK<br />" : " $FAIL!<br />");
783

    
784
	if($bDebugModus) {
785
		echo implode(PHP_EOL,$aDebugMessage);
786
	} else {
787
        echo '<strong>Successfully upgraded</strong>'." $OK<br />";	   
788
	}
789
	echo '</div>';
790
}
791

    
792
if(version_compare(WB_REVISION, REVISION, '<='))
793
{
794
	$aDebugMessage = array();
795
	echo '<h3>Step '.(++$stepID).': Updating structure in table users/groups</h3>';
796
	/**********************************************************
797
	 * Modify Administrator on groups table
798
	 */
799
	echo '<div style="margin-left:2em;">';
800
	echo "<h4>Updating Administrator group permissions on table groups</h4>";
801
	$aDebugMessage[] = "<span>Modify Administrator on groups table</span>";
802
	$sModulePermissions = '';
803
	$sTemplatePermissions = '';
804
	$sSystemPermissions  = 'access,addons,admintools,admintools_view,groups,groups_add,groups_delete,groups_modify,groups_view,';
805
	$sSystemPermissions .= 'languages,languages_install,languages_uninstall,languages_view,media,media_create,media_delete,media_rename,media_upload,media_view,';
806
	$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,';
807
	$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';
808

    
809
	$sql  = 'UPDATE `'.TABLE_PREFIX.'groups` ';
810
	$sql .= 'SET `name` = \'Administrators\', ';
811
	$sql .= '`system_permissions` = \''.$sSystemPermissions.'\', ';
812
	$sql .= '`module_permissions` = \''.$sModulePermissions.'\', ';
813
	$sql .= '`template_permissions` = \''.$sTemplatePermissions.'\' ';
814
	$sql .= 'WHERE `group_id` = \'1\' ';
815
	$aDebugMessage[] = ($database->query($sql)) ? " $OK<br />" : " $FAIL!<br />";
816
	if( ($admin->is_authenticated() == true) && ($admin->ami_group_member('1') ) ) {
817
	    $_SESSION['SYSTEM_PERMISSIONS'] = array_merge($_SESSION['SYSTEM_PERMISSIONS'], explode(',', $sSystemPermissions));
818
	}
819

    
820
	if($bDebugModus) {
821
		echo implode(PHP_EOL,$aDebugMessage);
822
	} else {
823
        echo '<strong>Successfully upgraded</strong>'." $OK<br />";	   
824
	}
825
	echo '</div>';
826
	$aDebugMessage = array();
827
	/**********************************************************
828
	 *   `confirm_code` VARCHAR(32) NOT NULL DEFAULT '',
829
	 *   `confirm_timeout` INT(11) NOT NULL DEFAULT '0',
830
	 */
831
	echo '<div style="margin-left:2em;">';
832
	echo "<h4>Change field structure on table users</h4>";
833
	$table_name = TABLE_PREFIX.'users';
834
	$field_name = 'confirm_code';
835
	$description = "VARCHAR( 32 ) NOT NULL DEFAULT '' AFTER `password` ";
836
	add_modify_field_in_database($table_name,$field_name,$description);
837

    
838
	$table_name = TABLE_PREFIX.'users';
839
	$field_name = 'confirm_timeout';
840
	$description = "INT(11) NOT NULL DEFAULT '0' AFTER `confirm_code` ";
841
	add_modify_field_in_database($table_name,$field_name,$description);
842

    
843
	if($bDebugModus) {
844
	    echo implode(PHP_EOL,$aDebugMessage);
845
	} else {
846
        echo '<strong>Successfully upgraded</strong>'." $OK<br />";	   
847
	}
848
	echo '</div>';
849

    
850
	$aDebugMessage = array();
851
	/**********************************************************
852
	* Updating group_id in table users
853
	*/
854
	echo '<div style="margin-left:2em;">';
855
	echo "<h4>Updating users groups permissions on table groups</h4>";
856
	    $aUsers = array();
857
		// Get existing values
858
        $sql  = 'SELECT * FROM `'.TABLE_PREFIX.'users` ' ;
859
        $sql .= 'WHERE `user_id` != 1 ';
860
        if($oUser = $database->query($sql)){
861
            $iTotalUsers = $oUser->numRows();
862
            while($Users = $oUser->fetchRow(MYSQL_ASSOC)) {
863
                $aUsers[$Users['user_id']]['groups_id'] = $Users['groups_id'];
864
                $aUsers[$Users['user_id']]['display_name'] = $Users['display_name'];
865
            }
866
        } else {
867
            $aDebugMessage[] = $database->is_error()==false ? " $OK<br />" : " $FAIL!<br />";
868
        }
869
        foreach($aUsers AS $user_id => $value){
870
                // choose group_id from groups_id - workaround for still remaining calls to group_id (to be cleaned-up)
871
                $aGroups_id = explode(',', $aUsers[$user_id]['groups_id']);
872
                $groups_id = $aUsers[$user_id]['groups_id'];
873
                $group_id = 0;
874
                //if user is in administrator-group, get this group else just get the first one
875
                if($admin->is_group_match($aGroups_id,'1')) { $group_id = 1; $groups_id = '1'; } else { $group_id = intval($aGroups_id[0]); }
876
                $sMessage = "<span>Updating group_id ".$TEXT['DISPLAY_NAME']." " .$aUsers[$user_id]['display_name']."</span>";
877
                $sql  = 'UPDATE `'.TABLE_PREFIX.'users` ';
878
                $sql .= 'SET `group_id`  = '.$group_id.', ';
879
                $sql .=     '`groups_id` = \''.$groups_id.'\' ';
880
                $sql .= 'WHERE `user_id` = '.intval($user_id);
881
                if($oRes = $database->query($sql)){  }
882
                $aDebugMessage[] = $database->is_error()==false ? $sMessage." $OK<br />" : $sMessage." $FAIL!<br />";
883
        }
884
        unset($aUsers);
885
	$aDebugMessage[] = '</div>';
886

    
887
	if($bDebugModus) {
888
	// $aDebugMessage[] =
889
	    echo implode(PHP_EOL,$aDebugMessage);
890
	}else {
891
	    echo '<span><strong>'.$iTotalUsers.' users updating the groups</strong></span>'." $OK<br />";
892
	    echo '</div>';
893
	}
894
}
895

    
896
$aDebugMessage = array();
897
echo '<h3>Step '.(++$stepID).': Updating access files in folders</h3>';
898

    
899
echo '<div style="margin-left:2em;">';
900
	/**********************************************************
901
	* upgrade media directory index protect files
902
	*/
903
//	echo '<h4>Upgrade media directory '.MEDIA_DIRECTORY.'/ index.php protect files</h4>';
904
//	$aDebugMessage = rebuildFolderProtectFile();
905
//	if( sizeof( $aDebugMessage ) ){
906
//		echo '<span><strong>Upgrade '.sizeof( $aDebugMessage ).' directory '.MEDIA_DIRECTORY.'/ protect files</strong></span>'." $OK<br />";
907
//	} else {
908
//		echo '<span><strong>Upgrade directory '.MEDIA_DIRECTORY.'/ protect files</strong></span>'." $FAIL!<br />";
909
//		echo implode ('<br />',$aDebugMessage);
910
//	}
911
//
912
//    $aDebugMessage = array();
913
    /**********************************************************
914
     * upgrade pages directory index access files
915
     */
916
	echo '<h4>Upgrade pages directory '.PAGES_DIRECTORY.'/  access files</h4>';
917

    
918
    /**********************************************************
919
     *  - Reformat/rebuild all existing access files
920
     */
921
    $msg = rebuild_all_accessfiles($bDebugModus);
922
	echo '<strong>'.implode ('<br />',$msg).'</strong>';
923
    echo '</div>';
924

    
925
	/* *****************************************************************************
926
	 * - check for deprecated / never needed files
927
	 */
928
	$iLoaded = sizeof($aFilesToRemove);
929
	if($iLoaded) {
930
		echo '<h3>Step '.(++$stepID).': Remove deprecated and outdated files</h3>';
931
		$iFailed = 0;
932
		$iFound = 0;
933
		$searches = array(
934
			'[ADMIN]',
935
			'[MEDIA]',
936
			'[PAGES]',
937
			'[FRAMEWORK]',
938
			'[MODULES]',
939
			'[TEMPLATE]'
940
		);
941
		$replacements = array(
942
			'/'.substr(ADMIN_PATH, strlen(WB_PATH)+1),
943
			MEDIA_DIRECTORY,
944
			PAGES_DIRECTORY,
945
			'/framework',
946
			'/modules',
947
			'/templates'
948
		);
949

    
950
		$msg = '';
951
		echo '<div style="margin-left:2em;">';
952
		echo '<h4>Search '.$iLoaded.' deprecated and outdated files</h4>';
953
		foreach( $aFilesToRemove as $file )
954
		{
955
			$file = str_replace($searches, $replacements, $file);
956
			if( is_writable(WB_PATH.'/'.$file) ) {
957
				$iFound++;
958
				// try to unlink file
959
				if(!unlink(WB_PATH.$file)) {
960
					$iFailed++;
961
				}
962
			}
963
			if( is_readable(WB_PATH.'/'.$file) ) {
964
				// save in err-list, if failed
965
				$msg .= $file.'<br />';
966
			}
967
		}
968
		$iRemove = $iFound-$iFailed;
969
		echo '<strong>Remove '.$iRemove.' from '.$iFound.' founded</strong> ';
970
		echo ($iFailed == 0) ? $OK : $FAIL;
971
		echo '</div>';
972

    
973
		if($msg != '')
974
		{
975
			$msg = '<br /><br />Following files are deprecated, outdated or a security risk and
976
				    can not be removed automatically.<br /><br />Please delete them
977
					using FTP and restart upgrade-script!<br /><br />'.$msg.'<br />';
978
			status_msg($msg, 'error warning', 'div');
979
			echo '<p style="font-size:120%;"><strong>WARNING: The upgrade script failed ...</strong></p>';
980

    
981
			echo '<form action="'.$_SERVER['SCRIPT_NAME'].'">';
982
			echo '&nbsp;<input name="send" type="submit" value="Restart upgrade script" />';
983
			echo '</form>';
984
			echo "<br /><br /></div>
985
			</div>
986
			</div>
987
			</body>
988
			</html>";
989
			exit;
990
		}
991
	}
992

    
993

    
994
	/**********************************************************
995
	 * - check for deprecated / never needed files
996
	 */
997
	$iLoaded = sizeof($dirRemove);
998
	if($iLoaded) {
999
		echo '<h3>Step  '.(++$stepID).': Remove deprecated and outdated folders</h3>';
1000
		$iFailed = 0;
1001
		$iFound = 0;
1002
		$searches = array(
1003
			'[ADMIN]',
1004
			'[MEDIA]',
1005
			'[PAGES]',
1006
			'[TEMPLATE]'
1007
		);
1008
		$replacements = array(
1009
			substr(ADMIN_PATH, strlen(WB_PATH)+1),
1010
			MEDIA_DIRECTORY,
1011
			PAGES_DIRECTORY,
1012
			'/templates',
1013
		);
1014
		$msg = '';
1015
		echo '<div style="margin-left:2em;">';
1016
		echo '<h4>Search '.$iLoaded.' deprecated and outdated folders</h4>';
1017
		foreach( $dirRemove as $dir ) {
1018
			$dir = str_replace($searches, $replacements, $dir);
1019
			$dir = WB_PATH.'/'.$dir;
1020
			if( is_dir( $dir )) {
1021
				$iFound++;
1022
			// try to delete dir
1023
				if(!is_writable( $dir ) || !rm_full_dir($dir)) {
1024
				// save in err-list, if failed
1025
					$iFailed++;
1026
				}
1027
			}
1028
			if( is_readable(WB_PATH.'/'.$dir) ) {
1029
				$msg .= str_replace(WB_PATH,'',$dir).'<br />';
1030
			}
1031
		}
1032
		
1033
		$iRemove = $iFound-$iFailed;
1034
		echo '<strong>Remove '.$iRemove.' from '.$iFound.' founded</strong> ';
1035
		echo ($iFailed == 0) ? $OK : $FAIL;
1036
		echo '</div>';
1037

    
1038
		if($msg != '') {
1039
			$msg = '<br /><br />Following directories are deprecated, outdated or a security risk and
1040
					can not be removed automatically.<br /><br />Please delete them
1041
					using FTP and restart upgrade-script!<br /><br />'.$msg.'<br />';
1042
			status_msg($msg, 'error warning', 'div');
1043
			echo '<p style="font-size:120%;"><strong>WARNING: The upgrade script failed ...</strong></p>';
1044
			echo '<form action="'.$_SERVER['SCRIPT_NAME'].'">';
1045
			echo '&nbsp;<input name="send" type="submit" value="Restart upgrade script" />';
1046
			echo '</form>';
1047
			echo "<br /><br /></div>
1048
			</div>
1049
			</div>
1050
			</body>
1051
			</html>";
1052
			exit;
1053
		}
1054

    
1055

    
1056
	}
1057

    
1058
	/**********************************************************
1059
	 * upgrade modules if newer version is available
1060
	 * $aModuleList list of proofed modules
1061
	 */
1062
	$aProofedModuleList = array(
1063
	              'captcha_control','code','droplets','form','jsadmin',
1064
	              'menu_link','news','output_filter','wrapper','wysiwyg','MultiLingual');
1065
	if(sizeof($aProofedModuleList)) 
1066
	{
1067
		echo '<h3>Step '.(++$stepID).': Upgrade proofed modules</h3>';
1068
		foreach($aProofedModuleList as $sModul) {
1069
			if(file_exists(WB_PATH.'/modules/'.$sModul.'/upgrade.php')) {
1070
				$currModulVersion = get_modul_version ($sModul, false);
1071
				$newModulVersion =  get_modul_version ($sModul, true);
1072
				if((version_compare($currModulVersion, $newModulVersion) <= 0)) {
1073
					echo '<div style="margin-left:2em;">';
1074
					echo '<h4>'.'Upgrade module \''.$sModul.'\' version '.$newModulVersion.'</h4>';
1075
					require(WB_PATH.'/modules/'.$sModul.'/upgrade.php');
1076
					echo '</div>';
1077
				}
1078
			}
1079
		}
1080
	}
1081

    
1082
	/**********************************************************
1083
	 * Reformat/rebuild all existing moules access files
1084
	 * $aModuleList list of modules
1085
	 */
1086
	$aModuleList = array('bakery','topics','news');
1087
	if(sizeof($aModuleList)) 
1088
	{
1089
		echo '<h3>Step '.(++$stepID).': Create/Reorg Accessfiles from modules</h3>';
1090
		foreach($aModuleList as $sModul) {
1091
			$aReturnMsg = array();
1092
			$sModulReorg = 'm_'.$sModul.'_Reorg';
1093
			if(class_exists($sModulReorg)) {
1094
				$sModulVersion =  get_modul_version ($sModul, true);
1095
				echo '<div style="margin-left:2em;">';
1096
				echo '<h4>'.'Create/Reorg Accessfiles for module \''.$sModul.'\' version '.$sModulVersion.'</h4>';
1097
				$oReorg = new $sModulReorg($sModulReorg::LOG_EXTENDED);
1098
				$aReturnMsg = $oReorg->execute(); // show details
1099
                $aReport = $oReorg->getReport();
1100
                unset($oReorg);
1101
                if($bDebugModus) {
1102
                    foreach($aReport['Failed'] as $sValue) {
1103
                        echo $sValue.'<br />';
1104
                    }
1105
                    foreach($aReport['Success'] as $sValue) {
1106
                        echo $sValue.'<br />';
1107
                    }
1108
    			}
1109
//				echo '<strong>'.$aReport['FilesDeleted'].' Files successful deleted</strong><br />';
1110
				echo '<strong>Number of new formated access files: '.$aReport['FilesCreated'].'</strong><br />';
1111

    
1112
				echo '</div>';
1113
			}
1114
		}
1115
	}
1116
/**********************************************************
1117
 *  - Reload all addons
1118
 */
1119

    
1120
	echo '<h3>Step '.(++$stepID).' : Reload all addons database entry (no upgrade)</h3><br />';
1121
	echo '<div style="margin-left:2em;">';
1122
	$iFound = 0;
1123
	$iLoaded = 0;
1124
	////delete modules
1125
	//$database->query("DELETE FROM ".TABLE_PREFIX."addons WHERE type = 'module'");
1126
	// Load all modules
1127
	if( ($handle = opendir(WB_PATH.'/modules/')) ) {
1128
		while(false !== ($file = readdir($handle))) {
1129
			if($file != '' && substr($file, 0, 1) != '.' && is_dir(WB_PATH.'/modules/'.$file) ) {
1130
				$iFound++;
1131
				$iLoaded = load_module(WB_PATH.'/modules/'.$file ) ? $iLoaded+1 : $iLoaded;
1132
// 	upgrade_module($file, true);
1133
			}
1134
		}
1135
		closedir($handle);
1136
	}
1137
	echo '<strong><span>'.$iLoaded.' Modules reloaded,</span> found '.$iFound.' directories in folder /modules/</strong><br />';
1138

    
1139
	$iFound = 0;
1140
	$iLoaded = 0;
1141
	////delete templates
1142
	//$database->query("DELETE FROM ".TABLE_PREFIX."addons WHERE type = 'template'");
1143
	// Load all templates
1144
	if( ($handle = opendir(WB_PATH.'/templates/')) ) {
1145
		while(false !== ($file = readdir($handle))) {
1146
			if($file != '' AND substr($file, 0, 1) != '.' AND $file != 'index.php') {
1147

    
1148
				$iFound++;
1149
				$iLoaded = (load_template(WB_PATH.'/templates/'.$file)==true) ? $iLoaded+1 : $iLoaded;
1150

    
1151
			}
1152
		}
1153
		closedir($handle);
1154
	}
1155
	echo '<strong><span>'.$iLoaded.' Templates reloaded,</span> found '.$iFound.' directories in folder /templates/</strong><br />';
1156

    
1157
	$iFound = 0;
1158
	$iLoaded = 0;
1159
	////delete languages
1160
	//$database->query("DELETE FROM ".TABLE_PREFIX."addons WHERE type = 'language'");
1161
	// Load all languages
1162
	if( ($handle = opendir(WB_PATH.'/languages/')) ) {
1163
		while(false !== ($file = readdir($handle))) {
1164
			if($file != '' AND (preg_match('#^([A-Z]{2}.php)#', basename($file)))) {
1165
				$iFound++;
1166
				$iLoaded = load_language(WB_PATH.'/languages/'.$file) ? $iLoaded+1 : $iLoaded;
1167
			}
1168
		}
1169
		closedir($handle);
1170
	}
1171
	echo '<strong><span>'.$iLoaded.' Languages reloaded,</span> found '.$iFound.' files in folder /languages/</strong><br />';
1172
	echo '</div>';
1173

    
1174
/**********************************************************
1175
 *  - install new droplets
1176
	$drops = (!in_array ( "mod_droplets", $all_tables)) ? "<br />Install droplets<br />" : "<br />Upgrade droplets<br />";
1177
	echo $drops;
1178
	$file_name = (!in_array ( "mod_droplets", $all_tables) ? "install.php" : "upgrade.php");
1179
	require_once (WB_PATH."/modules/droplets/".$file_name);
1180
********************************************************** */
1181

    
1182
/**********************************************************
1183
 *  - End of upgrade script
1184
 */
1185
	if(!defined('DEFAULT_THEME')) { define('DEFAULT_THEME', $DEFAULT_THEME); }
1186
	if(!defined('THEME_PATH')) { define('THEME_PATH', WB_PATH.'/templates/'.DEFAULT_THEME);}
1187
/**********************************************************
1188
 *  - Set Version to new Version
1189
 */
1190
echo '<h3>Step '.(++$stepID).': Update database version number </h3>';
1191
echo '<div style="margin-left:2em;">';
1192

    
1193
$cfg = array(
1194
	'wb_version' => VERSION,
1195
	'wb_revision' => REVISION,
1196
	'wb_sp' => SP
1197
);
1198
echo '<br /><span><strong>Set WebsiteBaker version number to '.VERSION.' '.SP.' '.' Revision ['.REVISION.'] : </strong></span>';
1199
echo (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");
1200
echo '</div>';
1201

    
1202
echo '<p style="font-size:140%;"><strong>Congratulations: The upgrade script is finished ...</strong></p>';
1203
status_msg('<strong>:</strong><br />Please delete the file <strong>upgrade-script.php</strong> via FTP before proceeding.', 'warning', 'div');
1204
// show buttons to go to the backend or frontend
1205
echo '<br />';
1206

    
1207
if(defined('WB_URL')) {
1208
	echo '<form action="'.WB_URL.'/">';
1209
	echo '&nbsp;<input type="submit" value="kick me to the Frontend" />';
1210
	echo '</form>';
1211
}
1212
if(defined('ADMIN_URL')) {
1213
	echo '<form action="'.ADMIN_URL.'/">';
1214
	echo '&nbsp;<input type="submit" value="kick me to the Backend" />';
1215
	echo '</form>';
1216
}
1217

    
1218
echo "<br /><br /></div>
1219
</div>
1220
</div>
1221
</body>
1222
</html>
1223
";
1224
exit();
(6-6/6)