X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fsearch%2Fsqlradius_usage.html;h=494a275912ab0e09229618bb06408911c6c82ef1;hp=6b1806ee38e1d4a66c75d9a0c3f62296404f65d6;hb=ae2ce7f3fc2a0fe00f05145ce64e8b6b8c034631;hpb=ade06c71a2159e9079951c00662843455b01a5d8

diff --git a/httemplate/search/sqlradius_usage.html b/httemplate/search/sqlradius_usage.html
index 6b1806ee3..494a27591 100644
--- a/httemplate/search/sqlradius_usage.html
+++ b/httemplate/search/sqlradius_usage.html
@@ -74,12 +74,16 @@ if ( $opt{'agentnum'} =~ /^(\d+)$/ ) {
   my @agentnums = grep /^(\d+)$/, $cgi->param('agentnum');
 
   if ( ! @agentnums ) {
-    @include_agents = qsearch('agent', {});
+    @include_agents = qsearch({ 'table'     => 'agent',
+                                'hashref'   => { 'disabled'=>'' },
+                                'extra_sql' => ' AND '. $curuser->agentnums_sql,
+                             });
   } elsif ( scalar(@agentnums) == 1 ) {
     $agentnum = $agentnums[0];
   } else {
     @include_agents = qsearch({ 'table'     => 'agent',
-                                'extra_sql' => 'WHERE agentnum IN ('.
+                                'hashref'   => { 'disabled' => '', },
+                                'extra_sql' => 'AND agentnum IN ('.
                                                  join(',',@agentnums). ') '.
                                                ' AND '. $curuser->agentnums_sql,
                              });