vb.org Archive - Extract mailing list by language selection

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - Extract mailing list by language selection (https://vborg.vbsupport.ru/showthread.php?t=195432)

Cibulo

11-04-2008 04:15 PM

Extract mailing list by language selection

Hello, I ask here for help as I have posted a request on vbulletin.com and they suggested me to show up here for my request.

I have a forum where people choose their favourite language: english and spanish.
I need to extract two mailing list from my forum, depending on the language they have selected. So then I will be able to use poMMo in order to send separate mailing lists depending on the preferred language.

For further info, please give a look at the original thread http://www.vbulletin.com/forum/showt...61#post1647461

I am a total newbie as far as php and programming is concerned, so I count on your help and kindness.

Thank you so much,

--------------- Added [DATE]1225872785[/DATE] at [TIME]1225872785[/TIME] ---------------

anyone can help me on this? It would be really useful for me! :(

I'd like to send two separate November newsletter, one in english and the other one in spanish...

Cibulo

11-06-2008 08:06 PM

come on guys, please! ;)

Gio~Logist

11-06-2008 08:22 PM

A query like this is what you'd want.

Code:

select userid, username, email from user WHERE languageid == 'x'

So in a vb page it will be something like:

PHP Code:


		
			
$vbulletin->db->query_read("SELECT userid, username, email
                        FROM " . TABLE_PREFIX . "user
                        WHERE languageid == 'x'
                    ");

Replace x with the languageid for the language you're trying to pull info based on.

All times are GMT. The time now is 12:13 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01378 seconds Memory Usage 1,716KB 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)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)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
Messages: