File: /var/www/web37/htdocs/websuche/adm/mod2/newsletter_archiv2.php
<?PHP
include "./inc/pfade.php";
db();
$id= $_GET['id'];
// Annoncen zählen --------------------------------------
$eintragzahl_sql= mysql_query("SELECT COUNT(*) as 'anzahl'
FROM ".$dbtable04."
WHERE html='nein' ");
$treffer = mysql_result($eintragzahl_sql,0,'anzahl');
$newsarchiv_sql= mysql_query("SELECT *
FROM ".$dbtable03."
WHERE siteid='".NoI("$id")."' ");
$ROW=mysql_fetch_assoc($newsarchiv_sql);
$titel= $ROW['titel'];
$text= $ROW['newslettertext'];
$datum= $ROW['datum'];
$zeit= $ROW['zeit'];
$artn= $ROW['html'];
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1">
<link rel="stylesheet" type="text/css" href="./inc/admin.css">
<TITLE>Administration</TITLE>
</HEAD>
<BODY BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0033CC" VLINK="#990099" ALINK="#FF0000" TOPMARGIN=0 LEFTMARGIN=0 MARGINWIDTH=0 MARGINHEIGHT=0>
<CENTER><br>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=981 class="menu_links">
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=60 COLSPAN=2 ALIGN=CENTER VALIGN=MIDDLE WIDTH=983><IMG HEIGHT=60 WIDTH=983 SRC="./gfx/logo.jpg" BORDER=0 ALT=""></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD ROWSPAN=2 WIDTH=200>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=200>
<TR VALIGN=TOP ALIGN=LEFT>
<TD WIDTH=8 HEIGHT=15><IMG SRC="./gfx/cpl.gif" WIDTH=8 HEIGHT=1 BORDER=0 ALT=""></TD>
<TD></TD>
<TD WIDTH=9><IMG SRC="./gfx/cpl.gif" WIDTH=9 HEIGHT=1 BORDER=0 ALT=""></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=534></TD>
<TD WIDTH=183>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=183 HEIGHT=534 bgcolor="#F4FAFF" class="menu_links">
<TR ALIGN=LEFT VALIGN=TOP>
<TD>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=183>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=28 COLSPAN=3 WIDTH=183>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=183 HEIGHT=28 bgcolor="#DEE3E7">
<TR ALIGN=LEFT VALIGN=TOP>
<TD>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=183>
<TR VALIGN=TOP ALIGN=LEFT>
<TD WIDTH=183 HEIGHT=5><IMG SRC="./gfx/cpl.gif" WIDTH=183 HEIGHT=1 BORDER=0 ALT=""></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD WIDTH=183 class="einsb">
<P ALIGN=CENTER>
Menü Anzeigenmarkt
</P>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD WIDTH=5 HEIGHT=8><IMG SRC="./gfx/cpl.gif" WIDTH=5 HEIGHT=1 BORDER=0 ALT=""></TD>
<TD></TD>
<TD WIDTH=6><IMG SRC="./gfx/cpl.gif" WIDTH=6 HEIGHT=1 BORDER=0 ALT=""></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=498></TD>
<TD WIDTH=172>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=172 HEIGHT=498>
<TR ALIGN=LEFT VALIGN=TOP>
<TD>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=172>
<TR VALIGN=TOP ALIGN=LEFT>
<TD WIDTH=172>
<P>
<?PHP include "./inc/menu.php";
?>
</P>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
<TD></TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
<TD></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=27 COLSPAN=3 WIDTH=200>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=200 HEIGHT=27>
<TR ALIGN=LEFT VALIGN=TOP>
<TD> </TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
<TD HEIGHT=10></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=566 WIDTH=781>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=781>
<TR VALIGN=TOP ALIGN=LEFT>
<TD WIDTH=7 HEIGHT=19><IMG SRC="./gfx/cpl.gif" WIDTH=7 HEIGHT=1 BORDER=0 ALT=""></TD>
<TD></TD>
<TD WIDTH=8><IMG SRC="./gfx/cpl.gif" WIDTH=8 HEIGHT=1 BORDER=0 ALT=""></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=520></TD>
<TD WIDTH=766>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=766 HEIGHT=520>
<TR ALIGN=LEFT VALIGN=TOP>
<TD>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=766>
<TR VALIGN=TOP ALIGN=LEFT>
<TD WIDTH=766 class="einsa">
<P>
<b>Newsletter aus dem Archiv senden</b> ( Abonnenten: <b><?PHP echo $treffer ?></b> )<br><br>
Der Newsletter wird so gesendet wie eingetragen, incl. Freizeichen, Absätze u.s.w. - HTML ist <u>nicht</u> möglich!<br>Zur Sicherheit wird eine Kopie des Newsletters im Archiv abgelegt.<br>Empfänger sind ALLE Mitglieder die den Newsletter bei der Anmeldung abonniert haben.<br><br>
</P>
</TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=484 WIDTH=766>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=766 HEIGHT=484>
<TR ALIGN=LEFT VALIGN=TOP>
<TD>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=766>
<TR VALIGN=TOP ALIGN=LEFT>
<TD WIDTH=766 class="einsa">
<P>
<form name="FormName" action="newsletter_2.php" method="post" target="_top">
<br>
<table cellpadding="12" cellspaceing="1" width="99%" border="0" cellspacing="0">
<tr>
<td width="95%" style="border-top: 1pt solid rgb(151,165,176); border-left: 1pt solid rgb(151,165,176); border-right: 1pt solid rgb(151,165,176); border-bottom: 1pt solid rgb(151,165,176);" class="einsa">
<br>
Newsletter-ID: <b><?PHP echo $id ?></b>
<?PHP if($artn == "vorl") { echo "- Vorlage gespeichert am:"; } else { echo"- zuletzt gesendet am:"; }?> <b><?PHP echo $datum ?></b> um: <b><?PHP echo $zeit ?></b> Uhr<br><br>
<b>Newslettertitel:</b>
<br>
<input type="text" name="titel" size="44" value="<?PHP echo $titel ?>"><br>
<br>
<br>
<b>Newslettertext:</b>
<br>
<textarea name="text" cols="87" rows="25"><?PHP echo $text ?></textarea><br>
<br>
<?PHP if($treffer >=1) { echo '<input type="hidden" value="'.$treffer.'" name="abos"><br>
<input type="hidden" value="senden" name="statusn">
<input type="submit" class="submit" value="Newsletter Absenden..">'; }
else
{
echo 'Absenden nicht möglich, Keine Abonnenten vorhanden';
}
?>
<br> <br>
</td>
</tr>
</table>
</form>
<br>
</P>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
<TD></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=27 COLSPAN=3 WIDTH=781>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=781 HEIGHT=27>
<TR ALIGN=LEFT VALIGN=TOP>
<TD> </TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=28 COLSPAN=2 WIDTH=983>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=981 HEIGHT=28 bgcolor="#B4D7F3">
<TR ALIGN=LEFT VALIGN=TOP>
<TD>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=983>
<TR VALIGN=TOP ALIGN=LEFT>
<TD WIDTH=983 HEIGHT=5><IMG SRC="./gfx/cpl.gif" WIDTH=983 HEIGHT=1 BORDER=0 ALT=""></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD WIDTH=983>
<P ALIGN=CENTER>
<?PHP include "./inc/footer.php"; ?>
</P>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</CENTER>
</BODY>
</HTML>