[0003658] Errors during reference line edition when no table prefix is used.

[fa-stable.git] / includes / db / class.reflines_db.inc

diff --git a/includes/db/class.reflines_db.inc b/includes/db/class.reflines_db.inc
index 344a18bf47e2eeda14a59ac117abfb41cd1d9d98..47976504a550f29cbbaa7f5db4f4bf7993221d5c 100644 (file)
--- a/includes/db/class.reflines_db.inc
+++ b/includes/db/class.reflines_db.inc
@@ -79,12 +79,12 @@ class reflines_db extends data_set {
        {
 
                $sql = "SELECT *
-                       FROM (SELECT r.* FROM 0_refs r 
+                       FROM (SELECT r.* FROM ".TB_PREF."refs r 
                                LEFT JOIN ".TB_PREF."voided as v
                                        ON r.id=v.id AND r.type=v.type
                                WHERE r.type=".db_escape($trans_type)." AND ISNULL(v.id)
                                ) ref
-                       LEFT JOIN 0_reflines line ON ref.type=line.trans_type AND substr(ref.reference,1, LENGTH(line.prefix))= line.prefix AND line.prefix<>''
+                       LEFT JOIN ".TB_PREF."reflines line ON ref.type=line.trans_type AND substr(ref.reference,1, LENGTH(line.prefix))= line.prefix AND line.prefix<>''
                        WHERE ".($prefix == '' ? "ISNULL(prefix)" : "prefix=".db_escape($prefix));
 
                $res = db_query($sql, "cannot check reference line");
@@ -139,6 +139,7 @@ class reflines_db extends data_set {
        function count($type, $all=false)
        {
                $sql = "SELECT count(*) FROM ".TB_PREF."reflines WHERE trans_type=".db_escape($type);
+
                if (!$all)
                        $sql .= " AND !inactive";
                $result = db_query($sql, "cannot retreive refline count for transaction type $type");
@@ -149,7 +150,7 @@ class reflines_db extends data_set {
        /*
                Recognize refline by reference prefix
        */
-       function find_refline_id($reference, $type, $fallback = true)
+       function find_refline_id($reference, $type, $fallback=true)
        {
                $sql = "SELECT * FROM ".TB_PREF."reflines WHERE trans_type=".db_escape($type)
                        ." AND CHAR_LENGTH(`prefix`) AND LEFT('$reference', CHAR_LENGTH(`prefix`)) = `prefix`";
@@ -167,7 +168,7 @@ class reflines_db extends data_set {
        function save_next($type, $reference, $line=null)
        {
            $sql = "UPDATE ".TB_PREF."reflines SET pattern=SUBSTRING(" . db_escape(trim($reference)) .", LENGTH(`prefix`)+1)"
-               . " WHERE trans_type = ".db_escape($type) . " AND ";
+               . " WHERE trans_type = ".db_escape($type)." AND ";
 
                if (isset($line))
                        $sql .= "`id`=".db_escape($line);