From b01ee3e9d7061a1b3b4887980b0542371be9bcd8 Mon Sep 17 00:00:00 2001
From: Ivan Kohler <ivan@freeside.biz>
Date: Wed, 16 Jul 2014 06:19:03 -0700
Subject: REST API, RT#28181

---
 httemplate/REST/1.0/.cust_bill.swp   | Bin 12288 -> 0 bytes
 httemplate/REST/1.0/.cust_main.swp   | Bin 12288 -> 0 bytes
 httemplate/REST/1.0/.cust_pkg.swp    | Bin 12288 -> 0 bytes
 httemplate/REST/1.0/.part_pkg.swp    | Bin 12288 -> 0 bytes
 httemplate/REST/1.0/.phone_avail.swp | Bin 12288 -> 0 bytes
 httemplate/REST/1.0/.rate_detail.swp | Bin 12288 -> 0 bytes
 httemplate/REST/1.0/rate_detail      |   2 +-
 7 files changed, 1 insertion(+), 1 deletion(-)
 delete mode 100644 httemplate/REST/1.0/.cust_bill.swp
 delete mode 100644 httemplate/REST/1.0/.cust_main.swp
 delete mode 100644 httemplate/REST/1.0/.cust_pkg.swp
 delete mode 100644 httemplate/REST/1.0/.part_pkg.swp
 delete mode 100644 httemplate/REST/1.0/.phone_avail.swp
 delete mode 100644 httemplate/REST/1.0/.rate_detail.swp

diff --git a/httemplate/REST/1.0/.cust_bill.swp b/httemplate/REST/1.0/.cust_bill.swp
deleted file mode 100644
index 44d4de7a9..000000000
Binary files a/httemplate/REST/1.0/.cust_bill.swp and /dev/null differ
diff --git a/httemplate/REST/1.0/.cust_main.swp b/httemplate/REST/1.0/.cust_main.swp
deleted file mode 100644
index d785784d3..000000000
Binary files a/httemplate/REST/1.0/.cust_main.swp and /dev/null differ
diff --git a/httemplate/REST/1.0/.cust_pkg.swp b/httemplate/REST/1.0/.cust_pkg.swp
deleted file mode 100644
index 451a98554..000000000
Binary files a/httemplate/REST/1.0/.cust_pkg.swp and /dev/null differ
diff --git a/httemplate/REST/1.0/.part_pkg.swp b/httemplate/REST/1.0/.part_pkg.swp
deleted file mode 100644
index 547a79eee..000000000
Binary files a/httemplate/REST/1.0/.part_pkg.swp and /dev/null differ
diff --git a/httemplate/REST/1.0/.phone_avail.swp b/httemplate/REST/1.0/.phone_avail.swp
deleted file mode 100644
index a65bb2748..000000000
Binary files a/httemplate/REST/1.0/.phone_avail.swp and /dev/null differ
diff --git a/httemplate/REST/1.0/.rate_detail.swp b/httemplate/REST/1.0/.rate_detail.swp
deleted file mode 100644
index 8d46a280f..000000000
Binary files a/httemplate/REST/1.0/.rate_detail.swp and /dev/null differ
diff --git a/httemplate/REST/1.0/rate_detail b/httemplate/REST/1.0/rate_detail
index 54e55de6c..6ae503190 100644
--- a/httemplate/REST/1.0/rate_detail
+++ b/httemplate/REST/1.0/rate_detail
@@ -7,7 +7,7 @@ my $extra_sql = '';
 if ( $cgi->param('countrycode') =~ /^\+?(\d+)$/ ) {
   my $countrycode = $1;
   $extra_sql = "
-    WHERE EXISTS ( SELECT 1 rate_region
+    WHERE EXISTS ( SELECT 1 FROM rate_region
                      WHERE rate_detail.dest_regionnum = rate_region.regionnum
                        AND countrycode = '$countrycode'
   ";
-- 
cgit v1.2.1