/** * @return bool * @author Nicolas Juen */ private function getCampaigns() { /* @var $wpdb wpdb */ global $wpdb; $cols = $wpdb->get_col("SELECT id FROM {$wpdb->bea_s_campaigns} WHERE current_status IN( '" . implode("','", Bea_Sender_Campaign::getAuthStatuses()) . "' ) AND scheduled_from <= '" . current_time('mysql') . "' ORDER BY add_date ASC"); $this->log->log_this(sprintf('%d campaigns to send', count($cols))); if (!isset($cols) || empty($cols)) { $this->campaigns = array(); return false; } $this->campaigns = array_map('absint', $cols); return true; }
/** * @return string * @author Nicolas Juen */ private static function get_status_filter() { global $wpdb; return !isset($_GET['current_status']) || empty($_GET['current_status']) || !in_array($_GET['current_status'], Bea_Sender_Campaign::getAuthStatuses()) ? '' : $wpdb->prepare(' AND c.current_status = %s', $_GET['current_status']); }