Pretty Emails

https://www.phpbb.com/ideas/
Post Reply
User avatar
Dazbobaby
Registered User
Posts: 121
Joined: Fri Feb 13, 2009 7:02 pm
Name: Darron
Contact:

Pretty Emails

Post by Dazbobaby »

Emails are quite bland being text only. I would like to add the ability to customise outgoing emails with an image(s) and or emojis just to make things a little more interesting.

A custom email signature is already possible within the admin control panel, but images and emojis are not allowed, in fact emojis will actually break MYSQL, so a work around might be required for them.

I'm sure this would be a nice idea for a LOT of people.

TIA.
Daz.
User avatar
danieltj
Registered User
Posts: 208
Joined: Thu May 03, 2018 9:32 pm
Name: Daniel James
Contact:

Re: Pretty Emails

Post by danieltj »

It would be nice to have some kind of update to emails so they are a little bit more visual than what they currently are. The issue with text only emails is it's often hard to see what is an important part of an email like a link or a code.
User avatar
AmigoJack
Registered User
Posts: 6108
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Re: Pretty Emails

Post by AmigoJack »

Dazbobaby wrote: Tue Feb 02, 2021 1:37 pmbeing text only
...
emojis will actually break MYSQL
This is only partially true: emojis are only characters, too, and where not all Unicode planes are supported by phpBB's database tables (not bound to MySQL only) yet older ones are always available:

Code: Select all

☠️ ☹️ ☺️
But since e-mail templates are saved in text files you could try changing/augmenting them (in /language/*/email/*.txt, then flush the cache) with your favorite characters.
  • "The problem is probably not my English but you do not want to understand correctly. ... We will not come anybody anyway, nevertheless, it's best to shit this." Affin, 2018-11-20
  • "But this shit is not here for you. You can follow with your. Maybe the question, instead, was for you, who know, so you shoved us how you are." axe70, 2020-10-10
  • "My reaction is not to everyone, especially to you." Raptiye, 2021-02-28
User avatar
Dazbobaby
Registered User
Posts: 121
Joined: Fri Feb 13, 2009 7:02 pm
Name: Darron
Contact:

Re: Pretty Emails

Post by Dazbobaby »

AmigoJack wrote: Wed Feb 03, 2021 5:33 pm
Dazbobaby wrote: Tue Feb 02, 2021 1:37 pmbeing text only
...
emojis will actually break MYSQL
This is only partially true: emojis are only characters, too, and where not all Unicode planes are supported by phpBB's database tables (not bound to MySQL only) yet older ones are always available:

Code: Select all

☠️ ☹️ ☺️
But since e-mail templates are saved in text files you could try changing/augmenting them (in /language/*/email/*.txt, then flush the cache) with your favorite characters.
Sorry, I should elaborate, within ACP the email signature box, adding an emoji there, and I think that goes for ANY emoji, then it breaks MYSQL.
Screenshot_2021-02-03 Email settings.png
Screenshot_2021-02-03 Email settings.png (6.27 KiB) Viewed 1987 times

Code: Select all

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 1023
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 195
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 345
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/phpbb/config/db.php
LINE: 148
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/phpbb/config/db.php
LINE: 122
CALL: phpbb\config\db->set_atomic()

FILE: [ROOT]/includes/acp/acp_board.php
LINE: 614
CALL: phpbb\config\db->set()

FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: acp_board->main()

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()
All because I added a single smiley face.
User avatar
SpIdErPiGgY
Registered User
Posts: 189
Joined: Sun May 02, 2021 2:11 pm
Location: Erpe-Mere, Aalst, BE
Name: Andy Dm
Contact:

Re: Pretty Emails

Post by SpIdErPiGgY »

I would like to use html in mass emails. Yes there is an extension from "forumhulp", but it's very old.
phpBB NL Extension translations, also on request.
--> Click Here: Myarea51secrets.com <--
User avatar
Mick
Support Team Member
Support Team Member
Posts: 26505
Joined: Fri Aug 29, 2008 9:49 am

Re: Pretty Emails

Post by Mick »

I would add that the justification of the existing email templates needs sorting out as well, maybe even before the above is acted on.
  • "The more connected we get the more alone we become" - Kyle Broflovski©
  • "The good news is hell is just the product of a morbid human imagination.
    The bad news is, whatever humans can imagine, they can usually create.
    " - Harmony Cobel
User avatar
AmigoJack
Registered User
Posts: 6108
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Re: Pretty Emails

Post by AmigoJack »

Oh please - the database table collations just have to be set up correctly, which was available 6+ years ago in MySQL/MariaDB already and phpBB still only does it only homeopathically instead of everywhere. Likewise the database table column for storing the e-mail signature (should still be phpbb_config) could be fixed easily to accept every Unicode codepoint, including emojis.
  • "The problem is probably not my English but you do not want to understand correctly. ... We will not come anybody anyway, nevertheless, it's best to shit this." Affin, 2018-11-20
  • "But this shit is not here for you. You can follow with your. Maybe the question, instead, was for you, who know, so you shoved us how you are." axe70, 2020-10-10
  • "My reaction is not to everyone, especially to you." Raptiye, 2021-02-28
User avatar
3Di
I've Been Banned!
Posts: 17538
Joined: Mon Apr 04, 2005 11:09 pm
Location: I'm with Ukraine 🇺🇦
Name: Marco
Contact:

Re: Pretty Emails

Post by 3Di »

Fix Emoji for Email signature
https://github.com/phpbb/phpbb/pull/6210

(phpBB 3.3.3 or greater required)
🆓 Free support for our extensions also provided here: phpBB Studio
🚀 Looking for a specific feature or alternative option? We will rock you!
Please PM me only to request paid works. Thx. Buy me a coffee -> Image
My development's activity º PhpStorm's proud user º Extensions, Scripts, MOD porting, Update/Upgrades
Post Reply

Return to “phpBB Ideas”