X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=includes%2Fdb%2Fcrm_contacts_db.inc;h=e5a91fb1be4561bbca0c811b37074ab15ef63402;hb=d8d40a67b517dd35425a1fa0eb02f84c3f9fd843;hp=8623c8e0043525755a07ff8a2248ef76dbc7556e;hpb=fa43a9c974d05b77517a0d8e3e510ef4a088632e;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];
+}
+
+