X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=includes%2Fdb%2Freferences_db.inc;h=48b16fad23c12d9d571a24bd74590b9679f3d1b0;hb=8864b1ec0fd3321e510511ef22614bc36845540e;hp=9b769859da7269053c91462100cb78fa56de1dab;hpb=46d3debec422c5ad5ee99c4acfe42bfa60308afb;p=fa-stable.git diff --git a/includes/db/references_db.inc b/includes/db/references_db.inc index 9b769859..48b16fad 100644 --- a/includes/db/references_db.inc +++ b/includes/db/references_db.inc @@ -1,5 +1,14 @@ . +***********************************************************************/ //-------------------------------------------------------------------------------------------------- function get_reference($type, $id) @@ -14,7 +23,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 +52,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"); }