Blog Documentation Book a Demo
Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

Query for messages

2»

Comments

  • dotmikodotmiko New

    Sorry, I was on leave for the holy week. Anyways I just wanted to know on how many users have that user actually replied to regardless of the content of the message that he sent.

    Like:

    200 received messages
    100 read messages
    50 of which, he replied to.

  • peregrineperegrine MVP

    x00's way is probably more efficient if it is done frequently.

    If you ran something in cron you could use

    It would be a bit of a performance buster
    but you could

    loop

    through users with shadowdares second solution

    • If you need to retrieve how many conversations a user has responded to, with SQL Count

    but you could loop through users with shadowdares second solution

    replied to number
    here - http://vanillaforums.org/discussion/comment/178786/#Comment_178786

    and you said you already had solutions for receive and read.

    I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

Sign In or Register to comment.