DragonByte Tech | vBulletin Mods & Addons - Powered by vBulletin





User Tag List

Page 1 of 2 12 Last
Results 1 to 10 of 12

Thread: Recalculating Points


Forum: vBActivity & Awards Lite Support

Questions & Answers for vBActivity & Awards.
Click here to buy!

  1. #1
    Junior Member
    Level 0 (0 Loyalty Points)
    Blizzard Opb's Avatar
    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    May 2014
    Posts
    10
    Rep Power
    0

    Default Recalculating Points

    We have a very large forum and want to implement vBActivity properly. I have the plugin installed and set-up, but since the plugin recalculates points for each user the process is extremely slow, slow enough for my admin login to timeout and the process to halt at around 980th user. I would like to know if there is a way I can make this recalculation process faster, or attempt it using a script? Or if there is a way to recalculate points for more users in a single process.

    Also, explanation of the following line: Number of users to process per cycle
    The word "cycle" in this entry is the cycle I am running for the entire recalculation, meaning if I enter like 50 users in there, will only first 50 users be processed? Or does the word "cycle" means the process thing that happens; "Processing: 1" (meaning 50 users in that process, or is it only 1 user in one process?

    So, my question is, if I want to process like 12,000 users, should I set the value to 12,000, or processing 50 each cycle will work just fine and recalculate 50 uses each process until it recalculates all 12,000?

    Thanks for the help, and great job with the plugin!
    0 0 0
     
    Recalculating Points Send PM  

  2. #2
    Junior Member
    Level 0 (0 Loyalty Points)
    Blizzard Opb's Avatar
    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    May 2014
    Posts
    10
    Rep Power
    0

    Default

    Update; So, turns out it wasn't that my login timed-out. The process actually stops at 980th user.

    Code:
    Processing: 980
    totalpoints
    activitylevel
    albumpictures
    attachments
    attachmentviews
    post
    post_own
    thread
    threadrating
    threadratingreceived
    vmgiven
    vmreceived
    pollposted
    pollvote
    friend
    givenrep
    gottenrep
    infractiongiven
    infractionreceived
    referral
    sgmessage
    sgdiscussion
    calendarevent
    dayregistered
    lastvisit
    lastpost
    blogpost
    blogcomment
    shout
    mentionsgiven
    mentionsreceived
    tagsgiven
    tagsreceived
    ttbattledraw
    ttbattlewon
    ttbattlelost
    tttournywon
    tttrade
    profilecomplete
    contestswon
    contestprize
    registration
    dbgalleryupload
    awards
    totalpoints
    activitylevel
    albumpictures
    attachments
    attachmentviews
    post
    post_own
    thread
    0 0 0
     
    Recalculating Points Send PM  

  3. #3
    Founder
    Level 0 (0 Loyalty Points)
    Belazor's Avatar
    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Dec 2009
    Location
    Glasgow, United Kingdom
    Age
    30
    Posts
    27,738
    Blog Entries
    13
    Rep Power
    10

    Default

    Firstly, the number of users per page is just that; how many users it processes before redirecting to the next page. Setting this number lower helps keep the script from hitting php's Max Execution Time limit.

    Secondly, please make sure display_errors is turned on in your php.ini configuration. Without this, we have no way of knowing why the script terminates.
    Fillip Hannisdal
    Founder & Programming Director
    DragonByte Technologies http://www.DragonByte-Tech.com


    Please do not Private Message me with support requests or product questions. PMs are only for exchanging sensitive information (like FTP / AdminCP logins).
    Please do not Private Message me with business related queries (refunds, complaints, feedback, etc). Decado is the person to PM for those issues.
    Please do not Private Message Decado with support requests or forum errors.

    When I say "Hotfix Released" it means you should re-download the product and re-upload the files.
    Like our products? Want to be notified on social media networks when we release updates or new products? Click the buttons below to Like us on Facebook, Follow us on Twitter and Follow us on Google+!
    1 0 0
     
    Recalculating Points Send PM  

  4. #4
    Junior Member
    Level 0 (0 Loyalty Points)
    Blizzard Opb's Avatar
    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    May 2014
    Posts
    10
    Rep Power
    0

    Default

    Quote Originally Posted by Belazor View Post
    Firstly, the number of users per page is just that; how many users it processes before redirecting to the next page. Setting this number lower helps keep the script from hitting php's Max Execution Time limit.

    Secondly, please make sure display_errors is turned on in your php.ini configuration. Without this, we have no way of knowing why the script terminates.
    I will try it out with a smaller number. First, I was getting a db-error during the recalculation, it somehow tried to insert multiple values for the same user in the points table, to test it out, I changed the primary key in the database to another id which auto incremented, but i am not yet sure what things would go wrong if that is done. My idea was to manually get rid of multiple userid entries in the userid table once it was completed, and then delete id and make userid primary again.

    What do you suggest? Also, is there a command line method for this?
    0 0 0
     
    Recalculating Points Send PM  

  5. #5
    Junior Member
    Level 0 (0 Loyalty Points)
    Blizzard Opb's Avatar
    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    May 2014
    Posts
    10
    Rep Power
    0

    Default

    It worked, after approx 19 hours, all users' points were calculated. @Belazor; A new issue is that the trophy didn't readjust. Some users shouldn't have those as others now have more points, what do you suggest for that? And thanks for the help!
    0 0 0
     
    Recalculating Points Send PM  

  6. #6
    Founder
    Level 0 (0 Loyalty Points)
    Belazor's Avatar
    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Dec 2009
    Location
    Glasgow, United Kingdom
    Age
    30
    Posts
    27,738
    Blog Entries
    13
    Rep Power
    10

    Default

    Trophies are automatically re-checked every 24 hours
    Fillip Hannisdal
    Founder & Programming Director
    DragonByte Technologies http://www.DragonByte-Tech.com


    Please do not Private Message me with support requests or product questions. PMs are only for exchanging sensitive information (like FTP / AdminCP logins).
    Please do not Private Message me with business related queries (refunds, complaints, feedback, etc). Decado is the person to PM for those issues.
    Please do not Private Message Decado with support requests or forum errors.

    When I say "Hotfix Released" it means you should re-download the product and re-upload the files.
    Like our products? Want to be notified on social media networks when we release updates or new products? Click the buttons below to Like us on Facebook, Follow us on Twitter and Follow us on Google+!
    0 1 0
     
    Recalculating Points Send PM  

  7. #7
    Junior Member
    Level 0 (0 Loyalty Points)
    Blizzard Opb's Avatar
    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    May 2014
    Posts
    10
    Rep Power
    0

    Default

    Quote Originally Posted by Belazor View Post
    Trophies are automatically re-checked every 24 hours
    Awesome, thanks a lot!
    Looking forward to the following things if they're every developed:
    Command line points recalculation.
    Individual user/Range of users point recalculation; instead of going through the entire list.
    0 0 0
     
    Recalculating Points Send PM  

  8. #8
    Founder
    Level 0 (0 Loyalty Points)
    Belazor's Avatar
    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Dec 2009
    Location
    Glasgow, United Kingdom
    Age
    30
    Posts
    27,738
    Blog Entries
    13
    Rep Power
    10

    Default

    Command line recalculation is already a feature, check the "do not upload" folder
    Fillip Hannisdal
    Founder & Programming Director
    DragonByte Technologies http://www.DragonByte-Tech.com


    Please do not Private Message me with support requests or product questions. PMs are only for exchanging sensitive information (like FTP / AdminCP logins).
    Please do not Private Message me with business related queries (refunds, complaints, feedback, etc). Decado is the person to PM for those issues.
    Please do not Private Message Decado with support requests or forum errors.

    When I say "Hotfix Released" it means you should re-download the product and re-upload the files.
    Like our products? Want to be notified on social media networks when we release updates or new products? Click the buttons below to Like us on Facebook, Follow us on Twitter and Follow us on Google+!
    0 0 0
     
    Recalculating Points Send PM  

  9. #9
    Junior Member
    Level 0 (0 Loyalty Points)
    Blizzard Opb's Avatar
    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    May 2014
    Posts
    10
    Rep Power
    0

    Default

    Quote Originally Posted by Belazor View Post
    Command line recalculation is already a feature, check the "do not upload" folder
    Great, sorry, I just noticed. Sorry to keep bugging you with questions, but can you exactly tell me where can I find the css file for vBactivity? I would like to edit the awards in the post-bit but they are not as a template in the forums I think. I didn't do the initial installation so I am not familiar about the raw files that it came with.
    0 0 0
     
    Recalculating Points Send PM  

  10. #10
    Founder
    Level 0 (0 Loyalty Points)
    Belazor's Avatar
    User InfoThanks / Tagging InfoGifts / Achievements / AwardsActivity Stats
    Join Date
    Dec 2009
    Location
    Glasgow, United Kingdom
    Age
    30
    Posts
    27,738
    Blog Entries
    13
    Rep Power
    10

    Default

    Styles & Templates -> CSS Templates
    Fillip Hannisdal
    Founder & Programming Director
    DragonByte Technologies http://www.DragonByte-Tech.com


    Please do not Private Message me with support requests or product questions. PMs are only for exchanging sensitive information (like FTP / AdminCP logins).
    Please do not Private Message me with business related queries (refunds, complaints, feedback, etc). Decado is the person to PM for those issues.
    Please do not Private Message Decado with support requests or forum errors.

    When I say "Hotfix Released" it means you should re-download the product and re-upload the files.
    Like our products? Want to be notified on social media networks when we release updates or new products? Click the buttons below to Like us on Facebook, Follow us on Twitter and Follow us on Google+!
    0 0 0
     
    Recalculating Points Send PM  

Page 1 of 2 12 Last

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [vB 4.2.x] Recalculating points issue
    By Bullmama DeLano in forum vBActivity & Awards Lite Support
    Replies: 5
    Last Post: 27th January 2014, 15:07

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
This website uses cookies
We use cookies to store session information to facilitate remembering your login information, to allow you to save website preferences, to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners.