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

[fa-stable.git] / admin / crm_categories.php

diff --git a/admin/crm_categories.php b/admin/crm_categories.php
index 372faa71637995cff71b84c3f94d9658f5060d93..59166a3a3f9a91f266b04f06f340e47937d71306 100644 (file)
--- a/admin/crm_categories.php
+++ b/admin/crm_categories.php
@@ -52,20 +52,11 @@ if ($Mode=='ADD_ITEM' || $Mode=='UPDATE_ITEM')
        }
 } 
 
-function key_in_crm_contacts($id) // extra function for testing foreign concatenated key. Joe 02.09.2013.
-{
-       $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];
-}
-
 if ($Mode == 'Delete')
 {
        $cancel_delete = 0;
 
-       if (key_in_crm_contacts($selected_id))
+       if (is_crm_category_used($selected_id))
        {
                $cancel_delete = 1;
                display_error(_("Cannot delete this category because there are contacts related to it."));