[tpearl5]

Originally Posted by Ted S

There's no import feature at this point... not sure how they work exactly if you can explain?

One like = one helpful answer vote. There are no down votes. There was an importer for this mod for the likes. This was the query:

PHP Code:

"select p.postid,p.userid,ha.dateline as date,ha.userid as whoadded,hp.threadid,u.username,l.l_contentid ".
"from ".vbseo_tbl_prefix('helpfulanswer')." ha inner join ".vbseo_tbl_prefix('post')." p on (ha.postid = p.postid) ".
"inner join ".vbseo_tbl_prefix('helpfulpost')." hp on (ha.postid = hp.postid) ".
"inner join ".vbseo_tbl_prefix('user')." u on (ha.userid = u.userid) ".
"left join ".vbseo_tbl_prefix('vbseo_likes')." l on l_ctype=1 and l_contentid=p.postid and l_from_userid=ha.userid ".
"where ha.yesno = 1";