Project

General

Profile

1 552 thorn
<?php
2
3 554 Ruebenwurz
// $Id$
4 552 thorn
5
/*
6
7
 Website Baker Project <http://www.websitebaker.org/>
8 915 Ruebenwurz
 Copyright (C) 2004-2009, Ryan Djurovich
9 552 thorn
10
 Website Baker is free software; you can redistribute it and/or modify
11
 it under the terms of the GNU General Public License as published by
12
 the Free Software Foundation; either version 2 of the License, or
13
 (at your option) any later version.
14
15
 Website Baker is distributed in the hope that it will be useful,
16
 but WITHOUT ANY WARRANTY; without even the implied warranty of
17
 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
18
 GNU General Public License for more details.
19
20
 You should have received a copy of the GNU General Public License
21
 along with Website Baker; if not, write to the Free Software
22
 Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
23
24
*/
25
26 749 doc
@include_once('config.php');
27
28 715 doc
// this function checks the basic configurations of an existing WB intallation
29
function status_msg($message, $class='check', $element='span') {
30
	// returns a status message
31
	echo '<'.$element .' class="' .$class .'">' .$message .'</' .$element.'>';
32
}
33 552 thorn
34
35
?>
36
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
37
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
38
<head>
39 882 Ruebenwurz
<title>Upgrade script</title>
40 719 doc
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
41 692 doc
<style type="text/css">
42 715 doc
body {
43
	margin:0;
44
	padding:0;
45
	border:0;
46
	background: #EBF7FC;
47
	color:#000;
48 882 Ruebenwurz
	font-family: 'Trebuchet MS', Verdana, Arial, Helvetica, Sans-Serif;
49 715 doc
	font-size: small;
50
	height:101%;
51
}
52 692 doc
53 715 doc
#container {
54
	width:85%;
55 752 doc
	background: #A8BCCB url(<?php echo ADMIN_URL;?>/interface/background.png) repeat-x;
56 715 doc
	border:1px solid #000;
57
	color:#000;
58
	margin:2em auto;
59
	padding:0 15px;
60
	min-height: 500px;
61
	text-align:left;
62 692 doc
}
63
64
p { line-height:1.5em; }
65
66 715 doc
h1,h2,h3,h4,h5,h6 {
67
	font-family: Verdana, Arial, Helvetica, sans-serif;
68
	color: #369;
69
	margin-top: 1.0em;
70
	margin-bottom: 0.1em;
71
}
72
73
h1 { font-size:150%; }
74
h2 { font-size: 130%; border-bottom: 1px #CCC solid; }
75
h3 { font-size: 120%; }
76
77
.ok, .error { font-weight:bold; }
78
.ok { color:green; }
79
.error { color:red; }
80
.check { color:#555; }
81
82
.warning {
83
	width: 98%;
84
	background:#FFDBDB;
85
	padding:0.2em;
86
	margin-top:0.5em;
87
	border: 1px solid black;
88
}
89 692 doc
</style>
90 552 thorn
</head>
91
<body>
92 715 doc
<div id="container">
93 749 doc
<img src="<?php echo ADMIN_URL;?>/interface/logo.png" alt="Website Baker Logo" />
94 715 doc
95
<h1>Website Baker Upgrade</h1>
96
97 692 doc
<?php
98 715 doc
99 719 doc
require_once('config.php');
100
require_once(WB_PATH.'/framework/functions.php');
101 552 thorn
102 720 doc
$OK   = '<span class="ok">OK</span>';
103
$FAIL = '<span class="error">FAILED</span>';
104 552 thorn
105 883 thorn
// function to add a var/value-pair into settings-table
106 882 Ruebenwurz
function db_add_key_value($key, $value) {
107 552 thorn
	global $database; global $OK; global $FAIL;
108 882 Ruebenwurz
	$table = TABLE_PREFIX.'settings';
109 596 thorn
	$query = $database->query("SELECT value FROM $table WHERE name = '$key' LIMIT 1");
110 552 thorn
	if($query->numRows() > 0) {
111
		echo "$key: allready there. $OK.<br />";
112
		return true;
113
	} else {
114 882 Ruebenwurz
		$database->query("INSERT INTO $table (name,value) VALUES ('$key', '$value')");
115 648 thorn
		echo (mysql_error()?mysql_error().'<br />':'');
116 596 thorn
		$query = $database->query("SELECT value FROM $table WHERE name = '$key' LIMIT 1");
117 552 thorn
		if($query->numRows() > 0) {
118
			echo "$key: $OK.<br />";
119
			return true;
120
		} else {
121
			echo "$key: $FAIL!<br />";
122
			return false;
123
		}
124
	}
125
}
126
127 883 thorn
// function to add a new field into a table
128
function db_add_field($field, $table, $desc) {
129
	global $database; global $OK; global $FAIL;
130
	echo "<u>Adding field '$field' to table '$table'</u><br />";
131
	$table = TABLE_PREFIX.$table;
132
	$query = $database->query("DESCRIBE $table '$field'");
133
	if($query->numRows() == 0) { // add field
134
		$query = $database->query("ALTER TABLE $table ADD $field $desc");
135
		echo (mysql_error()?mysql_error().'<br />':'');
136
		$query = $database->query("DESCRIBE $table '$field'");
137
		echo (mysql_error()?mysql_error().'<br />':'');
138
		if($query->numRows() > 0) {
139
			echo "'$field' added. $OK.<br />";
140
		} else {
141
			echo "adding '$field' $FAIL!<br />";
142
		}
143
	} else {
144
		echo "'$field' allready there. $OK.<br />";
145
	}
146
}
147
148
149
/**********************************************************
150
 *  - Adding field sec_anchor to settings table
151
 */
152
echo "<br />Adding key sec_anchor to settings table<br />";
153 552 thorn
$cfg = array(
154 882 Ruebenwurz
	'sec_anchor' => 'wb_'
155 552 thorn
);
156
foreach($cfg as $key=>$value) {
157 882 Ruebenwurz
	db_add_key_value($key, $value);
158 552 thorn
}
159
160 929 doc
/**********************************************************
161
 *  - Adding redirect timer to settings table
162
 */
163
echo "<br />Adding redirect timer to settings table<br />";
164
$cfg = array(
165
	'redirect_timer' => '1500'
166
);
167
foreach($cfg as $key=>$value) {
168
	db_add_key_value($key, $value);
169
}
170 883 thorn
171 552 thorn
/**********************************************************
172 883 thorn
 *  - Add field "redirect_type" to table "mod_menu_link"
173
 */
174
echo "<br />Adding field redirect_type to mod_menu_link table<br />";
175
db_add_field('redirect_type', 'mod_menu_link', "INT NOT NULL DEFAULT '302' AFTER `target_page_id`");
176
177
178
/**********************************************************
179 714 Ruebenwurz
 *  - End of upgrade script
180
 */
181 722 doc
echo '<p style="font-size:120%;"><strong>Congratulations: The upgrade script is finished ...</strong></p>';
182 882 Ruebenwurz
status_msg('<strong>Warning:</strong><br />Please delete the file <strong>upgrade-script.php</strong> via FTP before proceeding.', 'warning', 'div');
183 722 doc
// show buttons to go to the backend or frontend
184
echo '<br />';
185
if(defined('WB_URL')) {
186
	echo '<form action="'.WB_URL.'" target="_self">';
187 724 doc
	echo '<input type="submit" value="kick me to the Frontend" style="float:left;" />';
188 722 doc
	echo '</form>';
189 715 doc
}
190 722 doc
if(defined('ADMIN_URL')) {
191
	echo '<form action="'.ADMIN_URL.'" target="_self">';
192 724 doc
	echo '&nbsp;<input type="submit" value="kick me to the Backend" />';
193 722 doc
	echo '</form>';
194
}
195
echo '<p>&nbsp;</p>';
196 882 Ruebenwurz
197 552 thorn
?>
198 882 Ruebenwurz
199 715 doc
</div>
200 552 thorn
</body>
201 714 Ruebenwurz
</html>