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?