WebSVN – ALCASAR – Diff – /web/acc/manager/lib/sql/group_info.php


<?php
require('../lib/sql/attrmap.php');
if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php"))
	include_once("../lib/sql/drivers/$config[sql_type]/functions.php");
else{
	echo "<b>Could not include SQL library</b><br>\n";
	exit();
}
if ($config['sql_use_operators'] == 'true'){
	$op = ',op';
	$use_op = 1;
}else{
	$op = "";
	$use_op = 0;
}
$group_exists = 'no';
$link = da_sql_pconnect($config);
if ($link){
	if (!isset($login) || $login == ''){
		unset($existing_groups);
 
		$res = da_sql_query($link,$config,
		"SELECT COUNT(*) as counter,groupname FROM $config[sql_usergroup_table]
		GROUP BY groupname;");
		if ($res){
			while(($row = da_sql_fetch_array($res,$config))){
				$name = $row['groupname'];
				$existing_groups["$name"] = $row['counter'];
			}
			if (isset($existing_groups))
				ksort($existing_groups);
		}
		else
			echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n";
	}
	else{
		unset($item_vals);
		unset($tmp);
		unset($group_members);
		unset($existing_groups);
 
		$res = da_sql_query($link,$config,
		"SELECT attribute,value $op FROM $config[sql_groupcheck_table] WHERE groupname = '$login';");
		if ($res){
			if (da_sql_num_rows($res,$config))
				$group_exists = 'yes';
			while(($row = da_sql_fetch_array($res,$config))){
				$attr = $row['attribute'];
				$val = $row['value'];
				if(!isset($tmp["$attr"]['count'])) $tmp["$attr"]['count'] = 0;
				/*Ajout en vue de l'impression des données (thank's to Geoffroy MUSITELLI)*/
				if($attr == "Max-All-Session") $mas_imp = $val;
				if($attr == "Max-Daily-Session") $mds_imp = $val;
				if($attr == "Max-Monthly-Session") $mms_imp = $val;
				if($attr == "Expiration") $Expiration = $val;
				/*Fin Ajout*/
				if ($use_op){
					$oper = $row['op'];
					$tmp["$attr"]['operator'][]="$oper";
				}
				$tmp["$attr"][]="$val";
				$tmp["$attr"]['count']++;
			}
			$res = da_sql_query($link,$config,
			"SELECT attribute,value $op FROM $config[sql_groupreply_table] WHERE groupname = '$login';");
			if ($res){
				if (da_sql_num_rows($res,$config))
					$group_exists = 'yes';
				while(($row = da_sql_fetch_array($res,$config))){
					$attr = $row['attribute'];
					$val = $row['value'];
					if(!isset($tmp["$attr"]['count'])) $tmp["$attr"]['count'] = 0;
					/*Ajout en vue de l'impression des données (thank's to Geoffroy MUSITELLI)*/
					if($attr == "Session-Timeout") $sto_imp = $val;
					/*Fin Ajout*/
					if ($use_op){
						$oper = $row['op'];
						$tmp["$attr"]['operator'][]="$oper";
					}
					$tmp["$attr"][] = "$val";
					$tmp["$attr"]['count']++;
				}
			}
			else
				echo "<b>Database query failed partially: " . da_sql_error($link,$config) . "</b><br>\n";
			$res = da_sql_query($link,$config,
			"SELECT username FROM $config[sql_usergroup_table] WHERE groupname = '$login' ORDER BY username;");
			if ($res){
				if (da_sql_num_rows($res,$config))
					$group_exists = 'yes';
				while(($row = da_sql_fetch_array($res,$config))){
					$member = $row['username'];
					$group_members[] = "$member";
				}
			}
			else
				echo "<b>Database query failed partially: " . da_sql_error($link,$config) . "</b><br>\n";
			if (isset($tmp)){
				foreach(array_keys($tmp) as $val){
					unset($key);
					if ($val == '')
						continue;
					if ((isset($rev_attrmap["$val"])) && (!empty($rev_attrmap["$val"]))) {
						$key = $rev_attrmap["$val"];
					} else {
						$key = $val;
						$attrmap["$key"] = $val;
						$attr_type["$key"] = 'replyItem';
						$rev_attrmap["$val"] = $key;
					}
					$item_vals["$key"] = $tmp[$val];
					$item_vals["$key"]['count'] = $tmp[$val]['count'];
					if ($use_op)
						$item_vals["$key"]['operator'] = $tmp[$val]['operator'];
				}
			}
		}
		else
			echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n";
	}
}
else
	echo "<b>Could not connect to SQL database</b><br>\n";
?>
 

Rev 2340	Rev 2501
1	`<?php`	1	`<?php`
2	`require('../lib/sql/attrmap.php');`	2	`require('../lib/sql/attrmap.php');`
3	`if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php"))`	3	`if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php"))`
4	`include_once("../lib/sql/drivers/$config[sql_type]/functions.php");`	4	`include_once("../lib/sql/drivers/$config[sql_type]/functions.php");`
5	`else{`	5	`else{`
6	`echo "<b>Could not include SQL library</b><br>\n";`	6	`echo "<b>Could not include SQL library</b><br>\n";`
7	`exit();`	7	`exit();`
8	`}`	8	`}`
9	`if ($config['sql_use_operators'] == 'true'){`	9	`if ($config['sql_use_operators'] == 'true'){`
10	`$op = ',op';`	10	`$op = ',op';`
11	`$use_op = 1;`	11	`$use_op = 1;`
12	`}else{`	12	`}else{`
13	`$op = "";`	13	`$op = "";`
14	`$use_op = 0;`	14	`$use_op = 0;`
15	`}`	15	`}`
16	`$group_exists = 'no';`	16	`$group_exists = 'no';`
17	`$link = da_sql_pconnect($config);`	17	`$link = da_sql_pconnect($config);`
18	`if ($link){`	18	`if ($link){`
19	`if (!isset($login) \|\| $login == ''){`	19	`if (!isset($login) \|\| $login == ''){`
20	`unset($existing_groups);`	20	`unset($existing_groups);`
21		21
22	`$res = da_sql_query($link,$config,`	22	`$res = da_sql_query($link,$config,`
23	`"SELECT COUNT(*) as counter,groupname FROM $config[sql_usergroup_table]`	23	`"SELECT COUNT(*) as counter,groupname FROM $config[sql_usergroup_table]`
24	`GROUP BY groupname;");`	24	`GROUP BY groupname;");`
25	`if ($res){`	25	`if ($res){`
26	`while(($row = da_sql_fetch_array($res,$config))){`	26	`while(($row = da_sql_fetch_array($res,$config))){`
27	`$name = $row['groupname'];`	27	`$name = $row['groupname'];`
28	`$existing_groups["$name"] = $row['counter'];`	28	`$existing_groups["$name"] = $row['counter'];`
29	`}`	29	`}`
30	`if (isset($existing_groups))`	30	`if (isset($existing_groups))`
31	`ksort($existing_groups);`	31	`ksort($existing_groups);`
32	`}`	32	`}`
33	`else`	33	`else`
34	`echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n";`	34	`echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n";`
35	`}`	35	`}`
36	`else{`	36	`else{`
37	`unset($item_vals);`	37	`unset($item_vals);`
38	`unset($tmp);`	38	`unset($tmp);`
39	`unset($group_members);`	39	`unset($group_members);`
40	`unset($existing_groups);`	40	`unset($existing_groups);`
41		41
42	`$res = da_sql_query($link,$config,`	42	`$res = da_sql_query($link,$config,`
43	`"SELECT attribute,value $op FROM $config[sql_groupcheck_table] WHERE groupname = '$login';");`	43	`"SELECT attribute,value $op FROM $config[sql_groupcheck_table] WHERE groupname = '$login';");`
44	`if ($res){`	44	`if ($res){`
45	`if (da_sql_num_rows($res,$config))`	45	`if (da_sql_num_rows($res,$config))`
46	`$group_exists = 'yes';`	46	`$group_exists = 'yes';`
47	`while(($row = da_sql_fetch_array($res,$config))){`	47	`while(($row = da_sql_fetch_array($res,$config))){`
48	`$attr = $row['attribute'];`	48	`$attr = $row['attribute'];`
49	`$val = $row['value'];`	49	`$val = $row['value'];`
50	`if(!isset($tmp["$attr"]['count'])) $tmp["$attr"]['count'] = 0;`	50	`if(!isset($tmp["$attr"]['count'])) $tmp["$attr"]['count'] = 0;`
51	`/Ajout en vue de l'impression des données (thank's to Geoffroy MUSITELLI)/`	51	`/Ajout en vue de l'impression des données (thank's to Geoffroy MUSITELLI)/`
52	`if($attr == "Max-All-Session") $mas_imp = $val;`	52	`if($attr == "Max-All-Session") $mas_imp = $val;`
53	`if($attr == "Max-Daily-Session") $mds_imp = $val;`	53	`if($attr == "Max-Daily-Session") $mds_imp = $val;`
54	`if($attr == "Max-Monthly-Session") $mms_imp = $val;`	54	`if($attr == "Max-Monthly-Session") $mms_imp = $val;`
55	`if($attr == "Expiration") $Expiration = $val;`	55	`if($attr == "Expiration") $Expiration = $val;`
56	`/Fin Ajout/`	56	`/Fin Ajout/`
57	`if ($use_op){`	57	`if ($use_op){`
58	`$oper = $row['op'];`	58	`$oper = $row['op'];`
59	`$tmp["$attr"]['operator'][]="$oper";`	59	`$tmp["$attr"]['operator'][]="$oper";`
60	`}`	60	`}`
61	`$tmp["$attr"][]="$val";`	61	`$tmp["$attr"][]="$val";`
62	`$tmp["$attr"]['count']++;`	62	`$tmp["$attr"]['count']++;`
63	`}`	63	`}`
64	`$res = da_sql_query($link,$config,`	64	`$res = da_sql_query($link,$config,`
65	`"SELECT attribute,value $op FROM $config[sql_groupreply_table] WHERE groupname = '$login';");`	65	`"SELECT attribute,value $op FROM $config[sql_groupreply_table] WHERE groupname = '$login';");`
66	`if ($res){`	66	`if ($res){`
67	`if (da_sql_num_rows($res,$config))`	67	`if (da_sql_num_rows($res,$config))`
68	`$group_exists = 'yes';`	68	`$group_exists = 'yes';`
69	`while(($row = da_sql_fetch_array($res,$config))){`	69	`while(($row = da_sql_fetch_array($res,$config))){`
70	`$attr = $row['attribute'];`	70	`$attr = $row['attribute'];`
71	`$val = $row['value'];`	71	`$val = $row['value'];`
72	`if(!isset($tmp["$attr"]['count'])) $tmp["$attr"]['count'] = 0;`	72	`if(!isset($tmp["$attr"]['count'])) $tmp["$attr"]['count'] = 0;`
73	`/Ajout en vue de l'impression des données (thank's to Geoffroy MUSITELLI)/`	73	`/Ajout en vue de l'impression des données (thank's to Geoffroy MUSITELLI)/`
74	`if($attr == "Session-Timeout") $sto_imp = $val;`	74	`if($attr == "Session-Timeout") $sto_imp = $val;`
75	`/Fin Ajout/`	75	`/Fin Ajout/`
76	`if ($use_op){`	76	`if ($use_op){`
77	`$oper = $row['op'];`	77	`$oper = $row['op'];`
78	`$tmp["$attr"]['operator'][]="$oper";`	78	`$tmp["$attr"]['operator'][]="$oper";`
79	`}`	79	`}`
80	`$tmp["$attr"][] = "$val";`	80	`$tmp["$attr"][] = "$val";`
81	`$tmp["$attr"]['count']++;`	81	`$tmp["$attr"]['count']++;`
82	`}`	82	`}`
83	`}`	83	`}`
84	`else`	84	`else`
85	`echo "<b>Database query failed partially: " . da_sql_error($link,$config) . "</b><br>\n";`	85	`echo "<b>Database query failed partially: " . da_sql_error($link,$config) . "</b><br>\n";`
86	`$res = da_sql_query($link,$config,`	86	`$res = da_sql_query($link,$config,`
87	`"SELECT username FROM $config[sql_usergroup_table] WHERE groupname = '$login' ORDER BY username;");`	87	`"SELECT username FROM $config[sql_usergroup_table] WHERE groupname = '$login' ORDER BY username;");`
88	`if ($res){`	88	`if ($res){`
89	`if (da_sql_num_rows($res,$config))`	89	`if (da_sql_num_rows($res,$config))`
90	`$group_exists = 'yes';`	90	`$group_exists = 'yes';`
91	`while(($row = da_sql_fetch_array($res,$config))){`	91	`while(($row = da_sql_fetch_array($res,$config))){`
92	`$member = $row['username'];`	92	`$member = $row['username'];`
93	`$group_members[] = "$member";`	93	`$group_members[] = "$member";`
94	`}`	94	`}`
95	`}`	95	`}`
96	`else`	96	`else`
97	`echo "<b>Database query failed partially: " . da_sql_error($link,$config) . "</b><br>\n";`	97	`echo "<b>Database query failed partially: " . da_sql_error($link,$config) . "</b><br>\n";`
98	`if (isset($tmp)){`	98	`if (isset($tmp)){`
99	`foreach(array_keys($tmp) as $val){`	99	`foreach(array_keys($tmp) as $val){`
100	`unset($key);`	100	`unset($key);`
101	`if ($val == '')`	101	`if ($val == '')`
102	`continue;`	102	`continue;`
-		103	`if ((isset($rev_attrmap["$val"])) && (!empty($rev_attrmap["$val"]))) {`
103	`$key = $rev_attrmap["$val"];`	104	`$key = $rev_attrmap["$val"];`
104	`if ((!isset($key)) \|\| (empty($key))) {`	105	`} else {`
105	`$key = $val;`	106	`$key = $val;`
106	`$attrmap["$key"] = $val;`	107	`$attrmap["$key"] = $val;`
107	`$attr_type["$key"] = 'replyItem';`	108	`$attr_type["$key"] = 'replyItem';`
108	`$rev_attrmap["$val"] = $key;`	109	`$rev_attrmap["$val"] = $key;`
109	`}`	110	`}`
110	`$item_vals["$key"] = $tmp[$val];`	111	`$item_vals["$key"] = $tmp[$val];`
111	`$item_vals["$key"]['count'] = $tmp[$val]['count'];`	112	`$item_vals["$key"]['count'] = $tmp[$val]['count'];`
112	`if ($use_op)`	113	`if ($use_op)`
113	`$item_vals["$key"]['operator'] = $tmp[$val]['operator'];`	114	`$item_vals["$key"]['operator'] = $tmp[$val]['operator'];`
114	`}`	115	`}`
115	`}`	116	`}`
116	`}`	117	`}`
117	`else`	118	`else`
118	`echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n";`	119	`echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n";`
119	`}`	120	`}`
120	`}`	121	`}`
121	`else`	122	`else`
122	`echo "<b>Could not connect to SQL database</b><br>\n";`	123	`echo "<b>Could not connect to SQL database</b><br>\n";`
123	`?>`	124	`?>`
124		125

Subversion Repositories ALCASAR

(root)/web/acc/manager/lib/sql/group_info.php – Rev 2340 → 2501