la otra parte del codigo:
echo " <TABLE Align=$maintablealign Width=$maintablewidth Border=1 cellspacing=0 cellpadding=2 Bordercolor=black Class=boxborder>
<TR Bgcolor=$background>
<TD><P>$text_newslettertitle</TD>
<TD><P>$text_newsletterdesc</TD>
<TD><P>$text_newsletterselect</TD>
</TR>";
$query = " SELECT tipnl_id, tipnl_title, tipnl_description
FROM newsletters
WHERE tipnl_status = '1'
ORDER BY tipnl_id ASC";
$result = @mysql_query($query);
WHILE($row = @mysql_fetch_array($result))
{
extract($row);
echo " <TR>
<TD Valign=Top><P>".stripslashes($tipnl_title)."</TD>
<TD><P>".stripslashes($tipnl_description)."</TD>
<TD Valign=Top Align=Right><INPUT Type=checkbox Name=newsletter[] Value=$tipnl_id></TD>
</TR>";
}
echo " </TABLE>
<TABLE Align=$maintablealign Width=$maintablewidth Border=0 cellspacing=0 cellpadding=0>
<TR>
<TD Height=10></TD>
</TR>
<TR>
<TD Align=Right>
<INPUT Type=Hidden Name=form Value=new>
<INPUT Type=Submit Value=$text_subbutton>
</TD>
</TR>
</FORM>
</TABLE>";
}
BREAK;
CASE "archive";
PageTitle($texta_title);
$query = " SELECT tipna_id, tipna_subject, tipna_body, tipna_timestamp
FROM newsletterarchive";
IF (isset($_GET['newsid']))
$query .= " WHERE tipna_id = '".$_GET['newsid']."'
LIMIT 0,1";
ELSE
$query .= " ORDER BY tipna_timestamp DESC";
$result = @mysql_query($query);
IF (@mysql_num_rows($result) > 0)
{
echo " <TABLE Width=$maintablewidth Align=$maintablealign Border=1 Bordercolor=BLACK Cellspacing=0 Cellpadding=2 Class=boxborder>";
IF (isset($_GET['newsid']))
{
$row = @mysql_fetch_array($result);
extract($row);
$tipna_timestamp = date("d/m/y",$row["tipna_timestamp"]);
echo " <TR>
<TD Width=100><P><B>$textai_volume:</TD>
<TD><P>$tipna_id</TD>
</TR>
<TR>
<TD><P><B>$textai_date:</TD>
<TD><P>$tipna_timestamp</TD>
</TR>
<TR>
<TD><P><B>$textai_subject:</TD>
<TD><P>".stripslashes($tipna_subject)."</TD>
</TR>
<TR>
<TD Valign=Top><P><B>$textai_body:</TD>
<TD><P>".stripslashes(nl2br($tipna_body))."</TD>
</TR>
<TR>
<TD Colspan=2 Align=Center><BR><P><INPUT Type=Button Value=$textai_back onClick=history.back()><BR><BR></TD>
</TR>";
}
ELSE
{
echo " <TR Valign=Top>
<TD><P><B>$texta_volume</TD>
<TD><P><B>$texta_date</TD>
<TD><P><B>$texta_subject</TD>
<TD><P><B>$texta_select</TD>
</TR>";
WHILE ($row = @mysql_fetch_array($result))
{
$trcolor = usecolor();
extract($row);
$tipna_timestamp = date("d/m/y",$row["tipna_timestamp"]);
echo " <TR BGcolor=$trcolor Valign=Top>
<TD><P> $tipna_id</TD>
<TD><P>$tipna_timestamp</TD>
<TD><P>".stripslashes($tipna_subject)."</TD>
<TD><P><BUTTON onClick=location='".$_SERVER['PHP_SELF']."?caseid=archive&newsid=$tipna_id'>Select</BUTTON>
</TR>";
}
}
}
ELSE
echo " <TABLE Width=$maintablewidth Align=$maintablealign Border=0 Cellspacing=0 Cellpadding=2 Class=boxborder>
<TR>
<TD><P>$texta_noarchive</TD>
</TR>";
echo " </TABLE>";
BREAK;
CASE "unregister";
PageTitle($textu_title);
IF (isset($_POST['form']) == "new" && isset($_POST['newsletter']))
{
echo " <TABLE Width=$maintablewidth Align=$maintablealign Border=0 Cellspacing=0 Cellpadding=2 Class=boxborder>
<TR>
<TD><P> $text
nsubmessage</TD>
</TR>
</TABLE>";
$numrows = count($_POST['newsletter']);
FOR ($i = 0; $i < $numrows; $i++)
{
$query = " DELETE FROM newslettermembers
WHERE tipnm_newsid = '".$_POST['newsletter'][$i]."'
AND tipnm_email = '".$_POST['email']."'";
$result = @mysql_query($query);
}
}
echo " <TABLE Align=$maintablealign Width=$maintablewidth Border=0 cellspacing=0 cellpadding=2 Class=boxborder>
<TR>
<TD><BLOCKQUOTE>
<LI>$textu_instruction1
<LI>$textu_instruction2
<BR><BR></TD>
</TR>
</TABLE>";
echo " <TABLE Align=$maintablealign Width=$maintablewidth Border=0 cellspacing=0 cellpadding=2 Class=boxborder>
<FORM Action=".$_SERVER['PHP_SELF']."?caseid=unregister Method=POST>
<TR>
<TD><BLOCKQUOTE><P>$textu_email:</TD>
<TD><P>
<INPUT Name=email Value='";
IF (isset($_POST['email']))
echo $_POST['email'];
echo "' Size=30>
<INPUT Type=submit Value='$textu_list'>
</TD>
</TR>
</FORM>
</TABLE>";
IF (!isset($_POST['email']) OR !ereg("^.+@.+\\..+$", $_POST['email']))
echo " <TABLE Align=$maintablealign Width=$maintablewidth Border=0 cellspacing=0 cellpadding=2 Class=boxborder>
<TR>
<TD><BLOCKQUOTE><LI>$textu_valid</TD>
</TR>
</TABLE>";
ELSE
{
$query = " SELECT tipnl_id, tipnl_title, tipnl_description
FROM newsletters a, newslettermembers b
WHERE b.tipnm_email = '".$_POST['email']."'
AND b.tipnm_newsid = a.tipnl_id
ORDER BY a.tipnl_id ASC";
$result = @mysql_query($query);
IF (@mysql_num_rows($result) <= 0)
echo " <TABLE Align=$maintablealign Width=$maintablewidth Border=0 cellspacing=0 cellpadding=2 Class=boxborder>
<TR>
<TD><BLOCKQUOTE><LI>$textu_nomember <A HREF=index.php>$textu_subscribe</TD>
</TR>
</TABLE>";
ELSE
{
PageTitle($textu_subscribed);
echo " <TABLE Align=$maintablealign Width=$maintablewidth Border=1 Bordercolor=#000000 cellspacing=0 cellpadding=2 Class=boxborder>
<FORM Action=".$_SERVER['PHP_SELF']."?caseid=unregister Method=POST>
<TR Bgcolor=#f4f7fd>
<TD><P>$text_newslettertitle</TD>
<TD><P>$text_newsletterdesc</TD>
<TD Align=Right><P>$textu_title</TD>
</TR>";
WHILE ($row = @mysql_fetch_array($result))
{
extract($row);
echo " <TR>
<TD Valign=Top><P>".stripslashes($tipnl_title)."</TD>
<TD><P>".stripslashes($tipnl_description)."</TD>
<TD Align=Right><INPUT Type=checkbox Name=newsletter[] Value=$tipnl_id></TD>
</TR>";
}
echo " </TABLE>
<TABLE Align=$maintablealign Width=$maintablewidth Border=0 cellspacing=0 cellpadding=0>
<TR>
<TD Height=10></TD>
</TR>
<TR>
<TD><DIV Align=Right>
<INPUT Type=Hidden Name=email Value=".$_POST['email'].">
<INPUT Type=Hidden Name=form Value=new>
<INPUT Type=submit Name=Submit Value=$text
nsubbutton>
</TD>
</TR>
</FORM>
</TABLE>";
}
}
BREAK;
}
IF ($footeron == 'TRUE')
require("footer.php");
?>
gracias saludos