diff options
| author | redmatrix <redmatrix@redmatrix.me> | 2015-06-14 21:19:13 -0700 |
|---|---|---|
| committer | redmatrix <redmatrix@redmatrix.me> | 2015-06-14 21:19:13 -0700 |
| commit | d2178e43f620f6de2d7903b9d2428a2d9ef851ed (patch) | |
| tree | 3137b983d865f5cfac099eebdad6f08351775760 | |
| parent | be0459a98b9c047e4cf89b835fd35a32da51ca31 (diff) | |
| download | volse-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.php | 2 | ||||
| -rw-r--r-- | mod/ping.php | 2 |
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()) ); |