and here also...
--- /usr/local/cvs/radiusd/dialup_admin/lib/sql/defaults.php3
2003-01-28 15:14:53.000000000 +0100
+++ /usr/local/dialup_admin/lib/sql/defaults.php3 2003-09-16
15:18:27.000000000 +0200
@@ -121,10 +121,10 @@
$link = @da_sql_pconnect($config);
if ($link){
$res = @da_sql_query($link,$config,
- "SELECT DISTINCT GroupName FROM
$config[sql_usergroup_table];");
+ "SELECT DISTINCT s.groupname FROM
$config[sql_groupcheck_table] CROSS JOIN (SELECT DISTINCT u.groupname
FROM $config[sql_groupreply_table] CROSS JOIN
$config[sql_usergroup_table] u) as s;");
if ($res){
while(($row =
@da_sql_fetch_array($res,$config)))
- $member_groups[] = $row[GroupName];
+ $member_groups[] = $row[groupname];
}
else
echo "<b>Database query failed: " .
da_sql_error($link,$config) . "</b><br>\n";
Am Fre, 2003-09-12 um 16.08 schrieb Ulrich Walcher:
> Oops,
> forgot to add this one...
>
> OoLee
>
> --- /usr/local/cvs/radiusd/dialup_admin/lib/sql/defaults.php3
> 2003-01-28 15:14:53.000000000 +0100
> +++ /usr/local/dialup_admin/lib/sql/defaults.php3 2003-09-12
> 16:04:15.000000000 +0200
> @@ -121,10 +121,10 @@
> $link = @da_sql_pconnect($config);
> if ($link){
> $res = @da_sql_query($link,$config,
> - "SELECT DISTINCT GroupName FROM
> $config[sql_usergroup_table];");
> + "SELECT DISTINCT c.groupname FROM
> $config[sql_groupcheck_table] c CROSS JOIN $config[sql_groupreply_table]
> r;");
> if ($res){
> while(($row =
> @da_sql_fetch_array($res,$config)))
> - $member_groups[] = $row[GroupName];
> + $member_groups[] = $row[groupname];
> }
> else
> echo "<b>Database query failed: " .
> da_sql_error($link,$config) . "</b><br>\n";
>
>
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
