X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=includes%2Fdb%2Freferences_db.inc;h=a41597f9701d1e69e8abaadeb9d1594b1798040e;hb=c55119ade6f4c6bd4acdfa55c46870187f408978;hp=9b769859da7269053c91462100cb78fa56de1dab;hpb=2489ca7e5fc4414b7b70132a23090fd687af5f1b;p=fa-stable.git diff --git a/includes/db/references_db.inc b/includes/db/references_db.inc index 9b769859..a41597f9 100644 --- a/includes/db/references_db.inc +++ b/includes/db/references_db.inc @@ -14,7 +14,7 @@ function get_reference($type, $id) function add_reference($type, $id, $reference) { $sql = "INSERT INTO ".TB_PREF."refs (type, id, reference) - VALUES ($type, $id, " . db_quote(trim($reference)) . ")"; + VALUES ($type, $id, " . db_escape(trim($reference)) . ")"; db_query($sql, "could not add reference entry"); } @@ -43,7 +43,7 @@ function find_reference($type, $reference) function save_next_reference($type, $reference) { - $sql = "UPDATE ".TB_PREF."sys_types SET next_reference=" . db_quote(trim($reference)) . " WHERE type_id = $type"; + $sql = "UPDATE ".TB_PREF."sys_types SET next_reference=" . db_escape(trim($reference)) . " WHERE type_id = $type"; db_query($sql, "The next transaction ref for $type could not be updated"); }