[RSS Feed/News] Importing the likes to the forum

[XenForo]

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...

Read more

ادامه مطلب...