Easter Sale 2024

  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: Show newsletter archive

Show newsletter archive 11 years 4 months ago #20522

  • renekreijveld
  • renekreijveld's Avatar
  • OFFLINE
  • Junior Boarder
  • Posts: 24
  • Thank you received: 7
How can I show to my website visitors a newletter archive? According to the documentation, I can display a History Menu item, but that only seems to be available to logged in users:
www.rsjoomla.com/support/documentation/v...mail-menu-items.html

I want to display this archive to all my website visitors. Any suggestions how to do this?
René Kreijveld, Joomla! specialist
The administrator has disabled public write access.

Show newsletter archive 11 years 4 months ago #20523

  • renekreijveld
  • renekreijveld's Avatar
  • OFFLINE
  • Junior Boarder
  • Posts: 24
  • Thank you received: 7
It looks like this not possible without hacking core RSMail code. Here's how to do it.
This hack applies to RSMail 1.0.0 REV 18.

1. Open /components/com_rsmail/models/history.php.
2. Uncomment lines 32 to 40:
//if ($user->get('guest') && empty($code))
//{
//	$link = JRequest::getURI();
//	$link = base64_encode($link);
//	if (rsmailHelper::is16())
//		$app->redirect(JRoute::_('index.php?option=com_users&view=login&return='.$link, false));
//	else
//		$app->redirect(JRoute::_('index.php?option=com_user&view=login&return='.$link, false));
//}

3. Uncomment line 61:
//$query  = "SELECT m.IdMessage , m.MessageSubject,s.IdSession,s.Date FROM #__rsmail_messages m LEFT JOIN #__rsmail_sessions s ON s.IdMessage=m.IdMessage LEFT JOIN #__rsmail_subscribers sb ON sb.IdList IN (s.Lists) WHERE sb.SubscriberEmail = '".$this->_db->getEscaped($user->email)."' AND s.Date > sb.DateSubscribed ORDER BY s.IdSession DESC ";

4. Below line 61 add the following line:
$query  = "SELECT m.IdMessage , m.MessageSubject,s.IdSession,s.Date FROM #__rsmail_messages m LEFT JOIN #__rsmail_sessions s ON s.IdMessage=m.IdMessage LEFT JOIN #__rsmail_subscribers sb ON sb.IdList IN (s.Lists) WHERE s.Date > sb.DateSubscribed ORDER BY s.IdSession DESC ";

5. Save the file.

This will show a list of ALL sent newsletters to Public users (depending on the access rights set on the menu item).
René Kreijveld, Joomla! specialist
Last Edit: 11 years 4 months ago by renekreijveld.
The administrator has disabled public write access.

Show newsletter archive 11 years 3 weeks ago #22517

  • KAIROS
  • KAIROS's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
Hi,
I need to do the same thing.
But I'm using Rev 19.
Is there something else to consider?

How about to make an option in the configuration menu of RSMail which says: Make newletter history public.

Thanks for your great tool - Keep up the good work

Bernd
The administrator has disabled public write access.

Show newsletter archive 11 years 3 weeks ago #22518

  • octavian
  • octavian's Avatar
  • OFFLINE
  • RSJoomla! Official Staff
  • Posts: 783
  • Thank you received: 110
The only reason why we haven't made it public yet is because every subscriber has details that can be used inside the newsletter (eg. email address, name, company etc). We'd have nowhere to grab that information from when displaying the newsletter publicly (ie. to unregistered/unsubscribed users).
Please note: my help is not official customer support. To receive your support, submit a ticket by clicking here
Regards,
RSJoomla! Development Team
The administrator has disabled public write access.

Show newsletter archive 10 years 10 months ago #23989

  • bobr
  • bobr's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
I have the same request - why not just have a setting to leave the field name without getting the actual data?

Bob
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!