language;
$valid = false;
$number = arg(2);//strtoupper($_POST[“cffnumber”]);
// check for this number being valid
$message = cff_number_pattern_valid($number);
if ($message != “ok”)
{
drupal_set_message(“Invalid Licence number: ” . $message );
}
else
{
// The number is valid, now check if it is on the site…
$result = db_query(“select * from users where name=’$number'”);
if ($result->rowCount() > 0) {
// User has an account. Show the regular log in block
$msg = “Please login with your CFF web site account to renew your licence.”;
if ($lang == “fr”) {
$msg = “SVP connectez vous à votre compte Internet de la FCE pour renouveler votre licence 2014”;
}
drupal_set_message($msg);
drupal_goto(‘user/login’, array(‘query’=>array(
‘number’=>$number
)));
} else {
$result = db_query(“select * from cff_licences where cff_num=’$number'”);
if ($result->rowCount() > 0) {

// User is not registered on the site. Send ’em to the user registration page, loaded with new #
drupal_goto(‘user/register’, array(‘query’=>array(
‘existing_cff_number’=>$number
)));
} else {
// This user does not exist anywhere. Direct them to the new member flow.
print “This CFF-Licence number does not exist: ” . $number;
}
}
}