Hi Team,

I'd like to have the whole users' IP addresses grabbed and stored in the Ari Quizz stats.
For now it is only the first 2 figures of the IP all mixed.

I'd like to have those IP, like this : 92.132.78.45
How can I do that ? Do I have to modify some piece of code ?

Could you advice ?
Many thanks in advance,

Dominique

Hello,

IP addresses are stored in "IpAddress" column in #__ariquizstatistics_pages table. They are stored as integer. It is possible to use long2ip PHP function to convert them to string.

Regards,
ARI Soft

Hi Team

Many thanks for your answer.

Yes, I indeed found "IpAddress" column in #__ariquizstatistics_pages.

But what I don't know is how to get the whole IP there, instead of what we have at the moment.

Could you tell me how to get this ? What piece of code I have to and and / or modify and where ?

Many thanks in advance for your help,

Dominique

Could you explain where you retrieve and show IP addresses?

Regards,
ARI Soft

Hi Team,

I am accessing the data in the DB via a great 'component' named 'Freestyle SQL Pro'.
(see the screenshot attached)

Related to that need af complete IP to be stored, I have a very important question for you guys...

Please check screenshot 2 and screenshot 3.

--> in screenshot 2, Am I correct if I suppose that a visitor arrived in the quizz, saw the first question, and never answered and pushed the 'Next' button : therefore, there is only the start date on question 1, with related IP. Is that what you would say too ?

--> if I am correct for screenshot 2, in your opinion : why in screenshot 3 there are no signs of connexion to the quizz (no start date, no IP address) ?? The quizz has been initiated (the lines have been generated in DB), but what could happen to get this kind of empty cells (start date and IP) ??

This question is VERY very important for me and to assess the quality of incoming traffic.
So many thanks for any opinion / thoughts regarding this strange empty cells on screenshot 3.

Many thanks in advance for your opinion on this question.