Question SQL query for points

I decided to recalculate points because everything's lower since changing from MyBB to vBulletin in 2015. Unfortunately this did not turn out as I hoped. The only solution I can think of is taking everybody's point values and multiplying by 30. Do you have an SQL query to do this?

Also, "days registered" achievements just aren't working. My account was registered in November 2008 on MyBB. Even though I've recalculated achievements, it has been unable to reward these achievements. It appears to be the case even for newer users.

I believe it might be something like UPDATE user SET dbtech_vbactivity_points = (dbtech_vbactivity_points * 30) but don't run that without making backups just in case.

Check the criteria used in the achievements as the first port of call for issues awarding achievements. Make sure you do not use "Days registered = 360" or something, as that achievement will only be true on the exact day 360 days after registering. Use >= instead.

Thanks, the points query worked fine. (I made a backup just in case of course.)

I also fixed the days problem. I wasn't aware that point rewards (or any for that matter) need to be enabled for respective achievements. I didn't want any points to be rewarded for that. When I disabled it the criteria still showed "Days Registered", so I was none the wiser until I changed some settings. Anyway, problem solved. I haven't tried changing the reward value to 0 for this, but it's not a big issue.

Cheers.

Hello @Mantis,

We hope your ticket regarding vBActivity & Awards has been addressed to your satisfaction. This ticket has now been closed.

If your ticket has not been resolved, you can reply to this thread at any point in the next 7 days in order to reopen the ticket, afterwards this thread will be closed.

Please do not reply to this thread if your ticket has been resolved.

Thank you.


- DragonByte Technologies, Ltd.