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

[CTXMedia]

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

 

[Mike]

It's only stored in the actual alert (xf_user_alert table).

 

[Chris D]

It would be stored as a blob in the extra_data field of the xf_user_alert table. It will look something like this:

 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.

 

[CTXMedia]

Thanks guys - I'll have a butchers!

Cheers,
Shaun