summaryrefslogtreecommitdiff
path: root/classes
diff options
context:
space:
mode:
authorZach Copley <zach@status.net>2010-01-11 14:11:43 -0800
committerZach Copley <zach@status.net>2010-01-24 16:36:03 -0800
commitc78937537ed17eabb665ec6e4344b564799cbccc (patch)
treeb8893746e5e2d9e7ced2b1f4c8406db76b2b990f /classes
parent11bd98025c1e41921359b634461772d22a1c059f (diff)
Better detial in connected OAuth applications list
Diffstat (limited to 'classes')
-rw-r--r--classes/Profile.php9
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') {