WordPress.org

1. fosterm
   Member
   Posted 4 months ago #

   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

2. macmend
   Member
   Posted 3 weeks ago #

   no response on this I would like to know more about converting XOOPs to wordpress

Reply

You must log in to post.