| 6,7 → 6,7 |
|---|
| echo "<b>Could not include SQL library</b><br>\n"; |
| exit(); |
| } |
| if ($config[sql_use_operators] == 'true'){ |
| if ($config['sql_use_operators'] == 'true'){ |
| $op = ',op'; |
| $use_op = 1; |
| }else{ |
| 14,18 → 14,18 |
|---|
| $use_op = 0; |
| } |
| $group_exists = 'no'; |
| $link = @da_sql_pconnect($config); |
| $link = da_sql_pconnect($config); |
| if ($link){ |
| if ($login == ''){ |
| if (!isset($login) || $login == ''){ |
| unset($existing_groups); |
| |
| $res = @da_sql_query($link,$config, |
| $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]; |
| while(($row = da_sql_fetch_array($res,$config))){ |
| $name = $row['groupname']; |
| $existing_groups["$name"] = $row['counter']; |
| } |
| if (isset($existing_groups)) |
| ksort($existing_groups); |
| 39,14 → 39,15 |
|---|
| unset($group_members); |
| unset($existing_groups); |
| |
| $res = @da_sql_query($link,$config, |
| $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)) |
| if (da_sql_num_rows($res,$config)) |
| $group_exists = 'yes'; |
| while(($row = @da_sql_fetch_array($res,$config))){ |
| $attr = $row[attribute]; |
| $val = $row[value]; |
| 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; |
| 54,40 → 55,41 |
|---|
| if($attr == "Expiration") $Expiration = $val; |
| /*Fin Ajout*/ |
| if ($use_op){ |
| $oper = $row[op]; |
| $tmp["$attr"][operator][]="$oper"; |
| $oper = $row['op']; |
| $tmp["$attr"]['operator'][]="$oper"; |
| } |
| $tmp["$attr"][]="$val"; |
| $tmp["$attr"][count]++; |
| $tmp["$attr"]['count']++; |
| } |
| $res = @da_sql_query($link,$config, |
| $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)) |
| if (da_sql_num_rows($res,$config)) |
| $group_exists = 'yes'; |
| while(($row = @da_sql_fetch_array($res,$config))){ |
| $attr = $row[attribute]; |
| $val = $row[value]; |
| 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"; |
| $oper = $row['op']; |
| $tmp["$attr"]['operator'][]="$oper"; |
| } |
| $tmp["$attr"][] = "$val"; |
| $tmp["$attr"][count]++; |
| $tmp["$attr"]['count']++; |
| } |
| } |
| else |
| echo "<b>Database query failed partially: " . da_sql_error($link,$config) . "</b><br>\n"; |
| $res = @da_sql_query($link,$config, |
| $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)) |
| if (da_sql_num_rows($res,$config)) |
| $group_exists = 'yes'; |
| while(($row = @da_sql_fetch_array($res,$config))){ |
| $member = $row[username]; |
| while(($row = da_sql_fetch_array($res,$config))){ |
| $member = $row['username']; |
| $group_members[] = "$member"; |
| } |
| } |
| 105,9 → 107,9 |
|---|
| $rev_attrmap["$val"] = $key; |
| } |
| $item_vals["$key"] = $tmp[$val]; |
| $item_vals["$key"][count] = $tmp[$val][count]; |
| $item_vals["$key"]['count'] = $tmp[$val]['count']; |
| if ($use_op) |
| $item_vals["$key"][operator] = $tmp[$val][operator]; |
| $item_vals["$key"]['operator'] = $tmp[$val]['operator']; |
| } |
| } |
| } |