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.
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-
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.
Attached screenshots
Modified 17 يونيو 2021، 4:14:26 م -0700 by contactkx2