By s866 on

Hello!
I need a Triggered rule that should be evaluated on event "User account has been created" and this rule should check if user whith particular uid exists and if it's true then add some userpoints to the account of the user who is just registered. What PHP code I should put into a condition "Rules - Check a truth value" to check if particular uid exists? This uid (for example uid=103) was entered by registered user (who is just registered and for example he have got a uid=134) into the CCK field at his own Content Profile node and is accessible directly in PHP evaluation field by token replacement pattern [account:content-profile-profile-referral].
So the logic is:
1) user 134 registered and he has typed into the registration form that he was invited by user with uid=103;
2) if user with uid=103 really exists then the user with uid=134 gets some userpoints;
3) if user with uid=103 does not exist - just registered user with uid=134 gets nothing.

⋅ Categories: Drupal 6.x

Comments

nevets’s picture

nevets commented

Given you have the uid

<?php
$uid = // the uid the user entered, you will need to determine this part

$account = user_load(array('uid' => $uid));
if ( empty($account) || $account->uid != $uid ) {
  // Invalid uid
}
else {
  // Valid uid
}
s866’s picture

s866 commented

Thank you nevets for your answer! But I think it is not what I'm looking for. I simply need that PHP code could perform a query and then return "False" if it determines that user with uid=103 does not exist or "True" if user with uid=103 does exist.
Maybe this code might look like this?

db_result(db_query("SELECT COUNT(*) FROM {users} WHERE uid = '%d';", [account:content-profile-profile-referral]));

at the moment of executing PHP code the token [account:content-profile-profile-referral] substituted with a number that is an exact uid (in this case number 103). how to return "false" or "true" properly?

s866’s picture

s866 commented

maybe like this?

if(db_result(db_query("SELECT COUNT(*) FROM {users} WHERE uid = '%d'", [account:content-profile-profile-referral]))){ 
return TRUE; 
} 
else { 
return FALSE; 
}
s866’s picture

s866 commented

Finaly I made it to work. I used another event - "Content is going to be saved", and added 3 conditions to this rule:
1) Saved content is profile (Content profile);
2) Saved content is new;
3) and Custom PHP code:

$answer = (db_result(db_query("SELECT COUNT(*) FROM {users} WHERE uid = '%d'", '[node:field_referral-formatted]')));
if ($answer >= 1){ 
return TRUE;
}
else{
return FALSE;
}

thanks to all who attended and answered :)

Alpinist1974’s picture

Alpinist1974 commented

Thanks for your post, s866 it helped me out!

Just as a note to others, the code should read:

db_result(db_query("SELECT COUNT(*) FROM {users} WHERE uid = '%d'", '[node:field_referral-formatted]'));
if ($answer >= 1){
return TRUE;
}
else{
return FALSE;
}

You left extra parentheses in the db_result() function from the previous iteration when you were using it inside an if statement.

Notice that I omitted the PHP brackets, as rules won't work if you include them...