X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=mod%2Fwall_upload.php;h=4cd4e5f52d853933d73f3486486887e9b7b38b61;hb=d4b2d3bf8a64e1fef8dbd88dbd625acbdef4a0df;hp=3bd3d8dc2657c57c6854f39313a933766f999061;hpb=449b44fe4c9049f7bf93e0b2e688a1f7de404c97;p=friendica.git diff --git a/mod/wall_upload.php b/mod/wall_upload.php index 3bd3d8dc26..4cd4e5f52d 100644 --- a/mod/wall_upload.php +++ b/mod/wall_upload.php @@ -9,7 +9,7 @@ function wall_upload_post(&$a) { if($a->argc > 1) { if(! x($_FILES,'media')) { $nick = $a->argv[1]; - $r = q("SELECT `user`.*, `contact`.`id` FROM `user` LEFT JOIN `contact` on `user`.`uid` = `contact`.`uid` WHERE `user`.`nickname` = '%s' AND `user`.`blocked` = 0 and `contact`.`self` = 1 LIMIT 1", + $r = q("SELECT `user`.*, `contact`.`id` FROM `user` INNER JOIN `contact` on `user`.`uid` = `contact`.`uid` WHERE `user`.`nickname` = '%s' AND `user`.`blocked` = 0 and `contact`.`self` = 1 LIMIT 1", dbesc($nick) ); @@ -18,7 +18,7 @@ function wall_upload_post(&$a) { } else { $user_info = api_get_user($a); - $r = q("SELECT `user`.*, `contact`.`id` FROM `user` LEFT JOIN `contact` on `user`.`uid` = `contact`.`uid` WHERE `user`.`nickname` = '%s' AND `user`.`blocked` = 0 and `contact`.`self` = 1 LIMIT 1", + $r = q("SELECT `user`.*, `contact`.`id` FROM `user` INNER JOIN `contact` on `user`.`uid` = `contact`.`uid` WHERE `user`.`nickname` = '%s' AND `user`.`blocked` = 0 and `contact`.`self` = 1 LIMIT 1", dbesc($user_info['screen_name']) ); }