Home Support Extensions Messages Message/Conversion ID in SQL

Message/Conversion ID in SQL

  • Author
    Posts
  • jreitter

    Dear Ihor,

    is there some sort of message/conversion ID in the database where I can filter complete conversations between users/vendors? I couldn’t see any?

    I often have to report logs to the police and it would be nice to quickly filter out conversations via sql.

    Kind regrds,
    Johannes

    ihor developer

    Yes, the current Messages version stores messages as comments of “hp_message” type in wp_comments table. The sender ID is stored in the user_id column, while the recipient ID is stored in the comment_karma column. This way you can filter messages between 2 users (via the SELECT query).

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.