Search The ForumSearch   RegisterRegister  LoginLogin

AfterLogic WebMail Pro

 AfterLogic Forum : AfterLogic WebMail Pro
Subject Topic: Email Signatures in the Database Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
sterl16
Newbie
Newbie
Avatar

Joined: 06 April 2021
Location: United States
Online Status: Offline
Posts: 1
Posted: 06 April 2021 at 4:34pm | IP Logged Quote sterl16

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 View sterl16's Profile Search for other posts by sterl16
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
Posted: 07 April 2021 at 12:57am | IP Logged Quote Igor

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 View Igor's Profile Search for other posts by Igor
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
Posted: 07 April 2021 at 2:20am | IP Logged Quote Igor

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 View Igor's Profile Search for other posts by Igor
 

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

  Post ReplyPost New Topic
Printable version Printable version

Forum Jump

Powered by Web Wiz Forums version 7.9
Copyright ©2001-2004 Web Wiz Guide