1 reply to this topic

[Sa64]

Hi,

I have a phpbb2 forum and when converting it to ip.board members joined date not converted correctly and all set to (for example) jun 20 2012 in forum or 1340209890 in db.

After looking up in to the phpbb2 db, I see user_regdate's are in this format (example) jun 20 2012 , may 10 2010 ... but in ip.board they are in string format look like 1340209890.

I need a date converter code to insert it into the ips converter.

// Member info
$rank = ipsRegistry::DB('hb')->buildAndFetch(array('select' => 'rank_title', 'from' => $this->nukedPrefix . 'ranks', 'where' => 'rank_id='.intval($row['user_rank'])));
$time_arry = explode( ".", $row['user_timezone']);
$time_offset = $time_arry[0];
$members = array( 'ip_address' => $row['last_ip'],
	 'joined' => $row['user_regdate'],
	 'last_visit' => $row['user_lastvisit'],
	 'last_activity' => $row['user_lastvisit'],
	 'last_post' => $row['user_lastvisit'],
	 'warn_level' => $row['user_warnings'],
	 'warn_lastwarn' => $row['user_last_warning'],
	 'posts' => $row['user_posts'],
	 'time_offset' => $time_offset,
	 //'title'	 => $rank['rank_title'],
	 'email_pm'		 => $row['user_notify_pm'],
	 'members_disable_pm'=> ($row['user_allow_pm'] == 1) ? 0 : 1,
	 'hide_email' => $row['user_viewemail'] ? 0 : 1);

Can somebody help me? please.

[Sa64]

Finally it's not done by changing converter codes.

I use this code and edit manually in excel then import it to old db and reconvert to ipb.

=TEXT( A1*86400-DATE(1970,1,1)*24*60*60,"0000000000")