public static function insertMailingData($mailing)
{
$db = JFactory::getDBO();
if ($mailing->mailing_type == 7) {
//modified for the fix on smartnewsletter
$mailing->senddate = !empty($mailing->send_date) ? $mailing->send_date : 0;
if (empty($mailing->notify_id)) {
$mailing->notify_id = 0;
}
if (empty($mailing->delay_max)) {
$mailing->delay_max = 1;
}
if (empty($mailing->smart_date)) {
$mailing->smart_date = 0;
}
if (empty($mailing->cat_id)) {
$mailing->cat_id = '0:0';
}
if (empty($mailing->attachments)) {
$mailing->attachments = '';
}
if (empty($mailing->images)) {
$mailing->images = '';
}
}
if (is_array($mailing->attachments)) {
$mailing->attachments = trim(implode("\n", $mailing->attachments));
}
if (empty($mailing->senddate)) {
$mailing->senddate = 0;
}
if (empty($mailing->list_id)) {
$mailing->list_id = 0;
}
$xf = new jNews_Config();
$query = "INSERT INTO `#__jnews_mailings` ( `list_id`,\n `mailing_type`,\n `template_id`,\n `send_date`,\n `subject`,\n `htmlcontent`,\n `textonly`,\n " . "\n `attachments`,\n `images`,\n `published`,\n `html`,\n `visible`,\n `fromname`,\n `fromemail`,\n `frombounce`,\n " . "\n `author_id`,\n `delay`,\n `follow_up`,\n `cat_id`,\n `delay_min`,\n `delay_max`,\n `notify_id`,\n `next_date`,\n `start_date`,\n `smart_date`,\n `issue_nb`,\n `acc_level`,\n `createdate`) " . "\n VALUES (" . "{$mailing->list_id}, " . "{$mailing->mailing_type}, " . "{$mailing->template_id}, " . "'{$mailing->senddate}', " . "'" . addslashes($mailing->subject) . "', " . "'" . addslashes($mailing->htmlcontent) . "', " . "'" . addslashes($mailing->textonly) . "', " . "'{$mailing->attachments}', " . "'{$mailing->images}', " . "{$mailing->published}, " . "{$mailing->html}, " . "{$mailing->visible}, " . "'{$mailing->fromname}', " . "'{$mailing->fromemail}', " . "'{$mailing->frombounce}', " . "'{$mailing->author_id}', " . "{$mailing->delay}, " . "{$mailing->follow_up}, " . "'{$mailing->cat_id}', " . "{$mailing->delay_min}, " . "{$mailing->delay_max}, " . "{$mailing->notify_id}, " . "{$mailing->next_date}, " . "{$mailing->start_date}, " . "'{$mailing->smart_date}', " . "'{$mailing->issue_nb}', " . "'{$mailing->acc_level}', " . "{$mailing->createdate} ) ";
$db->setQuery($query);
$db->query();
$xf->plus('totalmailing0', 1);
$xf->plus('act_totalmailing0', 1);
$xf->plus('totalmailing' . $mailing->mailing_type, 1);
$xf->plus('act_totalmailing' . $mailing->mailing_type, 1);
$mailingId = jNews_Mailing::getLastMailingId();
jNews_Mailing::insertStatsGlobal($mailingId);
return $mailingId;
}
