Project

General

Profile

1
<?php
2
/**
3
 *
4
 * @category        frontend
5
 * @package         account
6
 * @author          WebsiteBaker Project
7
 * @copyright       2004-2009, Ryan Djurovich
8
 * @copyright       2009-2011, Website Baker Org. e.V.
9
 * @link			http://www.websitebaker2.org/
10
 * @license         http://www.gnu.org/licenses/gpl.html
11
 * @platform        WebsiteBaker 2.8.x
12
 * @requirements    PHP 5.2.2 and higher
13
 * @version         $Id: class.admin.php 1441 2011-04-09 23:04:22Z Luisehahne $
14
 * @filesource		$HeadURL: svn://isteam.dynxs.de/wb-archiv/branches/2.8.x/wb/framework/class.admin.php $
15
 * @lastmodified    $Date: 2011-04-10 01:04:22 +0200 (Sun, 10 Apr 2011) $
16
 *
17
 */
18

    
19
// Must include code to stop this file being access directly
20
if(defined('WB_PATH') == false) { die("Cannot access this file directly"); }
21

    
22
require_once(WB_PATH.'/framework/class.wb.php');
23

    
24
// Get WB version
25
require_once(ADMIN_PATH.'/interface/version.php');
26

    
27
// Include EditArea wrapper functions
28
// require_once(WB_PATH . '/include/editarea/wb_wrapper_edit_area.php');
29
require_once(WB_PATH . '/framework/SecureForm.php');
30

    
31

    
32
class admin extends wb {
33
	// Authenticate user then auto print the header
34
	public function __construct($section_name= '##skip##', $section_permission = 'start', $auto_header = true, $auto_auth = true)
35
	{
36
		parent::__construct(SecureForm::BACKEND);
37
	if( $section_name != '##skip##' )
38
	{
39
		global $database, $MESSAGE;
40
		// Specify the current applications name
41
		$this->section_name = $section_name;
42
		$this->section_permission = $section_permission;
43
		// Authenticate the user for this application
44
		if($auto_auth == true)
45
		{
46
			// First check if the user is logged-in
47
			if($this->is_authenticated() == false)
48
			{
49
				header('Location: '.ADMIN_URL.'/login/index.php');
50
				exit(0);
51
			}
52

    
53
			// Now check if they are allowed in this section
54
			if($this->get_permission($section_permission) == false) {
55
				die($MESSAGE['ADMIN']['INSUFFICIENT_PRIVELLIGES']);
56
			}
57
		}
58

    
59
		// Check if the backend language is also the selected language. If not, send headers again.
60
		$get_user_language = @$database->query("SELECT language FROM ".TABLE_PREFIX.
61
			"users WHERE user_id = '" .(int) $this->get_user_id() ."'");
62
		$user_language = ($get_user_language) ? $get_user_language->fetchRow() : '';
63
		// prevent infinite loop if language file is not XX.php (e.g. DE_du.php)
64
		$user_language = substr($user_language[0],0,2);
65
		// obtain the admin folder (e.g. /admin)
66
		$admin_folder = str_replace(WB_PATH, '', ADMIN_PATH);
67
		if((LANGUAGE != $user_language) && file_exists(WB_PATH .'/languages/' .$user_language .'.php')
68
			&& strpos($_SERVER['PHP_SELF'],$admin_folder.'/') !== false) {
69
			// check if page_id is set
70
			$page_id_url = (isset($_GET['page_id'])) ? '&page_id=' .(int) $_GET['page_id'] : '';
71
			$section_id_url = (isset($_GET['section_id'])) ? '&section_id=' .(int) $_GET['section_id'] : '';
72
			if(isset($_SERVER['QUERY_STRING']) && $_SERVER['QUERY_STRING'] != '') { // check if there is an query-string
73
				header('Location: '.$_SERVER['PHP_SELF'] .'?lang='.$user_language .$page_id_url .$section_id_url.'&'.$_SERVER['QUERY_STRING']);
74
			} else {
75
				header('Location: '.$_SERVER['PHP_SELF'] .'?lang='.$user_language .$page_id_url .$section_id_url);
76
			}
77
			exit();
78
		}
79

    
80
		// Auto header code
81
		if($auto_header == true) {
82
			$this->print_header();
83
		}
84
	}
85
	}
86

    
87
	// Print the admin header
88
	function print_header($body_tags = '') {
89
		// Get vars from the language file
90
		global $MENU;
91
		global $MESSAGE;
92
		global $TEXT;
93
		// Connect to database and get website title
94
		global $database;
95
		$get_title = $database->query("SELECT value FROM ".TABLE_PREFIX."settings WHERE name = 'website_title'");
96
		$title = $get_title->fetchRow();
97
		$header_template = new Template(THEME_PATH.'/templates');
98
		$header_template->set_file('page', 'header.htt');
99
		$header_template->set_block('page', 'header_block', 'header');
100
		if(defined('DEFAULT_CHARSET')) {
101
			$charset=DEFAULT_CHARSET;
102
		} else {
103
			$charset='utf-8';
104
		}
105

    
106
		// work out the URL for the 'View menu' link in the WB backend
107
		// if the page_id is set, show this page otherwise show the root directory of WB
108
		$view_url = WB_URL;
109
		if(isset($_GET['page_id'])) {
110
			// extract page link from the database
111
			$result = @$database->query("SELECT link FROM " .TABLE_PREFIX ."pages WHERE page_id = '" .(int) addslashes($_GET['page_id']) ."'");
112
			$row = @$result->fetchRow();
113
			if($row) $view_url .= PAGES_DIRECTORY .$row['link']. PAGE_EXTENSION;
114
		}
115

    
116
		$header_template->set_var(	array(
117
							'SECTION_NAME' => $MENU[strtoupper($this->section_name)],
118
							'BODY_TAGS' => $body_tags,
119
							'WEBSITE_TITLE' => ($title['value']),
120
							'TEXT_ADMINISTRATION' => $TEXT['ADMINISTRATION'],
121
							'CURRENT_USER' => $MESSAGE['START']['CURRENT_USER'],
122
							'DISPLAY_NAME' => $this->get_display_name(),
123
							'CHARSET' => $charset,
124
							'LANGUAGE' => strtolower(LANGUAGE),
125
							'VERSION' => VERSION,
126
							'REVISION' => REVISION,
127
							'WB_URL' => WB_URL,
128
							'ADMIN_URL' => ADMIN_URL,
129
							'THEME_URL' => THEME_URL,
130
							'TITLE_START' => $MENU['START'],
131
							'TITLE_VIEW' => $MENU['VIEW'],
132
							'TITLE_HELP' => $MENU['HELP'],
133
							'TITLE_LOGOUT' =>  $MENU['LOGOUT'],
134
							'URL_VIEW' => $view_url,
135
							'URL_HELP' => 'http://www.websitebaker2.org/',
136
							'BACKEND_MODULE_CSS' => $this->register_backend_modfiles('css'),	// adds backend.css
137
							'BACKEND_MODULE_JS'  => $this->register_backend_modfiles('js')		// adds backend.js
138
						)
139
					);
140

    
141
		// Create the menu
142
		$menu = array(
143
					array(ADMIN_URL.'/pages/index.php', '', $MENU['PAGES'], 'pages', 1),
144
					array(ADMIN_URL.'/media/index.php', '', $MENU['MEDIA'], 'media', 1),
145
					array(ADMIN_URL.'/addons/index.php', '', $MENU['ADDONS'], 'addons', 1),
146
					array(ADMIN_URL.'/preferences/index.php', '', $MENU['PREFERENCES'], 'preferences', 0),
147
					array(ADMIN_URL.'/settings/index.php', '', $MENU['SETTINGS'], 'settings', 1),
148
					array(ADMIN_URL.'/admintools/index.php', '', $MENU['ADMINTOOLS'], 'admintools', 1),
149
					array(ADMIN_URL.'/access/index.php', '', $MENU['ACCESS'], 'access', 1)
150
					);
151
		$header_template->set_block('header_block', 'linkBlock', 'link');
152
		foreach($menu AS $menu_item) {
153
			$link = $menu_item[0];
154
			$target = ($menu_item[1] == '') ? '_self' : $menu_item[1];
155
			$title = $menu_item[2];
156
			$permission_title = $menu_item[3];
157
			$required = $menu_item[4];
158
			$replace_old = array(ADMIN_URL, WB_URL, '/', 'index.php');
159
			if($required == false OR $this->get_link_permission($permission_title)) {
160
				$header_template->set_var('LINK', $link);
161
				$header_template->set_var('TARGET', $target);
162
				// If link is the current section apply a class name
163
				if($permission_title == strtolower($this->section_name)) {
164
					$header_template->set_var('CLASS', $menu_item[3] . ' current');
165
				} else {
166
					$header_template->set_var('CLASS', $menu_item[3]);
167
				}
168
				$header_template->set_var('TITLE', $title);
169
				// Print link
170
				$header_template->parse('link', 'linkBlock', true);
171
			}
172
		}
173
		$header_template->parse('header', 'header_block', false);
174
		$header_template->pparse('output', 'page');
175
	}
176
	
177
	// Print the admin footer
178
	function print_footer() {
179
		// include the required file for Javascript admin
180
		if(file_exists(WB_PATH.'/modules/jsadmin/jsadmin_backend_include.php')){
181
		@include(WB_PATH.'/modules/jsadmin/jsadmin_backend_include.php');
182
		}
183
		$footer_template = new Template(THEME_PATH.'/templates');
184
		$footer_template->set_file('page', 'footer.htt');
185
		$footer_template->set_block('page', 'footer_block', 'header');
186
		$footer_template->set_var(array(
187
						'BACKEND_BODY_MODULE_JS' => $this->register_backend_modfiles_body('js'),
188
						'WB_URL' => WB_URL,
189
						'ADMIN_URL' => ADMIN_URL,
190
						'THEME_URL' => THEME_URL,
191
			 ) );
192
		$footer_template->parse('header', 'footer_block', false);
193
		$footer_template->pparse('output', 'page');
194
	}
195
	
196
	// Return a system permission
197
	function get_permission($name, $type = 'system') {
198
		// Append to permission type
199
		$type .= '_permissions';
200
		// Check if we have a section to check for
201
		if($name == 'start') {
202
			return true;
203
		} else {
204
			// Set system permissions var
205
			$system_permissions = $this->get_session('SYSTEM_PERMISSIONS');
206
			// Set module permissions var
207
			$module_permissions = $this->get_session('MODULE_PERMISSIONS');
208
			// Set template permissions var
209
			$template_permissions = $this->get_session('TEMPLATE_PERMISSIONS');
210
			// Return true if system perm = 1
211
			if (isset($$type) && is_array($$type) && is_numeric(array_search($name, $$type))) {
212
				if($type == 'system_permissions') {
213
					return true;
214
				} else {
215
					return false;
216
				}
217
			} else {
218
				if($type == 'system_permissions') {
219
					return false;
220
				} else {
221
					return true;
222
				}
223
			}
224
		}
225
	}
226
/*
227
	function get_user_details($user_id) {
228
		global $database;
229
		$sql  = 'SELECT * FROM `'.TABLE_PREFIX.'users` ';
230
		$sql .= 'WHERE `user_id`='.(int)$user_id.' LIMIT 1';
231
		if(($resUser = $database->query($sql))){
232
			if(!($recUser = $resUser->fetchRow())) {
233
				$recUser['display_name'] = 'Unknown';
234
				$recUser['username'] = 'unknown';
235
			}
236
		}
237
		return $recUser;
238
	}
239
*/
240
 function get_user_details($user_id) {
241
  global $database;
242
  $retval = array('username'=>'unknown','display_name'=>'Unknown','email'=>'');
243
  $sql  = 'SELECT `username`,`display_name`,`email` ';
244
  $sql .= 'FROM `'.TABLE_PREFIX.'users` ';
245
  $sql .= 'WHERE `user_id`='.(int)$user_id.' ';
246
  // $sql .= 'AND (`statusflags` & '.USERS_DELETED.') > 0';
247
  if( ($resUsers = $database->query($sql)) ) {
248
   if( ($recUser = $resUsers->fetchRow()) ) {
249
    $retval = $recUser;
250
   }
251
  }
252
  return $retval;
253
 }
254

    
255
    //
256
	function get_section_details( $section_id, $backLink = 'index.php' ) {
257
	global $database, $TEXT;
258
		$sql  = 'SELECT * FROM `'.TABLE_PREFIX.'sections` ';
259
		$sql .= 'WHERE `section_id`='.intval($section_id).' LIMIT 1';
260
		if(($resSection = $database->query($sql))){
261
			if(!($recSection = $resSection->fetchRow())) {
262
				$this->print_header();
263
				$this->print_error($TEXT['SECTION'].' '.$TEXT['NOT_FOUND'], $backLink, true);
264
			}
265
			} else {
266
				$this->print_header();
267
				$this->print_error($database->get_error(), $backLink, true);
268
			}
269
		return $recSection;
270
	}
271

    
272
	function get_page_details( $page_id, $backLink = 'index.php' ) {
273
	  global $database, $TEXT;
274
	  $sql  = 'SELECT * FROM `'.TABLE_PREFIX.'pages` ';
275
	  $sql .= 'WHERE `page_id`='.(int)$page_id.' LIMIT 1';
276
	  if(($resPages = $database->query($sql))){
277
	   if(!($recPage = $resPages->fetchRow())) {
278
	    $this->print_header();
279
	    $this->print_error($TEXT['PAGE'].' '.$TEXT['NOT_FOUND'], $backLink, true);
280
	   }
281
	  } else {
282
	   $this->print_header();
283
	   $this->print_error($database->get_error(), $backLink, true);
284
	  }
285
	  return $recPage;
286
	 }
287

    
288
	/** Function get_page_permission takes either a numerical page_id,
289
	 * upon which it looks up the permissions in the database,
290
	 * or an array with keys admin_groups and admin_users
291
	 */
292
/*
293
	function get_page_permission($page,$action='admin') {
294
		if ($action!='viewing') $action='admin';
295
		$action_groups=$action.'_groups';
296
		$action_users=$action.'_users';
297
		if (is_array($page)) {
298
				$groups=$page[$action_groups];
299
				$users=$page[$action_users];
300
		} else {
301
			global $database;
302
			$results = $database->query("SELECT $action_groups,$action_users FROM ".TABLE_PREFIX."pages WHERE page_id = '$page'");
303
			$result = $results->fetchRow();
304
			$groups = explode(',', str_replace('_', '', $result[$action_groups]));
305
			$users = explode(',', str_replace('_', '', $result[$action_users]));
306
		}
307

    
308
		$in_group = FALSE;
309
		foreach($this->get_groups_id() as $cur_gid){
310
		    if (in_array($cur_gid, $groups)) {
311
		        $in_group = TRUE;
312
		    }
313
		}
314
		if((!$in_group) AND !is_numeric(array_search($this->get_user_id(), $users))) {
315
			return false;
316
		}
317
		return true;
318
	}
319
*/
320

    
321
	function get_page_permission($page,$action='admin') {
322
		if($action != 'viewing') { $action = 'admin'; }
323
		$action_groups = $action.'_groups';
324
		$action_users  = $action.'_users';
325
		$groups = $users = '0';
326
		if(is_array($page)) {
327
			$groups = $page[$action_groups];
328
			$users  = $page[$action_users];
329
		} else {
330
			global $database;
331
			$sql  = 'SELECT `'.$action_groups.'`,`'.$action_users.'` ';
332
			$sql .= 'FROM `'.TABLE_PREFIX.'pages` ';
333
			$sql .= 'WHERE `page_id`='.(int)$page;
334
			if( ($res = $database->query($sql)) ) {
335
				if( ($rec = $res->fetchRow()) ) {
336
					$groups = $rec[$action_groups];
337
					$users  = $rec[$action_users];
338
				}
339
			}
340
		}
341
		return ($this->ami_group_member($groups) || $this->is_group_match($this->get_user_id(), $users));
342
	}
343

    
344
	// Returns a system permission for a menu link
345
	function get_link_permission($title) {
346
		$title = str_replace('_blank', '', $title);
347
		$title = strtolower($title);
348
		// Set system permissions var
349
		$system_permissions = $this->get_session('SYSTEM_PERMISSIONS');
350
		// Set module permissions var
351
		$module_permissions = $this->get_session('MODULE_PERMISSIONS');
352
		if($title == 'start') {
353
			return true;
354
		} else {
355
			// Return true if system perm = 1
356
			if(is_numeric(array_search($title, $system_permissions))) {
357
				return true;
358
			} else {
359
				return false;
360
			}
361
		}
362
	}
363

    
364
	// Function to add optional module Javascript or CSS stylesheets into the <body> section of the backend
365
	function register_backend_modfiles_body($file_id="js")
366
		{
367
		// sanity check of parameter passed to the function
368
		$file_id = strtolower($file_id);
369
		if($file_id !== "javascript" && $file_id !== "js")
370
		{
371
			return;
372
		}
373
		global $database;
374
        $body_links = "";
375
		// define default baselink and filename for optional module javascript and stylesheet files
376
		if($file_id == "js") {
377
			$base_link = '<script src="'.WB_URL.'/modules/{MODULE_DIRECTORY}/backend_body.js" type="text/javascript"></script>';
378
			$base_file = "backend_body.js";
379
		}
380
		// check if backend_body.js files needs to be included to the <body></body> section of the backend
381
		if(isset($_GET['tool']))
382
			{
383
			// check if displayed page contains a installed admin tool
384
			$result = $database->query("SELECT * FROM " .TABLE_PREFIX ."addons
385
				WHERE type = 'module' AND function = 'tool' AND directory = '".addslashes($_GET['tool'])."'");
386
			if($result->numRows())
387
				{
388
				// check if admin tool directory contains a backend_body.js file to include
389
				$tool = $result->fetchRow();
390
				if(file_exists(WB_PATH ."/modules/" .$tool['directory'] ."/$base_file"))
391
				{
392
					// return link to the backend_body.js file
393
					return str_replace("{MODULE_DIRECTORY}", $tool['directory'], $base_link);
394
				}
395
			}
396
		} elseif(isset($_GET['page_id']) or isset($_POST['page_id']))
397
		{
398
			// check if displayed page in the backend contains a page module
399
			if (isset($_GET['page_id']))
400
			{
401
				$page_id = (int) addslashes($_GET['page_id']);
402
			} else {
403
				$page_id = (int) addslashes($_POST['page_id']);
404
			}
405
			// gather information for all models embedded on actual page
406
			$query_modules = $database->query("SELECT module FROM " .TABLE_PREFIX ."sections
407
				WHERE page_id=$page_id");
408
			while($row = $query_modules->fetchRow()) {
409
				// check if page module directory contains a backend_body.js file
410
				if(file_exists(WB_PATH ."/modules/" .$row['module'] ."/$base_file")) {
411
					// create link with backend_body.js source for the current module
412
					$tmp_link = str_replace("{MODULE_DIRECTORY}", $row['module'], $base_link);
413
					// ensure that backend_body.js is only added once per module type
414
					if(strpos($body_links, $tmp_link) === false) {
415
						$body_links .= $tmp_link ."\n";
416
					}
417
				}
418
			}
419
			// write out links with all external module javascript/CSS files, remove last line feed
420
			return rtrim($body_links);
421
		}
422
	}
423

    
424

    
425
	// Function to add optional module Javascript or CSS stylesheets into the <head> section of the backend
426
	function register_backend_modfiles($file_id="css") {
427
		// sanity check of parameter passed to the function
428
		$file_id = strtolower($file_id);
429
		if($file_id !== "css" && $file_id !== "javascript" && $file_id !== "js") {
430
			return;
431
		}
432

    
433
		global $database;
434
		// define default baselink and filename for optional module javascript and stylesheet files
435
		$head_links = "";
436
		if($file_id == "css") {
437
      	$base_link = '<link href="'.WB_URL.'/modules/{MODULE_DIRECTORY}/backend.css"';
438
			$base_link.= ' rel="stylesheet" type="text/css" media="screen" />';
439
			$base_file = "backend.css";
440
		} else {
441
			$base_link = '<script src="'.WB_URL.'/modules/{MODULE_DIRECTORY}/backend.js" type="text/javascript"></script>';
442
			$base_file = "backend.js";
443
		}
444

    
445
		// check if backend.js or backend.css files needs to be included to the <head></head> section of the backend
446
		if(isset($_GET['tool'])) {
447
			// check if displayed page contains a installed admin tool
448
			$result = $database->query("SELECT * FROM " .TABLE_PREFIX ."addons
449
				WHERE type = 'module' AND function = 'tool' AND directory = '".addslashes($_GET['tool'])."'");
450

    
451
			if($result->numRows()) {
452
				// check if admin tool directory contains a backend.js or backend.css file to include
453
				$tool = $result->fetchRow();
454
				if(file_exists(WB_PATH ."/modules/" .$tool['directory'] ."/$base_file")) {
455
        			// return link to the backend.js or backend.css file
456
					return str_replace("{MODULE_DIRECTORY}", $tool['directory'], $base_link);
457
				}
458
			}
459
		} elseif(isset($_GET['page_id']) || isset($_POST['page_id'])) {
460
			// check if displayed page in the backend contains a page module
461
			if (isset($_GET['page_id'])) {
462
				$page_id = (int)$_GET['page_id'];
463
			} else {
464
				$page_id = (int)$_POST['page_id'];
465
			}
466

    
467
    		// gather information for all models embedded on actual page
468
			$query_modules = $database->query("SELECT module FROM " .TABLE_PREFIX ."sections
469
				WHERE page_id=$page_id");
470

    
471
    		while($row = $query_modules->fetchRow()) {
472
				// check if page module directory contains a backend.js or backend.css file
473
      		if(file_exists(WB_PATH ."/modules/" .$row['module'] ."/$base_file")) {
474
					// create link with backend.js or backend.css source for the current module
475
					$tmp_link = str_replace("{MODULE_DIRECTORY}", $row['module'], $base_link);
476
        			// ensure that backend.js or backend.css is only added once per module type
477
        			if(strpos($head_links, $tmp_link) === false) {
478
						$head_links .= $tmp_link ."\n";
479
					}
480
				}
481
    		}
482
    		// write out links with all external module javascript/CSS files, remove last line feed
483
			return rtrim($head_links);
484
		}
485
	}
486
}
487

    
488
?>
(4-4/16)