Announcement

Collapse
No announcement yet.

Reset or prune reputation

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

  • LCD_Angel
    replied
    Thanks guys! That worked great! Now I just need my question in the other thread addressed about how to diable multiple usergroups from posting.

    Leave a comment:


  • Jake Bunce
    replied
    You should be fine on 56k. The query should be fast. Rebuilding the reputations might take some time. All of the processing is done on the server.

    Leave a comment:


  • LCD_Angel
    replied
    That worked. Now I only have to run the query.

    Would that be okay to do on 56k with 19,000 users? Does the server "do all the work" so to speak.

    Also, would rebuilding the reputations be unwise on 56k? (I know some processes require that the browser go through all 19,000 members.

    Leave a comment:


  • Jake Bunce
    replied
    Enter your userid into your includes/config.php file:

    // ****** USERS WITH QUERY RUNNING PERMISSIONS ******
    // The users specified here will be allowed to run queries from the control panel.
    // See the above entries for more information on the format.
    // Please note that the ability to run queries is quite powerful. You may wish
    // to remove all user IDs from this list for security reasons.
    $canrunqueries = '';

    Leave a comment:


  • LCD_Angel
    replied
    How do I give myself permission to execute MySql queries via control panel?



    Originally posted by Jake Bunce
    First you need to delete all current reputation points given by users. Run this query on your database:

    DELETE FROM reputation WHERE 1

    Backup first! If you use table prefixes then you need to change reputation to include the prefix.

    Then set a base reputation value in your:

    Admin CP -> vBulletin Options -> User Reputation Options -> Default Reputation

    Then rebuild your reputations:

    Admin CP -> Import & Maintenance -> Update Counters -> Rebuild User Reputation

    Leave a comment:


  • wential
    replied
    Originally posted by Jake Bunce
    Run this query instead:

    DELETE FROM reputation WHERE dateline < 1085074901

    That should work. Backup first!

    1085074901 is the timestamp for 30 days ago as of today. This is not a relative number. So if you need to run this query again later on you will need a new timestamp for 30 days ago as of that day.
    I'll stop here since this isn't the place for it. Thanks to you guys I came up with this. I just wanted to show you the results of your appreciated assistance.
    DELETE FROM reputation WHERE dateline < (TIMENOW - (86400 * 30))

    Leave a comment:


  • wential
    replied
    Wow, you guys are good and fast. Thanks!

    Leave a comment:


  • Freddie Bingham
    replied
    Try this one..

    DELETE FROM reputation WHERE dateline < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 1 MONTH))

    Leave a comment:


  • Jake Bunce
    replied
    Originally posted by wential
    Can you alter this script to only prune Reputation over 30 days old?
    Run this query instead:

    DELETE FROM reputation WHERE dateline < 1085074901

    That should work. Backup first!

    1085074901 is the timestamp for 30 days ago as of today. This is not a relative number. So if you need to run this query again later on you will need a new timestamp for 30 days ago as of that day.

    Leave a comment:


  • Steve Machol
    replied
    That requires modifying the code. Try asking at vbulletin.org.

    Leave a comment:


  • wential
    replied
    Originally posted by Jake Bunce
    First you need to delete all current reputation points given by users. Run this query on your database:

    DELETE FROM reputation WHERE 1

    Backup first! If you use table prefixes then you need to change reputation to include the prefix.

    Then set a base reputation value in your:

    Admin CP -> vBulletin Options -> User Reputation Options -> Default Reputation

    Then rebuild your reputations:

    Admin CP -> Import & Maintenance -> Update Counters -> Rebuild User Reputation
    Can you alter this script to only prune Reputation over 30 days old?

    Leave a comment:


  • kie
    replied
    Thank you!

    Leave a comment:


  • Jake Bunce
    replied
    First you need to delete all current reputation points given by users. Run this query on your database:

    DELETE FROM reputation WHERE 1

    Backup first! If you use table prefixes then you need to change reputation to include the prefix.

    Then set a base reputation value in your:

    Admin CP -> vBulletin Options -> User Reputation Options -> Default Reputation

    Then rebuild your reputations:

    Admin CP -> Import & Maintenance -> Update Counters -> Rebuild User Reputation

    Leave a comment:


  • kie
    started a topic Reset or prune reputation

    Reset or prune reputation

    I want to reset the reputationlevel for everyone on my board.

    How do I do that?
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X