merging mailing lists automatically?

[bdjncox]

I am currently maintaining two separate mailing lists: my registered Vb users and a separate list that I manage with MyMail (php/MySQL-based).

I'd like to get that down to just one list. My preference would be for everyone to register for my forum and just use that list, but that's not going to happen.

Is there a way to give the option for joining our newsletter at the Vb registration and have that e-mail address automatically entered into the MyMail list?

[Admin]

Is the MyMail database the same as vBulletin's? If not, can they be accessed using the same MySQL user?

[bdjncox]

They are separate MySQL DB's and both, I assume, are accessible by the same user. How would I check that to be certain?

[Admin]

See if the info in vB's config.php is the same as the info in MyMail's configuration file.

[bdjncox]

yeah, they are the same.

[Admin]

Ok. Can you get the MySQL query that inserts new e-mail into the MyMail mailing list?

(I'm querying you like this because I have no idea what MyMail is nor where to get it :))

[bdjncox]

I'm not exactly sure where to find that query. Would it be contained in the .SQL file that came with the software?

Its a free program available at http://scripts.codingclick.com/MyMail/ if you want to take a look.

[Admin]

Alright...
INSERT INTO emails SET listID='$listID', email='$email', validated='1', date=CURDATE()
(for reference)

What's the database MyMail is using?

[bdjncox]

mail_list

[Admin]

What's the default list ID you want them to join?

[bdjncox]

2

It assigns each list a numeric ID.

[bdjncox]

Sorry for bumping this, but do you think this one was going to be possible? I'm getting ready to launch the new site design and upgrade to 2.2.4 so I thought I'd include this hack if it sounds easily accomplished.

[Admin]

Ooops, missed this thread! Sorry. :)

In register.php add:
$DB_site->query("INSERT INTO emails SET listID='2', email='".addslashes($email)."', validated='1', date=CURDATE()");
right after this:
$userid=$DB_site->insert_id();

[bdjncox]

Hmmm....

I assume that I DO NOT include the hyperlink to the php.net site in that code...

Under that assumption, I modified the register.php file and two things happened:

1) a new registrant did show up on the forumhome as the newest member; however, I could not search for the new user in the Admin CP.

2) the email address of the new user was not added to the mailing list.

Its quite possible that I misunderstood a direction. Was I supposed to fill in a variable in that code you gave me or use as-is?

[bdjncox]

(politely bumping this as I am still in need of an answer if possible)

[glo]

Any news on this bdjncox

[mtf169]

I'm interested in this too ... any answers?

[glo]

any further developments on this Chen or bdjncox.

Would like to know if this is completed or dropped.