Details about this thread
  • State Suggested Answer
  • Replies 3 replies
  • Answers 1 answer
  • Subscribers 313 subscribers
  • Views 964 views
  • Users 0 members are here
Related content from around SugarClub

Where to find the Default Email Signtature

Christopher Hart

In database, there is table names user_signatures which stores email signatures but there is no database field that stores default.

I also checked the table user_preferences table and decoded the data using 

unserialize(base64_decode($arr['contents'])) but could not find this.


is this stored in php dfirectly by any chance?

Thank you
Christopher Hart
 

Parents
  • 0 Sugar Employee Badge

    Hello  


    You are on the good path, this information is indeed stored in the user_preferences table. 
    Try searching for the user_preferences for a given user that you know has a default signature setup and category='global':

    SELECT * FROM `user_preferences`
where assigned_user_id='<yourUserID>' 
and category='global';



    After that, you have to Base64 decode the "contents" column content and you'll find the parameter signature_default that stores the ID of the default signature for a given user. 

    Let me know if this works for you. 

    Cheers, 

    André

Reply
  • 0 Sugar Employee Badge

    Hello  


    You are on the good path, this information is indeed stored in the user_preferences table. 
    Try searching for the user_preferences for a given user that you know has a default signature setup and category='global':

    SELECT * FROM `user_preferences`
where assigned_user_id='<yourUserID>' 
and category='global';



    After that, you have to Base64 decode the "contents" column content and you'll find the parameter signature_default that stores the ID of the default signature for a given user. 

    Let me know if this works for you. 

    Cheers, 

    André

Children