diff options
| author | cvs2git <cvs2git> | 2004-04-07 09:08:35 +0000 |
|---|---|---|
| committer | cvs2git <cvs2git> | 2004-04-07 09:08:35 +0000 |
| commit | 022491d9d2723ca4d7d0718cdb1fd67e7652428e (patch) | |
| tree | fc1e50c0d78ecc401ef2214a6a11ee07242be0f8 /FS/bin/freeside-count-active-customers | |
| parent | 35effa1bf4ac902547615c816960bbc8db8e7256 (diff) | |
This commit was manufactured by cvs2svn to create tag 'NET_WHOIS_RAW_0_31'.NET_WHOIS_RAW_0_31
Diffstat (limited to 'FS/bin/freeside-count-active-customers')
| -rwxr-xr-x | FS/bin/freeside-count-active-customers | 17 |
1 files changed, 0 insertions, 17 deletions
diff --git a/FS/bin/freeside-count-active-customers b/FS/bin/freeside-count-active-customers deleted file mode 100755 index 759085a..0000000 --- a/FS/bin/freeside-count-active-customers +++ /dev/null @@ -1,17 +0,0 @@ -#!/bin/sh - -domain=$1 - -echo "\t -select count(*) from cust_main where - 0 < ( SELECT COUNT(*) FROM cust_pkg - WHERE cust_pkg.custnum = cust_main.custnum - AND ( cust_pkg.cancel IS NULL - OR cust_pkg.cancel = 0 - ) - ) - OR 0 = ( SELECT COUNT(*) FROM cust_pkg - WHERE cust_pkg.custnum = cust_main.custnum - ); -" | psql -U freeside -q $domain | head -1 - |