User Reg. Date and MKtime

ehsanix · **User Reg. Date and MKtime -** 08-06-2003, 03:44 AM

I had a php-NUKE 6.0 with an active forum and moded with the 2.0.6
then I decided to leave the nuke and just use a phpBB forum instead, so I just transfer tha tables with some problems but at last I did it, but I forgot that the Registration date format of NUKE for users table is for example Dec 05, 2002 and for phpBB is a MKtime result,
so every old user in forum is joined 01, jan 1970 !!
Any Idea how can I change a simple date to a MKtime format?!

Thanks :wink:

Mighty_Y · 08-06-2003, 05:40 AM

The only thing I can advice you is this:
- Learn PHP
- Learn SQL
- Write a script wich takes out the joined dates from the database (using a while(list) or so ), and using this little code for transforming the dates to MKtime

Code:

$time = strtotime($time);

and then in the while loop you put the date back in.

It seems simple when I write it down but isn't that simple for doing it right

(I know that because I wrote a similar script wich had to do the same thing too, but for other purposes)

ehsanix · 08-06-2003, 06:18 PM

Thanks for the reply,
I just know some php and mysql so I could transfer the nuke_users table to phpbb_users table, but in this case I couldn't manage the mktime function, but I made a php file to do this for me after reading the php manual more carefully,

Anyways thanks again :wink: