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
