user.module 87.2 KB
Newer Older
Dries's avatar
 
Dries committed
1 2 3 4 5
<?php
// $Id$

/*** Common functions ******************************************************/

Dries's avatar
 
Dries committed
6 7 8 9
// we cannot use module_invoke because we need passing by reference
function user_module_invoke($type, &$array, &$user) {
  foreach (module_list() as $module) {
    $function = $module .'_user';
Dries's avatar
 
Dries committed
10
    if (function_exists($function)) $function($type, $array, $user);
Dries's avatar
 
Dries committed
11 12 13
  }
}

Dries's avatar
 
Dries committed
14
function user_external_load($authname) {
Dries's avatar
 
Dries committed
15
  $result = db_query("SELECT uid FROM {authmap} WHERE authname = '%s'", $authname);
Dries's avatar
 
Dries committed
16

Dries's avatar
 
Dries committed
17 18
  if ($user = db_fetch_object($result)) {
    return user_load($user);
Dries's avatar
 
Dries committed
19 20 21 22 23 24 25 26 27 28 29
  }
  else {
    return 0;
  }
}

function user_load($array = array()) {
  /*
  ** Dynamically compose a SQL query:
  */

Dries's avatar
 
Dries committed
30 31
  $query = "";

Dries's avatar
 
Dries committed
32
  foreach ($array as $key => $value) {
Dries's avatar
 
Dries committed
33
    if ($key == 'pass') {
Kjartan's avatar
Kjartan committed
34
      $query .= "u.$key = '". md5($value) ."' AND ";
35
    }
Dries's avatar
 
Dries committed
36
    else {
Dries's avatar
 
Dries committed
37
      $query .= "u.$key = '". check_query($value) ."' AND ";
Dries's avatar
 
Dries committed
38 39
    }
  }
Dries's avatar
 
Dries committed
40
  $result = db_query_range("SELECT u.*, r.name AS role FROM {role} r INNER JOIN {users} u ON r.rid = u.rid WHERE $query u.status < 3", 0, 1);
Dries's avatar
 
Dries committed
41 42

  $user = db_fetch_object($result);
Dries's avatar
 
Dries committed
43 44
  $user = drupal_unpack($user);

Dries's avatar
 
Dries committed
45

Dries's avatar
 
Dries committed
46 47
  user_module_invoke("load", $array, $user);

Dries's avatar
 
Dries committed
48 49 50 51 52 53 54 55
  return $user;
}

function user_save($account, $array = array()) {
  /*
  ** Dynamically compose a SQL query:
  */

Kjartan's avatar
Kjartan committed
56
  $user_fields = user_fields();
Dries's avatar
 
Dries committed
57
  if ($account->uid) {
Dries's avatar
 
Dries committed
58 59
    user_module_invoke("update", $array, $account);

Dries's avatar
 
Dries committed
60
    $data = unserialize(db_result(db_query("SELECT data FROM {users} WHERE uid = %d", $account->uid)));
Dries's avatar
 
Dries committed
61
    foreach ($array as $key => $value) {
Dries's avatar
 
Dries committed
62
      if ($key == 'pass') {
Dries's avatar
 
Dries committed
63 64
        $query .= "$key = '%s', ";
        $v[] = md5($value);
Dries's avatar
 
Dries committed
65 66
      }
      else if (substr($key, 0, 4) !== "auth") {
Kjartan's avatar
Kjartan committed
67
        if (in_array($key, $user_fields)) {
Dries's avatar
 
Dries committed
68 69
          // escape '%'s:
          $value = str_replace("%", "%%", $value);
Dries's avatar
 
Dries committed
70 71
          $query .= "$key = '%s', ";
          $v[] = $value;
Dries's avatar
 
Dries committed
72 73 74 75
        }
        else {
          $data[$key] = $value;
        }
Dries's avatar
 
Dries committed
76 77
      }
    }
Dries's avatar
 
Dries committed
78 79
    $query .= "data = '%s', ";
    $v[] = serialize($data);
Dries's avatar
 
Dries committed
80

Dries's avatar
 
Dries committed
81
    db_query("UPDATE {users} SET $query changed = %d WHERE uid = %d", array_merge($v, array(time(), $account->uid)));
Dries's avatar
 
Dries committed
82

Dries's avatar
 
Dries committed
83
    $user = user_load(array('uid' => $account->uid));
Dries's avatar
 
Dries committed
84 85
  }
  else {
Dries's avatar
 
Dries committed
86 87
    $array['created'] = time();
    $array['changed'] = time();
Dries's avatar
 
Dries committed
88
    $array['uid'] = db_next_id("{users}_uid");
Dries's avatar
 
Dries committed
89 90

    foreach ($array as $key => $value) {
Dries's avatar
 
Dries committed
91
      if ($key == 'pass') {
Dries's avatar
 
Dries committed
92
        $fields[] = check_query($key);
Dries's avatar
 
Dries committed
93 94
        $values[] = md5($value);
        $s[] = "'%s'";
Dries's avatar
 
Dries committed
95 96
      }
      else if (substr($key, 0, 4) !== "auth") {
Kjartan's avatar
Kjartan committed
97
        if (in_array($key, $user_fields)) {
Dries's avatar
 
Dries committed
98
          $fields[] = check_query($key);
Dries's avatar
 
Dries committed
99 100
          $values[] = $value;
          $s[] = "'%s'";
Dries's avatar
 
Dries committed
101 102 103 104
        }
        else {
          $data[$key] = $value;
        }
Dries's avatar
 
Dries committed
105 106 107
      }
    }

Dries's avatar
 
Dries committed
108
    $fields[] = "data";
Dries's avatar
 
Dries committed
109 110
    $values[] = serialize($data);
    $s[] = "'%s'";
Dries's avatar
 
Dries committed
111

Dries's avatar
 
Dries committed
112
    db_query("INSERT INTO {users} (". implode(", ", $fields) .") VALUES (". implode(", ", $s) .")", $values);
Dries's avatar
 
Dries committed
113

Dries's avatar
 
Dries committed
114
    $user = user_load(array('name' => $array['name']));
Dries's avatar
 
Dries committed
115

Dries's avatar
 
Dries committed
116
    module_invoke_all('user', 'insert', $array, $user);
Dries's avatar
 
Dries committed
117 118 119
  }

  foreach ($array as $key => $value) {
Dries's avatar
 
Dries committed
120
    if (substr($key, 0, 4) == 'auth') {
Dries's avatar
 
Dries committed
121 122 123 124 125
      $authmaps[$key] = $value;
    }
  }

  if ($authmaps) {
Dries's avatar
 
Dries committed
126
    user_set_authmaps($user, $authmaps);
Dries's avatar
 
Dries committed
127 128 129 130 131 132 133 134 135 136
  }

  return $user;
}

function user_validate_name($name) {
  /*
  ** Verify the syntax of the given name:
  */

Dries's avatar
 
Dries committed
137
  if (!$name) return t("You must enter a username.");
Dries's avatar
 
Dries committed
138 139
  if (substr($name, 0, 1) == ' ') return t("The username cannot begin with a space.");
  if (substr($name, -1) == ' ') return t("The username cannot end with a space.");
Dries's avatar
 
Dries committed
140
  if (ereg('  ', $name)) return t("The username cannot contain multiple spaces in a row.");
Dries's avatar
 
Dries committed
141 142
  if (ereg('[^ [:alnum:]@_.-]', $name)) return t("The username contains an illegal character.");
  if (ereg('@', $name) && !eregi('@([0-9a-z](-?[0-9a-z])*.)+[a-z]{2}([zmuvtg]|fo|me)?$', $name)) return t("The username is not a valid authentication ID.");
Dries's avatar
 
Dries committed
143
  if (strlen($name) > 56) return t("The username '%name' is too long: it must be less than 56 characters.", array("%name" => $name));
Dries's avatar
 
Dries committed
144 145 146
}

function user_validate_mail($mail) {
Dries's avatar
 
Dries committed
147
  if (!$mail) return t("You must enter an e-mail address.");
Dries's avatar
 
Dries committed
148
  if ($mail && !valid_email_address($mail)) {
Dries's avatar
 
Dries committed
149
    return t("The e-mail address '%mail' is not valid.", array("%mail" => $mail));
Dries's avatar
 
Dries committed
150 151 152
  }
}

Dries's avatar
 
Dries committed
153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181
function user_validate_picture($file, &$edit, $user) {

  // initialize the picture:
  $edit['picture'] = $user->picture;

  // check that uploaded file is an image, with a maximum file size and maximum height/width
  $extension = strtolower(strrchr($file->name, "."));
  $size = getimagesize($file->path);
  list($maxwidth, $maxheight) = explode("x", variable_get('user_picture_dimensions', "85x85"));

  if ((!in_array($size[2], array(1, 2, 3))) || (!in_array($extension, array(".gif", ".jpg", ".png", ".jpeg")))) {
    $error = t("The uploaded file was not an image.");
  }
  else if ($file->size > (variable_get('user_picture_file_size', "30") * 1000)) {
    $error = t("The uploaded image is too large; the maximum file size is %a kB.", array("%a" => variable_get('user_picture_file_size', "30")));
  }
  else if ($size[0] > $maxwidth || $size[1] > $maxheight) {
    $error = t("The uploaded image is too large; the maximum dimensions are %a pixels.", array("%a" => variable_get('user_picture_dimensions', "85x85")));
  }
  else if ($file = file_save_upload('picture', variable_get('user_picture_path', "pictures") . FILE_SEPARATOR .'picture-'. $user->uid . $extension, 1)) {
    $edit['picture'] = $file->path;
  }
  else {
    $error = t("Failed to upload the picture image; the '%directory' directory doesn't exist.", array("%directory" => variable_get('user_picture_path', "pictures")));
  }

  return $error;
}

182
function user_validate_authmap($account, $authname, $module) {
Dries's avatar
 
Dries committed
183
  $result = db_query("SELECT COUNT(*) from {authmap} WHERE uid != %d AND authname = '%s'", $account->uid, $authname);
Dries's avatar
 
Dries committed
184
  if (db_result($result) > 0) {
Dries's avatar
 
Dries committed
185
    $name = module_invoke($module, 'info', 'name');
Dries's avatar
 
Dries committed
186 187
    return t("The %u ID %s is already taken.", array("%u" => ucfirst($name), "%s" => "<i>$authname</i>"));
  }
Dries's avatar
 
Dries committed
188 189
}

Dries's avatar
 
Dries committed
190
function user_password($length = 10) {
Dries's avatar
 
Dries committed
191
  /*
Dries's avatar
 
Dries committed
192
  ** Generate a random alphanumeric password.
Dries's avatar
 
Dries committed
193 194
  */

Dries's avatar
 
Dries committed
195 196 197 198 199 200 201 202 203
  // This variable contains the list of allowable characters for the
  // password.  Note that the number 0 and the letter 'O' have been
  // removed to avoid confusion between the two.  The same is true
  // of 'I' and 1.
  $allowable_characters = "abcdefghijklmnopqrstuvwxyzABCDEFGHJKLMNPQRSTUVWXYZ23456789";
  // We see how many characters are in the allowable list:
  $len = strlen($allowable_characters);

  // Seed the random number generator with the microtime stamp:
Dries's avatar
 
Dries committed
204
  mt_srand((double)microtime() * 1000000);
Dries's avatar
 
Dries committed
205 206 207 208 209 210 211 212 213 214 215 216 217

  // Declare the password as a blank string:
  $pass = "";

  // Loop the number of times specified by $length:
  for ($i = 0; $i < $length; $i++) {

    // Each iteration, pick a random character from the
    // allowable string and append it to the password:
    $pass .= $allowable_characters[mt_rand(0, $len - 1)];
  }

  return $pass;
Dries's avatar
 
Dries committed
218 219 220 221
}

function user_access($string) {
  global $user;
Dries's avatar
 
Dries committed
222
  static $perm = 0;
Dries's avatar
 
Dries committed
223

Dries's avatar
 
Dries committed
224
  // User #1 has all priveleges:
Dries's avatar
 
Dries committed
225 226 227 228
  if ($user->uid == 1) {
    return 1;
  }

Dries's avatar
 
Dries committed
229 230 231 232
  /*
  ** To reduce the number of SQL queries, we cache the user's permissions
  ** in a static variable.
  */
Dries's avatar
 
Dries committed
233

Dries's avatar
 
Dries committed
234 235
  if ($perm === 0) {
    $perm = db_result(db_query("SELECT p.perm FROM {role} r, {permission} p WHERE r.rid = p.rid AND r.rid = %d", $user->rid), 0);
Dries's avatar
 
Dries committed
236 237
  }

Dries's avatar
 
Dries committed
238
  return strstr($perm, $string);
Dries's avatar
 
Dries committed
239 240 241 242 243
}

function user_mail($mail, $subject, $message, $header) {
  if (variable_get("smtp_library", "") && file_exists(variable_get("smtp_library", ""))) {
    include_once variable_get("smtp_library", "");
244
    return user_mail_wrapper($mail, $subject, $message, $header);
Dries's avatar
 
Dries committed
245 246
  }
  else {
247 248 249 250 251 252 253
    /*
    ** Note: if you are having problems with sending mail, or mails look wrong
    ** when they are recieved you may have to modify the str_replace to suit
    ** your systems.
    **  - \r\n will work under dos and windows.
    **  - \n will work for linux, unix and BSDs.
    **  - \r will work for macs.
Dries's avatar
 
Dries committed
254 255 256 257 258 259 260 261 262 263 264 265
    **
    ** According to RFC 2646, it's quite rude to not wrap your e-mails:
    **
    ** "The Text/Plain media type is the lowest common denominator of
    ** Internet email, with lines of no more than 997 characters (by
    ** convention usually no more than 80), and where the CRLF sequence
    ** represents a line break [MIME-IMT]."
    **
    ** CRLF === \r\n
    **
    ** http://www.rfc-editor.org/rfc/rfc2646.txt
    **
266
    */
Dries's avatar
 
Dries committed
267 268 269 270
    return mail(
      $mail,
      user_mail_encode($subject),
      str_replace("\r", "", $message),
Dries's avatar
 
Dries committed
271
      "MIME-Version: 1.0\nContent-Type: text/plain; charset=UTF-8; format=flowed\nContent-transfer-encoding: 8Bit\n" . $header
Dries's avatar
 
Dries committed
272
    );
Dries's avatar
 
Dries committed
273 274 275
  }
}

Kjartan's avatar
Kjartan committed
276 277 278 279 280
function user_mail_encode($string, $charset = "UTF-8") {
  /*
  ** Used to encodes mail headers that contain non US- ASCII
  ** characters.
  ** http://www.rfc-editor.org/rfc/rfc2047.txt
Kjartan's avatar
Kjartan committed
281 282 283 284 285 286 287 288
  **
  ** Notes:
  **   - The chunks come in groupings of 4 bytes when using base64
  **     encoded.
  **   - trim() is used to ensure that no extra spacing is added by
  **     chunk_split() or preg_replace().
  **   - Using \n as the chunk separator may cause problems on some
  **     systems and may have to be changed to \r\n or \r.
Kjartan's avatar
Kjartan committed
289
  */
Kjartan's avatar
Kjartan committed
290 291 292
  $chunk_size = 75 - 7 - strlen($charset);
  $chunk_size -= $chunk_size % 4;
  $string = trim(chunk_split(base64_encode($string), $chunk_size, "\n"));
Kjartan's avatar
Kjartan committed
293 294
  $string = trim(preg_replace('/^(.*)$/m', " =?$charset?B?\\1?=", $string));
  return $string;
Dries's avatar
 
Dries committed
295 296
}

Dries's avatar
 
Dries committed
297
function user_deny($type, $mask) {
Dries's avatar
 
Dries committed
298 299
  $allow = db_fetch_object(db_query("SELECT * FROM {access} WHERE status = '1' AND type = '%s' AND LOWER('%s') LIKE LOWER(mask)", $type, $mask));
  $deny = db_fetch_object(db_query("SELECT * FROM {access} WHERE status = '0' AND type = '%s' AND LOWER('%s') LIKE LOWER(mask)", $type, $mask));
Dries's avatar
 
Dries committed
300

Dries's avatar
 
Dries committed
301
  return $deny && !$allow;
Dries's avatar
 
Dries committed
302 303
}

Dries's avatar
 
Dries committed
304 305
function user_fields() {
  static $fields;
Dries's avatar
 
Dries committed
306

Dries's avatar
 
Dries committed
307
  if (!$fields) {
Dries's avatar
 
Dries committed
308
    $result = db_query("SELECT * FROM {users} WHERE uid = 1");
Kjartan's avatar
Kjartan committed
309 310 311
    if (db_num_rows($result)) {
      $fields = array_keys(db_fetch_array($result));
    }
Dries's avatar
 
Dries committed
312 313
    else {
      // Make sure we return the default fields at least
Dries's avatar
 
Dries committed
314
      $fields = array('uid', 'name', 'pass', "mail", "picture", "mode", "sort", "threshold", "theme", "signature", "created", "changed", "status", "timezone", "language", "init", "data", "rid");
Dries's avatar
 
Dries committed
315
    }
Dries's avatar
 
Dries committed
316
  }
Dries's avatar
 
Dries committed
317

Dries's avatar
 
Dries committed
318
  return $fields;
Dries's avatar
 
Dries committed
319 320
}

Dries's avatar
 
Dries committed
321 322 323
/*** Module hooks **********************************************************/

function user_perm() {
Dries's avatar
 
Dries committed
324
  return array("administer users", "access user list");
Dries's avatar
 
Dries committed
325 326
}

Dries's avatar
 
Dries committed
327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351
function user_file_download($file) {
  if (strpos($file, variable_get('user_picture_path', "pictures") . FILE_SEPARATOR . 'picture-') === 0) {
    list($width, $height, $type, $attr) = getimagesize(file_create_path($file));
    $types = array(
      IMAGETYPE_GIF => 'image/gif',
      IMAGETYPE_JPEG => 'image/jpeg',
      IMAGETYPE_PNG => 'image/png',
      IMAGETYPE_SWF => 'application/x-shockwave-flash',
      IMAGETYPE_PSD => 'image/psd',
      IMAGETYPE_BMP => 'image/bmp',
      IMAGETYPE_TIFF_II => 'image/tiff',
      IMAGETYPE_TIFF_MM  => 'image/tiff',
      IMAGETYPE_JPC => 'application/octet-stream',
      IMAGETYPE_JP2 => 'image/jp2',
      IMAGETYPE_JPX => 'application/octet-stream',
      IMAGETYPE_JB2 => 'application/octet-stream',
      IMAGETYPE_SWC => 'application/x-shockwave-flash',
      IMAGETYPE_IFF => 'image/iff',
      IMAGETYPE_WBMP => 'image/vnd.wap.wbmp',
      IMAGETYPE_XBM => 'image/xbm'
    );
    return array('Content-type: '. $types[$type]);
  }
}

Dries's avatar
 
Dries committed
352
function user_search($keys) {
Dries's avatar
 
Dries committed
353 354
  $find = array();
  $result = db_query_range("SELECT * FROM {users} WHERE name LIKE '%%%s%%'", $keys, 0, 20);
Dries's avatar
 
Dries committed
355
  while ($account = db_fetch_object($result)) {
Dries's avatar
 
Dries committed
356
    $find[] = array("title" => $account->name, "link" => (strstr(request_uri(), "admin") ? url("admin/user/edit/$account->uid") : url("user/view/$account->uid")), 'user' => $account->name);
Dries's avatar
 
Dries committed
357
  }
Dries's avatar
 
Dries committed
358
  return array(t("Matching users"), $find);
Dries's avatar
 
Dries committed
359 360
}

Dries's avatar
Dries committed
361
function user_user($type, &$edit, &$user) {
Dries's avatar
Dries committed
362
  if ($type == 'view') {
Dries's avatar
Dries committed
363
    return array(t('History') => form_item(t('Member for'), format_interval(time() - $user->created)));
Dries's avatar
Dries committed
364 365 366
  }
}

Dries's avatar
 
Dries committed
367
function user_block($op = "list", $delta = 0) {
Dries's avatar
 
Dries committed
368 369
  global $user;

Dries's avatar
 
Dries committed
370
  if ($op == "list") {
Dries's avatar
 
Dries committed
371 372 373 374
     $blocks[0]['info'] = t("User login");
     $blocks[1]['info'] = t("Navigation");
     $blocks[2]['info'] = t("Who's new");
     $blocks[3]['info'] = t("Who's online");
375

376
     return $blocks;
377 378
  }
  else {
Dries's avatar
 
Dries committed
379 380
    $block = array();

Dries's avatar
 
Dries committed
381 382
    switch ($delta) {
      case 0:
Dries's avatar
 
Dries committed
383

384
        if (!$user->uid) {
Dries's avatar
 
Dries committed
385 386 387 388 389
          /*
          ** For usability's sake, avoid showing two login forms on one
          ** page.
          */

Dries's avatar
 
Dries committed
390
          if (arg(0) == 'user' && arg(1) != "view") {
Dries's avatar
 
Dries committed
391 392 393
            return;
          }

Dries's avatar
 
Dries committed
394 395
          $edit = $_POST["edit"];

Dries's avatar
 
Dries committed
396 397
          $output = "<div class=\"user-login-block\">\n";

398
          /*
Dries's avatar
Dries committed
399 400
          ** Save the referer.  We record where the user came from such
          ** that we/ can redirect him after having completed the login
401 402
          ** form.
          */
Dries's avatar
Dries committed
403

404
          if (empty($edit)) {
Dries's avatar
Dries committed
405
            $edit["destination"] = $_GET["q"];
406 407
          }
          // NOTE: special care needs to be taken because on pages with forms, such as node and comment submission pages, the $edit variable might already be set.
Dries's avatar
Dries committed
408

Dries's avatar
 
Dries committed
409
          $output .= form_hidden("destination", $edit["destination"]);
Dries's avatar
 
Dries committed
410 411
          $output .= form_textfield(t("Username"), 'name', $edit['name'], 15, 64);
          $output .= form_password(t("Password"), 'pass', $pass, 15, 64);
Dries's avatar
 
Dries committed
412
          $output .= form_submit(t("Log in"));
Dries's avatar
 
Dries committed
413
          $output .= "</div>\n";
Dries's avatar
 
Dries committed
414

Dries's avatar
 
Dries committed
415 416
          $output  = form($output, "post", url("user/login"));

Dries's avatar
 
Dries committed
417
          if (variable_get("user_register", 1)) {
Dries's avatar
 
Dries committed
418
            $items[] = l(t("Create new account"), "user/register", array("title" => t("Create a new user account.")));
Dries's avatar
 
Dries committed
419
          }
Dries's avatar
 
Dries committed
420
          $items[] = l(t("Request new password"), "user/password", array("title" => t("Request new password via e-mail.")));
Dries's avatar
 
Dries committed
421

Dries's avatar
 
Dries committed
422
          $output .= theme("item_list", $items);
423

Dries's avatar
 
Dries committed
424
          $block["subject"] = t("User login");
Dries's avatar
 
Dries committed
425
          $block["content"] = $output;
Dries's avatar
 
Dries committed
426
        }
Dries's avatar
Dries committed
427
        return $block;
428
      case 1:
Dries's avatar
 
Dries committed
429 430
        if ($menu = menu_tree()) {
           $block["subject"] = $user->uid ? $user->name : t("Navigation");
Dries's avatar
 
Dries committed
431
           $block["content"] = "<div class=\"menu\">". $menu ."</div>";
Dries's avatar
 
Dries committed
432
        }
433
        return $block;
Dries's avatar
 
Dries committed
434
      case 2:
435 436 437
        if (user_access("access content")) {
          $result = db_query_range("SELECT uid, name FROM {users} WHERE status != '0' ORDER BY uid DESC", 0, 5);
          while ($account = db_fetch_object($result)) {
438
            $items[] = format_name($account);
439
          }
Dries's avatar
 
Dries committed
440

Dries's avatar
 
Dries committed
441
          $output = theme("user_list", $items);
Dries's avatar
 
Dries committed
442

443 444 445 446
          $block["subject"] = t("Who's new");
          $block["content"] = $output;
          return $block;
        }
Dries's avatar
 
Dries committed
447 448
      case 3:
        if (user_access("access content")) {
Dries's avatar
 
Dries committed
449 450
          /* count users with activity in the past defined period */
          $time_period = variable_get("user_block_seconds_online", 2700);
Dries's avatar
 
Dries committed
451

Dries's avatar
 
Dries committed
452 453 454
          /* perform database queries to gather online user lists */
          $guests = db_fetch_object(db_query("SELECT COUNT(DISTINCT sid) AS count FROM {sessions} WHERE timestamp >= %d AND uid = 0", time() - $time_period));
          $users = db_query("SELECT DISTINCT uid, MAX(timestamp) AS max_timestamp FROM {sessions} WHERE timestamp >= %d AND uid != 0 GROUP BY uid ORDER BY max_timestamp DESC", time() - $time_period );
Dries's avatar
 
Dries committed
455
          $total_users = db_num_rows($users);
Dries's avatar
 
Dries committed
456 457 458 459

          /* format the output with proper grammar */
          if ($total_users == 1 && $guests->count == 1) {
            $output = t("There is currently %members and %visitors online.", array("%members" => format_plural($total_users, "1 user", "%count users"), "%visitors" => format_plural($guests->count, "1 guest", "%count guests")));
Dries's avatar
 
Dries committed
460 461
          }
          else {
Dries's avatar
 
Dries committed
462 463 464 465
            $output = t("There are currently %members and %visitors online.", array("%members" => format_plural($total_users, "1 user", "%count users"), "%visitors" => format_plural($guests->count, "1 guest", "%count guests")));
          }

          if (user_access("access user list") && $total_users) {
Dries's avatar
 
Dries committed
466

Dries's avatar
 
Dries committed
467
            // Display a list of currently online users
Dries's avatar
 
Dries committed
468
            $max_users = variable_get("user_block_max_list_count", 10);
Dries's avatar
 
Dries committed
469 470
            if ($max_users) {
              $items = array();
Dries's avatar
 
Dries committed
471

Dries's avatar
 
Dries committed
472
              while ($max_users-- && $uid = db_fetch_object($users)) {
Dries's avatar
 
Dries committed
473
                $items[] = format_name(user_load(array('uid' => $uid->uid)));
Dries's avatar
 
Dries committed
474 475 476
              }

              if ($items) {
Dries's avatar
 
Dries committed
477 478 479
                if (db_fetch_object($users)) {
                  $items[] = "...";
                }
Dries's avatar
 
Dries committed
480 481
                $output .= theme("item_list", $items, t("Online users:"));
              }
Dries's avatar
 
Dries committed
482
            }
Dries's avatar
 
Dries committed
483
          }
Dries's avatar
 
Dries committed
484 485
          $block["subject"] = t("Who's online");
          $block["content"] = $output;
Dries's avatar
 
Dries committed
486
        }
Dries's avatar
 
Dries committed
487
        return $block;
Dries's avatar
 
Dries committed
488 489
    }
  }
490 491
}

Dries's avatar
 
Dries committed
492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511
function theme_user_picture($account) {
  if (variable_get('user_pictures', 0)) {
    if ($account->picture && file_exists($account->picture)) {
      $picture = file_create_url($account->picture);
    }
    else if (variable_get('user_picture_default', '')) {
      $picture = variable_get('user_picture_default', '');
    }

    if ($picture) {
      $picture = "<img src=\"$picture\" alt=\"" . t("%user's picture", array("%user" => $account->name ? $account->name : t(variable_get("anonymous", "Anonymous")))) . "\" />";
      if ($account->uid) {
        $picture = l($picture, "user/view/$account->uid", array("title" => t("View user profile.")));
      }

      return "<div class=\"picture\">$picture</div>";
    }
  }
}

Dries's avatar
Dries committed
512
function theme_user_profile($account, $fields) {
Dries's avatar
 
Dries committed
513 514
  $output = "<div class=\"profile\">\n";
  $output .= theme('user_picture', $account);
Dries's avatar
Dries committed
515 516 517
  foreach ($fields as $category => $value) {
    $output .= "<h2>$category</h2>$value";
  }
Dries's avatar
 
Dries committed
518 519 520 521 522 523 524 525 526 527

  if (user_access("administer users")) {
    $output .= form_item(t("Administration"), l(t("edit account"), "admin/user/edit/$account->uid"));
  }

  $output .= "</div>\n";

  return $output;
}

Dries's avatar
 
Dries committed
528
function theme_user_list($items, $title = NULL) {
Dries's avatar
 
Dries committed
529
  return theme("item_list", $items, $title);
Dries's avatar
 
Dries committed
530 531
}

Dries's avatar
 
Dries committed
532
function user_link($type) {
Dries's avatar
 
Dries committed
533
  global $user;
Dries's avatar
 
Dries committed
534

Dries's avatar
 
Dries committed
535
  if ($type == "system") {
Dries's avatar
Dries committed
536
    if ($user->uid) {
Dries's avatar
 
Dries committed
537
      menu('user', t("my account"), "user_page", 8);
Dries's avatar
 
Dries committed
538
      menu("user/edit", t("edit account"), "user_page", 0);
539
      menu("logout", t("log out"), "user_logout", 10);
Dries's avatar
Dries committed
540
    }
Dries's avatar
 
Dries committed
541
    else {
542
      menu("user/login", t("log in"), "user_page", 0, MENU_HIDE);
Dries's avatar
 
Dries committed
543
    }
544 545
    menu("user/password", t("e-mail new password"), "user_page", 0, MENU_HIDE);
    menu("user/register", t("create new account"), "user_page", 0, MENU_HIDE);
Dries's avatar
 
Dries committed
546

Dries's avatar
 
Dries committed
547
    if (user_access("administer users")) {
Dries's avatar
 
Dries committed
548 549
      menu("admin/user", t("accounts"), "user_admin", 2);
      menu("admin/user/create", t("new user"), "user_admin", 1);
Dries's avatar
 
Dries committed
550
      menu("admin/user/access", t("access rules"), "user_admin", 3);
551 552
      menu("admin/user/access/mail", t("e-mail rules"), "user_admin");
      menu("admin/user/access/user", t("name rules"), "user_admin");
Dries's avatar
 
Dries committed
553 554
      menu("admin/user/role", t("roles"), "user_admin", 4);
      menu("admin/user/permission", t("permissions"), "user_admin", 5);
Dries's avatar
 
Dries committed
555
      menu("admin/user/help", t("help"), "user_help_page", 9);
556
      menu("admin/user/edit", t("edit user account"), "user_admin", 0, MENU_HIDE, MENU_LOCKED);
Dries's avatar
 
Dries committed
557 558 559
      if (module_exist('search')) {
        menu("admin/user/search", t("search"), "user_admin", 8);
      }
Dries's avatar
 
Dries committed
560
    }
Dries's avatar
 
Dries committed
561 562 563 564 565
  }
}

/*** Authentication methods ************************************************/

566
function user_get_authname($account, $module) {
Dries's avatar
 
Dries committed
567 568

  /*
569
  **  Called by authentication modules in order to edit/view their authmap information.
Dries's avatar
 
Dries committed
570 571
  */

Dries's avatar
 
Dries committed
572
  $result = db_query("SELECT authname FROM {authmap} WHERE uid = %d AND module = '%s'", $account->uid, $module);
573 574 575
  return db_result($result);
}

Dries's avatar
 
Dries committed
576

577 578 579 580 581 582 583
function user_get_authmaps($authname = NULL) {

  /*
  ** Accepts an user object, $account, or an DA name and returns an
  ** associtive array of modules and DA names. Called at external login.
  */

Dries's avatar
 
Dries committed
584
  $result = db_query("SELECT authname, module FROM {authmap} WHERE authname = '%s'", $authname);
Dries's avatar
 
Dries committed
585 586 587 588 589 590 591 592 593 594 595 596 597 598 599
  if (db_num_rows($result) > 0) {
    while ($authmap = db_fetch_object($result)) {
      $authmaps[$authmap->module] = $authmap->authname;
    }
    return $authmaps;
  }
  else {
    return 0;
  }
}

function user_set_authmaps($account, $authmaps) {
  foreach ($authmaps as $key => $value) {
    $module = explode("_", $key, 2);
    if ($value) {
Dries's avatar
 
Dries committed
600 601 602
      db_query("UPDATE {authmap} SET authname = '%s' WHERE uid = %d AND module = '%s'", $value, $account->uid, $module["1"]);
      if (!db_affected_rows()) {
        db_query("INSERT INTO {authmap} (authname, uid, module) VALUES ('%s', %d, '%s')", $value, $account->uid, $module[1]);
Dries's avatar
 
Dries committed
603 604 605
      }
    }
    else {
Dries's avatar
 
Dries committed
606
      db_query("DELETE FROM {authmap} WHERE uid = %d AND module = '%s'", $account->uid, $module["1"]);
Dries's avatar
 
Dries committed
607 608 609 610 611
    }
  }
}

function user_auth_help_links() {
612
  $links = array();
Dries's avatar
 
Dries committed
613
  foreach (module_list() as $module) {
Dries's avatar
 
Dries committed
614
    if (module_hook($module, "auth")) {
Dries's avatar
 
Dries committed
615
      $links[] = l(module_invoke($module, 'info', 'name'), "user/help#$module");
Dries's avatar
 
Dries committed
616 617 618 619 620 621 622
    }
  }
  return $links;
}

/*** User features *********************************************************/

Dries's avatar
 
Dries committed
623
function user_login($edit = array(), $msg = "") {
Dries's avatar
 
Dries committed
624
  global $user, $base_url;
Dries's avatar
 
Dries committed
625 626 627 628 629 630

  /*
  ** If we are already logged on, go to the user page instead.
  */

  if ($user->uid) {
Dries's avatar
Dries committed
631
    drupal_goto('user');
Dries's avatar
 
Dries committed
632 633
  }

Dries's avatar
 
Dries committed
634 635
  if (user_deny('user', $edit['name'])) {
    $error = t("The name '%s' has been denied access.", array("%s" => $edit['name']));
Dries's avatar
 
Dries committed
636
  }
Dries's avatar
 
Dries committed
637
  else if ($edit['name'] && $edit['pass']) {
Dries's avatar
 
Dries committed
638 639

    /*
Dries's avatar
 
Dries committed
640
    ** Try to log in the user locally:
Dries's avatar
 
Dries committed
641 642
    */

Dries's avatar
 
Dries committed
643
    if (!$user->uid) {
Dries's avatar
 
Dries committed
644 645 646
      $name = $edit['name'];
      $pass = $edit['pass'];
      $user = user_load(array('name' => $name, 'pass' => $pass, "status" => 1));
Dries's avatar
 
Dries committed
647 648 649 650 651 652
    }

    /*
    ** Strip name and server from ID:
    */

Dries's avatar
 
Dries committed
653 654
    if ($server = strrchr($edit['name'], "@")) {
      $name = substr($edit['name'], 0, strlen($edit['name']) - strlen($server));
655
      $server = substr($server, 1);
Dries's avatar
 
Dries committed
656
      $pass = $edit['pass'];
Dries's avatar
 
Dries committed
657
    }
Dries's avatar
 
Dries committed
658

Dries's avatar
 
Dries committed
659
    /*
Dries's avatar
 
Dries committed
660
    ** When possible, determine corresponding external auth source. Invoke
Dries's avatar
 
Dries committed
661
    ** source, and login user if successful:
Dries's avatar
 
Dries committed
662 663
    */

Dries's avatar
 
Dries committed
664
    if (!$user->uid && $server && $result = user_get_authmaps("$name@$server")) {
Dries's avatar
 
Dries committed
665 666
      if (module_invoke(key($result), "auth", $name, $pass, $server)) {
        $user = user_external_load("$name@$server");
Dries's avatar
 
Dries committed
667
        watchdog('user', "external load: $name@$server, module: ". key($result));
Dries's avatar
 
Dries committed
668 669
      }
      else {
Dries's avatar
 
Dries committed
670
        $error = t("Invalid password for %s.", array("%s" => "<i>$name@$server</i>"));
Dries's avatar
 
Dries committed
671 672 673
      }
    }

Dries's avatar
 
Dries committed
674
    /*
Dries's avatar
 
Dries committed
675
    ** Try each external authentication source in series. Register user if
Dries's avatar
 
Dries committed
676
    ** successful.
Dries's avatar
 
Dries committed
677 678
    */

Dries's avatar
 
Dries committed
679
    else if (!$user->uid && $server) {
Dries's avatar
 
Dries committed
680 681 682
      foreach (module_list() as $module) {
        if (module_hook($module, "auth")) {
          if (module_invoke($module, "auth", $name, $pass, $server)) {
Dries's avatar
 
Dries committed
683 684 685
            if (variable_get("user_register", 1) == 1 && !user_load(array('name' => "$name@$server"))) { //register this new user
              $user = user_save("", array('name' => "$name@$server", 'pass' => user_password(), "init" => "$name@$server", "status" => 1, "authname_$module" => "$name@$server", "rid" => _user_authenticated_id()));
              watchdog('user', "new user: $name@$server ($module ID)", l(t("edit user"), "admin/user/edit/$user->uid"));
Dries's avatar
 
Dries committed
686 687 688 689 690 691 692 693
              break;
            }
          }
        }
      }
    }

    if ($user->uid) {
Dries's avatar
 
Dries committed
694
      watchdog('user', "session opened for '$user->name'");
Dries's avatar
 
Dries committed
695

Dries's avatar
 
Dries committed
696
      // update the user table timestamp noting user has logged in
Dries's avatar
 
Dries committed
697
      db_query("UPDATE {users} SET changed = '%d' WHERE uid = '%s'", time(), $user->uid);
Dries's avatar
 
Dries committed
698

Dries's avatar
 
Dries committed
699 700
      user_module_invoke("login", $edit, $user);

Dries's avatar
 
Dries committed
701 702 703 704 705
      /*
      ** If the user wants to be remembered, set the proper cookie such
      ** that the session won't expire.
      */

Dries's avatar
 
Dries committed
706
      $path = preg_replace("/.+\/\/[^\/]+(.*)/", "\$1/", $base_url);
Dries's avatar
 
Dries committed
707
      setcookie(session_name(), session_id(), FALSE, $path);
Dries's avatar
 
Dries committed
708 709

      /*
Dries's avatar
 
Dries committed
710
      ** Redirect the user to the page he logged on from.
Dries's avatar
 
Dries committed
711 712
      */

Dries's avatar
 
Dries committed
713
      drupal_goto($edit["destination"]);
Dries's avatar
 
Dries committed
714 715 716
    }
    else {
      if (!$error) {
Dries's avatar
 
Dries committed
717
        $error = t("Sorry.  Unrecognized username or password.") ." ". l(t("Have you forgotten your password?"), "user/password");
Dries's avatar
 
Dries committed
718 719
      }
      if ($server) {
Dries's avatar
 
Dries committed
720
        watchdog('user', "failed login for '$name@$server': $error");
Dries's avatar
 
Dries committed
721 722
      }
      else {
Dries's avatar
 
Dries committed
723
        watchdog('user', "failed login for '$name': $error");
Dries's avatar
 
Dries committed
724 725 726 727 728 729 730 731 732
      }
    }
  }

  /*
  ** Display error message (if any):
  */

  if ($error) {
Dries's avatar
 
Dries committed
733
    drupal_set_message($error, 'error');
Dries's avatar
 
Dries committed
734 735
  }

Dries's avatar
 
Dries committed
736
  /*
Dries's avatar
 
Dries committed
737
  ** Save the referrer.  We record where the user came from such that we
Dries's avatar
 
Dries committed
738 739 740
  ** can redirect him after having completed the login form.
  */

741
  if (empty($edit)) {
Dries's avatar
Dries committed
742
    $edit["destination"] = $_GET["q"];
Dries's avatar
 
Dries committed
743 744 745
  }
  $output .= form_hidden("destination", $edit["destination"]);

Dries's avatar
 
Dries committed
746 747 748 749
  /*
  ** Display login form:
  */

Dries's avatar
 
Dries committed
750 751 752
  if ($msg) {
    $output .= "<p>$msg</p>";
  }
Dries's avatar
 
Dries committed
753
  if (count(user_auth_help_links()) > 0) {
Dries's avatar
 
Dries committed
754
    $output .= form_textfield(t("Username"), 'name', $edit['name'], 30, 64, t("Enter your %s username, or an ID from one of our affiliates: %a.", array("%s" => variable_get("site_name", "local"), "%a" => implode(", ", user_auth_help_links()))));
Dries's avatar
 
Dries committed
755 756
  }
  else {
Dries's avatar
 
Dries committed
757
    $output .= form_textfield(t("Username"), 'name', $edit['name'], 30, 64, t("Enter your %s username.", array("%s" => variable_get("site_name", "local"))));
Dries's avatar
 
Dries committed
758
  }
Dries's avatar
 
Dries committed
759
  $output .= form_password(t("Password"), 'pass', $pass, 30, 64, t("Enter the password that accompanies your username."));
Dries's avatar
 
Dries committed
760
  $output .= form_submit(t("Log in"));
Dries's avatar
 
Dries committed
761
  $items[] = l(t("Request new password"), "user/password");
762
  if (variable_get("user_register", 1)) {
Dries's avatar
 
Dries committed
763
    $items[] = l(t("Create new account"), "user/register");
764
  }
Dries's avatar
 
Dries committed
765
  $output .= theme("item_list", $items);
Dries's avatar
 
Dries committed
766

Dries's avatar
 
Dries committed
767 768
  $output  = form_group(t('User login'), $output);

769
  return form($output, "post", url('user/login'));
Dries's avatar
 
Dries committed
770 771
}

772
function _user_authenticated_id() {
Dries's avatar
 
Dries committed
773
  return db_result(db_query("SELECT rid FROM {role} WHERE name = 'authenticated user'"));
774 775
}

Dries's avatar
 
Dries committed
776 777 778 779
function user_logout() {
  global $user;

  if ($user->uid) {
Dries's avatar
 
Dries committed
780
    watchdog('user', "session closed for '$user->name'");
Dries's avatar
 
Dries committed
781 782 783 784 785 786

    /*
    ** Destroy the current session:
    */

    session_destroy();
Dries's avatar
 
Dries committed
787
    module_invoke_all('user', 'logout', NULL, $user);
Dries's avatar
 
Dries committed
788 789 790
    unset($user);
  }

Dries's avatar
Dries committed
791
  drupal_goto();
Dries's avatar
 
Dries committed
792 793 794
}

function user_pass($edit = array()) {
Dries's avatar
 
Dries committed
795 796
  global $base_url;

Dries's avatar
 
Dries committed
797 798 799
  if ($edit['name']) {
    $account = db_fetch_object(db_query("SELECT uid, name, mail FROM {users} WHERE status = 1 AND name = '%s'", $edit['name']));
    if (!$account) $error = t("Sorry. The username <i>%s</i> is not recognized.", array("%s" => $edit['name']));
800
  }
Dries's avatar
 
Dries committed
801 802 803
  else if ($edit['mail']) {
    $account = db_fetch_object(db_query("SELECT uid, name, mail FROM {users} WHERE status = 1 AND mail = '%s'", $edit['mail']));
    if (!$account) $error = t("Sorry. The e-mail address <i>%s</i> is not recognized.", array("%s" => $edit['mail']));
Kjartan's avatar
Kjartan committed
804 805
  }
  if ($account) {
Dries's avatar
 
Dries committed
806

807
      $from = variable_get("site_mail", ini_get("sendmail_from"));
Dries's avatar
 
Dries committed
808 809 810 811 812 813
      $pass = user_password();

      /*
      ** Save new password:
      */

Dries's avatar
 
Dries committed
814
      user_save($account, array('pass' => $pass));
Dries's avatar
 
Dries committed
815 816 817 818 819

      /*
      ** Mail new password:
      */

Dries's avatar
Dries committed
820
      $variables = array("%username" => $account->name, "%site" => variable_get("site_name", "drupal"), "%password" => $pass, "%uri" => $base_url, "%uri_brief" => substr($base_url, strlen("http://")), "%mailto" => $account->mail, "%date" => format_date(time()), '%login_uri' => url('user/login', NULL, NULL, TRUE), '%edit_uri' => url('user/edit', NULL, NULL, TRUE));
Dries's avatar
 
Dries committed
821 822
      $subject = _user_mail_text("pass_subject", $variables);
      $body = _user_mail_text("pass_body", $variables);
823
      $headers = "From: $from\nReply-to: $from\nX-Mailer: Drupal\nReturn-path: $from\nErrors-to: $from";
Dries's avatar
 
Dries committed
824
      $mail_success = user_mail($account->mail, $subject, $body, $headers);
Dries's avatar
 
Dries committed
825

Dries's avatar
 
Dries committed
826
      if ($mail_success) {
Dries's avatar
 
Dries committed
827
        watchdog('user', "mail password: '". $account->name ."' &lt;". $account->mail ."&gt;");
Dries's avatar
 
Dries committed
828 829 830
        return t("Your password and further instructions have been sent to your e-mail address.");
      }
      else {
Dries's avatar
 
Dries committed
831
        watchdog('error', "error mailing new password: '". $account->name ."' &lt;". $account->mail ."&gt;");
Dries's avatar
 
Dries committed
832 833
        return t("Unable to send mail. Please contact the site admin.");
      }
Dries's avatar
 
Dries committed
834 835
    }
    else {
836

Kjartan's avatar
Kjartan committed
837 838
    // Display error message if necessary.
    if ($error) {
Dries's avatar
 
Dries committed
839
      drupal_set_message($error, 'error');
Dries's avatar
 
Dries committed
840 841 842 843 844 845
    }

    /*
    ** Display form:
    */

Dries's avatar
 
Dries committed
846
    $output .= "<p>". t("Enter your username <strong><em>or</em></strong> your e-mail address.") ."</p>";
Dries's avatar
 
Dries committed
847 848
    $output .= form_textfield(t("Username"), 'name', $edit['name'], 30, 64);
    $output .= form_textfield(t("E-mail address"), "mail", $edit['mail'], 30, 64);
Dries's avatar
 
Dries committed
849
    $output .= form_submit(t("E-mail new password"));
Dries's avatar
 
Dries committed
850
    $items[] = l(t("Log in"), "user/login");
851
    if (variable_get("user_register", 1)) {
Dries's avatar
 
Dries committed
852
      $items[] = l(t("Create new account"), "user/register");
853
    }
Dries's avatar
 
Dries committed
854
    $output .= theme("item_list", $items);
Dries's avatar
 
Dries committed
855
    $output  = form_group(t('Request new password'), $output);
856
    return form($output, "post", url('user/password'));
Dries's avatar
 
Dries committed
857 858 859 860
  }
}

function user_register($edit = array()) {
Dries's avatar
 
Dries co