<?PHP
include "./inc/config.inc.php";
include "./inc/systemeinstellungen.php";
include "./inc/de.php";
include "./system/funktionen.php";
$startzeit = getmicrotime();
db();
$seitentitel= PROJEKT_TITEL1." - ".PROJEKT_TITEL2." - Eintrag in den Newsletter bestätigen";
$hinweis ="";
if (isset($_GET['uid']) && $_GET['uid'] !="")
{
$newsletterid = $_GET['uid'];
// AnzeigenID prüfen ---------------
if (strlen($newsletterid) != 10)
{
$hinweis="<b>Hinweis:</b><br>Der Freischaltlink wurde manipuliert oder ist nicht komplett eingegeben worden.<br>Bitte versuchen Sie es erneut!";
$cs= false;
}
else
{
// ist der User bereits freigeschaltet oder eMail bereits vorhanden? ----------------------------------------
$eintrag_vorhanden_sql = mysql_query("SELECT code
FROM ".$dbtable04."
WHERE user = '".NoI("$newsletterid")."' ");
if(mysql_num_rows($eintrag_vorhanden_sql) == false)
{
$hinweis="<b>Hinweis:</b><br>Ihr Eintrag wurde in unseren Newsletter wurde nicht gefunden, Freischaltung nicht möglich.!";
}
else
{
$eintrag_frei_sql = mysql_query("SELECT code
FROM ".$dbtable04."
WHERE user = '".NoI("$newsletterid")."'
AND code ='1' ");
if(mysql_num_rows($eintrag_frei_sql) == true)
{
$hinweis ="<b>Hinweis:</b><br>Ihr Freischaltlink wurde bereits benutzt!";
}
else
{
mysql_query("UPDATE ".$dbtable04."
SET code ='1'
WHERE user ='".NoI("$newsletterid")."' ");
$hinweis ="<b>Hinweis:</b><br>Vielen Dank für die Bestätigung Ihrer Anmeldung zu unserem Newsletter.<br>";
}
}
}
}
else
{
$hinweis="<b>Hinweis:</b><br>Der Freischaltlink wurde manipuliert oder ist nicht komplett eingegeben worden.<br>Bitte versuchen Sie es erneut!";
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1">
<TITLE><?PHP echo $seitentitel ?></TITLE>
<link rel="stylesheet" type="text/css" href="./system/<?PHP echo $design_typ ?>">
<?PHP include "./inc/meta.php"; ?>
<meta name="description" content="Newsletter...">
<script
language="JavaScript">
<!--
button1= new Image();
button1.src = "button_home.gif"
button2= new Image();
button2.src = "button_home2.gif"
//-->
</script>
</HEAD>
<BODY BACKGROUND="./gfx/back.gif" TOPMARGIN=0 LEFTMARGIN=0 MARGINWIDTH=0 MARGINHEIGHT=0>
<CENTER>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=980 CLASS="back_x">
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=749 WIDTH=980>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=980>
<?PHP
$headerinfo= "Sie befinden sich hier --> Newsletter";
include "./inc/header.php";
?>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=253 COLSPAN=2 WIDTH=190>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=190 HEIGHT=253>
<TR ALIGN=LEFT VALIGN=TOP>
<TD>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=190>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=2></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD WIDTH=190>
<P ALIGN=LEFT class="datum">
<?PHP echo $seitendatum ?></P>
</TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=4></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=216 WIDTH=190>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=190 HEIGHT=216 class="menu_links">
<TR ALIGN=LEFT VALIGN=TOP>
<TD>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=190>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=22 COLSPAN=3 WIDTH=190>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=190 HEIGHT=22 class="menu_links_top">
<TR ALIGN=LEFT VALIGN=TOP>
<TD>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=188>
<TR VALIGN=TOP ALIGN=LEFT>
<TD WIDTH=4 HEIGHT=2><IMG SRC="./gfx/cpl.gif" WIDTH=4 HEIGHT=1 BORDER=0></TD>
<TD WIDTH=184><IMG SRC="./gfx/cpl.gif" WIDTH=184 HEIGHT=1 BORDER=0></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD></TD>
<TD WIDTH=184>
<P ALIGN=CENTER class="menuber"><?PHP echo $menuli_name ?></P>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD WIDTH=9 HEIGHT=9><IMG SRC="./gfx/cpl.gif" WIDTH=9 HEIGHT=1 BORDER=0></TD>
<TD WIDTH=173><IMG SRC="./gfx/cpl.gif" WIDTH=173 HEIGHT=1 BORDER=0></TD>
<TD WIDTH=8><IMG SRC="./gfx/cpl.gif" WIDTH=8 HEIGHT=1 BORDER=0></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD></TD>
<TD WIDTH=173>
<P>
<?PHP include "./inc/menulinks.php"; ?>
</TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=16 WIDTH=190>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=190 HEIGHT=16>
<TR ALIGN=LEFT VALIGN=TOP>
<TD> </TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
<TD COLSPAN=3 WIDTH=596>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=596 HEIGHT=453>
<TR ALIGN=LEFT VALIGN=TOP>
<TD>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=584>
<TR VALIGN=TOP ALIGN=LEFT>
<TD WIDTH=11 HEIGHT=9><IMG SRC="./gfx/cpl.gif" WIDTH=11 HEIGHT=1 BORDER=0></TD>
<TD></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=30></TD>
<TD WIDTH=573>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=573 HEIGHT=35>
<TR ALIGN=LEFT VALIGN=TOP>
<TD>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=572>
<TR VALIGN=TOP ALIGN=LEFT>
<TD class="einsa">
<P>
<br>Newsletter abonnieren
</P>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=10></TD>
<TD WIDTH=573>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=573 HEIGHT=10 class="kategorien1">
<TR ALIGN=LEFT VALIGN=TOP>
<TD>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=573>
<TR VALIGN=TOP ALIGN=LEFT>
<TD WIDTH=1><IMG SRC="./gfx/cpl.gif" WIDTH=1 HEIGHT=1 BORDER=0></TD>
<TD WIDTH=8><IMG SRC="./gfx/cpl.gif" WIDTH=8 HEIGHT=1 BORDER=0></TD>
<TD WIDTH=554 class="einsa">
<P><br><br>
<!-- INDEX CENTERSCREEN -->
<?PHP
if ($hinweis !="")
{
echo '<table cellpadding="5" cellspacing="0" WIDTH=554>
<tr>
<TD WIDTH=554 valign="top" class="einsa">'.$hinweis.'
</td>
</tr>
</table><br><br>';
}
?><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>
<!-- INDEX CENTERSCREEN ENDE-->
</P>
</TD>
<TD WIDTH=9><IMG SRC="./gfx/cpl.gif" WIDTH=9 HEIGHT=1 BORDER=0></TD>
<TD WIDTH=1><IMG SRC="./gfx/cpl.gif" WIDTH=1 HEIGHT=1 BORDER=0></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD COLSPAN=5 HEIGHT=15></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=41 COLSPAN=4 WIDTH=572>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=572 HEIGHT=41 class="kategorien2">
<TR ALIGN=LEFT VALIGN=TOP>
<TD>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=563>
<TR VALIGN=TOP ALIGN=LEFT>
<TD WIDTH=20 HEIGHT=15><IMG SRC="./gfx/cpl.gif" WIDTH=20 HEIGHT=1 BORDER=0></TD>
<TD WIDTH=543 HEIGHT=15><IMG SRC="./gfx/cpl.gif" WIDTH=543 HEIGHT=1 BORDER=0></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD></TD>
<TD WIDTH=543>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=543 HEIGHT=10>
<TR VALIGN=TOP ALIGN=CENTER>
<P>
</P>
</TR>
</table>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
<TD></TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
<TD COLSPAN=3 WIDTH=190>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=190 HEIGHT=453>
<TR ALIGN=LEFT VALIGN=TOP>
<TD>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=190>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=21></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=400 WIDTH=190>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=190 HEIGHT=400 class="menu_rechts">
<TR ALIGN=LEFT VALIGN=TOP>
<TD>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=190>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=22 COLSPAN=3 WIDTH=190>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=190 HEIGHT=22>
<TR ALIGN=LEFT VALIGN=TOP>
<TD>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=190>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=22 WIDTH=190>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=190 HEIGHT=22 class="menu_rechts_top">
<TR ALIGN=LEFT VALIGN=TOP>
<TD>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=188>
<TR VALIGN=TOP ALIGN=LEFT>
<TD WIDTH=4 HEIGHT=2><IMG SRC="./gfx/cpl.gif" WIDTH=4 HEIGHT=1 BORDER=0 ALT=""></TD>
<TD WIDTH=184><IMG SRC="./gfx/cpl.gif" WIDTH=184 HEIGHT=1 BORDER=0 ALT=""></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD></TD>
<TD WIDTH=184>
<P ALIGN=CENTER class="menuber"><?PHP echo $menure_name ?></P>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD WIDTH=9 HEIGHT=9><IMG SRC="./gfx/cpl.gif" WIDTH=9 HEIGHT=1 BORDER=0 ALT=""></TD>
<TD WIDTH=175><IMG SRC="./gfx/cpl.gif" WIDTH=175 HEIGHT=1 BORDER=0 ALT=""></TD>
<TD WIDTH=6><IMG SRC="./gfx/cpl.gif" WIDTH=6 HEIGHT=1 BORDER=0 ALT=""></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD></TD>
<TD WIDTH=175>
<P>
<?PHP include "./inc/menurechts.php"; ?>
</P>
</TD>
<TD></TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=16></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD HEIGHT=16 WIDTH=190>
<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=190 HEIGHT=16>
<TR ALIGN=LEFT VALIGN=TOP>
<TD> </TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
</TR>
<?PHP
include "./inc/footer.php";
db_();
?>
</TABLE>
</TD>
</TR>
</TABLE>
</CENTER>
</BODY>
</HTML>