What do i need to do to allow a user to subscribe to a role ?

After u'have successful with the setup just post the workflow.
So that it would be helpful to others. If time premits it.

Sunny
www.gleez.com

There are some hacks in here, driven by laziness. I'll be refactoring soon, but this is good enough to get the idea from. The main piece for drupal is:

$assignRoleQuery = "INSERT INTO drupal.users_roles(uid,rid) VALUES('".$site_uid."','3')";

'3' is a role id on my site, something that would be different from site to site.

/* 
CREATE TABLE payments (
    txn_id varchar(30) NOT NULL default '',
    first_name varchar(100) NOT NULL default '',
    last_name varchar(100) NOT NULL default '',
    country varchar(50) NOT NULL default 'Unknown',
    side_uid int NOT NULL,
    email varchar(100) NOT NULL,
    payment_date varchar(50) NOT NULL,
    subs_effective varchar(50) NOT NULL,
    subs_type varchar(50) NOT NULL,
    payment_amount varchar(6) NOT NULL,
    payment_currency varchar(6) NOT NULL default '',
    payment_commission varchar(6) NOT NULL,
    payment_status varchar(15),    
    payment_type varchar(15));
 */

// read the post from PayPal system and add 'cmd'
$req = 'cmd=_notify-validate';
foreach ($_POST as $key => $value) {
    $value = urlencode(stripslashes($value));
    $req .= "&$key=$value";
}
// post back to PayPal system to validate
$header = "POST /us/cgi-bin/webscr HTTP/1.0\r\n";
$header .= "Content-Type: application/x-www-form-urlencoded\r\n";
$header .= "Content-Length: " . strlen($req) . "\r\n\r\n";
//$fp = fsockopen ('www.paypal.com', 80, $errno, $errstr, 30);
$fp = fsockopen ('www.sandbox.paypal.com', 80, $errno, $errstr, 30);



// assign posted variables to local variables

$status = $_POST['payment_status'];
$payment_amount = $_POST['mc_gross'];
$payment_currency = $_POST['mc_currency'];
$txn_id = $_POST['txn_id'];
$payment_date = $_POST['payment_date'];
$first_name = $_POST['first_name'];
$last_name = $_POST['last_name'];
$payment_type = $_POST['payment_type'];
$payment_status = $_POST['payment_status'];
$email = $_POST['payer_email'];
$txn_type = $_POST['txn_type'];
$payer_status = $_POST['payer_status'];
$country = $_POST['address_country'];
$custom = $_POST['custom'];
$subs_effective  = $_POST['subscr_effective'];

list($subs_type, $site_uid) = explode(':', $custom);


$notify_email =  "root@localhost";         //email address to which debug emails are sent to

$DB_Server = "localhost"; //your MySQL Server
$DB_Username = "root"; //your MySQL User Name
$DB_Password = "root"; //your MySQL Password
$DB_PaypalDBName = "paypal"; //your MySQL Database Name
$DB_DrupalDBName = "drupal";


$log = fopen("ipn.log", 'a');


if (!$fp) {
// HTTP ERROR
} 
else {
    fputs ($fp, $header . $req);
    while (!feof($fp)) {
        $res = fgets ($fp, 1024);
    }
    if (strcmp ($res, "VERIFIED") == 0) {
        
        fputs($log, $txn_id . ": VERIFIED.  Dump: " . $req . "\n");
        
        //create MySQL connection
        $Connect = @mysql_connect($DB_Server, $DB_Username, $DB_Password)
            or die("Couldn't connect to MySQL:<br>" . mysql_error() . "<br>" . mysql_errno());

        //select database
        $Db = @mysql_select_db($DB_PaypalDBName, $Connect)
            or die("Couldn't select database:<br>" . mysql_error(). "<br>" . mysql_errno());
        

        //check if transaction ID has been processed before
        $checkquery = "select txn_id from payments where txn_id='".$txn_id."'";
        $sihay = mysql_query($checkquery) or die("Duplicate txn id check query failed:<br>" . mysql_error() . "<br>" . mysql_errno());
        $nm = mysql_num_rows($sihay);
        if ($nm == 0){
        //execute query
        //subscription handling branch
            if ($txn_type == "subscr_payment") {
                fputs($log, "subscr_payment called\n");
                 if ($subs_type == 'FOOBAR_1YR' && $payment_amount != "35.00") {
                     fputs($log, "FRAUD: " . $txn_id . "/" . $site_uid . "/" . $email . "/expected=35.00, paid=" . $payment_amount);
                 }
                 else {
                     
                     fputs($log, "Now inserting to database...\n");
                    $insertQuery = "INSERT INTO payments(txn_id, first_name, last_name, country, site_uid, email, payment_date, " .
                                  "subs_effective, subs_type, payment_amount, payment_currency, payment_commission, payment_status, "    .
                                  "payment_type) VALUES ('".$txn_id."','".$first_name."','".$last_name."','".$country."','".$site_uid."','".$email."','".$payment_date."','".$subs_effective."','".$subs_type."','".$payment_amount."','".$payment_currency."','".$payment_commission."','".$payment_status."','".$payment_type."')";
                    fputs($log, "\n" . $insertQuery . "\n");
                    $result = mysql_query($insertQuery) or die("Subscription - paypal_payment_info, Query failed:<br>" . mysql_error() . "<br>" . mysql_errno());
                    
                        fputs($log,mysql_errno() . mysql_error() . "\n");
                    
                    
                    $assignRoleQuery = "INSERT INTO drupal.users_roles(uid,rid) VALUES('".$site_uid."','3')";
                
                    $result = mysql_query($assignRoleQuery) or die ("Couldn't add user to role.<br>" . mysql_error());
                    if (!$result) {
                        fputs($log, mysql_error() . "\n");
                    }
                    mysql_close($Connect);
                     mail($notify_email, "VERIFIED IPN", "$res\n $req\n $insertQuery\n$assignRoleQuery");
                 }
            }
            }
    }
    else if (strcmp ($res, "INVALID") == 0) {
        // log for manual investigation
        mail($notify_email, "INVALID IPN", "$res\n $req");
    }
}
fclose($log);