[SOLVED] Retrieve user IP for cb field?

Is it possible to retrieve the user ip from the cb registration and display it in a field?

Thanks for help!

SF

CBSubs stores a users IP Address in the database table _cbsubs_subscriptions when a subscription is made. You can retrieve this using a database query. To display that queries results as a field you'll need incubator project CB Query Field which renders a database queries results as a CB Field (non-searchable on userlists).

thank you,

is there IP information in the standard cb or joomla user tables?

regards,
SF

Joomla, no. CB, yes within database table _comprofiler_sessions. No idea the accuracy of this table however. It maybe best to develop an integration to obtain and store the IP and various CB triggers such as after login. CB also stores the users IP address at time of registration to _comprofiler.

Hi, I am using Joomla 1.6.3 and the latest CB, I am also a Joomla newbie who suffers multiple illnesses which make these things difficult to understand.
I am nearly ready to go live with my site but the thing that really scares me is not having I.P. addresses showing up anywhere.
With my current CMS I am about to delete, I am constantly getting spammers and hackers trying to gain access from countries such as Poland, China, Indonesia, Russia, etc, I can stop these causing damage by not allowing them in by doing a quick search of their I.P. addresses which show up in the new registration email.
Is there an easy way for IP addresses to be included in either new registration email, "My Settings" tab, or even an extra user management field?
Thank you

IP Address has always been provided with registrations via the "registeripaddr" database column in _comprofiler database table. This is set at the time of registration only however. To display this on profile you could use delimiter field with the contents of [registeripaddr] or use incubator project CB Query Field to query the database for this column using the below query.

Additionally to prevent spam it's best to combine subscriber or individually purchased available plugin CB Captcha. This would eliminate all or nearly all automated spam bots.

Please keep in mind IP Address is HIGHLY unreliable. The user could simply use a proxy, which is VERY easy to do. They could re-register with a new IP, etc.. With captcha in place you should not have many spam issues as it's a good deterrent for spammers and often causes them too much trouble to bother.