I need to transfer data from karma mod in phpbb to karma in smf. Phpbb has a table phpbb_karma which is basically a karma log. Important fields we need to focus on are user_id (user which got the karma) and karma_action (positive or negative karma, shown as + or -). I would need a query to count all the pluses and minuses and then copy the given results for each unique user_id into smf_members table under appropriate id_member (user_id field in smf) and karma_good (all the pluses) and karma_bad (all the minuses). I think it can be done but I am not sql expert.