Mir gehts genauso...seit dem update funktioniert der Mod nicht mehr und bei "absenden" tut sich absolut nichts mehr.
Dies kann eigentlich nur mit der newsletter_write.php zusammenhängen.
Ich poste die mal komplett rein..vielleicht fällt ja einem phpbb-Profi auf Anhieb etwas auf.
Wäre SEHR wichtig für mich, da ich einen Newsletter für einen mittelgroßen Ort verwalte...und da jetzt GR Wahlen anstehen und wichtige Infos raus müssen..also danke ich schon mal im voraus für eure Hilfe!!
<?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'] . " " . $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);
?>
. Ebenfalls wurde der Mod an den FETCH_ALL 2.0.3 angepasst. 
