aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorFabio Comuni <fabrix.xm@gmail.com>2011-04-08 16:52:58 +0200
committerFabio Comuni <fabrix.xm@gmail.com>2011-04-08 16:52:58 +0200
commit0e033eaa433aa44eb1d2ffc96cbd1b26278cebb8 (patch)
tree1e0e7913b6e574c1235f2c856b0cd8ecde6b959f
parent969cc6996a18290d234101fb9b245d27d4a6314a (diff)
downloadvolse-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.php13
1 files changed, 9 insertions, 4 deletions
diff --git a/boot.php b/boot.php
index 5d604599b..47e0a3afe 100644
--- a/boot.php
+++ b/boot.php
@@ -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;