/** * function to delete the Message Templates * * @access public * @static * * @return object */ static function del($messageTemplatesID) { // make sure messageTemplatesID is an integer if (!CRM_Utils_Rule::positiveInteger($messageTemplatesID)) { CRM_Core_Error::fatal(ts('Invalid Message template')); } // set membership_type to null $query = "UPDATE civicrm_membership_type\n SET renewal_msg_id = NULL\n WHERE renewal_msg_id = %1"; $params = array(1 => array($messageTemplatesID, 'Integer')); CRM_Core_DAO::executeQuery($query, $params); $query = "UPDATE civicrm_mailing\n SET msg_template_id = NULL\n WHERE msg_template_id = %1"; CRM_Core_DAO::executeQuery($query, $params); $messageTemplates = new CRM_Core_DAO_MessageTemplates(); $messageTemplates->id = $messageTemplatesID; $messageTemplates->delete(); CRM_Core_Session::setStatus(ts('Selected message templates has been deleted.')); }