X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=includes%2Fdb%2Fcrm_contacts_db.inc;h=e5a91fb1be4561bbca0c811b37074ab15ef63402;hb=fe81fed711c71c611f844fb06fa0ea03c63fda3b;hp=8623c8e0043525755a07ff8a2248ef76dbc7556e;hpb=639cd64caec0c789bb7093c7b07d1a752daeebe9;p=fa-stable.git

diff --git a/includes/db/crm_contacts_db.inc b/includes/db/crm_contacts_db.inc
index 8623c8e0..e5a91fb1 100644
--- a/includes/db/crm_contacts_db.inc
+++ b/includes/db/crm_contacts_db.inc
@@ -300,4 +300,16 @@ function get_crm_contact($id)
 	return $ret;
 }
 
-?>
\ No newline at end of file
+/*
+	 Check for whether category is used in contacts.
+*/
+function is_crm_category_used($id)
+{
+	$row = get_crm_category($id);
+	$sql = "SELECT COUNT(*) FROM ".TB_PREF."crm_contacts WHERE type='".$row['type']."' AND action='".$row['action']."'";
+	$result = db_query($sql, "check relations for crm_contacts failed");
+	$contacts = db_fetch($result);
+	return $contacts[0];
+}
+
+