IP addresses scrambled

    • 217 posts
    June 19, 2019 12:04 PM EDT

    I have exported a csv file of my database.  The columns with IP addresses are scrambled and I need them to be unscrambled. 

    As you can see from the attached screenshot the columns related to Creation_IP (column V in screenshot) and lastlogin_ip (column Y is screenshot) are no longer IP addresses after export. 

    Can you please explain how I can export them so that they are not scrambled?

    • 217 posts
    June 19, 2019 12:05 PM EDT

    Just to be clear I am in engine4_users of the database.

    • 36 posts
    July 2, 2019 4:19 PM EDT

    Not sure what additional information you desire, but this should do:

    SELECT P.user_id, P.email, P.displayname, INET6_NTOA(`creation_ip`) AS Signup_IP_Address, INET6_NTOA(`lastlogin_ip`) AS Last_Login_IP_Address FROM engine4_users P

     

    Prints: user id, e-mail, displayname, signup IP, last login IP

    • 217 posts
    July 3, 2019 8:59 AM EDT

    I love you OTAw!!!!!  It worked!