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.

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

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

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

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

On registration?

WOW!

Loveley!

Thankyou!

I will install!

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?

Should work with 3.6.

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]:

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.

Is this compatible with 3.6 Gold yet?

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

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
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! :)

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

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

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

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

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! :)

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

Aslo me, I'm running 3.5.5 :)

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

Thank you

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. :(

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

I've searched like a mad person and finally found the hack that was posted over at vB Hackers. Try this link, 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!

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 :)

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

This hack should work fine on 3.5.1.

So will your mod then work with 3.6.0 also?

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. :(

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.

.... deleted (oops) LOL

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!

Works a treat thanks.

I hope this is going to work on 3.6 too.

Does this work with 3.6??

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

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

Thank you
Eric

Any idea if this will work in 3.6.3?

yes works also on 3.6.3

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?