aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorredmatrix <redmatrix@redmatrix.me>2015-06-14 21:19:13 -0700
committerredmatrix <redmatrix@redmatrix.me>2015-06-14 21:19:13 -0700
commitd2178e43f620f6de2d7903b9d2428a2d9ef851ed (patch)
tree3137b983d865f5cfac099eebdad6f08351775760
parentbe0459a98b9c047e4cf89b835fd35a32da51ca31 (diff)
downloadvolse-hubzilla-d2178e43f620f6de2d7903b9d2428a2d9ef851ed.tar.gz
volse-hubzilla-d2178e43f620f6de2d7903b9d2428a2d9ef851ed.tar.bz2
volse-hubzilla-d2178e43f620f6de2d7903b9d2428a2d9ef851ed.zip
sql errors after last major edit adventure
-rw-r--r--mod/connections.php2
-rw-r--r--mod/ping.php2
2 files changed, 2 insertions, 2 deletions
diff --git a/mod/connections.php b/mod/connections.php
index 481ccfb99..2f1a1fdf5 100644
--- a/mod/connections.php
+++ b/mod/connections.php
@@ -211,7 +211,7 @@ function connections_content(&$a) {
nav_set_selected('intros');
break;
case 'ifpending':
- $r = q("SELECT COUNT(abook.abook_id) AS total FROM abook left join xchan on abook.abook_xchan = xchan.xchan_hash where abook_channel = %d and abook_pending = 1 and abook_self = 0 and abook_ignored = 0 and xchan_deleted = 0 and xchan_orphan = 0)",
+ $r = q("SELECT COUNT(abook.abook_id) AS total FROM abook left join xchan on abook.abook_xchan = xchan.xchan_hash where abook_channel = %d and abook_pending = 1 and abook_self = 0 and abook_ignored = 0 and xchan_deleted = 0 and xchan_orphan = 0 ",
intval(local_channel())
);
if($r && $r[0]['total']) {
diff --git a/mod/ping.php b/mod/ping.php
index 9af234514..16c72f5e6 100644
--- a/mod/ping.php
+++ b/mod/ping.php
@@ -405,7 +405,7 @@ function ping_init(&$a) {
$t2 = dba_timer();
if($vnotify & VNOTIFY_INTRO) {
- $intr = q("SELECT COUNT(abook.abook_id) AS total FROM abook left join xchan on abook.abook_xchan = xchan.xchan_hash where abook_channel = %d and abook_pending = 1 and abook_self = 0 and abook_ignored = 0 and xchan_deleted = 0 and xchan_orphan = 0)",
+ $intr = q("SELECT COUNT(abook.abook_id) AS total FROM abook left join xchan on abook.abook_xchan = xchan.xchan_hash where abook_channel = %d and abook_pending = 1 and abook_self = 0 and abook_ignored = 0 and xchan_deleted = 0 and xchan_orphan = 0 ",
intval(local_channel())
);