| Author |
|
sterl16
Newbie
Joined: 06 April 2021
Location: United States
Online Status: Offline
Posts: 1
|
| Posted: 06 April 2021 at 4:34pm | IP Logged
|
|
|
What table and columns are the email signatures stored in? I want to create email signatures for all users, the include their name. Global Signature will not achieve this.
|
| Back to Top |
|
| |
Igor
AfterLogic Support
Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6038
|
| Posted: 07 April 2021 at 12:57am | IP Logged
|
|
|
Account signatures are stored in au_eav_attributes_mediumblob database table. Please note that we're using EAV data storage model, and you can browse the database with built-in EAV viewer. You'll find signatures there when browsing "Mail Classes Account" section.
--
Regards,
Igor, Afterlogic Support
|
| Back to Top |
|
| |
Igor
AfterLogic Support
Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6038
|
| Posted: 07 April 2021 at 2:20am | IP Logged
|
|
|
Just wanted to add that, if you wish to manage identities, it's probably best to do that via PHP API of WebMail Pro, there's UpdateSignature method you can use.
You can find a sample of handing identities with PHP API at: Managing identities with PHP API
And as you can find with EAV viewer, there's default HTML code signature is wrapped into - we recommend keeping it that way so the signature can be used and edited in Settings as expected.
Code:
| <div data-crea="font-wrapper" style="font-family: Tahoma, sans-serif; font-size: 16px; direction: ltr">...<div></div></div> |
|
|
--
Regards,
Igor, Afterlogic Support
|
| Back to Top |
|
| |
MailBee.NET Objects 
MailBee.NET Queue 
MailBee Objects 
WebMail Pro PHP 
AfterLogic Aurora 
MailSuite Pro for Linux 
Unified Messaging Solution 
Search
Register
Login
Topic: Email Signatures in the Database
Privacy policy |
Refund policy