1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.5 Can you view alert message text in the database?

Discussion in 'XenForo Questions and Support' started by CyclingTribe, Oct 13, 2015.

  1. CyclingTribe

    CyclingTribe Well-Known Member

    When you move a thread you can optionally add some text that will be sent as an alert to the thread starter.

    That alert message doesn't appear to be logged anywhere in the moderator log - so is there somewhere in the database I can recover / view it?

    Thanks,
    Shaun :D
     
  2. Mike

    Mike XenForo Developer Staff Member

    It's only stored in the actual alert (xf_user_alert table).
     
    CyclingTribe likes this.
  3. Chris D

    Chris D XenForo Developer Staff Member

    It would be stored as a blob in the extra_data field of the xf_user_alert table. It will look something like this:
    Code:
     a:3:{s:5:"title";s:32:"Hello! My useful thread is here!";s:4:"link";s:51:"index.php?threads/hello-my-useful-thread-is-here.3/";s:6:"reason";s:38:"I have moved your thread because I can";}
    This contains the title of the thread, the link to the thread and the reason given via the author alert.
     
    CyclingTribe likes this.
  4. CyclingTribe

    CyclingTribe Well-Known Member

    Thanks guys - I'll have a butchers! (y)

    Cheers,
    Shaun :D
     

Share This Page