phpBB.de

<?php
/***************************************************************************
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
***************************************************************************/
define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);




//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_NEWSLETTER);
init_userprefs($userdata);
//
// End session management
//

if ( !$userdata['session_logged_in'] )
{
header('Location: ' . append_sid("login.$phpEx?redirect=newsletter_write.$phpEx", true));
exit;
}

if ((!$userdata['user_level']==ADMIN) || (!$userdata['user_level']==LESS_ADMIN))
{
message_die(GENERAL_MESSAGE, $lang['Not_Allowed']);
}


// Start Template-Settings
$template->set_filenames(array(
"body" => "newsletter_write_body.tpl")
);
// End Template-Settings


// Start writing newsletter
if($subject == '' || $message == '' || $group == '')
{
//message_die(GENERAL_ERROR, $lang['Newsletter_empty']);

$datum = time();
$date = date("d.m.Y",$datum);
}

else
{


//Sum active News_users
$sql = "SELECT count(*) as total FROM " . NEWSLETTER . " WHERE activation = 1 and cat = '$group'";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not obtain Sum', '', __LINE__, __FILE__, $sql);
}
if ( !($row = $db->sql_fetchrow($result)) )
{
message_die(GENERAL_ERROR, 'Could not obtain sum', '', __LINE__, __FILE__, $sql);
}
$sumactusers = $row['total'];




$datum = time();
$date = date("d.m.Y", $datum);

$newsletter_subject = $board_config['newsletter_subject'] . " " . $date;
$newsletter_subject = $subject;

$newsletter_message = $newsletter_subject . "\n\n" . stripslashes($message);

$newsletter_message .= $forum . stripslashes($news) . "\n\n" . $board_config['board_email_sig'];


$newsletter_message .= "\n\n";


$newsletter = mysql_query("SELECT recipient_mail FROM " . NEWSLETTER . " WHERE activation = '1' and cat = '$group'");

if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, "Could not obtain active recipients information.", '', __LINE__, __FILE__, $sql);
}

$count = mysql_num_rows($newsletter);

for($i = 0; $i < $count; $i++)
{
$recipient = mysql_result($newsletter, $i, "recipient_mail");

// Unsubscribe-Link mit Feldern zusammenbauen
$newsletter_message2 = $newsletter_message;
$newsletter_message2 .= $lang['UnsubscribeLink'] . "?email=" . $recipient . "&group=" . $group;

//Anzahl Newsletter-Empfänger zusammenbauen
$newsletter_message2 .= "\n\n";
$newsletter_message2 .= $lang['Newsletter_SendtoUser'] . " " . $sumactusers . " " . $lang['Newsletter_Recipient'] . ".";

mail($recipient, $newsletter_subject, $newsletter_message2, "From: " . $board_config['sitename'] . " <" . $board_config['board_email'] . ">");


//Empfänger schreiben
$sumrecip = $sumrecip . $recipient . "<br>";


}



if($inarchiv == 'yes')

{
// Archiving Newsletter
$subject = addslashes($newsletter_subject);
$archiv_message = $newsletter_subject . "<br><br>" . $message;
$news = addslashes($archiv_message);

$sql = "INSERT INTO " . NEWSLETTER_ARCHIV . " (subject,news,author,user_id,cat) VALUES ('$subject','$news','$userdata[username]','$userdata[user_id]','$group')";

if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, "Could not insert data into newsletter_archiv table.", '', __LINE__, __FILE__, $sql);
}
//
}

message_die(GENERAL_MESSAGE, $lang['Newsletter_submitted'] ."<br>" . $sumrecip . "<br>" . $lang['SumActUsers'] . " " . $sumactusers);


}
// End writing Newsletter



// Deleting inactive recipients after x days (defined in config_table)
/*$sql = "DELETE FROM " . NEWSLETTER . " WHERE activation = '0' AND expire = time()-$board_config[inactive_days]";

if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, "Could not delete inactive recipients.", '', __LINE__, __FILE__, $sql);
}*/
//



//Zeigen Gruppen für Sendeauswahl an
$select = '<select name="group">';
$sql = "SELECT name, id, descr, phpforum_id from " . NEWSLETTER_CAT_TABLE . " ";
$result = $db->sql_query($sql);
while ( $row = $db->sql_fetchrow($result) )
{
// $selected = '';
// if ($row['id']==1) $selected='selected';
$select .= '<option value=' . $row['name'] . ' ' . $selected . '>' . $row['descr'] . '</option>';
}
$select .= '</select>';






//Zeige Forumname neben Forum-ID an.
$forumname=' ';
$forumnbr = $new['newsletter_lastmsgforum'];
$sql = "SELECT forum_name from " . FORUMS_TABLE . " where forum_id = '$forumnbr'";
$result = $db->sql_query($sql);
while ( $row = $db->sql_fetchrow($result) )
{
$forumname = $row['forum_name'];

}




// Output page header
$page_title = $lang['Newsletter_Write'];

include($phpbb_root_path . 'includes/page_header.'.$phpEx);

// Begin Templates - Main
$template->assign_vars(array(
'PAGE_TITLE' => $lang['Newsletter_Write'],
'SUBJECT' => sprintf($board_config['newsletter_subject'] . "&nbsp;" . $date),
'INACTIVE_DAYS' => $new['inactive_days'],
'NEWSLETTER_SUBJECT' => $new['newsletter_subject'],
'NEWSLETTER_LASTMSGFORUM' => $new['newsletter_lastmsgforum'],
'M_FORUM' => $forumname,
'LASTNEWS' => $lastpost,
'S_GROUP_SELECT' => $select,
'L_ACTIVE_RECIPIENTS' => $lang['Active_Recipients'],
'L_INACTIVE_RECIPIENTS' => $lang['Inactive_Recipients'],
'L_NEWSLETTER_CONFIG' => $lang['Newsletter_Config'],
'L_NEWSLETTER_SUBJECT' => $lang['Newsletter_Subject'],
'L_NEWSLETTER_SUBJECT_EXPLAIN' => $lang['Newsletter_Subject_Explain'],
'L_INACTIVE_DAYS' => $lang['Inactive_Days'],
'L_INACTIVE_DAYS_EXPLAIN' => $lang['Inactive_Days_Explain'],
'L_NEWSLETTER_LASTMSGFORUM' => $lang['Newsletter_LastmsgForum'],
'L_NEWSLETTER_LASTMSGFORUM_EXPLAIN' => $lang['Newsletter_LastmsgForum_Explain'],
'L_EMAIL' => $lang['Email'],
'L_NAME' => $lang['Name'],
'L_SUBJECT' => $lang['Subject'],
'L_DELETE' => $lang['Delete'],
'L_POST_NEWSLETTER' => $lang['Post_Newsletter'],
'L_DATE' => $lang['Date'],
'L_RESET' => $lang['NewsReset'],
'M_UPDATE' => $lang['MessUpdate'],
'L_SUBMIT' => $lang['Submit'],
'L_NEWS' => $lang['News'],
'L_GROUP' => $lang['NewsGroup'],
'S_CONFIG_ACTION' => append_sid("newsletter_admin.$phpEx"),
'S_SEND_ACTION' => append_sid("newsletter_write.$phpEx"),
'L_NEWS_INARCHIV' => $lang['NewsInArchiv'],
'L_NEWS_YES' => $lang['News_Yes'],
'L_NEWS_NO' => $lang['News_No'],

'U_INDEX' => append_sid("index.$phpEx"),
'L_PORTAL' => sprintf($lang['Forum_Index'], $board_config['sitename']),
'U_ADMIN' => append_sid("newsletter_admin.$phpEx"),
'L_ADMIN' => $lang['Newsletter_Admin'],
'U_ARCHIV' => append_sid("newsletter_archiv.$phpEx"),
'L_ARCHIV' => $lang['Newsletter_Archiv'],
'U_WRITE' => append_sid("newsletter_write.$phpEx"),
'L_WRITE' => $lang['Newsletter_Write'],
'U_USER' => append_sid("newsletter_user.$phpEx"),
'L_USER' => $lang['Newsletter_User'] )
);
// End Templates - Main



//
// Set other Template-Variables
$template->pparse('body');
// Set other Template-Variables
//

include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
?>