I'm trying to do login auditing, by just inserting a record into a table whenever anyone logs in.

INSERT INTO jos_login_audit (user_id, ip,timestamp)
VALUES ([cb:userdata field="id" /] , 'fix me',NOW())

If I have the above query, what do I put for the IP so that it uses the actual current value for it?

Is there a table with these or somewhere I can use for future reference? I can find no documentation that lists all the possible substitutions.

Thanks!

Thanks Krileon.

Now I'm not sure how I activate CB's session functionality. It doesn't seem to be populating the jos_comprofiler_sessions table with any data at all. I'm definitely using the CB login module.

What else should I look for to turn this on? It's definitely populating the regular Joomla session table, but I'd really need that IP address logging so I need to go the route suggested.

Thanks.

Also, If there is a way to troubleshoot a CB query please let me know how. Sometimes the query works and sometimes it doesn't do anything at all. When it dosn't work I assume it's an error with the query, but I never know the specific error it's encountering. I'm just curious if there is a better way to diagnose query issues. Right now I'm trying the query you suggested, Krileon, but it's not doing anything at all right now. Maybe it's because jos_comprofiler_sessions isn't being populated, I don't know.

Krileon,

The query is set to execute immediately after the onAfterLogin event is fired. This is what led me to believe the sessions would be populated by the time this event happened, because the user would have just logged in. But I'm getting no data at all in my jos_comprofiler_session table, so I think the sessions aren't saving at all.

Please advise in how to get it to work properly. Thanks!