Send HTML Email to Users

[akanevsky]

/*================================================= =====================*\
|| Send HTML Email to Users
||
|| ================================================== =====
|| Brought to you by:
|| VisionScripts (http://www.visionscripts.com/)
|| Premium PHP & vBulletin Solutions!
|| ================================================== =====
||
|| Author : Psionic Vision
|| Works on : vBulletin 3.5
|| Released : Jul 01, 2006
||
|| Time required to install: 1 minute
|| Difficulty: easy
\*================================================ ======================*/

DESCRIPTION

Gives admin an ability to send HTML e-mail to users via AdminCP.

STATISTICS

File Changes: 2
Template Changes: 1
Products to Install: 1


FEATURES


Uses default style of your forum
Users can choose whether to receive Plain Text of HTML Emails


VERSION HISTORY

1.0.0
Initial Release

The installation manual is contained within the attached file.

IF YOU LIKE MY HACK, PLEASE CLICK INSTALL (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=120069)

[akanevsky]

First Post Reserved...

[bashy]

Hi m8, i am trying to install but i cannot find this code in my register template?
<if condition="$vboptions['enableemail']">
I have tried just searching for enable and <if condition="$vboptions but nothing....any ideas please?

[Kaleem]

thank God i got this

[akanevsky]

Hi m8, i am trying to install but i cannot find this code in my register template?
<if condition="$vboptions['enableemail']">
I have tried just searching for enable and <if condition="$vboptions but nothing....any ideas please?
It is present in the default vBulletin skin. Other skins are unsupported.

[bashy]

I have just searched all templates in all styles with that code and the only template showing up is the modifyoptions template, including the default....

I am quite supprised about only being for default as well, how many actually only use the default template?

[akanevsky]

If you are a designer, you should be able to figure these things out yourself. The code you are looking for is the one that displays "accept email from other members" option.

[bashy]

I am only learning but yes i did figure thats what it was all about
But whether i am a desinger or not is neither here nor there, this is your work not mine hence me asking you....I didnt ask for any arrogance, I will bid you good day and leave this 1, thank you anyway!!

[FleaBag]

I think he was just sticking to what he said about only supporting unmodified skins. Nice release!

[akanevsky]

I am only learning but yes i did figure thats what it was all about
But whether i am a desinger or not is neither here nor there, this is your work not mine hence me asking you....I didnt ask for any arrogance, I will bid you good day and leave this 1, thank you anyway!!

And leave this one after actually installing and using it? I received your newsletter...
There's no arrogance, I'm simply tired of explaining the same things over and over...

Nice release!

Thanks.

[DementedMindz]

nice job yet again Psionic Vision

[akanevsky]

Correction: In register template, what you are looking for is:
<if condition="$show['email']">
Not what is said in readme.
Bashy, I apologize.
DementedMindz, thanks. :)

[ViViD]

Is it also sending HTML automated subscription and register emails or just manual emails ?

[bashy]

No probs...I mangaed to find it and test it before i went bed last night...
Was leaving it till this morning to come back in here and let your know :)
Thanks for a great hack, works well :)


PS.... i wernt referring to leaving the hack, it was the argument i was leaving lol....
I dont like giving up on a hack if there is a possiblilty on getting it to work, I just
dont like arguing lol

Correction: In register template, what you are looking for is:
<if condition="$show['email']">
Not what is said in readme.
Bashy, I apologize.
DementedMindz, thanks. :)

[akanevsky]

Is it also sending HTML automated subscription and register emails or just manual emails ?
The hack is only for admin to send manual HTML emails.

Thanks for a great hack, works well
Yep, no problems :)

[MSheraz86]

Marvellous Mod :)

Only trouble is that I am sending emails out to myself but I don't seem to be getting any. I went to Users> Send Email to Users and did all the necessary input and sent it off to Admins only but it's of no use :(.

Also when trying to modify "modifyoptions" in default VB skin I get this message (Even when I remove the code that you said and leaving original code there)

The following error occurred when attempting to evaluate this template:

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/.../public_html/forum/includes/adminfunctions_template.php(3537) : eval()'d code on line 64

Where am I going wrong?

I never thought it would be possible to send HTML emails, so Thank You Psionic Vision for making it Possible!! :) I just hope I can get it to actually send the emails :p

[akanevsky]

Make sure you are running that vB 3.5.4... Also, adminfunctions_template has nothing to do with the hack.

[MSheraz86]

Yep, am running vB 3.5.4 and most certainly adminfunctions_template has nothing to do with this mod but that is the error I got.

[akanevsky]

Sorry, this is support thread for this particular mod. I cannot provide support for things that go beyong that point.

[MSheraz86]

Fair enough, but the emails not being sent is a definate from this mod :D so hopefully you can help me out on that matter ;).

Before installing this mod, emails were sent to yahoo, hotmail, personal domain sites etc but now hotmail stands no chance, yahoo may get the email after further repetetive attempts, as for the rest not sure.

I got the email at my yahoo account but none at my hotmail account. Usually i'd probably give up but i'm very eager to have HTML emails being enabled :D. The email that was sent to my yahoo account wasn't HTML based, it was normal font, I dunno why this mod ain't working properly with me lol.

[akanevsky]

I checked this on yahoo, optonline, hotmail and google, it's working for me...

[MSheraz86]

Update: Yahoo is working Fine!!

Stupid of me > Did not realise that options needed to be edited. I chose yes for HTML emails and so finally am seeing HTML based email at yahoo. My header isn't showing lol.

Here's the creepy part..

My IP address is being given away and I have the following on the left hand side appearing.

X-Apparently-To:
X-Originating-IP:
Return-Path:
Received:
Received:
To:
Subject: Testing
X-PHP-Script:
From: "MSheraz86@hotmail.com" <MSheraz86@hotmail.com> Add to Address Book
Message-ID: <200607050135.715d63543728@www.themobilefactor.com>
MIME-Version: 1.0
Content-Type: text/html; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit
X-Priority: 3
X-Mailer: vBulletin Mail via PHP
Date: Tue, 04 Jul 2006 20:28:35 -0500
X-AntiAbuse: This header was added to track abuse, please include it with any abuse report
X-AntiAbuse: Primary Hostname -
X-AntiAbuse:
X-AntiAbuse:
X-AntiAbuse: Sender Address Domain -
X-Source:
X-Source-Args:
X-Source-Dir:
Content-Length:

Sorry for the mess up there. Why is the above showing in yahoo? I'm glad I didn't send out emails to anyone else lol.

[akanevsky]

I believe those are normal. Configure yahoo not to show headers by default..

[MSheraz86]

Awesome!! Yahoo is sorted then :D, I don't seem to understand why hotmail isn't working. I'm definately certain that hotmail was accessible, I could send emails but now it's not possible. I asked one of my sup mods as well and he didn't get anything at all.

Is there a way to configure the header of my HTML? Yahoo shows the header pointing at http://mail.yahoo.com/config/login?/index.php and I don't see any image there :p.

On a site note some time ago this is EXACTLY How I had imagined HTML emails when I made an attempt to manually send one lol. Anyways putting hotmail aside this is a very useful and great mod :D. Only the issue with hotmail is left along with the header and i'm ready to start sending emails :D.

[I appreciate the on-going support Anthony :)]

[maroceve]

Hey there.

I was wondering if there is way to force users already registered to receive html emails without them checking the box in their options ?

[akanevsky]

Hey there.

I was wondering if there is way to force users already registered to receive html emails without them checking the box in their options ?
UPDATE user SET htmail = 1

[MSheraz86]

^^ Exremely USEFUL!! :D I ran the query successfully :).

Any luck with why hotmail users are not getting any emails from my site? :(

[Kirk Y]

Nice hack.

* installs

Edit: Psionic, do you by chance have a screenshot of a typical email when using this hack? My test email doesn't look that html..ish and my header image is messed up. It's attempting to call it from the images dir. without my site url. (http://images/misc/blabla.gif)

Edit: Hmm, appears it's something with Gmail. They're not taking too kindly to the CSS or something -- all my other accounts work fine: Comcast, Hotmail, Yahoo, etc.

[akanevsky]

Yes, the GMAIL does not correctly work with HTML e-mails.

[Logikos]

I've been using my own version of this for awhile now and noticed that not many Email Providers accept any CSS. Your best bet is to use the style="" attribute. The template I've been using to send emails that are formated nicely is the following.


<br />
<table border="0" width="80%" cellpadding="0" cellspacing="0" align="center" style="border: 1px solid #334676;">
<tr>
<td>

<table border="0" width="100%" cellpadding="0" cellspacing="0" align="center">
<tr>
<td><img src="http://www.vbhackers.com/forum/images/misc/vbulletin_hackers_logo.gif"></td>
</tr>
<tr>
<td valign="top" style="background: #405384;">&nbsp;</td>
</tr>
</table>


<table border="0" width="100%" cellpadding="1" cellspacing="6" align="center">
<tr>
<td class="alt2">

<div style="font: 11px verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif;"><strong>New Title</strong></div>
<br />
<div style="font: 11px verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif;">
Some Text Here
</div>

</td>
</tr>
</table>
</td>
</tr>
</table>
<br />


Notice the style="" attribute being used alot there. You cab basily use any CSS commands in the style attribute for that giving <table>, or <td>. You can see the howto here: http://www.vbhackers.com/forum/showthread.php?t=3840.

[akanevsky]

Thanks for the tip, LiveWire.

[MSheraz86]

Interesting info livewire, where would I insert that style="" attribute? which file are you referring to? :p

I'm using the Silver PS3 style for my forum, maybe that's why hotmail users couldn't get the email while yahoo and gmail users can! I'll need to check this to be sure so please let me know where I could insert this style="" attribute :) thanks.

[Logikos]

Well for example...

<table>
<tr>
<td style="background: #405384;">&nbsp;</td>
</tr>
</table>


This will make it so the background color is set to #405384 using the style attribute.

[MSheraz86]

Yes but which template or file am I to enter that into? :)

[Logikos]

I belive the template name in this hack is called 'HTMAIL'.

[MSheraz86]

Found it, made few adjustments yet no possibility of hotmail users getting the email.

I usually figure out these minor issues but this one seems to be out of my understanding. I'm almost near to uninstalling this mod, that's something I just don't wish to do. Is there not anything that I am missing out?

Forum software is correct, Every installation step was taken as according to the guide, no mistakes whatsoever. I don't get why everybody else is able to email hotmail users while i'm the only one around here stuck with this problem of hotmail users not getting the email :(

Surely there has to be a solution for this.

[Kirk Y]

Interesting thing is that I get emails from Playstation Underground all the time and they're formatted with CSS and always show fine. What's Sony doing right that we're not? Dang Japanese...

[TCB]

Is the same 'sent email to users' box used for html and non-html mails?

And when you select all users to sent an email to, type non-html text in the box and sent it. The people without the 'receive html emails' tagged will receive the flat text version, and the people with it enabled will receive the same text, but using the htmail template?

And what happens when you paste an html text in the box and sent it to all users. What do the people receive that haven't enabled the 'receive html emails' option?

[akanevsky]

Is the same 'sent email to users' box used for html and non-html mails?

Yes.

Currently, if you have any HTML, it'll be in the text version. Other than that, a plaintext version, as usual, will be received.

[manuka]

Hey, does this hack support mail to multiple groups or lists?

And does it have a bounce handle feature to sort the weed from the chaff?

[akanevsky]

I don't know what you are talking about. This mod integrated into vB's admincp "send e-mails" page, the only thing it changes is that text e-mails become html. Whatever else you have installed should continue working.

[manuka]

It's ok - I found what I was looking for... I'll still look at installing this though. Seems very useful at this stage!

[Jesus Chio]

I can not make it work.

I edited the email file with the 2 mods, edited the two templates, uploaded the file...

Do I have to change permissons or something else?

And I am getting this error:


Database error in vBulletin 3.5.1:

Invalid SQL:

SELECT user.userid, user.usergroupid, user.username, user.email, user.joindate, user.htmail,
useractivation.activationid
FROM user AS user
LEFT JOIN userfield AS userfield ON (userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid)
LEFT JOIN useractivation AS useractivation ON (useractivation.userid = user.userid AND useractivation.type = 0)
WHERE
1=1 AND user.username = 'xxxxx' AND (user.usergroupid = 6)
AND user.email <> ''
AND (options & 16)
ORDER BY userid
LIMIT 0, 500;

MySQL Error : Unknown column 'user.htmail' in 'field list'
Error Number : 1054
Date : Wednesday, August 2nd 2006 @ 07:34:56 PM
Script : http://www./foros/admincp/email.php
Referrer : http://www./foros/admincp/email.php?do=start
IP Address : xxxxx
Username :xxxx
Classname : vb_database

[newbe_haselina]

Hi there,

can you please help a newbe :cross-eyed: ?

I just installed the hack and at least there is no error message. But anyhow either I understand the functionallity wrong, or I am doing something stupid.

Just sent out a mail over "send Email to user" in the AdminCP. Put in some "test-text" but the email looks as a plaintext one. Can you help me and tell me how to use this hack? I thought the emails would look like my forum-style, somehow?

Thanks a lot in advance for helping me,
Kind regards
sabine

[rollo tamasi]

How can you set it so that the "receive html emails" box is automatically ticked?
/installed

[akanevsky]

On registration?

[Eagle Creek]

WOW!

Loveley!

Thankyou!

I will install!

[GreysAnatomy]

I used to have this installed on my forum but I've upgraded to vB 3.6 recently. Will it work there too or are you planning on updating?

[akanevsky]

Should work with 3.6.

[GreysAnatomy]

I installed it on 3.6 but couldn't find the modification in the register template, so I didn't do this step. But still, the box in the AdminCP where I used to check or uncheck 'HTML Email' still won't show up.

All the other steps were done as explained.

--------------------------
Me again. I managed to find the code inside the register template [vB 3.6]:

<tr>
<td>
$vbphrase[administrators_may_send_email]
</td>
</tr>

I just added the hack codes above and everything is working fine. Just thought I'd let you know.

The checkbox inside the AdminCP still doesn't show up though.

[DeeperImage]

Is this compatible with 3.6 Gold yet?

[GreysAnatomy]

Wasn't on my 3.6.0, so I assume it isn't.

[FamilyCorner]

UPDATE user SET htmail = 1

I have a question about this. I don't have access to MYSQL, that's all done by my server guy. Is there a way to run this query and reset all users to HTML email through the admin panel instead? I see under Maintenance there is an option called Execute SQL Query, but I don't dare do it until I know for sure as it says "Once a query is executed it can not be reversed". Any help on this would be MOST appreciated!

2nd question: I am assuming you need to paste the raw html into the message box if you want anything in your email to be bold, color, or hyperlinked. Is that assumption correct? I tested that and it works fine, however when I switched back to plain text on my user account and did the text again, I am not getting regular plain text, I am receiving raw html in the email text. What I would like to do (bold, color and all that doesn't really matter) is be able to link the title of a thread so that I don't have to include the hyperlink separately. For example, I would like it to look like this:

Thread title here (http://www.hyperlinkofthreadhere.com)
Thread description, blah blah blah blah blah
blah blah blah blah blah blah blah blah


instead of this, which is what I currently do in plain text:

Thread title here
Thread description, blah blah blah blah blah
blah blah blah blah blah blah blah blah
http://www.hyperlinkofthreadhere.com

Thanks for the great hack, I hope this will work for me! :)

[akanevsky]

I have a question about this. I don't have access to MYSQL, that's all done by my server guy. Is there a way to run this query and reset all users to HTML email through the admin panel instead? I see under Maintenance there is an option called Execute SQL Query, but I don't dare do it until I know for sure as it says "Once a query is executed it can not be reversed". Any help on this would be MOST appreciated!

That's correct, no query can be reverted. It is safe to run the query through there though.

[FamilyCorner]

2nd question: I am assuming you need to paste the raw html into the message box if you want anything in your email to be bold, color, or hyperlinked. Is that assumption correct? I tested that and it works fine, however when I switched back to plain text on my user account and did the text again, I am not getting regular plain text, I am receiving raw html in the email text. What I would like to do (bold, color and all that doesn't really matter) is be able to link the title of a thread so that I don't have to include the hyperlink separately. For example, I would like it to look like this:

Thread title here (http://www.hyperlinkofthreadhere.com)
Thread description, blah blah blah blah blah
blah blah blah blah blah blah blah blah


instead of this, which is what I currently do in plain text:

Thread title here
Thread description, blah blah blah blah blah
blah blah blah blah blah blah blah blah
http://www.hyperlinkofthreadhere.com

Thanks for the great hack, I hope this will work for me! :)

Thanks very much for the answer regarding the SQL query! :)

Any idea the answer to the question above? Again thanks!

[Khamis]

Hello,
thank you for this nice hack. Actually, I'm looking for some Modifications, I hope you can help me with it!

1) I would like everyone receive HTML email (there is no option!), and it should apply to everyone, so I don't need to ask them to change to html!

2) Activation email, can you make it also wrok with HTML!

3)How can I totally change the email templates!

Thank you,
Khamis

[FamilyCorner]

But still, the box in the AdminCP where I used to check or uncheck 'HTML Email' still won't show up.

Just thought I'd let you know.The checkbox inside the AdminCP still doesn't show up though.

I think this might be one of my problems. I do not see any option in the admin panel when sending an email to users to select html or plain text. So I was just assuming that I had to code in raw html. Am I missing something?

I am running 3.5.1 and have set my admin panel to every skin there is including VB 2 Default and none have this option. Please help, I would love to start using this! :)

[FamilyCorner]

I am running 3.5.1 .....

Sorry, me again :( Is this why I am having trouble with this? Because I am still running 3.5.1?

[Khamis]

I think this might be one of my problems. I do not see any option in the admin panel when sending an email to users to select html or plain text. So I was just assuming that I had to code in raw html. Am I missing something?

I am running 3.5.1 and have set my admin panel to every skin there is including VB 2 Default and none have this option. Please help, I would love to start using this! :)

Aslo me, I'm running 3.5.5 :)

[dutchbb]

Just installed this on a 3.6 board, but what is changed in admincp? Where can I send the html emails please?

Thank you

[GreysAnatomy]

It didn't work on my 3.6.0 board. There should be another box right below the one where you put in the content, a box where you can choose if you wanna send out HTML or normal email. But that box doesn't appear in 3.6.0, sadly. :(

[dutchbb]

Too bad, well let's hope this will be ported soon.

[GreysAnatomy]

I've searched like a mad person and finally found the hack that was posted over at vB Hackers. Try this link (http://www.vbhackers.com/forum/showthread.php?t=3850), worked perfectly fine for me.

[navjotjsingh]

I've searched like a mad person and finally found the hack that was posted over at vB Hackers. Try this link (http://www.vbhackers.com/forum/showthread.php?t=3850), worked perfectly fine for me.

This mod is here also at vbulletin.org: https://vborg.vbsupport.ru/showthread.php?t=99910

And no need for changing the code..the same code will work for 3.6.0!

[FamilyCorner]

I think this might be one of my problems. I do not see any option in the admin panel when sending an email to users to select html or plain text. So I was just assuming that I had to code in raw html. Am I missing something?

I am running 3.5.1 and have set my admin panel to every skin there is including VB 2 Default and none have this option. Please help, I would love to start using this! :)

I didn't see an answer to this yet. Is it possible to use this effectively in 3.5.1? I am not quite ready to upgrade to 3.6 yet, so any help would be appreciated :)

[akanevsky]

This mod is here also at vbulletin.org: https://vborg.vbsupport.ru/showthread.php?t=99910

And no need for changing the code..the same code will work for 3.6.0!

That's not the same hack though. It has less features.

I didn't see an answer to this yet. Is it possible to use this effectively in 3.5.1? I am not quite ready to upgrade to 3.6 yet, so any help would be appreciated :)

This hack should work fine on 3.5.1.

[navjotjsingh]

So will your mod then work with 3.6.0 also?

[FamilyCorner]

This hack should work fine on 3.5.1.

Well it installed just fine and I can send html email, but the problem is that there isn't anything in the control panel that gives me the option to choose whether I want to send plain text or html. So if I paste in the raw html it's fine, however, then the plain text users get a bunch of raw html in their mailbox. If I send it plain text without any html coding, the html users get it but the links don't work.

Is there supposed to be something in the control panel, like is the text box where you put the message, is that supposed to have a WYSIWYG editor or something?

I have a feeling something is missing because the way it stands now I can't use it. :(

[akanevsky]

Yes, this hack is not really finished... Unfortunately, I don't have time fix the few issues that it has right now, but I will when I can.

[FamilyCorner]

.... deleted (oops) LOL

[FamilyCorner]

Yes, this hack is not really finished... Unfortunately, I don't have time fix the few issues that it has right now, but I will when I can.

Well I'm relieved it wasn't something I had done :) I will stay subscribed and watch for updates. Thank you for all you do!

[kpr]

Works a treat thanks.

[Snake]

I hope this is going to work on 3.6 too.

[The Chief]

Does this work with 3.6??

[lafsunlmtd]

i am using 3.62 and it doesn't show any check box for it in the admincp. any help

[The Chief]

i am using 3.62 and it doesn't show any check box for it in the admincp. any help
It isn't supposed to show any checkbox...

[darkdiver]

ok, now can somebody tell me if this hack works with 3.6.2?

Thank you
Eric

[lange]

Any idea if this will work in 3.6.3?

[Barakat]

yes works also on 3.6.3

[navjotjsingh]

Nope it does not work since no checkbox is shown in admin panel to select HTML or Plain Text mail! Anybody knows here to how to show checkbox in 3.6.4?

[akanevsky]

It is not supposed to show any checkbox.

[navjotjsingh]

Then that means...we have no control whether to send Plain Text or HTML emails?

[Eagle Creek]

I want to make receive HTML ENABLED for all my current users. What query do I need to do this?

Btw, there's no such thing as "<if condition="$vboptions['enableemail']">" in the register template...

[GreysAnatomy]

I want to make receive HTML ENABLED for all my current users. What query do I need to do this?

Btw, there's no such thing as "<if condition="$vboptions['enableemail']">" in the register template...


I'm having the exact same question/problem. I'm using 3.6.4 and have had no problems finding the rest though.

Since it's "only" the Register template, I assume the hack should work anyway. But it doesn't... I sent a few test email to myself and they all came as plain text. I have the "receive html mails" checked and my email client also shows html mails, so that shouldn't be the problem. :o Can anyone help me here? Please? :confused: