When quiz is started, the component creates a quiz session (create pages with questions for this quiz session). Start date is populated when a question page is loaded.

If you want to convert IP address from number to string, use INET_NTOA MySQL function. A query will look like:


SELECT
INET_NTOA(IpAddress) AS IpAddress
FROM
#__ariquizstatistics_pages

Regards,
ARI Soft

Hi Team,

Thanks for your answer.

I - DB LINES
I need a little more info though :

1) the component creates a quiz session (and creates pages with question, meaning it creates the lines in the DB) = ok. I guessed that before, and you confirmed it, so I understand that.

then...

2) you explain that in those DB lines, the 'start date' appears when a question page is loaded = ok.
BUT... here is the main question for me about all this then : what is the situation / case that could make the 'start date' of the question 1 empty ? Is that possible ?

3) could it be possible that the component is over-loaded sometimes, and that then some quizz lines are created in the DB but not filled-in with 'start date' and 'end-dates', etc ?

We have a super powerful server (really), but we also get a lot of traffic and a lot of people doing that quizz at the same time (only during heavy marketing campaigns of course). During those periods, we have an average of 500 people playing with your quizz simultaneously. Sometime even more. So... As asked already just above : could it be possible that some quizz lines are not filled in because the component get too many things to do, or is it unlikely. Or impossible even ? Or possible ? (The whole server performances are fine, and it never crashed, for your info...)

What do you think ?
What could make even the start date of some quizz not filled in ?


II - WHERE TO USE YOUR CODE TO GET FULL IP ?
Could you indicate me in which file of your component, and where in that file (or in the DB) I should paste / replace the code you mentioned :

SELECT
INET_NTOA(IpAddress) AS IpAddress
FROM
#__ariquizstatistics_pages

... to get the whole IP instead of the first 2 figures ?


Many thanks for your help on those questions,
Best
D

2. StartDate can be an empty if a time limit is used for a quiz. StartDate field will be an empty for question page(s) which were not loaded when time limit is expired.

3. We described above when StartDate and EndDate fields can have empty value. Do you have any problem with some quiz sessions?

4. You wrote that use 'Freestyle SQL Pro' application to show data from a database. We provided a sample SQL query how to show IP addresses.

Regards,
ARI Soft