get_results( "SELECT * FROM " . $wpdb->prefix . "huge_it_contact_general_options ORDER BY id" ); $mailing_progress = $genOptions[33]->value; $mailerParams = array( 'sub_count_by_parts' => $genOptions[30]->value, 'sub_interval' => $genOptions[31]->value, 'email_subject' => $genOptions[32]->value, 'mailing_progress' => $genOptions[33]->value, ); $count = $wpdb->get_var( "SELECT COUNT(*) FROM " . $wpdb->prefix . "huge_it_contact_subscribers" ); $subscribers = $wpdb->get_results( "SELECT * FROM " . $wpdb->prefix . "huge_it_contact_subscribers ORDER BY subscriber_id DESC", ARRAY_A ); $fieldInfo = $wpdb->get_results( "SELECT DISTINCT subscriber_form_id FROM " . $wpdb->prefix . "huge_it_contact_subscribers", ARRAY_A ); $formsToShow = array(); foreach ( $fieldInfo as $key => $value ) { $res = $wpdb->get_results( "SELECT name,id FROM " . $wpdb->prefix . "huge_it_contact_contacts WHERE id=" . $value['subscriber_form_id'], ARRAY_A ); if ( $res ) { $formsToShow[ $res[0]['id'] ] = $res[0]['name']; } } $mailing = array(); if($mailing_progress=='start'){ $formsID=$genOptions[29]->value; $limit=$genOptions[30]->value; $schedule=$genOptions[31]->value; $query_form_string=($formsID!=='all')?" AND subscriber_form_id=".$formsID." ":' '; $count_subscribers = $wpdb->get_var("SELECT COUNT(*) FROM ".$wpdb->prefix."huge_it_contact_subscribers WHERE `send`='1'".$query_form_string); $total_total_percent = $wpdb->get_var("SELECT COUNT(*) FROM ".$wpdb->prefix."huge_it_contact_subscribers WHERE send='1' OR send='3'".$query_form_string); $current_total_percent=$wpdb->get_var("SELECT COUNT(*) FROM ".$wpdb->prefix."huge_it_contact_subscribers WHERE send='3'".$query_form_string); $need_time = ceil($count_subscribers / $limit) * $schedule; $need_time = date("H:i:s", mktime(0, 0, $need_time)); $percent=($total_total_percent)?round($current_total_percent/$total_total_percent*100):100; $mailing['need_time']=$need_time; $mailing['percent']=$percent; } hugeit_contact_html_show_emails( $subscribers, $mailerParams, $count, $formsToShow, $mailing ); } function hugeit_contact_save_global_options() { global $wpdb; if ( isset( $_POST['mailerParams'] ) ) { $mailerParams = esc_html( $_POST['mailerParams'] ); $mailerParams = huge_it_subscriber_sanitize( $mailerParams ); foreach ( $mailerParams as $key => $value ) { $wpdb->update( $wpdb->prefix . 'huge_it_contact_general_options', array( 'value' => $value ), array( 'name' => $key ), array( '%s' ) ); } ?>

0 ) ? $options['sub_count_by_parts'] : 10; if( in_array($options['sub_interval'], $schedule) ){ $clean_options['sub_interval'] = $options['sub_interval']; }else{ $clean_options['sub_interval'] = 120; } return $clean_options; }