/
access_levels.php
64 lines (58 loc) · 2.86 KB
/
access_levels.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
<?php
/******************************************************************************
Etano
===============================================================================
File: admin/access_levels.php
$Revision$
Software by: DateMill (http://www.datemill.com)
Copyright by: DateMill (http://www.datemill.com)
Support at: http://www.datemill.com/forum
*******************************************************************************
* See the "docs/licenses/etano.txt" file for license. *
******************************************************************************/
require_once '../includes/common.inc.php';
require_once '../includes/admin_functions.inc.php';
allow_dept(DEPT_ADMIN);
$tpl=new phemplate('skin/','remove_nonjs');
$query="SELECT `m_id`,`m_name`,`m_value`,`is_custom` FROM `{$dbtable_prefix}memberships` ORDER BY `m_id`";
if (!($res=@mysql_query($query))) {trigger_error(mysql_error(),E_USER_ERROR);}
$memberships=array();
$i=0;
while ($rsrow=mysql_fetch_assoc($res)) {
$memberships[$i]=$rsrow;
if ($memberships[$i]['is_custom']) {
$memberships[$i]['m_name'].=' <a href="javascript:;" onclick="del_membership('.$memberships[$i]['m_id'].')" title="Delete this membership"><img src="skin/images/del.png" alt="Delete this membership" /></a>';
}
++$i;
}
$query="SELECT `level_id`,`level_code`,`level_diz`,`level`,`disabled_level` FROM `{$dbtable_prefix}access_levels`";
if (!($res=@mysql_query($query))) {trigger_error(mysql_error(),E_USER_ERROR);}
$i=0;
$access_levels=array();
while ($rsrow=mysql_fetch_assoc($res)) {
$rsrow['level_code']=sanitize_and_format($rsrow['level_code'],TYPE_STRING,$__field2format[TEXT_DB2DISPLAY]);
$rsrow['level_diz']=sanitize_and_format($rsrow['level_diz'],TYPE_STRING,$__field2format[TEXT_DB2DISPLAY]);
$access_levels[$i]['row']='<td><a href="access_levels_addedit.php?level_id='.$rsrow['level_id'].'" title="'.$rsrow['level_diz'].'">'.$rsrow['level_code']."</a></td>\n";
for ($j=0;isset($memberships[$j]);++$j) {
$access_levels[$i]['row'].='<td><input type="checkbox" name="levels['.$rsrow['level_id'].']['.$memberships[$j]['m_value'].']" value="1"';
if (((int)$memberships[$j]['m_value']) & ((int)$rsrow['level'])) {
$access_levels[$i]['row'].=' checked="checked"';
}
if (((int)$memberships[$j]['m_value']) & ((int)$rsrow['disabled_level'])) {
$access_levels[$i]['row'].=' disabled="disabled"';
}
$access_levels[$i]['row'].=" /></td>\n";
}
++$i;
}
$tpl->set_file('content','access_levels.html');
$tpl->set_loop('access_levels',$access_levels);
$tpl->set_loop('memberships',$memberships);
$tpl->process('content','content',TPL_LOOP | TPL_NOLOOP);
$tpl->drop_loop('access_levels');
$tpl->drop_loop('memberships');
unset($access_levels);
unset($memberships);
$tplvars['title']='Define access levels';
$tplvars['page']='access_levels';
include 'frame.php';