Removed CCA, (currencyconverterapi.com) is no longer working. Updated url from google...

[fa-stable.git] / gl / includes / db / gl_db_trans.inc

diff --git a/gl/includes/db/gl_db_trans.inc b/gl/includes/db/gl_db_trans.inc
index 4e907726bdf56ef65c8cd4c05964395f7d8d77d6..feb17f09baa3838bfe80a3ebc01b395ea894cce4 100644 (file)
--- a/gl/includes/db/gl_db_trans.inc
+++ b/gl/includes/db/gl_db_trans.inc
@@ -148,7 +148,7 @@ function get_gl_transactions($from_date, $to_date, $trans_no=0,
         AND gl.amount <> 0"; 
 
     if ($trans_no > 0)
-        $sql .= " AND gl.type_no LIKE ".db_escape('%'.$trans_no);;
+        $sql .= " AND gl.type_no LIKE ".db_escape('%'.$trans_no);
 
     if ($account != null)
         $sql .= " AND gl.account = ".db_escape($account);
@@ -468,8 +468,10 @@ function add_trans_tax_details($trans_type, $trans_no, $tax_id, $rate, $included
                (trans_type, trans_no, tran_date, tax_type_id, rate, ex_rate,
                        included_in_price, net_amount, amount, memo, reg_type)
                VALUES (".db_escape($trans_type)."," . db_escape($trans_no).",'"
-                               .date2sql($tran_date)."',".db_escape($tax_id).","
-                               .db_escape($rate).",".db_escape($ex_rate).",".($included ? 1:0).","
+                               .date2sql($tran_date)."',"
+                               .(int)($tax_id).","
+                               .(float)($rate).","
+                               .(float)($ex_rate).",".($included ? 1:0).","
                                .db_escape($net_amount).","
                                .db_escape($amount).",".db_escape($memo).",".db_escape($reg_type, true).")";