[Phpgroupware-cvs] phpgwapi/inc class.accounts_sql.inc.php, 1.80.2.8.2.34

[skwashd]

Update of phpgwapi/inc

Modified Files:
     Branch: Version-0_9_16-branch
            class.accounts_sql.inc.php lines: +7 -6

Log Message:
make it so any accounts not groups are listed as not having contacts

====================================================
Index: phpgwapi/inc/class.accounts_sql.inc.php
diff -u phpgwapi/inc/class.accounts_sql.inc.php:1.80.2.8.2.33 
phpgwapi/inc/class.accounts_sql.inc.php:1.80.2.8.2.34
--- phpgwapi/inc/class.accounts_sql.inc.php:1.80.2.8.2.33       Tue Jun 15 
13:23:09 2004
+++ phpgwapi/inc/class.accounts_sql.inc.php     Sun Nov  6 21:41:22 2005
@@ -262,10 +262,10 @@

                        if (! $person_id)
                        {
-                               return False;
+                               return 0;
                        }

-                       if($person_list[$person_id])
+                       if( isset($person_list[$person_id]) )
                        {
                                return $person_list[$person_id];
                        }
@@ -278,7 +278,7 @@
                        }
                        else
                        {
-                               $person_list[$person_id] = False;
+                               $person_list[$person_id] = 0;
                        }
                        return $person_list[$person_id];
                }
@@ -521,8 +521,9 @@

                function get_account_without_contact()
                {
-                       $sql = 'SELECT account_id FROM phpgw_accounts '
-                               . 'WHERE person_id IS NULL OR person_id = 0';
+                       $sql = 'SELECT account_id FROM phpgw_accounts'
+                               . " WHERE account_type = 'u'"
+                                       . 'AND (person_id IS NULL OR person_id 
= 0)';
                        $this->db->query($sql,__LINE__,__FILE__);
                        while ($this->db->next_record())
                        {