Changeset 26619 for extensions/oAuth/maintain.inc.php

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

File:

• extensions/oAuth/maintain.inc.php (modified) (2 diffs)

extensions/oAuth/maintain.inc.php

@@ -32 +32 @@
     }
     
+    $result = pwg_query('SHOW COLUMNS FROM `' . USER_INFOS_TABLE . '` LIKE "oauth_id";');
+    if (!pwg_db_num_rows($result))
+    {
+      pwg_query('ALTER TABLE `' . USER_INFOS_TABLE . '` ADD `oauth_id` VARCHAR(255) DEFAULT NULL;');
+    }
+    
+    // move field from users table to user_infos
     $result = pwg_query('SHOW COLUMNS FROM `' . USERS_TABLE . '` LIKE "oauth_id";');
-    if (!pwg_db_num_rows($result))
-    {      
-      pwg_query('ALTER TABLE `' . USERS_TABLE . '` ADD `oauth_id` VARCHAR(255) DEFAULT NULL;');
+    if (pwg_db_num_rows($result))
+    {
+      $query = '
+UPDATE `' . USER_INFOS_TABLE . '` AS i
+  SET oauth_id = (
+    SELECT oauth_id
+      FROM `' . USERS_TABLE . '` AS u
+      WHERE u.'.$conf['user_fields']['id'].' = i.user_id
+    )
+;';
+      pwg_query($query);
+      
+      pwg_query('ALTER TABLE `' . USERS_TABLE . '` DROP `oauth_id`;');
     }
     
@@ -76 +93 @@
     conf_delete_param('oauth');
 
-    pwg_query('ALTER TABLE `'. USERS_TABLE .'` DROP `oauth_id`;');
+    pwg_query('ALTER TABLE `'. USER_INFOS_TABLE .'` DROP `oauth_id`;');
     
     @unlink($this->file);