Hi All
I am attempting to move all my users from my site (currently using XOOPS) to WPMU 2.7.1
I have matched up the proper tables from the db but with my limited sql ability I am stumped about how to convert the unix timestamp from user_regdate in XOOPS to the date format used in WPMU.
I am simply using the sql statement below in the myPHPadmin sql window.
It looks like using FROM_UNIXTIME might be a solution but I am unsure how to use it within the sql statement below.
SELECT uid AS 'ID', uname AS 'login_name', uname AS 'user_nicename', pass AS 'user_pass', email AS 'user_email', url AS 'user_url', user_regdate AS 'user_registered', uname AS 'display_name' FROM mcm_users WHERE 1
Any help would be appreciated.
Thanks Foz