Pretty Emails

https://www.phpbb.com/ideas/
Post Reply
User avatar
Dazbobaby
Registered User
Posts: 95
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.
DJ-Daz tutorials 🎧DJ-Daz.com🎧
danieltj
Registered User
Posts: 16
Joined: Thu May 03, 2018 9:32 pm
Name: Daniel James

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: 5841
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Re: Pretty Emails

Post by AmigoJack »

Dazbobaby wrote:
Tue Feb 02, 2021 1:37 pm
being 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: 95
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 pm
being 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 281 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.
DJ-Daz tutorials 🎧DJ-Daz.com🎧
Post Reply

Return to “phpBB Ideas”