Help Please {Newsletter Plugin}

[AjEe]

""

Hey {username}, here is the latest information from {bbname}.
Members: {bbmembers}
Threads: {bbthreads}
Posts: {bbposts}

The latest announcement is: {bblannounce}

Latest Threads:
{bblthreads}


Latest Posts:
{bblposts}


If you no longer want to receive these updates, please go to your User CP at {bburl} and then choose "Group Memberships" and "Leave Group" next to the "Mailing List" group.


Thank you,

The {bbname} Team. {bburl}

""

This was the default message, if i use this message to send Mass Email from Mass Email Function why all variables don't work !!! It gives me output like this...

Hey Guru, here is the latest information from Digital58.Net.
Members: {bbmembers}
Threads: {bbthreads}
Posts: {bbposts}

The latest announcement is: {bblannounce}

Latest Threads:
{bblthreads}


Latest Posts:
{bblposts}


If you no longer want to receive these updates, please go to your User CP at http://www.digital58.net and then choose "Group Memberships" and "Leave Group" next to the "Mailing List" group.


Thank you,

The Digital58.Net Team. http://www.digital58.net

Can I make this working thru Mass Email function in AdminCP..

Regards,

[MrD.]

No, some of those variables I added specifically for the Newsletter Plugin.

[AjEe]

oK ... I got it... Than I want to send this newsletter to all of my users .. How can i accomplish this...

How can I add all registered users to secondary user group .. i.e mail usergroup....

I dont know programming / coding .. If you tell me any query so i can run it to make all users to the group mail users .. so they receive newsletter on daily basis.. either they want it or not!!

Thanks for help

[MrD.]

I have a feeling that sending people email without an opt-out is illegal. Hence why the Newsletter plugin has a Mailing List group.

How many members do you have?

[AjEe]

I have over 2K members now and i get almost 50 users daily ... I want actually something like this.. That my users get daily activities happened in my board.... Thats all.. So is that possible to send that daily activity to all members daily...

[MrD.]

How many hits does your forum receive? The reason I ask is that the newsletter sends out 10 emails from the queue everytime a page of your forum is loaded. This means that if you don't get over 200 hits per day, the queue would not clear.

[AjEe]

Well ... I don't know Google analytic shows that i get more than 1K ... and by the statistics page almost guests and users 7K people visit daily. Now problem is that I used to send the email by default many times since yesterday but its not working.. The emails inst shown in Mail Queue even. I don't know why?

So I hope there will be some chance to send that email format from Mass Mail .. Is that possible by doing some modification or we can use already coding u did?

[MrD.]

Backup your copy of ./admin/users.php before starting this

Open ./admin/users.php.
On Line 649; before "$sendmessage = $searchop['message'];" Add:

$stats = $cache->read("stats");

On Line 649; after "@set_time_limit(0);" Add:

		// Get the latest announcement
		$query2 = $db->query("SELECT aid FROM ".TABLE_PREFIX."announcements ORDER BY aid DESC LIMIT 1");
		$row2 = $db->fetch_array($query2);
		if($db->num_rows($query2) > 0)
		{
			$bblannounce = "{$mybb->settings['bburl']}/announcements.php?aid={$row2['aid']}";
		}
		else
		{
			$bblannounce = "None";
		}
		
		
		// Get the latest threads
		$query2 = $db->query("SELECT tid FROM ".TABLE_PREFIX."threads ORDER BY tid DESC LIMIT 5");
		$bblthreads = "";
		if($db->num_rows($query2) > 0)
		{
			while($row2 = $db->fetch_array($query2))
			{
				$bblthreads .= "{$mybb->settings['bburl']}/showthread.php?tid={$row2['tid']}\r\n";
			}
		}
		else
		{
			$bblthreads .= "None";
		}
		
		
		// Get the latest posts
		$query2 = $db->query("SELECT tid, pid FROM ".TABLE_PREFIX."posts ORDER BY pid DESC LIMIT 5");
		$bblposts = "";
		if($db->num_rows($query2) > 0)
		{
			while($row2 = $db->fetch_array($query2))
			{
				$bblposts .= "{$mybb->settings['bburl']}/showthread.php?tid={$row2['tid']}&pid={$row2['pid']}#pid{$row2['pid']}\r\n";
			}
		}
		else
		{
			$bblposts .= "None";
		}

On Line 659; before "if($searchop['type'] == "html" && $user['email'] != '')" Add:

$sendmessage = str_replace("{bbthreads}", $stats['numthreads'], $sendmessage);
$sendmessage = str_replace("{bbposts}", $stats['numposts'], $sendmessage);
$sendmessage = str_replace("{bbmembers}", $stats['numusers'], $sendmessage);
$sendmessage = str_replace("{bblannounce}", $bblannounce, $sendmessage);
$sendmessage = str_replace("{bblthreads}", $bblthreads, $sendmessage);
$sendmessage = str_replace("{bblposts}", $bblposts, $sendmessage);

I haven't tested this, but it should work. Like I say, backup your copy of the file before starting incase it doesn't.

[AjEe]

Hey Guru, here is the latest information from Digital58.Net

Members:
Threads:
Posts:

The latest announcement is: None

Latest Threads:
http://www.digital58.net/showthread.php?tid=438
http://www.digital58.net/showthread.php?tid=437
http://www.digital58.net/showthread.php?tid=436
http://www.digital58.net/showthread.php?tid=435
http://www.digital58.net/showthread.php?tid=434



Latest Posts:
http://www.digital58.net/showthread.php?...27#pid2127
http://www.digital58.net/showthread.php?...26#pid2126
http://www.digital58.net/showthread.php?...25#pid2125
http://www.digital58.net/showthread.php?...24#pid2124
http://www.digital58.net/showthread.php?...23#pid2123



If you no longer want to receive these updates, please go to your User CP at http://www.digital58.net and then choose "Group Memberships" and "Leave Group" next to the "Mailing List" group.


Thank you,

The Digital58.Net Team. http://www.digital58.net

It worked but there are some minor things to be changed or cleared...

1) Why its not giving the total number of users, threads, and posts in first line...

2) It is only giving last five threads and posts...

Thanks for all this u did already!

[MrD.]

I forgot to mention that this will allow you to use those extra variables in a Mass Email from the Admin CP.