Nebulous Well-known member Mar 27, 2015 #1 So in xf_user it shows the like_count for each user. Does anyone know of an SQL query I can run to change a specific user's like_count to a different number?
So in xf_user it shows the like_count for each user. Does anyone know of an SQL query I can run to change a specific user's like_count to a different number?
Paul B XenForo moderator Staff member Mar 27, 2015 #2 You can do it in the ACP on the member profile page via the [Profile Info] tab. Upvote 0 Downvote
Nebulous Well-known member Mar 27, 2015 #3 Would it be faster to run SQL queries though? I am going to be doing this for a lot of users. Upvote 0 Downvote
Nebulous Well-known member Mar 27, 2015 #4 Okay I think I got one figured out: Code: UPDATE `xf_user` SET `like_count` = '659' WHERE `user_id` =34 (an example of updating member #34 to have 659 likes) .... Did I do that right? Upvote 0 Downvote
Okay I think I got one figured out: Code: UPDATE `xf_user` SET `like_count` = '659' WHERE `user_id` =34 (an example of updating member #34 to have 659 likes) .... Did I do that right?
m1ne Well-known member Mar 27, 2015 #5 Code: UPDATE `xf_user` SET `like_count` = '659' WHERE `xf_user`.`user_id` = 34; Upvote 0 Downvote
Nebulous Well-known member Mar 27, 2015 #6 Thanks @Solidus Seems both do the job just fine. You could also throw your database name in there before the first `xf_user` (after the word "Update") Upvote 0 Downvote
Thanks @Solidus Seems both do the job just fine. You could also throw your database name in there before the first `xf_user` (after the word "Update")
