I have done some sort of research on that but havent found much to be honest. I thought it would be simplier to ask here than start digging into XF's deep source code, but maybe it'll end up a necessity depending on the answers.
I wonder how can I retrieve the registration IP and the confirmation IP of a user given his userid?
Basically I'd like a function like
And retrieve a string containing the IPs from these functions.
Problem is that it looks a bit complicated on how to obtain that. Looks like the registration IPs are stocked in a MySQL BLOB, somewhere in xf_data_registry and keyname dnsBlCache, however I'm not sure how to extract the info's I want (I'm not even sure either that's the correct Key or anything).
Note that I would retrieve this from an 'external' PHP script (i.e. not a xenforo addon, but still on the same host than my XF install). Is this possible?
Thanks (to be clear what I wanna know is how to do the query)