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


<?php
require('../lib/sql/attrmap.php');
if ((isset($login) && $login != '') && (isset($user_type) && $user_type !== 'group')){
 
	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;
	}
	$overwrite_defaults = 1;
	$stop = 0;
	$times = 0;
	do{
		unset($item_vals);
		unset($member_groups);
		unset($tmp);
		$times++;
		$link = da_sql_pconnect($config);
		if ($link){
			$res = da_sql_query($link,$config,
			"SELECT groupname FROM $config[sql_usergroup_table] WHERE username = '$login';");
			if ($res){
				while(($row = da_sql_fetch_array($res,$config))){
					$group = $row['groupname'];
					$member_groups[$group] = $group;
				}
				if (isset($member_groups))
					ksort($member_groups);
			}
			if (isset($member_groups)){
				$in = '(';
				foreach ($member_groups as $group)
					$in .= "'$group',";
				$in = substr($in,0,-1);
				$in .= ')';
				$res = da_sql_query($link,$config,
				"SELECT attribute,value $op FROM $config[sql_groupcheck_table]
				WHERE groupname IN $in;");
				if ($res){
					while(($row = da_sql_fetch_array($res,$config))){
						$attr = $row['attribute'];
						$val = $row['value'];
						if ($use_op){
							$oper = $row['op'];
							$tmp["$attr"]['operator'][]="$oper";
						}
						$tmp["$attr"][]="$val";
						if(isset($tmp["$attr"]['count']))
							$tmp["$attr"]['count']++;
					}
					$res = da_sql_query($link,$config,
					"SELECT attribute,value $op FROM $config[sql_groupreply_table]
					WHERE groupname IN $in;");
					if ($res){
						while(($row = da_sql_fetch_array($res,$config))){
							$attr = $row['attribute'];
							$val = $row['value'];
							if ($use_op){
								$oper = $row['op'];
								$tmp["$attr"]['operator'][]="$oper";
							}
							$tmp["$attr"][] = "$val";
							if(isset($tmp["$attr"]['count']))
							{
								$tmp["$attr"]['count']++;
							}
						}
					}
					else
						echo "<b>Database query failed partially: " . da_sql_error($link,$config) . "</b><br>\n";
				}
				else
					echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n";
				if (isset($tmp)){
					foreach(array_keys($tmp) as $val){
						if ($val == '')
							continue;
						$key = $rev_attrmap["$val"];
						if ($key == ''){
							$key = $val;
							$attrmap["$key"] = $val;
							$attr_type["$key"] = 'replyItem';
							$rev_attrmap["$val"] = $key;
						}
						if (!isset($default_vals["$key"]) || $overwrite_defaults){
							if ($use_op)
								$default_vals["$key"]['operator'] = $tmp["$val"]['operator'];
							if ($tmp[$val][0] != '')
								$default_vals["$key"] = $tmp["$val"];
						}
					}
				}
			}
			if ($times == 1){
				if (!isset($config['sql_default_user_profile']) || $config['sql_default_user_profile'] == '')
					$stop = 1;
				else{
					$saved_login = $login;
					$saved_member_groups = $member_groups;
					$login = $config['sql_default_user_profile'];
					$overwrite_defaults = 0;
				}
			}
			if ($times == 2){
				$login = $saved_login;
				$member_groups = $saved_member_groups;
				$stop = 1;
			}
		}
		else
			echo "<b>Could not connect to SQL database</b><br>\n";
	}while($stop == 0);
}
else{
	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();
	}
	unset($member_groups);
	$link = da_sql_pconnect($config);
	if ($link){
		if(isset($login) && $login != '')
		{	
			#affiche le groupe appartenant à l'utilisateur
			$res = da_sql_query($link,$config,
			"SELECT DISTINCT groupname FROM $config[sql_usergroup_table] WHERE username = '$login';");
		}
		else
		{
			#affiche la liste de groupe disponible (dans le cas de la creation d'un utilisateur)
			$res = da_sql_query($link,$config,
			"SELECT DISTINCT groupname FROM $config[sql_usergroup_table] ;");
		}
 
		if ($res){
			while(($row = da_sql_fetch_array($res,$config))){
				$member_groups[] = $row['groupname'];
			}
		}
		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 1831	Rev 1882
1	`<?php`	1	`<?php`
2	`require('../lib/sql/attrmap.php');`	2	`require('../lib/sql/attrmap.php');`
3	`if ((isset($login) && $login != '') && (isset($user_type) && $user_type !== 'group')){`	3	`if ((isset($login) && $login != '') && (isset($user_type) && $user_type !== 'group')){`
4		4
5	`if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php"))`	5	`if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php"))`
6	`include_once("../lib/sql/drivers/$config[sql_type]/functions.php");`	6	`include_once("../lib/sql/drivers/$config[sql_type]/functions.php");`
7	`else{`	7	`else{`
8	`echo "<b>Could not include SQL library</b><br>\n";`	8	`echo "<b>Could not include SQL library</b><br>\n";`
9	`exit();`	9	`exit();`
10	`}`	10	`}`
11	`if ($config['sql_use_operators'] == 'true'){`	11	`if ($config['sql_use_operators'] == 'true'){`
12	`$op = ',op';`	12	`$op = ',op';`
13	`$use_op = 1;`	13	`$use_op = 1;`
14	`}else{`	14	`}else{`
15	`$op = "";`	15	`$op = "";`
16	`$use_op = 0;`	16	`$use_op = 0;`
17	`}`	17	`}`
18	`$overwrite_defaults = 1;`	18	`$overwrite_defaults = 1;`
19	`$stop = 0;`	19	`$stop = 0;`
20	`$times = 0;`	20	`$times = 0;`
21	`do{`	21	`do{`
22	`unset($item_vals);`	22	`unset($item_vals);`
23	`unset($member_groups);`	23	`unset($member_groups);`
24	`unset($tmp);`	24	`unset($tmp);`
25	`$times++;`	25	`$times++;`
26	`$link = da_sql_pconnect($config);`	26	`$link = da_sql_pconnect($config);`
27	`if ($link){`	27	`if ($link){`
28	`$res = da_sql_query($link,$config,`	28	`$res = da_sql_query($link,$config,`
29	`"SELECT groupname FROM $config[sql_usergroup_table] WHERE username = '$login';");`	29	`"SELECT groupname FROM $config[sql_usergroup_table] WHERE username = '$login';");`
30	`if ($res){`	30	`if ($res){`
31	`while(($row = da_sql_fetch_array($res,$config))){`	31	`while(($row = da_sql_fetch_array($res,$config))){`
32	`$group = $row['groupname'];`	32	`$group = $row['groupname'];`
33	`$member_groups[$group] = $group;`	33	`$member_groups[$group] = $group;`
34	`}`	34	`}`
35	`if (isset($member_groups))`	35	`if (isset($member_groups))`
36	`ksort($member_groups);`	36	`ksort($member_groups);`
37	`}`	37	`}`
38	`if (isset($member_groups)){`	38	`if (isset($member_groups)){`
39	`$in = '(';`	39	`$in = '(';`
40	`foreach ($member_groups as $group)`	40	`foreach ($member_groups as $group)`
41	`$in .= "'$group',";`	41	`$in .= "'$group',";`
42	`$in = substr($in,0,-1);`	42	`$in = substr($in,0,-1);`
43	`$in .= ')';`	43	`$in .= ')';`
44	`$res = da_sql_query($link,$config,`	44	`$res = da_sql_query($link,$config,`
45	`"SELECT attribute,value $op FROM $config[sql_groupcheck_table]`	45	`"SELECT attribute,value $op FROM $config[sql_groupcheck_table]`
46	`WHERE groupname IN $in;");`	46	`WHERE groupname IN $in;");`
47	`if ($res){`	47	`if ($res){`
48	`while(($row = da_sql_fetch_array($res,$config))){`	48	`while(($row = da_sql_fetch_array($res,$config))){`
49	`$attr = $row['attribute'];`	49	`$attr = $row['attribute'];`
50	`$val = $row['value'];`	50	`$val = $row['value'];`
51	`if ($use_op){`	51	`if ($use_op){`
52	`$oper = $row['op'];`	52	`$oper = $row['op'];`
53	`$tmp["$attr"]['operator'][]="$oper";`	53	`$tmp["$attr"]['operator'][]="$oper";`
54	`}`	54	`}`
55	`$tmp["$attr"][]="$val";`	55	`$tmp["$attr"][]="$val";`
-		56	`if(isset($tmp["$attr"]['count']))`
56	`$tmp["$attr"]['count']++;`	57	`$tmp["$attr"]['count']++;`
57	`}`	58	`}`
58	`$res = da_sql_query($link,$config,`	59	`$res = da_sql_query($link,$config,`
59	`"SELECT attribute,value $op FROM $config[sql_groupreply_table]`	60	`"SELECT attribute,value $op FROM $config[sql_groupreply_table]`
60	`WHERE groupname IN $in;");`	61	`WHERE groupname IN $in;");`
61	`if ($res){`	62	`if ($res){`
62	`while(($row = da_sql_fetch_array($res,$config))){`	63	`while(($row = da_sql_fetch_array($res,$config))){`
63	`$attr = $row['attribute'];`	64	`$attr = $row['attribute'];`
64	`$val = $row['value'];`	65	`$val = $row['value'];`
65	`if ($use_op){`	66	`if ($use_op){`
66	`$oper = $row['op'];`	67	`$oper = $row['op'];`
67	`$tmp["$attr"]['operator'][]="$oper";`	68	`$tmp["$attr"]['operator'][]="$oper";`
68	`}`	69	`}`
69	`$tmp["$attr"][] = "$val";`	70	`$tmp["$attr"][] = "$val";`
70	`if(isset($tmp["$attr"]['count']))`	71	`if(isset($tmp["$attr"]['count']))`
71	`{`	72	`{`
72	`$tmp["$attr"]['count']++;`	73	`$tmp["$attr"]['count']++;`
73	`}`	74	`}`
74	`}`	75	`}`
75	`}`	76	`}`
76	`else`	77	`else`
77	`echo "<b>Database query failed partially: " . da_sql_error($link,$config) . "</b><br>\n";`	78	`echo "<b>Database query failed partially: " . da_sql_error($link,$config) . "</b><br>\n";`
78	`}`	79	`}`
79	`else`	80	`else`
80	`echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n";`	81	`echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n";`
81	`if (isset($tmp)){`	82	`if (isset($tmp)){`
82	`foreach(array_keys($tmp) as $val){`	83	`foreach(array_keys($tmp) as $val){`
83	`if ($val == '')`	84	`if ($val == '')`
84	`continue;`	85	`continue;`
85	`$key = $rev_attrmap["$val"];`	86	`$key = $rev_attrmap["$val"];`
86	`if ($key == ''){`	87	`if ($key == ''){`
87	`$key = $val;`	88	`$key = $val;`
88	`$attrmap["$key"] = $val;`	89	`$attrmap["$key"] = $val;`
89	`$attr_type["$key"] = 'replyItem';`	90	`$attr_type["$key"] = 'replyItem';`
90	`$rev_attrmap["$val"] = $key;`	91	`$rev_attrmap["$val"] = $key;`
91	`}`	92	`}`
92	`if (!isset($default_vals["$key"]) \|\| $overwrite_defaults){`	93	`if (!isset($default_vals["$key"]) \|\| $overwrite_defaults){`
93	`if ($use_op)`	94	`if ($use_op)`
94	`$default_vals["$key"]['operator'] = $tmp["$val"]['operator'];`	95	`$default_vals["$key"]['operator'] = $tmp["$val"]['operator'];`
95	`if ($tmp[$val][0] != '')`	96	`if ($tmp[$val][0] != '')`
96	`$default_vals["$key"] = $tmp["$val"];`	97	`$default_vals["$key"] = $tmp["$val"];`
97	`}`	98	`}`
98	`}`	99	`}`
99	`}`	100	`}`
100	`}`	101	`}`
101	`if ($times == 1){`	102	`if ($times == 1){`
102	`if (!isset($config['sql_default_user_profile']) \|\| $config['sql_default_user_profile'] == '')`	103	`if (!isset($config['sql_default_user_profile']) \|\| $config['sql_default_user_profile'] == '')`
103	`$stop = 1;`	104	`$stop = 1;`
104	`else{`	105	`else{`
105	`$saved_login = $login;`	106	`$saved_login = $login;`
106	`$saved_member_groups = $member_groups;`	107	`$saved_member_groups = $member_groups;`
107	`$login = $config['sql_default_user_profile'];`	108	`$login = $config['sql_default_user_profile'];`
108	`$overwrite_defaults = 0;`	109	`$overwrite_defaults = 0;`
109	`}`	110	`}`
110	`}`	111	`}`
111	`if ($times == 2){`	112	`if ($times == 2){`
112	`$login = $saved_login;`	113	`$login = $saved_login;`
113	`$member_groups = $saved_member_groups;`	114	`$member_groups = $saved_member_groups;`
114	`$stop = 1;`	115	`$stop = 1;`
115	`}`	116	`}`
116	`}`	117	`}`
117	`else`	118	`else`
118	`echo "<b>Could not connect to SQL database</b><br>\n";`	119	`echo "<b>Could not connect to SQL database</b><br>\n";`
119	`}while($stop == 0);`	120	`}while($stop == 0);`
120	`}`	121	`}`
121	`else{`	122	`else{`
122	`if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php"))`	123	`if (is_file("../lib/sql/drivers/$config[sql_type]/functions.php"))`
123	`include_once("../lib/sql/drivers/$config[sql_type]/functions.php");`	124	`include_once("../lib/sql/drivers/$config[sql_type]/functions.php");`
124	`else{`	125	`else{`
125	`echo "<b>Could not include SQL library</b><br>\n";`	126	`echo "<b>Could not include SQL library</b><br>\n";`
126	`exit();`	127	`exit();`
127	`}`	128	`}`
128	`unset($member_groups);`	129	`unset($member_groups);`
129	`$link = da_sql_pconnect($config);`	130	`$link = da_sql_pconnect($config);`
130	`if ($link){`	131	`if ($link){`
131	`if(isset($login) && $login != '')`	132	`if(isset($login) && $login != '')`
132	`{`	133	`{`
133	`#affiche le groupe appartenant à l'utilisateur`	134	`#affiche le groupe appartenant à l'utilisateur`
134	`$res = da_sql_query($link,$config,`	135	`$res = da_sql_query($link,$config,`
135	`"SELECT DISTINCT groupname FROM $config[sql_usergroup_table] WHERE username = '$login';");`	136	`"SELECT DISTINCT groupname FROM $config[sql_usergroup_table] WHERE username = '$login';");`
136	`}`	137	`}`
137	`else`	138	`else`
138	`{`	139	`{`
139	`#affiche la liste de groupe disponible (dans le cas de la creation d'un utilisateur)`	140	`#affiche la liste de groupe disponible (dans le cas de la creation d'un utilisateur)`
140	`$res = da_sql_query($link,$config,`	141	`$res = da_sql_query($link,$config,`
141	`"SELECT DISTINCT groupname FROM $config[sql_usergroup_table] ;");`	142	`"SELECT DISTINCT groupname FROM $config[sql_usergroup_table] ;");`
142	`}`	143	`}`
143		144
144	`if ($res){`	145	`if ($res){`
145	`while(($row = da_sql_fetch_array($res,$config))){`	146	`while(($row = da_sql_fetch_array($res,$config))){`
146	`$member_groups[] = $row['groupname'];`	147	`$member_groups[] = $row['groupname'];`
147	`}`	148	`}`
148	`}`	149	`}`
149	`else`	150	`else`
150	`echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n";`	151	`echo "<b>Database query failed: " . da_sql_error($link,$config) . "</b><br>\n";`
151	`}`	152	`}`
152	`else`	153	`else`
153	`echo "<b>Could not connect to SQL database</b><br>\n";`	154	`echo "<b>Could not connect to SQL database</b><br>\n";`
154	`}`	155	`}`
155	`?>`	156	`?>`
156		157

Subversion Repositories ALCASAR

(root)/web/acc/manager/lib/sql/defaults.php @ 2229 – Rev 1831 → 1882