phpBB.de - Die deutsche phpBB-Community
https://www.phpbb.de/community/
Code: Alles auswählen
##############################################################
## MOD Title: Massen-E-Mail Archiv
## MOD Author: Xstream < info@zepi.ch > (Matthias Zobrist) http://www.allinall-board.de/
## MOD Description: Diese Mod speicher alle Massen-E-Mails, die Sie mit Ihrem phpBB versenden und werden auf einer spezielen Seite angezeigt.
## MOD Version: 1.0.0
##
## Installation Level: easy
## Installation Time: ca. 15 Minutes
## Files To Edit: admin_mass_email.php, lang_admin.php
## Included Files: n/a
## Generator: phpBB2 Mod Maker 0.1.67
##############################################################
## For Security Purposes, Please Check: http://www.phpbb.com/mods/downloads/ for the
## latest version of this MOD. Downloading this MOD from other sites could cause malicious code
## to enter into your phpBB Forum. As such, phpBB will not offer support for MOD's not offered
## in our MOD-Database, located at: http://www.phpbb.com/mods/downloads/
##############################################################
## Author Notes:
##############################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
##############################################################
#
#-----[ COPY TO FOLDER ]------------------------------------------
#
admin/admin_mass_email_archiv.php TO admin/
templates/mass_email_archiv_body.tpl TO templates/subSilver/admin/
#
#-----[ SQL ]------------------------------------------
#
CREATE TABLE `phpbb_massenemails` (
`id` int(11) NOT NULL auto_increment,
`datum` varchar(10) NOT NULL default '',
`titel` varchar(255) default NULL,
`nachricht` text,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=16 ;
#
#-----[ OPEN ]------------------------------------------
#
admin/admin_mass_email.php
#
#-----[ FIND ]------------------------------------------
#
if ( isset($HTTP_POST_VARS['submit']) )
{
#
#-----[ AFTER, ADD ]------------------------------------------
#
$message2=$_POST[message];
$subject2=$_POST[subject];
$datum=date("d.m.Y");
$sql2="INSERT INTO phpbb_massenemails ( id , datum, titel , nachricht) VALUES ('', '$datum', '$subject2', '$message2')";
if (mysql_query($sql2)) {
echo "";
}
else {
echo "";
}
#
#-----[ OPEN ]------------------------------------------
#
language/lang_german/lang_admin.php
#
#-----[ FIND ]------------------------------------------
#
?>
#
#-----[ BEFORE, ADD ]------------------------------------------
#
//
// Massen-E-Mail Archiv
//
$lang['Link_Mass_Archiv'] = 'Massen-E-Mail Archiv';
$lang['Mass_Archiv_Titel'] = 'Massen-E-Mail Archiv Mod';
$lang['Mass_Archiv_explain'] = 'Hier sehen Sie alle Massen-E-Mails, die Sie versendet haben.';
#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoMCode: Alles auswählen
<?php
define('IN_PHPBB', 1);
if( !empty($setmodules) )
{
$file = basename(__FILE__);
$module['General']['Link_Mass_Archiv'] = 'admin_mass_email_archiv.'.$phpEx;
return;
}
//
// Let's set the root dir for phpBB
//
$phpbb_root_path = "./../";
require($phpbb_root_path . 'extension.inc');
require('./pagestart.' . $phpEx);
include('./page_header_admin.'.$phpEx);
$template->set_filenames(array(
'BODY' => 'admin/mass_email_archiv_body.tpl'
));
echo "<div class='maintitle'>{$lang['Mass_Archiv_Titel']}</div>" .
"<br />" .
"<p>{$lang['Mass_Archiv_explain']}</p>" .
"<br />" .
"<br />" .
"<table cellspacing='1' cellpadding='4' border='0' align='center' class='forumline'>" .
"<tr>" .
"<th class='thHead' colspan='3'>Archiv</th>" .
"</tr>";
mysql_connect("$dbhost","$dbuser","$dbpasswd");
mysql_select_db("$dbname");
$sql="SELECT * FROM phpbb_massenemails";
$result=mysql_query($sql);
while ($row=mysql_fetch_assoc($result)) {
$var1 = $row[nachricht];
$var1 = wordwrap($var1, 70, "<br>", 1);
echo "<tr>" .
"<td class='row2'><span class='gen'><b>Datum:</b></span></td>" .
"<td class='row2'><span class='gen'><b>Titel:</b></span></td>" .
"<td class='row2'><span class='gen'><b>Nachricht:</b></span></td>" .
"</tr>" .
"<tr>" .
"<td class='row2'><span class='gen'>$row[datum]</span></td>" .
"<td class='row2'><span class='gen'>$row[titel]</span></td>" .
"<td class='row2'><span class='gen'>$var1</span></td>" .
"</tr>" .
"<tr>" .
"<td class='row1' align='right'> </td>" .
"<td class='row1'><span class='gen'> </span></td>" .
"<td class='row1'><span class='gen'> </span></td>" .
"</tr>";
}
echo "<tr>" .
"<td class='catBottom' align='center' colspan='3'>Massen-E-Mail Archiv Mod © 2004 by <a href='http://www.allinall-board.de' target='_blank'>xstream</a></td>" .
"</tr>" .
"</table>" .
"<br />";
$template->assign_vars(array(
'NACHRICHT' => $nachricht,
'SUBJECT' => $subject)
);
$template->pparse('BODY');
include('./page_footer_admin.'.$phpEx);
?>Code: Alles auswählen
$sql="SELECT * FROM phpbb_massenemails"; Code: Alles auswählen
$sql="SELECT * FROM phpbb_massenemails Order By DESC";Code: Alles auswählen
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /www/htdocs/w0056704/admin/admin_mass_email_archiv.php on line 37Code: Alles auswählen
mysql_select_db("$dbname");
$sql="SELECT * FROM forum_massenemails Order By DESC";
$result=mysql_query($sql);
while ($row=mysql_fetch_assoc($result)) {
$var1 = $row[nachricht];
$var1 = wordwrap($var1, 70, "<br>", 1);