Moved all SQL statements from PHP files into relevant *_db.inc files.

[fa-stable.git] / admin / db / printers_db.inc

diff --git a/admin/db/printers_db.inc b/admin/db/printers_db.inc
index c1d80368b1d156acb76922d5a9a5a4d24c7eb33d..b873ee2e3e389589c253b1f89c11e78b937a4918 100644 (file)
--- a/admin/db/printers_db.inc
+++ b/admin/db/printers_db.inc
@@ -41,6 +41,11 @@ function get_printer($id)
                return  db_fetch($result);
 }
 
+function delete_printer($id)
+{
+       $sql="DELETE FROM ".TB_PREF."printers WHERE id=".db_escape($id);
+       db_query($sql,"could not delete printer definition");
+}
 //============================================================================
 // printer profiles functions
 //
@@ -101,4 +106,12 @@ function get_print_profile($name)
        return db_query($sql,"could not get printing profile");
 }
 
+function printer_has_profile($id)
+{
+       $sql= "SELECT COUNT(*) FROM ".TB_PREF."print_profiles WHERE printer = ".db_escape($id);
+       $result = db_query($sql,"check printers relations failed");
+       $myrow = db_fetch_row($result);
+       return ($myrow[0] > 0); 
+}
+
 ?>
\ No newline at end of file