X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;ds=sidebyside;f=purchasing%2Fsupplier_invoice.php;h=ab2409d981f7cafa7aa8786d86af896a66ffb953;hb=54d84ff9a67620ab38c676cdbcf87853632724f0;hp=b1bd2ece237921d589dd3402bdb57646c2a927c8;hpb=2829455fee1259fb5013f382309cb3e61e9381ef;p=fa-stable.git

diff --git a/purchasing/supplier_invoice.php b/purchasing/supplier_invoice.php
index b1bd2ece..ab2409d9 100644
--- a/purchasing/supplier_invoice.php
+++ b/purchasing/supplier_invoice.php
@@ -110,7 +110,7 @@ if (isset($_POST['AddGLCodeToTrans'])){
 	$Ajax->activate('gl_items');
 	$input_error = false;
 
-	$sql = "SELECT account_code, account_name FROM ".TB_PREF."chart_master WHERE account_code='" . $_POST['gl_code'] . "'";
+	$sql = "SELECT account_code, account_name FROM ".TB_PREF."chart_master WHERE account_code=".db_escape($_POST['gl_code']);
 	$result = db_query($sql,"get account information");
 	if (db_num_rows($result) == 0)
 	{
@@ -195,10 +195,10 @@ function check_data()
 		return false;
 	}
 
-	$sql = "SELECT Count(*) FROM ".TB_PREF."supp_trans WHERE supplier_id='" 
-		. $_SESSION['supp_trans']->supplier_id . "' AND supp_reference='" 
-		. $_POST['supp_reference'] 
-		. "' AND ov_amount!=0"; // ignore voided invoice references
+	$sql = "SELECT Count(*) FROM ".TB_PREF."supp_trans WHERE supplier_id="
+		.db_escape($_SESSION['supp_trans']->supplier_id) . " AND supp_reference=" 
+		.db_escape( $_POST['supp_reference']) 
+		. " AND ov_amount!=0"; // ignore voided invoice references
 
 	$result=db_query($sql,"The sql to check for the previous entry of the same invoice failed");