Cleanup: various random sql queries found in UI files moved to database interface...

[fa-stable.git] / includes / references.inc

diff --git a/includes/references.inc b/includes/references.inc
index 7f79fbc7157901fc954712e5f7cf370bcf4060e9..38bd84cdceb541470d38674b2b4f1eb638d5c187 100644 (file)
--- a/includes/references.inc
+++ b/includes/references.inc
@@ -100,44 +100,4 @@ class references
        }
 }
 
-//----------------------------------------------------------------------------
-
-function is_new_reference($ref, $type)
-{
-       $db_info = get_systype_db_info($type);
-       $db_name = $db_info[0];
-       $db_type = $db_info[1];
-       $db_trans = $db_info[2];
-       $db_ref = $db_info[3];
-       
-       $ref = db_escape(trim($ref));
-       $type = db_escape($type);
-       
-       if ($db_ref == null) { // journal or bank trans store references in refs table
-               $db_name = TB_PREF."refs";
-               $db_type = 'type';
-               $db_trans = 'id';
-               $db_ref = 'reference';
-       }
-
-       if ($db_type != null) {
-               $sql = "SELECT $db_ref FROM $db_name 
-                       LEFT JOIN ".TB_PREF."voided v ON 
-                               $db_name.$db_type=v.type AND $db_name.$db_trans=v.id
-                       WHERE $db_name.$db_ref=$ref AND ISNULL(v.id)
-                               AND $db_name.$db_type=$type";
-       } else {
-               $sql = "SELECT $db_ref FROM $db_name 
-                       LEFT JOIN ".TB_PREF."voided v ON 
-                               v.type=$type AND $db_name.$db_trans=v.id
-                       WHERE $db_ref=$ref AND ISNULL(v.id)";
-       }
-
-       $result = db_query($sql, "could not test for unique reference");
-
-       return (db_num_rows($result) == 0);
-
-}
-
-
 ?>
\ No newline at end of file