XOOPS to WP (4 posts)

  1. fosterm
    Posted 7 years 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. jonathan s
    Posted 6 years ago #

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

  3. cyror
    Posted 6 years ago #

  4. jonathan s
    Posted 6 years ago #

    this post is from a while ago, but there is still interest, at least from me on some help to convert Xoops to WordPress, can anyone help?

Topic Closed

This topic has been closed to new replies.

About this Topic