Show published Newsletters on Frontend

StudioZ · Post by **StudioZ** » Fri 9. Sep 2005, 16:30

On my WishList I have:
Show published Newsletters on Frontend

Could it be done by a simple newly created RT ?

spirelli · Post by **spirelli** » Wed 14. Sep 2005, 01:56

yes, please! would be a great feature.

StudioZ · Post by **StudioZ** » Wed 14. Sep 2005, 02:21

Good Ol' Spirelli

Always there when I need you to back me up

Remember the Search functionnalities in the now dead Mantis?

Cheers,

JensZ · Post by **JensZ** » Sun 18. Sep 2005, 00:14

I already did this a while back. It's not 100% complete, but check it out anyway:

http://www.ikfrej.se/index.php?downloads

Jens

StudioZ · Post by **StudioZ** » Mon 3. Oct 2005, 02:02

Thanks JensZ for the script.

I installed it in latest 1.2.5 DEV and I get this error:
Parse error: parse error, unexpected $ in /home/xxxxx/public_html/xxxxx/include/inc_tmpl/message.newsletter.tmpl.php on line 379

Any idea what could it be...?

JensZ · Post by **JensZ** » Tue 4. Oct 2005, 15:53

I don't even have a linenumber 379 in my file. Can you tell me what it says on that line?

I'm also using 1.2.5 dev.

Jens

StudioZ · Post by **StudioZ** » Tue 4. Oct 2005, 17:10

JensZ wrote:I don't even have a line number 379 in my file. Can you tell me what it says on that line?
Jens

Yep. I know Jens

But after editing the file by adding your script parts, the file sums up to around 377-379 lines:

Here's what I have now :

Code: Select all

<?php
/*************************************************************************************
   Copyright notice
   
   (c) 2002-2005 Oliver Georgi (oliver@phpwcms.de) // All rights reserved.
 
   This script is part of PHPWCMS. The PHPWCMS web content management system is
   free software; you can redistribute it and/or modify it under the terms of
   the GNU General Public License as published by the Free Software Foundation;
   either version 2 of the License, or (at your option) any later version.
  
   The GNU General Public License can be found at http://www.gnu.org/copyleft/gpl.html
   A copy is found in the textfile GPL.txt and important notices to the license 
   from the author is found in LICENSE.txt distributed with these scripts.
  
   This script is distributed in the hope that it will be useful, but WITHOUT ANY 
   WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A
   PARTICULAR PURPOSE.  See the GNU General Public License for more details.
 
   This copyright notice MUST APPEAR in all copies of the script!
*************************************************************************************/

// changed by jens
$sql = "SELECT * FROM ".DB_PREPEND."phpwcms_newsletter WHERE newsletter_trashed in (0,1) ORDER BY newsletter_changed DESC;";
if($result = mysql_query($sql, $db) or die("error while listing newsletters")) {
   while($row = mysql_fetch_assoc($result)) {
   
      echo "<tr".( ($row_count % 2) ? " bgcolor="#F3F5F8"" : "" ).">\n<td width="25">";
      echo '<img src="img/symbole/newsletter_little_icon.gif" width="25" height="17"></td>'."\n";
      echo '<td width="463" class="dir"><a href="phpwcms.php?do=messages&p=3&s='.$row["newsletter_id"];  // changed by jens
      echo '"><strong>'.html_specialchars($row["newsletter_subject"])."</strong></a></td>\n".'<td width="50" align="right">'; // changed by jens
      
      // added by jens
      $archimg = ($row["newsletter_trashed"] == 0 ? "img/button/active_11x11_0.gif" : "img/button/active_11x11_1.gif");
      $archact = ($row["newsletter_trashed"] == 0 ? 1 : 0);
      $archtitle = ($row["newsletter_trashed"] == 0 ? "Archive newsletter" : "Unarchive newsletter");
      echo '<a href="phpwcms.php?do=messages&p=3&s='.$row["newsletter_id"].'&archive=' . $archact;
      echo '" title="'.$archtitle.'"><img src="'.$archimg.'" width="11" height="11" border="0"></a>';
      echo '<img src="img/leer.gif" width="2" height="1">';
      // ----


if(!isset($_GET["s"])) { 
// check if subscription should be edited
?>
<table width="538" border="0" cellpadding="0" cellspacing="0">
	<tr><td colspan="3" class="title"><?php echo $BL['be_subnav_msg_newslettersend'] ?></td></tr>
	<tr><td colspan="3"><img src="img/leer.gif" width="1" height="5"></td></tr>
	<tr><td colspan="3" bgcolor="#92A1AF"><img src="img/leer.gif" width="1" height="1"></td></tr>
<?php
// loop listing available newsletters
$row_count = 0;                                           
$sql = "SELECT * FROM ".DB_PREPEND."phpwcms_newsletter WHERE newsletter_trashed=0 ORDER BY newsletter_changed DESC;";
if($result = mysql_query($sql, $db) or die("error while listing newsletters")) {
	while($row = mysql_fetch_assoc($result)) {
	
		echo "<tr".( ($row_count % 2) ? " bgcolor="#F3F5F8"" : "" ).">\n<td width="25">";
		echo '<img src="img/symbole/newsletter_little_icon.gif" width="25" height="17"></td>'."\n";
		echo '<td width="473" class="dir"><a href="phpwcms.php?do=messages&p=3&s='.$row["newsletter_id"];
		echo '"><strong>'.html_specialchars($row["newsletter_subject"])."</strong></a></td>\n".'<td width="40" align="right">';
		echo '<a href="phpwcms.php?do=messages&p=3&s='.$row["newsletter_id"];
		echo '"><img src="img/button/edit_22x11.gif" width="22" height="11" border="0"></a>';
		echo '<img src="img/leer.gif" width="2" height="1">';
		echo '<a href="phpwcms.php?do=messages&p=3&s='.$row["newsletter_id"].'&del='.$row["newsletter_id"];
		echo '" title="delete: '.html_specialchars($row["newsletter_subject"]).'">';
		echo '<img src="img/button/del_11x11.gif" width="11" height="11" border="0"></a>';
		echo '<img src="img/leer.gif" width="2" height="1">'."</td>\n</tr>\n";
		$row_count++;
	}
	mysql_free_result($result);
} // end listing

if(!$row_count) {
	echo '<tr><td colspan="3">&nbsp;no newsletter available</td></tr>';
}
		
?>
	<tr><td colspan="3" bgcolor="#92A1AF"><img src="img/leer.gif" width="1" height="1"></td></tr>
	<tr><td colspan="3"><img src="img/leer.gif" width="1" height="8"></td>
	</tr>
	<tr><td colspan="3"><form action="phpwcms.php?do=messages&p=3&s=0" method="post"><input type="submit" value="<?php echo $BL['be_newsletter_new'] ?>" class="button10" title="<?php echo $BL['be_newsletter_addnl'] ?>"></form></td>
	</tr>
</table>
<?php

} else {

	// should show newsletter form
	$newsletter["newsletter_id"] = intval($_GET["s"]);
	$newsletter["newsletter_subject"] = '';
	$newsletter["newsletter_date"] = time();
	$newsletter["newsletter_vars"]['from_name'] = '';
	$newsletter["newsletter_vars"]['from_email'] = '';
	$newsletter["newsletter_vars"]['replyto'] = '';
	$newsletter["newsletter_vars"]['html'] = '';
	$newsletter["newsletter_vars"]['text'] = '';
	
	if(!empty($_GET["del"]) && intval($_GET["del"]) == $newsletter["newsletter_id"]) {
	
		//delete newsletter now
		$sql  = "UPDATE ".DB_PREPEND."phpwcms_newsletter SET newsletter_trashed=9 ";
		$sql .= "WHERE newsletter_id=".intval($_GET["del"])." LIMIT 1;";
		mysql_query($sql, $db) or die("error while deleting newsletter");
		header("Location: ".PHPWCMS_URL."phpwcms.php?do=messages&p=3");
		exit();
	}
	
	// added by jens
   if(isset($_GET["archive"]))
   {
      $sql  = "UPDATE ".DB_PREPEND."phpwcms_newsletter SET newsletter_trashed=" . intval($_GET["archive"]);
      $sql .= " WHERE newsletter_id=" . intval($_GET["s"]) . " LIMIT 1;";
      mysql_query($sql, $db) or die("error while archiving newsletter: " . mysql_error());
      header("Location: ".PHPWCMS_URL."phpwcms.php?do=messages&p=3");
      exit();
   }
   // ----
	
	if(isset($_POST["newsletter_id"])) {
	// read the create or edit subscription form data
		$newsletter["newsletter_id"]				= intval($_POST["newsletter_id"]);
		$newsletter["newsletter_subject"]			= clean_slweg($_POST["newsletter_subject"]);
		if(!$newsletter["newsletter_subject"]) $newsletter["newsletter_subject"] = "Newsletter ".date('Y-m-d/H:i:s');
		
		$newsletter['newsletter_vars']['from_name']		= clean_slweg($_POST["newsletter_fromname"]);
		$newsletter['newsletter_vars']['from_email']	= clean_slweg($_POST["newsletter_fromemail"]);
		if(!is_valid_email($newsletter['newsletter_vars']['from_email'])) {
			$newsletter['error']['from_email'] = 1;
		}
		$newsletter['newsletter_vars']['replyto']	= clean_slweg($_POST["newsletter_replyto"]);
		if(!is_valid_email($newsletter['newsletter_vars']['replyto'])) {
			$newsletter['error']['replyto'] = 1;
		}
		
		$newsletter['newsletter_vars']['html']		= slweg($_POST["newsletter_html"]);
		$newsletter['newsletter_vars']['text']		= clean_slweg($_POST["newsletter_text"]);
		
		if(!empty($_POST['newsletter_subscription']) && count($_POST['newsletter_subscription'])) {
			foreach($_POST['newsletter_subscription'] as $value) {
				$value = intval($value);
				if($value) {
					$newsletter['newsletter_vars']['subscription'][] = intval($value);
				} else {
					if(count($newsletter['newsletter_vars']['subscription'])) {
						unset($newsletter['newsletter_vars']['subscription']);
					}
					$newsletter['newsletter_vars']['subscription'][0] = 0;
					break;
				}
			}
		} else {
			$newsletter['newsletter_vars']['subscription'][0] = 0;
		}
		
		$sql  = "newsletter_subject='".aporeplace($newsletter["newsletter_subject"])."', ";
		$sql .= "newsletter_vars='".aporeplace(serialize($newsletter['newsletter_vars']))."' ";
		
		if($newsletter["newsletter_id"]) {
			$sql  = "UPDATE ".DB_PREPEND."phpwcms_newsletter SET ".$sql;
			$sql .= "WHERE newsletter_id=".$newsletter["newsletter_id"]." LIMIT 1;";	
		} else {
			$sql  = "INSERT INTO ".DB_PREPEND."phpwcms_newsletter SET ".$sql.";";
		}
		
		if(!isset($newsletter['error'])) {
			// update or insert data entry
			mysql_query($sql, $db) or die("error while updating or inserting newsletter datas");
			if(!$newsletter["newsletter_id"]) $newsletter["newsletter_id"] = mysql_insert_id($db);
			header("Location: ".PHPWCMS_URL."phpwcms.php?do=messages&p=3&s=".$newsletter["newsletter_id"]);
			exit();
		}
	}

	if($newsletter["newsletter_id"] && !isset($_POST["newsletter_id"])) {
	// read the given subscription datas from db
		$sql  = "SELECT *, UNIX_TIMESTAMP(newsletter_changed) AS newsletter_date FROM ";
		$sql .= DB_PREPEND."phpwcms_newsletter WHERE newsletter_id=".$newsletter["newsletter_id"]." LIMIT 1;";
		if($result = mysql_query($sql, $db)) {
			if($row = mysql_fetch_assoc($result)) {
				$newsletter = $row;
				$newsletter['newsletter_vars'] = unserialize($newsletter['newsletter_vars']);
			}
			mysql_free_result($result);
		}
	}

	
	// show form
?><form action="phpwcms.php?do=messages&p=3&s=<?php echo $newsletter["newsletter_id"] ?>" method="post" name="newsletter" target="_self">
<table width="538" border="0" cellpadding="0" cellspacing="0">
	
	<tr><td colspan="2" class="title"><?php echo $BL['be_newsletter_titleeditnl'].": ".(($newsletter["newsletter_id"])? html_specialchars($newsletter["newsletter_subject"]) : $BL['be_newsletter_newnl']); ?></td></tr>
	<tr><td><img src="img/leer.gif" width="95" height="1"></td><td><img src="img/leer.gif" width="1" height="4"></td></tr>
	<tr><td colspan="2"><img src="img/lines/l538_70.gif" width="538" height="1"></td></tr>
	<tr bgcolor="#E6EAED"><td colspan="2"><img src="img/leer.gif" width="1" height="9"></td></tr>
	<tr bgcolor="#E6EAED">
		<td align="right" class="chatlist"><?php echo $BL['be_msg_subject'] ?>:&nbsp;</td>
		<td><input name="newsletter_subject" type="text" class="f11b" id="newsletter_subject" style="width:430px" value="<?php echo html_specialchars($newsletter["newsletter_subject"]) ?>" size="50" maxlength="250" onChange="hideLayer('messagesend');"></td>
	</tr>
	<tr bgcolor="#E6EAED"><td colspan="2"><img src="img/leer.gif" width="1" height="3"></td></tr>
	<tr bgcolor="#E6EAED">
		<td align="right" class="chatlist"><?php echo $BL['be_newsletter_changed'] ?>:&nbsp;</td>
		<td><strong><?php 
		
		if(isset($newsletter['error'])) $newsletter["newsletter_date"] = time();
		echo date('d-m-Y, H:i:s', $newsletter["newsletter_date"]) 
		
		?></strong></td>
	</tr>
	<tr bgcolor="#E6EAED"><td colspan="2"><img src="img/leer.gif" width="1" height="8"></td></tr>
	<tr><td colspan="2"><img src="img/lines/l538_70.gif" width="538" height="1"></td></tr>
	<tr><td colspan="2"><img src="img/leer.gif" width="1" height="8"></td></tr>
	<tr>
		<td align="right" class="chatlist"><?php echo $BL['be_newsletter_fromname'] ?>:&nbsp;</td>
		<td><input name="newsletter_fromname" type="text" class="f11" id="newsletter_fromname" style="width:350px" value="<?php echo html_specialchars($newsletter["newsletter_vars"]['from_name']) ?>" size="50" maxlength="250"></td>
	</tr>
	<tr><td colspan="2"><img src="img/leer.gif" width="1" height="2"></td></tr>
	<tr>
		<td align="right" class="chatlist"><?php 
		
		echo $BL['be_newsletter_fromemail'];
		if(isset($newsletter['error']) && isset($newsletter['error']['from_email'])) {
			echo '<img src="img/symbole/error_9x9.gif" width="9" height="9" alt="" />';
		}
		
		?>:&nbsp;</td>
		<td><input name="newsletter_fromemail" type="text" class="f11" id="newsletter_fromemail" style="width:350px" value="<?php echo html_specialchars($newsletter["newsletter_vars"]['from_email']) ?>" size="50" maxlength="250"></td>
	</tr>
	<tr><td colspan="2"><img src="img/leer.gif" width="1" height="2"></td></tr>
	<tr>
		<td align="right" class="chatlist"><?php 
		
		echo $BL['be_newsletter_replyto'];
		if(isset($newsletter['error']) && isset($newsletter['error']['replyto'])) {
			echo '<img src="img/symbole/error_9x9.gif" width="9" height="9" alt="" />';
		}
		
		?>:&nbsp;</td>
		<td><input name="newsletter_replyto" type="text" class="f11" id="newsletter_replyto" style="width:350px" value="<?php echo html_specialchars($newsletter["newsletter_vars"]['replyto']) ?>" size="50" maxlength="250"></td>
	</tr>
	<tr><td colspan="2"><img src="img/leer.gif" width="1" height="5"></td></tr>
	<tr>
		<td align="right" class="chatlist" valign="top"><img src="img/leer.gif" width="1" height="14"><?php echo $BL['be_cnt_subscription'] ?>:&nbsp;</td>
		<td valign="top"><table cellpadding="0" cellspacing="0" border="0">
		
		<tr>
			<td><input name="newsletter_subscription[]" type="checkbox" value="0" <?php if(isset($newsletter["newsletter_vars"]["subscription"]) && $newsletter["newsletter_vars"]["subscription"][0] == 0) echo ' checked="checked"'; ?> /></td>
			<td><?php echo $BL['be_newsletter_allsubscriptions']; ?></td>
		</tr>
		
<?php
	//retrieve available subscription lists/channels
	
	$sql = "SELECT * FROM ".DB_PREPEND."phpwcms_subscription ORDER BY subscription_name;";
	if($result = mysql_query($sql, $db)) {
		$i = '';
		while($row = mysql_fetch_row($result)) {
			$i .= "<tr>\n<td><input name="newsletter_subscription[]" type="checkbox" value="".$row[0].""";
			if(!empty($newsletter["newsletter_vars"]["subscription"]) && count($newsletter["newsletter_vars"]["subscription"]) && $newsletter["newsletter_vars"]["subscription"][0] != 0) {
				foreach($newsletter["newsletter_vars"]["subscription"] as $value) {
					if($value == $row[0]) {
						$i .= ' checked="checked"';
						break;
					}
				}
			}
			$i .= " /></td>\n<td>".html_specialchars($row[1])."</td>\n</tr>\n";
		}
		mysql_free_result($result);
		echo $i;
	}
?>	
		
		</table></td>
	</tr>
	
	<tr><td colspan="2"><img src="img/leer.gif" width="1" height="8"></td></tr>
	<tr><td colspan="2"><img src="img/lines/l538_70.gif" width="538" height="1"></td></tr>
	<tr><td colspan="2"><img src="img/leer.gif" width="1" height="8"></td></tr>
</table><div id="messageclose" style="display:<?php echo ($_SESSION["dhtml_hiding"]) ? 'block' : 'none'; ?>; "><table width="538" border="0" cellpadding="0" cellspacing="0">
	<tr><td class="chatlist"><a href="javascript:;" onClick="hideLayer('messageclose');showLayer('messageopen');"><img src="img/symbols/icon_minicategory_12x9_1.gif" alt="<?php echo $BL['be_func_struct_open'] ?>" name="switchit" width="12" height="9" border="0"></a>&nbsp;<strong><?php echo $BL['be_newsletter_open'] ?></strong> <?php echo $BL['be_newsletter_open1'] ?></td></tr>
	</table></div><div id="messageopen" style="display:<?php echo ($_SESSION["dhtml_hiding"]) ? 'none' : 'block'; ?>;"><table width="538" border="0" cellpadding="0" cellspacing="0">
	<tr><td class="chatlist"><a href="javascript:;" onClick="hideLayer('messageopen');showLayer('messageclose');"><img src="img/symbols/icon_minicategory_12x9_2.gif" alt="<?php echo $BL['be_func_struct_close'] ?>" name="switchit" width="12" height="9" border="0"></a>&nbsp;<strong><?php echo $BL['be_newsletter_open'] ?></strong> <?php echo $BL['be_newsletter_open1'] ?></td></tr>
	<tr><td><img src="img/leer.gif" width="1" height="5"></td></tr>
	<tr><td><span class="chatlist"><?php echo $BL['be_newsletter_placeholder'] ?>:</span><br>###RECIPIENT_NAME###, ###RECIPIENT_EMAIL###, ###VERIFY_LINK###, ###DELETE_LINK###, ###SITE_URL###</td></tr>
	<tr><td><img src="img/leer.gif" width="1" height="5"></td></tr>
	<tr><td class="chatlist"><?php echo $BL['be_newsletter_htmlpart'] ?>:</td></tr>
	<tr><td><img src="img/leer.gif" width="1" height="1"></td></tr>
	<tr><td align="center"><?php

$wysiwyg_editor = array(
	'value'		=> $newsletter["newsletter_vars"]['html'],
	'field'		=> 'newsletter_html',
	'height'	=> '500px',
	'width'		=> '536px',
	'rows'		=> '15',
	'editor'	=> $_SESSION["WYSIWYG_EDITOR"],
	'lang'		=> 'en'
);
include('include/inc_lib/wysiwyg.editor.inc.php');

?></td></tr>

	<tr><td><img src="img/leer.gif" width="1" height="5"></td></tr>
	<tr><td class="chatlist"><?php echo $BL['be_newsletter_textpart'] ?>:</td></tr>
	<tr><td><img src="img/leer.gif" width="1" height="1"></td></tr>
	<tr><td align="center"><textarea name="newsletter_text" rows="20" wrap="OFF" class="code" style="width:536px;height:200px;background-color:#ffffff;"><?php echo html_specialchars($newsletter["newsletter_vars"]['text']) ?></textarea></td></tr>
	</table></div><div id="nlbutton" style="display:block;"><table width="538" border="0" cellpadding="0" cellspacing="0">
	<tr><td><img src="img/leer.gif" width="1" height="8"></td></tr>
	<tr><td><img src="img/lines/l538_70.gif" width="538" height="1"></td></tr>
	<tr><td bgcolor="#E6EAED"><img src="img/leer.gif" width="1" height="8"></td></tr>
	<tr><td bgcolor="#E6EAED"><img src="img/leer.gif" width="95" height="1"><input name="newsletter_id" type="hidden" value="<?php echo $newsletter["newsletter_id"] ?>"><input name="Submit" type="submit" class="button10" value="<?php echo $BL['be_newsletter_button_savenl'] ?>">&nbsp;&nbsp;<input type="button" class="button10" value="<?php echo $BL['be_newsletter_button_cancel'] ?>" onClick="location.href='phpwcms.php?do=messages&p=3';"></td></tr>
	<tr><td bgcolor="#E6EAED"><img src="img/leer.gif" width="1" height="8"></td></tr>
	<?php
	
	
	if($newsletter["newsletter_id"] && ($newsletter["newsletter_vars"]['html'] || $newsletter["newsletter_vars"]['text']) && !isset($newsletter['error'])) {
		$show_nl_send = 1;
	} else {
		echo '<tr><td><img src="img/lines/l538_70.gif" width="538" height="1"></td></tr>';
		$show_nl_send = 0;
	}
	
	?>
	
</table></div></form><?php 
	
	//show send form
	if($show_nl_send) {
	
	$_SESSION['nljob'] = $newsletter;
	
	?><div id="messagesend" style="display:block;"><form action="include/inc_act/act_sendnewsletter.php" method="post" name="sendnewsletter" target="sendframe" onSubmit="hideLayer('messageclose');hideLayer('messageopen');hideLayer('nlbutton');hideLayer('messagesend');showLayer('sendjobnow');"><table width="538" border="0" cellpadding="0" cellspacing="0">
	<tr><td colspan="2"><img src="img/lines/l538_70.gif" width="538" height="1"></td></tr>
	<tr><td colspan="2"><img src="img/leer.gif" width="1" height="25"></td></tr>
	<tr><td colspan="2" class="title"><?php echo $BL['be_newsletter_sendnow'] ?></td></tr>
	<tr><td><img src="img/leer.gif" width="95" height="5"></td><td><img src="img/leer.gif" width="443" height="1"></td></tr>
	<tr><td colspan="2"><img src="img/lines/l538_70.gif" width="538" height="1"></td></tr>
	<tr><td bgcolor="#E6EAED" colspan="2"><table cellpadding="8" cellspacing="0" border="0">
				<tr><td><?php echo $BL['be_newsletter_attention'] ?><br><img src="img/leer.gif" width="1" height="4"><br><?php echo $BL['be_newsletter_attention1'] ?></td></tr>
	</table></td></tr>
	<tr><td colspan="2"><img src="img/lines/l538_70.gif" width="538" height="1"></td></tr>
	<tr><td colspan="2"><img src="img/leer.gif" width="1" height="8"></td></tr>
	<tr>
		<td align="right" class="chatlist"><?php echo $BL['be_newsletter_testemail'] ?>:&nbsp;</td>
		<td><input name="send_testemail" type="text" class="f11b" id="send_testemail" style="width:350px" size="50" maxlength="250"></td>
	</tr>
	<tr><td colspan="2"><img src="img/leer.gif" width="1" height="8"></td></tr>
	<tr><td colspan="2"><img src="img/lines/l538_70.gif" width="538" height="1"></td></tr>
	<tr><td colspan="2" bgcolor="#E6EAED"><img src="img/leer.gif" width="1" height="8"></td></tr>
	<tr bgcolor="#E6EAED"><td>&nbsp;</td><td><input name="sendit" type="submit" class="button10" style="color:#CC3300;font-weight:bold;" value="<?php echo $BL['be_newsletter_sendnlbutton'] ?>">&nbsp;&nbsp;<input type="button" class="button10" value="<?php echo $BL['be_newsletter_button_cancel'] ?>" onClick="location.href='phpwcms.php?do=messages&p=3';"></td></tr>
	<tr><td colspan="2" bgcolor="#E6EAED"><img src="img/leer.gif" width="1" height="8"></td></tr>
	<tr><td colspan="2"><img src="img/lines/l538_70.gif" width="538" height="1"></td></tr>
	<tr><td colspan="2"><img src="img/leer.gif" width="1" height="5"></td></tr>
	
</table></form></div>
<div id="sendjobnow" style="display:none;"><table width="538" border="0" cellpadding="0" cellspacing="0">
	<tr><td class="title"><?php echo $BL['be_newsletter_sendprocess'] ?></td></tr>
	<tr><td><img src="img/leer.gif" width="1" height="5"></td></tr>
	<tr><td><img src="img/lines/l538_70.gif" width="538" height="1"></td></tr>
	<tr><td bgcolor="#E6EAED" colspan="2"><table cellpadding="8" cellspacing="0" border="0">
		<tr><td><?php echo $BL['be_newsletter_attention2'] ?></td></tr>
	</table></td></tr>
	<tr><td><img src="img/lines/l538_70.gif" width="538" height="1"></td></tr>
	<tr><td><iframe frameborder="0" height="200" width="100%" name="sendframe" scrolling="auto"></iframe></td></tr>
	<tr><td><img src="img/lines/l538_70.gif" width="538" height="1"></td></tr>
	<tr><td bgcolor="#E6EAED"><img src="img/leer.gif" width="1" height="8"></td></tr>
	<tr bgcolor="#E6EAED"><td align="center"><input type="button" class="button10" value="<?php echo $BL['be_newsletter_button_cancel'] ?>" onClick="hideLayer('sendjobnow');showLayer('messageclose');hideLayer('messageopen');showLayer('nlbutton');showLayer('messagesend');"></td></tr>
	<tr><td bgcolor="#E6EAED"><img src="img/leer.gif" width="1" height="8"></td></tr>
	<tr><td><img src="img/lines/l538_70.gif" width="538" height="1"></td></tr>
</table></div>
<?php

	}

}

?>

Regards,

JensZ · Post by **JensZ** » Tue 4. Oct 2005, 17:50

Yeah, my instructions really suck...

Hopefully this is better:

In message.newsletter.tmpl.php, look for:

Code: Select all

$sql = "SELECT * FROM ".DB_PREPEND."phpwcms_newsletter WHERE newsletter_trashed=0 ORDER BY newsletter_changed DESC;";
if($result = mysql_query($sql, $db) or die("error while listing newsletters")) {
	while($row = mysql_fetch_assoc($result)) {
	
		echo "<tr".( ($row_count % 2) ? " bgcolor=\"#F3F5F8\"" : "" ).">\n<td width=\"25\">";
		echo '<img src="img/symbole/newsletter_little_icon.gif" width="25" height="17"></td>'."\n";
		echo '<td width="473" class="dir"><a href="phpwcms.php?do=messages&p=3&s='.$row["newsletter_id"];
		echo '"><strong>'.html_specialchars($row["newsletter_subject"])."</strong></a></td>\n".'<td width="40" align="right">';
		echo '<a href="phpwcms.php?do=messages&p=3&s='.$row["newsletter_id"];
		echo '"><img src="img/button/edit_22x11.gif" width="22" height="11" border="0"></a>';
		echo '<img src="img/leer.gif" width="2" height="1">';
		echo '<a href="phpwcms.php?do=messages&p=3&s='.$row["newsletter_id"].'&del='.$row["newsletter_id"];
		echo '" title="delete: '.html_specialchars($row["newsletter_subject"]).'">';
		echo '<img src="img/button/del_11x11.gif" width="11" height="11" border="0"></a>';
		echo '<img src="img/leer.gif" width="2" height="1">'."</td>\n</tr>\n";
		$row_count++;
	}
	mysql_free_result($result);
} // end listing

REPLACE above code block with:

Code: Select all

// changed by jens
$sql = "SELECT * FROM ".DB_PREPEND."phpwcms_newsletter WHERE newsletter_trashed in (0,1) ORDER BY newsletter_changed DESC;";
if($result = mysql_query($sql, $db) or die("error while listing newsletters")) {
	while($row = mysql_fetch_assoc($result)) {
	
		echo "<tr".( ($row_count % 2) ? " bgcolor=\"#F3F5F8\"" : "" ).">\n<td width=\"25\">";
		echo '<img src="img/symbole/newsletter_little_icon.gif" width="25" height="17"></td>'."\n";
		echo '<td width="463" class="dir"><a href="phpwcms.php?do=messages&p=3&s='.$row["newsletter_id"];  // changed by jens
		echo '"><strong>'.html_specialchars($row["newsletter_subject"])."</strong></a></td>\n".'<td width="50" align="right">'; // changed by jens
		
		// added by jens
		$archimg = ($row["newsletter_trashed"] == 0 ? "img/button/active_11x11_0.gif" : "img/button/active_11x11_1.gif");
		$archact = ($row["newsletter_trashed"] == 0 ? 1 : 0);
		$archtitle = ($row["newsletter_trashed"] == 0 ? "Archive newsletter" : "Unarchive newsletter");
		echo '<a href="phpwcms.php?do=messages&p=3&s='.$row["newsletter_id"].'&archive=' . $archact;
		echo '" title="'.$archtitle.'"><img src="'.$archimg.'" width="11" height="11" border="0"></a>';
		echo '<img src="img/leer.gif" width="2" height="1">';
		// ----
		
		echo '<a href="phpwcms.php?do=messages&p=3&s='.$row["newsletter_id"];
		echo '"><img src="img/button/edit_22x11.gif" width="22" height="11" border="0"></a>';
		echo '<img src="img/leer.gif" width="2" height="1">';
		echo '<a href="phpwcms.php?do=messages&p=3&s='.$row["newsletter_id"].'&del='.$row["newsletter_id"];
		echo '" title="delete: '.html_specialchars($row["newsletter_subject"]).'">';
		echo '<img src="img/button/del_11x11.gif" width="11" height="11" border="0"></a>';
		echo '<img src="img/leer.gif" width="2" height="1">'."</td>\n</tr>\n";
		$row_count++;
	}
	mysql_free_result($result);
} // end listing

Now look for:

Code: Select all

	
if(isset($_POST["newsletter_id"])) {

BEFORE, add this:

Code: Select all

	
	// added by jens
	if(isset($_GET["archive"])) 
	{
		$sql  = "UPDATE ".DB_PREPEND."phpwcms_newsletter SET newsletter_trashed=" . intval($_GET["archive"]);
		$sql .= " WHERE newsletter_id=" . intval($_GET["s"]) . " LIMIT 1;";
		mysql_query($sql, $db) or die("error while archiving newsletter: " . mysql_error());
		header("Location: ".PHPWCMS_URL."phpwcms.php?do=messages&p=3");
		exit();
	}
	// ----

StudioZ · Post by **StudioZ** » Tue 4. Oct 2005, 18:28

Cool!

Awesome

Simply Great!

You made my day !!!

Thanks again Jensz for this great add-on

Most of all... thanks for your precious time

Cheers,

StudioZ · Post by **StudioZ** » Tue 4. Oct 2005, 18:37

JensZ,

I just noticed that if I use the URL rewrite function, then it does not work.
Just in case you ever find a work around...?

Cheers,

frold · Post by **frold** » Tue 4. Oct 2005, 20:01

If this a hack I think it should be moved to the hack section - what do you think?

StudioZ · Post by **StudioZ** » Tue 4. Oct 2005, 20:17

frold wrote:If this a hack I think it should be moved to the hack section - what do you think?

Yep! I think you are right Frold

Show published Newsletters on Frontend

Show published Newsletters on Frontend

Yes Sir!