show_choose_audience = true; // $this->show_choose_audience = (count(get_audiences_list('newsletters')) > 1 ); //if only 1 list of newsletters, don't offer selection $this->title = $title; $this->content = $content; $this->content_html = $content_html; $this->query_name = $queryname; } function choose_audience() { global $_GET; $choose_audience_string = '

' . '' . ' ' . "\n" . ' ' . "\n" . '' . ' ' . "\n" . ' ' . "\n" . ' ' . ' ' . "\n" . '

' . TEXT_PLEASE_SELECT_AUDIENCE .' ' . '' . zen_draw_pull_down_menu('audience_selected', get_audiences_list('newsletters'), $this->query_name) . '

' . zen_image_submit('button_select.gif', IMAGE_SELECT) . '

'; return $choose_audience_string; } function confirm() { global $_GET, $_POST, $db; if ($_POST['audience_selected']) { $this->query_name=$_POST['audience_selected']; if (is_array($_POST['audience_selected'])) $this->query_name=$_POST['audience_selected']['text']; } $query_array = get_audience_sql_query($this->query_name, 'newsletters'); $mail = $db->Execute($query_array['query_string'] ); $confirm_string = '' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . '' . '' . ' ' . "\n" . '' . ' ' . "\n" . '

' . sprintf(TEXT_COUNT_CUSTOMERS, $mail->RecordCount() ) . '

' . zen_draw_separator('pixel_trans.gif', '1', '10') . '

' . $this->title . '

' . zen_draw_separator('pixel_trans.gif', '1', '10') . '

' . nl2br($this->content_html) . '

' . zen_draw_separator('pixel_trans.gif', '1', '10') . '

' . nl2br($this->content) . '

' . zen_draw_separator('pixel_trans.gif', '1', '10') . '

' . zen_draw_hidden_field('audience_selected',$this->query_name). zen_image_submit('button_send_mail.gif', IMAGE_SEND_EMAIL) . '' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . '

'; return $confirm_string; } function send($newsletter_id) { global $db; $audience_select = get_audience_sql_query($this->query_name, 'newsletters'); $audience = $db->Execute($audience_select['query_string']); $records = $audience->RecordCount(); if ($records==0) return 0; $i=0; while (!$audience->EOF) { $i++; $html_msg['EMAIL_FIRST_NAME'] = $audience->fields['customers_firstname']; $html_msg['EMAIL_LAST_NAME'] = $audience->fields['customers_lastname']; $html_msg['EMAIL_MESSAGE_HTML'] = $this->content_html; zen_mail($audience->fields['customers_firstname'] . ' ' . $audience->fields['customers_lastname'], $audience->fields['customers_email_address'], $this->title, $this->content, STORE_NAME, EMAIL_FROM, $html_msg, 'newsletters'); echo zen_image(DIR_WS_ICONS . 'tick.gif', $audience->fields['customers_email_address']); //force output to the screen to show status indicator each time a message is sent... if (function_exists('ob_flush')) @ob_flush(); @flush(); $audience->MoveNext(); } $newsletter_id = zen_db_prepare_input($newsletter_id); $db->Execute("update " . TABLE_NEWSLETTERS . " set date_sent = now(), status = '1' where newsletters_id = '" . zen_db_input($newsletter_id) . "'"); return $records; //return number of records processed whether successful or not } } ?>