[mod] API to subscribe using particular code

[dani]

I have the same problem.
I'm using phpBB3 for my forum, and I would like to auto-subscribe every user that registers in my forum to the newsletters.
I think the admin/subscribelib2 has the php funcions needed to register a user, so probably can be done with that.
I will try it.

[dani]

Finally, I've done. It was not difficult.
Here is the code:

Code: Select all

// User registration
$query_user = sprintf("INSERT INTO phplist_user_user (email, confirmed, entered, htmlemail, rssfrequency) VALUES ('%s', '%s', '%s', '%s', '%s')", $email, 1, date('Y-m-d H:i:s'),1, ''); 
mysql_query($query_user, $PhplistConn) or die(mysql_error());

$query_userid = sprintf("SELECT id from phplist_user_user WHERE email LIKE '%s'", $email);
$Recordset_user = mysql_query($query_userid, $PhplistConn) or die(mysql_error());
$row_Recordset_user = mysql_fetch_assoc($Recordset_user);
$user_id = $row_Recordset_user['id'];

// User subscription
$query_listuser = sprintf("INSERT INTO phplist_listuser (userid, listid, entered) VALUES ('%s', '%s', '%s')",
$user_id, $list_id, date('Y-m-d H:i:s'));

mysql_query($query_listuser, $PhplistConn) or die(mysql_error());


Hope it helps[/code]

[spazcer]

I also added this little bit to the bottom of your code to add attributes

Code: Select all

// User attributes
      $query_listatt = sprintf("INSERT INTO phplist_user_user_attribute (attributeid, userid , value) VALUES ('%s', '%s', '%s')",
      '1', $user_id, $full_name);
      mysql_query($query_listatt, $PhplistConn) or die(mysql_error());


thanks a bunch dani. your code def saved me some time and got me started