XF 1.2 Recalculate and update all user post counts and Vbseo likes imported?

[Jarod]

Hello all,

Is it possible, with a query, to recalculate and update all user post counts and vbseo likes, previously imported from Vbulletin 3.8?

Like this @Jake Bunce query here:

http://xenforo.com/community/threads/recalculate-and-update-all-user-post-counts-query.19736/


Thanks

 

[Jarod]

Done for vbseo likes

 

[Jake Bunce]

I attached a file to this thread to rebuild like counts:

http://xenforo.com/community/threads/is-there-a-way-to-rebuild-post-profile-post-like-caches.42384/