vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)
-   -   merging mailing lists automatically? (https://vborg.vbsupport.ru/showthread.php?t=35864)

bdjncox 03-08-2002 01:56 PM

merging mailing lists automatically?
 
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 03-08-2002 02:00 PM

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

bdjncox 03-08-2002 02:24 PM

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 03-08-2002 02:26 PM

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

bdjncox 03-08-2002 02:30 PM

yeah, they are the same.

Admin 03-08-2002 02:33 PM

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 03-08-2002 02:39 PM

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 03-08-2002 02:45 PM

Alright...
Code:

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

What's the database MyMail is using?

bdjncox 03-08-2002 02:54 PM

mail_list

Admin 03-08-2002 02:57 PM

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

bdjncox 03-08-2002 02:58 PM

2

It assigns each list a numeric ID.

bdjncox 03-11-2002 05:43 PM

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 03-11-2002 06:32 PM

Ooops, missed this thread! Sorry. :)

In register.php add:
Code:

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

  $userid=$DB_site->insert_id();

bdjncox 03-11-2002 08:12 PM

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 03-19-2002 07:31 PM

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

glo 07-27-2003 06:34 AM

Any news on this bdjncox

mtf169 01-08-2004 11:22 PM

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

glo 02-01-2004 09:36 AM

any further developments on this Chen or bdjncox.

Would like to know if this is completed or dropped.


All times are GMT. The time now is 05:03 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01110 seconds
  • Memory Usage 1,740KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (18)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete