台灣數位學習數位教學平台 RSS feed provider zh-tw http://lms.xms.com.tw/board.php?courseID=100&f=doclist&folderID=1234 http://lms.xms.com.tw/board.php?courseID=100&f=doc&cid=5694 /** * Unserializes and appends elements from a serialized string. * * @param $obj *   The object to which the elements are appended. * @param $field *   The attribute of $obj whose value should be unserialized. */function drupal_unpack($obj, $field = 'data') {  if ($obj->$field && $data = unserialize($obj->$field)) {    foreach ($data as $key => $value) {      if (!empty($key) && !isset($obj->$key)) {        $obj->$key = $value;      }    }  }  return $obj;} Sat, 30 Apr 2011 12:05:20 +0800 http://lms.xms.com.tw/board.php?courseID=100&f=doc&cid=5691 1. get user info db_query('SELECT * FROM {users} u WHERE '. implode(' AND ', $query), $params);   2. get user role db_query('SELECT r.rid, r.name FROM {role} r INNER JOIN {users_roles} ur ON ur.rid = r.rid WHERE ur.uid = %d', $user->uid);   /** * Fetch a user object. * * @param $user_info *   Information about the user to load, consisting of one of the following: *   - An associative array whose keys are fields in the {users} table (such as *     uid, name, pass, mail, status) and whose values are the field's value. *   - A numeric user ID. * * @return *   A fully-loaded $user object upon successful user load or FALSE if user *   cannot be loaded. */function user_load($user_info = array()) {  // Dynamically compose a SQL query:  $query = array();  $params = array();   if (is_numeric($user_info)) {    $user_info = array('uid' => $user_info);  }  elseif (!is_array($user_info)) {    return FALSE;  }   foreach ($user_info as $key => $value) {    if ($key == 'uid' || $key == 'status') {      $query[] = "$key = %d";      $params[] = $value;    }    else if ($key == 'pass') {      $query[] = "pass = '%s'";      $params[] = md5($value);    }    else {      $query[]= "LOWER($key) = LOWER('%s')";      $params[] = $value;    }  }  $result = db_query('SELECT * FROM {users} u WHERE '. implode(' AND ', $query), $params);   if ($user = db_fetch_object($result)) {    $user = drupal_unpack($user);     $user->roles = array();    if ($user->uid) {      $user->roles[DRUPAL_AUTHENTICATED_RID] = 'authenticated user';    }    else {      $user->roles[DRUPAL_ANONYMOUS_RID] = 'anonymous user';    }    $result = db_query('SELECT r.rid, r.name FROM {role} r INNER JOIN {users_roles} ur ON ur.rid = r.rid WHERE ur.uid = %d', $user->uid);    while ($role = db_fetch_object($result)) {      $user->roles[$role->rid] = $role->name;    }    user_module_invoke('load', $user_info, $user);  }  else {    $user = FALSE;  }   return $user;} Sat, 30 Apr 2011 11:27:07 +0800