Get my users ip

[Popa Andrei]

I would like to know if there is a way to fecth all my current accounts ip from the database so i can whitelistem into cloudflare.

Thanl you in advance.

[kh99]

You could do

SELECT DISTINCT ipaddress FROM post


to get a list of every ip that anyone has posted from. You might also want

SELECT DISTINCT ipaddress FROM user


to get the registration ips. Someone who is better at sql than I am might be able to figure out a way to get one list of distinct ip addresses from both tables in one query, but it's beyond me.

[Popa Andrei]

where can i run those queryes in vb?

[kh99]

Maintenance > Execute SQL Query, if you have access to that. You can also use phpMyAdmin if you have that.

[Popa Andrei]

I have access,thank you.
And it work.Thanks alot.