/** * Returns the CM IDs for a given list of template IDs * * @param array $templateIds The ids of the templates. * @return array */ public static function getCampaignMonitorIDsForTemplates($templateIds) { // check if templates are set, $templates = empty($templateIds) ? array(BackendMailmotorModel::getDefaultTemplateID()) : $templateIds; // fetch campaignmonitor IDs return (array) BackendModel::getDB()->getColumn('SELECT mci.cm_id FROM mailmotor_campaignmonitor_ids AS mci WHERE mci.type = ? AND mci.other_id IN (' . implode(',', $templates) . ')', array('template')); }