diff options
author | Fabio Comuni <fabrix.xm@gmail.com> | 2011-04-08 16:52:58 +0200 |
---|---|---|
committer | Fabio Comuni <fabrix.xm@gmail.com> | 2011-04-08 16:52:58 +0200 |
commit | 0e033eaa433aa44eb1d2ffc96cbd1b26278cebb8 (patch) | |
tree | 1e0e7913b6e574c1235f2c856b0cd8ecde6b959f | |
parent | 969cc6996a18290d234101fb9b245d27d4a6314a (diff) | |
download | volse-hubzilla-0e033eaa433aa44eb1d2ffc96cbd1b26278cebb8.tar.gz volse-hubzilla-0e033eaa433aa44eb1d2ffc96cbd1b26278cebb8.tar.bz2 volse-hubzilla-0e033eaa433aa44eb1d2ffc96cbd1b26278cebb8.zip |
Fix query for authors in item_photo_menu(), cache authors from extract_item_authors()
-rw-r--r-- | boot.php | 13 |
1 files changed, 9 insertions, 4 deletions
@@ -2662,14 +2662,19 @@ function extract_item_authors($arr,$uid) { // pre-quoted, don't put quotes on %s if(count($urls)) { - $r = q("SELECT `id`,`url` FROM `contact` WHERE `uid` = %d AND `url` IN ( %s ) AND `network` = 'dfrn' AND `self` = 0 AND `blocked` = 0 ", + $r = q("SELECT `id`,`network`,`url` FROM `contact` WHERE `uid` = %d AND `url` IN ( %s ) AND `self` = 0 AND `blocked` = 0 ", intval($uid), implode(',',$urls) ); if(count($r)) { $ret = array(); - foreach($r as $rr) - $ret[$rr['url']] = $rr['id']; + $authors = array(); + foreach($r as $rr){ + if ($rr['network']=='dfrn') + $ret[$rr['url']] = $rr['id']; + $authors[$r['url']]= $rr; + } + $a->authors = $authors; return $ret; } } @@ -2681,7 +2686,7 @@ function item_photo_menu($item){ $a = get_app(); if (!isset($a->authors)){ - $rr = q("SELECT id, network, url FROM contact WHERE uid=%d AND self!=1", intval(local_user())); + $rr = q("SELECT `id`, `network`, `url` FROM `contact` WHERE `uid`=%d AND `self`=0 AND `blocked`=0 ", intval(local_user())); $authors = array(); foreach($rr as $r) $authors[$r['url']]= $r; $a->authors = $authors; |