Avatar for Username

Søg i Support

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

Denne tråd blev arkiveret. Stil et nyt spørgsmål, hvis du har brug for hjælp.

Firefox browser history time spent on each website by user

  • Ingen svar
  • 1 har dette problem
  • 1 visning
contactkx2
contactkx2
more options

I am creating a DotNet application to fetch time spent by user on websites visited by him using Firefox browser. The solution I am using does not give correct results for Firefox browser. Used approach from below link-

https://social.msdn.microsoft.com/Forums/vstudio/en-US/3e9f3588-ad0b-49af-b269-2abfda0b9abc/how-to-get-the-browser-history-in-program-using-c?forum=csharpgeneral

Output should be as below: 1. www.facebook.com , 20 minutes. 2. www.youtube.com , 15 seconds.

Which columns OR tables should I query to have accurate time spent by user ? I am using tables moz_places and moz_historyvisits. But the last_visit_date column only gives date time stamp when user last visited. As you can see I need total time spent.

Please guide me.

I am creating a DotNet application to fetch time spent by user on websites visited by him using Firefox browser. The solution I am using does not give correct results for Firefox browser. Used approach from below link- https://social.msdn.microsoft.com/Forums/vstudio/en-US/3e9f3588-ad0b-49af-b269-2abfda0b9abc/how-to-get-the-browser-history-in-program-using-c?forum=csharpgeneral Output should be as below:''' 1. www.facebook.com , 20 minutes. 2. www.youtube.com , 15 seconds.''' Which columns OR tables should I query to have accurate time spent by user ? I am using tables '''moz_places''' and '''moz_historyvisits'''. But the last_visit_date column only gives date time stamp when user last visited. As you can see I need total time spent. Please guide me.
Vedhæftede skærmbilleder

Ændret af contactkx2 den