Forgot one case...
--- /usr/local/cvs/radiusd/dialup_admin/htdocs/show_groups.php3
2003-05-11 16:03
:37.000000000 +0200
+++ /usr/local/dialup_admin/htdocs/show_groups.php3 2003-09-16
15:17:24.0000
00000 +0200
@@ -58,13 +58,23 @@
$link = @da_sql_pconnect($config);
if ($link){
$search = @da_sql_query($link,$config,
- "SELECT COUNT(*),GroupName FROM $config[sql_usergroup_table]
GROUP BY Gr
oupName;");
+ "SELECT DISTINCT s.groupname FROM $config[sql_groupcheck_table]
CROSS JO
IN (SELECT DISTINCT u.groupname FROM $config[sql_groupreply_table] CROSS
JOIN $c
onfig[sql_usergroup_table] u) as s;");
if ($search){
if (@da_sql_num_rows($search,$config)){
while( $row =
@da_sql_fetch_array($search,$config) ){
$num++;
- $group = $row[GroupName];
- $num_members = $row['COUNT(*)'];
+ $group = $row[groupname];
+ $search2 = @da_sql_query($link,$config,
+ "SELECT COUNT(*) FROM
$config[sql_usergroup_tabl
e] WHERE groupname = '$group';");
+ if ($search2) {
+ if
(@da_sql_num_rows($search,$config)){
+ while( $row2 =
@da_sql_fetch_arr
ay($search2,$config) ){
+ $num_members =
$row2['co
unt'];
+ }
+ }
+ }
+ else
+ echo "<b>Database query failed:
" . da_s
ql_error($link,$config) . "</b><br>\n";
echo <<<EOM
<tr align=center>
<td>$num</td>
Am Fre, 2003-09-12 um 15.52 schrieb Ulrich Walcher:
> Hi,
> a little patch that solves the problem of groups with no members
> assigned not being displayed. (At least it works for Postgres).
>
> OoLee
>
> --- /usr/local/cvs/radiusd/dialup_admin/htdocs/show_groups.php3
> 2003-05-11 16:03:37.000000000 +0200
> +++ /usr/local/dialup_admin/htdocs/show_groups.php3 2003-09-12
> 15:45:18.000000000 +0200
> @@ -58,13 +58,23 @@
> $link = @da_sql_pconnect($config);
> if ($link){
> $search = @da_sql_query($link,$config,
> - "SELECT COUNT(*),GroupName FROM $config[sql_usergroup_table]
> GROUP BY GroupName;");
> + "SELECT DISTINCT c.groupname FROM $config[sql_groupcheck_table]
> c CROSS JOIN $config[sql_groupreply_table] r;");
> if ($search){
> if (@da_sql_num_rows($search,$config)){
> while( $row =
> @da_sql_fetch_array($search,$config) ){
> $num++;
> - $group = $row[GroupName];
> - $num_members = $row['COUNT(*)'];
> + $group = $row[groupname];
> + $search2 = @da_sql_query($link,$config,
> + "SELECT COUNT(*) FROM
> $config[sql_usergroup_table] WHERE groupname = '$group';");
> + if ($search2) {
> + if
> (@da_sql_num_rows($search,$config)){
> + while( $row2 =
> @da_sql_fetch_array($search2,$config) ){
> + $num_members =
> $row2['count'];
> + }
> + }
> + }
> + else
> + echo "<b>Database query failed:
> " . da_sql_error($link,$config) . "</b><br>\n";
> echo <<<EOM
> <tr align=center>
> <td>$num</td>
>
>
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
