Administrative and Maintenance Tools - Send HTML Email to Users

/*================================================= =====================*\
|| Send HTML Email to Users
||
|| ================================================== =====
|| Brought to you by:
|| VisionScripts
|| 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

[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.