Thread

Hello-

Is it possible to sort members by their IP addresses?

Thank you for your time.

CW

clwhitmire,

Do you want to do this in the member templates, or on a ‘regular’ template?

I think in the member template. Right now, I’m going member-by-member, doing an IP search for each address, for over 1,000 members. I just thought there might be an easier way to identify multiples.

Would the ip search form help?  Admin ›  Members and Groups ›  Member Search

-greg

I’ve been using the IP search. I still have to enter all the existing IP addresses one at a time to search for duplicates. I was just hoping there was a way to sort them, to save time and see where my multiples are.

ah, okay.

What about running the following in a template:

{exp:query sql="SELECT member_id, group_id, username, screen_name, email, ip_address from exp_members ORDER BY ip_address DESC"}

    Member Id: {member_id}

    Group Id: {group_id}

    Username: {username}

    Screen name: {screen_name}

    Email Address: {email}

    IP Address: {ip_address}

    <hr >
    

{/exp:query}

Or, you can run the same query at:  Admin ›  Utilities ›  SQL Manager ›  Database Query Form

-greg