Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
setting users post count?
Avatar
mike olson
Member
sp_UserOfflineSmall Offline
Mar 8, 2017 - 2:55 pm

Mr Papa said
sorry, late to the game, but if the users are not in the database, then they wont be associated with existing posts... so in addition to creating the user post count, do you need/want to associate them with their old posts?  

Thanks for the follow up. I think what I will do is update their post counts once they have registered. I've created a sticky post asking them to check in once they've registered. I then built a tool that will query the old database to get their old post count and then update their new post count in wp_sfmembers. Not ideal but it should get the job done. 

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Mar 8, 2017 - 3:24 pm

If you can extract all users post counts into a table then the sfmembers table could be updated in one go for everybody with a simple update query...

andy-signature.png
YELLOW
SWORDFISH
Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 649
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 618
Members: 17357
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10123
Posts: 79616