diff options
| author | Zach Copley <zach@status.net> | 2010-01-11 14:11:43 -0800 |
|---|---|---|
| committer | Zach Copley <zach@status.net> | 2010-01-24 16:36:03 -0800 |
| commit | c78937537ed17eabb665ec6e4344b564799cbccc (patch) | |
| tree | b8893746e5e2d9e7ced2b1f4c8406db76b2b990f /classes/Profile.php | |
| parent | 11bd98025c1e41921359b634461772d22a1c059f (diff) | |
Better detial in connected OAuth applications list
Diffstat (limited to 'classes/Profile.php')
| -rw-r--r-- | classes/Profile.php | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/classes/Profile.php b/classes/Profile.php index 687215b11..fef2a2171 100644 --- a/classes/Profile.php +++ b/classes/Profile.php @@ -355,10 +355,11 @@ class Profile extends Memcached_DataObject function getApplications($offset = 0, $limit = null) { $qry = - 'SELECT oauth_application_user.* ' . - 'FROM oauth_application_user ' . - 'WHERE profile_id = %d ' . - 'ORDER BY created DESC '; + 'SELECT a.* ' . + 'FROM oauth_application_user u, oauth_application a ' . + 'WHERE u.profile_id = %d ' . + 'AND a.id = u.application_id ' . + 'ORDER BY u.created DESC '; if ($offset > 0) { if (common_config('db','type') == 'pgsql') { |