diff options
author | RedMatrix <info@friendica.com> | 2014-11-18 13:00:26 +1100 |
---|---|---|
committer | RedMatrix <info@friendica.com> | 2014-11-18 13:00:26 +1100 |
commit | 913dafc5937e876250c2f177e303f226e8255093 (patch) | |
tree | 118426791adaf2c4cd65a05f249f35c2260c3e8b /mod/poco.php | |
parent | 65a6121014b1b985d176ea482077400cfee1c3a9 (diff) | |
parent | e61dbf722d35b748ff57b1260f30b9ac0fda60aa (diff) | |
download | volse-hubzilla-913dafc5937e876250c2f177e303f226e8255093.tar.gz volse-hubzilla-913dafc5937e876250c2f177e303f226e8255093.tar.bz2 volse-hubzilla-913dafc5937e876250c2f177e303f226e8255093.zip |
Merge pull request #698 from habeascodice/master
some sql fixes
Diffstat (limited to 'mod/poco.php')
-rw-r--r-- | mod/poco.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mod/poco.php b/mod/poco.php index fc01fc565..3f932e92f 100644 --- a/mod/poco.php +++ b/mod/poco.php @@ -69,7 +69,7 @@ function poco_init(&$a) { if($system_mode) { $r = q("SELECT count(*) as `total` from abook where ( abook_flags & " . ABOOK_FLAG_SELF . - " )>0 and abook_channel in (select uid from pconfig where cat = 'system' and k = 'suggestme' and v = 1) "); + " )>0 and abook_channel in (select uid from pconfig where cat = 'system' and k = 'suggestme' and v = '1') "); } else { $r = q("SELECT count(*) as `total` from abook where abook_channel = %d @@ -93,7 +93,7 @@ function poco_init(&$a) { if($system_mode) { $r = q("SELECT abook.*, xchan.* from abook left join xchan on abook_xchan = xchan_hash where ( abook_flags & " . ABOOK_FLAG_SELF . - " )>0 and abook_channel in (select uid from pconfig where cat = 'system' and k = 'suggestme' and v = 1) limit %d offset %d ", + " )>0 and abook_channel in (select uid from pconfig where cat = 'system' and k = 'suggestme' and v = '1') limit %d offset %d ", intval($itemsPerPage), intval($startIndex) ); |