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