Project

General

Profile

1 1352 Luisehahne
<?php
2
/**
3
 *
4
 * @category        frontend
5
 * @package         framework
6 1705 Luisehahne
 * @author          Ryan Djurovich,WebsiteBaker Project
7
 * @copyright       2009-2012, WebsiteBaker Org. e.V.
8 1352 Luisehahne
 * @link			http://www.websitebaker2.org/
9
 * @license         http://www.gnu.org/licenses/gpl.html
10
 * @platform        WebsiteBaker 2.8.x
11 1374 Luisehahne
 * @requirements    PHP 5.2.2 and higher
12 1352 Luisehahne
 * @version         $Id$
13
 * @filesource		$HeadURL$
14
 * @lastmodified    $Date$
15
 *
16
*/
17 1496 DarkViper
/* -------------------------------------------------------- */
18
// Must include code to stop this file being accessed directly
19 1499 DarkViper
if(!defined('WB_PATH')) {
20
	require_once(dirname(__FILE__).'/globalExceptionHandler.php');
21
	throw new IllegalFileException();
22
}
23 1496 DarkViper
/* -------------------------------------------------------- */
24 1352 Luisehahne
// Define that this file has been loaded
25
define('FUNCTIONS_FILE_LOADED', true);
26
27 1365 Luisehahne
/**
28
 * @description: recursively delete a non empty directory
29
 * @param string $directory :
30
 * @param bool $empty : true if you want the folder just emptied, but not deleted
31
 *                      false, or just simply leave it out, the given directory will be deleted, as well
32 1676 Luisehahne
 * @return boolean: true/false
33 1365 Luisehahne
 * @from http://www.php.net/manual/de/function.rmdir.php#98499
34
 */
35 1676 Luisehahne
function rm_full_dir($directory, $empty = false)
36
{
37 1765 Luisehahne
    $iErrorReporting = error_reporting(0);
38 1495 DarkViper
	if(substr($directory,-1) == "/") {
39 1365 Luisehahne
        $directory = substr($directory,0,-1);
40
    }
41 1601 Luisehahne
   // If suplied dirname is a file then unlink it
42 1676 Luisehahne
    if (is_file( $directory )&& is_writable( $directory )) {
43 1765 Luisehahne
        $retval = unlink($directory);
44
        clearstatcache();
45
        error_reporting($iErrorReporting);
46
        return $retval;
47 1352 Luisehahne
    }
48 1676 Luisehahne
    if(!is_writable($directory) || !is_dir($directory)) {
49 1765 Luisehahne
        error_reporting($iErrorReporting);
50 1365 Luisehahne
        return false;
51 1495 DarkViper
    } elseif(!is_readable($directory)) {
52 1765 Luisehahne
        error_reporting($iErrorReporting);
53 1365 Luisehahne
        return false;
54
    } else {
55
        $directoryHandle = opendir($directory);
56
        while ($contents = readdir($directoryHandle))
57
		{
58
            if($contents != '.' && $contents != '..')
59 1352 Luisehahne
			{
60 1365 Luisehahne
                $path = $directory . "/" . $contents;
61 1495 DarkViper
                if(is_dir($path)) {
62 1365 Luisehahne
                    rm_full_dir($path);
63
                } else {
64
                    unlink($path);
65 1601 Luisehahne
					clearstatcache();
66 1365 Luisehahne
                }
67 1352 Luisehahne
            }
68 1365 Luisehahne
        }
69
        closedir($directoryHandle);
70 1495 DarkViper
        if($empty == false) {
71 1676 Luisehahne
            if(is_dir($directory) && is_writable(dirname($directory))) {
72 1765 Luisehahne
                $retval = rmdir($directory);
73
                error_reporting($iErrorReporting);
74
                return $retval;
75 1676 Luisehahne
            } else {
76 1765 Luisehahne
                error_reporting($iErrorReporting);
77 1676 Luisehahne
				return false;
78 1352 Luisehahne
            }
79
        }
80 1765 Luisehahne
        error_reporting($iErrorReporting);
81 1365 Luisehahne
        return true;
82
    }
83 1352 Luisehahne
}
84
85
/*
86
 * returns a recursive list of all subdirectories from a given directory
87
 * @access  public
88
 * @param   string  $directory: from this dir the recursion will start
89
 * @param   bool    $show_hidden:  if set to TRUE also hidden dirs (.dir) will be shown
90
 * @return  array
91
 * example:
92
 *  /srv/www/httpdocs/wb/media/a/b/c/
93
 *  /srv/www/httpdocs/wb/media/a/b/d/
94
 * directory_list('/srv/www/httpdocs/wb/media/') will return:
95
 *  /a
96
 *  /a/b
97
 *  /a/b/c
98
 *  /a/b/d
99
 */
100
 function directory_list($directory, $show_hidden = false)
101
{
102
	$result_list = array();
103
	if (is_dir($directory))
104
    {
105
    	$dir = dir($directory); // Open the directory
106
    	while (false !== $entry = $dir->read()) // loop through the directory
107
		{
108
			if($entry == '.' || $entry == '..') { continue; } // Skip pointers
109
			if($entry[0] == '.' && $show_hidden == false) { continue; } // Skip hidden files
110 1495 DarkViper
    		if (is_dir("$directory/$entry")) { // Add dir and contents to list
111 1352 Luisehahne
    			$result_list = array_merge($result_list, directory_list("$directory/$entry"));
112
    			$result_list[] = "$directory/$entry";
113
    		}
114
    	}
115
        $dir->close();
116
    }
117 1365 Luisehahne
	// sorting
118 1495 DarkViper
	if(natcasesort($result_list)) {
119 1365 Luisehahne
		// new indexing
120
		$result_list = array_merge($result_list);
121
	}
122 1352 Luisehahne
	return $result_list; // Now return the list
123
}
124
125
// Function to open a directory and add to a dir list
126
function chmod_directory_contents($directory, $file_mode)
127
{
128
	if (is_dir($directory))
129
    {
130
    	// Set the umask to 0
131
    	$umask = umask(0);
132
    	// Open the directory then loop through its contents
133
    	$dir = dir($directory);
134
    	while (false !== $entry = $dir->read())
135
		{
136
    		// Skip pointers
137
    		if($entry[0] == '.') { continue; }
138
    		// Chmod the sub-dirs contents
139 1495 DarkViper
    		if(is_dir("$directory/$entry")) {
140 1352 Luisehahne
    			chmod_directory_contents($directory.'/'.$entry, $file_mode);
141
    		}
142
    		change_mode($directory.'/'.$entry);
143
    	}
144
        $dir->close();
145
    	// Restore the umask
146
    	umask($umask);
147
    }
148
}
149
150 1365 Luisehahne
/**
151
* Scan a given directory for dirs and files.
152
*
153
* usage: scan_current_dir ($root = '' )
154
*
155
* @param     $root   set a absolute rootpath as string. if root is empty the current path will be scan
156
* @param     $search set a search pattern for files, empty search brings all files
157
* @access    public
158
* @return    array    returns a natsort array with keys 'path' and 'filename'
159
*
160
*/
161
if(!function_exists('scan_current_dir'))
162
{
163
	function scan_current_dir($root = '', $search = '/.*/')
164
	{
165
	    $FILE = array();
166
		$array = array();
167
	    clearstatcache();
168
	    $root = empty ($root) ? getcwd() : $root;
169
	    if (($handle = opendir($root)))
170
	    {
171
	    // Loop through the files and dirs an add to list  DIRECTORY_SEPARATOR
172
	        while (false !== ($file = readdir($handle)))
173
	        {
174
	            if (substr($file, 0, 1) != '.' && $file != 'index.php')
175
	            {
176 1495 DarkViper
	                if (is_dir($root.'/'.$file)) {
177 1365 Luisehahne
	                    $FILE['path'][] = $file;
178 1495 DarkViper
	                } elseif (preg_match($search, $file, $array) ) {
179 1365 Luisehahne
	                    $FILE['filename'][] = $array[0];
180
	                }
181
	            }
182
	        }
183
	        $close_verz = closedir($handle);
184
	    }
185
		// sorting
186 1495 DarkViper
	    if (isset ($FILE['path']) && natcasesort($FILE['path'])) {
187 1365 Luisehahne
			// new indexing
188
	        $FILE['path'] = array_merge($FILE['path']);
189
	    }
190
		// sorting
191 1495 DarkViper
	    if (isset ($FILE['filename']) && natcasesort($FILE['filename'])) {
192 1365 Luisehahne
			// new indexing
193
	        $FILE['filename'] = array_merge($FILE['filename']);
194
	    }
195
	    return $FILE;
196
	}
197
}
198
199 1352 Luisehahne
// Function to open a directory and add to a file list
200
function file_list($directory, $skip = array(), $show_hidden = false)
201
{
202
	$result_list = array();
203
	if (is_dir($directory))
204
    {
205
    	$dir = dir($directory); // Open the directory
206
		while (false !== ($entry = $dir->read())) // loop through the directory
207
		{
208
			if($entry == '.' || $entry == '..') { continue; } // Skip pointers
209
			if($entry[0] == '.' && $show_hidden == false) { continue; } // Skip hidden files
210
			if( sizeof($skip) > 0 && in_array($entry, $skip) ) { continue; } // Check if we to skip anything else
211 1495 DarkViper
			if(is_file( $directory.'/'.$entry)) { // Add files to list
212 1352 Luisehahne
				$result_list[] = $directory.'/'.$entry;
213
			}
214
		}
215
		$dir->close(); // Now close the folder object
216
	}
217 1365 Luisehahne
218
    // make the list nice. Not all OS do this itself
219 1495 DarkViper
	if(natcasesort($result_list)) {
220 1365 Luisehahne
		$result_list = array_merge($result_list);
221 1495 DarkViper
	}
222 1352 Luisehahne
	return $result_list;
223
}
224
225 1824 Luisehahne
function remove_home_subs($directory = '/', $home_folders = '')
226
{
227
	if( ($handle = opendir(WB_PATH.MEDIA_DIRECTORY.$directory)) )
228
	{
229
		// Loop through the dirs to check the home folders sub-dirs are not shown
230
		while(false !== ($file = readdir($handle)))
231
		{
232
			if($file[0] != '.' && $file != 'index.php')
233
			{
234
				if(is_dir(WB_PATH.MEDIA_DIRECTORY.$directory.'/'.$file))
235
				{
236
					if($directory != '/') {
237
						$file = $directory.'/'.$file;
238
					}else {
239
						$file = '/'.$file;
240
					}
241
					foreach($home_folders AS $hf)
242
					{
243
						$hf_length = strlen($hf);
244
						if($hf_length > 0) {
245
							if(substr($file, 0, $hf_length+1) == $hf) {
246
								$home_folders[$file] = $file;
247
							}
248
						}
249
					}
250
					$home_folders = remove_home_subs($file, $home_folders);
251
				}
252
			}
253
		}
254
	}
255
	return $home_folders;
256
}
257
258 1352 Luisehahne
// Function to get a list of home folders not to show
259
function get_home_folders()
260
{
261
	global $database, $admin;
262
	$home_folders = array();
263
	// Only return home folders is this feature is enabled
264
	// and user is not admin
265
//	if(HOME_FOLDERS AND ($_SESSION['GROUP_ID']!='1')) {
266
	if(HOME_FOLDERS AND (!in_array('1',explode(',', $_SESSION['GROUPS_ID']))))
267
	{
268 1495 DarkViper
		$sql  = 'SELECT `home_folder` FROM `'.TABLE_PREFIX.'users` ';
269
		$sql .= 'WHERE `home_folder`!=\''.$admin->get_home_folder().'\'';
270 1352 Luisehahne
		$query_home_folders = $database->query($sql);
271
		if($query_home_folders->numRows() > 0)
272
		{
273 1495 DarkViper
			while($folder = $query_home_folders->fetchRow()) {
274 1352 Luisehahne
				$home_folders[$folder['home_folder']] = $folder['home_folder'];
275
			}
276
		}
277
		$home_folders = remove_home_subs('/', $home_folders);
278
	}
279
	return $home_folders;
280
}
281
282 1365 Luisehahne
/*
283
 * @param object &$wb: $wb from frontend or $admin from backend
284
 * @return array: list of new entries
285
 * @description: callback remove path in files/dirs stored in array
286
 * @example: array_walk($array,'remove_path',PATH);
287
 */
288
//
289
function remove_path(&$path, $key, $vars = '')
290
{
291
	$path = str_replace($vars, '', $path);
292
}
293
/*
294
 * @param object &$wb: $wb from frontend or $admin from backend
295
 * @return array: list of ro-dirs
296
 * @description: returns a list of directories beyound /wb/media which are ReadOnly for current user
297
 */
298
function media_dirs_ro( &$wb )
299
{
300
	global $database;
301
	// if user is admin or home-folders not activated then there are no restrictions
302
	$allow_list = array();
303 1495 DarkViper
	if( $wb->get_user_id() == 1 || !HOME_FOLDERS ) {
304 1365 Luisehahne
		return array();
305
	}
306
	// at first read any dir and subdir from /media
307
	$full_list = directory_list( WB_PATH.MEDIA_DIRECTORY );
308
	// add own home_folder to allow-list
309 1495 DarkViper
	if( $wb->get_home_folder() ) {
310 1365 Luisehahne
		// old: $allow_list[] = get_home_folder();
311
		$allow_list[] = $wb->get_home_folder();
312
	}
313
	// get groups of current user
314
	$curr_groups = $wb->get_groups_id();
315
	// if current user is in admin-group
316 1495 DarkViper
	if( ($admin_key = array_search('1', $curr_groups)) !== false)
317 1365 Luisehahne
	{
318
		// remove admin-group from list
319
		unset($curr_groups[$admin_key]);
320
		// search for all users where the current user is admin from
321
		foreach( $curr_groups as $group)
322
		{
323
			$sql  = 'SELECT `home_folder` FROM `'.TABLE_PREFIX.'users` ';
324
			$sql .= 'WHERE (FIND_IN_SET(\''.$group.'\', `groups_id`) > 0) AND `home_folder` <> \'\' AND `user_id` <> '.$wb->get_user_id();
325 1495 DarkViper
			if( ($res_hf = $database->query($sql)) != null ) {
326
				while( $rec_hf = $res_hf->fetchrow() ) {
327 1365 Luisehahne
					$allow_list[] = $rec_hf['home_folder'];
328
				}
329
			}
330
		}
331
	}
332
	$tmp_array = $full_list;
333
	// create a list for readonly dir
334
    $array = array();
335
	while( sizeof($tmp_array) > 0)
336
	{
337
        $tmp = array_shift($tmp_array);
338
        $x = 0;
339 1495 DarkViper
		while($x < sizeof($allow_list)) {
340 1365 Luisehahne
			if(strpos ($tmp,$allow_list[$x])) {
341
				$array[] = $tmp;
342
			}
343
			$x++;
344
		}
345
	}
346
	$full_list = array_diff( $full_list, $array );
347
	$tmp = array();
348
	$full_list = array_merge($tmp,$full_list);
349
	return $full_list;
350
}
351
352
/*
353
 * @param object &$wb: $wb from frontend or $admin from backend
354
 * @return array: list of rw-dirs
355
 * @description: returns a list of directories beyound /wb/media which are ReadWrite for current user
356
 */
357
function media_dirs_rw ( &$wb )
358
{
359
	global $database;
360
	// if user is admin or home-folders not activated then there are no restrictions
361
	// at first read any dir and subdir from /media
362
	$full_list = directory_list( WB_PATH.MEDIA_DIRECTORY );
363
    $array = array();
364
	$allow_list = array();
365 1495 DarkViper
	if( ($wb->ami_group_member('1')) && !HOME_FOLDERS ) {
366 1365 Luisehahne
		return $full_list;
367
	}
368
	// add own home_folder to allow-list
369 1495 DarkViper
	if( $wb->get_home_folder() ) {
370 1365 Luisehahne
	  	$allow_list[] = $wb->get_home_folder();
371
	} else {
372
		$array = $full_list;
373
	}
374
	// get groups of current user
375
	$curr_groups = $wb->get_groups_id();
376
	// if current user is in admin-group
377
	if( ($admin_key = array_search('1', $curr_groups)) == true)
378
	{
379
		// remove admin-group from list
380
		// unset($curr_groups[$admin_key]);
381
		// search for all users where the current user is admin from
382
		foreach( $curr_groups as $group)
383
		{
384
			$sql  = 'SELECT `home_folder` FROM `'.TABLE_PREFIX.'users` ';
385
			$sql .= 'WHERE (FIND_IN_SET(\''.$group.'\', `groups_id`) > 0) AND `home_folder` <> \'\' AND `user_id` <> '.$wb->get_user_id();
386 1495 DarkViper
			if( ($res_hf = $database->query($sql)) != null ) {
387
				while( $rec_hf = $res_hf->fetchrow() ) {
388 1365 Luisehahne
					$allow_list[] = $rec_hf['home_folder'];
389
				}
390
			}
391
		}
392
	}
393
394
	$tmp_array = $full_list;
395
	// create a list for readwrite dir
396
	while( sizeof($tmp_array) > 0)
397
	{
398
        $tmp = array_shift($tmp_array);
399
        $x = 0;
400 1495 DarkViper
		while($x < sizeof($allow_list)) {
401 1365 Luisehahne
			if(strpos ($tmp,$allow_list[$x])) {
402
				$array[] = $tmp;
403
			}
404
			$x++;
405
		}
406
	}
407
	$tmp = array();
408
    $array = array_unique($array);
409
	$full_list = array_merge($tmp,$array);
410
    unset($array);
411
    unset($allow_list);
412
	return $full_list;
413
}
414
415 1352 Luisehahne
// Function to create directories
416 1556 Luisehahne
function make_dir($dir_name, $dir_mode = OCTAL_DIR_MODE, $recursive=true)
417 1352 Luisehahne
{
418 1765 Luisehahne
	$retVal = is_dir($dir_name);
419 1352 Luisehahne
	if(!is_dir($dir_name))
420
    {
421 1759 Luisehahne
		// To create the folder with 0777 permissions, we need to set umask to zero.
422
		$oldumask = umask(0) ;
423 1765 Luisehahne
		$retVal = mkdir($dir_name, $dir_mode, $recursive);
424 1759 Luisehahne
		umask( $oldumask ) ;
425 1352 Luisehahne
	}
426 1555 Luisehahne
	return $retVal;
427 1352 Luisehahne
}
428
429 1651 darkviper
/**
430
 * Function to chmod files and/or directories
431 1653 darkviper
 * the function also prevents the owner to loose rw-rights
432 1651 darkviper
 * @param string $sName
433
 * @param int rights in dec-value. 0= use wb-defaults
434 1676 Luisehahne
 * @return bool
435 1651 darkviper
 */
436
function change_mode($sName, $iMode = 0)
437 1352 Luisehahne
{
438 1651 darkviper
	$bRetval = true;
439 1759 Luisehahne
    $iErrorReporting = error_reporting(0);
440 1653 darkviper
	$iMode = intval($iMode) & 0777; // sanitize value
441 1705 Luisehahne
	if (strtoupper(substr(PHP_OS, 0, 3)) !== 'WIN')
442 1651 darkviper
	{ // Only chmod if os is not windows
443
		$bRetval = false;
444
		if(!$iMode) {
445
			$iMode = (is_file($sName) ? octdec(STRING_FILE_MODE) : octdec(STRING_DIR_MODE));
446 1352 Luisehahne
		}
447 1653 darkviper
		$iMode |= 0600; // set o+rw
448 1651 darkviper
		if(is_writable($sName)) {
449
			$bRetval = chmod($sName, $iMode);
450 1352 Luisehahne
		}
451
	}
452 1759 Luisehahne
    error_reporting($iErrorReporting);
453 1651 darkviper
	return $bRetval;
454 1352 Luisehahne
}
455
456
// Function to figure out if a parent exists
457
function is_parent($page_id)
458
{
459
	global $database;
460
	// Get parent
461
	$sql = 'SELECT `parent` FROM `'.TABLE_PREFIX.'pages` WHERE `page_id` = '.$page_id;
462
	$parent = $database->get_one($sql);
463
	// If parent isnt 0 return its ID
464 1495 DarkViper
	if(is_null($parent)) {
465 1352 Luisehahne
		return false;
466 1495 DarkViper
	}else {
467 1352 Luisehahne
		return $parent;
468
	}
469
}
470
471
// Function to work out level
472
function level_count($page_id)
473
{
474
	global $database;
475
	// Get page parent
476
	$sql = 'SELECT `parent` FROM `'.TABLE_PREFIX.'pages` WHERE `page_id` = '.$page_id;
477
	$parent = $database->get_one($sql);
478 1495 DarkViper
	if($parent > 0)
479 1352 Luisehahne
	{	// Get the level of the parent
480
		$sql = 'SELECT `level` FROM `'.TABLE_PREFIX.'pages` WHERE `page_id` = '.$parent;
481
		$level = $database->get_one($sql);
482
		return $level+1;
483 1495 DarkViper
	}else {
484 1352 Luisehahne
		return 0;
485
	}
486
}
487
488
// Function to work out root parent
489
function root_parent($page_id)
490
{
491
	global $database;
492
	// Get page details
493
	$sql = 'SELECT `parent`, `level` FROM `'.TABLE_PREFIX.'pages` WHERE `page_id` = '.$page_id;
494 1754 Luisehahne
495 1352 Luisehahne
	$query_page = $database->query($sql);
496 1759 Luisehahne
	$fetch_page = $query_page->fetchRow(MYSQL_ASSOC);
497 1352 Luisehahne
	$parent = $fetch_page['parent'];
498 1495 DarkViper
	$level = $fetch_page['level'];
499
	if($level == 1) {
500 1352 Luisehahne
		return $parent;
501 1754 Luisehahne
	} elseif($parent == 0) {
502 1352 Luisehahne
		return $page_id;
503 1754 Luisehahne
	} else {	// Figure out what the root parents id is
504 1352 Luisehahne
		$parent_ids = array_reverse(get_parent_ids($page_id));
505
		return $parent_ids[0];
506
	}
507
}
508
509
// Function to get page title
510
function get_page_title($id)
511
{
512
	global $database;
513
	// Get title
514
	$sql = 'SELECT `page_title` FROM `'.TABLE_PREFIX.'pages` WHERE `page_id` = '.$id;
515
	$page_title = $database->get_one($sql);
516
	return $page_title;
517
}
518
519
// Function to get a pages menu title
520
function get_menu_title($id)
521
{
522
	global $database;
523
	// Get title
524
	$sql = 'SELECT `menu_title` FROM `'.TABLE_PREFIX.'pages` WHERE `page_id` = '.$id;
525
	$menu_title = $database->get_one($sql);
526
	return $menu_title;
527
}
528
529
// Function to get all parent page titles
530
function get_parent_titles($parent_id)
531
{
532
	$titles[] = get_menu_title($parent_id);
533 1495 DarkViper
	if(is_parent($parent_id) != false) {
534 1352 Luisehahne
		$parent_titles = get_parent_titles(is_parent($parent_id));
535
		$titles = array_merge($titles, $parent_titles);
536
	}
537
	return $titles;
538
}
539
540
// Function to get all parent page id's
541
function get_parent_ids($parent_id)
542
{
543
	$ids[] = $parent_id;
544 1495 DarkViper
	if(is_parent($parent_id) != false) {
545 1352 Luisehahne
		$parent_ids = get_parent_ids(is_parent($parent_id));
546
		$ids = array_merge($ids, $parent_ids);
547
	}
548
	return $ids;
549
}
550
551
// Function to genereate page trail
552 1495 DarkViper
function get_page_trail($page_id)
553
{
554 1352 Luisehahne
	return implode(',', array_reverse(get_parent_ids($page_id)));
555
}
556
557
// Function to get all sub pages id's
558 1514 Luisehahne
function get_subs($parent, array $subs )
559 1352 Luisehahne
{
560
	// Connect to the database
561
	global $database;
562
	// Get id's
563
	$sql = 'SELECT `page_id` FROM `'.TABLE_PREFIX.'pages` WHERE `parent` = '.$parent;
564 1514 Luisehahne
	if( ($query = $database->query($sql)) ) {
565 1759 Luisehahne
		while($fetch = $query->fetchRow(MYSQL_ASSOC)) {
566 1352 Luisehahne
			$subs[] = $fetch['page_id'];
567 1514 Luisehahne
			// Get subs of this sub recursive
568 1352 Luisehahne
			$subs = get_subs($fetch['page_id'], $subs);
569
		}
570
	}
571
	// Return subs array
572
	return $subs;
573
}
574
575
// Function as replacement for php's htmlspecialchars()
576
// Will not mangle HTML-entities
577
function my_htmlspecialchars($string)
578
{
579
	$string = preg_replace('/&(?=[#a-z0-9]+;)/i', '__amp;_', $string);
580
	$string = strtr($string, array('<'=>'&lt;', '>'=>'&gt;', '&'=>'&amp;', '"'=>'&quot;', '\''=>'&#39;'));
581
	$string = preg_replace('/__amp;_(?=[#a-z0-9]+;)/i', '&', $string);
582
	return($string);
583
}
584
585
// Convert a string from mixed html-entities/umlauts to pure $charset_out-umlauts
586
// Will replace all numeric and named entities except &gt; &lt; &apos; &quot; &#039; &nbsp;
587
// In case of error the returned string is unchanged, and a message is emitted.
588
function entities_to_umlauts($string, $charset_out=DEFAULT_CHARSET)
589
{
590
	require_once(WB_PATH.'/framework/functions-utf8.php');
591
	return entities_to_umlauts2($string, $charset_out);
592
}
593
594
// Will convert a string in $charset_in encoding to a pure ASCII string with HTML-entities.
595
// In case of error the returned string is unchanged, and a message is emitted.
596
function umlauts_to_entities($string, $charset_in=DEFAULT_CHARSET)
597
{
598
	require_once(WB_PATH.'/framework/functions-utf8.php');
599
	return umlauts_to_entities2($string, $charset_in);
600
}
601
602
// Function to convert a page title to a page filename
603
function page_filename($string)
604
{
605
	require_once(WB_PATH.'/framework/functions-utf8.php');
606
	$string = entities_to_7bit($string);
607
	// Now remove all bad characters
608
	$bad = array(
609
	'\'', /* /  */ '"', /* " */	'<', /* < */	'>', /* > */
610
	'{', /* { */	'}', /* } */	'[', /* [ */	']', /* ] */	'`', /* ` */
611
	'!', /* ! */	'@', /* @ */	'#', /* # */	'$', /* $ */	'%', /* % */
612
	'^', /* ^ */	'&', /* & */	'*', /* * */	'(', /* ( */	')', /* ) */
613
	'=', /* = */	'+', /* + */	'|', /* | */	'/', /* / */	'\\', /* \ */
614
	';', /* ; */	':', /* : */	',', /* , */	'?' /* ? */
615
	);
616
	$string = str_replace($bad, '', $string);
617
	// replace multiple dots in filename to single dot and (multiple) dots at the end of the filename to nothing
618
	$string = preg_replace(array('/\.+/', '/\.+$/'), array('.', ''), $string);
619
	// Now replace spaces with page spcacer
620
	$string = trim($string);
621
	$string = preg_replace('/(\s)+/', PAGE_SPACER, $string);
622
	// Now convert to lower-case
623
	$string = strtolower($string);
624
	// If there are any weird language characters, this will protect us against possible problems they could cause
625
	$string = str_replace(array('%2F', '%'), array('/', ''), urlencode($string));
626
	// Finally, return the cleaned string
627
	return $string;
628
}
629
630 1457 Luisehahne
// Function to convert a desired media filename to a clean mediafilename
631 1352 Luisehahne
function media_filename($string)
632
{
633
	require_once(WB_PATH.'/framework/functions-utf8.php');
634
	$string = entities_to_7bit($string);
635
	// Now remove all bad characters
636 1454 DarkViper
	$bad = array('\'','"','`','!','@','#','$','%','^','&','*','=','+','|','/','\\',';',':',',','?');
637 1352 Luisehahne
	$string = str_replace($bad, '', $string);
638
	// replace multiple dots in filename to single dot and (multiple) dots at the end of the filename to nothing
639 1454 DarkViper
	$string = preg_replace(array('/\.+/', '/\.+$/', '/\s/'), array('.', '', '_'), $string);
640 1352 Luisehahne
	// Clean any page spacers at the end of string
641
	$string = trim($string);
642
	// Finally, return the cleaned string
643
	return $string;
644
}
645
646
// Function to work out a page link
647
if(!function_exists('page_link'))
648
{
649
	function page_link($link)
650
	{
651
		global $admin;
652
		return $admin->page_link($link);
653
	}
654
}
655
656 1468 Luisehahne
// Create a new directory and/or protected file in the given directory
657 1477 Luisehahne
function createFolderProtectFile($sAbsDir='',$make_dir=true)
658 1457 Luisehahne
{
659
	global $admin, $MESSAGE;
660
	$retVal = array();
661 1484 Luisehahne
	$wb_path = rtrim(str_replace('\/\\', '/', WB_PATH), '/');
662
    if( ($sAbsDir=='') || ($sAbsDir == $wb_path) ) { return $retVal;}
663 1457 Luisehahne
664
	if ( $make_dir==true ) {
665
		// Check to see if the folder already exists
666 1477 Luisehahne
		if(file_exists($sAbsDir)) {
667 1457 Luisehahne
			// $admin->print_error($MESSAGE['MEDIA_DIR_EXISTS']);
668 1477 Luisehahne
			$retVal[] = basename($sAbsDir).'::'.$MESSAGE['MEDIA_DIR_EXISTS'];
669 1457 Luisehahne
		}
670 1555 Luisehahne
		if (!is_dir($sAbsDir) && !make_dir($sAbsDir) ) {
671 1457 Luisehahne
			// $admin->print_error($MESSAGE['MEDIA_DIR_NOT_MADE']);
672 1477 Luisehahne
			$retVal[] = basename($sAbsDir).'::'.$MESSAGE['MEDIA_DIR_NOT_MADE'];
673
		} else {
674
			change_mode($sAbsDir);
675 1457 Luisehahne
		}
676
	}
677
678 1477 Luisehahne
	if( is_writable($sAbsDir) )
679 1457 Luisehahne
	{
680 1477 Luisehahne
        // if(file_exists($sAbsDir.'/index.php')) { unlink($sAbsDir.'/index.php'); }
681 1457 Luisehahne
	    // Create default "index.php" file
682 1484 Luisehahne
		$rel_pages_dir = str_replace($wb_path, '', dirname($sAbsDir) );
683 1457 Luisehahne
		$step_back = str_repeat( '../', substr_count($rel_pages_dir, '/')+1 );
684
685
		$sResponse  = $_SERVER['SERVER_PROTOCOL'].' 301 Moved Permanently';
686
		$content =
687
			'<?php'."\n".
688
			'// *** This file is generated by WebsiteBaker Ver.'.VERSION."\n".
689
			'// *** Creation date: '.date('c')."\n".
690
			'// *** Do not modify this file manually'."\n".
691
			'// *** WB will rebuild this file from time to time!!'."\n".
692
			'// *************************************************'."\n".
693
			"\t".'header(\''.$sResponse.'\');'."\n".
694
			"\t".'header(\'Location: '.WB_URL.'/index.php\');'."\n".
695
			'// *************************************************'."\n";
696 1477 Luisehahne
		$filename = $sAbsDir.'/index.php';
697 1484 Luisehahne
698 1457 Luisehahne
		// write content into file
699 1551 Luisehahne
		  if(is_writable($filename) || !file_exists($filename)) {
700
		      if(file_put_contents($filename, $content)) {
701
		//    print 'create => '.str_replace( $wb_path,'',$filename).'<br />';
702
		          change_mode($filename, 'file');
703 1765 Luisehahne
		      } else {
704 1551 Luisehahne
		    $retVal[] = $MESSAGE['GENERIC_BAD_PERMISSIONS'].' :: '.$filename;
705
		   }
706
		  }
707
		 } else {
708
		   $retVal[] = $MESSAGE['GENERIC_BAD_PERMISSIONS'];
709
		 }
710
		 return $retVal;
711 1457 Luisehahne
}
712
713
function rebuildFolderProtectFile($dir='')
714
{
715 1675 Luisehahne
	global $MESSAGE;
716 1495 DarkViper
	$retVal = array();
717
	$dir = rtrim(str_replace('\/\\', '/', $dir), '/');
718
	try {
719
		$files = array();
720
		$files[] = $dir;
721
		foreach(new RecursiveIteratorIterator(new RecursiveDirectoryIterator($dir)) as $fileInfo) {
722
			$files[] = $fileInfo->getPath();
723
		}
724
		$files = array_unique($files);
725
		foreach( $files as $file) {
726
			$protect_file = rtrim(str_replace('\/\\', '/', $file), '/');
727
			$retVal[] = createFolderProtectFile($protect_file,false);
728
		}
729
	} catch ( Exception $e ) {
730
		$retVal[] = $MESSAGE['MEDIA_DIR_ACCESS_DENIED'];
731
	}
732
	return $retVal;
733 1457 Luisehahne
}
734
735
// Create a new file in the pages directory
736 1352 Luisehahne
function create_access_file($filename,$page_id,$level)
737
{
738
	global $admin, $MESSAGE;
739 1765 Luisehahne
	$retVal = array();
740 1495 DarkViper
	// First make sure parent folder exists
741
	$parent_folders = explode('/',str_replace(WB_PATH.PAGES_DIRECTORY, '', dirname($filename)));
742
	$parents = '';
743
	foreach($parent_folders AS $parent_folder)
744 1352 Luisehahne
	{
745 1495 DarkViper
		if($parent_folder != '/' AND $parent_folder != '')
746 1352 Luisehahne
		{
747 1495 DarkViper
			$parents .= '/'.$parent_folder;
748
			$acces_file = WB_PATH.PAGES_DIRECTORY.$parents;
749
			// can only be dirs
750
			if(!file_exists($acces_file)) {
751
				if(!make_dir($acces_file)) {
752 1765 Luisehahne
//					$admin->print_error($MESSAGE['PAGES_CANNOT_CREATE_ACCESS_FILE_FOLDER']);
753
                    $retVal[] = $MESSAGE['MEDIA_DIR_ACCESS_DENIED'];
754 1352 Luisehahne
				}
755 1457 Luisehahne
			}
756 1352 Luisehahne
		}
757 1495 DarkViper
	}
758
	// The depth of the page directory in the directory hierarchy
759
	// '/pages' is at depth 1
760
	$pages_dir_depth = count(explode('/',PAGES_DIRECTORY))-1;
761
	// Work-out how many ../'s we need to get to the index page
762
	$index_location = '';
763
	for($i = 0; $i < $level + $pages_dir_depth; $i++) {
764
		$index_location .= '../';
765
	}
766
	$content =
767
		'<?php'."\n".
768
		'// *** This file is generated by WebsiteBaker Ver.'.VERSION."\n".
769
		'// *** Creation date: '.date('c')."\n".
770
		'// *** Do not modify this file manually'."\n".
771
		'// *** WB will rebuild this file from time to time!!'."\n".
772
		'// *************************************************'."\n".
773
		"\t".'$page_id    = '.$page_id.';'."\n".
774
		"\t".'require(\''.$index_location.'index.php\');'."\n".
775
		'// *************************************************'."\n";
776 1352 Luisehahne
777 1495 DarkViper
	if( ($handle = fopen($filename, 'w')) ) {
778
		fwrite($handle, $content);
779
		fclose($handle);
780
		// Chmod the file
781
		change_mode($filename);
782
	} else {
783 1765 Luisehahne
//		$admin->print_error($MESSAGE['PAGES_CANNOT_CREATE_ACCESS_FILE']);
784
        $retVal[] = $MESSAGE['PAGES_CANNOT_CREATE_ACCESS_FILE'];
785 1495 DarkViper
	}
786 1765 Luisehahne
	return $retVal;
787 1457 Luisehahne
 }
788
789 1352 Luisehahne
// Function for working out a file mime type (if the in-built PHP one is not enabled)
790
if(!function_exists('mime_content_type'))
791
{
792 1457 Luisehahne
    function mime_content_type($filename)
793 1352 Luisehahne
	{
794
	    $mime_types = array(
795
            'txt'	=> 'text/plain',
796
            'htm'	=> 'text/html',
797
            'html'	=> 'text/html',
798
            'php'	=> 'text/html',
799
            'css'	=> 'text/css',
800
            'js'	=> 'application/javascript',
801
            'json'	=> 'application/json',
802
            'xml'	=> 'application/xml',
803
            'swf'	=> 'application/x-shockwave-flash',
804
            'flv'	=> 'video/x-flv',
805
806
            // images
807
            'png'	=> 'image/png',
808
            'jpe'	=> 'image/jpeg',
809
            'jpeg'	=> 'image/jpeg',
810
            'jpg'	=> 'image/jpeg',
811
            'gif'	=> 'image/gif',
812
            'bmp'	=> 'image/bmp',
813
            'ico'	=> 'image/vnd.microsoft.icon',
814
            'tiff'	=> 'image/tiff',
815
            'tif'	=> 'image/tiff',
816
            'svg'	=> 'image/svg+xml',
817
            'svgz'	=> 'image/svg+xml',
818
819
            // archives
820
            'zip'	=> 'application/zip',
821
            'rar'	=> 'application/x-rar-compressed',
822
            'exe'	=> 'application/x-msdownload',
823
            'msi'	=> 'application/x-msdownload',
824
            'cab'	=> 'application/vnd.ms-cab-compressed',
825
826
            // audio/video
827
            'mp3'	=> 'audio/mpeg',
828
            'mp4'	=> 'audio/mpeg',
829
            'qt'	=> 'video/quicktime',
830
            'mov'	=> 'video/quicktime',
831
832
            // adobe
833
            'pdf'	=> 'application/pdf',
834
            'psd'	=> 'image/vnd.adobe.photoshop',
835
            'ai'	=> 'application/postscript',
836
            'eps'	=> 'application/postscript',
837
            'ps'	=> 'application/postscript',
838
839
            // ms office
840
            'doc'	=> 'application/msword',
841
            'rtf'	=> 'application/rtf',
842
            'xls'	=> 'application/vnd.ms-excel',
843
            'ppt'	=> 'application/vnd.ms-powerpoint',
844
845
            // open office
846
            'odt'	=> 'application/vnd.oasis.opendocument.text',
847
            'ods'	=> 'application/vnd.oasis.opendocument.spreadsheet',
848
        );
849
        $temp = explode('.',$filename);
850
        $ext = strtolower(array_pop($temp));
851 1495 DarkViper
        if (array_key_exists($ext, $mime_types)) {
852 1352 Luisehahne
            return $mime_types[$ext];
853 1495 DarkViper
        }elseif (function_exists('finfo_open')) {
854 1352 Luisehahne
            $finfo = finfo_open(FILEINFO_MIME);
855
            $mimetype = finfo_file($finfo, $filename);
856
            finfo_close($finfo);
857
            return $mimetype;
858 1495 DarkViper
        }else {
859 1352 Luisehahne
            return 'application/octet-stream';
860
        }
861
    }
862
}
863
864
// Generate a thumbnail from an image
865
function make_thumb($source, $destination, $size)
866
{
867
	// Check if GD is installed
868 1365 Luisehahne
	if(extension_loaded('gd') && function_exists('imageCreateFromJpeg'))
869 1352 Luisehahne
	{
870
		// First figure out the size of the thumbnail
871
		list($original_x, $original_y) = getimagesize($source);
872 1495 DarkViper
		if ($original_x > $original_y) {
873 1352 Luisehahne
			$thumb_w = $size;
874
			$thumb_h = $original_y*($size/$original_x);
875
		}
876 1495 DarkViper
		if ($original_x < $original_y) {
877 1352 Luisehahne
			$thumb_w = $original_x*($size/$original_y);
878
			$thumb_h = $size;
879
		}
880 1495 DarkViper
		if ($original_x == $original_y) {
881 1352 Luisehahne
			$thumb_w = $size;
882 1495 DarkViper
			$thumb_h = $size;
883 1352 Luisehahne
		}
884
		// Now make the thumbnail
885
		$source = imageCreateFromJpeg($source);
886
		$dst_img = ImageCreateTrueColor($thumb_w, $thumb_h);
887
		imagecopyresampled($dst_img,$source,0,0,0,0,$thumb_w,$thumb_h,$original_x,$original_y);
888
		imagejpeg($dst_img, $destination);
889
		// Clear memory
890
		imagedestroy($dst_img);
891
		imagedestroy($source);
892
	   // Return true
893
		return true;
894
	} else {
895
		return false;
896
	}
897
}
898
899
/*
900
 * Function to work-out a single part of an octal permission value
901
 *
902
 * @param mixed $octal_value: an octal value as string (i.e. '0777') or real octal integer (i.e. 0777 | 777)
903
 * @param string $who: char or string for whom the permission is asked( U[ser] / G[roup] / O[thers] )
904
 * @param string $action: char or string with the requested action( r[ead..] / w[rite..] / e|x[ecute..] )
905
 * @return boolean
906
 */
907
function extract_permission($octal_value, $who, $action)
908
{
909
	// Make sure that all arguments are set and $octal_value is a real octal-integer
910 1495 DarkViper
	if(($who == '') || ($action == '') || (preg_match( '/[^0-7]/', (string)$octal_value ))) {
911 1352 Luisehahne
		return false; // invalid argument, so return false
912
	}
913
	// convert $octal_value into a decimal-integer to be sure having a valid value
914
	$right_mask = octdec($octal_value);
915
	$action_mask = 0;
916
	// set the $action related bit in $action_mask
917 1495 DarkViper
	switch($action[0]) { // get action from first char of $action
918 1352 Luisehahne
		case 'r':
919
		case 'R':
920
			$action_mask = 4; // set read-bit only (2^2)
921
			break;
922
		case 'w':
923
		case 'W':
924
			$action_mask = 2; // set write-bit only (2^1)
925
			break;
926
		case 'e':
927
		case 'E':
928
		case 'x':
929
		case 'X':
930
			$action_mask = 1; // set execute-bit only (2^0)
931
			break;
932
		default:
933
			return false; // undefined action name, so return false
934
	}
935
	// shift action-mask into the right position
936 1495 DarkViper
	switch($who[0]) { // get who from first char of $who
937 1352 Luisehahne
		case 'u':
938
		case 'U':
939
			$action_mask <<= 3; // shift left 3 bits
940
		case 'g':
941
		case 'G':
942
			$action_mask <<= 3; // shift left 3 bits
943
		case 'o':
944
		case 'O':
945
			/* NOP */
946
			break;
947
		default:
948
			return false; // undefined who, so return false
949
	}
950
	return( ($right_mask & $action_mask) != 0 ); // return result of binary-AND
951
}
952
953
// Function to delete a page
954 1365 Luisehahne
	function delete_page($page_id)
955 1352 Luisehahne
	{
956 1365 Luisehahne
		global $admin, $database, $MESSAGE;
957
		// Find out more about the page
958 1495 DarkViper
		$sql  = 'SELECT `page_id`, `menu_title`, `page_title`, `level`, ';
959
		$sql .=        '`link`, `parent`, `modified_by`, `modified_when` ';
960
		$sql .= 'FROM `'.TABLE_PREFIX.'pages` WHERE `page_id`='.$page_id;
961 1365 Luisehahne
		$results = $database->query($sql);
962
		if($database->is_error())    { $admin->print_error($database->get_error()); }
963 1759 Luisehahne
		if($results->numRows() == 0) { $admin->print_error($MESSAGE['PAGES_NOT_FOUND']); }
964
		$results_array = $results->fetchRow(MYSQL_ASSOC);
965 1365 Luisehahne
		$parent     = $results_array['parent'];
966
		$level      = $results_array['level'];
967
		$link       = $results_array['link'];
968
		$page_title = $results_array['page_title'];
969
		$menu_title = $results_array['menu_title'];
970
		// Get the sections that belong to the page
971 1495 DarkViper
		$sql  = 'SELECT `section_id`, `module` FROM `'.TABLE_PREFIX.'sections` ';
972
		$sql .= 'WHERE `page_id`='.$page_id;
973 1365 Luisehahne
		$query_sections = $database->query($sql);
974
		if($query_sections->numRows() > 0)
975 1352 Luisehahne
		{
976 1495 DarkViper
			while($section = $query_sections->fetchRow()) {
977 1365 Luisehahne
				// Set section id
978
				$section_id = $section['section_id'];
979
				// Include the modules delete file if it exists
980 1495 DarkViper
				if(file_exists(WB_PATH.'/modules/'.$section['module'].'/delete.php')) {
981 1365 Luisehahne
					include(WB_PATH.'/modules/'.$section['module'].'/delete.php');
982
				}
983 1352 Luisehahne
			}
984
		}
985 1365 Luisehahne
		// Update the pages table
986 1495 DarkViper
		$sql = 'DELETE FROM `'.TABLE_PREFIX.'pages` WHERE `page_id`='.$page_id;
987 1365 Luisehahne
		$database->query($sql);
988 1495 DarkViper
		if($database->is_error()) {
989 1365 Luisehahne
			$admin->print_error($database->get_error());
990
		}
991
		// Update the sections table
992 1495 DarkViper
		$sql = 'DELETE FROM `'.TABLE_PREFIX.'sections` WHERE `page_id`='.$page_id;
993 1365 Luisehahne
		$database->query($sql);
994
		if($database->is_error()) {
995
			$admin->print_error($database->get_error());
996
		}
997
		// Include the ordering class or clean-up ordering
998
		include_once(WB_PATH.'/framework/class.order.php');
999
		$order = new order(TABLE_PREFIX.'pages', 'position', 'page_id', 'parent');
1000
		$order->clean($parent);
1001
		// Unlink the page access file and directory
1002
		$directory = WB_PATH.PAGES_DIRECTORY.$link;
1003
		$filename = $directory.PAGE_EXTENSION;
1004
		$directory .= '/';
1005
		if(file_exists($filename))
1006
		{
1007 1495 DarkViper
			if(!is_writable(WB_PATH.PAGES_DIRECTORY.'/')) {
1008 1759 Luisehahne
				$admin->print_error($MESSAGE['PAGES_CANNOT_DELETE_ACCESS_FILE']);
1009 1495 DarkViper
			}else {
1010 1365 Luisehahne
				unlink($filename);
1011
				if( file_exists($directory) &&
1012
				   (rtrim($directory,'/') != WB_PATH.PAGES_DIRECTORY) &&
1013
				   (substr($link, 0, 1) != '.'))
1014
				{
1015
					rm_full_dir($directory);
1016
				}
1017
			}
1018
		}
1019 1352 Luisehahne
	}
1020 1365 Luisehahne
1021
/*
1022
 * @param string $file: name of the file to read
1023
 * @param int $size: number of maximum bytes to read (0 = complete file)
1024
 * @return string: the content as string, false on error
1025
 */
1026
	function getFilePart($file, $size = 0)
1027 1352 Luisehahne
	{
1028 1365 Luisehahne
		$file_content = '';
1029
		if( file_exists($file) && is_file($file) && is_readable($file))
1030 1352 Luisehahne
		{
1031 1495 DarkViper
			if($size == 0) {
1032 1365 Luisehahne
				$size = filesize($file);
1033
			}
1034 1495 DarkViper
			if(($fh = fopen($file, 'rb'))) {
1035
				if( ($file_content = fread($fh, $size)) !== false ) {
1036 1365 Luisehahne
					return $file_content;
1037
				}
1038
				fclose($fh);
1039
			}
1040 1352 Luisehahne
		}
1041 1365 Luisehahne
		return false;
1042
	}
1043
1044
	/**
1045
	* replace varnames with values in a string
1046
	*
1047
	* @param string $subject: stringvariable with vars placeholder
1048
	* @param array $replace: values to replace vars placeholder
1049
	* @return string
1050
	*/
1051
    function replace_vars($subject = '', &$replace = null )
1052
    {
1053
		if(is_array($replace))
1054 1352 Luisehahne
		{
1055 1495 DarkViper
			foreach ($replace  as $key => $value) {
1056 1365 Luisehahne
				$subject = str_replace("{{".$key."}}", $value, $subject);
1057 1352 Luisehahne
			}
1058
		}
1059 1365 Luisehahne
		return $subject;
1060
    }
1061 1352 Luisehahne
1062
// Load module into DB
1063
function load_module($directory, $install = false)
1064
{
1065
	global $database,$admin,$MESSAGE;
1066 1365 Luisehahne
	$retVal = false;
1067
	if(is_dir($directory) && file_exists($directory.'/info.php'))
1068 1352 Luisehahne
	{
1069
		require($directory.'/info.php');
1070
		if(isset($module_name))
1071
		{
1072 1365 Luisehahne
			if(!isset($module_license)) { $module_license = 'GNU General Public License'; }
1073
			if(!isset($module_platform) && isset($module_designed_for)) { $module_platform = $module_designed_for; }
1074
			if(!isset($module_function) && isset($module_type)) { $module_function = $module_type; }
1075 1352 Luisehahne
			$module_function = strtolower($module_function);
1076
			// Check that it doesn't already exist
1077 1365 Luisehahne
			$sqlwhere = 'WHERE `type` = \'module\' AND `directory` = \''.$module_directory.'\'';
1078
			$sql  = 'SELECT COUNT(*) FROM `'.TABLE_PREFIX.'addons` '.$sqlwhere;
1079 1495 DarkViper
			if( $database->get_one($sql) ) {
1080 1365 Luisehahne
				$sql  = 'UPDATE `'.TABLE_PREFIX.'addons` SET ';
1081
			}else{
1082 1352 Luisehahne
				// Load into DB
1083
				$sql  = 'INSERT INTO `'.TABLE_PREFIX.'addons` SET ';
1084 1365 Luisehahne
				$sqlwhere = '';
1085
			}
1086 1495 DarkViper
			$sql .= '`directory`=\''.$module_directory.'\', ';
1087
			$sql .= '`name`=\''.$module_name.'\', ';
1088
			$sql .= '`description`=\''.addslashes($module_description).'\', ';
1089
			$sql .= '`type`=\'module\', ';
1090
			$sql .= '`function`=\''.$module_function.'\', ';
1091
			$sql .= '`version`=\''.$module_version.'\', ';
1092
			$sql .= '`platform`=\''.$module_platform.'\', ';
1093
			$sql .= '`author`=\''.addslashes($module_author).'\', ';
1094
			$sql .= '`license`=\''.addslashes($module_license).'\'';
1095 1365 Luisehahne
			$sql .= $sqlwhere;
1096 1765 Luisehahne
			$retVal = intval($database->query($sql) ? true : false);
1097 1365 Luisehahne
			// Run installation script
1098 1495 DarkViper
			if($install == true) {
1099
				if(file_exists($directory.'/install.php')) {
1100 1365 Luisehahne
					require($directory.'/install.php');
1101 1352 Luisehahne
				}
1102
			}
1103
		}
1104 1765 Luisehahne
        return $retVal;
1105 1352 Luisehahne
	}
1106
}
1107
1108
// Load template into DB
1109
function load_template($directory)
1110
{
1111
	global $database, $admin;
1112 1365 Luisehahne
	$retVal = false;
1113
	if(is_dir($directory) && file_exists($directory.'/info.php'))
1114 1352 Luisehahne
	{
1115
		require($directory.'/info.php');
1116
		if(isset($template_name))
1117
		{
1118 1495 DarkViper
			if(!isset($template_license)) {
1119 1352 Luisehahne
              $template_license = 'GNU General Public License';
1120
            }
1121 1495 DarkViper
			if(!isset($template_platform) && isset($template_designed_for)) {
1122 1352 Luisehahne
              $template_platform = $template_designed_for;
1123
            }
1124 1495 DarkViper
			if(!isset($template_function)) {
1125 1352 Luisehahne
              $template_function = 'template';
1126
            }
1127
			// Check that it doesn't already exist
1128 1495 DarkViper
			$sqlwhere = 'WHERE `type`=\'template\' AND `directory`=\''.$template_directory.'\'';
1129 1365 Luisehahne
			$sql  = 'SELECT COUNT(*) FROM `'.TABLE_PREFIX.'addons` '.$sqlwhere;
1130 1495 DarkViper
			if( $database->get_one($sql) ) {
1131 1365 Luisehahne
				$sql  = 'UPDATE `'.TABLE_PREFIX.'addons` SET ';
1132
			}else{
1133 1352 Luisehahne
				// Load into DB
1134
				$sql  = 'INSERT INTO `'.TABLE_PREFIX.'addons` SET ';
1135 1365 Luisehahne
				$sqlwhere = '';
1136 1352 Luisehahne
			}
1137 1495 DarkViper
			$sql .= '`directory`=\''.$template_directory.'\', ';
1138
			$sql .= '`name`=\''.$template_name.'\', ';
1139
			$sql .= '`description`=\''.addslashes($template_description).'\', ';
1140
			$sql .= '`type`=\'template\', ';
1141
			$sql .= '`function`=\''.$template_function.'\', ';
1142
			$sql .= '`version`=\''.$template_version.'\', ';
1143
			$sql .= '`platform`=\''.$template_platform.'\', ';
1144
			$sql .= '`author`=\''.addslashes($template_author).'\', ';
1145
			$sql .= '`license`=\''.addslashes($template_license).'\' ';
1146 1365 Luisehahne
			$sql .= $sqlwhere;
1147 1765 Luisehahne
			$retVal = intval($database->query($sql) ? true : false);
1148 1352 Luisehahne
		}
1149
	}
1150 1365 Luisehahne
	return $retVal;
1151 1352 Luisehahne
}
1152
1153
// Load language into DB
1154
function load_language($file)
1155
{
1156
	global $database,$admin;
1157 1365 Luisehahne
	$retVal = false;
1158 1352 Luisehahne
	if (file_exists($file) && preg_match('#^([A-Z]{2}.php)#', basename($file)))
1159
	{
1160 1365 Luisehahne
		// require($file);  it's to large
1161
		// read contents of the template language file into string
1162
		$data = @file_get_contents(WB_PATH.'/languages/'.str_replace('.php','',basename($file)).'.php');
1163
		// use regular expressions to fetch the content of the variable from the string
1164 1435 Luisehahne
		$language_name = get_variable_content('language_name', $data, false, false);
1165
		$language_code = get_variable_content('language_code', $data, false, false);
1166
		$language_author = get_variable_content('language_author', $data, false, false);
1167
		$language_version = get_variable_content('language_version', $data, false, false);
1168
		$language_platform = get_variable_content('language_platform', $data, false, false);
1169 1365 Luisehahne
1170 1352 Luisehahne
		if(isset($language_name))
1171
		{
1172 1365 Luisehahne
			if(!isset($language_license)) { $language_license = 'GNU General Public License'; }
1173
			if(!isset($language_platform) && isset($language_designed_for)) { $language_platform = $language_designed_for; }
1174 1352 Luisehahne
			// Check that it doesn't already exist
1175 1495 DarkViper
			$sqlwhere = 'WHERE `type`=\'language\' AND `directory`=\''.$language_code.'\'';
1176 1365 Luisehahne
			$sql  = 'SELECT COUNT(*) FROM `'.TABLE_PREFIX.'addons` '.$sqlwhere;
1177 1495 DarkViper
			if( $database->get_one($sql) ) {
1178 1365 Luisehahne
				$sql  = 'UPDATE `'.TABLE_PREFIX.'addons` SET ';
1179
			}else{
1180 1352 Luisehahne
				// Load into DB
1181
				$sql  = 'INSERT INTO `'.TABLE_PREFIX.'addons` SET ';
1182 1365 Luisehahne
				$sqlwhere = '';
1183 1352 Luisehahne
			}
1184 1495 DarkViper
			$sql .= '`directory`=\''.$language_code.'\', ';
1185
			$sql .= '`name`=\''.$language_name.'\', ';
1186 1747 Luisehahne
            $sql .= '`description`=\'\', ';
1187
			$sql .= '`function`=\'\', ';
1188 1495 DarkViper
			$sql .= '`type`=\'language\', ';
1189
			$sql .= '`version`=\''.$language_version.'\', ';
1190
			$sql .= '`platform`=\''.$language_platform.'\', ';
1191
			$sql .= '`author`=\''.addslashes($language_author).'\', ';
1192
			$sql .= '`license`=\''.addslashes($language_license).'\' ';
1193 1365 Luisehahne
			$sql .= $sqlwhere;
1194 1765 Luisehahne
			$retVal = intval($database->query($sql) ? true : false);
1195 1352 Luisehahne
		}
1196
	}
1197 1365 Luisehahne
	return $retVal;
1198 1352 Luisehahne
}
1199
1200
// Upgrade module info in DB, optionally start upgrade script
1201
function upgrade_module($directory, $upgrade = false)
1202
{
1203
	global $database, $admin, $MESSAGE, $new_module_version;
1204
	$mod_directory = WB_PATH.'/modules/'.$directory;
1205
	if(file_exists($mod_directory.'/info.php'))
1206
	{
1207
		require($mod_directory.'/info.php');
1208
		if(isset($module_name))
1209
		{
1210 1365 Luisehahne
			if(!isset($module_license)) { $module_license = 'GNU General Public License'; }
1211 1352 Luisehahne
			if(!isset($module_platform) && isset($module_designed_for)) { $module_platform = $module_designed_for; }
1212 1365 Luisehahne
			if(!isset($module_function) && isset($module_type)) { $module_function = $module_type; }
1213 1352 Luisehahne
			$module_function = strtolower($module_function);
1214
			// Check that it does already exist
1215
			$sql  = 'SELECT COUNT(*) FROM `'.TABLE_PREFIX.'addons` ';
1216 1495 DarkViper
			$sql .= 'WHERE `directory`=\''.$module_directory.'\'';
1217 1352 Luisehahne
			if( $database->get_one($sql) )
1218
			{
1219
				// Update in DB
1220
				$sql  = 'UPDATE `'.TABLE_PREFIX.'addons` SET ';
1221 1495 DarkViper
				$sql .= '`version`=\''.$module_version.'\', ';
1222
				$sql .= '`description`=\''.addslashes($module_description).'\', ';
1223
				$sql .= '`platform`=\''.$module_platform.'\', ';
1224
				$sql .= '`author`=\''.addslashes($module_author).'\', ';
1225
				$sql .= '`license`=\''.addslashes($module_license).'\' ';
1226
				$sql .= 'WHERE `directory`=\''.$module_directory.'\' ';
1227 1352 Luisehahne
				$database->query($sql);
1228
				if($database->is_error()) {
1229
					$admin->print_error($database->get_error());
1230
				}
1231
				// Run upgrade script
1232 1495 DarkViper
				if($upgrade == true) {
1233
					if(file_exists($mod_directory.'/upgrade.php')) {
1234 1352 Luisehahne
						require($mod_directory.'/upgrade.php');
1235
					}
1236
				}
1237
			}
1238
		}
1239
	}
1240
}
1241
1242
// extracts the content of a string variable from a string (save alternative to including files)
1243
if(!function_exists('get_variable_content'))
1244
{
1245
	function get_variable_content($search, $data, $striptags=true, $convert_to_entities=true)
1246
	{
1247
		$match = '';
1248
		// search for $variable followed by 0-n whitespace then by = then by 0-n whitespace
1249
		// then either " or ' then 0-n characters then either " or ' followed by 0-n whitespace and ;
1250
		// the variable name is returned in $match[1], the content in $match[3]
1251
		if (preg_match('/(\$' .$search .')\s*=\s*("|\')(.*)\2\s*;/', $data, $match))
1252
		{
1253 1495 DarkViper
			if(strip_tags(trim($match[1])) == '$' .$search) {
1254 1352 Luisehahne
				// variable name matches, return it's value
1255
				$match[3] = ($striptags == true) ? strip_tags($match[3]) : $match[3];
1256
				$match[3] = ($convert_to_entities == true) ? htmlentities($match[3]) : $match[3];
1257
				return $match[3];
1258
			}
1259
		}
1260
		return false;
1261
	}
1262
}
1263
1264 1365 Luisehahne
/*
1265
 * @param string $modulname: like saved in addons.directory
1266
 * @param boolean $source: true reads from database, false from info.php
1267
 * @return string:  the version as string, if not found returns null
1268
 */
1269
1270
	function get_modul_version($modulname, $source = true)
1271
	{
1272
		global $database;
1273
		$version = null;
1274
		if( $source != true )
1275
		{
1276 1495 DarkViper
			$sql  = 'SELECT `version` FROM `'.TABLE_PREFIX.'addons` ';
1277
			$sql .= 'WHERE `directory`=\''.$modulname.'\'';
1278 1365 Luisehahne
			$version = $database->get_one($sql);
1279
		} else {
1280
			$info_file = WB_PATH.'/modules/'.$modulname.'/info.php';
1281 1495 DarkViper
			if(file_exists($info_file)) {
1282
				if(($info_file = file_get_contents($info_file))) {
1283 1365 Luisehahne
					$version = get_variable_content('module_version', $info_file, false, false);
1284
					$version = ($version !== false) ? $version : null;
1285
				}
1286
			}
1287
		}
1288
		return $version;
1289
	}
1290
1291
/*
1292
 * @param string $varlist: commaseperated list of varnames to move into global space
1293
 * @return bool:  false if one of the vars already exists in global space (error added to msgQueue)
1294
 */
1295
	function vars2globals_wrapper($varlist)
1296
	{
1297
		$retval = true;
1298
		if( $varlist != '')
1299
		{
1300
			$vars = explode(',', $varlist);
1301
			foreach( $vars as $var)
1302
			{
1303 1495 DarkViper
				if( isset($GLOBALS[$var]) ){
1304 1365 Luisehahne
					ErrorLog::write( 'variabe $'.$var.' already defined in global space!!',__FILE__, __FUNCTION__, __LINE__);
1305
					$retval = false;
1306 1495 DarkViper
				}else {
1307 1365 Luisehahne
					global $$var;
1308
				}
1309
			}
1310
		}
1311
		return $retval;
1312
	}
1313
1314 1400 FrankH
/*
1315
 * filter directory traversal more thoroughly, thanks to hal 9000
1316
 * @param string $dir: directory relative to MEDIA_DIRECTORY
1317
 * @param bool $with_media_dir: true when to include MEDIA_DIRECTORY
1318
 * @return: false if directory traversal detected, real path if not
1319
 */
1320
	function check_media_path($directory, $with_media_dir = true)
1321
	{
1322 1495 DarkViper
		$md = ($with_media_dir) ? MEDIA_DIRECTORY : '';
1323 1400 FrankH
		$dir = realpath(WB_PATH . $md . '/' . utf8_decode($directory));
1324
		$required = realpath(WB_PATH . MEDIA_DIRECTORY);
1325
		if (strstr($dir, $required)) {
1326
			return $dir;
1327
		} else {
1328
			return false;
1329
		}
1330
	}
1331 1475 Luisehahne
1332
/*
1333
urlencode function and rawurlencode are mostly based on RFC 1738.
1334
However, since 2005 the current RFC in use for URIs standard is RFC 3986.
1335
Here is a function to encode URLs according to RFC 3986.
1336
*/
1337
if(!function_exists('url_encode')){
1338
	function url_encode($string) {
1339
	    $string = html_entity_decode($string,ENT_QUOTES,'UTF-8');
1340 1477 Luisehahne
	    $entities = array('%21', '%2A', '%27', '%28', '%29', '%3B', '%3A', '%40', '%26', '%3D', '%2B', '%24', '%2C', '%2F', '%3F', '%25', '%23', '%5B', '%5D');
1341
	    $replacements = array('!', '*', "'", "(", ")", ";", ":", "@", "&", "=", "+", "$", ",", "/", "?", "%", "#", "[", "]");
1342
	    return str_replace($entities,$replacements, rawurlencode($string));
1343 1475 Luisehahne
	}
1344 1705 Luisehahne
}
1345 1765 Luisehahne
1346
if(!function_exists('rebuild_all_accessfiles')){
1347
	function rebuild_all_accessfiles() {
1348
        global $database;
1349
    	$retVal = array();
1350
    	/**
1351
    	 * try to remove access files and build new folder protect files
1352
    	 */
1353
    	$sTempDir = (defined('PAGES_DIRECTORY') && (PAGES_DIRECTORY != '') ? PAGES_DIRECTORY : '');
1354
    	if(($sTempDir!='') && is_writeable(WB_PATH.$sTempDir)==true) {
1355
    	 	if(rm_full_dir (WB_PATH.$sTempDir, true )==false) {
1356
    			$retVal[] = '<span><strong>Could not delete existing access files</strong></span>';
1357
    	 	}
1358
    	}
1359
		$retVal[] = createFolderProtectFile(rtrim( WB_PATH.PAGES_DIRECTORY,'/') );
1360
    	/**
1361
    	 * Reformat/rebuild all existing access files
1362
    	 */
1363
        $sql = 'SELECT `page_id`,`root_parent`,`link`, `level` FROM `'.TABLE_PREFIX.'pages` ORDER BY `link`';
1364
        if (($oPage = $database->query($sql)))
1365
        {
1366
            $x = 0;
1367
            while (($page = $oPage->fetchRow(MYSQL_ASSOC)))
1368
            {
1369
                // Work out level
1370
                $level = level_count($page['page_id']);
1371
                // Work out root parent
1372
                $root_parent = root_parent($page['page_id']);
1373
                // Work out page trail
1374
                $page_trail = get_page_trail($page['page_id']);
1375
                // Update page with new level and link
1376
                $sql  = 'UPDATE `'.TABLE_PREFIX.'pages` SET ';
1377
                $sql .= '`root_parent` = '.$root_parent.', ';
1378
                $sql .= '`level` = '.$level.', ';
1379
                $sql .= '`page_trail` = "'.$page_trail.'" ';
1380
                $sql .= 'WHERE `page_id` = '.$page['page_id'];
1381
1382
                if(!$database->query($sql)) {}
1383
                $filename = WB_PATH.PAGES_DIRECTORY.$page['link'].PAGE_EXTENSION;
1384
                $retVal = create_access_file($filename, $page['page_id'], $page['level']);
1385
                $x++;
1386
            }
1387
            $retVal[] = '<span><strong>Number of new formated access files: '.$x.'</strong></span>';
1388
        }
1389
    return $retVal;
1390
	}
1391
}
1392
1393
if(!function_exists('upgrade_modules')){
1394
	function upgrade_modules($aModuleList) {
1395
        global $database;
1396
    	foreach($aModuleList as $sModul) {
1397
    		if(file_exists(WB_PATH.'/modules/'.$sModul.'/upgrade.php')) {
1398
    			$currModulVersion = get_modul_version ($sModul, false);
1399
    			$newModulVersion =  get_modul_version ($sModul, true);
1400
    			if((version_compare($currModulVersion, $newModulVersion) <= 0)) {
1401
    				require_once(WB_PATH.'/modules/'.$sModul.'/upgrade.php');
1402
    			}
1403
    		}
1404
    	}
1405
    }
1406
}