Jump to content
Sign in to follow this  
tuppergreen

Broken image link using FCKeditor in mail.php

Recommended Posts

Hi all,

 

I've recently installed FCKeditor and can't find my ways to fix the broken image link in mail.php. When I tried sending the email with an inserted image, the email received is with a broken image link. The editor works well in Newsletter manager but not in mail.php. I'll presumed I did something wrong with the code in mail.php which i have tried several ways to edit it hoping I can get it right but after umpteen attempts and still unable to fix it. I hope someone can help here. The code is as follow

 

<?php
/*
 $Id: mail.php 1739 2007-12-20 00:52:16Z hpdl $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
*/

 require('mydomain/demostore/admin/includes/application_top.php');

 $action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : '');

 if ( ($action == 'send_email_to_user') && isset($HTTP_POST_VARS['customers_email_address']) && !isset($HTTP_POST_VARS['back_x']) ) {
switch ($HTTP_POST_VARS['customers_email_address']) {
  case '***':
	$mail_query = tep_db_query("select customers_firstname, customers_lastname, customers_email_address from " . TABLE_CUSTOMERS);
	$mail_sent_to = TEXT_ALL_CUSTOMERS;
	break;
  case '**D':
	$mail_query = tep_db_query("select customers_firstname, customers_lastname, customers_email_address from " . TABLE_CUSTOMERS . " where customers_newsletter = '1'");
	$mail_sent_to = TEXT_NEWSLETTER_CUSTOMERS;
	break;
  default:
	$customers_email_address = tep_db_prepare_input($HTTP_POST_VARS['customers_email_address']);

	$mail_query = tep_db_query("select customers_firstname, customers_lastname, customers_email_address from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($customers_email_address) . "'");
	$mail_sent_to = $HTTP_POST_VARS['customers_email_address'];
	break;
}


  $from_name = tep_db_prepare_input($HTTP_POST_VARS['from_name']); 

$subject = tep_db_prepare_input($HTTP_POST_VARS['subject']);
$messageraw = tep_db_prepare_input(stripslashes($HTTP_POST_VARS['message']));
$message = tep_add_base_ref($messageraw);



while ($mail = tep_db_fetch_array($mail_query)) {
['customers_email_address'], '', $from, $subject);
  tep_mail($mail['customers_firstname'] . ' ' . $mail['customers_lastname'], $mail['customers_email_address'], $subject, $message, $from_name, $from, true);

}

tep_redirect(tep_href_link(FILENAME_MAIL, 'mail_sent_to=' . urlencode($mail_sent_to)));
 }


 if ( ($action == 'preview') && !tep_not_null($HTTP_POST_VARS['customers_email_address']) ) {	// NO ADDRESS
$messageStack->add(ERROR_NO_CUSTOMER_SELECTED, 'error');
	tep_draw_hidden_field('back_x', '');

 }

 if (isset($HTTP_GET_VARS['mail_sent_to'])) {
$messageStack->add(sprintf(NOTICE_EMAIL_SENT_TO, $HTTP_GET_VARS['mail_sent_to']), 'success');
 }
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo TITLE; ?></title>
<link rel="stylesheet" type="text/css" href="mydomain/demostore/admin/includes/stylesheet.css">
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="100%" cellspacing="2" cellpadding="2">
 <tr>
<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
</table></td>
<!-- body_text //-->
<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
  <tr>
	<td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">
	  <tr>
		<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
		<td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
	  </tr>
	</table></td>
  </tr>
  <tr>
	<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
<?php
 if ( ($action == 'preview') && isset($HTTP_POST_VARS['customers_email_address']) ) {
switch ($HTTP_POST_VARS['customers_email_address']) {
  case '***':
	$mail_sent_to = TEXT_ALL_CUSTOMERS;
	break;
  case '**D':
	$mail_sent_to = TEXT_NEWSLETTER_CUSTOMERS;
	break;
  default:
	$mail_sent_to = $HTTP_POST_VARS['customers_email_address'];
	break;
}
?>
	  <tr><?php echo tep_draw_form('mail', FILENAME_MAIL, 'action=send_email_to_user'); ?>
		<td><table border="0" width="100%" cellpadding="0" cellspacing="2">
		  <tr>
			<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
		  </tr>
		  <tr>
			<td class="smallText"><b><?php echo TEXT_CUSTOMER; ?></b><br><?php echo $mail_sent_to; ?></td>
		  </tr>
		  <tr>
			<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
		  </tr>
<tr>
			<td class="smallText"><b><?php echo TEXT_FROM; ?></b><br><?php echo htmlspecialchars(stripslashes($HTTP_POST_VARS['from_name'])); ?></td>
		  </tr>
		  <tr>
			<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
		  </tr>

		  <tr>
			<td class="smallText"><b><?php echo TEXT_FROM_EMAIL; ?></b><br><?php echo htmlspecialchars(stripslashes($HTTP_POST_VARS['from'])); ?></td>
		  </tr>
		  <tr>
			<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
		  </tr>			  

		  <tr>
			<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
		  </tr>
		  <tr>
			<td class="smallText"><b><?php echo TEXT_SUBJECT; ?></b><br><?php echo htmlspecialchars(stripslashes($HTTP_POST_VARS['subject'])); ?></td>
		  </tr>
		  <tr>
			<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
		  </tr>

							<tr>
			<td class="smallText"><b><?php echo TEXT_MESSAGE; ?></b><br><?php echo (stripslashes($HTTP_POST_VARS['message'])); ?></td>
		  </tr>
		  <tr>
			<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
		  </tr>
		  <tr>
			<td>
<?php
/* Re-Post all POST'ed variables */
reset($HTTP_POST_VARS);
while (list($key, $value) = each($HTTP_POST_VARS)) {
  if (!is_array($HTTP_POST_VARS[$key])) {
	echo tep_draw_hidden_field($key, htmlspecialchars(stripslashes($value)));
  }
}
?>
			<table border="0" width="100%" cellpadding="0" cellspacing="2">
			  <tr>

<td align="center"><?php echo tep_image_submit('button_back.gif', IMAGE_BACK, 'name="back"'); echo tep_draw_separator('pixel_trans.gif', '30', '10') . '<a href="' . tep_href_link(FILENAME_MAIL) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a> '; if (tep_not_null($HTTP_POST_VARS['customers_email_address'])) {echo tep_draw_separator('pixel_trans.gif', '30', '10') .  tep_image_submit('button_send_mail.gif', IMAGE_SEND_EMAIL);} ?></td>

			  </tr>
			</table></td>
		  </tr>
		</table></td>
	  </form></tr>
<?php
 } else {
?>
	  <tr><?php echo tep_draw_form('mail', FILENAME_MAIL, 'action=preview'); ?>
		<td><table border="0" cellpadding="0" cellspacing="2">
		  <tr>
			<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
		  </tr>
<?php
$customers = array();
$customers[] = array('id' => '', 'text' => TEXT_SELECT_CUSTOMER);
$customers[] = array('id' => '***', 'text' => TEXT_ALL_CUSTOMERS);
$customers[] = array('id' => '**D', 'text' => TEXT_NEWSLETTER_CUSTOMERS);
$mail_query = tep_db_query("select customers_email_address, customers_firstname, customers_lastname from " . TABLE_CUSTOMERS . " order by customers_lastname");
while($customers_values = tep_db_fetch_array($mail_query)) {
  $customers[] = array('id' => $customers_values['customers_email_address'],
					   'text' => $customers_values['customers_lastname'] . ', ' . $customers_values['customers_firstname'] . ' (' . $customers_values['customers_email_address'] . ')');
}
?>
		  <tr>
			<td class="main"><?php echo TEXT_CUSTOMER; ?></td>
			<td><?php echo tep_draw_pull_down_menu('customers_email_address', $customers, (isset($HTTP_GET_VARS['customer']) ? $HTTP_GET_VARS['customer'] : ''));?></td>
		  </tr>
		  <tr>
			<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
		  </tr>

		   <tr>
			<td class="main"><?php echo TEXT_FROM; ?></td>
			<td><?php echo tep_draw_input_field('from_name', STORE_NAME,'size="80"'); ?></td>
		  </tr>
						<tr>
			<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
		  </tr>
						<tr>
			<td class="main"><?php echo TEXT_FROM_EMAIL; ?></td>
			<td><?php echo tep_draw_input_field('from', EMAIL_FROM,'size="80"'); ?></td>
		  </tr>
		  <tr>
			<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
		  </tr>
		   <tr>
			<td class="main"><?php echo TEXT_SUBJECT; ?></td>
			<td><?php echo tep_draw_input_field('subject','','size="80"'); ?></td>
		  </tr>


		  <tr>
			<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
		  </tr>
		  <tr>
			<td valign="top" class="main"><?php echo TEXT_MESSAGE; ?></td>
	 <td><?php echo tep_draw_fckeditor('message','580','400',$message); ?></td>

		  </tr>
		  <tr>
			<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
		  </tr>
		  <tr>
			<td colspan="2" align="right"><?php echo tep_image_submit('button_send_mail.gif', IMAGE_SEND_EMAIL); ?></td>
		  </tr>
		</table></td>
	  </form></tr>
<?php
 }
?>
<!-- body_text_eof //-->
	</table></td>
  </tr>
</table></td>
 </tr>
</table>
<!-- body_eof //-->

<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Share this post


Link to post
Share on other sites

Finally, found my way and managed to fix the broken link issue in mail.php.

 

Another problem I am facing is the extra lines if I insert a table in products description page. Can someone help?

Edited by tuppergreen

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×