Announcement

Collapse
No announcement yet.

Neg rep - querying individual reps

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Neg rep - querying individual reps

    I wondered if anyone knew how to query just individual negative reputations. The query in Admin CP > User Reputation> View Reputation Comments is by user.

    What I'm looking for ... I'd like to be able to query only negative reputations given out during a certain period of time.

    Is this the kind of question that should go to vb.org?

    thanks!

  • #2
    You can search by user and date in your:

    Admin CP -> User Reputations -> View Reputation Comments

    But there is no option to limit the results to negative rep.

    This query will return all negative reputations:

    SELECT *
    FROM reputation
    WHERE reputation < 0

    Comment


    • #3
      That works, thank you. Is there a way to limit date? Also I don't know how to read "dateline." The clue I see to date in this query is the post number. Thanks again!

      I don't know what user I'm looking for until I see the neg reps, and see if particular members are regularly on the receiving end (and awarding end as well.)

      Comment


      • #4
        SELECT *
        FROM reputation
        WHERE reputation < 0
        AND dateline > UNIX_TIMESTAMP('2006-10-20 00:00:00')
        AND dateline < UNIX_TIMESTAMP('2008-10-20 00:00:00')

        Use any date bounds you want.

        Comment

        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
        Working...
        X