X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2Fbin%2Ffreeside-svcbroadband_update_speeds;h=8a6f33f7d5fe8f7c7f335eb6e66ba8e575d35411;hb=dc83512c36dc6bea2585abada4f88d714c600e55;hp=b3b257a5a5e3bf269677033ad41a7ac332bb5b70;hpb=3c1daaa7219fa4eef418a0a1e3ae70018ef6791e;p=freeside.git

diff --git a/FS/bin/freeside-svcbroadband_update_speeds b/FS/bin/freeside-svcbroadband_update_speeds
index b3b257a5a..8a6f33f7d 100755
--- a/FS/bin/freeside-svcbroadband_update_speeds
+++ b/FS/bin/freeside-svcbroadband_update_speeds
@@ -47,12 +47,12 @@ my @services = qsearch({
 });
 
 ### get list of all unprovisioned services
-my $ups_extra_sql = "where cust_pkg.cancel is null and pkg_svc.quantity > 0 and  pkg_svc.quantity > (select count(1) from cust_svc where  cust_svc.pkgnum = cust_pkg.pkgnum and  cust_svc.svcpart = pkg_svc.svcpart)  and pkg_svc.svcpart = $opt_s";
-my @unprovisioned_services = qsearchs({
-    'table'     => 'cust_pkg',
-    'addl_from' => 'JOIN pkg_svc using (pkgpart)',
-    'extra_sql' => $ups_extra_sql,
-});
+#my $ups_extra_sql = "where cust_pkg.cancel is null and pkg_svc.quantity > 0 and  pkg_svc.quantity > (select count(1) from cust_svc where  cust_svc.pkgnum = cust_pkg.pkgnum and  cust_svc.svcpart = pkg_svc.svcpart)  and pkg_svc.svcpart = $opt_s";
+#my @unprovisioned_services = qsearch({
+#    'table'     => 'cust_pkg',
+#    'addl_from' => 'JOIN pkg_svc using (pkgpart)',
+#    'extra_sql' => $ups_extra_sql,
+#});
 
 my $speed;
 $speed = 'package' if $opt_p;