Advertisement
Guest User

Untitled

a guest
Jul 18th, 2017
479
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 2.09 KB | None | 0 0
  1. FUNCTION staging_users_drush_import($initial_install = FALSE) {
  2.   // Import users
  3.   $query = _db_select_staging_users_w_staging_users_users_uid();
  4.   while ($result = db_fetch_object($query)) {
  5.     $user_info = array(
  6.       'name' => $result->user_name .' '. $result->user_id,
  7.       'mail' => $result->user_email,
  8.       'status' => $result->user_active ? 1 : 0,
  9.       'profile_company' => $result->user_company,
  10.       'init' => $result->user_email,
  11.     );
  12.     IF ($result->user_isadmin) {
  13.       $user_info['roles'] = array(
  14.         3 => 3,
  15.       );
  16.     }
  17.     IF ($result->uid) {
  18.       $user = user_load($result->uid);
  19.       $user = user_save($user, $user_info);
  20.     }
  21.     ELSE {
  22.       $user_info['pass'] = $result->user_password;
  23.       $user = user_save('', $user_info);
  24.       IF ($result->user_notified_new) {
  25.         $to = $result->user_email;
  26.         $name = $result->user_name;
  27.         $subject = variable_get('email_comp_user_email_subject', '');
  28.         $message = token_replace(variable_get('email_comp_user_email', ''), 'email_comp_user', $user);
  29.         $headers = 'From: '. variable_get('email_comp_admin_mail', variable_get('site_mail', ini_get('sendmail_from'))) . "\r\n";
  30.         IF (!$initial_install) {
  31.           // Test FOR Kurt
  32.           // $subject = $to .' -- '. $subject;
  33.           // $to = 'kvanderw2@gmail.com';
  34.           IF(!mail($to, $subject, $message, $headers)) {
  35.             watchdog("staging", "User email failed for %name (%to)", array( '%name' => $name, '%to' => $to ), WATCHDOG_WARNING );
  36.           }
  37.         }
  38.       }
  39.       db_query("INSERT INTO {staging_users_users} (uid, user_id) VALUES (%d, %d)", $user->uid, $result->user_id);
  40.     }    $delete_array = (array) $result;
  41.     unset($delete_array['uid']);
  42.     db_query("DELETE FROM {staging_users} WHERE user_id = %d AND user_name = '%s' AND user_email = '%s' AND user_password = '%s' AND user_active = %d AND user_company = '%s' AND user_isadmin = %d AND u
  43. ser_notified_new = %d", $delete_array);
  44.     unset($result);
  45.     unset($user);
  46.     unset($user_info);
  47.     unset($delete_array);
  48.   }
  49.   unset($query);
  50. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement