- $r = q("SELECT `user`.`prvkey`, `contact`.`addr`, `user`.`nickname`, `contact`.`nick` FROM `user`
- INNER JOIN `contact` ON `contact`.`uid` = `user`.`uid`
- WHERE `user`.`uid` = %d", intval($item[0]["uid"]));
+ $r = q(
+ "SELECT `user`.`prvkey`, `contact`.`addr`, `user`.`nickname`, `contact`.`nick` FROM `user`
+ INNER JOIN `contact` ON `contact`.`uid` = `user`.`uid` AND `contact`.`self`
+ WHERE `user`.`uid` = %d",
+ intval($item[0]["uid"])
+ );
+