phpBB.de - Die deutsche phpBB-Community
https://www.phpbb.de/community/
#
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.';
#
<?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);
?>
<div class="maintitle"></div>
<br />
<div class="genmed"></div>
<br />
<br />
DreamPromise hat geschrieben:Moinmoin
nein....die heißt nicht phpbb_massenemails sondern forum_massenemails
Muß man denn jetzt irgendwo das phpbb mit forum ersetzen ???
Code: Alles auswählen
$sql="SELECT * FROM phpbb_massenemails"; Wenn ich nun aber das phpbb durch forum ersetzen kommt Hacking attempt<?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 forum_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 </td>" .
"</tr>" .
"</table>" .
"<br />";
$template->assign_vars(array(
'NACHRICHT' => $nachricht,
'SUBJECT' => $subject)
);
$template->pparse('BODY');
include('./page_footer_admin.'.$phpEx);
?>
Code: Alles auswählen
mysql_connect("$dbhost","$dbuser","$dbpasswd");
mysql_select_db("$dbname");