[spirit_rider]

Hello,

I have installed this great MOD on vBulletin 4.1.1 board which has the data imported from a phpBB 3.0.7 board. There was a Thanks mod installed on previous phBB board but the data was not imported by ImpEx script. So I'm here asking help from vB experts to help on this. Here are the relavent database table and its relavent fields.

vB Tables
------------------
vb_post_thanks : id , userid (from) , username (from) , date , postid
vb_post : postid , importpostid , post_thanks_amount
vb_user : userid , importuserid , post_thanks_user_amount , post_thanks_thanked_posts , post_thanks_thanked_times

phpBB Tables
------------------
phpbb_thanks : thanks_id , thanks_from (user_id) , thanks_to (user_id) , post_id , thanks_time (similar to date in vb_post_thanks table)
phpbb_users : user_id , username , user_thanked , user_thanks , user_thanks_post
phpbb_posts : post_id , post_thanked

I think we have to use importpostid and importuserid from vB table to match with phpBB tables since the userid<>user_id and postid<>post_id are not same. And I tried to edit only in table vb_post_thanks but it shows the wrong thanks count.

I think running sql queries will do this but I'm not that expert in sql

Help me to do this. Thanks in advance.