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?


All times are GMT. The time now is 01:40 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.00976 seconds
  • Memory Usage 1,726KB
  • 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
  • (1)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete