Question Updating Past Activity

[XGC Paravain]

Im wondering how to update my members past activity?

 

[Ozzy47]

Are you wanting to recalculate all points the users have?

 

[XGC Paravain]

Yes, I just installed and just got it running last night and would like to give every one the points for the last past year

 

[Ozzy47]

You can try Maintenance/Recalculate Points, under the DBTech - vBActivity menu in the ACP

Note: This is a server intensive process.

Recalculate Points: Here you can choose to recalculate all the points of every user. This resets them back to ‘0’ (including their levels) and the recounts everything, meaning some users may lose points (dependent on changes in the forum since the last change). It is a very server intensive process. You are asked to confirm you want to proceed first of all. Next you are asked for the Number of users to process per cycle. A low figure here will help keep the pressure off the server. The next option is for the Start Date, which is the date you want to start recalculating from. Often this is best being the start of the forum board, but that may not always be the case depending on what you wish to reset.

 

[XGC Paravain]

Ok thanks I will check that out but first I think I should work out the other issue im having

 

[XGC Paravain]

The points Recalculate that did work but the achievements wont recalculate for some reason its not giving members the achievements they already earned

 

[Fillip H.]

Click Recalculate Achievements

 

[XGC Paravain]

Click Recalculate Achievements

I have done that and I still don't have some of the achievements that I have earned But I will try again i just upgraded to the Pro

 

[Fillip H.]

If you've bought Pro, you should probably delete your existing achievements / criteria / etc and import the provided achievement set - that's known to work, and gets rid of any potential configuration issues

 

[XGC Paravain]

Are you seeing with the Pro it already has the achievements set up? like the trophies were I noticed?

 

[XGC Paravain]

Delete Category also?

 

[XGC Paravain]

If you've bought Pro, you should probably delete your existing achievements / criteria / etc and import the provided achievement set - that's known to work, and gets rid of any potential configuration issues

Ok thats done and that is awesome that will save me so much time thanks

But achievement notification still wont go away

 

[Fillip H.]

Are you talking about the one in vBulletin? If so, you can make it go away by clicking on it so it takes you to your profile

 

[XGC Paravain]

I do but it does not go away I been clicking on it ever since I uploaded the lite version it just keeps going up it started with 2 new achievements then 4 then 6 now 7 lol here is a screen shot of the notification tab that will not go away I also clicked on it before I took the screen shot

 

[Fillip H.]

In that case, you can run

UPDATE user SET dbtech_vbactivity_achievementcount = 0

via vBulletin's "Execute SQL Queries" page.

If you're using a table prefix (which is set in /includes/config.php) you need to prefix that to the table name user in the above query.

 

[XGC Paravain]

Ok cool I will check that out and report back

 

[XGC Paravain]

This is what I found for table prefix

****** TABLE PREFIX ******
// Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = '';

Is that what your speaking of?

 

[XGC Paravain]

In that case, you can run

UPDATE user SET dbtech_vbactivity_achievementcount = 0

via vBulletin's "Execute SQL Queries" page.

If you're using a table prefix (which is set in /includes/config.php) you need to prefix that to the table name user in the above query.

Fillip H. Can you explain how do I run that code? where is the vBulletin's "Execute SQL Queries" page.

 

[Fillip H.]

Under the Maintenance group in the AdminCP.

 

[XGC Paravain]

Oh lol ok another day and some thing else learned I got it BUT lol there is always some thing

Before I do it wrong, In the above query I don't have the option for user

should I just run the code?