Project

General

Profile

1 1457 Luisehahne
<?php
2
/**
3
 *
4
 * @category        backend
5
 * @package         installation
6
 * @author          WebsiteBaker Project
7 1688 Luisehahne
 * @copyright       2009-2012, WebsiteBaker Org. e.V.
8 1684 Luisehahne
 * @link            http://www.websitebaker2.org/
9 1457 Luisehahne
 * @license         http://www.gnu.org/licenses/gpl.html
10
 * @platform        WebsiteBaker 2.8.x
11
 * @requirements    PHP 5.2.2 and higher
12
 * @version         $Id$
13
 * @filesource		$HeadURL$
14
 * @lastmodified    $Date$
15
 *
16
 */
17
18 1677 Luisehahne
require_once('config.php');
19 1457 Luisehahne
20 1484 Luisehahne
require_once(WB_PATH.'/framework/functions.php');
21
require_once(WB_PATH.'/framework/class.admin.php');
22 1684 Luisehahne
// require_once(WB_PATH.'/framework/Database.php');
23 1484 Luisehahne
$admin = new admin('Addons', 'modules', false, false);
24
25 1677 Luisehahne
$oldVersion  = 'Version '.WB_VERSION;
26 1689 darkviper
$oldVersion .= (defined('WB_SP') ? WB_SP : '');
27 1688 Luisehahne
$oldRevision = (defined('WB_REVISION') ? ' Revision ['.WB_REVISION.'] ' : '') ;
28 1677 Luisehahne
$newVersion  = 'Version '.VERSION;
29 1689 darkviper
$newVersion .= (defined('SP') ? SP : '');
30 1688 Luisehahne
$newRevision = (defined('REVISION') ? ' Revision ['.REVISION.'] ' : '');
31 1457 Luisehahne
32 1677 Luisehahne
// set addition settings if not exists, otherwise upgrade will be breaks
33
if(!defined('WB_SP')) { define('WB_SP',''); }
34
if(!defined('WB_REVISION')) { define('WB_REVISION',''); }
35
36 1457 Luisehahne
// database tables including in WB package
37 1677 Luisehahne
$aTable = array (
38 1457 Luisehahne
    'settings','groups','addons','pages','sections','search','users',
39
    'mod_captcha_control','mod_code','mod_droplets','mod_form_fields',
40
    'mod_form_settings','mod_form_submissions','mod_jsadmin','mod_menu_link',
41
    'mod_news_comments','mod_news_groups','mod_news_posts','mod_news_settings',
42
    'mod_output_filter','mod_wrapper','mod_wysiwyg'
43
);
44
45 1484 Luisehahne
$OK            = ' <span class="ok">OK</span> ';
46
$FAIL          = ' <span class="error">FAILED</span> ';
47
$DEFAULT_THEME = 'wb_theme';
48 1677 Luisehahne
49 1671 Luisehahne
$stepID = 0;
50 1532 Luisehahne
$dirRemove = array(
51 1484 Luisehahne
/*
52
			'[TEMPLATE]/allcss/',
53
			'[TEMPLATE]/blank/',
54
			'[TEMPLATE]/round/',
55
			'[TEMPLATE]/simple/',
56
*/
57 1641 Luisehahne
			'[ADMIN]/themes/',
58 1484 Luisehahne
		 );
59
60 1532 Luisehahne
$filesRemove['0'] = array(
61 1484 Luisehahne
62 1525 Luisehahne
			'[ADMIN]/preferences/details.php',
63
			'[ADMIN]/preferences/email.php',
64 1666 Luisehahne
			'[ADMIN]/preferences/password.php',
65 1684 Luisehahne
			'[ADMIN]/pages/settings2.php',
66 1525 Luisehahne
67 1684 Luisehahne
			'[FRAMEWORK]/class.msg_queue.php',
68 1689 darkviper
			'[FRAMEWORK]/class.logfile.php',
69
//			'[FRAMEWORK]/class.database.php',
70 1684 Luisehahne
71 1532 Luisehahne
		 );
72
73 1684 Luisehahne
if(version_compare(WB_REVISION, '1681', '<'))
74 1671 Luisehahne
{
75
	$filesRemove['1'] = array(
76 1532 Luisehahne
77 1529 Luisehahne
			'[TEMPLATE]/argos_theme/templates/access.htt',
78
			'[TEMPLATE]/argos_theme/templates/addons.htt',
79
			'[TEMPLATE]/argos_theme/templates/admintools.htt',
80
			'[TEMPLATE]/argos_theme/templates/error.htt',
81
			'[TEMPLATE]/argos_theme/templates/groups.htt',
82
			'[TEMPLATE]/argos_theme/templates/groups_form.htt',
83
			'[TEMPLATE]/argos_theme/templates/languages.htt',
84
			'[TEMPLATE]/argos_theme/templates/languages_details.htt',
85 1671 Luisehahne
	/*
86 1529 Luisehahne
			'[TEMPLATE]/argos_theme/templates/login.htt',
87
			'[TEMPLATE]/argos_theme/templates/login_forgot.htt',
88 1671 Luisehahne
	*/
89 1529 Luisehahne
			'[TEMPLATE]/argos_theme/templates/media.htt',
90
			'[TEMPLATE]/argos_theme/templates/media_browse.htt',
91
			'[TEMPLATE]/argos_theme/templates/media_rename.htt',
92
			'[TEMPLATE]/argos_theme/templates/modules.htt',
93
			'[TEMPLATE]/argos_theme/templates/modules_details.htt',
94
			'[TEMPLATE]/argos_theme/templates/pages.htt',
95
			'[TEMPLATE]/argos_theme/templates/pages_modify.htt',
96
			'[TEMPLATE]/argos_theme/templates/pages_sections.htt',
97
			'[TEMPLATE]/argos_theme/templates/pages_settings.htt',
98
			'[TEMPLATE]/argos_theme/templates/preferences.htt',
99
			'[TEMPLATE]/argos_theme/templates/setparameter.htt',
100
			'[TEMPLATE]/argos_theme/templates/settings.htt',
101
			'[TEMPLATE]/argos_theme/templates/start.htt',
102
			'[TEMPLATE]/argos_theme/templates/success.htt',
103
			'[TEMPLATE]/argos_theme/templates/templates.htt',
104
			'[TEMPLATE]/argos_theme/templates/templates_details.htt',
105
			'[TEMPLATE]/argos_theme/templates/users.htt',
106
			'[TEMPLATE]/argos_theme/templates/users_form.htt',
107
108
			'[TEMPLATE]/wb_theme/templates/access.htt',
109
			'[TEMPLATE]/wb_theme/templates/addons.htt',
110
			'[TEMPLATE]/wb_theme/templates/admintools.htt',
111
			'[TEMPLATE]/wb_theme/templates/error.htt',
112
			'[TEMPLATE]/wb_theme/templates/groups.htt',
113
			'[TEMPLATE]/wb_theme/templates/groups_form.htt',
114
			'[TEMPLATE]/wb_theme/templates/languages.htt',
115
			'[TEMPLATE]/wb_theme/templates/languages_details.htt',
116 1625 Luisehahne
117 1671 Luisehahne
	/*
118 1529 Luisehahne
			'[TEMPLATE]/wb_theme/templates/login.htt',
119
			'[TEMPLATE]/wb_theme/templates/login_forgot.htt',
120 1671 Luisehahne
	*/
121 1625 Luisehahne
122 1529 Luisehahne
			'[TEMPLATE]/wb_theme/templates/media.htt',
123
			'[TEMPLATE]/wb_theme/templates/media_browse.htt',
124
			'[TEMPLATE]/wb_theme/templates/media_rename.htt',
125
			'[TEMPLATE]/wb_theme/templates/modules.htt',
126
			'[TEMPLATE]/wb_theme/templates/modules_details.htt',
127
			'[TEMPLATE]/wb_theme/templates/pages.htt',
128
			'[TEMPLATE]/wb_theme/templates/pages_modify.htt',
129
			'[TEMPLATE]/wb_theme/templates/pages_sections.htt',
130
			'[TEMPLATE]/wb_theme/templates/pages_settings.htt',
131
			'[TEMPLATE]/wb_theme/templates/preferences.htt',
132
			'[TEMPLATE]/wb_theme/templates/setparameter.htt',
133
			'[TEMPLATE]/wb_theme/templates/settings.htt',
134
			'[TEMPLATE]/wb_theme/templates/start.htt',
135
			'[TEMPLATE]/wb_theme/templates/success.htt',
136
			'[TEMPLATE]/wb_theme/templates/templates.htt',
137
			'[TEMPLATE]/wb_theme/templates/templates_details.htt',
138
			'[TEMPLATE]/wb_theme/templates/users.htt',
139
			'[TEMPLATE]/wb_theme/templates/users_form.htt',
140 1525 Luisehahne
		 );
141 1671 Luisehahne
}
142 1525 Luisehahne
143 1677 Luisehahne
/* display a status message on the screen **************************************
144
 * @param string $message: the message to show
145
 * @param string $class:   kind of message as a css-class
146
 * @param string $element: witch HTML-tag use to cover the message
147
 * @return void
148
 */
149
function status_msg($message, $class='check', $element='span')
150
{
151
	// returns a status message
152
	$msg  = '<'.$element.' class="'.$class.'">';
153
	$msg .= '<strong>'.strtoupper(strtok($class, ' ')).'</strong>';
154
	$msg .= $message.'</'.$element.'>';
155
	echo $msg;
156
}
157
158 1457 Luisehahne
// analyze/check database tables
159
function mysqlCheckTables( $dbName )
160
{
161 1677 Luisehahne
    global $aTable;
162 1457 Luisehahne
    $table_prefix = TABLE_PREFIX;
163
    $sql = "SHOW TABLES FROM " . $dbName;
164
    $result = @mysql_query( $sql );
165
    $data = array();
166
    $x = 0;
167
168 1677 Luisehahne
    while( ( $row = mysql_fetch_array( $result, MYSQL_NUM ) ) == true )
169 1457 Luisehahne
    {
170
        $tmp = str_replace($table_prefix, '', $row[0]);
171
172 1677 Luisehahne
        if( stristr( $row[0], $table_prefix )&& in_array($tmp,$aTable) )
173 1457 Luisehahne
        {
174
            $sql = "CHECK TABLE " . $dbName . '.' . $row[0];
175 1677 Luisehahne
            $analyze = mysql_query( $sql );
176
            $rowFetch = mysql_fetch_array( $analyze, MYSQL_ASSOC );
177 1457 Luisehahne
            $data[$x]['Op'] = $rowFetch["Op"];
178
            $data[$x]['Msg_type'] = $rowFetch["Msg_type"];
179
            $msgColor = '<span class="error">';
180
            $data[$x]['Table'] = $row[0];
181
           // print  " ";
182
            $msgColor = ($rowFetch["Msg_text"] == 'OK') ? '<span class="ok">' : '<span class="error">';
183
            $data[$x]['Msg_text'] = $msgColor.$rowFetch["Msg_text"].'</span>';
184
           // print  "<br />";
185
            $x++;
186
        }
187
    }
188
    return $data;
189
}
190
191
// check existings tables for upgrade or install
192
function check_wb_tables()
193
{
194 1677 Luisehahne
    global $database,$aTable;
195 1457 Luisehahne
196
 // if prefix inludes '_' or '%'
197
 $search_for = addcslashes ( TABLE_PREFIX, '%_' );
198
 $get_result = $database->query( 'SHOW TABLES LIKE "'.$search_for.'%"');
199
200
        // $get_result = $database->query( "SHOW TABLES FROM ".DB_NAME);
201
        $all_tables = array();
202
        if($get_result->numRows() > 0)
203
        {
204
            while ($data = $get_result->fetchRow())
205
            {
206
                $tmp = str_replace(TABLE_PREFIX, '', $data[0]);
207 1677 Luisehahne
                if(in_array($tmp,$aTable))
208 1457 Luisehahne
                {
209
                    $all_tables[] = $tmp;
210
                }
211
            }
212
        }
213
     return $all_tables;
214
}
215
216
// check existing tables
217
$all_tables = check_wb_tables();
218
219 1671 Luisehahne
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
220 1457 Luisehahne
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
221
<head>
222
<title>Upgrade script</title>
223
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
224
<style type="text/css">
225 1684 Luisehahne
html { overflow-y: scroll; /* Force firefox to always show room for a vertical scrollbar */ }
226 1457 Luisehahne
227
body {
228
	margin:0;
229
	padding:0;
230
	border:0;
231
	background: #EBF7FC;
232
	color:#000;
233
	font-family: 'Trebuchet MS', Verdana, Arial, Helvetica, Sans-Serif;
234
	font-size: small;
235
	height:101%;
236
}
237
238
#container {
239
	width:85%;
240
	background: #A8BCCB url(templates/wb_theme/images/background.png) repeat-x;
241
	border:1px solid #000;
242
	color:#000;
243
	margin:2em auto;
244
	padding:0 15px;
245
	min-height: 500px;
246
	text-align:left;
247
}
248
249
p { line-height:1.5em; }
250
251 1532 Luisehahne
form {
252
	display: inline-block;
253
	line-height: 20px;
254
	vertical-align: baseline;
255
}
256
input[type="submit"].restart {
257
	background-color: #FFDBDB;
258
	font-weight: bold;
259
}
260
261 1457 Luisehahne
h1,h2,h3,h4,h5,h6 {
262
	font-family: Verdana, Arial, Helvetica, sans-serif;
263
	color: #369;
264
	margin-top: 1.0em;
265
	margin-bottom: 0.1em;
266
}
267
268
h1 { font-size:150%; }
269
h2 { font-size: 130%; border-bottom: 1px #CCC solid; }
270 1671 Luisehahne
h3 { font-size: 110%; font-weight: bold;; }
271 1457 Luisehahne
272
.ok, .error { font-weight:bold; }
273
.ok { color:green; }
274
.error { color:red; }
275
.check { color:#555; }
276
277
.warning {
278
	width: 98%;
279
	background:#FFDBDB;
280
	padding:0.2em;
281
	margin-top:0.5em;
282
	border: 1px solid black;
283
}
284
.info {
285
	width: 98%;
286
	background:#99CC99;
287
	padding:0.2em;
288
	margin-top:0.5em;
289
	border: 1px solid black;
290
}
291
292
</style>
293
</head>
294
<body>
295
<div id="container">
296
<img src="templates/wb_theme/images/logo.png" alt="WebsiteBaker Project" />
297
<h1>WebsiteBaker Upgrade</h1>
298
<?php
299 1525 Luisehahne
	if( version_compare( WB_VERSION, '2.7', '<' )) {
300 1529 Luisehahne
		status_msg('<strong>Warning:</strong><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');
301 1457 Luisehahne
		echo '<br /><br />';
302
		echo "</div>
303
		</body>
304
		</html>
305
		";
306
		exit();
307
	}
308 1532 Luisehahne
309 1457 Luisehahne
?>
310 1688 Luisehahne
<p>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>
311 1457 Luisehahne
312
<?php
313
/**
314
 * Check if disclaimer was accepted
315
 */
316
if (!(isset($_POST['backup_confirmed']) && $_POST['backup_confirmed'] == 'confirmed')) { ?>
317
<h2>Step 1: Backup your files</h2>
318
<p>It is highly recommended to <strong>create a manual backup</strong> of the entire <strong>/pages folder</strong> and the <strong>MySQL database</strong> before proceeding.<br /><strong class="error">Note: </strong>The upgrade script alters some settings of your existing database!!! You need to confirm the disclaimer before proceeding.</p>
319
320 1532 Luisehahne
<form name="send" action="<?php echo $_SERVER['SCRIPT_NAME'];?>" method="post">
321 1457 Luisehahne
<textarea cols="80" 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 /pages folder (including all files and subfolders contained in it) and backup of the entire WebsiteBaker MySQL database was created before you can proceed.</textarea>
322
<br /><br /><input name="backup_confirmed" type="checkbox" value="confirmed" />&nbsp;I confirm that a manual backup of the /pages folder and the MySQL database was created.
323
<br /><br /><input name="send" type="submit" value="Start upgrade script" />
324
</form>
325
<br />
326
327
<?php
328
	status_msg('<strong>Notice:</strong><br />You need to confirm that you have created a manual backup of the /pages directory and the MySQL database before you can proceed.', 'warning', 'div');
329
	echo '<br /><br />';
330
    echo "</div>
331
    </body>
332
    </html>
333
    ";
334
	exit();
335
}
336
337 1671 Luisehahne
echo '<h3>Step '.(++$stepID).': Setting default_theme</h3>';
338 1532 Luisehahne
339 1457 Luisehahne
/**********************************************************
340
 *  - Adding field default_theme to settings table
341
 */
342 1671 Luisehahne
echo "<br />Adding default_theme to settings table";
343
// db_update_key_value('settings', 'default_theme', $DEFAULT_THEME);
344
echo (db_update_key_value( 'settings', 'default_theme', $DEFAULT_THEME ) ? " $OK<br />" : " $FAIL!<br />");
345 1457 Luisehahne
346
// check again all tables, to get a new array
347
 if(sizeof($all_tables) < 22) { $all_tables = check_wb_tables(); }
348
/**********************************************************
349
 *  - check tables comin with WebsiteBaker
350
 */
351
    $check_text = 'total ';
352
    // $check_tables = mysqlCheckTables( DB_NAME ) ;
353
354
    if(sizeof($all_tables) == 22)
355
    {
356 1688 Luisehahne
        echo '<h4>NOTICE: Your database '.DB_NAME.' has '.sizeof($all_tables).' '.$check_text.' tables from '.sizeof($aTable).' included in package '.$OK.'</h4>';
357 1457 Luisehahne
    }
358
    else
359
    {
360
        status_msg('<strong>WARNING:</strong><br />can\'t run Upgrade, missing tables', 'warning', 'div');
361
    	echo '<h4>Missing required tables. You can install them in backend->addons->modules->advanced. Then again run upgrade-script.php</h4>';
362 1677 Luisehahne
        $result = array_diff ( $aTable, $all_tables );
363 1457 Luisehahne
        echo '<h4 class="warning"><br />';
364
        while ( list ( $key, $val ) = each ( $result ) )
365
        {
366
            echo TABLE_PREFIX.$val.' '.$FAIL.'<br>';
367
        }
368
        echo '<br /></h4>';
369
    	echo '<br /><form action="'. $_SERVER['PHP_SELF'] .'">';
370
    	echo '<input type="submit" value="kick me back" style="float:left;" />';
371
    	echo '</form>';
372
        if(defined('ADMIN_URL'))
373
        {
374
        	echo '<form action="'.ADMIN_URL.'" target="_self">';
375
        	echo '&nbsp;<input type="submit" value="kick me to the Backend" />';
376
        	echo '</form>';
377
        }
378
        echo "<br /><br /></div>
379
        </body>
380
        </html>
381
        ";
382
        exit();
383
    }
384
385 1671 Luisehahne
386
echo '<h3>Step '.(++$stepID).': Updating settings</h3>';
387 1457 Luisehahne
/**********************************************************
388
 *  - Adding field sec_anchor to settings table
389
 */
390 1671 Luisehahne
echo "<br />Adding sec_anchor to settings table";
391 1457 Luisehahne
$cfg = array(
392 1684 Luisehahne
	'sec_anchor' => defined('SEC_ANCHOR') ? SEC_ANCHOR : 'wb_'
393 1457 Luisehahne
);
394
395 1671 Luisehahne
echo (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");
396
397
398 1457 Luisehahne
/**********************************************************
399
 *  - Adding redirect timer to settings table
400
 */
401 1671 Luisehahne
echo "Adding redirect timer to settings table";
402 1457 Luisehahne
$cfg = array(
403 1684 Luisehahne
	'redirect_timer' => defined('Redirect_Timer') ? Redirect_Timer : '1500'
404 1457 Luisehahne
);
405 1671 Luisehahne
echo (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");
406 1457 Luisehahne
407
/**********************************************************
408 1532 Luisehahne
 *  - Adding rename_files_on_upload to settings table
409
 */
410 1671 Luisehahne
echo "Updating rename_files_on_upload to settings table";
411 1532 Luisehahne
$cfg = array(
412 1684 Luisehahne
	'rename_files_on_upload' => (defined('RENAME_FILES_ON_UPLOAD') ? RENAME_FILES_ON_UPLOAD : 'ph.*?,cgi,pl,pm,exe,com,bat,pif,cmd,src,asp,aspx,js')
413 1532 Luisehahne
);
414 1671 Luisehahne
echo (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");
415 1532 Luisehahne
416
/**********************************************************
417 1457 Luisehahne
 *  - Adding mediasettings to settings table
418
 */
419 1671 Luisehahne
echo "Adding mediasettings to settings table";
420 1457 Luisehahne
$cfg = array(
421 1684 Luisehahne
	'mediasettings' => (defined('MEDIASETTINGS') ? MEDIASETTINGS : ''),
422 1457 Luisehahne
);
423 1484 Luisehahne
424 1671 Luisehahne
echo (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");
425 1457 Luisehahne
426
/**********************************************************
427
 *  - Adding fingerprint_with_ip_octets to settings table
428
 */
429 1671 Luisehahne
echo "Adding fingerprint_with_ip_octets to settings table";
430 1457 Luisehahne
$cfg = array(
431 1684 Luisehahne
	'fingerprint_with_ip_octets' => (defined('FINGERPRINT_WITH_IP_OCTETS') ? FINGERPRINT_WITH_IP_OCTETS : '2'),
432
	'secure_form_module' => (defined('SECURE_FORM_MODULE') ? SECURE_FORM_MODULE : '')
433 1457 Luisehahne
);
434 1671 Luisehahne
435
echo (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");
436
437 1666 Luisehahne
/**********************************************************
438
 *  - Adding page_icon_dir to settings table
439
 */
440 1671 Luisehahne
echo "Adding page_icon_dir to settings table";
441 1666 Luisehahne
$cfg = array(
442 1684 Luisehahne
	'page_icon_dir' => (defined('PAGE_ICON_DIR') ? PAGE_ICON_DIR : '/templates/*/title_images'),
443 1666 Luisehahne
);
444 1671 Luisehahne
445
echo (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");
446
447 1666 Luisehahne
/**********************************************************
448
 *  - Adding dev_infos to settings table
449
 */
450 1671 Luisehahne
echo "Adding dev_infos to settings table";
451 1666 Luisehahne
$cfg = array(
452 1684 Luisehahne
	'dev_infos' => (defined('DEV_INFOS') ? DEV_INFOS : 'false')
453 1666 Luisehahne
);
454 1457 Luisehahne
455 1671 Luisehahne
echo (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");
456
457 1689 darkviper
if(version_compare(WB_REVISION, REVISION, '<'))
458 1671 Luisehahne
{
459
	echo '<h3>Step '.(++$stepID).': Updating core tables</h3>';
460
461
	/**********************************************************
462
	 *  - Update search no results database filed to create
463
	 *  valid XHTML if search is empty
464
	 */
465
	if (version_compare(WB_VERSION, '2.8', '<'))
466
	{
467
	    echo "<br />Updating database field `no_results` of search table: ";
468
	    $search_no_results = addslashes('<tr><td><p>[TEXT_NO_RESULTS]</p></td></tr>');
469
	    $sql  = 'UPDATE `'.TABLE_PREFIX.'search` ';
470
		$sql .= 'SET `value`=\''.$search_no_results.'\' ';
471
		$sql .= 'WHERE `name`=\'no_results\'';
472
	    echo ($database->query($sql)) ? ' $OK<br />' : ' $FAIL<br />';
473
	}
474
	/**********************************************************
475 1457 Luisehahne
 *  - Add field "redirect_type" to table "mod_menu_link"
476
 */
477 1671 Luisehahne
	$table_name = TABLE_PREFIX.'mod_menu_link';
478
	$field_name = 'redirect_type';
479
	$description = "INT NOT NULL DEFAULT '302' AFTER `target_page_id`";
480
	if(!$database->field_exists($table_name,$field_name)) {
481
		echo "<br />Adding field redirect_type to mod_menu_link table";
482
		echo ($database->field_add($table_name, $field_name, $description) ? " $OK<br />" : " $FAIL!<br />");
483
	} else {
484
		echo "<br />Modify field redirect_type to mod_menu_link table";
485
		echo ($database->field_modify($table_name, $field_name, $description) ? " $OK<br />" : " $FAIL!<br />");
486
	}
487 1457 Luisehahne
488 1671 Luisehahne
	/**********************************************************
489
	 *  - Add field "page_trail" to table "pages"
490
	 */
491
	$table_name = TABLE_PREFIX.'pages';
492
	$field_name = 'page_trail';
493
	$description = "VARCHAR( 255 ) NOT NULL DEFAULT ''";
494
	echo "Modify field page_trail to pages table";
495
	echo ($database->field_modify($table_name, $field_name, $description) ? " $OK<br />" : " $FAIL!<br />");
496
497
	/**********************************************************
498 1666 Luisehahne
 *  - Add field "page_icon" to table "pages"
499
 */
500 1671 Luisehahne
	$table_name = TABLE_PREFIX.'pages';
501
	$field_name = 'page_icon';
502 1684 Luisehahne
	$description = "VARCHAR( 512 ) NOT NULL DEFAULT '' AFTER `page_title`";
503 1671 Luisehahne
	if(!$database->field_exists($table_name,$field_name)) {
504
		echo "Adding field page_icon to pages table";
505
		echo ($database->field_add($table_name, $field_name, $description) ? " $OK<br />" : " $FAIL!<br />");
506
	} else {
507
		echo "Modify field page_icon to pages table";
508
		echo ($database->field_modify($table_name, $field_name, $description) ? " $OK<br />" : " $FAIL!<br />");
509
	}
510 1666 Luisehahne
511 1671 Luisehahne
	/**********************************************************
512 1688 Luisehahne
	 *  - Add field "tooltip" to table "pages"
513 1686 darkviper
 */
514
	$table_name = TABLE_PREFIX.'pages';
515
	$field_name = 'tooltip';
516
	$description = "VARCHAR( 512 ) NOT NULL DEFAULT '' AFTER `page_icon`";
517 1688 Luisehahne
	if(!$database->field_exists($table_name,$field_name)) {
518
		echo "Adding field tooltip to pages table";
519
		echo ($database->field_add($table_name, $field_name, $description) ? " $OK<br />" : " $FAIL!<br />");
520
	} else {
521 1686 darkviper
	echo "Modify field tooltip to pages table";
522
	echo ($database->field_modify($table_name, $field_name, $description) ? " $OK<br />" : " $FAIL!<br />");
523 1688 Luisehahne
	}
524 1686 darkviper
525
	/**********************************************************
526 1671 Luisehahne
	 *  - Add field "page_code" to table "pages"
527
	 */
528
	$table_name = TABLE_PREFIX.'pages';
529
	$field_name = 'page_code';
530
	$description = "INT NOT NULL DEFAULT '0' AFTER `language`";
531
	if(!$database->field_exists($table_name,$field_name)) {
532
		echo "Adding field page_code to pages table";
533
		echo ($database->field_add($table_name, $field_name, $description) ? " $OK<br />" : " $FAIL!<br />");
534
	} else {
535
		echo "Modify field page_code to pages table";
536
		echo ($database->field_modify($table_name, $field_name, $description) ? " $OK<br />" : " $FAIL!<br />");
537
	}
538
539
	/**********************************************************
540 1666 Luisehahne
 *  - Add field "menu_icon_0" to table "pages"
541
 */
542 1671 Luisehahne
	$table_name = TABLE_PREFIX.'pages';
543
	$field_name = 'menu_icon_0';
544 1684 Luisehahne
	$description = "VARCHAR( 512 ) NOT NULL DEFAULT '' AFTER `menu_title`";
545 1671 Luisehahne
	if(!$database->field_exists($table_name,$field_name)) {
546
		echo "Adding field menu_icon_0 to pages table";
547
		echo ($database->field_add($table_name, $field_name, $description) ? " $OK<br />" : " $FAIL!<br />");
548
	} else {
549
		echo "Modify field menu_icon_0 to pages table";
550
		echo ($database->field_modify($table_name, $field_name, $description) ? " $OK<br />" : " $FAIL!<br />");
551
	}
552 1666 Luisehahne
553 1671 Luisehahne
	/**********************************************************
554
	 *  - Add field "menu_icon_1" to table "pages"
555 1666 Luisehahne
 */
556 1671 Luisehahne
	$table_name = TABLE_PREFIX.'pages';
557
	$field_name = 'menu_icon_1';
558 1684 Luisehahne
	$description = "VARCHAR( 512 ) NOT NULL DEFAULT '' AFTER `menu_icon_0`";
559 1671 Luisehahne
	if(!$database->field_exists($table_name,$field_name)) {
560
		echo "Adding field menu_icon_1 to pages table";
561
		echo ($database->field_add($table_name, $field_name, $description) ? " $OK<br />" : " $FAIL!<br />");
562
	} else {
563
		echo "Modify field menu_icon_1 to pages table";
564
		echo ($database->field_modify($table_name, $field_name, $description) ? " $OK<br />" : " $FAIL!<br />");
565
	}
566 1666 Luisehahne
567 1671 Luisehahne
	/**********************************************************
568 1684 Luisehahne
	 *  - Add field "tooltip" to table "pages"
569
 */
570
	$table_name = TABLE_PREFIX.'pages';
571
	$field_name = 'tooltip';
572
	$description = "VARCHAR( 512 ) NOT NULL DEFAULT '' AFTER `menu_icon_1`";
573
	if(!$database->field_exists($table_name,$field_name)) {
574
		echo "Adding field tooltip to pages table";
575
		echo ($database->field_add($table_name, $field_name, $description) ? " $OK<br />" : " $FAIL!<br />");
576
	} else {
577
		echo "Modify field tooltip to pages table";
578
		echo ($database->field_modify($table_name, $field_name, $description) ? " $OK<br />" : " $FAIL!<br />");
579
	}
580
581
	/**********************************************************
582 1671 Luisehahne
	 *  - Add field "admin_groups" to table "pages"
583 1588 darkviper
 */
584 1671 Luisehahne
	$table_name = TABLE_PREFIX.'pages';
585
	$field_name = 'admin_groups';
586
	$description = "VARCHAR( 512 ) NOT NULL DEFAULT '1'";
587
	echo "Modify field admin_groups to pages table";
588
	echo ($database->field_modify($table_name, $field_name, $description) ? " $OK<br />" : " $FAIL!<br />");
589
590
	/**********************************************************
591
	 *  - Add field "admin_users" to table "pages"
592
	 */
593
	$table_name = TABLE_PREFIX.'pages';
594
	$field_name = 'admin_users';
595
	$description = "VARCHAR( 512 ) NOT NULL DEFAULT ''";
596
	echo "Modify field admin_users to pages table";
597
	echo ($database->field_modify($table_name, $field_name, $description) ? " $OK<br />" : " $FAIL!<br />");
598
599
	/**********************************************************
600
	 *  - Add field "viewing_groups" to table "pages"
601
	 */
602
	$table_name = TABLE_PREFIX.'pages';
603
	$field_name = 'viewing_groups';
604
	$description = "VARCHAR( 512 ) NOT NULL DEFAULT '1'";
605
	echo "Modify field viewing_groups to pages table";
606
	echo ($database->field_modify($table_name, $field_name, $description) ? " $OK<br />" : " $FAIL!<br />");
607
608
	/**********************************************************
609
	 *  - Add field "viewing_users" to table "pages"
610
	 */
611
	$table_name = TABLE_PREFIX.'pages';
612
	$field_name = 'viewing_users';
613
	$description = "VARCHAR( 512 ) NOT NULL DEFAULT ''";
614
	echo "Modify field viewing_users to pages table";
615
	echo ($database->field_modify($table_name, $field_name, $description) ? " $OK<br />" : " $FAIL!<br />");
616 1457 Luisehahne
}
617 1671 Luisehahne
618 1457 Luisehahne
/**********************************************************
619
 * upgrade media folder index protect files
620 1671 Luisehahne
 ALTER TABLE `wb_pages` CHANGE `page_icon` `page_icon` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ''
621 1457 Luisehahne
 */
622 1588 darkviper
	$dir = (WB_PATH.MEDIA_DIRECTORY);
623
	echo '<h4>Upgrade '.MEDIA_DIRECTORY.'/ index.php protect files</h4><br />';
624
	$array = rebuildFolderProtectFile($dir);
625
	if( sizeof( $array ) ){
626
		print '<br /><strong>Upgrade '.sizeof( $array ).' '.MEDIA_DIRECTORY.'/ protect files</strong>'." $OK<br />";
627
	} else {
628
		print '<br /><strong>Upgrade '.MEDIA_DIRECTORY.'/ protect files</strong>'." $FAIL!<br />";
629
		print implode ('<br />',$array);
630 1457 Luisehahne
	}
631 1677 Luisehahne
632 1593 Luisehahne
/**********************************************************
633 1677 Luisehahne
 * upgrade pages folder index access files
634
 */
635
	echo '<h4>Upgrade /pages/ index.php access files</h4><br />';
636 1688 Luisehahne
637 1677 Luisehahne
    ///**********************************************************
638 1688 Luisehahne
    // *  - try to remove access files
639
    // */
640
	$sTempDir = (defined('PAGES_DIRECTORY') && (PAGES_DIRECTORY != '') ? PAGES_DIRECTORY : '');
641
	if(($sTempDir!='') && is_readable(WB_PATH.$sTempDir)==true) {
642
	 	if(rm_full_dir (WB_PATH.$sTempDir, true )==false) {
643
			$msg[] = '<strong>Could not delete existing access files</strong><br />';
644
	 	} else {
645
			$msg[] = createFolderProtectFile(rtrim( WB_PATH.$sTempDir,'/') );
646
        }
647
	}
648
649
    ///**********************************************************
650 1677 Luisehahne
    // *  - Reformat/rebuild all existing access files
651
    // */
652
    $msg[] = "All existing access files anew format";
653
    $sql = 'SELECT `page_id`,`link`, `level` FROM `'.TABLE_PREFIX.'pages` ORDER BY `link`';
654
    if (($res_pages = $database->query($sql)))
655
    {
656
        $x = 0;
657
        while (($rec_page = $res_pages->fetchRow()))
658
        {
659
            $filename = WB_PATH.PAGES_DIRECTORY.$rec_page['link'].PAGE_EXTENSION;
660
            $msg = create_access_file($filename, $rec_page['page_id'], $rec_page['level']);
661
            $x++;
662
        }
663
        $msg[] = '<strong>Number of the anew formatted access files: '.$x.'</strong><br />';
664
    }
665
666
	print implode ('<br />',$msg);
667
668
/*
669
	if( sizeof( $msg ) ){
670
671
		print '<br /><strong>Upgrade '.sizeof( $msg ).' /pages/ access files</strong>'." $OK<br />";
672
	} else {
673
		print '<br /><strong>Upgrade /pages/ access files</strong>'." $FAIL!<br />";
674
		print implode ('<br />',$msg);
675
	}
676
*/
677
/**********************************************************
678 1593 Luisehahne
 * upgrade posts folder index protect files
679
 */
680
	$sPostsPath = WB_PATH.PAGES_DIRECTORY.'/posts';
681
	echo '<h4>Upgrade /posts/ index.php protect files</h4><br />';
682
	$array = rebuildFolderProtectFile($sPostsPath);
683
	if( sizeof( $array ) ){
684
		print '<br /><strong>Upgrade '.sizeof( $array ).' /posts/ protect files</strong>'." $OK<br />";
685
	} else {
686
		print '<br /><strong>Upgrade /posts/ protect files</strong>'." $FAIL!<br />";
687
		print implode ('<br />',$array);
688
	}
689 1677 Luisehahne
690 1484 Luisehahne
/* *****************************************************************************
691
 * - check for deprecated / never needed files
692
 */
693 1588 darkviper
	if(sizeof($filesRemove)) {
694 1671 Luisehahne
		echo '<h3>Step '.(++$stepID).': Remove deprecated and old files</h3>';
695 1588 darkviper
	}
696 1484 Luisehahne
	$searches = array(
697
		'[ADMIN]',
698
		'[MEDIA]',
699 1525 Luisehahne
		'[PAGES]',
700 1533 Luisehahne
		'[FRAMEWORK]',
701
		'[MODULES]',
702 1525 Luisehahne
		'[TEMPLATE]'
703 1484 Luisehahne
	);
704
	$replacements = array(
705 1525 Luisehahne
		substr(ADMIN_PATH, strlen(WB_PATH)+1),
706 1484 Luisehahne
		MEDIA_DIRECTORY,
707 1525 Luisehahne
		PAGES_DIRECTORY,
708 1533 Luisehahne
		'/framework',
709
		'/modules',
710
		'/templates'
711 1484 Luisehahne
	);
712
713 1532 Luisehahne
	foreach( $filesRemove as $filesId )
714 1484 Luisehahne
	{
715 1532 Luisehahne
		$msg = '';
716
		foreach( $filesId as $file )
717
		{
718
			$file = str_replace($searches, $replacements, $file);
719
			$file = WB_PATH.'/'.$file;
720 1588 darkviper
			if( file_exists($file) ) {
721
				// try to unlink file
722
				if(!is_writable( $file ) || !unlink($file)) {
723
					// save in err-list, if failed
724 1532 Luisehahne
					$msg .= $file.'<br />';
725
				}
726 1484 Luisehahne
			}
727
		}
728 1532 Luisehahne
729
		if($msg != '')
730
		{
731
			$msg = '<br /><br />Following files are deprecated, outdated or a security risk and
732
				    can not be removed automatically.<br /><br />Please delete them
733
					using FTP and restart upgrade-script!<br /><br />'.$msg.'<br />';
734
	        status_msg($msg, 'error warning', 'div');
735
			echo '<p style="font-size:120%;"><strong>WARNING: The upgrade script failed ...</strong></p>';
736
737
			echo '<form action="'.$_SERVER['SCRIPT_NAME'].'">';
738
			echo '&nbsp;<input name="send" type="submit" value="Restart upgrade script" />';
739
			echo '</form>';
740
			echo '<br /><br /></div></body></html>';
741
			exit;
742
		}
743 1484 Luisehahne
	}
744
745 1532 Luisehahne
746 1457 Luisehahne
/**********************************************************
747 1525 Luisehahne
 * - check for deprecated / never needed files
748
 */
749 1588 darkviper
	if(sizeof($dirRemove)) {
750 1671 Luisehahne
		echo '<h3>Step  '.(++$stepID).': Remove deprecated and old folders</h3>';
751 1588 darkviper
		$searches = array(
752
			'[ADMIN]',
753
			'[MEDIA]',
754
			'[PAGES]',
755
			'[TEMPLATE]'
756
		);
757
		$replacements = array(
758
			substr(ADMIN_PATH, strlen(WB_PATH)+1),
759
			MEDIA_DIRECTORY,
760
			PAGES_DIRECTORY,
761
			'/templates',
762
		);
763
		$msg = '';
764
		foreach( $dirRemove as $dir ) {
765
			$dir = str_replace($searches, $replacements, $dir);
766
			$dir = WB_PATH.'/'.$dir;
767
			if( is_dir( $dir )) {
768
			// try to delete dir
769 1641 Luisehahne
				if(!is_writable( $dir ) || !rm_full_dir($dir)) {
770 1588 darkviper
				// save in err-list, if failed
771 1641 Luisehahne
					$msg .= str_replace(WB_PATH,'',$dir).'<br />';
772 1588 darkviper
				}
773 1525 Luisehahne
			}
774
		}
775 1588 darkviper
		if($msg != '') {
776 1641 Luisehahne
			$msg = '<br /><br />Following directories are deprecated, outdated or a security risk and
777 1588 darkviper
					can not be removed automatically.<br /><br />Please delete them
778
					using FTP and restart upgrade-script!<br /><br />'.$msg.'<br />';
779
			status_msg($msg, 'error warning', 'div');
780
			echo '<p style="font-size:120%;"><strong>WARNING: The upgrade script failed ...</strong></p>';
781
			echo '<form action="'.$_SERVER['SCRIPT_NAME'].'">';
782
			echo '&nbsp;<input name="send" type="submit" value="Restart upgrade script" />';
783
			echo '</form>';
784
			echo '<br /><br /></div></body></html>';
785
			exit;
786
		}
787 1525 Luisehahne
	}
788 1532 Luisehahne
789 1588 darkviper
/**********************************************************
790
 * upgrade modules if newer version is available
791
 */
792
	$aModuleList = array('news');
793
	foreach($aModuleList as $sModul) {
794
		if(file_exists(WB_PATH.'/modules/'.$sModul.'/upgrade.php')) {
795
			$currModulVersion = get_modul_version ($sModul, false);
796
			$newModulVersion =  get_modul_version ($sModul, true);
797
			if((version_compare($currModulVersion, $newModulVersion) <= 0)) {
798 1671 Luisehahne
				echo '<h3>Step '.(++$stepID).' : Upgrade module \''.$sModul.'\' to version '.$newModulVersion.'</h3>';
799 1588 darkviper
				require_once(WB_PATH.'/modules/'.$sModul.'/upgrade.php');
800
			}
801
		}
802 1525 Luisehahne
	}
803
/**********************************************************
804 1457 Luisehahne
 *  - Reload all addons
805
 */
806
807 1671 Luisehahne
	echo '<h3>Step '.(++$stepID).' : Reload all addons database entry (no upgrade)</h3>';
808 1588 darkviper
	////delete modules
809
	//$database->query("DELETE FROM ".TABLE_PREFIX."addons WHERE type = 'module'");
810
	// Load all modules
811
	if( ($handle = opendir(WB_PATH.'/modules/')) ) {
812
		while(false !== ($file = readdir($handle))) {
813
			if($file != '' AND substr($file, 0, 1) != '.' AND $file != 'admin.php' AND $file != 'index.php') {
814
				load_module(WB_PATH.'/modules/'.$file );
815
			   // 	upgrade_module($file, true);
816
			}
817 1457 Luisehahne
		}
818 1588 darkviper
		closedir($handle);
819 1457 Luisehahne
	}
820 1588 darkviper
	echo '<br />Modules reloaded<br />';
821 1457 Luisehahne
822 1588 darkviper
	////delete templates
823
	//$database->query("DELETE FROM ".TABLE_PREFIX."addons WHERE type = 'template'");
824
	// Load all templates
825
	if( ($handle = opendir(WB_PATH.'/templates/')) ) {
826
		while(false !== ($file = readdir($handle))) {
827
			if($file != '' AND substr($file, 0, 1) != '.' AND $file != 'index.php') {
828
				load_template(WB_PATH.'/templates/'.$file);
829
			}
830 1457 Luisehahne
		}
831 1588 darkviper
		closedir($handle);
832 1457 Luisehahne
	}
833 1588 darkviper
	echo '<br />Templates reloaded<br />';
834 1457 Luisehahne
835 1588 darkviper
	////delete languages
836
	//$database->query("DELETE FROM ".TABLE_PREFIX."addons WHERE type = 'language'");
837
	// Load all languages
838
	if( ($handle = opendir(WB_PATH.'/languages/')) ) {
839
		while(false !== ($file = readdir($handle))) {
840
			if($file != '' AND substr($file, 0, 1) != '.' AND $file != 'index.php') {
841
				load_language(WB_PATH.'/languages/'.$file);
842
			}
843 1457 Luisehahne
		}
844 1588 darkviper
		closedir($handle);
845 1457 Luisehahne
	}
846 1588 darkviper
	echo '<br />Languages reloaded<br />';
847 1457 Luisehahne
848
/**********************************************************
849 1671 Luisehahne
 *  - install new droplets
850
	$drops = (!in_array ( "mod_droplets", $all_tables)) ? "<br />Install droplets<br />" : "<br />Upgrade droplets<br />";
851
	echo $drops;
852
	$file_name = (!in_array ( "mod_droplets", $all_tables) ? "install.php" : "upgrade.php");
853
	require_once (WB_PATH."/modules/droplets/".$file_name);
854
********************************************************** */
855
856
/**********************************************************
857 1457 Luisehahne
 *  - End of upgrade script
858
 */
859 1588 darkviper
	if(!defined('DEFAULT_THEME')) { define('DEFAULT_THEME', $DEFAULT_THEME); }
860
	if(!defined('THEME_PATH')) { define('THEME_PATH', WB_PATH.'/templates/'.DEFAULT_THEME);}
861 1532 Luisehahne
/**********************************************************
862
 *  - Set Version to new Version
863
 */
864 1671 Luisehahne
echo '<br />Update database version number to '.VERSION.' '.SP.' '.' Revision ['.REVISION.'] : ';
865 1457 Luisehahne
866 1671 Luisehahne
$cfg = array(
867
	'wb_version' => VERSION,
868
	'wb_revision' => REVISION,
869
	'wb_sp' => SP
870
);
871
872
echo (db_update_key_value( 'settings', $cfg ) ? " $OK<br />" : " $FAIL!<br />");
873
874 1588 darkviper
	echo '<p style="font-size:120%;"><strong>Congratulations: The upgrade script is finished ...</strong></p>';
875
	status_msg('<strong>Warning:</strong><br />Please delete the file <strong>upgrade-script.php</strong> via FTP before proceeding.', 'warning', 'div');
876
	// show buttons to go to the backend or frontend
877
	echo '<br />';
878 1532 Luisehahne
879 1588 darkviper
	if(defined('WB_URL')) {
880
		echo '<form action="'.WB_URL.'/">';
881
		echo '&nbsp;<input type="submit" value="kick me to the Frontend" />';
882
		echo '</form>';
883
	}
884
	if(defined('ADMIN_URL')) {
885
		echo '<form action="'.ADMIN_URL.'/">';
886
		echo '&nbsp;<input type="submit" value="kick me to the Backend" />';
887
		echo '</form>';
888
	}
889 1457 Luisehahne
890 1588 darkviper
	echo '<br /><br /></div></body></html>';