MailerPress – Send Beautiful Email Campaigns

Use placeholders and $wpdb->prepare(); found prepare

Unescaped parameter $query used in $wpdb->get_results($query)\n$query assigned unsafely at line 938:\n $query = $wpdb->prepare("\n SELECT \n c.campaign_id,\n c.name,\n c.status,\n c.created_at,\n b.id AS batch_id,\n b.scheduled_at,\n b.total_emails,\n b.sent_emails,\n b.created_at AS batch_created_at\n FROM {$campaignsTable} c\n INNER JOIN {$batchesTable} b ON c.batch_id = b.id\n WHERE c.status = 'sent'\n AND c.status != 'trash'\n AND b.sent_emails > 0\n ORDER BY b.created_at DESC\n LIMIT %d\n ", $limit)\n$campaignsTable assigned unsafely at line 932:\n $campaignsTable = Tables::get(Tables::MAILERPRESS_CAMPAIGNS)\n$batchesTable assigned unsafely at line 933:\n $batchesTable = Tables::get(Tables::MAILERPRESS_EMAIL_BATCHES)

Use placeholders and $wpdb->prepare(); found $query

Use placeholders and $wpdb->prepare(); found $totalQuery

Use placeholders and $wpdb->prepare(); found $userId

Unescaped parameter $trackingTable used in $wpdb->get_results($wpdb->prepare(\n "SELECT batch_id,\n COUNT(DISTINCT CASE WHEN opened_at IS NOT NULL THEN contact_id END) AS total_opens,\n SUM(clicks) AS total_clicks,\n COUNT(DISTINCT CASE WHEN unsubscribed_at IS NOT NULL THEN contact_id END) AS total_unsubscribes\n FROM {$trackingTable}\n WHERE batch_id IN ($batch_placeholders)\n GROUP BY batch_id",\n ...$batch_ids\n ))\n$trackingTable assigned unsafely at line 934:\n $trackingTable = Tables::get(Tables::MAILERPRESS_EMAIL_TRACKING)

Use placeholders and $wpdb->prepare(); found $this

Use placeholders and $wpdb->prepare(); found wpdb

Use placeholders and $wpdb->prepare(); found prepare

A function call to __() with texts containing placeholders was found, but was not accompanied by a "translators:" comment on the line above to clarify the meaning of the placeholders.