Sign in to follow this  
Followers 0

joined not converted

2 posts in this topic

Posted

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.



Can somebody help me? please.


// 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);

Share this post


Link to post
Share on other sites

Posted

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Who's Browsing   0 members

    No registered users viewing this page.