Status
Not open for further replies.
Website
http://www.narutobase.net/
Product version
3.1.4
Forum version
vBulletin 4.2.x
#1
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!
 
#2
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
 

Belazor

Staff member
Owner
Developer
Customer
#3
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.
 
#4
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?
 
#5
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!
 
#7
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.
 
#9
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.
 
#11
Styles & Templates -> CSS Templates :)
Well, I know about that but the thing I want to change is style incorporated in the file, like so:

Code:
element.style {
border: 1px solid #6b91ab;
padding: 6px;
margin: 6px;
To change the <fieldset> style, I need to find the file in which its hard coded. It is the award border thing.

Code:
<fieldset style="border:1px solid #6b91ab; padding:6px; margin:6px;">
Is there a way to overwrite that?
 

Belazor

Staff member
Owner
Developer
Customer
#12
You can search for the code you posted in the templates and find the resulting template, then edit it directly from there.
 
Status
Not open for further replies.

vBActivity & Awards

vBulletin 3.8.x vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
1,655
Customer rating
0.00 star(s) 0 ratings
Top