HTML Email Feature

Hiyas,

What does it do?
With this hack, your board will have "HTML email" feature.

How does it work?
After applying the hack, your users will be able to choose whether they want PLAIN TEXT emails or HTML messages and mails originated from your site will be sent accordingly. (At the moment works for PM and email notification mails). Your existing users who didnt change their mail settings will recieve the original plain texts mails, while users who asked for HTML mails will get mails in HTML format. All users can anytime change their mail settings inside User CP or by calling the new 2 links with one click that comes with the hack and update member's mail type.

What versions of vbulletin does it work with?
Hack tested with version 2.2.2, 2.2.6, 2.2.8 and 2.2.9 but I believe it will work with any versions > 2.0.3.

Any Screenshots?
See the message below

Planned Future Features:
* Hack will apply to ALL mails originated from your board (At the moment it is for PM and email notification mails)
* Your HTML mails may include compiled data from your board such as "Last X message titles", "Recent Titles from the forum you subscribed", "Last X answered/unanswered messages", "user's incoming personal events", "Incoming general events from your calender" and etc.

I plan to work on this hack only if it's considered useful and used by people. After spending a long time to code/debug/test/publish a hack, it's quite disappointing to see that 2 months later only 3-5 people used (installed) a hack. So if you use the hack, please dont forget to click INSTALL for this hack or for any hack you use!

Thank you and Enjoy..\\=^))
Logician

[Logician]

Originally posted by Dan Flynn
alter command denied to user: 'powerwas@localhost' for table 'user' Any idea why?

Dan as your error states, the problem you are having is related to your MYSQL user rights. You are trying to run a SQL query with a user account that does not hold "changing(alter) database" privileges.. You have to contact your host and ask "with which username and MYSQL password you should run ALTER commands", then use these info to run the SQL command..

[Dan Flynn]

Thanks I'll check into that. I'm pretty sure I have ran them before under that name!!!!

[ChurchMedia]

Another great hack!

I have the "threadstarter" hack installed, which emails forum subscribers when new threads are started. I'm trying to implement your hack into that one. It goes into the newthread.php.

Here is what I added, along with a new template, but it doesn't seem to work. It just sends out plain text. See anything wrong?

PHP Code:

// Hack: Send email notification on subscribed forums
      if ($enableemail and $visible) {
        $tousers=$DB_site->query("SELECT user.username,user.email
                                     FROM subscribeforum,user
                                     WHERE subscribeforum.forumid='$forumid'
                                       AND subscribeforum.userid=user.userid
                                       AND user.userid<>'$bbuserinfo[userid]'");
        $forumtitle=unhtmlspecialchars($foruminfo['title']);
    $author=unhtmlspecialchars($bbuserinfo['username']);
    $postsubject=unhtmlspecialchars($subject);
    $postcontents=unhtmlspecialchars($message);
        while ($touser=$DB_site->fetch_array($tousers)) {
          $touser['username']=unhtmlspecialchars($touser['username']);
// Logician HTML mail hack
if ($touserinfo['htmltext']==0){
// user wants plain text messages
          eval("\$emailmsg = \"".gettemplate("email_threadstarter",1,0)."\";");
          eval("\$emailsubject = \"".gettemplate("emailsubject_threadstarter",1,0)."\";");

          mail($touser['email'],$emailsubject,$emailmsg,"From: \"$bbtitle Mailer\" <$webmasteremail>");
        }
      else
//user wants HTML messages
{
eval("\$emailmsg = \"".gettemplate("email_threadstarter_html",1,0)."\";");
eval("\$emailsubject = \"".gettemplate("emailsubject_threadstarter",1,0)."\";");
mail($touser['email'],$emailsubject,$emailmsg,"From: \"$bbtitle \" <$webmasteremail>\nMIME-VERSION: 1.0\nCONTENT-TYPE: TEXT/HTML; CHARSET=iso-8859-9\nCONTENT-DISPOSITION: INLINE\n");
}
// Logician HTML mail hack
      
        }
      }
      // End hack 


I think I may have a } out of place...

[Logician]

I didn't understand why you are editing newthread.php while installing my hack? My hack does not modify newthread.php in anyway. Please check hack installations carefully, I believe you installed it incorrectly and this is why it does not work.. :knockedout:

[ChurchMedia]

Originally posted by Logician
I didn't understand why you are editing newthread.php while installing my hack? My hack does not modify newthread.php in anyway. Please check hack installations carefully, I believe you installed it incorrectly and this is why it does not work.. :knockedout:

This is a "hack of your hack of a hack". I'm trying to make the threadstarter hack, FOUND HERE, work the same way and send out html emails for thread starts. I also want to do it for moderators....

Your hack as described in the instructions is working perfectly. I was just wondering if you could help me with some additional modifications....

[Logician]

Originally posted by ChurchMedia

Your hack as described in the instructions is working perfectly. I was just wondering if you could help me with some additional modifications....

ok I see..

Give this a shot:

PHP Code:

=================================================================
      // Hack: Send email notification on subscribed forums
      if ($enableemail and $visible) {
        $tousers=$DB_site->query("SELECT user.username,user.email,user.htmltext
                                     FROM subscribeforum,user
                                     WHERE subscribeforum.forumid='$forumid'
                                       AND subscribeforum.userid=user.userid
                                       AND user.userid<>'$bbuserinfo[userid]'");
        $forumtitle=unhtmlspecialchars($foruminfo['title']);
    $author=unhtmlspecialchars($bbuserinfo['username']);
    $postsubject=unhtmlspecialchars($subject);
    $postcontents=unhtmlspecialchars($message);
        while ($touser=$DB_site->fetch_array($tousers)) {
          $touser['username']=unhtmlspecialchars($touser['username']);
    // Logician HTML mail hack
        if ($touser['htmltext']==0){
        // user wants plain text messages

                  eval("\$emailmsg = \"".gettemplate("email_threadstarter",1,0)."\";");
              eval("\$emailsubject = \"".gettemplate("emailsubject_threadstarter",1,0)."\";");

              mail($touser['email'],$emailsubject,$emailmsg,"From: \"$bbtitle Mailer\" <$webmasteremail>");
        }
         else
        //user wants HTML messages
        {
        eval("\$emailmsg = \"".gettemplate("email_threadstarter_html",1,0)."\";");
        eval("\$emailsubject = \"".gettemplate("emailsubject_threadstarter",1,0)."\";");
        mail($touser['email'],$emailsubject,$emailmsg,"From: \"$bbtitle \" <$webmasteremail>\nMIME-VERSION: 1.0\nCONTENT-TYPE: TEXT/HTML; CHARSET=iso-8859-9\nCONTENT-DISPOSITION: INLINE\n");
        }
// Logician HTML mail hack

        }
      }
      // End hack
================================================================= 


Enjoy..

[ChurchMedia]

Worked perfectly! I see where I messed up -- Thanks a ton!

[SpankMe]

Is there going to be an update for this hack for vBulletin 2.3.0 which has changed its mail code.

[Logician]

Is there going to be an update for this hack for vBulletin 2.3.0 which has changed its mail code.

Nope sorry.. My access to vb.com member area has expired and I don't plan to renew it until a stable vb3 release which I'll upgrade comes up..

[ryancooper]

will this work wit hteh email all users option in hte Admin CP. If so it is exactly what i am looking for.