CB Query

Krileon,

So is your only suggestion to fix this problem to uninstall and reinstall CB? I know my deadlines are no concern of yours but we have little time left to implement this site and without the session data our login auditing report is going to be little to no use. Our clients have to be able to audit the medical data that is viewed and CB query saving the IP addresses was going to provide that for us.

Thanks,
Will

So is your only suggestion to fix this problem to uninstall and reinstall CB?

No, certainly not. Don't believe a re-install would resolve your issue.

Please review my previous post as suggested using CB Code so you can execute your Query with PHP with will provide the ability to use PHP functions to obtain the IP Address of the user. CB Code allows you to execute a code file based on trigger. Inside the code file being executed would be code to handle your query.

Alternatively you could write a new CB plugin that utilizes CB triggers to execute whatever code necessary (including query) so you could have the IP Address a part of the query. Tutorial on CB triggers as follows (full installable example is provided).

www.allmysocials.com/tutorials/item/228-event-triggers

The main issue is obtaining IP Address through SQL is impossible; it must be done from PHP.