ip addresses are stored where?

[rcane]

Is there some other place other than member_ip2 in the members table where IP addresses are maintained?

I thought log_ips might exist but can't seem to find it.

[shawnb61]

For a question like that, I'd suggest looking at the actual installer & doing a search.

It's kinda of a broad question, actually, it's stored in a lot of places for a variety of reasons.

E.g., open this & search:
https://github.com/SimpleMachines/SMF/blob/release-2.1/other/install_2-1_mysql.sql

[rcane]

OK, yes i see.

thanks.

i wanted to run a search and see what kind of traffic i have from a particular area.

[rcane]

On this subject however,
Is there a way to locate where all the currently logged in users' IP addresses are kept?

Rather than deal with templates and such I was wondering if I could pull the IPs into an array and search through them on my own dime.

[Aleksi "Lex" Kilpinen]

i wanted to run a search and see what kind of traffic i have from a particular area.

You are looking at the wrong place - If this is what you are interested in, then you should be looking at your server's access logs instead of the forum's database. There is no place in SMF that I know of, that would keep a permanent record like that for you.

[rcane]

i wanted to run a search and see what kind of traffic i have from a particular area.

You are looking at the wrong place - If this is what you are interested in, then you should be looking at your server's access logs instead of the forum's database. There is no place in SMF that I know of, that would keep a permanent record like that for you.

True,

I think I was confusing the "who's online" section that shows who is logged in and their IP.   That's coming from ip_address or ip2_address. 

[Aleksi "Lex" Kilpinen]

No, I think those come from smf_log_online, which temporarily keeps session info including IP-address.

[shawnb61]

If you're an Excel junkie, it's quite easy to pull the data into a spreadsheet, whether it's from smf_log_actions, smf_members, or your web access logs.

There are also freebie geo ip downloadable databases out there in csv format.

The only trick is finding an approach to making the ips usable in Excel's vlookup...  I split the ips using text-to-columns, then calc the ip as a decimal number using the columns as input.   Takes a couple steps, but works.

[rcane]

If you're an Excel junkie, it's quite easy to pull the data into a spreadsheet, whether it's from smf_log_actions, smf_members, or your web access logs.

There are also freebie geo ip downloadable databases out there in csv format.

The only trick is finding an approach to making the ips usable in Excel's vlookup...  I split the ips using text-to-columns, then calc the ip as a decimal number using the columns as input.   Takes a couple steps, but works.

don't tease me.  i love me some excel projects. 

[shawnb61]

don't tease me.

Free, & no registration required:
https://db-ip.com/db/lite.php

I keep the ipv4 entries (the first ~300K) and delete the ipv6 entries.

Of course, lots of caveats...  In many cases you're getting the IP of a server, but the actual user can be anywhere.

[rcane]

that's neat.

I figure it's only good for those members who aren't using a VPN. 

[rcane]

No, I think those come from smf_log_online, which temporarily keeps session info including IP-address.

yeah curious about that. 

with me just logged in right now as admin the ip in the table doesn't match the ip on the who's online page--which is actually my current ip.