Jump to content


Photo

joined not converted


  • Please log in to reply
1 reply to this topic

#1 Sa64

Sa64

    IPB Newbie

  • Members
  • Pip
  • 2 posts

Posted 20 June 2012 - 04:08 PM

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.

#2 Sa64

Sa64

    IPB Newbie

  • Members
  • Pip
  • 2 posts

Posted 26 June 2012 - 01:37 PM

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")





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users