I'm moving a phpbb forum to xenforo. I made a sql query to update the likes table in xenforo.
It's just that in practice, although this code changes the design and color of the button for clicking on the like (I see it because I'm the logged in user who is marked as having given thanks), but in the section below the message that displays the names of the users who gave a like, there is no list of the users who gave a like.
(I noticed - and I still need to add this in the code - that the
But I didn't see where in the db the names of the users who gave a like should be updated, so that they appear as mentioned below the message.
Code:
DROP PROCEDURE IF EXISTS CALCPERFORMANCE;
DELIMITER ;;
CREATE PROCEDURE CALCPERFORMANCE()
BEGIN
DECLARE length INT DEFAULT 0;
DECLARE counter INT DEFAULT 0;
SELECT COUNT(*)FROM `toraforu_phpbb`.phpbb_thanks INTO length ;
SET counter=0;
WHILE counter<length DO
INSERT INTO xf_reaction_content(reaction_id,content_type,content_id,reaction_user_id,reaction_date,content_user_id)
SELECT 1,'post',`post_id `,`user_id`,`thanks_time`,`poster_id`,1 FROM toraforu_phpbb LIMIT counter,1;
SET counter = counter + 1;
END WHILE;
End;
It's just that in practice, although this code changes the design and color of the button for clicking on the like (I see it because I'm the logged in user who is marked as having given thanks), but in the section below the message that displays the names of the users who gave a like, there is no list of the users who gave a like.
(I noticed - and I still need to add this in the code - that the
reactions
column in the xf_post
table should also be updated with the number of users who gave a like).But I didn't see where in the db the names of the users who gave a like should be updated, so that they appear as mentioned below the message.