Email Notification on a Moved Thread

Currently, if you move a thread to a forum that is configured to send email on new thread creation, the email is not sent even though the moved thread is a new thread to the destination forum.

One of the uses of our board is to leave an 'audit' trail via the redirection option when a thread is moved and notify members of the transition of an item when the thread is moved to the next forum. In specific, a thread moves from the 'Development' forum to the 'Review' forum and we want the appropriate mailing list notified just as they were when the initial thread was created in the 'Development' forum.

Will start looking at the vBulletin components that handle email notification when a thread is created and then compare that to when a thread is moved. Wanted to see if anyone has thought about this and has any ideas. Also, if anyone knows exactly where I should look, that would be helpful.

Regards,

web

[Admin]

See this in newthread.php?

PHP Code:

      // 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>");
            }
          }
        }
      } 


You basically need to add this to postings.php where the thread is being moved (with a little mod here and a little mod there).

You be da' Man!
Was hoping you would see this and give me some 'direction'.
Appreciate all your help, will try this later today and get back to you. Thanks again.

Best regards,

web

[Admin]

No problem.

If you do solve this, please post it here, I'm also interested in this.

I have not had a chance to try this yet, but was wondering if this is the same code that send email to the email addresses specified in the forum creation/update page or only the moderator creation/update page. My need is for the email addresses that are specified on the forum creation/update page. Will take a look at the code in 'newthread.php' and see if there is a separate code fragment that deals with moderator notification and email addresses designated when the forum is created or updated.

Regards,

web

With the events of last week and the aftermath, I've not been able to test this until now.

Adding the code fragment from newthread.php (listed in an post above) to postings.php works like a charm! If moderation email notification is set in the destination forum, the migration of a thread to that forum will cause the email to be sent.

I inserted the above code fragment from newthread.php into postings.php as shown below:

PHP Code:

if ($deleteuser) {
  $DB_site->query("DELETE FROM subscribethread WHERE threadid='$threadid' AND userid IN ($deleteuser)");
}

// send email to moderators - code fragment from newthread.php here

eval("standardredirect(\"".gettemplate("redirect_movethread")."\",\"showthread.php?s=$session[sessionhash]&threadid=$threadid\");");
} 


In the code fragment, this line needs to be deleted:

PHP Code:

$threadinfo['title'] = $subject; 


Thanks much, FireFly!

Best regards,

web

P.S. I tested move, move with redirection, and copy to a destination forum with email notification on. Then repeated the tests to a forum with email notification off. All tests 'did the right thing' .

[Admin]

Great!