Project

General

Profile

« Previous | Next » 

Revision 552

Added by thorn almost 17 years ago

added new module-based search-function and publish-by-date code

View differences:

save.php
1
<?php
2

  
3
// $Id$
4

  
5
/*
6

  
7
 Website Baker Project <http://www.websitebaker.org/>
8
 Copyright (C) 2004-2008, Ryan Djurovich
9

  
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
// Start a session
27
if(!defined('SESSION_STARTED')) {
28
	session_name('wb_session_id');
29
	session_start();
30
	define('SESSION_STARTED', true);
31
}
32

  
33
// Function to set error
34
function set_error($message) {
35
	global $_POST;
36
	if(isset($message) AND $message != '') {
37
		// Copy values entered into session so user doesn't have to re-enter everything
38
		if(isset($_POST['website_title'])) {
39
			$_SESSION['wb_url'] = $_POST['wb_url'];
40
			$_SESSION['wb_path'] = $_POST['wb_path'];
41
			$_SESSION['default_timezone'] = $_POST['default_timezone'];
42
			if(!isset($_POST['operating_system'])) {
43
				$_SESSION['operating_system'] = 'linux';
44
			} else {
45
				$_SESSION['operating_system'] = $_POST['operating_system'];
46
			}
47
			if(!isset($_POST['world_writeable'])) {
48
				$_SESSION['world_writeable'] = false;
49
			} else {
50
				$_SESSION['world_writeable'] = true;
51
			}
52
			$_SESSION['database_host'] = $_POST['database_host'];
53
			$_SESSION['database_username'] = $_POST['database_username'];
54
			$_SESSION['database_password'] = $_POST['database_password'];
55
			$_SESSION['database_name'] = $_POST['database_name'];
56
			$_SESSION['table_prefix'] = $_POST['table_prefix'];
57
			if(!isset($_POST['install_tables'])) {
58
				$_SESSION['install_tables'] = false;
59
			} else {
60
				$_SESSION['install_tables'] = true;
61
			}
62
			$_SESSION['website_title'] = $_POST['website_title'];
63
			$_SESSION['admin_username'] = $_POST['admin_username'];
64
			$_SESSION['admin_email'] = $_POST['admin_email'];
65
			$_SESSION['admin_password'] = $_POST['admin_password'];
66
		}
67
		// Set the message
68
		$_SESSION['message'] = $message;
69
		// Specify that session support is enabled
70
		$_SESSION['session_support'] = '<font class="good">Enabled</font>';
71
		// Redirect to first page again and exit
72
		header('Location: index.php?sessions_checked=true');
73
		exit();
74
	}
75
}
76

  
77
// Dummy class to allow modules' install scripts to call $admin->print_error
78
class admin_dummy
79
{
80
	var $error='';
81
	function print_error($message)
82
	{
83
		$this->error=$message;
84
	}
85
}
86

  
87
// Function to workout what the default permissions are for files created by the webserver
88
function default_file_mode($temp_dir) {
89
	$v = explode(".",PHP_VERSION);
90
	$v = $v[0].$v[1];
91
	if($v > 41 AND is_writable($temp_dir)) {
92
		$filename = $temp_dir.'/test_permissions.txt';
93
		$handle = fopen($filename, 'w');
94
		fwrite($handle, 'This file is to get the default file permissions');
95
		fclose($handle);
96
		$default_file_mode = '0'.substr(sprintf('%o', fileperms($filename)), -3);
97
		unlink($filename);
98
	} else {
99
		$default_file_mode = '0777';
100
	}
101
	return $default_file_mode;
102
}
103

  
104
// Function to workout what the default permissions are for directories created by the webserver
105
function default_dir_mode($temp_dir) {
106
	$v = explode(".",PHP_VERSION);
107
	$v = $v[0].$v[1];
108
	if($v > 41 AND is_writable($temp_dir)) {
109
		$dirname = $temp_dir.'/test_permissions/';
110
		mkdir($dirname);
111
		$default_dir_mode = '0'.substr(sprintf('%o', fileperms($dirname)), -3);
112
		rmdir($dirname);
113
	} else {
114
		$default_dir_mode = '0777';
115
	}
116
	return $default_dir_mode;
117
}
118

  
119
function add_slashes($input) {
120
		if ( get_magic_quotes_gpc() || ( !is_string($input) ) ) {
121
			return $input;
122
		}
123
		$output = addslashes($input);
124
		return $output;
125
	}
126

  
127
// Begin check to see if form was even submitted
128
// Set error if no post vars found
129
if(!isset($_POST['website_title'])) {
130
	set_error('Please fill-in the form below');
131
}
132
// End check to see if form was even submitted
133

  
134
// Begin path and timezone details code
135

  
136
// Check if user has entered the installation url
137
if(!isset($_POST['wb_url']) OR $_POST['wb_url'] == '') {
138
	set_error('Please enter an absolute URL');
139
} else {
140
	$wb_url = $_POST['wb_url'];
141
}
142
// Remove any slashes at the end of the URL
143
if(substr($wb_url, strlen($wb_url)-1, 1) == "/") {
144
	$wb_url = substr($wb_url, 0, strlen($wb_url)-1);
145
}
146
if(substr($wb_url, strlen($wb_url)-1, 1) == "\\") {
147
	$wb_url = substr($wb_url, 0, strlen($wb_url)-1);
148
}
149
if(substr($wb_url, strlen($wb_url)-1, 1) == "/") {
150
	$wb_url = substr($wb_url, 0, strlen($wb_url)-1);
151
}
152
if(substr($wb_url, strlen($wb_url)-1, 1) == "\\") {
153
	$wb_url = substr($wb_url, 0, strlen($wb_url)-1);
154
}
155
// Get the default time zone
156
if(!isset($_POST['default_timezone']) OR !is_numeric($_POST['default_timezone'])) {
157
	set_error('Please select a valid default timezone');
158
} else {
159
	$default_timezone = $_POST['default_timezone']*60*60;
160
}
161
// End path and timezone details code
162

  
163
// Begin operating system specific code
164
// Get operating system
165
if(!isset($_POST['operating_system']) OR $_POST['operating_system'] != 'linux' AND $_POST['operating_system'] != 'windows') {
166
	set_error('Please select a valid operating system');
167
} else {
168
	$operating_system = $_POST['operating_system'];
169
}
170
// Work-out file permissions
171
if($operating_system == 'windows') {
172
	$file_mode = '0777';
173
	$dir_mode = '0777';
174
} elseif(isset($_POST['world_writeable']) AND $_POST['world_writeable'] == 'true') {
175
	$file_mode = '0777';
176
	$dir_mode = '0777';
177
} else {
178
	$file_mode = default_file_mode('../temp');
179
	$dir_mode = default_dir_mode('../temp');
180
}
181
// End operating system specific code
182

  
183
// Begin database details code
184
// Check if user has entered a database host
185
if(!isset($_POST['database_host']) OR $_POST['database_host'] == '') {
186
	set_error('Please enter a database host name');
187
} else {
188
	$database_host = $_POST['database_host'];
189
}
190
// Check if user has entered a database username
191
if(!isset($_POST['database_username']) OR $_POST['database_username'] == '') {
192
	set_error('Please enter a database username');
193
} else {
194
	$database_username = $_POST['database_username'];
195
}
196
// Check if user has entered a database password
197
if(!isset($_POST['database_password'])) {
198
	set_error('Please enter a database password');
199
} else {
200
	$database_password = $_POST['database_password'];
201
}
202
// Check if user has entered a database name
203
if(!isset($_POST['database_name']) OR $_POST['database_name'] == '') {
204
	set_error('Please enter a database name');
205
} else {
206
	$database_name = $_POST['database_name'];
207
}
208
// Get table prefix
209
$table_prefix = $_POST['table_prefix'];
210
// Find out if the user wants to install tables and data
211
if(isset($_POST['install_tables']) AND $_POST['install_tables'] == 'true') {
212
	$install_tables = true;
213
} else {
214
	$install_tables = false;
215
}
216
// End database details code
217

  
218
// Begin website title code
219
// Get website title
220
if(!isset($_POST['website_title']) OR $_POST['website_title'] == '') {
221
	set_error('Please enter a website title');
222
} else {
223
	$website_title = add_slashes($_POST['website_title']);
224
}
225
// End website title code
226

  
227
// Begin admin user details code
228
// Get admin username
229
if(!isset($_POST['admin_username']) OR $_POST['admin_username'] == '') {
230
	set_error('Please enter a username for the Administrator account');
231
} else {
232
	$admin_username = $_POST['admin_username'];
233
}
234
// Get admin email and validate it
235
if(!isset($_POST['admin_email']) OR $_POST['admin_email'] == '') {
236
	set_error('Please enter an email for the Administrator account');
237
} else {
238
	if(eregi("^([0-9a-zA-Z]+[-._+&])*[0-9a-zA-Z]+@([-0-9a-zA-Z]+[.])+[a-zA-Z]{2,6}$", $_POST['admin_email'])) {
239
		$admin_email = $_POST['admin_email'];
240
	} else {
241
		set_error('Please enter a valid email address for the Administrator account');
242
	}
243
}
244
// Get the two admin passwords entered, and check that they match
245
if(!isset($_POST['admin_password']) OR $_POST['admin_password'] == '') {
246
	set_error('Please enter a password for the Administrator account');
247
} else {
248
	$admin_password = $_POST['admin_password'];
249
}
250
if(!isset($_POST['admin_repassword']) OR $_POST['admin_repassword'] == '') {
251
	set_error('Please make sure you re-enter the password for the Administrator account');
252
} else {
253
	$admin_repassword = $_POST['admin_repassword'];
254
}
255
if($admin_password != $admin_repassword) {
256
	set_error('Sorry, the two Administrator account passwords you entered do not match');
257
}
258
// End admin user details code
259

  
260
// Try and write settings to config file
261
$config_content = "" .
262
"<?php\n".
263
"\n".
264
"define('DB_TYPE', 'mysql');\n".
265
"define('DB_HOST', '$database_host');\n".
266
"define('DB_USERNAME', '$database_username');\n".
267
"define('DB_PASSWORD', '$database_password');\n".
268
"define('DB_NAME', '$database_name');\n".
269
"define('TABLE_PREFIX', '$table_prefix');\n".
270
"\n".
271
"define('WB_PATH', dirname(__FILE__));\n".
272
"define('WB_URL', '$wb_url');\n".
273
"define('ADMIN_PATH', WB_PATH.'/admin');\n".
274
"define('ADMIN_URL', '$wb_url/admin');\n".
275
"\n".
276
"require_once(WB_PATH.'/framework/initialize.php');\n".
277
"\n".
278
"?>";
279

  
280
$config_filename = '../config.php';
281

  
282
// Check if the file exists and is writable first.
283
if(file_exists($config_filename) AND is_writable($config_filename)) {
284
	if(!$handle = fopen($config_filename, 'w')) {
285
		set_error("Cannot open the configuration file ($config_filename)");
286
	} else {
287
		if (fwrite($handle, $config_content) === FALSE) {
288
			set_error("Cannot write to the configuration file ($config_filename)");
289
		}
290
		// Close file
291
		fclose($handle);
292
	}
293
} else {
294
	set_error("The configuration file $config_filename is not writable. Change its permissions so it is, then re-run step 4.");
295
}
296

  
297
// Define configuration vars
298
define('DB_TYPE', 'mysql');
299
define('DB_HOST', $database_host);
300
define('DB_USERNAME', $database_username);
301
define('DB_PASSWORD', $database_password);
302
define('DB_NAME', $database_name);
303
define('TABLE_PREFIX', $table_prefix);
304
define('WB_PATH', str_replace(array('/install','\install'), '',dirname(__FILE__)));
305
define('WB_URL', $wb_url);
306
define('ADMIN_PATH', WB_PATH.'/admin');
307
define('ADMIN_URL', $wb_url.'/admin');
308

  
309
// Check if the user has entered a correct path
310
if(!file_exists(WB_PATH.'/framework/class.admin.php')) {
311
	set_error('It appears the Absolute path that you entered is incorrect');
312
}
313

  
314
// Try connecting to database	
315
if(!mysql_connect(DB_HOST, DB_USERNAME, DB_PASSWORD)) {
316
	set_error('Database host name, username and/or password incorrect. MySQL Error:<br />'.mysql_error());
317
}
318

  
319
// Try to create the database
320
mysql_query('CREATE DATABASE '.$database_name);
321

  
322
// Close the mysql connection
323
mysql_close();
324

  
325
// Include WB functions file
326
require_once(WB_PATH.'/framework/functions.php');
327

  
328
// Re-connect to the database, this time using in-build database class
329
require_once(WB_PATH.'/framework/class.login.php');
330
$database=new database();
331

  
332
// Check if we should install tables
333
if($install_tables == true) {
334
	
335
	// Remove tables if they exist
336

  
337
	// Pages table
338
	$pages = "DROP TABLE IF EXISTS `".TABLE_PREFIX."pages`";
339
	$database->query($pages);
340
	// Sections table
341
	$sections = "DROP TABLE IF EXISTS `".TABLE_PREFIX."sections`";
342
	$database->query($sections);
343
	// Settings table
344
	$settings = "DROP TABLE IF EXISTS `".TABLE_PREFIX."settings`";
345
	$database->query($settings);
346
	// Users table
347
	$users = "DROP TABLE IF EXISTS `".TABLE_PREFIX."users`";
348
	$database->query($users);
349
	// Groups table
350
	$groups = "DROP TABLE IF EXISTS `".TABLE_PREFIX."groups`";
351
	$database->query($groups);
352
	// Search table
353
	$search = "DROP TABLE IF EXISTS `".TABLE_PREFIX."search`";
354
	$database->query($search);
355
	// Addons table
356
	$addons = "DROP TABLE IF EXISTS `".TABLE_PREFIX."addons`";
357
	$database->query($addons);
358
				
359
	// Try installing tables
360
	
361
	// Pages table
362
	$pages = 'CREATE TABLE `'.TABLE_PREFIX.'pages` ( `page_id` INT NOT NULL auto_increment,'
363
	       . ' `parent` INT NOT NULL DEFAULT \'0\','
364
	       . ' `root_parent` INT NOT NULL DEFAULT \'0\','
365
	       . ' `level` INT NOT NULL DEFAULT \'0\','
366
	       . ' `link` TEXT NOT NULL,'
367
	       . ' `target` VARCHAR( 7 ) NOT NULL DEFAULT \'\' ,'
368
	       . ' `page_title` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
369
	       . ' `menu_title` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
370
	       . ' `description` TEXT NOT NULL ,'
371
	       . ' `keywords` TEXT NOT NULL ,'
372
	       . ' `page_trail` TEXT NOT NULL  ,'
373
	       . ' `template` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
374
	       . ' `visibility` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
375
	       . ' `position` INT NOT NULL DEFAULT \'0\','
376
	       . ' `menu` INT NOT NULL DEFAULT \'0\','
377
	       . ' `language` VARCHAR( 5 ) NOT NULL DEFAULT \'\' ,'
378
	       . ' `searching` INT NOT NULL DEFAULT \'0\','
379
	       . ' `admin_groups` TEXT NOT NULL ,'
380
	       . ' `admin_users` TEXT NOT NULL ,'
381
	       . ' `viewing_groups` TEXT NOT NULL ,'
382
	       . ' `viewing_users` TEXT NOT NULL ,'
383
	       . ' `modified_when` INT NOT NULL DEFAULT \'0\','
384
	       . ' `modified_by` INT NOT NULL  DEFAULT \'0\','
385
	       . ' PRIMARY KEY ( `page_id` ) '
386
	       . ' )';
387
	$database->query($pages);
388
	
389
	// Sections table
390
	$pages = 'CREATE TABLE `'.TABLE_PREFIX.'sections` ( `section_id` INT NOT NULL auto_increment,'
391
	       . ' `page_id` INT NOT NULL DEFAULT \'0\','
392
	       . ' `position` INT NOT NULL DEFAULT \'0\','
393
	       . ' `module` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
394
	       . ' `block` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
395
	       . ' PRIMARY KEY ( `section_id` ) '
396
	       . ' )';
397
	$database->query($pages);
398
	
399
	require(WB_PATH.'/admin/interface/version.php');
400
	
401
	// Settings table
402
	$settings='CREATE TABLE `'.TABLE_PREFIX.'settings` ( `setting_id` INT NOT NULL auto_increment,'
403
		. ' `name` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
404
		. ' `value` TEXT NOT NULL ,'
405
		. ' PRIMARY KEY ( `setting_id` ) '
406
		. ' )';
407
	$database->query($settings);
408

  
409
	$settings_rows=	"INSERT INTO `".TABLE_PREFIX."settings` "
410
	." (name, value) VALUES "
411
	." ('wb_version', '".VERSION."'),"
412
	." ('website_title', '$website_title'),"
413
	." ('website_description', ''),"
414
	." ('website_keywords', ''),"
415
	." ('website_header', ''),"
416
	." ('website_footer', ''),"
417
	." ('wysiwyg_style', 'font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px;'),"
418
	." ('rename_files_on_upload', 'php,asp,phpx,aspx'),"
419
	." ('er_level', ''),"
420
	." ('default_language', 'EN'),"
421
	." ('app_name', 'wb'),"
422
	." ('default_timezone', '$default_timezone'),"
423
	." ('default_date_format', 'M d Y'),"
424
	." ('default_time_format', 'g:i A'),"
425
	." ('home_folders', 'true'),"
426
	." ('default_template', 'round'),"
427
	." ('default_charset', 'utf-8'),"
428
	." ('multiple_menus', 'false'),"
429
	." ('page_level_limit', '4'),"
430
	." ('intro_page', 'false'),"
431
	." ('page_trash', 'disabled'),"
432
	." ('homepage_redirection', 'false'),"
433
	." ('page_languages', 'false'),"
434
	." ('wysiwyg_editor', 'fckeditor'),"
435
	." ('manage_sections', 'true'),"
436
	." ('section_blocks', 'false'),"
437
	." ('smart_login', 'false'),"
438
	." ('captcha_verification', 'true'),"
439
	." ('frontend_login', 'false'),"
440
	." ('frontend_signup', 'false'),"
441
	." ('server_email', '$admin_email'),"
442
	." ('search', 'public'),"
443
	." ('page_extension', '.php'),"
444
	." ('page_spacer', '-'),"
445
	." ('pages_directory', '/pages'),"
446
	." ('media_directory', '/media'),"
447
	." ('operating_system', '$operating_system'),"
448
	." ('string_file_mode', '$file_mode'),"
449
	." ('string_dir_mode', '$dir_mode'),"
450
	." ('wbmailer_routine', 'phpmail'),"
451
	." ('wbmailer_smtp_host', ''),"
452
	." ('wbmailer_smtp_auth', ''),"
453
	." ('wbmailer_smtp_username', ''),"
454
	." ('wbmailer_smtp_password', '')";
455
	$database->query($settings_rows);
456
	
457
	// Users table
458
	$users = 'CREATE TABLE `'.TABLE_PREFIX.'users` ( `user_id` INT NOT NULL auto_increment,'
459
	       . ' `group_id` INT NOT NULL DEFAULT \'0\','
460
	       . ' `groups_id` VARCHAR( 255 ) NOT NULL DEFAULT \'0\','
461
	       . ' `active` INT NOT NULL DEFAULT \'0\','
462
	       . ' `username` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
463
	       . ' `password` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
464
	       . ' `remember_key` VARCHAR( 255 ) NOT NULL DEFAULT \'\','
465
	       . ' `last_reset` INT NOT NULL DEFAULT \'0\','
466
	       . ' `display_name` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
467
	       . ' `email` TEXT NOT NULL ,'
468
	       . ' `timezone` INT NOT NULL DEFAULT \'0\','
469
	       . ' `date_format` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
470
	       . ' `time_format` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
471
	       . ' `language` VARCHAR( 5 ) NOT NULL DEFAULT \'\' ,'
472
	       . ' `home_folder` TEXT NOT NULL ,'
473
	       . ' `login_when` INT NOT NULL  DEFAULT \'0\','
474
	       . ' `login_ip` VARCHAR( 15 ) NOT NULL DEFAULT \'\' ,'
475
	       . ' PRIMARY KEY ( `user_id` ) '
476
	       . ' )';
477
	$database->query($users);
478
	
479
	// Groups table
480
	$groups = 'CREATE TABLE `'.TABLE_PREFIX.'groups` ( `group_id` INT NOT NULL auto_increment,'
481
	        . ' `name` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
482
	        . ' `system_permissions` TEXT NOT NULL ,'
483
	        . ' `module_permissions` TEXT NOT NULL ,'
484
	        . ' `template_permissions` TEXT NOT NULL ,'
485
	        . ' PRIMARY KEY ( `group_id` ) '
486
	        . ' )';
487
	$database->query($groups);
488
	
489
	// Search settings table
490
	$search = 'CREATE TABLE `'.TABLE_PREFIX.'search` ( `search_id` INT NOT NULL auto_increment,'
491
	        . ' `name` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
492
	        . ' `value` TEXT NOT NULL ,'
493
	        . ' `extra` TEXT NOT NULL ,'
494
	        . ' PRIMARY KEY ( `search_id` ) '
495
	        . ' )';
496
	$database->query($search);
497
	
498
	// Addons table
499
	$addons = 'CREATE TABLE `'.TABLE_PREFIX.'addons` ( '
500
			.'`addon_id` INT NOT NULL auto_increment ,'
501
			.'`type` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
502
			.'`directory` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
503
			.'`name` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
504
			.'`description` TEXT NOT NULL ,'
505
			.'`function` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
506
			.'`version` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
507
			.'`platform` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
508
			.'`author` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
509
			.'`license` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
510
			.' PRIMARY KEY ( `addon_id` ) '
511
			.' )';
512
	$database->query($addons);
513

  
514
	// Insert default data
515
	
516
	// Admin group
517
	$full_system_permissions = 'pages,pages_view,pages_add,pages_add_l0,pages_settings,pages_modify,pages_intro,pages_delete,media,media_view,media_upload,media_rename,media_delete,media_create,addons,modules,modules_view,modules_install,modules_uninstall,templates,templates_view,templates_install,templates_uninstall,languages,languages_view,languages_install,languages_uninstall,settings,settings_basic,settings_advanced,access,users,users_view,users_add,users_modify,users_delete,groups,groups_view,groups_add,groups_modify,groups_delete,admintools';
518
	$insert_admin_group = "INSERT INTO `".TABLE_PREFIX."groups` VALUES ('1', 'Administrators', '$full_system_permissions', '', '')";
519
	$database->query($insert_admin_group);
520
	// Admin user
521
	$insert_admin_user = "INSERT INTO `".TABLE_PREFIX."users` (user_id,group_id,groups_id,active,username,password,email,display_name) VALUES ('1','1','1','1','$admin_username','".md5($admin_password)."','$admin_email','Administrator')";
522
	$database->query($insert_admin_user);
523
	
524
	// Search header
525
	$search_header = addslashes('
526
<h1>[TEXT_SEARCH]</h1>
527

  
528
<form name="search" action="[WB_URL]/search/index.php" method="get">
529
<table cellpadding="3" cellspacing="0" border="0" width="500">
530
<tr>
531
<td>
532
<input type="text" name="string" value="[SEARCH_STRING]" style="width: 100%;" />
533
</td>
534
<td width="150">
535
<input type="submit" value="[TEXT_SEARCH]" style="width: 100%;" />
536
</td>
537
</tr>
538
<tr>
539
<td colspan="2">
540
<input type="radio" name="match" id="match_all" value="all"[ALL_CHECKED] />
541
<label for="match_all">[TEXT_ALL_WORDS]</label>
542
<input type="radio" name="match" id="match_any" value="any"[ANY_CHECKED] />
543
<label for="match_any">[TEXT_ANY_WORDS]</label>
544
<input type="radio" name="match" id="match_exact" value="exact"[EXACT_CHECKED] />
545
<label for="match_exact">[TEXT_EXACT_MATCH]</label>
546
</td>
547
</tr>
548
</table>
549

  
550
</form>
551

  
552
<hr />
553
	');
554
	$insert_search_header = "INSERT INTO `".TABLE_PREFIX."search` VALUES ('', 'header', '$search_header', '')";
555
	$database->query($insert_search_header);
556
	// Search footer
557
	$search_footer = addslashes('');
558
	$insert_search_footer = "INSERT INTO `".TABLE_PREFIX."search` VALUES ('', 'footer', '$search_footer', '')";
559
	$database->query($insert_search_footer);
560
	// Search results header
561
	$search_results_header = addslashes(''.
562
'[TEXT_RESULTS_FOR] \'<b>[SEARCH_STRING]</b>\':
563
<table cellpadding="2" cellspacing="0" border="0" width="100%" style="padding-top: 10px;">');
564
	$insert_search_results_header = "INSERT INTO `".TABLE_PREFIX."search` VALUES ('', 'results_header', '$search_results_header', '')";
565
	$database->query($insert_search_results_header);
566
	// Search results loop
567
	$search_results_loop = addslashes(''.
568
'<tr style="background-color: #F0F0F0;">
569
<td><a href="[LINK]">[TITLE]</a></td>
570
<td align="right">[TEXT_LAST_UPDATED_BY] [DISPLAY_NAME] ([USERNAME]) [TEXT_ON] [DATE]</td>
571
</tr>
572
<tr><td colspan="2" style="text-align: justify; padding-bottom: 10px;">[DESCRIPTION]</td></tr>');
573

  
574
	$insert_search_results_loop = "INSERT INTO `".TABLE_PREFIX."search` VALUES ('', 'results_loop', '$search_results_loop', '')";
575
	$database->query($insert_search_results_loop);
576
	// Search results footer
577
	$search_results_footer = addslashes("</table>");
578
	$insert_search_results_footer = "INSERT INTO `".TABLE_PREFIX."search` VALUES ('', 'results_footer', '$search_results_footer', '')";
579
	$database->query($insert_search_results_footer);
580
	// Search no results
581
	$search_no_results = addslashes('<br />[TEXT_NO_RESULTS]');
582
	$insert_search_no_results = "INSERT INTO `".TABLE_PREFIX."search` VALUES ('', 'no_results', '$search_no_results', '')";
583
	$database->query($insert_search_no_results);
584
	// Search template
585
	$database->query("INSERT INTO `".TABLE_PREFIX."search` (name) VALUES ('template')");
586
		
587
	require_once(WB_PATH.'/framework/initialize.php');
588
	
589
	// Include the PclZip class file (thanks to 
590
	require_once(WB_PATH.'/include/pclzip/pclzip.lib.php');
591
			
592
	// Install add-ons
593
	if(file_exists(WB_PATH.'/install/modules')) {
594
		// Unpack pre-packaged modules
595
			
596
	}
597
	if(file_exists(WB_PATH.'/install/templates')) {
598
		// Unpack pre-packaged templates
599
		
600
	}
601
	if(file_exists(WB_PATH.'/install/languages')) {
602
		// Unpack pre-packaged languages
603
		
604
	}
605
	
606
	$admin=new admin_dummy();
607
	// Load addons into DB
608
	$dirs['modules'] = WB_PATH.'/modules/';
609
	$dirs['templates'] = WB_PATH.'/templates/';
610
	$dirs['languages'] = WB_PATH.'/languages/';
611
	foreach($dirs AS $type => $dir) {
612
		if($handle = opendir($dir)) {
613
			while(false !== ($file = readdir($handle))) {
614
				if($file != '' AND substr($file, 0, 1) != '.' AND $file != 'admin.php' AND $file != 'index.php') {
615
					// Get addon type
616
					if($type == 'modules') {
617
						load_module($dir.'/'.$file, true);
618
						// Pretty ugly hack to let modules run $admin->set_error
619
						// See dummy class definition admin_dummy above
620
						if ($admin->error!='') {
621
							set_error($admin->error);
622
						}
623
					} elseif($type == 'templates') {
624
						load_template($dir.'/'.$file);
625
					} elseif($type == 'languages') {
626
						load_language($dir.'/'.$file);
627
					}
628
				}
629
			}
630
		closedir($handle);
631
		}
632
	}
633
	
634
	// Check if there was a database error
635
	if($database->is_error()) {
636
		set_error($database->get_error());
637
	}
638
	
639
}
640

  
641
// Log the user in and go to Website Baker Administration
642
$thisApp = new Login(
643
							array(
644
									"MAX_ATTEMPS" => "50",
645
									"WARNING_URL" => ADMIN_URL."/login/warning.html",
646
									"USERNAME_FIELDNAME" => 'admin_username',
647
									"PASSWORD_FIELDNAME" => 'admin_password',
648
									"REMEMBER_ME_OPTION" => SMART_LOGIN,
649
									"MIN_USERNAME_LEN" => "2",
650
									"MIN_PASSWORD_LEN" => "2",
651
									"MAX_USERNAME_LEN" => "30",
652
									"MAX_PASSWORD_LEN" => "30",
653
									'LOGIN_URL' => ADMIN_URL."/login/index.php",
654
									'DEFAULT_URL' => ADMIN_URL."/start/index.php",
655
									'TEMPLATE_DIR' => ADMIN_PATH."/login",
656
									'TEMPLATE_FILE' => "template.html",
657
									'FRONTEND' => false,
658
									'FORGOTTEN_DETAILS_APP' => ADMIN_URL."/login/forgot/index.php",
659
									'USERS_TABLE' => TABLE_PREFIX."users",
660
									'GROUPS_TABLE' => TABLE_PREFIX."groups",
661
							)
662
					);
663
?>
1
<?php
2

  
3
// $Id$
4

  
5
/*
6

  
7
 Website Baker Project <http://www.websitebaker.org/>
8
 Copyright (C) 2004-2008, Ryan Djurovich
9

  
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
// Start a session
27
if(!defined('SESSION_STARTED')) {
28
	session_name('wb_session_id');
29
	session_start();
30
	define('SESSION_STARTED', true);
31
}
32

  
33
// Function to set error
34
function set_error($message) {
35
	global $_POST;
36
	if(isset($message) AND $message != '') {
37
		// Copy values entered into session so user doesn't have to re-enter everything
38
		if(isset($_POST['website_title'])) {
39
			$_SESSION['wb_url'] = $_POST['wb_url'];
40
			$_SESSION['wb_path'] = $_POST['wb_path'];
41
			$_SESSION['default_timezone'] = $_POST['default_timezone'];
42
			if(!isset($_POST['operating_system'])) {
43
				$_SESSION['operating_system'] = 'linux';
44
			} else {
45
				$_SESSION['operating_system'] = $_POST['operating_system'];
46
			}
47
			if(!isset($_POST['world_writeable'])) {
48
				$_SESSION['world_writeable'] = false;
49
			} else {
50
				$_SESSION['world_writeable'] = true;
51
			}
52
			$_SESSION['database_host'] = $_POST['database_host'];
53
			$_SESSION['database_username'] = $_POST['database_username'];
54
			$_SESSION['database_password'] = $_POST['database_password'];
55
			$_SESSION['database_name'] = $_POST['database_name'];
56
			$_SESSION['table_prefix'] = $_POST['table_prefix'];
57
			if(!isset($_POST['install_tables'])) {
58
				$_SESSION['install_tables'] = false;
59
			} else {
60
				$_SESSION['install_tables'] = true;
61
			}
62
			$_SESSION['website_title'] = $_POST['website_title'];
63
			$_SESSION['admin_username'] = $_POST['admin_username'];
64
			$_SESSION['admin_email'] = $_POST['admin_email'];
65
			$_SESSION['admin_password'] = $_POST['admin_password'];
66
		}
67
		// Set the message
68
		$_SESSION['message'] = $message;
69
		// Specify that session support is enabled
70
		$_SESSION['session_support'] = '<font class="good">Enabled</font>';
71
		// Redirect to first page again and exit
72
		header('Location: index.php?sessions_checked=true');
73
		exit();
74
	}
75
}
76

  
77
// Dummy class to allow modules' install scripts to call $admin->print_error
78
class admin_dummy
79
{
80
	var $error='';
81
	function print_error($message)
82
	{
83
		$this->error=$message;
84
	}
85
}
86

  
87
// Function to workout what the default permissions are for files created by the webserver
88
function default_file_mode($temp_dir) {
89
	$v = explode(".",PHP_VERSION);
90
	$v = $v[0].$v[1];
91
	if($v > 41 AND is_writable($temp_dir)) {
92
		$filename = $temp_dir.'/test_permissions.txt';
93
		$handle = fopen($filename, 'w');
94
		fwrite($handle, 'This file is to get the default file permissions');
95
		fclose($handle);
96
		$default_file_mode = '0'.substr(sprintf('%o', fileperms($filename)), -3);
97
		unlink($filename);
98
	} else {
99
		$default_file_mode = '0777';
100
	}
101
	return $default_file_mode;
102
}
103

  
104
// Function to workout what the default permissions are for directories created by the webserver
105
function default_dir_mode($temp_dir) {
106
	$v = explode(".",PHP_VERSION);
107
	$v = $v[0].$v[1];
108
	if($v > 41 AND is_writable($temp_dir)) {
109
		$dirname = $temp_dir.'/test_permissions/';
110
		mkdir($dirname);
111
		$default_dir_mode = '0'.substr(sprintf('%o', fileperms($dirname)), -3);
112
		rmdir($dirname);
113
	} else {
114
		$default_dir_mode = '0777';
115
	}
116
	return $default_dir_mode;
117
}
118

  
119
function add_slashes($input) {
120
		if ( get_magic_quotes_gpc() || ( !is_string($input) ) ) {
121
			return $input;
122
		}
123
		$output = addslashes($input);
124
		return $output;
125
	}
126

  
127
// Begin check to see if form was even submitted
128
// Set error if no post vars found
129
if(!isset($_POST['website_title'])) {
130
	set_error('Please fill-in the form below');
131
}
132
// End check to see if form was even submitted
133

  
134
// Begin path and timezone details code
135

  
136
// Check if user has entered the installation url
137
if(!isset($_POST['wb_url']) OR $_POST['wb_url'] == '') {
138
	set_error('Please enter an absolute URL');
139
} else {
140
	$wb_url = $_POST['wb_url'];
141
}
142
// Remove any slashes at the end of the URL
143
if(substr($wb_url, strlen($wb_url)-1, 1) == "/") {
144
	$wb_url = substr($wb_url, 0, strlen($wb_url)-1);
145
}
146
if(substr($wb_url, strlen($wb_url)-1, 1) == "\\") {
147
	$wb_url = substr($wb_url, 0, strlen($wb_url)-1);
148
}
149
if(substr($wb_url, strlen($wb_url)-1, 1) == "/") {
150
	$wb_url = substr($wb_url, 0, strlen($wb_url)-1);
151
}
152
if(substr($wb_url, strlen($wb_url)-1, 1) == "\\") {
153
	$wb_url = substr($wb_url, 0, strlen($wb_url)-1);
154
}
155
// Get the default time zone
156
if(!isset($_POST['default_timezone']) OR !is_numeric($_POST['default_timezone'])) {
157
	set_error('Please select a valid default timezone');
158
} else {
159
	$default_timezone = $_POST['default_timezone']*60*60;
160
}
161
// End path and timezone details code
162

  
163
// Begin operating system specific code
164
// Get operating system
165
if(!isset($_POST['operating_system']) OR $_POST['operating_system'] != 'linux' AND $_POST['operating_system'] != 'windows') {
166
	set_error('Please select a valid operating system');
167
} else {
168
	$operating_system = $_POST['operating_system'];
169
}
170
// Work-out file permissions
171
if($operating_system == 'windows') {
172
	$file_mode = '0777';
173
	$dir_mode = '0777';
174
} elseif(isset($_POST['world_writeable']) AND $_POST['world_writeable'] == 'true') {
175
	$file_mode = '0777';
176
	$dir_mode = '0777';
177
} else {
178
	$file_mode = default_file_mode('../temp');
179
	$dir_mode = default_dir_mode('../temp');
180
}
181
// End operating system specific code
182

  
183
// Begin database details code
184
// Check if user has entered a database host
185
if(!isset($_POST['database_host']) OR $_POST['database_host'] == '') {
186
	set_error('Please enter a database host name');
187
} else {
188
	$database_host = $_POST['database_host'];
189
}
190
// Check if user has entered a database username
191
if(!isset($_POST['database_username']) OR $_POST['database_username'] == '') {
192
	set_error('Please enter a database username');
193
} else {
194
	$database_username = $_POST['database_username'];
195
}
196
// Check if user has entered a database password
197
if(!isset($_POST['database_password'])) {
198
	set_error('Please enter a database password');
199
} else {
200
	$database_password = $_POST['database_password'];
201
}
202
// Check if user has entered a database name
203
if(!isset($_POST['database_name']) OR $_POST['database_name'] == '') {
204
	set_error('Please enter a database name');
205
} else {
206
	$database_name = $_POST['database_name'];
207
}
208
// Get table prefix
209
$table_prefix = $_POST['table_prefix'];
210
// Find out if the user wants to install tables and data
211
if(isset($_POST['install_tables']) AND $_POST['install_tables'] == 'true') {
212
	$install_tables = true;
213
} else {
214
	$install_tables = false;
215
}
216
// End database details code
217

  
218
// Begin website title code
219
// Get website title
220
if(!isset($_POST['website_title']) OR $_POST['website_title'] == '') {
221
	set_error('Please enter a website title');
222
} else {
223
	$website_title = add_slashes($_POST['website_title']);
224
}
225
// End website title code
226

  
227
// Begin admin user details code
228
// Get admin username
229
if(!isset($_POST['admin_username']) OR $_POST['admin_username'] == '') {
230
	set_error('Please enter a username for the Administrator account');
231
} else {
232
	$admin_username = $_POST['admin_username'];
233
}
234
// Get admin email and validate it
235
if(!isset($_POST['admin_email']) OR $_POST['admin_email'] == '') {
236
	set_error('Please enter an email for the Administrator account');
237
} else {
238
	if(eregi("^([0-9a-zA-Z]+[-._+&])*[0-9a-zA-Z]+@([-0-9a-zA-Z]+[.])+[a-zA-Z]{2,6}$", $_POST['admin_email'])) {
239
		$admin_email = $_POST['admin_email'];
240
	} else {
241
		set_error('Please enter a valid email address for the Administrator account');
242
	}
243
}
244
// Get the two admin passwords entered, and check that they match
245
if(!isset($_POST['admin_password']) OR $_POST['admin_password'] == '') {
246
	set_error('Please enter a password for the Administrator account');
247
} else {
248
	$admin_password = $_POST['admin_password'];
249
}
250
if(!isset($_POST['admin_repassword']) OR $_POST['admin_repassword'] == '') {
251
	set_error('Please make sure you re-enter the password for the Administrator account');
252
} else {
253
	$admin_repassword = $_POST['admin_repassword'];
254
}
255
if($admin_password != $admin_repassword) {
256
	set_error('Sorry, the two Administrator account passwords you entered do not match');
257
}
258
// End admin user details code
259

  
260
// Try and write settings to config file
261
$config_content = "" .
262
"<?php\n".
263
"\n".
264
"define('DB_TYPE', 'mysql');\n".
265
"define('DB_HOST', '$database_host');\n".
266
"define('DB_USERNAME', '$database_username');\n".
267
"define('DB_PASSWORD', '$database_password');\n".
268
"define('DB_NAME', '$database_name');\n".
269
"define('TABLE_PREFIX', '$table_prefix');\n".
270
"\n".
271
"define('WB_PATH', dirname(__FILE__));\n".
272
"define('WB_URL', '$wb_url');\n".
273
"define('ADMIN_PATH', WB_PATH.'/admin');\n".
274
"define('ADMIN_URL', '$wb_url/admin');\n".
275
"\n".
276
"require_once(WB_PATH.'/framework/initialize.php');\n".
277
"\n".
278
"?>";
279

  
280
$config_filename = '../config.php';
281

  
282
// Check if the file exists and is writable first.
283
if(file_exists($config_filename) AND is_writable($config_filename)) {
284
	if(!$handle = fopen($config_filename, 'w')) {
285
		set_error("Cannot open the configuration file ($config_filename)");
286
	} else {
287
		if (fwrite($handle, $config_content) === FALSE) {
288
			set_error("Cannot write to the configuration file ($config_filename)");
289
		}
290
		// Close file
291
		fclose($handle);
292
	}
293
} else {
294
	set_error("The configuration file $config_filename is not writable. Change its permissions so it is, then re-run step 4.");
295
}
296

  
297
// Define configuration vars
298
define('DB_TYPE', 'mysql');
299
define('DB_HOST', $database_host);
300
define('DB_USERNAME', $database_username);
301
define('DB_PASSWORD', $database_password);
302
define('DB_NAME', $database_name);
303
define('TABLE_PREFIX', $table_prefix);
304
define('WB_PATH', str_replace(array('/install','\install'), '',dirname(__FILE__)));
305
define('WB_URL', $wb_url);
306
define('ADMIN_PATH', WB_PATH.'/admin');
307
define('ADMIN_URL', $wb_url.'/admin');
308

  
309
// Check if the user has entered a correct path
310
if(!file_exists(WB_PATH.'/framework/class.admin.php')) {
311
	set_error('It appears the Absolute path that you entered is incorrect');
312
}
313

  
314
// Try connecting to database	
315
if(!mysql_connect(DB_HOST, DB_USERNAME, DB_PASSWORD)) {
316
	set_error('Database host name, username and/or password incorrect. MySQL Error:<br />'.mysql_error());
317
}
318

  
319
// Try to create the database
320
mysql_query('CREATE DATABASE '.$database_name);
321

  
322
// Close the mysql connection
323
mysql_close();
324

  
325
// Include WB functions file
326
require_once(WB_PATH.'/framework/functions.php');
327

  
328
// Re-connect to the database, this time using in-build database class
329
require_once(WB_PATH.'/framework/class.login.php');
330
$database=new database();
331

  
332
// Check if we should install tables
333
if($install_tables == true) {
334
	
335
	// Remove tables if they exist
336

  
337
	// Pages table
338
	$pages = "DROP TABLE IF EXISTS `".TABLE_PREFIX."pages`";
339
	$database->query($pages);
340
	// Sections table
341
	$sections = "DROP TABLE IF EXISTS `".TABLE_PREFIX."sections`";
342
	$database->query($sections);
343
	// Settings table
344
	$settings = "DROP TABLE IF EXISTS `".TABLE_PREFIX."settings`";
345
	$database->query($settings);
346
	// Users table
347
	$users = "DROP TABLE IF EXISTS `".TABLE_PREFIX."users`";
348
	$database->query($users);
349
	// Groups table
350
	$groups = "DROP TABLE IF EXISTS `".TABLE_PREFIX."groups`";
351
	$database->query($groups);
352
	// Search table
353
	$search = "DROP TABLE IF EXISTS `".TABLE_PREFIX."search`";
354
	$database->query($search);
355
	// Addons table
356
	$addons = "DROP TABLE IF EXISTS `".TABLE_PREFIX."addons`";
357
	$database->query($addons);
358
				
359
	// Try installing tables
360
	
361
	// Pages table
362
	$pages = 'CREATE TABLE `'.TABLE_PREFIX.'pages` ( `page_id` INT NOT NULL auto_increment,'
363
	       . ' `parent` INT NOT NULL DEFAULT \'0\','
364
	       . ' `root_parent` INT NOT NULL DEFAULT \'0\','
365
	       . ' `level` INT NOT NULL DEFAULT \'0\','
366
	       . ' `link` TEXT NOT NULL,'
367
	       . ' `target` VARCHAR( 7 ) NOT NULL DEFAULT \'\' ,'
368
	       . ' `page_title` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
369
	       . ' `menu_title` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
370
	       . ' `description` TEXT NOT NULL ,'
371
	       . ' `keywords` TEXT NOT NULL ,'
372
	       . ' `page_trail` TEXT NOT NULL  ,'
373
	       . ' `template` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
374
	       . ' `visibility` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
375
	       . ' `position` INT NOT NULL DEFAULT \'0\','
376
	       . ' `menu` INT NOT NULL DEFAULT \'0\','
377
	       . ' `language` VARCHAR( 5 ) NOT NULL DEFAULT \'\' ,'
378
	       . ' `searching` INT NOT NULL DEFAULT \'0\','
379
	       . ' `admin_groups` TEXT NOT NULL ,'
380
	       . ' `admin_users` TEXT NOT NULL ,'
381
	       . ' `viewing_groups` TEXT NOT NULL ,'
382
	       . ' `viewing_users` TEXT NOT NULL ,'
383
	       . ' `modified_when` INT NOT NULL DEFAULT \'0\','
384
	       . ' `modified_by` INT NOT NULL  DEFAULT \'0\','
385
	       . ' PRIMARY KEY ( `page_id` ) '
386
	       . ' )';
387
	$database->query($pages);
388
	
389
	// Sections table
390
	$pages = 'CREATE TABLE `'.TABLE_PREFIX.'sections` ( `section_id` INT NOT NULL auto_increment,'
391
	       . ' `page_id` INT NOT NULL DEFAULT \'0\','
392
	       . ' `position` INT NOT NULL DEFAULT \'0\','
393
	       . ' `module` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
394
	       . ' `block` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
395
	       . ' `publ_start` VARCHAR( 255 ) NOT NULL DEFAULT \'0\' ,'
396
	       . ' `publ_end` VARCHAR( 255 ) NOT NULL DEFAULT \'0\' ,' 
397
	       . ' PRIMARY KEY ( `section_id` ) '
398
	       . ' )';
399
	$database->query($pages);
400

  
401
	require(WB_PATH.'/admin/interface/version.php');
402
	
403
	// Settings table
404
	$settings='CREATE TABLE `'.TABLE_PREFIX.'settings` ( `setting_id` INT NOT NULL auto_increment,'
405
		. ' `name` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
406
		. ' `value` TEXT NOT NULL ,'
407
		. ' PRIMARY KEY ( `setting_id` ) '
408
		. ' )';
409
	$database->query($settings);
410

  
411
	$settings_rows=	"INSERT INTO `".TABLE_PREFIX."settings` "
412
	." (name, value) VALUES "
413
	." ('wb_version', '".VERSION."'),"
414
	." ('website_title', '$website_title'),"
415
	." ('website_description', ''),"
416
	." ('website_keywords', ''),"
417
	." ('website_header', ''),"
418
	." ('website_footer', ''),"
419
	." ('wysiwyg_style', 'font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px;'),"
420
	." ('rename_files_on_upload', 'php,asp,phpx,aspx'),"
421
	." ('er_level', ''),"
422
	." ('default_language', 'EN'),"
423
	." ('app_name', 'wb'),"
424
	." ('default_timezone', '$default_timezone'),"
425
	." ('default_date_format', 'M d Y'),"
426
	." ('default_time_format', 'g:i A'),"
427
	." ('home_folders', 'true'),"
428
	." ('default_template', 'round'),"
429
	." ('default_charset', 'utf-8'),"
430
	." ('multiple_menus', 'false'),"
431
	." ('page_level_limit', '4'),"
432
	." ('intro_page', 'false'),"
433
	." ('page_trash', 'disabled'),"
434
	." ('homepage_redirection', 'false'),"
435
	." ('page_languages', 'false'),"
436
	." ('wysiwyg_editor', 'fckeditor'),"
437
	." ('manage_sections', 'true'),"
438
	." ('section_blocks', 'false'),"
439
	." ('smart_login', 'false'),"
440
	." ('captcha_verification', 'true'),"
441
	." ('frontend_login', 'false'),"
442
	." ('frontend_signup', 'false'),"
443
	." ('server_email', '$admin_email'),"
444
	." ('search', 'public'),"
445
	." ('page_extension', '.php'),"
446
	." ('page_spacer', '-'),"
447
	." ('pages_directory', '/pages'),"
448
	." ('media_directory', '/media'),"
449
	." ('operating_system', '$operating_system'),"
450
	." ('string_file_mode', '$file_mode'),"
451
	." ('string_dir_mode', '$dir_mode'),"
452
	." ('wbmailer_routine', 'phpmail'),"
453
	." ('wbmailer_smtp_host', ''),"
454
	." ('wbmailer_smtp_auth', ''),"
455
	." ('wbmailer_smtp_username', ''),"
456
	." ('wbmailer_smtp_password', '')";
457
	$database->query($settings_rows);
458
	
459
	// Users table
460
	$users = 'CREATE TABLE `'.TABLE_PREFIX.'users` ( `user_id` INT NOT NULL auto_increment,'
461
	       . ' `group_id` INT NOT NULL DEFAULT \'0\','
462
	       . ' `groups_id` VARCHAR( 255 ) NOT NULL DEFAULT \'0\','
463
	       . ' `active` INT NOT NULL DEFAULT \'0\','
464
	       . ' `username` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
465
	       . ' `password` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
466
	       . ' `remember_key` VARCHAR( 255 ) NOT NULL DEFAULT \'\','
467
	       . ' `last_reset` INT NOT NULL DEFAULT \'0\','
468
	       . ' `display_name` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
469
	       . ' `email` TEXT NOT NULL ,'
470
	       . ' `timezone` INT NOT NULL DEFAULT \'0\','
471
	       . ' `date_format` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
472
	       . ' `time_format` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
473
	       . ' `language` VARCHAR( 5 ) NOT NULL DEFAULT \'\' ,'
474
	       . ' `home_folder` TEXT NOT NULL ,'
475
	       . ' `login_when` INT NOT NULL  DEFAULT \'0\','
476
	       . ' `login_ip` VARCHAR( 15 ) NOT NULL DEFAULT \'\' ,'
477
	       . ' PRIMARY KEY ( `user_id` ) '
478
	       . ' )';
479
	$database->query($users);
480
	
481
	// Groups table
482
	$groups = 'CREATE TABLE `'.TABLE_PREFIX.'groups` ( `group_id` INT NOT NULL auto_increment,'
483
	        . ' `name` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
484
	        . ' `system_permissions` TEXT NOT NULL ,'
485
	        . ' `module_permissions` TEXT NOT NULL ,'
486
	        . ' `template_permissions` TEXT NOT NULL ,'
487
	        . ' PRIMARY KEY ( `group_id` ) '
488
	        . ' )';
489
	$database->query($groups);
490
	
491
	// Search settings table
492
	$search = 'CREATE TABLE `'.TABLE_PREFIX.'search` ( `search_id` INT NOT NULL auto_increment,'
493
	        . ' `name` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
494
	        . ' `value` TEXT NOT NULL ,'
495
	        . ' `extra` TEXT NOT NULL ,'
496
	        . ' PRIMARY KEY ( `search_id` ) '
497
	        . ' )';
498
	$database->query($search);
499
	
500
	// Addons table
501
	$addons = 'CREATE TABLE `'.TABLE_PREFIX.'addons` ( '
502
			.'`addon_id` INT NOT NULL auto_increment ,'
503
			.'`type` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
504
			.'`directory` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
505
			.'`name` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
506
			.'`description` TEXT NOT NULL ,'
507
			.'`function` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
508
			.'`version` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
509
			.'`platform` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
510
			.'`author` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
511
			.'`license` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
512
			.' PRIMARY KEY ( `addon_id` ) '
513
			.' )';
514
	$database->query($addons);
515

  
516
	// Insert default data
517
	
518
	// Admin group
519
	$full_system_permissions = 'pages,pages_view,pages_add,pages_add_l0,pages_settings,pages_modify,pages_intro,pages_delete,media,media_view,media_upload,media_rename,media_delete,media_create,addons,modules,modules_view,modules_install,modules_uninstall,templates,templates_view,templates_install,templates_uninstall,languages,languages_view,languages_install,languages_uninstall,settings,settings_basic,settings_advanced,access,users,users_view,users_add,users_modify,users_delete,groups,groups_view,groups_add,groups_modify,groups_delete,admintools';
520
	$insert_admin_group = "INSERT INTO `".TABLE_PREFIX."groups` VALUES ('1', 'Administrators', '$full_system_permissions', '', '')";
521
	$database->query($insert_admin_group);
522
	// Admin user
523
	$insert_admin_user = "INSERT INTO `".TABLE_PREFIX."users` (user_id,group_id,groups_id,active,username,password,email,display_name) VALUES ('1','1','1','1','$admin_username','".md5($admin_password)."','$admin_email','Administrator')";
524
	$database->query($insert_admin_user);
525
	
526
	// Search header
527
	$search_header = addslashes('
528
<h1>[TEXT_SEARCH]</h1>
529

  
530
<form name="search" action="[WB_URL]/search/index.php" method="get">
531
<table cellpadding="3" cellspacing="0" border="0" width="500">
532
<tr>
533
<td>
534
<input type="hidden" name="search_path" value="[SEARCH_PATH]" />
535
<input type="text" name="string" value="[SEARCH_STRING]" style="width: 100%;" />
536
</td>
537
<td width="150">
538
<input type="submit" value="[TEXT_SEARCH]" style="width: 100%;" />
539
</td>
540
</tr>
541
<tr>
542
<td colspan="2">
543
<input type="radio" name="match" id="match_all" value="all"[ALL_CHECKED] />
544
<label for="match_all">[TEXT_ALL_WORDS]</label>
545
<input type="radio" name="match" id="match_any" value="any"[ANY_CHECKED] />
546
<label for="match_any">[TEXT_ANY_WORDS]</label>
547
<input type="radio" name="match" id="match_exact" value="exact"[EXACT_CHECKED] />
548
<label for="match_exact">[TEXT_EXACT_MATCH]</label>
549
</td>
550
</tr>
551
</table>
552

  
553
</form>
554

  
555
<hr />
556
	');
557
	$insert_search_header = "INSERT INTO `".TABLE_PREFIX."search` VALUES ('', 'header', '$search_header', '')";
558
	$database->query($insert_search_header);
559
	// Search footer
560
	$search_footer = addslashes('');
561
	$insert_search_footer = "INSERT INTO `".TABLE_PREFIX."search` VALUES ('', 'footer', '$search_footer', '')";
562
	$database->query($insert_search_footer);
563
	// Search results header
564
	$search_results_header = addslashes(''.
565
'[TEXT_RESULTS_FOR] \'<b>[SEARCH_STRING]</b>\':
566
<table cellpadding="2" cellspacing="0" border="0" width="100%" style="padding-top: 10px;">');
567
	$insert_search_results_header = "INSERT INTO `".TABLE_PREFIX."search` VALUES ('', 'results_header', '$search_results_header', '')";
568
	$database->query($insert_search_results_header);
569
	// Search results loop
570
	$search_results_loop = addslashes(''.
571
'<tr style="background-color: #F0F0F0;">
572
<td><a href="[LINK]">[TITLE]</a></td>
573
<td align="right">[TEXT_LAST_UPDATED_BY] [DISPLAY_NAME] ([USERNAME]) [TEXT_ON] [DATE]</td>
574
</tr>
575
<tr><td colspan="2" style="text-align: justify; padding-bottom: 5px;">[DESCRIPTION]</td></tr>
576
<tr><td colspan="2" style="text-align: justify; padding-bottom: 10px;">[EXCERPT]</td></tr>');
577

  
578
	$insert_search_results_loop = "INSERT INTO `".TABLE_PREFIX."search` VALUES ('', 'results_loop', '$search_results_loop', '')";
579
	$database->query($insert_search_results_loop);
580
	// Search results footer
581
	$search_results_footer = addslashes("</table>");
582
	$insert_search_results_footer = "INSERT INTO `".TABLE_PREFIX."search` VALUES ('', 'results_footer', '$search_results_footer', '')";
583
	$database->query($insert_search_results_footer);
584
	// Search no results
585
	$search_no_results = addslashes('<br />[TEXT_NO_RESULTS]');
586
	$insert_search_no_results = "INSERT INTO `".TABLE_PREFIX."search` VALUES ('', 'no_results', '$search_no_results', '')";
587
	$database->query($insert_search_no_results);
588
	// Search module-order
589
	$search_module_order = addslashes('faqbaker,manual,wysiwyg');
590
	$insert_search_module_order = "INSERT INTO `".TABLE_PREFIX."search` VALUES ('', 'module_order', '$search_module_order', '')";
591
	$database->query($insert_search_module_order);
592
	// Search max lines of excerpt
593
	$search_max_excerpt = addslashes('15');
594
	$insert_search_max_excerpt = "INSERT INTO `".TABLE_PREFIX."search` VALUES ('', 'max_excerpt', '$search_max_excerpt', '')";
595
	$database->query($insert_search_max_excerpt);
596
	// some config-elements
597
	$database->query("INSERT INTO `".TABLE_PREFIX."search` VALUES ('', 'cfg_enable_old_search', 'true', '')");
598
	$database->query("INSERT INTO `".TABLE_PREFIX."search` VALUES ('', 'cfg_search_keywords', 'true', '')");
599
	$database->query("INSERT INTO `".TABLE_PREFIX."search` VALUES ('', 'cfg_search_description', 'true', '')");
600
	$database->query("INSERT INTO `".TABLE_PREFIX."search` VALUES ('', 'cfg_show_description', 'true', '')");
601
	// Search template
602
	$database->query("INSERT INTO `".TABLE_PREFIX."search` (name) VALUES ('template')");
603
		
604
	require_once(WB_PATH.'/framework/initialize.php');
605
	
606
	// Include the PclZip class file (thanks to 
607
	require_once(WB_PATH.'/include/pclzip/pclzip.lib.php');
608
			
609
	// Install add-ons
610
	if(file_exists(WB_PATH.'/install/modules')) {
611
		// Unpack pre-packaged modules
612
			
613
	}
614
	if(file_exists(WB_PATH.'/install/templates')) {
615
		// Unpack pre-packaged templates
616
		
617
	}
618
	if(file_exists(WB_PATH.'/install/languages')) {
619
		// Unpack pre-packaged languages
620
		
621
	}
622
	
623
	$admin=new admin_dummy();
624
	// Load addons into DB
625
	$dirs['modules'] = WB_PATH.'/modules/';
626
	$dirs['templates'] = WB_PATH.'/templates/';
627
	$dirs['languages'] = WB_PATH.'/languages/';
628
	foreach($dirs AS $type => $dir) {
629
		if($handle = opendir($dir)) {
630
			while(false !== ($file = readdir($handle))) {
631
				if($file != '' AND substr($file, 0, 1) != '.' AND $file != 'admin.php' AND $file != 'index.php') {
632
					// Get addon type
633
					if($type == 'modules') {
634
						load_module($dir.'/'.$file, true);
635
						// Pretty ugly hack to let modules run $admin->set_error
636
						// See dummy class definition admin_dummy above
637
						if ($admin->error!='') {
638
							set_error($admin->error);
639
						}
640
					} elseif($type == 'templates') {
641
						load_template($dir.'/'.$file);
642
					} elseif($type == 'languages') {
643
						load_language($dir.'/'.$file);
644
					}
645
				}
646
			}
647
		closedir($handle);
648
		}
649
	}
650
	
651
	// Check if there was a database error
652
	if($database->is_error()) {
653
		set_error($database->get_error());
654
	}
655
	
656
}
657

  
658
// Log the user in and go to Website Baker Administration
659
$thisApp = new Login(
660
							array(
661
									"MAX_ATTEMPS" => "50",
662
									"WARNING_URL" => ADMIN_URL."/login/warning.html",
663
									"USERNAME_FIELDNAME" => 'admin_username',
664
									"PASSWORD_FIELDNAME" => 'admin_password',
665
									"REMEMBER_ME_OPTION" => SMART_LOGIN,
666
									"MIN_USERNAME_LEN" => "2",
667
									"MIN_PASSWORD_LEN" => "2",
668
									"MAX_USERNAME_LEN" => "30",
669
									"MAX_PASSWORD_LEN" => "30",
670
									'LOGIN_URL' => ADMIN_URL."/login/index.php",
671
									'DEFAULT_URL' => ADMIN_URL."/start/index.php",
672
									'TEMPLATE_DIR' => ADMIN_PATH."/login",
673
									'TEMPLATE_FILE' => "template.html",
674
									'FRONTEND' => false,
675
									'FORGOTTEN_DETAILS_APP' => ADMIN_URL."/login/forgot/index.php",
676
									'USERS_TABLE' => TABLE_PREFIX."users",
677
									'GROUPS_TABLE' => TABLE_PREFIX."groups",
678
							)
679
					);
680
?>

Also available in: Unified diff