aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2012-04-12 07:48:28 -0700
committerfriendica <info@friendica.com>2012-04-12 07:48:28 -0700
commit73487989c0a27deae38881379b052c5002b225ae (patch)
tree4668fbb9b5cfcb1688bbeb8b9dd81ff213131b95
parent60871555f539caec07f2dcfe37f11fc090bac1be (diff)
downloadvolse-hubzilla-73487989c0a27deae38881379b052c5002b225ae.tar.gz
volse-hubzilla-73487989c0a27deae38881379b052c5002b225ae.tar.bz2
volse-hubzilla-73487989c0a27deae38881379b052c5002b225ae.zip
query to find un-grouped contacts
-rw-r--r--include/Contact.php13
1 files changed, 12 insertions, 1 deletions
diff --git a/include/Contact.php b/include/Contact.php
index ee434cb6d..8d893cf70 100644
--- a/include/Contact.php
+++ b/include/Contact.php
@@ -173,4 +173,15 @@ function random_profile() {
if(count($r))
return dirname($r[0]['url']);
return '';
-} \ No newline at end of file
+}
+
+
+function contacts_not_grouped($uid) {
+ $r = q("select * from contact where uid = %d and self = 0 and id not in (select distinct(`contact-id`) from group_member where uid = %d) ",
+ intval($uid),
+ intval($uid)
+ );
+
+ return $r;
+}
+