Changeset 26619 for extensions/oAuth/include

Timestamp:

Jan 11, 2014, 2:11:21 PM (10 years ago)

Author:

mistic100

Message:

move "oauth_id" field to user + display 16px icon on users list

Location:

extensions/oAuth/include

Files:

• admin_events.inc.php (added)
• functions.inc.php (modified) (1 diff)
• public_events.inc.php (modified) (2 diffs)

extensions/oAuth/include/functions.inc.php

@@ -62 +62 @@
 function get_oauth_id($user_id)
 {
-  global $conf;
-  
   $query = '
-SELECT oauth_id FROM ' . USERS_TABLE . '
-  WHERE ' . $conf['user_fields']['id'] . ' = ' . $user_id . '
+SELECT oauth_id FROM ' . USER_INFOS_TABLE . '
+  WHERE user_id = ' . $user_id . '
   AND oauth_id != ""
 ;';

extensions/oAuth/include/public_events.inc.php

@@ -28 +28 @@
   
   $query = '
-SELECT oauth_id FROM ' . USERS_TABLE . '
+SELECT oauth_id
+  FROM ' . USER_INFOS_TABLE . ' AS i
+    INNER JOIN ' . USERS_TABLE . ' AS u
+    ON i.user_id = u.' . $conf['user_fields']['id'] . '
   WHERE ' . $conf['user_fields']['username'] . ' = "' . pwg_db_real_escape_string($username) . '"
   AND oauth_id != ""
@@ -125 +128 @@
           // update oauth field
           $query = '
-UPDATE ' . USERS_TABLE . '
+UPDATE ' . USER_INFOS_TABLE . '
   SET oauth_id = "' . $oauth_id . '"
-  WHERE ' . $conf['user_fields']['id'] . ' = ' . $user_id . '
+  WHERE user_id = ' . $user_id . '
 ;';
           pwg_query($query);