[RELEASE] v2.0 Email new thread notifications to subscribed users

[chrispadfield]

A few have requested this, me especially so i made it.

What it does: Emails all those who have subscribed to a forum an email telling them about a new thread.

Extra queries: 1 upon every new thread. Extra time processing new threads as emails must be sent.

code changes, 1 in newthread.php and 2 new templates.




CODE CHANGE:

Add:

// This emails a new thread notification to those subscribed to the forum
    if ($enableemail) {
      // do emails

      $useremails=$DB_site->query("SELECT user.*
                                   FROM subscribeforum,user
                                   WHERE subscribeforum.forumid='$forumid'
                                     AND subscribeforum.userid=user.userid
                                     AND user.userid<>'$bbuserinfo[userid]'
                                    ");

              $toemail=$val;
              $forumtitle = $foruminfo['title'];
              $threadinfo['title'] = $subject;

      $bbuserinfo['username']=unhtmlspecialchars($bbuserinfo['username']);
      while ($touser=$DB_site->fetch_array($useremails)) {
        $touser['username']=unhtmlspecialchars($touser['username']);

        eval("\$emailmsg = \"".gettemplate("email_newthread",1,0)."\";");
        eval("\$emailsubject = \"".gettemplate("email_newthreadsubject",1,0)."\";");

        mail($touser[email],$emailsubject,$emailmsg,"From: \"$bbtitle Mailer\" <$webmasteremail>");
      }
} 

below the section //send email to moderators which ends with

}
}
}
}

add two templates:

i) email_newthread

Hello $touser[username],

$bbuserinfo[username] has just started a new thread: in $foruminfo[title]
This is a forum you have subscribed to at $bbtitle

The thread title is: $threadinfo[title] 
This thread is located at:
$bburl/showthread.php?threadid=$threadid&goto=newpost

Yours,
$bbtitle team

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Unsubscription information:

You are receiving these "new thread" notifications because 
you are subscribed to the $foruminfo[title] forum. 

To unsubscribe, please visit:
$bburl/usercp.php

and secondly

email_newthreadsubject

New Thread in $foruminfo[title]

any you are away

[chrispadfield]

please note if you are testing this you need two users because it will NOT send an email to the person who started the thread. Either remove the last line of the query

AND user.userid<>'$bbuserinfo[userid]' 

or use two different users.

[chrispadfield]

oops, i left a line of debug code in.

if you have already installed this, remove this line
echo $touser;
the code change had been updated so if you have not installed it yet don't worry.

[mrlister]

is it possible to make it so it does this every hour and every hour lists all the new threads within the thread.

[chrispadfield]

i am not sure what you mean. Why would you want to send them every hour when they can be done instantly? by the sounds of it you want something more like the community bulletin thing made by Kier/tubedog

[chrispadfield]

sorry, another fix

you need to change $threadinfo[threadid] to $threadid

[Joe]

The emails this sends out are from "nobody" at : nobody@snoturtle.serverhost.com

How do i change this to Bike Forums with my real email addy?

[chrispadfield]

mail($touser[email],$emailsubject,$emailmsg,"From: \"$bbtitle Mailer\" <$webmasteremail>");

is the line that generates that and it is copied straight from the newreply.php code (which is where most of this code came from). I can't see how it can work in one place and not the other. sorry, not a clue.

[Kevin Green]

Hi,

Very interested in this thread for user support purposes.

Will it email users subscribed to the Forum when there are additions to any of the existing threads

Will it email users if there are additions to the thread it has already notified them of?

I ask because I am interested in having users emailed if there is a new thread or if there are any additions to existing threads regardless of whether they have been previously notified but perhaps failed to check the Forum.

Many thanks

kevin

[Pie'oh'pah]

Hi,

we have the same problem as Joe, when unregistered users are involved.

-Pie

[Pie'oh'pah]

No i must stand corrected: It's happening even if users are registered...

-Pie

[claytonp]

Hello,

I thought I would attempt this code hack myself, however I cannot locate the following in newthread.php

below the section //send email to moderators which ends with

}
}
}
}

as indicated by chrispadfield. Am I doing something wrong.

I have already created the two templates.


Regards,

Clayton

[express]

Below This

// send email to moderators
      if ($enableemail) {
        $moderators=$DB_site->query_first("SELECT CONCAT(newthreademail,' ',newpostemail) AS newthreademail FROM forum WHERE forumid='$forumid'");

        $modtable=$DB_site->query("SELECT DISTINCT user.email FROM moderator,user WHERE moderator.userid=user.userid AND forumid IN ($foruminfo[parentlist]) AND (newthreademail=1 OR newpostemail=1)");
        while($thismod=$DB_site->fetch_array($modtable)) {
          $moderators['newthreademail'].=" $thismod[email]";
        }

        if ($moderators['newthreademail']!="") {
          $mods=explode(" ",trim($moderators['newthreademail']));
          while (list($key,$val)=each($mods)) {

            if (trim($val)!="") {
              $toemail=$val;
              $forumtitle = $foruminfo['title'];
              $threadinfo['title'] = $subject;

              eval("\$emailmsg = \"".gettemplate("email_moderator",1,0)."\";");
              eval("\$emailsubject = \"".gettemplate("emailsubject_moderator",1,0)."\";");
              mail($toemail,$emailsubject,$emailmsg,"From: \"$bbtitle Mailer\" <$webmasteremail>");
            }
          }
        }
      } 

[Stasik]

to fix "nobody" problem replace"

eval("\$emailsubject = \"".gettemplate("email_newthreadsubject",1,0)."\";");

with:

eval("\$emailsubject = \"".gettemplate("emailsubject_moderator",1,0)."\";");

then you can delete teplate called "email_newthreadsubject"

[chrispadfield]

not quite sure how that will help as that edits the subject of the email not where it is from. Unless you have a linebreak in the subject template, that might make it not work.