How to assign role with PHP in Drupal?

Question

I need to assign a kind of "premium status" to members that purchase an amount equal or greater than 100 € via PHP.

Conditional Actions are already set up (user = anonymous/authenticated AND total amount = equal/greater than 100 AND user =! premium) but I'm missing the PHP part to actually say "then grant him the premium membership".

How can I achieve this?

EDIT: is the below code correct?

if ($account) {
  $uid = $account->uid;
  $role_name = 'authenticated user';
  $rid = db_result(db_query("SELECT rid FROM {role} WHERE name = '%s'", $role_name));
  db_query("INSERT INTO {users_roles} (uid, rid) VALUES(%d, %d)", $uid, $rid);
  watchdog('user', 'uc ca added role to Ubercart created user');
}

score 6 · Accepted Answer · 2010-08-21T20:43:41.187

You can do this with user_load() and user_save():

$uid = 1; // UID of user to add role to
$role_name = 'test role'; // Name of role to add

// Get RID of role
$rid = db_result(db_query("SELECT r.rid FROM {role} r WHERE r.name = '%s'", $role_name));

// Load user object
$account = user_load(array('uid' => 1));

// Save the user object with the new roles.
if ($account !== FALSE && !isset($account->roles[$rid])) {
  $roles = $account->roles + array($rid => $role_name);
  user_save($account, array('roles' => $roles));
}

If you wanted to do this in bulk for multiple users, there's user_multiple_role_edit():

$uids = array(1, 2, 3, 4); // UIDs of users to add role to
$role_name = 'test role'; // Name of role to add

// Get RID of role
$rid = db_result(db_query("SELECT r.rid FROM {role} r WHERE r.name = '%s'", $role_name));

// Add the role to UIDs
user_multiple_role_edit($uids, 'add_role', $rid);

Edit

If you wanted to do this for the current user (like part of the check you mentioned in a comment), you can do:

// Check for value over 100.00
if ($total_value > 100) {
  global $user; // Retrieve user object for currently logged in user.

  $role_name = 'test role'; // Name of role to add

  // Get RID of role
  $rid = db_result(db_query("SELECT r.rid FROM {role} r WHERE r.name = '%s'", $role_name));

  // Save the user object with the new role.
  if (!isset($user->roles[$rid])) {
    $roles = $user->roles + array($rid => $role_name);
    user_save($user, array('roles' => $roles));
  }
}
// Other code here.

I want the role to change on the event of a total purchase equal/greather than 100€ but, if I understand your code, that's a static solution (I'll have to use it everytime I want to change roles by hand). — dag729, Aug 20 '10 at 19:18
No, just put this code in wherever you're checking the total purchase. (i.e. `if ($purchase > 100) { // insert code above here }`, see also edit)This is permanent, though: the user will always have this role once granted unless you revoke it later on. The other solution is temporary, and will not last between pages. — , Aug 20 '10 at 19:24
Slightly unfortunate acronim they use, it took me a while to figure out that your comment Get RID of role didnt mean delete the role :) — Toby Allen, Dec 01 '11 at 20:17

rix · Answer 2 · 2014-11-12T09:28:57.810

3

Just though I'd update the snippet for Drupal 7. Otherwise it works fine :)

$rid = db_query("SELECT r.rid FROM {role} r WHERE r.name = :rname", 
                array(':rname' => $role_name))->fetchField();

edited Nov 12 '14 at 09:28

answered Mar 12 '13 at 16:03

rix

10,104
14
65
92

score 2 · Answer 3 · answered May 21 '13 at 23:31

2

I'd rather use user_role_load_by_name function.

answered May 21 '13 at 23:31

Bulat

6,869
1
29
52

score 0 · Answer 4 · answered Aug 30 '13 at 06:49

for drupal 7:

     global $user; // Retrieve user object for currently logged in user.

  $role_name = 'test role'; // Name of role to add

  // Get RID of role
  $rid = db_query("SELECT r.rid FROM {role} r WHERE r.name = :rname", array(':rname' => $role_name))->fetchField();

  // Save the user object with the new role.
  if (!isset($user->roles[$rid])) {
    $roles = $user->roles + array($rid => $role_name);
    user_save($user, array('roles' => $roles));
  }

thanks rix.

How to assign role with PHP in Drupal?

4 Answers4

Edit

Linked