2
// $Id: views_handler_field_user_roles.inc,v 1.1 2008/09/03 19:21:30 merlinofchaos Exp $
4
* Field handler to provide a list of roles.
6
class views_handler_field_user_roles extends views_handler_field_prerender_list {
9
$this->additional_fields['uid'] = array('table' => 'users', 'field' => 'uid');
13
$this->add_additional_fields();
14
$this->field_alias = $this->aliases['uid'];
17
function pre_render($values) {
19
$this->items = array();
21
foreach ($values as $result) {
22
$uids[] = $result->{$this->aliases['uid']};
26
$result = db_query("SELECT u.uid, u.rid, r.name FROM {role} r INNER JOIN {users_roles} u ON u.rid = r.rid WHERE u.uid IN (" . implode(', ', $uids) . ") ORDER BY r.name");
27
while ($role = db_fetch_object($result)) {
28
$this->items[$role->uid][$role->rid] = check_plain($role->name);