XF 2.2 Importing the likes to the forum

canina

Active member
I'm moving a phpbb forum to xenforo. I made a sql query to update the likes table in xenforo.

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.
 
Back
Top Bottom