Announcement

Collapse
No announcement yet.

Total Of All Reputation Points / Remove Reputation For Deleted Posts

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

  • Total Of All Reputation Points / Remove Reputation For Deleted Posts

    Hi all, 2 questions here:

    Is there an SQL Query to see how many total reputation poitns there are across all users. (I want an added total).

    Also, if a post is deleted, does the associated reputation comments (and points) get deleted as well. If not, is there an SQL query for that too?

    Thanks!
    -Hastin

  • #2
    Originally posted by Hastin
    Is there an SQL Query to see how many total reputation poitns there are across all users. (I want an added total).
    This should work:

    Code:
    SELECT SUM(reputation) AS totalrep
    FROM reputation
    Originally posted by Hastin
    Also, if a post is deleted, does the associated reputation comments (and points) get deleted as well. If not, is there an SQL query for that too?
    Yes, but only on physical deletion. I just tested this.

    Comment


    • #3
      Thanks! (As always!)

      -Hastin

      Comment

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